2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Age = "Juvenile", Primary Fur Color = "Cinnamon" and Shift = "AM" sorted by rowid

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Date, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number ✖

Shift ✖

Primary Fur Color ✖

  • Cinnamon · 25 ✖
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
204 204 -73.96795381633409 40.7837103696906 22C-AM-1013-03 22C AM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1 eating (mushroom) 0 0 0 0 0 0 0 1   POINT (-73.9679538163341 40.7837103696906)
254 254 -73.9762246600197 40.775164077652 10A-AM-1006-03 10A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE Bridle Path lawn 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9762246600197 40.775164077652)
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
525 525 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)
588 588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
928 928 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)
954 954 -73.96584435488221 40.7796704898979 19F-AM-1007-03 19F AM 10072018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 scared POINT (-73.9658443548822 40.7796704898979)
1003 1003 -73.9645547556826 40.776877007081 16I-AM-1008-04 16I AM 10082018 4 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 9 tree hollow 0 0 0 0 0 in hollow 0 0 0 0 0 0 0 0 curious POINT (-73.9645547556826 40.776877007081)
1006 1006 -73.96862962178929 40.771812308875 10H-AM-1014-02 10H AM 10142018 2 Juvenile Cinnamon   Cinnamon+   Above Ground 6   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686296217893 40.771812308875)
1103 1103 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 Sitting on tree limb 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0 watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)
1212 1212 -73.9761792189352 40.7745745517215 9A-AM-1013-09 09A AM 10132018 9 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9761792189352 40.7745745517215)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1230 1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9790822606486 40.7714466633386)
1354 1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
1394 1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9594676326588 40.7984457363388)
1855 1855 -73.9791826197108 40.768577844752 2B-AM-1010-08 02B AM 10102018 8 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9791826197108 40.768577844752)
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0 cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)
2081 2081 -73.96757180595391 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675718059539 40.7786049141486)
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   0 0 1 1 1   1 0 0 0 0 0 1 0   POINT (-73.9789251806378 40.7699558513225)
2547 2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2671 2671 -73.97433690682541 40.7675726965985 3F-AM-1006-11 03F AM 10062018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9743369068254 40.7675726965985)
2742 2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2919 2919 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 10132018 12 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE foot of tree 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9768563402344 40.7744487310786)
2941 2941 -73.96902666603171 40.7853134751509 23A-AM-1018-01 23A AM 10182018 1 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690266660317 40.7853134751509)

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 163.535ms