squirrels

30 rows where Chasing = "true", Hectare Squirrel Number = 2, Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, Other Interactions

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
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
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
230 230 -73.9731498064872 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true true false false   false false false false false true false false   POINT (-73.9731498064872 40.7659963196581)   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
721 721 -73.9718262034469 40.7666771797442 4I-PM-1007-02 04I PM 10072018 2 Adult Black   Black+   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9718262034469 40.7666771797442)   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
1201 1201 -73.9782813538421 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true true false false   false false false true false false false false   POINT (-73.9782813538421 40.7715730368712)   19 4 19 13
1220 1220 -73.9779983794849 40.7675452099173 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree false true true false false   false false false false false false false false   POINT (-73.9779983794849 40.7675452099173)   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
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
1414 1414 -73.9580513096783 40.79909641532 41B-AM-1010-02 41B AM 10102018 2 Adult Gray White Gray+White   Above Ground 16   false true false false false   false false false false false false false false   POINT (-73.9580513096783 40.79909641532)   19 4 19 13
1415 1415 -73.9678561384348 40.7782877397822 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false true false false false   false false false true false false false false gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)   19 4 19 13
1451 1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   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
1539 1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9681874036914 40.7817948690964)   19 4 19 13
1649 1649 -73.969347812694 40.7744098063421 12G-PM-1007-02 12G PM 10072018 2   Gray   Gray+   Above Ground   in tree false true false false false   false false false false false false false false   POINT (-73.969347812694 40.7744098063421)   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
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
1916 1916 -73.9693504617353 40.7830678709405 21B-PM-1017-02 21B PM 10172018 2 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false true false false false false false false stood on hind legs with front legs on the chest POINT (-73.9693504617353 40.7830678709405)   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
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
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
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
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
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
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
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
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 59.25ms