latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
12 rows where deaths = 4 and fips = 11 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 |
---|---|---|---|---|---|---|---|---|
22510 | 22510 | 2020-08-10 | Colusa | 11 | 391 | 4 | 29 | 0 |
22568 | 22568 | 2020-08-09 | Colusa | 11 | 362 | 4 | 0 | 0 |
22626 | 22626 | 2020-08-08 | Colusa | 11 | 362 | 4 | 0 | 0 |
22684 | 22684 | 2020-08-07 | Colusa | 11 | 362 | 4 | 1 | 0 |
22742 | 22742 | 2020-08-06 | Colusa | 11 | 361 | 4 | 2 | 0 |
22800 | 22800 | 2020-08-05 | Colusa | 11 | 359 | 4 | 2 | 0 |
22858 | 22858 | 2020-08-04 | Colusa | 11 | 357 | 4 | 26 | 0 |
22916 | 22916 | 2020-08-03 | Colusa | 11 | 331 | 4 | 8 | 0 |
22974 | 22974 | 2020-08-02 | Colusa | 11 | 323 | 4 | 0 | 0 |
23032 | 23032 | 2020-08-01 | Colusa | 11 | 323 | 4 | 0 | 0 |
23090 | 23090 | 2020-07-31 | Colusa | 11 | 323 | 4 | 11 | 0 |
23148 | 23148 | 2020-07-30 | Colusa | 11 | 312 | 4 | 8 | 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 );