squirrels

59 rows where Date = 10132018, Indifferent = "false" and Shift = "AM" sorted by Tail twitches

View and edit SQL

Suggested facets: Hectare, Hectare Squirrel Number, 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, Tail flags, Tail twitches, Approaches, Other Interactions

Age

Runs from

Shift

Indifferent

  • false · 59

Date

  • 10132018 · 59

Community Districts

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
29 -73.9671786715256 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9671786715256 40.7867352791232)   19 4 19 13
30 -73.9692943291611 40.7769536102488 15E-AM-1013-01 15E AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9692943291611 40.7769536102488)   19 4 19 13
88 -73.9683608295976 40.7842927405327 22B-AM-1013-04 22B AM 10132018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE Under bench false false false false true   false false false false false false false true ran from dog-walker POINT (-73.9683608295976 40.7842927405327)   19 4 19 13
145 -73.971970670614 40.7720868124544 9F-AM-1013-04 09F AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.971970670614 40.7720868124544)   19 4 19 13
204 -73.9679538163341 40.7837103696906 22C-AM-1013-03 22C AM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true eating (mushroom) false false false false false false false true   POINT (-73.9679538163341 40.7837103696906)   19 4 19 13
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
271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false true false false approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)   19 4 19 13
291 -73.9679661308374 40.7837388390673 22C-AM-1013-01 22C AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false sitting still,tail over back false false false false false false false false   POINT (-73.9679661308374 40.7837388390673)   19 4 19 13
374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false watching me from tree - curious POINT (-73.9556817958407 40.788852000621)   19 4 19 13
384 -73.968045072743 40.7836626717225 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   false false true false true   true false false true false false false true   POINT (-73.968045072743 40.7836626717225)   19 4 19 13
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
630 -73.9580109357087 40.7855654405447 28I-AM-1013-01 28I AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Jumped onto path & then back into brush false false false false false stood on fence false false false false false false false true   POINT (-73.9580109357087 40.7855654405447)   19 4 19 13
654 -73.976769659152 40.7741908010484 9A-AM-1013-04 09A AM 10132018 4 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.976769659152 40.7741908010484)   19 4 19 13
797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false   false false false false false true false false   POINT (-73.969345754447 40.7770429650288)   19 4 19 13
819 -73.9603620122205 40.7955965755851 36B-AM-1013-02 36B AM 10132018 2   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false didn't see me POINT (-73.9603620122205 40.7955965755851)   19 4 19 13
852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   true false true false false hopping false false false false false true false true   POINT (-73.9609704650925 40.7938786854735)   19 4 19 13
867 -73.9762257701293 40.7744032758323 9A-AM-1013-08 09A AM 10132018 8 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9762257701293 40.7744032758323)   19 4 19 13
943 -73.9773096718574 40.7738053862489 8A-AM-1013-06 08A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9773096718574 40.7738053862489)   19 4 19 13
993 -73.9772422664657 40.773436329163 8A-AM-1013-02 08A AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE playground true false false false false   false false false false false false false true   POINT (-73.9772422664657 40.773436329163)   19 4 19 13
1011 -73.9719111470164 40.7758789855474 12D-AM-1013-02 12D AM 10132018 2 Adult Gray   Gray+   Above Ground 7 Was on top of the edge of Bow Bridge false false false false false jumped off false false false true false false false true   POINT (-73.9719111470164 40.7758789855474)   19 4 19 13
1096 -73.9568300899773 40.7935855743354 36E-AM-1013-01 36E AM 10132018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran into treebrush) POINT (-73.9568300899773 40.7935855743354)   19 4 19 13
1261 -73.9719109949232 40.7723138521327 9F-AM-1013-01 09F AM 10132018 1 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9719109949232 40.7723138521327)   19 4 19 13
1354 -73.9765269282059 40.7746876635248 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9765269282059 40.7746876635248)   19 4 19 13
1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9594676326588 40.7984457363388)   19 4 19 13
1449 -73.9561124892063 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   false false true true false   true false false false false false false true   POINT (-73.9561124892063 40.7949440648632)   19 4 19 13
1459 -73.9563847867316 40.7906012261163 33G-AM-1013-03 33G AM 10132018 3 ?     + Only peeked head out Above Ground 13   false false false false false peeking out of tree,did *not* come out false false false false false false false false   POINT (-73.9563847867316 40.7906012261163)   19 4 19 13
1467 -73.9684657285532 40.7840113573723 22B-AM-1013-05 22B AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree false false true false false   false false false false false false false false looked down on me like her imperial subject POINT (-73.9684657285532 40.7840113573723)   19 4 19 13
1493 -73.9684790657851 40.7838818717863 22B-AM-1013-01 22B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false looked at me,standing on back feet POINT (-73.9684790657851 40.7838818717863)   19 4 19 13
1507 -73.9699799501516 40.7736576286234 11F-AM-1013-02 11F AM 10132018 2 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9699799501516 40.7736576286234)   19 4 19 13
1621 -73.9734969320943 40.7722754599865 8E-AM-1013-01 08E AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9734969320943 40.7722754599865)   19 4 19 13
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
1707 -73.9604524271167 40.7956624328733 36B-AM-1013-01 36B AM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9604524271167 40.7956624328733)   19 4 19 13
1809 -73.9690168673844 40.7777612043914 15E-AM-1013-04 15E AM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9690168673844 40.7777612043914)   19 4 19 13
1938 -73.9719879697272 40.7725625124591 9F-AM-1013-02 09F AM 10132018 2 Adult Black   Black+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9719879697272 40.7725625124591)   19 4 19 13
2161 -73.9715375915057 40.7751212088827 12D-AM-1013-01 12D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9715375915057 40.7751212088827)   19 4 19 13
2179 -73.9559663949511 40.7974497269789 40D-AM-1013-07 40D AM 10132018 7 Adult Gray   Gray+   Above Ground 6   false false true false true   false false false false false false false true curious POINT (-73.9559663949511 40.7974497269789)   19 4 19 13
2262 -73.9556177490335 40.7888569161537 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false false false watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)   19 4 19 13
2263 -73.9569375355884 40.7935398008612 36E-AM-1013-02 36E AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9569375355884 40.7935398008612)   19 4 19 13
2284 -73.9730181306326 40.7794601322427 16A-AM-1013-02 16A AM 10132018 2 Adult Black   Black+   Above Ground     false false false false true   false false false false false true false false   POINT (-73.9730181306326 40.7794601322427)   19 4 19 13
2338 -73.9716621112698 40.7742862219469 11E-AM-1013-01 11E AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9716621112698 40.7742862219469)   19 4 19 13
2371 -73.9769520212123 40.774006725863 9A-AM-1013-01 09A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9769520212123 40.774006725863)   19 4 19 13
2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9704328573603 40.7739347247552)   19 4 19 13
2446 -73.9522704511969 40.7965668878961 41G-AM-1013-01 41G AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9522704511969 40.7965668878961)   19 4 19 13
2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9657958433575 40.7763496875058)   19 4 19 13
2585 -73.9771726831497 40.7732320781799 8A-AM-1013-01 08A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE trail true false false false true   false false false false false false false true   POINT (-73.9771726831497 40.7732320781799)   19 4 19 13
2609 -73.9596865318094 40.7893787188526 31F-AM-1013-01 31F AM 10132018 1 Adult Gray Black Gray+Black   Above Ground 25   true false true false false   false false false false false false false false   POINT (-73.9596865318094 40.7893787188526)   19 4 19 13
2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2693 -73.9561498646036 40.7949288561893 37E-AM-1013-05 37E AM 10132018 5 ?     +   Above Ground 10 unsure, just heard kuks false false false false false   true false false false false false false false   POINT (-73.9561498646036 40.79492885618931)   19 4 19 13
2784 -73.9763722433833 40.7744121430891 9A-AM-1013-07 09A AM 10132018 7 Adult     +         false false false false false   false false false false false false false true   POINT (-73.9763722433833 40.7744121430891)   19 4 19 13
2926 -73.9714653576023 40.7717400139502 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714653576023 40.7717400139502)   19 4 19 13
27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   19 4 19 13
109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   true false false false false   false false false false true true false true   POINT (-73.9604089940153 40.7910028063138)   19 4 19 13
1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true false true false true   true false false false true false false true   POINT (-73.9565824187667 40.797312050952)   19 4 19 13
2275 -73.9614218413356 40.7938945058793 34B-AM-1013-01 34B AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true hopping false false false false true true false false   POINT (-73.9614218413356 40.7938945058793)   19 4 19 13
2969 -73.9654409838612 40.7901338748522 29A-AM-1013-01 29A AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true climbed tree (oak) false false false false true false false true   POINT (-73.9654409838612 40.7901338748522)   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 83.438ms