2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Above Ground Sighter Measurement = 20, Hectare Squirrel Number = 1 and Shift = "AM" sorted by Climbing

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Chasing, Climbing, Eating, Kuks, Moans, Approaches, Indifferent, Runs from

Shift

Hectare Squirrel Number

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
1239 -73.9725897240269 40.7691342079294 6G-AM-1008-01 06G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 in tree 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9725897240269 40.7691342079294)
1431 -73.9601918930677 40.7944134683406 35C-AM-1007-01 35C AM 10072018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20 (white oak) 0 0 0 0 0 sitting still 0 0 0 0 0 0 0 0   POINT (-73.9601918930677 40.7944134683406)
917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   0 0 1 0 0   0 0 0 0 0 1 0 0 started climbing down to me POINT (-73.9676514056678 40.7730853732876)
1010 -73.9689723590015 40.7756860990338 13F-AM-1007-01 13F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689723590015 40.7756860990338)
1351 -73.9610985171525 40.7913867116989 32D-AM-1013-01 32D AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610985171525 40.7913867116989)
1512 -73.97338823645741 40.768307870659704 5G-AM-1006-01 05G AM 10062018 1 Adult Gray Black Gray+Black   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0 made eye contact with me POINT (-73.9733882364574 40.7683078706597)
1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9587072763996 40.7850256219415)
2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 1 0   1 0 0 0 0 0 1 0   POINT (-73.955352152771 40.7988549523022)
2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree 0 0 1 0 0 chased by a doggo 0 0 1 0 0 0 0 1 runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)
2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)

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