Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Community_Districts, City_Council_Districts, Police_Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | |||||
238 | 238 | -73.9751625910271 | 40.7671023412885 | 3F-AM-1006-02 | 03F | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9751625910271 40.7671023412885) | 19 | 4 | 19 | 13 | |||||
374 | 374 | -73.9704024529864 | 40.772925606388895 | 10G-AM-1006-04 | 10G | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#3) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704024529864 40.7729256063889) | 19 | 4 | 19 | 13 | ||||
436 | 436 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | 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 | |||||
521 | 521 | -73.97042696309641 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 1006 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704269630964 40.7722964640257) | 19 | 4 | 19 | 13 | |||||
569 | 569 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 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 | |||||
607 | 607 | -73.9569324958684 | 40.7877748374259 | 30I-PM-1006-01 | 30I | PM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting there | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569324958684 40.7877748374259) | 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 | |||
648 | 648 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | curious | POINT (-73.97826438139 40.7717086090782) | 19 | 4 | 19 | 13 | ||||
708 | 708 | -73.97629653413091 | 40.775112516678 | 10A-AM-1006-02 | 10A | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Bridle Path lawn | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9762965341309 40.775112516678) | 19 | 4 | 19 | 13 | ||||
714 | 714 | -73.9782983634755 | 40.766831436426294 | 1D-AM-1006-04 | 01D | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782983634755 40.7668314364263) | 19 | 4 | 19 | 13 | |||||
724 | 724 | -73.95498609472341 | 40.79115503283089 | 34H-PM-1006-07 | 34H | PM | 1006 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9549860947234 40.7911550328309) | 19 | 4 | 19 | 13 | ||||
733 | 733 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
825 | 825 | -73.956502663005 | 40.788160908881004 | 30I-PM-1006-05 | 30I | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
1056 | 1056 | -73.9693772461788 | 40.770687589290105 | 8I-AM-1006-03 | 08I | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
1120 | 1120 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 1006 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
1122 | 1122 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
1166 | 1166 | -73.97568897660891 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 1006 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12.0 | 1 | 0 | 1 | 0 | 0 | running from dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
1213 | 1213 | -73.97368963630059 | 40.767763086262605 | 4G-AM-1006-01 | 04G | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9736896363006 40.7677630862626) | 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 | |||||
1270 | 1270 | -73.9735489537928 | 40.76812579115229 | 4G-AM-1006-02 | 04G | AM | 1006 | 2 | Gray | White | Gray+White | Above Ground | 12.0 | tree | 0 | 0 | 0 | 0 | 0 | sitting in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
1291 | 1291 | -73.97824171151392 | 40.77246650364471 | 7A-AM-1006-01 | 07A | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | in tree | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
1353 | 1353 | -73.9579292340076 | 40.7976287835027 | 39C-PM-1006-04 | 39C | PM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579292340076 40.7976287835027) | 19 | 4 | 19 | 13 | |||||
1478 | 1478 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
1536 | 1536 | -73.9564606426367 | 40.788054657260794 | 30I-PM-1006-06 | 30I | PM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ran up tree | POINT (-73.9564606426367 40.7880546572608) | 19 | 4 | 19 | 13 | ||||
1753 | 1753 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1790 | 1790 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.7893712398425) | 19 | 4 | 19 | 13 | |||||
1922 | 1922 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | lower branch of tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 19 | 4 | 19 | 13 | |||
1988 | 1988 | -73.9734108731087 | 40.767605139269705 | 4G-AM-1006-03 | 04G | AM | 1006 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734108731087 40.7676051392697) | 19 | 4 | 19 | 13 | ||||||
2025 | 2025 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695560376915 40.7708835103516) | 19 | 4 | 19 | 13 | |||||
2080 | 2080 | -73.96904988769441 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 1006 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
2214 | 2214 | -73.96788229832741 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
2257 | 2257 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
2268 | 2268 | -73.95307395621309 | 40.7932034409546 | 37H-PM-1006-01 | 37H | PM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | from voice | POINT (-73.9530739562131 40.7932034409546) | 19 | 4 | 19 | 13 | ||||
2286 | 2286 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
2436 | 2436 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
2561 | 2561 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
2697 | 2697 | -73.9704592500888 | 40.772962887933005 | 10G-AM-1006-03 | 10G | AM | 1006 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
2861 | 2861 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
2986 | 2986 | -73.97841448676391 | 40.771817766751106 | 6A-AM-1006-01 | 06A | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784144867639 40.7718177667511) | 19 | 4 | 19 | 13 | |||||
2996 | 2996 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697160572446 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
3015 | 3015 | -73.97469187620759 | 40.765523188367794 | 1G-AM-1006-02 | 01G | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
3085 | 3085 | -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 | |||||
3163 | 3163 | -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 | |||||
3180 | 3180 | -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 | |||||
3221 | 3221 | -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 | ||||
3234 | 3234 | -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 | |||||
3261 | 3261 | -73.9751625910271 | 40.7671023412885 | 3F-AM-1006-02 | 03F | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9751625910271 40.7671023412885) | 19 | 4 | 19 | 13 | |||||
3397 | 3397 | -73.9704024529864 | 40.772925606388895 | 10G-AM-1006-04 | 10G | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#3) | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9704024529864 40.7729256063889) | 19 | 4 | 19 | 13 | ||||
3459 | 3459 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
3464 | 3464 | -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 | |||||
3544 | 3544 | -73.97042696309641 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 1006 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704269630964 40.7722964640257) | 19 | 4 | 19 | 13 | |||||
3592 | 3592 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
3598 | 3598 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
3601 | 3601 | -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 | |||||
3630 | 3630 | -73.9569324958684 | 40.7877748374259 | 30I-PM-1006-01 | 30I | PM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting there | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569324958684 40.7877748374259) | 19 | 4 | 19 | 13 | ||||
3656 | 3656 | -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 | |||
3671 | 3671 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | curious | POINT (-73.97826438139 40.7717086090782) | 19 | 4 | 19 | 13 | ||||
3731 | 3731 | -73.97629653413091 | 40.775112516678 | 10A-AM-1006-02 | 10A | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Bridle Path lawn | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9762965341309 40.775112516678) | 19 | 4 | 19 | 13 | ||||
3737 | 3737 | -73.9782983634755 | 40.766831436426294 | 1D-AM-1006-04 | 01D | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782983634755 40.7668314364263) | 19 | 4 | 19 | 13 | |||||
3747 | 3747 | -73.95498609472341 | 40.79115503283089 | 34H-PM-1006-07 | 34H | PM | 1006 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9549860947234 40.7911550328309) | 19 | 4 | 19 | 13 | ||||
3756 | 3756 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
3848 | 3848 | -73.956502663005 | 40.788160908881004 | 30I-PM-1006-05 | 30I | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
4079 | 4079 | -73.9693772461788 | 40.770687589290105 | 8I-AM-1006-03 | 08I | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
4143 | 4143 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 1006 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
4145 | 4145 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
4189 | 4189 | -73.97568897660891 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 1006 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12.0 | 1 | 0 | 1 | 0 | 0 | running from dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
4236 | 4236 | -73.97368963630059 | 40.767763086262605 | 4G-AM-1006-01 | 04G | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9736896363006 40.7677630862626) | 19 | 4 | 19 | 13 | |||||
4286 | 4286 | -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 | |||||
4293 | 4293 | -73.9735489537928 | 40.76812579115229 | 4G-AM-1006-02 | 04G | AM | 1006 | 2 | Gray | White | Gray+White | Above Ground | 12.0 | tree | 0 | 0 | 0 | 0 | 0 | sitting in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
4314 | 4314 | -73.97824171151392 | 40.77246650364471 | 7A-AM-1006-01 | 07A | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | in tree | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
4376 | 4376 | -73.9579292340076 | 40.7976287835027 | 39C-PM-1006-04 | 39C | PM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579292340076 40.7976287835027) | 19 | 4 | 19 | 13 | |||||
4501 | 4501 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
4559 | 4559 | -73.9564606426367 | 40.788054657260794 | 30I-PM-1006-06 | 30I | PM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ran up tree | POINT (-73.9564606426367 40.7880546572608) | 19 | 4 | 19 | 13 | ||||
4776 | 4776 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
4813 | 4813 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.7893712398425) | 19 | 4 | 19 | 13 | |||||
4945 | 4945 | -73.95448101115 | 40.7954469678857 | 39F-PM-1006-03 | 39F | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | lower branch of tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ran up tree when approached | POINT (-73.95448101115 40.7954469678857) | 19 | 4 | 19 | 13 | |||
5011 | 5011 | -73.9734108731087 | 40.767605139269705 | 4G-AM-1006-03 | 04G | AM | 1006 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734108731087 40.7676051392697) | 19 | 4 | 19 | 13 | ||||||
5048 | 5048 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695560376915 40.7708835103516) | 19 | 4 | 19 | 13 | |||||
5103 | 5103 | -73.96904988769441 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 1006 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
5237 | 5237 | -73.96788229832741 | 40.7802960985637 | 18E-PM-1006-01 | 18E | PM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9678822983274 40.7802960985637) | 19 | 4 | 19 | 13 | |||||
5280 | 5280 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
5291 | 5291 | -73.95307395621309 | 40.7932034409546 | 37H-PM-1006-01 | 37H | PM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | from voice | POINT (-73.9530739562131 40.7932034409546) | 19 | 4 | 19 | 13 | ||||
5309 | 5309 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
5459 | 5459 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
5584 | 5584 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
5720 | 5720 | -73.9704592500888 | 40.772962887933005 | 10G-AM-1006-03 | 10G | AM | 1006 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704592500888 40.772962887933) | 19 | 4 | 19 | 13 | ||||
5884 | 5884 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
6009 | 6009 | -73.97841448676391 | 40.771817766751106 | 6A-AM-1006-01 | 06A | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784144867639 40.7718177667511) | 19 | 4 | 19 | 13 | |||||
6019 | 6019 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697160572446 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
6038 | 6038 | -73.97469187620759 | 40.765523188367794 | 1G-AM-1006-02 | 01G | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746918762076 40.7655231883678) | 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 | |||||
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 |
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 )