squirrels

75 rows where Combination of Primary and Highlight Color = "Gray+White" and Hectare Squirrel Number = 2 sorted by Primary Fur Color

✎ 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, Foraging, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, City Council Districts

Police Precincts ✖

Community Districts ✖

Hectare Squirrel Number ✖

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
167 167 -73.9597642778427 40.7976368003915 39A-PM-1014-02 39A PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9597642778427 40.7976368003915)   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
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.9553811810434 40.7970895007931)   19 4 19 13
189 189 -73.9735489537928 40.7681257911523 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree false false false false false sitting in tree false false false false false false true false   POINT (-73.9735489537928 40.7681257911523)   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
359 359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   false false true false false seems to be grinding teeth on a piece of material (sounds from grinding) false false false false false false true false   POINT (-73.9716404781264 40.7753181851766)   19 4 19 13
428 428 -73.96362827608 40.7807994595242 21G-AM-1014-02 21G AM 10142018 2 Adult Gray White Gray+White   Above Ground 3 fence false false true false false   false false false false false false true false   POINT (-73.96362827608 40.7807994595242)   19 4 19 13
469 469 -73.9717201378775 40.776120280884 13D-PM-1018-02 13D PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9717201378775 40.776120280884)   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
624 624 -73.9613051957306 40.7909351393505 31D-AM-1014-02 31D AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613051957306 40.7909351393505)   19 4 19 13
694 694 -73.9698032734704 40.7782343912417 16D-AM-1007-02 16D AM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9698032734704 40.7782343912417)   19 4 19 13
732 732 -73.9695041366722 40.7797878809482 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false true   POINT (-73.9695041366722 40.7797878809482)   19 4 19 13
742 742 -73.9767016963397 40.7674012784541 2E-PM-1014-02 02E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9767016963397 40.7674012784541)   19 4 19 13
756 756 -73.9773079154219 40.7696506688861 4C-AM-1006-02 04C AM 10062018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false true false true false   POINT (-73.9773079154219 40.7696506688861)   19 4 19 13
762 762 -73.9679291347956 40.7846973096665 23B-PM-1012-02 23B PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true 2/3 were chasing each other false false false false true false false true   POINT (-73.9679291347956 40.7846973096665)   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
1047 1047 -73.9580111056675 40.7854339401483 27I-PM-1020-02 27I PM 10202018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9580111056675 40.7854339401483)   19 4 19 13
1085 1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9722265046794 40.7700916895929)   19 4 19 13
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9584106786233 40.7902777556926)   19 4 19 13
1139 1139 -73.9716271494641 40.7796462634184 16B-PM-1017-02 16B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false false false true false   POINT (-73.9716271494641 40.7796462634184)   19 4 19 13
1154 1154 -73.9786936992465 40.7713943674666 5A-PM-1010-02 05A PM 10102018 2 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9786936992465 40.7713943674666)   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
1203 1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9616999731028 40.7954126939561)   19 4 19 13
1204 1204 -73.9762965341309 40.775112516678 10A-AM-1006-02 10A AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE Bridle Path lawn true false false false false   false false false false false false false false   POINT (-73.9762965341309 40.775112516678)   19 4 19 13
1252 1252 -73.9777998932399 40.7709815865334 5B-PM-1013-02 05B PM 10132018 2 Adult Gray White Gray+White   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9777998932399 40.7709815865334)   19 4 19 13
1256 1256 -73.9679457364586 40.7717350221981 10I-AM-1010-02 10I AM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9679457364586 40.7717350221981)   19 4 19 13
1283 1283 -73.9566785136491 40.7963368332834 39D-PM-1012-02 39D PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9566785136491 40.7963368332834)   19 4 19 13
1374 1374 -73.9653739273979 40.7889762096967 28B-PM-1010-02 28B PM 10102018 2 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9653739273979 40.7889762096967)   19 4 19 13
1387 1387 -73.9697160572446 40.7711445570446 9H-AM-1006-02 09H AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.96971605724461 40.7711445570446)   19 4 19 13
1414 1414 -73.9580513096783 40.79909641532 41B-AM-1010-02 41B AM 10102018 2 Adult Gray White Gray+White   Above Ground 16   false true false false false   false false false false false false false false   POINT (-73.9580513096783 40.79909641532)   19 4 19 13
1421 1421 -73.9595022290348 40.7831151330074 25I-PM-1007-02 25I PM 10072018 2 Adult Gray White Gray+White white belly Ground Plane FALSE   false false false false true   false false false true true false false true   POINT (-73.9595022290348 40.783115133007406)   19 4 19 13
1439 1439 -73.9729645190377 40.7723310150843 9E-AM-1008-02 09E AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9729645190377 40.7723310150843)   19 4 19 13
1482 1482 -73.9588610195699 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path false false false true true   false false false false false false true false   POINT (-73.9588610195699 40.7945269936639)   19 4 19 13
1717 1717 -73.9714952092767 40.7748063281815 12E-AM-1017-02 12E AM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9714952092767 40.7748063281815)   19 4 19 13
1804 1804 -73.980777106431 40.7681635726316 1A-AM-1007-02 01A AM 10072018 2 Adult Gray White Gray+White   Above Ground 11   false false true false false   false false false false true false true false   POINT (-73.980777106431 40.7681635726316)   19 4 19 13
1873 1873 -73.955754300682 40.79568139974 38E-PM-1014-02 38E PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.955754300682 40.79568139974)   19 4 19 13
1933 1933 -73.9584824361655 40.7934247634031 35D-PM-1013-02 35D PM 10132018 2 Adult Gray White Gray+White   Above Ground 24   false false true false false   false false false false false false true false   POINT (-73.9584824361655 40.7934247634031)   19 4 19 13
1956 1956 -73.980897497712 40.7690578709841 2A-PM-1019-02 02A PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false true false false false false   POINT (-73.980897497712 40.7690578709841)   19 4 19 13
1972 1972 -73.9558370309765 40.7921977208472 35G-AM-1007-02 35G AM 10072018 2 Adult Gray White Gray+White   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.9558370309765 40.7921977208472)   19 4 19 13
1978 1978 -73.9579689996645 40.7949338489917 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579689996645 40.7949338489917)   19 4 19 13
1984 1984 -73.9739249209875 40.7768528386853 13B-PM-1008-02 13B PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false false false true false   POINT (-73.9739249209875 40.7768528386853)   19 4 19 13
2040 2040 -73.9648167334089 40.7811164976329 20F-PM-1007-02 20F PM 10072018 2 Adult Gray White Gray+White white on tail Ground Plane FALSE   false false false true true digging one hole w/ determination false false false false true false false true   POINT (-73.96481673340891 40.7811164976329)   19 4 19 13
2051 2051 -73.9544808708211 40.7906575852286 34I-AM-1012-02 34I AM 10122018 2 Adult Gray White Gray+White Short tail Ground Plane FALSE   false false false false false hiding false false false false false false false true   POINT (-73.9544808708211 40.7906575852286)   19 4 19 13
2072 2072 -73.9618709589382 40.7944969066792 35A-PM-1013-02 35A PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9618709589382 40.7944969066792)   19 4 19 13
2097 2097 -73.9773486521595 40.7708454902113 5C-PM-1010-02 05C PM 10102018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9773486521595 40.7708454902113)   19 4 19 13
2112 2112 -73.9655206571055 40.7764851568746 16H-PM-1014-02 16H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9655206571055 40.7764851568746)   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
2212 2212 -73.9801138983722 40.7685721515635 2B-PM-1013-02 02B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9801138983722 40.7685721515635)   19 4 19 13
2216 2216 -73.9735195018446 40.7787147279715 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false true false false false   POINT (-73.9735195018446 40.7787147279715)   19 4 19 13
2225 2225 -73.9562323455674 40.7946180656349 37E-AM-1013-02 37E AM 10132018 2   Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false true false   POINT (-73.9562323455674 40.79461806563491)   19 4 19 13
2226 2226 -73.9624296435843 40.791320813687 31C-PM-1010-02 31C PM 10102018 2 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9624296435843 40.791320813687)   19 4 19 13
2231 2231 -73.9545427611477 40.7930353817441 36G-PM-1012-02 36G PM 10122018 2 Adult Gray White Gray+White   Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.9545427611477 40.7930353817441)   19 4 19 13
2249 2249 -73.9785709201168 40.7674391934208 2C-PM-1013-02 02C PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9785709201168 40.7674391934208)   19 4 19 13
2298 2298 -73.9755371849972 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9755371849972 40.7733561233828)   19 4 19 13
2326 2326 -73.9691692160865 40.7725330502929 10H-PM-1007-02 10H PM 10072018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9691692160865 40.7725330502929)   19 4 19 13
2352 2352 -73.9727310397798 40.7787016773517 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree false false true true true digging,chewing on tree—has nut in mouth! false false false false false false false true   POINT (-73.97273103977982 40.7787016773517)   19 4 19 13
2394 2394 -73.9785829546046 40.7719652299132 6A-PM-1012-02 06A PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785829546046 40.7719652299132)   19 4 19 13
2398 2398 -73.958713848373 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.958713848373 40.7963918051751)   19 4 19 13
2405 2405 -73.9588361742943 40.791115225155 33E-PM-1012-02 33E PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9588361742943 40.791115225155)   19 4 19 13
2430 2430 -73.9569811285656 40.793091234605 35F-PM-1012-02 35F PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9569811285656 40.793091234605)   19 4 19 13
2444 2444 -73.966590487009 40.7802469052891 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false true false false false false   POINT (-73.96659048700901 40.7802469052891)   19 4 19 13
2458 2458 -73.969517504176 40.7820741344297 20B-PM-1013-02 20B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969517504176 40.7820741344297)   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
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)   19 4 19 13
2576 2576 -73.9751625910271 40.7671023412885 3F-AM-1006-02 03F AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9751625910271 40.7671023412885)   19 4 19 13
2594 2594 -73.9638812060405 40.7923714941429 32A-PM-1013-02 32A PM 10132018 2 ? Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9638812060405 40.792371494142905)   19 4 19 13
2632 2632 -73.950827557335 40.797579073666 42H-PM-1014-02 42H PM 10142018 2 Adult Gray White Gray+White   Above Ground   Running along stone ledge true false false false false   false false false false false false true false   POINT (-73.950827557335 40.797579073666)   18 4 36 18
2643 2643 -73.9693719015914 40.7768710160557 14E-PM-1017-02 14E PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true staring false false false false false false false false   POINT (-73.9693719015914 40.7768710160557)   19 4 19 13
2688 2688 -73.9799302952205 40.7677207209798 1B-PM-1019-02 01B PM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9799302952205 40.7677207209798)   19 4 19 13
2689 2689 -73.9704121989487 40.7824040236981 19A-PM-1013-02 19A PM 10132018 2 Adult Gray White Gray+White Looks very brown, not like English red squirrels Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9704121989487 40.7824040236981)   19 4 19 13
2819 2819 -73.9550350096938 40.797694218705 41E-PM-1013-02 41E PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9550350096938 40.797694218705004)   19 4 19 13
2885 2885 -73.9530811255728 40.7983069118579 42F-AM-1019-02 42F AM 10192018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9530811255728 40.79830691185791)   19 4 19 13
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.964593167562 40.7780374890066)   19 4 19 13
2949 2949 -73.9651206201297 40.7785279064847 18G-AM-1014-02 18G AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9651206201297 40.7785279064847)   19 4 19 13
3009 3009 -73.9675637870968 40.7823880671728 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9675637870968 40.7823880671728)   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 110.681ms