Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Combination_of_Primary_and_Highlight_Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | -73.955710327539 | 40.797451079756705 | 40D-AM-1013-03 | 40D | AM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955710327539 40.7974510797567) | 19 | 4 | 19 | 13 | |||||
102 | 102 | -73.95657388959721 | 40.7900160952624 | 32H-AM-1010-01 | 32H | AM | 1010 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | not sure; walking-stop-walking-stop | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | did seem to observe me for a moment | POINT (-73.9565738895972 40.7900160952624) | 19 | 4 | 19 | 13 | |||
103 | 103 | -73.9662895079734 | 40.7843300758044 | 23C-AM-1019-01 | 23C | AM | 1019 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 7.0 | 0 | 0 | 1 | 1 | 0 | eating (on branch) | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662895079734 40.7843300758044) | 19 | 4 | 19 | 13 | |||
104 | 104 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
105 | 105 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 1013 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.969345754447 40.7770429650288) | 19 | 4 | 19 | 13 | |||||
106 | 106 | -73.970962498391 | 40.7766899040856 | 14D-AM-1014-05 | 14D | AM | 1014 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970962498391 40.7766899040856) | 19 | 4 | 19 | 13 | |||||
107 | 107 | -73.95874591363909 | 40.7982497351812 | 40B-PM-1014-05 | 40B | PM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587459136391 40.7982497351812) | 19 | 4 | 19 | 13 | |||||
108 | 108 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 1007 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
109 | 109 | -73.95302635524891 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 1007 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
110 | 110 | -73.96280415779341 | 40.7884180156055 | 28D-AM-1012-06 | 28D | AM | 1012 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 5.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9628041577934 40.7884180156055) | 19 | 4 | 19 | 13 | |||||
111 | 111 | -73.9558118887106 | 40.796885713436 | 39E-PM-1013-01 | 39E | PM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9558118887106 40.796885713436) | 19 | 4 | 19 | 13 | ||||
112 | 112 | -73.9596505138955 | 40.794036773498796 | 35C-PM-1013-06 | 35C | PM | 1013 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596505138955 40.7940367734988) | 19 | 4 | 19 | 13 | |||||
113 | 113 | -73.9680774548516 | 40.7762491903691 | 14F-PM-1012-01 | 14F | PM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680774548516 40.7762491903691) | 19 | 4 | 19 | 13 | |||||
114 | 114 | -73.96721526968341 | 40.782387458182896 | 21D-AM-1008-05 | 21D | AM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9672152696834 40.7823874581829) | 19 | 4 | 19 | 13 | |||||
115 | 115 | -73.97263812347471 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 1014 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726381234747 40.7752694815985) | 19 | 4 | 19 | 13 | |||||
116 | 116 | -73.9640989602986 | 40.789929543926505 | 29B-PM-1010-03 | 29B | PM | 1010 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9640989602986 40.7899295439265) | 19 | 4 | 19 | 13 | |||||
117 | 117 | -73.9675697600155 | 40.776679741446294 | 15G-PM-1019-06 | 15G | PM | 1019 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675697600155 40.7766797414463) | 19 | 4 | 19 | 13 | ||||
118 | 118 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | 19 | 4 | 19 | 13 | |||
119 | 119 | -73.95292302079079 | 40.7960663442573 | 40G-PM-1013-06 | 40G | PM | 1013 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9529230207908 40.7960663442573) | 19 | 4 | 19 | 13 | |||||
120 | 120 | -73.9729378674198 | 40.7672407594559 | 4H-AM-1006-04 | 04H | AM | 1006 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | met #3 while foraging and briefly tussled | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729378674198 40.7672407594559) | 19 | 4 | 19 | 13 | |||||
121 | 121 | -73.9698642668906 | 40.7784669316504 | 16D-PM-1010-10 | 16D | PM | 1010 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698642668906 40.7784669316504) | 19 | 4 | 19 | 13 | ||||||
122 | 122 | -73.9719901848577 | 40.7720525965356 | 9F-PM-1014-07 | 09F | PM | 1014 | 7 | Adult | Black | Black+ | !!! | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719901848577 40.7720525965356) | 19 | 4 | 19 | 13 | |||||
123 | 123 | -73.96908283251791 | 40.781803817227505 | 19C-PM-1018-04 | 19C | PM | 1018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690828325179 40.7818038172275) | 19 | 4 | 19 | 13 | |||||
124 | 124 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 1007 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540908513075 40.794201225045) | 19 | 4 | 19 | 13 | |||||
125 | 125 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.963911430308 40.7809127228847) | 19 | 4 | 19 | 13 | |||||
126 | 126 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 1014 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
127 | 127 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 1017 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9798390387307 40.7700761090896) | 19 | 4 | 19 | 13 | |||||
128 | 128 | -73.97567542977471 | 40.7738518843446 | 9B-PM-1013-02 | 09B | PM | 1013 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9756754297747 40.7738518843446) | 19 | 4 | 19 | 13 | |||||
129 | 129 | -73.960094705031 | 40.7916066137699 | 33D-AM-1017-01 | 33D | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960094705031 40.7916066137699) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9624296435843 | 40.791320813687 | 31C-PM-1010-02 | 31C | PM | 1010 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9624296435843 40.791320813687) | 19 | 4 | 19 | 13 | |||||
131 | 131 | -73.97149072356758 | 40.774058386152 | 11E-PM-1012-01 | 11E | PM | 1012 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714907235676 40.774058386152) | 19 | 4 | 19 | 13 | |||||
132 | 132 | -73.95121209494779 | 40.7947945266515 | 39I-PM-1013-01 | 39I | PM | 1013 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | along the road | 0 | 0 | 0 | 1 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9512120949478 40.7947945266515) | 19 | 4 | 19 | 13 | ||||
133 | 133 | -73.9673919075839 | 40.7786845769177 | 17F-PM-1020-05 | 17F | PM | 1020 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9673919075839 40.7786845769177) | 19 | 4 | 19 | 13 | ||||||
134 | 134 | -73.964593167562 | 40.7780374890066 | 18H-PM-1014-02 | 18H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964593167562 40.7780374890066) | 19 | 4 | 19 | 13 | |||||
135 | 135 | -73.9779811967788 | 40.7675178797546 | 2D-AM-1007-01 | 02D | AM | 1007 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9779811967788 40.7675178797546) | 19 | 4 | 19 | 13 | |||||
136 | 136 | -73.95807856006171 | 40.795798131089704 | 37C-PM-1013-01 | 37C | PM | 1013 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9580785600617 40.7957981310897) | 19 | 4 | 19 | 13 | |||||
137 | 137 | -73.9694169352433 | 40.774440829385796 | 12G-PM-1007-03 | 12G | PM | 1007 | 3 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | bushes | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | friendly | POINT (-73.9694169352433 40.7744408293858) | 19 | 4 | 19 | 13 | ||||
138 | 138 | -73.97047902632241 | 40.776227064566605 | 13E-AM-1017-01 | 13E | AM | 1017 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | in middle of path | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704790263224 40.7762270645666) | 19 | 4 | 19 | 13 | |||||
139 | 139 | -73.972069937746 | 40.765940262783204 | 3I-PM-1013-04 | 03I | PM | 1013 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972069937746 40.7659402627832) | 19 | 4 | 19 | 13 | |||||
140 | 140 | -73.97868986562791 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 1006 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786898656279 40.7720833097065) | 19 | 4 | 19 | 13 | |||||
141 | 141 | -73.96431539204279 | 40.78208185169571 | 22F-PM-1014-05 | 22F | PM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9643153920428 40.7820818516957) | 19 | 4 | 19 | 13 | |||||
142 | 142 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 1013 | 8 | Adult | Black | Black+ | Above Ground | 4.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
143 | 143 | -73.9590074024938 | 40.7907059424675 | 32E-PM-1017-05 | 32E | PM | 1017 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9590074024938 40.7907059424675) | 19 | 4 | 19 | 13 | |||||
144 | 144 | -73.9761527947483 | 40.770960700253895 | 6C-AM-1007-06 | 06C | AM | 1007 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | disappeared when jogger ran by | POINT (-73.9761527947483 40.7709607002539) | 19 | 4 | 19 | 13 | ||||
145 | 145 | -73.97535742799359 | 40.768321169425704 | 4E-PM-1008-08 | 04E | PM | 1008 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
146 | 146 | -73.9564777440695 | 40.7993068355401 | 42C-AM-1007-01 | 42C | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | nut in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9564777440695 40.7993068355401) | 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 | |||
148 | 148 | -73.9698231469857 | 40.7702048311133 | 8I-PM-1013-04 | 08I | PM | 1013 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698231469857 40.7702048311133) | 19 | 4 | 19 | 13 | |||||
149 | 149 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 1012 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564599077179 40.7965185098695) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9562765288004 | 40.78806179638679 | 31I-PM-1019-02 | 31I | PM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562765288004 40.7880617963868) | 19 | 4 | 19 | 13 | ||||||
151 | 151 | -73.9715621134573 | 40.7695918717513 | 7H-AM-1006-02 | 07H | AM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | running (along ground,up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715621134573 40.7695918717513) | 19 | 4 | 19 | 13 | ||||
152 | 152 | -73.95886101956991 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 1014 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9588610195699 40.7945269936639) | 19 | 4 | 19 | 13 | ||||
153 | 153 | -73.9752225195115 | 40.7703747669865 | 6D-PM-1020-05 | 06D | PM | 1020 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9752225195115 40.7703747669865) | 19 | 4 | 19 | 13 | ||||||
154 | 154 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 1014 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958932543729 40.7913445531266) | 19 | 4 | 19 | 13 | |||||
155 | 155 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 1018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9649611089685 40.7814371834837) | 19 | 4 | 19 | 13 | |||||
156 | 156 | -73.9787796921165 | 40.7707526535381 | 5A-PM-1010-01 | 05A | PM | 1010 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9787796921165 40.7707526535381) | 19 | 4 | 19 | 13 | |||||
157 | 157 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 1006 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | 19 | 4 | 19 | 13 | |||||
158 | 158 | -73.9742010726136 | 40.769150169929 | 5F-AM-1007-03 | 05F | AM | 1007 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742010726136 40.769150169929) | 19 | 4 | 19 | 13 | |||||
159 | 159 | -73.9632337134707 | 40.791468237073396 | 31B-PM-1007-01 | 31B | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 1 | 1 | 0 | 0 | chasing #2 and climbing tree w/ #2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
160 | 160 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959514034869 40.789911786416) | 19 | 4 | 19 | 13 | ||||
161 | 161 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.7757055884538) | 19 | 4 | 19 | 13 | ||||
162 | 162 | -73.97633735105359 | 40.774116893392794 | 9B-PM-1013-09 | 09B | PM | 1013 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (people) | POINT (-73.9763373510536 40.7741168933928) | 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 | ||||||
164 | 164 | -73.95320745731391 | 40.793466946490796 | 37H-PM-1006-06 | 37H | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532074573139 40.7934669464908) | 19 | 4 | 19 | 13 | ||||
165 | 165 | -73.95828003055091 | 40.798947371297395 | 40B-PM-1014-03 | 40B | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582800305509 40.7989473712974) | 19 | 4 | 19 | 13 | |||||
166 | 166 | -73.9636482556874 | 40.7775831570186 | 18I-PM-1007-05 | 18I | PM | 1007 | 5 | Juvenile | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | jumping crazily / digging hole | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9636482556874 40.7775831570186) | 19 | 4 | 19 | 13 | ||||
167 | 167 | -73.9638526062093 | 40.782693848993 | 22F-AM-1007-02 | 22F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638526062093 40.782693848993) | 19 | 4 | 19 | 13 | ||||
168 | 168 | -73.97346875380642 | 40.769430895922206 | 6F-PM-1008-04 | 06F | PM | 1008 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734687538064 40.7694308959222) | 19 | 4 | 19 | 13 | ||||
169 | 169 | -73.9580813119325 | 40.79055382370421 | 32F-PM-1008-04 | 32F | PM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580813119325 40.7905538237042) | 19 | 4 | 19 | 13 | ||||||
170 | 170 | -73.972154069981 | 40.769012800972206 | 6G-AM-1008-03 | 06G | AM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.972154069981 40.7690128009722) | 19 | 4 | 19 | 13 | ||||
171 | 171 | -73.9550235589287 | 40.7951312356844 | 38F-AM-1018-03 | 38F | AM | 1018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9550235589287 40.7951312356844) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.9761579527932 | 40.7755877312075 | 10A-PM-1014-02 | 10A | PM | 1014 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | in the bushes beneath a tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9761579527932 40.7755877312075) | 19 | 4 | 19 | 13 | ||||
173 | 173 | -73.9607746337979 | 40.793958106938206 | 35B-AM-1010-01 | 35B | AM | 1010 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn | 0 | 0 | 0 | 0 | 0 | walking w/ something in mouth | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9607746337979 40.7939581069382) | 19 | 4 | 19 | 13 | ||||
174 | 174 | -73.9766195697096 | 40.766190726154704 | 1F-AM-1010-04 | 01F | AM | 1010 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766195697096 40.7661907261547) | 19 | 4 | 19 | 13 | ||||||
175 | 175 | -73.9682688752331 | 40.7711934835539 | 9I-PM-1010-06 | 09I | PM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682688752331 40.7711934835539) | 19 | 4 | 19 | 13 | |||||
176 | 176 | -73.9652921233647 | 40.790440565854 | 29A-PM-1019-01 | 29A | PM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9652921233647 40.790440565854) | 19 | 4 | 19 | 13 | |||||
177 | 177 | -73.9731113265165 | 40.778664067635496 | 15A-PM-1017-01 | 15A | PM | 1017 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10.0 | 0 | 0 | 1 | 1 | 0 | eating in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731113265165 40.7786640676355) | 19 | 4 | 19 | 13 | ||||
178 | 178 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 1012 | 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 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715921982161 40.7746153066601) | 19 | 4 | 19 | 13 | ||||
179 | 179 | -73.95257524081691 | 40.7954915417553 | 39H-AM-1007-03 | 39H | AM | 1007 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9525752408169 40.7954915417553) | 19 | 4 | 19 | 13 | |||||
180 | 180 | -73.95560399976209 | 40.7977549157287 | 40D-AM-1013-05 | 40D | AM | 1013 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9556039997621 40.7977549157287) | 19 | 4 | 19 | 13 | ||||||
181 | 181 | -73.97203897567171 | 40.7763524091989 | 13C-PM-1019-02 | 13C | PM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720389756717 40.7763524091989) | 19 | 4 | 19 | 13 | ||||||
182 | 182 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 1012 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20.0 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615402629655 40.7924082330328) | 19 | 4 | 19 | 13 | |||
183 | 183 | -73.9801971465604 | 40.7697081749827 | 3A-PM-1017-04 | 03A | PM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9801971465604 40.7697081749827) | 19 | 4 | 19 | 13 | |||||
184 | 184 | -73.97470601437419 | 40.7728528164878 | 8C-AM-1007-02 | 08C | AM | 1007 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | peeps out from behind tree at cooing tourists | POINT (-73.9747060143742 40.7728528164878) | 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 | |||||
186 | 186 | -73.9710273070712 | 40.776652124615296 | 14D-PM-1019-16 | 14D | PM | 1019 | 16 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9710273070712 40.7766521246153) | 19 | 4 | 19 | 13 | |||||
187 | 187 | -73.97908754803579 | 40.767610478065706 | 2C-AM-1010-03 | 02C | AM | 1010 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
188 | 188 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 1010 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
189 | 189 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 1018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
190 | 190 | -73.96967203626271 | 40.779185159819704 | 17D-AM-1008-04 | 17D | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9696720362627 40.7791851598197) | 19 | 4 | 19 | 13 | |||||
191 | 191 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 1007 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
192 | 192 | -73.95701300171591 | 40.799602742862504 | 42B-AM-1014-02 | 42B | AM | 1014 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570130017159 40.7996027428625) | 19 | 4 | 19 | 13 | |||||
193 | 193 | -73.9577919365342 | 40.796085328505896 | 38C-PM-1014-08 | 38C | PM | 1014 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9577919365342 40.7960853285059) | 19 | 4 | 19 | 13 | |||||
194 | 194 | -73.96081673001041 | 40.795434868826796 | 36A-PM-1013-05 | 36A | PM | 1013 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
195 | 195 | -73.9737872335563 | 40.7726586835985 | 8D-PM-1007-01 | 08D | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9737872335563 40.7726586835985) | 19 | 4 | 19 | 13 | |||||
196 | 196 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 1017 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960237785199 40.7907831607574) | 19 | 4 | 19 | 13 | |||||
197 | 197 | -73.96761128642859 | 40.7772792086081 | 16F-AM-1008-03 | 16F | AM | 1008 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | road | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9676112864286 40.7772792086081) | 19 | 4 | 19 | 13 | ||||
198 | 198 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 1006 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | 19 | 4 | 19 | 13 | ||||
199 | 199 | -73.9720887275538 | 40.776079953797606 | 13D-PM-1018-08 | 13D | PM | 1018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720887275538 40.7760799537976) | 19 | 4 | 19 | 13 | ||||
200 | 200 | -73.96704295859901 | 40.778437071937105 | 17F-AM-1007-05 | 17F | AM | 1007 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.967042958599 40.7784370719371) | 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 )