2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Above Ground Sighter Measurement = 2, Foraging = 1 and Running = 0 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Climbing, Eating, Tail twitches, Indifferent, Runs from

Running

Foraging

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
1696 -73.96945916677049 40.776651822199796 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694591667705 40.7766518221998)
1729 -73.97650461090191 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765046109019 40.7736674124746)
1828 -73.9682965197661 40.780537896388296 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9682965197661 40.7805378963883)
2419 -73.9590551473416 40.7891607060794 31F-PM-1007-02 31F PM 10072018 2 Adult Gray   Gray+   Above Ground 2 tree trunk 0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.95905514734162 40.7891607060794)
2265 -73.97052601032391 40.782633368659894 19A-PM-1013-04 19A PM 10132018 4 Adult Gray Black, White Gray+Black, White Also looks quite brown - minimal body highlight coloring - black edges Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705260103239 40.78263336865991)
1777 -73.9711751356843 40.775242275820204 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711751356843 40.7752422758202)
1875 -73.9527430510248 40.792480795055205 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9527430510248 40.7924807950552)
2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9759432151552 40.7733240612552)

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