latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2021-03-13 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
10554 | 10554 | Alameda | Alameda | 1 | 2021-03-13 | 79069 | 1189 | |
10555 | 10555 | Berkeley | Alameda | 1 | 2021-03-13 | 3363 | 45 | |
10556 | 10556 | Alpine | Alpine | 3 | 2021-03-13 | 85 | 0 | TRUE |
10557 | 10557 | Amador | Amador | 5 | 2021-03-13 | 3471 | 44 | TRUE |
10558 | 10558 | Butte | Butte | 7 | 2021-03-13 | 11131 | 170 | TRUE |
10559 | 10559 | Calaveras | Calaveras | 9 | 2021-03-13 | 1944 | 50 | TRUE |
10560 | 10560 | Colusa | Colusa | 11 | 2021-03-13 | 2155 | 14 | TRUE |
10561 | 10561 | Contra Costa | Contra Costa | 13 | 2021-03-13 | 63830 | 716 | TRUE |
10562 | 10562 | Del Norte | Del Norte | 15 | 2021-03-13 | 1056 | 5 | TRUE |
10563 | 10563 | El Dorado | El Dorado | 17 | 2021-03-13 | 9277 | 105 | TRUE |
10564 | 10564 | Fresno | Fresno | 19 | 2021-03-13 | 97471 | 1534 | |
10565 | 10565 | Glenn | Glenn | 21 | 2021-03-13 | 2214 | 23 | TRUE |
10566 | 10566 | Humboldt | Humboldt | 23 | 2021-03-13 | 3349 | 34 | TRUE |
10567 | 10567 | Imperial | Imperial | 25 | 2021-03-13 | 26749 | 680 | TRUE |
10568 | 10568 | Inyo | Inyo | 27 | 2021-03-13 | 1362 | 37 | TRUE |
10569 | 10569 | Kern | Kern | 29 | 2021-03-13 | 104814 | 987 | |
10570 | 10570 | Kings | Kings | 31 | 2021-03-13 | 22353 | 235 | |
10571 | 10571 | Lake | Lake | 33 | 2021-03-13 | 3207 | 42 | TRUE |
10572 | 10572 | Lassen | Lassen | 35 | 2021-03-13 | 5629 | 24 | TRUE |
10573 | 10573 | Long Beach | Los Angeles | 37 | 2021-03-13 | 51621 | 885 | TRUE |
10574 | 10574 | Los Angeles | Los Angeles | 37 | 2021-03-13 | 1147014 | 21237 | |
10575 | 10575 | Pasadena | Los Angeles | 37 | 2021-03-13 | 11026 | 327 | |
10576 | 10576 | Madera | Madera | 39 | 2021-03-13 | 15667 | 222 | TRUE |
10577 | 10577 | Marin | Marin | 41 | 2021-03-13 | 13445 | 198 | |
10578 | 10578 | Mariposa | Mariposa | 43 | 2021-03-13 | 396 | 7 | TRUE |
10579 | 10579 | Mendocino | Mendocino | 45 | 2021-03-13 | 3873 | 45 | TRUE |
10580 | 10580 | Merced | Merced | 47 | 2021-03-13 | 29796 | 421 | TRUE |
10581 | 10581 | Modoc | Modoc | 49 | 2021-03-13 | 463 | 4 | TRUE |
10582 | 10582 | Mono | Mono | 51 | 2021-03-13 | 1225 | 4 | TRUE |
10583 | 10583 | Monterey | Monterey | 53 | 2021-03-13 | 42575 | 336 | |
10584 | 10584 | Napa | Napa | 55 | 2021-03-13 | 9161 | 72 | TRUE |
10585 | 10585 | Nevada | Nevada | 57 | 2021-03-13 | 4097 | 74 | TRUE |
10586 | 10586 | Orange | Orange | 59 | 2021-03-13 | 248561 | 4434 | |
10587 | 10587 | Placer | Placer | 61 | 2021-03-13 | 20273 | 232 | TRUE |
10588 | 10588 | Plumas | Plumas | 63 | 2021-03-13 | 660 | 6 | TRUE |
10589 | 10589 | Riverside | Riverside | 65 | 2021-03-13 | 291866 | 3971 | TRUE |
10590 | 10590 | Sacramento | Sacramento | 67 | 2021-03-13 | 95088 | 1541 | TRUE |
10591 | 10591 | San Benito | San Benito | 69 | 2021-03-13 | 5776 | 61 | |
10592 | 10592 | San Bernardino | San Bernardino | 71 | 2021-03-13 | 288599 | 4686 | |
10593 | 10593 | San Diego | San Diego | 73 | 2021-03-13 | 265273 | 3444 | |
10594 | 10594 | San Francisco | San Francisco | 75 | 2021-03-13 | 34527 | 445 | |
10595 | 10595 | San Joaquin | San Joaquin | 77 | 2021-03-13 | 67817 | 1210 | TRUE |
10596 | 10596 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-13 | 20041 | 251 | TRUE |
10597 | 10597 | San Mateo | San Mateo | 81 | 2021-03-13 | 39393 | 534 | |
10598 | 10598 | Santa Barbara | Santa Barbara | 83 | 2021-03-13 | 32595 | 428 | |
10599 | 10599 | Santa Clara | Santa Clara | 85 | 2021-03-13 | 112019 | 1627 | |
10600 | 10600 | Santa Cruz | Santa Cruz | 87 | 2021-03-13 | 15023 | 193 | TRUE |
10601 | 10601 | Shasta | Shasta | 89 | 2021-03-13 | 11084 | 190 | TRUE |
10602 | 10602 | Sierra | Sierra | 91 | 2021-03-13 | 100 | 0 | TRUE |
10603 | 10603 | Siskiyou | Siskiyou | 93 | 2021-03-13 | 1831 | 14 | TRUE |
10604 | 10604 | Solano | Solano | 95 | 2021-03-13 | 30517 | 177 | TRUE |
10605 | 10605 | Sonoma | Sonoma | 97 | 2021-03-13 | 28666 | 306 | |
10606 | 10606 | Stanislaus | Stanislaus | 99 | 2021-03-13 | 51663 | 969 | |
10607 | 10607 | Sutter | Sutter | 101 | 2021-03-13 | 8977 | 99 | TRUE |
10608 | 10608 | Tehama | Tehama | 103 | 2021-03-13 | 5160 | 53 | |
10609 | 10609 | Trinity | Trinity | 105 | 2021-03-13 | 377 | 5 | TRUE |
10610 | 10610 | Tulare | Tulare | 107 | 2021-03-13 | 48550 | 784 | TRUE |
10611 | 10611 | Tuolumne | Tuolumne | 109 | 2021-03-13 | 3991 | 59 | TRUE |
10612 | 10612 | Ventura | Ventura | 111 | 2021-03-13 | 78713 | 925 | |
10613 | 10613 | Yolo | Yolo | 113 | 2021-03-13 | 12919 | 190 | TRUE |
10614 | 10614 | Yuba | Yuba | 115 | 2021-03-13 | 5854 | 40 | TRUE |
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 );