2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Hectare Squirrel Number = 11 and Indifferent = 1 sorted by Color notes

View and edit SQL

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

Chasing

  • 0 16
  • 1 4

Indifferent

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
183 -73.9768434635084 40.772849403874396 7B-AM-1008-11 07B AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9768434635084 40.7728494038744)
596 -73.9769319450348 40.7743883576247 9A-AM-1013-11 09A AM 10132018 11 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE foot of tree 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9769319450348 40.7743883576247)
734 -73.9714921188372 40.776758371867 14D-AM-1014-11 14D AM 10142018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714921188372 40.776758371867)
952 -73.9699763667769 40.775706073102604 13E-PM-1008-11 13E PM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699763667769 40.775706073102604)
1001 -73.9801985977846 40.768015951170504 1B-AM-1012-11 01B AM 10122018 11 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0 fighting w/ pigeons 0 0 0 0 0 0 1 0   POINT (-73.9801985977846 40.7680159511705)
1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691293546408 40.77032190765491)
1229 -73.9677751507448 40.779099006665795 17E-AM-1017-11 17E AM 10172018 11 Adult Gray   Gray+   Ground Plane FALSE Shore 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9677751507448 40.7790990066658)
1278 -73.9729848996456 40.770714329426106 7F-AM-1008-11 07F AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9729848996456 40.7707143294261)
1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.974828939898 40.7668886121909)
1743 -73.9635412640983 40.7902529354639 30B-AM-1007-11 30B AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9635412640983 40.7902529354639)
1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.9720365327715 40.7762329714016)
1903 -73.9701379806066 40.7785234812393 16D-PM-1010-11 16D PM 10102018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701379806066 40.7785234812393)
1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9692925815903 40.7774506065008)
2022 -73.9719583492187 40.7763434967164 13D-AM-1014-11 13D AM 10142018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719583492187 40.7763434967164)
2348 -73.9531965469704 40.794743798397704 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 1 1 0   POINT (-73.9531965469704 40.7947437983977)
2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.958932543729 40.7913445531266)
2665 -73.969784066769 40.77669404054029 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0 curious POINT (-73.969784066769 40.7766940405403)
2751 -73.956289117157 40.795339399380296 38E-AM-1010-11 38E AM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of the stream 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.956289117157 40.7953393993803)
2760 -73.9701808122548 40.7744632730919 12F-PM-1007-11 12F PM 10072018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701808122548 40.7744632730919)
2797 -73.95769134926691 40.7994216061391 41B-AM-1010-11 41B AM 10102018 11 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 1 0 eating a mushroom! 0 0 0 0 0 0 1 0   POINT (-73.9576913492669 40.7994216061391)

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