squirrels

31 rows where Chasing = "true" and Date = 10132018

✎ 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, Specific Location, Running, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Climbing ✖

Date ✖

  • 10132018 · 31 ✖

Chasing ✖

  • true · 31 ✖
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
103 103 -73.9607701370443 40.7955418990855 36A-PM-1013-07 36A PM 10132018 7   Gray   Gray+   Ground Plane FALSE "FIELD" false true false false false chasing #8 false false false false false false false true   POINT (-73.9607701370443 40.7955418990855)   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
318 318 -73.9743990576746 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   false true false false false chasing #3 false false false false false false true false   POINT (-73.9743990576746 40.7768690723163)   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
474 474 -73.9540652304705 40.7955226178199 39G-PM-1013-05 39G PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9540652304705 40.7955226178199)   19 4 19 13
497 497 -73.9602166876979 40.7953811003986 36B-AM-1013-04 36B AM 10132018 4   Black   Black+   Above Ground 20 Moved 20+ feet high above top of tree limb false true false false false   false false false false false false false true   POINT (-73.9602166876979 40.7953811003986)   19 4 19 13
582 582 -73.9677779408464 40.7867482211349 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE false true false false false chasing #3 false false false true false false true false   POINT (-73.9677779408464 40.7867482211349)   19 4 19 13
596 596 -73.9769319450348 40.7743883576247 9A-AM-1013-11 09A AM 10132018 11 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE foot of tree true true false false false   false false false false false false true false   POINT (-73.9769319450348 40.7743883576247)   19 4 19 13
603 603 -73.9721592378418 40.776034583573 12C-AM-1013-02 12C AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   true false false false false false true false   POINT (-73.9721592378418 40.776034583573)   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
874 874 -73.9591957793992 40.7949568873453 36C-PM-1013-01 36C PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9591957793992 40.7949568873453)   19 4 19 13
1143 1143 -73.9628349778362 40.793887005206 34A-PM-1013-03 34A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9628349778362 40.793887005206)   19 4 19 13
1167 1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   false false false false true false true false   POINT (-73.9593244415072 40.794964729747)   19 4 19 13
1264 1264 -73.9785353775382 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9785353775382 40.7674923683184)   19 4 19 13
1267 1267 -73.9701010964667 40.7688919314508 6I-PM-1013-02 06I PM 10132018 2 Adult Black   Black+   Ground Plane FALSE Bushes false true false false false   false false false false false false false false   POINT (-73.9701010964667 40.76889193145081)   19 4 19 13
1601 1601 -73.9544278270221 40.7987827316512 42D-PM-1013-02 42D PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail, Cinnamon feet Ground Plane FALSE   false true false false true chasing (chased by #1),found a nut,buried it false false false false false false true false   POINT (-73.9544278270221 40.7987827316512)   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
1656 1656 -73.9557399927792 40.7971563708988 40D-PM-1013-07 40D PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false false false false true   POINT (-73.9557399927792 40.7971563708988)   19 4 19 13
1705 1705 -73.9765417282001 40.7740994735325 9A-AM-1013-05 09A AM 10132018 5 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765417282001 40.7740994735325)   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
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
1971 1971 -73.9591880400132 40.7950071252836 36C-PM-1013-02 36C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) false true false true true   true true false false true false true false   POINT (-73.95918804001322 40.7950071252836)   19 4 19 13
2085 2085 -73.9690551477139 40.7823685663196 20B-PM-1013-07 20B PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9690551477139 40.7823685663196)   19 4 19 13
2225 2225 -73.9562323455674 40.7946180656349 37E-AM-1013-02 37E AM 10132018 2   Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9562323455674 40.79461806563491)   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
2812 2812 -73.963209639301 40.7926138443715 32A-PM-1013-07 32A PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.963209639301 40.7926138443715)   19 4 19 13
2845 2845 -73.9765016413674 40.7740672862953 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765016413674 40.7740672862953)   19 4 19 13
2855 2855 -73.9690832219322 40.782343340986 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false true false true false   POINT (-73.96908322193221 40.782343340986)   19 4 19 13
2919 2919 -73.9768563402344 40.7744487310786 9A-AM-1013-12 09A AM 10132018 12 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE foot of tree true true false false false   false false false false false false true false   POINT (-73.9768563402344 40.7744487310786)   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

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