squirrels

120 rows where Combination of Primary and Highlight Color = "Gray+White" and Eating = "true" sorted by Above Ground Sighter Measurement

✎ View and edit SQL

This data as json, CSV (advanced)

Climbing ✖

Eating ✖

  • true · 20 ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 20 ✖
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
2482 2482 -73.9805927710872 40.7679989116642 1B-PM-1019-07 01B PM 10192018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9805927710872 40.7679989116642)   19 4 19 13
2526 2526 -73.9646495450499 40.7791203699027 19H-PM-1008-01 19H PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9646495450499 40.7791203699027)   19 4 19 13
2545 2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9617594316752 40.7946803725236)   19 4 19 13
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)   19 4 19 13
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false true false false false true   POINT (-73.95795157569 40.7961254697958)   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
2665 2665 -73.969784066769 40.7766940405403 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true burying false false false false false false true false curious POINT (-73.969784066769 40.7766940405403)   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
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9618094076328 40.7944097368153)   19 4 19 13
2766 2766 -73.9551639847466 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree false false false true false   false false false false true false false false   POINT (-73.9551639847466 40.790858199891)   19 4 19 13
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9705409446299 40.7764608087703)   19 4 19 13
2800 2800 -73.9802983138318 40.7676540772339 1B-PM-1019-05 01B PM 10192018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9802983138318 40.7676540772339)   19 4 19 13
2804 2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9576094432477 40.7965342664074)   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
2843 2843 -73.9714787178201 40.7798049470745 16B-PM-1017-01 16B PM 10172018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9714787178201 40.7798049470745)   19 4 19 13
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9530811255728 40.79830691185791)   19 4 19 13
2926 2926 -73.9714653576023 40.7717400139502 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714653576023 40.7717400139502)   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
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9747963162162 40.7745023355775)   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 7.492ms