2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Hectare = "02B" and Tail twitches = 0 sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

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

Highlight Fur Color ✖

Tail twitches ✖

Hectare ✖

  • 02B · 17 ✖
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
893 893 -73.9799311173259 40.768557699755895 2B-AM-1010-03 02B AM 10102018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9799311173259 40.7685576997559)
2165 2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9794371709817 40.768387910254)
1855 1855 -73.9791826197108 40.768577844752 2B-AM-1010-08 02B AM 10102018 8 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9791826197108 40.768577844752)
866 866 -73.9792091200122 40.7685845475313 2B-PM-1013-06 02B PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 sat there! in front of us POINT (-73.9792091200122 40.7685845475313)
910 910 -73.9796383715206 40.7682477738244 2B-AM-1010-07 02B AM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9796383715206 40.7682477738244)
1195 1195 -73.9801698909399 40.7683721553321 2B-AM-1010-04 02B AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9801698909399 40.7683721553321)
2038 2038 -73.98035621370491 40.7685780990634 2B-AM-1010-02 02B AM 10102018 2 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9803562137049 40.7685780990634)
2894 2894 -73.979734151564 40.7682150214703 2B-AM-1010-06 02B AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.979734151564 40.7682150214703)
1722 1722 -73.98025646852649 40.768175909819895 2B-AM-1010-05 02B AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9802564685265 40.7681759098199)
51 51 -73.9801666435401 40.7686905339212 2B-PM-1013-01 02B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0 running (with nut) 0 0 0 0 0 0 0 0   POINT (-73.9801666435401 40.7686905339212)
1587 1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0 climbing fence! 0 0 0 0 0 0 0 0 snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)
1915 1915 -73.9797112925048 40.76880467784721 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9797112925048 40.7688046778472)
2042 2042 -73.9800896621713 40.7684379810317 2B-PM-1013-03 02B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9800896621713 40.7684379810317)
2116 2116 -73.9801562527339 40.76872673271129 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801562527339 40.7687267327113)
2212 2212 -73.9801138983722 40.768572151563504 2B-PM-1013-02 02B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9801138983722 40.7685721515635)
2349 2349 -73.98003374000399 40.768360829233295 2B-PM-1013-04 02B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.980033740004 40.7683608292333)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)

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