2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Eating = 1, Foraging = 1 and Hectare Squirrel Number = 8 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

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

Runs from ✖

  • 0 14
  • 1 4

Hectare Squirrel Number ✖

Foraging ✖

Eating ✖

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
214 214 -73.97725765612441 40.767989509396294 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0 approaches (food stand) POINT (-73.9772576561244 40.7679895093963)
274 274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639832886071 40.7909532437095)
303 303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 1 1 climbed fence staring at me - went up tree 0 0 0 0 0 0 0 1   POINT (-73.97623482246482 40.7694522315322)
677 677 -73.97991559660859 40.7698034314993 3A-PM-1017-08 03A PM 10172018 8 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9799155966086 40.7698034314993)
827 827 -73.97002473508999 40.78369290444589 21A-AM-1019-08 21A AM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97002473509 40.7836929044459)
1404 1404 -73.9700666654946 40.774285704258105 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 stared POINT (-73.9700666654946 40.7742857042581)
1514 1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   1 0 0 1 0 0 1 0   POINT (-73.9548006161673 40.7945503341011)
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9795585338537 40.768895893226)
1855 1855 -73.9791826197108 40.768577844752 2B-AM-1010-08 02B AM 10102018 8 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9791826197108 40.768577844752)
2023 2023 -73.9663977261879 40.775645134229 14H-PM-1012-08 14H PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9663977261879 40.775645134229)
2255 2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
2593 2593 -73.9590191812452 40.790616698140894 32E-PM-1017-08 32E PM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590191812452 40.7906166981409)
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.96926766598071 40.7700678919108)
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9730926233232 40.7781330751738)
2976 2976 -73.97240833205379 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1 drinking 0 0 0 0 0 1 0 0   POINT (-73.9724083320538 40.7744163768061)
3015 3015 -73.97591633005351 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9759163300535 40.7736180793606)
895 895 -73.97868986562791 40.7720833097065 6A-AM-1006-08 06A AM 10062018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9786898656279 40.77208330970651)
1772 1772 -73.9690540696008 40.7766014124609 14F-PM-1012-08 14F PM 10122018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9690540696008 40.7766014124609)

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