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-18
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 |
---|---|---|---|---|---|---|---|---|---|
11905 | 11905 | 2020-06-18 | asian | 0-17 | 218 | 0.025 | 0 | 0.0 | 0.13 |
11906 | 11906 | 2020-06-18 | asian | 18+ | 9299 | 0.08600000000000001 | 780 | 0.151 | 0.165 |
11907 | 11907 | 2020-06-18 | asian | 18-34 | 2053 | 0.061 | 4 | 0.069 | 0.151 |
11908 | 11908 | 2020-06-18 | asian | 35-49 | 2410 | 0.082 | 22 | 0.08600000000000001 | 0.179 |
11909 | 11909 | 2020-06-18 | asian | 50-64 | 2493 | 0.095 | 80 | 0.096 | 0.167 |
11910 | 11910 | 2020-06-18 | asian | 65-79 | 1316 | 0.108 | 201 | 0.122 | 0.17200000000000001 |
11911 | 11911 | 2020-06-18 | asian | 80+ | 1027 | 0.155 | 473 | 0.199 | 0.17200000000000001 |
11912 | 11912 | 2020-06-18 | asian | all | 9527 | 0.082 | 780 | 0.151 | 0.157 |
11913 | 11913 | 2020-06-18 | black | 0-17 | 132 | 0.016 | 0 | 0.0 | 0.054 |
11914 | 11914 | 2020-06-18 | black | 18+ | 5160 | 0.048 | 491 | 0.095 | 0.061 |
11915 | 11915 | 2020-06-18 | black | 18-34 | 1198 | 0.035 | 5 | 0.08600000000000001 | 0.065 |
11916 | 11916 | 2020-06-18 | black | 35-49 | 1138 | 0.039 | 20 | 0.078 | 0.059000000000000004 |
11917 | 11917 | 2020-06-18 | black | 50-64 | 1390 | 0.053 | 73 | 0.088 | 0.064 |
11918 | 11918 | 2020-06-18 | black | 65-79 | 910 | 0.075 | 186 | 0.113 | 0.055 |
11919 | 11919 | 2020-06-18 | black | 80+ | 524 | 0.079 | 207 | 0.08700000000000001 | 0.048 |
11920 | 11920 | 2020-06-18 | black | all | 5296 | 0.045 | 491 | 0.095 | 0.06 |
11921 | 11921 | 2020-06-18 | cdph-other | 0-17 | 1578 | 0.187 | 0 | 0.0 | 0.0 |
11922 | 11922 | 2020-06-18 | cdph-other | 18+ | 12691 | 0.117 | 47 | 0.009000000000000001 | 0.0 |
11923 | 11923 | 2020-06-18 | cdph-other | 18-34 | 4731 | 0.14 | 0 | 0.0 | 0.0 |
11924 | 11924 | 2020-06-18 | cdph-other | 35-49 | 3636 | 0.123 | 0 | 0.0 | 0.0 |
11925 | 11925 | 2020-06-18 | cdph-other | 50-64 | 2916 | 0.111 | 8 | 0.01 | 0.0 |
11926 | 11926 | 2020-06-18 | cdph-other | 65-79 | 1003 | 0.083 | 18 | 0.011 | 0.0 |
11927 | 11927 | 2020-06-18 | cdph-other | 80+ | 405 | 0.061 | 21 | 0.009000000000000001 | 0.0 |
11928 | 11928 | 2020-06-18 | cdph-other | all | 14270 | 0.122 | 47 | 0.009000000000000001 | 0.0 |
11929 | 11929 | 2020-06-18 | latino | 0-17 | 5836 | 0.6900000000000001 | 0 | 0.0 | 0.47900000000000004 |
11930 | 11930 | 2020-06-18 | latino | 18+ | 60372 | 0.557 | 2084 | 0.403 | 0.363 |
11931 | 11931 | 2020-06-18 | latino | 18-34 | 21303 | 0.631 | 40 | 0.6900000000000001 | 0.45 |
11932 | 11932 | 2020-06-18 | latino | 35-49 | 17952 | 0.609 | 188 | 0.732 | 0.41500000000000004 |
11933 | 11933 | 2020-06-18 | latino | 50-64 | 14266 | 0.542 | 498 | 0.601 | 0.322 |
11934 | 11934 | 2020-06-18 | latino | 65-79 | 4927 | 0.406 | 706 | 0.429 | 0.218 |
11935 | 11935 | 2020-06-18 | latino | 80+ | 1924 | 0.29 | 652 | 0.275 | 0.196 |
11936 | 11936 | 2020-06-18 | latino | all | 66261 | 0.5670000000000001 | 2085 | 0.404 | 0.389 |
11937 | 11937 | 2020-06-18 | other | 0-17 | 55 | 0.006 | 0 | 0.0 | 0.044 |
11938 | 11938 | 2020-06-18 | other | 18+ | 1000 | 0.009000000000000001 | 51 | 0.01 | 0.022 |
11939 | 11939 | 2020-06-18 | other | 18-34 | 310 | 0.009000000000000001 | 2 | 0.034 | 0.032 |
11940 | 11940 | 2020-06-18 | other | 35-49 | 270 | 0.009000000000000001 | 4 | 0.016 | 0.021 |
11941 | 11941 | 2020-06-18 | other | 50-64 | 251 | 0.01 | 8 | 0.01 | 0.017 |
11942 | 11942 | 2020-06-18 | other | 65-79 | 103 | 0.009000000000000001 | 12 | 0.007 | 0.015 |
11943 | 11943 | 2020-06-18 | other | 80+ | 66 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
11944 | 11944 | 2020-06-18 | other | all | 1055 | 0.009000000000000001 | 51 | 0.01 | 0.027 |
11945 | 11945 | 2020-06-18 | white | 0-17 | 639 | 0.076 | 0 | 0.0 | 0.292 |
11946 | 11946 | 2020-06-18 | white | 18+ | 19811 | 0.183 | 1712 | 0.331 | 0.388 |
11947 | 11947 | 2020-06-18 | white | 18-34 | 4190 | 0.124 | 7 | 0.121 | 0.302 |
11948 | 11948 | 2020-06-18 | white | 35-49 | 4059 | 0.138 | 23 | 0.089 | 0.325 |
11949 | 11949 | 2020-06-18 | white | 50-64 | 5007 | 0.19 | 161 | 0.194 | 0.43 |
11950 | 11950 | 2020-06-18 | white | 65-79 | 3875 | 0.319 | 524 | 0.318 | 0.54 |
11951 | 11951 | 2020-06-18 | white | 80+ | 2680 | 0.404 | 997 | 0.42 | 0.5720000000000001 |
11952 | 11952 | 2020-06-18 | white | all | 20475 | 0.17500000000000002 | 1712 | 0.331 | 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 );