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-30 sorted by confirmed_cases_total
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 |
---|---|---|---|---|---|---|---|---|---|
11415 | 11415 | 2020-06-30 | other | 80+ | 69 | 0.009000000000000001 | 20 | 0.007 | 0.013000000000000001 |
11409 | 11409 | 2020-06-30 | other | 0-17 | 84 | 0.006 | 0 | 0.0 | 0.044 |
11414 | 11414 | 2020-06-30 | other | 65-79 | 121 | 0.008 | 13 | 0.007 | 0.015 |
11385 | 11385 | 2020-06-30 | black | 0-17 | 236 | 0.019 | 0 | 0.0 | 0.054 |
11377 | 11377 | 2020-06-30 | asian | 0-17 | 312 | 0.026000000000000002 | 0 | 0.0 | 0.13 |
11413 | 11413 | 2020-06-30 | other | 50-64 | 312 | 0.01 | 8 | 0.008 | 0.017 |
11412 | 11412 | 2020-06-30 | other | 35-49 | 340 | 0.009000000000000001 | 6 | 0.02 | 0.021 |
11411 | 11411 | 2020-06-30 | other | 18-34 | 441 | 0.009000000000000001 | 2 | 0.032 | 0.032 |
11399 | 11399 | 2020-06-30 | cdph-other | 80+ | 502 | 0.065 | 35 | 0.013000000000000001 | 0.0 |
11391 | 11391 | 2020-06-30 | black | 80+ | 597 | 0.077 | 235 | 0.08700000000000001 | 0.048 |
11417 | 11417 | 2020-06-30 | white | 0-17 | 937 | 0.076 | 0 | 0.0 | 0.292 |
11390 | 11390 | 2020-06-30 | black | 65-79 | 1061 | 0.07200000000000001 | 214 | 0.113 | 0.055 |
11383 | 11383 | 2020-06-30 | asian | 80+ | 1149 | 0.149 | 531 | 0.196 | 0.17200000000000001 |
11410 | 11410 | 2020-06-30 | other | 18+ | 1283 | 0.009000000000000001 | 49 | 0.009000000000000001 | 0.022 |
11416 | 11416 | 2020-06-30 | other | all | 1367 | 0.009000000000000001 | 49 | 0.009000000000000001 | 0.027 |
11398 | 11398 | 2020-06-30 | cdph-other | 65-79 | 1382 | 0.094 | 18 | 0.01 | 0.0 |
11388 | 11388 | 2020-06-30 | black | 35-49 | 1497 | 0.038 | 20 | 0.07 | 0.059000000000000004 |
11382 | 11382 | 2020-06-30 | asian | 65-79 | 1502 | 0.101 | 233 | 0.124 | 0.17200000000000001 |
11389 | 11389 | 2020-06-30 | black | 50-64 | 1656 | 0.05 | 77 | 0.08 | 0.064 |
11387 | 11387 | 2020-06-30 | black | 18-34 | 1716 | 0.036000000000000004 | 10 | 0.161 | 0.065 |
11407 | 11407 | 2020-06-30 | latino | 80+ | 2317 | 0.30000000000000004 | 769 | 0.28400000000000003 | 0.196 |
11379 | 11379 | 2020-06-30 | asian | 18-34 | 2516 | 0.052000000000000005 | 4 | 0.065 | 0.151 |
11393 | 11393 | 2020-06-30 | cdph-other | 0-17 | 2545 | 0.20600000000000002 | 0 | 0.0 | 0.0 |
11381 | 11381 | 2020-06-30 | asian | 50-64 | 2812 | 0.085 | 88 | 0.091 | 0.167 |
11380 | 11380 | 2020-06-30 | asian | 35-49 | 2859 | 0.073 | 22 | 0.077 | 0.179 |
11423 | 11423 | 2020-06-30 | white | 80+ | 3083 | 0.4 | 1115 | 0.41200000000000003 | 0.5720000000000001 |
11397 | 11397 | 2020-06-30 | cdph-other | 50-64 | 4426 | 0.134 | 11 | 0.011 | 0.0 |
11422 | 11422 | 2020-06-30 | white | 65-79 | 4615 | 0.313 | 579 | 0.307 | 0.54 |
11420 | 11420 | 2020-06-30 | white | 35-49 | 5220 | 0.133 | 21 | 0.073 | 0.325 |
11396 | 11396 | 2020-06-30 | cdph-other | 35-49 | 5999 | 0.153 | 0 | 0.0 | 0.0 |
11406 | 11406 | 2020-06-30 | latino | 65-79 | 6078 | 0.41200000000000003 | 829 | 0.44 | 0.218 |
11419 | 11419 | 2020-06-30 | white | 18-34 | 6096 | 0.128 | 7 | 0.113 | 0.302 |
11421 | 11421 | 2020-06-30 | white | 50-64 | 6149 | 0.186 | 180 | 0.187 | 0.43 |
11386 | 11386 | 2020-06-30 | black | 18+ | 6527 | 0.046 | 556 | 0.094 | 0.061 |
11392 | 11392 | 2020-06-30 | black | all | 6774 | 0.044 | 556 | 0.094 | 0.06 |
11401 | 11401 | 2020-06-30 | latino | 0-17 | 8266 | 0.668 | 0 | 0.0 | 0.47900000000000004 |
11395 | 11395 | 2020-06-30 | cdph-other | 18-34 | 8616 | 0.181 | 0 | 0.0 | 0.0 |
11378 | 11378 | 2020-06-30 | asian | 18+ | 10838 | 0.076 | 878 | 0.149 | 0.165 |
11384 | 11384 | 2020-06-30 | asian | all | 11160 | 0.07200000000000001 | 878 | 0.149 | 0.157 |
11405 | 11405 | 2020-06-30 | latino | 50-64 | 17703 | 0.536 | 600 | 0.622 | 0.322 |
11394 | 11394 | 2020-06-30 | cdph-other | 18+ | 20925 | 0.147 | 64 | 0.011 | 0.0 |
11404 | 11404 | 2020-06-30 | latino | 35-49 | 23264 | 0.594 | 218 | 0.76 | 0.41500000000000004 |
11400 | 11400 | 2020-06-30 | cdph-other | all | 23472 | 0.152 | 64 | 0.011 | 0.0 |
11418 | 11418 | 2020-06-30 | white | 18+ | 25163 | 0.177 | 1902 | 0.322 | 0.388 |
11424 | 11424 | 2020-06-30 | white | all | 26127 | 0.169 | 1902 | 0.322 | 0.366 |
11403 | 11403 | 2020-06-30 | latino | 18-34 | 28323 | 0.594 | 39 | 0.629 | 0.45 |
11402 | 11402 | 2020-06-30 | latino | 18+ | 77685 | 0.545 | 2455 | 0.41600000000000004 | 0.363 |
11408 | 11408 | 2020-06-30 | latino | all | 86009 | 0.555 | 2456 | 0.41600000000000004 | 0.389 |
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 );