Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Eating, Foraging, Kuks, Quaas, Moans, Tail_twitches, Approaches, Indifferent, Runs_from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2101 | 2101 | -73.96774098419691 | 40.776357914063894 | 15G-PM-1019-08 | 15G | PM | 1019 | 8 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
2417 | 2417 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 1019 | 7 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9677593344667 40.7763054313195) | 19 | 4 | 19 | 13 | |||||||
5124 | 5124 | -73.96774098419691 | 40.776357914063894 | 15G-PM-1019-08 | 15G | PM | 1019 | 8 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
5440 | 5440 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 1019 | 7 | Adult | + | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9677593344667 40.7763054313195) | 19 | 4 | 19 | 13 | |||||||
7 | 7 | -73.97077370737709 | 40.780037346583796 | 17B-PM-1012-02 | 17B | PM | 1012 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 2/3 chasing each other | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9707737073771 40.7800373465838) | 19 | 4 | 19 | 13 | |||||
459 | 459 | -73.9701010964667 | 40.768891931450796 | 6I-PM-1013-02 | 06I | PM | 1013 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701010964667 40.7688919314508) | 19 | 4 | 19 | 13 | |||||
499 | 499 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 1006 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | 19 | 4 | 19 | 13 | ||||||
509 | 509 | -73.97182620344691 | 40.76667717974421 | 4I-PM-1007-02 | 04I | PM | 1007 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
3030 | 3030 | -73.97077370737709 | 40.780037346583796 | 17B-PM-1012-02 | 17B | PM | 1012 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 2/3 chasing each other | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9707737073771 40.7800373465838) | 19 | 4 | 19 | 13 | |||||
3482 | 3482 | -73.9701010964667 | 40.768891931450796 | 6I-PM-1013-02 | 06I | PM | 1013 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | Bushes | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9701010964667 40.7688919314508) | 19 | 4 | 19 | 13 | |||||
3522 | 3522 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 1006 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | 19 | 4 | 19 | 13 | ||||||
3532 | 3532 | -73.97182620344691 | 40.76667717974421 | 4I-PM-1007-02 | 04I | PM | 1007 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9718262034469 40.7666771797442) | 19 | 4 | 19 | 13 | ||||||
1927 | 1927 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 1006 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
4950 | 4950 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 1006 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
185 | 185 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
925 | 925 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 1014 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
1271 | 1271 | -73.9563311167069 | 40.79509015633371 | 38E-AM-1010-12 | 38E | AM | 1010 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1319 | 1319 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
2358 | 2358 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
2477 | 2477 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
3208 | 3208 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
3948 | 3948 | -73.97116665233759 | 40.776151305703394 | 13D-AM-1014-02 | 13D | AM | 1014 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
4294 | 4294 | -73.9563311167069 | 40.79509015633371 | 38E-AM-1010-12 | 38E | AM | 1010 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
4342 | 4342 | -73.97443873476259 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744387347626 40.7776953143835) | 19 | 4 | 19 | 13 | ||||||||
5381 | 5381 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 1010 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | chasing #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
5500 | 5500 | -73.9800669115792 | 40.767682513438395 | 1B-AM-1012-07 | 01B | AM | 1012 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
147 | 147 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 1013 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (chased by #1),found a nut,buried it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
228 | 228 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 1008 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | Oak tree | 0 | 1 | 0 | 0 | 0 | watching me | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
818 | 818 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 1010 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #6 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
987 | 987 | -73.97684509716998 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 1010 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97684509717 40.7709430375069) | 19 | 4 | 19 | 13 | |||||
1220 | 1220 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 1010 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772810073685 40.7693577540392) | 19 | 4 | 19 | 13 | |||||
1391 | 1391 | -73.96624099976421 | 40.789104293543204 | 28A-PM-1007-03 | 28A | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing #2 took #2 food wrapper and is foraging through it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
2284 | 2284 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 1012 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31.0 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
3170 | 3170 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 1013 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (chased by #1),found a nut,buried it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
3251 | 3251 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 1008 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | Oak tree | 0 | 1 | 0 | 0 | 0 | watching me | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
3841 | 3841 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 1010 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #6 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
4010 | 4010 | -73.97684509716998 | 40.7709430375069 | 5C-PM-1010-07 | 05C | PM | 1010 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 13.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.97684509717 40.7709430375069) | 19 | 4 | 19 | 13 | |||||
4243 | 4243 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 1010 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772810073685 40.7693577540392) | 19 | 4 | 19 | 13 | |||||
4414 | 4414 | -73.96624099976421 | 40.789104293543204 | 28A-PM-1007-03 | 28A | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 1 | chasing #2 took #2 food wrapper and is foraging through it | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
5307 | 5307 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 1012 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31.0 | on tree | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
80 | 80 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 1008 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | 19 | 4 | 19 | 13 | ||||
2137 | 2137 | -73.9691057326088 | 40.7765973509721 | 14F-PM-1012-07 | 14F | PM | 1012 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691057326088 40.7765973509721) | 19 | 4 | 19 | 13 | |||||
2825 | 2825 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 1012 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
2910 | 2910 | -73.97634308293419 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 1008 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | on tree facing downward | 0 | 1 | 0 | 0 | 0 | chased #12 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
3103 | 3103 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 1008 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | 19 | 4 | 19 | 13 | ||||
5160 | 5160 | -73.9691057326088 | 40.7765973509721 | 14F-PM-1012-07 | 14F | PM | 1012 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691057326088 40.7765973509721) | 19 | 4 | 19 | 13 | |||||
5848 | 5848 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 1012 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
5933 | 5933 | -73.97634308293419 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 1008 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3.0 | on tree facing downward | 0 | 1 | 0 | 0 | 0 | chased #12 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
241 | 241 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
942 | 942 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 1010 | 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.7700650799886) | 19 | 4 | 19 | 13 | ||
1642 | 1642 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 1010 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
1796 | 1796 | -73.9785114291288 | 40.771977958944895 | 6A-PM-1012-03 | 06A | PM | 1012 | 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) | 19 | 4 | 19 | 13 | |||||
1810 | 1810 | -73.9684834138222 | 40.772428912021105 | 11H-AM-1010-06 | 11H | AM | 1010 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9684834138222 40.7724289120211) | 19 | 4 | 19 | 13 | |||||
1852 | 1852 | -73.974451175321 | 40.770129463526395 | 6E-PM-1010-04 | 06E | PM | 1010 | 4 | 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 #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974451175321 40.7701294635264) | 19 | 4 | 19 | 13 | ||
2058 | 2058 | -73.97855365291359 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 1012 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9785536529136 40.7716184505002) | 19 | 4 | 19 | 13 | ||||
2819 | 2819 | -73.98085173247209 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 1014 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
3264 | 3264 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
3965 | 3965 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 1010 | 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.7700650799886) | 19 | 4 | 19 | 13 | ||
4665 | 4665 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 1010 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
4819 | 4819 | -73.9785114291288 | 40.771977958944895 | 6A-PM-1012-03 | 06A | PM | 1012 | 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) | 19 | 4 | 19 | 13 | |||||
4833 | 4833 | -73.9684834138222 | 40.772428912021105 | 11H-AM-1010-06 | 11H | AM | 1010 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9684834138222 40.7724289120211) | 19 | 4 | 19 | 13 | |||||
4875 | 4875 | -73.974451175321 | 40.770129463526395 | 6E-PM-1010-04 | 06E | PM | 1010 | 4 | 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 #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974451175321 40.7701294635264) | 19 | 4 | 19 | 13 | ||
5081 | 5081 | -73.97855365291359 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 1012 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9785536529136 40.7716184505002) | 19 | 4 | 19 | 13 | ||||
5842 | 5842 | -73.98085173247209 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 1014 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
9 | 9 | -73.9707274055755 | 40.772388908037705 | 10G-PM-1017-10 | 10G | PM | 1017 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | playing (with #9) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707274055755 40.7723889080377) | 19 | 4 | 19 | 13 | |||||
29 | 29 | -73.97142951022491 | 40.776954371947 | 14D-PM-1019-02 | 14D | PM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714295102249 40.776954371947) | 19 | 4 | 19 | 13 | ||||||
36 | 36 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 1008 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9664120826015 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
53 | 53 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 1017 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573656523498 40.7979754563974) | 19 | 4 | 19 | 13 | |||||
77 | 77 | -73.9532952763106 | 40.792007446262204 | 36I-AM-1017-08 | 36I | AM | 1017 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#7) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me) | POINT (-73.9532952763106 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
94 | 94 | -73.9676314068477 | 40.7788030406918 | 17E-AM-1017-08 | 17E | AM | 1017 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9676314068477 40.7788030406918) | 19 | 4 | 19 | 13 | ||||||
304 | 304 | -73.97574132156208 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 10.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
346 | 346 | -73.9562105506291 | 40.796699119790894 | 39D-AM-1008-02 | 39D | AM | 1008 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9562105506291 40.7966991197909) | 19 | 4 | 19 | 13 | ||||||
415 | 415 | -73.974828939898 | 40.7668886121909 | 2F-PM-1014-11 | 02F | PM | 1014 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974828939898 40.7668886121909) | 19 | 4 | 19 | 13 | ||||||
454 | 454 | -73.97714226252741 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771422625274 40.772361415776) | 19 | 4 | 19 | 13 | ||||||
472 | 472 | -73.9597845469964 | 40.790617930344794 | 32E-AM-1007-11 | 32E | AM | 1007 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597845469964 40.7906179303448) | 19 | 4 | 19 | 13 | ||||||
483 | 483 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 1014 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | chasing (a chipmunk) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
488 | 488 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 1014 | 3 | Adult | Gray | Gray+ | Above Ground | 30.0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 19 | 4 | 19 | 13 | |||||
563 | 563 | -73.95919577939921 | 40.79495688734529 | 36C-PM-1013-01 | 36C | PM | 1013 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9591957793992 40.7949568873453) | 19 | 4 | 19 | 13 | |||||
603 | 603 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 1008 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676692772518 40.7764726688908) | 19 | 4 | 19 | 13 | ||||||
661 | 661 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
693 | 693 | -73.96542881512659 | 40.7815953970174 | 21E-AM-1017-02 | 21E | AM | 1017 | 2 | Adult | Gray | Gray+ | Above Ground | 7.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9654288151266 40.7815953970174) | 19 | 4 | 19 | 13 | ||||||
728 | 728 | -73.9703076450783 | 40.770158422628995 | 8H-PM-1014-07 | 08H | PM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 5.0 | 0 | 1 | 0 | 0 | 0 | chasing (#8),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
757 | 757 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 1012 | 4 | Adult | Gray | Gray+ | Above Ground | 3.0 | on tree trunk | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9766342759486 40.7687518380873) | 19 | 4 | 19 | 13 | |||||
790 | 790 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 1008 | 2 | Adult | Gray | Gray+ | Above Ground | 10.0 | oak tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
822 | 822 | -73.9770948563006 | 40.7724063459185 | 7B-AM-1008-04 | 07B | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770948563006 40.7724063459185) | 19 | 4 | 19 | 13 | ||||||
828 | 828 | -73.9681874036914 | 40.7817948690964 | 20C-PM-1018-02 | 20C | PM | 1018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681874036914 40.7817948690964) | 19 | 4 | 19 | 13 | ||||||
948 | 948 | -73.974275954985 | 40.775472387930705 | 11B-AM-1007-02 | 11B | AM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.974275954985 40.7754723879307) | 19 | 4 | 19 | 13 | ||||||
955 | 955 | -73.9677146741772 | 40.77882313323371 | 17E-AM-1017-07 | 17E | AM | 1017 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677146741772 40.7788231332337) | 19 | 4 | 19 | 13 | ||||||
1022 | 1022 | -73.9698762023146 | 40.778205568811295 | 16D-PM-1010-09 | 16D | PM | 1010 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698762023146 40.7782055688113) | 19 | 4 | 19 | 13 | ||||||
1027 | 1027 | -73.958369699409 | 40.79024566683321 | 32F-PM-1008-01 | 32F | PM | 1008 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
1046 | 1046 | -73.9698064901149 | 40.7842538115839 | 21A-AM-1019-03 | 21A | AM | 1019 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698064901149 40.7842538115839) | 19 | 4 | 19 | 13 | |||||
1085 | 1085 | -73.9701824825872 | 40.776653057929295 | 14E-AM-1008-09 | 14E | AM | 1008 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
1089 | 1089 | -73.97072153948871 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 1006 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#6) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
1109 | 1109 | -73.9655238539833 | 40.7815633947684 | 21E-AM-1017-03 | 21E | AM | 1017 | 3 | Adult | Gray | Gray+ | Above Ground | 7.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655238539833 40.7815633947684) | 19 | 4 | 19 | 13 | ||||||
1184 | 1184 | -73.96318185288159 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 1018 | 1 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1194 | 1194 | -73.976658503418 | 40.768686845691704 | 4D-AM-1012-03 | 04D | AM | 1012 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.976658503418 40.7686868456917) | 19 | 4 | 19 | 13 | ||||||
1227 | 1227 | -73.96762706709958 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676270670996 40.776391443152) | 19 | 4 | 19 | 13 | ||||||
1229 | 1229 | -73.96148244372509 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 1013 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9614824437251 40.7912929799884) | 19 | 4 | 19 | 13 | ||||||
1234 | 1234 | -73.9719735582476 | 40.769304513357795 | 6G-PM-1020-02 | 06G | PM | 1020 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719735582476 40.7693045133578) | 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 |
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 )