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 adjusted_case_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 | |
26 | 26 | 2021-06-15 | Mono | 51 | 0.0 | 0.0 | 0.01 | |
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 | |
517 | 517 | 2021-06-07 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
575 | 575 | 2021-06-06 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
633 | 633 | 2021-06-05 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
691 | 691 | 2021-06-04 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
749 | 749 | 2021-06-03 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
807 | 807 | 2021-06-02 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
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 | |
865 | 865 | 2021-06-01 | Trinity | 105 | 0.0 | 0.0 | 0.016 | |
872 | 872 | 2021-05-31 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
884 | 884 | 2021-05-31 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
923 | 923 | 2021-05-31 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
930 | 930 | 2021-05-30 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
942 | 942 | 2021-05-30 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
981 | 981 | 2021-05-30 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
988 | 988 | 2021-05-29 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1000 | 1000 | 2021-05-29 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
1039 | 1039 | 2021-05-29 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
1046 | 1046 | 2021-05-28 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1058 | 1058 | 2021-05-28 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
1097 | 1097 | 2021-05-28 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
1104 | 1104 | 2021-05-27 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1116 | 1116 | 2021-05-27 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
1155 | 1155 | 2021-05-27 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
1162 | 1162 | 2021-05-26 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1174 | 1174 | 2021-05-26 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
1213 | 1213 | 2021-05-26 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
1220 | 1220 | 2021-05-25 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1232 | 1232 | 2021-05-25 | Inyo | 27 | 0.0 | 0.0 | 0.006 | |
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 | |
1271 | 1271 | 2021-05-25 | Trinity | 105 | 0.0 | 0.0 | 0.02 | |
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 |
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 );