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-03-19 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 |
---|---|---|---|---|---|---|---|---|
10188 | 10188 | Alameda | Alameda | 1 | 2021-03-19 | 79545 | 1194 | |
10189 | 10189 | Berkeley | Alameda | 1 | 2021-03-19 | 3400 | 45 | |
10190 | 10190 | Alpine | Alpine | 3 | 2021-03-19 | 86 | 0 | TRUE |
10191 | 10191 | Amador | Amador | 5 | 2021-03-19 | 3484 | 44 | |
10192 | 10192 | Butte | Butte | 7 | 2021-03-19 | 11191 | 171 | |
10193 | 10193 | Calaveras | Calaveras | 9 | 2021-03-19 | 1968 | 50 | |
10194 | 10194 | Colusa | Colusa | 11 | 2021-03-19 | 2156 | 15 | |
10195 | 10195 | Contra Costa | Contra Costa | 13 | 2021-03-19 | 64454 | 730 | |
10196 | 10196 | Del Norte | Del Norte | 15 | 2021-03-19 | 1095 | 5 | |
10197 | 10197 | El Dorado | El Dorado | 17 | 2021-03-19 | 9340 | 107 | |
10198 | 10198 | Fresno | Fresno | 19 | 2021-03-19 | 98096 | 1546 | TRUE |
10199 | 10199 | Glenn | Glenn | 21 | 2021-03-19 | 2229 | 24 | |
10200 | 10200 | Humboldt | Humboldt | 23 | 2021-03-19 | 3419 | 35 | |
10201 | 10201 | Imperial | Imperial | 25 | 2021-03-19 | 26851 | 691 | |
10202 | 10202 | Inyo | Inyo | 27 | 2021-03-19 | 1377 | 37 | |
10203 | 10203 | Kern | Kern | 29 | 2021-03-19 | 105368 | 1032 | |
10204 | 10204 | Kings | Kings | 31 | 2021-03-19 | 22459 | 237 | |
10205 | 10205 | Lake | Lake | 33 | 2021-03-19 | 3240 | 43 | |
10206 | 10206 | Lassen | Lassen | 35 | 2021-03-19 | 5634 | 24 | |
10207 | 10207 | Long Beach | Los Angeles | 37 | 2021-03-19 | 51691 | 887 | |
10208 | 10208 | Los Angeles | Los Angeles | 37 | 2021-03-19 | 1150518 | 21505 | |
10209 | 10209 | Pasadena | Los Angeles | 37 | 2021-03-19 | 11072 | 329 | |
10210 | 10210 | Madera | Madera | 39 | 2021-03-19 | 15788 | 226 | |
10211 | 10211 | Marin | Marin | 41 | 2021-03-19 | 13507 | 202 | |
10212 | 10212 | Mariposa | Mariposa | 43 | 2021-03-19 | 400 | 7 | |
10213 | 10213 | Mendocino | Mendocino | 45 | 2021-03-19 | 3899 | 46 | |
10214 | 10214 | Merced | Merced | 47 | 2021-03-19 | 30142 | 428 | |
10215 | 10215 | Modoc | Modoc | 49 | 2021-03-19 | 467 | 4 | |
10216 | 10216 | Mono | Mono | 51 | 2021-03-19 | 1240 | 4 | |
10217 | 10217 | Monterey | Monterey | 53 | 2021-03-19 | 42712 | 337 | |
10218 | 10218 | Napa | Napa | 55 | 2021-03-19 | 9247 | 74 | |
10219 | 10219 | Nevada | Nevada | 57 | 2021-03-19 | 4162 | 74 | |
10220 | 10220 | Orange | Orange | 59 | 2021-03-19 | 249308 | 4536 | |
10221 | 10221 | Placer | Placer | 61 | 2021-03-19 | 20493 | 244 | |
10222 | 10222 | Plumas | Plumas | 63 | 2021-03-19 | 670 | 6 | TRUE |
10223 | 10223 | Riverside | Riverside | 65 | 2021-03-19 | 292967 | 4117 | |
10224 | 10224 | Sacramento | Sacramento | 67 | 2021-03-19 | 95964 | 1576 | |
10225 | 10225 | San Benito | San Benito | 69 | 2021-03-19 | 5817 | 61 | |
10226 | 10226 | San Bernardino | San Bernardino | 71 | 2021-03-19 | 289405 | 4703 | |
10227 | 10227 | San Diego | San Diego | 73 | 2021-03-19 | 267177 | 3491 | |
10228 | 10228 | San Francisco | San Francisco | 75 | 2021-03-19 | 34677 | 451 | |
10229 | 10229 | San Joaquin | San Joaquin | 77 | 2021-03-19 | 68714 | 1229 | |
10230 | 10230 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-19 | 20189 | 253 | |
10231 | 10231 | San Mateo | San Mateo | 81 | 2021-03-19 | 39660 | 543 | |
10232 | 10232 | Santa Barbara | Santa Barbara | 83 | 2021-03-19 | 32798 | 435 | |
10233 | 10233 | Santa Clara | Santa Clara | 85 | 2021-03-19 | 112711 | 1636 | |
10234 | 10234 | Santa Cruz | Santa Cruz | 87 | 2021-03-19 | 15196 | 197 | |
10235 | 10235 | Shasta | Shasta | 89 | 2021-03-19 | 11113 | 195 | TRUE |
10236 | 10236 | Sierra | Sierra | 91 | 2021-03-19 | 101 | 0 | TRUE |
10237 | 10237 | Siskiyou | Siskiyou | 93 | 2021-03-19 | 1850 | 14 | |
10238 | 10238 | Solano | Solano | 95 | 2021-03-19 | 30745 | 181 | |
10239 | 10239 | Sonoma | Sonoma | 97 | 2021-03-19 | 28882 | 308 | TRUE |
10240 | 10240 | Stanislaus | Stanislaus | 99 | 2021-03-19 | 51938 | 979 | |
10241 | 10241 | Sutter | Sutter | 101 | 2021-03-19 | 9042 | 101 | |
10242 | 10242 | Tehama | Tehama | 103 | 2021-03-19 | 5213 | 54 | |
10243 | 10243 | Trinity | Trinity | 105 | 2021-03-19 | 384 | 5 | |
10244 | 10244 | Tulare | Tulare | 107 | 2021-03-19 | 48770 | 793 | |
10245 | 10245 | Tuolumne | Tuolumne | 109 | 2021-03-19 | 4008 | 59 | |
10246 | 10246 | Ventura | Ventura | 111 | 2021-03-19 | 79090 | 943 | |
10247 | 10247 | Yolo | Yolo | 113 | 2021-03-19 | 13064 | 191 | |
10248 | 10248 | Yuba | Yuba | 115 | 2021-03-19 | 5903 | 40 |
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 );