2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Climbing = 1, Eating = 1 and Highlight Fur Color = "Cinnamon" sorted by Foraging

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number ✖

Highlight Fur Color ✖

  • Cinnamon · 19 ✖

Eating ✖

Climbing ✖

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
112 112 -73.96517544644391 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651754464439 40.7755181941559)
210 210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
220 220 -73.96718161220299 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.967181612203 40.7787752287055)
339 339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.96550957640301 40.7752456763263)
505 505 -73.9677387336667 40.774269591199996 12H-PM-1007-02 12H PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree 0 0 1 1 0 peanuts 0 0 0 0 0 0 1 0   POINT (-73.9677387336667 40.7742695912)
942 942 -73.9533923917973 40.796170187476896 40G-AM-1007-01 40G AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 large tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9533923917973 40.7961701874769)
1444 1444 -73.9763852372393 40.768876248561 4D-AM-1012-02 04D AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763852372393 40.768876248561)
2380 2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
2463 2463 -73.9653343572865 40.77752869246171 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9653343572865 40.7775286924617)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2783 2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)
760 760 -73.97182341595571 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 1 burying 0 0 0 1 0 0 0 1   POINT (-73.9718234159557 40.7810842503715)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
1480 1480 -73.96285255338309 40.793844934501706 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 eating upside down on tree trunk 0 0 0 0 0 0 0 0   POINT (-73.9628525533831 40.7938449345017)
1609 1609 -73.96390249881229 40.777695306584896 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639024988123 40.7776953065849)
2222 2222 -73.9639048209454 40.777737334555795 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639048209454 40.7777373345558)
2366 2366 -73.96761918469849 40.777641740816996 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9676191846985 40.777641740817)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)

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