This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
273 | 273 | -73.9579218587172 | 40.7960605028848 | 38C-AM-1019-04 | 38C | AM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | true | false | false | false | false | true | false | POINT (-73.9579218587172 40.79606050288481) | 19 | 4 | 19 | 13 | ||||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 19 | 4 | 19 | 13 | ||||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 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 | |||||
529 | 529 | -73.9635290751183 | 40.7820936628202 | 22G-AM-1018-02 | 22G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9635290751183 40.7820936628202) | 19 | 4 | 19 | 13 | ||||||
603 | 603 | -73.9721592378418 | 40.776034583573 | 12C-AM-1013-02 | 12C | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9721592378418 40.776034583573) | 19 | 4 | 19 | 13 | ||||||
609 | 609 | -73.9698762023146 | 40.7782055688113 | 16D-PM-1010-09 | 16D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698762023146 40.77820556881131) | 19 | 4 | 19 | 13 | ||||||
739 | 739 | -73.9620597449066 | 40.7922465876813 | 33B-PM-1010-10 | 33B | PM | 10102018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | false | false | POINT (-73.9620597449066 40.7922465876813) | 19 | 4 | 19 | 13 | ||||||
771 | 771 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | Ran up tree | true | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
935 | 935 | -73.9666195118963 | 40.7839216739357 | 22C-PM-1006-10 | 22C | PM | 10062018 | 10 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666195118963 40.78392167393571) | 19 | 4 | 19 | 13 | ||||||
978 | 978 | -73.9676692772518 | 40.7764726688908 | 15G-AM-1008-03 | 15G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676692772518 40.7764726688908) | 19 | 4 | 19 | 13 | ||||||
1084 | 1084 | -73.9698839750249 | 40.7781433076692 | 16D-PM-1010-08 | 16D | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698839750249 40.7781433076692) | 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 | ||||||
1172 | 1172 | -73.9706929270645 | 40.7727841119424 | 10G-AM-1006-06 | 10G | AM | 10062018 | 6 | Juvenile | Gray | Gray+ | skinny tail | Ground Plane | FALSE | false | true | false | false | false | chasing (#5) | true | false | false | false | false | false | false | false | POINT (-73.9706929270645 40.7727841119424) | 19 | 4 | 19 | 13 | ||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 19 | 4 | 19 | 13 | |||||
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.980919134781 40.7683772453336) | 19 | 4 | 19 | 13 | ||||||
1355 | 1355 | -73.9655277320465 | 40.7806120529369 | 20F-AM-1014-03 | 20F | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9655277320465 40.7806120529369) | 19 | 4 | 19 | 13 | ||||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
1563 | 1563 | -73.9676270670996 | 40.776391443152 | 15G-AM-1008-04 | 15G | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9676270670996 40.776391443152) | 19 | 4 | 19 | 13 | ||||||
1574 | 1574 | -73.9561840935803 | 40.7992037821497 | 42C-PM-1013-05 | 42C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | true | false | false | false | false | false | true | false | POINT (-73.9561840935803 40.7992037821497) | 19 | 4 | 19 | 13 | ||||||
1596 | 1596 | -73.9666945123922 | 40.7839956493194 | 22C-PM-1006-11 | 22C | PM | 10062018 | 11 | Juvenile | Gray | Gray+ | Above Ground | 13 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9666945123922 40.7839956493194) | 19 | 4 | 19 | 13 | ||||||
1774 | 1774 | -73.9668909481942 | 40.7841298584027 | 22C-PM-1006-12 | 22C | PM | 10062018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | true | false | false | false | false | false | false | false | human friendly | POINT (-73.9668909481942 40.7841298584027) | 19 | 4 | 19 | 13 | |||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | true | true | false | false | false | false | false | true | POINT (-73.9581366214863 40.7988964092722) | 19 | 4 | 19 | 13 | ||||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.956806913988 40.7987736900857) | 19 | 4 | 19 | 13 | ||||||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9606559309874 40.7889527629826) | 19 | 4 | 19 | 13 | ||||||
1971 | 1971 | -73.9591880400132 | 40.7950071252836 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | true | true | false | false | true | false | true | false | POINT (-73.95918804001322 40.7950071252836) | 19 | 4 | 19 | 13 | |||||
2295 | 2295 | -73.9590632051055 | 40.7963146584827 | 38B-AM-1019-04 | 38B | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting in tree | true | true | false | true | false | false | true | false | observant | POINT (-73.9590632051055 40.7963146584827) | 19 | 4 | 19 | 13 | ||||
2588 | 2588 | -73.9581007437094 | 40.7959403112722 | 38C-AM-1019-06 | 38C | AM | 10192018 | 6 | Adult | Gray | Gray+ | Above Ground | 23 | false | false | true | false | false | true | false | false | true | false | false | true | false | POINT (-73.9581007437094 40.7959403112722) | 19 | 4 | 19 | 13 | ||||||
2712 | 2712 | -73.9682760864462 | 40.7780727569417 | 16E-PM-1018-04 | 16E | PM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | true | false | POINT (-73.9682760864462 40.7780727569417) | 19 | 4 | 19 | 13 | ||||||
2820 | 2820 | -73.9615926031253 | 40.7944223235385 | 35B-PM-1013-05 | 35B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | chased by dog #2 | true | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.96159260312531 40.7944223235385) | 19 | 4 | 19 | 13 | ||||
2960 | 2960 | -73.962524814515 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.962524814515 40.7810022923615) | 19 | 4 | 19 | 13 | ||||||
3011 | 3011 | -73.9678831312936 | 40.7847605974975 | 23B-PM-1012-06 | 23B | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | scolding | POINT (-73.9678831312936 40.7847605974975) | 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 );