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 age
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 |
9 | 9 | 2022-12-09 | black | 0-17 | 74258 | 0.047 | 8 | 0.09 | 0.054 |
17 | 17 | 2022-12-09 | cdph-other | 0-17 | 219965 | 0.14 | 1 | 0.011 | 0.0 |
25 | 25 | 2022-12-09 | latino | 0-17 | 832398 | 0.528 | 46 | 0.517 | 0.47900000000000004 |
33 | 33 | 2022-12-09 | other | 0-17 | 23819 | 0.015 | 4 | 0.045 | 0.044 |
41 | 41 | 2022-12-09 | white | 0-17 | 284334 | 0.181 | 18 | 0.202 | 0.292 |
49 | 49 | 2022-11-03 | asian | 0-17 | 138319 | 0.089 | 10 | 0.123 | 0.13 |
57 | 57 | 2022-11-03 | black | 0-17 | 73374 | 0.047 | 8 | 0.099 | 0.054 |
65 | 65 | 2022-11-03 | cdph-other | 0-17 | 217449 | 0.139 | 2 | 0.025 | 0.0 |
73 | 73 | 2022-11-03 | latino | 0-17 | 825480 | 0.529 | 42 | 0.519 | 0.47900000000000004 |
81 | 81 | 2022-11-03 | other | 0-17 | 23600 | 0.015 | 4 | 0.049 | 0.044 |
89 | 89 | 2022-11-03 | white | 0-17 | 280976 | 0.18 | 15 | 0.185 | 0.292 |
97 | 97 | 2022-10-06 | asian | 0-17 | 137407 | 0.088 | 10 | 0.127 | 0.13 |
105 | 105 | 2022-10-06 | black | 0-17 | 72911 | 0.047 | 8 | 0.101 | 0.054 |
113 | 113 | 2022-10-06 | cdph-other | 0-17 | 216534 | 0.14 | 2 | 0.025 | 0.0 |
121 | 121 | 2022-10-06 | latino | 0-17 | 822371 | 0.53 | 40 | 0.506 | 0.47900000000000004 |
129 | 129 | 2022-10-06 | other | 0-17 | 23446 | 0.015 | 4 | 0.051000000000000004 | 0.044 |
137 | 137 | 2022-10-06 | white | 0-17 | 279530 | 0.18 | 15 | 0.19 | 0.292 |
145 | 145 | 2022-09-30 | asian | 0-17 | 137130 | 0.088 | 10 | 0.127 | 0.13 |
153 | 153 | 2022-09-30 | black | 0-17 | 72782 | 0.047 | 8 | 0.101 | 0.054 |
161 | 161 | 2022-09-30 | cdph-other | 0-17 | 216341 | 0.14 | 2 | 0.025 | 0.0 |
169 | 169 | 2022-09-30 | latino | 0-17 | 821415 | 0.53 | 40 | 0.506 | 0.47900000000000004 |
177 | 177 | 2022-09-30 | other | 0-17 | 23411 | 0.015 | 4 | 0.051000000000000004 | 0.044 |
185 | 185 | 2022-09-30 | white | 0-17 | 279046 | 0.18 | 15 | 0.19 | 0.292 |
193 | 193 | 2022-09-23 | asian | 0-17 | 136830 | 0.088 | 10 | 0.127 | 0.13 |
201 | 201 | 2022-09-23 | black | 0-17 | 72621 | 0.047 | 8 | 0.101 | 0.054 |
209 | 209 | 2022-09-23 | cdph-other | 0-17 | 216056 | 0.14 | 2 | 0.025 | 0.0 |
217 | 217 | 2022-09-23 | latino | 0-17 | 820466 | 0.53 | 40 | 0.506 | 0.47900000000000004 |
225 | 225 | 2022-09-23 | other | 0-17 | 23367 | 0.015 | 4 | 0.051000000000000004 | 0.044 |
233 | 233 | 2022-09-23 | white | 0-17 | 278621 | 0.18 | 15 | 0.19 | 0.292 |
241 | 241 | 2022-09-16 | asian | 0-17 | 136510 | 0.088 | 10 | 0.127 | 0.13 |
249 | 249 | 2022-09-16 | black | 0-17 | 72493 | 0.047 | 8 | 0.101 | 0.054 |
257 | 257 | 2022-09-16 | cdph-other | 0-17 | 215658 | 0.14 | 2 | 0.025 | 0.0 |
265 | 265 | 2022-09-16 | latino | 0-17 | 819393 | 0.53 | 40 | 0.506 | 0.47900000000000004 |
273 | 273 | 2022-09-16 | other | 0-17 | 23330 | 0.015 | 4 | 0.051000000000000004 | 0.044 |
281 | 281 | 2022-09-16 | white | 0-17 | 278130 | 0.18 | 15 | 0.19 | 0.292 |
289 | 289 | 2022-09-09 | asian | 0-17 | 136159 | 0.088 | 10 | 0.13 | 0.13 |
297 | 297 | 2022-09-09 | black | 0-17 | 72274 | 0.047 | 8 | 0.10400000000000001 | 0.054 |
305 | 305 | 2022-09-09 | cdph-other | 0-17 | 215368 | 0.14 | 1 | 0.013000000000000001 | 0.0 |
313 | 313 | 2022-09-09 | latino | 0-17 | 817808 | 0.53 | 40 | 0.519 | 0.47900000000000004 |
321 | 321 | 2022-09-09 | other | 0-17 | 23280 | 0.015 | 4 | 0.052000000000000005 | 0.044 |
329 | 329 | 2022-09-09 | white | 0-17 | 277541 | 0.18 | 14 | 0.182 | 0.292 |
337 | 337 | 2022-09-02 | asian | 0-17 | 135577 | 0.088 | 10 | 0.13 | 0.13 |
345 | 345 | 2022-09-02 | black | 0-17 | 71853 | 0.047 | 8 | 0.10400000000000001 | 0.054 |
353 | 353 | 2022-09-02 | cdph-other | 0-17 | 214571 | 0.14 | 1 | 0.013000000000000001 | 0.0 |
361 | 361 | 2022-09-02 | latino | 0-17 | 814996 | 0.53 | 40 | 0.519 | 0.47900000000000004 |
369 | 369 | 2022-09-02 | other | 0-17 | 23220 | 0.015 | 4 | 0.052000000000000005 | 0.044 |
377 | 377 | 2022-09-02 | white | 0-17 | 276330 | 0.18 | 14 | 0.182 | 0.292 |
385 | 385 | 2022-08-26 | asian | 0-17 | 134919 | 0.088 | 10 | 0.131 | 0.13 |
393 | 393 | 2022-08-26 | black | 0-17 | 71430 | 0.047 | 7 | 0.092 | 0.054 |
401 | 401 | 2022-08-26 | cdph-other | 0-17 | 213433 | 0.139 | 1 | 0.013000000000000001 | 0.0 |
409 | 409 | 2022-08-26 | latino | 0-17 | 811426 | 0.531 | 40 | 0.526 | 0.47900000000000004 |
417 | 417 | 2022-08-26 | other | 0-17 | 23125 | 0.015 | 4 | 0.053 | 0.044 |
425 | 425 | 2022-08-26 | white | 0-17 | 275040 | 0.18 | 14 | 0.184 | 0.292 |
433 | 433 | 2022-08-19 | asian | 0-17 | 133980 | 0.088 | 10 | 0.133 | 0.13 |
441 | 441 | 2022-08-19 | black | 0-17 | 70923 | 0.047 | 7 | 0.093 | 0.054 |
449 | 449 | 2022-08-19 | cdph-other | 0-17 | 212040 | 0.139 | 1 | 0.013000000000000001 | 0.0 |
457 | 457 | 2022-08-19 | latino | 0-17 | 807272 | 0.531 | 39 | 0.52 | 0.47900000000000004 |
465 | 465 | 2022-08-19 | other | 0-17 | 23037 | 0.015 | 4 | 0.053 | 0.044 |
473 | 473 | 2022-08-19 | white | 0-17 | 273584 | 0.18 | 14 | 0.187 | 0.292 |
481 | 481 | 2022-08-12 | asian | 0-17 | 133066 | 0.088 | 10 | 0.133 | 0.13 |
489 | 489 | 2022-08-12 | black | 0-17 | 70521 | 0.047 | 7 | 0.093 | 0.054 |
497 | 497 | 2022-08-12 | cdph-other | 0-17 | 210604 | 0.139 | 1 | 0.013000000000000001 | 0.0 |
505 | 505 | 2022-08-12 | latino | 0-17 | 803077 | 0.531 | 39 | 0.52 | 0.47900000000000004 |
513 | 513 | 2022-08-12 | other | 0-17 | 22949 | 0.015 | 4 | 0.053 | 0.044 |
521 | 521 | 2022-08-12 | white | 0-17 | 272112 | 0.18 | 14 | 0.187 | 0.292 |
529 | 529 | 2022-08-05 | asian | 0-17 | 132045 | 0.088 | 10 | 0.137 | 0.13 |
537 | 537 | 2022-08-05 | black | 0-17 | 70106 | 0.047 | 7 | 0.096 | 0.054 |
545 | 545 | 2022-08-05 | cdph-other | 0-17 | 209396 | 0.139 | 1 | 0.014 | 0.0 |
553 | 553 | 2022-08-05 | latino | 0-17 | 798931 | 0.531 | 39 | 0.534 | 0.47900000000000004 |
561 | 561 | 2022-08-05 | other | 0-17 | 22839 | 0.015 | 4 | 0.055 | 0.044 |
569 | 569 | 2022-08-05 | white | 0-17 | 270602 | 0.18 | 12 | 0.164 | 0.292 |
577 | 577 | 2022-07-29 | asian | 0-17 | 130775 | 0.08700000000000001 | 10 | 0.137 | 0.13 |
585 | 585 | 2022-07-29 | black | 0-17 | 69556 | 0.047 | 7 | 0.096 | 0.054 |
593 | 593 | 2022-07-29 | cdph-other | 0-17 | 207743 | 0.139 | 1 | 0.014 | 0.0 |
601 | 601 | 2022-07-29 | latino | 0-17 | 794024 | 0.532 | 39 | 0.534 | 0.47900000000000004 |
609 | 609 | 2022-07-29 | other | 0-17 | 22728 | 0.015 | 4 | 0.055 | 0.044 |
617 | 617 | 2022-07-29 | white | 0-17 | 268633 | 0.18 | 12 | 0.164 | 0.292 |
625 | 625 | 2022-07-22 | asian | 0-17 | 129067 | 0.08700000000000001 | 10 | 0.137 | 0.13 |
633 | 633 | 2022-07-22 | black | 0-17 | 68878 | 0.047 | 7 | 0.096 | 0.054 |
641 | 641 | 2022-07-22 | cdph-other | 0-17 | 205779 | 0.139 | 1 | 0.014 | 0.0 |
649 | 649 | 2022-07-22 | latino | 0-17 | 788447 | 0.532 | 39 | 0.534 | 0.47900000000000004 |
657 | 657 | 2022-07-22 | other | 0-17 | 22581 | 0.015 | 4 | 0.055 | 0.044 |
665 | 665 | 2022-07-22 | white | 0-17 | 266218 | 0.18 | 12 | 0.164 | 0.292 |
673 | 673 | 2022-07-15 | asian | 0-17 | 127320 | 0.08700000000000001 | 10 | 0.139 | 0.13 |
681 | 681 | 2022-07-15 | black | 0-17 | 68201 | 0.046 | 7 | 0.097 | 0.054 |
689 | 689 | 2022-07-15 | cdph-other | 0-17 | 203568 | 0.139 | 1 | 0.014 | 0.0 |
697 | 697 | 2022-07-15 | latino | 0-17 | 782357 | 0.533 | 38 | 0.528 | 0.47900000000000004 |
705 | 705 | 2022-07-15 | other | 0-17 | 22430 | 0.015 | 4 | 0.056 | 0.044 |
713 | 713 | 2022-07-15 | white | 0-17 | 263845 | 0.18 | 12 | 0.167 | 0.292 |
721 | 721 | 2022-07-08 | asian | 0-17 | 125253 | 0.08600000000000001 | 10 | 0.139 | 0.13 |
729 | 729 | 2022-07-08 | black | 0-17 | 67499 | 0.046 | 7 | 0.097 | 0.054 |
737 | 737 | 2022-07-08 | cdph-other | 0-17 | 201394 | 0.139 | 1 | 0.014 | 0.0 |
745 | 745 | 2022-07-08 | latino | 0-17 | 776375 | 0.534 | 38 | 0.528 | 0.47900000000000004 |
753 | 753 | 2022-07-08 | other | 0-17 | 22241 | 0.015 | 4 | 0.056 | 0.044 |
761 | 761 | 2022-07-08 | white | 0-17 | 261189 | 0.18 | 12 | 0.167 | 0.292 |
769 | 769 | 2022-07-01 | asian | 0-17 | 123378 | 0.085 | 10 | 0.139 | 0.13 |
777 | 777 | 2022-07-01 | black | 0-17 | 66909 | 0.046 | 7 | 0.097 | 0.054 |
785 | 785 | 2022-07-01 | cdph-other | 0-17 | 199595 | 0.138 | 1 | 0.014 | 0.0 |
793 | 793 | 2022-07-01 | latino | 0-17 | 771879 | 0.535 | 38 | 0.528 | 0.47900000000000004 |
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 );