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-03 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 |
---|---|---|---|---|---|---|---|---|
29708 | 29708 | Alameda | Alameda | 1 | 2020-05-03 | 1713 | 98 | |
29709 | 29709 | Berkeley | Alameda | 1 | 2020-05-03 | 55 | 1 | |
29710 | 29710 | Alpine | Alpine | 3 | 2020-05-03 | 1 | 0 | TRUE |
29711 | 29711 | Amador | Amador | 5 | 2020-05-03 | 8 | 0 | TRUE |
29712 | 29712 | Butte | Butte | 7 | 2020-05-03 | 17 | 0 | TRUE |
29713 | 29713 | Calaveras | Calaveras | 9 | 2020-05-03 | 13 | 0 | TRUE |
29714 | 29714 | Colusa | Colusa | 11 | 2020-05-03 | 3 | 0 | TRUE |
29715 | 29715 | Contra Costa | Contra Costa | 13 | 2020-05-03 | 936 | 28 | |
29716 | 29716 | Del Norte | Del Norte | 15 | 2020-05-03 | 3 | 0 | TRUE |
29717 | 29717 | El Dorado | El Dorado | 17 | 2020-05-03 | 47 | 0 | TRUE |
29718 | 29718 | Fresno | Fresno | 19 | 2020-05-03 | 1198 | 8 | TRUE |
29719 | 29719 | Glenn | Glenn | 21 | 2020-05-03 | 5 | 0 | TRUE |
29720 | 29720 | Humboldt | Humboldt | 23 | 2020-05-03 | 54 | 0 | TRUE |
29721 | 29721 | Imperial | Imperial | 25 | 2020-05-03 | 358 | 9 | TRUE |
29722 | 29722 | Inyo | Inyo | 27 | 2020-05-03 | 19 | 1 | TRUE |
29723 | 29723 | Kern | Kern | 29 | 2020-05-03 | 1005 | 8 | |
29724 | 29724 | Kings | Kings | 31 | 2020-05-03 | 172 | 1 | |
29725 | 29725 | Lake | Lake | 33 | 2020-05-03 | 7 | 0 | TRUE |
29726 | 29726 | Lassen | Lassen | 35 | 2020-05-03 | 0 | 0 | |
29727 | 29727 | Long Beach | Los Angeles | 37 | 2020-05-03 | 760 | 37 | |
29728 | 29728 | Los Angeles | Los Angeles | 37 | 2020-05-03 | 24500 | 1138 | |
29729 | 29729 | Pasadena | Los Angeles | 37 | 2020-05-03 | 439 | 56 | |
29730 | 29730 | Madera | Madera | 39 | 2020-05-03 | 51 | 2 | |
29731 | 29731 | Marin | Marin | 41 | 2020-05-03 | 240 | 13 | |
29732 | 29732 | Mariposa | Mariposa | 43 | 2020-05-03 | 13 | 0 | TRUE |
29733 | 29733 | Mendocino | Mendocino | 45 | 2020-05-03 | 12 | 0 | TRUE |
29734 | 29734 | Merced | Merced | 47 | 2020-05-03 | 142 | 3 | |
29735 | 29735 | Modoc | Modoc | 49 | 2020-05-03 | 0 | 0 | TRUE |
29736 | 29736 | Mono | Mono | 51 | 2020-05-03 | 26 | 1 | TRUE |
29737 | 29737 | Monterey | Monterey | 53 | 2020-05-03 | 235 | 6 | |
29738 | 29738 | Napa | Napa | 55 | 2020-05-03 | 70 | 2 | TRUE |
29739 | 29739 | Nevada | Nevada | 57 | 2020-05-03 | 41 | 1 | TRUE |
29740 | 29740 | Orange | Orange | 59 | 2020-05-03 | 2715 | 52 | |
29741 | 29741 | Placer | Placer | 61 | 2020-05-03 | 159 | 8 | TRUE |
29742 | 29742 | Plumas | Plumas | 63 | 2020-05-03 | 4 | 0 | TRUE |
29743 | 29743 | Riverside | Riverside | 65 | 2020-05-03 | 4180 | 161 | |
29744 | 29744 | Sacramento | Sacramento | 67 | 2020-05-03 | 1117 | 42 | |
29745 | 29745 | San Benito | San Benito | 69 | 2020-05-03 | 51 | 2 | |
29746 | 29746 | San Bernardino | San Bernardino | 71 | 2020-05-03 | 2182 | 118 | TRUE |
29747 | 29747 | San Diego | San Diego | 73 | 2020-05-03 | 3927 | 139 | |
29748 | 29748 | San Francisco | San Francisco | 75 | 2020-05-03 | 1602 | 29 | |
29749 | 29749 | San Joaquin | San Joaquin | 77 | 2020-05-03 | 569 | 25 | |
29750 | 29750 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-03 | 201 | 1 | |
29751 | 29751 | San Mateo | San Mateo | 81 | 2020-05-03 | 1233 | 51 | TRUE |
29752 | 29752 | Santa Barbara | Santa Barbara | 83 | 2020-05-03 | 514 | 8 | |
29753 | 29753 | Santa Clara | Santa Clara | 85 | 2020-05-03 | 2264 | 120 | |
29754 | 29754 | Santa Cruz | Santa Cruz | 87 | 2020-05-03 | 137 | 2 | |
29755 | 29755 | Shasta | Shasta | 89 | 2020-05-03 | 31 | 4 | |
29756 | 29756 | Sierra | Sierra | 91 | 2020-05-03 | 0 | 0 | TRUE |
29757 | 29757 | Siskiyou | Siskiyou | 93 | 2020-05-03 | 5 | 0 | |
29758 | 29758 | Solano | Solano | 95 | 2020-05-03 | 266 | 5 | TRUE |
29759 | 29759 | Sonoma | Sonoma | 97 | 2020-05-03 | 257 | 3 | |
29760 | 29760 | Stanislaus | Stanislaus | 99 | 2020-05-03 | 411 | 14 | |
29761 | 29761 | Sutter | Sutter | 101 | 2020-05-03 | 31 | 2 | |
29762 | 29762 | Tehama | Tehama | 103 | 2020-05-03 | 1 | 1 | TRUE |
29763 | 29763 | Trinity | Trinity | 105 | 2020-05-03 | 0 | 0 | TRUE |
29764 | 29764 | Tulare | Tulare | 107 | 2020-05-03 | 743 | 40 | |
29765 | 29765 | Tuolumne | Tuolumne | 109 | 2020-05-03 | 2 | 0 | TRUE |
29766 | 29766 | Ventura | Ventura | 111 | 2020-05-03 | 566 | 19 | |
29767 | 29767 | Yolo | Yolo | 113 | 2020-05-03 | 171 | 17 | |
29768 | 29768 | Yuba | Yuba | 115 | 2020-05-03 | 19 | 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 );