2018_Central_Park_Squirrel_Census_-_Squirrel_Data

37 rows where Date = 10142018, Foraging = 0 and Hectare Squirrel Number = 2 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from

Location ✖

Hectare Squirrel Number ✖

Foraging ✖

Date ✖

  • 10142018 · 37 ✖
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
158 158 -73.9710991123992 40.77238897266471 9F-PM-1014-02 09F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9710991123992 40.7723889726647)
167 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)
600 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)
656 656 -73.9553726714504 40.798757854112296 41D-AM-1014-02 41D AM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 jumping 0 0 0 0 0 0 1 0   POINT (-73.9553726714504 40.7987578541123)
742 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 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)
1006 1006 -73.96862962178929 40.771812308875 10H-AM-1014-02 10H AM 10142018 2 Juvenile Cinnamon   Cinnamon+   Above Ground 6   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686296217893 40.771812308875)
1075 1075 -73.9640534906634 40.777738389983604 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0 standing upright 0 0 0 0 0 1 0 1 runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)
1635 1635 -73.95607317386771 40.798033601855394 41D-PM-1014-02 41D PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9560731738677 40.7980336018554)
1652 1652 -73.94984217462209 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9498421746221 40.7969397424182)
1673 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)
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9618486459307 40.7946365810826)
1844 1844 -73.9682062012675 40.786498436192005 24A-AM-1014-02 24A AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon Blonde? in Highlights Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9682062012675 40.786498436192)
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9733898487296 40.7666975131518)
1908 1908 -73.95883455468791 40.7991830272008 40A-PM-1014-02 40A PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from base of tree into bushes) POINT (-73.9588345546879 40.7991830272008)
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
2086 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)
2112 2112 -73.9655206571055 40.7764851568746 16H-PM-1014-02 16H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9655206571055 40.7764851568746)
2307 2307 -73.9736997033862 40.778497952406 14A-PM-1014-02 14A PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9736997033862 40.778497952406)
2481 2481 -73.9719068478565 40.7789062312585 15B-AM-1014-02 15B AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 grooming,scratching 0 0 0 0 0 0 1 0   POINT (-73.9719068478565 40.7789062312585)
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)
2632 2632 -73.95082755733499 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.950827557335 40.797579073666)
2881 2881 -73.9541629063295 40.7934259301577 37G-AM-1014-02 37G AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0 ran away & disappeared 0 0 0 0 0 0 0 0   POINT (-73.9541629063295 40.7934259301577)
2949 2949 -73.9651206201297 40.778527906484705 18G-AM-1014-02 18G AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9651206201297 40.7785279064847)
359 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)
428 428 -73.96362827608 40.780799459524204 21G-AM-1014-02 21G AM 10142018 2 Adult Gray White Gray+White   Above Ground 3 fence 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.96362827608 40.7807994595242)
593 593 -73.95933528061751 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9593352806175 40.7918150568046)
755 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)
767 767 -73.9655734633649 40.7805366922231 20F-AM-1014-02 20F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0 pulling leaves 1 0 0 0 0 0 0 0   POINT (-73.9655734633649 40.7805366922231)
838 838 -73.96910310946879 40.77066938351889 9I-AM-1014-02 09I AM 10142018 2 Adult Gray   Gray+ Very far, so appx Above Ground 35   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9691031094688 40.7706693835189)
1041 1041 -73.9643236505425 40.7887854771596 28C-AM-1014-02 28C AM 10142018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9643236505425 40.7887854771596)
1732 1732 -73.97671414072741 40.7737313251559 8A-PM-1014-02 08A PM 10142018 2 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.9767141407274 40.7737313251559)
1807 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)
2243 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)
2663 2663 -73.96134291849741 40.79121580572671 32C-AM-1014-02 32C AM 10142018 2 Adult Gray   Gray+   Above Ground 3   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9613429184974 40.7912158057267)
2762 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)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)

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