2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Climbing = 1, Highlight Fur Color = "Cinnamon" and Tail twitches = 1 sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Highlight Fur Color ✖

  • Cinnamon · 22 ✖
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
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
339 339 -73.965509576403 40.7752456763263 14I-PM-1018-05 14I PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.96550957640301 40.7752456763263)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
641 641 -73.97190362174459 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719036217446 40.7803588122409)
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
682 682 -73.9651828383592 40.780282094386294 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9651828383592 40.7802820943863)
733 733 -73.9764397550289 40.7737004557104 8B-AM-1007-01 08B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9764397550289 40.7737004557104)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
1035 1035 -73.97725699096729 40.7664804797448 1E-AM-1006-02 01E AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9772569909673 40.7664804797448)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9716736557408 40.7749333494336)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
2016 2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
2242 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)
2559 2559 -73.95723834787741 40.787685738072206 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9572383478774 40.7876857380722)
2586 2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.970595860252 40.7832060751268)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)

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