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 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 | |||
15603 | 15603 | 2020-09-01 | Alameda | 1 | 10.5582465244 | 0.0564508316 | ||
15604 | 15604 | 2020-09-01 | Alpine | 3 | 0.0 | 0.0 | ||
15605 | 15605 | 2020-09-01 | Amador | 5 | 2.595312865 | 0.0251046025 | ||
15606 | 15606 | 2020-09-01 | Butte | 7 | 11.7424558001 | 0.0401442308 | ||
15607 | 15607 | 2020-09-01 | Calaveras | 9 | 4.838350703 | 0.0315789474 | ||
15608 | 15608 | 2020-09-01 | Colusa | 11 | 10.1169135826 | 0.0822510823 | ||
15609 | 15609 | 2020-09-01 | Contra Costa | 13 | 10.7626282634 | 0.0623303404 | ||
15610 | 15610 | 2020-09-01 | Del Norte | 15 | 2.0735487751 | 0.0156739812 | ||
15611 | 15611 | 2020-09-01 | El Dorado | 17 | 3.5511206005 | 0.0360970107 | ||
15612 | 15612 | 2020-09-01 | Fresno | 19 | 16.510764728 | 0.1102986359 | ||
15613 | 15613 | 2020-09-01 | Glenn | 21 | 6.3280048288 | 0.062305296 | ||
15614 | 15614 | 2020-09-01 | Humboldt | 23 | 3.6220844883 | 0.0140306122 | ||
15615 | 15615 | 2020-09-01 | Imperial | 25 | 14.7591243814 | 0.153414406 | ||
15616 | 15616 | 2020-09-01 | Inyo | 27 | 27.095865171 | 0.1320132013 | ||
15617 | 15617 | 2020-09-01 | Kern | 29 | 15.005953851 | 0.1438025799 | ||
15618 | 15618 | 2020-09-01 | Kings | 31 | 15.4322678676 | 0.1113163972 | ||
15619 | 15619 | 2020-09-01 | Lake | 33 | 3.3032589953000002 | 0.0356652949 | ||
15620 | 15620 | 2020-09-01 | Lassen | 35 | 0.0 | 0.0080256822 | ||
15621 | 15621 | 2020-09-01 | Los Angeles | 37 | 13.0677175026 | 0.0501956961 | ||
15622 | 15622 | 2020-09-01 | Madera | 39 | 19.631936878 | 0.158564289 | ||
15623 | 15623 | 2020-09-01 | Marin | 41 | 5.9158632778 | 0.0301044803 | ||
15624 | 15624 | 2020-09-01 | Mariposa | 43 | 3.2111748886 | 0.010380622800000001 | ||
15625 | 15625 | 2020-09-01 | Mendocino | 45 | 10.4995695176 | 0.0419222904 | ||
15626 | 15626 | 2020-09-01 | Merced | 47 | 27.7344254799 | 0.1138548951 | ||
15627 | 15627 | 2020-09-01 | Modoc | 49 | 0.0 | 0.0 | ||
15628 | 15628 | 2020-09-01 | Mono | 51 | 1.0232586696 | 0.0056179775 | ||
15629 | 15629 | 2020-09-01 | Monterey | 53 | 15.5040042991 | 0.1087289433 | ||
15630 | 15630 | 2020-09-01 | Napa | 55 | 6.5468859328 | 0.0424892704 | ||
15631 | 15631 | 2020-09-01 | Nevada | 57 | 4.052274339 | 0.0220883534 | ||
15632 | 15632 | 2020-09-01 | Orange | 59 | 5.6328348341000005 | 0.0499685884 | ||
15633 | 15633 | 2020-09-01 | Placer | 61 | 5.3156610792 | 0.038704249100000004 | ||
15634 | 15634 | 2020-09-01 | Plumas | 63 | 0.0 | 0.02 | ||
15635 | 15635 | 2020-09-01 | Riverside | 65 | 10.3779501262 | 0.0856521241 | ||
15636 | 15636 | 2020-09-01 | Sacramento | 67 | 12.0355417474 | 0.08094625870000001 | ||
15637 | 15637 | 2020-09-01 | San Benito | 69 | 21.4212078884 | 0.1128158845 | ||
15638 | 15638 | 2020-09-01 | San Bernardino | 71 | 12.1764338202 | 0.10189690430000001 | ||
15639 | 15639 | 2020-09-01 | San Diego | 73 | 5.8195409929 | 0.0367064963 | ||
15640 | 15640 | 2020-09-01 | San Francisco | 75 | 9.830354341 | 0.0335995022 | ||
15641 | 15641 | 2020-09-01 | San Joaquin | 77 | 16.5759522729 | 0.11338646220000001 | ||
15642 | 15642 | 2020-09-01 | San Luis Obispo | 79 | 7.325692073 | 0.042266187100000005 | ||
15643 | 15643 | 2020-09-01 | San Mateo | 81 | 8.6301762007 | 0.0477365675 | ||
15644 | 15644 | 2020-09-01 | Santa Barbara | 83 | 8.9838794144 | 0.0648379052 |
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 );