This data as json, CSV (advanced)
Suggested facets: Unique Squirrel ID, Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | -73.9584970643213 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9584970643213 40.7982886348696) | 19 | 4 | 19 | 13 | |||||
170 | 170 | -73.9597205966324 | 40.7969409510133 | 38B-AM-1019-01 | 38B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9597205966324 40.7969409510133) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.958535640774 40.7982737896998) | 19 | 4 | 19 | 13 | |||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
365 | 365 | -73.9576035072364 | 40.7966120824816 | 38C-AM-1019-01 | 38C | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (lawnmower) | POINT (-73.9576035072364 40.7966120824816) | 19 | 4 | 19 | 13 | ||||
737 | 737 | -73.9711176999471 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711176999471 40.7724278547281) | 19 | 4 | 19 | 13 | ||||
846 | 846 | -73.9582643954055 | 40.8000460061272 | 42A-AM-1019-01 | 42A | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.95826439540551 40.8000460061272) | 19 | 4 | 19 | 13 | |||||
855 | 855 | -73.9808247660048 | 40.7689408831287 | 2A-PM-1019-01 | 02A | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | runs from | false | false | false | true | false | false | false | true | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
1184 | 1184 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9807982742225 40.7678795985389) | 19 | 4 | 19 | 13 | |||||
1185 | 1185 | -73.958230674366 | 40.7989268396525 | 40B-AM-1019-08 | 40B | AM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | true | POINT (-73.958230674366 40.7989268396525) | 19 | 4 | 19 | 13 | |||||
1411 | 1411 | -73.9802840031759 | 40.7678599069819 | 1B-PM-1019-04 | 01B | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9802840031759 40.7678599069819) | 19 | 4 | 19 | 13 | ||||
1540 | 1540 | -73.957710975899 | 40.7984055614047 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.957710975899 40.7984055614047) | 19 | 4 | 19 | 13 | |||||
1758 | 1758 | -73.9581241870185 | 40.7961057536141 | 38C-AM-1019-05 | 38C | AM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9581241870185 40.7961057536141) | 19 | 4 | 19 | 13 | |||||
1759 | 1759 | -73.9576219570858 | 40.7963351225672 | 38C-AM-1019-03 | 38C | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9576219570858 40.7963351225672) | 19 | 4 | 19 | 13 | |||||
1801 | 1801 | -73.9587072373474 | 40.7985209579925 | 40B-AM-1019-01 | 40B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9587072373474 40.7985209579925) | 19 | 4 | 19 | 13 | |||||
1956 | 1956 | -73.980897497712 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
1986 | 1986 | -73.958247706428 | 40.7989079136796 | 40B-AM-1019-07 | 40B | AM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.958247706428 40.7989079136796) | 19 | 4 | 19 | 13 | |||||
2117 | 2117 | -73.9597192455543 | 40.7973316178661 | 38A-AM-1019-03 | 38A | AM | 10192018 | 3 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | false | false | false | false | true | stood on back legs | false | false | false | false | false | true | true | true | POINT (-73.9597192455543 40.7973316178661) | 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 | |||||
2168 | 2168 | -73.9582363437135 | 40.7987752300505 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9582363437135 40.7987752300505) | 19 | 4 | 19 | 13 | |||||
2283 | 2283 | -73.9628982772673 | 40.7884304803386 | 28D-PM-1019-01 | 28D | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9628982772673 40.7884304803386) | 19 | 4 | 19 | 13 | |||||
2412 | 2412 | -73.9809446489564 | 40.7685032165879 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
2657 | 2657 | -73.9582150734453 | 40.7962862794303 | 38C-AM-1019-08 | 38C | AM | 10192018 | 8 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | false | false | true | false | POINT (-73.9582150734453 40.7962862794303) | 19 | 4 | 19 | 13 | |||||
2684 | 2684 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
2688 | 2688 | -73.9799302952205 | 40.7677207209798 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
2865 | 2865 | -73.9802842404016 | 40.7678257384977 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.98028424040162 40.7678257384977) | 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 );