2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Highlight Fur Color = "Gray" and Tail twitches = 1 sorted by Lat/Long

View and edit SQL

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, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Tail twitches

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 ▼
2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0 cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)
2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
2244 -73.9509628195532 40.797777567417796 42H-PM-1014-01 42H PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9509628195532 40.7977775674178)
3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9528482858163 40.7922056218325)
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
2746 -73.95614328368629 40.798266534723396 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9561432836863 40.7982665347234)
2454 -73.9565151662506 40.794664798744705 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 me POINT (-73.9565151662506 40.7946647987447)
298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
1473 -73.9584064190878 40.7912992852442 33F-PM-1012-03 33F PM 10122018 3 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9584064190878 40.7912992852442)
2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2255 -73.96429678758571 40.78156523539371 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9642967875857 40.7815652353937)
588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9647845655965 40.7816573808695)
506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649611089685 40.7814371834837)
987 -73.96498278073409 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649827807341 40.7817322832767)
2156 -73.96503878480009 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9650387848001 40.7814134438394)
534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9650499507011 40.7908191782173)
1725 -73.96574800660741 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9657480066074 40.7753465489231)
2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.968381325559 40.7780143443779)
2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9694382427984 40.7846350692923)
2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 1 0 0   POINT (-73.9698870647042 40.7826510985538)
2938 -73.97033289561999 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97033289562 40.7701079697795)
1296 -73.97055091705421 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9705509170542 40.7689416540228)
1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9710187505339 40.7797265666746)
2999 -73.972415182837 40.773080463452004 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.972415182837 40.773080463452)
2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)
2467 -73.9755923256429 40.7672967972471 3F-PM-1013-02 03F PM 10132018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.97559232564292 40.7672967972471)
748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756603846107 40.7672531319384)
423 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756754297747 40.7738518843446)
905 -73.9757216124349 40.7754310239649 11A-PM-1013-05 11A PM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1 digging 0 0 0 0 1 0 0 0   POINT (-73.9757216124349 40.7754310239649)
432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9757787135906 40.7737231427345)
1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1492 -73.9807078515193 40.768333529264204 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9807078515193 40.7683335292642)

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.726ms