squirrels

52 rows where Combination of Primary and Highlight Color = "Gray+White" and Hectare Squirrel Number = 4 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Police Precincts ✖

Hectare Squirrel Number ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 52 ✖
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
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
2103 2103 -73.9782983634755 40.7668314364263 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9782983634755 40.7668314364263)   19 4 19 13
1411 1411 -73.9802840031759 40.7678599069819 1B-PM-1019-04 01B PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 25 in tree false true false false false   false false false false false false false false   POINT (-73.9802840031759 40.7678599069819)   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
2349 2349 -73.980033740004 40.7683608292333 2B-PM-1013-04 02B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.980033740004 40.7683608292333)   19 4 19 13
999 999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   19 4 19 13
1709 1709 -73.9771696835698 40.7697011100487 4C-AM-1006-04 04C AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9771696835698 40.7697011100487)   19 4 19 13
1730 1730 -73.9796142848349 40.7702117898305 4A-PM-1007-04 04A PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9796142848349 40.7702117898305)   19 4 19 13
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush false true false false false   false false false false false false true false   POINT (-73.9730284815849 40.7702462529502)   19 4 19 13
627 627 -73.9763791121438 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   false true false false false chasing (dog chasing) false false false false false false false true   POINT (-73.9763791121438 40.770281512254)   19 4 19 13
1529 1529 -73.9692401421068 40.7707128895661 8I-AM-1006-04 08I AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false true false false true false   POINT (-73.9692401421068 40.7707128895661)   19 4 19 13
1083 1083 -73.9788117755401 40.7707347137469 5B-PM-1013-04 05B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.97881177554011 40.7707347137469)   19 4 19 13
163 163 -73.9712308864394 40.7714534847379 9G-AM-1007-04 09G AM 10072018 4 Adult Gray White Gray+White   Above Ground 15   false false false false false grooming false false false false false false true false   POINT (-73.9712308864394 40.7714534847379)   19 4 19 13
1802 1802 -73.9736418085696 40.7716931127716 8E-PM-1008-04 08E PM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE in grass by a grove of tall maples false false false true true   false false false false false false true false there's a family playing soccer POINT (-73.9736418085696 40.7716931127716)   19 4 19 13
1901 1901 -73.9680237209555 40.7717022208225 10I-AM-1010-04 10I AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9680237209555 40.7717022208225)   19 4 19 13
1826 1826 -73.9707542189896 40.7717032986885 9G-PM-1007-04 09G PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9707542189896 40.77170329868851)   19 4 19 13
589 589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false true false false false curious POINT (-73.97826438139 40.7717086090782)   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
2355 2355 -73.9728654439465 40.7724853142211 9E-AM-1008-04 09E AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728654439465 40.7724853142211)   19 4 19 13
1302 1302 -73.9704024529864 40.7729256063889 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false chasing (#3) true false false false false false false false   POINT (-73.9704024529864 40.7729256063889)   19 4 19 13
1460 1460 -73.9714329979305 40.7741873388945 11E-PM-1012-04 11E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9714329979305 40.7741873388945)   19 4 19 13
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9747963162162 40.7745023355775)   19 4 19 13
421 421 -73.9664630067791 40.7756361515825 14H-AM-1007-04 14H AM 10072018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9664630067791 40.7756361515825)   19 4 19 13
1541 1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9711617997772 40.7761212878075)   19 4 19 13
2094 2094 -73.9701630539326 40.7779553961101 15D-AM-1007-04 15D AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.97016305393261 40.7779553961101)   19 4 19 13
1182 1182 -73.9667206046912 40.7779993565098 17G-PM-1017-04 17G PM 10172018 4 Adult Gray White Gray+White   Above Ground 10 tree & ground true true true false false   false false false false false false true false   POINT (-73.9667206046912 40.7779993565098)   19 4 19 13
1663 1663 -73.9696720362627 40.7791851598197 17D-AM-1008-04 17D AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false true false true false   POINT (-73.9696720362627 40.7791851598197)   19 4 19 13
2613 2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   false false false true false   false false false false false false true false   POINT (-73.96393252683 40.7808289765857)   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
2532 2532 -73.9695150319891 40.782613519363 20B-PM-1013-04 20B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true chased a bird carrying massive wad of grass false false false false true false false false   POINT (-73.9695150319891 40.782613519363)   19 4 19 13
2390 2390 -73.9680741975294 40.7847036778165 23B-PM-1012-04 23B PM 10122018 4 Adult Gray White Gray+White   Above Ground 20   false false false false false watching me - didn't move false false false false true false false true   POINT (-73.9680741975294 40.7847036778165)   19 4 19 13
29 29 -73.9671786715256 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9671786715256 40.7867352791232)   19 4 19 13
1342 1342 -73.9662063642345 40.7890778665307 28A-PM-1007-04 28A PM 10072018 4 Adult Gray White Gray+White         false false false false false looking at me & #5 true false false false true false false false freezes POINT (-73.9662063642345 40.7890778665307)   19 4 19 13
2906 2906 -73.9597260014375 40.790707423031 32E-AM-1007-04 32E AM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9597260014375 40.790707423031)   19 4 19 13
1547 1547 -73.958939037549 40.7913193931203 33E-PM-1012-04 33E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true playing false false false false false false false false   POINT (-73.958939037549 40.7913193931203)   19 4 19 13
157 157 -73.9637946878735 40.7915700446878 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9637946878735 40.7915700446878)   19 4 19 13
106 106 -73.9634623418761 40.7917685404482 31A-PM-1017-04 31A PM 10172018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9634623418761 40.7917685404482)   19 4 19 13
3005 3005 -73.9616141152539 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616141152539 40.7921803313341)   19 4 19 13
2353 2353 -73.963623175585 40.7927451068919 32A-PM-1013-04 32A PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.963623175585 40.7927451068919)   19 4 19 13
173 173 -73.958770180151 40.7934123941528 35D-PM-1013-04 35D PM 10132018 4 Juvenile Gray White Gray+White         false false false false false   false false false false false false false false   POINT (-73.958770180151 40.7934123941528)   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
205 205 -73.9564724104048 40.7936055508162 36F-PM-1012-04 36F PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9564724104048 40.7936055508162)   19 4 19 13
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   true false false true true   true false false false false true false true approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
1585 1585 -73.9611312355348 40.7950130863913 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND false false false false false sitting false false false false true false true false   POINT (-73.9611312355348 40.7950130863913)   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
2618 2618 -73.95795157569 40.7961254697958 38C-PM-1014-04 38C PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false true false false false true   POINT (-73.95795157569 40.7961254697958)   19 4 19 13
2232 2232 -73.9566277721581 40.7966674587803 39D-PM-1012-04 39D PM 10122018 4 Juvenile Gray White Gray+White   Above Ground 10 on tree trunk (descending from height of ~10 ft) false false true false false   false false false false false false true false   POINT (-73.95662777215811 40.7966674587803)   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
2842 2842 -73.9579292340076 40.7976287835027 39C-PM-1006-04 39C PM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579292340076 40.7976287835027)   19 4 19 13
2277 2277 -73.95385121459 40.7981257651433 42E-PM-1012-04 42E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.95385121459 40.7981257651433)   19 4 19 13
354 354 -73.9566751022336 40.799035789744 41C-PM-1007-04 41C PM 10072018 4 Adult Gray White Gray+White   Above Ground 65   false false true false false   false false false false false false false false   POINT (-73.9566751022336 40.799035789744)   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 78.966ms