This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
209 | 209 | -73.97107601968679 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9710760196868 40.7725506006789) | ||
250 | 250 | -73.97267476660019 | 40.77030226693079 | 7F-AM-1008-02 | 07F | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | see stories and locations | POINT (-73.9726747666002 40.7703022669308) | |||
292 | 292 | -73.9674069524601 | 40.7772529662424 | 16F-PM-1013-02 | 16F | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674069524601 40.7772529662424) | |||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.95983407835722 40.7915857030295) | |||||
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) | |||
615 | 615 | -73.96532790698879 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653279069888 40.7758743113817) | ||
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) | |||||
779 | 779 | -73.9745305540008 | 40.7742043234014 | 10C-PM-1013-02 | 10C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9745305540008 40.7742043234014) | ||||
972 | 972 | -73.9704591091677 | 40.7729175143429 | 10G-AM-1006-02 | 10G | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | notch on tail | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9704591091677 40.7729175143429) | |||
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) | |||
1134 | 1134 | -73.9716995507598 | 40.7797671327739 | 16B-AM-1014-02 | 16B | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9716995507598 40.7797671327739) | ||||
1186 | 1186 | -73.96740331258341 | 40.7769132902037 | 15G-PM-1019-02 | 15G | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674033125834 40.7769132902037) | ||||
1332 | 1332 | -73.97749282457809 | 40.7720464606979 | 6B-AM-1012-02 | 06B | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | by bike racks at Tavern on the Green | 0 | 0 | 0 | 0 | 1 | walking,exploring - digging in flower bed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9774928245781 40.7720464606979) | ||
1346 | 1346 | -73.9735655529245 | 40.7716072681474 | 7E-PM-1013-02 | 07E | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9735655529245 40.7716072681474) | |||
1472 | 1472 | -73.9698611971209 | 40.7753915552001 | 13F-PM-1008-02 | 13F | PM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698611971209 40.7753915552001) | ||||
1635 | 1635 | -73.95607317386771 | 40.798033601855394 | 41D-PM-1014-02 | 41D | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9560731738677 40.7980336018554) | ||||
1884 | 1884 | -73.9733898487296 | 40.7666975131518 | 3H-PM-1014-02 | 03H | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9733898487296 40.7666975131518) | ||||
2137 | 2137 | -73.96488316116292 | 40.780132641497296 | 19G-PM-1017-02 | 19G | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | patting ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9648831611629 40.7801326414973) | |||
2337 | 2337 | -73.9673490137465 | 40.778272813040104 | 17F-PM-1020-02 | 17F | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9673490137465 40.7782728130401) | ||||
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) | |||
2432 | 2432 | -73.9657203199746 | 40.775173008911 | 14I-PM-1018-02 | 14I | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9657203199746 40.775173008911) | ||||
2615 | 2615 | -73.97346051766459 | 40.7686218881386 | 5G-PM-1010-02 | 05G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9734605176646 40.7686218881386) | ||||
372 | 372 | -73.9781303869038 | 40.7725000348875 | 7A-AM-1006-02 | 07A | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9781303869038 40.7725000348875) | |||
504 | 504 | -73.95334760207359 | 40.7933003544685 | 37H-PM-1006-02 | 37H | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | tree | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | dogs | POINT (-73.9533476020736 40.7933003544685) | ||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685227310735 40.776599466588) | |||
738 | 738 | -73.9725712588741 | 40.7669101832926 | 4H-AM-1006-02 | 04H | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | climbing (over small wire fence then on the ground) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | approaches (saw me & came forward),runs from (startled by another person) | POINT (-73.9725712588741 40.7669101832926) | ||
760 | 760 | -73.97182341595571 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 1 | 1 | burying | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9718234159557 40.7810842503715) | |||
808 | 808 | -73.97168818386709 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9716881838671 40.778553537087) | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | ||||||
1698 | 1698 | -73.9631392113757 | 40.791463563578404 | 31B-PM-1007-02 | 31B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 1 | 1 | 0 | 0 | chasing #1 and climbing tree w/ #1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9631392113757 40.7914635635784) | |||
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) | ||
1949 | 1949 | -73.9605362268777 | 40.7939470599346 | 35C-AM-1007-02 | 35C | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9605362268777 40.7939470599346) | ||||
2968 | 2968 | -73.9587236619579 | 40.799185018043396 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9587236619579 40.7991850180434) |
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 );