2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Above Ground Sighter Measurement = 12 sorted by Age

View and edit SQL

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Hectare Squirrel Number

Above Ground Sighter Measurement

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
189 -73.9735489537928 40.76812579115229 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree 0 0 0 0 0 sitting in tree 0 0 0 0 0 0 1 0   POINT (-73.9735489537928 40.7681257911523)
96 -73.9708549670788 40.7699587019058 7H-PM-1006-04 07H PM 10062018 4 Adult Gray   Gray+   Above Ground 12 on tree knob 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9708549670788 40.7699587019058)
352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
1095 -73.9735547926323 40.772342007610796 8D-AM-1007-02 08D AM 10072018 2 Adult Gray   Gray+   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735547926323 40.7723420076108)
1225 -73.95848035139392 40.7933802077327 35D-PM-1013-01 35D PM 10132018 1 Adult Gray White Gray+White   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584803513939 40.7933802077327)
1420 -73.9647605121306 40.780396153151706 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree 1 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9647605121306 40.7803961531517)
2114 -73.9651541395415 40.7798283208748 19G-PM-1017-01 19G PM 10172018 1 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 0 0 watching 0 0 0 0 0 1 0 0   POINT (-73.9651541395415 40.7798283208748)
2190 -73.9657040391563 40.7755567428199 15I-AM-1008-06 15I AM 10082018 6 Adult Cinnamon White Cinnamon+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9657040391563 40.7755567428199)
2222 -73.9639048209454 40.777737334555795 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639048209454 40.7777373345558)
2521 -73.976869549792 40.770698245472296 5C-AM-1006-04 05C AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 12 thin branch of tree 0 0 0 0 0 relaxing 0 0 0 1 0 0 1 0   POINT (-73.976869549792 40.7706982454723)
2640 -73.9788304714091 40.7696373635315 4B-AM-1010-06 04B AM 10102018 6 Adult Gray   Gray+   Above Ground 12   1 0 0 0 0 running from squirrel #5 0 0 0 0 0 0 0 0   POINT (-73.9788304714091 40.7696373635315)
2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2811 -73.97568897660891 40.7676078308589 3F-AM-1006-14 03F AM 10062018 14 Adult Gray White Gray+White   Above Ground 12   1 0 1 0 0 running from dog 0 0 0 0 0 0 0 1   POINT (-73.9756889766089 40.7676078308589)
399 -73.97634332024009 40.773847349068106 9B-PM-1013-10 09B PM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763433202401 40.7738473490681)
856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.95916671628011 40.7937602121568)
2783 -73.97917671562679 40.7714445258765 5A-AM-1006-02 05A AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 12 in tall shrubs near wall next to CPW 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9791767156268 40.7714445258765)

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