2018_Central_Park_Squirrel_Census_-_Squirrel_Data

115 rows where Highlight Fur Color = "Cinnamon, White" and Shift = "AM" sorted by Date

View and edit SQL

Tail twitches

  • 0 12
  • 1 3

Shift

Other Interactions

Highlight Fur Color

  • Cinnamon, White · 15
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
2310 -73.9712863172608 40.774698758184 12E-AM-1017-01 12E AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9712863172608 40.774698758184)
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)
1895 -73.954699659637 40.7951308856929 38F-AM-1018-02 38F AM 10182018 2 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.954699659637 40.7951308856929)
2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0 sitting in the sun 0 0 0 0 0 0 1 0   POINT (-73.9748635473782 40.7742591029151)
2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550235589287 40.7951312356844)
187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 0 posing 0 0 0 0 0 0 1 1 indifferent then runs from POINT (-73.9700162034073 40.7815277479588)
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)
1196 -73.95801114962751 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 0   POINT (-73.9580111496275 40.7985365971474)
1591 -73.95762233900821 40.79797466396471 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 1 0   POINT (-73.9576223390082 40.79797466396471)
1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594174605642 40.7973128653773)
2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   0 0 0 0 1 standing on back legs 0 0 0 0 0 1 1 0   POINT (-73.9601851468038 40.7968698151479)
3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)
243 -73.9754778808471 40.7685619029765 4E-AM-1020-01 04E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 0 0 sitting very still 0 0 0 0 0 0 1 0   POINT (-73.9754778808471 40.7685619029765)
1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)
1810 -73.9579506263361 40.7936973555953 35E-AM-1020-01 35E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579506263361 40.7936973555953)

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