2018_Central_Park_Squirrel_Census_-_Squirrel_Data

17 rows where Hectare Squirrel Number = 6, Highlight Fur Color = "Cinnamon" and Runs from = 1 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

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

Runs from ✖

Highlight Fur Color ✖

  • Cinnamon · 17 ✖

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
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575791421589 40.7959934459432)
41 41 -73.96391592984459 40.789177463798794 29C-AM-1007-06 29C AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9639159298446 40.7891774637988)
61 61 -73.9797084866613 40.7698885241349 3A-PM-1017-06 03A PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9797084866613 40.7698885241349)
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9708798496132 40.7761532088521)
522 522 -73.97738211356109 40.769045349438294 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9773821135611 40.7690453494383)
713 713 -73.956200809768 40.798181446265 40C-AM-1017-06 40C AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.956200809768 40.798181446265)
943 943 -73.9773096718574 40.773805386248895 8A-AM-1013-06 08A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9773096718574 40.7738053862489)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
1520 1520 -73.968021326951 40.7778807692445 16F-PM-1013-06 16F PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Big rock in meadow 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.968021326951 40.7778807692445)
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)
2276 2276 -73.9611985783336 40.791604823372005 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9611985783336 40.791604823372)
2357 2357 -73.96323010348829 40.7925707244111 32A-PM-1013-06 32A PM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9632301034883 40.7925707244111)
2374 2374 -73.9551370586201 40.7946465469021 38F-AM-1018-06 38F AM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 hopped away 0 0 0 0 0 0 0 1   POINT (-73.95513705862011 40.7946465469021)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
2637 2637 -73.968891673893 40.776700147172896 15F-AM-1007-06 15F AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 pair with #5 0 0 0 0 0 0 0 1   POINT (-73.968891673893 40.7767001471729)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
2892 2892 -73.9688070760806 40.777968829417205 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688070760806 40.777968829417205)

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