squirrels

13 rows where Climbing = "true", Date = 10172018 and Highlight Fur Color = "Cinnamon" sorted by Kuks

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Foraging, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from

Tail flags ✖

Highlight Fur Color ✖

  • Cinnamon · 13 ✖

Eating ✖

Date ✖

  • 10172018 · 13 ✖

Climbing ✖

  • true · 13 ✖
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
364 364 -73.9623696148045 40.792184861375 32B-AM-1017-04 32B AM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false false false false true   POINT (-73.9623696148045 40.792184861375)   19 4 19 13
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
457 457 -73.965848283831 40.7797243033057 19F-PM-1017-01 19F PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.965848283831 40.7797243033057)   19 4 19 13
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false true false false true   POINT (-73.9652584749758 40.7803011124382)   19 4 19 13
641 641 -73.9719036217446 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree true false true false true   false false false false true false false true   POINT (-73.9719036217446 40.7803588122409)   19 4 19 13
682 682 -73.9651828383592 40.7802820943863 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true true false false   POINT (-73.9651828383592 40.7802820943863)   19 4 19 13
808 808 -73.9716881838671 40.778553537087 15C-PM-1017-02 15C PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 0   false false true false false   false false false false false false false true   POINT (-73.9716881838671 40.778553537087)   19 4 19 13
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9716736557408 40.7749333494336)   19 4 19 13
1564 1564 -73.9703816112358 40.7773846065919 15D-PM-1017-02 15D PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   false false true false true   false false false false false false true false   POINT (-73.9703816112358 40.7773846065919)   19 4 19 13
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true false false true   POINT (-73.9652134469963 40.7803438278765)   19 4 19 13
2747 2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   false false true false true   false false false false false false true false   POINT (-73.971314838366 40.774951285041)   19 4 19 13
2748 2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.960094705031 40.7916066137699)   19 4 19 13
2731 2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   false false true false false   true true false false false false true true   POINT (-73.9595886063173 40.7918405182594)   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 64.198ms