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 date
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 |
---|---|---|---|---|---|---|---|---|---|
12919 | 12919 | 2020-05-14 | asian | 0-17 | 80 | 0.042 | 0 | 0.0 | 0.13 |
12920 | 12920 | 2020-05-14 | asian | 18-34 | 1177 | 0.092 | 3 | 0.111 | 0.151 |
12921 | 12921 | 2020-05-14 | asian | 35-49 | 1498 | 0.116 | 11 | 0.078 | 0.179 |
12922 | 12922 | 2020-05-14 | asian | 50-64 | 1627 | 0.126 | 53 | 0.121 | 0.167 |
12923 | 12923 | 2020-05-14 | asian | 65-79 | 873 | 0.129 | 117 | 0.127 | 0.17200000000000001 |
12924 | 12924 | 2020-05-14 | asian | 80+ | 676 | 0.178 | 295 | 0.218 | 0.17200000000000001 |
12925 | 12925 | 2020-05-14 | asian | all | 5941 | 0.116 | 480 | 0.167 | 0.157 |
12926 | 12926 | 2020-05-14 | black | 0-17 | 44 | 0.023 | 0 | 0.0 | 0.054 |
12927 | 12927 | 2020-05-14 | black | 18-34 | 594 | 0.047 | 4 | 0.148 | 0.065 |
12928 | 12928 | 2020-05-14 | black | 35-49 | 661 | 0.051000000000000004 | 14 | 0.099 | 0.059000000000000004 |
12929 | 12929 | 2020-05-14 | black | 50-64 | 851 | 0.066 | 47 | 0.107 | 0.064 |
12930 | 12930 | 2020-05-14 | black | 65-79 | 567 | 0.084 | 110 | 0.11900000000000001 | 0.055 |
12931 | 12931 | 2020-05-14 | black | 80+ | 308 | 0.081 | 117 | 0.08600000000000001 | 0.048 |
12932 | 12932 | 2020-05-14 | black | all | 3026 | 0.059000000000000004 | 292 | 0.101 | 0.06 |
12933 | 12933 | 2020-05-14 | cdph-other | 0-17 | 83 | 0.043000000000000003 | 0 | 0.0 | 0.0 |
12934 | 12934 | 2020-05-14 | cdph-other | 18-34 | 684 | 0.054 | 1 | 0.037 | 0.0 |
12935 | 12935 | 2020-05-14 | cdph-other | 35-49 | 690 | 0.053 | 0 | 0.0 | 0.0 |
12936 | 12936 | 2020-05-14 | cdph-other | 50-64 | 765 | 0.059000000000000004 | 7 | 0.016 | 0.0 |
12937 | 12937 | 2020-05-14 | cdph-other | 65-79 | 354 | 0.052000000000000005 | 17 | 0.018000000000000002 | 0.0 |
12938 | 12938 | 2020-05-14 | cdph-other | 80+ | 155 | 0.041 | 15 | 0.011 | 0.0 |
12939 | 12939 | 2020-05-14 | cdph-other | all | 2734 | 0.054 | 40 | 0.014 | 0.0 |
12940 | 12940 | 2020-05-14 | latino | 0-17 | 1491 | 0.779 | 0 | 0.0 | 0.47900000000000004 |
12941 | 12941 | 2020-05-14 | latino | 18-34 | 7899 | 0.621 | 16 | 0.593 | 0.45 |
12942 | 12942 | 2020-05-14 | latino | 35-49 | 7530 | 0.583 | 102 | 0.723 | 0.41500000000000004 |
12943 | 12943 | 2020-05-14 | latino | 50-64 | 6506 | 0.503 | 234 | 0.533 | 0.322 |
12944 | 12944 | 2020-05-14 | latino | 65-79 | 2466 | 0.365 | 360 | 0.389 | 0.218 |
12945 | 12945 | 2020-05-14 | latino | 80+ | 972 | 0.256 | 348 | 0.257 | 0.196 |
12946 | 12946 | 2020-05-14 | latino | all | 26880 | 0.526 | 1060 | 0.367 | 0.389 |
12947 | 12947 | 2020-05-14 | other | 0-17 | 20 | 0.011 | 0 | 0.0 | 0.044 |
12948 | 12948 | 2020-05-14 | other | 18-34 | 168 | 0.013000000000000001 | 0 | 0.0 | 0.032 |
12949 | 12949 | 2020-05-14 | other | 35-49 | 136 | 0.01 | 3 | 0.021 | 0.021 |
12950 | 12950 | 2020-05-14 | other | 50-64 | 128 | 0.01 | 2 | 0.004 | 0.017 |
12951 | 12951 | 2020-05-14 | other | 65-79 | 66 | 0.01 | 10 | 0.01 | 0.015 |
12952 | 12952 | 2020-05-14 | other | 80+ | 28 | 0.007 | 9 | 0.006 | 0.013000000000000001 |
12953 | 12953 | 2020-05-14 | other | all | 546 | 0.011 | 24 | 0.009000000000000001 | 0.027 |
12954 | 12954 | 2020-05-14 | white | 0-17 | 197 | 0.10300000000000001 | 0 | 0.0 | 0.292 |
12955 | 12955 | 2020-05-14 | white | 18-34 | 2199 | 0.17300000000000001 | 3 | 0.111 | 0.302 |
12956 | 12956 | 2020-05-14 | white | 35-49 | 2392 | 0.185 | 11 | 0.078 | 0.325 |
12957 | 12957 | 2020-05-14 | white | 50-64 | 3062 | 0.23700000000000002 | 96 | 0.219 | 0.43 |
12958 | 12958 | 2020-05-14 | white | 65-79 | 2433 | 0.36 | 312 | 0.337 | 0.54 |
12959 | 12959 | 2020-05-14 | white | 80+ | 1665 | 0.438 | 569 | 0.421 | 0.5720000000000001 |
12960 | 12960 | 2020-05-14 | white | all | 11956 | 0.234 | 991 | 0.343 | 0.366 |
12877 | 12877 | 2020-05-15 | asian | 0-17 | 87 | 0.043000000000000003 | 0 | 0.0 | 0.13 |
12878 | 12878 | 2020-05-15 | asian | 18-34 | 1218 | 0.092 | 3 | 0.10300000000000001 | 0.151 |
12879 | 12879 | 2020-05-15 | asian | 35-49 | 1547 | 0.116 | 10 | 0.069 | 0.179 |
12880 | 12880 | 2020-05-15 | asian | 50-64 | 1672 | 0.126 | 52 | 0.116 | 0.167 |
12881 | 12881 | 2020-05-15 | asian | 65-79 | 893 | 0.129 | 123 | 0.128 | 0.17200000000000001 |
12882 | 12882 | 2020-05-15 | asian | 80+ | 691 | 0.177 | 300 | 0.213 | 0.17200000000000001 |
12883 | 12883 | 2020-05-15 | asian | all | 6118 | 0.116 | 489 | 0.163 | 0.157 |
12884 | 12884 | 2020-05-15 | black | 0-17 | 47 | 0.023 | 0 | 0.0 | 0.054 |
12885 | 12885 | 2020-05-15 | black | 18-34 | 638 | 0.048 | 3 | 0.10300000000000001 | 0.065 |
12886 | 12886 | 2020-05-15 | black | 35-49 | 694 | 0.052000000000000005 | 14 | 0.096 | 0.059000000000000004 |
12887 | 12887 | 2020-05-15 | black | 50-64 | 887 | 0.067 | 48 | 0.107 | 0.064 |
12888 | 12888 | 2020-05-15 | black | 65-79 | 585 | 0.084 | 112 | 0.117 | 0.055 |
12889 | 12889 | 2020-05-15 | black | 80+ | 326 | 0.084 | 127 | 0.09 | 0.048 |
12890 | 12890 | 2020-05-15 | black | all | 3178 | 0.06 | 304 | 0.10200000000000001 | 0.06 |
12891 | 12891 | 2020-05-15 | cdph-other | 0-17 | 84 | 0.042 | 0 | 0.0 | 0.0 |
12892 | 12892 | 2020-05-15 | cdph-other | 18-34 | 691 | 0.052000000000000005 | 1 | 0.034 | 0.0 |
12893 | 12893 | 2020-05-15 | cdph-other | 35-49 | 688 | 0.052000000000000005 | 0 | 0.0 | 0.0 |
12894 | 12894 | 2020-05-15 | cdph-other | 50-64 | 768 | 0.058 | 6 | 0.013000000000000001 | 0.0 |
12895 | 12895 | 2020-05-15 | cdph-other | 65-79 | 363 | 0.052000000000000005 | 17 | 0.018000000000000002 | 0.0 |
12896 | 12896 | 2020-05-15 | cdph-other | 80+ | 155 | 0.04 | 14 | 0.01 | 0.0 |
12897 | 12897 | 2020-05-15 | cdph-other | all | 2751 | 0.052000000000000005 | 38 | 0.013000000000000001 | 0.0 |
12898 | 12898 | 2020-05-15 | latino | 0-17 | 1575 | 0.782 | 0 | 0.0 | 0.47900000000000004 |
12899 | 12899 | 2020-05-15 | latino | 18-34 | 8256 | 0.625 | 18 | 0.621 | 0.45 |
12900 | 12900 | 2020-05-15 | latino | 35-49 | 7803 | 0.586 | 106 | 0.726 | 0.41500000000000004 |
12901 | 12901 | 2020-05-15 | latino | 50-64 | 6750 | 0.507 | 242 | 0.538 | 0.322 |
12902 | 12902 | 2020-05-15 | latino | 65-79 | 2545 | 0.367 | 376 | 0.392 | 0.218 |
12903 | 12903 | 2020-05-15 | latino | 80+ | 1000 | 0.256 | 368 | 0.262 | 0.196 |
12904 | 12904 | 2020-05-15 | latino | all | 27943 | 0.53 | 1110 | 0.371 | 0.389 |
12905 | 12905 | 2020-05-15 | other | 0-17 | 20 | 0.009000000000000001 | 0 | 0.0 | 0.044 |
12906 | 12906 | 2020-05-15 | other | 18-34 | 172 | 0.013000000000000001 | 1 | 0.034 | 0.032 |
12907 | 12907 | 2020-05-15 | other | 35-49 | 153 | 0.011 | 4 | 0.028 | 0.021 |
12908 | 12908 | 2020-05-15 | other | 50-64 | 133 | 0.01 | 4 | 0.008 | 0.017 |
12909 | 12909 | 2020-05-15 | other | 65-79 | 72 | 0.011 | 12 | 0.012 | 0.015 |
12910 | 12910 | 2020-05-15 | other | 80+ | 32 | 0.008 | 10 | 0.007 | 0.013000000000000001 |
12911 | 12911 | 2020-05-15 | other | all | 582 | 0.011 | 31 | 0.01 | 0.027 |
12912 | 12912 | 2020-05-15 | white | 0-17 | 202 | 0.1 | 0 | 0.0 | 0.292 |
12913 | 12913 | 2020-05-15 | white | 18-34 | 2234 | 0.169 | 3 | 0.10300000000000001 | 0.302 |
12914 | 12914 | 2020-05-15 | white | 35-49 | 2433 | 0.183 | 12 | 0.082 | 0.325 |
12915 | 12915 | 2020-05-15 | white | 50-64 | 3107 | 0.233 | 98 | 0.218 | 0.43 |
12916 | 12916 | 2020-05-15 | white | 65-79 | 2471 | 0.357 | 320 | 0.333 | 0.54 |
12917 | 12917 | 2020-05-15 | white | 80+ | 1697 | 0.435 | 588 | 0.418 | 0.5720000000000001 |
12918 | 12918 | 2020-05-15 | white | all | 12153 | 0.23 | 1021 | 0.341 | 0.366 |
12835 | 12835 | 2020-05-16 | asian | 0-17 | 95 | 0.044 | 0 | 0.0 | 0.13 |
12836 | 12836 | 2020-05-16 | asian | 18-34 | 1282 | 0.093 | 3 | 0.097 | 0.151 |
12837 | 12837 | 2020-05-16 | asian | 35-49 | 1596 | 0.116 | 10 | 0.068 | 0.179 |
12838 | 12838 | 2020-05-16 | asian | 50-64 | 1725 | 0.125 | 53 | 0.116 | 0.167 |
12839 | 12839 | 2020-05-16 | asian | 65-79 | 910 | 0.129 | 124 | 0.127 | 0.17200000000000001 |
12840 | 12840 | 2020-05-16 | asian | 80+ | 712 | 0.177 | 305 | 0.211 | 0.17200000000000001 |
12841 | 12841 | 2020-05-16 | asian | all | 6330 | 0.116 | 496 | 0.162 | 0.157 |
12842 | 12842 | 2020-05-16 | black | 0-17 | 48 | 0.022 | 0 | 0.0 | 0.054 |
12843 | 12843 | 2020-05-16 | black | 18-34 | 643 | 0.047 | 3 | 0.097 | 0.065 |
12844 | 12844 | 2020-05-16 | black | 35-49 | 708 | 0.051000000000000004 | 14 | 0.095 | 0.059000000000000004 |
12845 | 12845 | 2020-05-16 | black | 50-64 | 898 | 0.065 | 50 | 0.109 | 0.064 |
12846 | 12846 | 2020-05-16 | black | 65-79 | 592 | 0.084 | 114 | 0.117 | 0.055 |
12847 | 12847 | 2020-05-16 | black | 80+ | 331 | 0.083 | 130 | 0.09 | 0.048 |
12848 | 12848 | 2020-05-16 | black | all | 3221 | 0.059000000000000004 | 311 | 0.10200000000000001 | 0.06 |
12849 | 12849 | 2020-05-16 | cdph-other | 0-17 | 87 | 0.04 | 0 | 0.0 | 0.0 |
12850 | 12850 | 2020-05-16 | cdph-other | 18-34 | 709 | 0.051000000000000004 | 1 | 0.032 | 0.0 |
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 );