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-02
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 |
---|---|---|---|---|---|---|---|---|---|
11281 | 11281 | 2020-07-02 | asian | 0-17 | 331 | 0.025 | 0 | 0.0 | 0.13 |
11282 | 11282 | 2020-07-02 | asian | 18+ | 11292 | 0.075 | 900 | 0.148 | 0.165 |
11283 | 11283 | 2020-07-02 | asian | 18-34 | 2651 | 0.052000000000000005 | 4 | 0.062 | 0.151 |
11284 | 11284 | 2020-07-02 | asian | 35-49 | 2992 | 0.07200000000000001 | 23 | 0.077 | 0.179 |
11285 | 11285 | 2020-07-02 | asian | 50-64 | 2929 | 0.084 | 90 | 0.09 | 0.167 |
11286 | 11286 | 2020-07-02 | asian | 65-79 | 1550 | 0.1 | 237 | 0.122 | 0.17200000000000001 |
11287 | 11287 | 2020-07-02 | asian | 80+ | 1170 | 0.146 | 546 | 0.195 | 0.17200000000000001 |
11288 | 11288 | 2020-07-02 | asian | all | 11633 | 0.07100000000000001 | 900 | 0.147 | 0.157 |
11289 | 11289 | 2020-07-02 | black | 0-17 | 262 | 0.02 | 0 | 0.0 | 0.054 |
11290 | 11290 | 2020-07-02 | black | 18+ | 6871 | 0.046 | 570 | 0.093 | 0.061 |
11291 | 11291 | 2020-07-02 | black | 18-34 | 1868 | 0.037 | 10 | 0.156 | 0.065 |
11292 | 11292 | 2020-07-02 | black | 35-49 | 1583 | 0.038 | 20 | 0.067 | 0.059000000000000004 |
11293 | 11293 | 2020-07-02 | black | 50-64 | 1724 | 0.05 | 80 | 0.08 | 0.064 |
11294 | 11294 | 2020-07-02 | black | 65-79 | 1086 | 0.07100000000000001 | 219 | 0.113 | 0.055 |
11295 | 11295 | 2020-07-02 | black | 80+ | 610 | 0.077 | 241 | 0.08600000000000001 | 0.048 |
11296 | 11296 | 2020-07-02 | black | all | 7144 | 0.044 | 570 | 0.093 | 0.06 |
11297 | 11297 | 2020-07-02 | cdph-other | 0-17 | 2627 | 0.198 | 0 | 0.0 | 0.0 |
11298 | 11298 | 2020-07-02 | cdph-other | 18+ | 21956 | 0.146 | 68 | 0.011 | 0.0 |
11299 | 11299 | 2020-07-02 | cdph-other | 18-34 | 9079 | 0.177 | 0 | 0.0 | 0.0 |
11300 | 11300 | 2020-07-02 | cdph-other | 35-49 | 6276 | 0.151 | 0 | 0.0 | 0.0 |
11301 | 11301 | 2020-07-02 | cdph-other | 50-64 | 4635 | 0.134 | 12 | 0.012 | 0.0 |
11302 | 11302 | 2020-07-02 | cdph-other | 65-79 | 1448 | 0.094 | 19 | 0.01 | 0.0 |
11303 | 11303 | 2020-07-02 | cdph-other | 80+ | 518 | 0.065 | 37 | 0.013000000000000001 | 0.0 |
11304 | 11304 | 2020-07-02 | cdph-other | all | 24585 | 0.15 | 68 | 0.011 | 0.0 |
11305 | 11305 | 2020-07-02 | latino | 0-17 | 8928 | 0.672 | 0 | 0.0 | 0.47900000000000004 |
11306 | 11306 | 2020-07-02 | latino | 18+ | 82328 | 0.547 | 2545 | 0.417 | 0.363 |
11307 | 11307 | 2020-07-02 | latino | 18-34 | 30324 | 0.593 | 40 | 0.625 | 0.45 |
11308 | 11308 | 2020-07-02 | latino | 35-49 | 24631 | 0.594 | 228 | 0.765 | 0.41500000000000004 |
11309 | 11309 | 2020-07-02 | latino | 50-64 | 18601 | 0.536 | 624 | 0.623 | 0.322 |
11310 | 11310 | 2020-07-02 | latino | 65-79 | 6373 | 0.41400000000000003 | 853 | 0.44 | 0.218 |
11311 | 11311 | 2020-07-02 | latino | 80+ | 2399 | 0.301 | 800 | 0.28600000000000003 | 0.196 |
11312 | 11312 | 2020-07-02 | latino | all | 91317 | 0.557 | 2546 | 0.418 | 0.389 |
11313 | 11313 | 2020-07-02 | other | 0-17 | 91 | 0.006 | 0 | 0.0 | 0.044 |
11314 | 11314 | 2020-07-02 | other | 18+ | 1394 | 0.009000000000000001 | 57 | 0.01 | 0.022 |
11315 | 11315 | 2020-07-02 | other | 18-34 | 488 | 0.01 | 2 | 0.031 | 0.032 |
11316 | 11316 | 2020-07-02 | other | 35-49 | 363 | 0.009000000000000001 | 6 | 0.02 | 0.021 |
11317 | 11317 | 2020-07-02 | other | 50-64 | 331 | 0.01 | 8 | 0.008 | 0.017 |
11318 | 11318 | 2020-07-02 | other | 65-79 | 133 | 0.009000000000000001 | 15 | 0.008 | 0.015 |
11319 | 11319 | 2020-07-02 | other | 80+ | 79 | 0.01 | 26 | 0.01 | 0.013000000000000001 |
11320 | 11320 | 2020-07-02 | other | all | 1485 | 0.009000000000000001 | 57 | 0.01 | 0.027 |
11321 | 11321 | 2020-07-02 | white | 0-17 | 1046 | 0.079 | 0 | 0.0 | 0.292 |
11322 | 11322 | 2020-07-02 | white | 18+ | 26799 | 0.178 | 1957 | 0.321 | 0.388 |
11323 | 11323 | 2020-07-02 | white | 18-34 | 6747 | 0.132 | 8 | 0.125 | 0.302 |
11324 | 11324 | 2020-07-02 | white | 35-49 | 5588 | 0.135 | 21 | 0.07 | 0.325 |
11325 | 11325 | 2020-07-02 | white | 50-64 | 6482 | 0.187 | 187 | 0.187 | 0.43 |
11326 | 11326 | 2020-07-02 | white | 65-79 | 4792 | 0.312 | 595 | 0.307 | 0.54 |
11327 | 11327 | 2020-07-02 | white | 80+ | 3190 | 0.4 | 1146 | 0.41000000000000003 | 0.5720000000000001 |
11328 | 11328 | 2020-07-02 | white | all | 27871 | 0.17 | 1957 | 0.321 | 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 );