latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 753
- Alameda 496
- Orange 275
- Santa Clara 275
- San Benito 270
- Humboldt 253
- Sacramento 253
- Solano 249
- 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
- …
agency >30
- Los Angeles 275
- Orange 275
- Santa Clara 275
- San Benito 270
- Humboldt 253
- Sacramento 253
- Solano 249
- Alameda 248
- Berkeley 248
- Calaveras 248
- Contra Costa 248
- Long Beach 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
- Pasadena 230
- Tulare 230
- …
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
18972 | 18972 | Alameda | Alameda | 1 | 2020-10-26 | 22634 | 444 | |
18973 | 18973 | Berkeley | Alameda | 1 | 2020-10-26 | 762 | 10 | |
18974 | 18974 | Alpine | Alpine | 3 | 2020-10-26 | 3 | 0 | TRUE |
18975 | 18975 | Amador | Amador | 5 | 2020-10-26 | 299 | 15 | |
18976 | 18976 | Butte | Butte | 7 | 2020-10-26 | 3095 | 52 | |
18977 | 18977 | Calaveras | Calaveras | 9 | 2020-10-26 | 342 | 18 | TRUE |
18978 | 18978 | Colusa | Colusa | 11 | 2020-10-26 | 551 | 6 | |
18979 | 18979 | Contra Costa | Contra Costa | 13 | 2020-10-26 | 18763 | 242 | |
18980 | 18980 | Del Norte | Del Norte | 15 | 2020-10-26 | 180 | 1 | |
18981 | 18981 | El Dorado | El Dorado | 17 | 2020-10-26 | 1351 | 4 | |
18982 | 18982 | Fresno | Fresno | 19 | 2020-10-26 | 33353 | 436 | |
18983 | 18983 | Glenn | Glenn | 21 | 2020-10-26 | 671 | 3 | |
18984 | 18984 | Humboldt | Humboldt | 23 | 2020-10-26 | 567 | 9 | |
18985 | 18985 | Imperial | Imperial | 25 | 2020-10-26 | 12882 | 336 | |
18986 | 18986 | Inyo | Inyo | 27 | 2020-10-26 | 231 | 15 | |
18987 | 18987 | Kern | Kern | 29 | 2020-10-26 | 33928 | 416 | |
18988 | 18988 | Kings | Kings | 31 | 2020-10-26 | 8239 | 83 | |
18989 | 18989 | Lake | Lake | 33 | 2020-10-26 | 698 | 16 | |
18990 | 18990 | Lassen | Lassen | 35 | 2020-10-26 | 766 | 1 | TRUE |
18991 | 18991 | Long Beach | Los Angeles | 37 | 2020-10-26 | 13048 | 255 | |
18992 | 18992 | Los Angeles | Los Angeles | 37 | 2020-10-26 | 284844 | 6616 | |
18993 | 18993 | Pasadena | Los Angeles | 37 | 2020-10-26 | 2770 | 129 | |
18994 | 18994 | Madera | Madera | 39 | 2020-10-26 | 5020 | 74 | |
18995 | 18995 | Marin | Marin | 41 | 2020-10-26 | 7096 | 127 | |
18996 | 18996 | Mariposa | Mariposa | 43 | 2020-10-26 | 78 | 2 | |
18997 | 18997 | Mendocino | Mendocino | 45 | 2020-10-26 | 1136 | 21 | |
18998 | 18998 | Merced | Merced | 47 | 2020-10-26 | 9531 | 155 | |
18999 | 18999 | Modoc | Modoc | 49 | 2020-10-26 | 36 | 0 | |
19000 | 19000 | Mono | Mono | 51 | 2020-10-26 | 189 | 2 | |
19001 | 19001 | Monterey | Monterey | 53 | 2020-10-26 | 11419 | 90 | |
19002 | 19002 | Napa | Napa | 55 | 2020-10-26 | 1961 | 15 | |
19003 | 19003 | Nevada | Nevada | 57 | 2020-10-26 | 623 | 8 | |
19004 | 19004 | Orange | Orange | 59 | 2020-10-26 | 58725 | 1447 | |
19005 | 19005 | Placer | Placer | 61 | 2020-10-26 | 4178 | 57 | |
19006 | 19006 | Plumas | Plumas | 63 | 2020-10-26 | 70 | 0 | |
19007 | 19007 | Riverside | Riverside | 65 | 2020-10-26 | 66732 | 1295 | |
19008 | 19008 | Sacramento | Sacramento | 67 | 2020-10-26 | 25601 | 491 | |
19009 | 19009 | San Benito | San Benito | 69 | 2020-10-26 | 1442 | 15 | |
19010 | 19010 | San Bernardino | San Bernardino | 71 | 2020-10-26 | 62774 | 1209 | |
19011 | 19011 | San Diego | San Diego | 73 | 2020-10-26 | 54941 | 870 | |
19012 | 19012 | San Francisco | San Francisco | 75 | 2020-10-26 | 12152 | 140 | |
19013 | 19013 | San Joaquin | San Joaquin | 77 | 2020-10-26 | 21729 | 489 | |
19014 | 19014 | San Luis Obispo | San Luis Obispo | 79 | 2020-10-26 | 4174 | 32 | |
19015 | 19015 | San Mateo | San Mateo | 81 | 2020-10-26 | 11149 | 159 | |
19016 | 19016 | Santa Barbara | Santa Barbara | 83 | 2020-10-26 | 9820 | 122 | |
19017 | 19017 | Santa Clara | Santa Clara | 85 | 2020-10-26 | 24745 | 357 | |
19018 | 19018 | Santa Cruz | Santa Cruz | 87 | 2020-10-26 | 2808 | 25 | |
19019 | 19019 | Shasta | Shasta | 89 | 2020-10-26 | 1881 | 30 | |
19020 | 19020 | Sierra | Sierra | 91 | 2020-10-26 | 6 | 0 | |
19021 | 19021 | Siskiyou | Siskiyou | 93 | 2020-10-26 | 205 | 0 | |
19022 | 19022 | Solano | Solano | 95 | 2020-10-26 | 7384 | 76 | |
19023 | 19023 | Sonoma | Sonoma | 97 | 2020-10-26 | 9402 | 136 | |
19024 | 19024 | Stanislaus | Stanislaus | 99 | 2020-10-26 | 17686 | 397 | |
19025 | 19025 | Sutter | Sutter | 101 | 2020-10-26 | 1865 | 12 | |
19026 | 19026 | Tehama | Tehama | 103 | 2020-10-26 | 861 | 8 | |
19027 | 19027 | Trinity | Trinity | 105 | 2020-10-26 | 27 | 0 | |
19028 | 19028 | Tulare | Tulare | 107 | 2020-10-26 | 17590 | 288 | |
19029 | 19029 | Tuolumne | Tuolumne | 109 | 2020-10-26 | 275 | 4 | |
19030 | 19030 | Ventura | Ventura | 111 | 2020-10-26 | 14161 | 165 | |
19031 | 19031 | Yolo | Yolo | 113 | 2020-10-26 | 3207 | 59 | |
19032 | 19032 | Yuba | Yuba | 115 | 2020-10-26 | 1323 | 10 | |
19033 | 19033 | Alameda | Alameda | 1 | 2020-10-25 | 22540 | 443 | |
19034 | 19034 | Berkeley | Alameda | 1 | 2020-10-25 | 758 | 10 | |
19035 | 19035 | Alpine | Alpine | 3 | 2020-10-25 | 3 | 0 | TRUE |
19036 | 19036 | Amador | Amador | 5 | 2020-10-25 | 291 | 15 | TRUE |
19037 | 19037 | Butte | Butte | 7 | 2020-10-25 | 3087 | 52 | TRUE |
19038 | 19038 | Calaveras | Calaveras | 9 | 2020-10-25 | 342 | 18 | TRUE |
19039 | 19039 | Colusa | Colusa | 11 | 2020-10-25 | 550 | 6 | TRUE |
19040 | 19040 | Contra Costa | Contra Costa | 13 | 2020-10-25 | 18694 | 242 | |
19041 | 19041 | Del Norte | Del Norte | 15 | 2020-10-25 | 178 | 1 | TRUE |
19042 | 19042 | El Dorado | El Dorado | 17 | 2020-10-25 | 1315 | 4 | TRUE |
19043 | 19043 | Fresno | Fresno | 19 | 2020-10-25 | 33225 | 436 | |
19044 | 19044 | Glenn | Glenn | 21 | 2020-10-25 | 657 | 3 | TRUE |
19045 | 19045 | Humboldt | Humboldt | 23 | 2020-10-25 | 567 | 9 | TRUE |
19046 | 19046 | Imperial | Imperial | 25 | 2020-10-25 | 12700 | 336 | TRUE |
19047 | 19047 | Inyo | Inyo | 27 | 2020-10-25 | 227 | 15 | TRUE |
19048 | 19048 | Kern | Kern | 29 | 2020-10-25 | 33881 | 416 | |
19049 | 19049 | Kings | Kings | 31 | 2020-10-25 | 8207 | 83 | TRUE |
19050 | 19050 | Lake | Lake | 33 | 2020-10-25 | 689 | 15 | TRUE |
19051 | 19051 | Lassen | Lassen | 35 | 2020-10-25 | 766 | 1 | TRUE |
19052 | 19052 | Long Beach | Los Angeles | 37 | 2020-10-25 | 13013 | 255 | |
19053 | 19053 | Los Angeles | Los Angeles | 37 | 2020-10-25 | 283990 | 6609 | |
19054 | 19054 | Pasadena | Los Angeles | 37 | 2020-10-25 | 2757 | 129 | |
19055 | 19055 | Madera | Madera | 39 | 2020-10-25 | 4981 | 74 | TRUE |
19056 | 19056 | Marin | Marin | 41 | 2020-10-25 | 7089 | 128 | |
19057 | 19057 | Mariposa | Mariposa | 43 | 2020-10-25 | 78 | 2 | |
19058 | 19058 | Mendocino | Mendocino | 45 | 2020-10-25 | 1129 | 21 | |
19059 | 19059 | Merced | Merced | 47 | 2020-10-25 | 9465 | 155 | TRUE |
19060 | 19060 | Modoc | Modoc | 49 | 2020-10-25 | 29 | 0 | TRUE |
19061 | 19061 | Mono | Mono | 51 | 2020-10-25 | 189 | 2 | |
19062 | 19062 | Monterey | Monterey | 53 | 2020-10-25 | 11399 | 90 | |
19063 | 19063 | Napa | Napa | 55 | 2020-10-25 | 1937 | 14 | TRUE |
19064 | 19064 | Nevada | Nevada | 57 | 2020-10-25 | 608 | 8 | TRUE |
19065 | 19065 | Orange | Orange | 59 | 2020-10-25 | 58573 | 1447 | |
19066 | 19066 | Placer | Placer | 61 | 2020-10-25 | 4088 | 57 | TRUE |
19067 | 19067 | Plumas | Plumas | 63 | 2020-10-25 | 68 | 0 | TRUE |
19068 | 19068 | Riverside | Riverside | 65 | 2020-10-25 | 65757 | 1279 | TRUE |
19069 | 19069 | Sacramento | Sacramento | 67 | 2020-10-25 | 25264 | 484 | TRUE |
19070 | 19070 | San Benito | San Benito | 69 | 2020-10-25 | 1437 | 15 | |
19071 | 19071 | San Bernardino | San Bernardino | 71 | 2020-10-25 | 62619 | 1206 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );