squirrels

42 rows where Chasing = "true" and Date = 10142018 sorted by City Council Districts

✎ 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, Color notes, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Other Activities, Quaas, Tail twitches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts

Climbing ✖

Date ✖

  • 10142018 · 42 ✖

Chasing ✖

  • true · 42 ✖
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
72 72 -73.9666007935638 40.7845098131567 23C-PM-1014-03 23C PM 10142018 3 Adult Gray   Gray+   Above Ground 8   false true false false false chasing (#4 across trees) false false false false false false false false   POINT (-73.9666007935638 40.7845098131567)   19 4 19 13
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false true chasing (a chipmunk) false false false false false false false true   POINT (-73.9574809028248 40.7950013620207)   19 4 19 13
167 167 -73.9597642778427 40.7976368003915 39A-PM-1014-02 39A PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9597642778427 40.7976368003915)   19 4 19 13
212 212 -73.9638837160341 40.7809747900833 21G-AM-1014-07 21G AM 10142018 7 Adult Gray White Gray+White   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638837160341 40.7809747900833)   19 4 19 13
576 576 -73.9622047677701 40.7945126358465 35A-AM-1014-06 35A AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9622047677701 40.7945126358465)   19 4 19 13
600 600 -73.9808202088503 40.7682921842325 1A-PM-1014-02 01A PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false false false false false   POINT (-73.9808202088503 40.7682921842325)   19 4 19 13
608 608 -73.9589675995517 40.7913119223584 33E-AM-1014-09 33E AM 10142018 9 Juvenile Black   Black+   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9589675995517 40.7913119223584)   19 4 19 13
633 633 -73.9673243699918 40.7875392957722 26A-AM-1014-01 26A AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false could not get close due to fences POINT (-73.9673243699918 40.7875392957722)   19 4 19 13
840 840 -73.9598084794625 40.7976165434502 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9598084794625 40.7976165434502)   19 4 19 13
958 958 -73.9613862251332 40.791282169715 32C-AM-1014-03 32C AM 10142018 3 Adult Gray   Gray+   Above Ground 3   false true true false false   false false false false false false false false   POINT (-73.9613862251332 40.791282169715)   19 4 19 13
1128 1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638599044346 40.7809288795308)   19 4 19 13
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   true true true false true   false true false false false false false false looked at us from tree POINT (-73.9677096985223 40.7825358361204)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1417 1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.974828939898 40.7668886121909)   19 4 19 13
1525 1525 -73.9727115915422 40.7782929320632 14B-PM-1014-02 14B PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9727115915422 40.7782929320632)   19 4 19 13
1527 1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#7),playing? false false false false false false true false   POINT (-73.970216605149 40.7702960667277)   19 4 19 13
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false false true   POINT (-73.9581310602492 40.7960214726964)   19 4 19 13
1639 1639 -73.9736800575584 40.7783069735758 14A-PM-1014-04 14A PM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#3) false false false false true false true false   POINT (-73.9736800575584 40.7783069735758)   19 4 19 13
1666 1666 -73.9649465476871 40.7822708362663 22F-PM-1014-07 22F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9649465476871 40.7822708362663)   19 4 19 13
1673 1673 -73.9746940851342 40.7760966488186 11B-PM-1014-02 11B PM 10142018 2 Juvenile Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746940851342 40.7760966488186)   19 4 19 13
1817 1817 -73.9703076450783 40.770158422629 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#8),playing? false false false false false false true false   POINT (-73.9703076450783 40.770158422629)   19 4 19 13
1831 1831 -73.9746877519291 40.7761402808083 11B-PM-1014-03 11B PM 10142018 3   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746877519291 40.7761402808083)   19 4 19 13
1876 1876 -73.973598991549 40.7783020016983 14A-PM-1014-03 14A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false true false   POINT (-73.973598991549 40.7783020016983)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
2029 2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9687213827744 40.7843586374648)   19 4 19 13
2059 2059 -73.9710026704697 40.7761052764621 13D-AM-1014-04 13D AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9710026704697 40.7761052764621)   19 4 19 13
2104 2104 -73.9622419917579 40.794579797904 35A-AM-1014-07 35A AM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9622419917579 40.794579797904)   19 4 19 13
2303 2303 -73.9589470461357 40.7912817646361 33E-AM-1014-10 33E AM 10142018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9589470461357 40.7912817646361)   19 4 19 13
2387 2387 -73.9808517324721 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false true false false false   POINT (-73.9808517324721 40.7683154647217)   19 4 19 13
2465 2465 -73.9686999860219 40.7844014735136 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true true false false false   false false false false false false false false   POINT (-73.9686999860219 40.7844014735136)   19 4 19 13
2498 2498 -73.9674556940019 40.7875399402461 26A-AM-1014-02 26A AM 10142018 2   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false could not get close due to fences POINT (-73.9674556940019 40.7875399402461)   19 4 19 13
2653 2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.958932543729 40.7913445531266)   19 4 19 13
2654 2654 -73.9549261242548 40.7944701994615 37G-AM-1014-04 37G AM 10142018 4 Adult Gray   Gray+   Above Ground 5   false true false false false playing false false false false false false true false   POINT (-73.9549261242548 40.7944701994615)   19 4 19 13
2663 2663 -73.9613429184974 40.7912158057267 32C-AM-1014-02 32C AM 10142018 2 Adult Gray   Gray+   Above Ground 3   false true true false false   false false false false false false false false   POINT (-73.9613429184974 40.7912158057267)   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
2809 2809 -73.9686756254868 40.7777459102651 16E-AM-1014-04 16E AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9686756254868 40.7777459102651)   19 4 19 13
2899 2899 -73.9686358129525 40.7778035516486 16E-AM-1014-05 16E AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9686358129525 40.7778035516486)   19 4 19 13
2933 2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false true true false false   false true false false false false false false looked at us from tree POINT (-73.9677903197449 40.7826561917755)   19 4 19 13
2940 2940 -73.963911430308 40.7809127228847 21G-AM-1014-05 21G AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false true true false false   false false false false false false false false   POINT (-73.963911430308 40.7809127228847)   19 4 19 13
2955 2955 -73.9711666523376 40.7761513057034 13D-AM-1014-02 13D AM 10142018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false true false false true   false false false false false false true false   POINT (-73.9711666523376 40.7761513057034)   19 4 19 13
1489 1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18

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