squirrels

25 rows where Date = 10142018, Foraging = "true" and Highlight Fur Color = "Cinnamon, White"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Eating, Other Activities, Tail twitches, Approaches, Indifferent, Runs from

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
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9708969246276 40.7767695507462)   19 4 19 13
351 351 -73.9713330594434 40.7771924214236 14D-AM-1014-10 14D AM 10142018 10 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.9713330594434 40.7771924214236)   19 4 19 13
541 541 -73.9617612388703 40.7952875954297 35A-AM-1014-04 35A AM 10142018 4 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.9617612388703 40.7952875954297)   19 4 19 13
734 734 -73.9714921188372 40.776758371867 14D-AM-1014-11 14D AM 10142018 11 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.9714921188372 40.776758371867)   19 4 19 13
826 826 -73.9557263533489 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN false false false true true   false false false false false false true false   POINT (-73.95572635334891 40.7939505791448)   19 4 19 13
842 842 -73.9645147011741 40.7772566833799 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true true false   POINT (-73.9645147011741 40.7772566833799)   19 4 19 13
843 843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
1036 1036 -73.9709207551033 40.7767932008037 14D-AM-1014-04 14D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9709207551033 40.7767932008037)   19 4 19 13
1245 1245 -73.9739326393775 40.7779105370473 14A-PM-1014-07 14A PM 10142018 7 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.9739326393775 40.7779105370473)   19 4 19 13
1295 1295 -73.9709534894049 40.7765964740768 14D-AM-1014-15 14D AM 10142018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9709534894049 40.7765964740768)   19 4 19 13
1359 1359 -73.9708782966369 40.776946866963 14D-AM-1014-08 14D AM 10142018 8 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.9708782966369 40.77694686696301)   19 4 19 13
1424 1424 -73.9709722223794 40.7767329646325 14D-AM-1014-06 14D AM 10142018 6 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.9709722223794 40.7767329646325)   19 4 19 13
1603 1603 -73.9545929242174 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9545929242174 40.7986940168685)   19 4 19 13
1686 1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch false false false false true digging? false false false false true false true false   POINT (-73.95933730937992 40.7982428507976)   19 4 19 13
1786 1786 -73.9709407456459 40.776423522087 14D-AM-1014-13 14D AM 10142018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true false   POINT (-73.9709407456459 40.776423522087)   19 4 19 13
1791 1791 -73.9710907175834 40.77637391082 13D-AM-1014-07 13D AM 10142018 7 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.9710907175834 40.77637391082)   19 4 19 13
1800 1800 -73.970962498391 40.7766899040856 14D-AM-1014-05 14D AM 10142018 5 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.970962498391 40.7766899040856)   19 4 19 13
2039 2039 -73.9708371806429 40.7764813666684 14D-AM-1014-14 14D AM 10142018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true false   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
2108 2108 -73.9702420100291 40.7772720889907 14D-AM-1014-02 14D AM 10142018 2 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.9702420100291 40.7772720889907)   19 4 19 13
2332 2332 -73.9709797467807 40.7769095710679 14D-AM-1014-07 14D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9709797467807 40.7769095710679)   19 4 19 13
2655 2655 -73.9659156108069 40.7810709818696 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9659156108069 40.7810709818696)   19 4 19 13
2849 2849 -73.9709912560997 40.7758965595198 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9709912560997 40.7758965595198)   19 4 19 13
2901 2901 -73.9735833104203 40.7786318041581 14A-PM-1014-08 14A PM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true new movement flailing arms while foraging false false false false false false false true   POINT (-73.9735833104203 40.7786318041581)   19 4 19 13
2922 2922 -73.9703421391442 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9703421391442 40.7773706575356)   19 4 19 13
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9730926233232 40.7781330751738)   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 55.369ms