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 2020-05-19 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 |
---|---|---|---|---|---|---|---|---|
28732 | 28732 | Alameda | Alameda | 1 | 2020-05-19 | 2442 | 117 | |
28733 | 28733 | Berkeley | Alameda | 1 | 2020-05-19 | 72 | 2 | |
28734 | 28734 | Alpine | Alpine | 3 | 2020-05-19 | 1 | 0 | TRUE |
28735 | 28735 | Amador | Amador | 5 | 2020-05-19 | 10 | 0 | |
28736 | 28736 | Butte | Butte | 7 | 2020-05-19 | 25 | 0 | |
28737 | 28737 | Calaveras | Calaveras | 9 | 2020-05-19 | 13 | 0 | |
28738 | 28738 | Colusa | Colusa | 11 | 2020-05-19 | 3 | 0 | |
28739 | 28739 | Contra Costa | Contra Costa | 13 | 2020-05-19 | 1180 | 33 | |
28740 | 28740 | Del Norte | Del Norte | 15 | 2020-05-19 | 14 | 0 | |
28741 | 28741 | El Dorado | El Dorado | 17 | 2020-05-19 | 67 | 0 | |
28742 | 28742 | Fresno | Fresno | 19 | 2020-05-19 | 2272 | 17 | |
28743 | 28743 | Glenn | Glenn | 21 | 2020-05-19 | 12 | 0 | |
28744 | 28744 | Humboldt | Humboldt | 23 | 2020-05-19 | 86 | 2 | |
28745 | 28745 | Imperial | Imperial | 25 | 2020-05-19 | 902 | 18 | |
28746 | 28746 | Inyo | Inyo | 27 | 2020-05-19 | 19 | 1 | |
28747 | 28747 | Kern | Kern | 29 | 2020-05-19 | 1571 | 25 | |
28748 | 28748 | Kings | Kings | 31 | 2020-05-19 | 416 | 2 | |
28749 | 28749 | Lake | Lake | 33 | 2020-05-19 | 11 | 0 | |
28750 | 28750 | Lassen | Lassen | 35 | 2020-05-19 | 0 | 0 | TRUE |
28751 | 28751 | Long Beach | Los Angeles | 37 | 2020-05-19 | 1362 | 62 | |
28752 | 28752 | Los Angeles | Los Angeles | 37 | 2020-05-19 | 37566 | 1790 | |
28753 | 28753 | Pasadena | Los Angeles | 37 | 2020-05-19 | 704 | 74 | |
28754 | 28754 | Madera | Madera | 39 | 2020-05-19 | 81 | 2 | |
28755 | 28755 | Marin | Marin | 41 | 2020-05-19 | 336 | 14 | |
28756 | 28756 | Mariposa | Mariposa | 43 | 2020-05-19 | 15 | 1 | |
28757 | 28757 | Mendocino | Mendocino | 45 | 2020-05-19 | 15 | 0 | TRUE |
28758 | 28758 | Merced | Merced | 47 | 2020-05-19 | 222 | 6 | |
28759 | 28759 | Modoc | Modoc | 49 | 2020-05-19 | 0 | 0 | |
28760 | 28760 | Mono | Mono | 51 | 2020-05-19 | 34 | 1 | |
28761 | 28761 | Monterey | Monterey | 53 | 2020-05-19 | 349 | 8 | |
28762 | 28762 | Napa | Napa | 55 | 2020-05-19 | 92 | 3 | |
28763 | 28763 | Nevada | Nevada | 57 | 2020-05-19 | 41 | 1 | |
28764 | 28764 | Orange | Orange | 59 | 2020-05-19 | 4500 | 88 | |
28765 | 28765 | Placer | Placer | 61 | 2020-05-19 | 177 | 8 | |
28766 | 28766 | Plumas | Plumas | 63 | 2020-05-19 | 4 | 0 | |
28767 | 28767 | Riverside | Riverside | 65 | 2020-05-19 | 6053 | 270 | |
28768 | 28768 | Sacramento | Sacramento | 67 | 2020-05-19 | 1250 | 56 | |
28769 | 28769 | San Benito | San Benito | 69 | 2020-05-19 | 63 | 2 | |
28770 | 28770 | San Bernardino | San Bernardino | 71 | 2020-05-19 | 3707 | 175 | |
28771 | 28771 | San Diego | San Diego | 73 | 2020-05-19 | 6026 | 222 | |
28772 | 28772 | San Francisco | San Francisco | 75 | 2020-05-19 | 2179 | 36 | |
28773 | 28773 | San Joaquin | San Joaquin | 77 | 2020-05-19 | 707 | 33 | |
28774 | 28774 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-19 | 247 | 1 | |
28775 | 28775 | San Mateo | San Mateo | 81 | 2020-05-19 | 1687 | 75 | |
28776 | 28776 | Santa Barbara | Santa Barbara | 83 | 2020-05-19 | 1517 | 11 | |
28777 | 28777 | Santa Clara | Santa Clara | 85 | 2020-05-19 | 2573 | 136 | |
28778 | 28778 | Santa Cruz | Santa Cruz | 87 | 2020-05-19 | 165 | 2 | |
28779 | 28779 | Shasta | Shasta | 89 | 2020-05-19 | 34 | 4 | |
28780 | 28780 | Sierra | Sierra | 91 | 2020-05-19 | 0 | 0 | |
28781 | 28781 | Siskiyou | Siskiyou | 93 | 2020-05-19 | 6 | 0 | |
28782 | 28782 | Solano | Solano | 95 | 2020-05-19 | 430 | 16 | |
28783 | 28783 | Sonoma | Sonoma | 97 | 2020-05-19 | 411 | 4 | |
28784 | 28784 | Stanislaus | Stanislaus | 99 | 2020-05-19 | 593 | 26 | |
28785 | 28785 | Sutter | Sutter | 101 | 2020-05-19 | 40 | 2 | |
28786 | 28786 | Tehama | Tehama | 103 | 2020-05-19 | 2 | 1 | |
28787 | 28787 | Trinity | Trinity | 105 | 2020-05-19 | 1 | 0 | |
28788 | 28788 | Tulare | Tulare | 107 | 2020-05-19 | 1539 | 71 | |
28789 | 28789 | Tuolumne | Tuolumne | 109 | 2020-05-19 | 2 | 0 | |
28790 | 28790 | Ventura | Ventura | 111 | 2020-05-19 | 837 | 28 | |
28791 | 28791 | Yolo | Yolo | 113 | 2020-05-19 | 185 | 22 | |
28792 | 28792 | Yuba | Yuba | 115 | 2020-05-19 | 28 | 1 |
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 );