squirrels

48 rows where Chasing = "true" and Combination of Primary and Highlight Color = "Gray+White" sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts

Police Precincts ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 48 ✖

Chasing ✖

  • true · 48 ✖
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
1489 1489 -73.9501762527462 40.7975534086077 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   true true false false false   false false false false false false false true   POINT (-73.9501762527462 40.7975534086077) 12423 18 4 36 18
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
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
1224 1224 -73.9572530843479 40.7987460430546 41B-AM-1010-05 41B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false false false   POINT (-73.9572530843479 40.7987460430546)   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
2214 2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9583688637255 40.791388958496)   19 4 19 13
772 772 -73.9584188461059 40.7913241048498 33E-PM-1012-07 33E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9584188461059 40.7913241048498)   19 4 19 13
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
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
957 957 -73.9586527721822 40.7908831110561 32F-PM-1008-08 32F PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   true true false false true   false false false false false false true false   POINT (-73.9586527721822 40.7908831110561)   19 4 19 13
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
840 840 -73.9598084794625 40.7976165434502 39A-PM-1014-01 39A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9598084794625 40.7976165434502)   19 4 19 13
2104 2104 -73.9622419917579 40.794579797904 35A-AM-1014-07 35A AM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9622419917579 40.794579797904)   19 4 19 13
212 212 -73.9638837160341 40.7809747900833 21G-AM-1014-07 21G AM 10142018 7 Adult Gray White Gray+White   Above Ground 5   false true true false false   false false false false false false false false   POINT (-73.9638837160341 40.7809747900833)   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
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
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
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
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
532 532 -73.9685429060839 40.7724786961619 11H-AM-1010-05 11H AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9685429060839 40.7724786961619)   19 4 19 13
82 82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
2085 2085 -73.9690551477139 40.7823685663196 20B-PM-1013-07 20B PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false false false true false   POINT (-73.9690551477139 40.7823685663196)   19 4 19 13
2855 2855 -73.9690832219322 40.782343340986 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false true false true false   POINT (-73.96908322193221 40.782343340986)   19 4 19 13
1588 1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   true false false false false false true false   POINT (-73.9693209851947 40.7707450042769)   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
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
750 750 -73.9699672074164 40.7774389345748 15D-AM-1007-07 15D AM 10072018 7 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true chasing #8 false false false false false false true false   POINT (-73.9699672074164 40.7774389345748)   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
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
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
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   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
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
1644 1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9734654671008 40.7715988711659)   19 4 19 13
879 879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9735120882106 40.7715915415169)   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
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
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
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
2633 2633 -73.9776151109912 40.7694681558386 4C-PM-1010-09 04C PM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false false false false false   POINT (-73.9776151109912 40.7694681558386)   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
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
1264 1264 -73.9785353775382 40.7674923683184 2C-PM-1013-01 02C PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9785353775382 40.7674923683184)   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
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
2591 2591 -73.9786351029146 40.7716114164002 6A-PM-1012-06 06A PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE elevated ground false true false false true   false false false true false false true false   POINT (-73.9786351029146 40.771611416400205)   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
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

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