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-14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29037 | 29037 | Alameda | Alameda | 1 | 2020-05-14 | 2175 | 111 | |
29038 | 29038 | Berkeley | Alameda | 1 | 2020-05-14 | 68 | 1 | |
29039 | 29039 | Alpine | Alpine | 3 | 2020-05-14 | 1 | 0 | TRUE |
29040 | 29040 | Amador | Amador | 5 | 2020-05-14 | 9 | 0 | |
29041 | 29041 | Butte | Butte | 7 | 2020-05-14 | 22 | 0 | |
29042 | 29042 | Calaveras | Calaveras | 9 | 2020-05-14 | 13 | 0 | TRUE |
29043 | 29043 | Colusa | Colusa | 11 | 2020-05-14 | 3 | 0 | |
29044 | 29044 | Contra Costa | Contra Costa | 13 | 2020-05-14 | 1079 | 33 | |
29045 | 29045 | Del Norte | Del Norte | 15 | 2020-05-14 | 4 | 0 | |
29046 | 29046 | El Dorado | El Dorado | 17 | 2020-05-14 | 62 | 0 | |
29047 | 29047 | Fresno | Fresno | 19 | 2020-05-14 | 1936 | 13 | |
29048 | 29048 | Glenn | Glenn | 21 | 2020-05-14 | 9 | 0 | |
29049 | 29049 | Humboldt | Humboldt | 23 | 2020-05-14 | 68 | 0 | |
29050 | 29050 | Imperial | Imperial | 25 | 2020-05-14 | 712 | 15 | |
29051 | 29051 | Inyo | Inyo | 27 | 2020-05-14 | 19 | 1 | |
29052 | 29052 | Kern | Kern | 29 | 2020-05-14 | 1393 | 21 | |
29053 | 29053 | Kings | Kings | 31 | 2020-05-14 | 358 | 1 | |
29054 | 29054 | Lake | Lake | 33 | 2020-05-14 | 8 | 0 | |
29055 | 29055 | Lassen | Lassen | 35 | 2020-05-14 | 0 | 0 | TRUE |
29056 | 29056 | Long Beach | Los Angeles | 37 | 2020-05-14 | 1157 | 51 | |
29057 | 29057 | Los Angeles | Los Angeles | 37 | 2020-05-14 | 33628 | 1591 | |
29058 | 29058 | Pasadena | Los Angeles | 37 | 2020-05-14 | 662 | 69 | |
29059 | 29059 | Madera | Madera | 39 | 2020-05-14 | 69 | 2 | |
29060 | 29060 | Marin | Marin | 41 | 2020-05-14 | 279 | 14 | |
29061 | 29061 | Mariposa | Mariposa | 43 | 2020-05-14 | 15 | 0 | |
29062 | 29062 | Mendocino | Mendocino | 45 | 2020-05-14 | 13 | 0 | TRUE |
29063 | 29063 | Merced | Merced | 47 | 2020-05-14 | 189 | 4 | |
29064 | 29064 | Modoc | Modoc | 49 | 2020-05-14 | 0 | 0 | TRUE |
29065 | 29065 | Mono | Mono | 51 | 2020-05-14 | 33 | 1 | |
29066 | 29066 | Monterey | Monterey | 53 | 2020-05-14 | 317 | 6 | |
29067 | 29067 | Napa | Napa | 55 | 2020-05-14 | 83 | 3 | |
29068 | 29068 | Nevada | Nevada | 57 | 2020-05-14 | 41 | 1 | |
29069 | 29069 | Orange | Orange | 59 | 2020-05-14 | 3968 | 80 | |
29070 | 29070 | Placer | Placer | 61 | 2020-05-14 | 172 | 8 | |
29071 | 29071 | Plumas | Plumas | 63 | 2020-05-14 | 4 | 0 | |
29072 | 29072 | Riverside | Riverside | 65 | 2020-05-14 | 5440 | 235 | |
29073 | 29073 | Sacramento | Sacramento | 67 | 2020-05-14 | 1194 | 54 | |
29074 | 29074 | San Benito | San Benito | 69 | 2020-05-14 | 59 | 2 | |
29075 | 29075 | San Bernardino | San Bernardino | 71 | 2020-05-14 | 3198 | 161 | |
29076 | 29076 | San Diego | San Diego | 73 | 2020-05-14 | 5391 | 200 | |
29077 | 29077 | San Francisco | San Francisco | 75 | 2020-05-14 | 1999 | 35 | |
29078 | 29078 | San Joaquin | San Joaquin | 77 | 2020-05-14 | 643 | 31 | |
29079 | 29079 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-14 | 237 | 1 | |
29080 | 29080 | San Mateo | San Mateo | 81 | 2020-05-14 | 1536 | 65 | |
29081 | 29081 | Santa Barbara | Santa Barbara | 83 | 2020-05-14 | 1387 | 11 | |
29082 | 29082 | Santa Clara | Santa Clara | 85 | 2020-05-14 | 2453 | 133 | |
29083 | 29083 | Santa Cruz | Santa Cruz | 87 | 2020-05-14 | 149 | 2 | |
29084 | 29084 | Shasta | Shasta | 89 | 2020-05-14 | 33 | 4 | |
29085 | 29085 | Sierra | Sierra | 91 | 2020-05-14 | 0 | 0 | |
29086 | 29086 | Siskiyou | Siskiyou | 93 | 2020-05-14 | 5 | 0 | |
29087 | 29087 | Solano | Solano | 95 | 2020-05-14 | 408 | 14 | |
29088 | 29088 | Sonoma | Sonoma | 97 | 2020-05-14 | 351 | 4 | |
29089 | 29089 | Stanislaus | Stanislaus | 99 | 2020-05-14 | 537 | 23 | |
29090 | 29090 | Sutter | Sutter | 101 | 2020-05-14 | 37 | 2 | |
29091 | 29091 | Tehama | Tehama | 103 | 2020-05-14 | 1 | 1 | TRUE |
29092 | 29092 | Trinity | Trinity | 105 | 2020-05-14 | 1 | 0 | |
29093 | 29093 | Tulare | Tulare | 107 | 2020-05-14 | 1295 | 54 | |
29094 | 29094 | Tuolumne | Tuolumne | 109 | 2020-05-14 | 2 | 0 | |
29095 | 29095 | Ventura | Ventura | 111 | 2020-05-14 | 748 | 25 | |
29096 | 29096 | Yolo | Yolo | 113 | 2020-05-14 | 182 | 22 | |
29097 | 29097 | Yuba | Yuba | 115 | 2020-05-14 | 25 | 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 );