latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- …
Link | rowid | date ▼ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31341 | 31341 | 2020-01-26 | Alameda | 1 | 0 | 0 | ||
31342 | 31342 | 2020-01-26 | Calaveras | 9 | 0 | 0 | ||
31343 | 31343 | 2020-01-26 | Contra Costa | 13 | 0 | 0 | ||
31344 | 31344 | 2020-01-26 | Humboldt | 23 | 0 | 0 | ||
31345 | 31345 | 2020-01-26 | Los Angeles | 37 | 1 | 0 | ||
31346 | 31346 | 2020-01-26 | Marin | 41 | 0 | 0 | ||
31347 | 31347 | 2020-01-26 | Orange | 59 | 1 | 0 | ||
31348 | 31348 | 2020-01-26 | Placer | 61 | 0 | 0 | ||
31349 | 31349 | 2020-01-26 | Riverside | 65 | 0 | 0 | ||
31350 | 31350 | 2020-01-26 | Sacramento | 67 | 0 | 0 | ||
31351 | 31351 | 2020-01-26 | San Benito | 69 | 0 | 0 | ||
31352 | 31352 | 2020-01-26 | San Diego | 73 | 0 | 0 | ||
31353 | 31353 | 2020-01-26 | San Francisco | 75 | 0 | 0 | ||
31354 | 31354 | 2020-01-26 | San Mateo | 81 | 0 | 0 | ||
31355 | 31355 | 2020-01-26 | Santa Clara | 85 | 0 | 0 | ||
31356 | 31356 | 2020-01-26 | Santa Cruz | 87 | 0 | 0 | ||
31357 | 31357 | 2020-01-26 | Shasta | 89 | 0 | 0 | ||
31358 | 31358 | 2020-01-26 | Solano | 95 | 0 | 0 | ||
31359 | 31359 | 2020-01-26 | Sonoma | 97 | 0 | 0 | ||
31360 | 31360 | 2020-01-26 | Stanislaus | 99 | 0 | 0 | ||
31361 | 31361 | 2020-01-26 | Ventura | 111 | 0 | 0 | ||
31362 | 31362 | 2020-01-26 | Yolo | 113 | 0 | 0 | ||
31338 | 31338 | 2020-01-27 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31339 | 31339 | 2020-01-27 | Orange | 59 | 1 | 0 | 0 | 0 |
31340 | 31340 | 2020-01-27 | Santa Clara | 85 | 1 | 0 | 1 | 0 |
31335 | 31335 | 2020-01-28 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31336 | 31336 | 2020-01-28 | Orange | 59 | 1 | 0 | 0 | 0 |
31337 | 31337 | 2020-01-28 | Santa Clara | 85 | 2 | 0 | 1 | 0 |
31332 | 31332 | 2020-01-29 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31333 | 31333 | 2020-01-29 | Orange | 59 | 1 | 0 | 0 | 0 |
31334 | 31334 | 2020-01-29 | Santa Clara | 85 | 3 | 0 | 1 | 0 |
31329 | 31329 | 2020-01-30 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31330 | 31330 | 2020-01-30 | Orange | 59 | 1 | 0 | 0 | 0 |
31331 | 31331 | 2020-01-30 | Santa Clara | 85 | 4 | 0 | 1 | 0 |
31307 | 31307 | 2020-01-31 | Alameda | 1 | 0 | 0 | 0 | 0 |
31308 | 31308 | 2020-01-31 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31309 | 31309 | 2020-01-31 | Contra Costa | 13 | 0 | 0 | 0 | 0 |
31310 | 31310 | 2020-01-31 | Humboldt | 23 | 0 | 0 | 0 | 0 |
31311 | 31311 | 2020-01-31 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31312 | 31312 | 2020-01-31 | Marin | 41 | 0 | 0 | 0 | 0 |
31313 | 31313 | 2020-01-31 | Orange | 59 | 1 | 0 | 0 | 0 |
31314 | 31314 | 2020-01-31 | Placer | 61 | 0 | 0 | 0 | 0 |
31315 | 31315 | 2020-01-31 | Riverside | 65 | 0 | 0 | 0 | 0 |
31316 | 31316 | 2020-01-31 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31317 | 31317 | 2020-01-31 | San Benito | 69 | 0 | 0 | 0 | 0 |
31318 | 31318 | 2020-01-31 | San Diego | 73 | 0 | 0 | 0 | 0 |
31319 | 31319 | 2020-01-31 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31320 | 31320 | 2020-01-31 | San Mateo | 81 | 0 | 0 | 0 | 0 |
31321 | 31321 | 2020-01-31 | Santa Clara | 85 | 6 | 0 | 2 | 0 |
31322 | 31322 | 2020-01-31 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31323 | 31323 | 2020-01-31 | Shasta | 89 | 0 | 0 | 0 | 0 |
31324 | 31324 | 2020-01-31 | Solano | 95 | 0 | 0 | 0 | 0 |
31325 | 31325 | 2020-01-31 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31326 | 31326 | 2020-01-31 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31327 | 31327 | 2020-01-31 | Ventura | 111 | 0 | 0 | 0 | 0 |
31328 | 31328 | 2020-01-31 | Yolo | 113 | 0 | 0 | 0 | 0 |
31304 | 31304 | 2020-02-01 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31305 | 31305 | 2020-02-01 | Orange | 59 | 1 | 0 | 0 | 0 |
31306 | 31306 | 2020-02-01 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31282 | 31282 | 2020-02-02 | Alameda | 1 | 1 | 0 | 1 | 0 |
31283 | 31283 | 2020-02-02 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31284 | 31284 | 2020-02-02 | Contra Costa | 13 | 0 | 0 | 0 | 0 |
31285 | 31285 | 2020-02-02 | Humboldt | 23 | 0 | 0 | 0 | 0 |
31286 | 31286 | 2020-02-02 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31287 | 31287 | 2020-02-02 | Marin | 41 | 0 | 0 | 0 | 0 |
31288 | 31288 | 2020-02-02 | Orange | 59 | 1 | 0 | 0 | 0 |
31289 | 31289 | 2020-02-02 | Placer | 61 | 0 | 0 | 0 | 0 |
31290 | 31290 | 2020-02-02 | Riverside | 65 | 0 | 0 | 0 | 0 |
31291 | 31291 | 2020-02-02 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31292 | 31292 | 2020-02-02 | San Benito | 69 | 2 | 0 | 2 | 0 |
31293 | 31293 | 2020-02-02 | San Diego | 73 | 0 | 0 | 0 | 0 |
31294 | 31294 | 2020-02-02 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31295 | 31295 | 2020-02-02 | San Mateo | 81 | 0 | 0 | 0 | 0 |
31296 | 31296 | 2020-02-02 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31297 | 31297 | 2020-02-02 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31298 | 31298 | 2020-02-02 | Shasta | 89 | 0 | 0 | 0 | 0 |
31299 | 31299 | 2020-02-02 | Solano | 95 | 0 | 0 | 0 | 0 |
31300 | 31300 | 2020-02-02 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31301 | 31301 | 2020-02-02 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31302 | 31302 | 2020-02-02 | Ventura | 111 | 0 | 0 | 0 | 0 |
31303 | 31303 | 2020-02-02 | Yolo | 113 | 0 | 0 | 0 | 0 |
31278 | 31278 | 2020-02-03 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31279 | 31279 | 2020-02-03 | Orange | 59 | 1 | 0 | 0 | 0 |
31280 | 31280 | 2020-02-03 | San Benito | 69 | 2 | 0 | 0 | 0 |
31281 | 31281 | 2020-02-03 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31274 | 31274 | 2020-02-04 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31275 | 31275 | 2020-02-04 | Orange | 59 | 1 | 0 | 0 | 0 |
31276 | 31276 | 2020-02-04 | San Benito | 69 | 2 | 0 | 0 | 0 |
31277 | 31277 | 2020-02-04 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31270 | 31270 | 2020-02-05 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31271 | 31271 | 2020-02-05 | Orange | 59 | 1 | 0 | 0 | 0 |
31272 | 31272 | 2020-02-05 | San Benito | 69 | 2 | 0 | 0 | 0 |
31273 | 31273 | 2020-02-05 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31266 | 31266 | 2020-02-06 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31267 | 31267 | 2020-02-06 | Orange | 59 | 1 | 0 | 0 | 0 |
31268 | 31268 | 2020-02-06 | San Benito | 69 | 2 | 0 | 0 | 0 |
31269 | 31269 | 2020-02-06 | Santa Clara | 85 | 6 | 1 | 0 | 1 |
31262 | 31262 | 2020-02-07 | Los Angeles | 37 | 1 | 0 | 0 | 0 |
31263 | 31263 | 2020-02-07 | Orange | 59 | 1 | 0 | 0 | 0 |
31264 | 31264 | 2020-02-07 | San Benito | 69 | 2 | 0 | 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 );