2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Climbing = 1, Hectare Squirrel Number = 4 and Shift = "AM" sorted by longitude

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 27
  • 1 3

Moans ✖

  • 0 30

Hectare Squirrel Number ✖

Climbing ✖

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
1365 1365 -73.9791648157033 40.767625444347 2C-AM-1010-04 02C AM 10102018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9791648157033 40.767625444347)
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)
1675 1675 -73.97774976458341 40.767734470917794 2D-AM-1007-04 02D AM 10072018 4 Adult Gray   Gray+   Above Ground 100   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9777497645834 40.7677344709178)
2248 2248 -73.9766477027266 40.7712737417779 6C-AM-1007-04 06C AM 10072018 4 Adult Gray   Gray+   Above Ground 20   0 1 1 0 0 chasing #5 0 0 0 0 0 0 1 0   POINT (-73.9766477027266 40.7712737417779)
2988 2988 -73.9766342759486 40.7687518380873 4D-AM-1012-04 04D AM 10122018 4 Adult Gray   Gray+   Above Ground 3 on tree trunk 0 1 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9766342759486 40.7687518380873)
1729 1729 -73.97650461090191 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765046109019 40.7736674124746)
2450 2450 -73.9756273257684 40.7706539186221 6D-AM-1008-04 06D AM 10082018 4 Adult Gray   Gray+   Above Ground     0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9756273257684 40.7706539186221)
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9752915601718 40.7739329570033)
1790 1790 -73.97305925481159 40.7740879251541 10D-AM-1008-04 10D AM 10082018 4 Juvenile Gray   Gray+   Above Ground 25   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730592548116 40.7740879251541)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
2634 2634 -73.96956851864891 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9695685186489 40.7788293026327)
2754 2754 -73.9687025912431 40.7719319822619 10H-AM-1014-04 10H AM 10142018 4 Juvenile     +   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687025912431 40.7719319822619)
1053 1053 -73.96858597054859 40.784880506532204 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685859705486 40.7848805065322)
1828 1828 -73.9682965197661 40.780537896388296 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9682965197661 40.7805378963883)
2790 2790 -73.9673554935258 40.782752724959394 21C-AM-1014-04 21C AM 10142018 4 Adult     + High in tree, unable to tell Above Ground 60   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.96735549352582 40.7827527249594)
2404 2404 -73.96653096896159 40.7775271020244 16G-AM-1010-04 16G AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665309689616 40.7775271020244)
511 511 -73.9653142636891 40.776001512929795 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653142636891 40.7760015129298)
2607 2607 -73.9642988690682 40.779559128197896 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 1 runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)
1518 1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632265832593 40.78169144754611)
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9624538733037 40.7883829851518)
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623696148045 40.792184861375)
2449 2449 -73.9599911537509 40.791445254284504 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9599911537509 40.7914452542845)
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
1591 1591 -73.95762233900821 40.79797466396471 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 1 0   POINT (-73.9576223390082 40.79797466396471)
1280 1280 -73.9562469727195 40.79685907654 39D-AM-1008-04 39D AM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562469727195 40.79685907654)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
1449 1449 -73.95611248920629 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   0 0 1 1 0   1 0 0 0 0 0 0 1   POINT (-73.9561124892063 40.7949440648632)
631 631 -73.95488778301359 40.795015748910295 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95488778301362 40.7950157489103)
1993 1993 -73.9546367558712 40.789840987798 33I-AM-1008-04 33I AM 10082018 4 Adult     +   Above Ground 100   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9546367558712 40.789840987798)
1227 1227 -73.9527924755398 40.79343662605329 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9527924755398 40.7934366260533)

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