2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Highlight Fur Color = "White" and Specific Location = "tree" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Indifferent, Runs from

Tail twitches

Specific Location

  • tree · 8

Highlight Fur Color

  • White · 8
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
189 -73.9735489537928 40.76812579115229 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree 0 0 0 0 0 sitting in tree 0 0 0 0 0 0 1 0   POINT (-73.9735489537928 40.7681257911523)
440 -73.9642717435966 40.782087049693 22F-AM-1007-05 22F AM 10072018 5 Adult Gray White Gray+White   Above Ground 10 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9642717435966 40.782087049693)
856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.95916671628011 40.7937602121568)
1745 -73.9688438058715 40.7703014325728 8I-AM-1006-05 08I AM 10062018 5 Adult Gray White Gray+White   Above Ground 20 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9688438058715 40.7703014325728)
2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree 0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.975198284551 40.7740343763399)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2352 -73.9727310397798 40.778701677351705 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree 0 0 1 1 1 digging,chewing on tree—has nut in mouth! 0 0 0 0 0 0 0 1   POINT (-73.97273103977982 40.7787016773517)
2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)

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