2018_Central_Park_Squirrel_Census_-_Squirrel_Data

161 rows where Hectare Squirrel Number = 7 sorted by Lat/Long

View and edit SQL

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 ▼
980 -73.9709817796369 40.7773554311586 14D-PM-1019-07 14D PM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9709817796369 40.7773554311586)
1897 -73.97107389601 40.7723265810536 10F-PM-1019-07 10F PM 10192018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Same tree (as #6) 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97107389601 40.7723265810536)
1791 -73.97109071758341 40.776373910820006 13D-AM-1014-07 13D AM 10142018 7 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.9710907175834 40.77637391082)
2304 -73.9715251156965 40.774621784862 11E-PM-1012-07 11E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9715251156965 40.774621784862)
1338 -73.9716624574422 40.776203711010105 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0 scratching 0 0 0 0 0 0 1 0   POINT (-73.9716624574422 40.7762037110101)
1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9716736557408 40.7749333494336)
1438 -73.97168547522399 40.7706668465923 7G-PM-1018-07 07G PM 10182018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.971685475224 40.7706668465923)
301 -73.9717425494287 40.7664227676653 3I-PM-1013-07 03I PM 10132018 7 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9717425494287 40.7664227676653)
2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719901848577 40.7720525965356)
1066 -73.9720174997123 40.774889426602705 11D-AM-1010-07 11D AM 10102018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9720174997123 40.7748894266027)
482 -73.97217978245759 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0 approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)
1814 -73.97223594012421 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9722359401242 40.7702891474555)
2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   0 0 1 0 0 gathering 0 0 0 0 0 0 0 0   POINT (-73.9724879969884 40.771098202397)
664 -73.9725174868556 40.7664248283566 3H-PM-1014-07 03H PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9725174868556 40.7664248283566)
2267 -73.97279263353971 40.77037055775 7F-AM-1008-07 07F AM 10082018 7 Adult Gray   Gray+   Above Ground 28 next to the hole of #6 0 0 0 0 0 standing 0 0 0 0 0 0 1 0   POINT (-73.9727926335397 40.77037055775)
1753 -73.9733437449715 40.778240154836205 14B-PM-1014-07 14B PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9733437449715 40.7782401548362)
879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9735120882106 40.7715915415169)
1245 -73.9739326393775 40.7779105370473 14A-PM-1014-07 14A PM 10142018 7 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.9739326393775 40.7779105370473)
2707 -73.97431653210991 40.775467467857396 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   1 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9743165321099 40.7754674678574)
2879 -73.9744080700098 40.773151572182606 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile 0 0 0 1 0   0 0 0 0 0 0 0 1 (me) POINT (-73.9744080700098 40.7731515721826)
1243 -73.97455562298549 40.767292104099795 3F-AM-1006-07 03F AM 10062018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE close to tall tree & light post 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9745556229855 40.7672921040998)
722 -73.9745953710328 40.7728284025195 8D-AM-1007-07 08D AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9745953710328 40.7728284025195)
1059 -73.97494575169209 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9749457516921 40.7676712372245)
761 -73.975062146111 40.7723417173451 8C-PM-1013-07 08C PM 10132018 7   Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.975062146111 40.7723417173451)
1771 -73.9750688083336 40.766558468102495 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9750688083336 40.7665584681025)
2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753585157592 40.7698398607941)
1687 -73.97547909645608 40.768336388516005 4E-PM-1008-07 04E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9754790964561 40.768336388516)
1861 -73.97555625268109 40.7678821029525 3E-AM-1006-07 03E AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 burying nuts 0 0 0 0 0 0 0 0   POINT (-73.9755562526811 40.7678821029525)
2986 -73.97565337638129 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9756533763813 40.7733537881363)
54 -73.97602982411779 40.7681954366911 3E-PM-1008-07 03E PM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9760298241178 40.7681954366911)
238 -73.9760942252437 40.7742035674209 9B-PM-1013-07 09B PM 10132018 7 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.97609422524371 40.7742035674209)
2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9761776424664 40.7695941843825)
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)
1209 -73.97631591531379 40.7705785330431 5C-AM-1006-07 05C AM 10062018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763159153138 40.7705785330431)
2784 -73.9763722433833 40.7744121430891 9A-AM-1013-07 09A AM 10132018 7 Adult     +         0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9763722433833 40.7744121430891)
1217 -73.9764850086767 40.7737340720562 8B-AM-1007-07 08B AM 10072018 7 Juvenile Gray Black Gray+Black   Above Ground 8   0 0 0 1 0 holding nut 0 0 0 0 0 0 1 0   POINT (-73.9764850086767 40.7737340720562)
1862 -73.97648512317541 40.771573686286104 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 ambling 0 0 0 0 0 1 0 1 trucks POINT (-73.9764851231754 40.7715736862861)
1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9765805609072 40.7692807820935)
2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9767590273554 40.7717561807266)
1226 -73.97684509716998 40.7709430375069 5C-PM-1010-07 05C PM 10102018 7 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 13   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.97684509717 40.7709430375069)
2462 -73.9768544488742 40.76800695009771 3D-AM-1006-07 03D AM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0 running (with food in mouth) 0 0 0 0 0 0 1 0   POINT (-73.9768544488742 40.7680069500977)
1073 -73.9769742179824 40.772748452182896 7B-AM-1008-07 07B AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9769742179824 40.7727484521829)
1793 -73.97715752493221 40.7673873716547 2E-AM-1010-07 02E AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9771575249322 40.7673873716547)
1580 -73.9775079672882 40.7691500357424 4C-PM-1010-07 04C PM 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.9775079672882 40.7691500357424)
1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9776445567926 40.768119107973)
2402 -73.9777206733344 40.7668595585487 1D-PM-1007-07 01D PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0 lying down 0 0 0 0 0 0 1 0   POINT (-73.9777206733344 40.7668595585487)
2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9784610031588 40.7668839966177)
816 -73.9785300509908 40.772112774842704 6A-AM-1006-07 06A AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9785300509908 40.7721127748427)
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)
407 -73.9787658435198 40.768941976539296 3B-PM-1007-07 03B PM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0 eating loudly <- peanuts w/ shells 0 0 0 0 0 0 1 0   POINT (-73.9787658435198 40.7689419765393)
2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0 together w/ #8 0 0 0 1 0 0 1 0   POINT (-73.9787771053108 40.76935621227501)
1648 -73.97902633720041 40.7683513714892 2C-PM-1013-07 02C PM 10132018 7 Adult Gray White Gray+White         1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9790263372004 40.7683513714892)
1236 -73.97920390711141 40.76787494712671 2C-AM-1010-07 02C AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 0 0 0 #7 & #8 chased each other up diff tree 0 0 0 0 0 0 0 1   POINT (-73.9792039071114 40.76787494712671)
2165 -73.9794371709817 40.768387910254 2B-PM-1013-07 02B PM 10132018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9794371709817 40.768387910254)
1281 -73.9795728289645 40.7678669804787 1C-PM-1013-07 01C PM 10132018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9795728289645 40.7678669804787)
910 -73.9796383715206 40.7682477738244 2B-AM-1010-07 02B AM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9796383715206 40.7682477738244)
1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9798390387307 40.7700761090896)
255 -73.9800669115792 40.767682513438395 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9800669115792 40.7676825134384)
2482 -73.9805927710872 40.76799891166421 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9805927710872 40.7679989116642)
1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 0 0 couldn't get near POINT (-73.9806718258385 40.76927768969951)
1105 -73.9811218801005 40.7684406206185 1A-PM-1014-07 01A PM 10142018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9811218801005 40.7684406206185)

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