2018_Central_Park_Squirrel_Census_-_Squirrel_Data

52 rows where Hectare Squirrel Number = 3, Highlight Fur Color = "White" and Shift = "PM" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 45
  • 1 7

Shift ✖

Highlight Fur Color ✖

  • White · 52 ✖

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
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
2542 2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2766 2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
73 73 -73.96148483609001 40.7922645521905 33C-PM-1007-03 33C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.96148483609 40.7922645521905)
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9793952066038 40.77078376578591)
561 561 -73.95819824864691 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   1 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.95819824864691 40.7992194575293)
575 575 -73.9783366903829 40.7668300056094 1D-PM-1007-03 01D PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9783366903829 40.7668300056094)
1851 1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9623621412501 40.7814673556041)
1914 1914 -73.9588714413332 40.7895787115444 31F-PM-1007-03 31F PM 10072018 3 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9588714413332 40.7895787115444)
2346 2346 -73.9562177305881 40.798341327633096 41C-PM-1007-03 41C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562177305881 40.7983413276331)
2518 2518 -73.9647219419257 40.781208440293206 20F-PM-1007-03 20F PM 10072018 3 Adult Gray White Gray+White gray on haunches white on tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647219419257 40.7812084402932)
1028 1028 -73.97070123456609 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9707012345661 40.7758938984066)
2253 2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees 0 0 0 1 1   0 0 0 0 0 1 0 0 also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)
140 140 -73.97686527856641 40.768483816820705 3D-PM-1010-03 03D PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97686527856641 40.7684838168207)
752 752 -73.9768617690725 40.7741877060705 9A-PM-1010-03 09A PM 10102018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0 froze - standing on hind legs for ~10 seconds then scampered off POINT (-73.97686176907251 40.7741877060705)
1268 1268 -73.96239842629359 40.7913900453449 31C-PM-1010-03 31C PM 10102018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623984262936 40.7913900453449)
1672 1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
2620 2620 -73.97718000981308 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9771800098131 40.7708863131336)
2946 2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)
1461 1461 -73.95692690934399 40.7965323262487 39D-PM-1012-03 39D PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956926909344 40.7965323262487)
1551 1551 -73.9785114291288 40.771977958944895 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785114291288 40.7719779589449)
2069 2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   1 1 0 0 0 2/3 chasing each other 0 0 0 0 1 0 1 0   POINT (-73.9707487237344 40.7800822831001)
2250 2250 -73.95890163858891 40.7911727679625 33E-PM-1012-03 33E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9589016385889 40.7911727679625)
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 2/3 were chasing each other 0 0 0 0 1 0 0 1   POINT (-73.96786208407411 40.784719027304)
2494 2494 -73.9713968424625 40.774039018852704 11E-PM-1012-03 11E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9713968424625 40.7740390188527)
2860 2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
280 280 -73.9587401274261 40.7960322222949 37C-PM-1013-03 37C PM 10132018 3 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9587401274261 40.7960322222949)
299 299 -73.9586214081667 40.7937473968735 35D-PM-1013-03 35D PM 10132018 3 Juvenile Gray White Gray+White No Tail! Above Ground 2 bench 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9586214081667 40.7937473968735)
986 986 -73.978400938697 40.7677411911854 2C-PM-1013-03 02C PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.978400938697 40.7677411911854)
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9751056714758 40.7732060035215)
2042 2042 -73.9800896621713 40.7684379810317 2B-PM-1013-03 02B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9800896621713 40.7684379810317)
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       0 0 0 1 1 watching 0 0 0 0 0 0 0 1   POINT (-73.9593909381748 40.7961036981921)
2138 2138 -73.9791536183194 40.7672705931866 1C-PM-1013-03 01C PM 10132018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9791536183194 40.7672705931866)
2571 2571 -73.9695468150218 40.7821142051746 20B-PM-1013-03 20B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9695468150218 40.7821142051746)
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9618094076328 40.7944097368153)
517 517 -73.954959868822 40.7985404965582 41D-PM-1014-03 41D PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.954959868822 40.7985404965582)
580 580 -73.97509925643621 40.7743391883762 10B-PM-1014-03 10B PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9750992564362 40.7743391883762)
1510 1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0 followed man across bridge POINT (-73.9655670884957 40.7763728890554)
1860 1860 -73.9767100101318 40.7675779951996 2E-PM-1014-03 02E PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767100101318 40.7675779951996)
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9573692542155 40.7989252908321)
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9693159934697 40.7831212338295)
2071 2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)
2129 2129 -73.9701182454818 40.777280550087106 15D-PM-1017-03 15D PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701182454818 40.7772805500871)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2890 2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
164 164 -73.9758676144255 40.7701671581939 5D-PM-1018-03 05D PM 10182018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9758676144255 40.7701671581939)
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.97202898636661 40.7763749561607)
2412 2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)
2865 2865 -73.98028424040159 40.767825738497706 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.98028424040162 40.7678257384977)

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