2018_Central_Park_Squirrel_Census_-_Squirrel_Data

35 rows where Date = 10202018, Eating = 0 and Shift = "PM" sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Shift ✖

Eating ✖

Date ✖

  • 10202018 · 35 ✖
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
1755 1755 -73.97147981967771 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole 0 0 1 0 0   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9714798196777 40.7695231949631)
1077 1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 1 0 0 0 0 0 1   POINT (-73.9541837143178 40.7944340477396)
7 7 -73.9719735582476 40.769304513357795 6G-PM-1020-02 06G PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9719735582476 40.7693045133578)
193 193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9537691298752 40.7941272599797)
216 216 -73.97542703689841 40.770241150230795 6D-PM-1020-01 06D PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE Baseball field 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9754270368984 40.7702411502308)
316 316 -73.9540616660191 40.795155660324504 38G-PM-1020-10 38G PM 10202018 10 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.9540616660191 40.7951556603245)
337 337 -73.95831019276521 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree 1 0 0 0 0   0 0 0 0 0 0 0 1 runs from (us) POINT (-73.9583101927652 40.7852649316039)
356 356 -73.97610364001441 40.77054826845939 6D-PM-1020-03 06D PM 10202018 3 Juvenile Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9761036400144 40.7705482684594)
410 410 -73.9584024936392 40.785149170194394 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1 runs from (us) POINT (-73.9584024936392 40.7851491701944)
539 539 -73.97614406279659 40.770603530154204 6D-PM-1020-04 06D PM 10202018 4   Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9761440627966 40.7706035301542)
984 984 -73.9672950266018 40.7782477517567 17F-PM-1020-01 17F PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9672950266018 40.7782477517567)
1047 1047 -73.9580111056675 40.785433940148295 27I-PM-1020-02 27I PM 10202018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9580111056675 40.7854339401483)
1218 1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.953375642605 40.7947144477885)
1263 1263 -73.9770873939997 40.771037966210606 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9770873939997 40.7710379662106)
1367 1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542684235907 40.7944237164092)
1368 1368 -73.95427708888809 40.794361036685295 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542770888881 40.79436103668531)
1377 1377 -73.9752263564287 40.772084917017004 7C-PM-1020-02 07C PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9752263564287 40.772084917017)
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)
1481 1481 -73.95388671863759 40.794140943400706 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9538867186376 40.7941409434007)
1497 1497 -73.9722261495647 40.7690542072646 6G-PM-1020-03 06G PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9722261495647 40.7690542072646)
1629 1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 1 0 0 0 0 0 0   POINT (-73.9759428006237 40.7715081817329)
1657 1657 -73.97682540587091 40.7716757945251 6C-PM-1020-03 06C PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9768254058709 40.7716757945251)
1888 1888 -73.9673919075839 40.7786845769177 17F-PM-1020-05 17F PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9673919075839 40.7786845769177)
2024 2024 -73.97224722861509 40.7699550476176 6G-PM-1020-04 06G PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9722472286151 40.7699550476176)
2088 2088 -73.96511558803459 40.790694632578 30A-PM-1020-01 30A PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9651155880346 40.790694632578)
2131 2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9752225195115 40.7703747669865)
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)
2399 2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0 begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)
2592 2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9758128509653 40.7715946097064)
2642 2642 -73.97514547259979 40.770291361572 6D-PM-1020-06 06D PM 10202018 6 Adult Gray White Gray+White   Ground Plane FALSE by carousel 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9751454725998 40.770291361572006)
2759 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)
2861 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)
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)
3002 3002 -73.9710991846972 40.768982782424104 6H-PM-1020-01 06H PM 10202018 1 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.9710991846972 40.7689827824241)
3016 3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9756457597888 40.7703559775625)

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