This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts
Link | rowid | Longitude | Latitude | Unique Squirrel ID | Hectare | Shift | Date | Hectare Squirrel Number ▼ | Age | Primary Fur Color | Highlight Fur Color | Combination of Primary and Highlight Color | Color notes | Location | Above Ground Sighter Measurement | Specific Location | Running | Chasing | Climbing | Eating | Foraging | Other Activities | Kuks | Quaas | Moans | Tail flags | Tail twitches | Approaches | Indifferent | Runs from | Other Interactions | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | false | false | false | false | false | unknown | true | false | false | false | false | false | false | false | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | true | false | false | false | false | flying | false | false | false | false | false | false | false | false | POINT (-73.9700100617602 40.7815739959357) | 19 | 4 | 19 | 13 | ||||
137 | 137 | -73.9782417115139 | 40.7724665036447 | 7A-AM-1006-01 | 07A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | false | false | true | false | true | false | false | true | false | false | false | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
144 | 144 | -73.9730750601212 | 40.7701304211944 | 6F-PM-1008-01 | 06F | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730750601212 40.7701304211944) | 19 | 4 | 19 | 13 | |||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
291 | 291 | -73.9679661308374 | 40.7837388390673 | 22C-AM-1013-01 | 22C | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | sitting still,tail over back | false | false | false | false | false | false | false | false | POINT (-73.9679661308374 40.7837388390673) | 19 | 4 | 19 | 13 | ||||
317 | 317 | -73.9545799024508 | 40.7908084039886 | 34I-PM-1010-01 | 34I | PM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545799024508 40.7908084039886) | 19 | 4 | 19 | 13 | ||||||
333 | 333 | -73.9667560049684 | 40.7882333830729 | 27A-PM-1006-01 | 27A | PM | 10062018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | false | false | false | true | true | walking up & down branches | false | false | false | false | false | false | true | false | POINT (-73.9667560049684 40.7882333830729) | 19 | 4 | 19 | 13 | ||||
385 | 385 | -73.979316275899 | 40.7692134727555 | 3B-PM-1007-01 | 03B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.979316275899 40.7692134727555) | 19 | 4 | 19 | 13 | ||||
387 | 387 | -73.9578316525492 | 40.7890102959629 | 31G-PM-1007-01 | 31G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | hiding | false | false | false | false | true | false | false | false | froze,sight of dogs | POINT (-73.9578316525492 40.7890102959629) | 19 | 4 | 19 | 13 | ||||
426 | 426 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on railing | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
433 | 433 | -73.9558474701153 | 40.7913335515534 | 34H-AM-1007-01 | 34H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.9558474701153 40.7913335515534) | 19 | 4 | 19 | 13 | ||||
488 | 488 | -73.9615751148595 | 40.7954551238146 | 36A-AM-1018-01 | 36A | AM | 10182018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9615751148595 40.7954551238146) | 19 | 4 | 19 | 13 | ||||
498 | 498 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9669432929573 40.779136518298) | 19 | 4 | 19 | 13 | |||||
512 | 512 | -73.9586098170241 | 40.7939653733898 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
673 | 673 | -73.958417813526 | 40.7927301214476 | 34E-PM-1006-01 | 34E | PM | 10062018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | false | false | false | false | false | sitting and watching on a tree | false | false | false | false | false | false | true | false | POINT (-73.958417813526 40.7927301214476) | 19 | 4 | 19 | 13 | ||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
906 | 906 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96641208260151 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
1109 | 1109 | -73.9678154033099 | 40.7742783484486 | 12H-PM-1007-01 | 12H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9678154033099 40.7742783484486) | 19 | 4 | 19 | 13 | ||||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
1147 | 1147 | -73.9631818528816 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1178 | 1178 | -73.9507772992986 | 40.7949188960194 | 40I-PM-1013-01 | 40I | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | false | true | false | eating (berries) | false | false | false | false | false | false | true | false | POINT (-73.9507772992986 40.7949188960194) | 19 | 4 | 19 | 13 | ||||
1235 | 1235 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | jumping back & forth on tree | false | false | false | true | true | false | true | false | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
1239 | 1239 | -73.9725897240269 | 40.7691342079294 | 6G-AM-1008-01 | 06G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | in tree | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9725897240269 40.7691342079294) | 19 | 4 | 19 | 13 | |||
1241 | 1241 | -73.9651817987035 | 40.7819082838334 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | false | false | false | true | true | false | false | false | false | true | false | false | false | walks from | POINT (-73.9651817987035 40.7819082838334) | 19 | 4 | 19 | 13 | |||
1384 | 1384 | -73.9787608762005 | 40.7686062296462 | 3C-PM-1008-01 | 03C | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | false | false | false | false | false | walked between trees | false | false | false | false | false | false | true | false | POINT (-73.9787608762005 40.7686062296462) | 19 | 4 | 19 | 13 | ||||
1408 | 1408 | -73.973230162241 | 40.7689824531444 | 5F-AM-1007-01 | 05F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | fence | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.973230162241 40.7689824531444) | 19 | 4 | 19 | 13 | ||||
1423 | 1423 | -73.9600204328201 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9600204328201 40.782877291358) | 19 | 4 | 19 | 13 | |||||
1431 | 1431 | -73.9601918930677 | 40.7944134683406 | 35C-AM-1007-01 | 35C | AM | 10072018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | (white oak) | false | false | false | false | false | sitting still | false | false | false | false | false | false | false | false | POINT (-73.9601918930677 40.7944134683406) | 19 | 4 | 19 | 13 | |||
1737 | 1737 | -73.9640741640547 | 40.7807274581426 | 20G-AM-1018-01 | 20G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 7 | Tree limb | false | false | false | false | false | sitting still on limb | false | false | false | false | false | false | true | false | POINT (-73.9640741640547 40.7807274581426) | 19 | 4 | 19 | 13 | ||||
1751 | 1751 | -73.9594045885402 | 40.7840886870652 | 26I-AM-1010-01 | 26I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9594045885402 40.7840886870652) | 19 | 4 | 19 | 13 | ||||||
1864 | 1864 | -73.9694344956258 | 40.7742869276902 | 12G-PM-1007-01 | 12G | PM | 10072018 | 1 | Gray | Gray+ | Above Ground | 40 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694344956258 40.7742869276902) | 19 | 4 | 19 | 13 | ||||||
1867 | 1867 | -73.9745204169071 | 40.7736282868469 | 9C-AM-1006-01 | 09C | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | Tree | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9745204169071 40.7736282868469) | 19 | 4 | 19 | 13 | |||||
2008 | 2008 | -73.9524364087437 | 40.792846505434 | 37I-PM-1006-01 | 37I | PM | 10062018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Above Ground | 5 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9524364087437 40.792846505434) | 19 | 4 | 19 | 13 | |||||
2067 | 2067 | -73.9725077933574 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | false | false | false | false | false | staring at me | false | false | false | false | false | false | false | true | POINT (-73.9725077933574 40.7654562710325) | 19 | 4 | 19 | 13 | |||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | false | false | watching | false | false | false | false | false | true | false | false | POINT (-73.9651541395415 40.7798283208748) | 19 | 4 | 19 | 13 | ||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
2387 | 2387 | -73.9808517324721 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
2389 | 2389 | -73.9801343393329 | 40.7691512453402 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
2417 | 2417 | -73.9720323148189 | 40.7729703459618 | 10E-PM-1007-01 | 10E | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9720323148189 40.7729703459618) | 19 | 4 | 19 | 13 | ||||||
2456 | 2456 | -73.9698446365683 | 40.7842607168578 | 22A-AM-1008-01 | 22A | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9698446365683 40.7842607168578) | 19 | 4 | 19 | 13 | ||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
2550 | 2550 | -73.9694805745522 | 40.7743556902843 | 12F-AM-1020-01 | 12F | AM | 10202018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 17 | Tree | false | false | false | false | false | jumping | false | false | false | false | false | false | false | false | POINT (-73.9694805745522 40.7743556902843) | 19 | 4 | 19 | 13 | |||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 19 | 4 | 19 | 13 | |||||
2680 | 2680 | -73.9721348050673 | 40.7666920046704 | 3H-AM-1008-01 | 03H | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | false | false | false | false | false | teasing barking dog | false | false | false | false | false | false | true | false | indifferent by not caring about dog | POINT (-73.9721348050673 40.7666920046704) | 19 | 4 | 19 | 13 | |||
2706 | 2706 | -73.9745141185576 | 40.7691479781207 | 5E-AM-1008-01 | 05E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2 | on a checker table | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9745141185576 40.7691479781207) | 19 | 4 | 19 | 13 | ||||
2755 | 2755 | -73.9712022111028 | 40.7672504368263 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
2786 | 2786 | -73.9683883750097 | 40.7754344396847 | 13G-PM-1008-01 | 13G | PM | 10082018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 20 | willow oak tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683883750097 40.7754344396847) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1662 | 1662 | -73.9561600237284 | 40.7953143196705 | 38E-AM-1010-10 | 38E | AM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | over a log across stream | false | false | false | false | false | chillin' | false | false | false | false | false | false | false | true | runs from leaf blower | POINT (-73.9561600237284 40.7953143196705) | 19 | 4 | 19 | 13 | ||
2177 | 2177 | -73.9758211560957 | 40.7693422860766 | 5E-AM-1008-10 | 05E | AM | 10082018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | up a tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9758211560957 40.7693422860766) | 19 | 4 | 19 | 13 | ||||
2215 | 2215 | -73.9674978826751 | 40.776288410765 | 15G-PM-1019-10 | 15G | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 1 | on a log | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9674978826751 40.776288410765) | 19 | 4 | 19 | 13 | |||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589470461357 40.7912817646361) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 19 | 4 | 19 | 13 | ||||||
683 | 683 | -73.9707683621584 | 40.7759815566123 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9707683621584 40.77598155661231) | 19 | 4 | 19 | 13 | |||||
1016 | 1016 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 10062018 | 11 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691293546408 40.77032190765491) | 19 | 4 | 19 | 13 | |||||
2653 | 2653 | -73.958932543729 | 40.7913445531266 | 33E-AM-1014-11 | 33E | AM | 10142018 | 11 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.958932543729 40.7913445531266) | 19 | 4 | 19 | 13 | |||||
901 | 901 | -73.9702228131711 | 40.7742131587983 | 12F-PM-1007-12 | 12F | PM | 10072018 | 12 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 5 | false | false | false | false | true | going down tree | false | false | false | false | false | false | true | false | POINT (-73.9702228131711 40.7742131587983) | 19 | 4 | 19 | 13 | ||||
966 | 966 | -73.958317581802 | 40.7916566683158 | 33E-AM-1014-12 | 33E | AM | 10142018 | 12 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | false | false | sleeping | false | false | false | false | false | false | false | false | asleep | POINT (-73.958317581802 40.7916566683158) | 19 | 4 | 19 | 13 | |||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
1875 | 1875 | -73.9527430510248 | 40.7924807950552 | 36I-PM-1007-12 | 36I | PM | 10072018 | 12 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Tiny! So tiny! | Above Ground | 2 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9527430510248 40.7924807950552) | 19 | 4 | 19 | 13 | ||||
1575 | 1575 | -73.9703169373939 | 40.7700658823854 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | running (up tree) | false | false | false | false | false | false | true | false | POINT (-73.9703169373939 40.7700658823854) | 19 | 4 | 19 | 13 | |||||
2648 | 2648 | -73.9729410488021 | 40.7709484964577 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | true | false | false | true | true | ran up tree 4 feet and ate leaves | false | false | false | false | false | false | true | false | POINT (-73.9729410488021 40.7709484964577) | 19 | 4 | 19 | 13 | ||||
1398 | 1398 | -73.9602808042376 | 40.7906130788763 | 32E-AM-1007-14 | 32E | AM | 10072018 | 14 | Adult | Gray | Gray+ | Above Ground | 50 | literally fell to ground from 50 feet up | false | false | false | false | false | falling | false | false | false | false | false | false | false | true | POINT (-73.9602808042376 40.7906130788763) | 19 | 4 | 19 | 13 | ||||
1768 | 1768 | -73.9773696455031 | 40.7687241866704 | 3D-PM-1010-14 | 03D | PM | 10102018 | 14 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | crying out | true | true | false | false | false | false | false | false | POINT (-73.9773696455031 40.7687241866704) | 19 | 4 | 19 | 13 | ||||
729 | 729 | -73.9776044578446 | 40.7697607308033 | 4C-PM-1010-15 | 04C | PM | 10102018 | 15 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree | false | true | false | false | false | chasing #14 | false | false | false | false | false | false | true | false | POINT (-73.9776044578446 40.7697607308033) | 19 | 4 | 19 | 13 | ||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
46 | 46 | -73.9673253417305 | 40.7749505252981 | 13H-PM-1010-02 | 13H | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9673253417305 40.7749505252981) | 19 | 4 | 19 | 13 | |||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
189 | 189 | -73.9735489537928 | 40.7681257911523 | 4G-AM-1006-02 | 04G | AM | 10062018 | 2 | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | false | false | false | sitting in tree | false | false | false | false | false | false | true | false | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
248 | 248 | -73.9751729403694 | 40.7743284123118 | 10B-PM-1014-02 | 10B | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | gingko tree by traffic light in front of Strawberry Fields | false | false | false | false | true | false | false | false | false | true | false | false | false | came over on tree to see me then disappeared | POINT (-73.9751729403694 40.7743284123118) | 19 | 4 | 19 | 13 | ||||
319 | 319 | -73.9659034359706 | 40.7797516688844 | 19F-AM-1007-02 | 19F | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 8 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659034359706 40.77975166888441) | 19 | 4 | 19 | 13 | |||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 19 | 4 | 19 | 13 | ||||||
503 | 503 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 10062018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.95983407835722 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
582 | 582 | -73.9677779408464 | 40.7867482211349 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | true | false | false | false | chasing #3 | false | false | false | true | false | false | true | false | POINT (-73.9677779408464 40.7867482211349) | 19 | 4 | 19 | 13 | |||||
600 | 600 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 10142018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
656 | 656 | -73.9553726714504 | 40.7987578541123 | 41D-AM-1014-02 | 41D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9553726714504 40.7987578541123) | 19 | 4 | 19 | 13 | |||||
744 | 744 | -73.9745687653791 | 40.7776396926997 | 13A-PM-1014-02 | 13A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 45 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9745687653791 40.7776396926997) | 19 | 4 | 19 | 13 | ||||||
747 | 747 | -73.9771422625274 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771422625274 40.772361415776) | 19 | 4 | 19 | 13 | ||||||
896 | 896 | -73.9755055978764 | 40.7707438681742 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755055978764 40.7707438681742) | 19 | 4 | 19 | 13 | ||||||
1006 | 1006 | -73.9686296217893 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 10142018 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
1011 | 1011 | -73.9719111470164 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | Was on top of the edge of Bow Bridge | false | false | false | false | false | jumped off | false | false | false | true | false | false | false | true | POINT (-73.9719111470164 40.7758789855474) | 19 | 4 | 19 | 13 | ||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | false | false | false | false | false | sitting & watching | false | false | false | false | false | false | true | false | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | 19 | 4 | 19 | 13 | ||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
1179 | 1179 | -73.9696762034757 | 40.7704883494264 | 8H-AM-1017-02 | 08H | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | root bed of tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696762034757 40.7704883494264) | 19 | 4 | 19 | 13 | ||||
1203 | 1203 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | eating (red berries) | false | false | false | false | false | false | true | false | POINT (-73.9616999731028 40.7954126939561) | 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 );