2018_Central_Park_Squirrel_Census_-_Squirrel_Data

15 rows where Above Ground Sighter Measurement = 6 and Indifferent = 0 sorted by Primary Fur Color

✎ 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, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail twitches, Approaches, Runs from

Highlight Fur Color ✖

Foraging ✖

  • 0 12
  • 1 3

Above Ground Sighter Measurement ✖

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
600 600 -73.9808202088503 40.7682921842325 1A-PM-1014-02 01A PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9808202088503 40.7682921842325)
1006 1006 -73.96862962178929 40.771812308875 10H-AM-1014-02 10H AM 10142018 2 Juvenile Cinnamon   Cinnamon+   Above Ground 6   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686296217893 40.771812308875)
2387 2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
2503 2503 -73.974382557804 40.7674812627373 3F-AM-1006-10 03F AM 10062018 10 Adult Cinnamon White Cinnamon+White   Above Ground 6 on fence 0 0 1 0 0   0 0 0 0 0 0 0 0 clueless POINT (-73.974382557804 40.7674812627373)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)
116 116 -73.9572093760529 40.798848730021604 41B-AM-1010-06 41B AM 10102018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9572093760529 40.7988487300216)
168 168 -73.9745691353018 40.777103558929795 13A-PM-1014-03 13A PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 0 1 child chasing POINT (-73.9745691353018 40.7771035589298)
229 229 -73.97241624297101 40.7714260236636 8F-PM-1012-04 08F PM 10122018 4 Adult Gray   Gray+   Above Ground 6   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.972416242971 40.7714260236636)
476 476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree 0 0 0 0 0   1 1 0 0 0 0 0 0 not backing down POINT (-73.9690968160819 40.769923269444)
869 869 -73.96294833745279 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9629483374528 40.7936809905265)
1220 1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1776 1776 -73.9562350820255 40.7913464147989 34G-PM-1006-02 34G PM 10062018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 1 1 eating bread it found on ground 0 0 0 0 0 0 0 1   POINT (-73.9562350820255 40.7913464147989)
2179 2179 -73.95596639495109 40.7974497269789 40D-AM-1013-07 40D AM 10132018 7 Adult Gray   Gray+   Above Ground 6   0 0 1 0 1   0 0 0 0 0 0 0 1 curious POINT (-73.9559663949511 40.7974497269789)
2734 2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9763629541474 40.7682321897044)
2762 2762 -73.9656324462902 40.783403475308106 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9656324462902 40.7834034753081)

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