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.
48 rows where "date" is on date 2020-06-23
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: race, age, deaths_percent, date (date)
Link | rowid ▼ | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
11665 | 11665 | 2020-06-23 | asian | 0-17 | 247 | 0.025 | 0 | 0.0 | 0.13 |
11666 | 11666 | 2020-06-23 | asian | 18+ | 9852 | 0.082 | 807 | 0.149 | 0.165 |
11667 | 11667 | 2020-06-23 | asian | 18-34 | 2236 | 0.058 | 4 | 0.069 | 0.151 |
11668 | 11668 | 2020-06-23 | asian | 35-49 | 2555 | 0.077 | 22 | 0.082 | 0.179 |
11669 | 11669 | 2020-06-23 | asian | 50-64 | 2609 | 0.091 | 83 | 0.095 | 0.167 |
11670 | 11670 | 2020-06-23 | asian | 65-79 | 1387 | 0.105 | 207 | 0.11900000000000001 | 0.17200000000000001 |
11671 | 11671 | 2020-06-23 | asian | 80+ | 1065 | 0.152 | 491 | 0.198 | 0.17200000000000001 |
11672 | 11672 | 2020-06-23 | asian | all | 10109 | 0.077 | 807 | 0.149 | 0.157 |
11673 | 11673 | 2020-06-23 | black | 0-17 | 173 | 0.017 | 0 | 0.0 | 0.054 |
11674 | 11674 | 2020-06-23 | black | 18+ | 5664 | 0.047 | 511 | 0.094 | 0.061 |
11675 | 11675 | 2020-06-23 | black | 18-34 | 1387 | 0.036000000000000004 | 6 | 0.10300000000000001 | 0.065 |
11676 | 11676 | 2020-06-23 | black | 35-49 | 1285 | 0.039 | 20 | 0.074 | 0.059000000000000004 |
11677 | 11677 | 2020-06-23 | black | 50-64 | 1484 | 0.051000000000000004 | 75 | 0.08600000000000001 | 0.064 |
11678 | 11678 | 2020-06-23 | black | 65-79 | 963 | 0.073 | 197 | 0.113 | 0.055 |
11679 | 11679 | 2020-06-23 | black | 80+ | 545 | 0.077 | 213 | 0.08600000000000001 | 0.048 |
11680 | 11680 | 2020-06-23 | black | all | 5845 | 0.045 | 511 | 0.094 | 0.06 |
11681 | 11681 | 2020-06-23 | cdph-other | 0-17 | 1952 | 0.197 | 0 | 0.0 | 0.0 |
11682 | 11682 | 2020-06-23 | cdph-other | 18+ | 15975 | 0.132 | 50 | 0.009000000000000001 | 0.0 |
11683 | 11683 | 2020-06-23 | cdph-other | 18-34 | 6169 | 0.159 | 0 | 0.0 | 0.0 |
11684 | 11684 | 2020-06-23 | cdph-other | 35-49 | 4638 | 0.14 | 0 | 0.0 | 0.0 |
11685 | 11685 | 2020-06-23 | cdph-other | 50-64 | 3553 | 0.123 | 9 | 0.01 | 0.0 |
11686 | 11686 | 2020-06-23 | cdph-other | 65-79 | 1171 | 0.089 | 18 | 0.01 | 0.0 |
11687 | 11687 | 2020-06-23 | cdph-other | 80+ | 444 | 0.063 | 23 | 0.009000000000000001 | 0.0 |
11688 | 11688 | 2020-06-23 | cdph-other | all | 17930 | 0.137 | 50 | 0.009000000000000001 | 0.0 |
11689 | 11689 | 2020-06-23 | latino | 0-17 | 6694 | 0.676 | 0 | 0.0 | 0.47900000000000004 |
11690 | 11690 | 2020-06-23 | latino | 18+ | 66618 | 0.551 | 2224 | 0.41000000000000003 | 0.363 |
11691 | 11691 | 2020-06-23 | latino | 18-34 | 23814 | 0.614 | 39 | 0.672 | 0.45 |
11692 | 11692 | 2020-06-23 | latino | 35-49 | 19873 | 0.6000000000000001 | 198 | 0.736 | 0.41500000000000004 |
11693 | 11693 | 2020-06-23 | latino | 50-64 | 15509 | 0.538 | 537 | 0.612 | 0.322 |
11694 | 11694 | 2020-06-23 | latino | 65-79 | 5361 | 0.40800000000000003 | 764 | 0.438 | 0.218 |
11695 | 11695 | 2020-06-23 | latino | 80+ | 2061 | 0.293 | 686 | 0.277 | 0.196 |
11696 | 11696 | 2020-06-23 | latino | all | 73357 | 0.56 | 2225 | 0.41000000000000003 | 0.389 |
11697 | 11697 | 2020-06-23 | other | 0-17 | 65 | 0.006 | 0 | 0.0 | 0.044 |
11698 | 11698 | 2020-06-23 | other | 18+ | 1104 | 0.009000000000000001 | 55 | 0.01 | 0.022 |
11699 | 11699 | 2020-06-23 | other | 18-34 | 359 | 0.009000000000000001 | 2 | 0.034 | 0.032 |
11700 | 11700 | 2020-06-23 | other | 35-49 | 291 | 0.009000000000000001 | 5 | 0.019 | 0.021 |
11701 | 11701 | 2020-06-23 | other | 50-64 | 274 | 0.01 | 9 | 0.011 | 0.017 |
11702 | 11702 | 2020-06-23 | other | 65-79 | 111 | 0.008 | 14 | 0.008 | 0.015 |
11703 | 11703 | 2020-06-23 | other | 80+ | 69 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
11704 | 11704 | 2020-06-23 | other | all | 1169 | 0.009000000000000001 | 55 | 0.01 | 0.027 |
11705 | 11705 | 2020-06-23 | white | 0-17 | 766 | 0.077 | 0 | 0.0 | 0.292 |
11706 | 11706 | 2020-06-23 | white | 18+ | 21710 | 0.18 | 1783 | 0.328 | 0.388 |
11707 | 11707 | 2020-06-23 | white | 18-34 | 4840 | 0.125 | 7 | 0.121 | 0.302 |
11708 | 11708 | 2020-06-23 | white | 35-49 | 4465 | 0.135 | 24 | 0.089 | 0.325 |
11709 | 11709 | 2020-06-23 | white | 50-64 | 5412 | 0.188 | 164 | 0.187 | 0.43 |
11710 | 11710 | 2020-06-23 | white | 65-79 | 4141 | 0.315 | 545 | 0.312 | 0.54 |
11711 | 11711 | 2020-06-23 | white | 80+ | 2849 | 0.405 | 1043 | 0.42 | 0.5720000000000001 |
11712 | 11712 | 2020-06-23 | white | all | 22500 | 0.17200000000000001 | 1783 | 0.328 | 0.366 |
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 );