places
8 rows where "airtable_createdTime" is on date 2020-09-02
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cayucos-beach | 2020-09-02T01:47:55.000Z | recoKPGrSfBynJ3gx | San Simeon | us | 35.4499004 | -120.9153318 | Cayucos Beach | us_pacific_coast | America/Los_Angeles | Cayucos Beach, north of pier, free parking, bathrooms, food, crowded, but good cobble tide pools (,) | |||||||||||||||||||||||||||||||||||||||
| coralina-cove | 2020-09-02T01:48:45.000Z | recd1gCmgZekQU4pw | San Simeon | us | 35.260293 | -120.8945889 | Coralina Cove | us_pacific_coast | America/Los_Angeles | Montana de Oro Coralina Cove in Montana de Oro, free Parking, bathrooms, 1/2 mile walk to tide pools. (,)p | |||||||||||||||||||||||||||||||||||||||
| fiscalini-ranch | 2020-09-02T01:09:42.000Z | recvGJIlcGjvteV4p | San Simeon | us | 35.5484032 | -121.1008331 | Fiscalini Ranch | us_pacific_coast | America/Los_Angeles | <p>Take the Bluff trail north for about half a mile. The entrance to get to the tidepools is hard to find and quite scrabbly to get to the beach level. You can also park at the other trailhead to the north:</p> | Cambria, CA | No | Natalie Downe | [{"filename": "2020-09-01 19.21.40.jpg", "height": 2271, "id": "attOknot9g84icbyc", "size": 5029213, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/y4cuuxnAa9lefTI_sxrbzg/WmloqmBKUTQQQ-p65OHKGslBPpPYQGiMEJGvG8Ne4VpZQT3LDDbokcx3XWchYiX-bNJ9rBbvmNy6ncSoKy2btQ/d5J50REtx_N3SdEE0ejWDX-fbK_Bbo5iAG9AeX1Ten8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/Cev6hJW4Bwbh7C1zmooPrA/OFnYjEN9QbYAndBY2CWb9qYBUat_JY66xYAE1bIu1-2qTJwLQIJLLRb3rOJAsEp6sotXFGjMTjXviBDVuNzeqA/uEal7qTft3RFdW7395_yTGPHHEKnsl0OUgo4hliIQDY", "width": 883}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/t85hORjrvjh1PBVGwdjaUg/StEO8rg7b2IjBNIEog2wNxgJ0hIHaiACz6QAC7OcYesd4M3rhipU5vTEIUqAs-8f-KOsb8YTx9t3F8aWSaDMcw/Jp-sR6kkF5dZUOq932HEBTNDLvcApRD9O5WSGK1HxPU", "width": 62}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/UhkRdi5KYMvCdJUfhCuM3w/MghnzN7CL2j4cgrGopwJO4OlGWcjicgPobXqVP0lClggXhPt26Xx7AYVjJtLJY-xaNzVUC11F-DqUl1YweOvT4zZAnG1JJ3F8SWBA2bhjmw/r-8GxZsYSy4oq7KhAsipcqfjgK2MdSLaQkE3sZwn940", "width": 3918}] | <p>Park on Windsor Blvd</p> | ["Marine reserve"] | Yes | No | Free | 35.547832 | -121.097269 | No | Yes | <p>Lots of great food options in nearby Cambria</p> | This site forms part of the Monterey bay National Marine Reserve. Absolutely no collecting animals or organic objects of any sort. | <p>The bluff trail is wheelchair accessible but the tidepools are not. Careful on the way down to the beach level as it is quite precarious. Always watch your back with the tide and be careful where you step.</p> | 1 | 1 | 9412110 | Lots of great varied tidepools and all the biodiversity and richness of the central coast. | Otter cove | http://blog.natbat.net/ | |||||||||||||||||
| harmony-headlands | 2020-09-02T01:46:02.000Z | recdYhqCho3ng0d0K | San Simeon | us | 35.4787053 | -121.0205771 | Harmony headlands | us_pacific_coast | America/Los_Angeles | Natalie, Harmony Headlands, (,), free parking, no bathrooms, 1 mile walk to shore | |||||||||||||||||||||||||||||||||||||||
| lampton-cliffs | 2020-09-02T01:46:28.000Z | recRa5VtLnA3XwkJ5 | San Simeon | us | 35.5419009 | -121.0924447 | Lampton Cliffs | us_pacific_coast | America/Los_Angeles | Natalie, Lampton Cliffs, (,), free parking, no bathrooms, stair access | |||||||||||||||||||||||||||||||||||||||
| leffingwell | 2020-09-02T01:47:18.000Z | recmlNf6L3HrIOwOS | San Simeon | us | 35.58149 | -121.1196817 | Leffingwell | us_pacific_coast | America/Los_Angeles | Leffingwell (,), free parking, bathroom | |||||||||||||||||||||||||||||||||||||||
| leguna-beach | 2020-09-02T19:13:46.000Z | recEokgDcPtjzNXeK | us | Leguna Beach | us_pacific_coast | America/Los_Angeles | sykospark | [{"filename": "2020-09-02 12.14.17.jpg", "height": 660, "id": "att6SADUeRg5WBYt5", "size": 340814, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ob8yAQbdIzh-11eHAQpteg/puoC5Beq0MhalJYKwU3arUtl0tCg7wWAOe6YqqpE4PUM2msA3wbk92BLgnkjqTeW2LlkiREeJy7gKt0lGwldsg/lsprtu2BFefQucGHs_nyrIouS7UBgMtztl2F1Rr7kG4", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/EQaeqLDpqWZSSZoNrLuDXQ/BrLUjHdEuRWJYO65fUyevNolO8A6jejcm7No4sYyXj1LqLrXjmMVozB6jfMC3l4GVWPBWCJgBURGw8AXZIFyZg/-mbsL0sjL2DSfWhffKi6TYvZefv96zxTS8SiFUYsIxM", "width": 696}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/I_B6pN4aTQW6ff0En8v7-g/zPj_O_aApm-hJkJFLlhPQQVaBW97KCyjVKSt_F-g5EnAtFRHNGz6hPidtmbF4jv-2BEkJG3uO_51N9NiPs92aw/uXy873idkowPGuq7c3i58-YfrgwdwCI_VAoFlP18Nxg", "width": 49}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/SSe__O3Wh6EiDb8iwD64mA/Li2KIS9ct19VYrsUdA1ocgxsy3ExUkhmqOZCmj-vgoNg7gJr-gDUwlf8Qv-VIiYX7pJT9RIwAhkd0clDoP0wTIfRjkwew5UUrgnq52Uefo4/of218R50jaJ2ktnlVgYZcSGkJUudFYCMxCH3CTcjut4", "width": 897}] | https://www.facebook.com/media/set/?set=a.10215474186587361&type=3 | ||||||||||||||||||||||||||||||||||||||||
| san-simeon-south | 2020-09-02T01:45:58.000Z | recy7d9rAGVE0PunR | San Simeon | us | 35.6043411 | -121.1420392 | San Simeon south | us_pacific_coast | America/Los_Angeles | 1/2 mile walk from the parking to the tidepools | No | free parking | Yes | Free | 1 | 9412110 |
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 );