2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Age = "Juvenile", Hectare Squirrel Number = 3 and Running = 1 sorted by Running

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Tail twitches, Approaches, Indifferent, Runs from

Running

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
53 -73.95849706432129 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9584970643213 40.7982886348696)
222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 chilling 0 0 0 0 0 0 1 0 observed POINT (-73.96337601736352 40.7818422357619)
598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9698196671161 40.7802972001469)
888 -73.9674177504573 40.7769569731993 15G-PM-1019-03 15G PM 10192018 3 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674177504573 40.7769569731993)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1932 -73.96169725573041 40.7953872829374 36A-PM-1013-03 36A PM 10132018 3 Juvenile Cinnamon   Cinnamon+ COULD HAVE BEEN CHIPPY, DEEP BROWN Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9616972557304 40.7953872829374)
1985 -73.9530791622513 40.79598856039671 40G-PM-1013-03 40G PM 10132018 3 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9530791622513 40.7959885603967)
2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)
2465 -73.9686999860219 40.784401473513604 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686999860219 40.7844014735136)

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