squirrels

55 rows where Combination of Primary and Highlight Color = "Gray+", Date = 10142018 and Shift = "PM" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Other Activities, Kuks, Quaas, Approaches, Indifferent, Runs from, Other Interactions

Tail twitches ✖

Foraging ✖

Eating ✖

Shift ✖

Combination of Primary and Highlight Color ✖

  • Gray+ · 55 ✖
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
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
66 66 -73.9749243901189 40.7761393551781 11B-PM-1014-05 11B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9749243901189 40.7761393551781)   19 4 19 13
72 72 -73.9666007935638 40.7845098131567 23C-PM-1014-03 23C PM 10142018 3 Adult Gray   Gray+   Above Ground 8   false true false false false chasing (#4 across trees) false false false false false false false false   POINT (-73.9666007935638 40.7845098131567)   19 4 19 13
108 108 -73.9574809028248 40.7950013620207 37D-PM-1014-04 37D PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false true chasing (a chipmunk) false false false false false false false true   POINT (-73.9574809028248 40.7950013620207)   19 4 19 13
177 177 -73.9554432393295 40.7945669054449 37F-PM-1014-01 37F PM 10142018 1   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9554432393295 40.7945669054449)   19 4 19 13
341 341 -73.9703161745884 40.7702610461336 8H-PM-1014-05 08H PM 10142018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false false true   POINT (-73.9703161745884 40.7702610461336)   19 4 19 13
415 415 -73.9570131890379 40.7991786736124 41B-PM-1014-05 41B PM 10142018 5 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true true   POINT (-73.9570131890379 40.7991786736124)   19 4 19 13
487 487 -73.9666521094255 40.7842753517648 23C-PM-1014-02 23C PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE in bushes, then ran across path true false false false true   false false false false false false false false   POINT (-73.9666521094255 40.7842753517648)   19 4 19 13
492 492 -73.9703010856224 40.7701983575511 8H-PM-1014-06 08H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9703010856224 40.7701983575511)   19 4 19 13
548 548 -73.9584696083284 40.7980121226635 39B-PM-1014-03 39B PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9584696083284 40.7980121226635)   19 4 19 13
558 558 -73.9579335275486 40.7953080673706 37D-PM-1014-05 37D PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9579335275486 40.7953080673706)   19 4 19 13
617 617 -73.9558809064648 40.7952765022241 38E-PM-1014-03 38E PM 10142018 3   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH false false false false true   false false false false false false true false   POINT (-73.9558809064648 40.7952765022241)   19 4 19 13
709 709 -73.9519387881692 40.7936273636929 38I-PM-1014-04 38I PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9519387881692 40.7936273636929)   19 4 19 13
744 744 -73.9745687653791 40.7776396926997 13A-PM-1014-02 13A PM 10142018 2 Adult Gray   Gray+   Above Ground 45   false false false false false   false false false false false false false false   POINT (-73.9745687653791 40.7776396926997)   19 4 19 13
793 793 -73.9730111650468 40.7782157736204 14B-PM-1014-05 14B PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9730111650468 40.7782157736204)   19 4 19 13
959 959 -73.9746133058077 40.7760646554109 11B-PM-1014-04 11B PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false false true jumping false false false false false false false false   POINT (-73.9746133058077 40.776064655410906)   19 4 19 13
974 974 -73.9753744539307 40.7671162211032 2F-PM-1014-12 02F PM 10142018 12 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.97537445393071 40.7671162211032)   19 4 19 13
1005 1005 -73.9558268731771 40.7952074193788 38E-PM-1014-04 38E PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH false false false false true   false false false false false false false true   POINT (-73.9558268731771 40.7952074193788)   19 4 19 13
1206 1206 -73.9748709206354 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   false false true false false   true false false false false false false true   POINT (-73.9748709206354 40.77608025411)   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
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false false true   POINT (-73.980919134781 40.7683772453336)   19 4 19 13
1360 1360 -73.9674930668431 40.781351011968 20D-PM-1014-01 20D PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.96749306684312 40.781351011968)   19 4 19 13
1389 1389 -73.9580021017892 40.7955140102242 37D-PM-1014-07 37D PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9580021017892 40.7955140102242)   19 4 19 13
1417 1417 -73.974828939898 40.7668886121909 2F-PM-1014-11 02F PM 10142018 11 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.974828939898 40.7668886121909)   19 4 19 13
1427 1427 -73.9755321998542 40.7668311576007 2F-PM-1014-01 02F PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.97553219985421 40.7668311576007)   19 4 19 13
1527 1527 -73.970216605149 40.7702960667277 8H-PM-1014-08 08H PM 10142018 8 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#7),playing? false false false false false false true false   POINT (-73.970216605149 40.7702960667277)   19 4 19 13
1618 1618 -73.9755836827968 40.7670239327996 2F-PM-1014-02 02F PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9755836827968 40.7670239327996)   19 4 19 13
1665 1665 -73.9583944353352 40.7979689846815 39B-PM-1014-04 39B PM 10142018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true true runs from (me—when i approached) POINT (-73.9583944353352 40.7979689846815)   19 4 19 13
1666 1666 -73.9649465476871 40.7822708362663 22F-PM-1014-07 22F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9649465476871 40.7822708362663)   19 4 19 13
1673 1673 -73.9746940851342 40.7760966488186 11B-PM-1014-02 11B PM 10142018 2 Juvenile Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746940851342 40.7760966488186)   19 4 19 13
1682 1682 -73.9759258407288 40.7667622711142 2F-PM-1014-05 02F PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9759258407288 40.7667622711142)   19 4 19 13
1694 1694 -73.9730196342874 40.766022437401 3H-PM-1014-06 03H PM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9730196342874 40.766022437401)   19 4 19 13
1732 1732 -73.9767141407274 40.7737313251559 8A-PM-1014-02 08A PM 10142018 2 Juvenile Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true runs from (goes up a tree) POINT (-73.9767141407274 40.7737313251559)   19 4 19 13
1771 1771 -73.9750688083336 40.7665584681025 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750688083336 40.7665584681025)   19 4 19 13
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   false false true false false   true true false false false false false true   POINT (-73.9581366214863 40.7988964092722)   19 4 19 13
1817 1817 -73.9703076450783 40.770158422629 8H-PM-1014-07 08H PM 10142018 7 Adult Gray   Gray+   Above Ground 5   false true false false false chasing (#8),playing? false false false false false false true false   POINT (-73.9703076450783 40.770158422629)   19 4 19 13
1831 1831 -73.9746877519291 40.7761402808083 11B-PM-1014-03 11B PM 10142018 3   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746877519291 40.7761402808083)   19 4 19 13
1908 1908 -73.9588345546879 40.7991830272008 40A-PM-1014-02 40A PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from base of tree into bushes) POINT (-73.9588345546879 40.7991830272008)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
1930 1930 -73.9744279648953 40.7777760612191 13A-PM-1014-01 13A PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9744279648953 40.7777760612191)   19 4 19 13
2027 2027 -73.964449990389 40.7830023160643 22F-PM-1014-04 22F PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.964449990389 40.7830023160643)   19 4 19 13
2070 2070 -73.9725700261894 40.7668793330427 3H-PM-1014-01 03H PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE under a parked car true false false false false   false false false false false false false true   POINT (-73.9725700261894 40.7668793330427)   19 4 19 13
2128 2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false true false   POINT (-73.9757673193743 40.766961432261304)   19 4 19 13
2154 2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   false false true true false   false false false false false false false false   POINT (-73.976716425804 40.7736889979965)   19 4 19 13
2243 2243 -73.9579967047318 40.7948682042252 37D-PM-1014-02 37D PM 10142018 2 Adult Gray   Gray+   Above Ground 40   false false true false false   false false false false false false false false   POINT (-73.95799670473181 40.7948682042252)   19 4 19 13
2279 2279 -73.9586085858962 40.7990326758282 40A-PM-1014-04 40A PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from path to bushes) POINT (-73.9586085858962 40.7990326758282)   19 4 19 13
2341 2341 -73.9665363265054 40.7844967881001 23C-PM-1014-04 23C PM 10142018 4 Adult Gray   Gray+   Above Ground 8   false false false false false being chased by #3 across trees false false false false false false false false   POINT (-73.9665363265054 40.7844967881001)   19 4 19 13
2416 2416 -73.9588689820908 40.7992384137972 40A-PM-1014-03 40A PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (ran from base of tree into bushes) POINT (-73.9588689820908 40.799238413797205)   19 4 19 13
2441 2441 -73.9579865329778 40.794906535675 37D-PM-1014-03 37D PM 10142018 3 Adult Gray   Gray+   Above Ground 40   false false true false false   false false false false false false false false   POINT (-73.9579865329778 40.794906535675)   19 4 19 13
2443 2443 -73.9667073186959 40.7840581361598 23C-PM-1014-01 23C PM 10142018 1 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false false false   POINT (-73.96670731869591 40.7840581361598)   19 4 19 13
2707 2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   false false true false true   false false false false false false false false   POINT (-73.9578840941242 40.7955586232429)   19 4 19 13
2945 2945 -73.9649103330443 40.7823913860445 22F-PM-1014-08 22F PM 10142018 8 Adult Gray   Gray+   Above Ground 10 CLIMBED THE TREE false false true false false   false false false false false false true false   POINT (-73.9649103330443 40.7823913860445)   19 4 19 13
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9742986032935 40.7770454318226)   19 4 19 13
2762 2762 -73.9656324462902 40.7834034753081 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false false true false false   POINT (-73.9656324462902 40.7834034753081)   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 15202.123ms