Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631 | 1631 | -73.98077710643099 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 1007 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.980777106431 40.7681635726316) | 19 | 4 | 19 | 13 | |||||
2938 | 2938 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
4654 | 4654 | -73.98077710643099 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 1007 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.980777106431 40.7681635726316) | 19 | 4 | 19 | 13 | |||||
5961 | 5961 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
837 | 837 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
965 | 965 | -73.9805927710872 | 40.76799891166421 | 1B-PM-1019-07 | 01B | PM | 1019 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9805927710872 40.7679989116642) | 19 | 4 | 19 | 13 | |||||
1448 | 1448 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807982742225 40.7678795985389) | 19 | 4 | 19 | 13 | |||||
1539 | 1539 | -73.98028424040159 | 40.767825738497706 | 1B-PM-1019-03 | 01B | PM | 1019 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9802842404016 40.7678257384977) | 19 | 4 | 19 | 13 | ||||
1670 | 1670 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 1019 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
1906 | 1906 | -73.98028400317591 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
2614 | 2614 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 1019 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
2797 | 2797 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 1019 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | 19 | 4 | 19 | 13 | |||||
2884 | 2884 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 1012 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
3860 | 3860 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
3988 | 3988 | -73.9805927710872 | 40.76799891166421 | 1B-PM-1019-07 | 01B | PM | 1019 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9805927710872 40.7679989116642) | 19 | 4 | 19 | 13 | |||||
4471 | 4471 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807982742225 40.7678795985389) | 19 | 4 | 19 | 13 | |||||
4562 | 4562 | -73.98028424040159 | 40.767825738497706 | 1B-PM-1019-03 | 01B | PM | 1019 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9802842404016 40.7678257384977) | 19 | 4 | 19 | 13 | ||||
4693 | 4693 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 1019 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
4929 | 4929 | -73.98028400317591 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
5637 | 5637 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 1019 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
5820 | 5820 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 1019 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | 19 | 4 | 19 | 13 | |||||
5907 | 5907 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 1012 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9806805581636 40.7681537966505) | 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 | |||||
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 | |||||
1111 | 1111 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 1007 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
2858 | 2858 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | 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 | |||||
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 | |||||
4134 | 4134 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 1007 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
5881 | 5881 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | 19 | 4 | 19 | 13 | |||||
188 | 188 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 1010 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
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 | |||||
3211 | 3211 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 1010 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
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 | ||||||
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 | |||||
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 | ||||
1230 | 1230 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 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 | ||||
1611 | 1611 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
1914 | 1914 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 1019 | 3 | 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.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
2536 | 2536 | -73.98089749771201 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
2721 | 2721 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
3328 | 3328 | -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 | ||||
4253 | 4253 | -73.98016364007441 | 40.769019205592606 | 2A-AM-1010-09 | 02A | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Above Ground | climbing in bush | 0 | 0 | 1 | 0 | 0 | hopping & flipping around. this one was very energetic & jumping aorund | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | climbed a foot up a tree and watched me | POINT (-73.9801636400744 40.7690192055926) | 19 | 4 | 19 | 13 | |||
4315 | 4315 | -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 | ||||
4634 | 4634 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
4937 | 4937 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 1019 | 3 | 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.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
5559 | 5559 | -73.98089749771201 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
5744 | 5744 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 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 | |||||
357 | 357 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | 19 | 4 | 19 | 13 | |||||
1040 | 1040 | -73.9801138983722 | 40.768572151563504 | 2B-PM-1013-02 | 02B | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801138983722 40.7685721515635) | 19 | 4 | 19 | 13 | |||||
1246 | 1246 | -73.9797112925048 | 40.76880467784721 | 2B-PM-1013-09 | 02B | PM | 1013 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
1634 | 1634 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | running (with nut) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
1962 | 1962 | -73.9801562527339 | 40.76872673271129 | 2B-AM-1010-01 | 02B | AM | 1010 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
2220 | 2220 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | climbing fence! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
2849 | 2849 | -73.98003374000399 | 40.768360829233295 | 2B-PM-1013-04 | 02B | PM | 1013 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.980033740004 40.7683608292333) | 19 | 4 | 19 | 13 | |||||
3281 | 3281 | -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 | |||||
3380 | 3380 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | 19 | 4 | 19 | 13 | |||||
4063 | 4063 | -73.9801138983722 | 40.768572151563504 | 2B-PM-1013-02 | 02B | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801138983722 40.7685721515635) | 19 | 4 | 19 | 13 | |||||
4269 | 4269 | -73.9797112925048 | 40.76880467784721 | 2B-PM-1013-09 | 02B | PM | 1013 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
4657 | 4657 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | running (with nut) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
4985 | 4985 | -73.9801562527339 | 40.76872673271129 | 2B-AM-1010-01 | 02B | AM | 1010 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
5243 | 5243 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | climbing fence! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
5872 | 5872 | -73.98003374000399 | 40.768360829233295 | 2B-PM-1013-04 | 02B | PM | 1013 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.980033740004 40.7683608292333) | 19 | 4 | 19 | 13 | |||||
246 | 246 | -73.97935655643609 | 40.767925939044794 | 2C-AM-1010-09 | 02C | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbed up tree as i neared | POINT (-73.9793565564361 40.7679259390448) | 19 | 4 | 19 | 13 | ||||
378 | 378 | -73.9791085350047 | 40.76770253426329 | 2C-PM-1013-12 | 02C | PM | 1013 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9791085350047 40.7677025342633) | 19 | 4 | 19 | 13 | |||||
429 | 429 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
625 | 625 | -73.9789126088606 | 40.7685079149692 | 2C-PM-1013-08 | 02C | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9789126088606 40.7685079149692) | 19 | 4 | 19 | 13 | |||||
993 | 993 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 1013 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | cleaning face & tail | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9788379085607 40.7683896583055) | 19 | 4 | 19 | 13 | ||||
1362 | 1362 | -73.9793082679745 | 40.7679930598805 | 2C-PM-1013-11 | 02C | PM | 1013 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9793082679745 40.7679930598805) | 19 | 4 | 19 | 13 | |||||
1409 | 1409 | -73.978400938697 | 40.7677411911854 | 2C-PM-1013-03 | 02C | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978400938697 40.7677411911854) | 19 | 4 | 19 | 13 | |||||
1594 | 1594 | -73.97912175106559 | 40.767658347539395 | 2C-AM-1010-05 | 02C | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791217510656 40.7676583475394) | 19 | 4 | 19 | 13 | ||||
1676 | 1676 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
2044 | 2044 | -73.9785709201168 | 40.7674391934208 | 2C-PM-1013-02 | 02C | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785709201168 40.7674391934208) | 19 | 4 | 19 | 13 | |||||
2252 | 2252 | -73.9792161469158 | 40.767928543625295 | 2C-PM-1013-10 | 02C | PM | 1013 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9792161469158 40.7679285436253) | 19 | 4 | 19 | 13 | |||||
2466 | 2466 | -73.97853537753821 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
2670 | 2670 | -73.9787846880249 | 40.768254590348796 | 2C-PM-1013-05 | 02C | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9787846880249 40.7682545903488) | 19 | 4 | 19 | 13 | |||||
3269 | 3269 | -73.97935655643609 | 40.767925939044794 | 2C-AM-1010-09 | 02C | AM | 1010 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | climbed up tree as i neared | POINT (-73.9793565564361 40.7679259390448) | 19 | 4 | 19 | 13 | ||||
3401 | 3401 | -73.9791085350047 | 40.76770253426329 | 2C-PM-1013-12 | 02C | PM | 1013 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9791085350047 40.7677025342633) | 19 | 4 | 19 | 13 | |||||
3452 | 3452 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
3648 | 3648 | -73.9789126088606 | 40.7685079149692 | 2C-PM-1013-08 | 02C | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9789126088606 40.7685079149692) | 19 | 4 | 19 | 13 | |||||
4016 | 4016 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 1013 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | cleaning face & tail | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9788379085607 40.7683896583055) | 19 | 4 | 19 | 13 | ||||
4385 | 4385 | -73.9793082679745 | 40.7679930598805 | 2C-PM-1013-11 | 02C | PM | 1013 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9793082679745 40.7679930598805) | 19 | 4 | 19 | 13 | |||||
4432 | 4432 | -73.978400938697 | 40.7677411911854 | 2C-PM-1013-03 | 02C | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.978400938697 40.7677411911854) | 19 | 4 | 19 | 13 | |||||
4617 | 4617 | -73.97912175106559 | 40.767658347539395 | 2C-AM-1010-05 | 02C | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791217510656 40.7676583475394) | 19 | 4 | 19 | 13 | ||||
4699 | 4699 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
5067 | 5067 | -73.9785709201168 | 40.7674391934208 | 2C-PM-1013-02 | 02C | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785709201168 40.7674391934208) | 19 | 4 | 19 | 13 | |||||
5275 | 5275 | -73.9792161469158 | 40.767928543625295 | 2C-PM-1013-10 | 02C | PM | 1013 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9792161469158 40.7679285436253) | 19 | 4 | 19 | 13 | |||||
5489 | 5489 | -73.97853537753821 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
5693 | 5693 | -73.9787846880249 | 40.768254590348796 | 2C-PM-1013-05 | 02C | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9787846880249 40.7682545903488) | 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 | |||||
2011 | 2011 | -73.9767016963397 | 40.7674012784541 | 2E-PM-1014-02 | 02E | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767016963397 40.7674012784541) | 19 | 4 | 19 | 13 | |||||
2713 | 2713 | -73.97658670292259 | 40.7674304266107 | 2E-PM-1014-01 | 02E | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9765867029226 40.7674304266107) | 19 | 4 | 19 | 13 | |||||
3224 | 3224 | -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 | |||||
5034 | 5034 | -73.9767016963397 | 40.7674012784541 | 2E-PM-1014-02 | 02E | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767016963397 40.7674012784541) | 19 | 4 | 19 | 13 | |||||
5736 | 5736 | -73.97658670292259 | 40.7674304266107 | 2E-PM-1014-01 | 02E | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9765867029226 40.7674304266107) | 19 | 4 | 19 | 13 | |||||
12 | 12 | -73.97494695668541 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 1014 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
1322 | 1322 | -73.97551920769341 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 1014 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755192076934 40.7664413570796) | 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 )