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-18 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 |
---|---|---|---|---|---|---|---|---|
14617 | 14617 | 2020-09-18 | Alameda | 1 | 6.016336302 | 5.624552482 | 0.0341552142 | |
14618 | 14618 | 2020-09-18 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
14619 | 14619 | 2020-09-18 | Amador | 5 | 1.1122769421 | 1.1122769421 | 0.013020833300000001 | |
14620 | 14620 | 2020-09-18 | Butte | 7 | 21.5169022483 | 18.1867312873 | 0.08329689550000001 | |
14621 | 14621 | 2020-09-18 | Calaveras | 9 | 5.1609074165 | 5.1609074165 | 0.0358490566 | |
14622 | 14622 | 2020-09-18 | Colusa | 11 | 7.5876851869 | 7.5876851869 | 0.08906882590000001 | |
14623 | 14623 | 2020-09-18 | Contra Costa | 13 | 7.0683622691 | 7.0707655123 | 0.047054802300000004 | |
14624 | 14624 | 2020-09-18 | Del Norte | 15 | 1.5551615813000002 | 1.5551615813000002 | 0.0046620047 | |
14625 | 14625 | 2020-09-18 | El Dorado | 17 | 2.1454686961 | 2.1454686961 | 0.0180575891 | |
14626 | 14626 | 2020-09-18 | Fresno | 19 | 7.7502332336 | 7.510363515 | 0.0621660135 | |
14627 | 14627 | 2020-09-18 | Glenn | 21 | 20.9310928951 | 20.9310928951 | 0.11677282380000001 | |
14628 | 14628 | 2020-09-18 | Humboldt | 23 | 3.9416801785 | 3.6799131978 | 0.0160472973 | |
14629 | 14629 | 2020-09-18 | Imperial | 25 | 8.7213007708 | 7.8130645086 | 0.0579551668 | |
14630 | 14630 | 2020-09-18 | Inyo | 27 | 2.3225027289 | 2.3225027289 | 0.014354067000000002 | |
14631 | 14631 | 2020-09-18 | Kern | 29 | 6.7018377055 | 7.5258956698 | 0.070532593 | |
14632 | 14632 | 2020-09-18 | Kings | 31 | 8.9488890593 | 7.5440924548 | 0.046983934500000005 | |
14633 | 14633 | 2020-09-18 | Lake | 33 | 5.9458661916 | 5.9458661916 | 0.0354330709 | |
14634 | 14634 | 2020-09-18 | Lassen | 35 | 2.8509657647 | 2.8509657647 | 0.012455516000000002 | |
14635 | 14635 | 2020-09-18 | Los Angeles | 37 | 9.0804133131 | 8.069490899 | 0.032113164 | |
14636 | 14636 | 2020-09-18 | Madera | 39 | 8.4774272882 | 9.3060110314 | 0.09006550220000001 | |
14637 | 14637 | 2020-09-18 | Marin | 41 | 7.0661700263 | 6.0361344216 | 0.0328675458 | |
14638 | 14638 | 2020-09-18 | Mariposa | 43 | 0.8027937222 | 0.8027937222 | 0.0070671378000000005 | |
14639 | 14639 | 2020-09-18 | Mendocino | 45 | 9.8534421627 | 9.8534421627 | 0.0540123457 | |
14640 | 14640 | 2020-09-18 | Merced | 47 | 13.767806197 | 9.5138294383 | 0.0530136099 | |
14641 | 14641 | 2020-09-18 | Modoc | 49 | 13.5695439126 | 13.5695439126 | 0.0166666667 | |
14642 | 14642 | 2020-09-18 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
14643 | 14643 | 2020-09-18 | Monterey | 53 | 13.2436669167 | 13.9005527958 | 0.0982697799 | |
14644 | 14644 | 2020-09-18 | Napa | 55 | 5.8308202839 | 5.1657569223 | 0.026122148600000002 | |
14645 | 14645 | 2020-09-18 | Nevada | 57 | 3.3286539213 | 3.3286539213 | 0.0196581197 | |
14646 | 14646 | 2020-09-18 | Orange | 59 | 4.4204257653 | 4.7170363342 | 0.0390002949 | |
14647 | 14647 | 2020-09-18 | Placer | 61 | 5.5653901231 | 6.098498843 | 0.0444492628 | |
14648 | 14648 | 2020-09-18 | Plumas | 63 | 1.5039968717 | 1.5039968717 | 0.0091743119 | |
14649 | 14649 | 2020-09-18 | Riverside | 65 | 5.8285531384 | 6.7400805637 | 0.0643999297 | |
14650 | 14650 | 2020-09-18 | Sacramento | 67 | 8.5369436922 | 9.0067317035 | 0.0566433908 | |
14651 | 14651 | 2020-09-18 | San Benito | 69 | 16.0659059163 | 16.0659059163 | 0.0805194805 | |
14652 | 14652 | 2020-09-18 | San Bernardino | 71 | 6.7840131284 | 7.4113308224 | 0.0643349601 | |
14653 | 14653 | 2020-09-18 | San Diego | 73 | 7.8837190436 | 8.1396245637 | 0.0445155567 | |
14654 | 14654 | 2020-09-18 | San Francisco | 75 | 6.5482327777 | 3.9289396666 | 0.0235960193 | |
14655 | 14655 | 2020-09-18 | San Joaquin | 77 | 8.7808733957 | 9.4628838323 | 0.07130890050000001 | |
14656 | 14656 | 2020-09-18 | San Luis Obispo | 79 | 7.325692073 | 6.3162117053 | 0.028531172900000002 | |
14657 | 14657 | 2020-09-18 | San Mateo | 81 | 6.1696578796 | 6.0025835442 | 0.0413354531 | |
14658 | 14658 | 2020-09-18 | Santa Barbara | 83 | 9.1403929931 | 9.1257683643 | 0.0479896239 | |
14659 | 14659 | 2020-09-18 | Santa Clara | 85 | 7.1879268966 | 5.9773362487 | 0.0304175326 | |
14660 | 14660 | 2020-09-18 | Santa Cruz | 87 | 5.5266103682 | 5.5247313207 | 0.035636889000000005 | |
14661 | 14661 | 2020-09-18 | Shasta | 89 | 1.4452317389 | 1.4452317389 | 0.0169082126 | |
14662 | 14662 | 2020-09-18 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
14663 | 14663 | 2020-09-18 | Siskiyou | 93 | 2.275002275 | 2.275002275 | 0.024943310700000002 | |
14664 | 14664 | 2020-09-18 | Solano | 95 | 5.3379896038 | 5.2916024741 | 0.0343322665 | |
14665 | 14665 | 2020-09-18 | Sonoma | 97 | 11.5052423637 | 10.6062227254 | 0.055722389100000005 | |
14666 | 14666 | 2020-09-18 | Stanislaus | 99 | 9.5779575882 | 9.3722230592 | 0.0563913964 | |
14667 | 14667 | 2020-09-18 | Sutter | 101 | 10.6723730089 | 10.6723730089 | 0.0697224015 | |
14668 | 14668 | 2020-09-18 | Tehama | 103 | 6.9384967313 | 6.9384967313 | 0.0435294118 | |
14669 | 14669 | 2020-09-18 | Trinity | 105 | 1.0697704273 | 1.0697704273 | 0.011627907000000002 | |
14670 | 14670 | 2020-09-18 | Tulare | 107 | 12.2089283834 | 12.2556885791 | 0.0871180842 | |
14671 | 14671 | 2020-09-18 | Tuolumne | 109 | 2.7288331237 | 2.7288331237 | 0.0196581197 | |
14672 | 14672 | 2020-09-18 | Ventura | 111 | 8.2590230665 | 7.8518532293 | 0.0436371157 | |
14673 | 14673 | 2020-09-18 | Yolo | 113 | 7.0913648897 | 7.4896159419 | 0.05805565100000001 | |
14674 | 14674 | 2020-09-18 | Yuba | 115 | 10.4498855918 | 10.4498855918 | 0.1057692308 |
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 );