squirrels

37 rows where Highlight Fur Color = "Gray, White", Running = "false" and Tail twitches = "false" sorted by Color notes

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Tail twitches ✖

  • false · 37 ✖

Running ✖

  • false · 37 ✖

Police Precincts ✖

Highlight Fur Color ✖

  • Gray, White · 37 ✖
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
150 150 -73.9763430829342 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward false true false false false chased #12 true false false true false false false true   POINT (-73.9763430829342 40.7686351097159)   19 4 19 13
151 151 -73.9714789136757 40.7694886645194 6H-AM-1008-01 06H AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714789136757 40.7694886645194)   19 4 19 13
188 188 -73.9570528770427 40.7990973804149 41B-AM-1010-07 41B AM 10102018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   false false false false false   true false false true false true false false mad! POINT (-73.9570528770427 40.7990973804149)   19 4 19 13
194 194 -73.9764839973068 40.7691725326976 4D-PM-1008-06 04D PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9764839973068 40.7691725326976)   19 4 19 13
233 233 -73.9568343093228 40.7949401350882 37E-PM-1006-04 37E PM 10062018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false false false doesn't see me POINT (-73.9568343093228 40.7949401350882)   19 4 19 13
249 249 -73.9786339295735 40.7684918638639 3C-PM-1008-02 03C PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9786339295735 40.7684918638639)   19 4 19 13
267 267 -73.9754742295091 40.7696998327247 5E-PM-1012-02 05E PM 10122018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9754742295091 40.7696998327247)   19 4 19 13
303 303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true true true climbed fence staring at me - went up tree false false false false false false false true   POINT (-73.97623482246482 40.7694522315322)   19 4 19 13
715 715 -73.9772026572674 40.7691598773017 4D-PM-1008-14 04D PM 10082018 14 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9772026572674 40.7691598773017)   19 4 19 13
799 799 -73.9529413156461 40.7920963446605 36I-PM-1007-06 36I PM 10072018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9529413156461 40.7920963446605)   19 4 19 13
813 813 -73.9758959798289 40.7694125671679 4D-PM-1008-01 04D PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9758959798289 40.7694125671679)   19 4 19 13
863 863 -73.9764016030666 40.7689894344251 4D-PM-1008-05 04D PM 10082018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764016030666 40.7689894344251)   19 4 19 13
925 925 -73.9763116425885 40.7688839576487 4D-PM-1008-03 04D PM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false false true ran two feet up tree trunk POINT (-73.9763116425885 40.7688839576487)   19 4 19 13
939 939 -73.9761447791484 40.7690147873986 4D-PM-1008-02 04D PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761447791484 40.7690147873986)   19 4 19 13
997 997 -73.9790896775237 40.7688048644871 3B-AM-1010-10 03B AM 10102018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9790896775237 40.7688048644871)   19 4 19 13
1384 1384 -73.9787608762005 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   false false false false false walked between trees false false false false false false true false   POINT (-73.9787608762005 40.7686062296462)   19 4 19 13
1605 1605 -73.9690362384597 40.7767162824413 14F-PM-1012-09 14F PM 10122018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9690362384597 40.7767162824413)   19 4 19 13
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true false true   false false false false false true false false   POINT (-73.9790889008147 40.7676402781925)   19 4 19 13
1775 1775 -73.951965247933 40.7938167628067 38I-PM-1014-03 38I PM 10142018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true true   POINT (-73.951965247933 40.7938167628067)   19 4 19 13
1855 1855 -73.9791826197108 40.768577844752 2B-AM-1010-08 02B AM 10102018 8 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9791826197108 40.768577844752)   19 4 19 13
2194 2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.960898739757 40.7961393097144)   19 4 19 13
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   false false true true true   true false false false false false true false   POINT (-73.9789251806378 40.7699558513225)   19 4 19 13
2451 2451 -73.9775865217038 40.7704928300008 5C-PM-1010-01 05C PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9775865217038 40.7704928300008)   19 4 19 13
2455 2455 -73.9577297187155 40.799225295679 41B-AM-1010-08 41B AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 20   false false true true false   false false false false false true false false   POINT (-73.9577297187155 40.799225295679)   19 4 19 13
2516 2516 -73.9649823687651 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9649823687651 40.7763395359636)   19 4 19 13
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   19 4 19 13
2787 2787 -73.9765306970303 40.7694956875859 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         false false false false true   false false false false false false true false   POINT (-73.9765306970303 40.7694956875859)   19 4 19 13
2837 2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9772691210241 40.7690960712994)   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
2952 2952 -73.9763719445827 40.7689551413337 4D-PM-1008-04 04D PM 10082018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9763719445827 40.7689551413337)   19 4 19 13
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture false false true false true   false false false false false true false false   POINT (-73.9767389132988 40.7689323691424)   19 4 19 13
2976 2976 -73.9724083320538 40.7744163768061 11D-AM-1010-08 11D AM 10102018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true drinking false false false false false true false false   POINT (-73.9724083320538 40.7744163768061)   19 4 19 13
2986 2986 -73.9756533763813 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9756533763813 40.7733537881363)   19 4 19 13
3023 3023 -73.9754794191553 40.7696404489025 5E-PM-1012-01 05E PM 10122018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9754794191553 40.7696404489025)   19 4 19 13
1572 1572 -73.9540197079615 40.798039260983 41E-PM-1013-03 41E PM 10132018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White Gray on legs Above Ground 20   false false false false true   false false false false false false false false   POINT (-73.9540197079615 40.798039260983)   19 4 19 13
458 458 -73.9735750352959 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       false false false false false   false false false false false false true false   POINT (-73.9735750352959 40.7694500333777)   19 4 19 13
660 660 -73.9638298997554 40.7825966332367 22F-AM-1007-03 22F AM 10072018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White large white highlight Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9638298997554 40.7825966332367)   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 81.55ms