2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Eating = 1, Hectare Squirrel Number = 10 and Indifferent = 0 sorted by Quaas

View and edit SQL

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

Hectare Squirrel Number

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
376 -73.9698817079185 40.775832262771104 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9698817079185 40.7758322627711)
463 -73.95921030643271 40.7904390691553 32E-PM-1017-10 32E PM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9592103064327 40.7904390691553)
572 -73.97636222692721 40.7704671295941 5C-PM-1010-10 05C PM 10102018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0 fed by woman POINT (-73.9763622269272 40.7704671295941)
669 -73.98020792598659 40.7678723471007 1B-AM-1012-10 01B AM 10122018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9802079259866 40.7678723471007)
1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
2215 -73.96749788267509 40.776288410765 15G-PM-1019-10 15G PM 10192018 10 Adult Gray   Gray+   Above Ground 1 on a log 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9674978826751 40.776288410765)
2288 -73.9577009571427 40.796126044520996 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 1 climbing (down from ~10') 0 0 0 0 0 0 0 1   POINT (-73.9577009571427 40.796126044521)

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 167.881ms