data: places: 2 rows where area = "LA" and bathrooms = "Yes"

2 rows where area = "LA" and bathrooms = "Yes"

descending

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
carpinteria-state-beach	2020-08-31T04:30:59.000Z	recAVPHG8YFCNXy2o	LA	The site is straight offshore, about 40 meters from the staircase and centered on the outermost and largest mussel-covered rock outcrop. The outcrop is surrounded by sand. It consists of a oceanward portion and a shoreward portion, separated by a narrow connection (“neck”) that bridges over two small tunnels Contact Carpinteria State Park well in advance of your scheduled rocky intertidal trip. The Park has a policy about the number of people who can go on the reef in a day Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov. You might also consider scheduling a tidepool walk with a ranger, guided walks last approximately one hour.	us	34.3872536	-119.516589	Carpinteria State Beach	us_pacific_coast	America/Los_Angeles		A staircase, just southeast from the parking lot, leads to the beach.	Carpinteria, CA	There are a few public restrooms inside the park.	Yes			This site is located at the east end of Carpinteria State Park in Carpinteria, Santa Barbara County. Take Highway 101 to Carpinteria (east of Santa Barbara). Get off at the Casitas Pass Rd exit and turn toward the ocean. Take a right on Carpinteria Drive, then take the first left on Palm Avenue. Go all the way to the end of Palm Avenue and enter Carpinteria State Park. After going through the kiosk, take a sharp left and proceed down the coast to the very end where there is a little cul-de-sac where you can park.		["California State Park"]						34.388201	-119.5147189	Yes				The Park waives parking fees for school groups, but you must first submit a school group reservation form that the park will send you when you call to schedule a field trip. Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov.
county-line-boulder-field	2020-08-31T04:24:49.000Z	recT5rGl8gXUPEDap	LA	The County Line Boulder Field is located a mile west of the Ventura/Los Angeles County line, just above Malibu along the Pacific Coast Highway. From the North, take Highway 101 to Oxnard. Exit Rice Ave and turn towards the ocean. Rice Ave becomes Highway 1 South, the Pacific Coast Highway (PCH). Continue on PCH until you come to the Neptune’s Net Seafood Restaurant (42505 PCH), three miles past the Sycamore Canyon State Park. Neptune’s Net will be on your left. Park in the dirt lot on your right. From the South, take the PCH Northbound. Continue along PCH past Pepperdine and Leo Carrillo State Park until you come to the Neptune’s Net Seafood Restaurant. Neptune’s Net will be on your right. Park in the dirt lot on your left.	us	34.0524691	-118.9641465	County line boulder field	us_pacific_coast	America/Los_Angeles		<p>To get to the boulder field, walk west (to the right of you are facing the sea from the carpark) along the bluff to a wooden staircase closest to the creek - not the staircase directly off the car park. The boulder field will be directly in front of you.</p>	Malibu, CA	Portable toilets are located at the west end of the dirt parking lot.	Yes			Park in the dirt lot along Highway 1, across from Neptune’s Net.								34.0527066	-118.9625872

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
);