2018_Central_Park_Squirrel_Census_-_Squirrel_Data

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

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 61

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
379 379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9606817053484 40.7917320450401)
2825 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)
3021 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)
301 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)
1217 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)
1843 1843 -73.9685940262068 40.776932102013 15F-AM-1007-07 15F AM 10072018 7 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685940262068 40.776932102013)
28 28 -73.958736593111 40.790852437062604 32F-PM-1008-07 32F PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958736593111 40.7908524370626)
76 76 -73.9530035564643 40.792182245761296 36I-PM-1007-07 36I PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9530035564643 40.7921822457613)
103 103 -73.96077013704429 40.7955418990855 36A-PM-1013-07 36A PM 10132018 7   Gray   Gray+   Ground Plane FALSE "FIELD" 0 1 0 0 0 chasing #8 0 0 0 0 0 0 0 1   POINT (-73.9607701370443 40.7955418990855)
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651601541795 40.7761841788025)
129 129 -73.9705092958892 40.7761092972965 13E-PM-1008-07 13E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9705092958892 40.7761092972965)
134 134 -73.9575943815564 40.7933755266787 35E-PM-1006-07 35E PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9575943815564 40.7933755266787)
237 237 -73.96789565689801 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.967895656898 40.7767409597341)
255 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)
322 322 -73.9546042927016 40.7898133734952 33I-PM-1006-07 33I PM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9546042927016 40.7898133734952)
434 434 -73.96766397404859 40.7745369616499 13H-PM-1010-07 13H PM 10102018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9676639740486 40.7745369616499)
559 559 -73.9704166194815 40.7766720346576 14E-AM-1008-07 14E AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 0 0 1 0   POINT (-73.9704166194815 40.7766720346576)
668 668 -73.9706903740547 40.7726873760687 10G-AM-1006-07 10G AM 10062018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9706903740547 40.77268737606871)
770 770 -73.95977827620291 40.79207733767571 33D-AM-1017-07 33D AM 10172018 7 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 1 0 1 0 0 1 0   POINT (-73.9597782762029 40.7920773376757)
812 812 -73.9699675160516 40.7773012642758 15E-PM-1008-07 15E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9699675160516 40.7773012642758)
910 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)
926 926 -73.9596006938677 40.7834706440535 25I-PM-1007-07 25I PM 10072018 7 Adult Gray   Gray+   Above Ground   playing very high in tree w/ #8 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9596006938677 40.7834706440535)
980 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)
1066 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)
1073 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)
1173 1173 -73.959070754026 40.790667514341294 32E-PM-1017-07 32E PM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE treed area 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.959070754026 40.7906675143413)
1207 1207 -73.95947083287321 40.791192982895005 32E-AM-1007-07 32E AM 10072018 7 Adult Gray   Gray+   Above Ground   on tennis club house roof 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9594708328732 40.791192982895)
1361 1361 -73.961934398055 40.79247895485221 33B-PM-1010-07 33B PM 10102018 7 Adult     +   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.961934398055 40.7924789548522)
1388 1388 -73.9685709455958 40.774487702650596 12G-PM-1007-07 12G PM 10072018 7 Juvenile     +   Above Ground 45   0 0 0 1 0 acorns 0 0 0 0 0 0 0 0   POINT (-73.9685709455958 40.7744877026506)
1389 1389 -73.9580021017892 40.7955140102242 37D-PM-1014-07 37D PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9580021017892 40.7955140102242)
1390 1390 -73.9677146741772 40.77882313323371 17E-AM-1017-07 17E AM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9677146741772 40.7788231332337)
1438 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)
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 1 0 got fed twice by grandpa,grabbed from grass and ate in tree 0 0 0 0 0 1 1 1 approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)
1517 1517 -73.970041085185 40.7834427580313 21A-AM-1019-07 21A AM 10192018 7 Adult Gray   Gray+   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.970041085185 40.783442758031306)
1666 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)
1688 1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9677593344667 40.7763054313195)
1765 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 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)
1817 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)
1922 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 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)
2080 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)
2100 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)
2165 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)
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9684092812839 40.7711445841928)
2179 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)
2193 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)
2261 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 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 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 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)
2311 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)
2339 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 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)
2402 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)
2554 2554 -73.9701505245419 40.768998364571 6I-PM-1013-07 06I PM 10132018 7 Adult Cinnamon   Cinnamon+   Above Ground 11   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701505245419 40.768998364571004)
2567 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)
2572 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)
2707 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)
2780 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)
2784 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)

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