2018_Central_Park_Squirrel_Census_-_Squirrel_Data

36 rows where Date = 10072018, Hectare Squirrel Number = 2 and Indifferent = 0 sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

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

Running ✖

  • 0 27
  • 1 9

Indifferent ✖

Hectare Squirrel Number ✖

Date ✖

  • 10072018 · 36 ✖
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
86 86 -73.9708726050721 40.7723572030236 10F-AM-1007-02 10F AM 10072018 2 Adult Gray   Gray+   Above Ground 70   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708726050721 40.7723572030236)
92 92 -73.9565759733611 40.7992461674802 42C-AM-1007-02 42C AM 10072018 2       +         0 0 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9565759733611 40.7992461674802)
159 159 -73.9638270331336 40.7810450065235 21G-PM-1007-02 21G PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9638270331336 40.7810450065235)
369 369 -73.9596398997228 40.793338695384705 34D-PM-1007-02 34D PM 10072018 2 Adult Black   Black+   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0 cautiously aware POINT (-73.9596398997228 40.7933386953847)
371 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)
425 425 -73.9704485231855 40.7717290560806 9G-AM-1007-02 09G AM 10072018 2 Adult Gray   Gray+   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 1 kids were trying to poke it with a stick POINT (-73.9704485231855 40.7717290560806)
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685227310735 40.776599466588)
648 648 -73.95394000282359 40.79800412717 41E-AM-1007-02 41E AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9539400028236 40.79800412717)
721 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)
858 858 -73.96293834202741 40.7889383725489 29C-AM-1007-02 29C AM 10072018 2 Adult Black Gray Black+Gray   Above Ground 10   1 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.9629383420274 40.7889383725489)
934 934 -73.9772053786965 40.766390657333204 1E-PM-1007-02 01E PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9772053786965 40.7663906573332)
1046 1046 -73.9647891228606 40.789853066039 29B-AM-1007-02 29B AM 10072018 2 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 1 0 0 0 0   POINT (-73.9647891228606 40.789853066039)
1112 1112 -73.9583934264026 40.7854742185504 27I-AM-1007-02 27I AM 10072018 2       +         0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9583934264026 40.785474218550405)
1168 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)
1220 1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1607 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)
1633 1633 -73.97470601437419 40.7728528164878 8C-AM-1007-02 08C AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 peeps out from behind tree at cooing tourists POINT (-73.9747060143742 40.7728528164878)
1649 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)
1698 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)
1879 1879 -73.97019267362809 40.7778587687376 15D-AM-1007-02 15D AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9701926736281 40.7778587687376)
1887 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)
1927 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)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
2512 2512 -73.974275954985 40.775472387930705 11B-AM-1007-02 11B AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.974275954985 40.7754723879307)
2564 2564 -73.970996228532 40.7715540712285 9G-PM-1007-02 09G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.970996228532 40.7715540712285)
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97435094238212 40.7690043677328)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
2893 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)
1421 1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 0 1   POINT (-73.9595022290348 40.783115133007406)
1808 1808 -73.9698870647042 40.7826510985538 20B-AM-1007-02 20B AM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 1 0 0   POINT (-73.9698870647042 40.7826510985538)
2037 2037 -73.96833704175509 40.781359835050004 19D-AM-1007-02 19D AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 0 1   0 0 0 0 1 0 0 0 fenced area POINT (-73.9683370417551 40.78135983505)
2040 2040 -73.96481673340891 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   0 0 0 1 1 digging one hole w/ determination 0 0 0 0 1 0 0 1   POINT (-73.96481673340891 40.7811164976329)
2273 2273 -73.9671534029191 40.7810849804467 20D-AM-1007-02 20D AM 10072018 2 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   0 0 0 0 1 quieter 0 0 0 0 1 0 0 0   POINT (-73.9671534029191 40.7810849804467)
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9691692160865 40.7725330502929)
2370 2370 -73.9573119777312 40.7875347862766 30H-AM-1007-02 30H AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0 following #1 0 0 0 0 1 0 0 0   POINT (-73.9573119777312 40.7875347862766)
2419 2419 -73.9590551473416 40.7891607060794 31F-PM-1007-02 31F PM 10072018 2 Adult Gray   Gray+   Above Ground 2 tree trunk 0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.95905514734162 40.7891607060794)

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