latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
16 rows where county = "Alameda" and new_deaths = 5 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1335 | 1335 | 2021-08-10 | Alameda | 1 | 100187 | 1296 | 506 | 5 |
11659 | 11659 | 2021-02-13 | Alameda | 1 | 78357 | 1204 | 272 | 5 |
11717 | 11717 | 2021-02-12 | Alameda | 1 | 78085 | 1199 | 362 | 5 |
12471 | 12471 | 2021-01-30 | Alameda | 1 | 73730 | 1157 | 409 | 5 |
15139 | 15139 | 2020-12-15 | Alameda | 1 | 40216 | 665 | 703 | 5 |
15719 | 15719 | 2020-12-05 | Alameda | 1 | 33108 | 573 | 680 | 5 |
16473 | 16473 | 2020-11-22 | Alameda | 1 | 27860 | 496 | 256 | 5 |
21461 | 21461 | 2020-08-28 | Alameda | 1 | 17901 | 380 | 185 | 5 |
21867 | 21867 | 2020-08-21 | Alameda | 1 | 16557 | 345 | 269 | 5 |
22157 | 22157 | 2020-08-16 | Alameda | 1 | 15472 | 314 | 171 | 5 |
22853 | 22853 | 2020-08-04 | Alameda | 1 | 12028 | 249 | 97 | 5 |
23665 | 23665 | 2020-07-21 | Alameda | 1 | 9811 | 227 | 264 | 5 |
23955 | 23955 | 2020-07-16 | Alameda | 1 | 8769 | 213 | 90 | 5 |
25753 | 25753 | 2020-06-15 | Alameda | 1 | 4414 | 155 | 85 | 5 |
29386 | 29386 | 2020-04-12 | Alameda | 1 | 887 | 68 | 47 | 5 |
30301 | 30301 | 2020-03-25 | Alameda | 1 | 186 | 15 | 22 | 5 |
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 );