2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Hectare Squirrel Number = 1, Indifferent = 0 and Primary Fur Color = "Black" sorted by Age

View and edit SQL

Suggested facets: Shift, Date, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail flags, Tail twitches, Runs from

Eating

Primary Fur Color

  • Black · 10

Indifferent

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
210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
872 -73.9551524422379 40.7910535596756 34H-PM-1006-01 34H PM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9551524422379 40.7910535596756)
1101 -73.95912925497 40.7925530280455 34D-AM-1008-01 34D AM 10082018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 staring at us POINT (-73.95912925497001 40.7925530280455)
1261 -73.9719109949232 40.772313852132704 9F-AM-1013-01 09F AM 10132018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9719109949232 40.7723138521327)
1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
2150 -73.9557710118271 40.791916118555704 34G-PM-1006-01 34G PM 10062018 1 Adult Black   Black+ Skinny, thin tail Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9557710118271 40.7919161185557)
2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
2469 -73.9600963639087 40.7934962325313 34C-AM-1007-01 34C AM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1 dog POINT (-73.9600963639087 40.7934962325313)
2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 1   POINT (-73.959412243507 40.7917871123534)

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