cdph-race-ethnicity
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- race
- The race being tallied.
- age
- The age bracket being tallied
- confirmed_cases_total
- The cumulative number of confirmed coronavirus case amoung this race and age at that time.
- confirmed_cases_percent
- The case totals percentage of the total in this age bracket
- deaths_total
- The cumulative number of deaths case amoung this race and age at that time.
- deaths_percent
- The death totals percentage of the total in this age bracket.
- population_percent
- The race's percentage of the overall state population in this age bracket.
12,960 rows sorted by confirmed_cases_percent
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: race, age, date (date)
Link | rowid | date | race | age | confirmed_cases_total | confirmed_cases_percent ▼ | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
11313 | 11313 | 2020-07-02 | other | 0-17 | 91 | 0.006 | 0 | 0.0 | 0.044 |
11409 | 11409 | 2020-06-30 | other | 0-17 | 84 | 0.006 | 0 | 0.0 | 0.044 |
11553 | 11553 | 2020-06-26 | other | 0-17 | 72 | 0.006 | 0 | 0.0 | 0.044 |
11601 | 11601 | 2020-06-25 | other | 0-17 | 68 | 0.006 | 0 | 0.0 | 0.044 |
11649 | 11649 | 2020-06-24 | other | 0-17 | 66 | 0.006 | 0 | 0.0 | 0.044 |
11697 | 11697 | 2020-06-23 | other | 0-17 | 65 | 0.006 | 0 | 0.0 | 0.044 |
11745 | 11745 | 2020-06-22 | other | 0-17 | 63 | 0.006 | 0 | 0.0 | 0.044 |
11937 | 11937 | 2020-06-18 | other | 0-17 | 55 | 0.006 | 0 | 0.0 | 0.044 |
11985 | 11985 | 2020-06-17 | other | 0-17 | 53 | 0.006 | 0 | 0.0 | 0.044 |
12033 | 12033 | 2020-06-15 | other | 0-17 | 50 | 0.006 | 0 | 0.0 | 0.044 |
12081 | 12081 | 2020-06-14 | other | 0-17 | 49 | 0.006 | 0 | 0.0 | 0.044 |
12129 | 12129 | 2020-06-13 | other | 0-17 | 49 | 0.006 | 0 | 0.0 | 0.044 |
12225 | 12225 | 2020-06-11 | other | 0-17 | 44 | 0.006 | 0 | 0.0 | 0.044 |
11025 | 11025 | 2020-07-08 | other | 0-17 | 124 | 0.007 | 0 | 0.0 | 0.044 |
11073 | 11073 | 2020-07-07 | other | 0-17 | 113 | 0.007 | 0 | 0.0 | 0.044 |
11121 | 11121 | 2020-07-06 | other | 0-17 | 106 | 0.007 | 0 | 0.0 | 0.044 |
11169 | 11169 | 2020-07-05 | other | 0-17 | 104 | 0.007 | 0 | 0.0 | 0.044 |
11217 | 11217 | 2020-07-04 | other | 0-17 | 103 | 0.007 | 0 | 0.0 | 0.044 |
11265 | 11265 | 2020-07-03 | other | 0-17 | 98 | 0.007 | 0 | 0.0 | 0.044 |
11361 | 11361 | 2020-07-01 | other | 0-17 | 90 | 0.007 | 0 | 0.0 | 0.044 |
11457 | 11457 | 2020-06-29 | other | 0-17 | 83 | 0.007 | 0 | 0.0 | 0.044 |
11505 | 11505 | 2020-06-27 | other | 0-17 | 77 | 0.007 | 0 | 0.0 | 0.044 |
11793 | 11793 | 2020-06-21 | other | 0-17 | 63 | 0.007 | 0 | 0.0 | 0.044 |
11841 | 11841 | 2020-06-20 | other | 0-17 | 61 | 0.007 | 0 | 0.0 | 0.044 |
11889 | 11889 | 2020-06-19 | other | 0-17 | 60 | 0.007 | 0 | 0.0 | 0.044 |
12177 | 12177 | 2020-06-12 | other | 0-17 | 47 | 0.007 | 0 | 0.0 | 0.044 |
12273 | 12273 | 2020-06-10 | other | 0-17 | 44 | 0.007 | 0 | 0.0 | 0.044 |
12952 | 12952 | 2020-05-14 | other | 80+ | 28 | 0.007 | 9 | 0.006 | 0.013000000000000001 |
10455 | 10455 | 2020-07-27 | other | 80+ | 95 | 0.008 | 34 | 0.009000000000000001 | 0.013000000000000001 |
10503 | 10503 | 2020-07-25 | other | 80+ | 95 | 0.008 | 33 | 0.009000000000000001 | 0.013000000000000001 |
10545 | 10545 | 2020-07-21 | other | 0-17 | 209 | 0.008 | 0 | 0.0 | 0.044 |
10551 | 10551 | 2020-07-21 | other | 80+ | 89 | 0.008 | 31 | 0.009000000000000001 | 0.013000000000000001 |
10593 | 10593 | 2020-07-20 | other | 0-17 | 193 | 0.008 | 0 | 0.0 | 0.044 |
10599 | 10599 | 2020-07-20 | other | 80+ | 90 | 0.008 | 29 | 0.008 | 0.013000000000000001 |
10641 | 10641 | 2020-07-19 | other | 0-17 | 189 | 0.008 | 0 | 0.0 | 0.044 |
10689 | 10689 | 2020-07-18 | other | 0-17 | 185 | 0.008 | 0 | 0.0 | 0.044 |
10737 | 10737 | 2020-07-16 | other | 0-17 | 166 | 0.008 | 0 | 0.0 | 0.044 |
10785 | 10785 | 2020-07-15 | other | 0-17 | 160 | 0.008 | 0 | 0.0 | 0.044 |
10833 | 10833 | 2020-07-13 | other | 0-17 | 150 | 0.008 | 0 | 0.0 | 0.044 |
10881 | 10881 | 2020-07-12 | other | 0-17 | 149 | 0.008 | 0 | 0.0 | 0.044 |
10929 | 10929 | 2020-07-11 | other | 0-17 | 145 | 0.008 | 0 | 0.0 | 0.044 |
10977 | 10977 | 2020-07-10 | other | 0-17 | 137 | 0.008 | 0 | 0.0 | 0.044 |
11366 | 11366 | 2020-07-01 | other | 65-79 | 126 | 0.008 | 13 | 0.007 | 0.015 |
11414 | 11414 | 2020-06-30 | other | 65-79 | 121 | 0.008 | 13 | 0.007 | 0.015 |
11462 | 11462 | 2020-06-29 | other | 65-79 | 118 | 0.008 | 13 | 0.007 | 0.015 |
11510 | 11510 | 2020-06-27 | other | 65-79 | 115 | 0.008 | 14 | 0.007 | 0.015 |
11558 | 11558 | 2020-06-26 | other | 65-79 | 113 | 0.008 | 15 | 0.008 | 0.015 |
11606 | 11606 | 2020-06-25 | other | 65-79 | 113 | 0.008 | 15 | 0.008 | 0.015 |
11702 | 11702 | 2020-06-23 | other | 65-79 | 111 | 0.008 | 14 | 0.008 | 0.015 |
11750 | 11750 | 2020-06-22 | other | 65-79 | 109 | 0.008 | 13 | 0.008 | 0.015 |
12317 | 12317 | 2020-06-02 | other | 0-17 | 37 | 0.008 | 0 | 0.0 | 0.044 |
12359 | 12359 | 2020-06-01 | other | 0-17 | 35 | 0.008 | 0 | 0.0 | 0.044 |
12401 | 12401 | 2020-05-31 | other | 0-17 | 35 | 0.008 | 0 | 0.0 | 0.044 |
12443 | 12443 | 2020-05-30 | other | 0-17 | 35 | 0.008 | 0 | 0.0 | 0.044 |
12485 | 12485 | 2020-05-29 | other | 0-17 | 33 | 0.008 | 0 | 0.0 | 0.044 |
12527 | 12527 | 2020-05-28 | other | 0-17 | 31 | 0.008 | 0 | 0.0 | 0.044 |
12569 | 12569 | 2020-05-27 | other | 0-17 | 29 | 0.008 | 0 | 0.0 | 0.044 |
12910 | 12910 | 2020-05-15 | other | 80+ | 32 | 0.008 | 10 | 0.007 | 0.013000000000000001 |
9879 | 9879 | 2020-08-14 | other | 80+ | 142 | 0.009000000000000001 | 44 | 0.01 | 0.013000000000000001 |
9927 | 9927 | 2020-08-13 | other | 80+ | 140 | 0.009000000000000001 | 43 | 0.01 | 0.013000000000000001 |
9975 | 9975 | 2020-08-12 | other | 80+ | 137 | 0.009000000000000001 | 43 | 0.01 | 0.013000000000000001 |
10071 | 10071 | 2020-08-10 | other | 80+ | 135 | 0.009000000000000001 | 42 | 0.01 | 0.013000000000000001 |
10161 | 10161 | 2020-08-08 | other | 0-17 | 328 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
10310 | 10310 | 2020-08-04 | other | 65-79 | 262 | 0.009000000000000001 | 26 | 0.009000000000000001 | 0.015 |
10358 | 10358 | 2020-08-03 | other | 65-79 | 257 | 0.009000000000000001 | 24 | 0.008 | 0.015 |
10406 | 10406 | 2020-07-30 | other | 65-79 | 245 | 0.009000000000000001 | 25 | 0.009000000000000001 | 0.015 |
10407 | 10407 | 2020-07-30 | other | 80+ | 111 | 0.009000000000000001 | 38 | 0.01 | 0.013000000000000001 |
10449 | 10449 | 2020-07-27 | other | 0-17 | 250 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
10453 | 10453 | 2020-07-27 | other | 50-64 | 582 | 0.009000000000000001 | 10 | 0.007 | 0.017 |
10454 | 10454 | 2020-07-27 | other | 65-79 | 218 | 0.009000000000000001 | 23 | 0.009000000000000001 | 0.015 |
10497 | 10497 | 2020-07-25 | other | 0-17 | 236 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
10501 | 10501 | 2020-07-25 | other | 50-64 | 563 | 0.009000000000000001 | 8 | 0.005 | 0.017 |
10502 | 10502 | 2020-07-25 | other | 65-79 | 214 | 0.009000000000000001 | 23 | 0.009000000000000001 | 0.015 |
10546 | 10546 | 2020-07-21 | other | 18+ | 2420 | 0.009000000000000001 | 70 | 0.009000000000000001 | 0.022 |
10549 | 10549 | 2020-07-21 | other | 50-64 | 512 | 0.009000000000000001 | 8 | 0.005 | 0.017 |
10550 | 10550 | 2020-07-21 | other | 65-79 | 205 | 0.009000000000000001 | 22 | 0.009000000000000001 | 0.015 |
10552 | 10552 | 2020-07-21 | other | all | 2630 | 0.009000000000000001 | 70 | 0.009000000000000001 | 0.027 |
10594 | 10594 | 2020-07-20 | other | 18+ | 2298 | 0.009000000000000001 | 66 | 0.008 | 0.022 |
10597 | 10597 | 2020-07-20 | other | 50-64 | 489 | 0.009000000000000001 | 8 | 0.007 | 0.017 |
10598 | 10598 | 2020-07-20 | other | 65-79 | 197 | 0.009000000000000001 | 21 | 0.009000000000000001 | 0.015 |
10600 | 10600 | 2020-07-20 | other | all | 2492 | 0.009000000000000001 | 66 | 0.008 | 0.027 |
10644 | 10644 | 2020-07-19 | other | 35-49 | 602 | 0.009000000000000001 | 6 | 0.014 | 0.021 |
10645 | 10645 | 2020-07-19 | other | 50-64 | 482 | 0.009000000000000001 | 8 | 0.007 | 0.017 |
10646 | 10646 | 2020-07-19 | other | 65-79 | 196 | 0.009000000000000001 | 21 | 0.009000000000000001 | 0.015 |
10647 | 10647 | 2020-07-19 | other | 80+ | 91 | 0.009000000000000001 | 29 | 0.008 | 0.013000000000000001 |
10648 | 10648 | 2020-07-19 | other | all | 2453 | 0.009000000000000001 | 66 | 0.008 | 0.027 |
10690 | 10690 | 2020-07-18 | other | 18+ | 2206 | 0.009000000000000001 | 66 | 0.008 | 0.022 |
10692 | 10692 | 2020-07-18 | other | 35-49 | 582 | 0.009000000000000001 | 6 | 0.014 | 0.021 |
10693 | 10693 | 2020-07-18 | other | 50-64 | 474 | 0.009000000000000001 | 8 | 0.007 | 0.017 |
10694 | 10694 | 2020-07-18 | other | 65-79 | 196 | 0.009000000000000001 | 21 | 0.009000000000000001 | 0.015 |
10695 | 10695 | 2020-07-18 | other | 80+ | 91 | 0.009000000000000001 | 29 | 0.008 | 0.013000000000000001 |
10696 | 10696 | 2020-07-18 | other | all | 2392 | 0.009000000000000001 | 66 | 0.008 | 0.027 |
10738 | 10738 | 2020-07-16 | other | 18+ | 2083 | 0.009000000000000001 | 67 | 0.009000000000000001 | 0.022 |
10740 | 10740 | 2020-07-16 | other | 35-49 | 550 | 0.009000000000000001 | 6 | 0.016 | 0.021 |
10741 | 10741 | 2020-07-16 | other | 50-64 | 457 | 0.009000000000000001 | 8 | 0.007 | 0.017 |
10742 | 10742 | 2020-07-16 | other | 65-79 | 187 | 0.009000000000000001 | 21 | 0.009000000000000001 | 0.015 |
10743 | 10743 | 2020-07-16 | other | 80+ | 91 | 0.009000000000000001 | 30 | 0.009000000000000001 | 0.013000000000000001 |
10744 | 10744 | 2020-07-16 | other | all | 2251 | 0.009000000000000001 | 67 | 0.009000000000000001 | 0.027 |
10786 | 10786 | 2020-07-15 | other | 18+ | 2016 | 0.009000000000000001 | 66 | 0.01 | 0.022 |
10788 | 10788 | 2020-07-15 | other | 35-49 | 530 | 0.009000000000000001 | 6 | 0.016 | 0.021 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-race-ethnicity" ( [date] TEXT, [race] TEXT, [age] TEXT, [confirmed_cases_total] INTEGER, [confirmed_cases_percent] FLOAT, [deaths_total] INTEGER, [deaths_percent] FLOAT, [population_percent] FLOAT );