2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Date = 10142018, Hectare Squirrel Number = 1 and Highlight Fur Color = "White" sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Moans, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 17
  • 1 3

Highlight Fur Color ✖

  • White · 20 ✖

Hectare Squirrel Number ✖

Date ✖

  • 10142018 · 20 ✖
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
498 498 -73.9669432929573 40.779136518298 18F-AM-1014-01 18F AM 10142018 1 Adult Gray White Gray+White   Above Ground   Low tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9669432929573 40.779136518298)
1397 1397 -73.9655233748105 40.7792737287734 18G-AM-1014-01 18G AM 10142018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 0 0   1 0 0 0 0 0 1 0 looking POINT (-73.9655233748105 40.7792737287734)
102 102 -73.95759861613641 40.799368134968 41B-PM-1014-01 41B PM 10142018 1 Adult Gray White Gray+White   Above Ground 25 Climbing tree 0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 0 1   POINT (-73.9575986161364 40.799368134968)
1924 1924 -73.95423325052309 40.793347517143395 37G-AM-1014-01 37G AM 10142018 1 Adult Gray White Gray+White White tail Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9542332505231 40.7933475171434)
2387 2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
386 386 -73.95503513809571 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550351380957 40.7974681522214)
431 431 -73.97574360194321 40.774606436322706 10B-PM-1014-01 10B PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE on lawn in front of a tree 0 0 0 0 1   0 0 0 0 1 0 0 0 stay on ground but went to other side of tree to hide from a dog POINT (-73.9757436019432 40.7746064363227)
465 465 -73.9683041099256 40.786265230008205 24A-AM-1014-01 24A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 freezes POINT (-73.9683041099256 40.7862652300082)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
736 736 -73.9660110060416 40.780999009859705 20F-AM-1014-01 20F AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9660110060416 40.7809990098597)
840 840 -73.9598084794625 40.797616543450204 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598084794625 40.7976165434502)
845 845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9582850206205 40.7978975855555)
1151 1151 -73.9557602499712 40.7956452424385 38E-PM-1014-01 38E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9557602499712 40.7956452424385)
1667 1667 -73.96459890035891 40.778215745915496 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9645989003589 40.7782157459155)
2105 2105 -73.9738723117119 40.7786845612246 14A-AM-1014-01 14A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 foraging?,crossing road 0 0 0 0 0 0 1 1 runs from (dogs) POINT (-73.9738723117119 40.7786845612246)
2119 2119 -73.96415843952991 40.7816571644072 21G-AM-1014-01 21G AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9641584395299 40.7816571644072)
2312 2312 -73.97658670292259 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9765867029226 40.7674304266107)
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9617594316752 40.7946803725236)
2920 2920 -73.9657391918196 40.776502470347 16H-PM-1014-01 16H PM 10142018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657391918196 40.776502470347)

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