squirrels

103 rows where Primary Fur Color = "Black" sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Foraging ✖

Primary Fur Color ✖

  • Black · 58 ✖

Police Precincts ✖

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
1979 1979 -73.9612759291399 40.7930468323219 33B-AM-1010-03 33B AM 10102018 3 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9612759291399 40.7930468323219)   19 4 19 13
2113 2113 -73.9582904814652 40.7905915749564 32F-AM-1012-04 32F AM 10122018 4 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9582904814652 40.7905915749564)   19 4 19 13
2120 2120 -73.9733905460282 40.7656337147768 2H-PM-1006-03 02H PM 10062018 3 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9733905460282 40.7656337147768)   19 4 19 13
2135 2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   false false true false true   false false false false true false true false   POINT (-73.9596251284566 40.7916254797561)   19 4 19 13
2150 2150 -73.9557710118271 40.7919161185557 34G-PM-1006-01 34G PM 10062018 1 Adult Black   Black+ Skinny, thin tail Ground Plane FALSE   false false false false false digging false false false false false false false false   POINT (-73.9557710118271 40.7919161185557)   19 4 19 13
2166 2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9711178122133 40.76726429584371)   19 4 19 13
2192 2192 -73.9593410965431 40.7923134010383 33D-AM-1017-08 33D AM 10172018 8 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9593410965431 40.7923134010383)   19 4 19 13
2206 2206 -73.9594446018346 40.7917800352042 33D-AM-1017-06 33D AM 10172018 6 Adult Black   Black+   Above Ground 10   false false true false false   true true false false false false false true runs from (ran into hole in tree trunk) POINT (-73.9594446018346 40.7917800352042)   19 4 19 13
2266 2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9716402454355 40.7665133780672)   19 4 19 13
2270 2270 -73.9703732649257 40.7701979377103 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.97037326492571 40.7701979377103)   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
2322 2322 -73.9723677854798 40.7667315410871 3H-AM-1008-04 03H AM 10082018 4 Adult Black   Black+   Above Ground 50   false false false false true   false false false false false false false false   POINT (-73.9723677854798 40.7667315410871)   19 4 19 13
2329 2329 -73.9717515173863 40.7747999274418 11D-PM-1006-04 11D PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9717515173863 40.7747999274418)   19 4 19 13
2351 2351 -73.9745818450109 40.7654498873627 1G-AM-1006-01 01G AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   false true false false true   false false false false true false true false   POINT (-73.9745818450109 40.7654498873627)   19 4 19 13
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   false false false false true   false false false false false false true true   POINT (-73.9729603550254 40.7660215710657)   19 4 19 13
2413 2413 -73.959701727877 40.790660026971 32E-AM-1007-03 32E AM 10072018 3 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.959701727877 40.790660026971)   19 4 19 13
2427 2427 -73.9729297485331 40.7673278541438 4H-AM-1006-03 04H AM 10062018 3 Adult Black   Black+   Ground Plane FALSE   false false false false true met #4 while foraging and briefly tussled false false false false false false true false   POINT (-73.9729297485331 40.7673278541438)   19 4 19 13
2449 2449 -73.9599911537509 40.7914452542845 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   false false true false false   false false false false true false false true   POINT (-73.9599911537509 40.7914452542845)   19 4 19 13
2469 2469 -73.9600963639087 40.7934962325313 34C-AM-1007-01 34C AM 10072018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false true false false false true dog POINT (-73.9600963639087 40.7934962325313)   19 4 19 13
2535 2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   false false true false false   false false false false true false false false   POINT (-73.9700101107283 40.7696729501144)   19 4 19 13
2549 2549 -73.972248505758 40.7659043693008 3I-PM-1013-01 03I PM 10132018 1 Adult Black   Black+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.972248505758 40.765904369300806)   19 4 19 13
2557 2557 -73.9712454251679 40.7674262749891 5I-PM-1008-02 05I PM 10082018 2 Adult Black   Black+   Ground Plane FALSE crossing pavement in front of arsenal true false false false false   false false false false false false false false   POINT (-73.9712454251679 40.7674262749891)   19 4 19 13
2572 2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9719901848577 40.7720525965356)   19 4 19 13
2638 2638 -73.9598973337711 40.7933346360478 34C-PM-1012-01 34C PM 10122018 1 Adult Black   Black+   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9598973337711 40.7933346360478)   19 4 19 13
2755 2755 -73.9712022111028 40.7672504368263 4I-AM-1006-01 04I AM 10062018 1 Adult Black   Black+   Above Ground 3 On top of park lamp true false false false false   false false false false false false true false   POINT (-73.9712022111028 40.7672504368263)   19 4 19 13
2768 2768 -73.9641088172632 40.7886555184212 28C-AM-1014-01 28C AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9641088172632 40.7886555184212)   19 4 19 13
2773 2773 -73.9625932664956 40.7885379477349 29D-AM-1014-01 29D AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9625932664956 40.7885379477349)   19 4 19 13
2817 2817 -73.9596445861554 40.7971948679007 38A-PM-1013-05 38A PM 10132018 5 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9596445861554 40.7971948679007)   19 4 19 13
2909 2909 -73.9564478909357 40.7976928775417 40C-PM-1006-04 40C PM 10062018 4 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9564478909357 40.7976928775417)   19 4 19 13
210 210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
430 430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
837 837 -73.9557172336815 40.7921125657722 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9557172336815 40.7921125657722)   19 4 19 13
1057 1057 -73.9594406225891 40.7918533707789 33D-AM-1017-02 33D AM 10172018 2 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9594406225891 40.7918533707789)   19 4 19 13
1392 1392 -73.9648090698176 40.7903882097837 29A-PM-1019-03 29A PM 10192018 3 Juvenile Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false true ran from,but now approaching. kind of weirding me out. POINT (-73.9648090698176 40.7903882097837)   19 4 19 13
1741 1741 -73.9736995552241 40.7722712518637 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree true false true false false   false false false false false false false false   POINT (-73.9736995552241 40.7722712518637)   19 4 19 13
1892 1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false true false false   POINT (-73.9745908987975 40.7655191512308)   19 4 19 13
2159 2159 -73.9696688162449 40.7741422177187 12F-AM-1020-05 12F AM 10202018 5 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9696688162449 40.7741422177187)   19 4 19 13
2325 2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728360875598 40.7660637295671)   19 4 19 13
2433 2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   false false false true false   false false false true true false true false   POINT (-73.9706949930717 40.772362045852)   19 4 19 13
2540 2540 -73.959127912788 40.7921197130403 33E-AM-1014-13 33E AM 10142018 13 Adult Black Cinnamon Black+Cinnamon Cinnamon on the tail Ground Plane FALSE   false false false false false sitting false false false false false false true false   POINT (-73.959127912788 40.7921197130403)   19 4 19 13
2731 2731 -73.9595886063173 40.7918405182594 33D-AM-1017-09 33D AM 10172018 9 Adult Black Cinnamon Black+Cinnamon   Above Ground 7   false false true false false   true true false false false false true true   POINT (-73.9595886063173 40.7918405182594)   19 4 19 13
2974 2974 -73.9575791421589 40.7959934459432 38D-AM-1017-06 38D AM 10172018 6 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9575791421589 40.7959934459432)   19 4 19 13
2975 2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false digging false false false false false false false true   POINT (-73.959412243507 40.7917871123534)   19 4 19 13
2985 2985 -73.9721159387757 40.7660503188637 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9721159387757 40.7660503188637)   19 4 19 13
1086 1086 -73.9713399316534 40.7750678026757 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   false false true false false lounging on tree upside down false false false false true false true false   POINT (-73.9713399316534 40.7750678026757)   19 4 19 13
1223 1223 -73.9591298551111 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9591298551111 40.7919612446005)   19 4 19 13
2879 2879 -73.9744080700098 40.7731515721826 9C-PM-1006-07 09C PM 10062018 7 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE on top of tarped sand pile false false false true false   false false false false false false false true (me) POINT (-73.9744080700098 40.7731515721826)   19 4 19 13
391 391 -73.9790875480358 40.7676104780657 2C-AM-1010-03 02C AM 10102018 3 Adult Black Gray Black+Gray   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9790875480358 40.7676104780657)   19 4 19 13
858 858 -73.9629383420274 40.7889383725489 29C-AM-1007-02 29C AM 10072018 2 Adult Black Gray Black+Gray   Above Ground 10   true false true false false   false true false false false false false true   POINT (-73.9629383420274 40.7889383725489)   19 4 19 13
1296 1296 -73.9705509170542 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass false false false true false   false false false false true false false false   POINT (-73.9705509170542 40.7689416540228)   19 4 19 13
1473 1473 -73.9584064190878 40.7912992852442 33F-PM-1012-03 33F PM 10122018 3 Adult Black Gray Black+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9584064190878 40.7912992852442)   19 4 19 13
2467 2467 -73.9755923256429 40.7672967972471 3F-PM-1013-02 03F PM 10132018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.97559232564292 40.7672967972471)   19 4 19 13
2496 2496 -73.9696274291417 40.7691980808067 7I-PM-1013-03 07I PM 10132018 3 Adult Black Gray Black+Gray   Ground Plane FALSE Trash bins false false false true false   false false false false false false false false   POINT (-73.9696274291417 40.7691980808067)   19 4 19 13
2651 2651 -73.9632993246327 40.7888199519656 29C-AM-1007-05 29C AM 10072018 5 Adult Black Gray Black+Gray   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9632993246327 40.7888199519656)   19 4 19 13
2999 2999 -73.972415182837 40.773080463452 10E-AM-1010-02 10E AM 10102018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   true false false false true   false false false false true false true false   POINT (-73.972415182837 40.773080463452)   19 4 19 13
1345 1345 -73.9581326554206 40.7918074743129 34E-PM-1006-02 34E PM 10062018 2 Juvenile Black Gray, White Black+Gray, White   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9581326554206 40.7918074743129)   19 4 19 13
181 181 -73.9708775864433 40.772473633538 10F-PM-1019-12 10F PM 10192018 12 Adult Black White Black+White   Ground Plane FALSE   true false false false true   false false false false false false false true   POINT (-73.9708775864433 40.772473633538)   19 4 19 13
1210 1210 -73.9707937464541 40.7725282708448 10G-PM-1017-07 10G PM 10172018 7 Adult Black White Black+White   Ground Plane FALSE   false false false false false traveling false false false false false false true false   POINT (-73.9707937464541 40.7725282708448)   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 207.903ms