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
15,718 rows sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips ▼ | percapita_case_rate | adjusted_case_rate | positivity_rate | equity_index |
---|---|---|---|---|---|---|---|---|
1 | 1 | 2021-06-15 | Alameda | 1 | 1.499847219 | 1.1 | 0.006 | 1.0 |
59 | 59 | 2021-06-14 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
117 | 117 | 2021-06-13 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
175 | 175 | 2021-06-12 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
233 | 233 | 2021-06-11 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
291 | 291 | 2021-06-10 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
349 | 349 | 2021-06-09 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
407 | 407 | 2021-06-08 | Alameda | 1 | 2.1269019885000002 | 1.5 | 0.007 | 1.3 |
465 | 465 | 2021-06-07 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
523 | 523 | 2021-06-06 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
581 | 581 | 2021-06-05 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
639 | 639 | 2021-06-04 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
697 | 697 | 2021-06-03 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
755 | 755 | 2021-06-02 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
813 | 813 | 2021-06-01 | Alameda | 1 | 2.254007685 | 1.6 | 0.008 | 1.4 |
871 | 871 | 2021-05-31 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
929 | 929 | 2021-05-30 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
987 | 987 | 2021-05-29 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
1045 | 1045 | 2021-05-28 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
1103 | 1103 | 2021-05-27 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
1161 | 1161 | 2021-05-26 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
1219 | 1219 | 2021-05-25 | Alameda | 1 | 2.8641150283 | 2.1 | 0.01 | 1.5 |
1277 | 1277 | 2021-05-24 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1335 | 1335 | 2021-05-23 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1393 | 1393 | 2021-05-22 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1451 | 1451 | 2021-05-21 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1509 | 1509 | 2021-05-20 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1567 | 1567 | 2021-05-19 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1625 | 1625 | 2021-05-18 | Alameda | 1 | 3.3810115275 | 2.6 | 0.011 | 1.8 |
1683 | 1683 | 2021-05-17 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
1741 | 1741 | 2021-05-16 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
1799 | 1799 | 2021-05-15 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
1857 | 1857 | 2021-05-14 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
1915 | 1915 | 2021-05-13 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
1973 | 1973 | 2021-05-12 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
2031 | 2031 | 2021-05-11 | Alameda | 1 | 4.0165400101 | 2.9 | 0.011 | 1.6 |
2089 | 2089 | 2021-05-10 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2147 | 2147 | 2021-05-09 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2205 | 2205 | 2021-05-08 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2263 | 2263 | 2021-05-07 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2321 | 2321 | 2021-05-06 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2379 | 2379 | 2021-05-05 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2437 | 2437 | 2021-05-04 | Alameda | 1 | 4.8300164678 | 3.7 | 0.013000000000000001 | 2.0 |
2495 | 2495 | 2021-05-03 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2553 | 2553 | 2021-05-02 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2611 | 2611 | 2021-05-01 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2669 | 2669 | 2021-04-30 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2727 | 2727 | 2021-04-29 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2785 | 2785 | 2021-04-28 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2843 | 2843 | 2021-04-27 | Alameda | 1 | 4.9486484512 | 3.6 | 0.014 | 2.4 |
2901 | 2901 | 2021-04-26 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
2959 | 2959 | 2021-04-25 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3017 | 3017 | 2021-04-24 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3075 | 3075 | 2021-04-23 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3133 | 3133 | 2021-04-22 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3191 | 3191 | 2021-04-21 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3249 | 3249 | 2021-04-20 | Alameda | 1 | 4.431751952 | 3.3 | 0.013000000000000001 | 1.9 |
3307 | 3307 | 2021-04-19 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3365 | 3365 | 2021-04-18 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3423 | 3423 | 2021-04-17 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3481 | 3481 | 2021-04-16 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3539 | 3539 | 2021-04-15 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3597 | 3597 | 2021-04-14 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3655 | 3655 | 2021-04-13 | Alameda | 1 | 4.6520684927 | 3.1 | 0.012 | 2.1 |
3713 | 3713 | 2021-04-08 | Alameda | 1 | 4.5758050748 | 3.5 | 0.014 | 2.1 |
3771 | 3771 | 2021-04-07 | Alameda | 1 | 4.5758050748 | 3.5 | 0.014 | 2.1 |
3829 | 3829 | 2021-04-06 | Alameda | 1 | 4.5758050748 | 3.5 | 0.014 | 2.1 |
3887 | 3887 | 2021-04-05 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
3945 | 3945 | 2021-04-04 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4003 | 4003 | 2021-04-03 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4061 | 4061 | 2021-04-02 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4119 | 4119 | 2021-04-01 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4177 | 4177 | 2021-03-31 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4235 | 4235 | 2021-03-30 | Alameda | 1 | 3.6521703467 | 2.6 | 0.011 | 1.9 |
4293 | 4293 | 2021-03-29 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4351 | 4351 | 2021-03-28 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4409 | 4409 | 2021-03-27 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4467 | 4467 | 2021-03-26 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4525 | 4525 | 2021-03-25 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4583 | 4583 | 2021-03-24 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4641 | 4641 | 2021-03-23 | Alameda | 1 | 4.6181736403 | 3.3 | 0.014 | 2.4 |
4699 | 4699 | 2021-03-22 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
4757 | 4757 | 2021-03-21 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
4815 | 4815 | 2021-03-20 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
4873 | 4873 | 2021-03-19 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
4931 | 4931 | 2021-03-18 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
4989 | 4989 | 2021-03-17 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
5047 | 5047 | 2021-03-16 | Alameda | 1 | 5.5502820814 | 3.6 | 0.015 | 2.4 |
5105 | 5105 | 2021-03-15 | Alameda | 1 | 7.1179190052 | 4.8 | 0.018000000000000002 | 2.6 |
5163 | 5163 | 2021-03-14 | Alameda | 1 | 7.1179190052 | 4.8 | 0.018000000000000002 | 2.6 |
5221 | 5221 | 2021-03-11 | Alameda | 1 | 7.1179190052 | 4.8 | 0.018000000000000002 | 2.6 |
5279 | 5279 | 2021-03-10 | Alameda | 1 | 7.1179190052 | 4.8 | 0.018000000000000002 | 2.6 |
5337 | 5337 | 2021-03-09 | Alameda | 1 | 7.1179190052 | 4.8 | 0.018000000000000002 | 2.6 |
5395 | 5395 | 2021-03-08 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5453 | 5453 | 2021-03-07 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5511 | 5511 | 2021-03-06 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5569 | 5569 | 2021-03-05 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5627 | 5627 | 2021-03-04 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5685 | 5685 | 2021-03-03 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
5743 | 5743 | 2021-03-02 | Alameda | 1 | 8.2110279953 | 6.3 | 0.024 | 3.7 |
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 );