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
58 rows where "date" is on date 2020-09-13
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | percapita_case_rate | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
14907 | 14907 | 2020-09-13 | Alameda | 1 | 7.9568166022 | 7.7524059837 | 0.0498154307 | |
14908 | 14908 | 2020-09-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
14909 | 14909 | 2020-09-13 | Amador | 5 | 2.2245538843 | 2.2245538843 | 0.0260223048 | |
14910 | 14910 | 2020-09-13 | Butte | 7 | 30.5041449557 | 27.5611050504 | 0.1123241145 | |
14911 | 14911 | 2020-09-13 | Calaveras | 9 | 8.3864745519 | 8.3864745519 | 0.0563380282 | |
14912 | 14912 | 2020-09-13 | Colusa | 11 | 17.0722916706 | 17.0722916706 | 0.11067193680000001 | |
14913 | 14913 | 2020-09-13 | Contra Costa | 13 | 8.2628416072 | 8.3626567339 | 0.0530395757 | |
14914 | 14914 | 2020-09-13 | Del Norte | 15 | 10.3677438753 | 10.3677438753 | 0.0092879257 | |
14915 | 14915 | 2020-09-13 | El Dorado | 17 | 2.2934320545 | 2.2934320545 | 0.01836969 | |
14916 | 14916 | 2020-09-13 | Fresno | 19 | 12.4280525781 | 12.6357253367 | 0.09798461950000001 | |
14917 | 14917 | 2020-09-13 | Glenn | 21 | 10.7089312487 | 10.7089312487 | 0.079787234 | |
14918 | 14918 | 2020-09-13 | Humboldt | 23 | 2.982893108 | 2.9263076258 | 0.010737628400000001 | |
14919 | 14919 | 2020-09-13 | Imperial | 25 | 10.6593676088 | 11.8025847848 | 0.1089294063 | |
14920 | 14920 | 2020-09-13 | Inyo | 27 | 6.9675081868 | 6.9675081868 | 0.038961039 | |
14921 | 14921 | 2020-09-13 | Kern | 29 | 7.8419204416 | 9.1643819049 | 0.0991563761 | |
14922 | 14922 | 2020-09-13 | Kings | 31 | 10.6838777545 | 11.2709568371 | 0.0879494655 | |
14923 | 14923 | 2020-09-13 | Lake | 33 | 6.1660834579 | 6.1660834579 | 0.0582901554 | |
14924 | 14924 | 2020-09-13 | Lassen | 35 | 0.9503219216000001 | 0.9503219216000001 | 0.0264317181 | |
14925 | 14925 | 2020-09-13 | Los Angeles | 37 | 11.0009485829 | 9.6395811957 | 0.043384223300000004 | |
14926 | 14926 | 2020-09-13 | Madera | 39 | 11.5114538966 | 12.4117647059 | 0.1104887984 | |
14927 | 14927 | 2020-09-13 | Marin | 41 | 10.4623137599 | 9.1261716696 | 0.043643987 | |
14928 | 14928 | 2020-09-13 | Mariposa | 43 | 1.6055874443 | 1.6055874443 | 0.007462686600000001 | |
14929 | 14929 | 2020-09-13 | Mendocino | 45 | 9.0457829691 | 9.0457829691 | 0.0447761194 | |
14930 | 14930 | 2020-09-13 | Merced | 47 | 14.2151356402 | 13.2540503196 | 0.074941452 | |
14931 | 14931 | 2020-09-13 | Modoc | 49 | 9.0463626084 | 9.0463626084 | 0.0208333333 | |
14932 | 14932 | 2020-09-13 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
14933 | 14933 | 2020-09-13 | Monterey | 53 | 14.5170964279 | 15.0866021208 | 0.0993195075 | |
14934 | 14934 | 2020-09-13 | Napa | 55 | 5.0124595423 | 4.2486609572 | 0.0285617137 | |
14935 | 14935 | 2020-09-13 | Nevada | 57 | 2.4603094201 | 2.4603094201 | 0.0209677419 | |
14936 | 14936 | 2020-09-13 | Orange | 59 | 4.8673356775 | 5.223332609 | 0.0418820839 | |
14937 | 14937 | 2020-09-13 | Placer | 61 | 5.5653901231 | 6.0752355123 | 0.0446049278 | |
14938 | 14938 | 2020-09-13 | Plumas | 63 | 0.7519984358 | 0.7519984358 | 0.026315789500000002 | |
14939 | 14939 | 2020-09-13 | Riverside | 65 | 7.391323096 | 8.5871652597 | 0.0778496542 | |
14940 | 14940 | 2020-09-13 | Sacramento | 67 | 9.3478166789 | 10.2614722811 | 0.072278488 | |
14941 | 14941 | 2020-09-13 | San Benito | 69 | 24.0988588744 | 24.0988588744 | 0.1339671564 | |
14942 | 14942 | 2020-09-13 | San Bernardino | 71 | 7.8985755892 | 8.686853433 | 0.0754984632 | |
14943 | 14943 | 2020-09-13 | San Diego | 73 | 6.8579878562 | 7.9238563288 | 0.0434007891 | |
14944 | 14944 | 2020-09-13 | San Francisco | 75 | 7.8290607048 | 5.0533455225 | 0.0276609007 | |
14945 | 14945 | 2020-09-13 | San Joaquin | 77 | 11.4279142322 | 12.5972184165 | 0.09120594530000001 | |
14946 | 14946 | 2020-09-13 | San Luis Obispo | 79 | 9.5797511724 | 9.6488211783 | 0.046455938700000005 | |
14947 | 14947 | 2020-09-13 | San Mateo | 81 | 7.8406068887 | 7.658861621 | 0.0517049076 | |
14948 | 14948 | 2020-09-13 | Santa Barbara | 83 | 7.9195870796 | 8.2994896718 | 0.0551836735 | |
14949 | 14949 | 2020-09-13 | Santa Clara | 85 | 8.3713936483 | 6.910166887 | 0.034641175 | |
14950 | 14950 | 2020-09-13 | Santa Cruz | 87 | 5.2659211999 | 5.7178425573 | 0.0380865326 | |
14951 | 14951 | 2020-09-13 | Shasta | 89 | 1.2846504346 | 1.2846504346 | 0.0119211371 | |
14952 | 14952 | 2020-09-13 | Sierra | 91 | 0.0 | 0.0 | 0.0476190476 | |
14953 | 14953 | 2020-09-13 | Siskiyou | 93 | 3.25000325 | 3.25000325 | 0.0223463687 | |
14954 | 14954 | 2020-09-13 | Solano | 95 | 8.2320803528 | 8.1494302661 | 0.044060475200000004 | |
14955 | 14955 | 2020-09-13 | Sonoma | 97 | 15.0718674964 | 14.20357721 | 0.0672821696 | |
14956 | 14956 | 2020-09-13 | Stanislaus | 99 | 13.1093530915 | 14.0517844853 | 0.1026442991 | |
14957 | 14957 | 2020-09-13 | Sutter | 101 | 14.319892898 | 14.319892898 | 0.0857142857 | |
14958 | 14958 | 2020-09-13 | Tehama | 103 | 5.4207005713 | 5.4207005713 | 0.028109029 | |
14959 | 14959 | 2020-09-13 | Trinity | 105 | 2.1395408545 | 2.1395408545 | 0.012738853500000001 | |
14960 | 14960 | 2020-09-13 | Tulare | 107 | 16.8978646466 | 17.5012873932 | 0.1199464923 | |
14961 | 14961 | 2020-09-13 | Tuolumne | 109 | 1.9101831866 | 1.9101831866 | 0.011600928100000001 | |
14962 | 14962 | 2020-09-13 | Ventura | 111 | 7.7899507625 | 7.7579340649 | 0.0477241589 | |
14963 | 14963 | 2020-09-13 | Yolo | 113 | 8.4329744634 | 9.3589150595 | 0.0735650768 | |
14964 | 14964 | 2020-09-13 | Yuba | 115 | 14.413635299 | 14.413635299 | 0.0923913043 |
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 );