2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Age = "Juvenile", Foraging = 1, Hectare Squirrel Number = 1 and Highlight Fur Color = "Cinnamon" sorted by Lat/Long

View and edit SQL

Suggested facets: Shift, Date, Location, Running, Eating, Tail flags, Tail twitches, Indifferent, Runs from

Highlight Fur Color

  • Cinnamon · 7

Hectare Squirrel Number

Age

  • Juvenile · 7
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 ▼
1189 -73.95776297445391 40.7897460758298 32G-PM-1013-01 32G PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 allowed me to approach within 10 ft POINT (-73.9577629744539 40.789746075829804)
2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree 0 0 0 1 1 walking up & down branches 0 0 0 0 0 0 1 0   POINT (-73.9667560049684 40.7882333830729)
1523 -73.9673103881521 40.78742674096179 26A-PM-1006-01 26A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9673103881521 40.7874267409618)
1980 -73.9686635017966 40.78431767328279 22B-PM-1014-01 22B PM 10142018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96866350179661 40.7843176732828)
2121 -73.9693462354257 40.776444438545205 14E-PM-1017-01 14E PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9693462354257 40.7764444385452)
2207 -73.9748943397482 40.770399256427204 6E-AM-1014-01 06E AM 10142018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9748943397482 40.7703992564272)

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