places

Table actions

1 row where managment contains "UC Davis"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: airtable_createdTime (date), managment (array)

slug ▼ airtable_createdTime airtable_id area body country_slug latitude longitude name region time_zone website_url directions_to_tidepools address bathroom_info bathrooms header_credit header_image parking temp_reference managment open_to_public phone visitor_center cost hours directions_latitude directions_longitude docents dogs food_options rules_and_collecting groups accessibility_and_safety live_on_site natalie_visited pet_policy radius_km rules_and_collecting_url station_id tagline tidepool_height variance_ft wikipedia other_names picnic_options header_credit_url official_open docent_info webcam_url
horseshoe-cove 2017-11-26T03:21:15.000Z rec89KiWlMvJxQLhE Bodega bay . The laboratory facilities are located adjacent to Horseshoe Cove and the outer coast. An almost continuous shoreline bench of dioritic granite, most of it exposed to the pounding waves characteristic of the Sonoma coast, supports a diverse community of marine algae and invertebrates. Numerous tidepools and adjacent waters harbor a rich array of fish species, and shorebirds forage on the rocks and in extensive mussel beds during low tides. Bodega marine lab visitor Center is open to public us 38.3155287 -123.0717508 Horseshoe Cove us_pacific_coast America/Los_Angeles http://bml.ucdavis.edu/bmr/location.html   2099 WESTSHORE RD, bodega bay             ["UC Davis"] No (707) 875-2211 checked                                                    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [places] (
   [airtable_createdTime] TEXT,
   [airtable_id] TEXT,
   [area] TEXT,
   [body] TEXT,
   [country_slug] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [name] TEXT,
   [region] TEXT,
   [slug] TEXT PRIMARY KEY,
   [time_zone] TEXT,
   [website_url] TEXT,
   [directions_to_tidepools] TEXT,
   [address] TEXT,
   [bathroom_info] TEXT,
   [bathrooms] TEXT,
   [header_credit] TEXT,
   [header_image] TEXT,
   [parking] TEXT,
   [temp_reference] TEXT,
   [managment] TEXT,
   [open_to_public] TEXT,
   [phone] TEXT,
   [visitor_center] TEXT,
   [cost] TEXT,
   [hours] TEXT,
   [directions_latitude] FLOAT,
   [directions_longitude] FLOAT,
   [docents] TEXT,
   [dogs] TEXT,
   [food_options] TEXT,
   [rules_and_collecting] TEXT,
   [groups] TEXT,
   [accessibility_and_safety] TEXT,
   [live_on_site] INTEGER,
   [natalie_visited] INTEGER,
   [pet_policy] TEXT,
   [radius_km] FLOAT,
   [rules_and_collecting_url] TEXT,
   [station_id] INTEGER,
   [tagline] TEXT,
   [tidepool_height] FLOAT,
   [variance_ft] INTEGER,
   [wikipedia] TEXT,
   [other_names] TEXT,
   [picnic_options] TEXT,
   [header_credit_url] TEXT,
   [official_open] INTEGER,
   [docent_info] TEXT,
   [webcam_url] TEXT
);