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.
2,160 rows where race = "white" sorted by deaths_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: age, population_percent, date (date)
Link | rowid | date | race | age | confirmed_cases_total | confirmed_cases_percent | deaths_total ▼ | deaths_percent | population_percent |
---|---|---|---|---|---|---|---|---|---|
4697 | 4697 | 2020-12-22 | white | 0-17 | 21573 | 0.124 | 0 | 0.0 | 0.292 |
4745 | 4745 | 2020-12-21 | white | 0-17 | 21105 | 0.123 | 0 | 0.0 | 0.292 |
4793 | 4793 | 2020-12-20 | white | 0-17 | 20585 | 0.123 | 0 | 0.0 | 0.292 |
4841 | 4841 | 2020-12-19 | white | 0-17 | 19856 | 0.122 | 0 | 0.0 | 0.292 |
4889 | 4889 | 2020-12-16 | white | 0-17 | 18072 | 0.12 | 0 | 0.0 | 0.292 |
4937 | 4937 | 2020-12-15 | white | 0-17 | 17510 | 0.121 | 0 | 0.0 | 0.292 |
4985 | 4985 | 2020-12-14 | white | 0-17 | 16877 | 0.12 | 0 | 0.0 | 0.292 |
5033 | 5033 | 2020-12-13 | white | 0-17 | 16385 | 0.11900000000000001 | 0 | 0.0 | 0.292 |
5081 | 5081 | 2020-12-12 | white | 0-17 | 16004 | 0.11900000000000001 | 0 | 0.0 | 0.292 |
5129 | 5129 | 2020-12-11 | white | 0-17 | 15513 | 0.11800000000000001 | 0 | 0.0 | 0.292 |
5177 | 5177 | 2020-12-10 | white | 0-17 | 15039 | 0.11800000000000001 | 0 | 0.0 | 0.292 |
5225 | 5225 | 2020-12-09 | white | 0-17 | 14485 | 0.117 | 0 | 0.0 | 0.292 |
5273 | 5273 | 2020-12-08 | white | 0-17 | 14129 | 0.117 | 0 | 0.0 | 0.292 |
5321 | 5321 | 2020-12-07 | white | 0-17 | 13706 | 0.116 | 0 | 0.0 | 0.292 |
5369 | 5369 | 2020-12-06 | white | 0-17 | 13345 | 0.115 | 0 | 0.0 | 0.292 |
5417 | 5417 | 2020-12-05 | white | 0-17 | 12900 | 0.114 | 0 | 0.0 | 0.292 |
5465 | 5465 | 2020-12-04 | white | 0-17 | 12466 | 0.113 | 0 | 0.0 | 0.292 |
5513 | 5513 | 2020-12-03 | white | 0-17 | 12110 | 0.112 | 0 | 0.0 | 0.292 |
5561 | 5561 | 2020-12-02 | white | 0-17 | 11812 | 0.112 | 0 | 0.0 | 0.292 |
5609 | 5609 | 2020-12-01 | white | 0-17 | 11501 | 0.111 | 0 | 0.0 | 0.292 |
5657 | 5657 | 2020-11-30 | white | 0-17 | 11212 | 0.11 | 0 | 0.0 | 0.292 |
5705 | 5705 | 2020-11-29 | white | 0-17 | 11066 | 0.11 | 0 | 0.0 | 0.292 |
5753 | 5753 | 2020-11-28 | white | 0-17 | 10857 | 0.109 | 0 | 0.0 | 0.292 |
5801 | 5801 | 2020-11-27 | white | 0-17 | 10642 | 0.108 | 0 | 0.0 | 0.292 |
5849 | 5849 | 2020-11-26 | white | 0-17 | 10448 | 0.108 | 0 | 0.0 | 0.292 |
5897 | 5897 | 2020-11-25 | white | 0-17 | 10216 | 0.107 | 0 | 0.0 | 0.292 |
5945 | 5945 | 2020-11-24 | white | 0-17 | 9979 | 0.106 | 0 | 0.0 | 0.292 |
5993 | 5993 | 2020-11-23 | white | 0-17 | 9683 | 0.105 | 0 | 0.0 | 0.292 |
6041 | 6041 | 2020-11-22 | white | 0-17 | 9462 | 0.10400000000000001 | 0 | 0.0 | 0.292 |
6089 | 6089 | 2020-11-20 | white | 0-17 | 9106 | 0.10300000000000001 | 0 | 0.0 | 0.292 |
6137 | 6137 | 2020-11-19 | white | 0-17 | 8890 | 0.10200000000000001 | 0 | 0.0 | 0.292 |
6185 | 6185 | 2020-11-18 | white | 0-17 | 8697 | 0.101 | 0 | 0.0 | 0.292 |
6233 | 6233 | 2020-11-17 | white | 0-17 | 8528 | 0.1 | 0 | 0.0 | 0.292 |
6281 | 6281 | 2020-11-16 | white | 0-17 | 8363 | 0.1 | 0 | 0.0 | 0.292 |
6329 | 6329 | 2020-11-15 | white | 0-17 | 8242 | 0.099 | 0 | 0.0 | 0.292 |
6377 | 6377 | 2020-11-14 | white | 0-17 | 8100 | 0.099 | 0 | 0.0 | 0.292 |
6425 | 6425 | 2020-11-13 | white | 0-17 | 7947 | 0.098 | 0 | 0.0 | 0.292 |
6473 | 6473 | 2020-11-12 | white | 0-17 | 7821 | 0.098 | 0 | 0.0 | 0.292 |
6521 | 6521 | 2020-11-11 | white | 0-17 | 7728 | 0.097 | 0 | 0.0 | 0.292 |
6569 | 6569 | 2020-11-10 | white | 0-17 | 7584 | 0.097 | 0 | 0.0 | 0.292 |
6617 | 6617 | 2020-11-09 | white | 0-17 | 7501 | 0.096 | 0 | 0.0 | 0.292 |
6665 | 6665 | 2020-11-08 | white | 0-17 | 7423 | 0.096 | 0 | 0.0 | 0.292 |
6713 | 6713 | 2020-11-05 | white | 0-17 | 7135 | 0.095 | 0 | 0.0 | 0.292 |
6761 | 6761 | 2020-11-04 | white | 0-17 | 7033 | 0.094 | 0 | 0.0 | 0.292 |
6809 | 6809 | 2020-11-03 | white | 0-17 | 6986 | 0.094 | 0 | 0.0 | 0.292 |
6857 | 6857 | 2020-11-02 | white | 0-17 | 6909 | 0.094 | 0 | 0.0 | 0.292 |
6905 | 6905 | 2020-11-01 | white | 0-17 | 6865 | 0.094 | 0 | 0.0 | 0.292 |
6953 | 6953 | 2020-10-31 | white | 0-17 | 6803 | 0.094 | 0 | 0.0 | 0.292 |
7001 | 7001 | 2020-10-29 | white | 0-17 | 6671 | 0.093 | 0 | 0.0 | 0.292 |
7049 | 7049 | 2020-10-28 | white | 0-17 | 6607 | 0.093 | 0 | 0.0 | 0.292 |
7097 | 7097 | 2020-10-27 | white | 0-17 | 6557 | 0.093 | 0 | 0.0 | 0.292 |
7145 | 7145 | 2020-10-26 | white | 0-17 | 6494 | 0.092 | 0 | 0.0 | 0.292 |
7193 | 7193 | 2020-10-25 | white | 0-17 | 6465 | 0.092 | 0 | 0.0 | 0.292 |
7241 | 7241 | 2020-10-23 | white | 0-17 | 6394 | 0.092 | 0 | 0.0 | 0.292 |
7289 | 7289 | 2020-10-21 | white | 0-17 | 6305 | 0.092 | 0 | 0.0 | 0.292 |
7337 | 7337 | 2020-10-20 | white | 0-17 | 6223 | 0.092 | 0 | 0.0 | 0.292 |
7385 | 7385 | 2020-10-19 | white | 0-17 | 6178 | 0.092 | 0 | 0.0 | 0.292 |
7433 | 7433 | 2020-10-18 | white | 0-17 | 6148 | 0.092 | 0 | 0.0 | 0.292 |
7481 | 7481 | 2020-10-17 | white | 0-17 | 6102 | 0.092 | 0 | 0.0 | 0.292 |
7529 | 7529 | 2020-10-15 | white | 0-17 | 6026 | 0.091 | 0 | 0.0 | 0.292 |
7577 | 7577 | 2020-10-14 | white | 0-17 | 5982 | 0.091 | 0 | 0.0 | 0.292 |
7625 | 7625 | 2020-10-13 | white | 0-17 | 5959 | 0.091 | 0 | 0.0 | 0.292 |
7673 | 7673 | 2020-10-12 | white | 0-17 | 5931 | 0.091 | 0 | 0.0 | 0.292 |
7721 | 7721 | 2020-10-11 | white | 0-17 | 5898 | 0.091 | 0 | 0.0 | 0.292 |
7769 | 7769 | 2020-10-10 | white | 0-17 | 5852 | 0.091 | 0 | 0.0 | 0.292 |
7817 | 7817 | 2020-10-09 | white | 0-17 | 5792 | 0.09 | 0 | 0.0 | 0.292 |
7865 | 7865 | 2020-10-08 | white | 0-17 | 5756 | 0.09 | 0 | 0.0 | 0.292 |
7913 | 7913 | 2020-10-07 | white | 0-17 | 5688 | 0.09 | 0 | 0.0 | 0.292 |
7961 | 7961 | 2020-10-06 | white | 0-17 | 5647 | 0.09 | 0 | 0.0 | 0.292 |
8009 | 8009 | 2020-10-05 | white | 0-17 | 5611 | 0.09 | 0 | 0.0 | 0.292 |
8057 | 8057 | 2020-10-04 | white | 0-17 | 5585 | 0.09 | 0 | 0.0 | 0.292 |
8105 | 8105 | 2020-10-03 | white | 0-17 | 5547 | 0.089 | 0 | 0.0 | 0.292 |
8153 | 8153 | 2020-10-02 | white | 0-17 | 5502 | 0.089 | 0 | 0.0 | 0.292 |
8201 | 8201 | 2020-10-01 | white | 0-17 | 5493 | 0.09 | 0 | 0.0 | 0.292 |
8249 | 8249 | 2020-09-30 | white | 0-17 | 5434 | 0.089 | 0 | 0.0 | 0.292 |
8297 | 8297 | 2020-09-29 | white | 0-17 | 5386 | 0.089 | 0 | 0.0 | 0.292 |
8345 | 8345 | 2020-09-28 | white | 0-17 | 5344 | 0.089 | 0 | 0.0 | 0.292 |
8393 | 8393 | 2020-09-27 | white | 0-17 | 5314 | 0.088 | 0 | 0.0 | 0.292 |
8441 | 8441 | 2020-09-26 | white | 0-17 | 5295 | 0.089 | 0 | 0.0 | 0.292 |
8489 | 8489 | 2020-09-25 | white | 0-17 | 5229 | 0.088 | 0 | 0.0 | 0.292 |
8537 | 8537 | 2020-09-24 | white | 0-17 | 5173 | 0.088 | 0 | 0.0 | 0.292 |
8585 | 8585 | 2020-09-23 | white | 0-17 | 5130 | 0.088 | 0 | 0.0 | 0.292 |
8633 | 8633 | 2020-09-22 | white | 0-17 | 5094 | 0.088 | 0 | 0.0 | 0.292 |
8681 | 8681 | 2020-09-21 | white | 0-17 | 5058 | 0.088 | 0 | 0.0 | 0.292 |
8729 | 8729 | 2020-09-20 | white | 0-17 | 5024 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
8777 | 8777 | 2020-09-19 | white | 0-17 | 5002 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
8825 | 8825 | 2020-09-17 | white | 0-17 | 4901 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
8873 | 8873 | 2020-09-16 | white | 0-17 | 4878 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
8921 | 8921 | 2020-09-15 | white | 0-17 | 4845 | 0.088 | 0 | 0.0 | 0.292 |
8969 | 8969 | 2020-09-14 | white | 0-17 | 4808 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
9017 | 9017 | 2020-09-13 | white | 0-17 | 4791 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
9065 | 9065 | 2020-09-12 | white | 0-17 | 4765 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
9113 | 9113 | 2020-09-11 | white | 0-17 | 4720 | 0.08700000000000001 | 0 | 0.0 | 0.292 |
9161 | 9161 | 2020-09-10 | white | 0-17 | 4685 | 0.088 | 0 | 0.0 | 0.292 |
9209 | 9209 | 2020-09-09 | white | 0-17 | 4646 | 0.088 | 0 | 0.0 | 0.292 |
9257 | 9257 | 2020-09-08 | white | 0-17 | 4622 | 0.088 | 0 | 0.0 | 0.292 |
9305 | 9305 | 2020-09-06 | white | 0-17 | 4579 | 0.088 | 0 | 0.0 | 0.292 |
9353 | 9353 | 2020-09-05 | white | 0-17 | 4542 | 0.088 | 0 | 0.0 | 0.292 |
9401 | 9401 | 2020-09-04 | white | 0-17 | 4491 | 0.088 | 0 | 0.0 | 0.292 |
9449 | 9449 | 2020-09-03 | white | 0-17 | 4442 | 0.088 | 0 | 0.0 | 0.292 |
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 );