2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Hectare Squirrel Number = 3, Primary Fur Color = "Cinnamon" and Running = 1 sorted by Chasing

View and edit SQL

Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Tail twitches, Approaches, Indifferent, Runs from

Eating

  • 0 10
  • 1 1

Running

Primary Fur Color

  • Cinnamon · 11

Hectare Squirrel Number

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
224 -73.9520592496349 40.797507629981105 42G-PM-1014-03 42G PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 on fence 1 0 0 0 0 prancing 0 0 0 0 0 0 0 1   POINT (-73.9520592496349 40.7975076299811)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
454 -73.9752793195744 40.7733960128931 9C-AM-1006-03 09C AM 10062018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752793195744 40.7733960128931)
852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   1 0 1 0 0 hopping 0 0 0 0 0 1 0 1   POINT (-73.9609704650925 40.7938786854735)
937 -73.97063234587691 40.7713196034265 9G-PM-1007-03 09G PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706323458769 40.771319603426505)
1418 -73.9673924060436 40.7788781851716 17F-AM-1007-03 17F AM 10072018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9673924060436 40.7788781851716)
1932 -73.96169725573041 40.7953872829374 36A-PM-1013-03 36A PM 10132018 3 Juvenile Cinnamon   Cinnamon+ COULD HAVE BEEN CHIPPY, DEEP BROWN Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9616972557304 40.7953872829374)
2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9590191655172 40.7926139425111)
2620 -73.97718000981308 40.7708863131336 5C-PM-1010-03 05C PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9771800098131 40.7708863131336)
1551 -73.9785114291288 40.771977958944895 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785114291288 40.7719779589449)
2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map 1 1 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9594986107981 40.7840083040604)

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