squirrels

20 rows where Date = 10072018, Highlight Fur Color = "White", Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches, Approaches, Other Interactions

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
348 348 -73.9542990150586 40.7940915300678 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false false false false false   POINT (-73.9542990150586 40.7940915300678)   19 4 19 13
349 349 -73.9689657039917 40.7767834276767 15F-AM-1007-04 15F AM 10072018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9689657039917 40.7767834276767)   19 4 19 13
354 354 -73.9566751022336 40.799035789744 41C-PM-1007-04 41C PM 10072018 4 Adult Gray White Gray+White   Above Ground 65   false false true false false   false false false false false false false false   POINT (-73.9566751022336 40.799035789744)   19 4 19 13
385 385 -73.979316275899 40.7692134727555 3B-PM-1007-01 03B PM 10072018 1 Adult Gray White Gray+White   Above Ground   in tree false false false false false chased by dog false false false false false false false false   POINT (-73.979316275899 40.7692134727555)   19 4 19 13
561 561 -73.9581982486469 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   true false true false false   false false false false true false false false   POINT (-73.95819824864691 40.7992194575293)   19 4 19 13
1342 1342 -73.9662063642345 40.7890778665307 28A-PM-1007-04 28A PM 10072018 4 Adult Gray White Gray+White         false false false false false looking at me & #5 true false false false true false false false freezes POINT (-73.9662063642345 40.7890778665307)   19 4 19 13
1494 1494 -73.9525752408169 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9525752408169 40.7954915417553)   19 4 19 13
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   false false true false false   false false false false true false false false curious,but wary POINT (-73.97699695480242 40.7710711265211)   19 4 19 13
1826 1826 -73.9707542189896 40.7717032986885 9G-PM-1007-04 09G PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9707542189896 40.77170329868851)   19 4 19 13
2123 2123 -73.959874668294 40.7907004233491 32E-AM-1007-09 32E AM 10072018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false true false false   POINT (-73.959874668294 40.7907004233491)   19 4 19 13
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2173 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
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9691692160865 40.7725330502929)   19 4 19 13
2346 2346 -73.9562177305881 40.7983413276331 41C-PM-1007-03 41C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9562177305881 40.7983413276331)   19 4 19 13
2518 2518 -73.9647219419257 40.7812084402932 20F-PM-1007-03 20F PM 10072018 3 Adult Gray White Gray+White gray on haunches white on tail Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9647219419257 40.7812084402932)   19 4 19 13
2529 2529 -73.9800271487863 40.7702554167042 4A-PM-1007-06 04A PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE A rock false false false false true   false false false false true false false false   POINT (-73.9800271487863 40.7702554167042)   19 4 19 13
2730 2730 -73.9653575758687 40.7805339953372 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree false false true true false   false false false false false false false false   POINT (-73.9653575758687 40.7805339953372)   19 4 19 13
2743 2743 -73.9587179613803 40.7992119571657 41A-PM-1007-01 41A PM 10072018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9587179613803 40.7992119571657)   19 4 19 13
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree false false true false false   false false false false false false false false   POINT (-73.9653873284496 40.7804699882574)   19 4 19 13
2944 2944 -73.9739403850622 40.7693162287509 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree true false false false true   false false false false false false false false   POINT (-73.9739403850622 40.7693162287509)   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 58.606ms