2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Date = 10072018, Indifferent = 1 and Tail flags = 1 sorted by Primary Fur Color

View and edit SQL

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

Foraging

Tail flags

Indifferent

Date

  • 10072018 · 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
928 -73.96704295859901 40.778437071937105 17F-AM-1007-05 17F AM 10072018 5 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.967042958599 40.7784370719371)
2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch 0 0 0 0 0 watching me scratching 1 0 0 1 0 0 1 0   POINT (-73.9622752768962 40.7814921913101)
25 -73.96711306801141 40.7784859700171 17F-AM-1007-07 17F AM 10072018 7 Adult Gray White Gray+White   Above Ground 24   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9671130680114 40.7784859700171)
38 -73.9742073452913 40.7757957380463 12B-AM-1007-01 12B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9742073452913 40.7757957380463)
94 -73.9641971813967 40.781353795943495 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9641971813967 40.7813537959435)
192 -73.9651654887991 40.7777806006951 17H-PM-1007-02 17H PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9651654887991 40.7777806006951)
234 -73.9741401377844 40.7758134257881 12B-AM-1007-02 12B AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9741401377844 40.7758134257881)
1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.96426660132072 40.7810384867375)
1660 -73.98004994980342 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock 0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9800499498034 40.770218109957305)
1910 -73.9699876501742 40.774248267675794 12F-PM-1007-06 12F PM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699876501742 40.77424826767581)
2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699124811406 40.7743016981538)
2440 -73.96738035086291 40.778524502550795 17F-AM-1007-01 17F AM 10072018 1 Adult Gray   Gray+   Above Ground 18   0 0 1 1 0   0 0 0 1 0 0 1 0   POINT (-73.9673803508629 40.7785245025508)

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