squirrels

76 rows where Combination of Primary and Highlight Color = "Gray+White" and Hectare Squirrel Number = 3 sorted by Combination of Primary and Highlight 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, 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 · 76 ✖
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
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
73 73 -73.96148483609 40.7922645521905 33C-PM-1007-03 33C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.96148483609 40.7922645521905)   19 4 19 13
77 77 -73.9615696577673 40.7951278622399 35A-AM-1014-03 35A AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9615696577673 40.7951278622399)   19 4 19 13
123 123 -73.9671147090087 40.7772624641112 16G-AM-1010-03 16G AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true was hanging out w/ #2 until i showed up true false false false false false false true   POINT (-73.9671147090087 40.7772624641112)   19 4 19 13
164 164 -73.9758676144255 40.7701671581939 5D-PM-1018-03 05D PM 10182018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9758676144255 40.7701671581939)   19 4 19 13
258 258 -73.9534333425633 40.7932564163328 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries false false false true false   false true false false false false false true   POINT (-73.9534333425633 40.7932564163328)   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
299 299 -73.9586214081667 40.7937473968735 35D-PM-1013-03 35D PM 10132018 3 Juvenile Gray White Gray+White No Tail! Above Ground 2 bench false false false true false   false false false false false false true false   POINT (-73.9586214081667 40.7937473968735)   19 4 19 13
307 307 -73.9683965841952 40.7718679848978 10I-AM-1010-03 10I AM 10102018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9683965841952 40.7718679848978)   19 4 19 13
323 323 -73.9573469787503 40.7944044592573 36E-AM-1013-03 36E AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false indifferent (moving very fast) POINT (-73.9573469787503 40.7944044592573)   19 4 19 13
331 331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree false false false true false   false false false false false false false true ran up tree when approached POINT (-73.95448101115 40.7954469678857)   19 4 19 13
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock false false false true true   false false false false false false true false   POINT (-73.9793952066038 40.77078376578591)   19 4 19 13
483 483 -73.9789952029637 40.7697758333099 4B-AM-1010-03 04B AM 10102018 3 Juvenile Gray White Gray+White   Above Ground 25   false false true false false   false false false false false false true false   POINT (-73.9789952029637 40.7697758333099)   19 4 19 13
517 517 -73.954959868822 40.7985404965582 41D-PM-1014-03 41D PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.954959868822 40.7985404965582)   19 4 19 13
561 561 -73.9581982486469 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   true false true false false   false false false false true false false false   POINT (-73.95819824864691 40.7992194575293)   19 4 19 13
575 575 -73.9783366903829 40.7668300056094 1D-PM-1007-03 01D PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9783366903829 40.7668300056094)   19 4 19 13
580 580 -73.9750992564362 40.7743391883762 10B-PM-1014-03 10B PM 10142018 3 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.9750992564362 40.7743391883762)   19 4 19 13
649 649 -73.9554891003543 40.7968774599654 40E-AM-1014-03 40E AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false false false true false   POINT (-73.9554891003543 40.79687745996541)   19 4 19 13
659 659 -73.9572686979412 40.796268457326 38D-AM-1017-03 38D AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false false false false   POINT (-73.9572686979412 40.796268457326)   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
752 752 -73.9768617690725 40.7741877060705 9A-PM-1010-03 09A PM 10102018 3   Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false froze - standing on hind legs for ~10 seconds then scampered off POINT (-73.97686176907251 40.7741877060705)   19 4 19 13
891 891 -73.9613351649026 40.7909866851357 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613351649026 40.7909866851357)   19 4 19 13
986 986 -73.978400938697 40.7677411911854 2C-PM-1013-03 02C PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.978400938697 40.7677411911854)   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
1116 1116 -73.9729847109778 40.7740709049602 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9729847109778 40.7740709049602)   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
1268 1268 -73.9623984262936 40.7913900453449 31C-PM-1010-03 31C PM 10102018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9623984262936 40.7913900453449)   19 4 19 13
1310 1310 -73.9546201403481 40.7989423768656 42D-AM-1014-03 42D AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9546201403481 40.7989423768656)   19 4 19 13
1328 1328 -73.9765758043111 40.7713803154032 6C-AM-1007-03 06C AM 10072018 3 Adult Gray White Gray+White   Above Ground 8 another tree true false true false false   false false false false false false false true   POINT (-73.9765758043111 40.7713803154032)   19 4 19 13
1358 1358 -73.9693772461788 40.7706875892901 8I-AM-1006-03 08I AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9693772461788 40.7706875892901)   19 4 19 13
1395 1395 -73.9710801547498 40.7760872452093 13D-AM-1014-03 13D AM 10142018 3 Juvenile Gray White Gray+White   Above Ground 2   false true true true false   false false false false false false false true   POINT (-73.9710801547498 40.7760872452093)   19 4 19 13
1461 1461 -73.956926909344 40.7965323262487 39D-PM-1012-03 39D PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.956926909344 40.7965323262487)   19 4 19 13
1465 1465 -73.9720289863666 40.7763749561607 13C-PM-1019-03 13C PM 10192018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.97202898636661 40.7763749561607)   19 4 19 13
1494 1494 -73.9525752408169 40.7954915417553 39H-AM-1007-03 39H AM 10072018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9525752408169 40.7954915417553)   19 4 19 13
1502 1502 -73.9705254801 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   true false false false false false false true acknowledges POINT (-73.9705254801 40.7763606494306)   19 4 19 13
1510 1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false true false false followed man across bridge POINT (-73.9655670884957 40.7763728890554)   19 4 19 13
1672 1672 -73.9640989602986 40.7899295439265 29B-PM-1010-03 29B PM 10102018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9640989602986 40.7899295439265)   19 4 19 13
1747 1747 -73.9665763797607 40.7761316400012 15H-AM-1013-03 15H AM 10132018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9665763797607 40.7761316400012)   19 4 19 13
1759 1759 -73.9576219570858 40.7963351225672 38C-AM-1019-03 38C AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9576219570858 40.7963351225672)   19 4 19 13
1779 1779 -73.9695560376915 40.7708835103516 9H-AM-1006-03 09H AM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.96955603769152 40.7708835103516)   19 4 19 13
1836 1836 -73.9751056714758 40.7732060035215 8C-PM-1013-03 08C PM 10132018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9751056714758 40.7732060035215)   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
1860 1860 -73.9767100101318 40.7675779951996 2E-PM-1014-03 02E PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.9767100101318 40.7675779951996)   19 4 19 13
1914 1914 -73.9588714413332 40.7895787115444 31F-PM-1007-03 31F PM 10072018 3 Adult Gray White Gray+White white belly Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9588714413332 40.7895787115444)   19 4 19 13
1937 1937 -73.9565549485301 40.7989823714955 41C-AM-1017-03 41C AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9565549485301 40.7989823714955)   19 4 19 13
1981 1981 -73.972154069981 40.7690128009722 6G-AM-1008-03 06G AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE grass false false false true true   false false false true false false true false   POINT (-73.972154069981 40.7690128009722)   19 4 19 13
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   false false true false false   false false false false false false false false   POINT (-73.9573692542155 40.7989252908321)   19 4 19 13
1988 1988 -73.957138794884 40.7985389822719 40C-AM-1017-03 40C AM 10172018 3 Adult Gray White Gray+White         true true true false false chasing (#4),digging false false false false true false true false   POINT (-73.957138794884 40.7985389822719)   19 4 19 13
2041 2041 -73.9651796685091 40.7785578267586 18G-AM-1014-03 18G AM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9651796685091 40.7785578267586)   19 4 19 13
2042 2042 -73.9800896621713 40.7684379810317 2B-PM-1013-03 02B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9800896621713 40.7684379810317)   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
2071 2071 -73.9667694439895 40.7779501809095 17G-PM-1017-03 17G PM 10172018 3 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.9667694439895 40.7779501809095)   19 4 19 13
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false false true stood on back legs false false false false false true true true   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
2129 2129 -73.9701182454818 40.7772805500871 15D-PM-1017-03 15D PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9701182454818 40.7772805500871)   19 4 19 13
2151 2151 -73.9697178769788 40.7791544102422 17D-AM-1008-03 17D AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.96971787697882 40.7791544102422)   19 4 19 13
2191 2191 -73.9734108731087 40.7676051392697 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9734108731087 40.7676051392697)   19 4 19 13
2213 2213 -73.9707487237344 40.7800822831001 17B-PM-1012-03 17B PM 10122018 3 Adult Gray White Gray+White   Above Ground 10   true true false false false 2/3 chasing each other false false false false true false true false   POINT (-73.9707487237344 40.7800822831001)   19 4 19 13
2250 2250 -73.9589016385889 40.7911727679625 33E-PM-1012-03 33E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9589016385889 40.7911727679625)   19 4 19 13
2253 2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees false false false true true   false false false false false true false false also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)   19 4 19 13
2328 2328 -73.9678620840741 40.784719027304 23B-PM-1012-03 23B PM 10122018 3 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.96786208407411 40.784719027304)   19 4 19 13
2346 2346 -73.9562177305881 40.7983413276331 41C-PM-1007-03 41C PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9562177305881 40.7983413276331)   19 4 19 13
2397 2397 -73.9704592500888 40.772962887933 10G-AM-1006-03 10G AM 10062018 3 Juvenile Gray White Gray+White tuft on butt Above Ground 10   false false true false false   false false false true false false false true   POINT (-73.9704592500888 40.772962887933)   19 4 19 13
2412 2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 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.9809446489564 40.7685032165879)   19 4 19 13
2494 2494 -73.9713968424625 40.7740390188527 11E-PM-1012-03 11E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9713968424625 40.7740390188527)   19 4 19 13
2518 2518 -73.9647219419257 40.7812084402932 20F-PM-1007-03 20F PM 10072018 3 Adult Gray White Gray+White gray on haunches white on tail Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9647219419257 40.7812084402932)   19 4 19 13
2528 2528 -73.9676529780724 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676529780724 40.7823206990549)   19 4 19 13
2542 2542 -73.9754802138871 40.773300804412 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9754802138871 40.773300804412)   19 4 19 13
2571 2571 -73.9695468150218 40.7821142051746 20B-PM-1013-03 20B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9695468150218 40.7821142051746)   19 4 19 13
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9618094076328 40.7944097368153)   19 4 19 13
2766 2766 -73.9551639847466 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree false false false true false   false false false false true false false false   POINT (-73.9551639847466 40.790858199891)   19 4 19 13
2774 2774 -73.9705409446299 40.7764608087703 14E-PM-1017-03 14E PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9705409446299 40.7764608087703)   19 4 19 13
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false true true false true   POINT (-73.9563473341712 40.78937123984251)   19 4 19 13
2860 2860 -73.9565179671319 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95651796713192 40.7936663940365)   19 4 19 13
2865 2865 -73.9802842404016 40.7678257384977 1B-PM-1019-03 01B PM 10192018 3 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.98028424040162 40.7678257384977)   19 4 19 13
2890 2890 -73.9726236083428 40.7788217771475 15B-PM-1017-03 15B PM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE by water true false false false true   false false false false false false true false   POINT (-73.9726236083428 40.778821777147506)   19 4 19 13
2926 2926 -73.9714653576023 40.7717400139502 9F-AM-1013-03 09F AM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9714653576023 40.7717400139502)   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 66.775ms