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-07 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 |
---|---|---|---|---|---|---|---|---|---|
11079 | 11079 | 2020-07-07 | other | 80+ | 84 | 0.009000000000000001 | 25 | 0.008 | 0.013000000000000001 |
11073 | 11073 | 2020-07-07 | other | 0-17 | 113 | 0.007 | 0 | 0.0 | 0.044 |
11078 | 11078 | 2020-07-07 | other | 65-79 | 150 | 0.009000000000000001 | 15 | 0.007 | 0.015 |
11049 | 11049 | 2020-07-07 | black | 0-17 | 326 | 0.021 | 0 | 0.0 | 0.054 |
11077 | 11077 | 2020-07-07 | other | 50-64 | 367 | 0.01 | 8 | 0.008 | 0.017 |
11041 | 11041 | 2020-07-07 | asian | 0-17 | 409 | 0.027 | 0 | 0.0 | 0.13 |
11076 | 11076 | 2020-07-07 | other | 35-49 | 422 | 0.009000000000000001 | 6 | 0.018000000000000002 | 0.021 |
11063 | 11063 | 2020-07-07 | cdph-other | 80+ | 565 | 0.066 | 39 | 0.013000000000000001 | 0.0 |
11075 | 11075 | 2020-07-07 | other | 18-34 | 576 | 0.01 | 2 | 0.027 | 0.032 |
11055 | 11055 | 2020-07-07 | black | 80+ | 646 | 0.075 | 244 | 0.084 | 0.048 |
11054 | 11054 | 2020-07-07 | black | 65-79 | 1163 | 0.069 | 223 | 0.111 | 0.055 |
11047 | 11047 | 2020-07-07 | asian | 80+ | 1240 | 0.14400000000000002 | 558 | 0.191 | 0.17200000000000001 |
11081 | 11081 | 2020-07-07 | white | 0-17 | 1320 | 0.08600000000000001 | 0 | 0.0 | 0.292 |
11074 | 11074 | 2020-07-07 | other | 18+ | 1599 | 0.009000000000000001 | 56 | 0.009000000000000001 | 0.022 |
11046 | 11046 | 2020-07-07 | asian | 65-79 | 1657 | 0.098 | 242 | 0.12 | 0.17200000000000001 |
11062 | 11062 | 2020-07-07 | cdph-other | 65-79 | 1687 | 0.1 | 23 | 0.01 | 0.0 |
11080 | 11080 | 2020-07-07 | other | all | 1713 | 0.009000000000000001 | 56 | 0.009000000000000001 | 0.027 |
11052 | 11052 | 2020-07-07 | black | 35-49 | 1814 | 0.039 | 21 | 0.065 | 0.059000000000000004 |
11053 | 11053 | 2020-07-07 | black | 50-64 | 1923 | 0.05 | 83 | 0.08 | 0.064 |
11051 | 11051 | 2020-07-07 | black | 18-34 | 2240 | 0.038 | 11 | 0.149 | 0.065 |
11071 | 11071 | 2020-07-07 | latino | 80+ | 2586 | 0.302 | 862 | 0.295 | 0.196 |
11043 | 11043 | 2020-07-07 | asian | 18-34 | 2995 | 0.05 | 5 | 0.068 | 0.151 |
11057 | 11057 | 2020-07-07 | cdph-other | 0-17 | 3067 | 0.199 | 0 | 0.0 | 0.0 |
11045 | 11045 | 2020-07-07 | asian | 50-64 | 3169 | 0.081 | 91 | 0.08700000000000001 | 0.167 |
11044 | 11044 | 2020-07-07 | asian | 35-49 | 3277 | 0.07 | 24 | 0.074 | 0.179 |
11087 | 11087 | 2020-07-07 | white | 80+ | 3448 | 0.402 | 1194 | 0.40900000000000003 | 0.5720000000000001 |
11086 | 11086 | 2020-07-07 | white | 65-79 | 5281 | 0.313 | 610 | 0.303 | 0.54 |
11061 | 11061 | 2020-07-07 | cdph-other | 50-64 | 5451 | 0.14100000000000001 | 12 | 0.012 | 0.0 |
11084 | 11084 | 2020-07-07 | white | 35-49 | 6587 | 0.14 | 22 | 0.068 | 0.325 |
11070 | 11070 | 2020-07-07 | latino | 65-79 | 6960 | 0.41200000000000003 | 899 | 0.447 | 0.218 |
11085 | 11085 | 2020-07-07 | white | 50-64 | 7395 | 0.191 | 190 | 0.182 | 0.43 |
11060 | 11060 | 2020-07-07 | cdph-other | 35-49 | 7635 | 0.162 | 1 | 0.003 | 0.0 |
11050 | 11050 | 2020-07-07 | black | 18+ | 7786 | 0.046 | 582 | 0.091 | 0.061 |
11056 | 11056 | 2020-07-07 | black | all | 8125 | 0.044 | 582 | 0.091 | 0.06 |
11083 | 11083 | 2020-07-07 | white | 18-34 | 8386 | 0.14200000000000002 | 10 | 0.135 | 0.302 |
11065 | 11065 | 2020-07-07 | latino | 0-17 | 10159 | 0.66 | 0 | 0.0 | 0.47900000000000004 |
11059 | 11059 | 2020-07-07 | cdph-other | 18-34 | 10975 | 0.186 | 1 | 0.014 | 0.0 |
11042 | 11042 | 2020-07-07 | asian | 18+ | 12338 | 0.07200000000000001 | 920 | 0.14400000000000002 | 0.165 |
11048 | 11048 | 2020-07-07 | asian | all | 12758 | 0.069 | 920 | 0.14400000000000002 | 0.157 |
11069 | 11069 | 2020-07-07 | latino | 50-64 | 20464 | 0.528 | 659 | 0.632 | 0.322 |
11058 | 11058 | 2020-07-07 | cdph-other | 18+ | 26313 | 0.154 | 76 | 0.012 | 0.0 |
11068 | 11068 | 2020-07-07 | latino | 35-49 | 27267 | 0.58 | 249 | 0.771 | 0.41500000000000004 |
11064 | 11064 | 2020-07-07 | cdph-other | all | 29384 | 0.158 | 76 | 0.012 | 0.0 |
11082 | 11082 | 2020-07-07 | white | 18+ | 31097 | 0.183 | 2026 | 0.318 | 0.388 |
11088 | 11088 | 2020-07-07 | white | all | 32447 | 0.17500000000000002 | 2026 | 0.318 | 0.366 |
11067 | 11067 | 2020-07-07 | latino | 18-34 | 33960 | 0.5740000000000001 | 45 | 0.608 | 0.45 |
11066 | 11066 | 2020-07-07 | latino | 18+ | 91237 | 0.536 | 2714 | 0.426 | 0.363 |
11072 | 11072 | 2020-07-07 | latino | all | 101464 | 0.546 | 2715 | 0.426 | 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 );