2018_Central_Park_Squirrel_Census_-_Squirrel_Data

52 rows where Foraging = 0, Hectare Squirrel Number = 4 and Runs from = 1 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Kuks, Tail flags, Tail twitches, Approaches, Indifferent

Runs from ✖

Moans ✖

  • 0 52

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
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9623696148045 40.792184861375)
497 497 -73.96021668769791 40.7953811003986 36B-AM-1013-04 36B AM 10132018 4   Black   Black+   Above Ground 20 Moved 20+ feet high above top of tree limb 0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9602166876979 40.7953811003986)
509 509 -73.9714289592392 40.775067070209296 12E-PM-1018-04 12E PM 10182018 4 Adult Cinnamon   Cinnamon+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9714289592392 40.7750670702093)
667 667 -73.9624538733037 40.7883829851518 28D-AM-1012-04 28D AM 10122018 4 Adult Cinnamon White Cinnamon+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9624538733037 40.7883829851518)
1053 1053 -73.96858597054859 40.784880506532204 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685859705486 40.7848805065322)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1449 1449 -73.95611248920629 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   0 0 1 1 0   1 0 0 0 0 0 0 1   POINT (-73.9561124892063 40.7949440648632)
1476 1476 -73.976609486498 40.7717832922535 7C-PM-1020-04 07C PM 10202018 4 Adult Gray   Gray+   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.976609486498 40.7717832922535)
1608 1608 -73.9545425520879 40.7956853415959 39F-PM-1006-04 39F PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 in tree 0 0 1 0 0 climbing down 0 0 0 0 0 0 0 1 ran when saw me POINT (-73.9545425520879 40.7956853415959)
1665 1665 -73.95839443533521 40.7979689846815 39B-PM-1014-04 39B PM 10142018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 1 runs from (me—when i approached) POINT (-73.9583944353352 40.7979689846815)
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
1925 1925 -73.95813898706442 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   1 0 1 0 0 laid down on the branch 0 0 0 0 0 0 0 1   POINT (-73.9581389870644 40.799308112252305)
2018 2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9697924026634 40.7803611152023)
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   0 0 0 0 0 watching me - didn't move 0 0 0 0 1 0 0 1   POINT (-73.9680741975294 40.7847036778165)
2449 2449 -73.9599911537509 40.791445254284504 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9599911537509 40.7914452542845)
2634 2634 -73.96956851864891 40.7788293026327 16D-AM-1007-04 16D AM 10072018 4 Adult Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9695685186489 40.7788293026327)
2734 2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9763629541474 40.7682321897044)
2745 2745 -73.97296259363002 40.7652601851275 1I-PM-1012-04 01I PM 10122018 4 Juvenile Cinnamon White Cinnamon+White Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 2 on ledge 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.97296259363 40.7652601851275)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
2779 2779 -73.9767835160078 40.767403033048204 2E-PM-1014-04 02E PM 10142018 4 Adult Cinnamon White Cinnamon+White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9767835160078 40.7674030330482)
2862 2862 -73.967466716152 40.782434654827796 21D-PM-1008-04 21D PM 10082018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 0 1 0   0 0 0 0 0 0 0 1 i scared it POINT (-73.967466716152 40.7824346548278)
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9503533343658 40.7976543603953)
338 338 -73.9765595553183 40.7748455340432 10A-PM-1014-04 10A PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765595553183 40.7748455340432)
421 421 -73.9664630067791 40.775636151582496 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9664630067791 40.7756361515825)
493 493 -73.97768547979159 40.768310229566296 3D-AM-1006-04 03D AM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (boy on bike) POINT (-73.9776854797916 40.7683102295663)
511 511 -73.9653142636891 40.776001512929795 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9653142636891 40.7760015129298)
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652584749758 40.7803011124382)
618 618 -73.957976896139 40.797027128241 39C-AM-1017-04 39C AM 10172018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.957976896139 40.797027128241005)
627 627 -73.97637911214379 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   0 1 0 0 0 chasing (dog chasing) 0 0 0 0 0 0 0 1   POINT (-73.9763791121438 40.770281512254)
727 727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.9634563222926 40.780992836417)
824 824 -73.9606344681252 40.7958337780644 37B-PM-1013-04 37B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9606344681252 40.795833778064406)
916 916 -73.95618876244708 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 1 me POINT (-73.95618876244711 40.7958187455815)
932 932 -73.9718597156773 40.776585876331296 13C-PM-1019-04 13C PM 10192018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9718597156773 40.7765858763313)
1029 1029 -73.9601259189134 40.795535060905706 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9601259189134 40.7955350609057)
1176 1176 -73.9553263156025 40.79755920605721 40D-PM-1013-04 40D PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9553263156025 40.7975592060572)
1294 1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 1   POINT (-73.9604089940153 40.7910028063138)
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1 was with a lot of robins POINT (-73.9534910562766 40.7935774443789)
1780 1780 -73.9640945609381 40.7910513041359 30A-PM-1020-04 30A PM 10202018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE Rock 1 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9640945609381 40.7910513041359)
1794 1794 -73.97579123504819 40.774759862145096 10B-AM-1006-04 10B AM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9757912350482 40.7747598621451)
2060 2060 -73.9575798004084 40.795701403548996 38D-PM-1006-04 38D PM 10062018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 near drive -runners -cyclists POINT (-73.95757980040841 40.795701403549)
2094 2094 -73.9701630539326 40.7779553961101 15D-AM-1007-04 15D AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97016305393261 40.7779553961101)
2101 2101 -73.957600085245 40.7936111607879 35E-PM-1006-04 35E PM 10062018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.957600085245 40.7936111607879)
2162 2162 -73.9583300280173 40.7853495002675 27I-PM-1020-04 27I PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9583300280173 40.7853495002675)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)
2560 2560 -73.97554590905341 40.7680866624003 4E-AM-1020-04 04E AM 10202018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   0 0 0 0 0 chillin' 0 0 0 0 0 0 0 1   POINT (-73.9755459090534 40.7680866624003)
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.95795157569 40.7961254697958)
2809 2809 -73.9686756254868 40.777745910265104 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9686756254868 40.7777459102651)
2821 2821 -73.97545365660129 40.769860491877104 5E-PM-1012-04 05E PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9754536566013 40.7698604918771)
2847 2847 -73.9568378330302 40.788031780276604 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568378330302 40.7880317802766)
2909 2909 -73.9564478909357 40.79769287754171 40C-PM-1006-04 40C PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9564478909357 40.7976928775417)
2971 2971 -73.9639801411692 40.7778921302618 18I-PM-1007-04 18I PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 walking sitting up 0 0 0 0 0 0 0 1   POINT (-73.9639801411692 40.7778921302618)

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