Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Eating, Foraging, Kuks, Tail_flags, Tail_twitches, Indifferent, Other_Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
55 | 55 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 1013 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching me from tree - curious | POINT (-73.9556817958407 40.788852000621) | 19 | 4 | 19 | 13 | ||||
62 | 62 | -73.97779784978941 | 40.7668620784309 | 1D-AM-1006-01 | 01D | AM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9777978497894 40.7668620784309) | 19 | 4 | 19 | 13 | |||||
64 | 64 | -73.976769659152 | 40.7741908010484 | 9A-AM-1013-04 | 09A | AM | 1013 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976769659152 40.7741908010484) | 19 | 4 | 19 | 13 | |||||
82 | 82 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 1017 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | 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 | |||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | |||||
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 | |||||
208 | 208 | -73.96185915109321 | 40.7921343738001 | 32C-PM-1013-11 | 32C | PM | 1013 | 11 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9618591510932 40.7921343738001) | 19 | 4 | 19 | 13 | ||||||
211 | 211 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 1006 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9755041276839 40.7678213857557) | 19 | 4 | 19 | 13 | |||||
214 | 214 | -73.9646597452128 | 40.7827698220703 | 22F-AM-1007-07 | 22F | AM | 1007 | 7 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | alert & aware | POINT (-73.9646597452128 40.7827698220703) | 19 | 4 | 19 | 13 | ||||
215 | 215 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 1018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9616999731028 40.7954126939561) | 19 | 4 | 19 | 13 | ||||
263 | 263 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 1013 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9591667162801 40.7937602121568) | 19 | 4 | 19 | 13 | ||||
266 | 266 | -73.9678923667678 | 40.7819675626236 | 20C-PM-1018-05 | 20C | PM | 1018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9678923667678 40.7819675626236) | 19 | 4 | 19 | 13 | ||||||
276 | 276 | -73.9658867660358 | 40.7756523577509 | 15H-PM-1008-06 | 15H | PM | 1008 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | base of gingko tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9658867660358 40.7756523577509) | 19 | 4 | 19 | 13 | ||||
287 | 287 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 1019 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | 19 | 4 | 19 | 13 | |||||
289 | 289 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 1018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690104245067 40.7853358193723) | 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 | |||||
324 | 324 | -73.9671306431211 | 40.783887015905705 | 22C-PM-1006-05 | 22C | PM | 1006 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9671306431211 40.7838870159057) | 19 | 4 | 19 | 13 | ||||||
337 | 337 | -73.954595058342 | 40.7956567934304 | 39F-AM-1014-04 | 39F | AM | 1014 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954595058342 40.7956567934304) | 19 | 4 | 19 | 13 | |||||
353 | 353 | -73.9795585338537 | 40.768895893226 | 3B-PM-1007-08 | 03B | PM | 1007 | 8 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9795585338537 40.768895893226) | 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 | |||||
396 | 396 | -73.9728895595977 | 40.769937833229896 | 6F-AM-1006-01 | 06F | AM | 1006 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9728895595977 40.7699378332299) | 19 | 4 | 19 | 13 | |||||
411 | 411 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 1007 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | stole (found?) an entire sandwich | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
427 | 427 | -73.95656845779891 | 40.79360039404129 | 36F-PM-1012-02 | 36F | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565684577989 40.7936003940413) | 19 | 4 | 19 | 13 | |||||
441 | 441 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
442 | 442 | -73.9787105069657 | 40.7693708133873 | 3B-AM-1010-08 | 03B | AM | 1010 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | together w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787105069657 40.7693708133873) | 19 | 4 | 19 | 13 | ||||
447 | 447 | -73.97010303935059 | 40.7838953063625 | 21A-AM-1019-04 | 21A | AM | 1019 | 4 | Juvenile | Gray | Black | Gray+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701030393506 40.7838953063625) | 19 | 4 | 19 | 13 | |||||
465 | 465 | -73.9784863123685 | 40.7669225020831 | 1D-AM-1006-08 | 01D | AM | 1006 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 45.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784863123685 40.7669225020831) | 19 | 4 | 19 | 13 | |||||
481 | 481 | -73.9690175838534 | 40.77604327200171 | 14F-AM-1007-05 | 14F | AM | 1007 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690175838534 40.7760432720017) | 19 | 4 | 19 | 13 | |||||
485 | 485 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
514 | 514 | -73.9563203089105 | 40.7906275357726 | 33G-PM-1006-01 | 33G | PM | 1006 | 1 | Juvenile | Gray | Gray+ | Above Ground | 2.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9563203089105 40.7906275357726) | 19 | 4 | 19 | 13 | ||||||
536 | 536 | -73.97301156879641 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 1008 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730115687964 40.7741018274312) | 19 | 4 | 19 | 13 | |||||
578 | 578 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 1006 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | 19 | 4 | 19 | 13 | |||||
583 | 583 | -73.95877875927509 | 40.7981699014259 | 40A-AM-1010-01 | 40A | AM | 1010 | 1 | Juvenile | Gray | Gray+ | Above Ground | 30.0 | bottom of great hill | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbing up a tree | POINT (-73.9587787592751 40.7981699014259) | 19 | 4 | 19 | 13 | ||||
594 | 594 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 1007 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9528482858163 40.7922056218325) | 19 | 4 | 19 | 13 | |||||
596 | 596 | -73.9788088165392 | 40.769015302587796 | 3B-AM-1010-04 | 03B | AM | 1010 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9788088165392 40.7690153025878) | 19 | 4 | 19 | 13 | ||||||
622 | 622 | -73.9690212174 | 40.783409940410706 | 21B-PM-1017-05 | 21B | PM | 1017 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690212174 40.7834099404107) | 19 | 4 | 19 | 13 | ||||||
632 | 632 | -73.96789372898371 | 40.7782808361645 | 16E-PM-1018-01 | 16E | PM | 1018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9678937289837 40.7782808361645) | 19 | 4 | 19 | 13 | |||||
633 | 633 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 1006 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | 19 | 4 | 19 | 13 | |||
635 | 635 | -73.96864133261721 | 40.7817423907284 | 19C-PM-1018-08 | 19C | PM | 1018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686413326172 40.7817423907284) | 19 | 4 | 19 | 13 | ||||
636 | 636 | -73.9728783802067 | 40.7731671049246 | 9E-PM-1014-02 | 09E | PM | 1014 | 2 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9728783802067 40.7731671049246) | 19 | 4 | 19 | 13 | |||||
649 | 649 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 1007 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8.0 | 0 | 0 | 0 | 1 | 0 | holding nut | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9764850086767 40.7737340720562) | 19 | 4 | 19 | 13 | ||||
655 | 655 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 1018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | 19 | 4 | 19 | 13 | |||||
656 | 656 | -73.97640135898651 | 40.766306349920704 | 1F-PM-1019-03 | 01F | PM | 1019 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9764013589865 40.7663063499207) | 19 | 4 | 19 | 13 | |||||
658 | 658 | -73.97458005923929 | 40.767356541975005 | 3F-AM-1006-08 | 03F | AM | 1006 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745800592393 40.767356541975) | 19 | 4 | 19 | 13 | ||||
660 | 660 | -73.9685709455958 | 40.774487702650596 | 12G-PM-1007-07 | 12G | PM | 1007 | 7 | Juvenile | + | Above Ground | 45.0 | 0 | 0 | 0 | 1 | 0 | acorns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9685709455958 40.7744877026506) | 19 | 4 | 19 | 13 | ||||||
667 | 667 | -73.97917671562679 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 1006 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12.0 | in tall shrubs near wall next to CPW | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791767156268 40.7714445258765) | 19 | 4 | 19 | 13 | ||||
679 | 679 | -73.9643538221947 | 40.7917565604735 | 31A-PM-1017-01 | 31A | PM | 1017 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9643538221947 40.7917565604735) | 19 | 4 | 19 | 13 | ||||
744 | 744 | -73.97186968288 | 40.778926988884 | 15B-AM-1014-03 | 15B | AM | 1014 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | running (from a dog) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97186968288 40.778926988884) | 19 | 4 | 19 | 13 | ||||
756 | 756 | -73.96757180595391 | 40.7786049141486 | 17F-AM-1007-06 | 17F | AM | 1007 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 8.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9675718059539 40.7786049141486) | 19 | 4 | 19 | 13 | |||||
762 | 762 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 1008 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9574648097543 40.7892508428622) | 19 | 4 | 19 | 13 | |||||
771 | 771 | -73.9626560807032 | 40.7884633049896 | 28D-AM-1012-05 | 28D | AM | 1012 | 5 | Juvenile | Black | Black+ | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9626560807032 40.7884633049896) | 19 | 4 | 19 | 13 | ||||||
785 | 785 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 1013 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | Sitting on tree limb | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | 19 | 4 | 19 | 13 | ||
796 | 796 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 1014 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2.0 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
812 | 812 | -73.9675472064204 | 40.7835947167436 | 22C-PM-1006-06 | 22C | PM | 1006 | 6 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | on tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675472064204 40.7835947167436) | 19 | 4 | 19 | 13 | ||||
829 | 829 | -73.9689227467959 | 40.783754160749396 | 21B-AM-1019-03 | 21B | AM | 1019 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689227467959 40.7837541607494) | 19 | 4 | 19 | 13 | |||||
862 | 862 | -73.9786940945874 | 40.769082027688796 | 3B-PM-1007-05 | 03B | PM | 1007 | 5 | Juvenile | Gray | Gray+ | Above Ground | 6.0 | on rock | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9786940945874 40.7690820276888) | 19 | 4 | 19 | 13 | |||||
869 | 869 | -73.96064260275601 | 40.791726541984204 | 32D-PM-1006-08 | 32D | PM | 1006 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | 19 | 4 | 19 | 13 | ||||
872 | 872 | -73.97217978245759 | 40.7801213843628 | 16A-PM-1019-07 | 16A | PM | 1019 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | approaches (very friendly) | POINT (-73.9721797824576 40.7801213843628) | 19 | 4 | 19 | 13 | ||||
892 | 892 | -73.97736964550309 | 40.7687241866704 | 3D-PM-1010-14 | 03D | PM | 1010 | 14 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 0 | 0 | 0 | 0 | crying out | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9773696455031 40.7687241866704) | 19 | 4 | 19 | 13 | ||||
909 | 909 | -73.9556177490335 | 40.788856916153705 | 32I-AM-1013-03 | 32I | AM | 1013 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching me from tree - curious | POINT (-73.9556177490335 40.7888569161537) | 19 | 4 | 19 | 13 | ||||
919 | 919 | -73.9777328709928 | 40.7669087724668 | 1D-AM-1006-02 | 01D | AM | 1006 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9777328709928 40.7669087724668) | 19 | 4 | 19 | 13 | |||||
921 | 921 | -73.9710025484537 | 40.7792529489016 | 16C-AM-1014-01 | 16C | AM | 1014 | 1 | Juvenile | Gray | Gray+ | Above Ground | 40.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710025484537 40.7792529489016) | 19 | 4 | 19 | 13 | ||||||
924 | 924 | -73.9686635017966 | 40.78431767328279 | 22B-PM-1014-01 | 22B | PM | 1014 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686635017966 40.7843176732828) | 19 | 4 | 19 | 13 | |||||
972 | 972 | -73.9615751148595 | 40.795455123814605 | 36A-AM-1018-01 | 36A | AM | 1018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615751148595 40.7954551238146) | 19 | 4 | 19 | 13 | ||||
983 | 983 | -73.96732355553209 | 40.7786749596774 | 17F-PM-1020-04 | 17F | PM | 1020 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9673235555321 40.7786749596774) | 19 | 4 | 19 | 13 | ||||||
1000 | 1000 | -73.96959649834541 | 40.7802302192799 | 18C-PM-1018-08 | 18C | PM | 1018 | 8 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695964983454 40.7802302192799) | 19 | 4 | 19 | 13 | ||||||
1009 | 1009 | -73.97549229705109 | 40.7707686392991 | 6D-AM-1008-03 | 06D | AM | 1008 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9754922970511 40.7707686392991) | 19 | 4 | 19 | 13 | ||||||
1023 | 1023 | -73.9642379942652 | 40.777479252073796 | 17I-PM-1017-01 | 17I | PM | 1017 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | was in a tree,so i couldn't really tell | POINT (-73.9642379942652 40.7774792520738) | 19 | 4 | 19 | 13 | ||||
1031 | 1031 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 1013 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
1041 | 1041 | -73.9762187733662 | 40.7739282973004 | 9B-PM-1013-08 | 09B | PM | 1013 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9762187733662 40.7739282973004) | 19 | 4 | 19 | 13 | |||||
1044 | 1044 | -73.95826439540551 | 40.800046006127204 | 42A-AM-1019-01 | 42A | AM | 1019 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9582643954055 40.8000460061272) | 19 | 4 | 19 | 13 | |||||
1047 | 1047 | -73.9700264128414 | 40.7692014637698 | 7I-PM-1013-01 | 07I | PM | 1013 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9700264128414 40.7692014637698) | 19 | 4 | 19 | 13 | ||||
1054 | 1054 | -73.96801718943509 | 40.772464442631296 | 11I-PM-1012-07 | 11I | PM | 1012 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying its food into the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680171894351 40.7724644426313) | 19 | 4 | 19 | 13 | |||||
1057 | 1057 | -73.9752000129992 | 40.773291812223896 | 8C-PM-1013-04 | 08C | PM | 1013 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
1072 | 1072 | -73.9693462354257 | 40.776444438545205 | 14E-PM-1017-01 | 14E | PM | 1017 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693462354257 40.7764444385452) | 19 | 4 | 19 | 13 | |||||
1075 | 1075 | -73.97487064155841 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 1006 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9748706415584 40.7744174965072) | 19 | 4 | 19 | 13 | |||||
1079 | 1079 | -73.96898934126929 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 1018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8.0 | Tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689893412693 40.785308737683) | 19 | 4 | 19 | 13 | ||||
1080 | 1080 | -73.9712327308512 | 40.7748702909218 | 12E-PM-1018-06 | 12E | PM | 1018 | 6 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9712327308512 40.7748702909218) | 19 | 4 | 19 | 13 | ||||||
1091 | 1091 | -73.9763506612375 | 40.771611393182 | 7C-PM-1020-05 | 07C | PM | 1020 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763506612375 40.771611393182) | 19 | 4 | 19 | 13 | |||||
1096 | 1096 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 1017 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | digging/burying,drinking from lake | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9737247632185 40.7759469280872) | 19 | 4 | 19 | 13 | ||||
1100 | 1100 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 1018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3.0 | On trunk | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9686370726471 40.7780382348833) | 19 | 4 | 19 | 13 | ||||
1128 | 1128 | -73.9545912098958 | 40.7948301813102 | 38F-PM-1013-06 | 38F | PM | 1013 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9545912098958 40.7948301813102) | 19 | 4 | 19 | 13 | |||||
1138 | 1138 | -73.9727488640736 | 40.7781916780621 | 14B-PM-1014-06 | 14B | PM | 1014 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | watching me | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | skittish | POINT (-73.9727488640736 40.7781916780621) | 19 | 4 | 19 | 13 | |||
1147 | 1147 | -73.9601918930677 | 40.7944134683406 | 35C-AM-1007-01 | 35C | AM | 1007 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | (white oak) | 0 | 0 | 0 | 0 | 0 | sitting still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9601918930677 40.7944134683406) | 19 | 4 | 19 | 13 | |||
1189 | 1189 | -73.9748943397482 | 40.770399256427204 | 6E-AM-1014-01 | 06E | AM | 1014 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9748943397482 40.7703992564272) | 19 | 4 | 19 | 13 | |||||
1191 | 1191 | -73.9565700386162 | 40.7902561000937 | 33H-AM-1019-02 | 33H | AM | 1019 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | wrestling with mother | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565700386162 40.7902561000937) | 19 | 4 | 19 | 13 | ||||
1235 | 1235 | -73.9640016324897 | 40.7921759097124 | 32A-PM-1013-01 | 32A | PM | 1013 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9640016324897 40.7921759097124) | 19 | 4 | 19 | 13 | |||||
1256 | 1256 | -73.95771130260559 | 40.7904332453456 | 32G-PM-1013-02 | 32G | PM | 1013 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9577113026056 40.7904332453456) | 19 | 4 | 19 | 13 | ||||||
1263 | 1263 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | 19 | 4 | 19 | 13 | |||||
1292 | 1292 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1297 | 1297 | -73.96584435488221 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 1007 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | scared | POINT (-73.9658443548822 40.7796704898979) | 19 | 4 | 19 | 13 | |||||
1302 | 1302 | -73.97248065806379 | 40.771007720613206 | 7F-AM-1008-15 | 07F | AM | 1008 | 15 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9724806580638 40.7710077206132) | 19 | 4 | 19 | 13 | ||||||
1315 | 1315 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 1014 | 4 | Juvenile | + | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687025912431 40.7719319822619) | 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 )