2018_Central_Park_Squirrel_Census_-_Squirrel_Data

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

View and edit SQL

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

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
1357 -73.96313500206341 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9631350020634 40.791907210332)
2609 -73.95968653180941 40.7893787188526 31F-AM-1013-01 31F AM 10132018 1 Adult Gray Black Gray+Black   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9596865318094 40.7893787188526)
942 -73.9533923917973 40.796170187476896 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9533923917973 40.7961701874769)
1609 -73.96390249881229 40.777695306584896 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639024988123 40.7776953065849)
45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
102 -73.95759861613641 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree 0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 0 1   POINT (-73.9575986161364 40.799368134968)
1315 -73.9595955824812 40.793304794353396 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   0 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9595955824812 40.7933047943534)
2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)

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