squirrels

30 rows where Approaches = "true" and Hectare Squirrel Number = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, 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, Tail flags, Indifferent, Runs from, Other Interactions

Tail twitches ✖

Hectare Squirrel Number ✖

Approaches ✖

  • true · 30 ✖
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
53 53 -73.9584970643213 40.7982886348696 40B-AM-1019-03 40B AM 10192018 3 Juvenile Gray White Gray+White   Ground Plane FALSE   true true false false false   false false false false true true false false   POINT (-73.9584970643213 40.7982886348696)   19 4 19 13
154 154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9686056085297 40.7781658424866)   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
232 232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true true true approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)   19 4 19 13
257 257 -73.9773317054464 40.7684035996758 3D-AM-1006-03 03D AM 10062018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE on top [of] a big rock/boulder in the area true false true false false climbing (rock) false false false false false true false false approaches (slightly),wary of humans POINT (-73.9773317054464 40.76840359967581)   19 4 19 13
266 266 -73.9786481009499 40.7697372811949 4B-PM-1018-03 04B PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9786481009499 40.7697372811949)   19 4 19 13
651 651 -73.9801661903932 40.7697950141751 3A-PM-1017-03 03A PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9801661903932 40.7697950141751)   19 4 19 13
723 723 -73.9654397484763 40.7798863522904 19F-PM-1017-03 19F PM 10172018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9654397484763 40.7798863522904)   19 4 19 13
852 852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   true false true false false hopping false false false false false true false true   POINT (-73.9609704650925 40.7938786854735)   19 4 19 13
998 998 -73.9600546294497 40.7914969165757 33D-AM-1017-03 33D AM 10172018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true true false   POINT (-73.9600546294497 40.7914969165757)   19 4 19 13
1024 1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true true true   POINT (-73.9521514669041 40.7949515182825)   19 4 19 13
1137 1137 -73.9520280004414 40.7946345014466 39I-PM-1013-03 39I PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false false playing false false false false false true false false   POINT (-73.9520280004414 40.7946345014466)   19 4 19 13
1289 1289 -73.9724681269526 40.7743474675821 11D-PM-1006-03 11D PM 10062018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9724681269526 40.7743474675821)   19 4 19 13
1392 1392 -73.9648090698176 40.7903882097837 29A-PM-1019-03 29A PM 10192018 3 Juvenile Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false true ran from,but now approaching. kind of weirding me out. POINT (-73.9648090698176 40.7903882097837)   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
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
1892 1892 -73.9745908987975 40.7655191512308 1G-AM-1006-03 01G AM 10062018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false true false false true   false false false false false true false false   POINT (-73.9745908987975 40.7655191512308)   19 4 19 13
2117 2117 -73.9597192455543 40.7973316178661 38A-AM-1019-03 38A AM 10192018 3 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false false true stood on back legs false false false false false true true true   POINT (-73.9597192455543 40.7973316178661)   19 4 19 13
2149 2149 -73.9691845420174 40.7707749899254 9I-AM-1014-03 09I AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9691845420174 40.7707749899254)   19 4 19 13
2205 2205 -73.9594986107981 40.7840083040604 25I-AM-1012-03 25I AM 10122018 3 Adult Cinnamon   Cinnamon+   Above Ground 8 on turn, see map true true false true false   false false false false true true false false   POINT (-73.9594986107981 40.7840083040604)   19 4 19 13
2253 2253 -73.973394428186 40.7722933513053 8E-PM-1008-03 08E PM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE in between 2 trees false false false true true   false false false false false true false false also being lured by mom & baby w/ food POINT (-73.973394428186 40.7722933513053)   19 4 19 13
2254 2254 -73.9709991016317 40.7725756707748 10F-PM-1019-03 10F PM 10192018 3 Juvenile Gray Cinnamon Gray+Cinnamon Cinnamon head Ground Plane FALSE Behind fence, grass false false false true false eating (nuts) false false false false false true false false approaches (bad tourists w/ nuts) POINT (-73.9709991016317 40.772575670774806)   19 4 19 13
2399 2399 -73.9583762071264 40.7852226065643 27I-PM-1020-03 27I PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false false begging for food; on hind legs POINT (-73.9583762071264 40.7852226065643)   19 4 19 13
2428 2428 -73.9755643404768 40.7697569149388 5E-PM-1012-03 05E PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9755643404768 40.7697569149388)   19 4 19 13
2453 2453 -73.9756105226696 40.7696531972655 5D-AM-1020-03 05D AM 10202018 3 Adult Cinnamon Black Cinnamon+Black   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9756105226696 40.7696531972655)   19 4 19 13
2586 2586 -73.9752965316933 40.7752538575789 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree false false true false false   false false false false true true false false   POINT (-73.9752965316933 40.7752538575789)   19 4 19 13
2782 2782 -73.9563473341712 40.7893712398425 32H-PM-1006-03 32H PM 10062018 3 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false true true false true   POINT (-73.9563473341712 40.78937123984251)   19 4 19 13
2856 2856 -73.9751615527833 40.767013871509 3F-AM-1006-03 03F AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE on the path false false false false true   false false false false false true false false   POINT (-73.9751615527833 40.767013871509)   19 4 19 13
2928 2928 -73.9767953468937 40.7676376977667 3E-AM-1006-03 03E AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true checkin' his stashes false false false true false true false true   POINT (-73.9767953468937 40.7676376977667)   19 4 19 13
2957 2957 -73.9747313152152 40.7653888351839 1G-PM-1010-03 01G PM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9747313152152 40.7653888351839)   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 178.476ms