latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
120 rows where county = "El Dorado" and deaths = 0 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
23905 | 23905 | 2020-07-17 | El Dorado | 17 | 394 | 0 | 13 | 0 |
23963 | 23963 | 2020-07-16 | El Dorado | 17 | 381 | 0 | 18 | 0 |
24021 | 24021 | 2020-07-15 | El Dorado | 17 | 363 | 0 | 13 | 0 |
24079 | 24079 | 2020-07-14 | El Dorado | 17 | 350 | 0 | 13 | 0 |
24137 | 24137 | 2020-07-13 | El Dorado | 17 | 337 | 0 | 30 | 0 |
24195 | 24195 | 2020-07-12 | El Dorado | 17 | 307 | 0 | 0 | 0 |
24253 | 24253 | 2020-07-11 | El Dorado | 17 | 307 | 0 | 0 | 0 |
24311 | 24311 | 2020-07-10 | El Dorado | 17 | 307 | 0 | 15 | 0 |
24369 | 24369 | 2020-07-09 | El Dorado | 17 | 292 | 0 | 12 | 0 |
24427 | 24427 | 2020-07-08 | El Dorado | 17 | 280 | 0 | 16 | 0 |
24485 | 24485 | 2020-07-07 | El Dorado | 17 | 264 | 0 | 2 | 0 |
24543 | 24543 | 2020-07-06 | El Dorado | 17 | 262 | 0 | 36 | 0 |
24601 | 24601 | 2020-07-05 | El Dorado | 17 | 226 | 0 | 0 | 0 |
24659 | 24659 | 2020-07-04 | El Dorado | 17 | 226 | 0 | 0 | 0 |
24717 | 24717 | 2020-07-03 | El Dorado | 17 | 226 | 0 | 20 | 0 |
24775 | 24775 | 2020-07-02 | El Dorado | 17 | 206 | 0 | 8 | 0 |
24833 | 24833 | 2020-07-01 | El Dorado | 17 | 198 | 0 | 14 | 0 |
24891 | 24891 | 2020-06-30 | El Dorado | 17 | 184 | 0 | 6 | 0 |
24949 | 24949 | 2020-06-29 | El Dorado | 17 | 178 | 0 | 20 | 0 |
25007 | 25007 | 2020-06-28 | El Dorado | 17 | 158 | 0 | 0 | 0 |
25065 | 25065 | 2020-06-27 | El Dorado | 17 | 158 | 0 | 0 | 0 |
25123 | 25123 | 2020-06-26 | El Dorado | 17 | 158 | 0 | 0 | 0 |
25181 | 25181 | 2020-06-25 | El Dorado | 17 | 158 | 0 | 5 | 0 |
25239 | 25239 | 2020-06-24 | El Dorado | 17 | 153 | 0 | 3 | 0 |
25297 | 25297 | 2020-06-23 | El Dorado | 17 | 150 | 0 | 5 | 0 |
25355 | 25355 | 2020-06-22 | El Dorado | 17 | 145 | 0 | 15 | 0 |
25413 | 25413 | 2020-06-21 | El Dorado | 17 | 130 | 0 | 0 | 0 |
25471 | 25471 | 2020-06-20 | El Dorado | 17 | 130 | 0 | 0 | 0 |
25529 | 25529 | 2020-06-19 | El Dorado | 17 | 130 | 0 | 5 | 0 |
25587 | 25587 | 2020-06-18 | El Dorado | 17 | 125 | 0 | 4 | 0 |
25645 | 25645 | 2020-06-17 | El Dorado | 17 | 121 | 0 | 3 | 0 |
25703 | 25703 | 2020-06-16 | El Dorado | 17 | 118 | 0 | 1 | 0 |
25761 | 25761 | 2020-06-15 | El Dorado | 17 | 117 | 0 | 4 | 0 |
25819 | 25819 | 2020-06-14 | El Dorado | 17 | 113 | 0 | 0 | 0 |
25877 | 25877 | 2020-06-13 | El Dorado | 17 | 113 | 0 | 0 | 0 |
25935 | 25935 | 2020-06-12 | El Dorado | 17 | 113 | 0 | 2 | 0 |
25993 | 25993 | 2020-06-11 | El Dorado | 17 | 111 | 0 | 0 | 0 |
26051 | 26051 | 2020-06-10 | El Dorado | 17 | 111 | 0 | 0 | 0 |
26109 | 26109 | 2020-06-09 | El Dorado | 17 | 111 | 0 | 2 | 0 |
26167 | 26167 | 2020-06-08 | El Dorado | 17 | 109 | 0 | 3 | 0 |
26225 | 26225 | 2020-06-07 | El Dorado | 17 | 106 | 0 | 0 | 0 |
26283 | 26283 | 2020-06-06 | El Dorado | 17 | 106 | 0 | 0 | 0 |
26341 | 26341 | 2020-06-05 | El Dorado | 17 | 106 | 0 | 4 | 0 |
26399 | 26399 | 2020-06-04 | El Dorado | 17 | 102 | 0 | 4 | 0 |
26457 | 26457 | 2020-06-03 | El Dorado | 17 | 98 | 0 | 2 | 0 |
26515 | 26515 | 2020-06-02 | El Dorado | 17 | 96 | 0 | 0 | 0 |
26573 | 26573 | 2020-06-01 | El Dorado | 17 | 96 | 0 | 6 | 0 |
26631 | 26631 | 2020-05-31 | El Dorado | 17 | 90 | 0 | 0 | 0 |
26689 | 26689 | 2020-05-30 | El Dorado | 17 | 90 | 0 | 0 | 0 |
26747 | 26747 | 2020-05-29 | El Dorado | 17 | 90 | 0 | 6 | 0 |
26805 | 26805 | 2020-05-28 | El Dorado | 17 | 84 | 0 | 3 | 0 |
26863 | 26863 | 2020-05-27 | El Dorado | 17 | 81 | 0 | 1 | 0 |
26921 | 26921 | 2020-05-26 | El Dorado | 17 | 80 | 0 | 2 | 0 |
26979 | 26979 | 2020-05-25 | El Dorado | 17 | 78 | 0 | 4 | 0 |
27037 | 27037 | 2020-05-24 | El Dorado | 17 | 74 | 0 | 0 | 0 |
27095 | 27095 | 2020-05-23 | El Dorado | 17 | 74 | 0 | 0 | 0 |
27153 | 27153 | 2020-05-22 | El Dorado | 17 | 74 | 0 | 7 | 0 |
27211 | 27211 | 2020-05-21 | El Dorado | 17 | 67 | 0 | 0 | 0 |
27269 | 27269 | 2020-05-20 | El Dorado | 17 | 67 | 0 | 0 | 0 |
27327 | 27327 | 2020-05-19 | El Dorado | 17 | 67 | 0 | 0 | 0 |
27385 | 27385 | 2020-05-18 | El Dorado | 17 | 67 | 0 | 3 | 0 |
27443 | 27443 | 2020-05-17 | El Dorado | 17 | 64 | 0 | 0 | 0 |
27501 | 27501 | 2020-05-16 | El Dorado | 17 | 64 | 0 | 0 | 0 |
27559 | 27559 | 2020-05-15 | El Dorado | 17 | 64 | 0 | 2 | 0 |
27617 | 27617 | 2020-05-14 | El Dorado | 17 | 62 | 0 | 2 | 0 |
27675 | 27675 | 2020-05-13 | El Dorado | 17 | 60 | 0 | 0 | 0 |
27733 | 27733 | 2020-05-12 | El Dorado | 17 | 60 | 0 | 4 | 0 |
27791 | 27791 | 2020-05-11 | El Dorado | 17 | 56 | 0 | 2 | 0 |
27849 | 27849 | 2020-05-10 | El Dorado | 17 | 54 | 0 | 0 | 0 |
27907 | 27907 | 2020-05-09 | El Dorado | 17 | 54 | 0 | 0 | 0 |
27965 | 27965 | 2020-05-08 | El Dorado | 17 | 54 | 0 | 0 | 0 |
28023 | 28023 | 2020-05-07 | El Dorado | 17 | 54 | 0 | 0 | 0 |
28081 | 28081 | 2020-05-06 | El Dorado | 17 | 54 | 0 | 1 | 0 |
28139 | 28139 | 2020-05-05 | El Dorado | 17 | 53 | 0 | 0 | 0 |
28197 | 28197 | 2020-05-04 | El Dorado | 17 | 53 | 0 | 6 | 0 |
28255 | 28255 | 2020-05-03 | El Dorado | 17 | 47 | 0 | 0 | 0 |
28313 | 28313 | 2020-05-02 | El Dorado | 17 | 47 | 0 | 0 | 0 |
28371 | 28371 | 2020-05-01 | El Dorado | 17 | 47 | 0 | 3 | 0 |
28429 | 28429 | 2020-04-30 | El Dorado | 17 | 44 | 0 | 0 | 0 |
28487 | 28487 | 2020-04-29 | El Dorado | 17 | 44 | 0 | 0 | 0 |
28545 | 28545 | 2020-04-28 | El Dorado | 17 | 44 | 0 | 1 | 0 |
28599 | 28599 | 2020-04-27 | El Dorado | 17 | 43 | 0 | 1 | 0 |
28652 | 28652 | 2020-04-26 | El Dorado | 17 | 42 | 0 | 0 | 0 |
28705 | 28705 | 2020-04-25 | El Dorado | 17 | 42 | 0 | 0 | 0 |
28758 | 28758 | 2020-04-24 | El Dorado | 17 | 42 | 0 | 2 | 0 |
28811 | 28811 | 2020-04-23 | El Dorado | 17 | 40 | 0 | 1 | 0 |
28864 | 28864 | 2020-04-22 | El Dorado | 17 | 39 | 0 | 0 | 0 |
28917 | 28917 | 2020-04-21 | El Dorado | 17 | 39 | 0 | 1 | 0 |
28970 | 28970 | 2020-04-20 | El Dorado | 17 | 38 | 0 | 2 | 0 |
29023 | 29023 | 2020-04-19 | El Dorado | 17 | 36 | 0 | 0 | 0 |
29076 | 29076 | 2020-04-18 | El Dorado | 17 | 36 | 0 | 0 | 0 |
29129 | 29129 | 2020-04-17 | El Dorado | 17 | 36 | 0 | 1 | 0 |
29182 | 29182 | 2020-04-16 | El Dorado | 17 | 35 | 0 | 0 | 0 |
29235 | 29235 | 2020-04-15 | El Dorado | 17 | 35 | 0 | 0 | 0 |
29288 | 29288 | 2020-04-14 | El Dorado | 17 | 35 | 0 | 1 | 0 |
29341 | 29341 | 2020-04-13 | El Dorado | 17 | 34 | 0 | 2 | 0 |
29394 | 29394 | 2020-04-12 | El Dorado | 17 | 32 | 0 | 0 | 0 |
29447 | 29447 | 2020-04-11 | El Dorado | 17 | 32 | 0 | 0 | 0 |
29500 | 29500 | 2020-04-10 | El Dorado | 17 | 32 | 0 | 2 | 0 |
29553 | 29553 | 2020-04-09 | El Dorado | 17 | 30 | 0 | 1 | 0 |
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 );