2018_Central_Park_Squirrel_Census_-_Squirrel_Data

14 rows where Date = 10082018, Foraging = 0 and Hectare Squirrel Number = 5 sorted by Color notes

View and edit SQL

Suggested facets: Shift, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Other Activities, Quaas, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Foraging

Date

  • 10082018 · 14
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
80 -73.9688454483585 40.78453012881629 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can 0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9688454483585 40.7845301288163)
139 -73.969847380865 40.7769884612305 14E-AM-1008-05 14E AM 10082018 5 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0 nest building 0 0 0 0 0 0 1 0   POINT (-73.969847380865 40.7769884612305)
276 -73.9758579666874 40.767932654884504 3E-PM-1008-05 03E PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0 jump 0 0 0 0 0 0 1 0   POINT (-73.9758579666874 40.7679326548845)
306 -73.96897001002671 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 sitting 0 1 0 0 0 0 0 0   POINT (-73.9689700100267 40.7775169562765)
647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
696 -73.96560981941491 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9656098194149 40.7757643078973)
792 -73.97301156879641 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9730115687964 40.7741018274312)
1288 -73.97304542959971 40.77029094543921 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9730454295997 40.7702909454392)
1592 -73.9575517912392 40.788915826819206 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575517912392 40.7889158268192)
1883 -73.9568108465086 40.7971727026108 39D-AM-1008-05 39D AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95681084650862 40.7971727026108)
1940 -73.9696445614055 40.779148620362704 17D-AM-1008-05 17D AM 10082018 5 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9696445614055 40.7791486203627)
2552 -73.97249477106979 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch 0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9724947710698 40.7696619340886)
2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9770313887741 40.772486925209904)
2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)

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