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 new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
223 | 223 | 2021-08-30 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
281 | 281 | 2021-08-29 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
397 | 397 | 2021-08-27 | Sonoma | 97 | 36158 | 349 | 0 | 0 |
571 | 571 | 2021-08-24 | Sonoma | 97 | 35664 | 344 | 0 | 0 |
803 | 803 | 2021-08-20 | Sonoma | 97 | 35210 | 344 | 0 | 0 |
1093 | 1093 | 2021-08-15 | Sonoma | 97 | 34686 | 338 | 0 | 0 |
1209 | 1209 | 2021-08-13 | Sonoma | 97 | 34394 | 337 | 0 | 0 |
1383 | 1383 | 2021-08-10 | Sonoma | 97 | 34023 | 337 | 0 | 0 |
1615 | 1615 | 2021-08-06 | Sonoma | 97 | 33564 | 334 | 0 | 0 |
1847 | 1847 | 2021-08-02 | Sonoma | 97 | 32880 | 330 | 0 | 0 |
2021 | 2021 | 2021-07-30 | Sonoma | 97 | 32665 | 330 | 0 | 0 |
2195 | 2195 | 2021-07-27 | Sonoma | 97 | 32325 | 329 | 0 | 0 |
2659 | 2659 | 2021-07-19 | Sonoma | 97 | 31763 | 327 | 0 | 0 |
2775 | 2775 | 2021-07-17 | Sonoma | 97 | 31703 | 327 | 0 | 0 |
3007 | 3007 | 2021-07-13 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3065 | 3065 | 2021-07-12 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3355 | 3355 | 2021-07-07 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3413 | 3413 | 2021-07-06 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3529 | 3529 | 2021-07-04 | Sonoma | 97 | 31116 | 318 | 0 | 0 |
3703 | 3703 | 2021-07-01 | Sonoma | 97 | 31026 | 318 | 0 | 0 |
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 |
4283 | 4283 | 2021-06-21 | Sonoma | 97 | 30868 | 317 | 0 | 0 |
4457 | 4457 | 2021-06-18 | Sonoma | 97 | 30825 | 316 | 0 | 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 |
4921 | 4921 | 2021-06-10 | Sonoma | 97 | 30586 | 316 | 0 | 0 |
5095 | 5095 | 2021-06-07 | Sonoma | 97 | 30493 | 315 | 0 | 0 |
5211 | 5211 | 2021-06-05 | Sonoma | 97 | 30454 | 315 | 0 | 0 |
5443 | 5443 | 2021-06-01 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5501 | 5501 | 2021-05-31 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5733 | 5733 | 2021-05-27 | Sonoma | 97 | 30257 | 315 | 0 | 0 |
5849 | 5849 | 2021-05-25 | Sonoma | 97 | 30170 | 315 | 0 | 0 |
6255 | 6255 | 2021-05-18 | Sonoma | 97 | 30071 | 314 | 0 | 0 |
6429 | 6429 | 2021-05-15 | Sonoma | 97 | 30053 | 314 | 0 | 0 |
6661 | 6661 | 2021-05-11 | Sonoma | 97 | 30002 | 312 | 0 | 0 |
6893 | 6893 | 2021-05-07 | Sonoma | 97 | 29951 | 312 | 0 | 0 |
7241 | 7241 | 2021-05-01 | Sonoma | 97 | 29856 | 312 | 0 | 0 |
7705 | 7705 | 2021-04-23 | Sonoma | 97 | 29747 | 312 | 0 | 0 |
7937 | 7937 | 2021-04-19 | Sonoma | 97 | 29696 | 311 | 0 | 0 |
8053 | 8053 | 2021-04-17 | Sonoma | 97 | 29632 | 311 | 0 | 0 |
8111 | 8111 | 2021-04-16 | Sonoma | 97 | 29632 | 311 | 0 | 0 |
8227 | 8227 | 2021-04-14 | Sonoma | 97 | 29573 | 311 | 0 | 0 |
8459 | 8459 | 2021-04-10 | Sonoma | 97 | 29448 | 309 | 0 | 0 |
9039 | 9039 | 2021-03-31 | Sonoma | 97 | 29235 | 308 | 0 | 0 |
9445 | 9445 | 2021-03-24 | Sonoma | 97 | 29045 | 308 | 0 | 0 |
9735 | 9735 | 2021-03-19 | Sonoma | 97 | 28882 | 308 | 0 | 0 |
9851 | 9851 | 2021-03-17 | Sonoma | 97 | 28820 | 308 | 0 | 0 |
9967 | 9967 | 2021-03-15 | Sonoma | 97 | 28753 | 308 | 0 | 0 |
10257 | 10257 | 2021-03-10 | Sonoma | 97 | 28538 | 306 | 0 | 0 |
10373 | 10373 | 2021-03-08 | Sonoma | 97 | 28448 | 303 | 0 | 0 |
10721 | 10721 | 2021-03-02 | Sonoma | 97 | 28134 | 298 | 0 | 0 |
10953 | 10953 | 2021-02-26 | Sonoma | 97 | 27925 | 298 | 0 | 0 |
11069 | 11069 | 2021-02-24 | Sonoma | 97 | 27803 | 295 | 0 | 0 |
11475 | 11475 | 2021-02-17 | Sonoma | 97 | 27361 | 291 | 0 | 0 |
11533 | 11533 | 2021-02-16 | Sonoma | 97 | 27361 | 291 | 0 | 4 |
11765 | 11765 | 2021-02-12 | Sonoma | 97 | 27056 | 283 | 0 | 0 |
13273 | 13273 | 2021-01-17 | Sonoma | 97 | 23261 | 234 | 0 | 0 |
13621 | 13621 | 2021-01-11 | Sonoma | 97 | 21463 | 218 | 0 | 0 |
14143 | 14143 | 2021-01-02 | Sonoma | 97 | 19360 | 196 | 0 | 0 |
14317 | 14317 | 2020-12-30 | Sonoma | 97 | 18872 | 184 | 0 | 0 |
14839 | 14839 | 2020-12-21 | Sonoma | 97 | 16706 | 174 | 0 | 0 |
15013 | 15013 | 2020-12-18 | Sonoma | 97 | 16024 | 172 | 0 | 0 |
16173 | 16173 | 2020-11-28 | Sonoma | 97 | 12049 | 157 | 0 | 0 |
16289 | 16289 | 2020-11-26 | Sonoma | 97 | 11846 | 157 | 0 | 0 |
16405 | 16405 | 2020-11-24 | Sonoma | 97 | 11608 | 155 | 0 | 0 |
17333 | 17333 | 2020-11-08 | Sonoma | 97 | 10248 | 146 | 0 | 0 |
17739 | 17739 | 2020-11-01 | Sonoma | 97 | 9686 | 136 | 0 | 0 |
18551 | 18551 | 2020-10-18 | Sonoma | 97 | 8810 | 129 | 0 | 0 |
19711 | 19711 | 2020-09-28 | Sonoma | 97 | 7412 | 122 | 0 | 0 |
20929 | 20929 | 2020-09-07 | Sonoma | 97 | 6360 | 93 | 0 | 0 |
21103 | 21103 | 2020-09-04 | Sonoma | 97 | 6142 | 93 | 0 | 0 |
21451 | 21451 | 2020-08-29 | Sonoma | 97 | 5588 | 78 | 0 | 0 |
22437 | 22437 | 2020-08-12 | Sonoma | 97 | 3825 | 51 | 0 | 0 |
22785 | 22785 | 2020-08-06 | Sonoma | 97 | 3208 | 42 | 0 | 0 |
22843 | 22843 | 2020-08-05 | Sonoma | 97 | 3208 | 42 | 0 | 0 |
22959 | 22959 | 2020-08-03 | Sonoma | 97 | 3113 | 39 | 0 | 0 |
23655 | 23655 | 2020-07-22 | Sonoma | 97 | 2241 | 22 | 0 | 0 |
24061 | 24061 | 2020-07-15 | Sonoma | 97 | 1941 | 16 | 0 | 0 |
24583 | 24583 | 2020-07-06 | Sonoma | 97 | 1359 | 11 | 0 | 0 |
24641 | 24641 | 2020-07-05 | Sonoma | 97 | 1359 | 11 | 0 | 0 |
24757 | 24757 | 2020-07-03 | Sonoma | 97 | 1267 | 10 | 0 | 0 |
24873 | 24873 | 2020-07-01 | Sonoma | 97 | 1185 | 7 | 0 | 0 |
25279 | 25279 | 2020-06-24 | Sonoma | 97 | 956 | 5 | 0 | 0 |
25511 | 25511 | 2020-06-20 | Sonoma | 97 | 835 | 4 | 0 | 0 |
25743 | 25743 | 2020-06-16 | Sonoma | 97 | 765 | 4 | 0 | 0 |
26091 | 26091 | 2020-06-10 | Sonoma | 97 | 671 | 4 | 0 | 0 |
26323 | 26323 | 2020-06-06 | Sonoma | 97 | 624 | 4 | 0 | 0 |
26729 | 26729 | 2020-05-30 | Sonoma | 97 | 548 | 4 | 0 | 0 |
27483 | 27483 | 2020-05-17 | Sonoma | 97 | 373 | 4 | 0 | 0 |
27889 | 27889 | 2020-05-10 | Sonoma | 97 | 309 | 3 | 0 | 0 |
28179 | 28179 | 2020-05-05 | Sonoma | 97 | 261 | 3 | 0 | 0 |
29112 | 29112 | 2020-04-18 | Sonoma | 97 | 180 | 2 | 0 | 0 |
29483 | 29483 | 2020-04-11 | Sonoma | 97 | 145 | 2 | 0 | 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 );