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-16 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 |
---|---|---|---|---|---|---|---|---|
14733 | 14733 | 2020-09-16 | Alameda | 1 | 6.016336302 | 5.624552482 | 0.0341552142 | |
14734 | 14734 | 2020-09-16 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
14735 | 14735 | 2020-09-16 | Amador | 5 | 1.1122769421 | 1.1122769421 | 0.013020833300000001 | |
14736 | 14736 | 2020-09-16 | Butte | 7 | 21.5169022483 | 18.1867312873 | 0.08329689550000001 | |
14737 | 14737 | 2020-09-16 | Calaveras | 9 | 5.1609074165 | 5.1609074165 | 0.0358490566 | |
14738 | 14738 | 2020-09-16 | Colusa | 11 | 7.5876851869 | 7.5876851869 | 0.08906882590000001 | |
14739 | 14739 | 2020-09-16 | Contra Costa | 13 | 7.0683622691 | 7.0707655123 | 0.047054802300000004 | |
14740 | 14740 | 2020-09-16 | Del Norte | 15 | 1.5551615813000002 | 1.5551615813000002 | 0.0046620047 | |
14741 | 14741 | 2020-09-16 | El Dorado | 17 | 2.1454686961 | 2.1454686961 | 0.0180575891 | |
14742 | 14742 | 2020-09-16 | Fresno | 19 | 7.7502332336 | 7.510363515 | 0.0621660135 | |
14743 | 14743 | 2020-09-16 | Glenn | 21 | 20.9310928951 | 20.9310928951 | 0.11677282380000001 | |
14744 | 14744 | 2020-09-16 | Humboldt | 23 | 3.9416801785 | 3.6799131978 | 0.0160472973 | |
14745 | 14745 | 2020-09-16 | Imperial | 25 | 8.7213007708 | 7.8130645086 | 0.0579551668 | |
14746 | 14746 | 2020-09-16 | Inyo | 27 | 2.3225027289 | 2.3225027289 | 0.014354067000000002 | |
14747 | 14747 | 2020-09-16 | Kern | 29 | 6.7018377055 | 7.5258956698 | 0.070532593 | |
14748 | 14748 | 2020-09-16 | Kings | 31 | 8.9488890593 | 7.5440924548 | 0.046983934500000005 | |
14749 | 14749 | 2020-09-16 | Lake | 33 | 5.9458661916 | 5.9458661916 | 0.0354330709 | |
14750 | 14750 | 2020-09-16 | Lassen | 35 | 2.8509657647 | 2.8509657647 | 0.012455516000000002 | |
14751 | 14751 | 2020-09-16 | Los Angeles | 37 | 9.0804133131 | 8.069490899 | 0.032113164 | |
14752 | 14752 | 2020-09-16 | Madera | 39 | 8.4774272882 | 9.3060110314 | 0.09006550220000001 | |
14753 | 14753 | 2020-09-16 | Marin | 41 | 7.0661700263 | 6.0361344216 | 0.0328675458 | |
14754 | 14754 | 2020-09-16 | Mariposa | 43 | 0.8027937222 | 0.8027937222 | 0.0070671378000000005 | |
14755 | 14755 | 2020-09-16 | Mendocino | 45 | 9.8534421627 | 9.8534421627 | 0.0540123457 | |
14756 | 14756 | 2020-09-16 | Merced | 47 | 13.767806197 | 9.5138294383 | 0.0530136099 | |
14757 | 14757 | 2020-09-16 | Modoc | 49 | 13.5695439126 | 13.5695439126 | 0.0166666667 | |
14758 | 14758 | 2020-09-16 | Mono | 51 | 0.0 | 0.0 | 0.0 | |
14759 | 14759 | 2020-09-16 | Monterey | 53 | 13.2436669167 | 13.9005527958 | 0.0982697799 | |
14760 | 14760 | 2020-09-16 | Napa | 55 | 5.8308202839 | 5.1657569223 | 0.026122148600000002 | |
14761 | 14761 | 2020-09-16 | Nevada | 57 | 3.3286539213 | 3.3286539213 | 0.0196581197 | |
14762 | 14762 | 2020-09-16 | Orange | 59 | 4.4204257653 | 4.7170363342 | 0.0390002949 | |
14763 | 14763 | 2020-09-16 | Placer | 61 | 5.5653901231 | 6.098498843 | 0.0444492628 | |
14764 | 14764 | 2020-09-16 | Plumas | 63 | 1.5039968717 | 1.5039968717 | 0.0091743119 | |
14765 | 14765 | 2020-09-16 | Riverside | 65 | 5.8285531384 | 6.7400805637 | 0.0643999297 | |
14766 | 14766 | 2020-09-16 | Sacramento | 67 | 8.5369436922 | 9.0067317035 | 0.0566433908 | |
14767 | 14767 | 2020-09-16 | San Benito | 69 | 16.0659059163 | 16.0659059163 | 0.0805194805 | |
14768 | 14768 | 2020-09-16 | San Bernardino | 71 | 6.7840131284 | 7.4113308224 | 0.0643349601 | |
14769 | 14769 | 2020-09-16 | San Diego | 73 | 7.8837190436 | 8.1396245637 | 0.0445155567 | |
14770 | 14770 | 2020-09-16 | San Francisco | 75 | 6.5482327777 | 3.9289396666 | 0.0235960193 | |
14771 | 14771 | 2020-09-16 | San Joaquin | 77 | 8.7808733957 | 9.4628838323 | 0.07130890050000001 | |
14772 | 14772 | 2020-09-16 | San Luis Obispo | 79 | 7.325692073 | 6.3162117053 | 0.028531172900000002 | |
14773 | 14773 | 2020-09-16 | San Mateo | 81 | 6.1696578796 | 6.0025835442 | 0.0413354531 | |
14774 | 14774 | 2020-09-16 | Santa Barbara | 83 | 9.1403929931 | 9.1257683643 | 0.0479896239 | |
14775 | 14775 | 2020-09-16 | Santa Clara | 85 | 7.1879268966 | 5.9773362487 | 0.0304175326 | |
14776 | 14776 | 2020-09-16 | Santa Cruz | 87 | 5.5266103682 | 5.5247313207 | 0.035636889000000005 | |
14777 | 14777 | 2020-09-16 | Shasta | 89 | 1.4452317389 | 1.4452317389 | 0.0169082126 | |
14778 | 14778 | 2020-09-16 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
14779 | 14779 | 2020-09-16 | Siskiyou | 93 | 2.275002275 | 2.275002275 | 0.024943310700000002 | |
14780 | 14780 | 2020-09-16 | Solano | 95 | 5.3379896038 | 5.2916024741 | 0.0343322665 | |
14781 | 14781 | 2020-09-16 | Sonoma | 97 | 11.5052423637 | 10.6062227254 | 0.055722389100000005 | |
14782 | 14782 | 2020-09-16 | Stanislaus | 99 | 9.5779575882 | 9.3722230592 | 0.0563913964 | |
14783 | 14783 | 2020-09-16 | Sutter | 101 | 10.6723730089 | 10.6723730089 | 0.0697224015 | |
14784 | 14784 | 2020-09-16 | Tehama | 103 | 6.9384967313 | 6.9384967313 | 0.0435294118 | |
14785 | 14785 | 2020-09-16 | Trinity | 105 | 1.0697704273 | 1.0697704273 | 0.011627907000000002 | |
14786 | 14786 | 2020-09-16 | Tulare | 107 | 12.2089283834 | 12.2556885791 | 0.0871180842 | |
14787 | 14787 | 2020-09-16 | Tuolumne | 109 | 2.7288331237 | 2.7288331237 | 0.0196581197 | |
14788 | 14788 | 2020-09-16 | Ventura | 111 | 8.2590230665 | 7.8518532293 | 0.0436371157 | |
14789 | 14789 | 2020-09-16 | Yolo | 113 | 7.0913648897 | 7.4896159419 | 0.05805565100000001 | |
14790 | 14790 | 2020-09-16 | 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 );