2018_Central_Park_Squirrel_Census_-_Squirrel_Data

42 rows where Hectare Squirrel Number = 2, Shift = "AM" and Tail twitches = 1 sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

Shift ✖

Hectare Squirrel Number ✖

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
2999 2999 -73.972415182837 40.773080463452004 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.972415182837 40.773080463452)
1256 1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9679457364586 40.7717350221981)
2330 2330 -73.9724618533895 40.7745021602455 11D-AM-1010-02 11D AM 10102018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 1 0 0 1   POINT (-73.9724618533895 40.7745021602455)
2739 2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
485 485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9677423154682 40.77288133502451)
1488 1488 -73.9690072647093 40.7737712267463 12G-AM-1012-02 12G AM 10122018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9690072647093 40.7737712267463)
2216 2216 -73.97351950184459 40.778714727971504 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9735195018446 40.7787147279715)
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9676539688726 40.7777229934129)
1816 1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9710187505339 40.7797265666746)
510 510 -73.9638590768396 40.777678211498106 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9638590768396 40.7776782114981)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
1804 1804 -73.98077710643099 40.7681635726316 1A-AM-1007-02 01A AM 10072018 2 Adult Gray White Gray+White   Above Ground 11   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.980777106431 40.7681635726316)
2898 2898 -73.97941182346509 40.767449554056896 1C-AM-1012-02 01C AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9794118234651 40.7674495540569)
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)
1035 1035 -73.97725699096729 40.7664804797448 1E-AM-1006-02 01E AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9772569909673 40.7664804797448)
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)
1808 1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 1 0 0   POINT (-73.9698870647042 40.7826510985538)
2273 2273 -73.9671534029191 40.7810849804467 20D-AM-1007-02 20D AM 10072018 2 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   0 0 0 0 1 quieter 0 0 0 0 1 0 0 0   POINT (-73.9671534029191 40.7810849804467)
127 127 -73.96641005044359 40.7828778892276 21D-AM-1008-02 21D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9664100504436 40.7828778892276)
450 450 -73.96442931957729 40.7813829172072 21F-AM-1018-02 21F AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9644293195773 40.7813829172072)
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
650 650 -73.98096101171708 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9809610117171 40.7683896665502)
862 862 -73.9626120417397 40.790512635862605 30C-AM-1014-02 30C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on a rock 1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9626120417397 40.7905126358626)
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0 following #1 0 0 0 0 1 0 0 0   POINT (-73.9573119777312 40.7875347862766)
513 513 -73.96310068980699 40.7920255189467 32B-AM-1017-02 32B AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on its head Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.963100689807 40.79202551894671)
923 923 -73.9578924882613 40.789806297824 32G-AM-1010-02 32G AM 10102018 2 Adult Gray   Gray+   Above Ground 13   0 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9578924882613 40.789806297824)
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9594406225891 40.7918533707789)
2258 2258 -73.95477850811709 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9547785081171 40.789612183711)
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)
2320 2320 -73.9576897478787 40.796469532845705 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9576897478787 40.7964695328457)
1062 1062 -73.957259673402 40.7974442913898 39C-AM-1017-02 39C AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.957259673402 40.7974442913898)
304 304 -73.9523001834395 40.7949231000186 39H-AM-1007-02 39H AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9523001834395 40.7949231000186)
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9802831706033 40.7692763295564)
2576 2576 -73.9751625910271 40.7671023412885 3F-AM-1006-02 03F AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9751625910271 40.7671023412885)
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)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
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)
110 110 -73.97113187902791 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9711318790279 40.7701941550273)
1578 1578 -73.97352989433209 40.771493999358896 8E-AM-1013-02 08E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9735298943321 40.7714939993589)
2490 2490 -73.9693876553956 40.7707232748402 8I-AM-1006-02 08I AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9693876553956 40.7707232748402)
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)
1387 1387 -73.9697160572446 40.7711445570446 9H-AM-1006-02 09H AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.96971605724461 40.7711445570446)

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