squirrels

29 rows where Chasing = "true" and Date = 10062018

View and edit SQL

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, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Date

  • 10062018 · 29

Chasing

  • true · 29
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
20 -73.9706105896967 40.7698124821507 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false true false   POINT (-73.9706105896967 40.7698124821507)   19 4 19 13
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
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
352 -73.970540988328 40.7698103067062 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false true false false false   false false false false false false true false   POINT (-73.970540988328 40.7698103067062)   19 4 19 13
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
449 -73.9701335162984 40.7722051011357 10G-AM-1006-10 10G AM 10062018 10 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false true false false false false false false   POINT (-73.9701335162984 40.7722051011357)   19 4 19 13
471 -73.9707215394887 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#6) true false false false false false false false   POINT (-73.9707215394887 40.7727508149058)   19 4 19 13
503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false   false false false false false false false true   POINT (-73.95983407835722 40.7915857030295)   19 4 19 13
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
1004 -73.9670850805619 40.7833747810387 22C-PM-1006-01 22C PM 10062018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false for food false true false false false false false false   POINT (-73.9670850805619 40.7833747810387)   19 4 19 13
1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree false true false false false   false false false false false false true false   POINT (-73.9691293546408 40.77032190765491)   19 4 19 13
1172 -73.9706929270645 40.7727841119424 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   false true false false false chasing (#5) true false false false false false false false   POINT (-73.9706929270645 40.7727841119424)   19 4 19 13
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
1302 -73.9704024529864 40.7729256063889 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false chasing (#3) true false false false false false false false   POINT (-73.9704024529864 40.7729256063889)   19 4 19 13
1535 -73.9703921271418 40.7700276115314 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #7 false false false false false false true false   POINT (-73.9703921271418 40.770027611531404)   19 4 19 13
1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   true false false false false false true false   POINT (-73.9693209851947 40.7707450042769)   19 4 19 13
1700 -73.965675791028 40.7887310058451 27B-PM-1006-02 27B PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE By large tree chasing #1 false true false false true   false false false false false false false true   POINT (-73.965675791028 40.7887310058451)   19 4 19 13
1815 -73.9603268255317 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603268255317 40.7900154505092)   19 4 19 13
1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false true false false   POINT (-73.9745908987975 40.7655191512308)   19 4 19 13
1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9603366992925 40.789961288953904)   19 4 19 13
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
2298 -73.9755371849972 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9755371849972 40.7733561233828)   19 4 19 13
2351 -73.9745818450109 40.7654498873627 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   false true false false true   false false false false true false true false   POINT (-73.9745818450109 40.7654498873627)   19 4 19 13
2362 -73.9700263936574 40.7699335098581 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #6 false false false false false false true false   POINT (-73.9700263936574 40.7699335098581)   19 4 19 13
2490 -73.9693876553956 40.7707232748402 8I-AM-1006-02 08I AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true false true false   POINT (-73.9693876553956 40.7707232748402)   19 4 19 13
2542 -73.9754802138871 40.773300804412 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9754802138871 40.773300804412)   19 4 19 13
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
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
2918 -73.9745152462626 40.7655415515908 1G-AM-1006-04 01G AM 10062018 4 Adult Gray White Gray+White         false true false false true collecting nest material false false false false true false true false   POINT (-73.9745152462626 40.76554155159081)   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.944ms