2018_Central_Park_Squirrel_Census_-_Squirrel_Data

25 rows where Date = 10062018, Hectare Squirrel Number = 3 and Shift = "PM" sorted by Hectare

View and edit SQL

Suggested facets: Unique Squirrel ID, Hectare, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Moans

  • 0 25

Hectare Squirrel Number

Date

  • 10062018 · 25
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
2120 -73.9733905460282 40.7656337147768 2H-PM-1006-03 02H PM 10062018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9733905460282 40.7656337147768)
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)
2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
1289 -73.97246812695259 40.7743474675821 11D-PM-1006-03 11D PM 10062018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9724681269526 40.7743474675821)
2396 -73.9704339422613 40.77401495296439 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9704339422613 40.7740149529644)
1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9714150090362 40.7774976423922)
2197 -73.9672413354558 40.7838116138235 22C-PM-1006-03 22C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9672413354558 40.7838116138235)
774 -73.9673603655908 40.787697417778205 26A-PM-1006-03 26A PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9673603655908 40.7876974177782)
1678 -73.95687265085459 40.7878795081255 30I-PM-1006-03 30I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 up tree POINT (-73.9568726508546 40.7878795081255)
1542 -73.960876728048 40.790357245370004 31D-PM-1006-03 31D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.960876728048 40.79035724537)
830 -73.95956459625391 40.7899599350145 31E-PM-1006-03 31E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes 0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9595645962539 40.7899599350145)
728 -73.96029131055779 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602913105578 40.7910635810038)
2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
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)
1920 -73.95453837191879 40.7899711263765 33I-PM-1006-03 33I PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.95453837191882 40.7899711263765)
2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
418 -73.9573604880421 40.7930844158021 35E-PM-1006-03 35E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9573604880421 40.7930844158021)
2 -73.9570437717691 40.7948509408039 37E-PM-1006-03 37E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 me POINT (-73.9570437717691 40.794850940803904)
2272 -73.9569670900695 40.7948792856813 37E-PM-1006-03 37E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 me POINT (-73.9569670900695 40.794879285681304)
1931 -73.9533085932603 40.793487786107505 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9533085932603 40.7934877861075)
2290 -73.95656457165641 40.795903994957705 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9565645716564 40.795903994957705)
825 -73.9580105174865 40.7974468322692 39C-PM-1006-03 39C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9580105174865 40.7974468322692)
331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
395 -73.9565686300382 40.797592846003 40C-PM-1006-03 40C PM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565686300382 40.797592846003)
2063 -73.95447632818859 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9544763281886 40.7969645476349)

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