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-04-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
9151 | 9151 | Alameda | Alameda | 1 | 2021-04-05 | 81032 | 1204 | |
9152 | 9152 | Berkeley | Alameda | 1 | 2021-04-05 | 3472 | 46 | |
9153 | 9153 | Alpine | Alpine | 3 | 2021-04-05 | 88 | 0 | |
9154 | 9154 | Amador | Amador | 5 | 2021-04-05 | 3552 | 45 | |
9155 | 9155 | Butte | Butte | 7 | 2021-04-05 | 11384 | 178 | |
9156 | 9156 | Calaveras | Calaveras | 9 | 2021-04-05 | 2023 | 51 | |
9157 | 9157 | Colusa | Colusa | 11 | 2021-04-05 | 2170 | 16 | |
9158 | 9158 | Contra Costa | Contra Costa | 13 | 2021-04-05 | 65718 | 760 | |
9159 | 9159 | Del Norte | Del Norte | 15 | 2021-04-05 | 1229 | 5 | |
9160 | 9160 | El Dorado | El Dorado | 17 | 2021-04-05 | 9514 | 108 | |
9161 | 9161 | Fresno | Fresno | 19 | 2021-04-05 | 99426 | 1597 | |
9162 | 9162 | Glenn | Glenn | 21 | 2021-04-05 | 2276 | 25 | |
9163 | 9163 | Humboldt | Humboldt | 23 | 2021-04-05 | 3500 | 36 | |
9164 | 9164 | Imperial | Imperial | 25 | 2021-04-05 | 27283 | 715 | |
9165 | 9165 | Inyo | Inyo | 27 | 2021-04-05 | 1402 | 38 | |
9166 | 9166 | Kern | Kern | 29 | 2021-04-05 | 106480 | 1291 | |
9167 | 9167 | Kings | Kings | 31 | 2021-04-05 | 22669 | 241 | |
9168 | 9168 | Lake | Lake | 33 | 2021-04-05 | 3327 | 43 | |
9169 | 9169 | Lassen | Lassen | 35 | 2021-04-05 | 5656 | 24 | |
9170 | 9170 | Long Beach | Los Angeles | 37 | 2021-04-05 | 52322 | 914 | |
9171 | 9171 | Los Angeles | Los Angeles | 37 | 2021-04-05 | 1159003 | 22027 | |
9172 | 9172 | Pasadena | Los Angeles | 37 | 2021-04-05 | 11154 | 335 | |
9173 | 9173 | Madera | Madera | 39 | 2021-04-05 | 15976 | 234 | |
9174 | 9174 | Marin | Marin | 41 | 2021-04-05 | 13730 | 203 | |
9175 | 9175 | Mariposa | Mariposa | 43 | 2021-04-05 | 411 | 7 | |
9176 | 9176 | Mendocino | Mendocino | 45 | 2021-04-05 | 3958 | 46 | |
9177 | 9177 | Merced | Merced | 47 | 2021-04-05 | 30906 | 442 | |
9178 | 9178 | Modoc | Modoc | 49 | 2021-04-05 | 479 | 4 | |
9179 | 9179 | Mono | Mono | 51 | 2021-04-05 | 1268 | 4 | TRUE |
9180 | 9180 | Monterey | Monterey | 53 | 2021-04-05 | 43002 | 342 | |
9181 | 9181 | Napa | Napa | 55 | 2021-04-05 | 9499 | 75 | |
9182 | 9182 | Nevada | Nevada | 57 | 2021-04-05 | 4352 | 74 | |
9183 | 9183 | Orange | Orange | 59 | 2021-04-05 | 251310 | 4772 | |
9184 | 9184 | Placer | Placer | 61 | 2021-04-05 | 21188 | 277 | |
9185 | 9185 | Plumas | Plumas | 63 | 2021-04-05 | 686 | 6 | |
9186 | 9186 | Riverside | Riverside | 65 | 2021-04-05 | 295426 | 4389 | |
9187 | 9187 | Sacramento | Sacramento | 67 | 2021-04-05 | 98848 | 1617 | |
9188 | 9188 | San Benito | San Benito | 69 | 2021-04-05 | 5891 | 62 | |
9189 | 9189 | San Bernardino | San Bernardino | 71 | 2021-04-05 | 291727 | 4752 | |
9190 | 9190 | San Diego | San Diego | 73 | 2021-04-05 | 271654 | 3583 | |
9191 | 9191 | San Francisco | San Francisco | 75 | 2021-04-05 | 35312 | 482 | |
9192 | 9192 | San Joaquin | San Joaquin | 77 | 2021-04-05 | 70245 | 1313 | |
9193 | 9193 | San Luis Obispo | San Luis Obispo | 79 | 2021-04-05 | 20606 | 256 | |
9194 | 9194 | San Mateo | San Mateo | 81 | 2021-04-05 | 40595 | 553 | |
9195 | 9195 | Santa Barbara | Santa Barbara | 83 | 2021-04-05 | 33358 | 440 | |
9196 | 9196 | Santa Clara | Santa Clara | 85 | 2021-04-05 | 114509 | 1661 | |
9197 | 9197 | Santa Cruz | Santa Cruz | 87 | 2021-04-05 | 15247 | 200 | |
9198 | 9198 | Shasta | Shasta | 89 | 2021-04-05 | 11463 | 208 | |
9199 | 9199 | Sierra | Sierra | 91 | 2021-04-05 | 106 | 0 | |
9200 | 9200 | Siskiyou | Siskiyou | 93 | 2021-04-05 | 1888 | 16 | |
9201 | 9201 | Solano | Solano | 95 | 2021-04-05 | 31401 | 203 | |
9202 | 9202 | Sonoma | Sonoma | 97 | 2021-04-05 | 29372 | 309 | |
9203 | 9203 | Stanislaus | Stanislaus | 99 | 2021-04-05 | 53074 | 1004 | |
9204 | 9204 | Sutter | Sutter | 101 | 2021-04-05 | 9197 | 102 | |
9205 | 9205 | Tehama | Tehama | 103 | 2021-04-05 | 5324 | 54 | TRUE |
9206 | 9206 | Trinity | Trinity | 105 | 2021-04-05 | 393 | 5 | |
9207 | 9207 | Tulare | Tulare | 107 | 2021-04-05 | 49129 | 813 | |
9208 | 9208 | Tuolumne | Tuolumne | 109 | 2021-04-05 | 4044 | 62 | |
9209 | 9209 | Ventura | Ventura | 111 | 2021-04-05 | 79820 | 986 | |
9210 | 9210 | Yolo | Yolo | 113 | 2021-04-05 | 13314 | 198 | |
9211 | 9211 | Yuba | Yuba | 115 | 2021-04-05 | 6041 | 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 );