2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Date = 10172018, Eating = 1 and Hectare Squirrel Number = 3 sorted by Chasing

View and edit SQL

Suggested facets: Shift, 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, Indifferent, 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
105 -73.9589249555235 40.7908193284981 32E-PM-1017-03 32E PM 10172018 3 Adult Gray   Gray+   Above Ground 2 bottom of tree 0 0 0 1 0 still 0 0 0 0 0 0 1 0   POINT (-73.9589249555235 40.7908193284981)
461 -73.96481954331921 40.7796399955868 19G-PM-1017-03 19G PM 10172018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 1 1 0 staring 0 0 0 0 1 0 0 0   POINT (-73.9648195433192 40.7796399955868)
723 -73.9654397484763 40.7798863522904 19F-PM-1017-03 19F PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9654397484763 40.7798863522904)
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
900 -73.9626527908786 40.7912472380247 31B-AM-1017-03 31B AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9626527908786 40.7912472380247)
1191 -73.9634835346077 40.7918244310746 31A-PM-1017-03 31A PM 10172018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9634835346077 40.7918244310746)
1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
2083 -73.9702382274798 40.7721754848905 10G-PM-1017-03 10G PM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9702382274798 40.7721754848905)
2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)

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