2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Above Ground Sighter Measurement = 10 and Date = 10132018 sorted by Location

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Foraging, Kuks, Indifferent, Runs from

Tail twitches

  • 0 11

Date

  • 10132018 · 11

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
291 -73.9679661308374 40.7837388390673 22C-AM-1013-01 22C AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 sitting still,tail over back 0 0 0 0 0 0 0 0   POINT (-73.9679661308374 40.7837388390673)
646 -73.954092292214 40.7979800395433 41E-PM-1013-05 41E PM 10132018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.954092292214 40.7979800395433)
1103 -73.9541500874008 40.7920329989756 35H-AM-1013-02 35H AM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 Sitting on tree limb 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0 watching me from tree,but calm POINT (-73.9541500874008 40.7920329989756)
1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9604083891356 40.7910284106931)
1747 -73.96657637976071 40.7761316400012 15H-AM-1013-03 15H AM 10132018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665763797607 40.7761316400012)
1938 -73.9719879697272 40.7725625124591 9F-AM-1013-02 09F AM 10132018 2 Adult Black   Black+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9719879697272 40.7725625124591)
2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.960898739757 40.7961393097144)
2224 -73.9662310606968 40.7747758221226 14I-AM-1013-01 14I AM 10132018 1 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9662310606968 40.7747758221226)
2366 -73.96761918469849 40.777641740816996 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9676191846985 40.777641740817)
2421 -73.96822789059891 40.773302750805705 11H-PM-1013-02 11H PM 10132018 2 Adult Gray Black Gray+Black   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 1 0   POINT (-73.9682278905989 40.7733027508057)
2693 -73.95614986460359 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks 0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9561498646036 40.79492885618931)

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