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-04-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
8724 | 8724 | Alameda | Alameda | 1 | 2021-04-12 | 81823 | 1208 | |
8725 | 8725 | Berkeley | Alameda | 1 | 2021-04-12 | 3500 | 46 | |
8726 | 8726 | Alpine | Alpine | 3 | 2021-04-12 | 88 | 0 | TRUE |
8727 | 8727 | Amador | Amador | 5 | 2021-04-12 | 3576 | 46 | |
8728 | 8728 | Butte | Butte | 7 | 2021-04-12 | 11488 | 181 | |
8729 | 8729 | Calaveras | Calaveras | 9 | 2021-04-12 | 2041 | 51 | |
8730 | 8730 | Colusa | Colusa | 11 | 2021-04-12 | 2184 | 16 | |
8731 | 8731 | Contra Costa | Contra Costa | 13 | 2021-04-12 | 66442 | 764 | |
8732 | 8732 | Del Norte | Del Norte | 15 | 2021-04-12 | 1254 | 7 | |
8733 | 8733 | El Dorado | El Dorado | 17 | 2021-04-12 | 9641 | 108 | |
8734 | 8734 | Fresno | Fresno | 19 | 2021-04-12 | 99833 | 1633 | |
8735 | 8735 | Glenn | Glenn | 21 | 2021-04-12 | 2290 | 25 | |
8736 | 8736 | Humboldt | Humboldt | 23 | 2021-04-12 | 3553 | 36 | |
8737 | 8737 | Imperial | Imperial | 25 | 2021-04-12 | 27494 | 716 | |
8738 | 8738 | Inyo | Inyo | 27 | 2021-04-12 | 1415 | 38 | |
8739 | 8739 | Kern | Kern | 29 | 2021-04-12 | 107374 | 1304 | |
8740 | 8740 | Kings | Kings | 31 | 2021-04-12 | 22708 | 243 | |
8741 | 8741 | Lake | Lake | 33 | 2021-04-12 | 3352 | 43 | |
8742 | 8742 | Lassen | Lassen | 35 | 2021-04-12 | 5666 | 24 | |
8743 | 8743 | Long Beach | Los Angeles | 37 | 2021-04-12 | 52496 | 920 | |
8744 | 8744 | Los Angeles | Los Angeles | 37 | 2021-04-12 | 1162543 | 22220 | |
8745 | 8745 | Pasadena | Los Angeles | 37 | 2021-04-12 | 11180 | 339 | |
8746 | 8746 | Madera | Madera | 39 | 2021-04-12 | 16077 | 236 | |
8747 | 8747 | Marin | Marin | 41 | 2021-04-12 | 13813 | 205 | |
8748 | 8748 | Mariposa | Mariposa | 43 | 2021-04-12 | 416 | 7 | |
8749 | 8749 | Mendocino | Mendocino | 45 | 2021-04-12 | 3974 | 47 | |
8750 | 8750 | Merced | Merced | 47 | 2021-04-12 | 31070 | 448 | |
8751 | 8751 | Modoc | Modoc | 49 | 2021-04-12 | 487 | 4 | |
8752 | 8752 | Mono | Mono | 51 | 2021-04-12 | 1272 | 4 | |
8753 | 8753 | Monterey | Monterey | 53 | 2021-04-12 | 43157 | 347 | TRUE |
8754 | 8754 | Napa | Napa | 55 | 2021-04-12 | 9597 | 75 | |
8755 | 8755 | Nevada | Nevada | 57 | 2021-04-12 | 4411 | 75 | |
8756 | 8756 | Orange | Orange | 59 | 2021-04-12 | 252436 | 4839 | |
8757 | 8757 | Placer | Placer | 61 | 2021-04-12 | 21540 | 279 | |
8758 | 8758 | Plumas | Plumas | 63 | 2021-04-12 | 688 | 6 | |
8759 | 8759 | Riverside | Riverside | 65 | 2021-04-12 | 296635 | 4492 | |
8760 | 8760 | Sacramento | Sacramento | 67 | 2021-04-12 | 100365 | 1640 | |
8761 | 8761 | San Benito | San Benito | 69 | 2021-04-12 | 5928 | 62 | |
8762 | 8762 | San Bernardino | San Bernardino | 71 | 2021-04-12 | 293835 | 4767 | |
8763 | 8763 | San Diego | San Diego | 73 | 2021-04-12 | 273430 | 3621 | |
8764 | 8764 | San Francisco | San Francisco | 75 | 2021-04-12 | 35576 | 502 | |
8765 | 8765 | San Joaquin | San Joaquin | 77 | 2021-04-12 | 70994 | 1334 | |
8766 | 8766 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-12 | 20754 | 256 | |
8767 | 8767 | San Mateo | San Mateo | 81 | 2021-04-12 | 40880 | 556 | |
8768 | 8768 | Santa Barbara | Santa Barbara | 83 | 2021-04-12 | 33727 | 441 | |
8769 | 8769 | Santa Clara | Santa Clara | 85 | 2021-04-12 | 115445 | 1669 | |
8770 | 8770 | Santa Cruz | Santa Cruz | 87 | 2021-04-12 | 15394 | 202 | |
8771 | 8771 | Shasta | Shasta | 89 | 2021-04-12 | 11539 | 214 | |
8772 | 8772 | Sierra | Sierra | 91 | 2021-04-12 | 108 | 0 | |
8773 | 8773 | Siskiyou | Siskiyou | 93 | 2021-04-12 | 1904 | 19 | |
8774 | 8774 | Solano | Solano | 95 | 2021-04-12 | 31673 | 209 | |
8775 | 8775 | Sonoma | Sonoma | 97 | 2021-04-12 | 29536 | 309 | |
8776 | 8776 | Stanislaus | Stanislaus | 99 | 2021-04-12 | 53576 | 1018 | |
8777 | 8777 | Sutter | Sutter | 101 | 2021-04-12 | 9242 | 103 | |
8778 | 8778 | Tehama | Tehama | 103 | 2021-04-12 | 5393 | 56 | |
8779 | 8779 | Trinity | Trinity | 105 | 2021-04-12 | 397 | 5 | |
8780 | 8780 | Tulare | Tulare | 107 | 2021-04-12 | 49272 | 823 | |
8781 | 8781 | Tuolumne | Tuolumne | 109 | 2021-04-12 | 4056 | 64 | |
8782 | 8782 | Ventura | Ventura | 111 | 2021-04-12 | 80078 | 990 | |
8783 | 8783 | Yolo | Yolo | 113 | 2021-04-12 | 13402 | 199 | |
8784 | 8784 | Yuba | Yuba | 115 | 2021-04-12 | 6073 | 40 |
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 );