squirrels

24 rows where Approaches = "true" and Combination of Primary and Highlight Color = "Gray+" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Combination of Primary and Highlight Color ✖

  • Gray+ · 24 ✖

Approaches ✖

  • true · 24 ✖
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
176 176 -73.9618064639153 40.792158440043 32C-PM-1013-12 32C PM 10132018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false true true false false   POINT (-73.9618064639153 40.792158440043)   19 4 19 13
266 266 -73.9786481009499 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786481009499 40.7697372811949)   19 4 19 13
579 579 -73.9786714207307 40.7696870806229 4B-PM-1018-01 04B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786714207307 40.7696870806229)   19 4 19 13
806 806 -73.970475755546 40.7763348062134 13E-AM-1017-02 13E AM 10172018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true begging (came one yard away from me and stood there) false false false false false true false false   POINT (-73.970475755546 40.7763348062134)   19 4 19 13
866 866 -73.9792091200122 40.7685845475313 2B-PM-1013-06 02B PM 10132018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false true false false sat there! in front of us POINT (-73.9792091200122 40.7685845475313)   19 4 19 13
882 882 -73.9786805884996 40.7697559231927 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786805884996 40.7697559231927)   19 4 19 13
998 998 -73.9600546294497 40.7914969165757 33D-AM-1017-03 33D AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true true false   POINT (-73.9600546294497 40.7914969165757)   19 4 19 13
1137 1137 -73.9520280004414 40.7946345014466 39I-PM-1013-03 39I PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false false playing false false false false false true false false   POINT (-73.9520280004414 40.7946345014466)   19 4 19 13
1214 1214 -73.9699517492486 40.7753169595373 13F-PM-1008-01 13F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9699517492486 40.7753169595373)   19 4 19 13
1322 1322 -73.9701824376506 40.7763703306736 14E-AM-1008-21 14E AM 10082018 21 Adult Gray   Gray+   Ground Plane FALSE   false false false false true walking false false false false false true false false curious,but not expecting food POINT (-73.9701824376506 40.7763703306736)   19 4 19 13
1428 1428 -73.9666113598566 40.7752662550312 14H-PM-1012-05 14H PM 10122018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false approaches (someone was feeding it) POINT (-73.9666113598566 40.7752662550312)   19 4 19 13
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   true false true true false got fed twice by grandpa,grabbed from grass and ate in tree false false false false false true true true approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)   19 4 19 13
1944 1944 -73.9743292066413 40.7756090404121 11B-AM-1007-05 11B AM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false true false true false false   POINT (-73.9743292066413 40.7756090404121)   19 4 19 13
2131 2131 -73.9752225195115 40.7703747669865 6D-PM-1020-05 06D PM 10202018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9752225195115 40.7703747669865)   19 4 19 13
2149 2149 -73.9691845420174 40.7707749899254 9I-AM-1014-03 09I AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9691845420174 40.7707749899254)   19 4 19 13
2170 2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9678923667678 40.781967562623606)   19 4 19 13
2383 2383 -73.9686551213305 40.7728617837174 11H-PM-1013-04 11H PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true true false   POINT (-73.9686551213305 40.7728617837174)   19 4 19 13
2590 2590 -73.9568524771058 40.7974664985551 40C-PM-1006-06 40C PM 10062018 6 Juvenile Gray   Gray+   Ground Plane FALSE By The Road false false false false true   false false false false false true false false   POINT (-73.9568524771058 40.7974664985551)   19 4 19 13
2670 2670 -73.9531041906469 40.7919916819219 36I-PM-1007-02 36I PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false true true true false chased birds (blue jay) POINT (-73.9531041906469 40.7919916819219)   19 4 19 13
2750 2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.957775998085 40.7932880937406)   19 4 19 13
2762 2762 -73.9656324462902 40.7834034753081 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false false true false false   POINT (-73.9656324462902 40.7834034753081)   19 4 19 13
2772 2772 -73.9677368646039 40.7821550964837 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.96773686460392 40.782155096483706)   19 4 19 13
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false true false false   POINT (-73.9531953594918 40.7960413520131)   19 4 19 13
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   false false true false false   false false false false false true false false   POINT (-73.9672063784809 40.7826070395665)   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 139.721ms