2018_Central_Park_Squirrel_Census_-_Squirrel_Data

24 rows where Climbing = 1, Highlight Fur Color = "Gray" and Indifferent = 0 sorted by Primary Fur Color

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Running, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from

Above Ground Sighter Measurement

Foraging

  • 0 19
  • 1 5

Highlight Fur Color

  • Gray · 24

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
391 -73.97908754803579 40.767610478065706 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9790875480358 40.7676104780657)
858 -73.96293834202741 40.7889383725489 29C-AM-1007-02 29C AM 10072018 2 Adult Black Gray Black+Gray   Above Ground 10   1 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.9629383420274 40.7889383725489)
257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area 1 0 1 0 0 climbing (rock) 0 0 0 0 0 1 0 0 approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)
384 -73.968045072743 40.783662671722496 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   0 0 1 0 1   1 0 0 1 0 0 0 1   POINT (-73.968045072743 40.7836626717225)
470 -73.95812430217221 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1 avoiding a dog POINT (-73.95812430217221 40.794431473386)
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)
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)
552 -73.9625416200877 40.7811302397912 21H-AM-1017-02 21H AM 10172018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9625416200877 40.78113023979121)
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)
625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.97642353733221 40.770606513989)
789 -73.9675023138703 40.7872554700995 25A-PM-1007-01 25A PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 40 tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9675023138703 40.7872554700995)
852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   1 0 1 0 0 hopping 0 0 0 0 0 1 0 1   POINT (-73.9609704650925 40.7938786854735)
1081 -73.9680855277775 40.7769251965381 15F-AM-1007-10 15F AM 10072018 10 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9680855277775 40.7769251965381)
1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9587072763996 40.7850256219415)
1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 1 me! POINT (-73.9527196716568 40.792363826828)
1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0 stared at me POINT (-73.9638167248251 40.77764856793541)
1891 -73.9749641575871 40.767330505627704 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9749641575871 40.7673305056277)
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)
2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
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)
2927 -73.96501200660741 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9650120066074 40.78059328824071)

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