Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Indifferent, Zip_Codes, Community_Districts, City_Council_Districts, Police_Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | -73.96252481451499 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 25.0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.962524814515 40.7810022923615) | 19 | 4 | 19 | 13 | ||||||
10 | 10 | -73.9756603846107 | 40.7672531319384 | 3F-PM-1013-03 | 03F | PM | 1013 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9756603846107 40.7672531319384) | 19 | 4 | 19 | 13 | |||||
19 | 19 | -73.9799250782277 | 40.767610659888895 | 1B-AM-1012-03 | 01B | AM | 1012 | 3 | 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.9799250782277 40.7676106598889) | 19 | 4 | 19 | 13 | |||||
21 | 21 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 1006 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733905460282 40.7656337147768) | 19 | 4 | 19 | 13 | ||||||
22 | 22 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618094076328 40.7944097368153) | 19 | 4 | 19 | 13 | |||||
24 | 24 | -73.9613351649026 | 40.79098668513571 | 31D-AM-1014-03 | 31D | AM | 1014 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
25 | 25 | -73.9655670884957 | 40.7763728890554 | 16H-PM-1014-03 | 16H | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | followed man across bridge | POINT (-73.9655670884957 40.7763728890554) | 19 | 4 | 19 | 13 | ||||
30 | 30 | -73.973047824163 | 40.7700873791211 | 7F-AM-1008-03 | 07F | AM | 1008 | 3 | Adult | Gray | Gray+ | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.973047824163 40.7700873791211) | 19 | 4 | 19 | 13 | ||||||
33 | 33 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
38 | 38 | -73.9530791622513 | 40.79598856039671 | 40G-PM-1013-03 | 40G | PM | 1013 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530791622513 40.7959885603967) | 19 | 4 | 19 | 13 | ||||||
45 | 45 | -73.9795081274695 | 40.7691431548544 | 3B-PM-1007-03 | 03B | PM | 1007 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9795081274695 40.7691431548544) | 19 | 4 | 19 | 13 | ||||||
57 | 57 | -73.9714150090362 | 40.7774976423922 | 14C-PM-1006-03 | 14C | PM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9714150090362 40.7774976423922) | 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 | |||
61 | 61 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 1010 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on trunk | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
70 | 70 | -73.9561103688639 | 40.794914085004 | 37E-AM-1013-03 | 37E | AM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9561103688639 40.794914085004) | 19 | 4 | 19 | 13 | |||||
73 | 73 | -73.9757215415855 | 40.766820597698604 | 2F-PM-1014-03 | 02F | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757215415855 40.7668205976986) | 19 | 4 | 19 | 13 | |||||
84 | 84 | -73.9701634768603 | 40.777869143321794 | 15D-AM-1007-03 | 15D | AM | 1007 | 3 | Adult | Gray | Gray+ | Above Ground | 10.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701634768603 40.7778691433218) | 19 | 4 | 19 | 13 | ||||||
90 | 90 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 1020 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | 19 | 4 | 19 | 13 | ||||
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 | |||||
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 | |||||
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 | ||||
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 | |||||
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 | ||||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
201 | 201 | -73.9767100101318 | 40.7675779951996 | 2E-PM-1014-03 | 02E | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767100101318 40.7675779951996) | 19 | 4 | 19 | 13 | |||||
205 | 205 | -73.96795381633409 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 1013 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | eating (mushroom) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9679538163341 40.7837103696906) | 19 | 4 | 19 | 13 | ||||
209 | 209 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 1006 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | 19 | 4 | 19 | 13 | |||||
210 | 210 | -73.9752965316933 | 40.775253857578896 | 10B-AM-1006-03 | 10B | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
227 | 227 | -73.9755569170561 | 40.7668006977526 | 2F-AM-1006-03 | 02F | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25.0 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755569170561 40.7668006977526) | 19 | 4 | 19 | 13 | ||||
239 | 239 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 1010 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15.0 | tree | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594391759139 40.784115697669) | 19 | 4 | 19 | 13 | |||
254 | 254 | -73.9746965894947 | 40.766435172430896 | 2G-AM-1010-03 | 02G | AM | 1010 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9746965894947 40.7664351724309) | 19 | 4 | 19 | 13 | ||||||
255 | 255 | -73.9763116425885 | 40.768883957648704 | 4D-PM-1008-03 | 04D | PM | 1008 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
257 | 257 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | checkin' his stashes | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9767953468937 40.7676376977667) | 19 | 4 | 19 | 13 | ||||
258 | 258 | -73.9800896621713 | 40.7684379810317 | 2B-PM-1013-03 | 02B | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9800896621713 40.7684379810317) | 19 | 4 | 19 | 13 | |||||
267 | 267 | -73.95638478673159 | 40.790601226116294 | 33G-AM-1013-03 | 33G | AM | 1013 | 3 | ? | + | Only peeked head out | Above Ground | 13.0 | 0 | 0 | 0 | 0 | 0 | peeking out of tree,did *not* come out | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9563847867316 40.7906012261163) | 19 | 4 | 19 | 13 | |||||
268 | 268 | -73.9745427984089 | 40.7691848214817 | 5E-AM-1008-03 | 05E | AM | 1008 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9745427984089 40.7691848214817) | 19 | 4 | 19 | 13 | |||||
270 | 270 | -73.96472472541271 | 40.780613656578396 | 20G-PM-1013-03 | 20G | PM | 1013 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9647247254127 40.7806136565784) | 19 | 4 | 19 | 13 | |||||
272 | 272 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598015842806 40.7973522744237) | 19 | 4 | 19 | 13 | |||||
279 | 279 | -73.97686527856641 | 40.768483816820705 | 3D-PM-1010-03 | 03D | PM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768652785664 40.7684838168207) | 19 | 4 | 19 | 13 | |||||
293 | 293 | -73.9695468150218 | 40.7821142051746 | 20B-PM-1013-03 | 20B | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695468150218 40.7821142051746) | 19 | 4 | 19 | 13 | |||||
294 | 294 | -73.9713906492842 | 40.775006131014294 | 12E-PM-1018-03 | 12E | PM | 1018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
300 | 300 | -73.9710547484029 | 40.7723589827074 | 9F-PM-1014-03 | 09F | 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.9710547484029 40.7723589827074) | 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 | ||||||||||
306 | 306 | -73.9684806250183 | 40.7858776210151 | 24A-PM-1007-03 | 24A | PM | 1007 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684806250183 40.7858776210151) | 19 | 4 | 19 | 13 | ||||||
313 | 313 | -73.9642900903774 | 40.791701716884205 | 31A-AM-1010-03 | 31A | AM | 1010 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9642900903774 40.7917017168842) | 19 | 4 | 19 | 13 | ||||||
315 | 315 | -73.9654397484763 | 40.7798863522904 | 19F-PM-1017-03 | 19F | PM | 1017 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9654397484763 40.7798863522904) | 19 | 4 | 19 | 13 | |||||
318 | 318 | -73.95486485185579 | 40.7946730924872 | 38F-PM-1013-03 | 38F | PM | 1013 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548648518558 40.7946730924872) | 19 | 4 | 19 | 13 | |||||
345 | 345 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
355 | 355 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | me | POINT (-73.9570437717691 40.7948509408039) | 19 | 4 | 19 | 13 | ||||
361 | 361 | -73.96260656728941 | 40.788722645116 | 29D-AM-1014-03 | 29D | AM | 1014 | 3 | Juvenile | Gray | Gray+ | Above Ground | 35.0 | End of tree limb foraging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9626065672894 40.788722645116) | 19 | 4 | 19 | 13 | |||||
362 | 362 | -73.95890163858891 | 40.7911727679625 | 33E-PM-1012-03 | 33E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9589016385889 40.7911727679625) | 19 | 4 | 19 | 13 | |||||
377 | 377 | -73.9651796685091 | 40.7785578267586 | 18G-AM-1014-03 | 18G | AM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651796685091 40.7785578267586) | 19 | 4 | 19 | 13 | |||||
379 | 379 | -73.97509925643621 | 40.7743391883762 | 10B-PM-1014-03 | 10B | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | avoided people | POINT (-73.9750992564362 40.7743391883762) | 19 | 4 | 19 | 13 | ||||
383 | 383 | -73.9768617690725 | 40.7741877060705 | 9A-PM-1010-03 | 09A | PM | 1010 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze - standing on hind legs for ~10 seconds then scampered off | POINT (-73.9768617690725 40.7741877060705) | 19 | 4 | 19 | 13 | |||||
387 | 387 | -73.9737091707831 | 40.771373256751204 | 7E-AM-1006-03 | 07E | AM | 1006 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9737091707831 40.7713732567512) | 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 | |||||
390 | 390 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 1014 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
395 | 395 | -73.9768311751004 | 40.766717807255795 | 2E-AM-1010-03 | 02E | AM | 1010 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768311751004 40.7667178072558) | 19 | 4 | 19 | 13 | ||||||
403 | 403 | -73.96868007849409 | 40.77667390291379 | 15F-AM-1007-03 | 15F | AM | 1007 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686800784941 40.7766739029138) | 19 | 4 | 19 | 13 | ||||
417 | 417 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791536183194 40.7672705931866) | 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 | ||||||||
426 | 426 | -73.9722261495647 | 40.7690542072646 | 6G-PM-1020-03 | 06G | PM | 1020 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722261495647 40.7690542072646) | 19 | 4 | 19 | 13 | ||||||
430 | 430 | -73.9751615527833 | 40.767013871509 | 3F-AM-1006-03 | 03F | AM | 1006 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | on the path | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9751615527833 40.767013871509) | 19 | 4 | 19 | 13 | |||
444 | 444 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 1010 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632164738341 40.7921270121312) | 19 | 4 | 19 | 13 | |||||
450 | 450 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954959868822 40.7985404965582) | 19 | 4 | 19 | 13 | |||||
451 | 451 | -73.9646901432328 | 40.775995869679 | 15I-PM-1012-03 | 15I | PM | 1012 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9646901432328 40.775995869679) | 19 | 4 | 19 | 13 | ||||||
452 | 452 | -73.97118651343641 | 40.7785039981892 | 15C-AM-1010-03 | 15C | AM | 1010 | 3 | Adult | Gray | Gray+ | Above Ground | 6.0 | 0 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711865134364 40.7785039981892) | 19 | 4 | 19 | 13 | |||||
462 | 462 | -73.960300330029 | 40.795347587186896 | 36B-AM-1013-03 | 36B | AM | 1013 | 3 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960300330029 40.7953475871869) | 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 | |||||||
477 | 477 | -73.95846960832841 | 40.7980121226635 | 39B-PM-1014-03 | 39B | PM | 1014 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584696083284 40.7980121226635) | 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 | |||||
497 | 497 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 1007 | 3 | Adult | + | Above Ground | 40.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9604476047877 40.7938014328732) | 19 | 4 | 19 | 13 | |||||||
506 | 506 | -73.9681917366128 | 40.7723298813768 | 11I-PM-1012-03 | 11I | PM | 1012 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from the dog | POINT (-73.9681917366128 40.7723298813768) | 19 | 4 | 19 | 13 | |||||
516 | 516 | -73.9573930079918 | 40.7934570294469 | 35E-AM-1020-03 | 35E | AM | 1020 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9573930079918 40.7934570294469) | 19 | 4 | 19 | 13 | |||||
518 | 518 | -73.95447632818859 | 40.7969645476349 | 40F-PM-1006-03 | 40F | PM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9544763281886 40.7969645476349) | 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 | |||||
531 | 531 | -73.9777124331985 | 40.7704051056666 | 5B-AM-1008-03 | 05B | AM | 1008 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777124331985 40.7704051056666) | 19 | 4 | 19 | 13 | |||||
537 | 537 | -73.9765355395622 | 40.7735653237366 | 8B-AM-1007-03 | 08B | AM | 1007 | 3 | Adult | Gray | Gray+ | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765355395622 40.7735653237366) | 19 | 4 | 19 | 13 | ||||||
555 | 555 | -73.9696802053043 | 40.781605740612505 | 19B-PM-1018-03 | 19B | PM | 1018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9696802053043 40.7816057406125) | 19 | 4 | 19 | 13 | ||||
556 | 556 | -73.9628349778362 | 40.793887005205995 | 34A-PM-1013-03 | 34A | PM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9628349778362 40.793887005206) | 19 | 4 | 19 | 13 | |||||
558 | 558 | -73.9578981223015 | 40.798996775435796 | 41B-AM-1010-03 | 41B | AM | 1010 | 3 | Adult | + | Above Ground | 60.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9578981223015 40.7989967754358) | 19 | 4 | 19 | 13 | |||||||
561 | 561 | -73.96481954331921 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 1017 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | staring | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
576 | 576 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 1012 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9584064190878 40.7912992852442) | 19 | 4 | 19 | 13 | |||||
581 | 581 | -73.960876728048 | 40.790357245370004 | 31D-PM-1006-03 | 31D | PM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960876728048 40.79035724537) | 19 | 4 | 19 | 13 | |||||
584 | 584 | -73.9671147090087 | 40.7772624641112 | 16G-AM-1010-03 | 16G | AM | 1010 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | was hanging out w/ #2 until i showed up | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671147090087 40.7772624641112) | 19 | 4 | 19 | 13 | ||||
585 | 585 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 1006 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731457102903 40.7660255393205) | 19 | 4 | 19 | 13 | |||||
587 | 587 | -73.9707487237344 | 40.7800822831001 | 17B-PM-1012-03 | 17B | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 1 | 1 | 0 | 0 | 0 | 2/3 chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9707487237344 40.7800822831001) | 19 | 4 | 19 | 13 | ||||
588 | 588 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 1014 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2.0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
589 | 589 | -73.96989341826121 | 40.7708211633861 | 8H-PM-1014-03 | 08H | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9698934182612 40.7708211633861) | 19 | 4 | 19 | 13 | |||||
590 | 590 | -73.9596820155238 | 40.7932886803231 | 34D-PM-1007-03 | 34D | PM | 1007 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9596820155238 40.7932886803231) | 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 | ||||||
608 | 608 | -73.9688470831269 | 40.7844651946415 | 22A-AM-1008-03 | 22A | AM | 1008 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9688470831269 40.7844651946415) | 19 | 4 | 19 | 13 | ||||||
623 | 623 | -73.9711378905748 | 40.7696218346333 | 7H-AM-1006-03 | 07H | AM | 1006 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | on rock (large) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9711378905748 40.7696218346333) | 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 )