This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, 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 | ||||||
2388 | 2388 | -73.9604476047877 | 40.7938014328732 | 35C-AM-1007-03 | 35C | AM | 10072018 | 3 | Adult | + | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9604476047877 40.7938014328732) | 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 | ||||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9713487591577 40.7784353043714) | 19 | 4 | 19 | 13 | |||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9625383795297 40.7883862331728) | 19 | 4 | 19 | 13 | ||||||
1979 | 1979 | -73.9612759291399 | 40.7930468323219 | 33B-AM-1010-03 | 33B | AM | 10102018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9612759291399 40.7930468323219) | 19 | 4 | 19 | 13 | ||||||
2120 | 2120 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9733905460282 40.7656337147768) | 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 | ||||||
2427 | 2427 | -73.9729297485331 | 40.7673278541438 | 4H-AM-1006-03 | 04H | AM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | met #4 while foraging and briefly tussled | false | false | false | false | false | false | true | false | POINT (-73.9729297485331 40.7673278541438) | 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 | ||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9745908987975 40.7655191512308) | 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 | |||||
1473 | 1473 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 10122018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9584064190878 40.7912992852442) | 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 | ||||
3 | 3 | -73.9768311751004 | 40.7667178072558 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768311751004 40.76671780725581) | 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 | |||||
454 | 454 | -73.9752793195744 | 40.7733960128931 | 9C-AM-1006-03 | 09C | AM | 10062018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9752793195744 40.7733960128931) | 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 | |||||
893 | 893 | -73.9799311173259 | 40.7685576997559 | 2B-AM-1010-03 | 02B | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9799311173259 40.7685576997559) | 19 | 4 | 19 | 13 | ||||||
954 | 954 | -73.9658443548822 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 10072018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | scared | POINT (-73.9658443548822 40.7796704898979) | 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 | ||||||
1323 | 1323 | -73.9744387347626 | 40.7776953143835 | 13A-AM-1017-03 | 13A | AM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744387347626 40.7776953143835) | 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 | |||||
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
2411 | 2411 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686907918759 40.7839462261858) | 19 | 4 | 19 | 13 | ||||||
358 | 358 | -73.9635658786416 | 40.7777291777901 | 18I-AM-1017-03 | 18I | AM | 10172018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9635658786416 40.77772917779011) | 19 | 4 | 19 | 13 | |||||
2291 | 2291 | -73.9756894776708 | 40.7681638218212 | 4E-AM-1020-03 | 04E | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756894776708 40.7681638218212) | 19 | 4 | 19 | 13 | |||||
2453 | 2453 | -73.9756105226696 | 40.7696531972655 | 5D-AM-1020-03 | 05D | AM | 10202018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9756105226696 40.7696531972655) | 19 | 4 | 19 | 13 | |||||
204 | 204 | -73.9679538163341 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | eating (mushroom) | false | false | false | false | false | false | false | true | POINT (-73.9679538163341 40.7837103696906) | 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 | ||
432 | 432 | -73.9757787135906 | 40.7737231427345 | 9B-PM-1013-03 | 09B | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9757787135906 40.7737231427345) | 19 | 4 | 19 | 13 | |||||
636 | 636 | -73.9757536187319 | 40.7755119810678 | 11A-PM-1013-03 | 11A | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9757536187319 40.7755119810678) | 19 | 4 | 19 | 13 | |||||
651 | 651 | -73.9801661903932 | 40.7697950141751 | 3A-PM-1017-03 | 03A | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801661903932 40.7697950141751) | 19 | 4 | 19 | 13 | |||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 19 | 4 | 19 | 13 | ||||
723 | 723 | -73.9654397484763 | 40.7798863522904 | 19F-PM-1017-03 | 19F | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9654397484763 40.7798863522904) | 19 | 4 | 19 | 13 | |||||
748 | 748 | -73.9756603846107 | 40.7672531319384 | 3F-PM-1013-03 | 03F | PM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9756603846107 40.7672531319384) | 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 | ||||
937 | 937 | -73.9706323458769 | 40.7713196034265 | 9G-PM-1007-03 | 09G | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9706323458769 40.771319603426505) | 19 | 4 | 19 | 13 | |||||
1145 | 1145 | -73.9611446263364 | 40.7911003407299 | 32D-AM-1013-03 | 32D | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611446263364 40.7911003407299) | 19 | 4 | 19 | 13 | |||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 19 | 4 | 19 | 13 | ||||
1289 | 1289 | -73.9724681269526 | 40.7743474675821 | 11D-PM-1006-03 | 11D | PM | 10062018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9724681269526 40.7743474675821) | 19 | 4 | 19 | 13 | |||||
1311 | 1311 | -73.9694169352433 | 40.7744408293858 | 12G-PM-1007-03 | 12G | PM | 10072018 | 3 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | bushes | false | false | false | false | true | false | false | false | false | false | false | false | false | friendly | POINT (-73.9694169352433 40.7744408293858) | 19 | 4 | 19 | 13 | ||||
1448 | 1448 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9772810073685 40.7693577540392) | 19 | 4 | 19 | 13 | |||||
1513 | 1513 | -73.9662409997642 | 40.7891042935432 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | true | true | chasing #2 took #2 food wrapper and is foraging through it | false | false | false | false | false | false | true | false | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
1619 | 1619 | -73.9744555348544 | 40.7728498106357 | 8D-PM-1007-03 | 08D | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9744555348544 40.7728498106357) | 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 | ||||
2184 | 2184 | -73.9694938608335 | 40.7745700102115 | 12F-PM-1007-03 | 12F | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694938608335 40.7745700102115) | 19 | 4 | 19 | 13 | |||||
2234 | 2234 | -73.9734741818047 | 40.766328451425 | 3H-PM-1014-03 | 03H | PM | 10142018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9734741818047 40.766328451425) | 19 | 4 | 19 | 13 | |||||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.954767265558 40.7973243644491) | 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 | |||||
2992 | 2992 | -73.9746063250438 | 40.7687654196811 | 4F-PM-1013-03 | 04F | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9746063250438 40.7687654196811) | 19 | 4 | 19 | 13 | |||||
660 | 660 | -73.9638298997554 | 40.7825966332367 | 22F-AM-1007-03 | 22F | AM | 10072018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | large white highlight | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9638298997554 40.7825966332367) | 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 | ||||
1121 | 1121 | -73.9645060433292 | 40.7768322057794 | 16I-AM-1008-03 | 16I | AM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9645060433292 40.7768322057794) | 19 | 4 | 19 | 13 | |||||
1572 | 1572 | -73.9540197079615 | 40.798039260983 | 41E-PM-1013-03 | 41E | PM | 10132018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Gray on legs | Above Ground | 20 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540197079615 40.798039260983) | 19 | 4 | 19 | 13 | ||||
1775 | 1775 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 10142018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | true | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
12 | 12 | -73.9683613516225 | 40.7725908847499 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9683613516225 40.7725908847499) | 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 | |||||
1418 | 1418 | -73.9673924060436 | 40.7788781851716 | 17F-AM-1007-03 | 17F | AM | 10072018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9673924060436 40.7788781851716) | 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 | |||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
2138 | 2138 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9791536183194 40.7672705931866) | 19 | 4 | 19 | 13 | |||||
2268 | 2268 | -73.9590191655172 | 40.7926139425111 | 34D-AM-1008-03 | 34D | AM | 10082018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9590191655172 40.7926139425111) | 19 | 4 | 19 | 13 | |||||
2539 | 2539 | -73.9781033448468 | 40.7666724066213 | 1D-AM-1006-03 | 01D | AM | 10062018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9781033448468 40.7666724066213) | 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 | |||||
2946 | 2946 | -73.974515099169 | 40.7700650799886 | 6E-PM-1010-03 | 06E | PM | 10102018 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | false | true | false | true | false | chasing #4 | false | false | false | false | false | false | true | false | POINT (-73.974515099169 40.770065079988605) | 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 | |||||
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | false | false | false | true | false | still | false | false | false | false | false | false | true | false | POINT (-73.9589249555235 40.7908193284981) | 19 | 4 | 19 | 13 | ||||
138 | 138 | -73.9721442939797 | 40.7700750802317 | 7G-PM-1018-03 | 07G | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9721442939797 40.7700750802317) | 19 | 4 | 19 | 13 | ||||||
179 | 179 | -73.9646901432328 | 40.775995869679 | 15I-PM-1012-03 | 15I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9646901432328 40.775995869679) | 19 | 4 | 19 | 13 | ||||||
196 | 196 | -73.965796978969 | 40.7760402842845 | 15H-PM-1008-03 | 15H | PM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | lawn moving east over Park path | false | false | false | false | false | not sure walk-pause-walk | false | false | false | false | false | false | true | false | POINT (-73.96579697896901 40.7760402842845) | 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 | ||||||
228 | 228 | -73.9728660779622 | 40.7753294525644 | 12C-AM-1013-03 | 12C | AM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying | false | false | false | false | false | false | true | false | POINT (-73.9728660779622 40.7753294525644) | 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 | ||||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
296 | 296 | -73.9596964641652 | 40.7957753591585 | 37B-AM-1018-03 | 37B | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9596964641652 40.7957753591585) | 19 | 4 | 19 | 13 | ||||||
297 | 297 | -73.9685604013735 | 40.7773439909065 | 15F-PM-1010-03 | 15F | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9685604013735 40.7773439909065) | 19 | 4 | 19 | 13 | ||||||
310 | 310 | -73.9795081274695 | 40.7691431548544 | 3B-PM-1007-03 | 03B | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9795081274695 40.7691431548544) | 19 | 4 | 19 | 13 | ||||||
329 | 329 | -73.967832992543 | 40.7783669913408 | 17E-PM-1018-03 | 17E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.967832992543 40.7783669913408) | 19 | 4 | 19 | 13 | ||||||
347 | 347 | -73.9611696144784 | 40.7816692895155 | 22I-AM-1007-03 | 22I | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611696144784 40.7816692895155) | 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 |
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 );