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-10-03
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | fips | percapita_case_rate | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
14327 | 14327 | 2020-10-03 | Alameda | 1 | 4.7876479023 | 4.0818570617 | 0.0229815976 | |
14328 | 14328 | 2020-10-03 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
14329 | 14329 | 2020-10-03 | Amador | 5 | 2.9660718457 | 2.9660718457 | 0.0205479452 | |
14330 | 14330 | 2020-10-03 | Butte | 7 | 5.5760264973 | 5.0471189721 | 0.026470588200000002 | |
14331 | 14331 | 2020-10-03 | Calaveras | 9 | 0.32255671350000004 | 0.32255671350000004 | 0.0142095915 | |
14332 | 14332 | 2020-10-03 | Colusa | 11 | 10.1169135826 | 10.1169135826 | 0.0944206009 | |
14333 | 14333 | 2020-10-03 | Contra Costa | 13 | 6.6743072297 | 6.3307001444 | 0.0365103379 | |
14334 | 14334 | 2020-10-03 | Del Norte | 15 | 5.1838719376 | 5.1838719376 | 0.0053475936000000005 | |
14335 | 14335 | 2020-10-03 | El Dorado | 17 | 2.6633404504 | 2.6633404504 | 0.0166340509 | |
14336 | 14336 | 2020-10-03 | Fresno | 19 | 6.1033086714 | 6.164103485 | 0.0494653283 | |
14337 | 14337 | 2020-10-03 | Glenn | 21 | 8.7618528398 | 8.7618528398 | 0.0608695652 | |
14338 | 14338 | 2020-10-03 | Humboldt | 23 | 1.1718508639 | 1.1718508639 | 0.0072222222 | |
14339 | 14339 | 2020-10-03 | Imperial | 25 | 8.0504314808 | 9.1559061856 | 0.0870933893 | |
14340 | 14340 | 2020-10-03 | Inyo | 27 | 0.7741675763 | 0.7741675763 | 0.0060606061 | |
14341 | 14341 | 2020-10-03 | Kern | 29 | 6.5939920413 | 7.3211743844 | 0.0580080621 | |
14342 | 14342 | 2020-10-03 | Kings | 31 | 8.4923130869 | 7.1950706506 | 0.040623091 | |
14343 | 14343 | 2020-10-03 | Lake | 33 | 16.2960777103 | 16.2960777103 | 0.0782122905 | |
14344 | 14344 | 2020-10-03 | Lassen | 35 | 3.3261267254 | 3.3261267254 | 0.0107991361 | |
14345 | 14345 | 2020-10-03 | Los Angeles | 37 | 8.8701153974 | 7.3428837646 | 0.0285722 | |
14346 | 14346 | 2020-10-03 | Madera | 39 | 7.7635386745 | 8.4211777101 | 0.0664573522 | |
14347 | 14347 | 2020-10-03 | Marin | 41 | 6.9018404908 | 5.6944176764000005 | 0.0294521893 | |
14348 | 14348 | 2020-10-03 | Mariposa | 43 | 0.0 | 0.0 | 0.0 | |
14349 | 14349 | 2020-10-03 | Mendocino | 45 | 10.6611013564 | 10.6611013564 | 0.0499027868 | |
14350 | 14350 | 2020-10-03 | Merced | 47 | 7.0081612772 | 6.9088237447 | 0.0361659641 | |
14351 | 14351 | 2020-10-03 | Modoc | 49 | 1.5077271014 | 1.5077271014 | 0.022222222200000002 | |
14352 | 14352 | 2020-10-03 | Mono | 51 | 0.0 | 0.0 | 0.015625 | |
14353 | 14353 | 2020-10-03 | Monterey | 53 | 10.6331364187 | 9.9294657549 | 0.057828282800000005 | |
14354 | 14354 | 2020-10-03 | Napa | 55 | 5.5239350058 | 4.276416429 | 0.0250831067 | |
14355 | 14355 | 2020-10-03 | Nevada | 57 | 3.9075502554 | 3.9075502554 | 0.0221300138 | |
14356 | 14356 | 2020-10-03 | Orange | 59 | 4.3584778567 | 4.3584778567 | 0.0310662775 | |
14357 | 14357 | 2020-10-03 | Placer | 61 | 4.5307983695 | 4.5307983695 | 0.031009245 | |
14358 | 14358 | 2020-10-03 | Plumas | 63 | 0.7519984358 | 0.7519984358 | 0.0049261084 | |
14359 | 14359 | 2020-10-03 | Riverside | 65 | 6.0195583554 | 6.6761157387 | 0.0484072684 | |
14360 | 14360 | 2020-10-03 | Sacramento | 67 | 6.5780932185 | 6.8074418592 | 0.046180107000000005 | |
14361 | 14361 | 2020-10-03 | San Benito | 69 | 10.9337415264 | 10.9337415264 | 0.0753221011 | |
14362 | 14362 | 2020-10-03 | San Bernardino | 71 | 7.2414347163 | 7.7459324384 | 0.0566854176 | |
14363 | 14363 | 2020-10-03 | San Diego | 73 | 7.2267424566 | 6.6701722124 | 0.0346023468 | |
14364 | 14364 | 2020-10-03 | San Francisco | 75 | 5.3154358978000005 | 3.1892615387 | 0.0198782961 | |
14365 | 14365 | 2020-10-03 | San Joaquin | 77 | 6.3346425536 | 6.7532888179 | 0.0471040129 | |
14366 | 14366 | 2020-10-03 | San Luis Obispo | 79 | 8.6064074704 | 5.8969219184 | 0.0200079502 | |
14367 | 14367 | 2020-10-03 | San Mateo | 81 | 6.481813189 | 5.9629754152 | 0.0367751061 | |
14368 | 14368 | 2020-10-03 | Santa Barbara | 83 | 4.7580127909000005 | 4.5158009636 | 0.0319599538 | |
14369 | 14369 | 2020-10-03 | Santa Clara | 85 | 5.9463758872 | 4.6970202522 | 0.0237849018 | |
14370 | 14370 | 2020-10-03 | Santa Cruz | 87 | 7.4035723801 | 7.0378124352 | 0.0351780352 | |
14371 | 14371 | 2020-10-03 | Shasta | 89 | 6.5838334772 | 6.4866221225 | 0.0397279885 | |
14372 | 14372 | 2020-10-03 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
14373 | 14373 | 2020-10-03 | Siskiyou | 93 | 0.6500006500000001 | 0.6500006500000001 | 0.004658385100000001 | |
14374 | 14374 | 2020-10-03 | Solano | 95 | 6.2383733924 | 6.0150567805 | 0.0320600273 | |
14375 | 14375 | 2020-10-03 | Sonoma | 97 | 8.3988269255 | 7.8113302419 | 0.0401720041 | |
14376 | 14376 | 2020-10-03 | Stanislaus | 99 | 6.9103566684 | 7.2468472956 | 0.047466238800000005 | |
14377 | 14377 | 2020-10-03 | Sutter | 101 | 8.9161597289 | 8.9161597289 | 0.0530744337 | |
14378 | 14378 | 2020-10-03 | Tehama | 103 | 9.3236049827 | 9.3236049827 | 0.0539419087 | |
14379 | 14379 | 2020-10-03 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
14380 | 14380 | 2020-10-03 | Tulare | 107 | 9.1714413702 | 9.2130530251 | 0.0602509306 | |
14381 | 14381 | 2020-10-03 | Tuolumne | 109 | 1.9101831866 | 1.9101831866 | 0.0114942529 | |
14382 | 14382 | 2020-10-03 | Ventura | 111 | 8.0077343322 | 7.0255883589 | 0.035735451 | |
14383 | 14383 | 2020-10-03 | Yolo | 113 | 3.1304223387 | 3.1304223387 | 0.0254556882 | |
14384 | 14384 | 2020-10-03 | Yuba | 115 | 5.0447723546 | 5.0447723546 | 0.0334685598 |
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 );