squirrels

19 rows where Above Ground Sighter Measurement = 50 and Kuks = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail twitches, 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
48 48 -73.9595933195409 40.7905847332369 32E-AM-1007-13 32E AM 10072018 13 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9595933195409 40.7905847332369)   19 4 19 13
71 71 -73.9576245992455 40.7873862510001 29H-PM-1006-01 29H PM 10062018 1 Adult Gray   Gray+   Above Ground 50   false false true false false sitting false false false false false false true false   POINT (-73.9576245992455 40.7873862510001)   19 4 19 13
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
156 156 -73.9576589997493 40.7972751877447 39C-PM-1006-02 39C PM 10062018 2 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false unaware of POINT (-73.95765899974931 40.7972751877447)   19 4 19 13
700 700 -73.9691261755936 40.7702929428604 8I-AM-1006-12 08I AM 10062018 12 Adult Gray   Gray+   Above Ground 50 tree false false true false false   false false false false false false true false   POINT (-73.9691261755936 40.7702929428604)   19 4 19 13
919 919 -73.9637279711853 40.7905198502307 30B-AM-1007-09 30B AM 10072018 9 Adult Gray   Gray+   Above Ground 50   false false true false false jumping b/w trees false false false false false false false false   POINT (-73.9637279711853 40.7905198502307)   19 4 19 13
1016 1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree false true false false false   false false false false false false true false   POINT (-73.9691293546408 40.77032190765491)   19 4 19 13
1071 1071 -73.9703774000082 40.7717607551555 9G-AM-1007-01 09G AM 10072018 1 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9703774000082 40.7717607551555)   19 4 19 13
1110 1110 -73.9676434256976 40.7862336624448 24A-PM-1007-04 24A PM 10072018 4 Adult Gray   Gray+   Above Ground 50 in tree false false true false false   false false false false false false false false   POINT (-73.9676434256976 40.7862336624448)   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
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   true true true false true   false true false false false false false false looked at us from tree POINT (-73.9677096985223 40.7825358361204)   19 4 19 13
1227 1227 -73.9527924755398 40.7934366260533 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree false false true false false   false false false false false false true false   POINT (-73.9527924755398 40.7934366260533)   19 4 19 13
1398 1398 -73.9602808042376 40.7906130788763 32E-AM-1007-14 32E AM 10072018 14 Adult Gray   Gray+   Above Ground 50 literally fell to ground from 50 feet up false false false false false falling false false false false false false false true   POINT (-73.9602808042376 40.7906130788763)   19 4 19 13
2322 2322 -73.9723677854798 40.7667315410871 3H-AM-1008-04 03H AM 10082018 4 Adult Black   Black+   Above Ground 50   false false false false true   false false false false false false false false   POINT (-73.9723677854798 40.7667315410871)   19 4 19 13
2393 2393 -73.9729190572117 40.770018150905 6F-PM-1008-03 06F PM 10082018 3 Adult Gray   Gray+   Above Ground 50 top of tree false false false false true   false false false false false false false false   POINT (-73.9729190572117 40.770018150905)   19 4 19 13
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9657958433575 40.7763496875058)   19 4 19 13
2603 2603 -73.9708781504528 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   false false true false false   false false false false false false false false   POINT (-73.9708781504528 40.7724138070355)   19 4 19 13
2777 2777 -73.9810843611086 40.7687905493699 2A-PM-1019-05 02A PM 10192018 5 ? Gray   Gray+   Above Ground 50 in tall planetree true false false false false   false false false false false false false false   POINT (-73.9810843611086 40.7687905493699)   19 4 19 13
2914 2914 -73.9722053355548 40.7662094993614 3I-AM-1010-03 03I AM 10102018 3 Adult Gray   Gray+   Above Ground 50   true false false false false   false false false false false false true false   POINT (-73.9722053355548 40.7662094993614)   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 61.737ms