2018_Central_Park_Squirrel_Census_-_Squirrel_Data

33 rows where Hectare Squirrel Number = 2, Highlight Fur Color = "Cinnamon" and Runs from = 1 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

Eating ✖

  • 0 25
  • 1 8

Runs from ✖

Highlight Fur Color ✖

  • Cinnamon · 33 ✖

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
209 209 -73.97107601968679 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9710760196868 40.7725506006789)
250 250 -73.97267476660019 40.77030226693079 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 see stories and locations POINT (-73.9726747666002 40.7703022669308)
292 292 -73.9674069524601 40.7772529662424 16F-PM-1013-02 16F PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Woods 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9674069524601 40.7772529662424)
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
513 513 -73.96310068980699 40.7920255189467 32B-AM-1017-02 32B AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on its head Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.963100689807 40.79202551894671)
615 615 -73.96532790698879 40.7758743113817 15I-AM-1008-02 15I AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon Could be same squirrel as #1? Above Ground 4 on fence 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653279069888 40.7758743113817)
650 650 -73.98096101171708 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9809610117171 40.7683896665502)
779 779 -73.9745305540008 40.7742043234014 10C-PM-1013-02 10C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9745305540008 40.7742043234014)
972 972 -73.9704591091677 40.7729175143429 10G-AM-1006-02 10G AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon notch on tail Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9704591091677 40.7729175143429)
993 993 -73.97724226646571 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9772422664657 40.773436329163)
1134 1134 -73.9716995507598 40.7797671327739 16B-AM-1014-02 16B AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9716995507598 40.7797671327739)
1186 1186 -73.96740331258341 40.7769132902037 15G-PM-1019-02 15G PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9674033125834 40.7769132902037)
1332 1332 -73.97749282457809 40.7720464606979 6B-AM-1012-02 06B AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE by bike racks at Tavern on the Green 0 0 0 0 1 walking,exploring - digging in flower bed 0 0 0 0 0 0 0 1   POINT (-73.9774928245781 40.7720464606979)
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9735655529245 40.7716072681474)
1472 1472 -73.9698611971209 40.7753915552001 13F-PM-1008-02 13F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9698611971209 40.7753915552001)
1635 1635 -73.95607317386771 40.798033601855394 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9560731738677 40.7980336018554)
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733898487296 40.7666975131518)
2137 2137 -73.96488316116292 40.780132641497296 19G-PM-1017-02 19G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 patting ground 0 0 0 0 1 0 0 1   POINT (-73.9648831611629 40.7801326414973)
2337 2337 -73.9673490137465 40.778272813040104 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9673490137465 40.7782728130401)
2426 2426 -73.9790203973636 40.768883711483205 3B-AM-1010-02 03B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 together w/ #3 0 0 0 0 0 0 0 1   POINT (-73.9790203973636 40.7688837114832)
2432 2432 -73.9657203199746 40.775173008911 14I-PM-1018-02 14I PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9657203199746 40.775173008911)
2615 2615 -73.97346051766459 40.7686218881386 5G-PM-1010-02 05G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9734605176646 40.7686218881386)
372 372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9781303869038 40.7725000348875)
504 504 -73.95334760207359 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree 1 0 1 0 1   1 0 0 0 0 0 0 1 dogs POINT (-73.9533476020736 40.7933003544685)
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685227310735 40.776599466588)
738 738 -73.9725712588741 40.7669101832926 4H-AM-1006-02 04H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 climbing (over small wire fence then on the ground) 0 0 0 0 0 1 0 1 approaches (saw me & came forward),runs from (startled by another person) POINT (-73.9725712588741 40.7669101832926)
760 760 -73.97182341595571 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 1 burying 0 0 0 1 0 0 0 1   POINT (-73.9718234159557 40.7810842503715)
808 808 -73.97168818386709 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9716881838671 40.778553537087)
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
1698 1698 -73.9631392113757 40.791463563578404 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 1 0 0 chasing #1 and climbing tree w/ #1 0 0 0 0 0 0 0 1   POINT (-73.9631392113757 40.7914635635784)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
2968 2968 -73.9587236619579 40.799185018043396 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West 1 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9587236619579 40.7991850180434)

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