2018_Central_Park_Squirrel_Census_-_Squirrel_Data

21 rows where Eating = 0, Hectare Squirrel Number = 1, Highlight Fur Color = "White" and Runs from = 1 sorted by Other Interactions

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Kuks, Moans, Tail flags, Tail twitches, Indifferent

Runs from

Highlight Fur Color

  • White · 21

Hectare Squirrel Number

Eating

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
27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots 0 0 0 0 0 sitting 0 0 0 0 1 0 0 1   POINT (-73.9670628558161 40.77349914209411)
45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
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)
170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
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)
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)
855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
865 -73.9741621946917 40.775248147202504 11C-PM-1018-01 11C PM 10182018 1 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9741621946917 40.7752481472025)
929 -73.97386112577159 40.773724677958704 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 1 0 0 1   POINT (-73.9738611257716 40.7737246779587)
1305 -73.9569324958684 40.7877748374259 30I-PM-1006-01 30I PM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 sitting there 0 0 0 0 0 0 0 1   POINT (-73.9569324958684 40.78777483742591)
1315 -73.9595955824812 40.793304794353396 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   0 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9595955824812 40.7933047943534)
1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695226023739 40.7797527775804)
1825 -73.9624209799704 40.79102009727521 31C-PM-1010-01 31C PM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9624209799704 40.7910200972752)
2278 -73.96453903109901 40.78099163100121 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.964539031099 40.7809916310012)
2406 -73.9668964315686 40.777757799088604 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9668964315686 40.7777577990886)
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2997 -73.96197353854829 40.7944667974974 35A-PM-1013-01 35A PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9619735385483 40.7944667974974)
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)
365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
410 -73.9584024936392 40.785149170194394 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1 runs from (us) POINT (-73.9584024936392 40.7851491701944)
342 -73.9605966636226 40.788984910863704 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)

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