This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
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 | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
173 | 173 | -73.958770180151 | 40.7934123941528 | 35D-PM-1013-04 | 35D | PM | 10132018 | 4 | Juvenile | Gray | White | Gray+White | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958770180151 40.7934123941528) | 19 | 4 | 19 | 13 | |||||||
441 | 441 | -73.9742973420446 | 40.7691801644292 | 5F-AM-1007-04 | 05F | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | rocks | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9742973420446 40.7691801644292) | 19 | 4 | 19 | 13 | |||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | mushroom | false | false | false | false | false | false | true | false | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
537 | 537 | -73.9682803241007 | 40.7724510558327 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
635 | 635 | -73.9673235555321 | 40.7786749596774 | 17F-PM-1020-04 | 17F | PM | 10202018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9673235555321 40.7786749596774) | 19 | 4 | 19 | 13 | ||||||
687 | 687 | -73.9636971843665 | 40.7825638537362 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
1008 | 1008 | -73.9553038162633 | 40.7909367783223 | 34H-PM-1006-04 | 34H | PM | 10062018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Elm tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9553038162633 40.790936778322305) | 19 | 4 | 19 | 13 | ||||||
1342 | 1342 | -73.9662063642345 | 40.7890778665307 | 28A-PM-1007-04 | 28A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | false | looking at me & #5 | true | false | false | false | true | false | false | false | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
1405 | 1405 | -73.9589371550945 | 40.7959812504467 | 37C-PM-1013-04 | 37C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589371550945 40.7959812504467) | 19 | 4 | 19 | 13 | |||||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
1823 | 1823 | -73.9612854506075 | 40.7920830673571 | 32C-PM-1013-04 | 32C | PM | 10132018 | 4 | Juvenile | Gray | Gray+ | Above Ground | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
2014 | 2014 | -73.9786474809514 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
2450 | 2450 | -73.9756273257684 | 40.7706539186221 | 6D-AM-1008-04 | 06D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9756273257684 40.7706539186221) | 19 | 4 | 19 | 13 | |||||||
2690 | 2690 | -73.9572840457971 | 40.7886933371744 | 31H-PM-1008-04 | 31H | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | Also way up | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.95728404579711 40.7886933371744) | 19 | 4 | 19 | 13 | ||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2918 | 2918 | -73.9745152462626 | 40.7655415515908 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | false | true | false | false | true | collecting nest material | false | false | false | false | true | false | true | false | POINT (-73.9745152462626 40.76554155159081) | 19 | 4 | 19 | 13 | ||||||
318 | 318 | -73.9743990576746 | 40.7768690723163 | 12A-PM-1013-04 | 12A | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | true | false | false | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.9743990576746 40.7768690723163) | 19 | 4 | 19 | 13 | |||||
1476 | 1476 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 10202018 | 4 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.976609486498 40.7717832922535) | 19 | 4 | 19 | 13 | ||||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
100 | 100 | -73.9761592532482 | 40.7747213585387 | 10A-AM-1006-04 | 10A | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 10 | tree near large rock on Bridle Path | false | false | false | false | false | walking on branch | false | false | false | false | true | false | false | false | POINT (-73.9761592532482 40.7747213585387) | 19 | 4 | 19 | 13 | ||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
1182 | 1182 | -73.9667206046912 | 40.7779993565098 | 17G-PM-1017-04 | 17G | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 10 | tree & ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
1280 | 1280 | -73.9562469727195 | 40.79685907654 | 39D-AM-1008-04 | 39D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562469727195 40.79685907654) | 19 | 4 | 19 | 13 | ||||||
1313 | 1313 | -73.9671813866177 | 40.7838640032038 | 22C-PM-1006-04 | 22C | PM | 10062018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9671813866177 40.7838640032038) | 19 | 4 | 19 | 13 | ||||||
1365 | 1365 | -73.9791648157033 | 40.767625444347 | 2C-AM-1010-04 | 02C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9791648157033 40.767625444347) | 19 | 4 | 19 | 13 | ||||||
1665 | 1665 | -73.9583944353352 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | true | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | 19 | 4 | 19 | 13 | |||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95662777215811 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
2366 | 2366 | -73.9676191846985 | 40.777641740817 | 16F-PM-1013-04 | 16F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9676191846985 40.777641740817) | 19 | 4 | 19 | 13 | |||||
2408 | 2408 | -73.9596949258862 | 40.7900079479217 | 31E-PM-1006-04 | 31E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9596949258862 40.7900079479217) | 19 | 4 | 19 | 13 | ||||||
2722 | 2722 | -73.9692271132136 | 40.777528508844 | 15E-PM-1008-04 | 15E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692271132136 40.777528508844) | 19 | 4 | 19 | 13 | ||||||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
1675 | 1675 | -73.9777497645834 | 40.7677344709178 | 2D-AM-1007-04 | 02D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9777497645834 40.7677344709178) | 19 | 4 | 19 | 13 | ||||||
1993 | 1993 | -73.9546367558712 | 40.789840987798 | 33I-AM-1008-04 | 33I | AM | 10082018 | 4 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9546367558712 40.789840987798) | 19 | 4 | 19 | 13 | |||||||
96 | 96 | -73.9708549670788 | 40.7699587019058 | 7H-PM-1006-04 | 07H | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 12 | on tree knob | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9708549670788 40.7699587019058) | 19 | 4 | 19 | 13 | ||||
2521 | 2521 | -73.976869549792 | 40.7706982454723 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | false | false | false | false | false | relaxing | false | false | false | true | false | false | true | false | POINT (-73.976869549792 40.7706982454723) | 19 | 4 | 19 | 13 | |||
364 | 364 | -73.9623696148045 | 40.792184861375 | 32B-AM-1017-04 | 32B | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9623696148045 40.792184861375) | 19 | 4 | 19 | 13 | |||||
163 | 163 | -73.9712308864394 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
539 | 539 | -73.9761440627966 | 40.7706035301542 | 6D-PM-1020-04 | 06D | PM | 10202018 | 4 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761440627966 40.7706035301542) | 19 | 4 | 19 | 13 | |||||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1767 | 1767 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 10142018 | 4 | Gray | White | Gray+White | Above Ground | 15 | Ground then tree to eat | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
2779 | 2779 | -73.9767835160078 | 40.7674030330482 | 2E-PM-1014-04 | 02E | PM | 10142018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9767835160078 40.7674030330482) | 19 | 4 | 19 | 13 | |||||
3008 | 3008 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9503533343658 40.7976543603953) | 12423 | 18 | 4 | 36 | 18 | ||||
805 | 805 | -73.9706851546184 | 40.7780777016038 | 15D-PM-1017-04 | 15D | PM | 10172018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on fence | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706851546184 40.7780777016038) | 19 | 4 | 19 | 13 | |||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
1729 | 1729 | -73.9765046109019 | 40.7736674124746 | 8B-AM-1007-04 | 08B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765046109019 40.7736674124746) | 19 | 4 | 19 | 13 | ||||||
1828 | 1828 | -73.9682965197661 | 40.7805378963883 | 18D-AM-1018-04 | 18D | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9682965197661 40.7805378963883) | 19 | 4 | 19 | 13 | ||||||
2140 | 2140 | -73.9598875541307 | 40.7973415580717 | 38A-AM-1019-04 | 38A | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | false | false | false | walking | false | false | false | false | false | false | true | false | POINT (-73.9598875541307 40.7973415580717) | 19 | 4 | 19 | 13 | |||||
2265 | 2265 | -73.9705260103239 | 40.7826333686599 | 19A-PM-1013-04 | 19A | PM | 10132018 | 4 | Adult | Gray | Black, White | Gray+Black, White | Also looks quite brown - minimal body highlight coloring - black edges | Above Ground | 2 | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9705260103239 40.78263336865991) | 19 | 4 | 19 | 13 | ||||
2745 | 2745 | -73.97296259363 | 40.7652601851275 | 1I-PM-1012-04 | 01I | PM | 10122018 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 2 | on ledge | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.97296259363 40.7652601851275) | 19 | 4 | 19 | 13 | |||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
497 | 497 | -73.9602166876979 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 10132018 | 4 | Black | Black+ | Above Ground | 20 | Moved 20+ feet high above top of tree limb | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
1079 | 1079 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 10082018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20 | tree | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9722737593623 40.768963018754) | 19 | 4 | 19 | 13 | |||
1506 | 1506 | -73.9728339757306 | 40.7782891207966 | 14B-PM-1014-04 | 14B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | running up and down | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9728339757306 40.7782891207966) | 19 | 4 | 19 | 13 | ||||
1508 | 1508 | -73.9693894305786 | 40.7756906748026 | 13F-PM-1008-04 | 13F | PM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9693894305786 40.7756906748026) | 19 | 4 | 19 | 13 | |||||
1925 | 1925 | -73.9581389870644 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | laid down on the branch | false | false | false | false | false | false | false | true | POINT (-73.9581389870644 40.799308112252305) | 19 | 4 | 19 | 13 | |||||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757673193743 40.766961432261304) | 19 | 4 | 19 | 13 | ||||||
2145 | 2145 | -73.9651250402583 | 40.7812884929069 | 20F-PM-1007-04 | 20F | PM | 10072018 | 4 | Juvenile | Gray | White | Gray+White | white on tail | Above Ground | 20 | climbed tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651250402583 40.7812884929069) | 19 | 4 | 19 | 13 | |||
2248 | 2248 | -73.9766477027266 | 40.7712737417779 | 6C-AM-1007-04 | 06C | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | true | true | false | false | chasing #5 | false | false | false | false | false | false | true | false | POINT (-73.9766477027266 40.7712737417779) | 19 | 4 | 19 | 13 | |||||
2295 | 2295 | -73.9590632051055 | 40.7963146584827 | 38B-AM-1019-04 | 38B | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting in tree | true | true | false | true | false | false | true | false | observant | POINT (-73.9590632051055 40.7963146584827) | 19 | 4 | 19 | 13 | ||||
2390 | 2390 | -73.9680741975294 | 40.7847036778165 | 23B-PM-1012-04 | 23B | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 20 | false | false | false | false | false | watching me - didn't move | false | false | false | false | true | false | false | true | POINT (-73.9680741975294 40.7847036778165) | 19 | 4 | 19 | 13 | ||||
2754 | 2754 | -73.9687025912431 | 40.7719319822619 | 10H-AM-1014-04 | 10H | AM | 10142018 | 4 | Juvenile | + | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687025912431 40.7719319822619) | 19 | 4 | 19 | 13 | |||||||
1411 | 1411 | -73.9802840031759 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
1573 | 1573 | -73.9595613548804 | 40.7838057527338 | 25I-PM-1007-04 | 25I | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595613548804 40.7838057527338) | 19 | 4 | 19 | 13 | ||||||
1790 | 1790 | -73.9730592548116 | 40.7740879251541 | 10D-AM-1008-04 | 10D | AM | 10082018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 25 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730592548116 40.7740879251541) | 19 | 4 | 19 | 13 | ||||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 19 | 4 | 19 | 13 | |||||
1053 | 1053 | -73.9685859705486 | 40.7848805065322 | 23A-AM-1018-04 | 23A | AM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | Tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685859705486 40.7848805065322) | 19 | 4 | 19 | 13 | |||||
1518 | 1518 | -73.9632265832593 | 40.7816914475461 | 22G-AM-1018-04 | 22G | AM | 10182018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9632265832593 40.78169144754611) | 19 | 4 | 19 | 13 | |||||
2175 | 2175 | -73.9657487923637 | 40.7786823090663 | 18G-PM-1013-04 | 18G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657487923637 40.7786823090663) | 19 | 4 | 19 | 13 | ||||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9766342759486 40.7687518380873) | 19 | 4 | 19 | 13 | |||||
178 | 178 | -73.9613780522542 | 40.790786197111 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9613780522542 40.790786197111) | 19 | 4 | 19 | 13 | ||||||
567 | 567 | -73.9756972647636 | 40.773624164826 | 9B-PM-1013-04 | 09B | PM | 10132018 | 4 | Juvenile | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9756972647636 40.773624164826) | 19 | 4 | 19 | 13 | |||||
1022 | 1022 | -73.9548853492712 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | jumping tree to tree | false | false | false | false | false | false | false | false | POINT (-73.9548853492712 40.7984783584388) | 19 | 4 | 19 | 13 | ||||
1391 | 1391 | -73.9578658632957 | 40.7933712188923 | 35E-AM-1020-04 | 35E | AM | 10202018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | false | false | false | hunkered down,tail over body; sitting perfectly still | false | false | false | false | false | false | true | false | POINT (-73.9578658632957 40.7933712188923) | 19 | 4 | 19 | 13 | ||||
2103 | 2103 | -73.9782983634755 | 40.7668314364263 | 1D-AM-1006-04 | 01D | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9782983634755 40.7668314364263) | 19 | 4 | 19 | 13 | |||||
1608 | 1608 | -73.9545425520879 | 40.7956853415959 | 39F-PM-1006-04 | 39F | PM | 10062018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | in tree | false | false | true | false | false | climbing down | false | false | false | false | false | false | false | true | ran when saw me | POINT (-73.9545425520879 40.7956853415959) | 19 | 4 | 19 | 13 | ||
1623 | 1623 | -73.9770119133023 | 40.7732949090005 | 8A-AM-1013-04 | 08A | AM | 10132018 | 4 | Juvenile | + | Above Ground | 4 | fence | true | true | false | true | true | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770119133023 40.7732949090005) | 19 | 4 | 19 | 13 | |||||
2478 | 2478 | -73.9674931070324 | 40.7783693690954 | 17F-AM-1007-04 | 17F | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 4 | false | false | false | true | false | chilling | true | false | false | false | false | false | true | false | POINT (-73.9674931070324 40.7783693690954) | 19 | 4 | 19 | 13 | ||||
2776 | 2776 | -73.9789687905912 | 40.7692693139328 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | true | false | true | true | false | false | false | false | false | true | false | true | true | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
2862 | 2862 | -73.967466716152 | 40.7824346548278 | 21D-PM-1008-04 | 21D | PM | 10082018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | false | false | false | true | false | false | false | false | false | false | false | false | true | i scared it | POINT (-73.967466716152 40.7824346548278) | 19 | 4 | 19 | 13 | ||||
670 | 670 | -73.9602398690946 | 40.7910157676119 | 32D-PM-1006-04 | 32D | PM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9602398690946 40.7910157676119) | 19 | 4 | 19 | 13 | |||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing | POINT (-73.9571233640232 40.7992458980266) | 19 | 4 | 19 | 13 | ||||
2839 | 2839 | -73.9672252136807 | 40.7876504743212 | 26A-PM-1006-04 | 26A | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672252136807 40.7876504743212) | 19 | 4 | 19 | 13 | ||||||
861 | 861 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 10062018 | 4 | + | Above Ground | 43 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
2449 | 2449 | -73.9599911537509 | 40.7914452542845 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9599911537509 40.7914452542845) | 19 | 4 | 19 | 13 | ||||||
2654 | 2654 | -73.9549261242548 | 40.7944701994615 | 37G-AM-1014-04 | 37G | AM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.9549261242548 40.7944701994615) | 19 | 4 | 19 | 13 | |||||
1110 | 1110 | -73.9676434256976 | 40.7862336624448 | 24A-PM-1007-04 | 24A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676434256976 40.7862336624448) | 19 | 4 | 19 | 13 | |||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
2322 | 2322 | -73.9723677854798 | 40.7667315410871 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9723677854798 40.7667315410871) | 19 | 4 | 19 | 13 | ||||||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 19 | 4 | 19 | 13 | ||||||
2613 | 2613 | -73.96393252683 | 40.7808289765857 | 21G-AM-1014-04 | 21G | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 6 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.96393252683 40.7808289765857) | 19 | 4 | 19 | 13 | |||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
2790 | 2790 | -73.9673554935258 | 40.7827527249594 | 21C-AM-1014-04 | 21C | AM | 10142018 | 4 | Adult | + | High in tree, unable to tell | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.96735549352582 40.7827527249594) | 19 | 4 | 19 | 13 | ||||||
354 | 354 | -73.9566751022336 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
1087 | 1087 | -73.9679955831115 | 40.7818431607916 | 20C-PM-1018-04 | 20C | PM | 10182018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9679955831115 40.7818431607916) | 19 | 4 | 19 | 13 | ||||||
1449 | 1449 | -73.9561124892063 | 40.7949440648632 | 37E-AM-1013-04 | 37E | AM | 10132018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | false | false | true | true | false | true | false | false | false | false | false | false | true | POINT (-73.9561124892063 40.7949440648632) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "Age" TEXT, "Primary Fur Color" TEXT, "Highlight Fur Color" TEXT, "Combination of Primary and Highlight Color" TEXT, "Color notes" TEXT, "Location" TEXT, "Above Ground Sighter Measurement" TEXT, "Specific Location" TEXT, "Running" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );