squirrels

19 rows where Date = 10142018, Highlight Fur Color = "White", Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, 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
128 128 -73.9746229094643 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false false false avoided people POINT (-73.9746229094643 40.7748467061969)   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
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
248 248 -73.9751729403694 40.7743284123118 10B-PM-1014-02 10B PM 10142018 2 Adult Gray White Gray+White   Above Ground   gingko tree by traffic light in front of Strawberry Fields false false false false true   false false false false true false false false came over on tree to see me then disappeared POINT (-73.9751729403694 40.7743284123118)   19 4 19 13
431 431 -73.9757436019432 40.7746064363227 10B-PM-1014-01 10B PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE on lawn in front of a tree false false false false true   false false false false true false false false stay on ground but went to other side of tree to hide from a dog POINT (-73.9757436019432 40.7746064363227)   19 4 19 13
465 465 -73.9683041099256 40.7862652300082 24A-AM-1014-01 24A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false freezes POINT (-73.9683041099256 40.7862652300082)   19 4 19 13
517 517 -73.954959868822 40.7985404965582 41D-PM-1014-03 41D PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.954959868822 40.7985404965582)   19 4 19 13
580 580 -73.9750992564362 40.7743391883762 10B-PM-1014-03 10B PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9750992564362 40.7743391883762)   19 4 19 13
600 600 -73.9808202088503 40.7682921842325 1A-PM-1014-02 01A PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false false false false false   POINT (-73.9808202088503 40.7682921842325)   19 4 19 13
966 966 -73.958317581802 40.7916566683158 33E-AM-1014-12 33E AM 10142018 12 Adult Gray White Gray+White   Above Ground 15   false false false false false sleeping false false false false false false false false asleep POINT (-73.958317581802 40.7916566683158)   19 4 19 13
1510 1510 -73.9655670884957 40.7763728890554 16H-PM-1014-03 16H PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false true false false followed man across bridge POINT (-73.9655670884957 40.7763728890554)   19 4 19 13
1987 1987 -73.9573692542155 40.7989252908321 41B-PM-1014-03 41B PM 10142018 3 Adult Gray White Gray+White   Above Ground 28   false false true false false   false false false false false false false false   POINT (-73.9573692542155 40.7989252908321)   19 4 19 13
2216 2216 -73.9735195018446 40.7787147279715 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true false true   false false false false true false false false   POINT (-73.9735195018446 40.7787147279715)   19 4 19 13
2312 2312 -73.9765867029226 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9765867029226 40.7674304266107)   19 4 19 13
2387 2387 -73.9808517324721 40.7683154647217 1A-PM-1014-01 01A PM 10142018 1 Adult Cinnamon White Cinnamon+White   Above Ground 6   false true false false false   false false false false true false false false   POINT (-73.9808517324721 40.7683154647217)   19 4 19 13
2398 2398 -73.958713848373 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.958713848373 40.7963918051751)   19 4 19 13
2551 2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)   19 4 19 13
2659 2659 -73.9553603438021 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   false false false true false   false false false false false false false false   POINT (-73.9553603438021 40.7985282963244)   19 4 19 13
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9747963162162 40.7745023355775)   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 78.554ms