2018_Central_Park_Squirrel_Census_-_Squirrel_Data

13 rows where Above Ground Sighter Measurement = 10, Indifferent = 0 and Running = 1 sorted by Primary Fur Color

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Chasing, Climbing, Eating, Quaas, Tail twitches, Runs from

Primary Fur Color

Foraging

  • 0 11
  • 1 2

Running

Indifferent

Above Ground Sighter Measurement

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
2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
858 -73.96293834202741 40.7889383725489 29C-AM-1007-02 29C AM 10072018 2 Adult Black Gray Black+Gray   Above Ground 10   1 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.9629383420274 40.7889383725489)
1741 -73.9736995552241 40.77227125186371 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9736995552241 40.7722712518637)
534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9650499507011 40.7908191782173)
1871 -73.9748367344424 40.7693513000034 5E-PM-1012-06 05E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10 oak tree at end of ramp from Chess House 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9748367344424 40.7693513000034)
337 -73.95831019276521 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree 1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (us) POINT (-73.9583101927652 40.7852649316039)
930 -73.96220300857941 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9622030085794 40.7917723228749)
983 -73.9641552070803 40.7908479527923 30B-AM-1007-05 30B AM 10072018 5 Adult Gray   Gray+   Above Ground 10   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9641552070803 40.7908479527923)
1125 -73.9775735077285 40.7692872082165 4C-PM-1010-08 04C PM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 on stone arch 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9775735077285 40.7692872082165)
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)
1960 -73.97301589136609 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 1 0 0 0 chasing #2 0 0 0 0 0 0 0 0   POINT (-73.9730158913661 40.7701310707272)
2002 -73.9581706950566 40.790632139726895 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9581706950566 40.7906321397269)
2707 -73.97431653210991 40.775467467857396 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   1 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9743165321099 40.7754674678574)

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