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.
12,960 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|
12960 | 12960 | 2020-05-14 | white | all | 11956 | 0.234 | 991 | 0.343 | 0.366 |
12959 | 12959 | 2020-05-14 | white | 80+ | 1665 | 0.438 | 569 | 0.421 | 0.5720000000000001 |
12958 | 12958 | 2020-05-14 | white | 65-79 | 2433 | 0.36 | 312 | 0.337 | 0.54 |
12957 | 12957 | 2020-05-14 | white | 50-64 | 3062 | 0.23700000000000002 | 96 | 0.219 | 0.43 |
12956 | 12956 | 2020-05-14 | white | 35-49 | 2392 | 0.185 | 11 | 0.078 | 0.325 |
12955 | 12955 | 2020-05-14 | white | 18-34 | 2199 | 0.17300000000000001 | 3 | 0.111 | 0.302 |
12954 | 12954 | 2020-05-14 | white | 0-17 | 197 | 0.10300000000000001 | 0 | 0.0 | 0.292 |
12953 | 12953 | 2020-05-14 | other | all | 546 | 0.011 | 24 | 0.009000000000000001 | 0.027 |
12952 | 12952 | 2020-05-14 | other | 80+ | 28 | 0.007 | 9 | 0.006 | 0.013000000000000001 |
12951 | 12951 | 2020-05-14 | other | 65-79 | 66 | 0.01 | 10 | 0.01 | 0.015 |
12950 | 12950 | 2020-05-14 | other | 50-64 | 128 | 0.01 | 2 | 0.004 | 0.017 |
12949 | 12949 | 2020-05-14 | other | 35-49 | 136 | 0.01 | 3 | 0.021 | 0.021 |
12948 | 12948 | 2020-05-14 | other | 18-34 | 168 | 0.013000000000000001 | 0 | 0.0 | 0.032 |
12947 | 12947 | 2020-05-14 | other | 0-17 | 20 | 0.011 | 0 | 0.0 | 0.044 |
12946 | 12946 | 2020-05-14 | latino | all | 26880 | 0.526 | 1060 | 0.367 | 0.389 |
12945 | 12945 | 2020-05-14 | latino | 80+ | 972 | 0.256 | 348 | 0.257 | 0.196 |
12944 | 12944 | 2020-05-14 | latino | 65-79 | 2466 | 0.365 | 360 | 0.389 | 0.218 |
12943 | 12943 | 2020-05-14 | latino | 50-64 | 6506 | 0.503 | 234 | 0.533 | 0.322 |
12942 | 12942 | 2020-05-14 | latino | 35-49 | 7530 | 0.583 | 102 | 0.723 | 0.41500000000000004 |
12941 | 12941 | 2020-05-14 | latino | 18-34 | 7899 | 0.621 | 16 | 0.593 | 0.45 |
12940 | 12940 | 2020-05-14 | latino | 0-17 | 1491 | 0.779 | 0 | 0.0 | 0.47900000000000004 |
12939 | 12939 | 2020-05-14 | cdph-other | all | 2734 | 0.054 | 40 | 0.014 | 0.0 |
12938 | 12938 | 2020-05-14 | cdph-other | 80+ | 155 | 0.041 | 15 | 0.011 | 0.0 |
12937 | 12937 | 2020-05-14 | cdph-other | 65-79 | 354 | 0.052000000000000005 | 17 | 0.018000000000000002 | 0.0 |
12936 | 12936 | 2020-05-14 | cdph-other | 50-64 | 765 | 0.059000000000000004 | 7 | 0.016 | 0.0 |
12935 | 12935 | 2020-05-14 | cdph-other | 35-49 | 690 | 0.053 | 0 | 0.0 | 0.0 |
12934 | 12934 | 2020-05-14 | cdph-other | 18-34 | 684 | 0.054 | 1 | 0.037 | 0.0 |
12933 | 12933 | 2020-05-14 | cdph-other | 0-17 | 83 | 0.043000000000000003 | 0 | 0.0 | 0.0 |
12932 | 12932 | 2020-05-14 | black | all | 3026 | 0.059000000000000004 | 292 | 0.101 | 0.06 |
12931 | 12931 | 2020-05-14 | black | 80+ | 308 | 0.081 | 117 | 0.08600000000000001 | 0.048 |
12930 | 12930 | 2020-05-14 | black | 65-79 | 567 | 0.084 | 110 | 0.11900000000000001 | 0.055 |
12929 | 12929 | 2020-05-14 | black | 50-64 | 851 | 0.066 | 47 | 0.107 | 0.064 |
12928 | 12928 | 2020-05-14 | black | 35-49 | 661 | 0.051000000000000004 | 14 | 0.099 | 0.059000000000000004 |
12927 | 12927 | 2020-05-14 | black | 18-34 | 594 | 0.047 | 4 | 0.148 | 0.065 |
12926 | 12926 | 2020-05-14 | black | 0-17 | 44 | 0.023 | 0 | 0.0 | 0.054 |
12925 | 12925 | 2020-05-14 | asian | all | 5941 | 0.116 | 480 | 0.167 | 0.157 |
12924 | 12924 | 2020-05-14 | asian | 80+ | 676 | 0.178 | 295 | 0.218 | 0.17200000000000001 |
12923 | 12923 | 2020-05-14 | asian | 65-79 | 873 | 0.129 | 117 | 0.127 | 0.17200000000000001 |
12922 | 12922 | 2020-05-14 | asian | 50-64 | 1627 | 0.126 | 53 | 0.121 | 0.167 |
12921 | 12921 | 2020-05-14 | asian | 35-49 | 1498 | 0.116 | 11 | 0.078 | 0.179 |
12920 | 12920 | 2020-05-14 | asian | 18-34 | 1177 | 0.092 | 3 | 0.111 | 0.151 |
12919 | 12919 | 2020-05-14 | asian | 0-17 | 80 | 0.042 | 0 | 0.0 | 0.13 |
12918 | 12918 | 2020-05-15 | white | all | 12153 | 0.23 | 1021 | 0.341 | 0.366 |
12917 | 12917 | 2020-05-15 | white | 80+ | 1697 | 0.435 | 588 | 0.418 | 0.5720000000000001 |
12916 | 12916 | 2020-05-15 | white | 65-79 | 2471 | 0.357 | 320 | 0.333 | 0.54 |
12915 | 12915 | 2020-05-15 | white | 50-64 | 3107 | 0.233 | 98 | 0.218 | 0.43 |
12914 | 12914 | 2020-05-15 | white | 35-49 | 2433 | 0.183 | 12 | 0.082 | 0.325 |
12913 | 12913 | 2020-05-15 | white | 18-34 | 2234 | 0.169 | 3 | 0.10300000000000001 | 0.302 |
12912 | 12912 | 2020-05-15 | white | 0-17 | 202 | 0.1 | 0 | 0.0 | 0.292 |
12911 | 12911 | 2020-05-15 | other | all | 582 | 0.011 | 31 | 0.01 | 0.027 |
12910 | 12910 | 2020-05-15 | other | 80+ | 32 | 0.008 | 10 | 0.007 | 0.013000000000000001 |
12909 | 12909 | 2020-05-15 | other | 65-79 | 72 | 0.011 | 12 | 0.012 | 0.015 |
12908 | 12908 | 2020-05-15 | other | 50-64 | 133 | 0.01 | 4 | 0.008 | 0.017 |
12907 | 12907 | 2020-05-15 | other | 35-49 | 153 | 0.011 | 4 | 0.028 | 0.021 |
12906 | 12906 | 2020-05-15 | other | 18-34 | 172 | 0.013000000000000001 | 1 | 0.034 | 0.032 |
12905 | 12905 | 2020-05-15 | other | 0-17 | 20 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12904 | 12904 | 2020-05-15 | latino | all | 27943 | 0.53 | 1110 | 0.371 | 0.389 |
12903 | 12903 | 2020-05-15 | latino | 80+ | 1000 | 0.256 | 368 | 0.262 | 0.196 |
12902 | 12902 | 2020-05-15 | latino | 65-79 | 2545 | 0.367 | 376 | 0.392 | 0.218 |
12901 | 12901 | 2020-05-15 | latino | 50-64 | 6750 | 0.507 | 242 | 0.538 | 0.322 |
12900 | 12900 | 2020-05-15 | latino | 35-49 | 7803 | 0.586 | 106 | 0.726 | 0.41500000000000004 |
12899 | 12899 | 2020-05-15 | latino | 18-34 | 8256 | 0.625 | 18 | 0.621 | 0.45 |
12898 | 12898 | 2020-05-15 | latino | 0-17 | 1575 | 0.782 | 0 | 0.0 | 0.47900000000000004 |
12897 | 12897 | 2020-05-15 | cdph-other | all | 2751 | 0.052000000000000005 | 38 | 0.013000000000000001 | 0.0 |
12896 | 12896 | 2020-05-15 | cdph-other | 80+ | 155 | 0.04 | 14 | 0.01 | 0.0 |
12895 | 12895 | 2020-05-15 | cdph-other | 65-79 | 363 | 0.052000000000000005 | 17 | 0.018000000000000002 | 0.0 |
12894 | 12894 | 2020-05-15 | cdph-other | 50-64 | 768 | 0.058 | 6 | 0.013000000000000001 | 0.0 |
12893 | 12893 | 2020-05-15 | cdph-other | 35-49 | 688 | 0.052000000000000005 | 0 | 0.0 | 0.0 |
12892 | 12892 | 2020-05-15 | cdph-other | 18-34 | 691 | 0.052000000000000005 | 1 | 0.034 | 0.0 |
12891 | 12891 | 2020-05-15 | cdph-other | 0-17 | 84 | 0.042 | 0 | 0.0 | 0.0 |
12890 | 12890 | 2020-05-15 | black | all | 3178 | 0.06 | 304 | 0.10200000000000001 | 0.06 |
12889 | 12889 | 2020-05-15 | black | 80+ | 326 | 0.084 | 127 | 0.09 | 0.048 |
12888 | 12888 | 2020-05-15 | black | 65-79 | 585 | 0.084 | 112 | 0.117 | 0.055 |
12887 | 12887 | 2020-05-15 | black | 50-64 | 887 | 0.067 | 48 | 0.107 | 0.064 |
12886 | 12886 | 2020-05-15 | black | 35-49 | 694 | 0.052000000000000005 | 14 | 0.096 | 0.059000000000000004 |
12885 | 12885 | 2020-05-15 | black | 18-34 | 638 | 0.048 | 3 | 0.10300000000000001 | 0.065 |
12884 | 12884 | 2020-05-15 | black | 0-17 | 47 | 0.023 | 0 | 0.0 | 0.054 |
12883 | 12883 | 2020-05-15 | asian | all | 6118 | 0.116 | 489 | 0.163 | 0.157 |
12882 | 12882 | 2020-05-15 | asian | 80+ | 691 | 0.177 | 300 | 0.213 | 0.17200000000000001 |
12881 | 12881 | 2020-05-15 | asian | 65-79 | 893 | 0.129 | 123 | 0.128 | 0.17200000000000001 |
12880 | 12880 | 2020-05-15 | asian | 50-64 | 1672 | 0.126 | 52 | 0.116 | 0.167 |
12879 | 12879 | 2020-05-15 | asian | 35-49 | 1547 | 0.116 | 10 | 0.069 | 0.179 |
12878 | 12878 | 2020-05-15 | asian | 18-34 | 1218 | 0.092 | 3 | 0.10300000000000001 | 0.151 |
12877 | 12877 | 2020-05-15 | asian | 0-17 | 87 | 0.043000000000000003 | 0 | 0.0 | 0.13 |
12876 | 12876 | 2020-05-16 | white | all | 12452 | 0.228 | 1039 | 0.34 | 0.366 |
12875 | 12875 | 2020-05-16 | white | 80+ | 1728 | 0.432 | 603 | 0.417 | 0.5720000000000001 |
12874 | 12874 | 2020-05-16 | white | 65-79 | 2514 | 0.355 | 322 | 0.331 | 0.54 |
12873 | 12873 | 2020-05-16 | white | 50-64 | 3183 | 0.232 | 99 | 0.215 | 0.43 |
12872 | 12872 | 2020-05-16 | white | 35-49 | 2493 | 0.181 | 12 | 0.082 | 0.325 |
12871 | 12871 | 2020-05-16 | white | 18-34 | 2299 | 0.167 | 3 | 0.097 | 0.302 |
12870 | 12870 | 2020-05-16 | white | 0-17 | 226 | 0.10300000000000001 | 0 | 0.0 | 0.292 |
12869 | 12869 | 2020-05-16 | other | all | 594 | 0.011 | 34 | 0.012 | 0.027 |
12868 | 12868 | 2020-05-16 | other | 80+ | 37 | 0.009000000000000001 | 13 | 0.009000000000000001 | 0.013000000000000001 |
12867 | 12867 | 2020-05-16 | other | 65-79 | 73 | 0.01 | 12 | 0.012 | 0.015 |
12866 | 12866 | 2020-05-16 | other | 50-64 | 134 | 0.01 | 4 | 0.008 | 0.017 |
12865 | 12865 | 2020-05-16 | other | 35-49 | 157 | 0.011 | 4 | 0.028 | 0.021 |
12864 | 12864 | 2020-05-16 | other | 18-34 | 172 | 0.013000000000000001 | 1 | 0.032 | 0.032 |
12863 | 12863 | 2020-05-16 | other | 0-17 | 21 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12862 | 12862 | 2020-05-16 | latino | all | 29208 | 0.535 | 1137 | 0.372 | 0.389 |
12861 | 12861 | 2020-05-16 | latino | 80+ | 1033 | 0.258 | 381 | 0.264 | 0.196 |
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 );