2018_Central_Park_Squirrel_Census_-_Squirrel_Data

155 rows where Tail flags = 1 sorted by Date

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 51
  • 1 4

Kuks ✖

  • 0 49
  • 1 6

Tail flags ✖

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
815 815 -73.9753283783695 40.7733043910649 8C-PM-1013-02 08C PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9753283783695 40.7733043910649)
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9635028497015 40.7928207574906)
1011 1011 -73.97191114701641 40.7758789855474 12D-AM-1013-02 12D AM 10132018 2 Adult Gray   Gray+   Above Ground 7 Was on top of the edge of Bow Bridge 0 0 0 0 0 jumped off 0 0 0 1 0 0 0 1   POINT (-73.9719111470164 40.7758789855474)
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552035011902 40.7889851896334)
1058 1058 -73.97371007431829 40.7708360121735 7E-PM-1013-03 07E PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Ground & Tree Base 0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9737100743183 40.7708360121735)
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)
1188 1188 -73.9669529835992 40.787186415136496 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO 1 0 1 0 0 d.p.t. 0 0 0 1 1 0 1 0 calm POINT (-73.96695298359921 40.7871864151365)
1198 1198 -73.9762187733662 40.7739282973004 9B-PM-1013-08 09B PM 10132018 8 Juvenile Cinnamon Black, White Cinnamon+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762187733662 40.7739282973004)
1403 1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9761632586697 40.7741085606149)
1636 1636 -73.97014086231209 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass 1 0 0 1 0   0 0 0 1 0 0 0 0   POINT (-73.9701408623121 40.7695511718541)
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9751056714758 40.7732060035215)
1967 1967 -73.96472472541271 40.780613656578396 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9647247254127 40.7806136565784)
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)
2505 2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762974698771 40.7740076116964)
2672 2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9614599022015 40.7945181285991)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2705 2705 -73.9748962681637 40.76787782717 4F-PM-1013-02 04F PM 10132018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9748962681637 40.76787782717)
2992 2992 -73.9746063250438 40.7687654196811 4F-PM-1013-03 04F PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9746063250438 40.7687654196811)
614 614 -73.9642411990432 40.7779692777193 18H-PM-1014-03 18H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9642411990432 40.7779692777193)
784 784 -73.9649658099293 40.782326236907394 22F-PM-1014-03 22F PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649658099293 40.7823262369074)
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)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
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)
2857 2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649230271173 40.7821766215675)
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)
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)
770 770 -73.95977827620291 40.79207733767571 33D-AM-1017-07 33D AM 10172018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9597782762029 40.7920773376757)
1818 1818 -73.956863563379 40.798641885114705 41C-AM-1017-01 41C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.95686356337902 40.7986418851147)
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)
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)
1415 1415 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)
1509 1509 -73.9556450015702 40.796718805800204 39E-AM-1018-04 39E AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9556450015702 40.7967188058002)
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)
2294 2294 -73.96308205774409 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9630820577441 40.7821632293136)
2444 2444 -73.966590487009 40.780246905289104 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.96659048700901 40.7802469052891)
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2876 2876 -73.95589957376541 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9558995737654 40.7960097734603)
2966 2966 -73.9630596103391 40.792572062055605 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9630596103391 40.7925720620556)
855 855 -73.9808247660048 40.76894088312871 2A-PM-1019-01 02A PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 runs from 0 0 0 1 0 0 0 1   POINT (-73.9808247660048 40.7689408831287)
1175 1175 -73.9803282698463 40.7680809889384 1B-PM-1019-09 01B PM 10192018 9 Adult Gray White Gray+White   Ground Plane FALSE Tree to ground 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9803282698463 40.7680809889384)
1956 1956 -73.98089749771201 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.980897497712 40.7690578709841)
2203 2203 -73.97105314852979 40.7773757069445 14D-PM-1019-06 14D PM 10192018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.97105314852982 40.777375706944504)
2295 2295 -73.9590632051055 40.79631465848271 38B-AM-1019-04 38B AM 10192018 4 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 sitting in tree 1 1 0 1 0 0 1 0 observant POINT (-73.9590632051055 40.7963146584827)
2335 2335 -73.9704679459444 40.7773384236212 14D-PM-1019-10 14D PM 10192018 10 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704679459444 40.7773384236212)
2588 2588 -73.95810074370941 40.795940311272204 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   0 0 1 0 0   1 0 0 1 0 0 1 0   POINT (-73.9581007437094 40.7959403112722)
74 74 -73.95466541841459 40.7947639241491 38G-PM-1020-09 38G PM 10202018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 1 0   POINT (-73.9546654184146 40.7947639241491)
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)
316 316 -73.9540616660191 40.795155660324504 38G-PM-1020-10 38G PM 10202018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9540616660191 40.7951556603245)
1218 1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.953375642605 40.7947144477885)
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)
1514 1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   1 0 0 1 0 0 1 0   POINT (-73.9548006161673 40.7945503341011)
2348 2348 -73.9531965469704 40.794743798397704 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 1 1 0   POINT (-73.9531965469704 40.7947437983977)
2759 2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9543373703455 40.7943889087123)

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