2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Approaches = 1, Date = 10132018 and Shift = "PM" sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Foraging, Other Activities, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number ✖

Shift ✖

Date ✖

  • 10132018 · 21 ✖
Link rowid longitude latitude Unique Squirrel ID Hectare Shift Date Hectare Squirrel Number Age Primary Fur Color Highlight Fur Color Combination of Primary and Highlight Color Color notes Location Above Ground Sighter Measurement Specific Location Running Chasing Climbing Eating ▼ Foraging Other Activities Kuks Quaas Moans Tail flags Tail twitches Approaches Indifferent Runs from Other Interactions Lat/Long
176 176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9618064639153 40.792158440043)
478 478 -73.954482814186 40.7987031768001 42D-PM-1013-01 42D PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon Drawing included. Ground Plane FALSE   0 0 0 0 1 watching passers-by 0 0 0 0 0 1 1 0   POINT (-73.954482814186 40.7987031768001)
515 515 -73.9601486483164 40.7943724108626 35C-PM-1013-02 35C PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 approaches (when i crouched down) POINT (-73.9601486483164 40.7943724108626)
586 586 -73.9789126088606 40.7685079149692 2C-PM-1013-08 02C PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9789126088606 40.7685079149692)
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)
866 866 -73.9792091200122 40.7685845475313 2B-PM-1013-06 02B PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 sat there! in front of us POINT (-73.9792091200122 40.7685845475313)
1024 1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 1   POINT (-73.9521514669041 40.7949515182825)
1137 1137 -73.9520280004414 40.7946345014466 39I-PM-1013-03 39I PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 1 0 0   POINT (-73.9520280004414 40.7946345014466)
1205 1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 1 0 0   POINT (-73.9611118778753 40.7952007875354)
1485 1485 -73.9791085350047 40.76770253426329 2C-PM-1013-12 02C PM 10132018 12 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9791085350047 40.7677025342633)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
2358 2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 cleaning face & tail 0 0 0 0 1 1 0 0   POINT (-73.9788379085607 40.7683896583055)
2504 2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9550131837533 40.7958617258176)
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 1 0 got fed twice by grandpa,grabbed from grass and ate in tree 0 0 0 0 0 1 1 1 approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)
1533 1533 -73.95200246546021 40.794732982815496 39I-PM-1013-04 39I PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0 playing 0 0 0 0 0 1 0 0   POINT (-73.95200246546021 40.7947329828155)
2030 2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9749251267433 40.7679111971294)
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9794371709817 40.768387910254)
2383 2383 -73.9686551213305 40.772861783717396 11H-PM-1013-04 11H PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 1 0   POINT (-73.9686551213305 40.7728617837174)
2636 2636 -73.9700264128414 40.7692014637698 7I-PM-1013-01 07I PM 10132018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Bench 0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9700264128414 40.7692014637698)
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9531953594918 40.7960413520131)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 144.465ms