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, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
101 | 101 | -73.9544007658685 | 40.7950689723135 | 38F-PM-1013-05 | 38F | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | being chased,was pushed by other squirrel | true | true | false | false | false | false | false | false | POINT (-73.9544007658685 40.7950689723135) | 19 | 4 | 19 | 13 | ||||
260 | 260 | -73.978436117932 | 40.7724769242403 | 6A-AM-1006-06 | 06A | AM | 10062018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.978436117932 40.7724769242403) | 19 | 4 | 19 | 13 | ||||
401 | 401 | -73.965862100991 | 40.7825926896917 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | false | false | true | false | false | true | false | false | false | false | false | false | false | climbing tree | POINT (-73.965862100991 40.7825926896917) | 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 | ||||
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 | |||||
476 | 476 | -73.9690968160819 | 40.769923269444 | 8I-AM-1006-08 | 08I | AM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | not backing down | POINT (-73.9690968160819 40.769923269444) | 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 | ||||||||
686 | 686 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 10082018 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9695745672033 40.7791835122147) | 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 | ||||||
740 | 740 | -73.9583477850634 | 40.7914073632782 | 33F-PM-1012-06 | 33F | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9583477850634 40.7914073632782) | 19 | 4 | 19 | 13 | |||||
767 | 767 | -73.9655734633649 | 40.7805366922231 | 20F-AM-1014-02 | 20F | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | pulling leaves | true | false | false | false | false | false | false | false | POINT (-73.9655734633649 40.7805366922231) | 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 | ||||||
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 | ||||||||||
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 | ||||
1302 | 1302 | -73.9704024529864 | 40.7729256063889 | 10G-AM-1006-04 | 10G | AM | 10062018 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | chasing (#3) | true | false | false | false | false | false | false | false | POINT (-73.9704024529864 40.7729256063889) | 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 | |||||
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 | |||||
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 | ||||||||||
1508 | 1508 | -73.9693894305786 | 40.7756906748026 | 13F-PM-1008-04 | 13F | PM | 10082018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9693894305786 40.7756906748026) | 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 | ||||||
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 | ||||||
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 | ||||
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 | |||||
1778 | 1778 | -73.9685598106128 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 10082018 | 2 | + | unknown - cannot see, only hear | Above Ground | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | false | true | false | false | false | chasing squirrel #6 | true | true | false | false | true | false | false | false | POINT (-73.978844141973 40.7696046074378) | 19 | 4 | 19 | 13 | ||||
1931 | 1931 | -73.9533085932603 | 40.7934877861075 | 37H-PM-1006-03 | 37H | PM | 10062018 | 3 | + | Above Ground | 43 | tree | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9533085932603 40.7934877861075) | 19 | 4 | 19 | 13 | |||||||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9587678566254 40.7962656030995) | 19 | 4 | 19 | 13 | |||||
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 | ||||||||
2515 | 2515 | -73.9693338657183 | 40.7757055884538 | 13F-PM-1008-05 | 13F | PM | 10082018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | tree trunk | true | false | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9693338657183 40.77570558845381) | 19 | 4 | 19 | 13 | ||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 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 | |||||||||
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 );