2018_Central_Park_Squirrel_Census_-_Squirrel_Data

30 rows where Eating = 1, Hectare Squirrel Number = 3 and Highlight Fur Color = "Cinnamon" sorted by Age

View and edit SQL

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Highlight Fur Color

  • Cinnamon · 30

Hectare Squirrel Number

Eating

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
577 -73.9497217674555 40.796517007214 42I-PM-1014-03 42I PM 10142018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9497217674555 40.796517007214)
2954 -73.9677474313377 40.7742119240825 12H-PM-1007-03 12H PM 10072018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0 peanuts 0 0 0 0 0 0 1 0   POINT (-73.9677474313377 40.7742119240825)
124 -73.9588660250232 40.7982597947515 40A-AM-1010-03 40A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE bottom of great hill 0 0 0 1 1   0 0 0 1 0 0 1 1 dog chased POINT (-73.9588660250232 40.7982597947515)
154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9686056085297 40.7781658424866)
220 -73.96718161220299 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.967181612203 40.7787752287055)
418 -73.9573604880421 40.7930844158021 35E-PM-1006-03 35E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9573604880421 40.7930844158021)
460 -73.9549135206961 40.798525897229 42D-PM-1013-03 42D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9549135206961 40.798525897229)
591 -73.95433237868879 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 1 0 lying on belly on branch,eating big nut 0 0 0 0 0 0 0 0   POINT (-73.9543323786888 40.7943086530436)
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
830 -73.95956459625391 40.7899599350145 31E-PM-1006-03 31E PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bushes 0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9595645962539 40.7899599350145)
878 -73.9757215415855 40.766820597698604 2F-PM-1014-03 02F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9757215415855 40.7668205976986)
962 -73.97154668503241 40.7695584933538 6H-PM-1020-03 06H PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (kids kicking the fence) POINT (-73.9715466850324 40.7695584933538)
1250 -73.9585133340331 40.796372167947396 38C-PM-1014-03 38C PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   1 0 0 0 0 0 0 1   POINT (-73.9585133340331 40.7963721679474)
1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
1586 -73.9714150090362 40.7774976423922 14C-PM-1006-03 14C PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9714150090362 40.7774976423922)
1664 -73.97291429122029 40.772409114667795 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729142912203 40.7724091146678)
2063 -73.95447632818859 40.7969645476349 40F-PM-1006-03 40F PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9544763281886 40.7969645476349)
2109 -73.9744488584414 40.7741627220859 10C-PM-1013-03 10C PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9744488584414 40.7741627220859)
2110 -73.9647151303629 40.7912681060756 30A-PM-1020-03 30A PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9647151303629 40.7912681060756)
2127 -73.9562442622553 40.7957285542564 38E-AM-1010-03 38E AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9562442622553 40.7957285542564)
2290 -73.95656457165641 40.795903994957705 38D-PM-1006-03 38D PM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9565645716564 40.795903994957705)
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)
2573 -73.9810149147578 40.7683925377714 2A-AM-1010-03 02A AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on trunk 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9810149147578 40.7683925377714)
2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
2957 -73.97473131521521 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9747313152152 40.7653888351839)
23 -73.9638179439747 40.7924173263904 32A-PM-1013-03 32A PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9638179439747 40.7924173263904)
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1620 -73.96356061997841 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9635606199784 40.782206970617)
2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass 0 0 0 1 0 eating (nuts) 0 0 0 0 0 1 0 0 approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)
2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)

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