2018_Central_Park_Squirrel_Census_-_Squirrel_Data

86 rows where Foraging = 0 and Hectare Squirrel Number = 7 sorted by Specific Location

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

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
2189 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 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)
2217 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)
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)
2301 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 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)
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)
2372 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 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)
2454 2454 -73.9565151662506 40.794664798744705 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 me POINT (-73.9565151662506 40.7946647987447)
2462 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)
2482 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)
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)
2713 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)
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)
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9647845655965 40.7816573808695)
2804 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 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)
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)
879 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)
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)
1897 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)
1797 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)
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #6 0 0 0 0 1 0 0 1   POINT (-73.9559677963727 40.7951124076946)
1142 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)
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)
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)
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)
2879 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)
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)
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)
602 602 -73.96857515954851 40.7709413567859 9I-PM-1010-07 09I PM 10102018 7 Adult Gray White Gray+White   Above Ground 1 ran up tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685751595485 40.7709413567859)
856 856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.95916671628011 40.7937602121568)
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)

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