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 deaths_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 |
---|---|---|---|---|---|---|---|---|---|
3713 | 3713 | 2021-04-28 | cdph-other | 0-17 | 46028 | 0.11800000000000001 | 0 | 0.0 | 0.0 |
3761 | 3761 | 2021-04-21 | cdph-other | 0-17 | 45952 | 0.11900000000000001 | 0 | 0.0 | 0.0 |
3809 | 3809 | 2021-04-14 | cdph-other | 0-17 | 45903 | 0.12 | 0 | 0.0 | 0.0 |
3857 | 3857 | 2021-04-07 | cdph-other | 0-17 | 45837 | 0.121 | 0 | 0.0 | 0.0 |
3905 | 3905 | 2021-03-31 | cdph-other | 0-17 | 45946 | 0.122 | 0 | 0.0 | 0.0 |
3953 | 3953 | 2021-03-24 | cdph-other | 0-17 | 46069 | 0.124 | 0 | 0.0 | 0.0 |
4001 | 4001 | 2021-03-17 | cdph-other | 0-17 | 46110 | 0.125 | 0 | 0.0 | 0.0 |
4049 | 4049 | 2021-03-10 | cdph-other | 0-17 | 46312 | 0.127 | 0 | 0.0 | 0.0 |
4097 | 4097 | 2021-02-24 | cdph-other | 0-17 | 46513 | 0.13 | 0 | 0.0 | 0.0 |
4145 | 4145 | 2021-02-17 | cdph-other | 0-17 | 46677 | 0.133 | 0 | 0.0 | 0.0 |
4193 | 4193 | 2021-02-10 | cdph-other | 0-17 | 46635 | 0.136 | 0 | 0.0 | 0.0 |
4241 | 4241 | 2021-02-03 | cdph-other | 0-17 | 45973 | 0.138 | 0 | 0.0 | 0.0 |
4289 | 4289 | 2021-01-27 | cdph-other | 0-17 | 45033 | 0.14100000000000001 | 0 | 0.0 | 0.0 |
4337 | 4337 | 2021-01-20 | cdph-other | 0-17 | 43176 | 0.14400000000000002 | 0 | 0.0 | 0.0 |
4385 | 4385 | 2021-01-13 | cdph-other | 0-17 | 38800 | 0.14400000000000002 | 0 | 0.0 | 0.0 |
4401 | 4401 | 2021-01-13 | other | 0-17 | 4225 | 0.016 | 0 | 0.0 | 0.044 |
4433 | 4433 | 2021-01-06 | cdph-other | 0-17 | 32747 | 0.14100000000000001 | 0 | 0.0 | 0.0 |
4449 | 4449 | 2021-01-06 | other | 0-17 | 3699 | 0.016 | 0 | 0.0 | 0.044 |
4481 | 4481 | 2021-01-05 | cdph-other | 0-17 | 32180 | 0.14100000000000001 | 0 | 0.0 | 0.0 |
4497 | 4497 | 2021-01-05 | other | 0-17 | 3633 | 0.016 | 0 | 0.0 | 0.044 |
4529 | 4529 | 2020-12-29 | cdph-other | 0-17 | 27861 | 0.139 | 0 | 0.0 | 0.0 |
4545 | 4545 | 2020-12-29 | other | 0-17 | 3166 | 0.016 | 0 | 0.0 | 0.044 |
4577 | 4577 | 2020-12-28 | cdph-other | 0-17 | 27416 | 0.139 | 0 | 0.0 | 0.0 |
4593 | 4593 | 2020-12-28 | other | 0-17 | 3123 | 0.016 | 0 | 0.0 | 0.044 |
4625 | 4625 | 2020-12-27 | cdph-other | 0-17 | 26816 | 0.138 | 0 | 0.0 | 0.0 |
4641 | 4641 | 2020-12-27 | other | 0-17 | 3091 | 0.016 | 0 | 0.0 | 0.044 |
4673 | 4673 | 2020-12-22 | cdph-other | 0-17 | 23457 | 0.135 | 0 | 0.0 | 0.0 |
4689 | 4689 | 2020-12-22 | other | 0-17 | 2784 | 0.016 | 0 | 0.0 | 0.044 |
4697 | 4697 | 2020-12-22 | white | 0-17 | 21573 | 0.124 | 0 | 0.0 | 0.292 |
4721 | 4721 | 2020-12-21 | cdph-other | 0-17 | 22771 | 0.133 | 0 | 0.0 | 0.0 |
4737 | 4737 | 2020-12-21 | other | 0-17 | 2756 | 0.016 | 0 | 0.0 | 0.044 |
4745 | 4745 | 2020-12-21 | white | 0-17 | 21105 | 0.123 | 0 | 0.0 | 0.292 |
4769 | 4769 | 2020-12-20 | cdph-other | 0-17 | 22142 | 0.132 | 0 | 0.0 | 0.0 |
4785 | 4785 | 2020-12-20 | other | 0-17 | 2710 | 0.016 | 0 | 0.0 | 0.044 |
4793 | 4793 | 2020-12-20 | white | 0-17 | 20585 | 0.123 | 0 | 0.0 | 0.292 |
4817 | 4817 | 2020-12-19 | cdph-other | 0-17 | 21331 | 0.131 | 0 | 0.0 | 0.0 |
4833 | 4833 | 2020-12-19 | other | 0-17 | 2610 | 0.016 | 0 | 0.0 | 0.044 |
4841 | 4841 | 2020-12-19 | white | 0-17 | 19856 | 0.122 | 0 | 0.0 | 0.292 |
4857 | 4857 | 2020-12-16 | black | 0-17 | 4296 | 0.028 | 0 | 0.0 | 0.054 |
4865 | 4865 | 2020-12-16 | cdph-other | 0-17 | 19306 | 0.128 | 0 | 0.0 | 0.0 |
4881 | 4881 | 2020-12-16 | other | 0-17 | 2384 | 0.016 | 0 | 0.0 | 0.044 |
4889 | 4889 | 2020-12-16 | white | 0-17 | 18072 | 0.12 | 0 | 0.0 | 0.292 |
4905 | 4905 | 2020-12-15 | black | 0-17 | 4117 | 0.028 | 0 | 0.0 | 0.054 |
4913 | 4913 | 2020-12-15 | cdph-other | 0-17 | 18506 | 0.128 | 0 | 0.0 | 0.0 |
4929 | 4929 | 2020-12-15 | other | 0-17 | 2322 | 0.016 | 0 | 0.0 | 0.044 |
4937 | 4937 | 2020-12-15 | white | 0-17 | 17510 | 0.121 | 0 | 0.0 | 0.292 |
4953 | 4953 | 2020-12-14 | black | 0-17 | 3957 | 0.028 | 0 | 0.0 | 0.054 |
4961 | 4961 | 2020-12-14 | cdph-other | 0-17 | 17489 | 0.125 | 0 | 0.0 | 0.0 |
4977 | 4977 | 2020-12-14 | other | 0-17 | 2287 | 0.016 | 0 | 0.0 | 0.044 |
4985 | 4985 | 2020-12-14 | white | 0-17 | 16877 | 0.12 | 0 | 0.0 | 0.292 |
5001 | 5001 | 2020-12-13 | black | 0-17 | 3863 | 0.028 | 0 | 0.0 | 0.054 |
5009 | 5009 | 2020-12-13 | cdph-other | 0-17 | 16810 | 0.122 | 0 | 0.0 | 0.0 |
5025 | 5025 | 2020-12-13 | other | 0-17 | 2264 | 0.017 | 0 | 0.0 | 0.044 |
5033 | 5033 | 2020-12-13 | white | 0-17 | 16385 | 0.11900000000000001 | 0 | 0.0 | 0.292 |
5049 | 5049 | 2020-12-12 | black | 0-17 | 3785 | 0.028 | 0 | 0.0 | 0.054 |
5057 | 5057 | 2020-12-12 | cdph-other | 0-17 | 16318 | 0.121 | 0 | 0.0 | 0.0 |
5073 | 5073 | 2020-12-12 | other | 0-17 | 2187 | 0.016 | 0 | 0.0 | 0.044 |
5081 | 5081 | 2020-12-12 | white | 0-17 | 16004 | 0.11900000000000001 | 0 | 0.0 | 0.292 |
5097 | 5097 | 2020-12-11 | black | 0-17 | 3686 | 0.028 | 0 | 0.0 | 0.054 |
5105 | 5105 | 2020-12-11 | cdph-other | 0-17 | 15708 | 0.12 | 0 | 0.0 | 0.0 |
5121 | 5121 | 2020-12-11 | other | 0-17 | 2149 | 0.016 | 0 | 0.0 | 0.044 |
5129 | 5129 | 2020-12-11 | white | 0-17 | 15513 | 0.11800000000000001 | 0 | 0.0 | 0.292 |
5145 | 5145 | 2020-12-10 | black | 0-17 | 3567 | 0.028 | 0 | 0.0 | 0.054 |
5153 | 5153 | 2020-12-10 | cdph-other | 0-17 | 15171 | 0.11900000000000001 | 0 | 0.0 | 0.0 |
5169 | 5169 | 2020-12-10 | other | 0-17 | 2092 | 0.016 | 0 | 0.0 | 0.044 |
5177 | 5177 | 2020-12-10 | white | 0-17 | 15039 | 0.11800000000000001 | 0 | 0.0 | 0.292 |
5193 | 5193 | 2020-12-09 | black | 0-17 | 3435 | 0.028 | 0 | 0.0 | 0.054 |
5201 | 5201 | 2020-12-09 | cdph-other | 0-17 | 14701 | 0.11900000000000001 | 0 | 0.0 | 0.0 |
5217 | 5217 | 2020-12-09 | other | 0-17 | 2014 | 0.016 | 0 | 0.0 | 0.044 |
5225 | 5225 | 2020-12-09 | white | 0-17 | 14485 | 0.117 | 0 | 0.0 | 0.292 |
5241 | 5241 | 2020-12-08 | black | 0-17 | 3359 | 0.028 | 0 | 0.0 | 0.054 |
5249 | 5249 | 2020-12-08 | cdph-other | 0-17 | 14311 | 0.11800000000000001 | 0 | 0.0 | 0.0 |
5265 | 5265 | 2020-12-08 | other | 0-17 | 1979 | 0.016 | 0 | 0.0 | 0.044 |
5273 | 5273 | 2020-12-08 | white | 0-17 | 14129 | 0.117 | 0 | 0.0 | 0.292 |
5289 | 5289 | 2020-12-07 | black | 0-17 | 3279 | 0.028 | 0 | 0.0 | 0.054 |
5297 | 5297 | 2020-12-07 | cdph-other | 0-17 | 13798 | 0.117 | 0 | 0.0 | 0.0 |
5313 | 5313 | 2020-12-07 | other | 0-17 | 1945 | 0.017 | 0 | 0.0 | 0.044 |
5321 | 5321 | 2020-12-07 | white | 0-17 | 13706 | 0.116 | 0 | 0.0 | 0.292 |
5337 | 5337 | 2020-12-06 | black | 0-17 | 3229 | 0.028 | 0 | 0.0 | 0.054 |
5345 | 5345 | 2020-12-06 | cdph-other | 0-17 | 13454 | 0.116 | 0 | 0.0 | 0.0 |
5361 | 5361 | 2020-12-06 | other | 0-17 | 1920 | 0.017 | 0 | 0.0 | 0.044 |
5369 | 5369 | 2020-12-06 | white | 0-17 | 13345 | 0.115 | 0 | 0.0 | 0.292 |
5385 | 5385 | 2020-12-05 | black | 0-17 | 3141 | 0.028 | 0 | 0.0 | 0.054 |
5393 | 5393 | 2020-12-05 | cdph-other | 0-17 | 13027 | 0.115 | 0 | 0.0 | 0.0 |
5409 | 5409 | 2020-12-05 | other | 0-17 | 1827 | 0.016 | 0 | 0.0 | 0.044 |
5417 | 5417 | 2020-12-05 | white | 0-17 | 12900 | 0.114 | 0 | 0.0 | 0.292 |
5433 | 5433 | 2020-12-04 | black | 0-17 | 3060 | 0.028 | 0 | 0.0 | 0.054 |
5441 | 5441 | 2020-12-04 | cdph-other | 0-17 | 12536 | 0.114 | 0 | 0.0 | 0.0 |
5457 | 5457 | 2020-12-04 | other | 0-17 | 1782 | 0.016 | 0 | 0.0 | 0.044 |
5465 | 5465 | 2020-12-04 | white | 0-17 | 12466 | 0.113 | 0 | 0.0 | 0.292 |
5481 | 5481 | 2020-12-03 | black | 0-17 | 2981 | 0.028 | 0 | 0.0 | 0.054 |
5489 | 5489 | 2020-12-03 | cdph-other | 0-17 | 12142 | 0.113 | 0 | 0.0 | 0.0 |
5505 | 5505 | 2020-12-03 | other | 0-17 | 1755 | 0.016 | 0 | 0.0 | 0.044 |
5513 | 5513 | 2020-12-03 | white | 0-17 | 12110 | 0.112 | 0 | 0.0 | 0.292 |
5529 | 5529 | 2020-12-02 | black | 0-17 | 2934 | 0.028 | 0 | 0.0 | 0.054 |
5537 | 5537 | 2020-12-02 | cdph-other | 0-17 | 11925 | 0.113 | 0 | 0.0 | 0.0 |
5553 | 5553 | 2020-12-02 | other | 0-17 | 1692 | 0.016 | 0 | 0.0 | 0.044 |
5561 | 5561 | 2020-12-02 | white | 0-17 | 11812 | 0.112 | 0 | 0.0 | 0.292 |
5577 | 5577 | 2020-12-01 | black | 0-17 | 2886 | 0.028 | 0 | 0.0 | 0.054 |
5585 | 5585 | 2020-12-01 | cdph-other | 0-17 | 11705 | 0.113 | 0 | 0.0 | 0.0 |
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 );