2018_Central_Park_Squirrel_Census_-_Squirrel_Data

121 rows where Eating = 1, Highlight Fur Color = "White" and Tail twitches = 0 sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

Highlight Fur Color ✖

  • White · 21 ✖

Eating ✖

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 ▼
1650 1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
1158 1158 -73.97638947595429 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9763894759543 40.7705523372364)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
2317 2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
199 199 -73.97716146866159 40.770967798324705 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9771614686616 40.7709677983247)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)
1827 1827 -73.97797608743551 40.769823093658296 4C-PM-1010-16 04C PM 10102018 16 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9779760874355 40.7698230936583)
986 986 -73.978400938697 40.7677411911854 2C-PM-1013-03 02C PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.978400938697 40.7677411911854)
1983 1983 -73.97841448676391 40.771817766751106 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9784144867639 40.7718177667511)
407 407 -73.9787658435198 40.768941976539296 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 eating loudly <- peanuts w/ shells 0 0 0 0 0 0 1 0   POINT (-73.9787658435198 40.7689419765393)
741 741 -73.9790214253443 40.7686791169776 3B-PM-1007-10 03B PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 hopping 0 0 0 0 0 0 1 0   POINT (-73.9790214253443 40.7686791169776)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
2701 2701 -73.97912175106559 40.767658347539395 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9791217510656 40.7676583475394)
704 704 -73.97935655643609 40.767925939044794 2C-AM-1010-09 02C AM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 climbed up tree as i neared POINT (-73.9793565564361 40.7679259390448)
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9793952066038 40.77078376578591)
495 495 -73.9801007327506 40.7677455633932 1B-PM-1019-06 01B PM 10192018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801007327506 40.7677455633932)
2116 2116 -73.9801562527339 40.76872673271129 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9801562527339 40.7687267327113)
1001 1001 -73.9801985977846 40.768015951170504 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0 fighting w/ pigeons 0 0 0 0 0 0 1 0   POINT (-73.9801985977846 40.7680159511705)
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)
1582 1582 -73.9804065254162 40.7681481183296 1B-PM-1019-08 01B PM 10192018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9804065254162 40.7681481183296)
2482 2482 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)

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