2018_Central_Park_Squirrel_Census_-_Squirrel_Data

19 rows where Hectare Squirrel Number = 9 and Runs from = 1 sorted by Chasing

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight 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

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
186 -73.9788138172962 40.7693001754769 3B-AM-1010-09 03B AM 10102018 9 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9788138172962 40.7693001754769)
268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.968107276769 40.7768612676036)
658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree 0 0 0 1 1   0 0 0 1 0 1 0 1   POINT (-73.9704575848926 40.7693499326095)
979 -73.9612349421547 40.795958647574395 36A-PM-1013-09 36A PM 10132018 9   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH 1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9612349421547 40.7959586475744)
1019 -73.97042696309641 40.7722964640257 10G-AM-1006-09 10G AM 10062018 9 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9704269630964 40.7722964640257)
1030 -73.9697526733133 40.7759529849808 13E-PM-1008-09 13E PM 10082018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697526733133 40.7759529849808)
1197 -73.95908687485841 40.7906047630418 32E-PM-1017-09 32E PM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9590868748584 40.7906047630418)
1232 -73.9589254878322 40.7914467650712 33E-PM-1012-09 33E PM 10122018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589254878322 40.7914467650712)
1293 -73.9775465365348 40.768194370787604 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9775465365348 40.7681943707876)
1622 -73.9615090149261 40.794515017391795 35A-PM-1013-09 35A PM 10132018 9   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9615090149261 40.7945150173918)
1651 -73.97633735105359 40.774116893392794 9B-PM-1013-09 09B PM 10132018 9 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 runs from (people) POINT (-73.9763373510536 40.7741168933928)
1733 -73.9756345867747 40.7675540517649 3E-PM-1008-09 03E PM 10082018 9 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9756345867747 40.7675540517649)
1850 -73.975809362521 40.773470273783495 8B-PM-1012-09 08B PM 10122018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.975809362521 40.7734702737835)
1893 -73.9708108312271 40.7773975776146 14D-PM-1019-09 14D PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9708108312271 40.7773975776146)
1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree 0 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9586570546871 40.796349417475)
2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708564226824 40.7726219968014)
2556 -73.96398284313679 40.7910151996207 30B-PM-1019-09 30B PM 10192018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9639828431368 40.7910151996207)
2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   0 0 1 0 0   1 1 0 0 0 0 1 1   POINT (-73.9595886063173 40.7918405182594)
84 -73.9701824825872 40.776653057929295 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9701824825872 40.7766530579293)

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