2018_Central_Park_Squirrel_Census_-_Squirrel_Data

64 rows where Eating = 0, Foraging = 0, Hectare Squirrel Number = 2, Running = 0 and Shift = "PM"

View and edit SQL

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

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
156 -73.9576589997493 40.7972751877447 39C-PM-1006-02 39C PM 10062018 2 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0 unaware of POINT (-73.95765899974931 40.7972751877447)
167 -73.95976427784271 40.7976368003915 39A-PM-1014-02 39A PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9597642778427 40.7976368003915)
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)
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)
600 -73.9808202088503 40.7682921842325 1A-PM-1014-02 01A PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9808202088503 40.7682921842325)
639 -73.9558589529608 40.789240039494096 32H-PM-1006-02 32H PM 10062018 2   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9558589529608 40.7892400394941)
721 -73.97182620344691 40.76667717974421 4I-PM-1007-02 04I PM 10072018 2 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9718262034469 40.7666771797442)
742 -73.9767016963397 40.7674012784541 2E-PM-1014-02 02E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9767016963397 40.7674012784541)
744 -73.97456876537909 40.7776396926997 13A-PM-1014-02 13A PM 10142018 2 Adult Gray   Gray+   Above Ground 45   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9745687653791 40.7776396926997)
755 -73.9579941847434 40.7991216713328 41B-PM-1014-02 41B PM 10142018 2 Adult Black   Black+   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9579941847434 40.7991216713328)
808 -73.97168818386709 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9716881838671 40.778553537087)
876 -73.96727895735371 40.7874778720268 26A-PM-1006-02 26A PM 10062018 2 Juvenile Gray   Gray+ injured Ground Plane FALSE   0 0 0 0 0 not moving 0 0 0 0 0 0 0 0   POINT (-73.96727895735371 40.7874778720268)
890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree 0 1 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9667755678511 40.7760256836088)
1086 -73.9713399316534 40.77506780267571 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   0 0 1 0 0 lounging on tree upside down 0 0 0 0 1 0 1 0   POINT (-73.9713399316534 40.7750678026757)
1154 -73.9786936992465 40.771394367466606 5A-PM-1010-02 05A PM 10102018 2 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9786936992465 40.7713943674666)
1168 -73.9779874405715 40.7730765377366 7A-PM-1007-02 07A PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779874405715 40.7730765377366)
1238 -73.97736921314409 40.767977115014894 3D-PM-1010-02 03D PM 10102018 2 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9773692131441 40.7679771150149)
1252 -73.9777998932399 40.770981586533395 5B-PM-1013-02 05B PM 10132018 2 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9777998932399 40.7709815865334)
1263 -73.9770873939997 40.771037966210606 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9770873939997 40.7710379662106)
1265 -73.96035971176191 40.7824399298414 23I-PM-1019-02 23I PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9603597117619 40.7824399298414)
1267 -73.9701010964667 40.768891931450796 6I-PM-1013-02 06I PM 10132018 2 Adult Black   Black+   Ground Plane FALSE Bushes 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701010964667 40.76889193145081)
1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0 laying on tree branch 0 0 0 1 1 0 0 0   POINT (-73.9754527701832 40.7656088463928)
1371 -73.9542733797804 40.795578653743 39F-PM-1006-02 39F PM 10062018 2 Adult Gray   Gray+   Above Ground 20 tree 0 0 0 0 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.9542733797804 40.795578653743)
1372 -73.95283537022091 40.7976456178263 41F-PM-1019-02 41F PM 10192018 2       +         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9528353702209 40.7976456178263)
1374 -73.9653739273979 40.788976209696706 28B-PM-1010-02 28B PM 10102018 2 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653739273979 40.7889762096967)
1415 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)
1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
1589 -73.9567062023419 40.797482865196 40C-PM-1006-02 40C PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9567062023419 40.797482865196)
1625 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)
1649 -73.969347812694 40.7744098063421 12G-PM-1007-02 12G PM 10072018 2   Gray   Gray+   Above Ground   in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.969347812694 40.7744098063421)
1668 -73.97469348106671 40.7659431884158 2G-PM-1007-02 02G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nut 0 0 0 0 1 0 1 0   POINT (-73.9746934810667 40.7659431884158)
1673 -73.9746940851342 40.7760966488186 11B-PM-1014-02 11B PM 10142018 2 Juvenile Gray   Gray+   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9746940851342 40.7760966488186)
1698 -73.9631392113757 40.791463563578404 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 1 0 0 chasing #1 and climbing tree w/ #1 0 0 0 0 0 0 0 1   POINT (-73.9631392113757 40.7914635635784)
1755 -73.97147981967771 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole 0 0 1 0 0   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9714798196777 40.7695231949631)
1778 -73.96855981061279 40.7807054868066 19D-PM-1008-02 19D PM 10082018 2       + unknown - cannot see, only hear Above Ground     0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9685598106128 40.7807054868066)
1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   1 1 0 0 0 0 0 1   POINT (-73.9581366214863 40.7988964092722)
1847 -73.9782283921819 40.766793260207706 1D-PM-1007-02 01D PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9782283921819 40.7667932602077)
1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9613998967903 40.7912437235667)
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)
1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   0 1 0 0 0   0 1 0 0 0 0 0 0 stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)
1927 -73.95443722977221 40.7942113164104 37G-PM-1007-02 37G PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE ran under dumpster w/ nut 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9544372297722 40.7942113164104)
1933 -73.95848243616551 40.7934247634031 35D-PM-1013-02 35D PM 10132018 2 Adult Gray White Gray+White   Above Ground 24   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584824361655 40.7934247634031)
1951 -73.9548431601579 40.7906346271566 34I-PM-1010-02 34I PM 10102018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9548431601579 40.7906346271566)
1970 -73.96314646937691 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree 0 0 0 0 0 hanging out,watching world 0 0 0 0 0 0 0 0 watching POINT (-73.9631464693769 40.793415656751)
2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch 0 0 0 0 0 watching me scratching 1 0 0 1 0 0 1 0   POINT (-73.9622752768962 40.7814921913101)
2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
2086 -73.9525627119429 40.793860286746394 38I-PM-1014-02 38I PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hanging out w/ Squirrel #1 0 0 0 0 0 scampering w/ squirrel #1 0 0 0 0 1 0 0 1   POINT (-73.9525627119429 40.7938602867464)
2137 -73.96488316116292 40.780132641497296 19G-PM-1017-02 19G PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 patting ground 0 0 0 0 1 0 0 1   POINT (-73.9648831611629 40.7801326414973)
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)
2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.960898739757 40.7961393097144)
2226 -73.9624296435843 40.791320813687 31C-PM-1010-02 31C PM 10102018 2 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9624296435843 40.791320813687)
2243 -73.9579967047318 40.7948682042252 37D-PM-1014-02 37D PM 10142018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95799670473181 40.7948682042252)
2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785709201168 40.7674391934208)
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)
2347 -73.9663124560664 40.779544003786 18F-PM-1008-02 18F PM 10082018 2 Adult Gray   Gray+         0 0 0 0 0 hopping around 0 0 0 0 0 0 0 1   POINT (-73.9663124560664 40.779544003786)
2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2421 -73.96822789059891 40.773302750805705 11H-PM-1013-02 11H PM 10132018 2 Adult Gray Black Gray+Black   Above Ground 10   0 0 0 0 0 digging 0 0 0 0 0 0 1 0   POINT (-73.9682278905989 40.7733027508057)
2509 -73.97142951022491 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714295102249 40.776954371947)
2762 -73.9656324462902 40.783403475308106 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9656324462902 40.7834034753081)
2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)
2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   0 0 1 0 0 different sound - happy,playful chirps 0 0 0 0 1 0 1 0   POINT (-73.955208233231 40.7890574331084)
2893 -73.97931014826541 40.7692600238491 3B-PM-1007-02 03B PM 10072018 2 Adult Gray   Gray+   Above Ground 10 in tree 0 0 0 0 0 chased by dog 0 0 0 0 0 0 0 0   POINT (-73.9793101482654 40.7692600238491)
2982 -73.9513477815203 40.7945259614138 39I-PM-1013-02 39I PM 10132018 2 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 1 1 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9513477815203 40.7945259614138)
3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9756457597888 40.7703559775625)

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