2018_Central_Park_Squirrel_Census_-_Squirrel_Data

36 rows where Eating = 1, Hectare Squirrel Number = 1 and Running = 1 sorted by Climbing

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Running

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
82 -73.96882712024009 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9688271202401 40.7809719445309)
109 -73.967097592707 40.785411934253794 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   1 0 0 1 0 took nut to bury 0 0 0 0 1 0 0 1   POINT (-73.967097592707 40.7854119342538)
404 -73.9680774548516 40.7762491903691 14F-PM-1012-01 14F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9680774548516 40.7762491903691)
420 -73.96718516112429 40.7750878657618 14H-PM-1012-01 14H PM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0 approaches (came very close to me) POINT (-73.9671851611243 40.7750878657618)
429 -73.96947840566179 40.7787735291442 16D-PM-1010-01 16D PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694784056618 40.7787735291442)
706 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)
749 -73.96863045815259 40.7773631337117 15E-PM-1008-01 15E PM 10082018 1 Adult Gray   Gray+   Above Ground 4 on fallen tree 1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9686304581526 40.7773631337117)
804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9697196619878 40.7814068507607)
1094 -73.9773898301093 40.770858156205705 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running across ball field 5,near home plate 0 0 0 0 0 0 1 0   POINT (-73.9773898301093 40.7708581562057)
1298 -73.9612900553755 40.791291739186704 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9612900553755 40.7912917391867)
1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9603302382958 40.7910100435196)
1307 -73.9565197137317 40.7986011403785 41C-PM-1007-01 41C PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9565197137317 40.7986011403785)
1408 -73.973230162241 40.768982453144396 5F-AM-1007-01 05F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 fence 1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.973230162241 40.7689824531444)
1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9594676326588 40.7984457363388)
1766 -73.972757765574 40.76542855100671 2I-AM-1006-01 02I AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.972757765574 40.7654285510067)
1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 1 0 0 0 look at humans determining POINT (-73.968004352343 40.7726669278308)
1866 -73.96360276644391 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636027664439 40.790075966587)
1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1 runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)
1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9753291616796 40.7687376032936)
2147 -73.9651217998407 40.7761115392738 15I-PM-1012-01 15I PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9651217998407 40.7761115392738)
2163 -73.9643664403785 40.77936707037271 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree 1 0 0 1 1   0 0 0 0 0 0 1 0 run from human w/ dog POINT (-73.9643664403785 40.7793670703727)
2294 -73.96308205774409 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9630820577441 40.7821632293136)
2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 digging/burying,drinking from lake 0 0 0 0 1 0 1 0   POINT (-73.9737247632185 40.7759469280872)
2424 -73.9684752839242 40.776581626151795 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 1   POINT (-73.9684752839242 40.7765816261518)
2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9617594316752 40.7946803725236)
2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2682 -73.97110012783891 40.778746609584104 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9711001278389 40.7787466095841)
2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9531953594918 40.7960413520131)
373 -73.96721272832829 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   1 0 1 1 0 a lot of activity 0 0 0 1 0 0 0 0   POINT (-73.9672127283283 40.7810666805133)
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)
1739 -73.96397004344492 40.777500305002796 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings 1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639700434449 40.7775003050028)
2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   1 0 1 1 0   0 0 0 0 1 0 0 1   POINT (-73.9621253644004 40.7912082086879)
2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)
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)

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