This data as json, CSV (advanced)
Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail twitches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 21 | -73.9703781726172 | 40.778752613032104 | 16C-PM-1018-03 | 16C | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703781726172 40.7787526130321) | ||||
288 | 288 | -73.9731113265165 | 40.778664067635496 | 15A-PM-1017-01 | 15A | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | 0 | 0 | 1 | 1 | 0 | eating in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731113265165 40.7786640676355) | |||
344 | 344 | -73.9759432151552 | 40.7733240612552 | 8B-PM-1012-06 | 08B | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | on a bench | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9759432151552 40.7733240612552) | |||
394 | 394 | -73.9719888241794 | 40.7667681685356 | 4I-PM-1007-03 | 04I | PM | 10072018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | ran to tree | 0 | 0 | 0 | 0 | 0 | being chased | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9719888241794 40.7667681685356) | ||
646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954092292214 40.7979800395433) | |||
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) | ||||
726 | 726 | -73.973305698325 | 40.778382331129606 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.973305698325 40.7783823311296) | ||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | 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.9602913105578 40.7910635810038) | ||||
776 | 776 | -73.9686816795392 | 40.775770422666994 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686816795392 40.775770422667) | ||||
782 | 782 | -73.9710559113762 | 40.779427991420896 | 16C-PM-1018-01 | 16C | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | disappeared up other side of tree | POINT (-73.9710559113762 40.7794279914209) | |||
901 | 901 | -73.97022281317109 | 40.7742131587983 | 12F-PM-1007-12 | 12F | PM | 10072018 | 12 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 5 | 0 | 0 | 0 | 0 | 1 | going down tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9702228131711 40.7742131587983) | |||
908 | 908 | -73.9594120573719 | 40.78419457505979 | 26I-PM-1010-05 | 26I | PM | 10102018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9594120573719 40.7841945750598) | |||
1086 | 1086 | -73.9713399316534 | 40.77506780267571 | 12E-PM-1018-02 | 12E | PM | 10182018 | 2 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 3 | 0 | 0 | 1 | 0 | 0 | lounging on tree upside down | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9713399316534 40.7750678026757) | ||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670858934045 40.7753505024976) | ||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9775735077285 40.7692872082165) | |||
1161 | 1161 | -73.9694066600156 | 40.7805662180672 | 18C-PM-1018-06 | 18C | PM | 10182018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694066600156 40.7805662180672) | ||||
1331 | 1331 | -73.9588809150045 | 40.7847231576181 | 26I-PM-1010-01 | 26I | PM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588809150045 40.7847231576181) | ||||
1396 | 1396 | -73.9704677007779 | 40.7786860108302 | 16C-PM-1018-02 | 16C | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704677007779 40.7786860108302) | ||||
1592 | 1592 | -73.9575517912392 | 40.788915826819206 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575517912392 40.7889158268192) | |||||
1686 | 1686 | -73.9593373093799 | 40.7982428507976 | 39A-PM-1014-03 | 39A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. | Above Ground | 6 | Jumped from ground onto branch | 0 | 0 | 0 | 0 | 1 | digging? | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95933730937992 40.7982428507976) | |
1863 | 1863 | -73.96828305109541 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682830510954 40.7810151087286) | ||
2054 | 2054 | -73.97263812347471 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726381234747 40.7752694815985) | ||||
2067 | 2067 | -73.97250779335741 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | 0 | 0 | 0 | 0 | 0 | staring at me | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9725077933574 40.7654562710325) | ||
2090 | 2090 | -73.9569759970802 | 40.7931497452294 | 35F-PM-1012-03 | 35F | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569759970802 40.79314974522941) | ||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587678566254 40.7962656030995) | ||||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715921982161 40.7746153066601) | |||
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) | |||
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) | |||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) | ||||
2916 | 2916 | -73.95175251116791 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9517525111679 40.7974407641075) |
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 );