latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
11 rows where county = "Santa Barbara" and deaths = 12 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 |
---|---|---|---|---|---|---|---|---|
26606 | 26606 | 2020-06-01 | Santa Barbara | 83 | 1669 | 12 | 20 | 0 |
26664 | 26664 | 2020-05-31 | Santa Barbara | 83 | 1649 | 12 | 0 | 0 |
26722 | 26722 | 2020-05-30 | Santa Barbara | 83 | 1649 | 12 | 0 | 0 |
26780 | 26780 | 2020-05-29 | Santa Barbara | 83 | 1649 | 12 | 13 | 0 |
26838 | 26838 | 2020-05-28 | Santa Barbara | 83 | 1636 | 12 | 12 | 0 |
26896 | 26896 | 2020-05-27 | Santa Barbara | 83 | 1624 | 12 | 20 | 0 |
26954 | 26954 | 2020-05-26 | Santa Barbara | 83 | 1604 | 12 | 53 | 0 |
27012 | 27012 | 2020-05-25 | Santa Barbara | 83 | 1551 | 12 | 0 | 0 |
27070 | 27070 | 2020-05-24 | Santa Barbara | 83 | 1551 | 12 | 0 | 0 |
27128 | 27128 | 2020-05-23 | Santa Barbara | 83 | 1551 | 12 | 0 | 0 |
27186 | 27186 | 2020-05-22 | Santa Barbara | 83 | 1551 | 12 | 11 | 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 );