2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Date = 10132018 and Hectare Squirrel Number = 6 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Highlight Fur Color ✖

Hectare Squirrel Number ✖

Date ✖

  • 10132018 · 19 ✖
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
1520 1520 -73.968021326951 40.7778807692445 16F-PM-1013-06 16F PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Big rock in meadow 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.968021326951 40.7778807692445)
1699 1699 -73.9706968708903 40.7821499135828 19A-PM-1013-06 19A PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9706968708903 40.7821499135828)
2855 2855 -73.9690832219322 40.782343340985996 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.96908322193221 40.782343340986)
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552035011902 40.7889851896334)
79 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)
1082 1082 -73.96174906802979 40.792153784924395 32C-PM-1013-06 32C PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9617490680298 40.7921537849244)
2357 2357 -73.96323010348829 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9632301034883 40.7925707244111)
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9589475065438 40.7934846881536)
1114 1114 -73.9596505138955 40.794036773498796 35C-PM-1013-06 35C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9596505138955 40.7940367734988)
400 400 -73.9590502257662 40.794290363687 36C-PM-1013-06 36C PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE Running across wide street 1 0 0 0 1 carrying food in mouth 0 0 0 0 0 0 0 0   POINT (-73.9590502257662 40.794290363687)
83 83 -73.9617088749928 40.7944585082367 35A-PM-1013-06 35A PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9617088749928 40.7944585082367)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
2434 2434 -73.9545912098958 40.7948301813102 38F-PM-1013-06 38F PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9545912098958 40.7948301813102)
31 31 -73.9540054100539 40.795244599983604 39G-PM-1013-06 39G PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9540054100539 40.7952445999836)
814 814 -73.9607608482656 40.7954687648248 36A-PM-1013-06 36A PM 10132018 6   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9607608482656 40.7954687648248)
701 701 -73.95292302079079 40.7960663442573 40G-PM-1013-06 40G PM 10132018 6 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9529230207908 40.7960663442573)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
2242 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)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)

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