latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
12 rows where fips = 77 and new_deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 77 · 12 ✖
county 1
- San Joaquin 12
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
619 | 619 | 2021-08-23 | San Joaquin | 77 | 83121 | 1498 | 1074 | 7 |
6941 | 6941 | 2021-05-06 | San Joaquin | 77 | 72942 | 1391 | 158 | 7 |
10363 | 10363 | 2021-03-08 | San Joaquin | 77 | 67395 | 1189 | 111 | 7 |
14423 | 14423 | 2020-12-28 | San Joaquin | 77 | 43930 | 625 | 2826 | 7 |
15061 | 15061 | 2020-12-17 | San Joaquin | 77 | 34641 | 556 | 1305 | 7 |
16047 | 16047 | 2020-11-30 | San Joaquin | 77 | 25920 | 509 | 245 | 7 |
19643 | 19643 | 2020-09-29 | San Joaquin | 77 | 20357 | 447 | 112 | 7 |
20281 | 20281 | 2020-09-18 | San Joaquin | 77 | 19793 | 414 | 92 | 7 |
20397 | 20397 | 2020-09-16 | San Joaquin | 77 | 19623 | 399 | 59 | 7 |
21093 | 21093 | 2020-09-04 | San Joaquin | 77 | 18099 | 368 | 99 | 7 |
22021 | 22021 | 2020-08-19 | San Joaquin | 77 | 15379 | 287 | 178 | 7 |
22833 | 22833 | 2020-08-05 | San Joaquin | 77 | 12034 | 187 | 76 | 7 |
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 );