latimes-beach-closures-county-list

Table actions

The county-level restrictions on beach access, compiled by the Los Angeles Times based on data released by the California Coastal Commission.

Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README

county
The name of the county where the agency is based.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
status
A Times classification of the current level of restriction in this county
restriction
A description of the current level of restriction in this county

15 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: status, restriction

Link rowid ▼ county fips status restriction
1 1 Del Norte 15 Some restrictions  
2 2 Humboldt 23 Some restrictions  
3 3 Los Angeles 37 Some restrictions  
4 4 Marin 41 Some restrictions  
5 5 Mendocino 45 Some restrictions  
6 6 Monterey 53 Some restrictions  
7 7 Orange 59 Open Beaches are open.
8 8 San Diego 73 Some restrictions  
9 9 San Francisco 75 Some restrictions  
10 10 San Luis Obispo 79 Some restrictions  
11 11 San Mateo 81 Open Beaches are open.
12 12 Santa Barbara 83 Open Beaches are open.
13 13 Santa Cruz 87 Some restrictions  
14 14 Sonoma 97 Open Beaches are open.
15 15 Ventura 111 Some restrictions  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "latimes-beach-closures-county-list" (
   [county] TEXT,
   [fips] INTEGER,
   [status] TEXT,
   [restriction] TEXT
);