2018_Central_Park_Squirrel_Census_-_Squirrel_Data

15 rows where Above Ground Sighter Measurement = 3, Eating = 0 and Shift = "PM" sorted by Moans

View and edit SQL

Suggested facets: Hectare, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Indifferent

Hectare Squirrel Number

Runs from

Shift

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
4 -73.9757249834141 40.7697032606755 5D-PM-1018-05 05D PM 10182018 5 Juvenile Gray   Gray+   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9757249834141 40.7697032606755)
150 -73.97634308293419 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward 0 1 0 0 0 chased #12 1 0 0 1 0 0 0 1   POINT (-73.9763430829342 40.7686351097159)
237 -73.96789565689801 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.967895656898 40.7767409597341)
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)
782 -73.9710559113762 40.779427991420896 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)
1086 -73.9713399316534 40.77506780267571 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   0 0 1 0 0 lounging on tree upside down 0 0 0 0 1 0 1 0   POINT (-73.9713399316534 40.7750678026757)
1150 -73.97447264347429 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 chased up a tree by #4 0 0 0 0 0 0 1 0   POINT (-73.9744726434743 40.776729630785)
1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   1 0 0 0 0 was chased by # 11 1 0 0 0 0 0 0 1   POINT (-73.9763236949008 40.7686815615335)
1384 -73.97876087620051 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   0 0 0 0 0 walked between trees 0 0 0 0 0 0 1 0   POINT (-73.9787608762005 40.7686062296462)
1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9778730762957 40.770827251547)
1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)
1825 -73.9624209799704 40.79102009727521 31C-PM-1010-01 31C PM 10102018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9624209799704 40.7910200972752)
1854 -73.9618076359384 40.7947808718203 35A-PM-1013-05 35A PM 10132018 5 Adult Gray   Gray+   Above Ground 3 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9618076359384 40.7947808718203)
2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9686370726471 40.7780382348833)
2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9761879300037 40.7683918970301)

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