2018_Central_Park_Squirrel_Census_-_Squirrel_Data

161 rows where Hectare Squirrel Number = 7 sorted by Primary Fur Color

View and edit SQL

Eating

  • 0 47
  • 1 14

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
1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9557399927792 40.7971563708988)
1659 -73.96904988769441 40.7700011818847 8I-AM-1006-07 08I AM 10062018 7 Adult Gray White Gray+White White ring on short tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690498876944 40.7700011818847)
1666 -73.96494654768709 40.7822708362663 22F-PM-1014-07 22F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649465476871 40.7822708362663)
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)
1738 -73.967975586222 40.77356830443129 12H-PM-1007-07 12H PM 10072018 7   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE grass field 0 0 0 0 1   0 0 0 0 0 0 0 1 humans POINT (-73.967975586222 40.7735683044313)
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)
1765 -73.9689041600147 40.7781788966185 16E-AM-1014-07 16E AM 10142018 7 Adult Gray   Gray+   Above Ground     1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9689041600147 40.7781788966185)
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)
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)
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)
1797 -73.96971780962751 40.769703669630104 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree 0 1 0 0 0 playing,interacting with #6 0 0 0 0 1 0 0 0   POINT (-73.9697178096275 40.769703669630104)
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)
1817 -73.9703076450783 40.770158422628995 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0 chasing (#8),playing? 0 0 0 0 0 0 1 0   POINT (-73.9703076450783 40.770158422629)
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)
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)
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)
1922 -73.9602197762862 40.7936850570022 35C-PM-1013-07 35C PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9602197762862 40.7936850570022)
1958 -73.96931200900549 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9693120090055 40.771096102012)
1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.958247706428 40.7989079136796)
1999 -73.95498609472341 40.79115503283089 34H-PM-1006-07 34H PM 10062018 7 Juvenile Gray White Gray+White white belly Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9549860947234 40.7911550328309)
2013 -73.96953483858279 40.7703657361802 8I-PM-1013-07 08I PM 10132018 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.9695348385828 40.7703657361802)
2057 -73.9579659543224 40.7905646887034 32F-AM-1012-07 32F AM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9579659543224 40.7905646887034)
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)
2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.954530253849 40.7910247489879)
2085 -73.9690551477139 40.782368566319604 20B-PM-1013-07 20B PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9690551477139 40.7823685663196)
2100 -73.9638312025305 40.7903826659569 30B-AM-1007-07 30B AM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9638312025305 40.7903826659569)
2104 -73.9622419917579 40.794579797904 35A-AM-1014-07 35A AM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9622419917579 40.794579797904)
2179 -73.95596639495109 40.7974497269789 40D-AM-1013-07 40D AM 10132018 7 Adult Gray   Gray+   Above Ground 6   0 0 1 0 1   0 0 0 0 0 0 0 1 curious POINT (-73.9559663949511 40.7974497269789)
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)
2193 -73.95693181052529 40.7973442139041 40C-PM-1006-07 40C PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9569318105253 40.7973442139041)
2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699124811406 40.7743016981538)
2217 -73.9652746477521 40.7809326848536 20F-PM-1007-07 20F PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon cinnamon tail Ground Plane FALSE   1 0 0 0 0 watching 0 0 0 1 0 0 0 1   POINT (-73.96527464775211 40.7809326848536)
2261 -73.9609692861012 40.790502891247 31D-AM-1014-07 31D AM 10142018 7   Gray   Gray+   Ground Plane FALSE Crossing path to tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9609692861012 40.790502891247)
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)
2292 -73.96698919404629 40.7835635162331 22C-PM-1006-07 22C PM 10062018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9669891940463 40.7835635162331)
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)
2301 -73.968906907671 40.781627826784295 19C-PM-1018-07 19C PM 10182018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.968906907671 40.7816278267843)
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)
2311 -73.96801718943509 40.772464442631296 11I-PM-1012-07 11I PM 10122018 7 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying its food into the ground 0 0 0 0 0 0 0 0   POINT (-73.96801718943512 40.7724644426313)
2332 -73.9709797467807 40.776909571067904 14D-AM-1014-07 14D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709797467807 40.7769095710679)
2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9695117797648 40.780267574323304)
2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
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)
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)
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)
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)
2567 -73.9690241805398 40.783796758077294 21B-AM-1019-07 21B AM 10192018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690241805398 40.7837967580773)
2623 -73.9604482901468 40.7898646293603 31E-PM-1006-07 31E PM 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.9604482901468 40.7898646293603)
2649 -73.9706428641753 40.7762933936464 13E-AM-1017-07 13E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706428641753 40.7762933936464)
2669 -73.9615900833886 40.7945431292846 35A-PM-1013-07 35A PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9615900833886 40.7945431292846)
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)
2713 -73.9687214684206 40.779284172016396 17D-AM-1008-07 17D AM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687214684206 40.7792841720164)
2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9543373703455 40.7943889087123)
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)
2780 -73.9700634278 40.778422372245295 16D-PM-1010-07 16D PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9700634278 40.7784223722453)
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)
2812 -73.963209639301 40.7926138443715 32A-PM-1013-07 32A PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.963209639301 40.7926138443715)
2823 -73.9664054327771 40.7756180893318 14H-PM-1012-07 14H PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9664054327771 40.7756180893318)
2825 -73.96435075880079 40.790432469329204 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.96435075880082 40.7904324693292)
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)
3021 -73.96658719935171 40.783677506488296 22D-PM-1012-07 22D PM 10122018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9665871993517 40.7836775064883)

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