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 2020-05-12 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29159 | 29159 | Alameda | Alameda | 1 | 2020-05-12 | 2070 | 109 | |
29160 | 29160 | Berkeley | Alameda | 1 | 2020-05-12 | 68 | 1 | |
29161 | 29161 | Alpine | Alpine | 3 | 2020-05-12 | 1 | 0 | TRUE |
29162 | 29162 | Amador | Amador | 5 | 2020-05-12 | 9 | 0 | |
29163 | 29163 | Butte | Butte | 7 | 2020-05-12 | 20 | 0 | |
29164 | 29164 | Calaveras | Calaveras | 9 | 2020-05-12 | 13 | 0 | TRUE |
29165 | 29165 | Colusa | Colusa | 11 | 2020-05-12 | 3 | 0 | |
29166 | 29166 | Contra Costa | Contra Costa | 13 | 2020-05-12 | 1057 | 32 | |
29167 | 29167 | Del Norte | Del Norte | 15 | 2020-05-12 | 3 | 0 | |
29168 | 29168 | El Dorado | El Dorado | 17 | 2020-05-12 | 60 | 0 | |
29169 | 29169 | Fresno | Fresno | 19 | 2020-05-12 | 1773 | 10 | |
29170 | 29170 | Glenn | Glenn | 21 | 2020-05-12 | 6 | 0 | |
29171 | 29171 | Humboldt | Humboldt | 23 | 2020-05-12 | 64 | 0 | |
29172 | 29172 | Imperial | Imperial | 25 | 2020-05-12 | 603 | 13 | |
29173 | 29173 | Inyo | Inyo | 27 | 2020-05-12 | 19 | 1 | |
29174 | 29174 | Kern | Kern | 29 | 2020-05-12 | 1316 | 17 | |
29175 | 29175 | Kings | Kings | 31 | 2020-05-12 | 325 | 1 | |
29176 | 29176 | Lake | Lake | 33 | 2020-05-12 | 8 | 0 | |
29177 | 29177 | Lassen | Lassen | 35 | 2020-05-12 | 0 | 0 | |
29178 | 29178 | Long Beach | Los Angeles | 37 | 2020-05-12 | 984 | 48 | |
29179 | 29179 | Los Angeles | Los Angeles | 37 | 2020-05-12 | 31670 | 1503 | |
29180 | 29180 | Pasadena | Los Angeles | 37 | 2020-05-12 | 593 | 66 | |
29181 | 29181 | Madera | Madera | 39 | 2020-05-12 | 69 | 2 | |
29182 | 29182 | Marin | Marin | 41 | 2020-05-12 | 271 | 14 | |
29183 | 29183 | Mariposa | Mariposa | 43 | 2020-05-12 | 15 | 0 | |
29184 | 29184 | Mendocino | Mendocino | 45 | 2020-05-12 | 12 | 0 | TRUE |
29185 | 29185 | Merced | Merced | 47 | 2020-05-12 | 177 | 4 | |
29186 | 29186 | Modoc | Modoc | 49 | 2020-05-12 | 0 | 0 | TRUE |
29187 | 29187 | Mono | Mono | 51 | 2020-05-12 | 32 | 1 | |
29188 | 29188 | Monterey | Monterey | 53 | 2020-05-12 | 299 | 6 | |
29189 | 29189 | Napa | Napa | 55 | 2020-05-12 | 81 | 3 | |
29190 | 29190 | Nevada | Nevada | 57 | 2020-05-12 | 41 | 1 | |
29191 | 29191 | Orange | Orange | 59 | 2020-05-12 | 3602 | 77 | |
29192 | 29192 | Placer | Placer | 61 | 2020-05-12 | 170 | 8 | |
29193 | 29193 | Plumas | Plumas | 63 | 2020-05-12 | 4 | 0 | |
29194 | 29194 | Riverside | Riverside | 65 | 2020-05-12 | 5248 | 225 | |
29195 | 29195 | Sacramento | Sacramento | 67 | 2020-05-12 | 1181 | 50 | |
29196 | 29196 | San Benito | San Benito | 69 | 2020-05-12 | 58 | 2 | |
29197 | 29197 | San Bernardino | San Bernardino | 71 | 2020-05-12 | 3078 | 153 | |
29198 | 29198 | San Diego | San Diego | 73 | 2020-05-12 | 5161 | 190 | |
29199 | 29199 | San Francisco | San Francisco | 75 | 2020-05-12 | 1977 | 35 | |
29200 | 29200 | San Joaquin | San Joaquin | 77 | 2020-05-12 | 628 | 30 | |
29201 | 29201 | San Luis Obispo | San Luis Obispo | 79 | 2020-05-12 | 227 | 1 | |
29202 | 29202 | San Mateo | San Mateo | 81 | 2020-05-12 | 1497 | 65 | |
29203 | 29203 | Santa Barbara | Santa Barbara | 83 | 2020-05-12 | 1371 | 11 | |
29204 | 29204 | Santa Clara | Santa Clara | 85 | 2020-05-12 | 2409 | 131 | |
29205 | 29205 | Santa Cruz | Santa Cruz | 87 | 2020-05-12 | 146 | 2 | |
29206 | 29206 | Shasta | Shasta | 89 | 2020-05-12 | 32 | 4 | |
29207 | 29207 | Sierra | Sierra | 91 | 2020-05-12 | 0 | 0 | |
29208 | 29208 | Siskiyou | Siskiyou | 93 | 2020-05-12 | 5 | 0 | |
29209 | 29209 | Solano | Solano | 95 | 2020-05-12 | 388 | 11 | |
29210 | 29210 | Sonoma | Sonoma | 97 | 2020-05-12 | 333 | 4 | |
29211 | 29211 | Stanislaus | Stanislaus | 99 | 2020-05-12 | 517 | 22 | |
29212 | 29212 | Sutter | Sutter | 101 | 2020-05-12 | 35 | 2 | |
29213 | 29213 | Tehama | Tehama | 103 | 2020-05-12 | 1 | 1 | |
29214 | 29214 | Trinity | Trinity | 105 | 2020-05-12 | 1 | 0 | |
29215 | 29215 | Tulare | Tulare | 107 | 2020-05-12 | 1241 | 52 | |
29216 | 29216 | Tuolumne | Tuolumne | 109 | 2020-05-12 | 2 | 0 | |
29217 | 29217 | Ventura | Ventura | 111 | 2020-05-12 | 700 | 21 | |
29218 | 29218 | Yolo | Yolo | 113 | 2020-05-12 | 177 | 22 | |
29219 | 29219 | Yuba | Yuba | 115 | 2020-05-12 | 23 | 1 |
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 );