Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Date, Hectare_Squirrel_Number, Age, Combination_of_Primary_and_Highlight_Color, Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 1019 | 4 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
3 | 3 | -73.9795454787631 | 40.768802689274104 | 3B-PM-1007-09 | 03B | PM | 1007 | 9 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
32 | 32 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 1010 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
229 | 229 | -73.96931200900549 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 1018 | 7 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
303 | 303 | -73.9561344937861 | 40.794082388408604 | 37F-PM-1014-03 | 37F | PM | 1014 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
336 | 336 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 1007 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694240327509 40.7755898126674) | 19 | 4 | 19 | 13 | |||||||
358 | 358 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
425 | 425 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 1007 | 3 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
429 | 429 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
445 | 445 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 1012 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
468 | 468 | -73.9744555348544 | 40.772849810635705 | 8D-PM-1007-03 | 08D | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
527 | 527 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
530 | 530 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
579 | 579 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 1019 | 13 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9708225719705 40.7772497804149) | 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 | ||||||||
600 | 600 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 1013 | 8 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
645 | 645 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 1007 | 8 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
677 | 677 | -73.95283537022091 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 1019 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
691 | 691 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 1012 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686778167484 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
787 | 787 | -73.9686737866872 | 40.773971402373206 | 12G-PM-1007-06 | 12G | PM | 1007 | 6 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
819 | 819 | -73.97357503529591 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 1008 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
859 | 859 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583934264026 40.7854742185504) | 19 | 4 | 19 | 13 | ||||||||||
885 | 885 | -73.9725669210177 | 40.768149698902896 | 5H-AM-1007-01 | 05H | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9725669210177 40.7681496989029) | 19 | 4 | 19 | 13 | |||||||
894 | 894 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
929 | 929 | -73.97083718064292 | 40.7764813666684 | 14D-AM-1014-14 | 14D | AM | 1014 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708371806429 40.7764813666684) | 19 | 4 | 19 | 13 | |||||||
1122 | 1122 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
1134 | 1134 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | mushroom | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
1156 | 1156 | -73.96369718436651 | 40.78256385373621 | 22F-AM-1007-04 | 22F | AM | 1007 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
1204 | 1204 | -73.97055600790999 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 1006 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97055600791 40.7698499183436) | 19 | 4 | 19 | 13 | |||||||
1238 | 1238 | -73.95950023395079 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 1017 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
1273 | 1273 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 1008 | 2 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
1289 | 1289 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 1008 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
1308 | 1308 | -73.95348783164721 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 1019 | 1 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9534878316472 40.7978951981698) | 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 | ||||||||
1340 | 1340 | -73.9709407456459 | 40.776423522087 | 14D-AM-1014-13 | 14D | AM | 1014 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709407456459 40.776423522087) | 19 | 4 | 19 | 13 | |||||||
1484 | 1484 | -73.97071972744808 | 40.777395680343105 | 14D-PM-1019-12 | 14D | PM | 1019 | 12 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707197274481 40.7773956803431) | 19 | 4 | 19 | 13 | ||||||||
1509 | 1509 | -73.9587401274261 | 40.7960322222949 | 37C-PM-1013-03 | 37C | PM | 1013 | 3 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9587401274261 40.7960322222949) | 19 | 4 | 19 | 13 | |||||||
1529 | 1529 | -73.9600738985438 | 40.793832879875204 | 35C-PM-1013-08 | 35C | PM | 1013 | 8 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
1531 | 1531 | -73.9542990150586 | 40.794091530067796 | 37G-PM-1007-09 | 37G | PM | 1007 | 9 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
1551 | 1551 | -73.95466167829221 | 40.790974533738996 | 34I-PM-1010-05 | 34I | PM | 1010 | 5 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 | ||||||||
1567 | 1567 | -73.97870151846621 | 40.7690114585688 | 3B-PM-1007-06 | 03B | PM | 1007 | 6 | Juvenile | + | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787015184662 40.7690114585688) | 19 | 4 | 19 | 13 | |||||||||
1676 | 1676 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
1689 | 1689 | -73.9761223919286 | 40.7685998275864 | 4E-PM-1008-06 | 04E | PM | 1008 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761223919286 40.7685998275864) | 19 | 4 | 19 | 13 | |||||||
1859 | 1859 | -73.97036835101758 | 40.774397536395796 | 12F-PM-1007-10 | 12F | PM | 1007 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
1885 | 1885 | -73.9506062997507 | 40.797618949667395 | 42H-PM-1014-03 | 42H | PM | 1014 | 3 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9506062997507 40.7976189496674) | 12,423 | 18 | 4 | 36 | 18 | ||||||||
1995 | 1995 | -73.9690080105286 | 40.7710230515054 | 9I-PM-1010-03 | 09I | PM | 1010 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9690080105286 40.7710230515054) | 19 | 4 | 19 | 13 | |||||||
2014 | 2014 | -73.95877018015099 | 40.793412394152796 | 35D-PM-1013-04 | 35D | PM | 1013 | 4 | Juvenile | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958770180151 40.7934123941528) | 19 | 4 | 19 | 13 | |||||||
2039 | 2039 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 1019 | 11 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.970720187655 40.7774564799983) | 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 | |||||||||
2163 | 2163 | -73.9596413903948 | 40.790312888902896 | 32E-PM-1017-14 | 32E | PM | 1017 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
2208 | 2208 | -73.96620636423451 | 40.789077866530704 | 28A-PM-1007-04 | 28A | PM | 1007 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 0 | looking at me & #5 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
2223 | 2223 | -73.95769134926691 | 40.7994216061391 | 41B-AM-1010-11 | 41B | AM | 1010 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | eating a mushroom! | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576913492669 40.7994216061391) | 19 | 4 | 19 | 13 | ||||||
2235 | 2235 | -73.9704778551644 | 40.77831191136271 | 15D-AM-1007-05 | 15D | AM | 1007 | 5 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
2265 | 2265 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 1007 | 4 | Juvenile | Gray | Gray+ | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2292 | 2292 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 1010 | 6 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
2369 | 2369 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 1013 | 7 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2438 | 2438 | -73.9758152322587 | 40.76923774014671 | 4E-PM-1008-03 | 04E | PM | 1008 | 3 | Adult | Gray | Gray+ | 0 | 1 | 0 | 0 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
2488 | 2488 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 1007 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565260889843 40.7991807924337) | 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 | |||||||
2753 | 2753 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 1010 | 2 | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2818 | 2818 | -73.9705331808443 | 40.769994357129605 | 7H-AM-1006-09 | 07H | AM | 1006 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705331808443 40.7699943571296) | 19 | 4 | 19 | 13 | |||||||
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 | ||||||
2911 | 2911 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
3024 | 3024 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 1019 | 4 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
3026 | 3026 | -73.9795454787631 | 40.768802689274104 | 3B-PM-1007-09 | 03B | PM | 1007 | 9 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
3055 | 3055 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 1010 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
3252 | 3252 | -73.96931200900549 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 1018 | 7 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
3326 | 3326 | -73.9561344937861 | 40.794082388408604 | 37F-PM-1014-03 | 37F | PM | 1014 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
3359 | 3359 | -73.96942403275091 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 1007 | 2 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694240327509 40.7755898126674) | 19 | 4 | 19 | 13 | |||||||
3381 | 3381 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
3448 | 3448 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 1007 | 3 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
3452 | 3452 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
3468 | 3468 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 1012 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
3491 | 3491 | -73.9744555348544 | 40.772849810635705 | 8D-PM-1007-03 | 08D | PM | 1007 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9744555348544 40.7728498106357) | 19 | 4 | 19 | 13 | |||||||
3550 | 3550 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
3553 | 3553 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
3602 | 3602 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 1019 | 13 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9708225719705 40.7772497804149) | 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 | ||||||||
3623 | 3623 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 1013 | 8 | Adult | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
3668 | 3668 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 1007 | 8 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
3700 | 3700 | -73.95283537022091 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 1019 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
3714 | 3714 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 1012 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686778167484 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
3810 | 3810 | -73.9686737866872 | 40.773971402373206 | 12G-PM-1007-06 | 12G | PM | 1007 | 6 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
3842 | 3842 | -73.97357503529591 | 40.7694500333777 | 6F-PM-1008-06 | 06F | PM | 1008 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | White patches. Almost looks like fox squirrel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735750352959 40.7694500333777) | 19 | 4 | 19 | 13 | ||||||
3882 | 3882 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583934264026 40.7854742185504) | 19 | 4 | 19 | 13 | ||||||||||
3908 | 3908 | -73.9725669210177 | 40.768149698902896 | 5H-AM-1007-01 | 05H | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9725669210177 40.7681496989029) | 19 | 4 | 19 | 13 | |||||||
3917 | 3917 | -73.96836135162249 | 40.772590884749896 | 11H-AM-1010-03 | 11H | AM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9683613516225 40.7725908847499) | 19 | 4 | 19 | 13 | |||||||
3952 | 3952 | -73.97083718064292 | 40.7764813666684 | 14D-AM-1014-14 | 14D | AM | 1014 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708371806429 40.7764813666684) | 19 | 4 | 19 | 13 | |||||||
4145 | 4145 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
4157 | 4157 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | mushroom | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
4179 | 4179 | -73.96369718436651 | 40.78256385373621 | 22F-AM-1007-04 | 22F | AM | 1007 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
4227 | 4227 | -73.97055600790999 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 1006 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97055600791 40.7698499183436) | 19 | 4 | 19 | 13 | |||||||
4261 | 4261 | -73.95950023395079 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 1017 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
4296 | 4296 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 1008 | 2 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
4312 | 4312 | -73.9765306970303 | 40.769495687585895 | 4D-PM-1008-09 | 04D | PM | 1008 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
4331 | 4331 | -73.95348783164721 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 1019 | 1 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9534878316472 40.7978951981698) | 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 | ||||||||
4363 | 4363 | -73.9709407456459 | 40.776423522087 | 14D-AM-1014-13 | 14D | AM | 1014 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9709407456459 40.776423522087) | 19 | 4 | 19 | 13 | |||||||
4507 | 4507 | -73.97071972744808 | 40.777395680343105 | 14D-PM-1019-12 | 14D | PM | 1019 | 12 | Adult | Gray | Gray+ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707197274481 40.7773956803431) | 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 )