squirrels

15 rows where Climbing = "true", Hectare Squirrel Number = 4 and Location = "Ground Plane"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, 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
511 511 -73.9653142636891 40.7760015129298 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9653142636891 40.7760015129298)   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
631 631 -73.9548877830136 40.7950157489103 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.95488778301362 40.7950157489103)   19 4 19 13
916 916 -73.9561887624471 40.7958187455815 38E-AM-1010-04 38E AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false true false false false true me POINT (-73.95618876244711 40.7958187455815)   19 4 19 13
964 964 -73.9631045499811 40.7906180969472 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false false false false true   POINT (-73.9631045499811 40.7906180969472)   19 4 19 13
1591 1591 -73.9576223390082 40.7979746639647 40B-AM-1019-04 40B AM 10192018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false true true false   POINT (-73.9576223390082 40.79797466396471)   19 4 19 13
1882 1882 -73.9541601469123 40.7907832744689 34I-PM-1010-04 34I PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE across the lawn and climb up a small tree true false true false false grooming false false false false false false false false   POINT (-73.9541601469123 40.79078327446891)   19 4 19 13
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false false   POINT (-73.9647318357023 40.7760936175332)   19 4 19 13
2404 2404 -73.9665309689616 40.7775271020244 16G-AM-1010-04 16G AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9665309689616 40.7775271020244)   19 4 19 13
2607 2607 -73.9642988690682 40.7795591281979 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true true runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)   19 4 19 13
2664 2664 -73.9598350385541 40.7973274000224 38A-PM-1013-04 38A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9598350385541 40.7973274000224)   19 4 19 13
2847 2847 -73.9568378330302 40.7880317802766 30I-PM-1006-04 30I PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9568378330302 40.7880317802766)   19 4 19 13
2895 2895 -73.9747873899653 40.7731945258327 9C-PM-1006-04 09C PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9747873899653 40.7731945258327)   19 4 19 13
2934 2934 -73.9561669236168 40.7994737431277 42C-PM-1013-04 42C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9561669236168 40.7994737431277)   19 4 19 13
3012 3012 -73.9613701960898 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true got threatened by dog (same dog,dog #1) false false false false false false false true runs from (dog) POINT (-73.9613701960898 40.7943363227822)   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 185.805ms