squirrels

67 rows where Date = 10202018

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Hectare

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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
7 -73.9719735582476 40.7693045133578 6G-PM-1020-02 06G PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9719735582476 40.7693045133578)   19 4 19 13
74 -73.9546654184146 40.7947639241491 38G-PM-1020-09 38G PM 10202018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false true false   POINT (-73.9546654184146 40.7947639241491)   19 4 19 13
193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9537691298752 40.7941272599797)   19 4 19 13
198 -73.9761107065353 40.769642060286 5D-AM-1020-01 05D AM 10202018 1 Adult     + Too far & cloudy to tell Above Ground 30   false false false false true   false false false false false false false false   POINT (-73.9761107065353 40.769642060286)   19 4 19 13
216 -73.9754270368984 40.7702411502308 6D-PM-1020-01 06D PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE Baseball field false false false false true   false false false false false false true false   POINT (-73.9754270368984 40.7702411502308)   19 4 19 13
220 -73.967181612203 40.7787752287055 17F-PM-1020-03 17F PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35   false false true true false   false false false false false false false false   POINT (-73.967181612203 40.7787752287055)   19 4 19 13
241 -73.9760256477558 40.7703573131398 5D-AM-1020-02 05D AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false true small jumps false false false false false false false false   POINT (-73.9760256477558 40.7703573131398)   19 4 19 13
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   false false true false false sitting very still false false false false false false true false   POINT (-73.9754778808471 40.7685619029765)   19 4 19 13
264 -73.9698714743386 40.7743814661685 12F-AM-1020-02 12F AM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9698714743386 40.7743814661685)   19 4 19 13
316 -73.9540616660191 40.7951556603245 38G-PM-1020-10 38G PM 10202018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9540616660191 40.7951556603245)   19 4 19 13
337 -73.9583101927652 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree true false false false false   false false false false false false false true runs from (us) POINT (-73.9583101927652 40.7852649316039)   19 4 19 13
356 -73.9761036400144 40.7705482684594 6D-PM-1020-03 06D PM 10202018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9761036400144 40.7705482684594)   19 4 19 13
410 -73.9584024936392 40.7851491701944 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true true runs from (us) POINT (-73.9584024936392 40.7851491701944)   19 4 19 13
477 -73.9701481200298 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9701481200298 40.7751110354034)   19 4 19 13
539 -73.9761440627966 40.7706035301542 6D-PM-1020-04 06D PM 10202018 4   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9761440627966 40.7706035301542)   19 4 19 13
605 -73.9573930079918 40.7934570294469 35E-AM-1020-03 35E AM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9573930079918 40.7934570294469)   19 4 19 13
635 -73.9673235555321 40.7786749596774 17F-PM-1020-04 17F PM 10202018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground     false false false true false   false false false false false false false false   POINT (-73.9673235555321 40.7786749596774)   19 4 19 13
962 -73.9715466850324 40.7695584933538 6H-PM-1020-03 06H PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false false true runs from (kids kicking the fence) POINT (-73.9715466850324 40.7695584933538)   19 4 19 13
984 -73.9672950266018 40.7782477517567 17F-PM-1020-01 17F PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   false false true false false   false false false false false false false true   POINT (-73.9672950266018 40.7782477517567)   19 4 19 13
1023 -73.9760880070186 40.7711057827923 6C-PM-1020-04 06C PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9760880070186 40.7711057827923)   19 4 19 13
1025 -73.9763506612375 40.771611393182 7C-PM-1020-05 07C PM 10202018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9763506612375 40.771611393182)   19 4 19 13
1047 -73.9580111056675 40.7854339401483 27I-PM-1020-02 27I PM 10202018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9580111056675 40.7854339401483)   19 4 19 13
1077 -73.9541837143178 40.7944340477396 38G-PM-1020-06 38G PM 10202018 6 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false true false false false false false true   POINT (-73.9541837143178 40.7944340477396)   19 4 19 13
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 false false false true false   false false false false false false false true   POINT (-73.9647904085226 40.7911589002217)   19 4 19 13
1218 -73.953375642605 40.7947144477885 38G-PM-1020-02 38G PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.953375642605 40.7947144477885)   19 4 19 13
1263 -73.9770873939997 40.7710379662106 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9770873939997 40.7710379662106)   19 4 19 13
1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542684235907 40.7944237164092)   19 4 19 13
1368 -73.9542770888881 40.7943610366853 38G-PM-1020-04 38G PM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false true false true false false true false   POINT (-73.9542770888881 40.79436103668531)   19 4 19 13
1377 -73.9752263564287 40.772084917017 7C-PM-1020-02 07C PM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9752263564287 40.772084917017)   19 4 19 13
1391 -73.9578658632957 40.7933712188923 35E-AM-1020-04 35E AM 10202018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   false false false false false hunkered down,tail over body; sitting perfectly still false false false false false false true false   POINT (-73.9578658632957 40.7933712188923)   19 4 19 13
1476 -73.976609486498 40.7717832922535 7C-PM-1020-04 07C PM 10202018 4 Adult Gray   Gray+   Above Ground 1   false false true false false   false false false false false false false true   POINT (-73.976609486498 40.7717832922535)   19 4 19 13
1481 -73.9538867186376 40.7941409434007 38G-PM-1020-03 38G PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9538867186376 40.7941409434007)   19 4 19 13
1497 -73.9722261495647 40.7690542072646 6G-PM-1020-03 06G PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9722261495647 40.7690542072646)   19 4 19 13
1514 -73.9548006161673 40.7945503341011 38G-PM-1020-08 38G PM 10202018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   true false false true false false true false   POINT (-73.9548006161673 40.7945503341011)   19 4 19 13
1595 -73.9754696312232 40.768191647092 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   false false true false true foraging (on the tree itself) false false false false false false true false   POINT (-73.9754696312232 40.768191647092)   19 4 19 13
1629 -73.9759428006237 40.7715081817329 7C-PM-1020-06 07C PM 10202018 6 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false true false false false false false false   POINT (-73.9759428006237 40.7715081817329)   19 4 19 13
1657 -73.9768254058709 40.7716757945251 6C-PM-1020-03 06C PM 10202018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9768254058709 40.7716757945251)   19 4 19 13
1755 -73.9714798196777 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole false false true false false   false false false false false false false true runs from (me) POINT (-73.9714798196777 40.7695231949631)   19 4 19 13
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 true false false true false   false false false false false false false true   POINT (-73.9640945609381 40.7910513041359)   19 4 19 13
1810 -73.9579506263361 40.7936973555953 35E-AM-1020-01 35E AM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579506263361 40.7936973555953)   19 4 19 13
1888 -73.9673919075839 40.7786845769177 17F-PM-1020-05 17F PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9673919075839 40.7786845769177)   19 4 19 13
2010 -73.9673821557469 40.7786375267659 17F-PM-1020-06 17F PM 10202018 6 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false false false   POINT (-73.96738215574692 40.7786375267659)   19 4 19 13
2024 -73.9722472286151 40.7699550476176 6G-PM-1020-04 06G PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9722472286151 40.7699550476176)   19 4 19 13
2088 -73.9651155880346 40.790694632578 30A-PM-1020-01 30A PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9651155880346 40.790694632578)   19 4 19 13
2110 -73.9647151303629 40.7912681060756 30A-PM-1020-03 30A PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rock false false false true false   false false false false false false false true   POINT (-73.9647151303629 40.7912681060756)   19 4 19 13
2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9752225195115 40.7703747669865)   19 4 19 13
2159 -73.9696688162449 40.7741422177187 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9696688162449 40.7741422177187)   19 4 19 13
2162 -73.9583300280173 40.7853495002675 27I-PM-1020-04 27I PM 10202018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9583300280173 40.7853495002675)   19 4 19 13
2291 -73.9756894776708 40.7681638218212 4E-AM-1020-03 04E AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9756894776708 40.7681638218212)   19 4 19 13
2337 -73.9673490137465 40.7782728130401 17F-PM-1020-02 17F PM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false true false   false false false false false false false true   POINT (-73.9673490137465 40.7782728130401)   19 4 19 13
2348 -73.9531965469704 40.7947437983977 38G-PM-1020-11 38G PM 10202018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false true true false   POINT (-73.9531965469704 40.7947437983977)   19 4 19 13
2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false false begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)   19 4 19 13
2453 -73.9756105226696 40.7696531972655 5D-AM-1020-03 05D AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9756105226696 40.7696531972655)   19 4 19 13
2550 -73.9694805745522 40.7743556902843 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree false false false false false jumping false false false false false false false false   POINT (-73.9694805745522 40.7743556902843)   19 4 19 13
2560 -73.9755459090534 40.7680866624003 4E-AM-1020-04 04E AM 10202018 4 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false false chillin' false false false false false false false true   POINT (-73.9755459090534 40.7680866624003)   19 4 19 13
2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9758128509653 40.7715946097064)   19 4 19 13
2602 -73.9754822938869 40.7717766893833 7C-PM-1020-01 07C PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9754822938869 40.7717766893833)   19 4 19 13
2642 -73.9751454725998 40.770291361572 6D-PM-1020-06 06D PM 10202018 6 Adult Gray White Gray+White   Ground Plane FALSE by carousel false false false false true   false false false false false false true false   POINT (-73.9751454725998 40.770291361572006)   19 4 19 13
2667 -73.9759510842771 40.769288289111 5D-AM-1020-04 05D AM 10202018 4 Adult Gray Black, White Gray+Black, White White selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9759510842771 40.76928828911101)   19 4 19 13
2759 -73.9543373703455 40.7943889087123 38G-PM-1020-07 38G PM 10202018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false true false true false false true false   POINT (-73.9543373703455 40.7943889087123)   19 4 19 13
2861 -73.9720102361126 40.7692143930301 6G-PM-1020-01 06G PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9720102361126 40.7692143930301)   19 4 19 13
2878 -73.969720780557 40.7741105688757 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false false true false false false   POINT (-73.969720780557 40.7741105688757)   19 4 19 13
2883 -73.9698592838836 40.7743071443959 12F-AM-1020-03 12F AM 10202018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false false playing false false false false true false false false   POINT (-73.9698592838836 40.7743071443959)   19 4 19 13
2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse false false true false false   false false false false false false true false   POINT (-73.9766693184436 40.7708879215854)   19 4 19 13
2979 -73.9571808775915 40.7934443866725 35E-AM-1020-02 35E AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false false false false cleaning herself false false false false false false true false   POINT (-73.9571808775915 40.7934443866725)   19 4 19 13
3002 -73.9710991846972 40.7689827824241 6H-PM-1020-01 06H PM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9710991846972 40.7689827824241)   19 4 19 13
3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9756457597888 40.7703559775625)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 81.102ms