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 positivity_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 |
---|---|---|---|---|---|---|---|---|
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 | |
2526 | 2526 | 2021-05-03 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2540 | 2540 | 2021-05-03 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2554 | 2554 | 2021-05-02 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2584 | 2584 | 2021-05-02 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2598 | 2598 | 2021-05-02 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2612 | 2612 | 2021-05-01 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2642 | 2642 | 2021-05-01 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2656 | 2656 | 2021-05-01 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2670 | 2670 | 2021-04-30 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2700 | 2700 | 2021-04-30 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2714 | 2714 | 2021-04-30 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2728 | 2728 | 2021-04-29 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2758 | 2758 | 2021-04-29 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2772 | 2772 | 2021-04-29 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2786 | 2786 | 2021-04-28 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2816 | 2816 | 2021-04-28 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2830 | 2830 | 2021-04-28 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2844 | 2844 | 2021-04-27 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2874 | 2874 | 2021-04-27 | Plumas | 63 | 3.7599921792 | 3.8 | 0.0 | |
2888 | 2888 | 2021-04-27 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
2902 | 2902 | 2021-04-26 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
2925 | 2925 | 2021-04-26 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
2983 | 2983 | 2021-04-25 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3041 | 3041 | 2021-04-24 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3099 | 3099 | 2021-04-23 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3157 | 3157 | 2021-04-22 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3215 | 3215 | 2021-04-21 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3273 | 3273 | 2021-04-20 | Modoc | 49 | 4.5231813041999995 | 4.5 | 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 | |
3366 | 3366 | 2021-04-18 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3424 | 3424 | 2021-04-17 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3482 | 3482 | 2021-04-16 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3540 | 3540 | 2021-04-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3598 | 3598 | 2021-04-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3656 | 3656 | 2021-04-13 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
3758 | 3758 | 2021-04-08 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3816 | 3816 | 2021-04-07 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3874 | 3874 | 2021-04-06 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
3911 | 3911 | 2021-04-05 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
3969 | 3969 | 2021-04-04 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4027 | 4027 | 2021-04-03 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4085 | 4085 | 2021-04-02 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4143 | 4143 | 2021-04-01 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4201 | 4201 | 2021-03-31 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4259 | 4259 | 2021-03-30 | Modoc | 49 | 0.0 | 0.0 | 0.0 | |
4294 | 4294 | 2021-03-29 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4352 | 4352 | 2021-03-28 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4410 | 4410 | 2021-03-27 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4468 | 4468 | 2021-03-26 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4526 | 4526 | 2021-03-25 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4584 | 4584 | 2021-03-24 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
4642 | 4642 | 2021-03-23 | Alpine | 3 | 12.7893592531 | 12.8 | 0.0 | |
5106 | 5106 | 2021-03-15 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5150 | 5150 | 2021-03-15 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
5164 | 5164 | 2021-03-14 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5208 | 5208 | 2021-03-14 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
5222 | 5222 | 2021-03-11 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5266 | 5266 | 2021-03-11 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
5280 | 5280 | 2021-03-10 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5324 | 5324 | 2021-03-10 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
5338 | 5338 | 2021-03-09 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5382 | 5382 | 2021-03-09 | Sierra | 91 | 0.0 | 0.0 | 0.0 | |
5396 | 5396 | 2021-03-08 | Alpine | 3 | 0.0 | 0.0 | 0.0 | |
5419 | 5419 | 2021-03-08 | Modoc | 49 | 1.5077271014 | 1.5 | 0.0 | |
5454 | 5454 | 2021-03-07 | Alpine | 3 | 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 );