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-06 sorted by percapita_case_rate
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips | percapita_case_rate ▼ | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
15314 | 15314 | 2020-09-06 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
15330 | 15330 | 2020-09-06 | Lassen | 35 | 0.0 | 0.0 | 0.0080256822 | |
15337 | 15337 | 2020-09-06 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
15344 | 15344 | 2020-09-06 | Plumas | 63 | 0.0 | 0.0 | 0.02 | |
15359 | 15359 | 2020-09-06 | Siskiyou | 93 | 0.6500006500000001 | 0.6500006500000001 | 0.006024096400000001 | |
15338 | 15338 | 2020-09-06 | Mono | 51 | 1.0232586696 | 1.0232586696 | 0.0056179775 | |
15367 | 15367 | 2020-09-06 | Tuolumne | 109 | 1.6372998742 | 1.6372998742 | 0.0135338346 | |
15320 | 15320 | 2020-09-06 | Del Norte | 15 | 2.0735487751 | 2.0735487751 | 0.0156739812 | |
15365 | 15365 | 2020-09-06 | Trinity | 105 | 2.1395408545 | 1.882795952 | 0.0165975104 | |
15357 | 15357 | 2020-09-06 | Shasta | 89 | 2.4087195648 | 2.4087195648 | 0.0155642023 | |
15315 | 15315 | 2020-09-06 | Amador | 5 | 2.595312865 | 2.595312865 | 0.0251046025 | |
15334 | 15334 | 2020-09-06 | Mariposa | 43 | 3.2111748886 | 3.2111748886 | 0.010380622800000001 | |
15329 | 15329 | 2020-09-06 | Lake | 33 | 3.3032589953000002 | 3.3032589953000002 | 0.0356652949 | |
15321 | 15321 | 2020-09-06 | El Dorado | 17 | 3.5511206005 | 3.5511206005 | 0.0360970107 | |
15324 | 15324 | 2020-09-06 | Humboldt | 23 | 3.6220844883 | 3.1874343497 | 0.0140306122 | |
15341 | 15341 | 2020-09-06 | Nevada | 57 | 4.052274339 | 4.052274339 | 0.0220883534 | |
15358 | 15358 | 2020-09-06 | Sierra | 91 | 4.5861041046 | 4.5861041046 | 0.0 | |
15317 | 15317 | 2020-09-06 | Calaveras | 9 | 4.838350703 | 4.838350703 | 0.0315789474 | |
15343 | 15343 | 2020-09-06 | Placer | 61 | 5.3156610792 | 5.3156610792 | 0.038704249100000004 | |
15342 | 15342 | 2020-09-06 | Orange | 59 | 5.6328348341000005 | 5.6328348341000005 | 0.0499685884 | |
15349 | 15349 | 2020-09-06 | San Diego | 73 | 5.8195409929 | 5.8195409929 | 0.0367064963 | |
15333 | 15333 | 2020-09-06 | Marin | 41 | 5.9158632778 | 4.6143733567 | 0.0301044803 | |
15356 | 15356 | 2020-09-06 | Santa Cruz | 87 | 6.2565400395 | 6.2565400395 | 0.0274693162 | |
15323 | 15323 | 2020-09-06 | Glenn | 21 | 6.3280048288 | 6.3280048288 | 0.062305296 | |
15340 | 15340 | 2020-09-06 | Napa | 55 | 6.5468859328 | 5.7612596209 | 0.0424892704 | |
15369 | 15369 | 2020-09-06 | Yolo | 113 | 7.2830234002 | 7.2830234002 | 0.059453032100000004 | |
15352 | 15352 | 2020-09-06 | San Luis Obispo | 79 | 7.325692073 | 7.325692073 | 0.042266187100000005 | |
15355 | 15355 | 2020-09-06 | Santa Clara | 85 | 8.5819490826 | 6.6939202844 | 0.035466839 | |
15353 | 15353 | 2020-09-06 | San Mateo | 81 | 8.6301762007 | 7.5945550566 | 0.0477365675 | |
15354 | 15354 | 2020-09-06 | Santa Barbara | 83 | 8.9838794144 | 8.9838794144 | 0.0648379052 | |
15368 | 15368 | 2020-09-06 | Ventura | 111 | 9.0631470161 | 9.0631470161 | 0.061522419200000004 | |
15360 | 15360 | 2020-09-06 | Solano | 95 | 9.0681510137 | 7.979972892 | 0.0431280852 | |
15350 | 15350 | 2020-09-06 | San Francisco | 75 | 9.830354341 | 6.3897303217 | 0.0335995022 | |
15318 | 15318 | 2020-09-06 | Colusa | 11 | 10.1169135826 | 10.1169135826 | 0.0822510823 | |
15364 | 15364 | 2020-09-06 | Tehama | 103 | 10.1909170741 | 10.1909170741 | 0.0593220339 | |
15345 | 15345 | 2020-09-06 | Riverside | 65 | 10.3779501262 | 10.3779501262 | 0.0856521241 | |
15335 | 15335 | 2020-09-06 | Mendocino | 45 | 10.4995695176 | 8.1896642238 | 0.0419222904 | |
15313 | 15313 | 2020-09-06 | Alameda | 1 | 10.5582465244 | 9.2912569415 | 0.0564508316 | |
15319 | 15319 | 2020-09-06 | Contra Costa | 13 | 10.7626282634 | 10.7626282634 | 0.0623303404 | |
15316 | 15316 | 2020-09-06 | Butte | 7 | 11.7424558001 | 10.3333611041 | 0.0401442308 | |
15346 | 15346 | 2020-09-06 | Sacramento | 67 | 12.0355417474 | 12.0355417474 | 0.08094625870000001 | |
15348 | 15348 | 2020-09-06 | San Bernardino | 71 | 12.1764338202 | 12.1764338202 | 0.10189690430000001 | |
15331 | 15331 | 2020-09-06 | Los Angeles | 37 | 13.0677175026 | 10.192819652 | 0.0501956961 | |
15362 | 15362 | 2020-09-06 | Stanislaus | 99 | 14.506667859 | 14.506667859 | 0.1251766036 | |
15325 | 15325 | 2020-09-06 | Imperial | 25 | 14.7591243814 | 14.7591243814 | 0.153414406 | |
15363 | 15363 | 2020-09-06 | Sutter | 101 | 14.9953595441 | 14.9953595441 | 0.0894085282 | |
15327 | 15327 | 2020-09-06 | Kern | 29 | 15.005953851 | 15.005953851 | 0.1438025799 | |
15328 | 15328 | 2020-09-06 | Kings | 31 | 15.4322678676 | 15.4322678676 | 0.1113163972 | |
15339 | 15339 | 2020-09-06 | Monterey | 53 | 15.5040042991 | 15.5040042991 | 0.1087289433 | |
15370 | 15370 | 2020-09-06 | Yuba | 115 | 15.8549988289 | 15.8549988289 | 0.11194029850000001 | |
15361 | 15361 | 2020-09-06 | Sonoma | 97 | 15.9059975678 | 13.9972778597 | 0.0652956896 | |
15322 | 15322 | 2020-09-06 | Fresno | 19 | 16.510764728 | 16.510764728 | 0.1102986359 | |
15351 | 15351 | 2020-09-06 | San Joaquin | 77 | 16.5759522729 | 16.5759522729 | 0.11338646220000001 | |
15366 | 15366 | 2020-09-06 | Tulare | 107 | 18.460843401 | 18.460843401 | 0.130333698 | |
15332 | 15332 | 2020-09-06 | Madera | 39 | 19.631936878 | 19.631936878 | 0.158564289 | |
15347 | 15347 | 2020-09-06 | San Benito | 69 | 21.4212078884 | 18.8506629418 | 0.1128158845 | |
15326 | 15326 | 2020-09-06 | Inyo | 27 | 27.095865171 | 27.095865171 | 0.1320132013 | |
15336 | 15336 | 2020-09-06 | Merced | 47 | 27.7344254799 | 27.7344254799 | 0.1138548951 |
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 );