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 deaths_total
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 |
---|---|---|---|---|---|---|---|---|---|
5601 | 5601 | 2020-12-01 | other | 0-17 | 1649 | 0.016 | 0 | 0.0 | 0.044 |
5609 | 5609 | 2020-12-01 | white | 0-17 | 11501 | 0.111 | 0 | 0.0 | 0.292 |
5625 | 5625 | 2020-11-30 | black | 0-17 | 2824 | 0.028 | 0 | 0.0 | 0.054 |
5633 | 5633 | 2020-11-30 | cdph-other | 0-17 | 11428 | 0.112 | 0 | 0.0 | 0.0 |
5649 | 5649 | 2020-11-30 | other | 0-17 | 1624 | 0.016 | 0 | 0.0 | 0.044 |
5657 | 5657 | 2020-11-30 | white | 0-17 | 11212 | 0.11 | 0 | 0.0 | 0.292 |
5673 | 5673 | 2020-11-29 | black | 0-17 | 2784 | 0.028 | 0 | 0.0 | 0.054 |
5681 | 5681 | 2020-11-29 | cdph-other | 0-17 | 11256 | 0.112 | 0 | 0.0 | 0.0 |
5697 | 5697 | 2020-11-29 | other | 0-17 | 1602 | 0.016 | 0 | 0.0 | 0.044 |
5705 | 5705 | 2020-11-29 | white | 0-17 | 11066 | 0.11 | 0 | 0.0 | 0.292 |
5721 | 5721 | 2020-11-28 | black | 0-17 | 2753 | 0.028 | 0 | 0.0 | 0.054 |
5729 | 5729 | 2020-11-28 | cdph-other | 0-17 | 11032 | 0.111 | 0 | 0.0 | 0.0 |
5745 | 5745 | 2020-11-28 | other | 0-17 | 1582 | 0.016 | 0 | 0.0 | 0.044 |
5753 | 5753 | 2020-11-28 | white | 0-17 | 10857 | 0.109 | 0 | 0.0 | 0.292 |
5769 | 5769 | 2020-11-27 | black | 0-17 | 2720 | 0.028 | 0 | 0.0 | 0.054 |
5777 | 5777 | 2020-11-27 | cdph-other | 0-17 | 10831 | 0.11 | 0 | 0.0 | 0.0 |
5793 | 5793 | 2020-11-27 | other | 0-17 | 1569 | 0.016 | 0 | 0.0 | 0.044 |
5801 | 5801 | 2020-11-27 | white | 0-17 | 10642 | 0.108 | 0 | 0.0 | 0.292 |
5817 | 5817 | 2020-11-26 | black | 0-17 | 2692 | 0.028 | 0 | 0.0 | 0.054 |
5825 | 5825 | 2020-11-26 | cdph-other | 0-17 | 10738 | 0.111 | 0 | 0.0 | 0.0 |
5841 | 5841 | 2020-11-26 | other | 0-17 | 1534 | 0.016 | 0 | 0.0 | 0.044 |
5849 | 5849 | 2020-11-26 | white | 0-17 | 10448 | 0.108 | 0 | 0.0 | 0.292 |
5865 | 5865 | 2020-11-25 | black | 0-17 | 2653 | 0.028 | 0 | 0.0 | 0.054 |
5873 | 5873 | 2020-11-25 | cdph-other | 0-17 | 10551 | 0.11 | 0 | 0.0 | 0.0 |
5889 | 5889 | 2020-11-25 | other | 0-17 | 1489 | 0.016 | 0 | 0.0 | 0.044 |
5897 | 5897 | 2020-11-25 | white | 0-17 | 10216 | 0.107 | 0 | 0.0 | 0.292 |
5913 | 5913 | 2020-11-24 | black | 0-17 | 2617 | 0.028 | 0 | 0.0 | 0.054 |
5921 | 5921 | 2020-11-24 | cdph-other | 0-17 | 10334 | 0.11 | 0 | 0.0 | 0.0 |
5937 | 5937 | 2020-11-24 | other | 0-17 | 1438 | 0.015 | 0 | 0.0 | 0.044 |
5945 | 5945 | 2020-11-24 | white | 0-17 | 9979 | 0.106 | 0 | 0.0 | 0.292 |
5961 | 5961 | 2020-11-23 | black | 0-17 | 2555 | 0.028 | 0 | 0.0 | 0.054 |
5969 | 5969 | 2020-11-23 | cdph-other | 0-17 | 10015 | 0.108 | 0 | 0.0 | 0.0 |
5985 | 5985 | 2020-11-23 | other | 0-17 | 1414 | 0.015 | 0 | 0.0 | 0.044 |
5993 | 5993 | 2020-11-23 | white | 0-17 | 9683 | 0.105 | 0 | 0.0 | 0.292 |
6009 | 6009 | 2020-11-22 | black | 0-17 | 2525 | 0.028 | 0 | 0.0 | 0.054 |
6017 | 6017 | 2020-11-22 | cdph-other | 0-17 | 9742 | 0.107 | 0 | 0.0 | 0.0 |
6033 | 6033 | 2020-11-22 | other | 0-17 | 1400 | 0.016 | 0 | 0.0 | 0.044 |
6041 | 6041 | 2020-11-22 | white | 0-17 | 9462 | 0.10400000000000001 | 0 | 0.0 | 0.292 |
6057 | 6057 | 2020-11-20 | black | 0-17 | 2460 | 0.028 | 0 | 0.0 | 0.054 |
6065 | 6065 | 2020-11-20 | cdph-other | 0-17 | 9507 | 0.107 | 0 | 0.0 | 0.0 |
6081 | 6081 | 2020-11-20 | other | 0-17 | 1352 | 0.015 | 0 | 0.0 | 0.044 |
6089 | 6089 | 2020-11-20 | white | 0-17 | 9106 | 0.10300000000000001 | 0 | 0.0 | 0.292 |
6105 | 6105 | 2020-11-19 | black | 0-17 | 2429 | 0.028 | 0 | 0.0 | 0.054 |
6113 | 6113 | 2020-11-19 | cdph-other | 0-17 | 9348 | 0.107 | 0 | 0.0 | 0.0 |
6129 | 6129 | 2020-11-19 | other | 0-17 | 1330 | 0.015 | 0 | 0.0 | 0.044 |
6137 | 6137 | 2020-11-19 | white | 0-17 | 8890 | 0.10200000000000001 | 0 | 0.0 | 0.292 |
6153 | 6153 | 2020-11-18 | black | 0-17 | 2379 | 0.028 | 0 | 0.0 | 0.054 |
6161 | 6161 | 2020-11-18 | cdph-other | 0-17 | 9229 | 0.107 | 0 | 0.0 | 0.0 |
6177 | 6177 | 2020-11-18 | other | 0-17 | 1302 | 0.015 | 0 | 0.0 | 0.044 |
6185 | 6185 | 2020-11-18 | white | 0-17 | 8697 | 0.101 | 0 | 0.0 | 0.292 |
6201 | 6201 | 2020-11-17 | black | 0-17 | 2353 | 0.028 | 0 | 0.0 | 0.054 |
6209 | 6209 | 2020-11-17 | cdph-other | 0-17 | 9116 | 0.107 | 0 | 0.0 | 0.0 |
6225 | 6225 | 2020-11-17 | other | 0-17 | 1282 | 0.015 | 0 | 0.0 | 0.044 |
6233 | 6233 | 2020-11-17 | white | 0-17 | 8528 | 0.1 | 0 | 0.0 | 0.292 |
6249 | 6249 | 2020-11-16 | black | 0-17 | 2328 | 0.028 | 0 | 0.0 | 0.054 |
6257 | 6257 | 2020-11-16 | cdph-other | 0-17 | 8975 | 0.107 | 0 | 0.0 | 0.0 |
6273 | 6273 | 2020-11-16 | other | 0-17 | 1263 | 0.015 | 0 | 0.0 | 0.044 |
6281 | 6281 | 2020-11-16 | white | 0-17 | 8363 | 0.1 | 0 | 0.0 | 0.292 |
6297 | 6297 | 2020-11-15 | black | 0-17 | 2293 | 0.028 | 0 | 0.0 | 0.054 |
6305 | 6305 | 2020-11-15 | cdph-other | 0-17 | 8807 | 0.106 | 0 | 0.0 | 0.0 |
6321 | 6321 | 2020-11-15 | other | 0-17 | 1243 | 0.015 | 0 | 0.0 | 0.044 |
6329 | 6329 | 2020-11-15 | white | 0-17 | 8242 | 0.099 | 0 | 0.0 | 0.292 |
6345 | 6345 | 2020-11-14 | black | 0-17 | 2270 | 0.028 | 0 | 0.0 | 0.054 |
6353 | 6353 | 2020-11-14 | cdph-other | 0-17 | 8648 | 0.105 | 0 | 0.0 | 0.0 |
6369 | 6369 | 2020-11-14 | other | 0-17 | 1218 | 0.015 | 0 | 0.0 | 0.044 |
6377 | 6377 | 2020-11-14 | white | 0-17 | 8100 | 0.099 | 0 | 0.0 | 0.292 |
6393 | 6393 | 2020-11-13 | black | 0-17 | 2227 | 0.028 | 0 | 0.0 | 0.054 |
6401 | 6401 | 2020-11-13 | cdph-other | 0-17 | 8508 | 0.105 | 0 | 0.0 | 0.0 |
6417 | 6417 | 2020-11-13 | other | 0-17 | 1195 | 0.015 | 0 | 0.0 | 0.044 |
6425 | 6425 | 2020-11-13 | white | 0-17 | 7947 | 0.098 | 0 | 0.0 | 0.292 |
6441 | 6441 | 2020-11-12 | black | 0-17 | 2202 | 0.027 | 0 | 0.0 | 0.054 |
6449 | 6449 | 2020-11-12 | cdph-other | 0-17 | 8423 | 0.105 | 0 | 0.0 | 0.0 |
6465 | 6465 | 2020-11-12 | other | 0-17 | 1183 | 0.015 | 0 | 0.0 | 0.044 |
6473 | 6473 | 2020-11-12 | white | 0-17 | 7821 | 0.098 | 0 | 0.0 | 0.292 |
6489 | 6489 | 2020-11-11 | black | 0-17 | 2175 | 0.027 | 0 | 0.0 | 0.054 |
6497 | 6497 | 2020-11-11 | cdph-other | 0-17 | 8310 | 0.105 | 0 | 0.0 | 0.0 |
6513 | 6513 | 2020-11-11 | other | 0-17 | 1162 | 0.015 | 0 | 0.0 | 0.044 |
6521 | 6521 | 2020-11-11 | white | 0-17 | 7728 | 0.097 | 0 | 0.0 | 0.292 |
6537 | 6537 | 2020-11-10 | black | 0-17 | 2141 | 0.027 | 0 | 0.0 | 0.054 |
6545 | 6545 | 2020-11-10 | cdph-other | 0-17 | 8173 | 0.10400000000000001 | 0 | 0.0 | 0.0 |
6561 | 6561 | 2020-11-10 | other | 0-17 | 1146 | 0.015 | 0 | 0.0 | 0.044 |
6569 | 6569 | 2020-11-10 | white | 0-17 | 7584 | 0.097 | 0 | 0.0 | 0.292 |
6585 | 6585 | 2020-11-09 | black | 0-17 | 2122 | 0.027 | 0 | 0.0 | 0.054 |
6593 | 6593 | 2020-11-09 | cdph-other | 0-17 | 8099 | 0.10400000000000001 | 0 | 0.0 | 0.0 |
6609 | 6609 | 2020-11-09 | other | 0-17 | 1128 | 0.015 | 0 | 0.0 | 0.044 |
6617 | 6617 | 2020-11-09 | white | 0-17 | 7501 | 0.096 | 0 | 0.0 | 0.292 |
6633 | 6633 | 2020-11-08 | black | 0-17 | 2102 | 0.027 | 0 | 0.0 | 0.054 |
6641 | 6641 | 2020-11-08 | cdph-other | 0-17 | 8008 | 0.10400000000000001 | 0 | 0.0 | 0.0 |
6657 | 6657 | 2020-11-08 | other | 0-17 | 1120 | 0.015 | 0 | 0.0 | 0.044 |
6665 | 6665 | 2020-11-08 | white | 0-17 | 7423 | 0.096 | 0 | 0.0 | 0.292 |
6681 | 6681 | 2020-11-05 | black | 0-17 | 2038 | 0.027 | 0 | 0.0 | 0.054 |
6689 | 6689 | 2020-11-05 | cdph-other | 0-17 | 7719 | 0.10300000000000001 | 0 | 0.0 | 0.0 |
6705 | 6705 | 2020-11-05 | other | 0-17 | 1079 | 0.015 | 0 | 0.0 | 0.044 |
6713 | 6713 | 2020-11-05 | white | 0-17 | 7135 | 0.095 | 0 | 0.0 | 0.292 |
6729 | 6729 | 2020-11-04 | black | 0-17 | 2012 | 0.027 | 0 | 0.0 | 0.054 |
6737 | 6737 | 2020-11-04 | cdph-other | 0-17 | 7602 | 0.10200000000000001 | 0 | 0.0 | 0.0 |
6753 | 6753 | 2020-11-04 | other | 0-17 | 1061 | 0.014 | 0 | 0.0 | 0.044 |
6761 | 6761 | 2020-11-04 | white | 0-17 | 7033 | 0.094 | 0 | 0.0 | 0.292 |
6777 | 6777 | 2020-11-03 | black | 0-17 | 2008 | 0.027 | 0 | 0.0 | 0.054 |
6785 | 6785 | 2020-11-03 | cdph-other | 0-17 | 7544 | 0.10200000000000001 | 0 | 0.0 | 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 );