2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Hectare Squirrel Number = 2, Highlight Fur Color = "Cinnamon, White" and Shift = "PM" sorted by Hectare Squirrel Number

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Quaas, Tail twitches, Approaches, Indifferent, Runs from

Shift ✖

Highlight Fur Color ✖

  • Cinnamon, White · 32 ✖

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
60 60 -73.9768674812942 40.7735232648872 8B-PM-1012-02 08B PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hiding in bushes 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768674812942 40.7735232648872)
119 119 -73.9592038887673 40.796382675378 38B-PM-1018-02 38B PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 burying nut 0 0 0 0 0 0 0 0   POINT (-73.9592038887673 40.796382675378)
155 155 -73.9522142360388 40.7949598486683 39H-PM-1013-02 39H PM 10132018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9522142360388 40.7949598486683)
246 246 -73.9779805668091 40.768093156679704 2D-PM-1012-02 02D PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9779805668091 40.7680931566797)
362 362 -73.9571407991577 40.793191739640605 35E-PM-1006-02 35E PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 begging for food POINT (-73.9571407991577 40.7931917396406)
679 679 -73.955018489069 40.7971235333699 40E-PM-1017-02 40E PM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.955018489069 40.7971235333699)
776 776 -73.9686816795392 40.775770422666994 14F-PM-1012-02 14F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9686816795392 40.775770422667)
787 787 -73.97251575343559 40.765837672923396 2I-PM-1006-02 02I PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9725157534356 40.7658376729234)
826 826 -73.95572635334891 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95572635334891 40.7939505791448)
938 938 -73.96994511963959 40.7710409982701 9H-PM-1018-02 09H PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9699451196396 40.7710409982701)
1086 1086 -73.9713399316534 40.77506780267571 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   0 0 1 0 0 lounging on tree upside down 0 0 0 0 1 0 1 0   POINT (-73.9713399316534 40.7750678026757)
1108 1108 -73.96383977903841 40.782895027290394 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 1 0 0 1 0 1 0 indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)
1123 1123 -73.9670858934045 40.7753505024976 14H-PM-1012-02 14H PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9670858934045 40.7753505024976)
1170 1170 -73.9647904085226 40.7911589002217 30A-PM-1020-02 30A PM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9647904085226 40.7911589002217)
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9704677007779 40.7786860108302)
1409 1409 -73.95815446824221 40.7958081306449 37C-PM-1013-02 37C PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9581544682422 40.7958081306449)
1552 1552 -73.9695655231393 40.769832465951296 8I-PM-1013-02 08I PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695655231393 40.7698324659513)
1847 1847 -73.9782283921819 40.766793260207706 1D-PM-1007-02 01D PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9782283921819 40.7667932602077)
1953 1953 -73.9644974196807 40.7810020292593 20G-PM-1013-02 20G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.96449741968071 40.7810020292593)
1954 1954 -73.9794840520702 40.7709595369804 4A-PM-1007-02 04A PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9794840520702 40.770959536980406)
2048 2048 -73.96276614653759 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9627661465376 40.7819356810575)
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
2086 2086 -73.9525627119429 40.793860286746394 38I-PM-1014-02 38I PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hanging out w/ Squirrel #1 0 0 0 0 0 scampering w/ squirrel #1 0 0 0 0 1 0 0 1   POINT (-73.9525627119429 40.7938602867464)
2229 2229 -73.9620719414292 40.788637452988 29D-PM-1010-02 29D PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9620719414292 40.788637452988)
2307 2307 -73.9736997033862 40.778497952406 14A-PM-1014-02 14A PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9736997033862 40.778497952406)
2500 2500 -73.9689703880705 40.7712025611298 9I-PM-1010-02 09I PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96897038807052 40.7712025611298)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2785 2785 -73.9729105002306 40.7672758037086 4H-PM-1006-02 04H PM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9729105002306 40.7672758037086)
2806 2806 -73.9714298880357 40.774105786890004 11E-PM-1012-02 11E PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714298880357 40.77410578689)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)
3022 3022 -73.9639941227864 40.7899152327912 29B-PM-1010-02 29B PM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639941227864 40.7899152327912)

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