squirrels

67 rows where Date = 10202018

✎ View and edit SQL

This data as json, CSV (advanced)

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, Runs from, Other Interactions

Hectare ✖

Indifferent ✖

Foraging ✖

Date ✖

  • 10202018 · 67 ✖
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 68.755ms