squirrels

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

✎ 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
1997 1997 -73.9714637683084 40.7768984561563 14D-PM-1019-01 14D PM 10192018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9714637683084 40.7768984561563)   19 4 19 13
2018 2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9697924026634 40.7803611152023)   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
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2148 2148 -73.9767317539505 40.7717600450632 6B-PM-1017-05 06B PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false true   false false false false false false false false   POINT (-73.9767317539505 40.7717600450632)   19 4 19 13
2182 2182 -73.9573656523498 40.7979754563974 40C-AM-1017-01 40C AM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#2) false false false false false false false true   POINT (-73.9573656523498 40.7979754563974)   19 4 19 13
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9583688637255 40.791388958496)   19 4 19 13
2236 2236 -73.9597845469964 40.7906179303448 32E-AM-1007-11 32E AM 10072018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9597845469964 40.7906179303448)   19 4 19 13
2249 2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9785709201168 40.7674391934208)   19 4 19 13
2313 2313 -73.9646174034945 40.7781287528262 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other true true false false false playing? false false false false false false false false   POINT (-73.9646174034945 40.7781287528262)   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
2365 2365 -73.9688773306324 40.7766669852358 15F-AM-1007-05 15F AM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false true   POINT (-73.9688773306324 40.7766669852358)   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
2394 2394 -73.9785829546046 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785829546046 40.7719652299132)   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
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
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
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
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
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
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
222 222 -73.9770273553525 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence true true true true false playing tag together false false false false false true false false   POINT (-73.9770273553525 40.7732399463626)   19 4 19 13
315 315 -73.9539734770934 40.7956055442 39G-PM-1013-04 39G PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false false false   POINT (-73.9539734770934 40.7956055442)   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
629 629 -73.9573724133264 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true false chasing (#1) false false false false false false false true   POINT (-73.9573724133264 40.7980080911115)   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
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
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
1623 1623 -73.9770119133023 40.7732949090005 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence true true false true true playing tag together false false false false false true false false   POINT (-73.9770119133023 40.7732949090005)   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

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