This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | -73.958736593111 | 40.7908524370626 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958736593111 40.7908524370626) | 19 | 4 | 19 | 13 | ||||||
76 | 76 | -73.9530035564643 | 40.7921822457613 | 36I-PM-1007-07 | 36I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9530035564643 40.7921822457613) | 19 | 4 | 19 | 13 | ||||||
103 | 103 | -73.9607701370443 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 10132018 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | false | true | false | false | false | chasing #8 | false | false | false | false | false | false | false | true | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
129 | 129 | -73.9705092958892 | 40.7761092972965 | 13E-PM-1008-07 | 13E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9705092958892 40.7761092972965) | 19 | 4 | 19 | 13 | ||||||
134 | 134 | -73.9575943815564 | 40.7933755266787 | 35E-PM-1006-07 | 35E | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9575943815564 40.7933755266787) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9546042927016 40.7898133734952) | 19 | 4 | 19 | 13 | ||||||
434 | 434 | -73.9676639740486 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9676639740486 40.7745369616499) | 19 | 4 | 19 | 13 | ||||||
559 | 559 | -73.9704166194815 | 40.7766720346576 | 14E-AM-1008-07 | 14E | AM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | walking | false | false | false | false | false | false | true | false | POINT (-73.9704166194815 40.7766720346576) | 19 | 4 | 19 | 13 | |||||
668 | 668 | -73.9706903740547 | 40.7726873760687 | 10G-AM-1006-07 | 10G | AM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9706903740547 40.77268737606871) | 19 | 4 | 19 | 13 | ||||||
812 | 812 | -73.9699675160516 | 40.7773012642758 | 15E-PM-1008-07 | 15E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699675160516 40.7773012642758) | 19 | 4 | 19 | 13 | ||||||
910 | 910 | -73.9796383715206 | 40.7682477738244 | 2B-AM-1010-07 | 02B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9796383715206 40.7682477738244) | 19 | 4 | 19 | 13 | ||||||
926 | 926 | -73.9596006938677 | 40.7834706440535 | 25I-PM-1007-07 | 25I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #8 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596006938677 40.7834706440535) | 19 | 4 | 19 | 13 | ||||||
980 | 980 | -73.9709817796369 | 40.7773554311586 | 14D-PM-1019-07 | 14D | PM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9709817796369 40.7773554311586) | 19 | 4 | 19 | 13 | ||||||
1073 | 1073 | -73.9769742179824 | 40.7727484521829 | 7B-AM-1008-07 | 07B | AM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9769742179824 40.7727484521829) | 19 | 4 | 19 | 13 | ||||||
1173 | 1173 | -73.959070754026 | 40.7906675143413 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.959070754026 40.7906675143413) | 19 | 4 | 19 | 13 | |||||
1207 | 1207 | -73.9594708328732 | 40.791192982895 | 32E-AM-1007-07 | 32E | AM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | on tennis club house roof | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9594708328732 40.791192982895) | 19 | 4 | 19 | 13 | ||||||
1389 | 1389 | -73.9580021017892 | 40.7955140102242 | 37D-PM-1014-07 | 37D | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9580021017892 40.7955140102242) | 19 | 4 | 19 | 13 | ||||||
1390 | 1390 | -73.9677146741772 | 40.7788231332337 | 17E-AM-1017-07 | 17E | AM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9677146741772 40.7788231332337) | 19 | 4 | 19 | 13 | ||||||
1438 | 1438 | -73.971685475224 | 40.7706668465923 | 7G-PM-1018-07 | 07G | PM | 10182018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.971685475224 40.7706668465923) | 19 | 4 | 19 | 13 | ||||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1517 | 1517 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 10192018 | 7 | Adult | Gray | Gray+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970041085185 40.783442758031306) | 19 | 4 | 19 | 13 | ||||||
1666 | 1666 | -73.9649465476871 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649465476871 40.7822708362663) | 19 | 4 | 19 | 13 | ||||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1771 | 1771 | -73.9750688083336 | 40.7665584681025 | 2F-PM-1014-07 | 02F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9750688083336 40.7665584681025) | 19 | 4 | 19 | 13 | ||||||
1817 | 1817 | -73.9703076450783 | 40.770158422629 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#8),playing? | false | false | false | false | false | false | true | false | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
1922 | 1922 | -73.9602197762862 | 40.7936850570022 | 35C-PM-1013-07 | 35C | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9602197762862 40.7936850570022) | 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 | ||||||||
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 | ||||||||
2100 | 2100 | -73.9638312025305 | 40.7903826659569 | 30B-AM-1007-07 | 30B | AM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9638312025305 40.7903826659569) | 19 | 4 | 19 | 13 | ||||||
2179 | 2179 | -73.9559663949511 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | true | false | false | false | false | false | false | false | true | curious | POINT (-73.9559663949511 40.7974497269789) | 19 | 4 | 19 | 13 | |||||
2193 | 2193 | -73.9569318105253 | 40.7973442139041 | 40C-PM-1006-07 | 40C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9569318105253 40.7973442139041) | 19 | 4 | 19 | 13 | ||||||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
2267 | 2267 | -73.9727926335397 | 40.77037055775 | 7F-AM-1008-07 | 07F | AM | 10082018 | 7 | Adult | Gray | Gray+ | Above Ground | 28 | next to the hole of #6 | false | false | false | false | false | standing | false | false | false | false | false | false | true | false | POINT (-73.9727926335397 40.77037055775) | 19 | 4 | 19 | 13 | ||||
2292 | 2292 | -73.9669891940463 | 40.7835635162331 | 22C-PM-1006-07 | 22C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9669891940463 40.7835635162331) | 19 | 4 | 19 | 13 | ||||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | together w/ #8 | false | false | false | true | false | false | true | false | POINT (-73.9787771053108 40.76935621227501) | 19 | 4 | 19 | 13 | |||||
2311 | 2311 | -73.9680171894351 | 40.7724644426313 | 11I-PM-1012-07 | 11I | PM | 10122018 | 7 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | burying its food into the ground | false | false | false | false | false | false | false | false | POINT (-73.96801718943512 40.7724644426313) | 19 | 4 | 19 | 13 | |||||
2339 | 2339 | -73.9695117797648 | 40.7802675743233 | 18C-PM-1018-07 | 18C | PM | 10182018 | 7 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9695117797648 40.780267574323304) | 19 | 4 | 19 | 13 | |||||||
2362 | 2362 | -73.9700263936574 | 40.7699335098581 | 7H-PM-1006-07 | 07H | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 15 | false | true | true | false | false | playing w/ #6 | false | false | false | false | false | false | true | false | POINT (-73.9700263936574 40.7699335098581) | 19 | 4 | 19 | 13 | |||||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | lying down | false | false | false | false | false | false | true | false | POINT (-73.9777206733344 40.7668595585487) | 19 | 4 | 19 | 13 | |||||
2567 | 2567 | -73.9690241805398 | 40.7837967580773 | 21B-AM-1019-07 | 21B | AM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9690241805398 40.7837967580773) | 19 | 4 | 19 | 13 | ||||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2780 | 2780 | -73.9700634278 | 40.7784223722453 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700634278 40.7784223722453) | 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 );