2018_Central_Park_Squirrel_Census_-_Squirrel_Data

13 rows where Date = 10072018, Foraging = 0 and Highlight Fur Color = "Cinnamon, White" sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Tail twitches, Indifferent, Runs from

Highlight Fur Color ✖

  • Cinnamon, White · 13 ✖

Foraging ✖

Date ✖

  • 10072018 · 13 ✖
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
394 394 -73.9719888241794 40.7667681685356 4I-PM-1007-03 04I PM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 ran to tree 0 0 0 0 0 being chased 0 0 0 0 0 0 0 0   POINT (-73.9719888241794 40.7667681685356)
616 616 -73.9556937218252 40.7990928062435 42C-AM-1007-04 42C AM 10072018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White young adult Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 1 0   POINT (-73.9556937218252 40.7990928062435)
674 674 -73.9779811967788 40.7675178797546 2D-AM-1007-01 02D AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779811967788 40.7675178797546)
725 725 -73.9689627791 40.776062004359005 14F-AM-1007-06 14F AM 10072018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689627791 40.776062004359)
795 795 -73.9582523503306 40.7996897499473 41A-PM-1007-05 41A PM 10072018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9582523503306 40.7996897499473)
1068 1068 -73.96660639702 40.7756655031741 14H-AM-1007-03 14H AM 10072018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96660639702002 40.7756655031741)
1220 1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1325 1325 -73.97752788478971 40.7687881061059 3C-AM-1007-02 03C AM 10072018 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.9775278847897 40.7687881061059)
1847 1847 -73.9782283921819 40.766793260207706 1D-PM-1007-02 01D PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9782283921819 40.7667932602077)
1954 1954 -73.9794840520702 40.7709595369804 4A-PM-1007-02 04A PM 10072018 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.9794840520702 40.770959536980406)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
2905 2905 -73.9784872728213 40.768812260393204 3C-AM-1007-01 03C AM 10072018 1 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.9784872728213 40.7688122603932)

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