This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | 24 | -73.9584070974734 | 40.7913812490557 | 33F-AM-1008-01 | 33F | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | moving slowly | false | false | false | false | false | false | true | false | POINT (-73.9584070974734 40.7913812490557) | 19 | 4 | 19 | 13 | |||||
26 | 26 | -73.9649866016038 | 40.7764929694457 | 16I-AM-1008-01 | 16I | AM | 10082018 | 1 | 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.9649866016038 40.7764929694457) | 19 | 4 | 19 | 13 | |||||
112 | 112 | -73.9651754464439 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9651754464439 40.7755181941559) | 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 | |||||
151 | 151 | -73.9714789136757 | 40.7694886645194 | 6H-AM-1008-01 | 06H | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9714789136757 40.7694886645194) | 19 | 4 | 19 | 13 | |||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
265 | 265 | -73.9691094942294 | 40.776760392858 | 14E-AM-1008-01 | 14E | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | walking | false | false | false | false | false | false | false | true | POINT (-73.9691094942294 40.776760392858) | 19 | 4 | 19 | 13 | |||||
342 | 342 | -73.9605966636226 | 40.7889849108637 | 30E-AM-1008-01 | 30E | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | scurried into bushes when jogger ran by | POINT (-73.9605966636226 40.7889849108637) | 19 | 4 | 19 | 13 | ||||
382 | 382 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | false | false | false | true | false | false | false | false | false | false | true | false | false | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | 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 | ||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
507 | 507 | -73.9744835563086 | 40.7729521433235 | 9D-AM-1008-01 | 09D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9744835563086 40.7729521433235) | 19 | 4 | 19 | 13 | ||||||
587 | 587 | -73.9771843912229 | 40.7723666382125 | 7B-AM-1008-01 | 07B | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9771843912229 40.77236663821251) | 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 | |||||
773 | 773 | -73.9566189145352 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 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 | ||||||
929 | 929 | -73.9738611257716 | 40.7737246779587 | 10D-AM-1008-01 | 10D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | true | false | false | true | POINT (-73.9738611257716 40.7737246779587) | 19 | 4 | 19 | 13 | |||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
982 | 982 | -73.9676424599715 | 40.7777766106807 | 16F-AM-1008-01 | 16F | AM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | near fence | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9676424599715 40.7777766106807) | 19 | 4 | 19 | 13 | ||||
1094 | 1094 | -73.9773898301093 | 40.7708581562057 | 5B-AM-1008-01 | 05B | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | running across ball field 5,near home plate | false | false | false | false | false | false | true | false | POINT (-73.9773898301093 40.7708581562057) | 19 | 4 | 19 | 13 | ||||
1101 | 1101 | -73.95912925497 | 40.7925530280455 | 34D-AM-1008-01 | 34D | AM | 10082018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | staring at us | POINT (-73.95912925497001 40.7925530280455) | 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 | ||
1144 | 1144 | -73.9743184653765 | 40.7667932997 | 3G-AM-1008-01 | 03G | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9743184653765 40.7667932997) | 19 | 4 | 19 | 13 | ||||||
1214 | 1214 | -73.9699517492486 | 40.7753169595373 | 13F-PM-1008-01 | 13F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | true | false | false | POINT (-73.9699517492486 40.7753169595373) | 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 | |||
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 | ||||
1430 | 1430 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.970804709441 40.7758611111219) | 19 | 4 | 19 | 13 | |||||
1432 | 1432 | -73.9632577850183 | 40.793112839016 | 33A-AM-1008-01 | 33A | AM | 10082018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | acknowledged | POINT (-73.9632577850183 40.793112839016) | 19 | 4 | 19 | 13 | ||||
1521 | 1521 | -73.9723922904119 | 40.7729164833027 | 9E-AM-1008-01 | 09E | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9723922904119 40.7729164833027) | 19 | 4 | 19 | 13 | |||||
1534 | 1534 | -73.9695226023739 | 40.7797527775804 | 17D-AM-1008-01 | 17D | AM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695226023739 40.7797527775804) | 19 | 4 | 19 | 13 | |||||
1545 | 1545 | -73.9669207809051 | 40.7792767850126 | 18F-PM-1008-01 | 18F | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9669207809051 40.7792767850126) | 19 | 4 | 19 | 13 | |||||
1723 | 1723 | -73.9747959143543 | 40.7768078174366 | 12A-AM-1008-01 | 12A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9747959143543 40.7768078174366) | 19 | 4 | 19 | 13 | ||||||
1835 | 1835 | -73.9562068537632 | 40.7967332853238 | 39D-AM-1008-01 | 39D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562068537632 40.7967332853238) | 19 | 4 | 19 | 13 | ||||||
1975 | 1975 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9753291616796 40.7687376032936) | 19 | 4 | 19 | 13 | |||||
1982 | 1982 | -73.9729979174723 | 40.7742904356698 | 10D-PM-1008-01 | 10D | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9729979174723 40.7742904356698) | 19 | 4 | 19 | 13 | |||||
2005 | 2005 | -73.9755259087781 | 40.7707256124181 | 6D-AM-1008-01 | 06D | AM | 10082018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | true | false | true | false | false | false | false | true | false | false | POINT (-73.9755259087781 40.7707256124181) | 19 | 4 | 19 | 13 | |||||
2058 | 2058 | -73.9669017345324 | 40.7766928987073 | 15G-AM-1008-01 | 15G | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9669017345324 40.7766928987073) | 19 | 4 | 19 | 13 | |||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2146 | 2146 | -73.9547398684817 | 40.7896483795302 | 33I-AM-1008-01 | 33I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park @ 98th (north) | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9547398684817 40.7896483795302) | 19 | 4 | 19 | 13 | ||||
2415 | 2415 | -73.9683598086625 | 40.7811150451315 | 19D-PM-1008-01 | 19D | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9683598086625 40.7811150451315) | 19 | 4 | 19 | 13 | |||||
2429 | 2429 | -73.9726699686943 | 40.7701123791223 | 7F-AM-1008-01 | 07F | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bench | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9726699686943 40.7701123791223) | 19 | 4 | 19 | 13 | ||||
2431 | 2431 | -73.9630054996358 | 40.7905225147022 | 30C-PM-1008-01 | 30C | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9630054996358 40.7905225147022) | 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 | ||||
2489 | 2489 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | true | false | true | false | POINT (-73.9663168490265 40.7825083721362) | 19 | 4 | 19 | 13 | |||||
2526 | 2526 | -73.9646495450499 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9646495450499 40.7791203699027) | 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 | ||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 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 | |||||
2864 | 2864 | -73.9761879300037 | 40.7683918970301 | 3E-PM-1008-01 | 03E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9761879300037 40.7683918970301) | 19 | 4 | 19 | 13 | ||||||
2942 | 2942 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 10082018 | 1 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
121 | 121 | -73.9769939796382 | 40.7729537573035 | 7B-AM-1008-10 | 07B | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9769939796382 40.7729537573035) | 19 | 4 | 19 | 13 | ||||||
376 | 376 | -73.9698817079185 | 40.7758322627711 | 13E-PM-1008-10 | 13E | PM | 10082018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9698817079185 40.7758322627711) | 19 | 4 | 19 | 13 | |||||
1602 | 1602 | -73.9728836727349 | 40.770815850599 | 7F-AM-1008-10 | 07F | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9728836727349 40.770815850599) | 19 | 4 | 19 | 13 | ||||||
2139 | 2139 | -73.9697471123497 | 40.7773163388327 | 15E-PM-1008-10 | 15E | PM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697471123497 40.777316338832705) | 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 | ||||
2921 | 2921 | -73.9699573485164 | 40.7765857838015 | 14E-AM-1008-10 | 14E | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699573485164 40.7765857838015) | 19 | 4 | 19 | 13 | ||||||
2965 | 2965 | -73.9767389132988 | 40.7689323691424 | 4D-PM-1008-10 | 04D | PM | 10082018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 6 | climbed the fence & posed for a picture | false | false | true | false | true | false | false | false | false | false | true | false | false | POINT (-73.9767389132988 40.7689323691424) | 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 | |||
183 | 183 | -73.9768434635084 | 40.7728494038744 | 7B-AM-1008-11 | 07B | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9768434635084 40.7728494038744) | 19 | 4 | 19 | 13 | ||||||
952 | 952 | -73.9699763667769 | 40.7757060731026 | 13E-PM-1008-11 | 13E | PM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699763667769 40.775706073102604) | 19 | 4 | 19 | 13 | |||||
1278 | 1278 | -73.9729848996456 | 40.7707143294261 | 7F-AM-1008-11 | 07F | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9729848996456 40.7707143294261) | 19 | 4 | 19 | 13 | ||||||
1946 | 1946 | -73.9692925815903 | 40.7774506065008 | 15E-PM-1008-11 | 15E | PM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9692925815903 40.7774506065008) | 19 | 4 | 19 | 13 | ||||||
2665 | 2665 | -73.969784066769 | 40.7766940405403 | 14E-AM-1008-11 | 14E | AM | 10082018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | burying | false | false | false | false | false | false | true | false | curious | POINT (-73.969784066769 40.7766940405403) | 19 | 4 | 19 | 13 | |||
969 | 969 | -73.9773529368499 | 40.7728750685699 | 7B-AM-1008-12 | 07B | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773529368499 40.7728750685699) | 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 | ||||
1386 | 1386 | -73.9730085729495 | 40.7708933570327 | 7F-AM-1008-12 | 07F | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9730085729495 40.7708933570327) | 19 | 4 | 19 | 13 | ||||||
1696 | 1696 | -73.9694591667705 | 40.7766518221998 | 14E-AM-1008-12 | 14E | AM | 10082018 | 12 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694591667705 40.7766518221998) | 19 | 4 | 19 | 13 | ||||||
1376 | 1376 | -73.9773361580792 | 40.7729478226715 | 7B-AM-1008-13 | 07B | AM | 10082018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773361580792 40.7729478226715) | 19 | 4 | 19 | 13 | |||||
2122 | 2122 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | true | false | curious | POINT (-73.9692946938852 40.7767389791452) | 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 | ||||
2837 | 2837 | -73.9772691210241 | 40.7690960712994 | 4D-PM-1008-13 | 04D | PM | 10082018 | 13 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9772691210241 40.7690960712994) | 19 | 4 | 19 | 13 | |||||
715 | 715 | -73.9772026572674 | 40.7691598773017 | 4D-PM-1008-14 | 04D | PM | 10082018 | 14 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9772026572674 40.7691598773017) | 19 | 4 | 19 | 13 | |||||
1364 | 1364 | -73.9726090882487 | 40.7710199108849 | 7F-AM-1008-14 | 07F | AM | 10082018 | 14 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9726090882487 40.7710199108849) | 19 | 4 | 19 | 13 | ||||
1905 | 1905 | -73.9691968748482 | 40.7765862996192 | 14E-AM-1008-14 | 14E | AM | 10082018 | 14 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691968748482 40.7765862996192) | 19 | 4 | 19 | 13 | ||||||
2017 | 2017 | -73.9775067398903 | 40.7726566142401 | 7B-AM-1008-14 | 07B | AM | 10082018 | 14 | Adult | Gray | Gray+ | Above Ground | on fence | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9775067398903 40.7726566142401) | 19 | 4 | 19 | 13 | ||||||
1257 | 1257 | -73.9767247593654 | 40.7726200054197 | 7B-AM-1008-15 | 07B | AM | 10082018 | 15 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9767247593654 40.7726200054197) | 19 | 4 | 19 | 13 | |||||
1470 | 1470 | -73.9724806580638 | 40.7710077206132 | 7F-AM-1008-15 | 07F | AM | 10082018 | 15 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724806580638 40.7710077206132) | 19 | 4 | 19 | 13 | ||||||
2269 | 2269 | -73.9695518341907 | 40.7762145993937 | 14E-AM-1008-15 | 14E | AM | 10082018 | 15 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | walking | false | false | false | false | false | false | true | false | POINT (-73.9695518341907 40.7762145993937) | 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 | |||||
1566 | 1566 | -73.9695133370801 | 40.7765009796853 | 14E-AM-1008-16 | 14E | AM | 10082018 | 16 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695133370801 40.7765009796853) | 19 | 4 | 19 | 13 | ||||||
759 | 759 | -73.969951118124 | 40.7762756593015 | 14E-AM-1008-17 | 14E | AM | 10082018 | 17 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96995111812402 40.7762756593015) | 19 | 4 | 19 | 13 | ||||||
2749 | 2749 | -73.972967003211 | 40.7711848438157 | 7F-AM-1008-17 | 07F | AM | 10082018 | 17 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | scratching self | false | false | false | false | false | false | false | true | POINT (-73.972967003211 40.7711848438157) | 19 | 4 | 19 | 13 | |||||
2984 | 2984 | -73.9700158929437 | 40.7762359066591 | 14E-AM-1008-18 | 14E | AM | 10082018 | 18 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9700158929437 40.7762359066591) | 19 | 4 | 19 | 13 | ||||||
524 | 524 | -73.970173142921 | 40.7762349924081 | 14E-AM-1008-19 | 14E | AM | 10082018 | 19 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970173142921 40.7762349924081) | 19 | 4 | 19 | 13 | ||||||
14 | 14 | -73.9582694312289 | 40.7917367820255 | 33F-AM-1008-02 | 33F | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582694312289 40.7917367820255) | 19 | 4 | 19 | 13 | ||||||
40 | 40 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9535410657077 40.79287117600611) | 19 | 4 | 19 | 13 | ||||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
56 | 56 | -73.9724642436394 | 40.7690526441109 | 6G-AM-1008-02 | 06G | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | bush | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9724642436394 40.7690526441109) | 19 | 4 | 19 | 13 | |||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 19 | 4 | 19 | 13 | |||||
127 | 127 | -73.9664100504436 | 40.7828778892276 | 21D-AM-1008-02 | 21D | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9664100504436 40.7828778892276) | 19 | 4 | 19 | 13 | ||||||
249 | 249 | -73.9786339295735 | 40.7684918638639 | 3C-PM-1008-02 | 03C | PM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9786339295735 40.7684918638639) | 19 | 4 | 19 | 13 | |||||
250 | 250 | -73.9726747666002 | 40.7703022669308 | 7F-AM-1008-02 | 07F | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | see stories and locations | POINT (-73.9726747666002 40.7703022669308) | 19 | 4 | 19 | 13 | ||||
464 | 464 | -73.9664450399121 | 40.7887844904695 | 27A-AM-1008-02 | 27A | AM | 10082018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664450399121 40.7887844904695) | 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 | |||
732 | 732 | -73.9695041366722 | 40.7797878809482 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695041366722 40.7797878809482) | 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 | ||||||
821 | 821 | -73.959077668148 | 40.7926045823346 | 34D-AM-1008-02 | 34D | AM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.959077668148 40.7926045823346) | 19 | 4 | 19 | 13 | ||||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 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 );