2018_Central_Park_Squirrel_Census_-_Squirrel_Data

14 rows where Foraging = 1, Hectare Squirrel Number = 6 and Tail twitches = 1

View and edit SQL

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

Tail twitches

Moans

  • 0 14

Hectare Squirrel Number

Foraging

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
67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.968381325559 40.7780143443779)
79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 1 1 eating (a mushroom),circles around us,really fat,scratching himself,grooming activity 0 0 0 0 1 1 0 0   POINT (-73.9610705592868 40.7914829661051)
165 -73.969058856545 40.776635622697896 14F-PM-1012-06 14F PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.969058856545 40.7766356226979)
217 -73.9712327308512 40.7748702909218 12E-PM-1018-06 12E PM 10182018 6 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9712327308512 40.7748702909218)
607 -73.9547711796823 40.7908540751983 34I-PM-1010-06 34I PM 10102018 6 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9547711796823 40.7908540751983)
740 -73.95834778506341 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9583477850634 40.7914073632782)
1498 -73.9765064169087 40.7737211426714 8B-AM-1007-06 08B AM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9765064169087 40.7737211426714)
1769 -73.9721086069437 40.7698172190404 6G-AM-1008-06 06G AM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White white at end of tail Ground Plane FALSE grass 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9721086069437 40.7698172190404)
2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2314 -73.9663961415789 40.7750691120996 14H-PM-1012-06 14H PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary with a note that it was "hard to tell". Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9663961415789 40.7750691120996)
2358 -73.9788379085607 40.7683896583055 2C-PM-1013-06 02C PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 cleaning face & tail 0 0 0 0 1 1 0 0   POINT (-73.9788379085607 40.7683896583055)
2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9690638424196 40.7713869295685)
2529 -73.98002714878629 40.7702554167042 4A-PM-1007-06 04A PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE A rock 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9800271487863 40.7702554167042)
2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)

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