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-05
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 |
---|---|---|---|---|---|---|---|---|---|
11137 | 11137 | 2020-07-05 | asian | 0-17 | 374 | 0.026000000000000002 | 0 | 0.0 | 0.13 |
11138 | 11138 | 2020-07-05 | asian | 18+ | 11897 | 0.073 | 908 | 0.146 | 0.165 |
11139 | 11139 | 2020-07-05 | asian | 18-34 | 2856 | 0.051000000000000004 | 4 | 0.061 | 0.151 |
11140 | 11140 | 2020-07-05 | asian | 35-49 | 3157 | 0.07100000000000001 | 24 | 0.078 | 0.179 |
11141 | 11141 | 2020-07-05 | asian | 50-64 | 3064 | 0.082 | 90 | 0.088 | 0.167 |
11142 | 11142 | 2020-07-05 | asian | 65-79 | 1617 | 0.099 | 238 | 0.121 | 0.17200000000000001 |
11143 | 11143 | 2020-07-05 | asian | 80+ | 1206 | 0.14400000000000002 | 552 | 0.193 | 0.17200000000000001 |
11144 | 11144 | 2020-07-05 | asian | all | 12282 | 0.069 | 908 | 0.146 | 0.157 |
11145 | 11145 | 2020-07-05 | black | 0-17 | 305 | 0.021 | 0 | 0.0 | 0.054 |
11146 | 11146 | 2020-07-05 | black | 18+ | 7375 | 0.045 | 575 | 0.092 | 0.061 |
11147 | 11147 | 2020-07-05 | black | 18-34 | 2082 | 0.037 | 10 | 0.152 | 0.065 |
11148 | 11148 | 2020-07-05 | black | 35-49 | 1690 | 0.038 | 20 | 0.065 | 0.059000000000000004 |
11149 | 11149 | 2020-07-05 | black | 50-64 | 1843 | 0.05 | 82 | 0.08 | 0.064 |
11150 | 11150 | 2020-07-05 | black | 65-79 | 1130 | 0.069 | 220 | 0.112 | 0.055 |
11151 | 11151 | 2020-07-05 | black | 80+ | 630 | 0.076 | 243 | 0.085 | 0.048 |
11152 | 11152 | 2020-07-05 | black | all | 7693 | 0.043000000000000003 | 575 | 0.092 | 0.06 |
11153 | 11153 | 2020-07-05 | cdph-other | 0-17 | 2864 | 0.197 | 0 | 0.0 | 0.0 |
11154 | 11154 | 2020-07-05 | cdph-other | 18+ | 24451 | 0.151 | 70 | 0.011 | 0.0 |
11155 | 11155 | 2020-07-05 | cdph-other | 18-34 | 10154 | 0.181 | 0 | 0.0 | 0.0 |
11156 | 11156 | 2020-07-05 | cdph-other | 35-49 | 7050 | 0.158 | 0 | 0.0 | 0.0 |
11157 | 11157 | 2020-07-05 | cdph-other | 50-64 | 5084 | 0.137 | 13 | 0.013000000000000001 | 0.0 |
11158 | 11158 | 2020-07-05 | cdph-other | 65-79 | 1603 | 0.098 | 20 | 0.01 | 0.0 |
11159 | 11159 | 2020-07-05 | cdph-other | 80+ | 560 | 0.06 | 37 | 0.013000000000000001 | 0.0 |
11160 | 11160 | 2020-07-05 | cdph-other | all | 27318 | 0.154 | 70 | 0.011 | 0.0 |
11161 | 11161 | 2020-07-05 | latino | 0-17 | 9691 | 0.667 | 0 | 0.0 | 0.47900000000000004 |
11162 | 11162 | 2020-07-05 | latino | 18+ | 87840 | 0.541 | 2624 | 0.421 | 0.363 |
11163 | 11163 | 2020-07-05 | latino | 18-34 | 32628 | 0.583 | 41 | 0.621 | 0.45 |
11164 | 11164 | 2020-07-05 | latino | 35-49 | 26264 | 0.588 | 23 | 0.769 | 0.41500000000000004 |
11165 | 11165 | 2020-07-05 | latino | 50-64 | 19731 | 0.533 | 644 | 0.629 | 0.322 |
11166 | 11166 | 2020-07-05 | latino | 65-79 | 6710 | 0.41200000000000003 | 871 | 0.443 | 0.218 |
11167 | 11167 | 2020-07-05 | latino | 80+ | 2507 | 0.301 | 831 | 0.29 | 0.196 |
11168 | 11168 | 2020-07-05 | latino | all | 97599 | 0.551 | 2625 | 0.422 | 0.389 |
11169 | 11169 | 2020-07-05 | other | 0-17 | 104 | 0.007 | 0 | 0.0 | 0.044 |
11170 | 11170 | 2020-07-05 | other | 18+ | 1496 | 0.009000000000000001 | 57 | 0.009000000000000001 | 0.022 |
11171 | 11171 | 2020-07-05 | other | 18-34 | 523 | 0.009000000000000001 | 2 | 0.03 | 0.032 |
11172 | 11172 | 2020-07-05 | other | 35-49 | 400 | 0.009000000000000001 | 6 | 0.019 | 0.021 |
11173 | 11173 | 2020-07-05 | other | 50-64 | 351 | 0.01 | 8 | 0.008 | 0.017 |
11174 | 11174 | 2020-07-05 | other | 65-79 | 142 | 0.009000000000000001 | 15 | 0.008 | 0.015 |
11175 | 11175 | 2020-07-05 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.012 |
11176 | 11176 | 2020-07-05 | other | all | 1601 | 0.009000000000000001 | 57 | 0.009000000000000001 | 0.027 |
11177 | 11177 | 2020-07-05 | white | 0-17 | 1199 | 0.082 | 0 | 0.0 | 0.292 |
11178 | 11178 | 2020-07-05 | white | 18+ | 29288 | 0.18 | 1992 | 0.32 | 0.388 |
11179 | 11179 | 2020-07-05 | white | 18-34 | 7740 | 0.138 | 9 | 0.136 | 0.302 |
11180 | 11180 | 2020-07-05 | white | 35-49 | 6128 | 0.137 | 21 | 0.068 | 0.325 |
11181 | 11181 | 2020-07-05 | white | 50-64 | 6973 | 0.188 | 187 | 0.183 | 0.43 |
11182 | 11182 | 2020-07-05 | white | 65-79 | 5090 | 0.312 | 601 | 0.306 | 0.54 |
11183 | 11183 | 2020-07-05 | white | 80+ | 3357 | 0.403 | 1174 | 0.41000000000000003 | 0.5720000000000001 |
11184 | 11184 | 2020-07-05 | white | all | 30519 | 0.17200000000000001 | 1992 | 0.32 | 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 );