2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Eating = 1 and Hectare = "03B" sorted by Primary Fur Color

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail twitches, Runs from

Hectare Squirrel Number

Hectare

Eating

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
2141 -73.97870151846621 40.7690114585688 3B-PM-1007-06 03B PM 10072018 6 Juvenile     +         0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9787015184662 40.7690114585688)
997 -73.9790896775237 40.7688048644871 3B-AM-1010-10 03B AM 10102018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9790896775237 40.7688048644871)
407 -73.9787658435198 40.768941976539296 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 eating loudly <- peanuts w/ shells 0 0 0 0 0 0 1 0   POINT (-73.9787658435198 40.7689419765393)
741 -73.9790214253443 40.7686791169776 3B-PM-1007-10 03B PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 hopping 0 0 0 0 0 0 1 0   POINT (-73.9790214253443 40.7686791169776)
1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9795585338537 40.768895893226)
2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2859 -73.9786940945874 40.769082027688796 3B-PM-1007-05 03B PM 10072018 5 Juvenile Gray   Gray+   Above Ground 6 on rock 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9786940945874 40.7690820276888)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 133.534ms