2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Foraging = 1, Hectare Squirrel Number = 1 and Primary Fur Color = "Cinnamon" sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

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

Running ✖

  • 0 24
  • 1 5

Primary Fur Color ✖

  • Cinnamon · 29 ✖

Hectare Squirrel Number ✖

Foraging ✖

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
26 26 -73.9649866016038 40.776492969445705 16I-AM-1008-01 16I AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9649866016038 40.7764929694457)
120 120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1 begging 0 0 0 0 0 0 0 0   POINT (-73.9511118711108 40.7950813345902)
470 470 -73.95812430217221 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1 avoiding a dog POINT (-73.95812430217221 40.794431473386)
557 557 -73.97921538931459 40.7688272492961 3B-AM-1010-01 03B AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9792153893146 40.7688272492961)
685 685 -73.9658181813014 40.7798160637561 19F-AM-1007-01 19F AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 bit scared POINT (-73.9658181813014 40.7798160637561)
699 699 -73.95046935442251 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9504693544225 40.797225436004)
931 931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
982 982 -73.9676424599715 40.777776610680704 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9676424599715 40.7777766106807)
1042 1042 -73.9593374341938 40.797258337802 38B-PM-1018-01 38B PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9593374341938 40.797258337802)
1098 1098 -73.96049542761291 40.7965682182001 37A-AM-1012-01 37A AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray Drawing included on tally sheet Ground Plane FALSE   0 0 0 0 1 scanning (drawing included) 0 0 0 0 0 0 0 1   POINT (-73.9604954276129 40.7965682182001)
1117 1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9693465383617 40.7744996336934)
1155 1155 -73.964572179093 40.7811208719018 21F-PM-1018-01 21F PM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.964572179093 40.7811208719018)
1276 1276 -73.9798005188704 40.7691868791734 3A-PM-1017-01 03A PM 10172018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97980051887042 40.7691868791734)
1412 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)
1505 1505 -73.9733461334967 40.7684314285151 5G-PM-1010-01 05G PM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9733461334967 40.7684314285151)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
1982 1982 -73.9729979174723 40.7742904356698 10D-PM-1008-01 10D PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9729979174723 40.7742904356698)
2008 2008 -73.95243640874371 40.792846505434 37I-PM-1006-01 37I PM 10062018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Above Ground 5   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9524364087437 40.792846505434)
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees 0 0 1 1 1 scratching self 0 0 0 0 1 0 1 0   POINT (-73.9639505810228 40.789573183584)
2278 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)
2451 2451 -73.9775865217038 40.7704928300008 5C-PM-1010-01 05C PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9775865217038 40.7704928300008)
2583 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)
2757 2757 -73.96714191194559 40.77586024868621 14G-AM-1012-01 14G AM 10122018 1 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9671419119456 40.7758602486862)
2761 2761 -73.96892042580629 40.7712540588951 9I-AM-1014-01 09I AM 10142018 1 Adult Cinnamon Black, White Cinnamon+Black, White Black on body, White Belly, White tail Ground Plane FALSE   0 0 0 0 1 digging deeeep 0 0 0 0 0 0 1 0   POINT (-73.9689204258063 40.7712540588951)
2802 2802 -73.9533101544112 40.7938634280159 38H-AM-1019-01 38H AM 10192018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9533101544112 40.7938634280159)
2900 2900 -73.9631005470369 40.788549405719294 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9631005470369 40.7885494057193)
2943 2943 -73.962534856258 40.7812134517411 22H-PM-1007-01 22H PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962534856258 40.7812134517411)
2989 2989 -73.9643538221947 40.7917565604735 31A-PM-1017-01 31A PM 10172018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White Gray lower back, Gray & Cinnamon selected as Primary with "lower back" written in next to Gray. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9643538221947 40.7917565604735)
3023 3023 -73.97547941915529 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9754794191553 40.7696404489025)

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