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-13 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 |
---|---|---|---|---|---|---|---|---|
29098 | 29098 | Alameda | Alameda | 1 | 2020-05-13 | 2110 | 110 | |
29099 | 29099 | Berkeley | Alameda | 1 | 2020-05-13 | 68 | 1 | TRUE |
29100 | 29100 | Alpine | Alpine | 3 | 2020-05-13 | 1 | 0 | TRUE |
29101 | 29101 | Amador | Amador | 5 | 2020-05-13 | 9 | 0 | |
29102 | 29102 | Butte | Butte | 7 | 2020-05-13 | 21 | 0 | |
29103 | 29103 | Calaveras | Calaveras | 9 | 2020-05-13 | 13 | 0 | |
29104 | 29104 | Colusa | Colusa | 11 | 2020-05-13 | 3 | 0 | |
29105 | 29105 | Contra Costa | Contra Costa | 13 | 2020-05-13 | 1072 | 33 | |
29106 | 29106 | Del Norte | Del Norte | 15 | 2020-05-13 | 4 | 0 | |
29107 | 29107 | El Dorado | El Dorado | 17 | 2020-05-13 | 60 | 0 | |
29108 | 29108 | Fresno | Fresno | 19 | 2020-05-13 | 1850 | 13 | |
29109 | 29109 | Glenn | Glenn | 21 | 2020-05-13 | 7 | 0 | |
29110 | 29110 | Humboldt | Humboldt | 23 | 2020-05-13 | 67 | 0 | |
29111 | 29111 | Imperial | Imperial | 25 | 2020-05-13 | 647 | 14 | |
29112 | 29112 | Inyo | Inyo | 27 | 2020-05-13 | 19 | 1 | |
29113 | 29113 | Kern | Kern | 29 | 2020-05-13 | 1343 | 17 | |
29114 | 29114 | Kings | Kings | 31 | 2020-05-13 | 348 | 1 | |
29115 | 29115 | Lake | Lake | 33 | 2020-05-13 | 8 | 0 | |
29116 | 29116 | Lassen | Lassen | 35 | 2020-05-13 | 0 | 0 | |
29117 | 29117 | Long Beach | Los Angeles | 37 | 2020-05-13 | 1094 | 49 | |
29118 | 29118 | Los Angeles | Los Angeles | 37 | 2020-05-13 | 32851 | 1545 | |
29119 | 29119 | Pasadena | Los Angeles | 37 | 2020-05-13 | 607 | 69 | |
29120 | 29120 | Madera | Madera | 39 | 2020-05-13 | 69 | 2 | |
29121 | 29121 | Marin | Marin | 41 | 2020-05-13 | 275 | 14 | |
29122 | 29122 | Mariposa | Mariposa | 43 | 2020-05-13 | 15 | 0 | |
29123 | 29123 | Mendocino | Mendocino | 45 | 2020-05-13 | 13 | 0 | |
29124 | 29124 | Merced | Merced | 47 | 2020-05-13 | 180 | 4 | |
29125 | 29125 | Modoc | Modoc | 49 | 2020-05-13 | 0 | 0 | |
29126 | 29126 | Mono | Mono | 51 | 2020-05-13 | 32 | 1 | |
29127 | 29127 | Monterey | Monterey | 53 | 2020-05-13 | 308 | 6 | |
29128 | 29128 | Napa | Napa | 55 | 2020-05-13 | 81 | 3 | |
29129 | 29129 | Nevada | Nevada | 57 | 2020-05-13 | 41 | 1 | |
29130 | 29130 | Orange | Orange | 59 | 2020-05-13 | 3749 | 80 | |
29131 | 29131 | Placer | Placer | 61 | 2020-05-13 | 170 | 8 | |
29132 | 29132 | Plumas | Plumas | 63 | 2020-05-13 | 4 | 0 | |
29133 | 29133 | Riverside | Riverside | 65 | 2020-05-13 | 5343 | 228 | |
29134 | 29134 | Sacramento | Sacramento | 67 | 2020-05-13 | 1183 | 51 | |
29135 | 29135 | San Benito | San Benito | 69 | 2020-05-13 | 58 | 2 | |
29136 | 29136 | San Bernardino | San Bernardino | 71 | 2020-05-13 | 3153 | 158 | |
29137 | 29137 | San Diego | San Diego | 73 | 2020-05-13 | 5278 | 194 | |
29138 | 29138 | San Francisco | San Francisco | 75 | 2020-05-13 | 1994 | 35 | |
29139 | 29139 | San Joaquin | San Joaquin | 77 | 2020-05-13 | 636 | 31 | |
29140 | 29140 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-13 | 232 | 1 | |
29141 | 29141 | San Mateo | San Mateo | 81 | 2020-05-13 | 1515 | 65 | |
29142 | 29142 | Santa Barbara | Santa Barbara | 83 | 2020-05-13 | 1376 | 11 | |
29143 | 29143 | Santa Clara | Santa Clara | 85 | 2020-05-13 | 2429 | 132 | |
29144 | 29144 | Santa Cruz | Santa Cruz | 87 | 2020-05-13 | 146 | 2 | |
29145 | 29145 | Shasta | Shasta | 89 | 2020-05-13 | 32 | 4 | |
29146 | 29146 | Sierra | Sierra | 91 | 2020-05-13 | 0 | 0 | |
29147 | 29147 | Siskiyou | Siskiyou | 93 | 2020-05-13 | 5 | 0 | |
29148 | 29148 | Solano | Solano | 95 | 2020-05-13 | 397 | 12 | |
29149 | 29149 | Sonoma | Sonoma | 97 | 2020-05-13 | 337 | 4 | |
29150 | 29150 | Stanislaus | Stanislaus | 99 | 2020-05-13 | 526 | 23 | |
29151 | 29151 | Sutter | Sutter | 101 | 2020-05-13 | 36 | 2 | |
29152 | 29152 | Tehama | Tehama | 103 | 2020-05-13 | 1 | 1 | |
29153 | 29153 | Trinity | Trinity | 105 | 2020-05-13 | 1 | 0 | |
29154 | 29154 | Tulare | Tulare | 107 | 2020-05-13 | 1268 | 54 | |
29155 | 29155 | Tuolumne | Tuolumne | 109 | 2020-05-13 | 2 | 0 | |
29156 | 29156 | Ventura | Ventura | 111 | 2020-05-13 | 725 | 24 | |
29157 | 29157 | Yolo | Yolo | 113 | 2020-05-13 | 179 | 22 | |
29158 | 29158 | Yuba | Yuba | 115 | 2020-05-13 | 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 );