2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Hectare Squirrel Number = 1 and Primary Fur Color = "Black" sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

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

Primary Fur Color ✖

  • Black · 19 ✖

Hectare Squirrel Number ✖

Age ✖

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
746 746 -73.9591407691 40.796084690312206 37B-AM-1018-01 37B AM 10182018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9591407691 40.7960846903122)
1101 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)
1193 1193 -73.9731880656287 40.766002618615495 2H-AM-1006-01 02H AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731880656287 40.7660026186155)
1261 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)
2351 2351 -73.97458184501092 40.765449887362706 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9745818450109 40.7654498873627)
2469 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)
2755 2755 -73.9712022111028 40.767250436826295 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9712022111028 40.7672504368263)
2768 2768 -73.96410881726321 40.7886555184212 28C-AM-1014-01 28C AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9641088172632 40.7886555184212)
2773 2773 -73.96259326649559 40.7885379477349 29D-AM-1014-01 29D AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9625932664956 40.7885379477349)
2975 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)
182 182 -73.9691050656013 40.780813953822204 18C-PM-1018-01 18C PM 10182018 1   Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9691050656013 40.7808139538222)
210 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 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 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)
1307 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 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 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)
2549 2549 -73.972248505758 40.76590436930079 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.972248505758 40.765904369300806)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)

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