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.
2,160 rows where race = "black" sorted by deaths_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: age, population_percent, date (date)
Link | rowid | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total ▼ | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
4857 | 4857 | 2020-12-16 | black | 0-17 | 4296 | 0.028 | 0 | 0.0 | 0.054 |
4905 | 4905 | 2020-12-15 | black | 0-17 | 4117 | 0.028 | 0 | 0.0 | 0.054 |
4953 | 4953 | 2020-12-14 | black | 0-17 | 3957 | 0.028 | 0 | 0.0 | 0.054 |
5001 | 5001 | 2020-12-13 | black | 0-17 | 3863 | 0.028 | 0 | 0.0 | 0.054 |
5049 | 5049 | 2020-12-12 | black | 0-17 | 3785 | 0.028 | 0 | 0.0 | 0.054 |
5097 | 5097 | 2020-12-11 | black | 0-17 | 3686 | 0.028 | 0 | 0.0 | 0.054 |
5145 | 5145 | 2020-12-10 | black | 0-17 | 3567 | 0.028 | 0 | 0.0 | 0.054 |
5193 | 5193 | 2020-12-09 | black | 0-17 | 3435 | 0.028 | 0 | 0.0 | 0.054 |
5241 | 5241 | 2020-12-08 | black | 0-17 | 3359 | 0.028 | 0 | 0.0 | 0.054 |
5289 | 5289 | 2020-12-07 | black | 0-17 | 3279 | 0.028 | 0 | 0.0 | 0.054 |
5337 | 5337 | 2020-12-06 | black | 0-17 | 3229 | 0.028 | 0 | 0.0 | 0.054 |
5385 | 5385 | 2020-12-05 | black | 0-17 | 3141 | 0.028 | 0 | 0.0 | 0.054 |
5433 | 5433 | 2020-12-04 | black | 0-17 | 3060 | 0.028 | 0 | 0.0 | 0.054 |
5481 | 5481 | 2020-12-03 | black | 0-17 | 2981 | 0.028 | 0 | 0.0 | 0.054 |
5529 | 5529 | 2020-12-02 | black | 0-17 | 2934 | 0.028 | 0 | 0.0 | 0.054 |
5577 | 5577 | 2020-12-01 | black | 0-17 | 2886 | 0.028 | 0 | 0.0 | 0.054 |
5625 | 5625 | 2020-11-30 | black | 0-17 | 2824 | 0.028 | 0 | 0.0 | 0.054 |
5673 | 5673 | 2020-11-29 | black | 0-17 | 2784 | 0.028 | 0 | 0.0 | 0.054 |
5721 | 5721 | 2020-11-28 | black | 0-17 | 2753 | 0.028 | 0 | 0.0 | 0.054 |
5769 | 5769 | 2020-11-27 | black | 0-17 | 2720 | 0.028 | 0 | 0.0 | 0.054 |
5817 | 5817 | 2020-11-26 | black | 0-17 | 2692 | 0.028 | 0 | 0.0 | 0.054 |
5865 | 5865 | 2020-11-25 | black | 0-17 | 2653 | 0.028 | 0 | 0.0 | 0.054 |
5913 | 5913 | 2020-11-24 | black | 0-17 | 2617 | 0.028 | 0 | 0.0 | 0.054 |
5961 | 5961 | 2020-11-23 | black | 0-17 | 2555 | 0.028 | 0 | 0.0 | 0.054 |
6009 | 6009 | 2020-11-22 | black | 0-17 | 2525 | 0.028 | 0 | 0.0 | 0.054 |
6057 | 6057 | 2020-11-20 | black | 0-17 | 2460 | 0.028 | 0 | 0.0 | 0.054 |
6105 | 6105 | 2020-11-19 | black | 0-17 | 2429 | 0.028 | 0 | 0.0 | 0.054 |
6153 | 6153 | 2020-11-18 | black | 0-17 | 2379 | 0.028 | 0 | 0.0 | 0.054 |
6201 | 6201 | 2020-11-17 | black | 0-17 | 2353 | 0.028 | 0 | 0.0 | 0.054 |
6249 | 6249 | 2020-11-16 | black | 0-17 | 2328 | 0.028 | 0 | 0.0 | 0.054 |
6297 | 6297 | 2020-11-15 | black | 0-17 | 2293 | 0.028 | 0 | 0.0 | 0.054 |
6345 | 6345 | 2020-11-14 | black | 0-17 | 2270 | 0.028 | 0 | 0.0 | 0.054 |
6393 | 6393 | 2020-11-13 | black | 0-17 | 2227 | 0.028 | 0 | 0.0 | 0.054 |
6441 | 6441 | 2020-11-12 | black | 0-17 | 2202 | 0.027 | 0 | 0.0 | 0.054 |
6489 | 6489 | 2020-11-11 | black | 0-17 | 2175 | 0.027 | 0 | 0.0 | 0.054 |
6537 | 6537 | 2020-11-10 | black | 0-17 | 2141 | 0.027 | 0 | 0.0 | 0.054 |
6585 | 6585 | 2020-11-09 | black | 0-17 | 2122 | 0.027 | 0 | 0.0 | 0.054 |
6633 | 6633 | 2020-11-08 | black | 0-17 | 2102 | 0.027 | 0 | 0.0 | 0.054 |
6681 | 6681 | 2020-11-05 | black | 0-17 | 2038 | 0.027 | 0 | 0.0 | 0.054 |
6729 | 6729 | 2020-11-04 | black | 0-17 | 2012 | 0.027 | 0 | 0.0 | 0.054 |
6777 | 6777 | 2020-11-03 | black | 0-17 | 2008 | 0.027 | 0 | 0.0 | 0.054 |
6825 | 6825 | 2020-11-02 | black | 0-17 | 1998 | 0.027 | 0 | 0.0 | 0.054 |
6873 | 6873 | 2020-11-01 | black | 0-17 | 1985 | 0.027 | 0 | 0.0 | 0.054 |
6921 | 6921 | 2020-10-31 | black | 0-17 | 1969 | 0.027 | 0 | 0.0 | 0.054 |
6969 | 6969 | 2020-10-29 | black | 0-17 | 1944 | 0.027 | 0 | 0.0 | 0.054 |
7017 | 7017 | 2020-10-28 | black | 0-17 | 1930 | 0.027 | 0 | 0.0 | 0.054 |
7065 | 7065 | 2020-10-27 | black | 0-17 | 1920 | 0.027 | 0 | 0.0 | 0.054 |
7113 | 7113 | 2020-10-26 | black | 0-17 | 1910 | 0.027 | 0 | 0.0 | 0.054 |
7161 | 7161 | 2020-10-25 | black | 0-17 | 1899 | 0.027 | 0 | 0.0 | 0.054 |
7209 | 7209 | 2020-10-23 | black | 0-17 | 1879 | 0.027 | 0 | 0.0 | 0.054 |
7257 | 7257 | 2020-10-21 | black | 0-17 | 1862 | 0.027 | 0 | 0.0 | 0.054 |
7305 | 7305 | 2020-10-20 | black | 0-17 | 1842 | 0.027 | 0 | 0.0 | 0.054 |
7353 | 7353 | 2020-10-19 | black | 0-17 | 1837 | 0.027 | 0 | 0.0 | 0.054 |
7401 | 7401 | 2020-10-18 | black | 0-17 | 1828 | 0.027 | 0 | 0.0 | 0.054 |
7449 | 7449 | 2020-10-17 | black | 0-17 | 1811 | 0.027 | 0 | 0.0 | 0.054 |
7497 | 7497 | 2020-10-15 | black | 0-17 | 1793 | 0.027 | 0 | 0.0 | 0.054 |
7545 | 7545 | 2020-10-14 | black | 0-17 | 1770 | 0.027 | 0 | 0.0 | 0.054 |
7593 | 7593 | 2020-10-13 | black | 0-17 | 1763 | 0.027 | 0 | 0.0 | 0.054 |
7641 | 7641 | 2020-10-12 | black | 0-17 | 1762 | 0.027 | 0 | 0.0 | 0.054 |
7689 | 7689 | 2020-10-11 | black | 0-17 | 1756 | 0.027 | 0 | 0.0 | 0.054 |
7737 | 7737 | 2020-10-10 | black | 0-17 | 1747 | 0.027 | 0 | 0.0 | 0.054 |
7785 | 7785 | 2020-10-09 | black | 0-17 | 1732 | 0.027 | 0 | 0.0 | 0.054 |
7833 | 7833 | 2020-10-08 | black | 0-17 | 1727 | 0.027 | 0 | 0.0 | 0.054 |
7881 | 7881 | 2020-10-07 | black | 0-17 | 1715 | 0.027 | 0 | 0.0 | 0.054 |
7929 | 7929 | 2020-10-06 | black | 0-17 | 1707 | 0.027 | 0 | 0.0 | 0.054 |
7977 | 7977 | 2020-10-05 | black | 0-17 | 1698 | 0.027 | 0 | 0.0 | 0.054 |
8025 | 8025 | 2020-10-04 | black | 0-17 | 1692 | 0.027 | 0 | 0.0 | 0.054 |
8073 | 8073 | 2020-10-03 | black | 0-17 | 1677 | 0.027 | 0 | 0.0 | 0.054 |
8121 | 8121 | 2020-10-02 | black | 0-17 | 1665 | 0.027 | 0 | 0.0 | 0.054 |
8169 | 8169 | 2020-10-01 | black | 0-17 | 1660 | 0.027 | 0 | 0.0 | 0.054 |
8217 | 8217 | 2020-09-30 | black | 0-17 | 1644 | 0.027 | 0 | 0.0 | 0.054 |
8265 | 8265 | 2020-09-29 | black | 0-17 | 1633 | 0.027 | 0 | 0.0 | 0.054 |
8313 | 8313 | 2020-09-28 | black | 0-17 | 1617 | 0.027 | 0 | 0.0 | 0.054 |
8361 | 8361 | 2020-09-27 | black | 0-17 | 1612 | 0.027 | 0 | 0.0 | 0.054 |
8409 | 8409 | 2020-09-26 | black | 0-17 | 1605 | 0.027 | 0 | 0.0 | 0.054 |
8457 | 8457 | 2020-09-25 | black | 0-17 | 1594 | 0.027 | 0 | 0.0 | 0.054 |
8505 | 8505 | 2020-09-24 | black | 0-17 | 1568 | 0.027 | 0 | 0.0 | 0.054 |
8553 | 8553 | 2020-09-23 | black | 0-17 | 1551 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
8601 | 8601 | 2020-09-22 | black | 0-17 | 1542 | 0.027 | 0 | 0.0 | 0.054 |
8649 | 8649 | 2020-09-21 | black | 0-17 | 1523 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
8697 | 8697 | 2020-09-20 | black | 0-17 | 1524 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
8745 | 8745 | 2020-09-19 | black | 0-17 | 1517 | 0.027 | 0 | 0.0 | 0.054 |
8793 | 8793 | 2020-09-17 | black | 0-17 | 1494 | 0.027 | 0 | 0.0 | 0.054 |
8841 | 8841 | 2020-09-16 | black | 0-17 | 1483 | 0.027 | 0 | 0.0 | 0.054 |
8889 | 8889 | 2020-09-15 | black | 0-17 | 1468 | 0.027 | 0 | 0.0 | 0.054 |
8937 | 8937 | 2020-09-14 | black | 0-17 | 1458 | 0.027 | 0 | 0.0 | 0.054 |
8985 | 8985 | 2020-09-13 | black | 0-17 | 1451 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9033 | 9033 | 2020-09-12 | black | 0-17 | 1443 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9081 | 9081 | 2020-09-11 | black | 0-17 | 1419 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9129 | 9129 | 2020-09-10 | black | 0-17 | 1411 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9177 | 9177 | 2020-09-09 | black | 0-17 | 1402 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9225 | 9225 | 2020-09-08 | black | 0-17 | 1386 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9273 | 9273 | 2020-09-06 | black | 0-17 | 1364 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9321 | 9321 | 2020-09-05 | black | 0-17 | 1353 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9369 | 9369 | 2020-09-04 | black | 0-17 | 1328 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9417 | 9417 | 2020-09-03 | black | 0-17 | 1305 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9465 | 9465 | 2020-09-02 | black | 0-17 | 1290 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9513 | 9513 | 2020-09-01 | black | 0-17 | 1276 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9561 | 9561 | 2020-08-31 | black | 0-17 | 1266 | 0.026000000000000002 | 0 | 0.0 | 0.054 |
9609 | 9609 | 2020-08-30 | black | 0-17 | 1251 | 0.026000000000000002 | 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 );