2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Date = 10062018, Location = "Above Ground" and Running = 1 sorted by Kuks

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Climbing, Eating, Foraging, Tail flags, Indifferent, Runs from

Tail twitches

  • 0 13
  • 1 3

Running

Location

  • Above Ground · 16

Date

  • 10062018 · 16
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 -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)
262 -73.97128762341721 40.7695885530701 7H-PM-1006-02 07H PM 10062018 2 Adult Gray   Gray+   Above Ground 25 tree 1 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9712876234172 40.7695885530701)
381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
528 -73.9647284206644 40.7839611840884 23E-PM-1006-01 23E PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9647284206644 40.7839611840884)
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)
757 -73.9783185278595 40.7724861675504 7A-AM-1006-03 07A AM 10062018 3 Adult Gray   Gray+ 3/4 length tail, hair loss Above Ground 20 in trees, then to ground 1 0 1 0 0 jumping 0 0 0 0 0 0 1 0   POINT (-73.9783185278595 40.7724861675504)
1329 -73.9772164524209 40.768839953875606 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree 1 0 1 0 0   0 0 0 0 0 0 0 0 did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)
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)
1464 -73.95320745731391 40.793466946490796 37H-PM-1006-06 37H PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9532074573139 40.7934669464908)
1575 -73.9703169373939 40.770065882385396 7H-AM-1006-13 07H AM 10062018 13 Adult Gray   Gray+   Above Ground 10   1 0 0 0 0 running (up tree) 0 0 0 0 0 0 1 0   POINT (-73.9703169373939 40.7700658823854)
1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree 1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9745204169071 40.7736282868469)
2280 -73.97671436441509 40.76847569413211 3D-AM-1006-02 03D AM 10062018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25 tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767143644151 40.7684756941321)
2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2755 -73.9712022111028 40.767250436826295 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9712022111028 40.7672504368263)
2803 -73.9576652087316 40.787545797780105 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9576652087316 40.7875457977801)
2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)

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