This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, 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, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
182 | 182 | -73.9691050656013 | 40.7808139538222 | 18C-PM-1018-01 | 18C | PM | 10182018 | 1 | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9691050656013 40.7808139538222) | 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 | ||||
252 | 252 | -73.974420668782 | 40.7749628597465 | 10C-PM-1013-04 | 10C | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.974420668782 40.7749628597465) | 19 | 4 | 19 | 13 | ||||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
305 | 305 | -73.9750283794865 | 40.7724101927821 | 8C-PM-1013-08 | 08C | PM | 10132018 | 8 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9750283794865 40.7724101927821) | 19 | 4 | 19 | 13 | ||||||
318 | 318 | -73.9743990576746 | 40.7768690723163 | 12A-PM-1013-04 | 12A | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | true | false | false | false | chasing #3 | false | false | false | false | false | false | true | false | POINT (-73.9743990576746 40.7768690723163) | 19 | 4 | 19 | 13 | |||||
398 | 398 | -73.9686737866872 | 40.7739714023732 | 12G-PM-1007-06 | 12G | PM | 10072018 | 6 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
446 | 446 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | mushroom | false | false | false | false | false | false | true | false | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
452 | 452 | -73.960300330029 | 40.7953475871869 | 36B-AM-1013-03 | 36B | AM | 10132018 | 3 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.960300330029 40.7953475871869) | 19 | 4 | 19 | 13 | |||||||
539 | 539 | -73.9761440627966 | 40.7706035301542 | 6D-PM-1020-04 | 06D | PM | 10202018 | 4 | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761440627966 40.7706035301542) | 19 | 4 | 19 | 13 | |||||||
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 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 | |||||
617 | 617 | -73.9558809064648 | 40.7952765022241 | 38E-PM-1014-03 | 38E | PM | 10142018 | 3 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9558809064648 40.7952765022241) | 19 | 4 | 19 | 13 | ||||||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
783 | 783 | -73.9677654289757 | 40.786785529449 | 25A-AM-1013-03 | 25A | AM | 10132018 | 3 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | false | false | false | false | being chased by #2 | false | false | false | false | false | false | true | false | POINT (-73.9677654289757 40.786785529449) | 19 | 4 | 19 | 13 | |||||
814 | 814 | -73.9607608482656 | 40.7954687648248 | 36A-PM-1013-06 | 36A | PM | 10132018 | 6 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9607608482656 40.7954687648248) | 19 | 4 | 19 | 13 | |||||
1072 | 1072 | -73.9566571713254 | 40.7989855775435 | 41C-AM-1017-04 | 41C | AM | 10172018 | 4 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566571713254 40.7989855775435) | 19 | 4 | 19 | 13 | |||||||
1089 | 1089 | -73.9655955841325 | 40.7762063860571 | 15H-PM-1008-04 | 15H | PM | 10082018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of landscape | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9655955841325 40.7762063860571) | 19 | 4 | 19 | 13 | |||||
1100 | 1100 | -73.980542388615 | 40.7682048804794 | 1B-AM-1012-14 | 01B | AM | 10122018 | 14 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980542388615 40.7682048804794) | 19 | 4 | 19 | 13 | ||||||
1150 | 1150 | -73.9744726434743 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 10132018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | chased up a tree by #4 | false | false | false | false | false | false | true | false | POINT (-73.9744726434743 40.776729630785) | 19 | 4 | 19 | 13 | |||||
1188 | 1188 | -73.9669529835992 | 40.7871864151365 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | true | false | true | false | false | d.p.t. | false | false | false | true | true | false | true | false | calm | POINT (-73.96695298359921 40.7871864151365) | 19 | 4 | 19 | 13 | ||||
1385 | 1385 | -73.9615649773504 | 40.7954761311501 | 36A-PM-1013-02 | 36A | PM | 10132018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9615649773504 40.7954761311501) | 19 | 4 | 19 | 13 | ||||||
1478 | 1478 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 10132018 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | false | false | false | true | false | staring at me | false | false | false | false | false | false | true | false | POINT (-73.96763709851662 40.7869888639434) | 19 | 4 | 19 | 13 | ||||
1585 | 1585 | -73.9611312355348 | 40.7950130863913 | 36A-PM-1013-04 | 36A | PM | 10132018 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | ON ROCK NEAR POND | false | false | false | false | false | sitting | false | false | false | false | true | false | true | false | POINT (-73.9611312355348 40.7950130863913) | 19 | 4 | 19 | 13 | ||||
1857 | 1857 | -73.9728797531377 | 40.7786733148687 | 15B-PM-1017-01 | 15B | PM | 10172018 | 1 | Gray | Gray+ | Above Ground | 20 | in tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9728797531377 40.7786733148687) | 19 | 4 | 19 | 13 | ||||||
1966 | 1966 | -73.9750911996499 | 40.7722445210179 | 8C-PM-1013-06 | 08C | PM | 10132018 | 6 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9750911996499 40.7722445210179) | 19 | 4 | 19 | 13 | ||||||
2163 | 2163 | -73.9643664403785 | 40.7793670703727 | 19H-AM-1010-01 | 19H | AM | 10102018 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | false | false | false | true | false | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | 19 | 4 | 19 | 13 | ||||
2191 | 2191 | -73.9734108731087 | 40.7676051392697 | 4G-AM-1006-03 | 04G | AM | 10062018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9734108731087 40.7676051392697) | 19 | 4 | 19 | 13 | ||||||
2225 | 2225 | -73.9562323455674 | 40.7946180656349 | 37E-AM-1013-02 | 37E | AM | 10132018 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9562323455674 40.79461806563491) | 19 | 4 | 19 | 13 | ||||||
2305 | 2305 | -73.9679833225379 | 40.7738547093402 | 12H-PM-1007-05 | 12H | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9679833225379 40.7738547093402) | 19 | 4 | 19 | 13 | ||||||
2582 | 2582 | -73.9665004148497 | 40.7805656411756 | 19E-PM-1018-05 | 19E | PM | 10182018 | 5 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9665004148497 40.7805656411756) | 19 | 4 | 19 | 13 | ||||||
2700 | 2700 | -73.9601988871514 | 40.7943473161329 | 35C-PM-1013-01 | 35C | PM | 10132018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | true | true | true | false | true | true | false | true | false | POINT (-73.9601988871514 40.7943473161329) | 19 | 4 | 19 | 13 | ||||||
2739 | 2739 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 10102018 | 2 | Cinnamon | Gray | Cinnamon+Gray | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2860 | 2860 | -73.9565179671319 | 40.7936663940365 | 36F-PM-1012-03 | 36F | PM | 10122018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95651796713192 40.7936663940365) | 19 | 4 | 19 | 13 | ||||||
2954 | 2954 | -73.9677474313377 | 40.7742119240825 | 12H-PM-1007-03 | 12H | PM | 10072018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677474313377 40.7742119240825) | 19 | 4 | 19 | 13 | |||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9800094828465 40.7677782585639) | 19 | 4 | 19 | 13 | ||||||
2995 | 2995 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9668442742942 40.7870781042595) | 19 | 4 | 19 | 13 | ||||||
3014 | 3014 | -73.9665572004288 | 40.7804347548303 | 19E-PM-1018-04 | 19E | PM | 10182018 | 4 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9665572004288 40.7804347548303) | 19 | 4 | 19 | 13 | |||||||
3022 | 3022 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639941227864 40.7899152327912) | 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 );