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-24
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
11617 | 11617 | 2020-06-24 | asian | 0-17 | 255 | 0.025 | 0 | 0.0 | 0.13 |
11618 | 11618 | 2020-06-24 | asian | 18+ | 10028 | 0.081 | 829 | 0.15 | 0.165 |
11619 | 11619 | 2020-06-24 | asian | 18-34 | 2280 | 0.057 | 4 | 0.069 | 0.151 |
11620 | 11620 | 2020-06-24 | asian | 35-49 | 2603 | 0.076 | 22 | 0.08 | 0.179 |
11621 | 11621 | 2020-06-24 | asian | 50-64 | 2647 | 0.09 | 85 | 0.095 | 0.167 |
11622 | 11622 | 2020-06-24 | asian | 65-79 | 1408 | 0.105 | 215 | 0.121 | 0.17200000000000001 |
11623 | 11623 | 2020-06-24 | asian | 80+ | 1090 | 0.153 | 503 | 0.2 | 0.17200000000000001 |
11624 | 11624 | 2020-06-24 | asian | all | 10293 | 0.076 | 829 | 0.15 | 0.157 |
11625 | 11625 | 2020-06-24 | black | 0-17 | 178 | 0.017 | 0 | 0.0 | 0.054 |
11626 | 11626 | 2020-06-24 | black | 18+ | 5794 | 0.047 | 519 | 0.094 | 0.061 |
11627 | 11627 | 2020-06-24 | black | 18-34 | 1436 | 0.036000000000000004 | 6 | 0.10300000000000001 | 0.065 |
11628 | 11628 | 2020-06-24 | black | 35-49 | 1317 | 0.039 | 20 | 0.073 | 0.059000000000000004 |
11629 | 11629 | 2020-06-24 | black | 50-64 | 1502 | 0.051000000000000004 | 77 | 0.08600000000000001 | 0.064 |
11630 | 11630 | 2020-06-24 | black | 65-79 | 982 | 0.073 | 201 | 0.113 | 0.055 |
11631 | 11631 | 2020-06-24 | black | 80+ | 557 | 0.078 | 215 | 0.085 | 0.048 |
11632 | 11632 | 2020-06-24 | black | all | 5981 | 0.045 | 519 | 0.094 | 0.06 |
11633 | 11633 | 2020-06-24 | cdph-other | 0-17 | 1948 | 0.19 | 0 | 0.0 | 0.0 |
11634 | 11634 | 2020-06-24 | cdph-other | 18+ | 16088 | 0.13 | 51 | 0.009000000000000001 | 0.0 |
11635 | 11635 | 2020-06-24 | cdph-other | 18-34 | 6231 | 0.156 | 0 | 0.0 | 0.0 |
11636 | 11636 | 2020-06-24 | cdph-other | 35-49 | 4665 | 0.137 | 0 | 0.0 | 0.0 |
11637 | 11637 | 2020-06-24 | cdph-other | 50-64 | 3557 | 0.121 | 9 | 0.01 | 0.0 |
11638 | 11638 | 2020-06-24 | cdph-other | 65-79 | 1184 | 0.088 | 18 | 0.01 | 0.0 |
11639 | 11639 | 2020-06-24 | cdph-other | 80+ | 451 | 0.063 | 24 | 0.01 | 0.0 |
11640 | 11640 | 2020-06-24 | cdph-other | all | 18038 | 0.134 | 51 | 0.009000000000000001 | 0.0 |
11641 | 11641 | 2020-06-24 | latino | 0-17 | 7059 | 0.6890000000000001 | 0 | 0.0 | 0.47900000000000004 |
11642 | 11642 | 2020-06-24 | latino | 18+ | 68929 | 0.556 | 2264 | 0.41000000000000003 | 0.363 |
11643 | 11643 | 2020-06-24 | latino | 18-34 | 24742 | 0.619 | 39 | 0.672 | 0.45 |
11644 | 11644 | 2020-06-24 | latino | 35-49 | 20605 | 0.605 | 202 | 0.737 | 0.41500000000000004 |
11645 | 11645 | 2020-06-24 | latino | 50-64 | 15965 | 0.542 | 549 | 0.613 | 0.322 |
11646 | 11646 | 2020-06-24 | latino | 65-79 | 5519 | 0.41100000000000003 | 777 | 0.437 | 0.218 |
11647 | 11647 | 2020-06-24 | latino | 80+ | 2098 | 0.293 | 697 | 0.277 | 0.196 |
11648 | 11648 | 2020-06-24 | latino | all | 76036 | 0.5660000000000001 | 2265 | 0.41000000000000003 | 0.389 |
11649 | 11649 | 2020-06-24 | other | 0-17 | 66 | 0.006 | 0 | 0.0 | 0.044 |
11650 | 11650 | 2020-06-24 | other | 18+ | 1117 | 0.009000000000000001 | 56 | 0.01 | 0.022 |
11651 | 11651 | 2020-06-24 | other | 18-34 | 364 | 0.009000000000000001 | 2 | 0.034 | 0.032 |
11652 | 11652 | 2020-06-24 | other | 35-49 | 294 | 0.009000000000000001 | 6 | 0.022 | 0.021 |
11653 | 11653 | 2020-06-24 | other | 50-64 | 276 | 0.01 | 8 | 0.009000000000000001 | 0.017 |
11654 | 11654 | 2020-06-24 | other | 65-79 | 115 | 0.009000000000000001 | 16 | 0.009000000000000001 | 0.015 |
11655 | 11655 | 2020-06-24 | other | 80+ | 68 | 0.009000000000000001 | 24 | 0.009000000000000001 | 0.013000000000000001 |
11656 | 11656 | 2020-06-24 | other | all | 1183 | 0.009000000000000001 | 56 | 0.01 | 0.027 |
11657 | 11657 | 2020-06-24 | white | 0-17 | 744 | 0.073 | 0 | 0.0 | 0.292 |
11658 | 11658 | 2020-06-24 | white | 18+ | 22103 | 0.178 | 1807 | 0.327 | 0.388 |
11659 | 11659 | 2020-06-24 | white | 18-34 | 4948 | 0.124 | 7 | 0.121 | 0.302 |
11660 | 11660 | 2020-06-24 | white | 35-49 | 4552 | 0.134 | 24 | 0.088 | 0.325 |
11661 | 11661 | 2020-06-24 | white | 50-64 | 5507 | 0.187 | 167 | 0.187 | 0.43 |
11662 | 11662 | 2020-06-24 | white | 65-79 | 4204 | 0.313 | 553 | 0.311 | 0.54 |
11663 | 11663 | 2020-06-24 | white | 80+ | 2892 | 0.404 | 1056 | 0.419 | 0.5720000000000001 |
11664 | 11664 | 2020-06-24 | white | all | 22871 | 0.17 | 1807 | 0.327 | 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 );