squirrels

30 rows where Date = 10102018, Foraging = "true", Police Precincts = 13 and Tail twitches = "true" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Climbing, Other Activities, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Running ✖

Tail twitches ✖

  • true · 30 ✖

Foraging ✖

  • true · 30 ✖

Date ✖

  • 10102018 · 30 ✖
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
12 12 -73.9683613516225 40.7725908847499 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false true false true false   POINT (-73.9683613516225 40.7725908847499)   19 4 19 13
157 157 -73.9637946878735 40.7915700446878 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9637946878735 40.7915700446878)   19 4 19 13
175 175 -73.9720065066618 40.7764043782924 13C-AM-1010-04 13C AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9720065066618 40.7764043782924)   19 4 19 13
203 203 -73.9638774579549 40.7913532129148 31A-AM-1010-05 31A AM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false true true jumping false false false true true false true false eventually ran from lawnmower (tail flag) POINT (-73.9638774579549 40.7913532129148)   19 4 19 13
253 253 -73.9589627056561 40.7847591558491 26I-PM-1010-02 26I PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true hiding food false false false false true false true false   POINT (-73.9589627056561 40.7847591558491)   19 4 19 13
278 278 -73.9787796921165 40.7707526535381 5A-PM-1010-01 05A PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9787796921165 40.7707526535381)   19 4 19 13
537 537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   19 4 19 13
607 607 -73.9547711796823 40.7908540751983 34I-PM-1010-06 34I PM 10102018 6 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9547711796823 40.7908540751983)   19 4 19 13
847 847 -73.9771335416403 40.7668431485224 2E-AM-1010-01 02E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9771335416403 40.7668431485224)   19 4 19 13
1000 1000 -73.9805137046778 40.769275143797 2A-AM-1010-08 02A AM 10102018 8 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false true   false false false false true false false false   POINT (-73.9805137046778 40.769275143797)   19 4 19 13
1256 1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9679457364586 40.7717350221981)   19 4 19 13
1492 1492 -73.9807078515193 40.7683335292642 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9807078515193 40.7683335292642)   19 4 19 13
1614 1614 -73.9806718258385 40.7692776896995 2A-AM-1010-07 02A AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false false false couldn't get near POINT (-73.9806718258385 40.76927768969951)   19 4 19 13
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree false false true true true   false false false false true false true false   POINT (-73.9594391759139 40.784115697669)   19 4 19 13
1714 1714 -73.9763542780331 40.7736531303622 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush false false true false true   false false false false true false false true froze POINT (-73.9763542780331 40.773653130362206)   19 4 19 13
1793 1793 -73.9771575249322 40.7673873716547 2E-AM-1010-07 02E AM 10102018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9771575249322 40.7673873716547)   19 4 19 13
1816 1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9710187505339 40.7797265666746)   19 4 19 13
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees false false true true true scratching self false false false false true false true false   POINT (-73.9639505810228 40.789573183584)   19 4 19 13
2330 2330 -73.9724618533895 40.7745021602455 11D-AM-1010-02 11D AM 10102018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true walking false false false false true false false true   POINT (-73.9724618533895 40.7745021602455)   19 4 19 13
2343 2343 -73.9719194877439 40.7748000962909 11D-AM-1010-04 11D AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9719194877439 40.7748000962909)   19 4 19 13
2553 2553 -73.9714744574918 40.7736266158925 10E-AM-1010-01 10E AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9714744574918 40.7736266158925)   19 4 19 13
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree true false true false true   false false false false true false false true   POINT (-73.978199543688 40.7695660563362)   19 4 19 13
2587 2587 -73.9789971286844 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9789971286844 40.7707024146365)   19 4 19 13
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree false false true false true   false false false false true false true false   POINT (-73.9588339897601 40.7848084865431)   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
2875 2875 -73.9546616782922 40.790974533739 34I-PM-1010-05 34I PM 10102018 5 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9546616782922 40.790974533739)   19 4 19 13
2963 2963 -73.9687020800791 40.7735903424522 11H-AM-1010-08 11H AM 10102018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9687020800791 40.7735903424522)   19 4 19 13
2999 2999 -73.972415182837 40.773080463452 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.972415182837 40.773080463452)   19 4 19 13
3015 3015 -73.9759163300535 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9759163300535 40.7736180793606)   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

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 6803.132ms