2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Date = 10172018, Highlight Fur Color = "White" and Location = "Above Ground" sorted by Specific Location

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail twitches, Approaches, Indifferent

Moans

  • 0 8

Location

  • Above Ground · 8

Highlight Fur Color

  • White · 8

Date

  • 10172018 · 8
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
844 -73.9642379942652 40.777479252073796 17I-PM-1017-01 17I PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 was in a tree,so i couldn't really tell POINT (-73.9642379942652 40.7774792520738)
1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9693159934697 40.7831212338295)
1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 1 0 0 0 0 0 0 stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)
2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   0 0 0 0 0 staying very still to avoid two very curious dogs on the ground 0 0 0 0 0 0 0 0 petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)
2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 0 0 watching 0 0 0 0 0 1 0 0   POINT (-73.9651541395415 40.7798283208748)
1241 -73.9651817987035 40.781908283833396 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree 0 0 0 1 1   0 0 0 0 1 0 0 0 walks from POINT (-73.9651817987035 40.7819082838334)
1182 -73.9667206046912 40.777999356509795 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667206046912 40.7779993565098)
2071 -73.96676944398949 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9667694439895 40.7779501809095)

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