2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Eating = 1, Hectare Squirrel Number = 2 and Highlight Fur Color = "White" sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Tail twitches, Indifferent

Runs from ✖

  • 0 15
  • 1 2

Highlight Fur Color ✖

  • White · 17 ✖

Hectare Squirrel Number ✖

Eating ✖

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
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
199 199 -73.97716146866159 40.770967798324705 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9771614686616 40.7709677983247)
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96423978295472 40.7918992406575)
756 756 -73.9773079154219 40.7696506688861 4C-AM-1006-02 04C AM 10062018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9773079154219 40.7696506688861)
1085 1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722265046794 40.7700916895929)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9716271494641 40.7796462634184)
1203 1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9616999731028 40.7954126939561)
1439 1439 -73.9729645190377 40.7723310150843 9E-AM-1008-02 09E AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729645190377 40.7723310150843)
1482 1482 -73.95886101956991 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9588610195699 40.7945269936639)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2231 2231 -73.95454276114769 40.793035381744104 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9545427611477 40.7930353817441)
2352 2352 -73.9727310397798 40.778701677351705 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree 0 0 1 1 1 digging,chewing on tree—has nut in mouth! 0 0 0 0 0 0 0 1   POINT (-73.97273103977982 40.7787016773517)
2398 2398 -73.95871384837301 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.958713848373 40.7963918051751)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.79830691185791)

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