2018_Central_Park_Squirrel_Census_-_Squirrel_Data

153 rows where Foraging = 1, Highlight Fur Color = "White" and Indifferent = 1 sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

Highlight Fur Color ✖

  • White · 53 ✖

Foraging ✖

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
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   0 0 0 0 1 stood on back legs 0 0 0 0 0 1 1 1   POINT (-73.9597192455543 40.7973316178661)
2119 2119 -73.96415843952991 40.7816571644072 21G-AM-1014-01 21G AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9641584395299 40.7816571644072)
2125 2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9687933229572 40.7788600242549)
2129 2129 -73.9701182454818 40.777280550087106 15D-PM-1017-03 15D PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701182454818 40.7772805500871)
2155 2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9538938706987 40.7981150065974)
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9707571364399 40.7758859812524)
2191 2191 -73.9734108731087 40.767605139269705 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9734108731087 40.7676051392697)
2221 2221 -73.9771847728747 40.769597116498105 4C-AM-1006-01 04C AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9771847728747 40.7695971164981)
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.95385121459 40.7981257651433)
2283 2283 -73.9628982772673 40.788430480338604 28D-PM-1019-01 28D PM 10192018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9628982772673 40.7884304803386)
2306 2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.956453902485 40.7936584431012)
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)
2331 2331 -73.9694681803635 40.770585795359004 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694681803635 40.770585795359)
2353 2353 -73.963623175585 40.7927451068919 32A-PM-1013-04 32A PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963623175585 40.7927451068919)
2363 2363 -73.9690638424196 40.7713869295685 9H-AM-1006-06 09H AM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 1 0 1 0   POINT (-73.9690638424196 40.7713869295685)
2415 2415 -73.9683598086625 40.7811150451315 19D-PM-1008-01 19D PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683598086625 40.7811150451315)
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9569811285656 40.793091234605)
2539 2539 -73.97810334484679 40.766672406621296 1D-AM-1006-03 01D AM 10062018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9781033448468 40.7666724066213)
2547 2547 -73.9743393747021 40.767634679832504 3F-AM-1006-12 03F AM 10062018 12 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9743393747021 40.7676346798325)
2576 2576 -73.9751625910271 40.7671023412885 3F-AM-1006-02 03F AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9751625910271 40.7671023412885)
2582 2582 -73.9665004148497 40.780565641175606 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665004148497 40.7805656411756)
2594 2594 -73.9638812060405 40.7923714941429 32A-PM-1013-02 32A PM 10132018 2 ? Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9638812060405 40.792371494142905)
2605 2605 -73.97368963630059 40.767763086262605 4G-AM-1006-01 04G AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9736896363006 40.7677630862626)
2642 2642 -73.97514547259979 40.770291361572 6D-PM-1020-06 06D PM 10202018 6 Adult Gray White Gray+White   Ground Plane FALSE by carousel 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9751454725998 40.770291361572006)
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)
2657 2657 -73.9582150734453 40.7962862794303 38C-AM-1019-08 38C AM 10192018 8 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 1 0   POINT (-73.9582150734453 40.7962862794303)
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)
2684 2684 -73.9809688694074 40.7688535974878 2A-PM-1019-06 02A PM 10192018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9809688694074 40.7688535974878)
2689 2689 -73.97041219894871 40.7824040236981 19A-PM-1013-02 19A PM 10132018 2 Adult Gray White Gray+White Looks very brown, not like English red squirrels Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704121989487 40.7824040236981)
2691 2691 -73.9564599077179 40.7965185098695 39D-PM-1012-01 39D PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9564599077179 40.7965185098695)
2704 2704 -73.96577644902841 40.781192322928604 20F-PM-1007-10 20F PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9657764490284 40.7811923229286)
2732 2732 -73.9694185786221 40.7787189999566 16D-AM-1007-06 16D AM 10072018 6 Adult Cinnamon White Cinnamon+White primary color: brown ( I marked cinnamon as closest to brown - JO) Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9694185786221 40.7787189999566)
2778 2778 -73.9761799699276 40.774213409933 9B-AM-1010-07 09B AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9761799699276 40.774213409933)
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)
2824 2824 -73.97506180080991 40.773752116709396 9B-AM-1010-05 09B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9750618008099 40.7737521167094)
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9579292340076 40.7976287835027)
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)
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)
2860 2860 -73.95651796713192 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95651796713192 40.7936663940365)
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)
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964593167562 40.7780374890066)
2890 2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9726236083428 40.778821777147506)
2906 2906 -73.9597260014375 40.790707423031 32E-AM-1007-04 32E AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9597260014375 40.790707423031)
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)
2978 2978 -73.96888170064429 40.7829120321438 20B-PM-1013-09 20B PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9688817006443 40.7829120321438)
3020 3020 -73.97040158596391 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9704015859639 40.7825600069973)
640 640 -73.97855365291359 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9785536529136 40.771618450500206)
750 750 -73.96996720741642 40.777438934574796 15D-AM-1007-07 15D AM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 1 chasing #8 0 0 0 0 0 0 1 0   POINT (-73.9699672074164 40.7774389345748)
957 957 -73.9586527721822 40.790883111056104 32F-PM-1008-08 32F PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586527721822 40.7908831110561)
2591 2591 -73.9786351029146 40.771611416400205 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground 0 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9786351029146 40.771611416400205)
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)
2918 2918 -73.9745152462626 40.76554155159079 1G-AM-1006-04 01G AM 10062018 4 Adult Gray White Gray+White         0 1 0 0 1 collecting nest material 0 0 0 0 1 0 1 0   POINT (-73.9745152462626 40.76554155159081)

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