Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Date, Hectare_Squirrel_Number, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Location, Running, Chasing, Eating, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, 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 | ||||||||||
5 | 5 | -73.9771646835311 | 40.769304916508396 | 4C-PM-1010-05 | 04C | PM | 1010 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
6 | 6 | -73.9772164524209 | 40.768839953875606 | 3D-AM-1006-06 | 03D | AM | 1006 | 6 | Gray | Gray+ | Above Ground | 10.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 19 | 4 | 19 | 13 | |||||
8 | 8 | -73.97296259363002 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 1012 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2.0 | on ledge | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
13 | 13 | -73.96279043284021 | 40.7939375305761 | 34A-PM-1013-04 | 34A | PM | 1013 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | digging & burying | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9627904328402 40.7939375305761) | 19 | 4 | 19 | 13 | ||||
14 | 14 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 1014 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (eats with head tilted far to the right (tooth issue?)) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968367485157 40.7838472644815) | 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 | ||||
27 | 27 | -73.96942888062121 | 40.7842952265291 | 22A-PM-1017-01 | 22A | PM | 1017 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9694288806212 40.7842952265291) | 19 | 4 | 19 | 13 | ||||||
28 | 28 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
29 | 29 | -73.97142951022491 | 40.776954371947 | 14D-PM-1019-02 | 14D | PM | 1019 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714295102249 40.776954371947) | 19 | 4 | 19 | 13 | ||||||
34 | 34 | -73.95693753558841 | 40.793539800861204 | 36E-AM-1013-02 | 36E | AM | 1013 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569375355884 40.7935398008612) | 19 | 4 | 19 | 13 | ||||||
36 | 36 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 1008 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9664120826015 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
40 | 40 | -73.95667510223359 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 1007 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
41 | 41 | -73.9741621946917 | 40.775248147202504 | 11C-PM-1018-01 | 11C | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
42 | 42 | -73.95777581255179 | 40.799384716477 | 41B-AM-1010-10 | 41B | AM | 1010 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9577758125518 40.799384716477) | 19 | 4 | 19 | 13 | |||||
44 | 44 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 1012 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
50 | 50 | -73.955258162768 | 40.7958147673603 | 39E-AM-1018-01 | 39E | AM | 1018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing still | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.955258162768 40.7958147673603) | 19 | 4 | 19 | 13 | ||||
51 | 51 | -73.957600085245 | 40.7936111607879 | 35E-PM-1006-04 | 35E | PM | 1006 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.957600085245 40.7936111607879) | 19 | 4 | 19 | 13 | ||||||
53 | 53 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 1017 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9573656523498 40.7979754563974) | 19 | 4 | 19 | 13 | |||||
54 | 54 | -73.9710674928906 | 40.7778757544025 | 15D-PM-1017-06 | 15D | PM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | stopped and watched me before slowly moving on | POINT (-73.9710674928906 40.7778757544025) | 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 | ||||
56 | 56 | -73.967767372181 | 40.784702631615 | 23B-PM-1012-07 | 23B | PM | 1012 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.967767372181 40.784702631615) | 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 | |||
63 | 63 | -73.9683479943823 | 40.7815827298303 | 20C-PM-1018-01 | 20C | PM | 1018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9683479943823 40.7815827298303) | 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 | |||||
67 | 67 | -73.9684657285532 | 40.7840113573723 | 22B-AM-1013-05 | 22B | AM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looked down on me like her imperial subject | POINT (-73.9684657285532 40.7840113573723) | 19 | 4 | 19 | 13 | ||||
68 | 68 | -73.9718597156773 | 40.776585876331296 | 13C-PM-1019-04 | 13C | PM | 1019 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
77 | 77 | -73.9532952763106 | 40.792007446262204 | 36I-AM-1017-08 | 36I | AM | 1017 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#7) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | runs from (me) | POINT (-73.9532952763106 40.7920074462622) | 19 | 4 | 19 | 13 | ||||
78 | 78 | -73.97554590905341 | 40.7680866624003 | 4E-AM-1020-04 | 04E | AM | 1020 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | chillin' | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9755459090534 40.7680866624003) | 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 | ||||
86 | 86 | -73.9742986032935 | 40.7770454318226 | 13A-PM-1014-04 | 13A | PM | 1014 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742986032935 40.7770454318226) | 19 | 4 | 19 | 13 | |||||||
88 | 88 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | Ran up tree | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
89 | 89 | -73.97624942397191 | 40.775017530671605 | 10A-AM-1006-01 | 10A | AM | 1006 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | near Strawberry Fields | 0 | 0 | 0 | 1 | 0 | eating (a peanut) | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9762494239719 40.7750175306716) | 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 | ||||
91 | 91 | -73.95759861613641 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | Climbing tree | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
99 | 99 | -73.97487092063541 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 1014 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748709206354 40.77608025411) | 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 | |||||
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 | ||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||||
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 | |||||
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 | ||||||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
207 | 207 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 1007 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587072763996 40.7850256219415) | 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 | |||||
212 | 212 | -73.9544808708211 | 40.7906575852286 | 34I-AM-1012-02 | 34I | AM | 1012 | 2 | Adult | Gray | White | Gray+White | Short tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | hiding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9544808708211 40.7906575852286) | 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 | ||||
218 | 218 | -73.959412243507 | 40.7917871123534 | 33E-AM-1014-01 | 33E | AM | 1014 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.959412243507 40.7917871123534) | 19 | 4 | 19 | 13 | ||||
222 | 222 | -73.9545399102352 | 40.7898646267709 | 33I-PM-1006-06 | 33I | PM | 1006 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545399102352 40.7898646267709) | 19 | 4 | 19 | 13 | ||||||
223 | 223 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 1007 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675023138703 40.7872554700995) | 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 | ||||
228 | 228 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 1008 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | Oak tree | 0 | 1 | 0 | 0 | 0 | watching me | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
231 | 231 | -73.9653142636891 | 40.776001512929795 | 15I-AM-1008-04 | 15I | AM | 1008 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
234 | 234 | -73.9769520212123 | 40.774006725862996 | 9A-AM-1013-01 | 09A | AM | 1013 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9769520212123 40.774006725863) | 19 | 4 | 19 | 13 | |||||
241 | 241 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
242 | 242 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 1007 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587179613803 40.7992119571657) | 19 | 4 | 19 | 13 | |||||
245 | 245 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 1010 | 4 | + | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
249 | 249 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 1018 | 6 | Adult | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9597048490102 40.7955846466241) | 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 | ||||
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 | |||||
261 | 261 | -73.95744422055 | 40.7961046528557 | 38D-AM-1017-04 | 38D | AM | 1017 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.95744422055 40.7961046528557) | 19 | 4 | 19 | 13 | |||||
264 | 264 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 1010 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9650499507011 40.7908191782173) | 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 | ||||||
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 | |||||
271 | 271 | -73.9656324462902 | 40.783403475308106 | 22E-PM-1014-02 | 22E | PM | 1014 | 2 | Adult | Gray | Gray+ | Above Ground | 6.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9656324462902 40.7834034753081) | 19 | 4 | 19 | 13 | ||||||
277 | 277 | -73.96378247566071 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 1007 | 8 | Adult | Gray | Gray+ | Above Ground | 40.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9637824756607 40.7904737110761) | 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 | |||||
282 | 282 | -73.96511776576759 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 1007 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9651177657676 40.7812408103825) | 19 | 4 | 19 | 13 | ||||
286 | 286 | -73.97545365660129 | 40.769860491877104 | 5E-PM-1012-04 | 05E | PM | 1012 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9754536566013 40.7698604918771) | 19 | 4 | 19 | 13 | |||||
288 | 288 | -73.97191114701641 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 1013 | 2 | Adult | Gray | Gray+ | Above Ground | 7.0 | Was on top of the edge of Bow Bridge | 0 | 0 | 0 | 0 | 0 | jumped off | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9719111470164 40.7758789855474) | 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 | ||||||
299 | 299 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 1020 | 4 | Adult | Gray | Gray+ | Above Ground | 1.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.976609486498 40.7717832922535) | 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 | ||||||||||
305 | 305 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
308 | 308 | -73.97680969536471 | 40.7708185213129 | 5C-PM-1010-08 | 05C | PM | 1010 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768096953647 40.7708185213129) | 19 | 4 | 19 | 13 | |||||
309 | 309 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 1013 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15.0 | Climbing up tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
316 | 316 | -73.9575517912392 | 40.788915826819206 | 31H-PM-1008-05 | 31H | PM | 1008 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575517912392 40.7889158268192) | 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 | ||||||
326 | 326 | -73.9588076804698 | 40.7912942607296 | 33E-AM-1014-06 | 33E | AM | 1014 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588076804698 40.7912942607296) | 19 | 4 | 19 | 13 | |||||
334 | 334 | -73.95944460183459 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 1017 | 6 | Adult | Black | Black+ | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 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 )