places
3 rows where "airtable_createdTime" is on date 2020-08-30
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
agate-beach | 2020-08-30T04:35:54.000Z | recoMUCXklspb27oG | Bolinas | <p>Keep a lookout for spiny red starfish that are often seen around these intertidal zones, also the occasional two-spotted octopus which you may be lucky enough to see lurking in a coral burrow.</p> | us | 37.8955166 | -122.7091799 | Agate beach | us_pacific_coast | America/Los_Angeles | |||||||||||||||||||||||||||||||||||||||
muir-beach | 2020-08-30T23:50:42.000Z | rec7J0oRPUedxUMT9 | Marin | One of the more accessible areas to explore tide pools, Muir Beach is just a 30-minute drive from the city. Take the Muir Beach trail for a quarter-mile before taking a sharp right on the Coastal Trail, where you'll find the sandy, pitted beach. Whale watchers, too, will be pleased with this location; both gray and humpback whales migrate through the cold waters during the summer months. // 100 Pacific Way (Muir Beach), parkconservancy.org | us | 37.85741 | -122.574565 | Muir Beach | us_pacific_coast | America/Los_Angeles | |||||||||||||||||||||||||||||||||||||||
sugarloaf-point | 2020-08-30T04:31:25.000Z | recsVm9vHXPQjzjQ5 | LA | us | Sugarloaf point | us_pacific_coast | America/Los_Angeles |
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 );