latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
10 rows where deaths = 6 and fips = 23 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 |
---|---|---|---|---|---|---|---|---|
19964 | 19964 | 2020-09-23 | Humboldt | 23 | 490 | 6 | 1 | 0 |
20022 | 20022 | 2020-09-22 | Humboldt | 23 | 489 | 6 | 4 | 0 |
20080 | 20080 | 2020-09-21 | Humboldt | 23 | 485 | 6 | 3 | 0 |
20138 | 20138 | 2020-09-20 | Humboldt | 23 | 482 | 6 | 0 | 0 |
20196 | 20196 | 2020-09-19 | Humboldt | 23 | 482 | 6 | 0 | 0 |
20254 | 20254 | 2020-09-18 | Humboldt | 23 | 482 | 6 | 0 | 0 |
20312 | 20312 | 2020-09-17 | Humboldt | 23 | 482 | 6 | 1 | 0 |
20370 | 20370 | 2020-09-16 | Humboldt | 23 | 481 | 6 | 2 | 0 |
20428 | 20428 | 2020-09-15 | Humboldt | 23 | 479 | 6 | 6 | 0 |
20486 | 20486 | 2020-09-14 | Humboldt | 23 | 473 | 6 | 26 | 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 );