2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Hectare = "04E" sorted by Climbing

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Tail twitches, Indifferent, Runs from

Date

Climbing

Hectare

  • 04E · 12
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
645 -73.9758152322587 40.76923774014671 4E-PM-1008-03 04E PM 10082018 3 Adult Gray   Gray+         0 1 0 0 0 chasing #4 0 0 0 0 0 0 0 0   POINT (-73.9758152322587 40.7692377401467)
1687 -73.97547909645608 40.768336388516005 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9754790964561 40.768336388516)
1702 -73.9752699507508 40.7688069184057 4E-PM-1008-02 04E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9752699507508 40.76880691840571)
1711 -73.975836799137 40.7691593428471 4E-PM-1008-05 04E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.975836799137 40.769159342847104)
1878 -73.9761223919286 40.7685998275864 4E-PM-1008-06 04E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9761223919286 40.7685998275864)
1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9753291616796 40.7687376032936)
2291 -73.9756894776708 40.768163821821204 4E-AM-1020-03 04E AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756894776708 40.7681638218212)
2560 -73.97554590905341 40.7680866624003 4E-AM-1020-04 04E AM 10202018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 0 chillin' 0 0 0 0 0 0 0 1   POINT (-73.9755459090534 40.7680866624003)
235 -73.97535742799359 40.768321169425704 4E-PM-1008-08 04E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9753574279936 40.7683211694257)
243 -73.9754778808471 40.7685619029765 4E-AM-1020-01 04E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 0 0 sitting very still 0 0 0 0 0 0 1 0   POINT (-73.9754778808471 40.7685619029765)
336 -73.97574132156208 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9757413215621 40.7692582758978)
1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)

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