squirrels

41 rows where Chasing = "true", Highlight Fur Color = "White" and Location = "Ground Plane"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

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
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
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
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
514 514 -73.9768357173861 40.7683813358343 3D-PM-1010-12 03D PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true false false true   false true false false false false false false   POINT (-73.9768357173861 40.7683813358343)   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
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
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
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
640 640 -73.9785536529136 40.7716184505002 6A-PM-1012-07 06A PM 10122018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE elevated ground false true false false true   false false false false false false true false   POINT (-73.9785536529136 40.771618450500206)   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
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
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
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
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
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
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
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
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
1282 1282 -73.974451175321 40.7701294635264 6E-PM-1010-04 06E PM 10102018 4 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #3 false false false false false false true false   POINT (-73.974451175321 40.7701294635264)   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
1551 1551 -73.9785114291288 40.7719779589449 6A-PM-1012-03 06A PM 10122018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true true true false false   false false false false false false false false   POINT (-73.9785114291288 40.7719779589449)   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
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
2007 2007 -73.9684834138222 40.7724289120211 11H-AM-1010-06 11H AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false true false false false   false false false false true false true false   POINT (-73.9684834138222 40.7724289120211)   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
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
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
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
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
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
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
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
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
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
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
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
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
2946 2946 -73.974515099169 40.7700650799886 6E-PM-1010-03 06E PM 10102018 3 Adult Cinnamon White Cinnamon+White white back legs Ground Plane FALSE small open area but w/ 7 large oak trees false true false true false chasing #4 false false false false false false true false   POINT (-73.974515099169 40.770065079988605)   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 67.844ms