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 equity_index
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 ▼ |
---|---|---|---|---|---|---|---|---|
13816 | 13816 | 2020-10-12 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
13874 | 13874 | 2020-10-11 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
13932 | 13932 | 2020-10-10 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
13990 | 13990 | 2020-10-09 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
14048 | 14048 | 2020-10-08 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
14106 | 14106 | 2020-10-07 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
14164 | 14164 | 2020-10-06 | Humboldt | 23 | 2.0241060376 | 2.0241060376 | 0.0152505447 | 0.0 |
12192 | 12192 | 2020-11-09 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
12250 | 12250 | 2020-11-08 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
12308 | 12308 | 2020-11-07 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
12366 | 12366 | 2020-11-06 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
12424 | 12424 | 2020-11-05 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
12482 | 12482 | 2020-11-04 | Humboldt | 23 | 1.0653189672 | 1.1 | 0.007 | 0.2 |
19 | 19 | 2021-06-15 | Los Angeles | 37 | 1.4776562155000001 | 0.7000000000000001 | 0.004 | 0.4 |
40 | 40 | 2021-06-15 | San Luis Obispo | 79 | 1.6393157085999999 | 1.4 | 0.008 | 0.4 |
77 | 77 | 2021-06-14 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
135 | 135 | 2021-06-13 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
193 | 193 | 2021-06-12 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
251 | 251 | 2021-06-11 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
309 | 309 | 2021-06-10 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
367 | 367 | 2021-06-09 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
425 | 425 | 2021-06-08 | Los Angeles | 37 | 1.3147101484000001 | 0.7000000000000001 | 0.004 | 0.4 |
483 | 483 | 2021-06-07 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
541 | 541 | 2021-06-06 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
599 | 599 | 2021-06-05 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
657 | 657 | 2021-06-04 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
715 | 715 | 2021-06-03 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
773 | 773 | 2021-06-02 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
831 | 831 | 2021-06-01 | Los Angeles | 37 | 1.4581583955 | 0.7000000000000001 | 0.004 | 0.4 |
21 | 21 | 2021-06-15 | Marin | 41 | 0.8216476775 | 0.7000000000000001 | 0.005 | 0.5 |
44 | 44 | 2021-06-15 | Santa Cruz | 87 | 0.8342053386 | 0.7000000000000001 | 0.004 | 0.5 |
889 | 889 | 2021-05-31 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
947 | 947 | 2021-05-30 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
1005 | 1005 | 2021-05-29 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
1063 | 1063 | 2021-05-28 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
1121 | 1121 | 2021-05-27 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
1179 | 1179 | 2021-05-26 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
1237 | 1237 | 2021-05-25 | Los Angeles | 37 | 1.7937994398 | 0.9 | 0.005 | 0.5 |
504 | 504 | 2021-06-07 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
562 | 562 | 2021-06-06 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
620 | 620 | 2021-06-05 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
678 | 678 | 2021-06-04 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
736 | 736 | 2021-06-03 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
794 | 794 | 2021-06-02 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
852 | 852 | 2021-06-01 | San Luis Obispo | 79 | 2.458973563 | 1.5 | 0.007 | 0.6000000000000001 |
1295 | 1295 | 2021-05-24 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1353 | 1353 | 2021-05-23 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1411 | 1411 | 2021-05-22 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1469 | 1469 | 2021-05-21 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1527 | 1527 | 2021-05-20 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1585 | 1585 | 2021-05-19 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
1643 | 1643 | 2021-05-18 | Los Angeles | 37 | 2.1740069297 | 1.2 | 0.006 | 0.6000000000000001 |
2515 | 2515 | 2021-05-03 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2573 | 2573 | 2021-05-02 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2631 | 2631 | 2021-05-01 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2689 | 2689 | 2021-04-30 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2747 | 2747 | 2021-04-29 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2805 | 2805 | 2021-04-28 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
2863 | 2863 | 2021-04-27 | Marin | 41 | 2.4101665206 | 1.5 | 0.005 | 0.6000000000000001 |
96 | 96 | 2021-06-14 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
99 | 99 | 2021-06-14 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
101 | 101 | 2021-06-14 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
154 | 154 | 2021-06-13 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
157 | 157 | 2021-06-13 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
159 | 159 | 2021-06-13 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
212 | 212 | 2021-06-12 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
215 | 215 | 2021-06-12 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
217 | 217 | 2021-06-12 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
270 | 270 | 2021-06-11 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
273 | 273 | 2021-06-11 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
275 | 275 | 2021-06-11 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
328 | 328 | 2021-06-10 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
331 | 331 | 2021-06-10 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
333 | 333 | 2021-06-10 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
386 | 386 | 2021-06-09 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
389 | 389 | 2021-06-09 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
391 | 391 | 2021-06-09 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
444 | 444 | 2021-06-08 | San Francisco | 75 | 1.248807229 | 0.8 | 0.005 | 0.7000000000000001 |
447 | 447 | 2021-06-08 | San Mateo | 81 | 1.3404316227 | 0.7000000000000001 | 0.004 | 0.7000000000000001 |
449 | 449 | 2021-06-08 | Santa Clara | 85 | 1.1762062194 | 0.6000000000000001 | 0.004 | 0.7000000000000001 |
492 | 492 | 2021-06-07 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
494 | 494 | 2021-06-07 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
505 | 505 | 2021-06-07 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
550 | 550 | 2021-06-06 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
552 | 552 | 2021-06-06 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
563 | 563 | 2021-06-06 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
608 | 608 | 2021-06-05 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
610 | 610 | 2021-06-05 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
621 | 621 | 2021-06-05 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
666 | 666 | 2021-06-04 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
668 | 668 | 2021-06-04 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
679 | 679 | 2021-06-04 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
724 | 724 | 2021-06-03 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
726 | 726 | 2021-06-03 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
737 | 737 | 2021-06-03 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
782 | 782 | 2021-06-02 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
784 | 784 | 2021-06-02 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
795 | 795 | 2021-06-02 | San Mateo | 81 | 1.597500701 | 0.8 | 0.004 | 0.7000000000000001 |
840 | 840 | 2021-06-01 | Napa | 55 | 1.1252460197 | 0.9 | 0.008 | 0.7000000000000001 |
842 | 842 | 2021-06-01 | Orange | 59 | 0.9115192269 | 0.9 | 0.006 | 0.7000000000000001 |
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 );