squirrels

41 rows where Above Ground Sighter Measurement = "" and Foraging = "true" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Police Precincts ✖

Foraging ✖

  • true · 41 ✖

Above Ground Sighter Measurement ✖

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
10 10 -73.9596413903948 40.7903128889029 32E-PM-1017-14 32E PM 10172018 14 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       false false false true true   false false false false false false false true   POINT (-73.9596413903948 40.7903128889029)   19 4 19 13
11 11 -73.9702676472613 40.7762126854894 13E-AM-1017-05 13E AM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   on tree stump false false false false true   false false false false false false false false   POINT (-73.9702676472613 40.7762126854894)   19 4 19 13
12 12 -73.9683613516225 40.7725908847499 11H-AM-1010-03 11H AM 10102018 3 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false true false true false   POINT (-73.9683613516225 40.7725908847499)   19 4 19 13
64 64 -73.9595002339508 40.7903365788694 32E-PM-1017-13 32E PM 10172018 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       false false false true true   false false false false false false true false   POINT (-73.9595002339508 40.7903365788694)   19 4 19 13
68 68 -73.9694240327509 40.7755898126674 13F-AM-1007-02 13F AM 10072018 2 Adult Cinnamon White Cinnamon+White         false false false true true   false false false false false false true false   POINT (-73.96942403275091 40.7755898126674)   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
280 280 -73.9587401274261 40.7960322222949 37C-PM-1013-03 37C PM 10132018 3 Adult Gray White Gray+White         false false false false true   false false false false false false true false   POINT (-73.9587401274261 40.7960322222949)   19 4 19 13
311 311 -73.9578779556574 40.7934116539732 35E-PM-1006-06 35E PM 10062018 6 Adult Gray   Gray+   Above Ground     false false false false true   false false false false false false false false   POINT (-73.9578779556574 40.7934116539732)   19 4 19 13
333 333 -73.9667560049684 40.7882333830729 27A-PM-1006-01 27A PM 10062018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   on a tree false false false true true walking up & down branches false false false false false false true false   POINT (-73.9667560049684 40.7882333830729)   19 4 19 13
348 348 -73.9542990150586 40.7940915300678 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         false false false false true   false false false false false false false false   POINT (-73.9542990150586 40.7940915300678)   19 4 19 13
398 398 -73.9686737866872 40.7739714023732 12G-PM-1007-06 12G PM 10072018 6   Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false false true false   POINT (-73.9686737866872 40.7739714023732)   19 4 19 13
441 441 -73.9742973420446 40.7691801644292 5F-AM-1007-04 05F AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   rocks false false false true true   false false false false false false false false   POINT (-73.9742973420446 40.7691801644292)   19 4 19 13
537 537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   19 4 19 13
607 607 -73.9547711796823 40.7908540751983 34I-PM-1010-06 34I PM 10102018 6 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9547711796823 40.7908540751983)   19 4 19 13
687 687 -73.9636971843665 40.7825638537362 22F-AM-1007-04 22F AM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray         false false false false true   false false false false false false true false   POINT (-73.9636971843665 40.7825638537362)   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
1405 1405 -73.9589371550945 40.7959812504467 37C-PM-1013-04 37C PM 10132018 4 Adult Gray White Gray+White         false false false false true   false false false false false false true false   POINT (-73.9589371550945 40.7959812504467)   19 4 19 13
1429 1429 -73.9706533131129 40.768902033819 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     true false true true true   false false false false false false false true runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)   19 4 19 13
1619 1619 -73.9744555348544 40.7728498106357 8D-PM-1007-03 08D PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray         false false false false true   false false false false false false false true   POINT (-73.9744555348544 40.7728498106357)   19 4 19 13
1648 1648 -73.9790263372004 40.7683513714892 2C-PM-1013-07 02C PM 10132018 7 Adult Gray White Gray+White         true false false false true   false false false false false false false false   POINT (-73.9790263372004 40.7683513714892)   19 4 19 13
1786 1786 -73.9709407456459 40.776423522087 14D-AM-1014-13 14D AM 10142018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true false   POINT (-73.9709407456459 40.776423522087)   19 4 19 13
1878 1878 -73.9761223919286 40.7685998275864 4E-PM-1008-06 04E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon         false false false true true   false false false false false false true false   POINT (-73.9761223919286 40.7685998275864)   19 4 19 13
1928 1928 -73.9725669210177 40.7681496989029 5H-AM-1007-01 05H AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false false false false   POINT (-73.9725669210177 40.7681496989029)   19 4 19 13
1958 1958 -73.9693120090055 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.9693120090055 40.771096102012)   19 4 19 13
2014 2014 -73.9786474809514 40.7679715341109 2C-PM-1013-04 02C PM 10132018 4 Adult Gray White Gray+White         false false false false true   false false false false false false false false   POINT (-73.9786474809514 40.7679715341109)   19 4 19 13
2015 2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! false false true false true throwing down acorns false false false false false false false false   POINT (-73.9574365550758 40.7886924675052)   19 4 19 13
2039 2039 -73.9708371806429 40.7764813666684 14D-AM-1014-14 14D AM 10142018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true false   POINT (-73.9708371806429 40.7764813666684)   19 4 19 13
2080 2080 -73.954530253849 40.7910247489879 34I-PM-1010-07 34I PM 10102018 7 Adult Gray   Gray+         true false false false true   false false false false false false false false   POINT (-73.954530253849 40.7910247489879)   19 4 19 13
2102 2102 -73.9593909381748 40.7961036981921 37B-PM-1013-03 37B PM 10132018 3 Adult Cinnamon White Cinnamon+White White back left leg       false false false true true watching false false false false false false false true   POINT (-73.9593909381748 40.7961036981921)   19 4 19 13
2257 2257 -73.95431338448 40.7940537582585 37G-PM-1007-08 37G PM 10072018 8 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.95431338448 40.7940537582585)   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
2522 2522 -73.9658747245917 40.7754033737532 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch true false false false true   false false false false true false false true   POINT (-73.9658747245917 40.7754033737532)   19 4 19 13
2631 2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         false false false false true   false false false false false false true true   POINT (-73.9690080105286 40.7710230515054)   19 4 19 13
2690 2690 -73.9572840457971 40.7886933371744 31H-PM-1008-04 31H PM 10082018 4 Adult Gray   Gray+   Above Ground   Also way up false false true false true   false false false false false false false false   POINT (-73.95728404579711 40.7886933371744)   19 4 19 13
2699 2699 -73.9743509423821 40.7690043677328 5F-AM-1007-02 05F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree true true false false true   false false false false false false false false   POINT (-73.97435094238212 40.7690043677328)   19 4 19 13
2737 2737 -73.9703683510176 40.7743975363958 12F-PM-1007-10 12F PM 10072018 10 Adult Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false false true false   POINT (-73.9703683510176 40.7743975363958)   19 4 19 13
2787 2787 -73.9765306970303 40.7694956875859 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         false false false false true   false false false false false false true false   POINT (-73.9765306970303 40.7694956875859)   19 4 19 13
2875 2875 -73.9546616782922 40.790974533739 34I-PM-1010-05 34I PM 10102018 5 Adult Gray   Gray+         false false false false true   false false false false true false false false   POINT (-73.9546616782922 40.790974533739)   19 4 19 13
2918 2918 -73.9745152462626 40.7655415515908 1G-AM-1006-04 01G AM 10062018 4 Adult Gray White Gray+White         false true false false true collecting nest material false false false false true false true false   POINT (-73.9745152462626 40.76554155159081)   19 4 19 13
1557 1557 -73.9705331808443 40.7699943571296 7H-AM-1006-09 07H AM 10062018 9 Adult Gray Cinnamon Gray+Cinnamon         false false false false true   false false false false false true false false   POINT (-73.9705331808443 40.7699943571296)   19 4 19 13
2284 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

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