2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Chasing = 1, Eating = 1 and Shift = "PM" sorted by Age

View and edit SQL

Suggested facets: Hectare, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Kuks, Quaas, Tail twitches, Indifferent, Runs from

Shift

Eating

Chasing

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
82 -73.96882712024009 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9688271202401 40.7809719445309)
315 -73.95397347709341 40.7956055442 39G-PM-1013-04 39G PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9539734770934 40.7956055442)
684 -73.9691057326088 40.7765973509721 14F-PM-1012-07 14F PM 10122018 7 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.9691057326088 40.7765973509721)
740 -73.95834778506341 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   1 0 0 0 1 0 0 0   POINT (-73.9583477850634 40.7914073632782)
874 -73.95919577939921 40.79495688734529 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9591957793992 40.7949568873453)
1009 -73.9636551433178 40.790157281877605 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636551433178 40.7901572818776)
1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9716271494641 40.7796462634184)
1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593244415072 40.794964729747)
1282 -73.974451175321 40.770129463526395 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #3 0 0 0 0 0 0 1 0   POINT (-73.974451175321 40.7701294635264)
1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9704677007779 40.7786860108302)
1513 -73.96624099976421 40.789104293543204 28A-PM-1007-03 28A PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 1 1 chasing #2 took #2 food wrapper and is foraging through it 0 0 0 0 0 0 1 0   POINT (-73.9662409997642 40.7891042935432)
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)
1971 -73.9591880400132 40.795007125283604 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   1 1 0 0 1 0 1 0   POINT (-73.95918804001322 40.7950071252836)
2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2485 -73.9584950620879 40.790277071064295 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584950620879 40.7902770710643)
2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)

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