latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
58 rows where "date" is on date 2020-05-21 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_deaths
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
27203 | 27203 | 2020-05-21 | Alameda | 1 | 2639 | 120 | 75 | 0 |
27204 | 27204 | 2020-05-21 | Alpine | 3 | 1 | 0 | 0 | 0 |
27205 | 27205 | 2020-05-21 | Amador | 5 | 10 | 0 | 0 | 0 |
27206 | 27206 | 2020-05-21 | Butte | 7 | 31 | 0 | 1 | 0 |
27207 | 27207 | 2020-05-21 | Calaveras | 9 | 13 | 0 | 0 | 0 |
27208 | 27208 | 2020-05-21 | Colusa | 11 | 4 | 0 | 0 | 0 |
27209 | 27209 | 2020-05-21 | Contra Costa | 13 | 1220 | 36 | 26 | 3 |
27210 | 27210 | 2020-05-21 | Del Norte | 15 | 20 | 0 | 5 | 0 |
27211 | 27211 | 2020-05-21 | El Dorado | 17 | 67 | 0 | 0 | 0 |
27212 | 27212 | 2020-05-21 | Fresno | 19 | 2444 | 22 | 72 | 2 |
27213 | 27213 | 2020-05-21 | Glenn | 21 | 12 | 0 | 0 | 0 |
27214 | 27214 | 2020-05-21 | Humboldt | 23 | 88 | 2 | 0 | 0 |
27215 | 27215 | 2020-05-21 | Imperial | 25 | 1076 | 21 | 91 | 2 |
27216 | 27216 | 2020-05-21 | Inyo | 27 | 19 | 1 | 0 | 0 |
27217 | 27217 | 2020-05-21 | Kern | 29 | 1644 | 25 | 39 | 0 |
27218 | 27218 | 2020-05-21 | Kings | 31 | 488 | 2 | 31 | 0 |
27219 | 27219 | 2020-05-21 | Lake | 33 | 12 | 0 | 0 | 0 |
27220 | 27220 | 2020-05-21 | Lassen | 35 | 0 | 0 | 0 | 0 |
27221 | 27221 | 2020-05-21 | Los Angeles | 37 | 42138 | 2021 | 1163 | 45 |
27222 | 27222 | 2020-05-21 | Madera | 39 | 83 | 2 | 1 | 0 |
27223 | 27223 | 2020-05-21 | Marin | 41 | 352 | 14 | 9 | 0 |
27224 | 27224 | 2020-05-21 | Mariposa | 43 | 15 | 1 | 0 | 0 |
27225 | 27225 | 2020-05-21 | Mendocino | 45 | 15 | 0 | 0 | 0 |
27226 | 27226 | 2020-05-21 | Merced | 47 | 234 | 6 | 8 | 0 |
27227 | 27227 | 2020-05-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
27228 | 27228 | 2020-05-21 | Mono | 51 | 34 | 1 | 0 | 0 |
27229 | 27229 | 2020-05-21 | Monterey | 53 | 362 | 8 | 7 | 0 |
27230 | 27230 | 2020-05-21 | Napa | 55 | 95 | 3 | 1 | 0 |
27231 | 27231 | 2020-05-21 | Nevada | 57 | 41 | 1 | 0 | 0 |
27232 | 27232 | 2020-05-21 | Orange | 59 | 4841 | 112 | 99 | 14 |
27233 | 27233 | 2020-05-21 | Placer | 61 | 177 | 8 | 0 | 0 |
27234 | 27234 | 2020-05-21 | Plumas | 63 | 4 | 0 | 0 | 0 |
27235 | 27235 | 2020-05-21 | Riverside | 65 | 6343 | 284 | 159 | 14 |
27236 | 27236 | 2020-05-21 | Sacramento | 67 | 1266 | 56 | 11 | 0 |
27237 | 27237 | 2020-05-21 | San Benito | 69 | 66 | 2 | 2 | 0 |
27238 | 27238 | 2020-05-21 | San Bernardino | 71 | 3984 | 179 | 189 | 2 |
27239 | 27239 | 2020-05-21 | San Diego | 73 | 6315 | 241 | 175 | 11 |
27240 | 27240 | 2020-05-21 | San Francisco | 75 | 2198 | 37 | 13 | 0 |
27241 | 27241 | 2020-05-21 | San Joaquin | 77 | 733 | 33 | 17 | 0 |
27242 | 27242 | 2020-05-21 | San Luis Obispo | 79 | 251 | 1 | 2 | 0 |
27243 | 27243 | 2020-05-21 | San Mateo | 81 | 1738 | 75 | 41 | 0 |
27244 | 27244 | 2020-05-21 | Santa Barbara | 83 | 1540 | 11 | 20 | 0 |
27245 | 27245 | 2020-05-21 | Santa Clara | 85 | 2630 | 136 | 21 | 0 |
27246 | 27246 | 2020-05-21 | Santa Cruz | 87 | 174 | 2 | 6 | 0 |
27247 | 27247 | 2020-05-21 | Shasta | 89 | 34 | 4 | 0 | 0 |
27248 | 27248 | 2020-05-21 | Sierra | 91 | 0 | 0 | 0 | 0 |
27249 | 27249 | 2020-05-21 | Siskiyou | 93 | 6 | 0 | 0 | 0 |
27250 | 27250 | 2020-05-21 | Solano | 95 | 449 | 19 | 14 | 1 |
27251 | 27251 | 2020-05-21 | Sonoma | 97 | 444 | 4 | 11 | 0 |
27252 | 27252 | 2020-05-21 | Stanislaus | 99 | 611 | 28 | 13 | 2 |
27253 | 27253 | 2020-05-21 | Sutter | 101 | 40 | 2 | 0 | 0 |
27254 | 27254 | 2020-05-21 | Tehama | 103 | 2 | 1 | 0 | 0 |
27255 | 27255 | 2020-05-21 | Trinity | 105 | 1 | 0 | 0 | 0 |
27256 | 27256 | 2020-05-21 | Tulare | 107 | 1603 | 74 | 51 | 1 |
27257 | 27257 | 2020-05-21 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
27258 | 27258 | 2020-05-21 | Ventura | 111 | 883 | 29 | 25 | 0 |
27259 | 27259 | 2020-05-21 | Yolo | 113 | 186 | 22 | 1 | 0 |
27260 | 27260 | 2020-05-21 | Yuba | 115 | 28 | 1 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );