latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
53 rows where "date" is on date 2020-04-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases
fips >30
county >30
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
29386 | 29386 | 2020-04-12 | Alameda | 1 | 887 | 68 | 47 | 5 |
29387 | 29387 | 2020-04-12 | Alpine | 3 | 1 | 0 | 0 | 0 |
29388 | 29388 | 2020-04-12 | Amador | 5 | 7 | 0 | 0 | 0 |
29389 | 29389 | 2020-04-12 | Butte | 7 | 13 | 0 | 0 | 0 |
29390 | 29390 | 2020-04-12 | Calaveras | 9 | 8 | 0 | 0 | 0 |
29391 | 29391 | 2020-04-12 | Colusa | 11 | 3 | 0 | 0 | 0 |
29392 | 29392 | 2020-04-12 | Contra Costa | 13 | 565 | 11 | 9 | 0 |
29393 | 29393 | 2020-04-12 | Del Norte | 15 | 2 | 0 | 0 | 0 |
29394 | 29394 | 2020-04-12 | El Dorado | 17 | 32 | 0 | 0 | 0 |
29395 | 29395 | 2020-04-12 | Fresno | 19 | 428 | 5 | 10 | 0 |
29396 | 29396 | 2020-04-12 | Glenn | 21 | 3 | 0 | 0 | 0 |
29397 | 29397 | 2020-04-12 | Humboldt | 23 | 50 | 0 | 0 | 0 |
29398 | 29398 | 2020-04-12 | Imperial | 25 | 87 | 3 | 0 | 0 |
29399 | 29399 | 2020-04-12 | Inyo | 27 | 12 | 0 | 0 | 0 |
29400 | 29400 | 2020-04-12 | Kern | 29 | 396 | 3 | 27 | 0 |
29401 | 29401 | 2020-04-12 | Kings | 31 | 10 | 1 | 0 | 0 |
29402 | 29402 | 2020-04-12 | Lake | 33 | 4 | 0 | 0 | 0 |
29403 | 29403 | 2020-04-12 | Los Angeles | 37 | 9197 | 300 | 308 | 33 |
29404 | 29404 | 2020-04-12 | Madera | 39 | 33 | 2 | 1 | 0 |
29405 | 29405 | 2020-04-12 | Marin | 41 | 164 | 10 | 11 | 0 |
29406 | 29406 | 2020-04-12 | Mendocino | 45 | 4 | 0 | 0 | 0 |
29407 | 29407 | 2020-04-12 | Merced | 47 | 65 | 3 | 1 | 0 |
29408 | 29408 | 2020-04-12 | Mono | 51 | 23 | 1 | 2 | 0 |
29409 | 29409 | 2020-04-12 | Monterey | 53 | 87 | 3 | 5 | 0 |
29410 | 29410 | 2020-04-12 | Napa | 55 | 34 | 2 | 0 | 0 |
29411 | 29411 | 2020-04-12 | Nevada | 57 | 34 | 1 | 0 | 0 |
29412 | 29412 | 2020-04-12 | Orange | 59 | 1250 | 19 | 49 | 1 |
29413 | 29413 | 2020-04-12 | Placer | 61 | 124 | 4 | 0 | 0 |
29414 | 29414 | 2020-04-12 | Plumas | 63 | 4 | 0 | 0 | 0 |
29415 | 29415 | 2020-04-12 | Riverside | 65 | 1619 | 41 | 188 | 0 |
29416 | 29416 | 2020-04-12 | Sacramento | 67 | 707 | 26 | 8 | 0 |
29417 | 29417 | 2020-04-12 | San Benito | 69 | 35 | 2 | 0 | 0 |
29418 | 29418 | 2020-04-12 | San Bernardino | 71 | 887 | 40 | 77 | 5 |
29419 | 29419 | 2020-04-12 | San Diego | 73 | 1804 | 45 | 43 | 0 |
29420 | 29420 | 2020-04-12 | San Francisco | 75 | 872 | 14 | 15 | 1 |
29421 | 29421 | 2020-04-12 | San Joaquin | 77 | 261 | 16 | 1 | 1 |
29422 | 29422 | 2020-04-12 | San Luis Obispo | 79 | 114 | 1 | 4 | 0 |
29423 | 29423 | 2020-04-12 | San Mateo | 81 | 652 | 21 | 0 | 0 |
29424 | 29424 | 2020-04-12 | Santa Barbara | 83 | 267 | 2 | 3 | 0 |
29425 | 29425 | 2020-04-12 | Santa Clara | 85 | 1750 | 67 | 24 | 6 |
29426 | 29426 | 2020-04-12 | Santa Cruz | 87 | 88 | 1 | 6 | 0 |
29427 | 29427 | 2020-04-12 | Shasta | 89 | 24 | 3 | 0 | 0 |
29428 | 29428 | 2020-04-12 | Siskiyou | 93 | 5 | 0 | 0 | 0 |
29429 | 29429 | 2020-04-12 | Solano | 95 | 121 | 2 | 0 | 0 |
29430 | 29430 | 2020-04-12 | Sonoma | 97 | 147 | 2 | 2 | 0 |
29431 | 29431 | 2020-04-12 | Stanislaus | 99 | 131 | 2 | 10 | 0 |
29432 | 29432 | 2020-04-12 | Sutter | 101 | 22 | 2 | 0 | 0 |
29433 | 29433 | 2020-04-12 | Tehama | 103 | 1 | 0 | 0 | 0 |
29434 | 29434 | 2020-04-12 | Tulare | 107 | 227 | 11 | 0 | 0 |
29435 | 29435 | 2020-04-12 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
29436 | 29436 | 2020-04-12 | Ventura | 111 | 314 | 10 | 5 | 0 |
29437 | 29437 | 2020-04-12 | Yolo | 113 | 93 | 3 | 5 | 0 |
29438 | 29438 | 2020-04-12 | Yuba | 115 | 15 | 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 );