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-04
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 |
---|---|---|---|---|---|---|---|---|---|
11185 | 11185 | 2020-07-04 | asian | 0-17 | 355 | 0.026000000000000002 | 0 | 0.0 | 0.13 |
11186 | 11186 | 2020-07-04 | asian | 18+ | 11676 | 0.074 | 905 | 0.147 | 0.165 |
11187 | 11187 | 2020-07-04 | asian | 18-34 | 2787 | 0.051000000000000004 | 4 | 0.062 | 0.151 |
11188 | 11188 | 2020-07-04 | asian | 35-49 | 3089 | 0.07200000000000001 | 23 | 0.075 | 0.179 |
11189 | 11189 | 2020-07-04 | asian | 50-64 | 3016 | 0.083 | 90 | 0.089 | 0.167 |
11190 | 11190 | 2020-07-04 | asian | 65-79 | 1597 | 0.1 | 238 | 0.122 | 0.17200000000000001 |
11191 | 11191 | 2020-07-04 | asian | 80+ | 1187 | 0.146 | 550 | 0.195 | 0.17200000000000001 |
11192 | 11192 | 2020-07-04 | asian | all | 12042 | 0.07 | 905 | 0.147 | 0.157 |
11193 | 11193 | 2020-07-04 | black | 0-17 | 289 | 0.021 | 0 | 0.0 | 0.054 |
11194 | 11194 | 2020-07-04 | black | 18+ | 7131 | 0.045 | 572 | 0.093 | 0.061 |
11195 | 11195 | 2020-07-04 | black | 18-34 | 1983 | 0.037 | 10 | 0.156 | 0.065 |
11196 | 11196 | 2020-07-04 | black | 35-49 | 1642 | 0.038 | 20 | 0.065 | 0.059000000000000004 |
11197 | 11197 | 2020-07-04 | black | 50-64 | 1775 | 0.049 | 81 | 0.08 | 0.064 |
11198 | 11198 | 2020-07-04 | black | 65-79 | 1114 | 0.07 | 219 | 0.112 | 0.055 |
11199 | 11199 | 2020-07-04 | black | 80+ | 617 | 0.076 | 242 | 0.08600000000000001 | 0.048 |
11200 | 11200 | 2020-07-04 | black | all | 7432 | 0.043000000000000003 | 572 | 0.093 | 0.06 |
11201 | 11201 | 2020-07-04 | cdph-other | 0-17 | 2717 | 0.194 | 0 | 0.0 | 0.0 |
11202 | 11202 | 2020-07-04 | cdph-other | 18+ | 23054 | 0.146 | 70 | 0.011 | 0.0 |
11203 | 11203 | 2020-07-04 | cdph-other | 18-34 | 9557 | 0.177 | 0 | 0.0 | 0.0 |
11204 | 11204 | 2020-07-04 | cdph-other | 35-49 | 6638 | 0.153 | 0 | 0.0 | 0.0 |
11205 | 11205 | 2020-07-04 | cdph-other | 50-64 | 4816 | 0.134 | 12 | 0.012 | 0.0 |
11206 | 11206 | 2020-07-04 | cdph-other | 65-79 | 1509 | 0.095 | 19 | 0.01 | 0.0 |
11207 | 11207 | 2020-07-04 | cdph-other | 80+ | 534 | 0.066 | 39 | 0.014 | 0.0 |
11208 | 11208 | 2020-07-04 | cdph-other | all | 25774 | 0.15 | 70 | 0.011 | 0.0 |
11209 | 11209 | 2020-07-04 | latino | 0-17 | 9424 | 0.672 | 0 | 0.0 | 0.47900000000000004 |
11210 | 11210 | 2020-07-04 | latino | 18+ | 85892 | 0.545 | 2587 | 0.42 | 0.363 |
11211 | 11211 | 2020-07-04 | latino | 18-34 | 31870 | 0.589 | 39 | 0.609 | 0.45 |
11212 | 11212 | 2020-07-04 | latino | 35-49 | 25708 | 0.592 | 235 | 0.768 | 0.41500000000000004 |
11213 | 11213 | 2020-07-04 | latino | 50-64 | 19289 | 0.535 | 635 | 0.627 | 0.322 |
11214 | 11214 | 2020-07-04 | latino | 65-79 | 6572 | 0.41300000000000003 | 863 | 0.443 | 0.218 |
11215 | 11215 | 2020-07-04 | latino | 80+ | 2453 | 0.301 | 815 | 0.28800000000000003 | 0.196 |
11216 | 11216 | 2020-07-04 | latino | all | 95380 | 0.555 | 2588 | 0.42 | 0.389 |
11217 | 11217 | 2020-07-04 | other | 0-17 | 103 | 0.007 | 0 | 0.0 | 0.044 |
11218 | 11218 | 2020-07-04 | other | 18+ | 1463 | 0.009000000000000001 | 57 | 0.01 | 0.022 |
11219 | 11219 | 2020-07-04 | other | 18-34 | 517 | 0.01 | 2 | 0.031 | 0.032 |
11220 | 11220 | 2020-07-04 | other | 35-49 | 383 | 0.009000000000000001 | 6 | 0.019 | 0.021 |
11221 | 11221 | 2020-07-04 | other | 50-64 | 344 | 0.01 | 8 | 0.008 | 0.017 |
11222 | 11222 | 2020-07-04 | other | 65-79 | 139 | 0.009000000000000001 | 15 | 0.008 | 0.015 |
11223 | 11223 | 2020-07-04 | other | 80+ | 80 | 0.009000000000000001 | 26 | 0.01 | 0.013000000000000001 |
11224 | 11224 | 2020-07-04 | other | all | 1566 | 0.009000000000000001 | 57 | 0.01 | 0.027 |
11225 | 11225 | 2020-07-04 | white | 0-17 | 1140 | 0.081 | 0 | 0.0 | 0.292 |
11226 | 11226 | 2020-07-04 | white | 18+ | 28430 | 0.18 | 1971 | 0.32 | 0.388 |
11227 | 11227 | 2020-07-04 | white | 18-34 | 7418 | 0.137 | 9 | 0.14100000000000001 | 0.302 |
11228 | 11228 | 2020-07-04 | white | 35-49 | 5938 | 0.137 | 22 | 0.07200000000000001 | 0.325 |
11229 | 11229 | 2020-07-04 | white | 50-64 | 6808 | 0.189 | 187 | 0.185 | 0.43 |
11230 | 11230 | 2020-07-04 | white | 65-79 | 4991 | 0.313 | 595 | 0.305 | 0.54 |
11231 | 11231 | 2020-07-04 | white | 80+ | 3275 | 0.402 | 1158 | 0.40900000000000003 | 0.5720000000000001 |
11232 | 11232 | 2020-07-04 | white | all | 29598 | 0.17200000000000001 | 1971 | 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 );