squirrels

24 rows where Date = 10202018, Foraging = "true" and Police Precincts = 13 sorted by Approaches

View and edit SQL

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

Combination of Primary and Highlight Color

Foraging

  • true · 24
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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