latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
54 rows where county = "Madera" and deaths = 2 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 |
---|---|---|---|---|---|---|---|---|
26584 | 26584 | 2020-06-01 | Madera | 39 | 114 | 2 | 8 | 0 |
26642 | 26642 | 2020-05-31 | Madera | 39 | 106 | 2 | 2 | 0 |
26700 | 26700 | 2020-05-30 | Madera | 39 | 104 | 2 | 0 | 0 |
26758 | 26758 | 2020-05-29 | Madera | 39 | 104 | 2 | 6 | 0 |
26816 | 26816 | 2020-05-28 | Madera | 39 | 98 | 2 | 4 | 0 |
26874 | 26874 | 2020-05-27 | Madera | 39 | 94 | 2 | 4 | 0 |
26932 | 26932 | 2020-05-26 | Madera | 39 | 90 | 2 | 5 | 0 |
26990 | 26990 | 2020-05-25 | Madera | 39 | 85 | 2 | 1 | 0 |
27048 | 27048 | 2020-05-24 | Madera | 39 | 84 | 2 | 0 | 0 |
27106 | 27106 | 2020-05-23 | Madera | 39 | 84 | 2 | 1 | 0 |
27164 | 27164 | 2020-05-22 | Madera | 39 | 83 | 2 | 0 | 0 |
27222 | 27222 | 2020-05-21 | Madera | 39 | 83 | 2 | 1 | 0 |
27280 | 27280 | 2020-05-20 | Madera | 39 | 82 | 2 | 1 | 0 |
27338 | 27338 | 2020-05-19 | Madera | 39 | 81 | 2 | 3 | 0 |
27396 | 27396 | 2020-05-18 | Madera | 39 | 78 | 2 | 7 | 0 |
27454 | 27454 | 2020-05-17 | Madera | 39 | 71 | 2 | 1 | 0 |
27512 | 27512 | 2020-05-16 | Madera | 39 | 70 | 2 | 0 | 0 |
27570 | 27570 | 2020-05-15 | Madera | 39 | 70 | 2 | 1 | 0 |
27628 | 27628 | 2020-05-14 | Madera | 39 | 69 | 2 | 0 | 0 |
27686 | 27686 | 2020-05-13 | Madera | 39 | 69 | 2 | 0 | 0 |
27744 | 27744 | 2020-05-12 | Madera | 39 | 69 | 2 | 2 | 0 |
27802 | 27802 | 2020-05-11 | Madera | 39 | 67 | 2 | 0 | 0 |
27860 | 27860 | 2020-05-10 | Madera | 39 | 67 | 2 | 0 | 0 |
27918 | 27918 | 2020-05-09 | Madera | 39 | 67 | 2 | 1 | 0 |
27976 | 27976 | 2020-05-08 | Madera | 39 | 66 | 2 | 4 | 0 |
28034 | 28034 | 2020-05-07 | Madera | 39 | 62 | 2 | 7 | 0 |
28092 | 28092 | 2020-05-06 | Madera | 39 | 55 | 2 | 1 | 0 |
28150 | 28150 | 2020-05-05 | Madera | 39 | 54 | 2 | 0 | 0 |
28208 | 28208 | 2020-05-04 | Madera | 39 | 54 | 2 | 3 | 0 |
28266 | 28266 | 2020-05-03 | Madera | 39 | 51 | 2 | 0 | 0 |
28324 | 28324 | 2020-05-02 | Madera | 39 | 51 | 2 | 5 | 0 |
28382 | 28382 | 2020-05-01 | Madera | 39 | 46 | 2 | 0 | 0 |
28440 | 28440 | 2020-04-30 | Madera | 39 | 46 | 2 | 0 | 0 |
28498 | 28498 | 2020-04-29 | Madera | 39 | 46 | 2 | 1 | 0 |
28555 | 28555 | 2020-04-28 | Madera | 39 | 45 | 2 | 1 | 0 |
28609 | 28609 | 2020-04-27 | Madera | 39 | 44 | 2 | 3 | 0 |
28662 | 28662 | 2020-04-26 | Madera | 39 | 41 | 2 | 1 | 0 |
28715 | 28715 | 2020-04-25 | Madera | 39 | 40 | 2 | 1 | 0 |
28768 | 28768 | 2020-04-24 | Madera | 39 | 39 | 2 | 0 | 0 |
28821 | 28821 | 2020-04-23 | Madera | 39 | 39 | 2 | 3 | 0 |
28874 | 28874 | 2020-04-22 | Madera | 39 | 36 | 2 | 0 | 0 |
28927 | 28927 | 2020-04-21 | Madera | 39 | 36 | 2 | 0 | 0 |
28980 | 28980 | 2020-04-20 | Madera | 39 | 36 | 2 | 2 | 0 |
29033 | 29033 | 2020-04-19 | Madera | 39 | 34 | 2 | 0 | 0 |
29086 | 29086 | 2020-04-18 | Madera | 39 | 34 | 2 | 1 | 0 |
29139 | 29139 | 2020-04-17 | Madera | 39 | 33 | 2 | 0 | 0 |
29192 | 29192 | 2020-04-16 | Madera | 39 | 33 | 2 | 0 | 0 |
29245 | 29245 | 2020-04-15 | Madera | 39 | 33 | 2 | 0 | 0 |
29298 | 29298 | 2020-04-14 | Madera | 39 | 33 | 2 | 0 | 0 |
29351 | 29351 | 2020-04-13 | Madera | 39 | 33 | 2 | 0 | 0 |
29404 | 29404 | 2020-04-12 | Madera | 39 | 33 | 2 | 1 | 0 |
29457 | 29457 | 2020-04-11 | Madera | 39 | 32 | 2 | 0 | 0 |
29510 | 29510 | 2020-04-10 | Madera | 39 | 32 | 2 | 2 | 0 |
29563 | 29563 | 2020-04-09 | Madera | 39 | 30 | 2 | 2 | 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 );