latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
14 rows where county = "Madera" and deaths = 3 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 |
---|---|---|---|---|---|---|---|---|
25772 | 25772 | 2020-06-15 | Madera | 39 | 226 | 3 | 28 | 0 |
25830 | 25830 | 2020-06-14 | Madera | 39 | 198 | 3 | 0 | 0 |
25888 | 25888 | 2020-06-13 | Madera | 39 | 198 | 3 | 0 | 0 |
25946 | 25946 | 2020-06-12 | Madera | 39 | 198 | 3 | 10 | 0 |
26004 | 26004 | 2020-06-11 | Madera | 39 | 188 | 3 | 10 | 0 |
26062 | 26062 | 2020-06-10 | Madera | 39 | 178 | 3 | 4 | 0 |
26120 | 26120 | 2020-06-09 | Madera | 39 | 174 | 3 | 2 | 0 |
26178 | 26178 | 2020-06-08 | Madera | 39 | 172 | 3 | 9 | 0 |
26236 | 26236 | 2020-06-07 | Madera | 39 | 163 | 3 | 0 | 0 |
26294 | 26294 | 2020-06-06 | Madera | 39 | 163 | 3 | 8 | 0 |
26352 | 26352 | 2020-06-05 | Madera | 39 | 155 | 3 | 14 | 0 |
26410 | 26410 | 2020-06-04 | Madera | 39 | 141 | 3 | 12 | 0 |
26468 | 26468 | 2020-06-03 | Madera | 39 | 129 | 3 | 12 | 0 |
26526 | 26526 | 2020-06-02 | Madera | 39 | 117 | 3 | 3 | 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 );