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-07-28 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 |
---|---|---|---|---|---|---|---|---|
2197 | 2197 | Alameda | Alameda | 1 | 2021-07-28 | 91616 | 1230 | |
2198 | 2198 | Berkeley | Alameda | 1 | 2021-07-28 | 3923 | 50 | |
2199 | 2199 | Alpine | Alpine | 3 | 2021-07-28 | 89 | 0 | TRUE |
2200 | 2200 | Amador | Amador | 5 | 2021-07-28 | 3832 | 48 | |
2201 | 2201 | Butte | Butte | 7 | 2021-07-28 | 13184 | 200 | TRUE |
2202 | 2202 | Calaveras | Calaveras | 9 | 2021-07-28 | 2295 | 58 | |
2203 | 2203 | Colusa | Colusa | 11 | 2021-07-28 | 2357 | 18 | TRUE |
2204 | 2204 | Contra Costa | Contra Costa | 13 | 2021-07-28 | 75842 | 830 | |
2205 | 2205 | Del Norte | Del Norte | 15 | 2021-07-28 | 1612 | 8 | |
2206 | 2206 | El Dorado | El Dorado | 17 | 2021-07-28 | 11010 | 120 | |
2207 | 2207 | Fresno | Fresno | 19 | 2021-07-28 | 104288 | 1746 | |
2208 | 2208 | Glenn | Glenn | 21 | 2021-07-28 | 2391 | 27 | |
2209 | 2209 | Humboldt | Humboldt | 23 | 2021-07-28 | 5010 | 53 | |
2210 | 2210 | Imperial | Imperial | 25 | 2021-07-28 | 28785 | 745 | |
2211 | 2211 | Inyo | Inyo | 27 | 2021-07-28 | 1453 | 38 | TRUE |
2212 | 2212 | Kern | Kern | 29 | 2021-07-28 | 112933 | 1420 | |
2213 | 2213 | Kings | Kings | 31 | 2021-07-28 | 23566 | 250 | |
2214 | 2214 | Lake | Lake | 33 | 2021-07-28 | 4074 | 65 | TRUE |
2215 | 2215 | Lassen | Lassen | 35 | 2021-07-28 | 5876 | 26 | |
2216 | 2216 | Long Beach | Los Angeles | 37 | 2021-07-28 | 55643 | 951 | |
2217 | 2217 | Los Angeles | Los Angeles | 37 | 2021-07-28 | 1222967 | 23355 | |
2218 | 2218 | Pasadena | Los Angeles | 37 | 2021-07-28 | 11785 | 352 | |
2219 | 2219 | Madera | Madera | 39 | 2021-07-28 | 16911 | 249 | TRUE |
2220 | 2220 | Marin | Marin | 41 | 2021-07-28 | 14791 | 214 | |
2221 | 2221 | Mariposa | Mariposa | 43 | 2021-07-28 | 497 | 7 | |
2222 | 2222 | Mendocino | Mendocino | 45 | 2021-07-28 | 4658 | 51 | |
2223 | 2223 | Merced | Merced | 47 | 2021-07-28 | 32961 | 484 | TRUE |
2224 | 2224 | Modoc | Modoc | 49 | 2021-07-28 | 573 | 7 | TRUE |
2225 | 2225 | Mono | Mono | 51 | 2021-07-28 | 1319 | 5 | |
2226 | 2226 | Monterey | Monterey | 53 | 2021-07-28 | 44438 | 526 | |
2227 | 2227 | Napa | Napa | 55 | 2021-07-28 | 10400 | 81 | |
2228 | 2228 | Nevada | Nevada | 57 | 2021-07-28 | 5324 | 75 | |
2229 | 2229 | Orange | Orange | 59 | 2021-07-28 | 263056 | 5140 | |
2230 | 2230 | Placer | Placer | 61 | 2021-07-28 | 24955 | 307 | TRUE |
2231 | 2231 | Plumas | Plumas | 63 | 2021-07-28 | 765 | 6 | TRUE |
2232 | 2232 | Riverside | Riverside | 65 | 2021-07-28 | 306836 | 4659 | TRUE |
2233 | 2233 | Sacramento | Sacramento | 67 | 2021-07-28 | 114652 | 1775 | |
2234 | 2234 | San Benito | San Benito | 69 | 2021-07-28 | 6263 | 63 | |
2235 | 2235 | San Bernardino | San Bernardino | 71 | 2021-07-28 | 305827 | 4856 | |
2236 | 2236 | San Diego | San Diego | 73 | 2021-07-28 | 294176 | 3798 | |
2237 | 2237 | San Francisco | San Francisco | 75 | 2021-07-28 | 39759 | 561 | |
2238 | 2238 | San Joaquin | San Joaquin | 77 | 2021-07-28 | 76915 | 1460 | |
2239 | 2239 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-28 | 21970 | 265 | TRUE |
2240 | 2240 | San Mateo | San Mateo | 81 | 2021-07-28 | 44287 | 588 | |
2241 | 2241 | Santa Barbara | Santa Barbara | 83 | 2021-07-28 | 35546 | 461 | |
2242 | 2242 | Santa Clara | Santa Clara | 85 | 2021-07-28 | 122821 | 1707 | |
2243 | 2243 | Santa Cruz | Santa Cruz | 87 | 2021-07-28 | 16532 | 207 | TRUE |
2244 | 2244 | Shasta | Shasta | 89 | 2021-07-28 | 12925 | 242 | |
2245 | 2245 | Sierra | Sierra | 91 | 2021-07-28 | 126 | 0 | TRUE |
2246 | 2246 | Siskiyou | Siskiyou | 93 | 2021-07-28 | 2554 | 40 | |
2247 | 2247 | Solano | Solano | 95 | 2021-07-28 | 35703 | 249 | |
2248 | 2248 | Sonoma | Sonoma | 97 | 2021-07-28 | 32526 | 329 | |
2249 | 2249 | Stanislaus | Stanislaus | 99 | 2021-07-28 | 58898 | 1088 | |
2250 | 2250 | Sutter | Sutter | 101 | 2021-07-28 | 10126 | 111 | |
2251 | 2251 | Tehama | Tehama | 103 | 2021-07-28 | 5864 | 66 | |
2252 | 2252 | Trinity | Trinity | 105 | 2021-07-28 | 459 | 6 | |
2253 | 2253 | Tulare | Tulare | 107 | 2021-07-28 | 50278 | 853 | |
2254 | 2254 | Tuolumne | Tuolumne | 109 | 2021-07-28 | 4461 | 73 | |
2255 | 2255 | Ventura | Ventura | 111 | 2021-07-28 | 83523 | 1036 | |
2256 | 2256 | Yolo | Yolo | 113 | 2021-07-28 | 14755 | 213 | |
2257 | 2257 | Yuba | Yuba | 115 | 2021-07-28 | 6949 | 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 );