2018_Central_Park_Squirrel_Census_-_Squirrel_Data

32 rows where Highlight Fur Color = "Cinnamon", Runs from = 1 and Tail twitches = 1 sorted by Kuks

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, Approaches, Indifferent

Tail twitches

Runs from

Highlight Fur Color

  • Cinnamon · 32
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 -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)
232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 1 approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)
312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.958356112357 40.796014459571)
403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
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)
522 -73.97738211356109 40.769045349438294 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches 0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9773821135611 40.7690453494383)
533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #6 0 0 0 0 1 0 0 1   POINT (-73.9559677963727 40.7951124076946)
628 -73.96001657854859 40.795246676183204 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9600165785486 40.7952466761832)
641 -73.97190362174459 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719036217446 40.7803588122409)
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)
697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
720 -73.9669814346326 40.780390919948 19E-PM-1018-01 19E PM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9669814346326 40.780390919948)
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)
837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.967767372181 40.784702631615)
1159 -73.9682129261841 40.77542323581179 14G-AM-1012-03 14G AM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9682129261841 40.7754232358118)
1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9716736557408 40.7749333494336)
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)
1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
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)
1896 -73.973998077367 40.773902913391105 10C-PM-1013-01 10C PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.973998077367 40.7739029133911)
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)
2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2342 -73.9533645762606 40.7983709215535 42F-AM-1019-01 42F AM 10192018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 0 1 runs from (me) POINT (-73.9533645762606 40.7983709215535)
2472 -73.9596820155238 40.7932886803231 34D-PM-1007-03 34D PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9596820155238 40.7932886803231)
2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9687020800791 40.7735903424522)
2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 climbed tree (oak) 0 0 0 0 1 0 0 1   POINT (-73.9654409838612 40.7901338748522)
3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)
2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)

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