2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Other Activities = "burying" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

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

Hectare Squirrel Number ✖

Other Activities ✖

  • burying · 12 ✖
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
830 830 -73.95956459625391 40.7899599350145 31E-PM-1006-03 31E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes 0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9595645962539 40.7899599350145)
1399 1399 -73.970442878377 40.7763755560359 14E-AM-1008-22 14E AM 10082018 22 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.970442878377 40.7763755560359)
2665 2665 -73.969784066769 40.77669404054029 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0 curious POINT (-73.969784066769 40.7766940405403)
2775 2775 -73.96971093983021 40.7776218260789 15E-PM-1008-06 15E PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9697109398302 40.7776218260789)
2474 2474 -73.97214488797658 40.7762112840981 13C-AM-1010-02 13C AM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   0 0 1 0 0 burying 0 0 0 0 0 0 1 0   POINT (-73.9721448879766 40.7762112840981)
760 760 -73.97182341595571 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 1 burying 0 0 0 1 0 0 0 1   POINT (-73.9718234159557 40.7810842503715)
143 143 -73.9661361310677 40.7787872561177 18G-PM-1013-01 18G PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 0 1   POINT (-73.9661361310677 40.7787872561177)
228 228 -73.97286607796221 40.7753294525644 12C-AM-1013-03 12C AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9728660779622 40.7753294525644)
481 481 -73.9714303315699 40.774593494770606 11E-AM-1013-04 11E AM 10132018 4 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9714303315699 40.7745934947706)
662 662 -73.9721854790038 40.776108635243794 12C-AM-1013-01 12C AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9721854790038 40.7761086352438)
1205 1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 1 0 0   POINT (-73.9611118778753 40.7952007875354)
2848 2848 -73.97159771705479 40.774217265062205 11E-AM-1013-03 11E AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9715977170548 40.774217265062205)

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.999ms