Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Chasing, Climbing, Eating, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Zip_Codes, Community_Districts, City_Council_Districts
Highlight_Fur_Color ✖
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 | Latlong | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
485 | 485 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
598 | 598 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
865 | 865 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
945 | 945 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 1012 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
1485 | 1485 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
1528 | 1528 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 1017 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.7759815566123) | 19 | 4 | 19 | 13 | |||||
1875 | 1875 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
2159 | 2159 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 1017 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2504 | 2504 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 1017 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2578 | 2578 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
2781 | 2781 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
2868 | 2868 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 1017 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
3508 | 3508 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
3621 | 3621 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
3888 | 3888 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
3968 | 3968 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 1012 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
4508 | 4508 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
4551 | 4551 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 1017 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.7759815566123) | 19 | 4 | 19 | 13 | |||||
4898 | 4898 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
5182 | 5182 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 1017 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
5527 | 5527 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 1017 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
5601 | 5601 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
5804 | 5804 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
5891 | 5891 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 1017 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
44 | 44 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 1012 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
810 | 810 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 19 | 4 | 19 | 13 | |||
1203 | 1203 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 1018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
1417 | 1417 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
2123 | 2123 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 1018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
2927 | 2927 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
3067 | 3067 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 1012 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
3833 | 3833 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 19 | 4 | 19 | 13 | |||
4226 | 4226 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 1018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
4440 | 4440 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
5146 | 5146 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 1018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
5950 | 5950 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
534 | 534 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
726 | 726 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 1008 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
1416 | 1416 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2.0 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1582 | 1582 | -73.9655905300923 | 40.775261463802295 | 14I-PM-1018-06 | 14I | PM | 1018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
1653 | 1653 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 1018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | 19 | 4 | 19 | 13 | |||
1769 | 1769 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
1826 | 1826 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
1856 | 1856 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 1017 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2.0 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
3557 | 3557 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
3749 | 3749 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 1008 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
4439 | 4439 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2.0 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
4605 | 4605 | -73.9655905300923 | 40.775261463802295 | 14I-PM-1018-06 | 14I | PM | 1018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
4676 | 4676 | -73.96893059787509 | 40.781815249626604 | 19C-PM-1018-06 | 19C | PM | 1018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | Climbed fence | 1 | 0 | 1 | 0 | 0 | climbing (fence) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689305978751 40.7818152496266) | 19 | 4 | 19 | 13 | |||
4792 | 4792 | -73.97068515461841 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 1017 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
4849 | 4849 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
4879 | 4879 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 1017 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2.0 | Fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
344 | 344 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 1006 | 1 | Adult | Black | Black+ | Above Ground | 3.0 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
388 | 388 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 1013 | 3 | Juvenile | + | Above Ground | 3.0 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
1277 | 1277 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
1463 | 1463 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | 19 | 4 | 19 | 13 | |||||
1998 | 1998 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 1019 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
2366 | 2366 | -73.97113187902791 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 1010 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
2682 | 2682 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 1014 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | jumping back & forth on tree | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
2863 | 2863 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 1008 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
2892 | 2892 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 1013 | 5 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
2920 | 2920 | -73.96789565689801 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 1010 | 7 | Adult | Gray | Gray+ | Above Ground | 3.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
3367 | 3367 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 1006 | 1 | Adult | Black | Black+ | Above Ground | 3.0 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
3411 | 3411 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 1013 | 3 | Juvenile | + | Above Ground | 3.0 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
4300 | 4300 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
4486 | 4486 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | 19 | 4 | 19 | 13 | |||||
5021 | 5021 | -73.95992022335359 | 40.7972599930224 | 38A-AM-1019-02 | 38A | AM | 1019 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599202233536 40.7972599930224) | 19 | 4 | 19 | 13 | ||||||
5389 | 5389 | -73.97113187902791 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 1010 | 2 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
5705 | 5705 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 1014 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | jumping back & forth on tree | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
5886 | 5886 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 1008 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | was chased by # 11 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
5915 | 5915 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 1013 | 5 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
5943 | 5943 | -73.96789565689801 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 1010 | 7 | Adult | Gray | Gray+ | Above Ground | 3.0 | on fence | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
59 | 59 | -73.9520592496349 | 40.797507629981105 | 42G-PM-1014-03 | 42G | PM | 1014 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | on fence | 1 | 0 | 0 | 0 | 0 | prancing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
873 | 873 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 1013 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
899 | 899 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 1007 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4.0 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
1696 | 1696 | -73.95991976123891 | 40.7954836456006 | 36B-PM-1013-05 | 36B | PM | 1013 | 5 | Adult | Gray | Gray+ | Above Ground | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9599197612389 40.7954836456006) | 19 | 4 | 19 | 13 | ||||||
3082 | 3082 | -73.9520592496349 | 40.797507629981105 | 42G-PM-1014-03 | 42G | PM | 1014 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | on fence | 1 | 0 | 0 | 0 | 0 | prancing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
3896 | 3896 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 1013 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
3922 | 3922 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 1007 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4.0 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
4719 | 4719 | -73.95991976123891 | 40.7954836456006 | 36B-PM-1013-05 | 36B | PM | 1013 | 5 | Adult | Gray | Gray+ | Above Ground | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9599197612389 40.7954836456006) | 19 | 4 | 19 | 13 | ||||||
88 | 88 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | Ran up tree | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
613 | 613 | -73.9782603348665 | 40.7705790257951 | 5B-PM-1013-06 | 05B | PM | 1013 | 6 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782603348665 40.7705790257951) | 19 | 4 | 19 | 13 | ||||||
1066 | 1066 | -73.9769700777377 | 40.772848957496706 | 7B-AM-1008-08 | 07B | AM | 1008 | 8 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
1460 | 1460 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 1007 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
1772 | 1772 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 1008 | 9 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
1801 | 1801 | -73.96617859405309 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | climbed tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
2144 | 2144 | -73.973230162241 | 40.768982453144396 | 5F-AM-1007-01 | 05F | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973230162241 40.7689824531444) | 19 | 4 | 19 | 13 | ||||
2738 | 2738 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 1007 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5.0 | 1 | 1 | 0 | 0 | 0 | burying nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
3111 | 3111 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | Ran up tree | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
3636 | 3636 | -73.9782603348665 | 40.7705790257951 | 5B-PM-1013-06 | 05B | PM | 1013 | 6 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782603348665 40.7705790257951) | 19 | 4 | 19 | 13 | ||||||
4089 | 4089 | -73.9769700777377 | 40.772848957496706 | 7B-AM-1008-08 | 07B | AM | 1008 | 8 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
4483 | 4483 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 1007 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
4795 | 4795 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 1008 | 9 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
4824 | 4824 | -73.96617859405309 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | climbed tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
5167 | 5167 | -73.973230162241 | 40.768982453144396 | 5F-AM-1007-01 | 05F | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973230162241 40.7689824531444) | 19 | 4 | 19 | 13 | ||||
5761 | 5761 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 1007 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5.0 | 1 | 1 | 0 | 0 | 0 | burying nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
163 | 163 | -73.96294833745279 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 6.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
1574 | 1574 | -73.96862962178929 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 1014 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
3016 | 3016 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 6.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
3186 | 3186 | -73.96294833745279 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 6.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census" ( "Longitude" REAL, "Latitude" REAL, "Unique_Squirrel_ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare_Squirrel_Number" INTEGER, "Age" REAL, "Primary_Fur_Color" REAL, "Highlight_Fur_Color" REAL, "Combination_of_Primary_and_Highlight_Color" TEXT, "Color_notes" REAL, "Location" REAL, "Above_Ground_Sighter_Measurement" REAL, "Specific_Location" REAL, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other_Activities" REAL, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail_flags" INTEGER, "Tail_twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs_from" INTEGER, "Other_Interactions" REAL, "Latlong" TEXT, "Zip_Codes" REAL, "Community_Districts" INTEGER, "Borough_Boundaries" INTEGER, "City_Council_Districts" INTEGER, "Police_Precincts" INTEGER )