squirrels

30 rows where Chasing = "true" and Date = 10082018 sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Indifferent, Runs from, Other Interactions

Climbing ✖

Tail twitches ✖

Date ✖

  • 10082018 · 30 ✖

Chasing ✖

  • true · 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
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
1135 1135 -73.9667474482967 40.7760643720793 15H-PM-1008-01 15H PM 10082018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10 Oak tree false true false false false watching me false true false true false false false false observant POINT (-73.9667474482967 40.7760643720793)   19 4 19 13
1142 1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn true true false false false   false false false false false false true false   POINT (-73.9765805609072 40.7692807820935)   19 4 19 13
28 28 -73.958736593111 40.7908524370626 32F-PM-1008-07 32F PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false false false true false   POINT (-73.958736593111 40.7908524370626)   19 4 19 13
84 84 -73.9701824825872 40.7766530579293 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   true false false false false false false true   POINT (-73.9701824825872 40.7766530579293)   19 4 19 13
144 144 -73.9730750601212 40.7701304211944 6F-PM-1008-01 06F PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9730750601212 40.7701304211944)   19 4 19 13
336 336 -73.9757413215621 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   true true true false false   false false false false false false true false   POINT (-73.9757413215621 40.7692582758978)   19 4 19 13
645 645 -73.9758152322587 40.7692377401467 4E-PM-1008-03 04E PM 10082018 3 Adult Gray   Gray+         false true false false false chasing #4 false false false false false false false false   POINT (-73.9758152322587 40.7692377401467)   19 4 19 13
732 732 -73.9695041366722 40.7797878809482 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9695041366722 40.7797878809482)   19 4 19 13
747 747 -73.9771422625274 40.772361415776 7B-AM-1008-02 07B AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771422625274 40.772361415776)   19 4 19 13
811 811 -73.9771695272048 40.7724277276263 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false true false false false   false false false false false false true false   POINT (-73.9771695272048 40.7724277276263)   19 4 19 13
873 873 -73.9770948563006 40.7724063459185 7B-AM-1008-04 07B AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9770948563006 40.7724063459185)   19 4 19 13
879 879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9735120882106 40.7715915415169)   19 4 19 13
890 890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree false true true false false   false false false false false false false true   POINT (-73.9667755678511 40.7760256836088)   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
957 957 -73.9586527721822 40.7908831110561 32F-PM-1008-08 32F PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false true   false false false false false false true false   POINT (-73.9586527721822 40.7908831110561)   19 4 19 13
978 978 -73.9676692772518 40.7764726688908 15G-AM-1008-03 15G AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   true false false false false false false false   POINT (-73.9676692772518 40.7764726688908)   19 4 19 13
1040 1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   true true false false true   false false false false false false false true   POINT (-73.9702588981432 40.776610754288)   19 4 19 13
1288 1288 -73.9730454295997 40.7702909454392 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730454295997 40.7702909454392)   19 4 19 13
1319 1319 -73.9562105506291 40.7966991197909 39D-AM-1008-02 39D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9562105506291 40.7966991197909)   19 4 19 13
1563 1563 -73.9676270670996 40.776391443152 15G-AM-1008-04 15G AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   true false false false false false false false   POINT (-73.9676270670996 40.776391443152)   19 4 19 13
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9734654671008 40.7715988711659)   19 4 19 13
1790 1790 -73.9730592548116 40.7740879251541 10D-AM-1008-04 10D AM 10082018 4 Juvenile Gray   Gray+   Above Ground 25   false true true false false   false false false false false false false false   POINT (-73.9730592548116 40.7740879251541)   19 4 19 13
1835 1835 -73.9562068537632 40.7967332853238 39D-AM-1008-01 39D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9562068537632 40.7967332853238)   19 4 19 13
1955 1955 -73.9606559309874 40.7889527629826 30E-AM-1008-02 30E AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false true false false false   true false false false false false true false   POINT (-73.9606559309874 40.7889527629826)   19 4 19 13
1960 1960 -73.9730158913661 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true true false false false chasing #2 false false false false false false false false   POINT (-73.9730158913661 40.7701310707272)   19 4 19 13
2118 2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730284815849 40.7702462529502)   19 4 19 13
2485 2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     false true false false false   false false false false false false true false   POINT (-73.9770313887741 40.772486925209904)   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 69.909ms