2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Hectare Squirrel Number = 1, Highlight Fur Color = "White" and Running = 1 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

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

Indifferent ✖

  • 0 18
  • 1 12

Running ✖

Highlight Fur Color ✖

  • White · 30 ✖

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
30 30 -73.96929432916109 40.776953610248796 15E-AM-1013-01 15E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9692943291611 40.7769536102488)
45 45 -73.9579645940414 40.7918613498407 34F-AM-1007-01 34F AM 10072018 1 Adult Gray White Gray+White   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9579645940414 40.7918613498407)
51 51 -73.9801666435401 40.7686905339212 2B-PM-1013-01 02B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0 running (with nut) 0 0 0 0 0 0 0 0   POINT (-73.9801666435401 40.7686905339212)
170 170 -73.95972059663241 40.7969409510133 38B-AM-1019-01 38B AM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9597205966324 40.7969409510133)
365 365 -73.9576035072364 40.7966120824816 38C-AM-1019-01 38C AM 10192018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (lawnmower) POINT (-73.9576035072364 40.7966120824816)
386 386 -73.95503513809571 40.7974681522214 40E-AM-1014-01 40E AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9550351380957 40.7974681522214)
465 465 -73.9683041099256 40.786265230008205 24A-AM-1014-01 24A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0 freezes POINT (-73.9683041099256 40.7862652300082)
520 520 -73.97494466297059 40.77206596960671 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9749446629706 40.7720659696067)
1264 1264 -73.97853537753821 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785353775382 40.7674923683184)
1549 1549 -73.97779784978941 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9777978497894 40.7668620784309)
1685 1685 -73.96788229832741 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9678822983274 40.7802960985637)
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1 runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)
2044 2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2235 2235 -73.9748522796455 40.771958662100296 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9748522796455 40.7719586621003)
2278 2278 -73.96453903109901 40.78099163100121 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.964539031099 40.7809916310012)
2743 2743 -73.9587179613803 40.7992119571657 41A-PM-1007-01 41A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9587179613803 40.7992119571657)
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2900 2900 -73.9631005470369 40.788549405719294 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9631005470369 40.7885494057193)
82 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)
426 426 -73.9741944367138 40.7769889953596 13B-PM-1008-01 13B PM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on railing 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9741944367138 40.7769889953596)
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   1 0 1 0 1   1 1 0 0 0 0 1 0   POINT (-73.9547959269955 40.7925162926273)
1308 1308 -73.95603964408441 40.7945080361909 37E-AM-1013-01 37E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9560396440844 40.7945080361909)
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
1590 1590 -73.9610388059192 40.793952935840004 34B-PM-1007-01 34B PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610388059192 40.79395293584)
1689 1689 -73.9547031549299 40.797886753932204 41E-PM-1013-01 41E PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9547031549299 40.7978867539322)
2111 2111 -73.968446056806 40.785824818871 24A-PM-1007-01 24A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96844605680602 40.785824818871)
2224 2224 -73.9662310606968 40.7747758221226 14I-AM-1013-01 14I AM 10132018 1 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9662310606968 40.7747758221226)
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9617594316752 40.7946803725236)
2691 2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
2920 2920 -73.9657391918196 40.776502470347 16H-PM-1014-01 16H PM 10142018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9657391918196 40.776502470347)

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