2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Above Ground Sighter Measurement = 15 and Tail twitches = 1 sorted by Indifferent

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Kuks, Runs from

Highlight Fur Color

Indifferent

Tail twitches

Above Ground Sighter Measurement

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
381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
387 -73.9578316525492 40.789010295962896 31G-PM-1007-01 31G PM 10072018 1 Adult Gray   Gray+   Above Ground 15   0 0 0 0 0 hiding 0 0 0 0 1 0 0 0 froze,sight of dogs POINT (-73.9578316525492 40.7890102959629)
510 -73.9638590768396 40.777678211498106 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9638590768396 40.7776782114981)
1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 0 curious,but wary POINT (-73.97699695480242 40.7710711265211)
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
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)
380 -73.9649590119935 40.782210792076896 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9649590119935 40.7822107920769)
1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.9720365327715 40.7762329714016)

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