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 positivity_rate
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 |
---|---|---|---|---|---|---|---|---|
2 | 2 | 2021-06-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
46 | 46 | 2021-06-15 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
60 | 60 | 2021-06-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
72 | 72 | 2021-06-14 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
111 | 111 | 2021-06-14 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
118 | 118 | 2021-06-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
130 | 130 | 2021-06-13 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
169 | 169 | 2021-06-13 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
176 | 176 | 2021-06-12 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
188 | 188 | 2021-06-12 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
227 | 227 | 2021-06-12 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
234 | 234 | 2021-06-11 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
246 | 246 | 2021-06-11 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
285 | 285 | 2021-06-11 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
292 | 292 | 2021-06-10 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
304 | 304 | 2021-06-10 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
343 | 343 | 2021-06-10 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
350 | 350 | 2021-06-09 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
362 | 362 | 2021-06-09 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
401 | 401 | 2021-06-09 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
408 | 408 | 2021-06-08 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
420 | 420 | 2021-06-08 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
459 | 459 | 2021-06-08 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
466 | 466 | 2021-06-07 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
478 | 478 | 2021-06-07 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
510 | 510 | 2021-06-07 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
524 | 524 | 2021-06-06 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
536 | 536 | 2021-06-06 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
568 | 568 | 2021-06-06 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
582 | 582 | 2021-06-05 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
594 | 594 | 2021-06-05 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
626 | 626 | 2021-06-05 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
640 | 640 | 2021-06-04 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
652 | 652 | 2021-06-04 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
684 | 684 | 2021-06-04 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
698 | 698 | 2021-06-03 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
710 | 710 | 2021-06-03 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
742 | 742 | 2021-06-03 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
756 | 756 | 2021-06-02 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
768 | 768 | 2021-06-02 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
800 | 800 | 2021-06-02 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
814 | 814 | 2021-06-01 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
826 | 826 | 2021-06-01 | Inyo | 27 | 0.0 | 0.0 | 0.0 | |
858 | 858 | 2021-06-01 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
872 | 872 | 2021-05-31 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
896 | 896 | 2021-05-31 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
916 | 916 | 2021-05-31 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
930 | 930 | 2021-05-30 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
954 | 954 | 2021-05-30 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
974 | 974 | 2021-05-30 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
988 | 988 | 2021-05-29 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1012 | 1012 | 2021-05-29 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
1032 | 1032 | 2021-05-29 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1046 | 1046 | 2021-05-28 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1070 | 1070 | 2021-05-28 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
1090 | 1090 | 2021-05-28 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1104 | 1104 | 2021-05-27 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1128 | 1128 | 2021-05-27 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
1148 | 1148 | 2021-05-27 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1162 | 1162 | 2021-05-26 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1186 | 1186 | 2021-05-26 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
1206 | 1206 | 2021-05-26 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1220 | 1220 | 2021-05-25 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1244 | 1244 | 2021-05-25 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
1264 | 1264 | 2021-05-25 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1278 | 1278 | 2021-05-24 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1322 | 1322 | 2021-05-24 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1329 | 1329 | 2021-05-24 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1336 | 1336 | 2021-05-23 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1380 | 1380 | 2021-05-23 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1387 | 1387 | 2021-05-23 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1394 | 1394 | 2021-05-22 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1438 | 1438 | 2021-05-22 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1445 | 1445 | 2021-05-22 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1452 | 1452 | 2021-05-21 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1496 | 1496 | 2021-05-21 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1503 | 1503 | 2021-05-21 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1510 | 1510 | 2021-05-20 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1554 | 1554 | 2021-05-20 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1561 | 1561 | 2021-05-20 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1568 | 1568 | 2021-05-19 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1612 | 1612 | 2021-05-19 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1619 | 1619 | 2021-05-19 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1626 | 1626 | 2021-05-18 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1670 | 1670 | 2021-05-18 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1677 | 1677 | 2021-05-18 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1684 | 1684 | 2021-05-17 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1735 | 1735 | 2021-05-17 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1742 | 1742 | 2021-05-16 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1793 | 1793 | 2021-05-16 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1800 | 1800 | 2021-05-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1851 | 1851 | 2021-05-15 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1858 | 1858 | 2021-05-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1909 | 1909 | 2021-05-14 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1916 | 1916 | 2021-05-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1967 | 1967 | 2021-05-13 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1974 | 1974 | 2021-05-12 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2025 | 2025 | 2021-05-12 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2032 | 2032 | 2021-05-11 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2083 | 2083 | 2021-05-11 | Trinity | 105 | 0.0 | 0.0 | 0.0 |
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 );