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 |
---|---|---|---|---|---|---|---|---|
6152 | 6152 | Sonoma | Sonoma | 97 | 2021-05-25 | 30170 | 315 | |
6213 | 6213 | Sonoma | Sonoma | 97 | 2021-05-24 | 30170 | 315 | |
6274 | 6274 | Sonoma | Sonoma | 97 | 2021-05-23 | 30169 | 314 | |
6335 | 6335 | Sonoma | Sonoma | 97 | 2021-05-22 | 30168 | 314 | |
6396 | 6396 | Sonoma | Sonoma | 97 | 2021-05-21 | 30150 | 314 | |
6457 | 6457 | Sonoma | Sonoma | 97 | 2021-05-20 | 30130 | 314 | |
6518 | 6518 | Sonoma | Sonoma | 97 | 2021-05-19 | 30104 | 314 | |
6579 | 6579 | Sonoma | Sonoma | 97 | 2021-05-18 | 30071 | 314 | TRUE |
6640 | 6640 | Sonoma | Sonoma | 97 | 2021-05-17 | 30071 | 314 | |
6701 | 6701 | Sonoma | Sonoma | 97 | 2021-05-16 | 30067 | 314 | |
6762 | 6762 | Sonoma | Sonoma | 97 | 2021-05-15 | 30053 | 314 | TRUE |
6823 | 6823 | Sonoma | Sonoma | 97 | 2021-05-14 | 30053 | 314 | |
6884 | 6884 | Sonoma | Sonoma | 97 | 2021-05-13 | 30035 | 314 | |
6945 | 6945 | Sonoma | Sonoma | 97 | 2021-05-12 | 30026 | 314 | |
7006 | 7006 | Sonoma | Sonoma | 97 | 2021-05-11 | 30002 | 312 | TRUE |
7067 | 7067 | Sonoma | Sonoma | 97 | 2021-05-10 | 30002 | 312 | |
7128 | 7128 | Sonoma | Sonoma | 97 | 2021-05-09 | 29984 | 312 | |
7189 | 7189 | Sonoma | Sonoma | 97 | 2021-05-08 | 29975 | 312 | |
7250 | 7250 | Sonoma | Sonoma | 97 | 2021-05-07 | 29951 | 312 | |
7311 | 7311 | Sonoma | Sonoma | 97 | 2021-05-06 | 29951 | 312 | |
7372 | 7372 | Sonoma | Sonoma | 97 | 2021-05-05 | 29921 | 312 | |
7433 | 7433 | Sonoma | Sonoma | 97 | 2021-05-04 | 29910 | 312 | |
7494 | 7494 | Sonoma | Sonoma | 97 | 2021-05-03 | 29897 | 312 | |
7555 | 7555 | Sonoma | Sonoma | 97 | 2021-05-02 | 29886 | 312 | |
7616 | 7616 | Sonoma | Sonoma | 97 | 2021-05-01 | 29856 | 312 | TRUE |
7677 | 7677 | Sonoma | Sonoma | 97 | 2021-04-30 | 29856 | 312 | |
7738 | 7738 | Sonoma | Sonoma | 97 | 2021-04-29 | 29832 | 312 | |
7799 | 7799 | Sonoma | Sonoma | 97 | 2021-04-28 | 29818 | 312 | |
7860 | 7860 | Sonoma | Sonoma | 97 | 2021-04-27 | 29807 | 312 | |
7921 | 7921 | Sonoma | Sonoma | 97 | 2021-04-26 | 29794 | 312 | |
7982 | 7982 | Sonoma | Sonoma | 97 | 2021-04-25 | 29778 | 312 | |
8043 | 8043 | Sonoma | Sonoma | 97 | 2021-04-24 | 29762 | 312 | |
8104 | 8104 | Sonoma | Sonoma | 97 | 2021-04-23 | 29747 | 312 | TRUE |
8165 | 8165 | Sonoma | Sonoma | 97 | 2021-04-22 | 29747 | 312 | |
8226 | 8226 | Sonoma | Sonoma | 97 | 2021-04-21 | 29734 | 312 | |
8287 | 8287 | Sonoma | Sonoma | 97 | 2021-04-20 | 29720 | 311 | |
8348 | 8348 | Sonoma | Sonoma | 97 | 2021-04-19 | 29696 | 311 | |
8409 | 8409 | Sonoma | Sonoma | 97 | 2021-04-18 | 29696 | 311 | |
8470 | 8470 | Sonoma | Sonoma | 97 | 2021-04-17 | 29632 | 311 | TRUE |
8531 | 8531 | Sonoma | Sonoma | 97 | 2021-04-16 | 29632 | 311 | TRUE |
8592 | 8592 | Sonoma | Sonoma | 97 | 2021-04-15 | 29632 | 311 | |
8653 | 8653 | Sonoma | Sonoma | 97 | 2021-04-14 | 29573 | 311 | TRUE |
8714 | 8714 | Sonoma | Sonoma | 97 | 2021-04-13 | 29573 | 311 | |
8775 | 8775 | Sonoma | Sonoma | 97 | 2021-04-12 | 29536 | 309 | |
8836 | 8836 | Sonoma | Sonoma | 97 | 2021-04-11 | 29501 | 309 | |
8897 | 8897 | Sonoma | Sonoma | 97 | 2021-04-10 | 29448 | 309 | TRUE |
8958 | 8958 | Sonoma | Sonoma | 97 | 2021-04-09 | 29448 | 309 | |
9019 | 9019 | Sonoma | Sonoma | 97 | 2021-04-08 | 29431 | 309 | |
9080 | 9080 | Sonoma | Sonoma | 97 | 2021-04-07 | 29423 | 309 | |
9141 | 9141 | Sonoma | Sonoma | 97 | 2021-04-06 | 29402 | 309 | |
9202 | 9202 | Sonoma | Sonoma | 97 | 2021-04-05 | 29372 | 309 | |
9263 | 9263 | Sonoma | Sonoma | 97 | 2021-04-04 | 29349 | 309 | |
9324 | 9324 | Sonoma | Sonoma | 97 | 2021-04-03 | 29310 | 309 | |
9385 | 9385 | Sonoma | Sonoma | 97 | 2021-04-02 | 29257 | 309 | |
9446 | 9446 | Sonoma | Sonoma | 97 | 2021-04-01 | 29255 | 308 | |
9507 | 9507 | Sonoma | Sonoma | 97 | 2021-03-31 | 29235 | 308 | TRUE |
9568 | 9568 | Sonoma | Sonoma | 97 | 2021-03-30 | 29235 | 308 | |
9629 | 9629 | Sonoma | Sonoma | 97 | 2021-03-29 | 29219 | 308 | |
9690 | 9690 | Sonoma | Sonoma | 97 | 2021-03-28 | 29169 | 308 | |
9751 | 9751 | Sonoma | Sonoma | 97 | 2021-03-27 | 29122 | 308 | |
9812 | 9812 | Sonoma | Sonoma | 97 | 2021-03-26 | 29090 | 308 | |
9873 | 9873 | Sonoma | Sonoma | 97 | 2021-03-25 | 29059 | 308 | |
9934 | 9934 | Sonoma | Sonoma | 97 | 2021-03-24 | 29045 | 308 | TRUE |
9995 | 9995 | Sonoma | Sonoma | 97 | 2021-03-23 | 29045 | 308 | |
10056 | 10056 | Sonoma | Sonoma | 97 | 2021-03-22 | 29006 | 308 | |
10117 | 10117 | Sonoma | Sonoma | 97 | 2021-03-21 | 28981 | 308 | |
10178 | 10178 | Sonoma | Sonoma | 97 | 2021-03-20 | 28914 | 308 | |
10239 | 10239 | Sonoma | Sonoma | 97 | 2021-03-19 | 28882 | 308 | TRUE |
10300 | 10300 | Sonoma | Sonoma | 97 | 2021-03-18 | 28882 | 308 | |
10361 | 10361 | Sonoma | Sonoma | 97 | 2021-03-17 | 28820 | 308 | TRUE |
10422 | 10422 | Sonoma | Sonoma | 97 | 2021-03-16 | 28820 | 308 | |
10483 | 10483 | Sonoma | Sonoma | 97 | 2021-03-15 | 28753 | 308 | TRUE |
10544 | 10544 | Sonoma | Sonoma | 97 | 2021-03-14 | 28753 | 308 | |
10605 | 10605 | Sonoma | Sonoma | 97 | 2021-03-13 | 28666 | 306 | |
10666 | 10666 | Sonoma | Sonoma | 97 | 2021-03-12 | 28622 | 306 | |
10727 | 10727 | Sonoma | Sonoma | 97 | 2021-03-11 | 28565 | 306 | |
10788 | 10788 | Sonoma | Sonoma | 97 | 2021-03-10 | 28538 | 306 | TRUE |
10849 | 10849 | Sonoma | Sonoma | 97 | 2021-03-09 | 28538 | 306 | |
10910 | 10910 | Sonoma | Sonoma | 97 | 2021-03-08 | 28448 | 303 | TRUE |
10971 | 10971 | Sonoma | Sonoma | 97 | 2021-03-07 | 28448 | 303 | |
11032 | 11032 | Sonoma | Sonoma | 97 | 2021-03-06 | 28326 | 303 | |
11093 | 11093 | Sonoma | Sonoma | 97 | 2021-03-05 | 28281 | 301 | |
11154 | 11154 | Sonoma | Sonoma | 97 | 2021-03-04 | 28213 | 301 | |
11215 | 11215 | Sonoma | Sonoma | 97 | 2021-03-03 | 28185 | 301 | |
11276 | 11276 | Sonoma | Sonoma | 97 | 2021-03-02 | 28134 | 298 | |
11337 | 11337 | Sonoma | Sonoma | 97 | 2021-03-01 | 28134 | 298 | |
11398 | 11398 | Sonoma | Sonoma | 97 | 2021-02-28 | 28092 | 298 | |
11459 | 11459 | Sonoma | Sonoma | 97 | 2021-02-27 | 28053 | 298 | |
11520 | 11520 | Sonoma | Sonoma | 97 | 2021-02-26 | 27925 | 298 | TRUE |
11581 | 11581 | Sonoma | Sonoma | 97 | 2021-02-25 | 27925 | 298 | |
11642 | 11642 | Sonoma | Sonoma | 97 | 2021-02-24 | 27803 | 295 | |
11703 | 11703 | Sonoma | Sonoma | 97 | 2021-02-23 | 27803 | 295 | |
11764 | 11764 | Sonoma | Sonoma | 97 | 2021-02-22 | 27744 | 295 | |
11825 | 11825 | Sonoma | Sonoma | 97 | 2021-02-21 | 27676 | 295 | |
11886 | 11886 | Sonoma | Sonoma | 97 | 2021-02-20 | 27606 | 291 | |
11947 | 11947 | Sonoma | Sonoma | 97 | 2021-02-19 | 27473 | 291 | |
12008 | 12008 | Sonoma | Sonoma | 97 | 2021-02-18 | 27414 | 291 | |
12069 | 12069 | Sonoma | Sonoma | 97 | 2021-02-17 | 27361 | 291 | TRUE |
12130 | 12130 | Sonoma | Sonoma | 97 | 2021-02-16 | 27361 | 291 | |
12191 | 12191 | Sonoma | Sonoma | 97 | 2021-02-15 | 27361 | 287 |
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 );