2018_Central_Park_Squirrel_Census_-_Squirrel_Data

59 rows where Foraging = 1, Running = 1 and Runs from = 1 sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Other Interactions

Runs from ✖

Running ✖

Moans ✖

  • 0 59
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
87 87 -73.95414534658171 40.798216222376396 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9541453465817 40.79821622237641)
95 95 -73.9692883970928 40.776855370308205 14E-AM-1008-02 14E AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 walking 0 0 0 0 0 0 0 1   POINT (-73.9692883970928 40.7768553703082)
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708775864433 40.772473633538)
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1 runs from the dog POINT (-73.9681917366128 40.7723298813768)
504 504 -73.95334760207359 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree 1 0 1 0 1   1 0 0 0 0 0 0 1 dogs POINT (-73.9533476020736 40.7933003544685)
706 706 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   1 0 0 1 1   1 0 0 0 0 1 0 1 approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)
930 930 -73.96220300857941 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9622030085794 40.7917723228749)
951 951 -73.97179185488301 40.78029717297839 17B-PM-1012-01 17B PM 10122018 1 Adult Gray   Gray+   Above Ground 2 climbed a fence 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.971791854883 40.7802971729784)
963 963 -73.9621066718851 40.7942427079733 34A-AM-1012-03 34A AM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9621066718851 40.7942427079733)
964 964 -73.9631045499811 40.790618096947206 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9631045499811 40.7906180969472)
972 972 -73.9704591091677 40.7729175143429 10G-AM-1006-02 10G AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon notch on tail Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9704591091677 40.7729175143429)
1040 1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9702588981432 40.776610754288)
1124 1124 -73.959516757215 40.7952545908471 36C-PM-1013-04 36C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE On rock 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.959516757215 40.7952545908471)
1192 1192 -73.9634811495245 40.790705585077 30B-AM-1007-10 30B AM 10072018 10 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9634811495245 40.790705585077)
1200 1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657721715305 40.778534830257)
1293 1293 -73.9775465365348 40.768194370787604 3D-PM-1010-09 03D PM 10102018 9 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9775465365348 40.7681943707876)
1298 1298 -73.9612900553755 40.791291739186704 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9612900553755 40.7912917391867)
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9735655529245 40.7716072681474)
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9594676326588 40.7984457363388)
1429 1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)
2000 2000 -73.9591070579246 40.789677677115705 31F-PM-1007-05 31F PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9591070579246 40.7896776771157)
2152 2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
2166 2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
2240 2240 -73.9697787673802 40.7781746195436 16D-PM-1010-05 16D PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697787673802 40.7781746195436)
2276 2276 -73.9611985783336 40.791604823372005 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9611985783336 40.791604823372)
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9717515173863 40.7747999274418)
2373 2373 -73.9613276802049 40.7943813964442 35B-PM-1013-03 35B PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 threatened by approaching dog (dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.96132768020492 40.7943813964442)
2384 2384 -73.9708564226824 40.7726219968014 10F-PM-1019-09 10F PM 10192018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Across Arbor path into hill w/ bushes 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9708564226824 40.7726219968014)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
2424 2424 -73.9684752839242 40.776581626151795 15F-AM-1007-01 15F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 1   POINT (-73.9684752839242 40.7765816261518)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
2585 2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail 1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9771726831497 40.7732320781799)
2662 2662 -73.97086289336241 40.772563088678396 10F-PM-1019-08 10F PM 10192018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Under "Grape Arbor" structure behind Bandshell 1 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9708628933624 40.7725630886784)
2673 2673 -73.9768867959365 40.7734803954589 8B-PM-1012-01 08B PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768867959365 40.7734803954589)
2682 2682 -73.97110012783891 40.778746609584104 15C-PM-1017-01 15C PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9711001278389 40.7787466095841)
2710 2710 -73.9577919365342 40.796085328505896 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 0 1   POINT (-73.9577919365342 40.7960853285059)
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)
2818 2818 -73.9681664642028 40.77246696819579 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 0 1 runs away from the ball POINT (-73.9681664642028 40.7724669681958)
3012 3012 -73.96137019608979 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1 got threatened by dog (same dog,dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9613701960898 40.7943363227822)
36 36 -73.96624389966809 40.7890381809441 28A-PM-1007-05 28A PM 10072018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9662438996681 40.7890381809441)
312 312 -73.958356112357 40.796014459571 38C-AM-1019-07 38C AM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.958356112357 40.796014459571)
403 403 -73.9597470659927 40.797321593541604 38A-PM-1013-01 38A PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9597470659927 40.7973215935416)
513 513 -73.96310068980699 40.7920255189467 32B-AM-1017-02 32B AM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on its head Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.963100689807 40.79202551894671)
641 641 -73.97190362174459 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719036217446 40.7803588122409)
697 697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719460335398 40.7810508156287)
1462 1462 -73.9584064203778 40.7912272455454 33F-PM-1012-04 33F PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9584064203778 40.7912272455454)
1866 1866 -73.96360276644391 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.9636027664439 40.790075966587)
1911 1911 -73.9528937660465 40.7922919074537 36I-AM-1017-01 36I AM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 1 runs from (me!)—from a pretty big distance POINT (-73.9528937660465 40.7922919074537)
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   1 0 0 1 1 0 0 1   POINT (-73.95832017896151 40.7913938722521)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2278 2278 -73.96453903109901 40.78099163100121 20G-PM-1013-01 20G PM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.964539031099 40.7809916310012)
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people 1 0 0 1 1   0 0 0 0 1 0 1 1   POINT (-73.9596083366477 40.7949526729608)
2522 2522 -73.9658747245917 40.77540337375321 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch 1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9658747245917 40.7754033737532)
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.978199543688 40.7695660563362)
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 1 0 1   POINT (-73.9563473341712 40.78937123984251)
2849 2849 -73.9709912560997 40.77589655951979 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9709912560997 40.7758965595198)

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