2018_Central_Park_Squirrel_Census_-_Squirrel_Data

29 rows where Chasing = 1 and Hectare Squirrel Number = 1 sorted by Primary Fur Color

View and edit SQL

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

Foraging

  • 0 24
  • 1 5

Eating

  • 0 25
  • 1 4

Hectare Squirrel Number

Chasing

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
2351 -73.97458184501092 40.765449887362706 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9745818450109 40.7654498873627)
1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree 0 1 0 0 0 watching me 0 1 0 1 0 0 0 0 observant POINT (-73.9667474482967 40.7760643720793)
2387 -73.98085173247209 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9808517324721 40.7683154647217)
38 -73.9742073452913 40.7757957380463 12B-AM-1007-01 12B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9742073452913 40.7757957380463)
82 -73.96882712024009 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9688271202401 40.7809719445309)
144 -73.9730750601212 40.7701304211944 6F-PM-1008-01 06F PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730750601212 40.7701304211944)
633 -73.9673243699918 40.787539295772206 26A-AM-1014-01 26A AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0 could not get close due to fences POINT (-73.9673243699918 40.7875392957722)
751 -73.9683479943823 40.7815827298303 20C-PM-1018-01 20C PM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9683479943823 40.7815827298303)
840 -73.9598084794625 40.797616543450204 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598084794625 40.7976165434502)
874 -73.95919577939921 40.79495688734529 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9591957793992 40.7949568873453)
906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96641208260151 40.7888022709721)
911 -73.9697277998257 40.7705198722028 8H-AM-1017-01 08H AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697277998257 40.7705198722028)
1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   1 1 0 0 0 for food 0 1 0 0 0 0 0 0   POINT (-73.9670850805619 40.7833747810387)
1007 -73.96353178229771 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   1 0 0 1 0 0 1 0   POINT (-73.9635317822977 40.7821352080233)
1055 -73.9632337134707 40.791468237073396 31B-PM-1007-01 31B PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 1 0 0 chasing #2 and climbing tree w/ #2 0 0 0 0 0 0 0 1   POINT (-73.9632337134707 40.7914682370734)
1147 -73.96318185288159 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9631818528816 40.7925332194132)
1264 -73.97853537753821 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9785353775382 40.7674923683184)
1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
1835 -73.9562068537632 40.796733285323796 39D-AM-1008-01 39D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562068537632 40.7967332853238)
1864 -73.9694344956258 40.7742869276902 12G-PM-1007-01 12G PM 10072018 1   Gray   Gray+   Above Ground 40 in tree 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9694344956258 40.7742869276902)
1997 -73.97146376830841 40.776898456156296 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9714637683084 40.7768984561563)
2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2142 -73.95985354257058 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0 hanging on fence 1 0 0 1 0 0 0 1   POINT (-73.9598535425706 40.7915589343685)
2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0 chasing (#2) 0 0 0 0 0 0 0 1   POINT (-73.9573656523498 40.7979754563974)
2313 -73.9646174034945 40.778128752826206 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other 1 1 0 0 0 playing? 0 0 0 0 0 0 0 0   POINT (-73.9646174034945 40.7781287528262)
2466 -73.95994199262991 40.797277472881106 38A-AM-1019-01 38A AM 10192018 1 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599419926299 40.7972774728811)
2652 -73.96205425147491 40.794373172213795 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9620542514749 40.7943731722138)
2861 -73.9720102361126 40.7692143930301 6G-PM-1020-01 06G PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9720102361126 40.7692143930301)
2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)

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