places
1 row where address = "Highway 1, Pescadero "
This data as json, CSV (advanced)
Suggested facets: airtable_createdTime (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pescadero-state-beach | 2017-11-26T02:38:06.000Z | recPeqGeNXsAgzaOk | Pescadero | Traveling south from Half Moon Bay, you arrive at Pescadero Rd going towards Pescadero. There is a parking area there off Highway 1. where you can spot sea stars and sea anemones a-plenty. | us | 37.2646157 | -122.4138891 | Pescadero State beach | us_pacific_coast | America/Los_Angeles | http://www.parks.ca.gov/?page_id=522 | Highway 1, Pescadero | Yes | Natalie Downe | [{"filename": "2020-09-01 10.21.09.jpg", "height": 2446, "id": "attk5XKj6t0Xj9j02", "size": 6451666, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/_bfjWdCPmykrbfJj13yyWA/vbcbMLYqgrgXw_rNTWbyaOYfLFnxXW1jjPEd7x3jq-aM-ZdJkjEiuJT6jiBOI0zk9dfB5nyIZsH9MMf9TZnjEg/Tryeh00UIzzioGhoaHLVkGSgO2VvB4QQX9mwutMiL88", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/O7JoadLaUy7hYohayJo3Lg/h_rC4he8n-NNXZ-9msM7cNIE_dfzkfO4ZAz1OyON7FuuOOQEibPe_nEgZZRcSjJJoS8RU2KXH_utooiER_pgHw/anGo7WcUm-wF_tf8DBnI5IJfDqFV4B557c3cYVvy8Zg", "width": 795}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/0tdiQIWRvaNqjHnp0c2rJg/mSUHxUdPA5l_BZ7gMM5ncU-sv5Y8TbLuANMCKCFUMkR8wqMe0rW-46FgB18exlD2EQG6wMm3DDqxRYTV7m-dww/4riAjJQ7WIRke6r13UvE_bO_nNiz13_1qLkTh6q5nfI", "width": 56}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/E_9dAeZLZ_jy1Au5BvloIw/HFBCexMtvZHHCapQL1BmfKvpOD6D9IWpjE-EHxGc9zH1Pe434Yn5ZuItHHDs04F2D-hXHcWLkIoXfS3uNjNyHV_YID6MyJLnh8S56OcFvmo/_yEXMRBcWIrbo6LPqDwMkZBcTsiy-V-1aB6-KxUgldA", "width": 3798}] | Between Half Moon Bay and Santa Cruz is Pescadero State Beach that includes three separate parking lots. The middle lot gives you access to the rocky shore and tide pools. | free guided tours of the marshland on the first Sunday of the month at 10 a.m. | 1 | http://blog.natbat.net/ |
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 );