cdph-reopening-metrics
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.
- percapita_case_rate
- The number of new cases in a recent seven-day period — excluding cases at prisons and jails — adjusted for population and multiplied by 100,000.
- adjusted_case_rate
- The percapita_case_rate adjusted to account for the volume of testing in the area. Not done for all counties.
- positivity_rate
- The percentage of tests for the virus that come back positive in a recent seven-day period.
- equity_metric
- An index measuring disparities in disadvantaged neighborhoods compared to the county overall. Many small counties are exempted. Added Oct. 6, 2020
15,718 rows sorted by percapita_case_rate descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | percapita_case_rate ▲ | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
11775 | 11775 | 2020-11-16 | Alameda | 1 | 0.0253407244 | |||
11776 | 11776 | 2020-11-16 | Alpine | 3 | 0.012048192800000001 | |||
11777 | 11777 | 2020-11-16 | Amador | 5 | 0.0292682927 | |||
11778 | 11778 | 2020-11-16 | Butte | 7 | 0.0368259535 | |||
11779 | 11779 | 2020-11-16 | Calaveras | 9 | 0.0295698925 | |||
11780 | 11780 | 2020-11-16 | Colusa | 11 | 0.057823129200000004 | |||
11781 | 11781 | 2020-11-16 | Contra Costa | 13 | 0.0366984901 | |||
11782 | 11782 | 2020-11-16 | Del Norte | 15 | 0.0205680705 | |||
11783 | 11783 | 2020-11-16 | El Dorado | 17 | 0.0333988212 | |||
11784 | 11784 | 2020-11-16 | Fresno | 19 | 0.0703722854 | |||
11785 | 11785 | 2020-11-16 | Glenn | 21 | 0.0938023451 | |||
11786 | 11786 | 2020-11-16 | Humboldt | 23 | 0.0195426195 | |||
11787 | 11787 | 2020-11-16 | Imperial | 25 | 0.16451705360000002 | |||
11788 | 11788 | 2020-11-16 | Inyo | 27 | 0.030985915500000002 | |||
11789 | 11789 | 2020-11-16 | Kern | 29 | 0.07980373760000001 | |||
11790 | 11790 | 2020-11-16 | Kings | 31 | 0.0457909343 | |||
11791 | 11791 | 2020-11-16 | Lake | 33 | 0.0285714286 | |||
11792 | 11792 | 2020-11-16 | Lassen | 35 | 0.0142585551 | |||
11793 | 11793 | 2020-11-16 | Los Angeles | 37 | 0.0527857074 | |||
11794 | 11794 | 2020-11-16 | Madera | 39 | 0.0646273158 | |||
11795 | 11795 | 2020-11-16 | Marin | 41 | 0.015495363600000001 | |||
11796 | 11796 | 2020-11-16 | Mariposa | 43 | 0.0163043478 | |||
11797 | 11797 | 2020-11-16 | Mendocino | 45 | 0.0315082645 | |||
11798 | 11798 | 2020-11-16 | Merced | 47 | 0.06447761190000001 | |||
11799 | 11799 | 2020-11-16 | Modoc | 49 | 0.06870229010000001 | |||
11800 | 11800 | 2020-11-16 | Mono | 51 | 0.0533333333 | |||
11801 | 11801 | 2020-11-16 | Monterey | 53 | 0.060777457800000004 | |||
11802 | 11802 | 2020-11-16 | Napa | 55 | 0.0474689087 | |||
11803 | 11803 | 2020-11-16 | Nevada | 57 | 0.0428931875 | |||
11804 | 11804 | 2020-11-16 | Orange | 59 | 0.046399725 | |||
11805 | 11805 | 2020-11-16 | Placer | 61 | 0.0600711046 | |||
11806 | 11806 | 2020-11-16 | Plumas | 63 | 0.0597539543 | |||
11807 | 11807 | 2020-11-16 | Riverside | 65 | 0.08871315290000001 | |||
11808 | 11808 | 2020-11-16 | Sacramento | 67 | 0.0713113574 | |||
11809 | 11809 | 2020-11-16 | San Benito | 69 | 0.0629742033 | |||
11810 | 11810 | 2020-11-16 | San Bernardino | 71 | 0.10525049510000001 | |||
11811 | 11811 | 2020-11-16 | San Diego | 73 | 0.0426202549 | |||
11812 | 11812 | 2020-11-16 | San Francisco | 75 | 0.0179176425 | |||
11813 | 11813 | 2020-11-16 | San Joaquin | 77 | 0.07402818650000001 | |||
11814 | 11814 | 2020-11-16 | San Luis Obispo | 79 | 0.050956738800000005 | |||
11815 | 11815 | 2020-11-16 | San Mateo | 81 | 0.0212184185 | |||
11816 | 11816 | 2020-11-16 | Santa Barbara | 83 | 0.0267964846 | |||
11817 | 11817 | 2020-11-16 | Santa Clara | 85 | 0.0253610326 | |||
11818 | 11818 | 2020-11-16 | Santa Cruz | 87 | 0.038527966000000004 | |||
11819 | 11819 | 2020-11-16 | Shasta | 89 | 0.0843908629 | |||
11820 | 11820 | 2020-11-16 | Sierra | 91 | 0.0357142857 | |||
11821 | 11821 | 2020-11-16 | Siskiyou | 93 | 0.0717884131 | |||
11822 | 11822 | 2020-11-16 | Solano | 95 | 0.055207630800000004 | |||
11823 | 11823 | 2020-11-16 | Sonoma | 97 | 0.043064241 | |||
11824 | 11824 | 2020-11-16 | Stanislaus | 99 | 0.075610283 | |||
11825 | 11825 | 2020-11-16 | Sutter | 101 | 0.10867293630000001 | |||
11826 | 11826 | 2020-11-16 | Tehama | 103 | 0.10992907800000001 | |||
11827 | 11827 | 2020-11-16 | Trinity | 105 | 0.1025641026 | |||
11828 | 11828 | 2020-11-16 | Tulare | 107 | 0.0710875332 | |||
11829 | 11829 | 2020-11-16 | Tuolumne | 109 | 0.081296191 | |||
11830 | 11830 | 2020-11-16 | Ventura | 111 | 0.0449391707 | |||
11831 | 11831 | 2020-11-16 | Yolo | 113 | 0.0671519136 | |||
11832 | 11832 | 2020-11-16 | Yuba | 115 | 0.08236208240000001 | |||
9084 | 9084 | 2021-01-04 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9142 | 9142 | 2021-01-03 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9200 | 9200 | 2021-01-02 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9258 | 9258 | 2021-01-01 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9316 | 9316 | 2020-12-31 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9374 | 9374 | 2020-12-30 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
9432 | 9432 | 2020-12-29 | San Bernardino | 71 | 165.5028615908 | 82.8 | 0.23 | 26.8 |
7866 | 7866 | 2021-01-25 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
7924 | 7924 | 2021-01-24 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
7982 | 7982 | 2021-01-23 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
8040 | 8040 | 2021-01-22 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
8098 | 8098 | 2021-01-21 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
8156 | 8156 | 2021-01-20 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
8214 | 8214 | 2021-01-19 | San Bernardino | 71 | 155.0079352982 | 77.5 | 0.20400000000000001 | 22.4 |
7886 | 7886 | 2021-01-25 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
7944 | 7944 | 2021-01-24 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
8002 | 8002 | 2021-01-23 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
8060 | 8060 | 2021-01-22 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
8118 | 8118 | 2021-01-21 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
8176 | 8176 | 2021-01-20 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
8234 | 8234 | 2021-01-19 | Ventura | 111 | 153.1018495018 | 76.6 | 0.154 | 21.0 |
7849 | 7849 | 2021-01-25 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
7907 | 7907 | 2021-01-24 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
7965 | 7965 | 2021-01-23 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
8023 | 8023 | 2021-01-22 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
8081 | 8081 | 2021-01-21 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
8139 | 8139 | 2021-01-20 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
8197 | 8197 | 2021-01-19 | Los Angeles | 37 | 150.6777602392 | 75.3 | 0.171 | 22.4 |
9490 | 9490 | 2020-12-28 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9548 | 9548 | 2020-12-27 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9606 | 9606 | 2020-12-26 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9664 | 9664 | 2020-12-25 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9722 | 9722 | 2020-12-24 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9780 | 9780 | 2020-12-23 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
9838 | 9838 | 2020-12-22 | San Bernardino | 71 | 149.4029102063 | 74.7 | 0.225 | 26.5 |
7863 | 7863 | 2021-01-25 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
7921 | 7921 | 2021-01-24 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
7979 | 7979 | 2021-01-23 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
8037 | 8037 | 2021-01-22 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
8095 | 8095 | 2021-01-21 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
8153 | 8153 | 2021-01-20 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
8211 | 8211 | 2021-01-19 | Riverside | 65 | 148.3763254243 | 95.9 | 0.23500000000000001 | 25.1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-reopening-metrics" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [percapita_case_rate] FLOAT, [adjusted_case_rate] FLOAT, [positivity_rate] FLOAT, [equity_index] FLOAT );