squirrels

61 rows where Date = 10132018, Foraging = "false" and Runs from = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, 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
27 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
83 83 -73.9617088749928 40.7944585082367 35A-PM-1013-06 35A PM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9617088749928 40.7944585082367)   19 4 19 13
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
109 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
147 147 -73.9564023626619 40.7905423546155 33G-AM-1013-02 33G AM 10132018 2 Adult Gray   Gray+   Above Ground 13 shelter in hole in tree false false true false false   false false false false false false true true   POINT (-73.9564023626619 40.7905423546155)   19 4 19 13
409 409 -73.9530809650496 40.7959176317705 40G-PM-1013-02 40G PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false hiding from dog false false false false false false false true runs from (dog) POINT (-73.9530809650496 40.79591763177051)   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
536 536 -73.9561141662309 40.7976258458604 40D-PM-1013-05 40D PM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9561141662309 40.7976258458604)   19 4 19 13
583 583 -73.9612398509782 40.7950033150385 35A-PM-1013-12 35A PM 10132018 12 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9612398509782 40.7950033150385)   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
630 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
824 824 -73.9606344681252 40.7958337780644 37B-PM-1013-04 37B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9606344681252 40.795833778064406)   19 4 19 13
852 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
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false true true false true   POINT (-73.9600964585868 40.7952339524416)   19 4 19 13
867 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
902 902 -73.969105907 40.7820474909192 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   true false false false false being chased by dog false false false false false false false true   POINT (-73.969105907 40.7820474909192)   19 4 19 13
943 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
955 955 -73.960657061561 40.7956150744102 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" true false false false false running from #7 false false false false false false false true   POINT (-73.960657061561 40.7956150744102)   19 4 19 13
979 979 -73.9612349421547 40.7959586475744 36A-PM-1013-09 36A PM 10132018 9   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH true false false false false   false false false false true false false true   POINT (-73.9612349421547 40.7959586475744)   19 4 19 13
993 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 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
1029 1029 -73.9601259189134 40.7955350609057 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9601259189134 40.7955350609057)   19 4 19 13
1059 1059 -73.9749457516921 40.7676712372245 3F-PM-1013-07 03F PM 10132018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9749457516921 40.7676712372245)   19 4 19 13
1096 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
1176 1176 -73.9553263156025 40.7975592060572 40D-PM-1013-04 40D PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9553263156025 40.7975592060572)   19 4 19 13
1180 1180 -73.9639726817977 40.7829083461049 23F-PM-1013-01 23F PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) POINT (-73.9639726817977 40.7829083461049)   19 4 19 13
1261 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
1273 1273 -73.9558943880051 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true false false   false false false false false false false true   POINT (-73.9558943880051 40.7971535141896)   19 4 19 13
1294 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
1348 1348 -73.9599197612389 40.7954836456006 36B-PM-1013-05 36B PM 10132018 5 Adult Gray   Gray+   Above Ground 4   true false false false false   false false false false false false false true   POINT (-73.9599197612389 40.7954836456006)   19 4 19 13
1354 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
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   true false true true false got fed twice by grandpa,grabbed from grass and ate in tree false false false false false true true true approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)   19 4 19 13
1449 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
1507 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
1553 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
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   true false true false false   false false false false false false false true   POINT (-73.9778730762957 40.770827251547)   19 4 19 13
1621 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
1640 1640 -73.9564632239432 40.7904807427954 33G-AM-1013-01 33G AM 10132018 1 Adult Cinnamon   Cinnamon+   Above Ground 13 shelter in hole in tree false false true false false   false false false false false false true true   POINT (-73.9564632239432 40.7904807427954)   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
1707 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
1900 1900 -73.9529224802393 40.7961895763649 40G-PM-1013-05 40G PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (to the tree) POINT (-73.9529224802393 40.7961895763649)   19 4 19 13
1932 1932 -73.9616972557304 40.7953872829374 36A-PM-1013-03 36A PM 10132018 3 Juvenile Cinnamon   Cinnamon+ COULD HAVE BEEN CHIPPY, DEEP BROWN Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9616972557304 40.7953872829374)   19 4 19 13
1939 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
1952 1952 -73.9681810466693 40.7720638449419 10I-PM-1013-01 10I PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9681810466693 40.7720638449419)   19 4 19 13
2143 2143 -73.9596232170232 40.7959550843229 37B-PM-1013-01 37B PM 10132018 1 Adult Gray   Gray+ Sighting was far away Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9596232170232 40.795955084322905)   19 4 19 13
2263 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
2274 2274 -73.9698044218476 40.7697007833531 7I-PM-1013-06 07I PM 10132018 6 Adult Cinnamon   Cinnamon+ "Brown" written in as Primary Ground Plane FALSE Under the tree false false false true false playing,interacting with #7 false false false false true false false true   POINT (-73.9698044218476 40.7697007833531)   19 4 19 13
2338 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
2357 2357 -73.9632301034883 40.7925707244111 32A-PM-1013-06 32A PM 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.9632301034883 40.7925707244111)   19 4 19 13
2371 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
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9589475065438 40.7934846881536)   19 4 19 13
2534 2534 -73.9744368038675 40.7674281958115 3G-PM-1013-03 03G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true runs from (climbed tree to run from) POINT (-73.97443680386752 40.7674281958115)   19 4 19 13
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.9615643742864 40.7944678447843)   19 4 19 13
2672 2672 -73.9614599022015 40.7945181285991 35A-PM-1013-11 35A PM 10132018 11 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9614599022015 40.7945181285991)   19 4 19 13
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag false false true true false   false false false false false false true true   POINT (-73.9566300789162 40.7993692120774)   19 4 19 13
2767 2767 -73.9751806727197 40.7671940332258 3F-PM-1013-05 03F PM 10132018 5 Adult Gray White Gray+White   Above Ground 13   true false false false false   false false false false false false false true   POINT (-73.97518067271972 40.7671940332258)   19 4 19 13
2784 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
2810 2810 -73.9614659899028 40.7945562907624 35A-PM-1013-10 35A PM 10132018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9614659899028 40.7945562907624)   19 4 19 13
2815 2815 -73.9747311312394 40.7677319725044 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   false false true false false   false true false false false false false true   POINT (-73.97473113123941 40.7677319725044)   19 4 19 13
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.96159260312531 40.7944223235385)   19 4 19 13
2985 2985 -73.9721159387757 40.7660503188637 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9721159387757 40.7660503188637)   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 60.963ms