latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
61 rows where "date" is on date 2021-05-10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
7016 | 7016 | Alameda | Alameda | 1 | 2021-05-10 | 84277 | 1217 | |
7017 | 7017 | Berkeley | Alameda | 1 | 2021-05-10 | 3599 | 46 | |
7018 | 7018 | Alpine | Alpine | 3 | 2021-05-10 | 88 | 0 | TRUE |
7019 | 7019 | Amador | Amador | 5 | 2021-05-10 | 3617 | 47 | TRUE |
7020 | 7020 | Butte | Butte | 7 | 2021-05-10 | 11993 | 182 | |
7021 | 7021 | Calaveras | Calaveras | 9 | 2021-05-10 | 2125 | 53 | |
7022 | 7022 | Colusa | Colusa | 11 | 2021-05-10 | 2232 | 16 | |
7023 | 7023 | Contra Costa | Contra Costa | 13 | 2021-05-10 | 68638 | 792 | |
7024 | 7024 | Del Norte | Del Norte | 15 | 2021-05-10 | 1380 | 7 | |
7025 | 7025 | El Dorado | El Dorado | 17 | 2021-05-10 | 10141 | 112 | |
7026 | 7026 | Fresno | Fresno | 19 | 2021-05-10 | 101261 | 1682 | |
7027 | 7027 | Glenn | Glenn | 21 | 2021-05-10 | 2323 | 25 | |
7028 | 7028 | Humboldt | Humboldt | 23 | 2021-05-10 | 3980 | 40 | |
7029 | 7029 | Imperial | Imperial | 25 | 2021-05-10 | 27837 | 721 | |
7030 | 7030 | Inyo | Inyo | 27 | 2021-05-10 | 1428 | 38 | |
7031 | 7031 | Kern | Kern | 29 | 2021-05-10 | 109052 | 1373 | |
7032 | 7032 | Kings | Kings | 31 | 2021-05-10 | 22977 | 246 | |
7033 | 7033 | Lake | Lake | 33 | 2021-05-10 | 3455 | 43 | |
7034 | 7034 | Lassen | Lassen | 35 | 2021-05-10 | 5701 | 24 | |
7035 | 7035 | Long Beach | Los Angeles | 37 | 2021-05-10 | 53107 | 932 | |
7036 | 7036 | Los Angeles | Los Angeles | 37 | 2021-05-10 | 1171463 | 22725 | |
7037 | 7037 | Pasadena | Los Angeles | 37 | 2021-05-10 | 11258 | 346 | |
7038 | 7038 | Madera | Madera | 39 | 2021-05-10 | 16348 | 242 | |
7039 | 7039 | Marin | Marin | 41 | 2021-05-10 | 14040 | 210 | |
7040 | 7040 | Mariposa | Mariposa | 43 | 2021-05-10 | 447 | 7 | |
7041 | 7041 | Mendocino | Mendocino | 45 | 2021-05-10 | 4072 | 49 | |
7042 | 7042 | Merced | Merced | 47 | 2021-05-10 | 31821 | 459 | |
7043 | 7043 | Modoc | Modoc | 49 | 2021-05-10 | 498 | 4 | |
7044 | 7044 | Mono | Mono | 51 | 2021-05-10 | 1280 | 4 | TRUE |
7045 | 7045 | Monterey | Monterey | 53 | 2021-05-10 | 43595 | 382 | |
7046 | 7046 | Napa | Napa | 55 | 2021-05-10 | 9857 | 77 | |
7047 | 7047 | Nevada | Nevada | 57 | 2021-05-10 | 4736 | 75 | |
7048 | 7048 | Orange | Orange | 59 | 2021-05-10 | 254357 | 5008 | |
7049 | 7049 | Placer | Placer | 61 | 2021-05-10 | 22610 | 291 | |
7050 | 7050 | Plumas | Plumas | 63 | 2021-05-10 | 710 | 6 | |
7051 | 7051 | Riverside | Riverside | 65 | 2021-05-10 | 299173 | 4588 | |
7052 | 7052 | Sacramento | Sacramento | 67 | 2021-05-10 | 104491 | 1676 | |
7053 | 7053 | San Benito | San Benito | 69 | 2021-05-10 | 6056 | 63 | |
7054 | 7054 | San Bernardino | San Bernardino | 71 | 2021-05-10 | 296655 | 4803 | |
7055 | 7055 | San Diego | San Diego | 73 | 2021-05-10 | 278182 | 3725 | |
7056 | 7056 | San Francisco | San Francisco | 75 | 2021-05-10 | 36320 | 538 | |
7057 | 7057 | San Joaquin | San Joaquin | 77 | 2021-05-10 | 73174 | 1391 | |
7058 | 7058 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-10 | 21208 | 260 | |
7059 | 7059 | San Mateo | San Mateo | 81 | 2021-05-10 | 41747 | 568 | TRUE |
7060 | 7060 | Santa Barbara | Santa Barbara | 83 | 2021-05-10 | 34323 | 450 | |
7061 | 7061 | Santa Clara | Santa Clara | 85 | 2021-05-10 | 117717 | 1686 | |
7062 | 7062 | Santa Cruz | Santa Cruz | 87 | 2021-05-10 | 16125 | 205 | |
7063 | 7063 | Shasta | Shasta | 89 | 2021-05-10 | 12110 | 226 | |
7064 | 7064 | Sierra | Sierra | 91 | 2021-05-10 | 112 | 0 | |
7065 | 7065 | Siskiyou | Siskiyou | 93 | 2021-05-10 | 2205 | 23 | |
7066 | 7066 | Solano | Solano | 95 | 2021-05-10 | 32864 | 216 | |
7067 | 7067 | Sonoma | Sonoma | 97 | 2021-05-10 | 30002 | 312 | |
7068 | 7068 | Stanislaus | Stanislaus | 99 | 2021-05-10 | 55427 | 1056 | |
7069 | 7069 | Sutter | Sutter | 101 | 2021-05-10 | 9421 | 105 | |
7070 | 7070 | Tehama | Tehama | 103 | 2021-05-10 | 5563 | 58 | TRUE |
7071 | 7071 | Trinity | Trinity | 105 | 2021-05-10 | 400 | 5 | |
7072 | 7072 | Tulare | Tulare | 107 | 2021-05-10 | 49579 | 839 | |
7073 | 7073 | Tuolumne | Tuolumne | 109 | 2021-05-10 | 4129 | 66 | |
7074 | 7074 | Ventura | Ventura | 111 | 2021-05-10 | 80905 | 1011 | |
7075 | 7075 | Yolo | Yolo | 113 | 2021-05-10 | 13821 | 207 | |
7076 | 7076 | Yuba | Yuba | 115 | 2021-05-10 | 6253 | 41 |
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 );