2018_Central_Park_Squirrel_Census_-_Squirrel_Data

127 rows where Highlight Fur Color = "White" and Runs from = 1 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 22
  • 1 5

Shift ✖

Runs from ✖

Highlight Fur Color ✖

  • White · 27 ✖
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
940 940 -73.9700879096644 40.7765899724756 14E-PM-1017-05 14E PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9700879096644 40.7765899724756)
1054 1054 -73.9570050460867 40.7985192250745 40C-AM-1017-05 40C AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9570050460867 40.7985192250745)
1502 1502 -73.97052548010001 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1 acknowledges POINT (-73.9705254801 40.7763606494306)
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)
2352 2352 -73.9727310397798 40.778701677351705 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree 0 0 1 1 1 digging,chewing on tree—has nut in mouth! 0 0 0 0 0 0 0 1   POINT (-73.97273103977982 40.7787016773517)
258 258 -73.9534333425633 40.793256416332795 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries 0 0 0 1 0   0 1 0 0 0 0 0 1   POINT (-73.9534333425633 40.7932564163328)
627 627 -73.97637911214379 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   0 1 0 0 0 chasing (dog chasing) 0 0 0 0 0 0 0 1   POINT (-73.9763791121438 40.770281512254)
865 865 -73.9741621946917 40.775248147202504 11C-PM-1018-01 11C PM 10182018 1 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9741621946917 40.7752481472025)
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)
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)
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)
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)
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)
855 855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
1185 1185 -73.95823067436599 40.7989268396525 40B-AM-1019-08 40B AM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 1   POINT (-73.958230674366 40.7989268396525)
1381 1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
1410 1410 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.97202898636661 40.7763749561607)
1540 1540 -73.957710975899 40.79840556140471 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.957710975899 40.7984055614047)
1758 1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9581241870185 40.7961057536141)
1759 1759 -73.9576219570858 40.79633512256721 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9576219570858 40.7963351225672)
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)
1986 1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.958247706428 40.7989079136796)
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)
2168 2168 -73.95823634371351 40.7987752300505 40B-AM-1019-06 40B AM 10192018 6 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9582363437135 40.7987752300505)
410 410 -73.9584024936392 40.785149170194394 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1 runs from (us) POINT (-73.9584024936392 40.7851491701944)
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 1 0 0 0 0 0 1   POINT (-73.9541837143178 40.7944340477396)

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