This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Foraging, Kuks, Tail twitches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
258 | 258 | -73.9534333425633 | 40.7932564163328 | 37H-AM-1018-03 | 37H | AM | 10182018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree with red berries | false | false | false | true | false | false | true | false | false | false | false | false | true | POINT (-73.9534333425633 40.7932564163328) | 19 | 4 | 19 | 13 | ||||
453 | 453 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | false | false | false | true | true | false | true | false | false | false | false | true | false | POINT (-73.959514034869 40.789911786416) | 19 | 4 | 19 | 13 | ||||
1108 | 1108 | -73.9638397790384 | 40.7828950272904 | 23F-PM-1013-02 | 23F | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | true | false | false | true | false | true | false | indifferent (mostly,did notice me,busy eating,foraging) | POINT (-73.9638397790384 40.7828950272904) | 19 | 4 | 19 | 13 | ||||
1789 | 1789 | -73.9596271142953 | 40.7906612313673 | 32E-PM-1017-12 | 32E | PM | 10172018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | true | false | false | false | false | false | false | POINT (-73.9596271142953 40.7906612313673) | 19 | 4 | 19 | 13 | ||||||
1936 | 1936 | -73.9667911565238 | 40.779321901098 | 18F-AM-1014-02 | 18F | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | In small tree by water | false | false | false | true | true | false | true | false | false | false | false | true | false | POINT (-73.9667911565238 40.77932190109801) | 19 | 4 | 19 | 13 | |||||
1971 | 1971 | -73.9591880400132 | 40.7950071252836 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | true | true | false | false | true | false | true | false | POINT (-73.95918804001322 40.7950071252836) | 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 );