squirrels

70 rows where Foraging = "false", Running = "true" and Tail twitches = "true" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Above Ground Sighter Measurement ✖

Police Precincts ✖

Tail twitches ✖

  • true · 70 ✖

Foraging ✖

  • false · 70 ✖
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
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   true false false true false   false false false false true false false true ran up tree POINT (-73.959709414696 40.7919745085986)   19 4 19 13
746 746 -73.9591407691 40.7960846903122 37B-AM-1018-01 37B AM 10182018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9591407691 40.7960846903122)   19 4 19 13
837 837 -73.9557172336815 40.7921125657722 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9557172336815 40.7921125657722)   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
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
620 620 -73.9655905300923 40.7752614638023 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   true false true false false   false false false false true false true false   POINT (-73.9655905300923 40.7752614638023)   19 4 19 13
534 534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   true false true false false   false false false false true false false true   POINT (-73.9650499507011 40.7908191782173)   19 4 19 13
987 987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
2033 2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2454 2454 -73.9565151662506 40.7946647987447 37E-PM-1006-07 37E PM 10062018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true me POINT (-73.9565151662506 40.7946647987447)   19 4 19 13
2487 2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2788 2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9647845655965 40.7816573808695)   19 4 19 13
2878 2878 -73.969720780557 40.7741105688757 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true false   false false false false true false false false   POINT (-73.969720780557 40.7741105688757)   19 4 19 13
2998 2998 -73.9752079247419 40.7755376979002 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true true false false   POINT (-73.9752079247419 40.7755376979002)   19 4 19 13
47 47 -73.9640032826529 40.7820309825448 22F-PM-1014-06 22F PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9640032826529 40.7820309825448)   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
110 110 -73.9711318790279 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   true false false false false   false false false false true false false true   POINT (-73.9711318790279 40.7701941550273)   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
1188 1188 -73.9669529835992 40.7871864151365 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO true false true false false d.p.t. false false false true true false true false calm POINT (-73.96695298359921 40.7871864151365)   19 4 19 13
1255 1255 -73.9717469822209 40.7753731930704 12D-PM-1014-03 12D PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false true false true false   POINT (-73.9717469822209 40.7753731930704)   19 4 19 13
1524 1524 -73.9725961508316 40.7795720444974 16A-PM-1019-06 16A PM 10192018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9725961508316 40.7795720444974)   19 4 19 13
1867 1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree true false false false false   false false false false true false false false   POINT (-73.9745204169071 40.7736282868469)   19 4 19 13
2708 2708 -73.9528429238071 40.7922651848867 36I-PM-1007-09 36I PM 10072018 9 Juvenile Gray   Gray+   Above Ground 5   true true false false false burying nut false false false false true false false false   POINT (-73.9528429238071 40.7922651848867)   19 4 19 13
2803 2803 -73.9576652087316 40.7875457977801 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   true false true false false   false false false false true false false true   POINT (-73.9576652087316 40.7875457977801)   19 4 19 13
2904 2904 -73.9720389756717 40.7763524091989 13C-PM-1019-02 13C PM 10192018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9720389756717 40.7763524091989)   19 4 19 13
1894 1894 -73.9699780857298 40.7688706046944 6I-PM-1013-01 06I PM 10132018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9699780857298 40.7688706046944)   19 4 19 13
1297 1297 -73.9802831706033 40.7692763295564 3A-AM-1012-02 03A AM 10122018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. Above Ground 1   true false false false false   false false false false true false false true   POINT (-73.9802831706033 40.7692763295564)   19 4 19 13
1840 1840 -73.9733222531339 40.7649975371546 1I-PM-1012-01 01I PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733222531339 40.7649975371546)   19 4 19 13
2604 2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false true true false   false false false false true false false true   POINT (-73.9605163698302 40.7914179994956)   19 4 19 13
2935 2935 -73.9604599477345 40.7915035010169 32D-PM-1006-06 32D PM 10062018 6 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9604599477345 40.7915035010169)   19 4 19 13
2947 2947 -73.9601215198114 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false true false false true   POINT (-73.9601215198114 40.7909769801241)   19 4 19 13
43 43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true false true false false   false false false false true false true false   POINT (-73.9574648097543 40.78925084286221)   19 4 19 13
209 209 -73.9710760196868 40.7725506006789 10F-PM-1019-02 10F PM 10192018 2 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head & stripe Ground Plane FALSE Behind fence, grass true false false false false   false false false false true false false true   POINT (-73.9710760196868 40.7725506006789)   19 4 19 13
419 419 -73.9777328709928 40.7669087724668 1D-AM-1006-02 01D AM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9777328709928 40.7669087724668)   19 4 19 13
447 447 -73.9725906016474 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false false   POINT (-73.9725906016474 40.7713889729739)   19 4 19 13
547 547 -73.9559677963727 40.7951124076946 38E-AM-1010-07 38E AM 10102018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #6 false false false false true false false true   POINT (-73.9559677963727 40.7951124076946)   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
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
720 720 -73.9669814346326 40.780390919948 19E-PM-1018-01 19E PM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9669814346326 40.780390919948)   19 4 19 13
884 884 -73.9678937289837 40.7782808361645 16E-PM-1018-01 16E PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9678937289837 40.7782808361645)   19 4 19 13
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1090 1090 -73.967767372181 40.784702631615 23B-PM-1012-07 23B PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.967767372181 40.784702631615)   19 4 19 13
1235 1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false jumping back & forth on tree false false false true true false true false   POINT (-73.9679686793869 40.7825993867876)   19 4 19 13
1484 1484 -73.9716736557408 40.7749333494336 12E-AM-1017-07 12E AM 10172018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9716736557408 40.7749333494336)   19 4 19 13
1511 1511 -73.9721642509914 40.7701179390078 7G-AM-1010-01 07G AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9721642509914 40.7701179390078)   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
1884 1884 -73.9733898487296 40.7666975131518 3H-PM-1014-02 03H PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733898487296 40.7666975131518)   19 4 19 13
2247 2247 -73.9559520137172 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches true true false false false chasing and being chased by #7 false false false false true false true false   POINT (-73.95595201371721 40.7950536287174)   19 4 19 13
2271 2271 -73.9673949458096 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9673949458096 40.78262185394961)   19 4 19 13
2320 2320 -73.9576897478787 40.7964695328457 38C-AM-1019-02 38C AM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9576897478787 40.7964695328457)   19 4 19 13
2324 2324 -73.9737247632185 40.7759469280872 12C-PM-1017-01 12C PM 10172018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false digging/burying,drinking from lake false false false false true false true false   POINT (-73.9737247632185 40.7759469280872)   19 4 19 13
3008 3008 -73.9503533343658 40.7976543603953 42H-PM-1014-04 42H PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   true true false false false   false false false false true false false true   POINT (-73.9503533343658 40.7976543603953) 12423 18 4 36 18
1303 1303 -73.9603302382958 40.7910100435196 32D-PM-1006-01 32D PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false true false false true   POINT (-73.9603302382958 40.7910100435196)   19 4 19 13
1600 1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.97530937770001 40.7666673897583)   19 4 19 13
2091 2091 -73.9676112864286 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road true false false false false   false false false false true false true false   POINT (-73.9676112864286 40.7772792086081)   19 4 19 13
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   true false true true false   false false false false true false false true   POINT (-73.9621253644004 40.7912082086879)   19 4 19 13
2776 2776 -73.9789687905912 40.7692693139328 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence true false true true false   false false false false true false true true   POINT (-73.9789687905912 40.7692693139328)   19 4 19 13
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
82 82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   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
561 561 -73.9581982486469 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   true false true false false   false false false false true false false false   POINT (-73.95819824864691 40.7992194575293)   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
1202 1202 -73.9694979297007 40.7694667408721 7I-PM-1013-02 07I PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE Construction materials true false false false false   false false false false true false false false   POINT (-73.9694979297007 40.7694667408721)   19 4 19 13
1356 1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false true false false true was with a lot of robins POINT (-73.9534910562766 40.7935774443789)   19 4 19 13
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1410 1410 -73.9587913289229 40.7961707624534 38C-AM-1019-11 38C AM 10192018 11 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9587913289229 40.7961707624534)   19 4 19 13
1453 1453 -73.9555856074105 40.7969457685677 40E-AM-1014-04 40E AM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE on rocks/bushy rocks true false false false false hiding from bird false true false false true false true false   POINT (-73.9555856074105 40.79694576856771)   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
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   true true false false false 2/3 chasing each other false false false false true false true false   POINT (-73.9707487237344 40.7800822831001)   19 4 19 13
2490 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

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 116.155ms