squirrels

13 rows where Foraging = "true", Hectare Squirrel Number = 7 and Highlight Fur Color = "White"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, 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
238 238 -73.9760942252437 40.7742035674209 9B-PM-1013-07 09B PM 10132018 7 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97609422524371 40.7742035674209)   19 4 19 13
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   19 4 19 13
664 664 -73.9725174868556 40.7664248283566 3H-PM-1014-07 03H PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9725174868556 40.7664248283566)   19 4 19 13
750 750 -73.9699672074164 40.7774389345748 15D-AM-1007-07 15D AM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true chasing #8 false false false false false false true false   POINT (-73.9699672074164 40.7774389345748)   19 4 19 13
1127 1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   19 4 19 13
1132 1132 -73.9798390387307 40.7700761090896 3A-PM-1017-07 03A PM 10172018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9798390387307 40.7700761090896)   19 4 19 13
1580 1580 -73.9775079672882 40.7691500357424 4C-PM-1010-07 04C PM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9775079672882 40.7691500357424)   19 4 19 13
1648 1648 -73.9790263372004 40.7683513714892 2C-PM-1013-07 02C PM 10132018 7 Adult Gray White Gray+White         true false false false true   false false false false false false false false   POINT (-73.9790263372004 40.7683513714892)   19 4 19 13
1659 1659 -73.9690498876944 40.7700011818847 8I-AM-1006-07 08I AM 10062018 7 Adult Gray White Gray+White White ring on short tail Above Ground 20   false false true false true   false false false false false false true false   POINT (-73.9690498876944 40.7700011818847)   19 4 19 13
1986 1986 -73.958247706428 40.7989079136796 40B-AM-1019-07 40B AM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true true   POINT (-73.958247706428 40.7989079136796)   19 4 19 13
2057 2057 -73.9579659543224 40.7905646887034 32F-AM-1012-07 32F AM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9579659543224 40.7905646887034)   19 4 19 13
2669 2669 -73.9615900833886 40.7945431292846 35A-PM-1013-07 35A PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9615900833886 40.7945431292846)   19 4 19 13
2778 2778 -73.9761799699276 40.774213409933 9B-AM-1010-07 09B AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9761799699276 40.774213409933)   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 111.599ms