2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Above Ground Sighter Measurement = 2, Eating = 1 and Indifferent = 1 sorted by Other Activities descending

View and edit SQL

Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Climbing, Foraging, Tail twitches

Hectare Squirrel Number

Indifferent

Eating

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
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)
299 -73.9586214081667 40.7937473968735 35D-PM-1013-03 35D PM 10132018 3 Juvenile Gray White Gray+White No Tail! Above Ground 2 bench 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9586214081667 40.7937473968735)
339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.96550957640301 40.7752456763263)
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)
1696 -73.96945916677049 40.776651822199796 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694591667705 40.7766518221998)
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)
2265 -73.97052601032391 40.782633368659894 19A-PM-1013-04 19A PM 10132018 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705260103239 40.78263336865991)
2706 -73.9745141185576 40.76914797812071 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9745141185576 40.7691479781207)

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