squirrels

17 rows where Kuks = "true", Location = "Ground Plane" and Runs from = "true"

✎ 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, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Tail flags, 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
84 84 -73.9701824825872 40.7766530579293 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   true false false false false false false true   POINT (-73.9701824825872 40.7766530579293)   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
504 504 -73.9533476020736 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree true false true false true   true false false false false false false true dogs POINT (-73.9533476020736 40.7933003544685)   19 4 19 13
529 529 -73.9635290751183 40.7820936628202 22G-AM-1018-02 22G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true false true false false   true false false false false false false true   POINT (-73.9635290751183 40.7820936628202)   19 4 19 13
643 643 -73.976730206737 40.773709213914 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   true false false false false false false true runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)   19 4 19 13
743 743 -73.9565035705619 40.7937382705056 36F-AM-1017-04 36F AM 10172018 4 Juvenile Gray White Gray+White White legs, front & back Ground Plane FALSE   true false false true true   true false false false false true false true approaches (me),runs from (me) POINT (-73.9565035705619 40.7937382705056)   19 4 19 13
769 769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   true false false false false false false true   POINT (-73.976521916284 40.773784724458)   19 4 19 13
929 929 -73.9738611257716 40.7737246779587 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   true false false false true false false true   POINT (-73.9738611257716 40.7737246779587)   19 4 19 13
1250 1250 -73.9585133340331 40.7963721679474 38C-PM-1014-03 38C PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   true false false false false false false true   POINT (-73.9585133340331 40.7963721679474)   19 4 19 13
1314 1314 -73.980919134781 40.7683772453336 1A-PM-1014-06 01A PM 10142018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   true false false false false false false true   POINT (-73.980919134781 40.7683772453336)   19 4 19 13
1502 1502 -73.9705254801 40.7763606494306 13E-AM-1017-03 13E AM 10172018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   true false false false false false false true acknowledges POINT (-73.9705254801 40.7763606494306)   19 4 19 13
2176 2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.9615643742864 40.7944678447843)   19 4 19 13
2710 2710 -73.9577919365342 40.7960853285059 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   true false false false false false false true   POINT (-73.9577919365342 40.7960853285059)   19 4 19 13
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   true false true false false chased by dog #2 true false false false false false false true runs from (dog) POINT (-73.96159260312531 40.7944223235385)   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 56.06ms