2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Eating = 1, Highlight Fur Color = "White" and Primary Fur Color = "Cinnamon" sorted by Foraging

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Kuks, Tail twitches, Approaches, Indifferent, Runs from

Tail flags ✖

  • 0 24

Primary Fur Color ✖

  • Cinnamon · 24 ✖

Highlight Fur Color ✖

  • White · 24 ✖
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
199 199 -73.97716146866159 40.770967798324705 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9771614686616 40.7709677983247)
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801007327506 40.7677455633932)
1001 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)
1129 1129 -73.97449068326779 40.7699948746776 6E-PM-1010-05 06E PM 10102018 5 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE   0 0 0 1 0 could this squirrel be eating a white mushroom? 0 0 0 0 0 0 1 0   POINT (-73.9744906832678 40.76999487467761)
1233 1233 -73.9722281263634 40.770408328801295 7G-AM-1010-06 07G AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722281263634 40.7704083288013)
1282 1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
1290 1290 -73.96681408040659 40.77681001473329 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9668140804066 40.7768100147333)
1561 1561 -73.9642397829547 40.7918992406575 31A-PM-1017-02 31A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96423978295472 40.7918992406575)
1650 1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
2005 2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
2190 2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9657040391563 40.7755567428199)
2344 2344 -73.9786310308892 40.766934936818295 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9786310308892 40.7669349368183)
2478 2478 -73.96749310703241 40.778369369095394 17F-AM-1007-04 17F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Above Ground 4   0 0 0 1 0 chilling 1 0 0 0 0 0 1 0   POINT (-73.9674931070324 40.7783693690954)
2742 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)
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
2946 2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)
68 68 -73.96942403275091 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.96942403275091 40.7755898126674)
349 349 -73.9689657039917 40.776783427676705 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9689657039917 40.7767834276767)
376 376 -73.9698817079185 40.775832262771104 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9698817079185 40.7758322627711)
699 699 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)
1158 1158 -73.97638947595429 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9763894759543 40.7705523372364)
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       0 0 0 1 1 watching 0 0 0 0 0 0 0 1   POINT (-73.9593909381748 40.7961036981921)
2317 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)
2587 2587 -73.97899712868441 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9789971286844 40.7707024146365)

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