2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Foraging = 0, Hectare Squirrel Number = 1 and Highlight Fur Color = "Cinnamon, White" sorted by Quaas

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Kuks, Tail flags, Tail twitches, Runs from

Indifferent ✖

  • 0 13
  • 1 11

Highlight Fur Color ✖

  • Cinnamon, White · 24 ✖

Hectare Squirrel Number ✖

Foraging ✖

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
236 236 -73.9737266070919 40.7786338379896 14A-PM-1014-01 14A PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9737266070919 40.7786338379896)
243 243 -73.9754778808471 40.7685619029765 4E-AM-1020-01 04E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 0 0 sitting very still 0 0 0 0 0 0 1 0   POINT (-73.9754778808471 40.7685619029765)
288 288 -73.9731113265165 40.778664067635496 15A-PM-1017-01 15A PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 1 0 eating in tree 0 0 0 0 0 0 1 0   POINT (-73.9731113265165 40.7786640676355)
674 674 -73.9779811967788 40.7675178797546 2D-AM-1007-01 02D AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779811967788 40.7675178797546)
782 782 -73.9710559113762 40.779427991420896 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)
804 804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9697196619878 40.7814068507607)
918 918 -73.9681093100008 40.7731753915361 11H-PM-1013-01 11H PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9681093100008 40.7731753915361)
1180 1180 -73.9639726817977 40.7829083461049 23F-PM-1013-01 23F PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) POINT (-73.9639726817977 40.7829083461049)
1183 1183 -73.9525699067954 40.7937125788106 38I-PM-1014-01 38I PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE on the lawn East of the fountain 0 0 0 0 0 scampering thru the grass! 0 0 0 0 1 0 0 1   POINT (-73.9525699067954 40.7937125788106)
1303 1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9603302382958 40.7910100435196)
1898 1898 -73.9721263050502 40.7698763846186 7G-PM-1018-01 07G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9721263050502 40.7698763846186)
1952 1952 -73.96818104666929 40.7720638449419 10I-PM-1013-01 10I PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9681810466693 40.7720638449419)
2054 2054 -73.97263812347471 40.7752694815985 12D-PM-1014-01 12D PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9726381234747 40.7752694815985)
2067 2067 -73.97250779335741 40.7654562710325 2I-PM-1006-01 02I PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 Sitting on back of bench with food hanging from mouth 0 0 0 0 0 staring at me 0 0 0 0 0 0 0 1   POINT (-73.9725077933574 40.7654562710325)
2195 2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 1 0   1 0 0 0 0 0 1 0   POINT (-73.955352152771 40.7988549523022)
2199 2199 -73.9677500862135 40.7726060987821 11I-AM-1012-01 11I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9677500862135 40.7726060987821)
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9587678566254 40.7962656030995)
2294 2294 -73.96308205774409 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9630820577441 40.7821632293136)
2389 2389 -73.9801343393329 40.769151245340204 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9801343393329 40.7691512453402)
2460 2460 -73.9526681107152 40.7977012009146 42F-PM-1017-01 42F PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0 playing 0 0 0 0 0 0 1 0   POINT (-73.9526681107152 40.7977012009146)
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9621253644004 40.7912082086879)
2600 2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9544553697736 40.7912866208106)
2905 2905 -73.9784872728213 40.768812260393204 3C-AM-1007-01 03C AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9784872728213 40.7688122603932)
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)

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