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-12
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 |
---|---|---|---|---|---|---|---|---|---|
12145 | 12145 | 2020-06-12 | asian | 0-17 | 200 | 0.029 | 0 | 0.0 | 0.13 |
12146 | 12146 | 2020-06-12 | asian | 18+ | 8795 | 0.091 | 733 | 0.153 | 0.165 |
12147 | 12147 | 2020-06-12 | asian | 18-34 | 1931 | 0.066 | 4 | 0.077 | 0.151 |
12148 | 12148 | 2020-06-12 | asian | 35-49 | 2260 | 0.08600000000000001 | 20 | 0.084 | 0.179 |
12149 | 12149 | 2020-06-12 | asian | 50-64 | 2377 | 0.1 | 76 | 0.099 | 0.167 |
12150 | 12150 | 2020-06-12 | asian | 65-79 | 1251 | 0.112 | 184 | 0.12 | 0.17200000000000001 |
12151 | 12151 | 2020-06-12 | asian | 80+ | 976 | 0.158 | 449 | 0.203 | 0.17200000000000001 |
12152 | 12152 | 2020-06-12 | asian | all | 9006 | 0.08700000000000001 | 733 | 0.153 | 0.157 |
12153 | 12153 | 2020-06-12 | black | 0-17 | 103 | 0.015 | 0 | 0.0 | 0.054 |
12154 | 12154 | 2020-06-12 | black | 18+ | 4799 | 0.05 | 458 | 0.095 | 0.061 |
12155 | 12155 | 2020-06-12 | black | 18-34 | 1090 | 0.037 | 5 | 0.096 | 0.065 |
12156 | 12156 | 2020-06-12 | black | 35-49 | 1057 | 0.04 | 19 | 0.08 | 0.059000000000000004 |
12157 | 12157 | 2020-06-12 | black | 50-64 | 1295 | 0.054 | 72 | 0.094 | 0.064 |
12158 | 12158 | 2020-06-12 | black | 65-79 | 859 | 0.077 | 175 | 0.114 | 0.055 |
12159 | 12159 | 2020-06-12 | black | 80+ | 498 | 0.081 | 187 | 0.085 | 0.048 |
12160 | 12160 | 2020-06-12 | black | all | 4906 | 0.047 | 458 | 0.095 | 0.06 |
12161 | 12161 | 2020-06-12 | cdph-other | 0-17 | 1236 | 0.179 | 0 | 0.0 | 0.0 |
12162 | 12162 | 2020-06-12 | cdph-other | 18+ | 10416 | 0.108 | 34 | 0.007 | 0.0 |
12163 | 12163 | 2020-06-12 | cdph-other | 18-34 | 3803 | 0.129 | 0 | 0.0 | 0.0 |
12164 | 12164 | 2020-06-12 | cdph-other | 35-49 | 2976 | 0.114 | 1 | 0.0 | 0.0 |
12165 | 12165 | 2020-06-12 | cdph-other | 50-64 | 2453 | 0.10300000000000001 | 6 | 0.008 | 0.0 |
12166 | 12166 | 2020-06-12 | cdph-other | 65-79 | 856 | 0.077 | 15 | 0.01 | 0.0 |
12167 | 12167 | 2020-06-12 | cdph-other | 80+ | 328 | 0.053 | 13 | 0.006 | 0.0 |
12168 | 12168 | 2020-06-12 | cdph-other | all | 11654 | 0.112 | 34 | 0.007 | 0.0 |
12169 | 12169 | 2020-06-12 | latino | 0-17 | 4807 | 0.6940000000000001 | 0 | 0.0 | 0.47900000000000004 |
12170 | 12170 | 2020-06-12 | latino | 18+ | 53560 | 0.554 | 1940 | 0.404 | 0.363 |
12171 | 12171 | 2020-06-12 | latino | 18-34 | 18498 | 0.63 | 34 | 0.654 | 0.45 |
12172 | 12172 | 2020-06-12 | latino | 35-49 | 15931 | 0.608 | 174 | 0.734 | 0.41500000000000004 |
12173 | 12173 | 2020-06-12 | latino | 50-64 | 12842 | 0.539 | 464 | 0.603 | 0.322 |
12174 | 12174 | 2020-06-12 | latino | 65-79 | 4497 | 0.403 | 655 | 0.427 | 0.218 |
12175 | 12175 | 2020-06-12 | latino | 80+ | 1792 | 0.291 | 613 | 0.277 | 0.196 |
12176 | 12176 | 2020-06-12 | latino | all | 58415 | 0.5630000000000001 | 1941 | 0.404 | 0.389 |
12177 | 12177 | 2020-06-12 | other | 0-17 | 47 | 0.007 | 0 | 0.0 | 0.044 |
12178 | 12178 | 2020-06-12 | other | 18+ | 929 | 0.01 | 46 | 0.01 | 0.022 |
12179 | 12179 | 2020-06-12 | other | 18-34 | 283 | 0.01 | 2 | 0.038 | 0.032 |
12180 | 12180 | 2020-06-12 | other | 35-49 | 251 | 0.009000000000000001 | 3 | 0.012 | 0.021 |
12181 | 12181 | 2020-06-12 | other | 50-64 | 228 | 0.01 | 6 | 0.008 | 0.017 |
12182 | 12182 | 2020-06-12 | other | 65-79 | 104 | 0.009000000000000001 | 12 | 0.008 | 0.015 |
12183 | 12183 | 2020-06-12 | other | 80+ | 63 | 0.01 | 23 | 0.01 | 0.013000000000000001 |
12184 | 12184 | 2020-06-12 | other | all | 976 | 0.009000000000000001 | 46 | 0.01 | 0.027 |
12185 | 12185 | 2020-06-12 | white | 0-17 | 531 | 0.077 | 0 | 0.0 | 0.292 |
12186 | 12186 | 2020-06-12 | white | 18+ | 18231 | 0.188 | 1594 | 0.332 | 0.388 |
12187 | 12187 | 2020-06-12 | white | 18-34 | 3779 | 0.129 | 7 | 0.135 | 0.302 |
12188 | 12188 | 2020-06-12 | white | 35-49 | 3714 | 0.14200000000000002 | 21 | 0.089 | 0.325 |
12189 | 12189 | 2020-06-12 | white | 50-64 | 4642 | 0.195 | 145 | 0.189 | 0.43 |
12190 | 12190 | 2020-06-12 | white | 65-79 | 3586 | 0.322 | 494 | 0.322 | 0.54 |
12191 | 12191 | 2020-06-12 | white | 80+ | 2510 | 0.40700000000000003 | 927 | 0.419 | 0.5720000000000001 |
12192 | 12192 | 2020-06-12 | white | all | 18783 | 0.181 | 1594 | 0.332 | 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 );