latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
27 rows where fips = 77 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 77 · 27 ✖
county 1
- San Joaquin 27
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
4505 | 4505 | 2021-06-17 | San Joaquin | 77 | 74629 | 1438 | 33 | 3 |
4621 | 4621 | 2021-06-15 | San Joaquin | 77 | 74559 | 1435 | 140 | 3 |
4853 | 4853 | 2021-06-11 | San Joaquin | 77 | 74401 | 1432 | 51 | 3 |
5027 | 5027 | 2021-06-08 | San Joaquin | 77 | 74257 | 1426 | 96 | 3 |
6477 | 6477 | 2021-05-14 | San Joaquin | 77 | 73310 | 1394 | 43 | 3 |
8507 | 8507 | 2021-04-09 | San Joaquin | 77 | 70746 | 1328 | 137 | 3 |
8739 | 8739 | 2021-04-05 | San Joaquin | 77 | 70245 | 1313 | 128 | 3 |
9783 | 9783 | 2021-03-18 | San Joaquin | 77 | 68551 | 1216 | 250 | 3 |
11117 | 11117 | 2021-02-23 | San Joaquin | 77 | 66290 | 1042 | 244 | 3 |
11407 | 11407 | 2021-02-18 | San Joaquin | 77 | 65705 | 1021 | 46 | 3 |
12277 | 12277 | 2021-02-03 | San Joaquin | 77 | 62890 | 874 | 153 | 3 |
12567 | 12567 | 2021-01-29 | San Joaquin | 77 | 61901 | 853 | 353 | 3 |
14365 | 14365 | 2020-12-29 | San Joaquin | 77 | 44660 | 628 | 730 | 3 |
15873 | 15873 | 2020-12-03 | San Joaquin | 77 | 27083 | 522 | 299 | 3 |
17207 | 17207 | 2020-11-10 | San Joaquin | 77 | 22993 | 500 | 253 | 3 |
17265 | 17265 | 2020-11-09 | San Joaquin | 77 | 22740 | 497 | 105 | 3 |
19933 | 19933 | 2020-09-24 | San Joaquin | 77 | 20126 | 437 | 66 | 3 |
20455 | 20455 | 2020-09-15 | San Joaquin | 77 | 19564 | 392 | 200 | 3 |
21731 | 21731 | 2020-08-24 | San Joaquin | 77 | 16131 | 297 | 509 | 3 |
23529 | 23529 | 2020-07-24 | San Joaquin | 77 | 10126 | 110 | 300 | 3 |
23645 | 23645 | 2020-07-22 | San Joaquin | 77 | 9595 | 98 | 796 | 3 |
24109 | 24109 | 2020-07-14 | San Joaquin | 77 | 7216 | 73 | 228 | 3 |
24457 | 24457 | 2020-07-08 | San Joaquin | 77 | 5817 | 61 | 217 | 3 |
24515 | 24515 | 2020-07-07 | San Joaquin | 77 | 5600 | 58 | 149 | 3 |
25153 | 25153 | 2020-06-26 | San Joaquin | 77 | 3140 | 52 | 186 | 3 |
25385 | 25385 | 2020-06-22 | San Joaquin | 77 | 2458 | 48 | 115 | 3 |
25733 | 25733 | 2020-06-16 | San Joaquin | 77 | 1781 | 45 | 64 | 3 |
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 );