2018_Central_Park_Squirrel_Census_-_Squirrel_Data

38 rows where Date = 10062018, Highlight Fur Color = "White" and Tail twitches = 0 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

Highlight Fur Color ✖

  • White · 38 ✖

Date ✖

  • 10062018 · 38 ✖
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
189 189 -73.9735489537928 40.76812579115229 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree 0 0 0 0 0 sitting in tree 0 0 0 0 0 0 1 0   POINT (-73.9735489537928 40.7681257911523)
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)
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
841 841 -73.97469338525721 40.773313866931 9C-PM-1006-05 09C PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1 w/ dog POINT (-73.9746933852572 40.773313866931)
921 921 -73.9698959071826 40.7716763799299 9H-AM-1006-05 09H AM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9698959071826 40.7716763799299)
1019 1019 -73.97042696309641 40.7722964640257 10G-AM-1006-09 10G AM 10062018 9 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704269630964 40.7722964640257)
1049 1049 -73.9564606426367 40.788054657260794 30I-PM-1006-06 30I PM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 1 ran up tree POINT (-73.9564606426367 40.7880546572608)
1107 1107 -73.95307395621309 40.7932034409546 37H-PM-1006-01 37H PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 from voice POINT (-73.95307395621312 40.7932034409546)
1204 1204 -73.97629653413091 40.775112516678 10A-AM-1006-02 10A AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE Bridle Path lawn 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9762965341309 40.775112516678)
1302 1302 -73.9704024529864 40.772925606388895 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0 chasing (#3) 1 0 0 0 0 0 0 0   POINT (-73.9704024529864 40.7729256063889)
1305 1305 -73.9569324958684 40.7877748374259 30I-PM-1006-01 30I PM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 sitting there 0 0 0 0 0 0 0 1   POINT (-73.9569324958684 40.78777483742591)
1358 1358 -73.9693772461788 40.770687589290105 8I-AM-1006-03 08I AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693772461788 40.7706875892901)
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9692401421068 40.7707128895661)
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)
1617 1617 -73.97520295136441 40.767173466736104 3F-AM-1006-04 03F AM 10062018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on a rock 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9752029513644 40.7671734667361)
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)
1659 1659 -73.96904988769441 40.7700011818847 8I-AM-1006-07 08I AM 10062018 7 Adult Gray White Gray+White White ring on short tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690498876944 40.7700011818847)
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)
1745 1745 -73.9688438058715 40.7703014325728 8I-AM-1006-05 08I AM 10062018 5 Adult Gray White Gray+White   Above Ground 20 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9688438058715 40.7703014325728)
1756 1756 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 10062018 13 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9755041276839 40.7678213857557)
1779 1779 -73.9695560376915 40.7708835103516 9H-AM-1006-03 09H AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96955603769152 40.7708835103516)
1783 1783 -73.9730001080547 40.7678719218983 4G-AM-1006-05 04G AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 0 0 climbing (tree) 0 0 0 0 0 0 1 0 indifferent—was in front of my face (we were on a bridge)! POINT (-73.9730001080547 40.7678719218983)
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)
1999 1999 -73.95498609472341 40.79115503283089 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9549860947234 40.7911550328309)
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)
2087 2087 -73.956502663005 40.788160908881004 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.956502663005 40.788160908881)
2103 2103 -73.9782983634755 40.766831436426294 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782983634755 40.7668314364263)
2191 2191 -73.9734108731087 40.767605139269705 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9734108731087 40.7676051392697)
2298 2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2331 2331 -73.9694681803635 40.770585795359004 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694681803635 40.770585795359)
2397 2397 -73.9704592500888 40.772962887933005 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704592500888 40.772962887933)
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)
2542 2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)
2547 2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2605 2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)
2811 2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579292340076 40.7976287835027)
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)

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