squirrels

35 rows where Foraging = "true", Hectare Squirrel Number = 5 and Highlight Fur Color = "White"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, 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
17 17 -73.9695063535333 40.7823507678183 20B-PM-1013-05 20B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9695063535333 40.7823507678183)   19 4 19 13
128 128 -73.9746229094643 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false false false avoided people POINT (-73.9746229094643 40.7748467061969)   19 4 19 13
239 239 -73.9758464905133 40.7725957408841 8C-PM-1013-05 08C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9758464905133 40.7725957408841)   19 4 19 13
247 247 -73.9733117663541 40.7694584620114 6F-PM-1008-05 06F PM 10082018 5 Adult Cinnamon White Cinnamon+White white patch Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.97331176635412 40.7694584620114)   19 4 19 13
357 357 -73.9724801784201 40.7790131966689 15B-PM-1017-05 15B PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9724801784201 40.7790131966689)   19 4 19 13
436 436 -73.9734695768004 40.7716297491384 8E-PM-1008-05 08E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false false false true true   false false false false false false false false   POINT (-73.9734695768004 40.7716297491384)   19 4 19 13
439 439 -73.9589770206691 40.791240542172 33E-AM-1014-05 33E AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9589770206691 40.791240542172)   19 4 19 13
475 475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9697855573137 40.7742186391935)   19 4 19 13
590 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
689 689 -73.970595381455 40.7762912142457 13E-PM-1008-05 13E PM 10082018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.970595381455 40.7762912142457)   19 4 19 13
887 887 -73.9635028497015 40.7928207574906 32A-PM-1013-05 32A PM 10132018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false true false false false true   POINT (-73.9635028497015 40.7928207574906)   19 4 19 13
921 921 -73.9698959071826 40.7716763799299 9H-AM-1006-05 09H AM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9698959071826 40.7716763799299)   19 4 19 13
1347 1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616693665254 40.792971019627)   19 4 19 13
1456 1456 -73.9714242426496 40.7744535798123 11E-PM-1012-05 11E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true foraging (foraged,ran to tree root,munched) false false false false false false true false   POINT (-73.9714242426496 40.7744535798123)   19 4 19 13
1660 1660 -73.9800499498034 40.7702181099573 4A-PM-1007-05 04A PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE At rock false false false false true   false false false true true false true false   POINT (-73.9800499498034 40.770218109957305)   19 4 19 13
1728 1728 -73.9787846880249 40.7682545903488 2C-PM-1013-05 02C PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9787846880249 40.7682545903488)   19 4 19 13
1784 1784 -73.9748318777506 40.7771821378056 13A-AM-1017-05 13A AM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9748318777506 40.7771821378056)   19 4 19 13
1849 1849 -73.9788436368415 40.7691104998969 3B-AM-1010-05 03B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9788436368415 40.7691104998969)   19 4 19 13
2012 2012 -73.9587464852561 40.793496354083 35D-PM-1013-05 35D PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9587464852561 40.793496354083)   19 4 19 13
2061 2061 -73.9608834102446 40.790624710005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9608834102446 40.790624710005)   19 4 19 13
2078 2078 -73.9706041173545 40.7780152784804 15D-PM-1017-05 15D PM 10172018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9706041173545 40.7780152784804)   19 4 19 13
2155 2155 -73.9538938706987 40.7981150065974 42E-PM-1012-05 42E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9538938706987 40.7981150065974)   19 4 19 13
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree true false true false true   false false false false true false true false   POINT (-73.9657171357842 40.7773277532224)   19 4 19 13
2306 2306 -73.956453902485 40.7936584431012 36F-PM-1012-05 36F PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.956453902485 40.7936584431012)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2582 2582 -73.9665004148497 40.7805656411756 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9665004148497 40.7805656411756)   19 4 19 13
2645 2645 -73.9584967368893 40.7977320341094 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. false false false false false false true false   POINT (-73.9584967368893 40.7977320341094)   19 4 19 13
2701 2701 -73.9791217510656 40.7676583475394 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 false false false true true   false false false false false false false false   POINT (-73.9791217510656 40.7676583475394)   19 4 19 13
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   19 4 19 13
2816 2816 -73.9809342290598 40.7687265606227 2A-AM-1010-05 02A AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE base of tree with ~ 30 small birds all eating false false false true true   false false false false true true true false   POINT (-73.9809342290598 40.7687265606227)   19 4 19 13
2824 2824 -73.9750618008099 40.7737521167094 9B-AM-1010-05 09B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9750618008099 40.7737521167094)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   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
2953 2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true eating (in a tree cage thing) false false false false false false true false   POINT (-73.9585862117341 40.7986549251083)   19 4 19 13
3020 3020 -73.9704015859639 40.7825600069973 19A-PM-1013-05 19A PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9704015859639 40.7825600069973)   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 67.539ms