places
2 rows where "airtable_createdTime" is on date 2017-11-26 and area = "Bodega bay"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dyllon-beach | 2017-11-26T04:55:13.000Z | recxL6HtYD4mOWRId | Bodega bay | Dillon Beach on Bodega Bay is privately-owned by the Dillon Beach Resort, but for a small fee anyone can enjoy this beautiful beach. The beach is located in the small town of Dillon Beach at the northern Marin County coastal border. Dillon Beach gets bigger waves rolling on shore than nearby Lawson’s Landing which has some protection from Tomales Point on Point Reyes Peninsula. For this reason surfers come here when conditions are right. When the tide is low and the surf is too, tide pool exploration is fun. | us | 38.2672745 | -122.9779365 | Dillon Beach | us_pacific_coast | America/Los_Angeles | https://www.californiabeaches.com/beach/dillon-beach/ | The beach is located in the small town of Dillon Beach at the northern Marin County coastal border. Head west on Dillon Beach Road from the town of Tomales on Highway 1 west of Petaluma. Stay left as you head into town and the road leads right to the beach. | 1 Beach Avenue Dillon Beach, CA 94929 | Yes | ["Private"] | Yes | The resort has a quaint little cafe and a general store | Surfing, Bodyboarding, Tidepooling, Bonfires Amenities Restrooms, Picnic Tables, Fire Pits, Cabins / Cottages, Cafe, Store, Tide Pools | Dogs allowed on leash | Privately owned but publicly accessible beach at a resort which has a quaint little cafe, a general store and surf shop, and cabins to rent. | checked | ||||||||||||||||||||||||||||
| 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
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 );