latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
35 rows where county = "El Dorado" and deaths = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
20541 | 20541 | 2020-09-13 | El Dorado | 17 | 1032 | 2 | 0 | 0 |
20599 | 20599 | 2020-09-12 | El Dorado | 17 | 1032 | 2 | 0 | 0 |
20657 | 20657 | 2020-09-11 | El Dorado | 17 | 1032 | 2 | 7 | 0 |
20715 | 20715 | 2020-09-10 | El Dorado | 17 | 1025 | 2 | 6 | 0 |
20773 | 20773 | 2020-09-09 | El Dorado | 17 | 1019 | 2 | 6 | 0 |
20831 | 20831 | 2020-09-08 | El Dorado | 17 | 1013 | 2 | 5 | 0 |
20889 | 20889 | 2020-09-07 | El Dorado | 17 | 1008 | 2 | 7 | 0 |
20947 | 20947 | 2020-09-06 | El Dorado | 17 | 1001 | 2 | 0 | 0 |
21005 | 21005 | 2020-09-05 | El Dorado | 17 | 1001 | 2 | 0 | 0 |
21063 | 21063 | 2020-09-04 | El Dorado | 17 | 1001 | 2 | 13 | 0 |
21121 | 21121 | 2020-09-03 | El Dorado | 17 | 988 | 2 | 8 | 0 |
21179 | 21179 | 2020-09-02 | El Dorado | 17 | 980 | 2 | 7 | 0 |
21237 | 21237 | 2020-09-01 | El Dorado | 17 | 973 | 2 | 6 | 0 |
21295 | 21295 | 2020-08-31 | El Dorado | 17 | 967 | 2 | 16 | 0 |
21353 | 21353 | 2020-08-30 | El Dorado | 17 | 951 | 2 | 0 | 0 |
21411 | 21411 | 2020-08-29 | El Dorado | 17 | 951 | 2 | 0 | 0 |
21469 | 21469 | 2020-08-28 | El Dorado | 17 | 951 | 2 | 9 | 0 |
21527 | 21527 | 2020-08-27 | El Dorado | 17 | 942 | 2 | 7 | 0 |
21585 | 21585 | 2020-08-26 | El Dorado | 17 | 935 | 2 | 3 | 0 |
21643 | 21643 | 2020-08-25 | El Dorado | 17 | 932 | 2 | 8 | 0 |
21701 | 21701 | 2020-08-24 | El Dorado | 17 | 924 | 2 | 28 | 0 |
21759 | 21759 | 2020-08-23 | El Dorado | 17 | 896 | 2 | 0 | 0 |
21817 | 21817 | 2020-08-22 | El Dorado | 17 | 896 | 2 | 0 | 0 |
21875 | 21875 | 2020-08-21 | El Dorado | 17 | 896 | 2 | 11 | 0 |
21933 | 21933 | 2020-08-20 | El Dorado | 17 | 885 | 2 | 8 | 0 |
21991 | 21991 | 2020-08-19 | El Dorado | 17 | 877 | 2 | 6 | 0 |
22049 | 22049 | 2020-08-18 | El Dorado | 17 | 871 | 2 | 22 | 0 |
22107 | 22107 | 2020-08-17 | El Dorado | 17 | 849 | 2 | 22 | 0 |
22165 | 22165 | 2020-08-16 | El Dorado | 17 | 827 | 2 | 0 | 0 |
22223 | 22223 | 2020-08-15 | El Dorado | 17 | 827 | 2 | 0 | 0 |
22281 | 22281 | 2020-08-14 | El Dorado | 17 | 827 | 2 | 25 | 0 |
22339 | 22339 | 2020-08-13 | El Dorado | 17 | 802 | 2 | 9 | 0 |
22397 | 22397 | 2020-08-12 | El Dorado | 17 | 793 | 2 | 8 | 0 |
22455 | 22455 | 2020-08-11 | El Dorado | 17 | 785 | 2 | 30 | 0 |
22513 | 22513 | 2020-08-10 | El Dorado | 17 | 755 | 2 | 26 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );