2018_Central_Park_Squirrel_Census_-_Squirrel_Data

174 rows where Eating = 0 and Hectare Squirrel Number = 6 sorted by Indifferent

✎ View and edit SQL

This data as json, CSV (advanced)

Runs from ✖

  • 0 71
  • 1 3

Hectare Squirrel Number ✖

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
89 89 -73.968052057989 40.777338666528 15F-PM-1010-06 15F PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.968052057989 40.777338666528)
194 194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9764839973068 40.7691725326976)
217 217 -73.9712327308512 40.7748702909218 12E-PM-1018-06 12E PM 10182018 6 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9712327308512 40.7748702909218)
282 282 -73.97015758910979 40.773097328242294 10G-PM-1017-06 10G PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701575891098 40.7730973282423)
300 300 -73.9528149779809 40.7924984810637 36I-AM-1017-06 36I AM 10172018 6 Adult Gray Black Gray+Black Darker than others Above Ground 10 Running down tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9528149779809 40.7924984810637)
352 352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
378 378 -73.95848354168459 40.7978213396921 39B-PM-1014-06 39B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584835416846 40.7978213396921)
398 398 -73.9686737866872 40.773971402373206 12G-PM-1007-06 12G PM 10072018 6   Gray Cinnamon Gray+Cinnamon         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9686737866872 40.7739714023732)
448 448 -73.9706929341294 40.7760473872395 13E-PM-1008-06 13E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706929341294 40.77604738723951)
458 458 -73.97357503529591 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735750352959 40.7694500333777)
468 468 -73.9780659679557 40.7672382282781 1D-PM-1007-06 01D PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9780659679557 40.7672382282781)
492 492 -73.97030108562241 40.7701983575511 8H-PM-1014-06 08H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703010856224 40.7701983575511)
543 543 -73.9701310753277 40.776800100808295 14E-AM-1008-06 14E AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701310753277 40.7768001008083)
573 573 -73.9674688433583 40.7789728381912 17E-AM-1017-06 17E AM 10172018 6 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9674688433583 40.7789728381912)
576 576 -73.96220476777009 40.7945126358465 35A-AM-1014-06 35A AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9622047677701 40.7945126358465)
620 620 -73.9655905300923 40.775261463802295 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9655905300923 40.7752614638023)
693 693 -73.969353372175 40.7838247422369 21A-AM-1019-06 21A AM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969353372175 40.7838247422369)
707 707 -73.961547503801 40.793156066867205 33B-AM-1010-06 33B AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.961547503801 40.7931560668672)
725 725 -73.9689627791 40.776062004359005 14F-AM-1007-06 14F AM 10072018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689627791 40.776062004359)
737 737 -73.97111769994709 40.7724278547281 10F-PM-1019-06 10F PM 10192018 6 Adult Gray White Gray+White   Above Ground 10 Different tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9711176999471 40.7724278547281)
790 790 -73.9745040517502 40.77333038538 9C-PM-1006-06 09C PM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97450405175022 40.77333038538)
967 967 -73.9683994064731 40.7710765500799 9I-AM-1014-06 09I AM 10142018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.96839940647311 40.7710765500799)
988 988 -73.97870401924729 40.767901024728104 2C-AM-1010-06 02C AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 stood still & watched me then jumped on a fence and ran away 0 0 0 0 0 0 1 1   POINT (-73.9787040192473 40.7679010247281)
990 990 -73.96296155944091 40.792417642582706 32B-PM-1010-06 32B PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9629615594409 40.7924176425827)
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552035011902 40.7889851896334)
1049 1049 -73.9564606426367 40.788054657260794 30I-PM-1006-06 30I PM 10062018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 1 ran up tree POINT (-73.9564606426367 40.7880546572608)
1074 1074 -73.9724657562746 40.7658015504376 3I-PM-1013-06 03I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9724657562746 40.7658015504376)
1078 1078 -73.9586591455169 40.790624390130894 32F-PM-1008-06 32F PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586591455169 40.7906243901309)
1133 1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9712550584322 40.7764273475386)
1166 1166 -73.980048119915 40.7676638655026 1B-AM-1012-06 01B AM 10122018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.980048119915 40.7676638655026)
1350 1350 -73.9727698663722 40.7714335285174 8F-PM-1012-06 08F PM 10122018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9727698663722 40.7714335285174)
1424 1424 -73.9709722223794 40.7767329646325 14D-AM-1014-06 14D AM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709722223794 40.7767329646325)
1454 1454 -73.9753818829907 40.76978409861629 5D-PM-1018-06 05D PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753818829907 40.7697840986163)
1498 1498 -73.9765064169087 40.7737211426714 8B-AM-1007-06 08B AM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9765064169087 40.7737211426714)
1530 1530 -73.96893059787509 40.781815249626604 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence 1 0 1 0 0 climbing (fence) 0 0 0 0 0 0 1 0   POINT (-73.9689305978751 40.7818152496266)
1535 1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
1556 1556 -73.97462382801159 40.7671491962844 3F-AM-1006-06 03F AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9746238280116 40.7671491962844)
1638 1638 -73.9770628333002 40.7728567364852 7B-AM-1008-06 07B AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9770628333002 40.7728567364852)
1670 1670 -73.9682688752331 40.7711934835539 9I-PM-1010-06 09I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682688752331 40.7711934835539)
1694 1694 -73.97301963428741 40.766022437401 3H-PM-1014-06 03H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9730196342874 40.766022437401)
1769 1769 -73.9721086069437 40.7698172190404 6G-AM-1008-06 06G AM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White white at end of tail Ground Plane FALSE grass 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9721086069437 40.7698172190404)
1770 1770 -73.97281709807791 40.770355783043705 7F-AM-1008-06 07F AM 10082018 6 Adult Gray   Gray+   Above Ground 28 in hole in tree 0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9728170980779 40.770355783043705)
1815 1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1870 1870 -73.9542118614769 40.7939171395463 37G-AM-1014-06 37G AM 10142018 6 Adult Gray White Gray+White White tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.95421186147692 40.7939171395463)
1886 1886 -73.956806913988 40.7987736900857 41C-AM-1017-06 41C AM 10172018 6 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.956806913988 40.7987736900857)
1910 1910 -73.9699876501742 40.774248267675794 12F-PM-1007-06 12F PM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699876501742 40.77424826767581)
1948 1948 -73.9738410069766 40.7691686156505 5F-PM-1007-06 05F PM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 jumping on fence 0 0 0 0 1 0 1 0   POINT (-73.9738410069766 40.7691686156505)
1964 1964 -73.9622859117854 40.788616918696604 29D-AM-1014-06 29D AM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9622859117854 40.7886169186966)
1998 1998 -73.9595686513629 40.7906859748696 32E-AM-1007-06 32E AM 10072018 6 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9595686513629 40.7906859748696)
2007 2007 -73.9684834138222 40.772428912021105 11H-AM-1010-06 11H AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9684834138222 40.7724289120211)
2025 2025 -73.97665418790059 40.7674077265375 2E-AM-1010-06 02E AM 10102018 6 Adult Cinnamon   Cinnamon+   Above Ground 35   0 0 0 0 0 leaping branch to branch 0 0 0 0 0 0 1 0   POINT (-73.9766541879006 40.7674077265375)
2052 2052 -73.97464934414141 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.9746493441414 40.7750478734868)
2075 2075 -73.96362349533341 40.7775138547689 18I-PM-1007-06 18I PM 10072018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9636234953334 40.7775138547689)
2081 2081 -73.96757180595391 40.7786049141486 17F-AM-1007-06 17F AM 10072018 6 Juvenile Cinnamon White Cinnamon+White   Above Ground 8   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675718059539 40.7786049141486)
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree 0 0 1 0 0 cleaning 0 0 0 0 0 0 1 0   POINT (-73.975198284551 40.7740343763399)
2247 2247 -73.95595201371721 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #7 0 0 0 0 1 0 1 0   POINT (-73.95595201371721 40.7950536287174)
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)
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)
2385 2385 -73.9787552947847 40.7690779628762 3B-AM-1010-06 03B AM 10102018 6 Adult Gray   Gray+   Above Ground 20   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9787552947847 40.7690779628762)
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)
2410 2410 -73.97551920769341 40.7664413570796 2F-PM-1014-06 02F PM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755192076934 40.7664413570796)
2459 2459 -73.9679156307975 40.77452693602589 13H-PM-1010-06 13H PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9679156307975 40.7745269360259)
2505 2505 -73.9762974698771 40.7740076116964 9B-PM-1013-06 09B PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9762974698771 40.7740076116964)
2548 2548 -73.9703571491616 40.7678515625131 5I-AM-1010-06 05I AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703571491616 40.7678515625131)
2588 2588 -73.95810074370941 40.795940311272204 38C-AM-1019-06 38C AM 10192018 6 Adult Gray   Gray+   Above Ground 23   0 0 1 0 0   1 0 0 1 0 0 1 0   POINT (-73.9581007437094 40.7959403112722)
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)
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)
2661 2661 -73.9693841004072 40.770414865829395 8I-PM-1013-06 08I PM 10132018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9693841004072 40.7704148658294)
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)
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)
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)
2855 2855 -73.9690832219322 40.782343340985996 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.96908322193221 40.782343340986)
2894 2894 -73.979734151564 40.7682150214703 2B-AM-1010-06 02B AM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.979734151564 40.7682150214703)
2935 2935 -73.96045994773449 40.7915035010169 32D-PM-1006-06 32D PM 10062018 6 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9604599477345 40.7915035010169)

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.632ms