2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Above Ground Sighter Measurement = 7 and Hectare Squirrel Number = 1 sorted by Primary Fur Color

View and edit SQL

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

Age

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
112 -73.96517544644391 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651754464439 40.7755181941559)
243 -73.9754778808471 40.7685619029765 4E-AM-1020-01 04E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 0 0 sitting very still 0 0 0 0 0 0 1 0   POINT (-73.9754778808471 40.7685619029765)
286 -73.97209073846129 40.7762987836055 13C-PM-1019-01 13C PM 10192018 1 Adult Gray   Gray+   Above Ground 7   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9720907384613 40.7762987836055)
984 -73.9672950266018 40.7782477517567 17F-PM-1020-01 17F PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9672950266018 40.7782477517567)
1178 -73.9507772992986 40.7949188960194 40I-PM-1013-01 40I PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 0 1 0 eating (berries) 0 0 0 0 0 0 1 0   POINT (-73.9507772992986 40.7949188960194)
1413 -73.98100322064279 40.768162563497896 1A-AM-1007-01 01A AM 10072018 1 Adult Gray White Gray+White   Above Ground 7   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9810032206428 40.7681625634979)
1737 -73.9640741640547 40.7807274581426 20G-AM-1018-01 20G AM 10182018 1 Juvenile Gray   Gray+   Above Ground 7 Tree limb 0 0 0 0 0 sitting still on limb 0 0 0 0 0 0 1 0   POINT (-73.9640741640547 40.7807274581426)
3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)

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