squirrels

146 rows where Chasing = "true" and Indifferent = "false" sorted by Tail twitches

✎ View and edit SQL

This data as json, CSV (advanced)

Runs from ✖

Indifferent ✖

  • false · 46 ✖

Chasing ✖

  • true · 46 ✖
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
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
2509 2509 -73.9714295102249 40.776954371947 14D-PM-1019-02 14D PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714295102249 40.776954371947)   19 4 19 13
2512 2512 -73.974275954985 40.7754723879307 11B-AM-1007-02 11B AM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.974275954985 40.7754723879307)   19 4 19 13
2513 2513 -73.9767590273554 40.7717561807266 6B-PM-1017-07 06B PM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767590273554 40.7717561807266)   19 4 19 13
2524 2524 -73.9743877909071 40.7754706115974 11B-AM-1007-03 11B AM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9743877909071 40.7754706115974)   19 4 19 13
2633 2633 -73.9776151109912 40.7694681558386 4C-PM-1010-09 04C PM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9776151109912 40.7694681558386)   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
2676 2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692849074642 40.7708755098145)   19 4 19 13
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true true false false true   false false false false false false false false   POINT (-73.97435094238212 40.7690043677328)   19 4 19 13
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13
2796 2796 -73.9631089011412 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9631089011412 40.789191946875)   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
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.98028424040162 40.7678257384977)   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
2930 2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692563597762 40.770904999952)   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
2982 2982 -73.9513477815203 40.7945259614138 39I-PM-1013-02 39I PM 10132018 2 Juvenile Gray   Gray+   Ground Plane FALSE along the road false true true false false playing false false false false false false false false   POINT (-73.9513477815203 40.7945259614138)   19 4 19 13
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
172 172 -73.958535640774 40.7982737896998 40B-AM-1019-02 40B AM 10192018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false false false   POINT (-73.958535640774 40.7982737896998)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
356 356 -73.9761036400144 40.7705482684594 6D-PM-1020-03 06D PM 10202018 3 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9761036400144 40.7705482684594)   19 4 19 13
360 360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   false true false false false   false false false false true false false false   POINT (-73.9672054610151 40.7876519923501)   19 4 19 13
361 361 -73.9614824437251 40.7912929799884 32C-PM-1013-03 32C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9614824437251 40.7912929799884)   19 4 19 13
533 533 -73.9652584749758 40.7803011124382 19F-PM-1017-04 19F PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true true false false   false false false false true false false true   POINT (-73.9652584749758 40.7803011124382)   19 4 19 13
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   19 4 19 13
589 589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false true false false false curious POINT (-73.97826438139 40.7717086090782)   19 4 19 13
628 628 -73.9600165785486 40.7952466761832 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false true false false true   POINT (-73.9600165785486 40.7952466761832)   19 4 19 13
682 682 -73.9651828383592 40.7802820943863 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true true false false   POINT (-73.9651828383592 40.7802820943863)   19 4 19 13
724 724 -73.9532952763106 40.7920074462622 36I-AM-1017-08 36I AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#7) false false false false true false false true runs from (me) POINT (-73.95329527631061 40.7920074462622)   19 4 19 13
740 740 -73.9583477850634 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true true   true false false false true false false false   POINT (-73.9583477850634 40.7914073632782)   19 4 19 13
762 762 -73.9679291347956 40.7846973096665 23B-PM-1012-02 23B PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true 2/3 were chasing each other false false false false true false false true   POINT (-73.9679291347956 40.7846973096665)   19 4 19 13
1009 1009 -73.9636551433178 40.7901572818776 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false true false true true   false false false false true false false true   POINT (-73.9636551433178 40.7901572818776)   19 4 19 13
1688 1688 -73.9677593344667 40.7763054313195 15G-PM-1019-07 15G PM 10192018 7 Adult     +   Above Ground 5   false true false false false   false false false false true false false false   POINT (-73.9677593344667 40.7763054313195)   19 4 19 13
1754 1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true true false false   false false false false true false false true   POINT (-73.9652134469963 40.7803438278765)   19 4 19 13
1797 1797 -73.9697178096275 40.7697036696301 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree false true false false false playing,interacting with #6 false false false false true false false false   POINT (-73.9697178096275 40.769703669630104)   19 4 19 13
1799 1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   false true false false false chasing squirrel #6 true true false false true false false false   POINT (-73.978844141973 40.7696046074378)   19 4 19 13
1872 1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9613998967903 40.7912437235667)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true 2/3 were chasing each other false false false false true false false true   POINT (-73.96786208407411 40.784719027304)   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
2708 2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   true true false false false burying nut false false false false true false false false   POINT (-73.9528429238071 40.7922651848867)   19 4 19 13
2839 2839 -73.9672252136807 40.7876504743212 26A-PM-1006-04 26A PM 10062018 4 Adult Gray   Gray+   Above Ground 40   false true false false false   false false false false true false false false   POINT (-73.9672252136807 40.7876504743212)   19 4 19 13
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
3016 3016 -73.9756457597888 40.7703559775625 6D-PM-1020-02 06D PM 10202018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false true   POINT (-73.9756457597888 40.7703559775625)   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 8.171ms