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_total
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 |
---|---|---|---|---|---|---|---|---|---|
12905 | 12905 | 2020-05-15 | other | 0-17 | 20 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12947 | 12947 | 2020-05-14 | other | 0-17 | 20 | 0.011 | 0 | 0.0 | 0.044 |
12863 | 12863 | 2020-05-16 | other | 0-17 | 21 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12821 | 12821 | 2020-05-17 | other | 0-17 | 22 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12779 | 12779 | 2020-05-18 | other | 0-17 | 23 | 0.01 | 0 | 0.0 | 0.044 |
12737 | 12737 | 2020-05-19 | other | 0-17 | 24 | 0.01 | 0 | 0.0 | 0.044 |
12611 | 12611 | 2020-05-22 | other | 0-17 | 25 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12653 | 12653 | 2020-05-21 | other | 0-17 | 25 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12695 | 12695 | 2020-05-20 | other | 0-17 | 25 | 0.01 | 0 | 0.0 | 0.044 |
12952 | 12952 | 2020-05-14 | other | 80+ | 28 | 0.007 | 9 | 0.006 | 0.013000000000000001 |
12569 | 12569 | 2020-05-27 | other | 0-17 | 29 | 0.008 | 0 | 0.0 | 0.044 |
12527 | 12527 | 2020-05-28 | other | 0-17 | 31 | 0.008 | 0 | 0.0 | 0.044 |
12910 | 12910 | 2020-05-15 | other | 80+ | 32 | 0.008 | 10 | 0.007 | 0.013000000000000001 |
12485 | 12485 | 2020-05-29 | other | 0-17 | 33 | 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 |
12317 | 12317 | 2020-06-02 | other | 0-17 | 37 | 0.008 | 0 | 0.0 | 0.044 |
12868 | 12868 | 2020-05-16 | other | 80+ | 37 | 0.009000000000000001 | 13 | 0.009000000000000001 | 0.013000000000000001 |
12784 | 12784 | 2020-05-18 | other | 80+ | 38 | 0.009000000000000001 | 13 | 0.008 | 0.013000000000000001 |
12826 | 12826 | 2020-05-17 | other | 80+ | 38 | 0.009000000000000001 | 13 | 0.008 | 0.013000000000000001 |
12742 | 12742 | 2020-05-19 | other | 80+ | 39 | 0.009000000000000001 | 14 | 0.009000000000000001 | 0.013000000000000001 |
12700 | 12700 | 2020-05-20 | other | 80+ | 41 | 0.009000000000000001 | 15 | 0.009000000000000001 | 0.013000000000000001 |
12658 | 12658 | 2020-05-21 | other | 80+ | 42 | 0.009000000000000001 | 16 | 0.01 | 0.013000000000000001 |
12574 | 12574 | 2020-05-27 | other | 80+ | 43 | 0.009000000000000001 | 17 | 0.009000000000000001 | 0.013000000000000001 |
12616 | 12616 | 2020-05-22 | other | 80+ | 43 | 0.01 | 16 | 0.01 | 0.013000000000000001 |
12225 | 12225 | 2020-06-11 | other | 0-17 | 44 | 0.006 | 0 | 0.0 | 0.044 |
12273 | 12273 | 2020-06-10 | other | 0-17 | 44 | 0.007 | 0 | 0.0 | 0.044 |
12532 | 12532 | 2020-05-28 | other | 80+ | 44 | 0.009000000000000001 | 17 | 0.009000000000000001 | 0.013000000000000001 |
12926 | 12926 | 2020-05-14 | black | 0-17 | 44 | 0.023 | 0 | 0.0 | 0.054 |
12490 | 12490 | 2020-05-29 | other | 80+ | 45 | 0.009000000000000001 | 17 | 0.009000000000000001 | 0.013000000000000001 |
12177 | 12177 | 2020-06-12 | other | 0-17 | 47 | 0.007 | 0 | 0.0 | 0.044 |
12448 | 12448 | 2020-05-30 | other | 80+ | 47 | 0.009000000000000001 | 18 | 0.01 | 0.013000000000000001 |
12884 | 12884 | 2020-05-15 | black | 0-17 | 47 | 0.023 | 0 | 0.0 | 0.054 |
12406 | 12406 | 2020-05-31 | other | 80+ | 48 | 0.009000000000000001 | 18 | 0.009000000000000001 | 0.013000000000000001 |
12842 | 12842 | 2020-05-16 | black | 0-17 | 48 | 0.022 | 0 | 0.0 | 0.054 |
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 |
12800 | 12800 | 2020-05-17 | black | 0-17 | 49 | 0.022 | 0 | 0.0 | 0.054 |
12033 | 12033 | 2020-06-15 | other | 0-17 | 50 | 0.006 | 0 | 0.0 | 0.044 |
12364 | 12364 | 2020-06-01 | other | 80+ | 50 | 0.009000000000000001 | 18 | 0.009000000000000001 | 0.013000000000000001 |
12322 | 12322 | 2020-06-02 | other | 80+ | 51 | 0.009000000000000001 | 18 | 0.009000000000000001 | 0.013000000000000001 |
12758 | 12758 | 2020-05-18 | black | 0-17 | 51 | 0.022 | 0 | 0.0 | 0.054 |
11985 | 11985 | 2020-06-17 | other | 0-17 | 53 | 0.006 | 0 | 0.0 | 0.044 |
12716 | 12716 | 2020-05-19 | black | 0-17 | 54 | 0.022 | 0 | 0.0 | 0.054 |
11937 | 11937 | 2020-06-18 | other | 0-17 | 55 | 0.006 | 0 | 0.0 | 0.044 |
12674 | 12674 | 2020-05-20 | black | 0-17 | 56 | 0.021 | 0 | 0.0 | 0.054 |
12279 | 12279 | 2020-06-10 | other | 80+ | 58 | 0.009000000000000001 | 22 | 0.01 | 0.013000000000000001 |
11889 | 11889 | 2020-06-19 | other | 0-17 | 60 | 0.007 | 0 | 0.0 | 0.044 |
12231 | 12231 | 2020-06-11 | other | 80+ | 60 | 0.01 | 23 | 0.011 | 0.013000000000000001 |
12632 | 12632 | 2020-05-21 | black | 0-17 | 60 | 0.022 | 0 | 0.0 | 0.054 |
11841 | 11841 | 2020-06-20 | other | 0-17 | 61 | 0.007 | 0 | 0.0 | 0.044 |
11745 | 11745 | 2020-06-22 | other | 0-17 | 63 | 0.006 | 0 | 0.0 | 0.044 |
11793 | 11793 | 2020-06-21 | other | 0-17 | 63 | 0.007 | 0 | 0.0 | 0.044 |
12183 | 12183 | 2020-06-12 | other | 80+ | 63 | 0.01 | 23 | 0.01 | 0.013000000000000001 |
12590 | 12590 | 2020-05-22 | black | 0-17 | 63 | 0.022 | 0 | 0.0 | 0.054 |
11991 | 11991 | 2020-06-17 | other | 80+ | 64 | 0.01 | 24 | 0.01 | 0.013000000000000001 |
11697 | 11697 | 2020-06-23 | other | 0-17 | 65 | 0.006 | 0 | 0.0 | 0.044 |
12039 | 12039 | 2020-06-15 | other | 80+ | 65 | 0.01 | 25 | 0.011 | 0.013000000000000001 |
12087 | 12087 | 2020-06-14 | other | 80+ | 65 | 0.01 | 25 | 0.011 | 0.013000000000000001 |
12135 | 12135 | 2020-06-13 | other | 80+ | 65 | 0.01 | 24 | 0.01 | 0.013000000000000001 |
11649 | 11649 | 2020-06-24 | other | 0-17 | 66 | 0.006 | 0 | 0.0 | 0.044 |
11943 | 11943 | 2020-06-18 | other | 80+ | 66 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
12951 | 12951 | 2020-05-14 | other | 65-79 | 66 | 0.01 | 10 | 0.01 | 0.015 |
11601 | 11601 | 2020-06-25 | other | 0-17 | 68 | 0.006 | 0 | 0.0 | 0.044 |
11655 | 11655 | 2020-06-24 | other | 80+ | 68 | 0.009000000000000001 | 24 | 0.009000000000000001 | 0.013000000000000001 |
11847 | 11847 | 2020-06-20 | other | 80+ | 68 | 0.01 | 24 | 0.01 | 0.013000000000000001 |
11895 | 11895 | 2020-06-19 | other | 80+ | 68 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
11415 | 11415 | 2020-06-30 | other | 80+ | 69 | 0.009000000000000001 | 20 | 0.007 | 0.013000000000000001 |
11463 | 11463 | 2020-06-29 | other | 80+ | 69 | 0.009000000000000001 | 20 | 0.007 | 0.013000000000000001 |
11607 | 11607 | 2020-06-25 | other | 80+ | 69 | 0.009000000000000001 | 24 | 0.009000000000000001 | 0.013000000000000001 |
11703 | 11703 | 2020-06-23 | other | 80+ | 69 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
11751 | 11751 | 2020-06-22 | other | 80+ | 69 | 0.01 | 24 | 0.01 | 0.013000000000000001 |
11799 | 11799 | 2020-06-21 | other | 80+ | 69 | 0.01 | 24 | 0.01 | 0.013000000000000001 |
11511 | 11511 | 2020-06-27 | other | 80+ | 71 | 0.009000000000000001 | 23 | 0.009000000000000001 | 0.013000000000000001 |
12548 | 12548 | 2020-05-27 | black | 0-17 | 71 | 0.019 | 0 | 0.0 | 0.054 |
11367 | 11367 | 2020-07-01 | other | 80+ | 72 | 0.01 | 21 | 0.007 | 0.013000000000000001 |
11553 | 11553 | 2020-06-26 | other | 0-17 | 72 | 0.006 | 0 | 0.0 | 0.044 |
11559 | 11559 | 2020-06-26 | other | 80+ | 72 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
12909 | 12909 | 2020-05-15 | other | 65-79 | 72 | 0.011 | 12 | 0.012 | 0.015 |
12867 | 12867 | 2020-05-16 | other | 65-79 | 73 | 0.01 | 12 | 0.012 | 0.015 |
12506 | 12506 | 2020-05-28 | black | 0-17 | 74 | 0.019 | 0 | 0.0 | 0.054 |
12825 | 12825 | 2020-05-17 | other | 65-79 | 75 | 0.011 | 13 | 0.013000000000000001 | 0.015 |
12783 | 12783 | 2020-05-18 | other | 65-79 | 76 | 0.011 | 13 | 0.013000000000000001 | 0.015 |
11505 | 11505 | 2020-06-27 | other | 0-17 | 77 | 0.007 | 0 | 0.0 | 0.044 |
12741 | 12741 | 2020-05-19 | other | 65-79 | 77 | 0.011 | 14 | 0.013000000000000001 | 0.015 |
12657 | 12657 | 2020-05-21 | other | 65-79 | 78 | 0.01 | 13 | 0.011 | 0.015 |
12699 | 12699 | 2020-05-20 | other | 65-79 | 78 | 0.011 | 13 | 0.012 | 0.015 |
11271 | 11271 | 2020-07-03 | other | 80+ | 79 | 0.009000000000000001 | 26 | 0.01 | 0.013000000000000001 |
11319 | 11319 | 2020-07-02 | other | 80+ | 79 | 0.01 | 26 | 0.01 | 0.013000000000000001 |
12615 | 12615 | 2020-05-22 | other | 65-79 | 79 | 0.01 | 13 | 0.011 | 0.015 |
11127 | 11127 | 2020-07-06 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.012 |
11175 | 11175 | 2020-07-05 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.012 |
11223 | 11223 | 2020-07-04 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.013000000000000001 |
12464 | 12464 | 2020-05-29 | black | 0-17 | 80 | 0.02 | 0 | 0.0 | 0.054 |
12919 | 12919 | 2020-05-14 | asian | 0-17 | 80 | 0.042 | 0 | 0.0 | 0.13 |
12296 | 12296 | 2020-06-02 | black | 0-17 | 82 | 0.017 | 0 | 0.0 | 0.054 |
12338 | 12338 | 2020-06-01 | black | 0-17 | 82 | 0.018000000000000002 | 0 | 0.0 | 0.054 |
12380 | 12380 | 2020-05-31 | black | 0-17 | 82 | 0.018000000000000002 | 0 | 0.0 | 0.054 |
12422 | 12422 | 2020-05-30 | black | 0-17 | 82 | 0.019 | 0 | 0.0 | 0.054 |
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 );