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 = "Santa Cruz" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
22722 | 22722 | 2020-08-07 | Santa Cruz | 87 | 1229 | 4 | 16 | 0 |
22780 | 22780 | 2020-08-06 | Santa Cruz | 87 | 1213 | 4 | 17 | 0 |
22838 | 22838 | 2020-08-05 | Santa Cruz | 87 | 1196 | 4 | 0 | 0 |
22896 | 22896 | 2020-08-04 | Santa Cruz | 87 | 1196 | 4 | 44 | 0 |
22954 | 22954 | 2020-08-03 | Santa Cruz | 87 | 1152 | 4 | 0 | 0 |
23012 | 23012 | 2020-08-02 | Santa Cruz | 87 | 1152 | 4 | 0 | 0 |
23070 | 23070 | 2020-08-01 | Santa Cruz | 87 | 1152 | 4 | 43 | 0 |
23128 | 23128 | 2020-07-31 | Santa Cruz | 87 | 1109 | 4 | 33 | 0 |
23186 | 23186 | 2020-07-30 | Santa Cruz | 87 | 1076 | 4 | 46 | 0 |
23244 | 23244 | 2020-07-29 | Santa Cruz | 87 | 1030 | 4 | 50 | 0 |
23302 | 23302 | 2020-07-28 | Santa Cruz | 87 | 980 | 4 | 60 | 0 |
23360 | 23360 | 2020-07-27 | Santa Cruz | 87 | 920 | 4 | 13 | 0 |
23418 | 23418 | 2020-07-26 | Santa Cruz | 87 | 907 | 4 | 9 | 0 |
23476 | 23476 | 2020-07-25 | Santa Cruz | 87 | 898 | 4 | 7 | 0 |
23534 | 23534 | 2020-07-24 | Santa Cruz | 87 | 891 | 4 | 13 | 0 |
23592 | 23592 | 2020-07-23 | Santa Cruz | 87 | 878 | 4 | 30 | 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 );