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, Foraging, Other Activities, Kuks, Quaas, Tail flags, Approaches, Other Interactions, Zip Codes, City Council Districts, Police Precincts
Link | rowid | Longitude | Latitude | Unique Squirrel ID | Hectare | Shift | Date ▼ | Hectare Squirrel Number | Age | Primary Fur Color | Highlight Fur Color | Combination of Primary and Highlight Color | Color notes | Location | Above Ground Sighter Measurement | Specific Location | Running | Chasing | Climbing | Eating | Foraging | Other Activities | Kuks | Quaas | Moans | Tail flags | Tail twitches | Approaches | Indifferent | Runs from | Other Interactions | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 90 | -73.9787180870736 | 40.7715877863274 | 5A-AM-1006-05 | 05A | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near 65th St arch | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9787180870736 40.7715877863274) | 19 | 4 | 19 | 13 | ||||
131 | 131 | -73.9755560786227 | 40.7662992317575 | 2F-AM-1006-05 | 02F | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | curious but shy | POINT (-73.9755560786227 40.7662992317575) | 19 | 4 | 19 | 13 | ||||
360 | 360 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672054610151 40.7876519923501) | 19 | 4 | 19 | 13 | ||||||
471 | 471 | -73.9707215394887 | 40.7727508149058 | 10G-AM-1006-05 | 10G | AM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#6) | true | false | false | false | false | false | false | false | POINT (-73.9707215394887 40.7727508149058) | 19 | 4 | 19 | 13 | |||||
500 | 500 | -73.9568305513017 | 40.7974086631267 | 40C-PM-1006-05 | 40C | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9568305513017 40.7974086631267) | 19 | 4 | 19 | 13 | ||||||
578 | 578 | -73.9671306431211 | 40.7838870159057 | 22C-PM-1006-05 | 22C | PM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9671306431211 40.783887015905705) | 19 | 4 | 19 | 13 | ||||||
697 | 697 | -73.970465600402 | 40.7701125773248 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | true | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.970465600402 40.7701125773248) | 19 | 4 | 19 | 13 | ||||
841 | 841 | -73.9746933852572 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
1043 | 1043 | -73.9758564394842 | 40.7674758942811 | 3E-AM-1006-05 | 03E | AM | 10062018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9758564394842 40.7674758942811) | 19 | 4 | 19 | 13 | ||||||
1048 | 1048 | -73.9782120139407 | 40.7717154468791 | 6A-AM-1006-05 | 06A | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | tree | false | false | true | false | false | false | false | false | true | true | false | false | false | curious | POINT (-73.9782120139407 40.7717154468791) | 19 | 4 | 19 | 13 | |||
1692 | 1692 | -73.973268329435 | 40.7708296517073 | 7E-AM-1006-05 | 07E | AM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.973268329435 40.7708296517073) | 19 | 4 | 19 | 13 | |||||
1842 | 1842 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 10062018 | 5 | + | Above Ground | tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
1891 | 1891 | -73.9749641575871 | 40.7673305056277 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9749641575871 40.7673305056277) | 19 | 4 | 19 | 13 | |||||
2087 | 2087 | -73.956502663005 | 40.788160908881 | 30I-PM-1006-05 | 30I | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
2245 | 2245 | -73.9774228454023 | 40.7686399839016 | 3D-AM-1006-05 | 03D | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (chased by boy),wary of humans in playground | POINT (-73.9774228454023 40.7686399839016) | 19 | 4 | 19 | 13 | ||||
2344 | 2344 | -73.9786310308892 | 40.7669349368183 | 1D-AM-1006-05 | 01D | AM | 10062018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | false | false | POINT (-73.9786310308892 40.7669349368183) | 19 | 4 | 19 | 13 | |||||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9605163698302 40.7914179994956) | 19 | 4 | 19 | 13 | |||||
2750 | 2750 | -73.957775998085 | 40.7932880937406 | 35E-PM-1006-05 | 35E | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.957775998085 40.7932880937406) | 19 | 4 | 19 | 13 | ||||||
2873 | 2873 | -73.955068474109 | 40.7911788152878 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.955068474109 40.7911788152878) | 19 | 4 | 19 | 13 | |||
36 | 36 | -73.9662438996681 | 40.7890381809441 | 28A-PM-1007-05 | 28A | PM | 10072018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9662438996681 40.7890381809441) | 19 | 4 | 19 | 13 | ||||||
49 | 49 | -73.9602222116708 | 40.793779699421 | 35C-AM-1007-05 | 35C | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9602222116708 40.793779699421) | 19 | 4 | 19 | 13 | ||||||
574 | 574 | -73.9706360005275 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
613 | 613 | -73.9688466874605 | 40.7737911559867 | 12G-PM-1007-05 | 12G | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688466874605 40.7737911559867) | 19 | 4 | 19 | 13 | ||||||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9582523503306 40.7996897499473) | 19 | 4 | 19 | 13 | |||||
983 | 983 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
1407 | 1407 | -73.9704778551644 | 40.7783119113627 | 15D-AM-1007-05 | 15D | AM | 10072018 | 5 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 19 | 4 | 19 | 13 | ||||||
1466 | 1466 | -73.9651177657676 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9651177657676 40.781240810382506) | 19 | 4 | 19 | 13 | ||||
1624 | 1624 | -73.9737060043988 | 40.7725660224983 | 8D-AM-1007-05 | 08D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737060043988 40.7725660224983) | 19 | 4 | 19 | 13 | ||||||
1944 | 1944 | -73.9743292066413 | 40.7756090404121 | 11B-AM-1007-05 | 11B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | true | false | false | POINT (-73.9743292066413 40.7756090404121) | 19 | 4 | 19 | 13 | ||||||
1994 | 1994 | -73.9598463837775 | 40.7834524724254 | 25I-PM-1007-05 | 25I | PM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9598463837775 40.7834524724254) | 19 | 4 | 19 | 13 | ||||||
2000 | 2000 | -73.9591070579246 | 40.7896776771157 | 31F-PM-1007-05 | 31F | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9591070579246 40.7896776771157) | 19 | 4 | 19 | 13 | ||||||
2074 | 2074 | -73.9676246014119 | 40.786355136088 | 24A-PM-1007-05 | 24A | PM | 10072018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 45 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676246014119 40.786355136088) | 19 | 4 | 19 | 13 | ||||
2173 | 2173 | -73.9546123259441 | 40.7941434862099 | 37G-PM-1007-05 | 37G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | jumping around! | false | false | false | false | false | false | false | false | POINT (-73.9546123259441 40.7941434862099) | 19 | 4 | 19 | 13 | ||||
2209 | 2209 | -73.9697583235533 | 40.7787320391004 | 16D-AM-1007-05 | 16D | AM | 10072018 | 5 | Adult | Gray | Gray+ | didn't get a good look | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96975832355331 40.7787320391004) | 19 | 4 | 19 | 13 | |||||
2365 | 2365 | -73.9688773306324 | 40.7766669852358 | 15F-AM-1007-05 | 15F | AM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9688773306324 40.7766669852358) | 19 | 4 | 19 | 13 | |||||
2651 | 2651 | -73.9632993246327 | 40.7888199519656 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9632993246327 40.7888199519656) | 19 | 4 | 19 | 13 | |||||
2944 | 2944 | -73.9739403850622 | 40.7693162287509 | 5F-AM-1007-05 | 05F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2 | tree | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9739403850622 40.7693162287509) | 19 | 4 | 19 | 13 | ||||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 19 | 4 | 19 | 13 | ||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9734695768004 40.7716297491384) | 19 | 4 | 19 | 13 | ||||
647 | 647 | -73.9734762649298 | 40.7663703404546 | 3H-AM-1008-05 | 03H | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 13 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9734762649298 40.7663703404546) | 19 | 4 | 19 | 13 | |||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
792 | 792 | -73.9730115687964 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9730115687964 40.7741018274312) | 19 | 4 | 19 | 13 | |||||
909 | 909 | -73.9665705456197 | 40.7823552871044 | 21D-PM-1008-05 | 21D | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9665705456197 40.7823552871044) | 19 | 4 | 19 | 13 | |||||
1592 | 1592 | -73.9575517912392 | 40.7889158268192 | 31H-PM-1008-05 | 31H | PM | 10082018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9575517912392 40.7889158268192) | 19 | 4 | 19 | 13 | ||||||
1883 | 1883 | -73.9568108465086 | 40.7971727026108 | 39D-AM-1008-05 | 39D | AM | 10082018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.95681084650862 40.7971727026108) | 19 | 4 | 19 | 13 | ||||||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 19 | 4 | 19 | 13 | ||||
2925 | 2925 | -73.9672152696834 | 40.7823874581829 | 21D-AM-1008-05 | 21D | AM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9672152696834 40.7823874581829) | 19 | 4 | 19 | 13 | |||||
313 | 313 | -73.9646610347972 | 40.7790583544252 | 19H-AM-1010-05 | 19H | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near a brush | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9646610347972 40.7790583544252) | 19 | 4 | 19 | 13 | ||||
1224 | 1224 | -73.9572530843479 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572530843479 40.7987460430546) | 19 | 4 | 19 | 13 | |||||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.976864402584 40.7705663751959) | 19 | 4 | 19 | 13 | |||||
1336 | 1336 | -73.9733820053679 | 40.7687330473562 | 5G-PM-1010-05 | 05G | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9733820053679 40.7687330473562) | 19 | 4 | 19 | 13 | |||||
1347 | 1347 | -73.9616693665254 | 40.792971019627 | 33B-AM-1010-05 | 33B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9616693665254 40.792971019627) | 19 | 4 | 19 | 13 | |||||
1606 | 1606 | -73.9628932797886 | 40.7923116396365 | 32B-PM-1010-05 | 32B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628932797886 40.7923116396365) | 19 | 4 | 19 | 13 | ||||||
1734 | 1734 | -73.9524132295658 | 40.7933777553406 | 37I-AM-1010-05 | 37I | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.95241322956582 40.7933777553406) | 19 | 4 | 19 | 13 | |||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
2107 | 2107 | -73.9772624834791 | 40.7692821918543 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772624834791 40.7692821918543) | 19 | 4 | 19 | 13 | |||||
2152 | 2152 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 10102018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9686925781295 40.7705688673142) | 19 | 4 | 19 | 13 | |||||
2240 | 2240 | -73.9697787673802 | 40.7781746195436 | 16D-PM-1010-05 | 16D | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697787673802 40.7781746195436) | 19 | 4 | 19 | 13 | ||||||
2701 | 2701 | -73.9791217510656 | 40.7676583475394 | 2C-AM-1010-05 | 02C | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9791217510656 40.7676583475394) | 19 | 4 | 19 | 13 | ||||
2875 | 2875 | -73.9546616782922 | 40.790974533739 | 34I-PM-1010-05 | 34I | PM | 10102018 | 5 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 | ||||||||
2889 | 2889 | -73.9771646835311 | 40.7693049165084 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
447 | 447 | -73.9725906016474 | 40.7713889729739 | 8F-PM-1012-05 | 08F | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9725906016474 40.7713889729739) | 19 | 4 | 19 | 13 | |||||
590 | 590 | -73.9785133301426 | 40.7718260288338 | 6A-PM-1012-05 | 06A | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785133301426 40.7718260288338) | 19 | 4 | 19 | 13 | |||||
1165 | 1165 | -73.9689504114652 | 40.7766770153764 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | true | false | false | true | false | sitting | false | false | false | false | false | false | false | false | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1292 | 1292 | -73.959019987128 | 40.7912546691805 | 33E-PM-1012-05 | 33E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | playing | false | false | false | false | false | false | false | false | POINT (-73.959019987128 40.7912546691805) | 19 | 4 | 19 | 13 | ||||
1428 | 1428 | -73.9666113598566 | 40.7752662550312 | 14H-PM-1012-05 | 14H | PM | 10122018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | approaches (someone was feeding it) | POINT (-73.9666113598566 40.7752662550312) | 19 | 4 | 19 | 13 | |||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
1568 | 1568 | -73.9681079869821 | 40.7723494081345 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
1845 | 1845 | -73.9626560807032 | 40.7884633049896 | 28D-AM-1012-05 | 28D | AM | 10122018 | 5 | Juvenile | Black | Black+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9626560807032 40.7884633049896) | 19 | 4 | 19 | 13 | ||||||
1947 | 1947 | -73.9747175419546 | 40.7692820030878 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | begging | POINT (-73.9747175419546 40.7692820030878) | 19 | 4 | 19 | 13 | ||||
2002 | 2002 | -73.9581706950566 | 40.7906321397269 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9581706950566 40.7906321397269) | 19 | 4 | 19 | 13 | |||||
2176 | 2176 | -73.9583201789615 | 40.7913938722521 | 33F-PM-1012-05 | 33F | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | true | false | false | true | true | false | false | true | POINT (-73.95832017896151 40.7913938722521) | 19 | 4 | 19 | 13 | |||||
2733 | 2733 | -73.9690082314914 | 40.7738993942891 | 12G-AM-1012-05 | 12G | AM | 10122018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9690082314914 40.7738993942891) | 19 | 4 | 19 | 13 | |||||
101 | 101 | -73.9544007658685 | 40.7950689723135 | 38F-PM-1013-05 | 38F | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | being chased,was pushed by other squirrel | true | true | false | false | false | false | false | false | POINT (-73.9544007658685 40.7950689723135) | 19 | 4 | 19 | 13 | ||||
412 | 412 | -73.9785675798034 | 40.7672992405289 | 1C-PM-1013-05 | 01C | PM | 10132018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9785675798034 40.7672992405289) | 19 | 4 | 19 | 13 | ||||||
416 | 416 | -73.9702788578386 | 40.7694484997295 | 7I-PM-1013-05 | 07I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9702788578386 40.7694484997295) | 19 | 4 | 19 | 13 | ||||
474 | 474 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540652304705 40.7955226178199) | 19 | 4 | 19 | 13 | |||||
536 | 536 | -73.9561141662309 | 40.7976258458604 | 40D-PM-1013-05 | 40D | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9561141662309 40.7976258458604) | 19 | 4 | 19 | 13 | |||||
646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.954092292214 40.7979800395433) | 19 | 4 | 19 | 13 | ||||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | digging | false | false | false | false | true | false | false | false | POINT (-73.9757216124349 40.7754310239649) | 19 | 4 | 19 | 13 | ||||
989 | 989 | -73.9603031059614 | 40.7943667735668 | 35C-PM-1013-05 | 35C | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9603031059614 40.7943667735668) | 19 | 4 | 19 | 13 | |||||
1157 | 1157 | -73.9704449096084 | 40.7689970778303 | 6I-PM-1013-05 | 06I | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | playing with #6 | false | false | false | false | true | false | false | false | POINT (-73.9704449096084 40.7689970778303) | 19 | 4 | 19 | 13 | ||||
1348 | 1348 | -73.9599197612389 | 40.7954836456006 | 36B-PM-1013-05 | 36B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9599197612389 40.7954836456006) | 19 | 4 | 19 | 13 | ||||||
1467 | 1467 | -73.9684657285532 | 40.7840113573723 | 22B-AM-1013-05 | 22B | AM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | looked down on me like her imperial subject | POINT (-73.9684657285532 40.7840113573723) | 19 | 4 | 19 | 13 | ||||
1496 | 1496 | -73.9615500510038 | 40.7920799263699 | 32C-PM-1013-05 | 32C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9615500510038 40.7920799263699) | 19 | 4 | 19 | 13 | ||||||
1501 | 1501 | -73.9608167300104 | 40.7954348688268 | 36A-PM-1013-05 | 36A | PM | 10132018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
1571 | 1571 | -73.9673129010312 | 40.7778169845999 | 16F-PM-1013-05 | 16F | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Pine tree near utility shed | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9673129010312 40.7778169845999) | 19 | 4 | 19 | 13 | ||||
1587 | 1587 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | climbing fence! | false | false | false | false | false | false | false | false | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
1728 | 1728 | -73.9787846880249 | 40.7682545903488 | 2C-PM-1013-05 | 02C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9787846880249 40.7682545903488) | 19 | 4 | 19 | 13 | |||||
1854 | 1854 | -73.9618076359384 | 40.7947808718203 | 35A-PM-1013-05 | 35A | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9618076359384 40.7947808718203) | 19 | 4 | 19 | 13 | |||||
1900 | 1900 | -73.9529224802393 | 40.7961895763649 | 40G-PM-1013-05 | 40G | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (to the tree) | POINT (-73.9529224802393 40.7961895763649) | 19 | 4 | 19 | 13 | |||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 19 | 4 | 19 | 13 | |||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 19 | 4 | 19 | 13 | ||||||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97518067271972 40.7671940332258) | 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 );