2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Other Activities = "digging" sorted by Foraging

✎ View and edit SQL

This data as json, CSV (advanced)

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

Date ✖

Quaas ✖

  • 0 19

Other Activities ✖

  • digging · 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
1194 1194 -73.96874625660729 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9687462566073 40.783898987005)
1279 1279 -73.95121209494779 40.7947945266515 39I-PM-1013-01 39I PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE along the road 0 0 0 1 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9512120949478 40.7947945266515)
2150 2150 -73.9557710118271 40.791916118555704 34G-PM-1006-01 34G PM 10062018 1 Adult Black   Black+ Skinny, thin tail Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 0   POINT (-73.9557710118271 40.7919161185557)
2421 2421 -73.96822789059891 40.773302750805705 11H-PM-1013-02 11H PM 10132018 2 Adult Gray Black Gray+Black   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 1 0   POINT (-73.9682278905989 40.7733027508057)
2975 2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 0 0 digging 0 0 0 0 0 0 0 1   POINT (-73.959412243507 40.7917871123534)
93 93 -73.95515394983059 40.798738465625604 41D-AM-1014-01 41D AM 10142018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9551539498306 40.7987384656256)
473 473 -73.95701300171591 40.799602742862504 42B-AM-1014-02 42B AM 10142018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9570130017159 40.7996027428625)
592 592 -73.9712256765283 40.776094287248796 13D-PM-1018-13 13D PM 10182018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9712256765283 40.7760942872488)
642 642 -73.9568382279233 40.7975685470963 40C-AM-1017-07 40C AM 10172018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9568382279233 40.7975685470963)
659 659 -73.9572686979412 40.796268457326 38D-AM-1017-03 38D AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 0   POINT (-73.9572686979412 40.796268457326)
905 905 -73.9757216124349 40.7754310239649 11A-PM-1013-05 11A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1 digging 0 0 0 0 1 0 0 0   POINT (-73.9757216124349 40.7754310239649)
1187 1187 -73.97933344163779 40.7674142089209 1C-PM-1013-02 01C PM 10132018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 0   POINT (-73.9793334416378 40.7674142089209)
1340 1340 -73.97730836162592 40.7710535931636 6B-PM-1017-01 06B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 1 0 0   POINT (-73.9773083616259 40.7710535931636)
1541 1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9711617997772 40.7761212878075)
2075 2075 -73.96362349533341 40.7775138547689 18I-PM-1007-06 18I PM 10072018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9636234953334 40.7775138547689)
2638 2638 -73.9598973337711 40.793334636047796 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9598973337711 40.7933346360478)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9726598256924 40.7707862446236)
2994 2994 -73.96172070912449 40.792283902593496 33B-AM-1010-01 33B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9617207091245 40.7922839025935)

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