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 = "Mariposa" and deaths = 10 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 |
---|---|---|---|---|---|---|---|---|
22 | 22 | 2021-09-02 | Mariposa | 43 | 833 | 10 | 8 | 0 |
80 | 80 | 2021-09-01 | Mariposa | 43 | 825 | 10 | 9 | 0 |
138 | 138 | 2021-08-31 | Mariposa | 43 | 816 | 10 | 13 | 0 |
196 | 196 | 2021-08-30 | Mariposa | 43 | 803 | 10 | 22 | 0 |
254 | 254 | 2021-08-29 | Mariposa | 43 | 781 | 10 | 0 | 0 |
312 | 312 | 2021-08-28 | Mariposa | 43 | 781 | 10 | 0 | 0 |
370 | 370 | 2021-08-27 | Mariposa | 43 | 781 | 10 | 12 | 0 |
428 | 428 | 2021-08-26 | Mariposa | 43 | 769 | 10 | 15 | 0 |
486 | 486 | 2021-08-25 | Mariposa | 43 | 754 | 10 | 5 | 0 |
544 | 544 | 2021-08-24 | Mariposa | 43 | 749 | 10 | 9 | 0 |
602 | 602 | 2021-08-23 | Mariposa | 43 | 740 | 10 | 40 | 0 |
660 | 660 | 2021-08-22 | Mariposa | 43 | 700 | 10 | 0 | 0 |
718 | 718 | 2021-08-21 | Mariposa | 43 | 700 | 10 | 0 | 0 |
776 | 776 | 2021-08-20 | Mariposa | 43 | 700 | 10 | 6 | 2 |
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 );