This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114 | 114 | -73.971905618214 | 40.776238547063 | 13D-PM-1018-10 | 13D | PM | 10182018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.971905618214 40.776238547063) | 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 | ||||||
227 | 227 | -73.9598155300913 | 40.7905887826983 | 32E-AM-1007-10 | 32E | AM | 10072018 | 10 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9598155300913 40.7905887826983) | 19 | 4 | 19 | 13 | ||||||
351 | 351 | -73.9713330594434 | 40.7771924214236 | 14D-AM-1014-10 | 14D | AM | 10142018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9713330594434 40.7771924214236) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9763433202401 | 40.7738473490681 | 9B-PM-1013-10 | 09B | PM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | "Brown" written in as Primary | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763433202401 40.7738473490681) | 19 | 4 | 19 | 13 | ||||
449 | 449 | -73.9701335162984 | 40.7722051011357 | 10G-AM-1006-10 | 10G | AM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9701335162984 40.7722051011357) | 19 | 4 | 19 | 13 | ||||||
572 | 572 | -73.9763622269272 | 40.7704671295941 | 5C-PM-1010-10 | 05C | PM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | fed by woman | POINT (-73.9763622269272 40.7704671295941) | 19 | 4 | 19 | 13 | ||||
669 | 669 | -73.9802079259866 | 40.7678723471007 | 1B-AM-1012-10 | 01B | AM | 10122018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9802079259866 40.7678723471007) | 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 | ||||||
922 | 922 | -73.9708002461415 | 40.7726685284831 | 10F-PM-1019-10 | 10F | PM | 10192018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Arbor path & hill w/ bushes | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9708002461415 40.7726685284831) | 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 | ||||||
941 | 941 | -73.9717920322306 | 40.7763095393715 | 13D-AM-1014-10 | 13D | AM | 10142018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9717920322306 40.7763095393715) | 19 | 4 | 19 | 13 | |||||
997 | 997 | -73.9790896775237 | 40.7688048644871 | 3B-AM-1010-10 | 03B | AM | 10102018 | 10 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9790896775237 40.7688048644871) | 19 | 4 | 19 | 13 | |||||
1469 | 1469 | -73.9704831177035 | 40.7699878995692 | 7H-AM-1006-10 | 07H | AM | 10062018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9704831177035 40.7699878995692) | 19 | 4 | 19 | 13 | |||||
1550 | 1550 | -73.9698642668906 | 40.7784669316504 | 16D-PM-1010-10 | 16D | PM | 10102018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698642668906 40.7784669316504) | 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 | ||||||
1740 | 1740 | -73.9577758125518 | 40.799384716477 | 41B-AM-1010-10 | 41B | AM | 10102018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9577758125518 40.799384716477) | 19 | 4 | 19 | 13 | |||||
1852 | 1852 | -73.9792161469158 | 40.7679285436253 | 2C-PM-1013-10 | 02C | PM | 10132018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792161469158 40.7679285436253) | 19 | 4 | 19 | 13 | |||||
1996 | 1996 | -73.977641787698 | 40.7695830265784 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.977641787698 40.7695830265784) | 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 | ||||||
2153 | 2153 | -73.9797122322834 | 40.7678347587435 | 1B-PM-1019-10 | 01B | PM | 10192018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | Dog chased up tree | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.97971223228342 40.7678347587435) | 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 | ||||
2303 | 2303 | -73.9589470461357 | 40.7912817646361 | 33E-AM-1014-10 | 33E | AM | 10142018 | 10 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589470461357 40.7912817646361) | 19 | 4 | 19 | 13 | |||||
2308 | 2308 | -73.9688574856542 | 40.7780770207023 | 16E-AM-1014-10 | 16E | AM | 10142018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9688574856542 40.7780770207023) | 19 | 4 | 19 | 13 | |||||
2414 | 2414 | -73.9708175461804 | 40.7759228565501 | 13E-AM-1017-10 | 13E | AM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9708175461804 40.7759228565501) | 19 | 4 | 19 | 13 | ||||||
2445 | 2445 | -73.96193040894 | 40.792045169318 | 32C-PM-1013-10 | 32C | PM | 10132018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.96193040894 40.792045169318) | 19 | 4 | 19 | 13 | ||||||
2503 | 2503 | -73.974382557804 | 40.7674812627373 | 3F-AM-1006-10 | 03F | AM | 10062018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | on fence | false | false | true | false | false | false | false | false | false | false | false | false | false | clueless | POINT (-73.974382557804 40.7674812627373) | 19 | 4 | 19 | 13 | |||
2558 | 2558 | -73.9749469566854 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 10142018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
2601 | 2601 | -73.979636950073 | 40.7677999753976 | 1C-PM-1013-10 | 01C | PM | 10132018 | 10 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.979636950073 40.7677999753976) | 19 | 4 | 19 | 13 | ||||||
2624 | 2624 | -73.9706308500637 | 40.7696174874596 | 7H-PM-1006-10 | 07H | PM | 10062018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9706308500637 40.7696174874596) | 19 | 4 | 19 | 13 | ||||||
2704 | 2704 | -73.9657764490284 | 40.7811923229286 | 20F-PM-1007-10 | 20F | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9657764490284 40.7811923229286) | 19 | 4 | 19 | 13 | |||||
2737 | 2737 | -73.9703683510176 | 40.7743975363958 | 12F-PM-1007-10 | 12F | PM | 10072018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
2897 | 2897 | -73.9689554458632 | 40.7778593393957 | 16E-PM-1018-10 | 16E | PM | 10182018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689554458632 40.7778593393957) | 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 | ||||
69 | 69 | -73.9689000978955 | 40.7828364735236 | 20B-PM-1013-10 | 20B | PM | 10132018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | drank from a pond of rain water | false | false | false | false | false | false | true | false | POINT (-73.9689000978955 40.7828364735236) | 19 | 4 | 19 | 13 | ||||
741 | 741 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | hopping | false | false | false | false | false | false | true | false | POINT (-73.9790214253443 40.7686791169776) | 19 | 4 | 19 | 13 | ||||
174 | 174 | -73.9707274055755 | 40.7723889080377 | 10G-PM-1017-10 | 10G | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | playing (with #9) | false | false | false | false | false | false | true | false | POINT (-73.9707274055755 40.7723889080377) | 19 | 4 | 19 | 13 | |||||
115 | 115 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 10072018 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | stole (found?) an entire sandwich | false | false | false | false | false | false | true | false | POINT (-73.9530040923555 40.7922896176936) | 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 );