squirrels

30 rows where Date = 10102018, Highlight Fur Color = "White", Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Unique Squirrel ID, Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail twitches, Approaches, 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
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
140 140 -73.9768652785664 40.7684838168207 3D-PM-1010-03 03D PM 10102018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.97686527856641 40.7684838168207)   19 4 19 13
157 157 -73.9637946878735 40.7915700446878 31A-AM-1010-04 31A AM 10102018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9637946878735 40.7915700446878)   19 4 19 13
278 278 -73.9787796921165 40.7707526535381 5A-PM-1010-01 05A PM 10102018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9787796921165 40.7707526535381)   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
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
537 537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   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
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
1127 1127 -73.9776445567926 40.768119107973 3D-PM-1010-07 03D PM 10102018 7 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9776445567926 40.768119107973)   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
1158 1158 -73.9763894759543 40.7705523372364 5C-PM-1010-12 05C PM 10102018 12 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9763894759543 40.7705523372364)   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
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
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
1740 1740 -73.9577758125518 40.799384716477 41B-AM-1010-10 41B AM 10102018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9577758125518 40.799384716477)   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
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
2587 2587 -73.9789971286844 40.7707024146365 5A-PM-1010-04 05A PM 10102018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9789971286844 40.7707024146365)   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
2674 2674 -73.9771009024581 40.7688793288864 3D-PM-1010-06 03D PM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9771009024581 40.7688793288864)   19 4 19 13
2692 2692 -73.9801636400744 40.7690192055926 2A-AM-1010-09 02A AM 10102018 9 Adult Gray White Gray+White   Above Ground   climbing in bush false false true false false hopping & flipping around. this one was very energetic & jumping aorund false false false false true false false false climbed a foot up a tree and watched me POINT (-73.9801636400744 40.7690192055926)   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
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

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