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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 275
- Orange 275
- Santa Clara 275
- San Benito 270
- Humboldt 253
- Sacramento 253
- Solano 249
- Alameda 248
- Calaveras 248
- Contra Costa 248
- Marin 248
- Placer 248
- Riverside 248
- San Diego 248
- San Francisco 248
- San Mateo 248
- Santa Cruz 248
- Shasta 248
- Sonoma 248
- Stanislaus 248
- Ventura 248
- Yolo 248
- Fresno 244
- San Joaquin 240
- Madera 234
- Imperial 230
- Tulare 230
- Amador 228
- San Luis Obispo 227
- San Bernardino 226
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18039 | 18039 | 2020-10-26 | Alameda | 1 | 23396 | 454 | 98 | 1 |
18040 | 18040 | 2020-10-26 | Alpine | 3 | 3 | 0 | 0 | 0 |
18041 | 18041 | 2020-10-26 | Amador | 5 | 299 | 15 | 8 | 0 |
18042 | 18042 | 2020-10-26 | Butte | 7 | 3095 | 52 | 8 | 0 |
18043 | 18043 | 2020-10-26 | Calaveras | 9 | 342 | 18 | 0 | 0 |
18044 | 18044 | 2020-10-26 | Colusa | 11 | 551 | 6 | 1 | 0 |
18045 | 18045 | 2020-10-26 | Contra Costa | 13 | 18763 | 242 | 69 | 0 |
18046 | 18046 | 2020-10-26 | Del Norte | 15 | 180 | 1 | 2 | 0 |
18047 | 18047 | 2020-10-26 | El Dorado | 17 | 1351 | 4 | 36 | 0 |
18048 | 18048 | 2020-10-26 | Fresno | 19 | 33353 | 436 | 128 | 0 |
18049 | 18049 | 2020-10-26 | Glenn | 21 | 671 | 3 | 14 | 0 |
18050 | 18050 | 2020-10-26 | Humboldt | 23 | 567 | 9 | 0 | 0 |
18051 | 18051 | 2020-10-26 | Imperial | 25 | 12882 | 336 | 182 | 0 |
18052 | 18052 | 2020-10-26 | Inyo | 27 | 231 | 15 | 4 | 0 |
18053 | 18053 | 2020-10-26 | Kern | 29 | 33928 | 416 | 47 | 0 |
18054 | 18054 | 2020-10-26 | Kings | 31 | 8239 | 83 | 32 | 0 |
18055 | 18055 | 2020-10-26 | Lake | 33 | 698 | 16 | 9 | 1 |
18056 | 18056 | 2020-10-26 | Lassen | 35 | 766 | 1 | 0 | 0 |
18057 | 18057 | 2020-10-26 | Los Angeles | 37 | 300662 | 7000 | 902 | 7 |
18058 | 18058 | 2020-10-26 | Madera | 39 | 5020 | 74 | 39 | 0 |
18059 | 18059 | 2020-10-26 | Marin | 41 | 7096 | 127 | 7 | -1 |
18060 | 18060 | 2020-10-26 | Mariposa | 43 | 78 | 2 | 0 | 0 |
18061 | 18061 | 2020-10-26 | Mendocino | 45 | 1136 | 21 | 7 | 0 |
18062 | 18062 | 2020-10-26 | Merced | 47 | 9531 | 155 | 66 | 0 |
18063 | 18063 | 2020-10-26 | Modoc | 49 | 36 | 0 | 7 | 0 |
18064 | 18064 | 2020-10-26 | Mono | 51 | 189 | 2 | 0 | 0 |
18065 | 18065 | 2020-10-26 | Monterey | 53 | 11419 | 90 | 20 | 0 |
18066 | 18066 | 2020-10-26 | Napa | 55 | 1961 | 15 | 24 | 1 |
18067 | 18067 | 2020-10-26 | Nevada | 57 | 623 | 8 | 15 | 0 |
18068 | 18068 | 2020-10-26 | Orange | 59 | 58725 | 1447 | 152 | 0 |
18069 | 18069 | 2020-10-26 | Placer | 61 | 4178 | 57 | 90 | 0 |
18070 | 18070 | 2020-10-26 | Plumas | 63 | 70 | 0 | 2 | 0 |
18071 | 18071 | 2020-10-26 | Riverside | 65 | 66732 | 1295 | 975 | 16 |
18072 | 18072 | 2020-10-26 | Sacramento | 67 | 25601 | 491 | 337 | 7 |
18073 | 18073 | 2020-10-26 | San Benito | 69 | 1442 | 15 | 5 | 0 |
18074 | 18074 | 2020-10-26 | San Bernardino | 71 | 62774 | 1209 | 155 | 3 |
18075 | 18075 | 2020-10-26 | San Diego | 73 | 54941 | 870 | 358 | 0 |
18076 | 18076 | 2020-10-26 | San Francisco | 75 | 12152 | 140 | 49 | 0 |
18077 | 18077 | 2020-10-26 | San Joaquin | 77 | 21729 | 489 | 99 | 0 |
18078 | 18078 | 2020-10-26 | San Luis Obispo | 79 | 4174 | 32 | 33 | 0 |
18079 | 18079 | 2020-10-26 | San Mateo | 81 | 11149 | 159 | 74 | 0 |
18080 | 18080 | 2020-10-26 | Santa Barbara | 83 | 9820 | 122 | 60 | 2 |
18081 | 18081 | 2020-10-26 | Santa Clara | 85 | 24745 | 357 | 158 | 1 |
18082 | 18082 | 2020-10-26 | Santa Cruz | 87 | 2808 | 25 | 6 | 0 |
18083 | 18083 | 2020-10-26 | Shasta | 89 | 1881 | 30 | 47 | 0 |
18084 | 18084 | 2020-10-26 | Sierra | 91 | 6 | 0 | 0 | 0 |
18085 | 18085 | 2020-10-26 | Siskiyou | 93 | 205 | 0 | 12 | 0 |
18086 | 18086 | 2020-10-26 | Solano | 95 | 7384 | 76 | 98 | 2 |
18087 | 18087 | 2020-10-26 | Sonoma | 97 | 9402 | 136 | 90 | 0 |
18088 | 18088 | 2020-10-26 | Stanislaus | 99 | 17686 | 397 | 57 | 1 |
18089 | 18089 | 2020-10-26 | Sutter | 101 | 1865 | 12 | 28 | 0 |
18090 | 18090 | 2020-10-26 | Tehama | 103 | 861 | 8 | 0 | 0 |
18091 | 18091 | 2020-10-26 | Trinity | 105 | 27 | 0 | 2 | 0 |
18092 | 18092 | 2020-10-26 | Tulare | 107 | 17590 | 288 | 95 | 2 |
18093 | 18093 | 2020-10-26 | Tuolumne | 109 | 275 | 4 | 7 | 0 |
18094 | 18094 | 2020-10-26 | Ventura | 111 | 14161 | 165 | 141 | 1 |
18095 | 18095 | 2020-10-26 | Yolo | 113 | 3207 | 59 | 16 | 0 |
18096 | 18096 | 2020-10-26 | Yuba | 115 | 1323 | 10 | 30 | 0 |
18097 | 18097 | 2020-10-25 | Alameda | 1 | 23298 | 453 | 95 | 1 |
18098 | 18098 | 2020-10-25 | Alpine | 3 | 3 | 0 | 0 | 0 |
18099 | 18099 | 2020-10-25 | Amador | 5 | 291 | 15 | 0 | 0 |
18100 | 18100 | 2020-10-25 | Butte | 7 | 3087 | 52 | 9 | 0 |
18101 | 18101 | 2020-10-25 | Calaveras | 9 | 342 | 18 | 0 | 0 |
18102 | 18102 | 2020-10-25 | Colusa | 11 | 550 | 6 | 0 | 0 |
18103 | 18103 | 2020-10-25 | Contra Costa | 13 | 18694 | 242 | 73 | 1 |
18104 | 18104 | 2020-10-25 | Del Norte | 15 | 178 | 1 | 0 | 0 |
18105 | 18105 | 2020-10-25 | El Dorado | 17 | 1315 | 4 | 0 | 0 |
18106 | 18106 | 2020-10-25 | Fresno | 19 | 33225 | 436 | 61 | 0 |
18107 | 18107 | 2020-10-25 | Glenn | 21 | 657 | 3 | 0 | 0 |
18108 | 18108 | 2020-10-25 | Humboldt | 23 | 567 | 9 | 5 | 0 |
18109 | 18109 | 2020-10-25 | Imperial | 25 | 12700 | 336 | 0 | 0 |
18110 | 18110 | 2020-10-25 | Inyo | 27 | 227 | 15 | 0 | 0 |
18111 | 18111 | 2020-10-25 | Kern | 29 | 33881 | 416 | 68 | 0 |
18112 | 18112 | 2020-10-25 | Kings | 31 | 8207 | 83 | 0 | 0 |
18113 | 18113 | 2020-10-25 | Lake | 33 | 689 | 15 | 0 | 0 |
18114 | 18114 | 2020-10-25 | Lassen | 35 | 766 | 1 | 0 | 0 |
18115 | 18115 | 2020-10-25 | Los Angeles | 37 | 299760 | 6993 | 753 | 4 |
18116 | 18116 | 2020-10-25 | Madera | 39 | 4981 | 74 | 0 | 0 |
18117 | 18117 | 2020-10-25 | Marin | 41 | 7089 | 128 | 15 | 0 |
18118 | 18118 | 2020-10-25 | Mariposa | 43 | 78 | 2 | 0 | 0 |
18119 | 18119 | 2020-10-25 | Mendocino | 45 | 1129 | 21 | 2 | 0 |
18120 | 18120 | 2020-10-25 | Merced | 47 | 9465 | 155 | 0 | 0 |
18121 | 18121 | 2020-10-25 | Modoc | 49 | 29 | 0 | 0 | 0 |
18122 | 18122 | 2020-10-25 | Mono | 51 | 189 | 2 | 1 | 0 |
18123 | 18123 | 2020-10-25 | Monterey | 53 | 11399 | 90 | 27 | 0 |
18124 | 18124 | 2020-10-25 | Napa | 55 | 1937 | 14 | 0 | 0 |
18125 | 18125 | 2020-10-25 | Nevada | 57 | 608 | 8 | 0 | 0 |
18126 | 18126 | 2020-10-25 | Orange | 59 | 58573 | 1447 | 247 | 3 |
18127 | 18127 | 2020-10-25 | Placer | 61 | 4088 | 57 | 0 | 0 |
18128 | 18128 | 2020-10-25 | Plumas | 63 | 68 | 0 | 0 | 0 |
18129 | 18129 | 2020-10-25 | Riverside | 65 | 65757 | 1279 | 0 | 0 |
18130 | 18130 | 2020-10-25 | Sacramento | 67 | 25264 | 484 | 0 | 0 |
18131 | 18131 | 2020-10-25 | San Benito | 69 | 1437 | 15 | 1 | 0 |
18132 | 18132 | 2020-10-25 | San Bernardino | 71 | 62619 | 1206 | 266 | 5 |
18133 | 18133 | 2020-10-25 | San Diego | 73 | 54583 | 870 | 269 | 2 |
18134 | 18134 | 2020-10-25 | San Francisco | 75 | 12103 | 140 | 34 | 0 |
18135 | 18135 | 2020-10-25 | San Joaquin | 77 | 21630 | 489 | 0 | 0 |
18136 | 18136 | 2020-10-25 | San Luis Obispo | 79 | 4141 | 32 | 0 | 0 |
18137 | 18137 | 2020-10-25 | San Mateo | 81 | 11075 | 159 | 0 | 0 |
18138 | 18138 | 2020-10-25 | Santa Barbara | 83 | 9760 | 120 | 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 );