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 confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|
27807 | 27807 | 2020-05-11 | Modoc | 49 | 0 | 0 | 0 | 0 |
27828 | 27828 | 2020-05-11 | Sierra | 91 | 0 | 0 | 0 | 0 |
27858 | 27858 | 2020-05-10 | Lassen | 35 | 0 | 0 | 0 | 0 |
27865 | 27865 | 2020-05-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
27886 | 27886 | 2020-05-10 | Sierra | 91 | 0 | 0 | 0 | 0 |
27916 | 27916 | 2020-05-09 | Lassen | 35 | 0 | 0 | 0 | 0 |
27923 | 27923 | 2020-05-09 | Modoc | 49 | 0 | 0 | 0 | 0 |
27944 | 27944 | 2020-05-09 | Sierra | 91 | 0 | 0 | 0 | 0 |
27974 | 27974 | 2020-05-08 | Lassen | 35 | 0 | 0 | 0 | 0 |
27981 | 27981 | 2020-05-08 | Modoc | 49 | 0 | 0 | 0 | 0 |
28002 | 28002 | 2020-05-08 | Sierra | 91 | 0 | 0 | 0 | 0 |
28009 | 28009 | 2020-05-08 | Trinity | 105 | 0 | 0 | 0 | 0 |
28032 | 28032 | 2020-05-07 | Lassen | 35 | 0 | 0 | 0 | 0 |
28039 | 28039 | 2020-05-07 | Modoc | 49 | 0 | 0 | 0 | 0 |
28060 | 28060 | 2020-05-07 | Sierra | 91 | 0 | 0 | 0 | 0 |
28067 | 28067 | 2020-05-07 | Trinity | 105 | 0 | 0 | 0 | 0 |
28090 | 28090 | 2020-05-06 | Lassen | 35 | 0 | 0 | 0 | 0 |
28097 | 28097 | 2020-05-06 | Modoc | 49 | 0 | 0 | 0 | 0 |
28118 | 28118 | 2020-05-06 | Sierra | 91 | 0 | 0 | 0 | 0 |
28125 | 28125 | 2020-05-06 | Trinity | 105 | 0 | 0 | 0 | 0 |
28148 | 28148 | 2020-05-05 | Lassen | 35 | 0 | 0 | 0 | 0 |
28155 | 28155 | 2020-05-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
28176 | 28176 | 2020-05-05 | Sierra | 91 | 0 | 0 | 0 | 0 |
28183 | 28183 | 2020-05-05 | Trinity | 105 | 0 | 0 | 0 | 0 |
28206 | 28206 | 2020-05-04 | Lassen | 35 | 0 | 0 | 0 | 0 |
28213 | 28213 | 2020-05-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
28234 | 28234 | 2020-05-04 | Sierra | 91 | 0 | 0 | 0 | 0 |
28241 | 28241 | 2020-05-04 | Trinity | 105 | 0 | 0 | 0 | 0 |
28264 | 28264 | 2020-05-03 | Lassen | 35 | 0 | 0 | 0 | 0 |
28271 | 28271 | 2020-05-03 | Modoc | 49 | 0 | 0 | 0 | 0 |
28292 | 28292 | 2020-05-03 | Sierra | 91 | 0 | 0 | 0 | 0 |
28299 | 28299 | 2020-05-03 | Trinity | 105 | 0 | 0 | 0 | 0 |
28322 | 28322 | 2020-05-02 | Lassen | 35 | 0 | 0 | 0 | 0 |
28329 | 28329 | 2020-05-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
28350 | 28350 | 2020-05-02 | Sierra | 91 | 0 | 0 | 0 | 0 |
28357 | 28357 | 2020-05-02 | Trinity | 105 | 0 | 0 | 0 | 0 |
28380 | 28380 | 2020-05-01 | Lassen | 35 | 0 | 0 | 0 | 0 |
28387 | 28387 | 2020-05-01 | Modoc | 49 | 0 | 0 | 0 | 0 |
28408 | 28408 | 2020-05-01 | Sierra | 91 | 0 | 0 | 0 | 0 |
28415 | 28415 | 2020-05-01 | Trinity | 105 | 0 | 0 | 0 | 0 |
28438 | 28438 | 2020-04-30 | Lassen | 35 | 0 | 0 | 0 | 0 |
28445 | 28445 | 2020-04-30 | Modoc | 49 | 0 | 0 | 0 | 0 |
28466 | 28466 | 2020-04-30 | Sierra | 91 | 0 | 0 | 0 | 0 |
28473 | 28473 | 2020-04-30 | Trinity | 105 | 0 | 0 | 0 | 0 |
28496 | 28496 | 2020-04-29 | Lassen | 35 | 0 | 0 | ||
28503 | 28503 | 2020-04-29 | Modoc | 49 | 0 | 0 | ||
28524 | 28524 | 2020-04-29 | Sierra | 91 | 0 | 0 | ||
28531 | 28531 | 2020-04-29 | Trinity | 105 | 0 | 0 | ||
30847 | 30847 | 2020-03-10 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30851 | 30851 | 2020-03-09 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30872 | 30872 | 2020-03-09 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30876 | 30876 | 2020-03-08 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30882 | 30882 | 2020-03-08 | Marin | 41 | 0 | 0 | 0 | 0 |
30897 | 30897 | 2020-03-08 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30901 | 30901 | 2020-03-07 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30907 | 30907 | 2020-03-07 | Marin | 41 | 0 | 0 | 0 | 0 |
30913 | 30913 | 2020-03-07 | San Diego | 73 | 0 | 0 | 0 | 0 |
30919 | 30919 | 2020-03-07 | Shasta | 89 | 0 | 0 | 0 | 0 |
30922 | 30922 | 2020-03-07 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30926 | 30926 | 2020-03-06 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30931 | 30931 | 2020-03-06 | Marin | 41 | 0 | 0 | 0 | 0 |
30934 | 30934 | 2020-03-06 | Riverside | 65 | 0 | 0 | 0 | 0 |
30937 | 30937 | 2020-03-06 | San Diego | 73 | 0 | 0 | 0 | 0 |
30942 | 30942 | 2020-03-06 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
30943 | 30943 | 2020-03-06 | Shasta | 89 | 0 | 0 | 0 | 0 |
30946 | 30946 | 2020-03-06 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30950 | 30950 | 2020-03-05 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30955 | 30955 | 2020-03-05 | Marin | 41 | 0 | 0 | 0 | 0 |
30958 | 30958 | 2020-03-05 | Riverside | 65 | 0 | 0 | 0 | 0 |
30961 | 30961 | 2020-03-05 | San Diego | 73 | 0 | 0 | 0 | 0 |
30966 | 30966 | 2020-03-05 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
30967 | 30967 | 2020-03-05 | Shasta | 89 | 0 | 0 | 0 | 0 |
30970 | 30970 | 2020-03-05 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30971 | 30971 | 2020-03-05 | Ventura | 111 | 0 | 0 | 0 | 0 |
30972 | 30972 | 2020-03-05 | Yolo | 113 | 0 | 0 | 0 | 0 |
30974 | 30974 | 2020-03-04 | Calaveras | 9 | 0 | 0 | 0 | 0 |
30979 | 30979 | 2020-03-04 | Marin | 41 | 0 | 0 | 0 | 0 |
30982 | 30982 | 2020-03-04 | Riverside | 65 | 0 | 0 | 0 | 0 |
30985 | 30985 | 2020-03-04 | San Diego | 73 | 0 | 0 | 0 | 0 |
30986 | 30986 | 2020-03-04 | San Francisco | 75 | 0 | 0 | 0 | 0 |
30987 | 30987 | 2020-03-04 | San Joaquin | 77 | 0 | 0 | 0 | 0 |
30990 | 30990 | 2020-03-04 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
30991 | 30991 | 2020-03-04 | Shasta | 89 | 0 | 0 | 0 | 0 |
30994 | 30994 | 2020-03-04 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
30995 | 30995 | 2020-03-04 | Ventura | 111 | 0 | 0 | 0 | 0 |
30996 | 30996 | 2020-03-04 | Yolo | 113 | 0 | 0 | 0 | 0 |
30998 | 30998 | 2020-03-03 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31003 | 31003 | 2020-03-03 | Marin | 41 | 0 | 0 | 0 | 0 |
31006 | 31006 | 2020-03-03 | Riverside | 65 | 0 | 0 | 0 | 0 |
31009 | 31009 | 2020-03-03 | San Diego | 73 | 0 | 0 | 0 | 0 |
31010 | 31010 | 2020-03-03 | San Francisco | 75 | 0 | 0 | 0 | 0 |
31011 | 31011 | 2020-03-03 | San Joaquin | 77 | 0 | 0 | 0 | 0 |
31014 | 31014 | 2020-03-03 | Santa Cruz | 87 | 0 | 0 | 0 | 0 |
31015 | 31015 | 2020-03-03 | Shasta | 89 | 0 | 0 | 0 | 0 |
31018 | 31018 | 2020-03-03 | Stanislaus | 99 | 0 | 0 | 0 | 0 |
31019 | 31019 | 2020-03-03 | Ventura | 111 | 0 | 0 | 0 | 0 |
31020 | 31020 | 2020-03-03 | Yolo | 113 | 0 | 0 | 0 | 0 |
31022 | 31022 | 2020-03-02 | Calaveras | 9 | 0 | 0 | 0 | 0 |
31027 | 31027 | 2020-03-02 | Marin | 41 | 0 | 0 | 0 | 0 |
31030 | 31030 | 2020-03-02 | Riverside | 65 | 0 | 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 );