2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Age = "Juvenile", Hectare Squirrel Number = 2 and Shift = "AM" sorted by Hectare

✎ View and edit SQL

This data as json, CSV (advanced)

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

Shift ✖

Hectare Squirrel Number ✖

Age ✖

  • Juvenile · 29 ✖
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
419 419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9777328709928 40.7669087724668)
508 508 -73.97469187620759 40.765523188367794 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9746918762076 40.7655231883678)
2038 2038 -73.98035621370491 40.7685780990634 2B-AM-1010-02 02B AM 10102018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9803562137049 40.7685780990634)
2426 2426 -73.9790203973636 40.768883711483205 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 together w/ #3 0 0 0 0 0 0 0 1   POINT (-73.9790203973636 40.7688837114832)
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)
756 756 -73.9773079154219 40.7696506688861 4C-AM-1006-02 04C AM 10062018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9773079154219 40.7696506688861)
2783 2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)
896 896 -73.9755055978764 40.77074386817421 6D-AM-1008-02 06D AM 10082018 2 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9755055978764 40.7707438681742)
56 56 -73.97246424363941 40.7690526441109 6G-AM-1008-02 06G AM 10082018 2 Juvenile Gray   Gray+   Ground Plane FALSE bush 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9724642436394 40.7690526441109)
993 993 -73.97724226646571 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9772422664657 40.773436329163)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
169 169 -73.97487064155841 40.7744174965072 10B-AM-1006-02 10B AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   High in a tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9748706415584 40.7744174965072)
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)
484 484 -73.9666526554772 40.7756111718355 14H-AM-1007-02 14H AM 10072018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9666526554772 40.77561117183551)
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0 posing 0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9700162034073 40.7815277479588)
1528 1528 -73.9690104245067 40.7853358193723 23A-AM-1018-02 23A AM 10182018 2 Juvenile Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690104245067 40.7853358193723)
624 624 -73.96130519573059 40.7909351393505 31D-AM-1014-02 31D AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Undergrowth 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9613051957306 40.7909351393505)
374 374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556817958407 40.788852000621)
593 593 -73.95933528061751 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9593352806175 40.7918150568046)
6 6 -73.9565700386162 40.7902561000937 33H-AM-1019-02 33H AM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 wrestling with mother 0 0 0 0 0 0 0 0   POINT (-73.9565700386162 40.7902561000937)
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)
1203 1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9616999731028 40.7954126939561)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
1978 1978 -73.9579689996645 40.794933848991704 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579689996645 40.7949338489917)
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594174605642 40.7973128653773)
1061 1061 -73.9532657715601 40.7949046809422 39G-AM-1018-02 39G AM 10182018 2 Juvenile Gray   Gray+   Above Ground 25 Tree 0 0 0 0 0 sitting & watching 0 0 0 0 0 0 1 0   POINT (-73.9532657715601 40.7949046809422)
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.958535640774 40.7982737896998)
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)
442 442 -73.9502466289084 40.795922877988296 41I-AM-1018-02 41I AM 10182018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0 runs off POINT (-73.9502466289084 40.7959228779883)

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