squirrels

20 rows where Above Ground Sighter Measurement = 3 and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Other Interactions

Runs from ✖

  • true · 20 ✖

Police Precincts ✖

Indifferent ✖

Above Ground Sighter Measurement ✖

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
4 4 -73.9757249834141 40.7697032606755 5D-PM-1018-05 05D PM 10182018 5 Juvenile Gray   Gray+   Above Ground 3   false false true false false   false false false false false false false true   POINT (-73.9757249834141 40.7697032606755)   19 4 19 13
80 80 -73.9688454483585 40.7845301288163 22A-AM-1008-05 22A AM 10082018 5 Adult Gray White Gray+White   Above Ground 3 trash can false false false true false   false false false true false false false true   POINT (-73.9688454483585 40.7845301288163)   19 4 19 13
110 110 -73.9711318790279 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   true false false false false   false false false false true false false true   POINT (-73.9711318790279 40.7701941550273)   19 4 19 13
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
237 237 -73.967895656898 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence true false false false false   false false false false false false false true   POINT (-73.967895656898 40.7767409597341)   19 4 19 13
641 641 -73.9719036217446 40.7803588122409 17A-AM-1017-01 17A AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3 ground & tree true false true false true   false false false false true false false true   POINT (-73.9719036217446 40.7803588122409)   19 4 19 13
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   false true false false false   false false false false false false false true   POINT (-73.96641208260151 40.7888022709721)   19 4 19 13
996 996 -73.9703149829421 40.7785583630323 16D-AM-1007-01 16D AM 10072018 1 Adult Gray White Gray+White   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9703149829421 40.7785583630323)   19 4 19 13
1053 1053 -73.9685859705486 40.7848805065322 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree false false true false false   false false false false false false false true   POINT (-73.9685859705486 40.7848805065322)   19 4 19 13
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree true false true false true   false false false false true false false true   POINT (-73.9719460335398 40.7810508156287)   19 4 19 13
1162 1162 -73.9568544270881 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock false false false false false   false false false false false false false true   POINT (-73.9568544270881 40.7972517274475)   19 4 19 13
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   true false false false false was chased by # 11 true false false false false false false true   POINT (-73.9763236949008 40.7686815615335)   19 4 19 13
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   true false true false false   false false false false false false false true   POINT (-73.9778730762957 40.770827251547)   19 4 19 13
1631 1631 -73.9527196716568 40.792363826828 36I-PM-1007-11 36I PM 10072018 11 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true false false   false false false false false false false true me! POINT (-73.9527196716568 40.792363826828)   19 4 19 13
1788 1788 -73.9685567075413 40.7703797723105 8I-AM-1006-10 08I AM 10062018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 bush false false true false false   false false false false false false false true   POINT (-73.96855670754131 40.7703797723105)   19 4 19 13
1825 1825 -73.9624209799704 40.7910200972752 31C-PM-1010-01 31C PM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9624209799704 40.7910200972752)   19 4 19 13
1891 1891 -73.9749641575871 40.7673305056277 3F-AM-1006-05 03F AM 10062018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3   false false true true false   false false false false false false false true   POINT (-73.9749641575871 40.7673305056277)   19 4 19 13
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   false false true true true   false false false false false false false true   POINT (-73.9657487923637 40.7786823090663)   19 4 19 13
2406 2406 -73.9668964315686 40.7777577990886 16G-AM-1010-01 16G AM 10102018 1 Adult Gray White Gray+White   Above Ground 3   false false true false false   false false false false true false false true   POINT (-73.9668964315686 40.7777577990886)   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 1576.01ms