squirrels

18 rows where Combination of Primary and Highlight Color = "Cinnamon+White", Foraging = "true", Indifferent = "false" and Runs from = "false"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Tail twitches, Approaches

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 -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 -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
490 -73.978426472499 40.771904101844 6A-PM-1012-04 06A PM 10122018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.978426472499 40.771904101844)   19 4 19 13
514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   19 4 19 13
590 -73.9785133301426 40.7718260288338 6A-PM-1012-05 06A PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9785133301426 40.7718260288338)   19 4 19 13
699 -73.9504693544225 40.797225436004 42H-AM-1019-01 42H AM 10192018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9504693544225 40.797225436004)   19 4 19 13
897 -73.9734687538064 40.7694308959222 6F-PM-1008-04 06F PM 10082018 4 Adult Cinnamon White Cinnamon+White patches of white on haunches Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9734687538064 40.7694308959222)   19 4 19 13
931 -73.9785948413883 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true false true   false false false false false false false false   POINT (-73.9785948413883 40.7718908026758)   19 4 19 13
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 -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
1146 -73.9794367096274 40.7672720598482 1C-PM-1013-04 01C PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9794367096274 40.7672720598482)   19 4 19 13
1158 -73.9763894759543 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9763894759543 40.7705523372364)   19 4 19 13
1187 -73.9793334416378 40.7674142089209 1C-PM-1013-02 01C PM 10132018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true digging false false false false false false false false   POINT (-73.9793334416378 40.7674142089209)   19 4 19 13
1712 -73.9801899519657 40.7695777009264 3A-PM-1017-02 03A PM 10172018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9801899519657 40.7695777009264)   19 4 19 13
2138 -73.9791536183194 40.7672705931866 1C-PM-1013-03 01C PM 10132018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9791536183194 40.7672705931866)   19 4 19 13
2587 -73.9789971286844 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9789971286844 40.7707024146365)   19 4 19 13
2674 -73.9771009024581 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9771009024581 40.7688793288864)   19 4 19 13
2900 -73.9631005470369 40.7885494057193 28D-AM-1012-01 28D AM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9631005470369 40.7885494057193)   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 66.362ms