squirrels

21 rows where Date = 10132018, Eating = "true" and Running = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, 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, Chasing, Climbing, Foraging, Other Activities, Quaas, Tail flags, Tail twitches, Approaches, 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
79 79 -73.9610705592868 40.7914829661051 32D-AM-1013-06 32D AM 10132018 6 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false true true eating (a mushroom),circles around us,really fat,scratching himself,grooming activity false false false false true true false false   POINT (-73.9610705592868 40.7914829661051)   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
222 222 -73.9770273553525 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence true true true true false playing tag together false false false false false true false false   POINT (-73.9770273553525 40.7732399463626)   19 4 19 13
409 409 -73.9530809650496 40.7959176317705 40G-PM-1013-02 40G PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false hiding from dog false false false false false false false true runs from (dog) POINT (-73.9530809650496 40.79591763177051)   19 4 19 13
868 868 -73.9738481771673 40.7706540698938 7E-PM-1013-04 07E PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9738481771673 40.7706540698938)   19 4 19 13
1029 1029 -73.9601259189134 40.7955350609057 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9601259189134 40.7955350609057)   19 4 19 13
1108 1108 -73.9638397790384 40.7828950272904 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false true false false true false true false indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)   19 4 19 13
1200 1200 -73.9657721715305 40.778534830257 18G-PM-1013-03 18G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9657721715305 40.778534830257)   19 4 19 13
1346 1346 -73.9735655529245 40.7716072681474 7E-PM-1013-02 07E PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false false true true   false false false false false false false true   POINT (-73.9735655529245 40.7716072681474)   19 4 19 13
1412 1412 -73.9594676326588 40.7984457363388 39A-AM-1013-01 39A AM 10132018 1 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9594676326588 40.7984457363388)   19 4 19 13
1416 1416 -73.9757313481982 40.7754704051391 11A-PM-1013-04 11A PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false true true   false false false false false false false false   POINT (-73.9757313481982 40.7754704051391)   19 4 19 13
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   true false true true false got fed twice by grandpa,grabbed from grass and ate in tree false false false false false true true true approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)   19 4 19 13
1623 1623 -73.9770119133023 40.7732949090005 8A-AM-1013-04 08A AM 10132018 4 Juvenile     +   Above Ground 4 fence true true false true true playing tag together false false false false false true false false   POINT (-73.9770119133023 40.7732949090005)   19 4 19 13
1636 1636 -73.9701408623121 40.7695511718541 7I-PM-1013-04 07I PM 10132018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE Grass true false false true false   false false false true false false false false   POINT (-73.9701408623121 40.7695511718541)   19 4 19 13
1695 1695 -73.9604083891356 40.7910284106931 32D-AM-1013-05 32D AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true false false true false   false false false false false false true false   POINT (-73.9604083891356 40.7910284106931)   19 4 19 13
2263 2263 -73.9569375355884 40.7935398008612 36E-AM-1013-02 36E AM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9569375355884 40.7935398008612)   19 4 19 13
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false true true true   false false false false false false false true   POINT (-73.973552877209 40.7715638228207)   19 4 19 13
2483 2483 -73.9596083366477 40.7949526729608 36C-PM-1013-05 36C PM 10132018 5 Adult Cinnamon   Cinnamon+ "Warm brown" written in for Primary. Ground Plane FALSE Ran across path in front of people true false false true true   false false false false true false true true   POINT (-73.9596083366477 40.7949526729608)   19 4 19 13
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true true false   false false false false false true false false   POINT (-73.9772239251936 40.7731716665766)   19 4 19 13
2716 2716 -73.9618094076328 40.7944097368153 35A-PM-1013-03 35A PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false true true   false false false false false false false true   POINT (-73.9618094076328 40.7944097368153)   19 4 19 13
2835 2835 -73.9531953594918 40.7960413520131 40G-PM-1013-01 40G PM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false false true false false   POINT (-73.9531953594918 40.7960413520131)   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 59.282ms