2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Above Ground Sighter Measurement = 3 and Hectare Squirrel Number = 4 sorted by Runs from

View and edit SQL

Suggested facets: Shift, Date, Combination of Primary and Highlight Color, Climbing, Eating, Foraging, Tail twitches, Indifferent, Runs from

Chasing

Hectare Squirrel Number

Above Ground Sighter Measurement

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
849 -73.9736165917399 40.772454390149704 8D-AM-1007-04 08D AM 10072018 4 Adult Gray   Gray+   Above Ground 3   0 1 0 0 0 chasing squirrel #3 0 0 0 0 0 0 0 0   POINT (-73.9736165917399 40.7724543901497)
1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632265832593 40.78169144754611)
2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk 0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9766342759486 40.7687518380873)
1053 -73.96858597054859 40.784880506532204 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685859705486 40.7848805065322)
2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657487923637 40.7786823090663)

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