2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Above Ground Sighter Measurement = 20, Highlight Fur Color = "Cinnamon" and Tail twitches = 0 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Specific Location, Running, Chasing, Climbing, Foraging, Kuks, Moans, Approaches, Indifferent, Runs from

Tail twitches ✖

Highlight Fur Color ✖

  • Cinnamon · 19 ✖

Above Ground Sighter Measurement ✖

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
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685227310735 40.776599466588)
698 698 -73.95855376683821 40.7903905787005 32F-AM-1012-03 32F AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 bringing green leaves to nest 0 0 0 0 0 0 0 0   POINT (-73.9585537668382 40.7903905787005)
797 797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.969345754447 40.7770429650288)
1431 1431 -73.9601918930677 40.7944134683406 35C-AM-1007-01 35C AM 10072018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20 (white oak) 0 0 0 0 0 sitting still 0 0 0 0 0 0 0 0   POINT (-73.9601918930677 40.7944134683406)
1506 1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9728339757306 40.7782891207966)
1508 1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree 0 0 1 0 0 chased by a doggo 0 0 1 0 0 0 0 1 runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)
2877 2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
444 444 -73.96414623605409 40.7778316005464 18I-PM-1007-09 18I PM 10072018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 canoodling w/ 8 0 0 0 0 0 0 1 0   POINT (-73.9641462360541 40.7778316005464)
565 565 -73.9615402629655 40.7924082330328 33C-AM-1012-02 33C AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along back & tail Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615402629655 40.7924082330328)
1010 1010 -73.9689723590015 40.7756860990338 13F-AM-1007-01 13F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689723590015 40.7756860990338)
1239 1239 -73.9725897240269 40.7691342079294 6G-AM-1008-01 06G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 in tree 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9725897240269 40.7691342079294)
1300 1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
1338 1338 -73.9716624574422 40.776203711010105 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0 scratching 0 0 0 0 0 0 1 0   POINT (-73.9716624574422 40.7762037110101)
1400 1400 -73.97734958071351 40.7664559937331 1E-AM-1006-05 01E AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773495807135 40.7664559937331)
1425 1425 -73.95862528758559 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586252875856 40.7852027586217)
1503 1503 -73.97321932906308 40.7748791447746 11D-PM-1006-01 11D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9732193290631 40.7748791447746)
2368 2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2872 2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)

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