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 rowid 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 |
---|---|---|---|---|---|---|---|---|
15718 | 15718 | 2020-08-31 | Yuba | 115 | 15.8549988289 | 0.11194029850000001 | ||
15717 | 15717 | 2020-08-31 | Yolo | 113 | 7.2830234002 | 0.059453032100000004 | ||
15716 | 15716 | 2020-08-31 | Ventura | 111 | 9.0631470161 | 0.061522419200000004 | ||
15715 | 15715 | 2020-08-31 | Tuolumne | 109 | 1.6372998742 | 0.0135338346 | ||
15714 | 15714 | 2020-08-31 | Tulare | 107 | 18.460843401 | 0.130333698 | ||
15713 | 15713 | 2020-08-31 | Trinity | 105 | 2.1395408545 | 0.0165975104 | ||
15712 | 15712 | 2020-08-31 | Tehama | 103 | 10.1909170741 | 0.0593220339 | ||
15711 | 15711 | 2020-08-31 | Sutter | 101 | 14.9953595441 | 0.0894085282 | ||
15710 | 15710 | 2020-08-31 | Stanislaus | 99 | 14.506667859 | 0.1251766036 | ||
15709 | 15709 | 2020-08-31 | Sonoma | 97 | 15.9059975678 | 0.0652956896 | ||
15708 | 15708 | 2020-08-31 | Solano | 95 | 9.0681510137 | 0.0431280852 | ||
15707 | 15707 | 2020-08-31 | Siskiyou | 93 | 0.6500006500000001 | 0.006024096400000001 | ||
15706 | 15706 | 2020-08-31 | Sierra | 91 | 4.5861041046 | 0.0 | ||
15705 | 15705 | 2020-08-31 | Shasta | 89 | 2.4087195648 | 0.0155642023 | ||
15704 | 15704 | 2020-08-31 | Santa Cruz | 87 | 6.2565400395 | 0.0274693162 | ||
15703 | 15703 | 2020-08-31 | Santa Clara | 85 | 8.5819490826 | 0.035466839 | ||
15702 | 15702 | 2020-08-31 | Santa Barbara | 83 | 8.9838794144 | 0.0648379052 | ||
15701 | 15701 | 2020-08-31 | San Mateo | 81 | 8.6301762007 | 0.0477365675 | ||
15700 | 15700 | 2020-08-31 | San Luis Obispo | 79 | 7.325692073 | 0.042266187100000005 | ||
15699 | 15699 | 2020-08-31 | San Joaquin | 77 | 16.5759522729 | 0.11338646220000001 | ||
15698 | 15698 | 2020-08-31 | San Francisco | 75 | 9.830354341 | 0.0335995022 | ||
15697 | 15697 | 2020-08-31 | San Diego | 73 | 5.8195409929 | 0.0367064963 | ||
15696 | 15696 | 2020-08-31 | San Bernardino | 71 | 12.1764338202 | 0.10189690430000001 | ||
15695 | 15695 | 2020-08-31 | San Benito | 69 | 21.4212078884 | 0.1128158845 | ||
15694 | 15694 | 2020-08-31 | Sacramento | 67 | 12.0355417474 | 0.08094625870000001 | ||
15693 | 15693 | 2020-08-31 | Riverside | 65 | 10.3779501262 | 0.0856521241 | ||
15692 | 15692 | 2020-08-31 | Plumas | 63 | 0.0 | 0.02 | ||
15691 | 15691 | 2020-08-31 | Placer | 61 | 5.3156610792 | 0.038704249100000004 | ||
15690 | 15690 | 2020-08-31 | Orange | 59 | 5.6328348341000005 | 0.0499685884 | ||
15689 | 15689 | 2020-08-31 | Nevada | 57 | 4.052274339 | 0.0220883534 | ||
15688 | 15688 | 2020-08-31 | Napa | 55 | 6.5468859328 | 0.0424892704 | ||
15687 | 15687 | 2020-08-31 | Monterey | 53 | 15.5040042991 | 0.1087289433 | ||
15686 | 15686 | 2020-08-31 | Mono | 51 | 1.0232586696 | 0.0056179775 | ||
15685 | 15685 | 2020-08-31 | Modoc | 49 | 0.0 | 0.0 | ||
15684 | 15684 | 2020-08-31 | Merced | 47 | 27.7344254799 | 0.1138548951 | ||
15683 | 15683 | 2020-08-31 | Mendocino | 45 | 10.4995695176 | 0.0419222904 | ||
15682 | 15682 | 2020-08-31 | Mariposa | 43 | 3.2111748886 | 0.010380622800000001 | ||
15681 | 15681 | 2020-08-31 | Marin | 41 | 5.9158632778 | 0.0301044803 | ||
15680 | 15680 | 2020-08-31 | Madera | 39 | 19.631936878 | 0.158564289 | ||
15679 | 15679 | 2020-08-31 | Los Angeles | 37 | 13.0677175026 | 0.0501956961 | ||
15678 | 15678 | 2020-08-31 | Lassen | 35 | 0.0 | 0.0080256822 | ||
15677 | 15677 | 2020-08-31 | Lake | 33 | 3.3032589953000002 | 0.0356652949 | ||
15676 | 15676 | 2020-08-31 | Kings | 31 | 15.4322678676 | 0.1113163972 | ||
15675 | 15675 | 2020-08-31 | Kern | 29 | 15.005953851 | 0.1438025799 | ||
15674 | 15674 | 2020-08-31 | Inyo | 27 | 27.095865171 | 0.1320132013 | ||
15673 | 15673 | 2020-08-31 | Imperial | 25 | 14.7591243814 | 0.153414406 | ||
15672 | 15672 | 2020-08-31 | Humboldt | 23 | 3.6220844883 | 0.0140306122 | ||
15671 | 15671 | 2020-08-31 | Glenn | 21 | 6.3280048288 | 0.062305296 | ||
15670 | 15670 | 2020-08-31 | Fresno | 19 | 16.510764728 | 0.1102986359 | ||
15669 | 15669 | 2020-08-31 | El Dorado | 17 | 3.5511206005 | 0.0360970107 | ||
15668 | 15668 | 2020-08-31 | Del Norte | 15 | 2.0735487751 | 0.0156739812 | ||
15667 | 15667 | 2020-08-31 | Contra Costa | 13 | 10.7626282634 | 0.0623303404 | ||
15666 | 15666 | 2020-08-31 | Colusa | 11 | 10.1169135826 | 0.0822510823 | ||
15665 | 15665 | 2020-08-31 | Calaveras | 9 | 4.838350703 | 0.0315789474 | ||
15664 | 15664 | 2020-08-31 | Butte | 7 | 11.7424558001 | 0.0401442308 | ||
15663 | 15663 | 2020-08-31 | Amador | 5 | 2.595312865 | 0.0251046025 | ||
15662 | 15662 | 2020-08-31 | Alpine | 3 | 0.0 | 0.0 | ||
15661 | 15661 | 2020-08-31 | Alameda | 1 | 10.5582465244 | 0.0564508316 | ||
15660 | 15660 | 2020-09-01 | Yuba | 115 | 15.8549988289 | 0.11194029850000001 | ||
15659 | 15659 | 2020-09-01 | Yolo | 113 | 7.2830234002 | 0.059453032100000004 | ||
15658 | 15658 | 2020-09-01 | Ventura | 111 | 9.0631470161 | 0.061522419200000004 | ||
15657 | 15657 | 2020-09-01 | Tuolumne | 109 | 1.6372998742 | 0.0135338346 | ||
15656 | 15656 | 2020-09-01 | Tulare | 107 | 18.460843401 | 0.130333698 | ||
15655 | 15655 | 2020-09-01 | Trinity | 105 | 2.1395408545 | 0.0165975104 | ||
15654 | 15654 | 2020-09-01 | Tehama | 103 | 10.1909170741 | 0.0593220339 | ||
15653 | 15653 | 2020-09-01 | Sutter | 101 | 14.9953595441 | 0.0894085282 | ||
15652 | 15652 | 2020-09-01 | Stanislaus | 99 | 14.506667859 | 0.1251766036 | ||
15651 | 15651 | 2020-09-01 | Sonoma | 97 | 15.9059975678 | 0.0652956896 | ||
15650 | 15650 | 2020-09-01 | Solano | 95 | 9.0681510137 | 0.0431280852 | ||
15649 | 15649 | 2020-09-01 | Siskiyou | 93 | 0.6500006500000001 | 0.006024096400000001 | ||
15648 | 15648 | 2020-09-01 | Sierra | 91 | 4.5861041046 | 0.0 | ||
15647 | 15647 | 2020-09-01 | Shasta | 89 | 2.4087195648 | 0.0155642023 | ||
15646 | 15646 | 2020-09-01 | Santa Cruz | 87 | 6.2565400395 | 0.0274693162 | ||
15645 | 15645 | 2020-09-01 | Santa Clara | 85 | 8.5819490826 | 0.035466839 | ||
15644 | 15644 | 2020-09-01 | Santa Barbara | 83 | 8.9838794144 | 0.0648379052 | ||
15643 | 15643 | 2020-09-01 | San Mateo | 81 | 8.6301762007 | 0.0477365675 | ||
15642 | 15642 | 2020-09-01 | San Luis Obispo | 79 | 7.325692073 | 0.042266187100000005 | ||
15641 | 15641 | 2020-09-01 | San Joaquin | 77 | 16.5759522729 | 0.11338646220000001 | ||
15640 | 15640 | 2020-09-01 | San Francisco | 75 | 9.830354341 | 0.0335995022 | ||
15639 | 15639 | 2020-09-01 | San Diego | 73 | 5.8195409929 | 0.0367064963 | ||
15638 | 15638 | 2020-09-01 | San Bernardino | 71 | 12.1764338202 | 0.10189690430000001 | ||
15637 | 15637 | 2020-09-01 | San Benito | 69 | 21.4212078884 | 0.1128158845 | ||
15636 | 15636 | 2020-09-01 | Sacramento | 67 | 12.0355417474 | 0.08094625870000001 | ||
15635 | 15635 | 2020-09-01 | Riverside | 65 | 10.3779501262 | 0.0856521241 | ||
15634 | 15634 | 2020-09-01 | Plumas | 63 | 0.0 | 0.02 | ||
15633 | 15633 | 2020-09-01 | Placer | 61 | 5.3156610792 | 0.038704249100000004 | ||
15632 | 15632 | 2020-09-01 | Orange | 59 | 5.6328348341000005 | 0.0499685884 | ||
15631 | 15631 | 2020-09-01 | Nevada | 57 | 4.052274339 | 0.0220883534 | ||
15630 | 15630 | 2020-09-01 | Napa | 55 | 6.5468859328 | 0.0424892704 | ||
15629 | 15629 | 2020-09-01 | Monterey | 53 | 15.5040042991 | 0.1087289433 | ||
15628 | 15628 | 2020-09-01 | Mono | 51 | 1.0232586696 | 0.0056179775 | ||
15627 | 15627 | 2020-09-01 | Modoc | 49 | 0.0 | 0.0 | ||
15626 | 15626 | 2020-09-01 | Merced | 47 | 27.7344254799 | 0.1138548951 | ||
15625 | 15625 | 2020-09-01 | Mendocino | 45 | 10.4995695176 | 0.0419222904 | ||
15624 | 15624 | 2020-09-01 | Mariposa | 43 | 3.2111748886 | 0.010380622800000001 | ||
15623 | 15623 | 2020-09-01 | Marin | 41 | 5.9158632778 | 0.0301044803 | ||
15622 | 15622 | 2020-09-01 | Madera | 39 | 19.631936878 | 0.158564289 | ||
15621 | 15621 | 2020-09-01 | Los Angeles | 37 | 13.0677175026 | 0.0501956961 | ||
15620 | 15620 | 2020-09-01 | Lassen | 35 | 0.0 | 0.0080256822 | ||
15619 | 15619 | 2020-09-01 | Lake | 33 | 3.3032589953000002 | 0.0356652949 |
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 );