2018_Central_Park_Squirrel_Census_-_Squirrel_Data

26 rows where Hectare Squirrel Number = 8 and Highlight Fur Color = "Cinnamon" sorted by Unique Squirrel ID

View and edit SQL

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

Highlight Fur Color

  • Cinnamon · 26

Hectare Squirrel Number

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
2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9710116801402 40.7723689301989)
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)
758 -73.9703621616472 40.775032271482 12E-AM-1017-08 12E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 0 1 0 chilling 0 0 0 0 0 0 1 0   POINT (-73.9703621616472 40.775032271482)
1404 -73.9700666654946 40.774285704258105 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 stared POINT (-73.9700666654946 40.7742857042581)
122 -73.9712527809516 40.7763310392591 13D-AM-1014-08 13D AM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9712527809516 40.7763310392591)
350 -73.9707471099503 40.7759255131734 13E-AM-1017-08 13E AM 10172018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9707471099503 40.7759255131734)
2023 -73.9663977261879 40.775645134229 14H-PM-1012-08 14H PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9663977261879 40.775645134229)
1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
2369 -73.9801956082236 40.767836440957 1B-AM-1012-08 01B AM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9801956082236 40.767836440957)
2223 -73.9784863123685 40.7669225020831 1D-AM-1006-08 01D AM 10062018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 45   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9784863123685 40.7669225020831)
827 -73.97002473508999 40.78369290444589 21A-AM-1019-08 21A AM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97002473509 40.7836929044459)
899 -73.97927540372909 40.7679690700399 2C-AM-1010-08 02C AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 stay on side of trunk 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9792754037291 40.7679690700399)
1757 -73.9601561064548 40.7900513933531 31E-PM-1006-08 31E PM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9601561064548 40.7900513933531)
956 -73.9581173730857 40.795477217054895 37D-PM-1014-08 37D PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9581173730857 40.7954772170549)
2710 -73.9577919365342 40.796085328505896 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 0 1   POINT (-73.9577919365342 40.7960853285059)
1880 -73.9562362816756 40.7950457218996 38E-AM-1010-08 38E AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9562362816756 40.7950457218996)
191 -73.9787105069657 40.7693708133873 3B-AM-1010-08 03B AM 10102018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0 together w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9787105069657 40.7693708133873)
2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9754709117681 40.7681421869407)
1761 -73.9575307970434 40.798317641948294 40B-PM-1014-08 40B PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9575307970434 40.7983176419483)
1285 -73.97051151894291 40.769839557706796 7H-AM-1006-08 07H AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705115189429 40.7698395577068)
1060 -73.97288710611909 40.771298365894395 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9728871061191 40.7712983658944)
476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree 0 0 0 0 0   1 1 0 0 0 0 0 0 not backing down POINT (-73.9690968160819 40.769923269444)
2047 -73.9721656413591 40.7722869065638 9F-PM-1014-08 09F PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 turned to face me while eating POINT (-73.9721656413591 40.7722869065638)
1726 -73.9686479277215 40.7705815354769 9I-AM-1014-08 09I AM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9686479277215 40.7705815354769)

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