squirrels

33 rows where Foraging = "false", Hectare Squirrel Number = 5 and Highlight Fur Color = "White" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Police Precincts

Highlight Fur Color

  • White · 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
1129 -73.9744906832678 40.7699948746776 6E-PM-1010-05 06E PM 10102018 5 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE   false false false true false could this squirrel be eating a white mushroom? false false false false false false true false   POINT (-73.9744906832678 40.76999487467761)   19 4 19 13
2344 -73.9786310308892 40.7669349368183 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9786310308892 40.7669349368183)   19 4 19 13
80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
277 -73.9619070229674 40.79525566925 35A-AM-1014-05 35A AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9619070229674 40.79525566925)   19 4 19 13
440 -73.9642717435966 40.782087049693 22F-AM-1007-05 22F AM 10072018 5 Adult Gray White Gray+White   Above Ground 10 tree false false true false false   false false false false false false true false   POINT (-73.9642717435966 40.782087049693)   19 4 19 13
532 -73.9685429060839 40.7724786961619 11H-AM-1010-05 11H AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9685429060839 40.7724786961619)   19 4 19 13
574 -73.9706360005275 40.7717074044466 9G-PM-1007-05 09G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9706360005275 40.7717074044466)   19 4 19 13
792 -73.9730115687964 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   false false true true false   false false false false false false false false   POINT (-73.9730115687964 40.7741018274312)   19 4 19 13
841 -73.9746933852572 40.773313866931 9C-PM-1006-05 09C PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true w/ dog POINT (-73.9746933852572 40.773313866931)   19 4 19 13
940 -73.9700879096644 40.7765899724756 14E-PM-1017-05 14E PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9700879096644 40.7765899724756)   19 4 19 13
1054 -73.9570050460867 40.7985192250745 40C-AM-1017-05 40C AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9570050460867 40.7985192250745)   19 4 19 13
1122 -73.9728700359494 40.7659842666881 3H-PM-1014-05 03H PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728700359494 40.7659842666881)   19 4 19 13
1141 -73.9664669369583 40.7774085361976 16G-AM-1010-05 16G AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9664669369583 40.7774085361976)   19 4 19 13
1157 -73.9704449096084 40.7689970778303 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing with #6 false false false false true false false false   POINT (-73.9704449096084 40.7689970778303)   19 4 19 13
1224 -73.9572530843479 40.7987460430546 41B-AM-1010-05 41B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9572530843479 40.7987460430546)   19 4 19 13
1259 -73.976864402584 40.7705663751959 5C-PM-1010-05 05C PM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false false false false false   POINT (-73.976864402584 40.7705663751959)   19 4 19 13
1292 -73.959019987128 40.7912546691805 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing false false false false false false false false   POINT (-73.959019987128 40.7912546691805)   19 4 19 13
1324 -73.954554245377 40.7983935730557 41E-AM-1007-05 41E AM 10072018 5 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true man/pit bull mix wandered POINT (-73.954554245377 40.7983935730557)   19 4 19 13
1403 -73.9761632586697 40.7741085606149 9B-PM-1013-05 09B PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false true false   POINT (-73.9761632586697 40.7741085606149)   19 4 19 13
1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false climbing fence! false false false false false false false false snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)   19 4 19 13
1604 -73.9734644470766 40.7782766486921 14A-PM-1014-05 14A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.97346444707661 40.7782766486921)   19 4 19 13
1745 -73.9688438058715 40.7703014325728 8I-AM-1006-05 08I AM 10062018 5 Adult Gray White Gray+White   Above Ground 20 tree false false true false false   false false false false false false true false   POINT (-73.9688438058715 40.7703014325728)   19 4 19 13
1758 -73.9581241870185 40.7961057536141 38C-AM-1019-05 38C AM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9581241870185 40.7961057536141)   19 4 19 13
1783 -73.9730001080547 40.7678719218983 4G-AM-1006-05 04G AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true false false climbing (tree) false false false false false false true false indifferent—was in front of my face (we were on a bridge)! POINT (-73.9730001080547 40.7678719218983)   19 4 19 13
2002 -73.9581706950566 40.7906321397269 32F-AM-1012-05 32F AM 10122018 5 Adult Gray White Gray+White   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9581706950566 40.7906321397269)   19 4 19 13
2084 -73.9567255763265 40.7936331899263 36F-AM-1017-05 36F AM 10172018 5 Adult Gray White Gray+White   Above Ground 8   false false false false false staying very still to avoid two very curious dogs on the ground false false false false false false false false petrified,frozen (tail over its back,frozen) POINT (-73.9567255763265 40.7936331899263)   19 4 19 13
2087 -73.956502663005 40.788160908881 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.956502663005 40.788160908881)   19 4 19 13
2173 -73.9546123259441 40.7941434862099 37G-PM-1007-05 37G PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false jumping around! false false false false false false false false   POINT (-73.9546123259441 40.7941434862099)   19 4 19 13
2659 -73.9553603438021 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   false false false true false   false false false false false false false false   POINT (-73.9553603438021 40.7985282963244)   19 4 19 13
2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   19 4 19 13
2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9802983138318 40.7676540772339)   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 78.275ms