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 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 |
---|---|---|---|---|---|---|---|---|
1554 | 1554 | 2021-05-20 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1561 | 1561 | 2021-05-20 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1568 | 1568 | 2021-05-19 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1612 | 1612 | 2021-05-19 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1619 | 1619 | 2021-05-19 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1626 | 1626 | 2021-05-18 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1670 | 1670 | 2021-05-18 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
1677 | 1677 | 2021-05-18 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1684 | 1684 | 2021-05-17 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1735 | 1735 | 2021-05-17 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1742 | 1742 | 2021-05-16 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1793 | 1793 | 2021-05-16 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1800 | 1800 | 2021-05-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1851 | 1851 | 2021-05-15 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1858 | 1858 | 2021-05-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1909 | 1909 | 2021-05-14 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1916 | 1916 | 2021-05-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
1967 | 1967 | 2021-05-13 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
1974 | 1974 | 2021-05-12 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2025 | 2025 | 2021-05-12 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2032 | 2032 | 2021-05-11 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2083 | 2083 | 2021-05-11 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2113 | 2113 | 2021-05-10 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2134 | 2134 | 2021-05-10 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2141 | 2141 | 2021-05-10 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2171 | 2171 | 2021-05-09 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2192 | 2192 | 2021-05-09 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2199 | 2199 | 2021-05-09 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2229 | 2229 | 2021-05-08 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2250 | 2250 | 2021-05-08 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2257 | 2257 | 2021-05-08 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2287 | 2287 | 2021-05-07 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2308 | 2308 | 2021-05-07 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2315 | 2315 | 2021-05-07 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2345 | 2345 | 2021-05-06 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2366 | 2366 | 2021-05-06 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2373 | 2373 | 2021-05-06 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2403 | 2403 | 2021-05-05 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2424 | 2424 | 2021-05-05 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2431 | 2431 | 2021-05-05 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2461 | 2461 | 2021-05-04 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
2482 | 2482 | 2021-05-04 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2489 | 2489 | 2021-05-04 | Trinity | 105 | 0.0 | 0.0 | 0.0 | |
2496 | 2496 | 2021-05-03 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2508 | 2508 | 2021-05-03 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2540 | 2540 | 2021-05-03 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2547 | 2547 | 2021-05-03 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2554 | 2554 | 2021-05-02 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2566 | 2566 | 2021-05-02 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2598 | 2598 | 2021-05-02 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2605 | 2605 | 2021-05-02 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2612 | 2612 | 2021-05-01 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2624 | 2624 | 2021-05-01 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2656 | 2656 | 2021-05-01 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2663 | 2663 | 2021-05-01 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2670 | 2670 | 2021-04-30 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2682 | 2682 | 2021-04-30 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2714 | 2714 | 2021-04-30 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2721 | 2721 | 2021-04-30 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2728 | 2728 | 2021-04-29 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2740 | 2740 | 2021-04-29 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2772 | 2772 | 2021-04-29 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2779 | 2779 | 2021-04-29 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2786 | 2786 | 2021-04-28 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2798 | 2798 | 2021-04-28 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2830 | 2830 | 2021-04-28 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2837 | 2837 | 2021-04-28 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2844 | 2844 | 2021-04-27 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2856 | 2856 | 2021-04-27 | Inyo | 27 | 0.0 | 0.0 | 0.012 | |
2888 | 2888 | 2021-04-27 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2895 | 2895 | 2021-04-27 | Trinity | 105 | 0.0 | 0.0 | 0.013000000000000001 | |
2902 | 2902 | 2021-04-26 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2946 | 2946 | 2021-04-26 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2960 | 2960 | 2021-04-25 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3004 | 3004 | 2021-04-25 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3018 | 3018 | 2021-04-24 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3062 | 3062 | 2021-04-24 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3076 | 3076 | 2021-04-23 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3120 | 3120 | 2021-04-23 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3134 | 3134 | 2021-04-22 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3178 | 3178 | 2021-04-22 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3192 | 3192 | 2021-04-21 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3236 | 3236 | 2021-04-21 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3250 | 3250 | 2021-04-20 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3294 | 3294 | 2021-04-20 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3308 | 3308 | 2021-04-19 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3352 | 3352 | 2021-04-19 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3366 | 3366 | 2021-04-18 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3410 | 3410 | 2021-04-18 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3424 | 3424 | 2021-04-17 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3468 | 3468 | 2021-04-17 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3482 | 3482 | 2021-04-16 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3526 | 3526 | 2021-04-16 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3540 | 3540 | 2021-04-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3584 | 3584 | 2021-04-15 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3598 | 3598 | 2021-04-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3642 | 3642 | 2021-04-14 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3656 | 3656 | 2021-04-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3700 | 3700 | 2021-04-13 | Sierra | 91 | 0.0 | 0.0 | 0.022 | |
3758 | 3758 | 2021-04-08 | Sierra | 91 | 0.0 | 0.0 | 0.0 |
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 );