cdph-race-ethnicity

Table actions

Statewide demographic data tallying race totals by age for both cases and deaths. Provided by the California Department of Public Health.

The original race categories published by the state have been grouped and aggregated to match the five race categories traditionally published by the Los Angeles Times.

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

✎ View and edit SQL

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
1 1 2022-12-09 asian 0-17 140281 0.089 12 0.134 0.13
2 2 2022-12-09 asian 18+ 819337 0.116 11258 0.117 0.165
3 3 2022-12-09 asian 18-34 304784 0.114 135 0.083 0.151
4 4 2022-12-09 asian 35-49 219157 0.11 381 0.063 0.17500000000000002
5 5 2022-12-09 asian 50-64 172463 0.114 1635 0.083 0.167
6 6 2022-12-09 asian 65-79 78302 0.117 3552 0.108 0.17200000000000001
7 7 2022-12-09 asian 80+ 26486 0.114 5488 0.151 0.17200000000000001
8 8 2022-12-09 asian all 959937 0.112 11270 0.117 0.157
9 9 2022-12-09 black 0-17 74258 0.047 8 0.09 0.054
10 10 2022-12-09 black 18+ 395223 0.056 6800 0.07100000000000001 0.061
11 11 2022-12-09 black 18-34 143812 0.054 149 0.091 0.065
12 12 2022-12-09 black 35-49 105220 0.053 469 0.077 0.059000000000000004
13 13 2022-12-09 black 50-64 93248 0.062 1623 0.082 0.064
14 14 2022-12-09 black 65-79 41159 0.062 2481 0.076 0.055
15 15 2022-12-09 black 80+ 11784 0.051000000000000004 2078 0.057 0.048
16 16 2022-12-09 black all 469635 0.054 6808 0.07100000000000001 0.06
17 17 2022-12-09 cdph-other 0-17 219965 0.14 1 0.011 0.0
18 18 2022-12-09 cdph-other 18+ 785838 0.111 892 0.009000000000000001 0.0
19 19 2022-12-09 cdph-other 18-34 317291 0.11900000000000001 13 0.008 0.0
20 20 2022-12-09 cdph-other 35-49 235234 0.11800000000000001 62 0.01 0.0
21 21 2022-12-09 cdph-other 50-64 156226 0.10400000000000001 194 0.011 0.0
22 22 2022-12-09 cdph-other 65-79 57464 0.08600000000000001 299 0.009000000000000001 0.0
23 23 2022-12-09 cdph-other 80+ 19623 0.085 324 0.009000000000000001 0.0
24 24 2022-12-09 cdph-other all 1006880 0.117 893 0.009000000000000001 0.0
25 25 2022-12-09 latino 0-17 832398 0.528 46 0.517 0.47900000000000004
26 26 2022-12-09 latino 18+ 3040207 0.431 41016 0.426 0.363
27 27 2022-12-09 latino 18-34 1286691 0.481 1072 0.658 0.45
28 28 2022-12-09 latino 35-49 902082 0.453 4048 0.668 0.41500000000000004
29 29 2022-12-09 latino 50-64 598174 0.399 11198 0.5680000000000001 0.322
30 30 2022-12-09 latino 65-79 199753 0.30000000000000004 14283 0.437 0.218
31 31 2022-12-09 latino 80+ 53506 0.232 10415 0.28700000000000003 0.196
32 32 2022-12-09 latino all 3873732 0.448 41064 0.426 0.389
33 33 2022-12-09 other 0-17 23819 0.015 4 0.045 0.044
34 34 2022-12-09 other 18+ 101387 0.015 1929 0.02 0.022
35 35 2022-12-09 other 18-34 39270 0.015 34 0.021 0.032
36 36 2022-12-09 other 35-49 28067 0.014 143 0.024 0.021
37 37 2022-12-09 other 50-64 21598 0.014 417 0.021 0.017
38 38 2022-12-09 other 65-79 9460 0.015 681 0.021 0.015
39 39 2022-12-09 other 80+ 2992 0.013000000000000001 654 0.018000000000000002 0.013000000000000001
40 40 2022-12-09 other all 125237 0.015 1933 0.02 0.027
41 41 2022-12-09 white 0-17 284334 0.181 18 0.202 0.292
42 42 2022-12-09 white 18+ 1918308 0.272 34461 0.358 0.388
43 43 2022-12-09 white 18-34 580812 0.217 226 0.139 0.302
44 44 2022-12-09 white 35-49 481678 0.242 892 0.147 0.325
45 45 2022-12-09 white 50-64 459206 0.306 4638 0.23500000000000001 0.43
46 46 2022-12-09 white 65-79 280129 0.42 11401 0.34900000000000003 0.54
47 47 2022-12-09 white 80+ 116481 0.505 17304 0.47700000000000004 0.5720000000000001
48 48 2022-12-09 white all 2203601 0.255 34483 0.358 0.366
49 49 2022-11-03 asian 0-17 138319 0.089 10 0.123 0.13
50 50 2022-11-03 asian 18+ 795552 0.115 11123 0.116 0.165
51 51 2022-11-03 asian 18-34 297782 0.113 135 0.083 0.151
52 52 2022-11-03 asian 35-49 213258 0.109 380 0.063 0.17500000000000002
53 53 2022-11-03 asian 50-64 166600 0.113 1615 0.083 0.167
54 54 2022-11-03 asian 65-79 75084 0.117 3507 0.108 0.17200000000000001
55 55 2022-11-03 asian 80+ 25019 0.115 5419 0.151 0.17200000000000001
56 56 2022-11-03 asian all 934187 0.111 11133 0.116 0.157
57 57 2022-11-03 black 0-17 73374 0.047 8 0.099 0.054
58 58 2022-11-03 black 18+ 385734 0.056 6756 0.07100000000000001 0.061
59 59 2022-11-03 black 18-34 141485 0.054 147 0.091 0.065
60 60 2022-11-03 black 35-49 102963 0.053 469 0.078 0.059000000000000004
61 61 2022-11-03 black 50-64 90631 0.062 1611 0.082 0.064
62 62 2022-11-03 black 65-79 39386 0.061 2466 0.076 0.055
63 63 2022-11-03 black 80+ 11269 0.052000000000000005 2063 0.058 0.048
64 64 2022-11-03 black all 459266 0.054 6764 0.07100000000000001 0.06
65 65 2022-11-03 cdph-other 0-17 217449 0.139 2 0.025 0.0
66 66 2022-11-03 cdph-other 18+ 765625 0.111 936 0.01 0.0
67 67 2022-11-03 cdph-other 18-34 311211 0.11800000000000001 17 0.01 0.0
68 68 2022-11-03 cdph-other 35-49 230049 0.11800000000000001 62 0.01 0.0
69 69 2022-11-03 cdph-other 50-64 151642 0.10400000000000001 209 0.011 0.0
70 70 2022-11-03 cdph-other 65-79 54698 0.085 308 0.009000000000000001 0.0
71 71 2022-11-03 cdph-other 80+ 18025 0.082 340 0.009000000000000001 0.0
72 72 2022-11-03 cdph-other all 984139 0.116 938 0.01 0.0
73 73 2022-11-03 latino 0-17 825480 0.529 42 0.519 0.47900000000000004
74 74 2022-11-03 latino 18+ 2991437 0.433 40837 0.427 0.363
75 75 2022-11-03 latino 18-34 1269314 0.483 1064 0.656 0.45
76 76 2022-11-03 latino 35-49 888814 0.455 4035 0.669 0.41500000000000004
77 77 2022-11-03 latino 50-64 586878 0.401 11166 0.5700000000000001 0.322
78 78 2022-11-03 latino 65-79 194699 0.303 14233 0.439 0.218
79 79 2022-11-03 latino 80+ 51731 0.23700000000000002 10339 0.28800000000000003 0.196
80 80 2022-11-03 latino all 3818017 0.451 40881 0.427 0.389
81 81 2022-11-03 other 0-17 23600 0.015 4 0.049 0.044
82 82 2022-11-03 other 18+ 99970 0.015 1911 0.02 0.022
83 83 2022-11-03 other 18-34 38869 0.015 33 0.02 0.032
84 84 2022-11-03 other 35-49 27686 0.014 141 0.024 0.021
85 85 2022-11-03 other 50-64 21268 0.014 416 0.021 0.017
86 86 2022-11-03 other 65-79 9245 0.015 677 0.021 0.015
87 87 2022-11-03 other 80+ 2902 0.013000000000000001 644 0.018000000000000002 0.013000000000000001
88 88 2022-11-03 other all 123602 0.015 1915 0.02 0.027
89 89 2022-11-03 white 0-17 280976 0.18 15 0.185 0.292
90 90 2022-11-03 white 18+ 1870845 0.271 33993 0.356 0.388
91 91 2022-11-03 white 18-34 572001 0.217 225 0.139 0.302
92 92 2022-11-03 white 35-49 472686 0.242 881 0.146 0.325
93 93 2022-11-03 white 50-64 447644 0.306 4577 0.234 0.43
94 94 2022-11-03 white 65-79 268748 0.419 11264 0.34700000000000003 0.54
95 95 2022-11-03 white 80+ 109764 0.502 17046 0.47500000000000003 0.5720000000000001
96 96 2022-11-03 white all 2152758 0.254 34012 0.356 0.366
97 97 2022-10-06 asian 0-17 137407 0.088 10 0.127 0.13
98 98 2022-10-06 asian 18+ 785734 0.115 11019 0.116 0.165
99 99 2022-10-06 asian 18-34 294913 0.113 134 0.083 0.151
100 100 2022-10-06 asian 35-49 210832 0.109 375 0.062 0.17500000000000002

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);