squirrels

20 rows where Chasing = "true", Date = 10172018 and Foraging = "false"

✎ 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, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Other Activities, Quaas, Tail twitches, Approaches, Indifferent, Runs from, 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
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false true false true false   false false false false false false true false   POINT (-73.970252675331 40.77059995882221)   19 4 19 13
174 174 -73.9707274055755 40.7723889080377 10G-PM-1017-10 10G PM 10172018 10 Adult Gray   Gray+   Ground Plane FALSE   false true false false false playing (with #9) false false false false false false true false   POINT (-73.9707274055755 40.7723889080377)   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
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
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
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false false false true false   POINT (-73.9716271494641 40.7796462634184)   19 4 19 13
1182 1182 -73.9667206046912 40.7779993565098 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667206046912 40.7779993565098)   19 4 19 13
1323 1323 -73.9744387347626 40.7776953143835 13A-AM-1017-03 13A AM 10172018 3 Adult Cinnamon   Cinnamon+         false true false false false   false false false false false false true false   POINT (-73.9744387347626 40.7776953143835)   19 4 19 13
1390 1390 -73.9677146741772 40.7788231332337 17E-AM-1017-07 17E AM 10172018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9677146741772 40.7788231332337)   19 4 19 13
1479 1479 -73.9707498430394 40.7723724480959 10G-PM-1017-09 10G PM 10172018 9 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9707498430394 40.7723724480959)   19 4 19 13
1611 1611 -73.9655238539833 40.7815633947684 21E-AM-1017-03 21E AM 10172018 3 Adult Gray   Gray+   Above Ground 7   false true false false false   false false false false false false true false   POINT (-73.9655238539833 40.7815633947684)   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
1821 1821 -73.9676314068477 40.7788030406918 17E-AM-1017-08 17E AM 10172018 8 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9676314068477 40.7788030406918)   19 4 19 13
1832 1832 -73.9693159934697 40.7831212338295 21B-PM-1017-03 21B PM 10172018 3 Juvenile Cinnamon White Cinnamon+White   Above Ground 1   false true false false false   false false false false false false false false   POINT (-73.9693159934697 40.7831212338295)   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
1988 1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         true true true false false chasing (#4),digging false false false false true false true false   POINT (-73.957138794884 40.7985389822719)   19 4 19 13
2071 2071 -73.9667694439895 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667694439895 40.7779501809095)   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
2908 2908 -73.9654288151266 40.7815953970174 21E-AM-1017-02 21E AM 10172018 2 Adult Gray   Gray+   Above Ground 7   false true false false false   false false false false false false true false   POINT (-73.9654288151266 40.7815953970174)   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 57.154ms