2018_Central_Park_Squirrel_Census_-_Squirrel_Data

49 rows where Date = 10062018 and Hectare Squirrel Number = 3 sorted by longitude

View and edit SQL

Suggested facets: Shift, Age, 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, Approaches, Indifferent, Runs from, Other Interactions

Tail twitches

  • 0 38
  • 1 11

Hectare Squirrel Number

Date

  • 10062018 · 49
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
1230 -73.9790822606486 40.7714466633386 5A-AM-1006-03 05A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Above Ground 8   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9790822606486 40.7714466633386)
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)
335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
2539 -73.97810334484679 40.766672406621296 1D-AM-1006-03 01D AM 10062018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9781033448468 40.7666724066213)
2403 -73.97778796352159 40.769359455673 4C-AM-1006-03 04C AM 10062018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9777879635216 40.769359455673)
1160 -73.97772569893621 40.766623699564 1E-AM-1006-03 01E AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9777256989362 40.766623699564)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
207 -73.9770824412252 40.770996130945704 5C-AM-1006-03 05C AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97708244122522 40.7709961309457)
2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 checkin' his stashes 0 0 0 1 0 1 0 1   POINT (-73.9767953468937 40.7676376977667)
254 -73.9762246600197 40.775164077652 10A-AM-1006-03 10A AM 10062018 3 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE Bridle Path lawn 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9762246600197 40.775164077652)
1012 -73.9755569170561 40.7668006977526 2F-AM-1006-03 02F AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9755569170561 40.7668006977526)
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)
2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
454 -73.9752793195744 40.7733960128931 9C-AM-1006-03 09C AM 10062018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752793195744 40.7733960128931)
2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9751615527833 40.767013871509)
1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9745908987975 40.7655191512308)
223 -73.9737091707831 40.771373256751204 7E-AM-1006-03 07E AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE under a tree 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9737091707831 40.7713732567512)
2191 -73.9734108731087 40.767605139269705 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9734108731087 40.7676051392697)
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)
961 -73.9731457102903 40.7660255393205 2H-AM-1006-03 02H AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731457102903 40.7660255393205)
2427 -73.97292974853309 40.767327854143794 4H-AM-1006-03 04H AM 10062018 3 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1 met #4 while foraging and briefly tussled 0 0 0 0 0 0 1 0   POINT (-73.9729297485331 40.7673278541438)
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)
1248 -73.9719729323923 40.7668318394546 4I-AM-1006-03 04I AM 10062018 3 Adult     + Can't tell :( Above Ground 28 Tree 0 0 1 0 0 building nest! 0 0 0 0 0 0 0 0   POINT (-73.9719729323923 40.7668318394546)
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)
1819 -73.9711378905748 40.7696218346333 7H-AM-1006-03 07H AM 10062018 3 Adult Gray   Gray+   Ground Plane FALSE on rock (large) 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9711378905748 40.769621834633305)
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)
2397 -73.9704592500888 40.772962887933005 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704592500888 40.772962887933)
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)
1779 -73.9695560376915 40.7708835103516 9H-AM-1006-03 09H AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96955603769152 40.7708835103516)
1358 -73.9693772461788 40.770687589290105 8I-AM-1006-03 08I AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693772461788 40.7706875892901)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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