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-08
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | percapita_case_rate | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
15197 | 15197 | 2020-09-08 | Alameda | 1 | 7.9568166022 | 7.7524059837 | 0.0498154307 | |
15198 | 15198 | 2020-09-08 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
15199 | 15199 | 2020-09-08 | Amador | 5 | 2.2245538843 | 2.2245538843 | 0.0260223048 | |
15200 | 15200 | 2020-09-08 | Butte | 7 | 30.5041449557 | 27.5611050504 | 0.1123241145 | |
15201 | 15201 | 2020-09-08 | Calaveras | 9 | 8.3864745519 | 8.3864745519 | 0.0563380282 | |
15202 | 15202 | 2020-09-08 | Colusa | 11 | 17.0722916706 | 17.0722916706 | 0.11067193680000001 | |
15203 | 15203 | 2020-09-08 | Contra Costa | 13 | 8.2628416072 | 8.3626567339 | 0.0530395757 | |
15204 | 15204 | 2020-09-08 | Del Norte | 15 | 10.3677438753 | 10.3677438753 | 0.0092879257 | |
15205 | 15205 | 2020-09-08 | El Dorado | 17 | 2.2934320545 | 2.2934320545 | 0.01836969 | |
15206 | 15206 | 2020-09-08 | Fresno | 19 | 12.4280525781 | 12.6357253367 | 0.09798461950000001 | |
15207 | 15207 | 2020-09-08 | Glenn | 21 | 10.7089312487 | 10.7089312487 | 0.079787234 | |
15208 | 15208 | 2020-09-08 | Humboldt | 23 | 2.982893108 | 2.9263076258 | 0.010737628400000001 | |
15209 | 15209 | 2020-09-08 | Imperial | 25 | 10.6593676088 | 11.8025847848 | 0.1089294063 | |
15210 | 15210 | 2020-09-08 | Inyo | 27 | 6.9675081868 | 6.9675081868 | 0.038961039 | |
15211 | 15211 | 2020-09-08 | Kern | 29 | 7.8419204416 | 9.1643819049 | 0.0991563761 | |
15212 | 15212 | 2020-09-08 | Kings | 31 | 10.6838777545 | 11.2709568371 | 0.0879494655 | |
15213 | 15213 | 2020-09-08 | Lake | 33 | 6.1660834579 | 6.1660834579 | 0.0582901554 | |
15214 | 15214 | 2020-09-08 | Lassen | 35 | 0.9503219216000001 | 0.9503219216000001 | 0.0264317181 | |
15215 | 15215 | 2020-09-08 | Los Angeles | 37 | 11.0009485829 | 9.6395811957 | 0.043384223300000004 | |
15216 | 15216 | 2020-09-08 | Madera | 39 | 11.5114538966 | 12.4117647059 | 0.1104887984 | |
15217 | 15217 | 2020-09-08 | Marin | 41 | 10.4623137599 | 9.1261716696 | 0.043643987 | |
15218 | 15218 | 2020-09-08 | Mariposa | 43 | 1.6055874443 | 1.6055874443 | 0.007462686600000001 | |
15219 | 15219 | 2020-09-08 | Mendocino | 45 | 9.0457829691 | 9.0457829691 | 0.0447761194 | |
15220 | 15220 | 2020-09-08 | Merced | 47 | 14.2151356402 | 13.2540503196 | 0.074941452 | |
15221 | 15221 | 2020-09-08 | Modoc | 49 | 9.0463626084 | 9.0463626084 | 0.0208333333 | |
15222 | 15222 | 2020-09-08 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
15223 | 15223 | 2020-09-08 | Monterey | 53 | 14.5170964279 | 15.0866021208 | 0.0993195075 | |
15224 | 15224 | 2020-09-08 | Napa | 55 | 5.0124595423 | 4.2486609572 | 0.0285617137 | |
15225 | 15225 | 2020-09-08 | Nevada | 57 | 2.4603094201 | 2.4603094201 | 0.0209677419 | |
15226 | 15226 | 2020-09-08 | Orange | 59 | 4.8673356775 | 5.223332609 | 0.0418820839 | |
15227 | 15227 | 2020-09-08 | Placer | 61 | 5.5653901231 | 6.0752355123 | 0.0446049278 | |
15228 | 15228 | 2020-09-08 | Plumas | 63 | 0.7519984358 | 0.7519984358 | 0.026315789500000002 | |
15229 | 15229 | 2020-09-08 | Riverside | 65 | 7.391323096 | 8.5871652597 | 0.0778496542 | |
15230 | 15230 | 2020-09-08 | Sacramento | 67 | 9.3478166789 | 10.2614722811 | 0.072278488 | |
15231 | 15231 | 2020-09-08 | San Benito | 69 | 24.0988588744 | 24.0988588744 | 0.1339671564 | |
15232 | 15232 | 2020-09-08 | San Bernardino | 71 | 7.8985755892 | 8.686853433 | 0.0754984632 | |
15233 | 15233 | 2020-09-08 | San Diego | 73 | 6.8579878562 | 7.9238563288 | 0.0434007891 | |
15234 | 15234 | 2020-09-08 | San Francisco | 75 | 7.8290607048 | 5.0533455225 | 0.0276609007 | |
15235 | 15235 | 2020-09-08 | San Joaquin | 77 | 11.4279142322 | 12.5972184165 | 0.09120594530000001 | |
15236 | 15236 | 2020-09-08 | San Luis Obispo | 79 | 9.5797511724 | 9.6488211783 | 0.046455938700000005 | |
15237 | 15237 | 2020-09-08 | San Mateo | 81 | 7.8406068887 | 7.658861621 | 0.0517049076 | |
15238 | 15238 | 2020-09-08 | Santa Barbara | 83 | 7.9195870796 | 8.2994896718 | 0.0551836735 | |
15239 | 15239 | 2020-09-08 | Santa Clara | 85 | 8.3713936483 | 6.910166887 | 0.034641175 | |
15240 | 15240 | 2020-09-08 | Santa Cruz | 87 | 5.2659211999 | 5.7178425573 | 0.0380865326 | |
15241 | 15241 | 2020-09-08 | Shasta | 89 | 1.2846504346 | 1.2846504346 | 0.0119211371 | |
15242 | 15242 | 2020-09-08 | Sierra | 91 | 0.0 | 0.0 | 0.0476190476 | |
15243 | 15243 | 2020-09-08 | Siskiyou | 93 | 3.25000325 | 3.25000325 | 0.0223463687 | |
15244 | 15244 | 2020-09-08 | Solano | 95 | 8.2320803528 | 8.1494302661 | 0.044060475200000004 | |
15245 | 15245 | 2020-09-08 | Sonoma | 97 | 15.0718674964 | 14.20357721 | 0.0672821696 | |
15246 | 15246 | 2020-09-08 | Stanislaus | 99 | 13.1093530915 | 14.0517844853 | 0.1026442991 | |
15247 | 15247 | 2020-09-08 | Sutter | 101 | 14.319892898 | 14.319892898 | 0.0857142857 | |
15248 | 15248 | 2020-09-08 | Tehama | 103 | 5.4207005713 | 5.4207005713 | 0.028109029 | |
15249 | 15249 | 2020-09-08 | Trinity | 105 | 2.1395408545 | 2.1395408545 | 0.012738853500000001 | |
15250 | 15250 | 2020-09-08 | Tulare | 107 | 16.8978646466 | 17.5012873932 | 0.1199464923 | |
15251 | 15251 | 2020-09-08 | Tuolumne | 109 | 1.9101831866 | 1.9101831866 | 0.011600928100000001 | |
15252 | 15252 | 2020-09-08 | Ventura | 111 | 7.7899507625 | 7.7579340649 | 0.0477241589 | |
15253 | 15253 | 2020-09-08 | Yolo | 113 | 8.4329744634 | 9.3589150595 | 0.0735650768 | |
15254 | 15254 | 2020-09-08 | 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 );