2018_Central_Park_Squirrel_Census_-_Squirrel_Data

144 rows where Eating = 1 and Highlight Fur Color = "White" sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Above Ground Sighter Measurement ✖

Tail twitches ✖

  • 0 38
  • 1 6

Highlight Fur Color ✖

  • White · 44 ✖

Eating ✖

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
2587 2587 -73.97899712868441 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9789971286844 40.7707024146365)
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.96393252683 40.7808289765857)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
2645 2645 -73.9584967368893 40.797732034109394 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. 0 0 0 0 0 0 1 0   POINT (-73.9584967368893 40.7977320341094)
2659 2659 -73.95536034380208 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9553603438021 40.7985282963244)
2665 2665 -73.969784066769 40.77669404054029 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0 curious POINT (-73.969784066769 40.7766940405403)
2701 2701 -73.97912175106559 40.767658347539395 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9791217510656 40.7676583475394)
2706 2706 -73.9745141185576 40.76914797812071 5E-AM-1008-01 05E AM 10082018 1 Adult Gray White Gray+White   Above Ground 2 on a checker table 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9745141185576 40.7691479781207)
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9618094076328 40.7944097368153)
2742 2742 -73.96280415779341 40.7884180156055 28D-AM-1012-06 28D AM 10122018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 5   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9628041577934 40.78841801560551)
2764 2764 -73.9692660977515 40.7830532310766 21B-PM-1017-01 21B PM 10172018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 paused to look at me POINT (-73.9692660977515 40.7830532310766)
2766 2766 -73.95516398474659 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9551639847466 40.790858199891)
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9705409446299 40.7764608087703)
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9802983138318 40.7676540772339)
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711634340673 40.7760553338671)
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating 0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.9809342290598 40.7687265606227)
2843 2843 -73.97147871782009 40.779804947074496 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9714787178201 40.7798049470745)
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9530811255728 40.79830691185791)
2926 2926 -73.9714653576023 40.77174001395021 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9714653576023 40.7717400139502)
2946 2946 -73.974515099169 40.770065079988605 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees 0 1 0 1 0 chasing #4 0 0 0 0 0 0 1 0   POINT (-73.974515099169 40.770065079988605)
2950 2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
2953 2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 eating (in a tree cage thing) 0 0 0 0 0 0 1 0   POINT (-73.9585862117341 40.7986549251083)
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9747963162162 40.7745023355775)
199 199 -73.97716146866159 40.770967798324705 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9771614686616 40.7709677983247)
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 1 0 0 1 0 too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
792 792 -73.97301156879641 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9730115687964 40.7741018274312)
996 996 -73.9703149829421 40.778558363032296 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9703149829421 40.7785583630323)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
1381 1381 -73.9586077039567 40.796189647707706 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9586077039567 40.7961896477077)
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   0 1 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9710801547498 40.7760872452093)
1410 1410 -73.95879132892291 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   1 0 1 1 0   1 0 0 0 1 0 0 1   POINT (-73.9587913289229 40.7961707624534)
1667 1667 -73.96459890035891 40.778215745915496 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9645989003589 40.7782157459155)
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
1787 1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   0 0 1 1 0   0 0 0 0 1 0 1 0   POINT (-73.9720365327715 40.7762329714016)
1983 1983 -73.97841448676391 40.771817766751106 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9784144867639 40.7718177667511)
2005 2005 -73.9755259087781 40.770725612418104 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 1 0   1 0 0 0 0 1 0 0   POINT (-73.9755259087781 40.7707256124181)
2288 2288 -73.9577009571427 40.796126044520996 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 1 climbing (down from ~10') 0 0 0 0 0 0 0 1   POINT (-73.9577009571427 40.796126044521)
2317 2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2352 2352 -73.9727310397798 40.778701677351705 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree 0 0 1 1 1 digging,chewing on tree—has nut in mouth! 0 0 0 0 0 0 0 1   POINT (-73.97273103977982 40.7787016773517)
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9622050752008 40.7886373772305)
2730 2730 -73.96535757586871 40.78053399533721 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.9653575758687 40.7805339953372)
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9576094432477 40.7965342664074)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)

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