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-07-06
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: age
Link | rowid ▼ | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
11089 | 11089 | 2020-07-06 | asian | 0-17 | 386 | 0.026000000000000002 | 0 | 0.0 | 0.13 |
11090 | 11090 | 2020-07-06 | asian | 18+ | 12044 | 0.073 | 911 | 0.145 | 0.165 |
11091 | 11091 | 2020-07-06 | asian | 18-34 | 2896 | 0.051000000000000004 | 4 | 0.059000000000000004 | 0.151 |
11092 | 11092 | 2020-07-06 | asian | 35-49 | 3193 | 0.07 | 24 | 0.077 | 0.179 |
11093 | 11093 | 2020-07-06 | asian | 50-64 | 3100 | 0.082 | 90 | 0.08700000000000001 | 0.167 |
11094 | 11094 | 2020-07-06 | asian | 65-79 | 1638 | 0.099 | 240 | 0.121 | 0.17200000000000001 |
11095 | 11095 | 2020-07-06 | asian | 80+ | 1217 | 0.14400000000000002 | 553 | 0.192 | 0.17200000000000001 |
11096 | 11096 | 2020-07-06 | asian | all | 12441 | 0.069 | 911 | 0.145 | 0.157 |
11097 | 11097 | 2020-07-06 | black | 0-17 | 315 | 0.021 | 0 | 0.0 | 0.054 |
11098 | 11098 | 2020-07-06 | black | 18+ | 7541 | 0.046 | 577 | 0.092 | 0.061 |
11099 | 11099 | 2020-07-06 | black | 18-34 | 2144 | 0.038 | 10 | 0.147 | 0.065 |
11100 | 11100 | 2020-07-06 | black | 35-49 | 1732 | 0.038 | 20 | 0.064 | 0.059000000000000004 |
11101 | 11101 | 2020-07-06 | black | 50-64 | 1880 | 0.05 | 82 | 0.079 | 0.064 |
11102 | 11102 | 2020-07-06 | black | 65-79 | 1144 | 0.069 | 221 | 0.112 | 0.055 |
11103 | 11103 | 2020-07-06 | black | 80+ | 641 | 0.076 | 244 | 0.085 | 0.048 |
11104 | 11104 | 2020-07-06 | black | all | 7869 | 0.044 | 577 | 0.092 | 0.06 |
11105 | 11105 | 2020-07-06 | cdph-other | 0-17 | 2957 | 0.199 | 0 | 0.0 | 0.0 |
11106 | 11106 | 2020-07-06 | cdph-other | 18+ | 25097 | 0.152 | 71 | 0.011 | 0.0 |
11107 | 11107 | 2020-07-06 | cdph-other | 18-34 | 10436 | 0.183 | 0 | 0.0 | 0.0 |
11108 | 11108 | 2020-07-06 | cdph-other | 35-49 | 7265 | 0.16 | 1 | 0.003 | 0.0 |
11109 | 11109 | 2020-07-06 | cdph-other | 50-64 | 5216 | 0.138 | 12 | 0.012 | 0.0 |
11110 | 11110 | 2020-07-06 | cdph-other | 65-79 | 1631 | 0.099 | 21 | 0.01 | 0.0 |
11111 | 11111 | 2020-07-06 | cdph-other | 80+ | 549 | 0.065 | 37 | 0.013000000000000001 | 0.0 |
11112 | 11112 | 2020-07-06 | cdph-other | all | 28058 | 0.156 | 71 | 0.011 | 0.0 |
11113 | 11113 | 2020-07-06 | latino | 0-17 | 9852 | 0.663 | 0 | 0.0 | 0.47900000000000004 |
11114 | 11114 | 2020-07-06 | latino | 18+ | 89034 | 0.539 | 2659 | 0.423 | 0.363 |
11115 | 11115 | 2020-07-06 | latino | 18-34 | 33091 | 0.58 | 43 | 0.632 | 0.45 |
11116 | 11116 | 2020-07-06 | latino | 35-49 | 26609 | 0.585 | 241 | 0.77 | 0.41500000000000004 |
11117 | 11117 | 2020-07-06 | latino | 50-64 | 19990 | 0.53 | 651 | 0.63 | 0.322 |
11118 | 11118 | 2020-07-06 | latino | 65-79 | 6796 | 0.41100000000000003 | 882 | 0.445 | 0.218 |
11119 | 11119 | 2020-07-06 | latino | 80+ | 2548 | 0.302 | 842 | 0.292 | 0.196 |
11120 | 11120 | 2020-07-06 | latino | all | 98954 | 0.549 | 2660 | 0.423 | 0.389 |
11121 | 11121 | 2020-07-06 | other | 0-17 | 106 | 0.007 | 0 | 0.0 | 0.044 |
11122 | 11122 | 2020-07-06 | other | 18+ | 1528 | 0.009000000000000001 | 57 | 0.009000000000000001 | 0.022 |
11123 | 11123 | 2020-07-06 | other | 18-34 | 534 | 0.009000000000000001 | 2 | 0.029 | 0.032 |
11124 | 11124 | 2020-07-06 | other | 35-49 | 407 | 0.009000000000000001 | 6 | 0.019 | 0.021 |
11125 | 11125 | 2020-07-06 | other | 50-64 | 357 | 0.01 | 8 | 0.008 | 0.017 |
11126 | 11126 | 2020-07-06 | other | 65-79 | 146 | 0.009000000000000001 | 15 | 0.008 | 0.015 |
11127 | 11127 | 2020-07-06 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.012 |
11128 | 11128 | 2020-07-06 | other | all | 1635 | 0.009000000000000001 | 57 | 0.009000000000000001 | 0.027 |
11129 | 11129 | 2020-07-06 | white | 0-17 | 1239 | 0.083 | 0 | 0.0 | 0.292 |
11130 | 11130 | 2020-07-06 | white | 18+ | 29951 | 0.181 | 2006 | 0.319 | 0.388 |
11131 | 11131 | 2020-07-06 | white | 18-34 | 7969 | 0.14 | 9 | 0.132 | 0.302 |
11132 | 11132 | 2020-07-06 | white | 35-49 | 6280 | 0.138 | 21 | 0.067 | 0.325 |
11133 | 11133 | 2020-07-06 | white | 50-64 | 7141 | 0.189 | 190 | 0.184 | 0.43 |
11134 | 11134 | 2020-07-06 | white | 65-79 | 5169 | 0.313 | 603 | 0.304 | 0.54 |
11135 | 11135 | 2020-07-06 | white | 80+ | 3392 | 0.402 | 1183 | 0.41000000000000003 | 0.5720000000000001 |
11136 | 11136 | 2020-07-06 | white | all | 31221 | 0.17300000000000001 | 2006 | 0.319 | 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 );