cdph-reopening-tiers

Table actions

In August 2020, the state introduced a new framework for deciding when and how counties can reopen. Under the regime, each county is assigned to one of four tiers based on a set of metrics developed by state officials.

This file records the current tier of each county by day. The definition for each group can be found on the state's website.

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

date
The date when the data were collected in ISO 8601 format.
county
The name of the county.
fips
The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
tier
The tier the county was classified in on this date. There are four possible values on an ordinal scale with one being the most restrictive and four the least restrictive.

2,494 rows

✎ View and edit SQL

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

Suggested facets: tier, date (date)

Link rowid ▼ date county fips tier
1 1 2021-06-15 Alameda 1 4
2 2 2021-06-15 Alpine 3 4
3 3 2021-06-15 Amador 5 4
4 4 2021-06-15 Butte 7 3
5 5 2021-06-15 Calaveras 9 3
6 6 2021-06-15 Colusa 11 3
7 7 2021-06-15 Contra Costa 13 3
8 8 2021-06-15 Del Norte 15 3
9 9 2021-06-15 El Dorado 17 3
10 10 2021-06-15 Fresno 19 3
11 11 2021-06-15 Glenn 21 4
12 12 2021-06-15 Humboldt 23 3
13 13 2021-06-15 Imperial 25 3
14 14 2021-06-15 Inyo 27 4
15 15 2021-06-15 Kern 29 3
16 16 2021-06-15 Kings 31 3
17 17 2021-06-15 Lake 33 3
18 18 2021-06-15 Lassen 35 4
19 19 2021-06-15 Los Angeles 37 4
20 20 2021-06-15 Madera 39 3
21 21 2021-06-15 Marin 41 4
22 22 2021-06-15 Mariposa 43 4
23 23 2021-06-15 Mendocino 45 4
24 24 2021-06-15 Merced 47 3
25 25 2021-06-15 Modoc 49 3
26 26 2021-06-15 Mono 51 4
27 27 2021-06-15 Monterey 53 4
28 28 2021-06-15 Napa 55 4
29 29 2021-06-15 Nevada 57 3
30 30 2021-06-15 Orange 59 4
31 31 2021-06-15 Placer 61 3
32 32 2021-06-15 Plumas 63 3
33 33 2021-06-15 Riverside 65 4
34 34 2021-06-15 Sacramento 67 3
35 35 2021-06-15 San Benito 69 4
36 36 2021-06-15 San Bernardino 71 4
37 37 2021-06-15 San Diego 73 4
38 38 2021-06-15 San Francisco 75 4
39 39 2021-06-15 San Joaquin 77 3
40 40 2021-06-15 San Luis Obispo 79 4
41 41 2021-06-15 San Mateo 81 4
42 42 2021-06-15 Santa Barbara 83 4
43 43 2021-06-15 Santa Clara 85 4
44 44 2021-06-15 Santa Cruz 87 4
45 45 2021-06-15 Shasta 89 3
46 46 2021-06-15 Sierra 91 4
47 47 2021-06-15 Siskiyou 93 3
48 48 2021-06-15 Solano 95 3
49 49 2021-06-15 Sonoma 97 3
50 50 2021-06-15 Stanislaus 99 3
51 51 2021-06-15 Sutter 101 3
52 52 2021-06-15 Tehama 103 3
53 53 2021-06-15 Trinity 105 4
54 54 2021-06-15 Tulare 107 4
55 55 2021-06-15 Tuolumne 109 3
56 56 2021-06-15 Ventura 111 4
57 57 2021-06-15 Yolo 113 4
58 58 2021-06-15 Yuba 115 2
59 59 2021-06-14 Alameda 1 4
60 60 2021-06-14 Alpine 3 4
61 61 2021-06-14 Amador 5 4
62 62 2021-06-14 Butte 7 3
63 63 2021-06-14 Calaveras 9 3
64 64 2021-06-14 Colusa 11 3
65 65 2021-06-14 Contra Costa 13 3
66 66 2021-06-14 Del Norte 15 2
67 67 2021-06-14 El Dorado 17 3
68 68 2021-06-14 Fresno 19 3
69 69 2021-06-14 Glenn 21 3
70 70 2021-06-14 Humboldt 23 3
71 71 2021-06-14 Imperial 25 3
72 72 2021-06-14 Inyo 27 4
73 73 2021-06-14 Kern 29 3
74 74 2021-06-14 Kings 31 3
75 75 2021-06-14 Lake 33 3
76 76 2021-06-14 Lassen 35 4
77 77 2021-06-14 Los Angeles 37 4
78 78 2021-06-14 Madera 39 3
79 79 2021-06-14 Marin 41 4
80 80 2021-06-14 Mariposa 43 4
81 81 2021-06-14 Mendocino 45 4
82 82 2021-06-14 Merced 47 3
83 83 2021-06-14 Modoc 49 3
84 84 2021-06-14 Mono 51 4
85 85 2021-06-14 Monterey 53 4
86 86 2021-06-14 Napa 55 4
87 87 2021-06-14 Nevada 57 3
88 88 2021-06-14 Orange 59 4
89 89 2021-06-14 Placer 61 3
90 90 2021-06-14 Plumas 63 3
91 91 2021-06-14 Riverside 65 3
92 92 2021-06-14 Sacramento 67 3
93 93 2021-06-14 San Benito 69 4
94 94 2021-06-14 San Bernardino 71 3
95 95 2021-06-14 San Diego 73 4
96 96 2021-06-14 San Francisco 75 4
97 97 2021-06-14 San Joaquin 77 3
98 98 2021-06-14 San Luis Obispo 79 4
99 99 2021-06-14 San Mateo 81 4
100 100 2021-06-14 Santa Barbara 83 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-reopening-tiers" (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [tier] INTEGER
);