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-28 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
28183 | 28183 | Alameda | Alameda | 1 | 2020-05-28 | 3013 | 123 | |
28184 | 28184 | Berkeley | Alameda | 1 | 2020-05-28 | 91 | 2 | TRUE |
28185 | 28185 | Alpine | Alpine | 3 | 2020-05-28 | 1 | 0 | TRUE |
28186 | 28186 | Amador | Amador | 5 | 2020-05-28 | 10 | 0 | |
28187 | 28187 | Butte | Butte | 7 | 2020-05-28 | 40 | 0 | |
28188 | 28188 | Calaveras | Calaveras | 9 | 2020-05-28 | 15 | 0 | TRUE |
28189 | 28189 | Colusa | Colusa | 11 | 2020-05-28 | 5 | 0 | |
28190 | 28190 | Contra Costa | Contra Costa | 13 | 2020-05-28 | 1373 | 37 | |
28191 | 28191 | Del Norte | Del Norte | 15 | 2020-05-28 | 44 | 0 | |
28192 | 28192 | El Dorado | El Dorado | 17 | 2020-05-28 | 84 | 0 | |
28193 | 28193 | Fresno | Fresno | 19 | 2020-05-28 | 2945 | 32 | |
28194 | 28194 | Glenn | Glenn | 21 | 2020-05-28 | 14 | 0 | |
28195 | 28195 | Humboldt | Humboldt | 23 | 2020-05-28 | 98 | 3 | |
28196 | 28196 | Imperial | Imperial | 25 | 2020-05-28 | 1545 | 26 | |
28197 | 28197 | Inyo | Inyo | 27 | 2020-05-28 | 19 | 1 | |
28198 | 28198 | Kern | Kern | 29 | 2020-05-28 | 2007 | 37 | |
28199 | 28199 | Kings | Kings | 31 | 2020-05-28 | 714 | 3 | |
28200 | 28200 | Lake | Lake | 33 | 2020-05-28 | 21 | 0 | |
28201 | 28201 | Lassen | Lassen | 35 | 2020-05-28 | 5 | 0 | TRUE |
28202 | 28202 | Long Beach | Los Angeles | 37 | 2020-05-28 | 1741 | 81 | |
28203 | 28203 | Los Angeles | Los Angeles | 37 | 2020-05-28 | 47208 | 2078 | |
28204 | 28204 | Pasadena | Los Angeles | 37 | 2020-05-28 | 911 | 82 | |
28205 | 28205 | Madera | Madera | 39 | 2020-05-28 | 98 | 2 | |
28206 | 28206 | Marin | Marin | 41 | 2020-05-28 | 436 | 14 | |
28207 | 28207 | Mariposa | Mariposa | 43 | 2020-05-28 | 16 | 1 | |
28208 | 28208 | Mendocino | Mendocino | 45 | 2020-05-28 | 30 | 0 | |
28209 | 28209 | Merced | Merced | 47 | 2020-05-28 | 280 | 7 | |
28210 | 28210 | Modoc | Modoc | 49 | 2020-05-28 | 0 | 0 | |
28211 | 28211 | Mono | Mono | 51 | 2020-05-28 | 35 | 1 | |
28212 | 28212 | Monterey | Monterey | 53 | 2020-05-28 | 469 | 8 | |
28213 | 28213 | Napa | Napa | 55 | 2020-05-28 | 111 | 3 | |
28214 | 28214 | Nevada | Nevada | 57 | 2020-05-28 | 41 | 1 | |
28215 | 28215 | Orange | Orange | 59 | 2020-05-28 | 5744 | 142 | |
28216 | 28216 | Placer | Placer | 61 | 2020-05-28 | 196 | 9 | |
28217 | 28217 | Plumas | Plumas | 63 | 2020-05-28 | 4 | 0 | |
28218 | 28218 | Riverside | Riverside | 65 | 2020-05-28 | 7341 | 313 | |
28219 | 28219 | Sacramento | Sacramento | 67 | 2020-05-28 | 1349 | 56 | |
28220 | 28220 | San Benito | San Benito | 69 | 2020-05-28 | 85 | 2 | |
28221 | 28221 | San Bernardino | San Bernardino | 71 | 2020-05-28 | 4914 | 211 | |
28222 | 28222 | San Diego | San Diego | 73 | 2020-05-28 | 7100 | 260 | |
28223 | 28223 | San Francisco | San Francisco | 75 | 2020-05-28 | 2437 | 40 | |
28224 | 28224 | San Joaquin | San Joaquin | 77 | 2020-05-28 | 844 | 34 | |
28225 | 28225 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-28 | 268 | 1 | |
28226 | 28226 | San Mateo | San Mateo | 81 | 2020-05-28 | 2022 | 82 | |
28227 | 28227 | Santa Barbara | Santa Barbara | 83 | 2020-05-28 | 1636 | 12 | |
28228 | 28228 | Santa Clara | Santa Clara | 85 | 2020-05-28 | 2776 | 139 | |
28229 | 28229 | Santa Cruz | Santa Cruz | 87 | 2020-05-28 | 205 | 2 | |
28230 | 28230 | Shasta | Shasta | 89 | 2020-05-28 | 37 | 4 | |
28231 | 28231 | Sierra | Sierra | 91 | 2020-05-28 | 1 | 0 | |
28232 | 28232 | Siskiyou | Siskiyou | 93 | 2020-05-28 | 6 | 0 | |
28233 | 28233 | Solano | Solano | 95 | 2020-05-28 | 509 | 22 | |
28234 | 28234 | Sonoma | Sonoma | 97 | 2020-05-28 | 531 | 4 | TRUE |
28235 | 28235 | Stanislaus | Stanislaus | 99 | 2020-05-28 | 683 | 28 | |
28236 | 28236 | Sutter | Sutter | 101 | 2020-05-28 | 42 | 2 | |
28237 | 28237 | Tehama | Tehama | 103 | 2020-05-28 | 4 | 1 | TRUE |
28238 | 28238 | Trinity | Trinity | 105 | 2020-05-28 | 1 | 0 | |
28239 | 28239 | Tulare | Tulare | 107 | 2020-05-28 | 1835 | 80 | |
28240 | 28240 | Tuolumne | Tuolumne | 109 | 2020-05-28 | 4 | 0 | TRUE |
28241 | 28241 | Ventura | Ventura | 111 | 2020-05-28 | 1062 | 32 | |
28242 | 28242 | Yolo | Yolo | 113 | 2020-05-28 | 207 | 23 | |
28243 | 28243 | Yuba | Yuba | 115 | 2020-05-28 | 29 | 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 );