latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
42 rows where "date" is on date 2020-03-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, new_confirmed_cases, date (date)
fips >30
county >30
- Alameda 1
- Amador 1
- Butte 1
- Calaveras 1
- Contra Costa 1
- El Dorado 1
- Fresno 1
- Humboldt 1
- Imperial 1
- Kern 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mendocino 1
- Merced 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
30429 | 30429 | 2020-03-22 | Alameda | 1 | 113 | 7 | 16 | 1 |
30430 | 30430 | 2020-03-22 | Amador | 5 | 2 | 0 | 0 | 0 |
30431 | 30431 | 2020-03-22 | Butte | 7 | 1 | 0 | 0 | 0 |
30432 | 30432 | 2020-03-22 | Calaveras | 9 | 2 | 0 | 0 | 0 |
30433 | 30433 | 2020-03-22 | Contra Costa | 13 | 64 | 1 | 11 | 0 |
30434 | 30434 | 2020-03-22 | El Dorado | 17 | 2 | 0 | 0 | 0 |
30435 | 30435 | 2020-03-22 | Fresno | 19 | 97 | 0 | 4 | 0 |
30436 | 30436 | 2020-03-22 | Humboldt | 23 | 2 | 0 | 0 | 0 |
30437 | 30437 | 2020-03-22 | Imperial | 25 | 6 | 0 | 0 | 0 |
30438 | 30438 | 2020-03-22 | Kern | 29 | 4 | 0 | 0 | 0 |
30439 | 30439 | 2020-03-22 | Los Angeles | 37 | 411 | 5 | 58 | 1 |
30440 | 30440 | 2020-03-22 | Madera | 39 | 3 | 0 | 0 | 0 |
30441 | 30441 | 2020-03-22 | Marin | 41 | 38 | 0 | 0 | 0 |
30442 | 30442 | 2020-03-22 | Mendocino | 45 | 1 | 0 | 0 | 0 |
30443 | 30443 | 2020-03-22 | Merced | 47 | 1 | 0 | ||
30444 | 30444 | 2020-03-22 | Mono | 51 | 1 | 0 | 0 | 0 |
30445 | 30445 | 2020-03-22 | Monterey | 53 | 14 | 1 | 3 | 0 |
30446 | 30446 | 2020-03-22 | Napa | 55 | 2 | 0 | ||
30447 | 30447 | 2020-03-22 | Nevada | 57 | 1 | 0 | 0 | 0 |
30448 | 30448 | 2020-03-22 | Orange | 59 | 94 | 0 | 17 | 0 |
30449 | 30449 | 2020-03-22 | Placer | 61 | 12 | 1 | 0 | 0 |
30450 | 30450 | 2020-03-22 | Riverside | 65 | 45 | 6 | 15 | 1 |
30451 | 30451 | 2020-03-22 | Sacramento | 67 | 53 | 3 | 0 | 0 |
30452 | 30452 | 2020-03-22 | San Benito | 69 | 6 | 1 | 1 | 0 |
30453 | 30453 | 2020-03-22 | San Bernardino | 71 | 17 | 0 | 7 | 0 |
30454 | 30454 | 2020-03-22 | San Diego | 73 | 143 | 1 | 25 | 1 |
30455 | 30455 | 2020-03-22 | San Francisco | 75 | 108 | 0 | 24 | 0 |
30456 | 30456 | 2020-03-22 | San Joaquin | 77 | 29 | 2 | 5 | 0 |
30457 | 30457 | 2020-03-22 | San Luis Obispo | 79 | 27 | 0 | 6 | 0 |
30458 | 30458 | 2020-03-22 | San Mateo | 81 | 117 | 1 | 7 | 0 |
30459 | 30459 | 2020-03-22 | Santa Barbara | 83 | 18 | 0 | 5 | 0 |
30460 | 30460 | 2020-03-22 | Santa Clara | 85 | 583 | 16 | 41 | 2 |
30461 | 30461 | 2020-03-22 | Santa Cruz | 87 | 15 | 0 | 0 | 0 |
30462 | 30462 | 2020-03-22 | Shasta | 89 | 2 | 0 | 1 | 0 |
30463 | 30463 | 2020-03-22 | Siskiyou | 93 | 2 | 0 | 0 | 0 |
30464 | 30464 | 2020-03-22 | Solano | 95 | 14 | 0 | 0 | 0 |
30465 | 30465 | 2020-03-22 | Sonoma | 97 | 27 | 1 | 3 | 0 |
30466 | 30466 | 2020-03-22 | Stanislaus | 99 | 8 | 0 | 3 | 0 |
30467 | 30467 | 2020-03-22 | Tulare | 107 | 12 | 0 | 1 | 0 |
30468 | 30468 | 2020-03-22 | Ventura | 111 | 30 | 1 | 4 | 1 |
30469 | 30469 | 2020-03-22 | Yolo | 113 | 6 | 1 | 0 | 1 |
30470 | 30470 | 2020-03-22 | Yuba | 115 | 3 | 0 | 1 | 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 );