2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Date = 10132018, Eating = 1 and Hectare Squirrel Number = 2 sorted by Shift

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Eating ✖

Date ✖

  • 10132018 · 16 ✖
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
346 346 -73.9712971568288 40.7745520717065 11E-AM-1013-02 11E AM 10132018 2 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9712971568288 40.7745520717065)
2263 2263 -73.95693753558841 40.793539800861204 36E-AM-1013-02 36E AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9569375355884 40.7935398008612)
409 409 -73.9530809650496 40.7959176317705 40G-PM-1013-02 40G PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0 hiding from dog 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9530809650496 40.79591763177051)
519 519 -73.96590102384171 40.7791683666215 18G-PM-1013-02 18G PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9659010238417 40.779168366621505)
779 779 -73.9745305540008 40.7742043234014 10C-PM-1013-02 10C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9745305540008 40.7742043234014)
1108 1108 -73.96383977903841 40.782895027290394 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 1 0 0 1 0 1 0 indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9735655529245 40.7716072681474)
1480 1480 -73.96285255338309 40.793844934501706 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 eating upside down on tree trunk 0 0 0 0 0 0 0 0   POINT (-73.9628525533831 40.7938449345017)
1504 1504 -73.97065861080058 40.779635744447106 17C-PM-1013-02 17C PM 10132018 2 Adult Gray   Gray+   Above Ground 20 in a tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9706586108006 40.7796357444471)
1552 1552 -73.9695655231393 40.769832465951296 8I-PM-1013-02 08I PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695655231393 40.7698324659513)
1677 1677 -73.9594332600733 40.7960622445291 37B-PM-1013-02 37B PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9594332600733 40.7960622445291)
1971 1971 -73.9591880400132 40.795007125283604 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   1 1 0 0 1 0 1 0   POINT (-73.95918804001322 40.7950071252836)
2093 2093 -73.9597994674082 40.797298837759 38A-PM-1013-02 38A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9597994674082 40.797298837759)
2606 2606 -73.96143417385001 40.794546426211205 35B-PM-1013-02 35B PM 10132018 2 Juvenile     +   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 0 1 0 1 0   POINT (-73.96143417385 40.7945464262112)
2683 2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree 0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.972179947936 40.7810042827198)
2915 2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9734630412566 40.7653097139415)

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