This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
541 | 541 | -73.9617612388703 | 40.7952875954297 | 35A-AM-1014-04 | 35A | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9617612388703 40.7952875954297) | ||||
616 | 616 | -73.9556937218252 | 40.7990928062435 | 42C-AM-1007-04 | 42C | AM | 10072018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | young adult | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9556937218252 40.7990928062435) | ||
670 | 670 | -73.9602398690946 | 40.7910157676119 | 32D-PM-1006-04 | 32D | PM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602398690946 40.7910157676119) | ||||
842 | 842 | -73.9645147011741 | 40.777256683379896 | 17I-AM-1014-04 | 17I | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9645147011741 40.7772566833799) | ||||
870 | 870 | -73.97187204036571 | 40.770233505633705 | 7G-PM-1018-04 | 07G | PM | 10182018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9718720403657 40.7702335056337) | ||||
964 | 964 | -73.9631045499811 | 40.790618096947206 | 30B-PM-1019-04 | 30B | PM | 10192018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9631045499811 40.7906180969472) | ||||
1031 | 1031 | -73.9766593636657 | 40.7735708178842 | 8B-PM-1012-04 | 08B | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766593636657 40.7735708178842) | ||||
1036 | 1036 | -73.9709207551033 | 40.7767932008037 | 14D-AM-1014-04 | 14D | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9709207551033 40.7767932008037) | ||||
1223 | 1223 | -73.95912985511109 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9591298551111 40.7919612446005) | ||||
1436 | 1436 | -73.97667795856859 | 40.7669673778105 | 2E-AM-1010-04 | 02E | AM | 10102018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766779585686 40.7669673778105) | ||||
1449 | 1449 | -73.95611248920629 | 40.7949440648632 | 37E-AM-1013-04 | 37E | AM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9561124892063 40.7949440648632) | ||||
1462 | 1462 | -73.9584064203778 | 40.7912272455454 | 33F-PM-1012-04 | 33F | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9584064203778 40.7912272455454) | ||||
1468 | 1468 | -73.96405889194459 | 40.790044098464 | 29B-PM-1010-04 | 29B | PM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9640588919446 40.790044098464) | ||||
1591 | 1591 | -73.95762233900821 | 40.79797466396471 | 40B-AM-1019-04 | 40B | AM | 10192018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | POINT (-73.9576223390082 40.79797466396471) | ||||
1600 | 1600 | -73.9753093777 | 40.7666673897583 | 2F-AM-1006-04 | 02F | AM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Beautiful white puff at the end of its tail | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97530937770001 40.7666673897583) | |||
1639 | 1639 | -73.9736800575584 | 40.778306973575795 | 14A-PM-1014-04 | 14A | PM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#3) | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9736800575584 40.7783069735758) | |||
1655 | 1655 | -73.96957001271599 | 40.7816501516863 | 19B-PM-1018-04 | 19B | PM | 10182018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969570012716 40.7816501516863) | |||
1710 | 1710 | -73.95454386561221 | 40.7902168635009 | 34I-AM-1012-04 | 34I | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9545438656122 40.7902168635009) | ||||
1780 | 1780 | -73.9640945609381 | 40.7910513041359 | 30A-PM-1020-04 | 30A | PM | 10202018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | Rock | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9640945609381 40.7910513041359) | ||
2059 | 2059 | -73.9710026704697 | 40.776105276462104 | 13D-AM-1014-04 | 13D | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710026704697 40.7761052764621) | |||
2092 | 2092 | -73.9698231469857 | 40.7702048311133 | 8I-PM-1013-04 | 08I | PM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698231469857 40.7702048311133) | ||||
2285 | 2285 | -73.9576325087936 | 40.7988448745116 | 41B-AM-1010-04 | 41B | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9576325087936 40.7988448745116) | ||||
2343 | 2343 | -73.9719194877439 | 40.774800096290896 | 11D-AM-1010-04 | 11D | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9719194877439 40.7748000962909) | ||||
2607 | 2607 | -73.9642988690682 | 40.779559128197896 | 19H-AM-1010-04 | 19H | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | runs from human w/ dog | POINT (-73.9642988690682 40.7795591281979) | |||
2770 | 2770 | -73.96379835137891 | 40.7828712516396 | 23F-PM-1013-04 | 23F | PM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2". | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | indifferent (busy foraging) | POINT (-73.9637983513789 40.7828712516396) | ||
2776 | 2776 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | |||
2821 | 2821 | -73.97545365660129 | 40.769860491877104 | 5E-PM-1012-04 | 05E | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9754536566013 40.7698604918771) | ||||
2862 | 2862 | -73.967466716152 | 40.782434654827796 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | i scared it | POINT (-73.967466716152 40.7824346548278) | |||
2863 | 2863 | -73.9698246369929 | 40.7711472794488 | 9H-AM-1006-04 | 09H | AM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698246369929 40.7711472794488) | ||||
3000 | 3000 | -73.9688293382172 | 40.7738958027568 | 12G-AM-1012-04 | 12G | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688293382172 40.773895802756805) |
JSON shape: default, array, newline-delimited
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 );