squirrels

41 rows where Combination of Primary and Highlight Color = "Gray+White", Date = 10102018, Police Precincts = 13 and Tail twitches = "false" sorted by Approaches

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Chasing, Climbing, Other Activities, Tail flags, Indifferent, Runs from, Other Interactions

Running ✖

Foraging ✖

Tail twitches ✖

  • false · 41 ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 41 ✖
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
111 111 -73.9763243383771 40.7705409315703 5C-PM-1010-13 05C PM 10102018 13 Adult Gray White Gray+White   Above Ground 20 way up a tree! false false true false false   false false false false false false false false   POINT (-73.9763243383771 40.7705409315703)   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
294 294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   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
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
520 520 -73.9749446629706 40.7720659696067 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare true false false false false   false false false false false false false false   POINT (-73.9749446629706 40.7720659696067)   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
602 602 -73.9685751595485 40.7709413567859 9I-PM-1010-07 09I PM 10102018 7 Adult Gray White Gray+White   Above Ground 1 ran up tree true false false false false   false false false false false false false true   POINT (-73.9685751595485 40.7709413567859)   19 4 19 13
704 704 -73.9793565564361 40.7679259390448 2C-AM-1010-09 02C AM 10102018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false climbed up tree as i neared POINT (-73.9793565564361 40.7679259390448)   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
807 807 -73.9777259022441 40.7682059907903 3D-PM-1010-10 03D PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9777259022441 40.7682059907903)   19 4 19 13
1080 1080 -73.9690211935346 40.773038298158 11H-AM-1010-07 11H AM 10102018 7 Adult Gray White Gray+White   Above Ground 4   false false false true false   false false false false false false false true   POINT (-73.9690211935346 40.773038298158)   19 4 19 13
1141 1141 -73.9664669369583 40.7774085361976 16G-AM-1010-05 16G AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9664669369583 40.7774085361976)   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
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
1259 1259 -73.976864402584 40.7705663751959 5C-PM-1010-05 05C PM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false false false false false   POINT (-73.976864402584 40.7705663751959)   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
1347 1347 -73.9616693665254 40.792971019627 33B-AM-1010-05 33B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9616693665254 40.792971019627)   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
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
1532 1532 -73.9779263114572 40.7682681855369 3D-PM-1010-08 03D PM 10102018 8 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9779263114572 40.7682681855369)   19 4 19 13
1580 1580 -73.9775079672882 40.7691500357424 4C-PM-1010-07 04C PM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9775079672882 40.7691500357424)   19 4 19 13
1814 1814 -73.9722359401242 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9722359401242 40.7702891474555)   19 4 19 13
1827 1827 -73.9779760874355 40.7698230936583 4C-PM-1010-16 04C PM 10102018 16 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9779760874355 40.7698230936583)   19 4 19 13
1849 1849 -73.9788436368415 40.7691104998969 3B-AM-1010-05 03B AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9788436368415 40.7691104998969)   19 4 19 13
1901 1901 -73.9680237209555 40.7717022208225 10I-AM-1010-04 10I AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9680237209555 40.7717022208225)   19 4 19 13
1913 1913 -73.9774630821854 40.7680626674086 3D-PM-1010-11 03D PM 10102018 11 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9774630821854 40.76806266740861)   19 4 19 13
1996 1996 -73.977641787698 40.7695830265784 4C-PM-1010-10 04C PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.977641787698 40.7695830265784)   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
2116 2116 -73.9801562527339 40.7687267327113 2B-AM-1010-01 02B AM 10102018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9801562527339 40.7687267327113)   19 4 19 13
2144 2144 -73.975198284551 40.7740343763399 9B-AM-1010-06 09B AM 10102018 6 Juvenile Gray White Gray+White   Above Ground 16 tree false false true false false cleaning false false false false false false true false   POINT (-73.975198284551 40.7740343763399)   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
2235 2235 -73.9748522796455 40.7719586621003 7D-PM-1010-01 07D PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE outside fenced hectare true false false false false   false false false false false false false false   POINT (-73.9748522796455 40.7719586621003)   19 4 19 13
2497 2497 -73.9622050752008 40.7886373772305 29D-PM-1010-01 29D PM 10102018 1 Juvenile Gray White Gray+White   Above Ground 10   false false true true false   false false false false false false true false   POINT (-73.9622050752008 40.7886373772305)   19 4 19 13
2628 2628 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 10102018 13 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9770439076963 40.7685720141731)   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
2701 2701 -73.9791217510656 40.7676583475394 2C-AM-1010-05 02C AM 10102018 5 Adult Gray White Gray+White   Ground Plane FALSE right at the base of the same tree as #3 false false false true true   false false false false false false false false   POINT (-73.9791217510656 40.7676583475394)   19 4 19 13
2778 2778 -73.9761799699276 40.774213409933 9B-AM-1010-07 09B AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9761799699276 40.774213409933)   19 4 19 13
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree false false true false false   false false false false false false false false   POINT (-73.9654741695628 40.7890427851106)   19 4 19 13
917 917 -73.9676514056678 40.7730853732876 11H-AM-1010-01 11H AM 10102018 1 Adult Gray White Gray+White   Above Ground 20   false false true false false   false false false false false true false false started climbing down to me POINT (-73.9676514056678 40.7730853732876)   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

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