2018_Central_Park_Squirrel_Census_-_Squirrel_Data

31 rows where Foraging = 0, Highlight Fur Color = "Cinnamon" and Tail flags = 1 sorted by Age

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail flags ✖

Highlight Fur Color ✖

  • Cinnamon · 31 ✖

Foraging ✖

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
727 727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9634563222926 40.780992836417)
2142 2142 -73.95985354257058 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0 hanging on fence 1 0 0 1 0 0 0 1   POINT (-73.9598535425706 40.7915589343685)
38 38 -73.9742073452913 40.7757957380463 12B-AM-1007-01 12B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9742073452913 40.7757957380463)
78 78 -73.964474836001 40.7883840104749 28C-PM-1006-01 28C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 gathering acorns 0 0 0 1 0 0 0 1 gnd to tree POINT (-73.964474836001 40.7883840104749)
94 94 -73.9641971813967 40.781353795943495 21G-PM-1007-01 21G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9641971813967 40.7813537959435)
133 133 -73.9664711607022 40.787896428768 26A-PM-1006-06 26A PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Tree 90th left 90th & 89 0 0 1 0 0   0 0 0 1 0 0 0 0 studying us looking for food POINT (-73.9664711607022 40.787896428768)
193 193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9537691298752 40.7941272599797)
210 210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
234 234 -73.9741401377844 40.7758134257881 12B-AM-1007-02 12B AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9741401377844 40.7758134257881)
416 416 -73.9702788578386 40.7694484997295 7I-PM-1013-05 07I PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9702788578386 40.7694484997295)
583 583 -73.9612398509782 40.7950033150385 35A-PM-1013-12 35A PM 10132018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9612398509782 40.7950033150385)
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)
1007 1007 -73.96353178229771 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   1 0 0 1 0 0 1 0   POINT (-73.9635317822977 40.7821352080233)
1059 1059 -73.97494575169209 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9749457516921 40.7676712372245)
1174 1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 1 0 1 0 0 approaches (very close) POINT (-73.9682067129876 40.7779911208015)
1235 1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 jumping back & forth on tree 0 0 0 1 1 0 1 0   POINT (-73.9679686793869 40.7825993867876)
1333 1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0 laying on tree branch 0 0 0 1 1 0 0 0   POINT (-73.9754527701832 40.7656088463928)
1367 1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542684235907 40.7944237164092)
1368 1368 -73.95427708888809 40.794361036685295 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542770888881 40.79436103668531)
1481 1481 -73.95388671863759 40.794140943400706 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9538867186376 40.7941409434007)
1815 1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1995 1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
2217 2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   1 0 0 0 0 watching 0 0 0 1 0 0 0 1   POINT (-73.96527464775211 40.7809326848536)
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
2463 2463 -73.9653343572865 40.77752869246171 17H-PM-1007-01 17H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 1 0   0 0 0 1 0 0 0 1   POINT (-73.9653343572865 40.7775286924617)
2569 2569 -73.9559663734409 40.794582826137706 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9559663734409 40.7945828261377)
2923 2923 -73.9672160533827 40.7830263908749 21C-AM-1014-05 21C AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9672160533827 40.7830263908749)
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)
2980 2980 -73.97164145863809 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 running (from birds) 0 0 0 1 0 0 1 0   POINT (-73.9716414586381 40.771760114722)
1531 1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
2134 2134 -73.9614373639552 40.7945051962914 35B-PM-1013-01 35B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 did not notice dog sitting a few yards away (10-20 ft) 0 0 0 1 0 0 1 0   POINT (-73.9614373639552 40.7945051962914)

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