2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Above Ground Sighter Measurement = 15 and Hectare Squirrel Number = 2 sorted by Kuks

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, 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
359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   0 0 1 0 0 seems to be grinding teeth on a piece of material (sounds from grinding) 0 0 0 0 0 0 1 0   POINT (-73.9716404781264 40.7753181851766)
371 -73.964080104186 40.79078986272871 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.964080104186 40.7907898627287)
374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556817958407 40.788852000621)
503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
510 -73.9638590768396 40.777678211498106 18I-AM-1017-02 18I AM 10172018 2 Adult Gray Black Gray+Black   Above Ground 15   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9638590768396 40.7776782114981)
582 -73.9677779408464 40.78674822113489 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE 0 1 0 0 0 chasing #3 0 0 0 1 0 0 1 0   POINT (-73.9677779408464 40.7867482211349)
657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9679008849677 40.7759013923034)
1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   0 0 0 1 0 eating (red berries) 0 0 0 0 0 0 1 0   POINT (-73.9616999731028 40.7954126939561)
1426 -73.9664986446294 40.778308334318 17G-PM-1017-02 17G PM 10172018 2 Adult Gray   Gray+   Above Ground 15   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664986446294 40.778308334318)
1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)
1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   0 0 1 0 0 pulling things off branches 0 0 0 0 0 0 0 0   POINT (-73.9770508584979 40.7710769301257)
1887 -73.95861842328891 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   0 0 1 0 0 jumping 0 0 0 0 0 0 0 0 stared at me POINT (-73.9586184232889 40.7993153832942)
1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684058476942 40.7753959833776)
1989 -73.96316467546471 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631646754647 40.7925716810884)
2180 -73.960864328605 40.7902122634639 31D-PM-1006-02 31D PM 10062018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960864328605 40.7902122634639)
2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0 nest building 0 0 0 0 0 0 1 0   POINT (-73.9708032298419 40.77842656745441)
2813 -73.96591181893591 40.7765739928504 15H-AM-1013-02 15H AM 10132018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9659118189359 40.7765739928504)

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