2018_Central_Park_Squirrel_Census_-_Squirrel_Data

28 rows where Eating = 1, Highlight Fur Color = "Cinnamon" and Running = 1 sorted by Age

View and edit SQL

Suggested facets: Hectare, Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Running

Highlight Fur Color

  • Cinnamon · 28

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
1029 -73.9601259189134 40.795535060905706 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9601259189134 40.7955350609057)
2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9800094828465 40.7677782585639)
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)
501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9708798496132 40.7761532088521)
619 -73.9769887473852 40.7707561532949 5C-PM-1010-04 05C PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.97698874738522 40.7707561532949)
678 -73.977447585355 40.769716782800295 4C-PM-1010-11 04C PM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.977447585355 40.7697167828003)
697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9738481771673 40.7706540698938)
922 -73.9708002461415 40.7726685284831 10F-PM-1019-10 10F PM 10192018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Arbor path & hill w/ bushes 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9708002461415 40.7726685284831)
1020 -73.97016933635 40.770545252978295 8H-AM-1017-05 08H AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97016933635001 40.7705452529783)
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)
1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9735655529245 40.7716072681474)
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)
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)
1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9604083891356 40.7910284106931)
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)
1990 -73.9774584305147 40.770813398619204 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9774584305147 40.7708133986192)
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)
2319 -73.97568707891871 40.773364678267896 9B-AM-1010-09 09B AM 10102018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 food in mouth 0 0 0 0 0 0 0 0   POINT (-73.9756870789187 40.7733646782679)
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)
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)
2515 -73.9693338657183 40.775705588453796 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk 1 0 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9693338657183 40.77570558845381)
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)
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
2980 -73.97164145863809 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 running (from birds) 0 0 0 1 0 0 1 0   POINT (-73.9716414586381 40.771760114722)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
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)

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