latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "Sonoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
12252 | 12252 | Sonoma | Sonoma | 97 | 2021-02-14 | 27249 | 287 | |
12313 | 12313 | Sonoma | Sonoma | 97 | 2021-02-13 | 27143 | 287 | |
12374 | 12374 | Sonoma | Sonoma | 97 | 2021-02-12 | 27056 | 283 | |
12435 | 12435 | Sonoma | Sonoma | 97 | 2021-02-11 | 27056 | 283 | |
12496 | 12496 | Sonoma | Sonoma | 97 | 2021-02-10 | 26971 | 283 | |
12557 | 12557 | Sonoma | Sonoma | 97 | 2021-02-09 | 26939 | 280 | |
12618 | 12618 | Sonoma | Sonoma | 97 | 2021-02-08 | 26909 | 277 | |
12679 | 12679 | Sonoma | Sonoma | 97 | 2021-02-07 | 26836 | 277 | |
12740 | 12740 | Sonoma | Sonoma | 97 | 2021-02-06 | 26674 | 275 | |
12801 | 12801 | Sonoma | Sonoma | 97 | 2021-02-05 | 26595 | 275 | |
12862 | 12862 | Sonoma | Sonoma | 97 | 2021-02-04 | 26430 | 270 | |
12923 | 12923 | Sonoma | Sonoma | 97 | 2021-02-03 | 26306 | 267 | |
12984 | 12984 | Sonoma | Sonoma | 97 | 2021-02-02 | 26250 | 267 | |
13045 | 13045 | Sonoma | Sonoma | 97 | 2021-02-01 | 26189 | 265 | |
13106 | 13106 | Sonoma | Sonoma | 97 | 2021-01-31 | 26108 | 260 | |
13167 | 13167 | Sonoma | Sonoma | 97 | 2021-01-30 | 25992 | 260 | |
13228 | 13228 | Sonoma | Sonoma | 97 | 2021-01-29 | 25825 | 260 | |
13289 | 13289 | Sonoma | Sonoma | 97 | 2021-01-28 | 25678 | 260 | |
13350 | 13350 | Sonoma | Sonoma | 97 | 2021-01-27 | 25536 | 254 | |
13411 | 13411 | Sonoma | Sonoma | 97 | 2021-01-26 | 25377 | 254 | |
13472 | 13472 | Sonoma | Sonoma | 97 | 2021-01-25 | 25141 | 251 | |
13533 | 13533 | Sonoma | Sonoma | 97 | 2021-01-24 | 24935 | 247 | |
13594 | 13594 | Sonoma | Sonoma | 97 | 2021-01-23 | 24761 | 247 | |
13655 | 13655 | Sonoma | Sonoma | 97 | 2021-01-22 | 24571 | 245 | |
13716 | 13716 | Sonoma | Sonoma | 97 | 2021-01-21 | 24469 | 245 | |
13777 | 13777 | Sonoma | Sonoma | 97 | 2021-01-20 | 24184 | 242 | |
13838 | 13838 | Sonoma | Sonoma | 97 | 2021-01-19 | 23977 | 242 | |
13899 | 13899 | Sonoma | Sonoma | 97 | 2021-01-18 | 23716 | 240 | |
13960 | 13960 | Sonoma | Sonoma | 97 | 2021-01-17 | 23261 | 234 | TRUE |
14021 | 14021 | Sonoma | Sonoma | 97 | 2021-01-16 | 23261 | 234 | |
14082 | 14082 | Sonoma | Sonoma | 97 | 2021-01-15 | 23089 | 234 | |
14143 | 14143 | Sonoma | Sonoma | 97 | 2021-01-14 | 22531 | 227 | |
14204 | 14204 | Sonoma | Sonoma | 97 | 2021-01-13 | 22043 | 219 | |
14265 | 14265 | Sonoma | Sonoma | 97 | 2021-01-12 | 21627 | 219 | |
14326 | 14326 | Sonoma | Sonoma | 97 | 2021-01-11 | 21463 | 218 | TRUE |
14387 | 14387 | Sonoma | Sonoma | 97 | 2021-01-10 | 21463 | 218 | |
14448 | 14448 | Sonoma | Sonoma | 97 | 2021-01-09 | 21264 | 218 | |
14509 | 14509 | Sonoma | Sonoma | 97 | 2021-01-08 | 21067 | 218 | |
14570 | 14570 | Sonoma | Sonoma | 97 | 2021-01-07 | 20752 | 214 | |
14631 | 14631 | Sonoma | Sonoma | 97 | 2021-01-06 | 20501 | 213 | |
14692 | 14692 | Sonoma | Sonoma | 97 | 2021-01-05 | 20147 | 204 | |
14753 | 14753 | Sonoma | Sonoma | 97 | 2021-01-04 | 20015 | 196 | |
14814 | 14814 | Sonoma | Sonoma | 97 | 2021-01-03 | 19386 | 196 | |
14875 | 14875 | Sonoma | Sonoma | 97 | 2021-01-02 | 19360 | 196 | |
14936 | 14936 | Sonoma | Sonoma | 97 | 2021-01-01 | 19360 | 196 | |
14997 | 14997 | Sonoma | Sonoma | 97 | 2020-12-31 | 19055 | 192 | |
15058 | 15058 | Sonoma | Sonoma | 97 | 2020-12-30 | 18872 | 184 | TRUE |
15119 | 15119 | Sonoma | Sonoma | 97 | 2020-12-29 | 18872 | 184 | |
15180 | 15180 | Sonoma | Sonoma | 97 | 2020-12-28 | 18649 | 182 | |
15241 | 15241 | Sonoma | Sonoma | 97 | 2020-12-27 | 18539 | 182 | |
15302 | 15302 | Sonoma | Sonoma | 97 | 2020-12-26 | 18147 | 182 | |
15363 | 15363 | Sonoma | Sonoma | 97 | 2020-12-25 | 17903 | 181 | |
15424 | 15424 | Sonoma | Sonoma | 97 | 2020-12-24 | 17723 | 181 | |
15485 | 15485 | Sonoma | Sonoma | 97 | 2020-12-23 | 17444 | 180 | |
15546 | 15546 | Sonoma | Sonoma | 97 | 2020-12-22 | 17208 | 180 | |
15607 | 15607 | Sonoma | Sonoma | 97 | 2020-12-21 | 16706 | 174 | TRUE |
15668 | 15668 | Sonoma | Sonoma | 97 | 2020-12-20 | 16706 | 174 | |
15729 | 15729 | Sonoma | Sonoma | 97 | 2020-12-19 | 16193 | 174 | |
15790 | 15790 | Sonoma | Sonoma | 97 | 2020-12-18 | 16024 | 172 | TRUE |
15851 | 15851 | Sonoma | Sonoma | 97 | 2020-12-17 | 16024 | 172 | |
15912 | 15912 | Sonoma | Sonoma | 97 | 2020-12-16 | 15702 | 166 | |
15973 | 15973 | Sonoma | Sonoma | 97 | 2020-12-15 | 15096 | 166 | |
16034 | 16034 | Sonoma | Sonoma | 97 | 2020-12-14 | 14859 | 164 | |
16095 | 16095 | Sonoma | Sonoma | 97 | 2020-12-13 | 14705 | 162 | |
16156 | 16156 | Sonoma | Sonoma | 97 | 2020-12-12 | 14475 | 162 | |
16217 | 16217 | Sonoma | Sonoma | 97 | 2020-12-11 | 14282 | 162 | |
16278 | 16278 | Sonoma | Sonoma | 97 | 2020-12-10 | 14168 | 162 | |
16339 | 16339 | Sonoma | Sonoma | 97 | 2020-12-09 | 13912 | 162 | |
16400 | 16400 | Sonoma | Sonoma | 97 | 2020-12-08 | 13719 | 160 | |
16461 | 16461 | Sonoma | Sonoma | 97 | 2020-12-07 | 13439 | 160 | |
16522 | 16522 | Sonoma | Sonoma | 97 | 2020-12-06 | 13369 | 160 | |
16583 | 16583 | Sonoma | Sonoma | 97 | 2020-12-05 | 13281 | 160 | |
16644 | 16644 | Sonoma | Sonoma | 97 | 2020-12-04 | 13098 | 160 | |
16705 | 16705 | Sonoma | Sonoma | 97 | 2020-12-03 | 12923 | 160 | |
16766 | 16766 | Sonoma | Sonoma | 97 | 2020-12-02 | 12795 | 160 | |
16827 | 16827 | Sonoma | Sonoma | 97 | 2020-12-01 | 12662 | 160 | |
16888 | 16888 | Sonoma | Sonoma | 97 | 2020-11-30 | 12319 | 157 | |
16949 | 16949 | Sonoma | Sonoma | 97 | 2020-11-29 | 12198 | 157 | |
17010 | 17010 | Sonoma | Sonoma | 97 | 2020-11-28 | 12049 | 157 | TRUE |
17071 | 17071 | Sonoma | Sonoma | 97 | 2020-11-27 | 12049 | 157 | TRUE |
17132 | 17132 | Sonoma | Sonoma | 97 | 2020-11-26 | 11846 | 157 | TRUE |
17193 | 17193 | Sonoma | Sonoma | 97 | 2020-11-25 | 11846 | 157 | |
17254 | 17254 | Sonoma | Sonoma | 97 | 2020-11-24 | 11608 | 155 | TRUE |
17315 | 17315 | Sonoma | Sonoma | 97 | 2020-11-23 | 11608 | 155 | |
17376 | 17376 | Sonoma | Sonoma | 97 | 2020-11-22 | 11486 | 155 | |
17437 | 17437 | Sonoma | Sonoma | 97 | 2020-11-21 | 11428 | 155 | |
17498 | 17498 | Sonoma | Sonoma | 97 | 2020-11-20 | 11363 | 155 | |
17559 | 17559 | Sonoma | Sonoma | 97 | 2020-11-19 | 11316 | 150 | |
17620 | 17620 | Sonoma | Sonoma | 97 | 2020-11-18 | 11169 | 150 | |
17681 | 17681 | Sonoma | Sonoma | 97 | 2020-11-17 | 11133 | 150 | |
17742 | 17742 | Sonoma | Sonoma | 97 | 2020-11-16 | 11055 | 150 | |
17803 | 17803 | Sonoma | Sonoma | 97 | 2020-11-15 | 10970 | 149 | |
17864 | 17864 | Sonoma | Sonoma | 97 | 2020-11-14 | 10845 | 149 | |
17925 | 17925 | Sonoma | Sonoma | 97 | 2020-11-13 | 10747 | 149 | |
17986 | 17986 | Sonoma | Sonoma | 97 | 2020-11-12 | 10679 | 149 | |
18047 | 18047 | Sonoma | Sonoma | 97 | 2020-11-11 | 10606 | 149 | |
18108 | 18108 | Sonoma | Sonoma | 97 | 2020-11-10 | 10505 | 149 | |
18169 | 18169 | Sonoma | Sonoma | 97 | 2020-11-09 | 10424 | 146 | |
18230 | 18230 | Sonoma | Sonoma | 97 | 2020-11-08 | 10248 | 146 | TRUE |
18291 | 18291 | Sonoma | Sonoma | 97 | 2020-11-07 | 10248 | 146 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );