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-12
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
10849 | 10849 | 2020-07-12 | asian | 0-17 | 455 | 0.025 | 0 | 0.0 | 0.13 |
10850 | 10850 | 2020-07-12 | asian | 18+ | 13464 | 0.069 | 968 | 0.14 | 0.165 |
10851 | 10851 | 2020-07-12 | asian | 18-34 | 3364 | 0.049 | 6 | 0.074 | 0.151 |
10852 | 10852 | 2020-07-12 | asian | 35-49 | 3586 | 0.067 | 25 | 0.069 | 0.179 |
10853 | 10853 | 2020-07-12 | asian | 50-64 | 3429 | 0.078 | 96 | 0.082 | 0.167 |
10854 | 10854 | 2020-07-12 | asian | 65-79 | 1791 | 0.095 | 263 | 0.11900000000000001 | 0.17200000000000001 |
10855 | 10855 | 2020-07-12 | asian | 80+ | 1294 | 0.14 | 578 | 0.187 | 0.17200000000000001 |
10856 | 10856 | 2020-07-12 | asian | all | 13930 | 0.066 | 968 | 0.14 | 0.157 |
10857 | 10857 | 2020-07-12 | black | 0-17 | 393 | 0.022 | 0 | 0.0 | 0.054 |
10858 | 10858 | 2020-07-12 | black | 18+ | 8790 | 0.045 | 615 | 0.089 | 0.061 |
10859 | 10859 | 2020-07-12 | black | 18-34 | 2617 | 0.038 | 12 | 0.148 | 0.065 |
10860 | 10860 | 2020-07-12 | black | 35-49 | 2068 | 0.039 | 21 | 0.058 | 0.059000000000000004 |
10861 | 10861 | 2020-07-12 | black | 50-64 | 2149 | 0.049 | 86 | 0.074 | 0.064 |
10862 | 10862 | 2020-07-12 | black | 65-79 | 1264 | 0.068 | 236 | 0.107 | 0.055 |
10863 | 10863 | 2020-07-12 | black | 80+ | 692 | 0.075 | 260 | 0.084 | 0.048 |
10864 | 10864 | 2020-07-12 | black | all | 9196 | 0.043000000000000003 | 615 | 0.089 | 0.06 |
10865 | 10865 | 2020-07-12 | cdph-other | 0-17 | 3396 | 0.189 | 0 | 0.0 | 0.0 |
10866 | 10866 | 2020-07-12 | cdph-other | 18+ | 29769 | 0.154 | 84 | 0.012 | 0.0 |
10867 | 10867 | 2020-07-12 | cdph-other | 18-34 | 12459 | 0.182 | 0 | 0.0 | 0.0 |
10868 | 10868 | 2020-07-12 | cdph-other | 35-49 | 8679 | 0.163 | 2 | 0.006 | 0.0 |
10869 | 10869 | 2020-07-12 | cdph-other | 50-64 | 6130 | 0.14100000000000001 | 12 | 0.01 | 0.0 |
10870 | 10870 | 2020-07-12 | cdph-other | 65-79 | 1888 | 0.101 | 27 | 0.012 | 0.0 |
10871 | 10871 | 2020-07-12 | cdph-other | 80+ | 613 | 0.066 | 43 | 0.014 | 0.0 |
10872 | 10872 | 2020-07-12 | cdph-other | all | 33170 | 0.157 | 84 | 0.012 | 0.0 |
10873 | 10873 | 2020-07-12 | latino | 0-17 | 11944 | 0.666 | 0 | 0.0 | 0.47900000000000004 |
10874 | 10874 | 2020-07-12 | latino | 18+ | 103806 | 0.537 | 3029 | 0.438 | 0.363 |
10875 | 10875 | 2020-07-12 | latino | 18-34 | 39361 | 0.5730000000000001 | 52 | 0.642 | 0.45 |
10876 | 10876 | 2020-07-12 | latino | 35-49 | 30941 | 0.58 | 282 | 0.779 | 0.41500000000000004 |
10877 | 10877 | 2020-07-12 | latino | 50-64 | 22898 | 0.527 | 748 | 0.642 | 0.322 |
10878 | 10878 | 2020-07-12 | latino | 65-79 | 7777 | 0.41600000000000004 | 1012 | 0.459 | 0.218 |
10879 | 10879 | 2020-07-12 | latino | 80+ | 2829 | 0.305 | 935 | 0.302 | 0.196 |
10880 | 10880 | 2020-07-12 | latino | all | 115828 | 0.548 | 3029 | 0.438 | 0.389 |
10881 | 10881 | 2020-07-12 | other | 0-17 | 149 | 0.008 | 0 | 0.0 | 0.044 |
10882 | 10882 | 2020-07-12 | other | 18+ | 1870 | 0.009000000000000001 | 65 | 0.01 | 0.022 |
10883 | 10883 | 2020-07-12 | other | 18-34 | 701 | 0.01 | 2 | 0.025 | 0.032 |
10884 | 10884 | 2020-07-12 | other | 35-49 | 485 | 0.009000000000000001 | 6 | 0.017 | 0.021 |
10885 | 10885 | 2020-07-12 | other | 50-64 | 423 | 0.01 | 8 | 0.007 | 0.017 |
10886 | 10886 | 2020-07-12 | other | 65-79 | 173 | 0.009000000000000001 | 20 | 0.009000000000000001 | 0.015 |
10887 | 10887 | 2020-07-12 | other | 80+ | 88 | 0.009000000000000001 | 29 | 0.01 | 0.013000000000000001 |
10888 | 10888 | 2020-07-12 | other | all | 2021 | 0.009000000000000001 | 65 | 0.01 | 0.027 |
10889 | 10889 | 2020-07-12 | white | 0-17 | 1607 | 0.09 | 0 | 0.0 | 0.292 |
10890 | 10890 | 2020-07-12 | white | 18+ | 35760 | 0.185 | 2147 | 0.311 | 0.388 |
10891 | 10891 | 2020-07-12 | white | 18-34 | 10136 | 0.148 | 9 | 0.111 | 0.302 |
10892 | 10892 | 2020-07-12 | white | 35-49 | 7627 | 0.14300000000000002 | 26 | 0.07200000000000001 | 0.325 |
10893 | 10893 | 2020-07-12 | white | 50-64 | 8412 | 0.194 | 215 | 0.185 | 0.43 |
10894 | 10894 | 2020-07-12 | white | 65-79 | 5814 | 0.311 | 648 | 0.294 | 0.54 |
10895 | 10895 | 2020-07-12 | white | 80+ | 3771 | 0.406 | 1249 | 0.404 | 0.5720000000000001 |
10896 | 10896 | 2020-07-12 | white | all | 37400 | 0.177 | 2147 | 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 );