squirrels

33 rows where Combination of Primary and Highlight Color = "Gray+", Hectare Squirrel Number = 1, Indifferent = "false", Police Precincts = 13 and Runs from = "true" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Other Interactions

Indifferent ✖

  • false · 33 ✖

Hectare Squirrel Number ✖

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
177 177 -73.9554432393295 40.7945669054449 37F-PM-1014-01 37F PM 10142018 1   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9554432393295 40.7945669054449)   19 4 19 13
244 244 -73.9597648775789 40.7903443029725 32E-AM-1007-01 32E AM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9597648775789 40.7903443029725)   19 4 19 13
283 283 -73.9529060669193 40.7927909735388 37I-AM-1010-01 37I AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9529060669193 40.7927909735388)   19 4 19 13
417 417 -73.9639888092327 40.791449395909 31A-AM-1010-01 31A AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9639888092327 40.791449395909005)   19 4 19 13
507 507 -73.9744835563086 40.7729521433235 9D-AM-1008-01 09D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9744835563086 40.7729521433235)   19 4 19 13
621 621 -73.9588886083793 40.7909991733435 32E-PM-1017-01 32E PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9588886083793 40.7909991733435)   19 4 19 13
623 623 -73.9662939630722 40.7878502338031 26B-AM-1010-01 26B AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE running across bridle path true false false false false   false false false false false false false true   POINT (-73.9662939630722 40.7878502338031)   19 4 19 13
653 653 -73.9703401385684 40.7795238784266 17C-PM-1013-01 17C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE then perched on 2-ft high border fencing false false false false true   false false false false false false false true   POINT (-73.9703401385684 40.7795238784266)   19 4 19 13
675 675 -73.9759830650957 40.7683034739069 3E-AM-1006-01 03E AM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9759830650957 40.7683034739069)   19 4 19 13
730 730 -73.9607280801601 40.7901506706248 31D-PM-1006-01 31D PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9607280801601 40.7901506706248)   19 4 19 13
777 777 -73.9654210263521 40.7782529692575 17G-AM-1018-01 17G AM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9654210263521 40.77825296925751)   19 4 19 13
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false false true   POINT (-73.96641208260151 40.7888022709721)   19 4 19 13
951 951 -73.971791854883 40.7802971729784 17B-PM-1012-01 17B PM 10122018 1 Adult Gray   Gray+   Above Ground 2 climbed a fence true false false false true   false false false false false false false true   POINT (-73.971791854883 40.7802971729784)   19 4 19 13
1033 1033 -73.975673607467 40.7699044294204 5D-PM-1018-01 05D PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.975673607467 40.7699044294204)   19 4 19 13
1051 1051 -73.9613747032702 40.7920483852431 33C-PM-1007-01 33C PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9613747032702 40.792048385243106)   19 4 19 13
1096 1096 -73.9568300899773 40.7935855743354 36E-AM-1013-01 36E AM 10132018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran into treebrush) POINT (-73.9568300899773 40.7935855743354)   19 4 19 13
1206 1206 -73.9748709206354 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   false false true false false   true false false false false false false true   POINT (-73.9748709206354 40.77608025411)   19 4 19 13
1298 1298 -73.9612900553755 40.7912917391867 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9612900553755 40.7912917391867)   19 4 19 13
1357 1357 -73.9631350020634 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false true false false true   POINT (-73.9631350020634 40.791907210332)   19 4 19 13
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car true false false false false   false false false false false false false true   POINT (-73.9725700261894 40.7668793330427)   19 4 19 13
2143 2143 -73.9596232170232 40.7959550843229 37B-PM-1013-01 37B PM 10132018 1 Adult Gray   Gray+ Sighting was far away Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9596232170232 40.795955084322905)   19 4 19 13
2338 2338 -73.9716621112698 40.7742862219469 11E-AM-1013-01 11E AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9716621112698 40.7742862219469)   19 4 19 13
2345 2345 -73.965738547469 40.7886962740167 27B-PM-1006-01 27B PM 10062018 1 Adult Gray   Gray+   Ground Plane FALSE By large tree false false false true true   false false false false false false false true   POINT (-73.965738547469 40.7886962740167)   19 4 19 13
2435 2435 -73.972087127535 40.776237268628 13C-AM-1010-01 13C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.972087127535 40.776237268628)   19 4 19 13
2565 2565 -73.9708640291801 40.7781721063527 15C-AM-1010-01 15C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9708640291801 40.7781721063527)   19 4 19 13
2621 2621 -73.9596904740342 40.7897200025671 31E-AM-1014-01 31E AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9596904740342 40.7897200025671)   19 4 19 13
2678 2678 -73.9562946873694 40.7938593012595 36F-AM-1017-01 36F AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (dog) POINT (-73.9562946873694 40.7938593012595)   19 4 19 13
2924 2924 -73.9727230609785 40.7795341640894 16A-PM-1019-01 16A PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9727230609785 40.7795341640894)   19 4 19 13
2929 2929 -73.953123365424 40.7941113777459 38H-PM-1012-01 38H PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.953123365424 40.7941113777459)   19 4 19 13
2182 2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#2) false false false false false false false true   POINT (-73.9573656523498 40.7979754563974)   19 4 19 13
833 833 -73.9741846413977 40.7762518164182 12B-PM-1018-01 12B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE Climbing up rocks false false true false true climbing (up rocks) false false false false false false false true   POINT (-73.9741846413977 40.7762518164182)   19 4 19 13
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
265 265 -73.9691094942294 40.776760392858 14E-AM-1008-01 14E AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false walking false false false false false false false true   POINT (-73.9691094942294 40.776760392858)   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 4799.011ms