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-07 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
7199 | 7199 | Alameda | Alameda | 1 | 2021-05-07 | 84042 | 1217 | |
7200 | 7200 | Berkeley | Alameda | 1 | 2021-05-07 | 3588 | 46 | |
7201 | 7201 | Alpine | Alpine | 3 | 2021-05-07 | 88 | 0 | |
7202 | 7202 | Amador | Amador | 5 | 2021-05-07 | 3617 | 47 | |
7203 | 7203 | Butte | Butte | 7 | 2021-05-07 | 11943 | 182 | |
7204 | 7204 | Calaveras | Calaveras | 9 | 2021-05-07 | 2121 | 53 | |
7205 | 7205 | Colusa | Colusa | 11 | 2021-05-07 | 2230 | 16 | |
7206 | 7206 | Contra Costa | Contra Costa | 13 | 2021-05-07 | 68437 | 789 | |
7207 | 7207 | Del Norte | Del Norte | 15 | 2021-05-07 | 1367 | 7 | |
7208 | 7208 | El Dorado | El Dorado | 17 | 2021-05-07 | 10111 | 112 | |
7209 | 7209 | Fresno | Fresno | 19 | 2021-05-07 | 101156 | 1680 | |
7210 | 7210 | Glenn | Glenn | 21 | 2021-05-07 | 2321 | 25 | |
7211 | 7211 | Humboldt | Humboldt | 23 | 2021-05-07 | 3935 | 39 | |
7212 | 7212 | Imperial | Imperial | 25 | 2021-05-07 | 27837 | 718 | |
7213 | 7213 | Inyo | Inyo | 27 | 2021-05-07 | 1426 | 38 | |
7214 | 7214 | Kern | Kern | 29 | 2021-05-07 | 108968 | 1367 | |
7215 | 7215 | Kings | Kings | 31 | 2021-05-07 | 22948 | 246 | |
7216 | 7216 | Lake | Lake | 33 | 2021-05-07 | 3447 | 43 | |
7217 | 7217 | Lassen | Lassen | 35 | 2021-05-07 | 5698 | 24 | |
7218 | 7218 | Long Beach | Los Angeles | 37 | 2021-05-07 | 53082 | 932 | |
7219 | 7219 | Los Angeles | Los Angeles | 37 | 2021-05-07 | 1170816 | 22703 | |
7220 | 7220 | Pasadena | Los Angeles | 37 | 2021-05-07 | 11252 | 346 | |
7221 | 7221 | Madera | Madera | 39 | 2021-05-07 | 16337 | 242 | |
7222 | 7222 | Marin | Marin | 41 | 2021-05-07 | 14030 | 210 | |
7223 | 7223 | Mariposa | Mariposa | 43 | 2021-05-07 | 445 | 7 | |
7224 | 7224 | Mendocino | Mendocino | 45 | 2021-05-07 | 4061 | 49 | |
7225 | 7225 | Merced | Merced | 47 | 2021-05-07 | 31743 | 458 | |
7226 | 7226 | Modoc | Modoc | 49 | 2021-05-07 | 495 | 4 | |
7227 | 7227 | Mono | Mono | 51 | 2021-05-07 | 1280 | 4 | |
7228 | 7228 | Monterey | Monterey | 53 | 2021-05-07 | 43563 | 382 | |
7229 | 7229 | Napa | Napa | 55 | 2021-05-07 | 9846 | 77 | |
7230 | 7230 | Nevada | Nevada | 57 | 2021-05-07 | 4707 | 75 | |
7231 | 7231 | Orange | Orange | 59 | 2021-05-07 | 254231 | 5000 | |
7232 | 7232 | Placer | Placer | 61 | 2021-05-07 | 22550 | 290 | |
7233 | 7233 | Plumas | Plumas | 63 | 2021-05-07 | 706 | 6 | |
7234 | 7234 | Riverside | Riverside | 65 | 2021-05-07 | 299064 | 4587 | |
7235 | 7235 | Sacramento | Sacramento | 67 | 2021-05-07 | 104176 | 1672 | |
7236 | 7236 | San Benito | San Benito | 69 | 2021-05-07 | 6045 | 63 | |
7237 | 7237 | San Bernardino | San Bernardino | 71 | 2021-05-07 | 296425 | 4800 | |
7238 | 7238 | San Diego | San Diego | 73 | 2021-05-07 | 277533 | 3718 | |
7239 | 7239 | San Francisco | San Francisco | 75 | 2021-05-07 | 36260 | 538 | |
7240 | 7240 | San Joaquin | San Joaquin | 77 | 2021-05-07 | 73009 | 1391 | |
7241 | 7241 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-07 | 21208 | 260 | |
7242 | 7242 | San Mateo | San Mateo | 81 | 2021-05-07 | 41747 | 568 | |
7243 | 7243 | Santa Barbara | Santa Barbara | 83 | 2021-05-07 | 34291 | 450 | |
7244 | 7244 | Santa Clara | Santa Clara | 85 | 2021-05-07 | 117623 | 1685 | |
7245 | 7245 | Santa Cruz | Santa Cruz | 87 | 2021-05-07 | 16125 | 205 | |
7246 | 7246 | Shasta | Shasta | 89 | 2021-05-07 | 12071 | 226 | |
7247 | 7247 | Sierra | Sierra | 91 | 2021-05-07 | 112 | 0 | |
7248 | 7248 | Siskiyou | Siskiyou | 93 | 2021-05-07 | 2181 | 23 | |
7249 | 7249 | Solano | Solano | 95 | 2021-05-07 | 32752 | 216 | |
7250 | 7250 | Sonoma | Sonoma | 97 | 2021-05-07 | 29951 | 312 | |
7251 | 7251 | Stanislaus | Stanislaus | 99 | 2021-05-07 | 55285 | 1055 | |
7252 | 7252 | Sutter | Sutter | 101 | 2021-05-07 | 9411 | 105 | |
7253 | 7253 | Tehama | Tehama | 103 | 2021-05-07 | 5553 | 58 | |
7254 | 7254 | Trinity | Trinity | 105 | 2021-05-07 | 399 | 5 | |
7255 | 7255 | Tulare | Tulare | 107 | 2021-05-07 | 49554 | 839 | |
7256 | 7256 | Tuolumne | Tuolumne | 109 | 2021-05-07 | 4123 | 64 | |
7257 | 7257 | Ventura | Ventura | 111 | 2021-05-07 | 80842 | 1011 | |
7258 | 7258 | Yolo | Yolo | 113 | 2021-05-07 | 13793 | 207 | |
7259 | 7259 | Yuba | Yuba | 115 | 2021-05-07 | 6221 | 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 );