latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "Sonoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, new_confirmed_cases, new_deaths
date (date) 559 ✖
- 2020-01-26 1
- 2020-01-31 1
- 2020-02-02 1
- 2020-02-20 1
- 2020-02-21 1
- 2020-02-26 1
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- 2020-05-12 1
- 2020-05-13 1
- 2020-05-14 1
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- 2020-06-27 1
- 2020-06-28 1
- 2020-06-29 1
- 2020-06-30 1
- 2020-07-01 1
- 2020-07-02 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- 2020-07-06 1
- 2020-07-07 1
- 2020-07-08 1
- 2020-07-09 1
- 2020-07-10 1
- 2020-07-11 1
- 2020-07-12 1
- 2020-07-13 1
- 2020-07-14 1
- 2020-07-15 1
- 2020-07-16 1
- 2020-07-17 1
- 2020-07-18 1
- 2020-07-19 1
- 2020-07-20 1
- 2020-07-21 1
- 2020-07-22 1
- 2020-07-23 1
- 2020-07-24 1
- 2020-07-25 1
- 2020-07-26 1
- 2020-07-27 1
- 2020-07-28 1
- 2020-07-29 1
- 2020-07-30 1
- 2020-07-31 1
- 2020-08-01 1
- 2020-08-02 1
- 2020-08-03 1
- 2020-08-04 1
- 2020-08-05 1
- 2020-08-06 1
- 2020-08-07 1
- 2020-08-08 1
- 2020-08-09 1
- 2020-08-10 1
- 2020-08-11 1
- 2020-08-12 1
- 2020-08-13 1
- 2020-08-14 1
- 2020-08-15 1
- 2020-08-16 1
- 2020-08-17 1
- 2020-08-18 1
- 2020-08-19 1
- 2020-08-20 1
- 2020-08-21 1
- 2020-08-22 1
- 2020-08-23 1
- 2020-08-24 1
- 2020-08-25 1
- 2020-08-26 1
- 2020-08-27 1
- 2020-08-28 1
- 2020-08-29 1
- 2020-08-30 1
- 2020-08-31 1
- 2020-09-01 1
- 2020-09-02 1
- 2020-09-03 1
- 2020-09-04 1
- 2020-09-05 1
- 2020-09-06 1
- 2020-09-07 1
- 2020-09-08 1
- 2020-09-09 1
- 2020-09-10 1
- 2020-09-11 1
- 2020-09-12 1
- 2020-09-13 1
- 2020-09-14 1
- 2020-09-15 1
- 2020-09-16 1
- 2020-09-17 1
- 2020-09-18 1
- 2020-09-19 1
- 2020-09-20 1
- 2020-09-21 1
- 2020-09-22 1
- 2020-09-23 1
- 2020-09-24 1
- 2020-09-25 1
- 2020-09-26 1
- 2020-09-27 1
- 2020-09-28 1
- 2020-09-29 1
- 2020-09-30 1
- 2020-10-01 1
- 2020-10-02 1
- 2020-10-03 1
- 2020-10-04 1
- 2020-10-05 1
- 2020-10-06 1
- 2020-10-07 1
- 2020-10-08 1
- 2020-10-09 1
- 2020-10-10 1
- 2020-10-11 1
- 2020-10-12 1
- 2020-10-13 1
- 2020-10-14 1
- 2020-10-15 1
- 2020-10-16 1
- 2020-10-17 1
- 2020-10-18 1
- 2020-10-19 1
- 2020-10-20 1
- 2020-10-21 1
- 2020-10-22 1
- 2020-10-23 1
- 2020-10-24 1
- 2020-10-25 1
- 2020-10-26 1
- 2020-10-27 1
- 2020-10-28 1
- 2020-10-29 1
- 2020-10-30 1
- 2020-10-31 1
- 2020-11-01 1
- 2020-11-02 1
- 2020-11-03 1
- 2020-11-04 1
- 2020-11-05 1
- 2020-11-06 1
- 2020-11-07 1
- 2020-11-08 1
- 2020-11-09 1
- 2020-11-10 1
- 2020-11-11 1
- 2020-11-12 1
- 2020-11-13 1
- 2020-11-14 1
- 2020-11-15 1
- 2020-11-16 1
- 2020-11-17 1
- 2020-11-18 1
- 2020-11-19 1
- 2020-11-20 1
- 2020-11-21 1
- 2020-11-22 1
- 2020-11-23 1
- 2020-11-24 1
- 2020-11-25 1
- 2020-11-26 1
- 2020-11-27 1
- 2020-11-28 1
- 2020-11-29 1
- 2020-11-30 1
- 2020-12-01 1
- 2020-12-02 1
- 2020-12-03 1
- 2020-12-04 1
- 2020-12-05 1
- 2020-12-06 1
- 2020-12-07 1
- 2020-12-08 1
- 2020-12-09 1
- 2020-12-10 1
- 2020-12-11 1
- 2020-12-12 1
- 2020-12-13 1
- 2020-12-14 1
- 2020-12-15 1
- 2020-12-16 1
- 2020-12-17 1
- 2020-12-18 1
- 2020-12-19 1
- 2020-12-20 1
- 2020-12-21 1
- 2020-12-22 1
- 2020-12-23 1
- 2020-12-24 1
- 2020-12-25 1
- 2020-12-26 1
- 2020-12-27 1
- 2020-12-28 1
- 2020-12-29 1
- 2020-12-30 1
- 2020-12-31 1
- 2021-01-01 1
- 2021-01-02 1
- 2021-01-03 1
- 2021-01-04 1
- 2021-01-05 1
- 2021-01-06 1
- 2021-01-07 1
- 2021-01-08 1
- 2021-01-09 1
- 2021-01-10 1
- 2021-01-11 1
- 2021-01-12 1
- 2021-01-13 1
- 2021-01-14 1
- 2021-01-15 1
- 2021-01-16 1
- 2021-01-17 1
- 2021-01-18 1
- 2021-01-19 1
- 2021-01-20 1
- 2021-01-21 1
- 2021-01-22 1
- 2021-01-23 1
- 2021-01-24 1
- 2021-01-25 1
- 2021-01-26 1
- 2021-01-27 1
- 2021-01-28 1
- 2021-01-29 1
- 2021-01-30 1
- 2021-01-31 1
- 2021-02-01 1
- 2021-02-02 1
- 2021-02-03 1
- 2021-02-04 1
- 2021-02-05 1
- 2021-02-06 1
- 2021-02-07 1
- 2021-02-08 1
- 2021-02-09 1
- 2021-02-10 1
- 2021-02-11 1
- 2021-02-12 1
- 2021-02-13 1
- 2021-02-14 1
- 2021-02-15 1
- 2021-02-16 1
- 2021-02-17 1
- 2021-02-18 1
- 2021-02-19 1
- 2021-02-20 1
- 2021-02-21 1
- 2021-02-22 1
- 2021-02-23 1
- 2021-02-24 1
- 2021-02-25 1
- 2021-02-26 1
- 2021-02-27 1
- 2021-02-28 1
- 2021-03-01 1
- 2021-03-02 1
- 2021-03-03 1
- 2021-03-04 1
- 2021-03-05 1
- 2021-03-06 1
- 2021-03-07 1
- 2021-03-08 1
- 2021-03-09 1
- 2021-03-10 1
- 2021-03-11 1
- 2021-03-12 1
- 2021-03-13 1
- 2021-03-14 1
- 2021-03-15 1
- 2021-03-16 1
- 2021-03-17 1
- 2021-03-18 1
- 2021-03-19 1
- 2021-03-20 1
- 2021-03-21 1
- 2021-03-22 1
- 2021-03-23 1
- 2021-03-24 1
- 2021-03-25 1
- 2021-03-26 1
- 2021-03-27 1
- 2021-03-28 1
- 2021-03-29 1
- 2021-03-30 1
- 2021-03-31 1
- 2021-04-01 1
- 2021-04-02 1
- 2021-04-03 1
- 2021-04-04 1
- 2021-04-05 1
- 2021-04-06 1
- 2021-04-07 1
- 2021-04-08 1
- 2021-04-09 1
- 2021-04-10 1
- 2021-04-11 1
- 2021-04-12 1
- 2021-04-13 1
- 2021-04-14 1
- 2021-04-15 1
- 2021-04-16 1
- 2021-04-17 1
- 2021-04-18 1
- 2021-04-19 1
- 2021-04-20 1
- 2021-04-21 1
- 2021-04-22 1
- 2021-04-23 1
- 2021-04-24 1
- 2021-04-25 1
- 2021-04-26 1
- 2021-04-27 1
- 2021-04-28 1
- 2021-04-29 1
- 2021-04-30 1
- 2021-05-01 1
- 2021-05-02 1
- 2021-05-03 1
- 2021-05-04 1
- 2021-05-05 1
- 2021-05-06 1
- 2021-05-07 1
- 2021-05-08 1
- 2021-05-09 1
- 2021-05-10 1
- 2021-05-11 1
- 2021-05-12 1
- 2021-05-13 1
- 2021-05-14 1
- 2021-05-15 1
- 2021-05-16 1
- 2021-05-17 1
- 2021-05-18 1
- 2021-05-19 1
- 2021-05-20 1
- 2021-05-21 1
- 2021-05-22 1
- 2021-05-23 1
- 2021-05-24 1
- 2021-05-25 1
- 2021-05-26 1
- 2021-05-27 1
- 2021-05-28 1
- 2021-05-29 1
- 2021-05-30 1
- 2021-05-31 1
- 2021-06-01 1
- 2021-06-02 1
- 2021-06-03 1
- 2021-06-04 1
- 2021-06-05 1
- 2021-06-06 1
- 2021-06-07 1
- 2021-06-08 1
- 2021-06-09 1
- 2021-06-10 1
- 2021-06-11 1
- 2021-06-12 1
- 2021-06-13 1
- 2021-06-14 1
- 2021-06-15 1
- 2021-06-16 1
- 2021-06-17 1
- 2021-06-18 1
- 2021-06-19 1
- 2021-06-20 1
- 2021-06-21 1
- 2021-06-22 1
- 2021-06-23 1
- 2021-06-24 1
- 2021-06-25 1
- 2021-06-26 1
- 2021-06-27 1
- 2021-06-28 1
- 2021-06-29 1
- 2021-06-30 1
- 2021-07-01 1
- 2021-07-02 1
- 2021-07-03 1
- 2021-07-04 1
- 2021-07-05 1
- 2021-07-06 1
- 2021-07-07 1
- 2021-07-08 1
- 2021-07-09 1
- 2021-07-10 1
- 2021-07-11 1
- 2021-07-12 1
- 2021-07-13 1
- 2021-07-14 1
- 2021-07-15 1
- 2021-07-16 1
- 2021-07-17 1
- 2021-07-18 1
- 2021-07-19 1
- 2021-07-20 1
- 2021-07-21 1
- 2021-07-22 1
- 2021-07-23 1
- 2021-07-24 1
- 2021-07-25 1
- 2021-07-26 1
- 2021-07-27 1
- 2021-07-28 1
- 2021-07-29 1
- 2021-07-30 1
- 2021-07-31 1
- 2021-08-01 1
- 2021-08-02 1
- 2021-08-03 1
- 2021-08-04 1
- 2021-08-05 1
- 2021-08-06 1
- 2021-08-07 1
- 2021-08-08 1
- 2021-08-09 1
- 2021-08-10 1
- 2021-08-11 1
- 2021-08-12 1
- 2021-08-13 1
- 2021-08-14 1
- 2021-08-15 1
- 2021-08-16 1
- 2021-08-17 1
- 2021-08-18 1
- 2021-08-19 1
- 2021-08-20 1
- 2021-08-21 1
- 2021-08-22 1
- 2021-08-23 1
- 2021-08-24 1
- 2021-08-25 1
- 2021-08-26 1
- 2021-08-27 1
- 2021-08-28 1
- 2021-08-29 1
- 2021-08-30 1
- 2021-08-31 1
- 2021-09-01 1
- 2021-09-02 1
fips 1
- 97 559
county 1
- Sonoma · 559 ✖
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
49 | 49 | 2021-09-02 | Sonoma | 97 | 37055 | 356 | 249 | 0 |
107 | 107 | 2021-09-01 | Sonoma | 97 | 36806 | 356 | 291 | 3 |
165 | 165 | 2021-08-31 | Sonoma | 97 | 36515 | 353 | 17 | 0 |
223 | 223 | 2021-08-30 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
281 | 281 | 2021-08-29 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
339 | 339 | 2021-08-28 | Sonoma | 97 | 36498 | 353 | 340 | 4 |
397 | 397 | 2021-08-27 | Sonoma | 97 | 36158 | 349 | 0 | 0 |
455 | 455 | 2021-08-26 | Sonoma | 97 | 36158 | 349 | 342 | 2 |
513 | 513 | 2021-08-25 | Sonoma | 97 | 35816 | 347 | 152 | 3 |
571 | 571 | 2021-08-24 | Sonoma | 97 | 35664 | 344 | 0 | 0 |
629 | 629 | 2021-08-23 | Sonoma | 97 | 35664 | 344 | 102 | 0 |
687 | 687 | 2021-08-22 | Sonoma | 97 | 35562 | 344 | 4 | 0 |
745 | 745 | 2021-08-21 | Sonoma | 97 | 35558 | 344 | 348 | 0 |
803 | 803 | 2021-08-20 | Sonoma | 97 | 35210 | 344 | 0 | 0 |
861 | 861 | 2021-08-19 | Sonoma | 97 | 35210 | 344 | 117 | 0 |
919 | 919 | 2021-08-18 | Sonoma | 97 | 35093 | 344 | 101 | 4 |
977 | 977 | 2021-08-17 | Sonoma | 97 | 34992 | 340 | 153 | 2 |
1035 | 1035 | 2021-08-16 | Sonoma | 97 | 34839 | 338 | 153 | 0 |
1093 | 1093 | 2021-08-15 | Sonoma | 97 | 34686 | 338 | 0 | 0 |
1151 | 1151 | 2021-08-14 | Sonoma | 97 | 34686 | 338 | 292 | 1 |
1209 | 1209 | 2021-08-13 | Sonoma | 97 | 34394 | 337 | 0 | 0 |
1267 | 1267 | 2021-08-12 | Sonoma | 97 | 34394 | 337 | 98 | 0 |
1325 | 1325 | 2021-08-11 | Sonoma | 97 | 34296 | 337 | 273 | 0 |
1383 | 1383 | 2021-08-10 | Sonoma | 97 | 34023 | 337 | 0 | 0 |
1441 | 1441 | 2021-08-09 | Sonoma | 97 | 34023 | 337 | 270 | 3 |
1499 | 1499 | 2021-08-08 | Sonoma | 97 | 33753 | 334 | 134 | 0 |
1557 | 1557 | 2021-08-07 | Sonoma | 97 | 33619 | 334 | 55 | 0 |
1615 | 1615 | 2021-08-06 | Sonoma | 97 | 33564 | 334 | 0 | 0 |
1673 | 1673 | 2021-08-05 | Sonoma | 97 | 33564 | 334 | 150 | 3 |
1731 | 1731 | 2021-08-04 | Sonoma | 97 | 33414 | 331 | 447 | 0 |
1789 | 1789 | 2021-08-03 | Sonoma | 97 | 32967 | 331 | 87 | 1 |
1847 | 1847 | 2021-08-02 | Sonoma | 97 | 32880 | 330 | 0 | 0 |
1905 | 1905 | 2021-08-01 | Sonoma | 97 | 32880 | 330 | 63 | 0 |
1963 | 1963 | 2021-07-31 | Sonoma | 97 | 32817 | 330 | 152 | 0 |
2021 | 2021 | 2021-07-30 | Sonoma | 97 | 32665 | 330 | 0 | 0 |
2079 | 2079 | 2021-07-29 | Sonoma | 97 | 32665 | 330 | 139 | 1 |
2137 | 2137 | 2021-07-28 | Sonoma | 97 | 32526 | 329 | 201 | 0 |
2195 | 2195 | 2021-07-27 | Sonoma | 97 | 32325 | 329 | 0 | 0 |
2253 | 2253 | 2021-07-26 | Sonoma | 97 | 32325 | 329 | 129 | 0 |
2311 | 2311 | 2021-07-25 | Sonoma | 97 | 32196 | 329 | 72 | 1 |
2369 | 2369 | 2021-07-24 | Sonoma | 97 | 32124 | 328 | 159 | 0 |
2427 | 2427 | 2021-07-23 | Sonoma | 97 | 31965 | 328 | 60 | 0 |
2485 | 2485 | 2021-07-22 | Sonoma | 97 | 31905 | 328 | 30 | 1 |
2543 | 2543 | 2021-07-21 | Sonoma | 97 | 31875 | 327 | 92 | 0 |
2601 | 2601 | 2021-07-20 | Sonoma | 97 | 31783 | 327 | 20 | 0 |
2659 | 2659 | 2021-07-19 | Sonoma | 97 | 31763 | 327 | 0 | 0 |
2717 | 2717 | 2021-07-18 | Sonoma | 97 | 31763 | 327 | 60 | 0 |
2775 | 2775 | 2021-07-17 | Sonoma | 97 | 31703 | 327 | 0 | 0 |
2833 | 2833 | 2021-07-16 | Sonoma | 97 | 31703 | 327 | 62 | 4 |
2891 | 2891 | 2021-07-15 | Sonoma | 97 | 31641 | 323 | 94 | 0 |
2949 | 2949 | 2021-07-14 | Sonoma | 97 | 31547 | 323 | 112 | 0 |
3007 | 3007 | 2021-07-13 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3065 | 3065 | 2021-07-12 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3123 | 3123 | 2021-07-11 | Sonoma | 97 | 31435 | 323 | 61 | 0 |
3181 | 3181 | 2021-07-10 | Sonoma | 97 | 31374 | 323 | 67 | 4 |
3239 | 3239 | 2021-07-09 | Sonoma | 97 | 31307 | 319 | 37 | 0 |
3297 | 3297 | 2021-07-08 | Sonoma | 97 | 31270 | 319 | 110 | 1 |
3355 | 3355 | 2021-07-07 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3413 | 3413 | 2021-07-06 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3471 | 3471 | 2021-07-05 | Sonoma | 97 | 31160 | 318 | 44 | 0 |
3529 | 3529 | 2021-07-04 | Sonoma | 97 | 31116 | 318 | 0 | 0 |
3587 | 3587 | 2021-07-03 | Sonoma | 97 | 31116 | 318 | 26 | 0 |
3645 | 3645 | 2021-07-02 | Sonoma | 97 | 31090 | 318 | 64 | 0 |
3703 | 3703 | 2021-07-01 | Sonoma | 97 | 31026 | 318 | 0 | 0 |
3761 | 3761 | 2021-06-30 | Sonoma | 97 | 31026 | 318 | 85 | 1 |
3819 | 3819 | 2021-06-29 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3877 | 3877 | 2021-06-28 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3935 | 3935 | 2021-06-27 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3993 | 3993 | 2021-06-26 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4051 | 4051 | 2021-06-25 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4109 | 4109 | 2021-06-24 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4167 | 4167 | 2021-06-23 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4225 | 4225 | 2021-06-22 | Sonoma | 97 | 30941 | 317 | 73 | 0 |
4283 | 4283 | 2021-06-21 | Sonoma | 97 | 30868 | 317 | 0 | 0 |
4341 | 4341 | 2021-06-20 | Sonoma | 97 | 30868 | 317 | 24 | 1 |
4399 | 4399 | 2021-06-19 | Sonoma | 97 | 30844 | 316 | 19 | 0 |
4457 | 4457 | 2021-06-18 | Sonoma | 97 | 30825 | 316 | 0 | 0 |
4515 | 4515 | 2021-06-17 | Sonoma | 97 | 30825 | 316 | 42 | 0 |
4573 | 4573 | 2021-06-16 | Sonoma | 97 | 30783 | 316 | 95 | 0 |
4631 | 4631 | 2021-06-15 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4689 | 4689 | 2021-06-14 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4747 | 4747 | 2021-06-13 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4805 | 4805 | 2021-06-12 | Sonoma | 97 | 30688 | 316 | 29 | 0 |
4863 | 4863 | 2021-06-11 | Sonoma | 97 | 30659 | 316 | 73 | 0 |
4921 | 4921 | 2021-06-10 | Sonoma | 97 | 30586 | 316 | 0 | 0 |
4979 | 4979 | 2021-06-09 | Sonoma | 97 | 30586 | 316 | 17 | 0 |
5037 | 5037 | 2021-06-08 | Sonoma | 97 | 30569 | 316 | 76 | 1 |
5095 | 5095 | 2021-06-07 | Sonoma | 97 | 30493 | 315 | 0 | 0 |
5153 | 5153 | 2021-06-06 | Sonoma | 97 | 30493 | 315 | 39 | 0 |
5211 | 5211 | 2021-06-05 | Sonoma | 97 | 30454 | 315 | 0 | 0 |
5269 | 5269 | 2021-06-04 | Sonoma | 97 | 30454 | 315 | 32 | 0 |
5327 | 5327 | 2021-06-03 | Sonoma | 97 | 30422 | 315 | 29 | 0 |
5385 | 5385 | 2021-06-02 | Sonoma | 97 | 30393 | 315 | 57 | 0 |
5443 | 5443 | 2021-06-01 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5501 | 5501 | 2021-05-31 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5559 | 5559 | 2021-05-30 | Sonoma | 97 | 30336 | 315 | 38 | 0 |
5617 | 5617 | 2021-05-29 | Sonoma | 97 | 30298 | 315 | 29 | 0 |
5675 | 5675 | 2021-05-28 | Sonoma | 97 | 30269 | 315 | 12 | 0 |
5733 | 5733 | 2021-05-27 | Sonoma | 97 | 30257 | 315 | 0 | 0 |
5791 | 5791 | 2021-05-26 | Sonoma | 97 | 30257 | 315 | 87 | 0 |
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 );