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-19
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: race, age, deaths_percent
Link | rowid ▼ | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
11857 | 11857 | 2020-06-19 | asian | 0-17 | 221 | 0.026000000000000002 | 0 | 0.0 | 0.13 |
11858 | 11858 | 2020-06-19 | asian | 18+ | 9372 | 0.085 | 787 | 0.15 | 0.165 |
11859 | 11859 | 2020-06-19 | asian | 18-34 | 2080 | 0.06 | 4 | 0.069 | 0.151 |
11860 | 11860 | 2020-06-19 | asian | 35-49 | 2433 | 0.081 | 22 | 0.085 | 0.179 |
11861 | 11861 | 2020-06-19 | asian | 50-64 | 2505 | 0.094 | 81 | 0.096 | 0.167 |
11862 | 11862 | 2020-06-19 | asian | 65-79 | 1322 | 0.107 | 204 | 0.122 | 0.17200000000000001 |
11863 | 11863 | 2020-06-19 | asian | 80+ | 1032 | 0.154 | 476 | 0.198 | 0.17200000000000001 |
11864 | 11864 | 2020-06-19 | asian | all | 9604 | 0.081 | 787 | 0.15 | 0.157 |
11865 | 11865 | 2020-06-19 | black | 0-17 | 139 | 0.016 | 0 | 0.0 | 0.054 |
11866 | 11866 | 2020-06-19 | black | 18+ | 5241 | 0.047 | 495 | 0.095 | 0.061 |
11867 | 11867 | 2020-06-19 | black | 18-34 | 1230 | 0.035 | 5 | 0.08600000000000001 | 0.065 |
11868 | 11868 | 2020-06-19 | black | 35-49 | 1154 | 0.038 | 20 | 0.077 | 0.059000000000000004 |
11869 | 11869 | 2020-06-19 | black | 50-64 | 1409 | 0.053 | 74 | 0.088 | 0.064 |
11870 | 11870 | 2020-06-19 | black | 65-79 | 921 | 0.075 | 188 | 0.112 | 0.055 |
11871 | 11871 | 2020-06-19 | black | 80+ | 527 | 0.079 | 208 | 0.08700000000000001 | 0.048 |
11872 | 11872 | 2020-06-19 | black | all | 5384 | 0.045 | 495 | 0.095 | 0.06 |
11873 | 11873 | 2020-06-19 | cdph-other | 0-17 | 1639 | 0.188 | 0 | 0.0 | 0.0 |
11874 | 11874 | 2020-06-19 | cdph-other | 18+ | 13080 | 0.11800000000000001 | 45 | 0.009000000000000001 | 0.0 |
11875 | 11875 | 2020-06-19 | cdph-other | 18-34 | 4919 | 0.14200000000000002 | 0 | 0.0 | 0.0 |
11876 | 11876 | 2020-06-19 | cdph-other | 35-49 | 3743 | 0.124 | 0 | 0.0 | 0.0 |
11877 | 11877 | 2020-06-19 | cdph-other | 50-64 | 2989 | 0.112 | 8 | 0.01 | 0.0 |
11878 | 11878 | 2020-06-19 | cdph-other | 65-79 | 1022 | 0.083 | 16 | 0.01 | 0.0 |
11879 | 11879 | 2020-06-19 | cdph-other | 80+ | 407 | 0.061 | 21 | 0.009000000000000001 | 0.0 |
11880 | 11880 | 2020-06-19 | cdph-other | all | 14722 | 0.123 | 45 | 0.009000000000000001 | 0.0 |
11881 | 11881 | 2020-06-19 | latino | 0-17 | 6013 | 0.6890000000000001 | 0 | 0.0 | 0.47900000000000004 |
11882 | 11882 | 2020-06-19 | latino | 18+ | 61751 | 0.558 | 2114 | 0.404 | 0.363 |
11883 | 11883 | 2020-06-19 | latino | 18-34 | 21892 | 0.63 | 40 | 0.6900000000000001 | 0.45 |
11884 | 11884 | 2020-06-19 | latino | 35-49 | 18351 | 0.61 | 190 | 0.734 | 0.41500000000000004 |
11885 | 11885 | 2020-06-19 | latino | 50-64 | 14540 | 0.543 | 505 | 0.603 | 0.322 |
11886 | 11886 | 2020-06-19 | latino | 65-79 | 5018 | 0.40800000000000003 | 719 | 0.429 | 0.218 |
11887 | 11887 | 2020-06-19 | latino | 80+ | 1950 | 0.291 | 660 | 0.275 | 0.196 |
11888 | 11888 | 2020-06-19 | latino | all | 67818 | 0.5680000000000001 | 2115 | 0.404 | 0.389 |
11889 | 11889 | 2020-06-19 | other | 0-17 | 60 | 0.007 | 0 | 0.0 | 0.044 |
11890 | 11890 | 2020-06-19 | other | 18+ | 1029 | 0.009000000000000001 | 51 | 0.01 | 0.022 |
11891 | 11891 | 2020-06-19 | other | 18-34 | 321 | 0.009000000000000001 | 2 | 0.034 | 0.032 |
11892 | 11892 | 2020-06-19 | other | 35-49 | 278 | 0.009000000000000001 | 4 | 0.016 | 0.021 |
11893 | 11893 | 2020-06-19 | other | 50-64 | 258 | 0.01 | 8 | 0.01 | 0.017 |
11894 | 11894 | 2020-06-19 | other | 65-79 | 104 | 0.009000000000000001 | 12 | 0.007 | 0.015 |
11895 | 11895 | 2020-06-19 | other | 80+ | 68 | 0.01 | 25 | 0.01 | 0.013000000000000001 |
11896 | 11896 | 2020-06-19 | other | all | 1089 | 0.009000000000000001 | 51 | 0.01 | 0.027 |
11897 | 11897 | 2020-06-19 | white | 0-17 | 656 | 0.075 | 0 | 0.0 | 0.292 |
11898 | 11898 | 2020-06-19 | white | 18+ | 20100 | 0.182 | 1739 | 0.332 | 0.388 |
11899 | 11899 | 2020-06-19 | white | 18-34 | 4286 | 0.123 | 7 | 0.121 | 0.302 |
11900 | 11900 | 2020-06-19 | white | 35-49 | 4121 | 0.137 | 23 | 0.089 | 0.325 |
11901 | 11901 | 2020-06-19 | white | 50-64 | 5067 | 0.189 | 161 | 0.192 | 0.43 |
11902 | 11902 | 2020-06-19 | white | 65-79 | 3918 | 0.318 | 536 | 0.32 | 0.54 |
11903 | 11903 | 2020-06-19 | white | 80+ | 2708 | 0.405 | 1012 | 0.421 | 0.5720000000000001 |
11904 | 11904 | 2020-06-19 | white | all | 20780 | 0.17400000000000002 | 1739 | 0.332 | 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 );