2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Date = 10142018, Location = "Above Ground" and Tail twitches = 1 sorted by Other Interactions

View and edit SQL

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

Hectare Squirrel Number

Highlight Fur Color

Tail twitches

Location

  • Above Ground · 10

Date

  • 10142018 · 10
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
702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963858549251 40.7808999610914)
1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 jumping back & forth on tree 0 0 0 1 1 0 1 0   POINT (-73.9679686793869 40.7825993867876)
1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch 0 0 0 0 1 digging? 0 0 0 0 1 0 1 0   POINT (-73.95933730937992 40.7982428507976)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)
248 -73.9751729403694 40.774328412311796 10B-PM-1014-02 10B PM 10142018 2 Adult Gray White Gray+White   Above Ground   gingko tree by traffic light in front of Strawberry Fields 0 0 0 0 1   0 0 0 0 1 0 0 0 came over on tree to see me then disappeared POINT (-73.9751729403694 40.7743284123118)
2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)

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