latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
6 rows where county = "Madera" and deaths = 4 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 |
---|---|---|---|---|---|---|---|---|
25424 | 25424 | 2020-06-21 | Madera | 39 | 314 | 4 | 0 | 0 |
25482 | 25482 | 2020-06-20 | Madera | 39 | 314 | 4 | 0 | 0 |
25540 | 25540 | 2020-06-19 | Madera | 39 | 314 | 4 | 19 | 0 |
25598 | 25598 | 2020-06-18 | Madera | 39 | 295 | 4 | 20 | 0 |
25656 | 25656 | 2020-06-17 | Madera | 39 | 275 | 4 | 25 | 0 |
25714 | 25714 | 2020-06-16 | Madera | 39 | 250 | 4 | 24 | 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 );