2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Above Ground Sighter Measurement = 40 and Indifferent = 1 sorted by Primary Fur Color

View and edit SQL

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

Hectare Squirrel Number

Indifferent

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
670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602398690946 40.7910157676119)
728 -73.96029131055779 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602913105578 40.7910635810038)
1630 -73.9710025484537 40.7792529489016 16C-AM-1014-01 16C AM 10142018 1 Juvenile Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9710025484537 40.7792529489016)
1715 -73.97457091090558 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   1 0 1 0 0 in tree 0 0 0 0 0 0 1 0   POINT (-73.9745709109056 40.7672225695415)
1998 -73.9595686513629 40.7906859748696 32E-AM-1007-06 32E AM 10072018 6 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9595686513629 40.7906859748696)
2136 -73.97218979152109 40.7660434203132 3I-AM-1010-02 03I AM 10102018 2 Adult Gray   Gray+   Above Ground 40   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9721897915211 40.76604342031321)
2356 -73.9611355303487 40.793069353224 34C-AM-1007-02 34C AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611355303487 40.793069353224)
2452 -73.9727323797981 40.766903546395504 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727323797981 40.7669035463955)
2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9593624259363 40.7905522356793)

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