squirrels

21 rows where Combination of Primary and Highlight Color = "Gray+White", Foraging = "true" and Location = "Above Ground"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Other Activities, Kuks, Quaas, Moans, Tail flags, Tail twitches, 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
137 137 -73.9782417115139 40.7724665036447 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree false false false false true   false true false false true false false false looked at us POINT (-73.9782417115139 40.7724665036447)   19 4 19 13
248 248 -73.9751729403694 40.7743284123118 10B-PM-1014-02 10B PM 10142018 2 Adult Gray White Gray+White   Above Ground   gingko tree by traffic light in front of Strawberry Fields false false false false true   false false false false true false false false came over on tree to see me then disappeared POINT (-73.9751729403694 40.7743284123118)   19 4 19 13
508 508 -73.9746918762076 40.7655231883678 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   false false true false true   false false false false true false true false   POINT (-73.9746918762076 40.7655231883678)   19 4 19 13
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   false false true false true   false false true false false false false true   POINT (-73.9522291603405 40.7976985385835)   19 4 19 13
702 702 -73.963858549251 40.7808999610914 21G-AM-1014-03 21G AM 10142018 3 Adult Gray White Gray+White   Above Ground 7   false false false false true   false false false false true false true false   POINT (-73.963858549251 40.7808999610914)   19 4 19 13
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   true false true false true   true true false false false false true false   POINT (-73.9547959269955 40.7925162926273)   19 4 19 13
1028 1028 -73.9707012345661 40.7758938984066 13E-PM-1008-03 13E PM 10082018 3 Juvenile Gray White Gray+White   Above Ground 10 hanging upside down to get a nut false false false false true   false false false false false false true false   POINT (-73.9707012345661 40.7758938984066)   19 4 19 13
1126 1126 -73.9700186001049 40.7826052184658 20B-AM-1007-03 20B AM 10072018 3 Adult Gray White Gray+White   Above Ground     false false false false true   false false false true false false false true   POINT (-73.9700186001049 40.7826052184658)   19 4 19 13
1241 1241 -73.9651817987035 40.7819082838334 21E-AM-1017-01 21E AM 10172018 1 Adult Gray White Gray+White   Above Ground 3 Climbs small tree false false false true true   false false false false true false false false walks from POINT (-73.9651817987035 40.7819082838334)   19 4 19 13
1315 1315 -73.9595955824812 40.7933047943534 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   false false true false true   false false false false true false false true   POINT (-73.9595955824812 40.7933047943534)   19 4 19 13
1659 1659 -73.9690498876944 40.7700011818847 8I-AM-1006-07 08I AM 10062018 7 Adult Gray White Gray+White White ring on short tail Above Ground 20   false false true false true   false false false false false false true false   POINT (-73.9690498876944 40.7700011818847)   19 4 19 13
1851 1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away false false true false true   false false false false false false true false   POINT (-73.9623621412501 40.7814673556041)   19 4 19 13
1977 1977 -73.9586570546871 40.796349417475 38C-AM-1019-09 38C AM 10192018 9 Adult Gray White Gray+White Gray & White selected as Primary & Highlights. Made executive adjustments. Above Ground 3 Between ground & tree false false false true true   false false false false true false false true   POINT (-73.9586570546871 40.796349417475)   19 4 19 13
2069 2069 -73.9538377039825 40.7980605334961 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree false false true false true   true false false false false false true false   POINT (-73.9538377039825 40.7980605334961)   19 4 19 13
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree true false true false true   false false false false true false true false   POINT (-73.9657171357842 40.7773277532224)   19 4 19 13
2185 2185 -73.9707571364399 40.7758859812524 13E-PM-1008-02 13E PM 10082018 2 Adult Gray White Gray+White   Above Ground 10   false false false false true   false false false true false false true false   POINT (-73.9707571364399 40.7758859812524)   19 4 19 13
2288 2288 -73.9577009571427 40.796126044521 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   false false true true true climbing (down from ~10') false false false false false false false true   POINT (-73.9577009571427 40.796126044521)   19 4 19 13
2331 2331 -73.9694681803635 40.770585795359 8I-AM-1006-06 08I AM 10062018 6 Adult Gray White Gray+White   Above Ground     false false false false true   false false false false false false true false   POINT (-73.9694681803635 40.770585795359)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   19 4 19 13
2944 2944 -73.9739403850622 40.7693162287509 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree true false false false true   false false false false false false false false   POINT (-73.9739403850622 40.7693162287509)   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 61.469ms