2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Eating = 1, Hectare Squirrel Number = 6, Indifferent = 1 and Location = "Above Ground" sorted by Other Activities

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Chasing, Climbing, Foraging

Location

  • Above Ground · 7

Indifferent

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
44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970252675331 40.77059995882221)
344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9759432151552 40.7733240612552)
1161 -73.9694066600156 40.7805662180672 18C-PM-1018-06 18C PM 10182018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694066600156 40.7805662180672)
1777 -73.9711751356843 40.775242275820204 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711751356843 40.7752422758202)
1943 -73.9690447463294 40.783913304529 21B-AM-1019-06 21B AM 10192018 6 Juvenile Gray   Gray+   Above Ground 7   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9690447463294 40.78391330452901)
2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9657040391563 40.7755567428199)
2323 -73.9715921982161 40.7746153066601 11E-PM-1012-06 11E PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 5   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9715921982161 40.7746153066601)

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