This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
92 | 92 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 10072018 | 2 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
173 | 173 | -73.958770180151 | 40.7934123941528 | 35D-PM-1013-04 | 35D | PM | 10132018 | 4 | Juvenile | Gray | White | Gray+White | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958770180151 40.7934123941528) | 19 | 4 | 19 | 13 | |||||||
348 | 348 | -73.9542990150586 | 40.7940915300678 | 37G-PM-1007-09 | 37G | PM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
363 | 363 | -73.9707197274481 | 40.7773956803431 | 14D-PM-1019-12 | 14D | PM | 10192018 | 12 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707197274481 40.7773956803431) | 19 | 4 | 19 | 13 | ||||||||
390 | 390 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 10192018 | 11 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
455 | 455 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 10192018 | 4 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
537 | 537 | -73.9682803241007 | 40.7724510558327 | 11H-AM-1010-04 | 11H | AM | 10102018 | 4 | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
607 | 607 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 10102018 | 6 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
645 | 645 | -73.9758152322587 | 40.7692377401467 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | false | true | false | false | false | chasing #4 | false | false | false | false | false | false | false | false | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
1112 | 1112 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 10072018 | 2 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9583934264026 40.785474218550405) | 19 | 4 | 19 | 13 | ||||||||||
1244 | 1244 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 10072018 | 3 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565260889843 40.79918079243371) | 19 | 4 | 19 | 13 | ||||||||||
1342 | 1342 | -73.9662063642345 | 40.7890778665307 | 28A-PM-1007-04 | 28A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | false | looking at me & #5 | true | false | false | false | true | false | false | false | freezes | POINT (-73.9662063642345 40.7890778665307) | 19 | 4 | 19 | 13 | |||||
1372 | 1372 | -73.9528353702209 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 10192018 | 2 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
1407 | 1407 | -73.9704778551644 | 40.7783119113627 | 15D-AM-1007-05 | 15D | AM | 10072018 | 5 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704778551644 40.7783119113627) | 19 | 4 | 19 | 13 | |||||||||
1475 | 1475 | -73.9686778167484 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 10122018 | 4 | + | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.96867781674841 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
1557 | 1557 | -73.9705331808443 | 40.7699943571296 | 7H-AM-1006-09 | 07H | AM | 10062018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9705331808443 40.7699943571296) | 19 | 4 | 19 | 13 | |||||||
1648 | 1648 | -73.9790263372004 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
1764 | 1764 | -73.9534878316472 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 10192018 | 1 | + | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9534878316472 40.7978951981698) | 19 | 4 | 19 | 13 | ||||||||||
1928 | 1928 | -73.9725669210177 | 40.7681496989029 | 5H-AM-1007-01 | 05H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9725669210177 40.7681496989029) | 19 | 4 | 19 | 13 | |||||||
1958 | 1958 | -73.9693120090055 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 10182018 | 7 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
2014 | 2014 | -73.9786474809514 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2237 | 2237 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 10192018 | 13 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708225719705 40.7772497804149) | 19 | 4 | 19 | 13 | ||||||||
2257 | 2257 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 10072018 | 8 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95431338448 40.7940537582585) | 19 | 4 | 19 | 13 | ||||||||
2714 | 2714 | -73.9600738985438 | 40.7938328798752 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
2719 | 2719 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 10072018 | 3 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2875 | 2875 | -73.9546616782922 | 40.790974533739 | 34I-PM-1010-05 | 34I | PM | 10102018 | 5 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 |
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 );