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-07 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | fips | percapita_case_rate | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
15255 | 15255 | 2020-09-07 | Alameda | 1 | 10.5582465244 | 9.2912569415 | 0.0564508316 | |
15256 | 15256 | 2020-09-07 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
15257 | 15257 | 2020-09-07 | Amador | 5 | 2.595312865 | 2.595312865 | 0.0251046025 | |
15258 | 15258 | 2020-09-07 | Butte | 7 | 11.7424558001 | 10.3333611041 | 0.0401442308 | |
15259 | 15259 | 2020-09-07 | Calaveras | 9 | 4.838350703 | 4.838350703 | 0.0315789474 | |
15260 | 15260 | 2020-09-07 | Colusa | 11 | 10.1169135826 | 10.1169135826 | 0.0822510823 | |
15261 | 15261 | 2020-09-07 | Contra Costa | 13 | 10.7626282634 | 10.7626282634 | 0.0623303404 | |
15262 | 15262 | 2020-09-07 | Del Norte | 15 | 2.0735487751 | 2.0735487751 | 0.0156739812 | |
15263 | 15263 | 2020-09-07 | El Dorado | 17 | 3.5511206005 | 3.5511206005 | 0.0360970107 | |
15264 | 15264 | 2020-09-07 | Fresno | 19 | 16.510764728 | 16.510764728 | 0.1102986359 | |
15265 | 15265 | 2020-09-07 | Glenn | 21 | 6.3280048288 | 6.3280048288 | 0.062305296 | |
15266 | 15266 | 2020-09-07 | Humboldt | 23 | 3.6220844883 | 3.1874343497 | 0.0140306122 | |
15267 | 15267 | 2020-09-07 | Imperial | 25 | 14.7591243814 | 14.7591243814 | 0.153414406 | |
15268 | 15268 | 2020-09-07 | Inyo | 27 | 27.095865171 | 27.095865171 | 0.1320132013 | |
15269 | 15269 | 2020-09-07 | Kern | 29 | 15.005953851 | 15.005953851 | 0.1438025799 | |
15270 | 15270 | 2020-09-07 | Kings | 31 | 15.4322678676 | 15.4322678676 | 0.1113163972 | |
15271 | 15271 | 2020-09-07 | Lake | 33 | 3.3032589953000002 | 3.3032589953000002 | 0.0356652949 | |
15272 | 15272 | 2020-09-07 | Lassen | 35 | 0.0 | 0.0 | 0.0080256822 | |
15273 | 15273 | 2020-09-07 | Los Angeles | 37 | 13.0677175026 | 10.192819652 | 0.0501956961 | |
15274 | 15274 | 2020-09-07 | Madera | 39 | 19.631936878 | 19.631936878 | 0.158564289 | |
15275 | 15275 | 2020-09-07 | Marin | 41 | 5.9158632778 | 4.6143733567 | 0.0301044803 | |
15276 | 15276 | 2020-09-07 | Mariposa | 43 | 3.2111748886 | 3.2111748886 | 0.010380622800000001 | |
15277 | 15277 | 2020-09-07 | Mendocino | 45 | 10.4995695176 | 8.1896642238 | 0.0419222904 | |
15278 | 15278 | 2020-09-07 | Merced | 47 | 27.7344254799 | 27.7344254799 | 0.1138548951 | |
15279 | 15279 | 2020-09-07 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
15280 | 15280 | 2020-09-07 | Mono | 51 | 1.0232586696 | 1.0232586696 | 0.0056179775 | |
15281 | 15281 | 2020-09-07 | Monterey | 53 | 15.5040042991 | 15.5040042991 | 0.1087289433 | |
15282 | 15282 | 2020-09-07 | Napa | 55 | 6.5468859328 | 5.7612596209 | 0.0424892704 | |
15283 | 15283 | 2020-09-07 | Nevada | 57 | 4.052274339 | 4.052274339 | 0.0220883534 | |
15284 | 15284 | 2020-09-07 | Orange | 59 | 5.6328348341000005 | 5.6328348341000005 | 0.0499685884 | |
15285 | 15285 | 2020-09-07 | Placer | 61 | 5.3156610792 | 5.3156610792 | 0.038704249100000004 | |
15286 | 15286 | 2020-09-07 | Plumas | 63 | 0.0 | 0.0 | 0.02 | |
15287 | 15287 | 2020-09-07 | Riverside | 65 | 10.3779501262 | 10.3779501262 | 0.0856521241 | |
15288 | 15288 | 2020-09-07 | Sacramento | 67 | 12.0355417474 | 12.0355417474 | 0.08094625870000001 | |
15289 | 15289 | 2020-09-07 | San Benito | 69 | 21.4212078884 | 18.8506629418 | 0.1128158845 | |
15290 | 15290 | 2020-09-07 | San Bernardino | 71 | 12.1764338202 | 12.1764338202 | 0.10189690430000001 | |
15291 | 15291 | 2020-09-07 | San Diego | 73 | 5.8195409929 | 5.8195409929 | 0.0367064963 | |
15292 | 15292 | 2020-09-07 | San Francisco | 75 | 9.830354341 | 6.3897303217 | 0.0335995022 | |
15293 | 15293 | 2020-09-07 | San Joaquin | 77 | 16.5759522729 | 16.5759522729 | 0.11338646220000001 | |
15294 | 15294 | 2020-09-07 | San Luis Obispo | 79 | 7.325692073 | 7.325692073 | 0.042266187100000005 | |
15295 | 15295 | 2020-09-07 | San Mateo | 81 | 8.6301762007 | 7.5945550566 | 0.0477365675 | |
15296 | 15296 | 2020-09-07 | Santa Barbara | 83 | 8.9838794144 | 8.9838794144 | 0.0648379052 | |
15297 | 15297 | 2020-09-07 | Santa Clara | 85 | 8.5819490826 | 6.6939202844 | 0.035466839 | |
15298 | 15298 | 2020-09-07 | Santa Cruz | 87 | 6.2565400395 | 6.2565400395 | 0.0274693162 | |
15299 | 15299 | 2020-09-07 | Shasta | 89 | 2.4087195648 | 2.4087195648 | 0.0155642023 | |
15300 | 15300 | 2020-09-07 | Sierra | 91 | 4.5861041046 | 4.5861041046 | 0.0 | |
15301 | 15301 | 2020-09-07 | Siskiyou | 93 | 0.6500006500000001 | 0.6500006500000001 | 0.006024096400000001 | |
15302 | 15302 | 2020-09-07 | Solano | 95 | 9.0681510137 | 7.979972892 | 0.0431280852 | |
15303 | 15303 | 2020-09-07 | Sonoma | 97 | 15.9059975678 | 13.9972778597 | 0.0652956896 | |
15304 | 15304 | 2020-09-07 | Stanislaus | 99 | 14.506667859 | 14.506667859 | 0.1251766036 | |
15305 | 15305 | 2020-09-07 | Sutter | 101 | 14.9953595441 | 14.9953595441 | 0.0894085282 | |
15306 | 15306 | 2020-09-07 | Tehama | 103 | 10.1909170741 | 10.1909170741 | 0.0593220339 | |
15307 | 15307 | 2020-09-07 | Trinity | 105 | 2.1395408545 | 1.882795952 | 0.0165975104 | |
15308 | 15308 | 2020-09-07 | Tulare | 107 | 18.460843401 | 18.460843401 | 0.130333698 | |
15309 | 15309 | 2020-09-07 | Tuolumne | 109 | 1.6372998742 | 1.6372998742 | 0.0135338346 | |
15310 | 15310 | 2020-09-07 | Ventura | 111 | 9.0631470161 | 9.0631470161 | 0.061522419200000004 | |
15311 | 15311 | 2020-09-07 | Yolo | 113 | 7.2830234002 | 7.2830234002 | 0.059453032100000004 | |
15312 | 15312 | 2020-09-07 | Yuba | 115 | 15.8549988289 | 15.8549988289 | 0.11194029850000001 |
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 );