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, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
222 | 222 | -73.9770273553525 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 10132018 | 3 | Juvenile | + | Above Ground | 3 | fence | true | true | true | true | false | playing tag together | false | false | false | false | false | true | false | false | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
1244 | 1244 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 10072018 | 3 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565260889843 40.79918079243371) | 19 | 4 | 19 | 13 | ||||||||||
1248 | 1248 | -73.9719729323923 | 40.7668318394546 | 4I-AM-1006-03 | 04I | AM | 10062018 | 3 | Adult | + | Can't tell :( | Above Ground | 28 | Tree | false | false | true | false | false | building nest! | false | false | false | false | false | false | false | false | POINT (-73.9719729323923 40.7668318394546) | 19 | 4 | 19 | 13 | ||||
1459 | 1459 | -73.9563847867316 | 40.7906012261163 | 33G-AM-1013-03 | 33G | AM | 10132018 | 3 | ? | + | Only peeked head out | Above Ground | 13 | false | false | false | false | false | peeking out of tree,did *not* come out | false | false | false | false | false | false | false | false | POINT (-73.9563847867316 40.7906012261163) | 19 | 4 | 19 | 13 | |||||
1931 | 1931 | -73.9533085932603 | 40.7934877861075 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9533085932603 40.7934877861075) | 19 | 4 | 19 | 13 | |||||||
2028 | 2028 | -73.9687347731861 | 40.7718955594385 | 10H-AM-1014-03 | 10H | AM | 10142018 | 3 | Juvenile | + | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9687347731861 40.7718955594385) | 19 | 4 | 19 | 13 | |||||||
2034 | 2034 | -73.9699135187297 | 40.7782354186163 | 16D-AM-1007-03 | 16D | AM | 10072018 | 3 | Adult | + | ran away before I could take a good look | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699135187297 40.7782354186163) | 19 | 4 | 19 | 13 | ||||||
2392 | 2392 | -73.9578981223015 | 40.7989967754358 | 41B-AM-1010-03 | 41B | AM | 10102018 | 3 | Adult | + | Above Ground | 60 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9578981223015 40.7989967754358) | 19 | 4 | 19 | 13 | |||||||
2910 | 2910 | -73.9506062997507 | 40.7976189496674 | 42H-PM-1014-03 | 42H | PM | 10142018 | 3 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9506062997507 40.7976189496674) | 12423 | 18 | 4 | 36 | 18 | ||||||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | true | false | false | true | false | false | false | false | false | true | false | false | true | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
388 | 388 | -73.9592537496995 | 40.7919271821316 | 33E-AM-1014-03 | 33E | AM | 10142018 | 3 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9592537496995 40.7919271821316) | 19 | 4 | 19 | 13 | ||||||
2413 | 2413 | -73.959701727877 | 40.790660026971 | 32E-AM-1007-03 | 32E | AM | 10072018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.959701727877 40.790660026971) | 19 | 4 | 19 | 13 | ||||||
1392 | 1392 | -73.9648090698176 | 40.7903882097837 | 29A-PM-1019-03 | 29A | PM | 10192018 | 3 | Juvenile | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | true | ran from,but now approaching. kind of weirding me out. | POINT (-73.9648090698176 40.7903882097837) | 19 | 4 | 19 | 13 | ||||
2985 | 2985 | -73.9721159387757 | 40.7660503188637 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9721159387757 40.7660503188637) | 19 | 4 | 19 | 13 | |||||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
2496 | 2496 | -73.9696274291417 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9696274291417 40.7691980808067) | 19 | 4 | 19 | 13 | ||||
254 | 254 | -73.9762246600197 | 40.775164077652 | 10A-AM-1006-03 | 10A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Bridle Path lawn | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9762246600197 40.775164077652) | 19 | 4 | 19 | 13 | |||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1369 | 1369 | -73.9702717260829 | 40.768951107763 | 6I-PM-1013-03 | 06I | PM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | Flowers, grass | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9702717260829 40.768951107763) | 19 | 4 | 19 | 13 | |||||
1543 | 1543 | -73.9713906492842 | 40.7750061310143 | 12E-PM-1018-03 | 12E | PM | 10182018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
1932 | 1932 | -73.9616972557304 | 40.7953872829374 | 36A-PM-1013-03 | 36A | PM | 10132018 | 3 | Juvenile | Cinnamon | Cinnamon+ | COULD HAVE BEEN CHIPPY, DEEP BROWN | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9616972557304 40.7953872829374) | 19 | 4 | 19 | 13 | |||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
224 | 224 | -73.9520592496349 | 40.7975076299811 | 42G-PM-1014-03 | 42G | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | on fence | true | false | false | false | false | prancing | false | false | false | false | false | false | false | true | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
257 | 257 | -73.9773317054464 | 40.7684035996758 | 3D-AM-1006-03 | 03D | AM | 10062018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | on top [of] a big rock/boulder in the area | true | false | true | false | false | climbing (rock) | false | false | false | false | false | true | false | false | approaches (slightly),wary of humans | POINT (-73.9773317054464 40.76840359967581) | 19 | 4 | 19 | 13 | ||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
1680 | 1680 | -73.9638167248251 | 40.7776485679354 | 18I-PM-1007-03 | 18I | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9638167248251 40.77764856793541) | 19 | 4 | 19 | 13 | ||||
2043 | 2043 | -73.9643223016635 | 40.781431908715 | 21F-AM-1018-03 | 21F | AM | 10182018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | dead | false | false | false | false | false | false | false | true | POINT (-73.9643223016635 40.781431908715) | 19 | 4 | 19 | 13 | ||||
2912 | 2912 | -73.9632164738341 | 40.7921270121312 | 32B-PM-1010-03 | 32B | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9632164738341 40.7921270121312) | 19 | 4 | 19 | 13 | |||||
925 | 925 | -73.9763116425885 | 40.7688839576487 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
140 | 140 | -73.9768652785664 | 40.7684838168207 | 3D-PM-1010-03 | 03D | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97686527856641 40.7684838168207) | 19 | 4 | 19 | 13 | |||||
1551 | 1551 | -73.9785114291288 | 40.7719779589449 | 6A-PM-1012-03 | 06A | PM | 10122018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785114291288 40.7719779589449) | 19 | 4 | 19 | 13 | |||||
1832 | 1832 | -73.9693159934697 | 40.7831212338295 | 21B-PM-1017-03 | 21B | PM | 10172018 | 3 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9693159934697 40.7831212338295) | 19 | 4 | 19 | 13 | |||||
2620 | 2620 | -73.9771800098131 | 40.7708863131336 | 5C-PM-1010-03 | 05C | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9771800098131 40.7708863131336) | 19 | 4 | 19 | 13 | |||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
223 | 223 | -73.9737091707831 | 40.7713732567512 | 7E-AM-1006-03 | 07E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737091707831 40.7713732567512) | 19 | 4 | 19 | 13 | |||||
226 | 226 | -73.9775681731459 | 40.7676421190309 | 2D-AM-1007-03 | 02D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775681731459 40.7676421190309) | 19 | 4 | 19 | 13 | ||||||
266 | 266 | -73.9786481009499 | 40.7697372811949 | 4B-PM-1018-03 | 04B | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9786481009499 40.7697372811949) | 19 | 4 | 19 | 13 | ||||||
356 | 356 | -73.9761036400144 | 40.7705482684594 | 6D-PM-1020-03 | 06D | PM | 10202018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9761036400144 40.7705482684594) | 19 | 4 | 19 | 13 | ||||||
361 | 361 | -73.9614824437251 | 40.7912929799884 | 32C-PM-1013-03 | 32C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9614824437251 40.7912929799884) | 19 | 4 | 19 | 13 | ||||||
395 | 395 | -73.9565686300382 | 40.797592846003 | 40C-PM-1006-03 | 40C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565686300382 40.797592846003) | 19 | 4 | 19 | 13 | ||||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
645 | 645 | -73.9758152322587 | 40.7692377401467 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | false | true | false | false | false | chasing #4 | false | false | false | false | false | false | false | false | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
665 | 665 | -73.9563661256875 | 40.7966823114508 | 39D-AM-1008-03 | 39D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9563661256875 40.7966823114508) | 19 | 4 | 19 | 13 | ||||||
778 | 778 | -73.9677054870327 | 40.778992870166 | 17E-AM-1017-03 | 17E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 9 | Tree trunk | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9677054870327 40.778992870166) | 19 | 4 | 19 | 13 | |||||
869 | 869 | -73.9629483374528 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
888 | 888 | -73.9674177504573 | 40.7769569731993 | 15G-PM-1019-03 | 15G | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674177504573 40.7769569731993) | 19 | 4 | 19 | 13 | ||||||
898 | 898 | -73.9542828053256 | 40.7941797320355 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9542828053256 40.7941797320355) | 19 | 4 | 19 | 13 | ||||||
958 | 958 | -73.9613862251332 | 40.791282169715 | 32C-AM-1014-03 | 32C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9613862251332 40.791282169715) | 19 | 4 | 19 | 13 | ||||||
978 | 978 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676692772518 40.7764726688908) | 19 | 4 | 19 | 13 | ||||||
1137 | 1137 | -73.9520280004414 | 40.7946345014466 | 39I-PM-1013-03 | 39I | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | false | true | false | false | POINT (-73.9520280004414 40.7946345014466) | 19 | 4 | 19 | 13 | |||||
1148 | 1148 | -73.9707339200738 | 40.7796333355689 | 17C-PM-1013-03 | 17C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707339200738 40.7796333355689) | 19 | 4 | 19 | 13 | |||||
1254 | 1254 | -73.9764013589865 | 40.7663063499207 | 1F-PM-1019-03 | 01F | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | false | false | false | false | false | hiding | false | false | false | false | false | false | false | false | POINT (-73.9764013589865 40.7663063499207) | 19 | 4 | 19 | 13 | |||||
1272 | 1272 | -73.9595717225279 | 40.7829872498299 | 25I-PM-1007-03 | 25I | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595717225279 40.7829872498299) | 19 | 4 | 19 | 13 | ||||||
1355 | 1355 | -73.9655277320465 | 40.7806120529369 | 20F-AM-1014-03 | 20F | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9655277320465 40.7806120529369) | 19 | 4 | 19 | 13 | ||||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9690645326017 40.7773822116124) | 19 | 4 | 19 | 13 | |||||
1824 | 1824 | -73.9617250054003 | 40.7925390432044 | 33B-PM-1010-03 | 33B | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9617250054003 40.7925390432044) | 19 | 4 | 19 | 13 | ||||||
1831 | 1831 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 10142018 | 3 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746877519291 40.7761402808083) | 19 | 4 | 19 | 13 | |||||||
1890 | 1890 | -73.9787723082807 | 40.7713655754004 | 5A-PM-1010-03 | 05A | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9787723082807 40.7713655754004) | 19 | 4 | 19 | 13 | ||||||
2076 | 2076 | -73.9712636931964 | 40.77998098773 | 17B-AM-1010-03 | 17B | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9712636931964 40.77998098773) | 19 | 4 | 19 | 13 | ||||||
2154 | 2154 | -73.976716425804 | 40.7736889979965 | 8A-PM-1014-03 | 08A | PM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 23 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.976716425804 40.7736889979965) | 19 | 4 | 19 | 13 | ||||||
2188 | 2188 | -73.9676113345824 | 40.7803482448467 | 19E-PM-1018-03 | 19E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Baseball field #3 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9676113345824 40.7803482448467) | 19 | 4 | 19 | 13 | |||||
2197 | 2197 | -73.9672413354558 | 40.7838116138235 | 22C-PM-1006-03 | 22C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9672413354558 40.7838116138235) | 19 | 4 | 19 | 13 | ||||||
2334 | 2334 | -73.9754922970511 | 40.7707686392991 | 6D-AM-1008-03 | 06D | AM | 10082018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9754922970511 40.7707686392991) | 19 | 4 | 19 | 13 | ||||||
2377 | 2377 | -73.9704328573603 | 40.7739347247552 | 11F-AM-1013-03 | 11F | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704328573603 40.7739347247552) | 19 | 4 | 19 | 13 | ||||||
2416 | 2416 | -73.9588689820908 | 40.7992384137972 | 40A-PM-1014-03 | 40A | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588689820908 40.799238413797205) | 19 | 4 | 19 | 13 | |||||
2422 | 2422 | -73.9683066605832 | 40.7781213930544 | 16E-PM-1018-03 | 16E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9683066605832 40.7781213930544) | 19 | 4 | 19 | 13 | ||||||
2441 | 2441 | -73.9579865329778 | 40.794906535675 | 37D-PM-1014-03 | 37D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579865329778 40.794906535675) | 19 | 4 | 19 | 13 | ||||||
2524 | 2524 | -73.9743877909071 | 40.7754706115974 | 11B-AM-1007-03 | 11B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9743877909071 40.7754706115974) | 19 | 4 | 19 | 13 | ||||||
2534 | 2534 | -73.9744368038675 | 40.7674281958115 | 3G-PM-1013-03 | 03G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (climbed tree to run from) | POINT (-73.97443680386752 40.7674281958115) | 19 | 4 | 19 | 13 | |||||
2603 | 2603 | -73.9708781504528 | 40.7724138070355 | 10F-AM-1007-03 | 10F | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708781504528 40.7724138070355) | 19 | 4 | 19 | 13 | ||||||
2660 | 2660 | -73.9726056411971 | 40.7793467904743 | 16A-PM-1019-03 | 16A | PM | 10192018 | 3 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9726056411971 40.7793467904743) | 19 | 4 | 19 | 13 | |||||||
2719 | 2719 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 10072018 | 3 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
2933 | 2933 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | true | true | false | false | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 19 | 4 | 19 | 13 | |||||
991 | 991 | -73.9635689059841 | 40.790163434915 | 30B-PM-1019-03 | 30B | PM | 10192018 | 3 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9635689059841 40.790163434915) | 19 | 4 | 19 | 13 | |||||
2228 | 2228 | -73.9714045891597 | 40.7715418333976 | 9G-AM-1007-03 | 09G | AM | 10072018 | 3 | Adult | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.97140458915972 40.7715418333976) | 19 | 4 | 19 | 13 | |||||
2883 | 2883 | -73.9698592838836 | 40.7743071443959 | 12F-AM-1020-03 | 12F | AM | 10202018 | 3 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | true | false | false | false | POINT (-73.9698592838836 40.7743071443959) | 19 | 4 | 19 | 13 | ||||
820 | 820 | -73.9801902133148 | 40.769557595068 | 3A-AM-1012-03 | 03A | AM | 10122018 | 3 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9801902133148 40.769557595068) | 19 | 4 | 19 | 13 | ||||
2852 | 2852 | -73.9728146482385 | 40.7652951714745 | 1I-PM-1012-03 | 01I | PM | 10122018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.97281464823851 40.765295171474506) | 19 | 4 | 19 | 13 | ||||
2 | 2 | -73.9570437717691 | 40.7948509408039 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | me | POINT (-73.9570437717691 40.794850940803904) | 19 | 4 | 19 | 13 | ||||
107 | 107 | -73.9521110154872 | 40.7978449143313 | 42G-AM-1018-03 | 42G | AM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | stop to look at me—then ran | false | false | false | false | false | false | false | true | POINT (-73.9521110154872 40.7978449143313) | 19 | 4 | 19 | 13 | ||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
220 | 220 | -73.967181612203 | 40.7787752287055 | 17F-PM-1020-03 | 17F | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 35 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.967181612203 40.7787752287055) | 19 | 4 | 19 | 13 | |||||
591 | 591 | -73.9543323786888 | 40.7943086530436 | 37G-PM-1007-03 | 37G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | false | true | false | lying on belly on branch,eating big nut | false | false | false | false | false | false | false | false | POINT (-73.9543323786888 40.7943086530436) | 19 | 4 | 19 | 13 | ||||
612 | 612 | -73.9629420113622 | 40.789133072717 | 29C-AM-1007-03 | 29C | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629420113622 40.789133072717) | 19 | 4 | 19 | 13 | |||||
628 | 628 | -73.9600165785486 | 40.7952466761832 | 36B-PM-1013-03 | 36B | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9600165785486 40.7952466761832) | 19 | 4 | 19 | 13 | |||||
698 | 698 | -73.9585537668382 | 40.7903905787005 | 32F-AM-1012-03 | 32F | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | bringing green leaves to nest | false | false | false | false | false | false | false | false | POINT (-73.9585537668382 40.7903905787005) | 19 | 4 | 19 | 13 | ||||
1012 | 1012 | -73.9755569170561 | 40.7668006977526 | 2F-AM-1006-03 | 02F | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755569170561 40.7668006977526) | 19 | 4 | 19 | 13 | ||||
1522 | 1522 | -73.9538970554532 | 40.7955196793479 | 39G-PM-1013-03 | 39G | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9538970554532 40.7955196793479) | 19 | 4 | 19 | 13 | |||||
1548 | 1548 | -73.9790044506465 | 40.7689469479245 | 3B-AM-1010-03 | 03B | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | chasing #2 | false | false | false | false | false | false | false | true | POINT (-73.9790044506465 40.7689469479245) | 19 | 4 | 19 | 13 | ||||
1620 | 1620 | -73.9635606199784 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9635606199784 40.782206970617) | 19 | 4 | 19 | 13 | |||||
1968 | 1968 | -73.9699088881236 | 40.7752778351626 | 13F-AM-1007-03 | 13F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699088881236 40.7752778351626) | 19 | 4 | 19 | 13 | |||||
2110 | 2110 | -73.9647151303629 | 40.7912681060756 | 30A-PM-1020-03 | 30A | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9647151303629 40.7912681060756) | 19 | 4 | 19 | 13 | ||||
2254 | 2254 | -73.9709991016317 | 40.7725756707748 | 10F-PM-1019-03 | 10F | PM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | Behind fence, grass | false | false | false | true | false | eating (nuts) | false | false | false | false | false | true | false | false | approaches (bad tourists w/ nuts) | POINT (-73.9709991016317 40.772575670774806) | 19 | 4 | 19 | 13 | |
2262 | 2262 | -73.9556177490335 | 40.7888569161537 | 32I-AM-1013-03 | 32I | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556177490335 40.7888569161537) | 19 | 4 | 19 | 13 | ||||
2272 | 2272 | -73.9569670900695 | 40.7948792856813 | 37E-PM-1006-03 | 37E | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | me | POINT (-73.9569670900695 40.794879285681304) | 19 | 4 | 19 | 13 | ||||
2399 | 2399 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | false | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | 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 );