2018_Central_Park_Squirrel_Census_-_Squirrel_Data

43 rows where Date = 10202018 and Foraging = 0 sorted by Shift

View and edit SQL

Suggested facets: Hectare, Shift, 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, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Foraging

Date

  • 10202018 · 43
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
243 -73.9754778808471 40.7685619029765 4E-AM-1020-01 04E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 0 0 sitting very still 0 0 0 0 0 0 1 0   POINT (-73.9754778808471 40.7685619029765)
264 -73.9698714743386 40.7743814661685 12F-AM-1020-02 12F AM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9698714743386 40.7743814661685)
477 -73.97014812002979 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701481200298 40.7751110354034)
1391 -73.95786586329571 40.7933712188923 35E-AM-1020-04 35E AM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 0 0 0 hunkered down,tail over body; sitting perfectly still 0 0 0 0 0 0 1 0   POINT (-73.9578658632957 40.7933712188923)
2159 -73.9696688162449 40.774142217718705 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9696688162449 40.7741422177187)
2550 -73.96948057455221 40.774355690284295 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree 0 0 0 0 0 jumping 0 0 0 0 0 0 0 0   POINT (-73.9694805745522 40.7743556902843)
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)
2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2883 -73.9698592838836 40.7743071443959 12F-AM-1020-03 12F AM 10202018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 1 0 0 0   POINT (-73.9698592838836 40.7743071443959)
2979 -73.9571808775915 40.793444386672505 35E-AM-1020-02 35E AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 0 0 0 cleaning herself 0 0 0 0 0 0 1 0   POINT (-73.9571808775915 40.7934443866725)
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 -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)
220 -73.96718161220299 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   0 0 1 1 0   0 0 0 0 0 0 0 0   POINT (-73.967181612203 40.7787752287055)
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 -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 -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)
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)
635 -73.96732355553209 40.7786749596774 17F-PM-1020-04 17F PM 10202018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground     0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9673235555321 40.7786749596774)
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)
1023 -73.97608800701859 40.7711057827923 6C-PM-1020-04 06C PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9760880070186 40.7711057827923)
1025 -73.9763506612375 40.771611393182 7C-PM-1020-05 07C PM 10202018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9763506612375 40.771611393182)
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)
1170 -73.9647904085226 40.7911589002217 30A-PM-1020-02 30A PM 10202018 2 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 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9647904085226 40.7911589002217)
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 -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 -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)
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 -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)
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)
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)
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)
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)
2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.96738215574692 40.7786375267659)
2110 -73.9647151303629 40.7912681060756 30A-PM-1020-03 30A PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9647151303629 40.7912681060756)
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)
2337 -73.9673490137465 40.778272813040104 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9673490137465 40.7782728130401)
2348 -73.9531965469704 40.794743798397704 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 1 1 0   POINT (-73.9531965469704 40.7947437983977)
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 -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)
2602 -73.97548229388691 40.771776689383294 7C-PM-1020-01 07C PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9754822938869 40.7717766893833)
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 -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)
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 145.31ms