2018_Central_Park_Squirrel_Census_-_Squirrel_Data

13 rows where Date = 10122018, Highlight Fur Color = "White" and Primary Fur Color = "Cinnamon" sorted by Primary Fur Color

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Indifferent, Runs from

Tail twitches

  • 0 10
  • 1 3

Primary Fur Color

  • Cinnamon · 13

Highlight Fur Color

  • White · 13

Date

  • 10122018 · 13
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
424 -73.9756557086441 40.773296289823996 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756557086441 40.773296289824)
485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9677423154682 40.77288133502451)
490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.978426472499 40.771904101844)
590 -73.97851333014259 40.77182602883379 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785133301426 40.7718260288338)
640 -73.97855365291359 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9785536529136 40.771618450500206)
667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9624538733037 40.7883829851518)
931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
1001 -73.9801985977846 40.768015951170504 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0 fighting w/ pigeons 0 0 0 0 0 0 1 0   POINT (-73.9801985977846 40.7680159511705)
1551 -73.9785114291288 40.771977958944895 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785114291288 40.7719779589449)
2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2745 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)
2900 -73.9631005470369 40.788549405719294 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9631005470369 40.7885494057193)

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