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-11
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 |
---|---|---|---|---|---|---|---|---|---|
10897 | 10897 | 2020-07-11 | asian | 0-17 | 440 | 0.025 | 0 | 0.0 | 0.13 |
10898 | 10898 | 2020-07-11 | asian | 18+ | 13265 | 0.07 | 966 | 0.14 | 0.165 |
10899 | 10899 | 2020-07-11 | asian | 18-34 | 3298 | 0.05 | 6 | 0.074 | 0.151 |
10900 | 10900 | 2020-07-11 | asian | 35-49 | 3537 | 0.068 | 25 | 0.069 | 0.179 |
10901 | 10901 | 2020-07-11 | asian | 50-64 | 3377 | 0.079 | 96 | 0.083 | 0.167 |
10902 | 10902 | 2020-07-11 | asian | 65-79 | 1767 | 0.096 | 262 | 0.11900000000000001 | 0.17200000000000001 |
10903 | 10903 | 2020-07-11 | asian | 80+ | 1286 | 0.14 | 577 | 0.187 | 0.17200000000000001 |
10904 | 10904 | 2020-07-11 | asian | all | 13716 | 0.067 | 966 | 0.14 | 0.157 |
10905 | 10905 | 2020-07-11 | black | 0-17 | 376 | 0.022 | 0 | 0.0 | 0.054 |
10906 | 10906 | 2020-07-11 | black | 18+ | 8632 | 0.046 | 613 | 0.089 | 0.061 |
10907 | 10907 | 2020-07-11 | black | 18-34 | 2551 | 0.038 | 12 | 0.148 | 0.065 |
10908 | 10908 | 2020-07-11 | black | 35-49 | 2030 | 0.039 | 21 | 0.058 | 0.059000000000000004 |
10909 | 10909 | 2020-07-11 | black | 50-64 | 2114 | 0.05 | 86 | 0.074 | 0.064 |
10910 | 10910 | 2020-07-11 | black | 65-79 | 1248 | 0.068 | 236 | 0.107 | 0.055 |
10911 | 10911 | 2020-07-11 | black | 80+ | 689 | 0.075 | 258 | 0.084 | 0.048 |
10912 | 10912 | 2020-07-11 | black | all | 9021 | 0.044 | 613 | 0.089 | 0.06 |
10913 | 10913 | 2020-07-11 | cdph-other | 0-17 | 3297 | 0.19 | 0 | 0.0 | 0.0 |
10914 | 10914 | 2020-07-11 | cdph-other | 18+ | 28758 | 0.152 | 84 | 0.012 | 0.0 |
10915 | 10915 | 2020-07-11 | cdph-other | 18-34 | 12036 | 0.181 | 0 | 0.0 | 0.0 |
10916 | 10916 | 2020-07-11 | cdph-other | 35-49 | 8358 | 0.161 | 1 | 0.003 | 0.0 |
10917 | 10917 | 2020-07-11 | cdph-other | 50-64 | 5950 | 0.14 | 13 | 0.011 | 0.0 |
10918 | 10918 | 2020-07-11 | cdph-other | 65-79 | 1817 | 0.099 | 27 | 0.012 | 0.0 |
10919 | 10919 | 2020-07-11 | cdph-other | 80+ | 597 | 0.065 | 43 | 0.014 | 0.0 |
10920 | 10920 | 2020-07-11 | cdph-other | all | 32060 | 0.156 | 84 | 0.012 | 0.0 |
10921 | 10921 | 2020-07-11 | latino | 0-17 | 11564 | 0.666 | 0 | 0.0 | 0.47900000000000004 |
10922 | 10922 | 2020-07-11 | latino | 18+ | 101215 | 0.537 | 3020 | 0.438 | 0.363 |
10923 | 10923 | 2020-07-11 | latino | 18-34 | 38161 | 0.5740000000000001 | 52 | 0.642 | 0.45 |
10924 | 10924 | 2020-07-11 | latino | 35-49 | 30218 | 0.58 | 282 | 0.781 | 0.41500000000000004 |
10925 | 10925 | 2020-07-11 | latino | 50-64 | 22412 | 0.528 | 745 | 0.642 | 0.322 |
10926 | 10926 | 2020-07-11 | latino | 65-79 | 7634 | 0.41600000000000004 | 1007 | 0.458 | 0.218 |
10927 | 10927 | 2020-07-11 | latino | 80+ | 2790 | 0.304 | 934 | 0.302 | 0.196 |
10928 | 10928 | 2020-07-11 | latino | all | 112854 | 0.548 | 3020 | 0.438 | 0.389 |
10929 | 10929 | 2020-07-11 | other | 0-17 | 145 | 0.008 | 0 | 0.0 | 0.044 |
10930 | 10930 | 2020-07-11 | other | 18+ | 1831 | 0.009000000000000001 | 65 | 0.01 | 0.022 |
10931 | 10931 | 2020-07-11 | other | 18-34 | 681 | 0.01 | 2 | 0.025 | 0.032 |
10932 | 10932 | 2020-07-11 | other | 35-49 | 479 | 0.009000000000000001 | 6 | 0.017 | 0.021 |
10933 | 10933 | 2020-07-11 | other | 50-64 | 413 | 0.01 | 8 | 0.007 | 0.017 |
10934 | 10934 | 2020-07-11 | other | 65-79 | 171 | 0.009000000000000001 | 20 | 0.009000000000000001 | 0.015 |
10935 | 10935 | 2020-07-11 | other | 80+ | 87 | 0.009000000000000001 | 29 | 0.01 | 0.013000000000000001 |
10936 | 10936 | 2020-07-11 | other | all | 1977 | 0.009000000000000001 | 65 | 0.01 | 0.027 |
10937 | 10937 | 2020-07-11 | white | 0-17 | 1553 | 0.089 | 0 | 0.0 | 0.292 |
10938 | 10938 | 2020-07-11 | white | 18+ | 34895 | 0.185 | 2140 | 0.311 | 0.388 |
10939 | 10939 | 2020-07-11 | white | 18-34 | 9768 | 0.147 | 9 | 0.111 | 0.302 |
10940 | 10940 | 2020-07-11 | white | 35-49 | 7447 | 0.14300000000000002 | 26 | 0.07200000000000001 | 0.325 |
10941 | 10941 | 2020-07-11 | white | 50-64 | 8208 | 0.193 | 212 | 0.183 | 0.43 |
10942 | 10942 | 2020-07-11 | white | 65-79 | 5732 | 0.312 | 646 | 0.294 | 0.54 |
10943 | 10943 | 2020-07-11 | white | 80+ | 3740 | 0.40700000000000003 | 1247 | 0.404 | 0.5720000000000001 |
10944 | 10944 | 2020-07-11 | white | all | 36481 | 0.177 | 2140 | 0.311 | 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 );