2018_Central_Park_Squirrel_Census_-_Squirrel_Data

22 rows where Eating = 0, Hectare Squirrel Number = 4, Running = 1 and Shift = "AM" sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

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

Shift ✖

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
493 493 -73.97768547979159 40.768310229566296 3D-AM-1006-04 03D AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (boy on bike) POINT (-73.9776854797916 40.7683102295663)
903 903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9719941577406 40.77037129313)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
1072 1072 -73.9566571713254 40.798985577543505 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9566571713254 40.7989855775435)
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)
1294 1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 1   POINT (-73.9604089940153 40.7910028063138)
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 was with a lot of robins POINT (-73.9534910562766 40.7935774443789)
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks 1 0 0 0 0 hiding from bird 0 1 0 0 1 0 1 0   POINT (-73.9555856074105 40.79694576856771)
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9692401421068 40.7707128895661)
1600 1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.97530937770001 40.7666673897583)
1736 1736 -73.9743873549635 40.7745426051392 10C-AM-1018-04 10C AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9743873549635 40.7745426051392)
1752 1752 -73.9561091686663 40.798146304742495 41D-AM-1014-04 41D AM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9561091686663 40.7981463047425)
1794 1794 -73.97579123504819 40.774759862145096 10B-AM-1006-04 10B AM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9757912350482 40.7747598621451)
1969 1969 -73.96890514730721 40.7764511282884 14F-AM-1007-04 14F AM 10072018 4 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689051473072 40.7764511282884)
2094 2094 -73.9701630539326 40.7779553961101 15D-AM-1007-04 15D AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97016305393261 40.7779553961101)
2113 2113 -73.95829048146521 40.790591574956395 32F-AM-1012-04 32F AM 10122018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9582904814652 40.7905915749564)
2246 2246 -73.9711607544742 40.774988247642 12E-AM-1017-04 12E AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711607544742 40.774988247642)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2514 2514 -73.95744422055 40.7961046528557 38D-AM-1017-04 38D AM 10172018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95744422055 40.7961046528557)
2619 2619 -73.9739737592602 40.772713047677705 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739737592602 40.7727130476777)
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
2866 2866 -73.9744025383371 40.7777296605765 13A-AM-1017-04 13A AM 10172018 4 Adult Gray   Gray+         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9744025383371 40.7777296605765)

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