2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Climbing = 1, Foraging = 1 and Hectare Squirrel Number = 5 sorted by Indifferent

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, Eating, Tail flags, Indifferent

Specific Location

Tail twitches

Moans

  • 0 10

Hectare Squirrel Number

Climbing

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
1487 -73.96539465596099 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1 burying the food on ground 0 0 0 0 0 0 0 0 look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)
1568 -73.96810798698209 40.772349408134495 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681079869821 40.7723494081345)
261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552861155228 40.788973931872)
908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   0 0 1 0 1   0 0 0 0 0 0 1 0 nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)
2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9596251284566 40.7916254797561)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)

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