2018_Central_Park_Squirrel_Census_-_Squirrel_Data

15 rows where Approaches = 1, Hectare Squirrel Number = 3 and Shift = "PM" sorted by Tail flags

View and edit SQL

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

Shift

Hectare Squirrel Number

Approaches

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
266 -73.97864810094991 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786481009499 40.7697372811949)
651 -73.9801661903932 40.7697950141751 3A-PM-1017-03 03A PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9801661903932 40.7697950141751)
723 -73.9654397484763 40.7798863522904 19F-PM-1017-03 19F PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9654397484763 40.7798863522904)
1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 1   POINT (-73.9521514669041 40.7949515182825)
1137 -73.9520280004414 40.7946345014466 39I-PM-1013-03 39I PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 1 0 0   POINT (-73.9520280004414 40.7946345014466)
1289 -73.97246812695259 40.7743474675821 11D-PM-1006-03 11D PM 10062018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9724681269526 40.7743474675821)
1392 -73.96480906981759 40.7903882097837 29A-PM-1019-03 29A PM 10192018 3 Juvenile Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 1 ran from,but now approaching. kind of weirding me out. POINT (-73.9648090698176 40.7903882097837)
1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0 followed man across bridge POINT (-73.9655670884957 40.7763728890554)
1672 -73.9640989602986 40.789929543926505 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9640989602986 40.7899295439265)
2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees 0 0 0 1 1   0 0 0 0 0 1 0 0 also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)
2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass 0 0 0 1 0 eating (nuts) 0 0 0 0 0 1 0 0 approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)
2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)
2428 -73.9755643404768 40.769756914938796 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9755643404768 40.7697569149388)
2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)

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