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)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5849 | 5849 | 2021-05-25 | Sonoma | 97 | 30170 | 315 | 0 | 0 |
5907 | 5907 | 2021-05-24 | Sonoma | 97 | 30170 | 315 | 1 | 1 |
5965 | 5965 | 2021-05-23 | Sonoma | 97 | 30169 | 314 | 1 | 0 |
6023 | 6023 | 2021-05-22 | Sonoma | 97 | 30168 | 314 | 18 | 0 |
6081 | 6081 | 2021-05-21 | Sonoma | 97 | 30150 | 314 | 20 | 0 |
6139 | 6139 | 2021-05-20 | Sonoma | 97 | 30130 | 314 | 26 | 0 |
6197 | 6197 | 2021-05-19 | Sonoma | 97 | 30104 | 314 | 33 | 0 |
6255 | 6255 | 2021-05-18 | Sonoma | 97 | 30071 | 314 | 0 | 0 |
6313 | 6313 | 2021-05-17 | Sonoma | 97 | 30071 | 314 | 4 | 0 |
6371 | 6371 | 2021-05-16 | Sonoma | 97 | 30067 | 314 | 14 | 0 |
6429 | 6429 | 2021-05-15 | Sonoma | 97 | 30053 | 314 | 0 | 0 |
6487 | 6487 | 2021-05-14 | Sonoma | 97 | 30053 | 314 | 18 | 0 |
6545 | 6545 | 2021-05-13 | Sonoma | 97 | 30035 | 314 | 9 | 0 |
6603 | 6603 | 2021-05-12 | Sonoma | 97 | 30026 | 314 | 24 | 2 |
6661 | 6661 | 2021-05-11 | Sonoma | 97 | 30002 | 312 | 0 | 0 |
6719 | 6719 | 2021-05-10 | Sonoma | 97 | 30002 | 312 | 18 | 0 |
6777 | 6777 | 2021-05-09 | Sonoma | 97 | 29984 | 312 | 9 | 0 |
6835 | 6835 | 2021-05-08 | Sonoma | 97 | 29975 | 312 | 24 | 0 |
6893 | 6893 | 2021-05-07 | Sonoma | 97 | 29951 | 312 | 0 | 0 |
6951 | 6951 | 2021-05-06 | Sonoma | 97 | 29951 | 312 | 30 | 0 |
7009 | 7009 | 2021-05-05 | Sonoma | 97 | 29921 | 312 | 11 | 0 |
7067 | 7067 | 2021-05-04 | Sonoma | 97 | 29910 | 312 | 13 | 0 |
7125 | 7125 | 2021-05-03 | Sonoma | 97 | 29897 | 312 | 11 | 0 |
7183 | 7183 | 2021-05-02 | Sonoma | 97 | 29886 | 312 | 30 | 0 |
7241 | 7241 | 2021-05-01 | Sonoma | 97 | 29856 | 312 | 0 | 0 |
7299 | 7299 | 2021-04-30 | Sonoma | 97 | 29856 | 312 | 24 | 0 |
7357 | 7357 | 2021-04-29 | Sonoma | 97 | 29832 | 312 | 14 | 0 |
7415 | 7415 | 2021-04-28 | Sonoma | 97 | 29818 | 312 | 11 | 0 |
7473 | 7473 | 2021-04-27 | Sonoma | 97 | 29807 | 312 | 13 | 0 |
7531 | 7531 | 2021-04-26 | Sonoma | 97 | 29794 | 312 | 16 | 0 |
7589 | 7589 | 2021-04-25 | Sonoma | 97 | 29778 | 312 | 16 | 0 |
7647 | 7647 | 2021-04-24 | Sonoma | 97 | 29762 | 312 | 15 | 0 |
7705 | 7705 | 2021-04-23 | Sonoma | 97 | 29747 | 312 | 0 | 0 |
7763 | 7763 | 2021-04-22 | Sonoma | 97 | 29747 | 312 | 13 | 0 |
7821 | 7821 | 2021-04-21 | Sonoma | 97 | 29734 | 312 | 14 | 1 |
7879 | 7879 | 2021-04-20 | Sonoma | 97 | 29720 | 311 | 24 | 0 |
7937 | 7937 | 2021-04-19 | Sonoma | 97 | 29696 | 311 | 0 | 0 |
7995 | 7995 | 2021-04-18 | Sonoma | 97 | 29696 | 311 | 64 | 0 |
8053 | 8053 | 2021-04-17 | Sonoma | 97 | 29632 | 311 | 0 | 0 |
8111 | 8111 | 2021-04-16 | Sonoma | 97 | 29632 | 311 | 0 | 0 |
8169 | 8169 | 2021-04-15 | Sonoma | 97 | 29632 | 311 | 59 | 0 |
8227 | 8227 | 2021-04-14 | Sonoma | 97 | 29573 | 311 | 0 | 0 |
8285 | 8285 | 2021-04-13 | Sonoma | 97 | 29573 | 311 | 37 | 2 |
8343 | 8343 | 2021-04-12 | Sonoma | 97 | 29536 | 309 | 35 | 0 |
8401 | 8401 | 2021-04-11 | Sonoma | 97 | 29501 | 309 | 53 | 0 |
8459 | 8459 | 2021-04-10 | Sonoma | 97 | 29448 | 309 | 0 | 0 |
8517 | 8517 | 2021-04-09 | Sonoma | 97 | 29448 | 309 | 17 | 0 |
8575 | 8575 | 2021-04-08 | Sonoma | 97 | 29431 | 309 | 8 | 0 |
8633 | 8633 | 2021-04-07 | Sonoma | 97 | 29423 | 309 | 21 | 0 |
8691 | 8691 | 2021-04-06 | Sonoma | 97 | 29402 | 309 | 30 | 0 |
8749 | 8749 | 2021-04-05 | Sonoma | 97 | 29372 | 309 | 23 | 0 |
8807 | 8807 | 2021-04-04 | Sonoma | 97 | 29349 | 309 | 39 | 0 |
8865 | 8865 | 2021-04-03 | Sonoma | 97 | 29310 | 309 | 53 | 0 |
8923 | 8923 | 2021-04-02 | Sonoma | 97 | 29257 | 309 | 2 | 1 |
8981 | 8981 | 2021-04-01 | Sonoma | 97 | 29255 | 308 | 20 | 0 |
9039 | 9039 | 2021-03-31 | Sonoma | 97 | 29235 | 308 | 0 | 0 |
9097 | 9097 | 2021-03-30 | Sonoma | 97 | 29235 | 308 | 16 | 0 |
9155 | 9155 | 2021-03-29 | Sonoma | 97 | 29219 | 308 | 50 | 0 |
9213 | 9213 | 2021-03-28 | Sonoma | 97 | 29169 | 308 | 47 | 0 |
9271 | 9271 | 2021-03-27 | Sonoma | 97 | 29122 | 308 | 32 | 0 |
9329 | 9329 | 2021-03-26 | Sonoma | 97 | 29090 | 308 | 31 | 0 |
9387 | 9387 | 2021-03-25 | Sonoma | 97 | 29059 | 308 | 14 | 0 |
9445 | 9445 | 2021-03-24 | Sonoma | 97 | 29045 | 308 | 0 | 0 |
9503 | 9503 | 2021-03-23 | Sonoma | 97 | 29045 | 308 | 39 | 0 |
9561 | 9561 | 2021-03-22 | Sonoma | 97 | 29006 | 308 | 25 | 0 |
9619 | 9619 | 2021-03-21 | Sonoma | 97 | 28981 | 308 | 67 | 0 |
9677 | 9677 | 2021-03-20 | Sonoma | 97 | 28914 | 308 | 32 | 0 |
9735 | 9735 | 2021-03-19 | Sonoma | 97 | 28882 | 308 | 0 | 0 |
9793 | 9793 | 2021-03-18 | Sonoma | 97 | 28882 | 308 | 62 | 0 |
9851 | 9851 | 2021-03-17 | Sonoma | 97 | 28820 | 308 | 0 | 0 |
9909 | 9909 | 2021-03-16 | Sonoma | 97 | 28820 | 308 | 67 | 0 |
9967 | 9967 | 2021-03-15 | Sonoma | 97 | 28753 | 308 | 0 | 0 |
10025 | 10025 | 2021-03-14 | Sonoma | 97 | 28753 | 308 | 87 | 2 |
10083 | 10083 | 2021-03-13 | Sonoma | 97 | 28666 | 306 | 44 | 0 |
10141 | 10141 | 2021-03-12 | Sonoma | 97 | 28622 | 306 | 57 | 0 |
10199 | 10199 | 2021-03-11 | Sonoma | 97 | 28565 | 306 | 27 | 0 |
10257 | 10257 | 2021-03-10 | Sonoma | 97 | 28538 | 306 | 0 | 0 |
10315 | 10315 | 2021-03-09 | Sonoma | 97 | 28538 | 306 | 90 | 3 |
10373 | 10373 | 2021-03-08 | Sonoma | 97 | 28448 | 303 | 0 | 0 |
10431 | 10431 | 2021-03-07 | Sonoma | 97 | 28448 | 303 | 122 | 0 |
10489 | 10489 | 2021-03-06 | Sonoma | 97 | 28326 | 303 | 45 | 2 |
10547 | 10547 | 2021-03-05 | Sonoma | 97 | 28281 | 301 | 68 | 0 |
10605 | 10605 | 2021-03-04 | Sonoma | 97 | 28213 | 301 | 28 | 0 |
10663 | 10663 | 2021-03-03 | Sonoma | 97 | 28185 | 301 | 51 | 3 |
10721 | 10721 | 2021-03-02 | Sonoma | 97 | 28134 | 298 | 0 | 0 |
10779 | 10779 | 2021-03-01 | Sonoma | 97 | 28134 | 298 | 42 | 0 |
10837 | 10837 | 2021-02-28 | Sonoma | 97 | 28092 | 298 | 39 | 0 |
10895 | 10895 | 2021-02-27 | Sonoma | 97 | 28053 | 298 | 128 | 0 |
10953 | 10953 | 2021-02-26 | Sonoma | 97 | 27925 | 298 | 0 | 0 |
11011 | 11011 | 2021-02-25 | Sonoma | 97 | 27925 | 298 | 122 | 3 |
11069 | 11069 | 2021-02-24 | Sonoma | 97 | 27803 | 295 | 0 | 0 |
11127 | 11127 | 2021-02-23 | Sonoma | 97 | 27803 | 295 | 59 | 0 |
11185 | 11185 | 2021-02-22 | Sonoma | 97 | 27744 | 295 | 68 | 0 |
11243 | 11243 | 2021-02-21 | Sonoma | 97 | 27676 | 295 | 70 | 4 |
11301 | 11301 | 2021-02-20 | Sonoma | 97 | 27606 | 291 | 133 | 0 |
11359 | 11359 | 2021-02-19 | Sonoma | 97 | 27473 | 291 | 59 | 0 |
11417 | 11417 | 2021-02-18 | Sonoma | 97 | 27414 | 291 | 53 | 0 |
11475 | 11475 | 2021-02-17 | Sonoma | 97 | 27361 | 291 | 0 | 0 |
11533 | 11533 | 2021-02-16 | Sonoma | 97 | 27361 | 291 | 0 | 4 |
11591 | 11591 | 2021-02-15 | Sonoma | 97 | 27361 | 287 | 112 | 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 );