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-06-30 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 |
---|---|---|---|---|---|---|---|---|
26170 | 26170 | Alameda | Alameda | 1 | 2020-06-30 | 5931 | 180 | |
26171 | 26171 | Berkeley | Alameda | 1 | 2020-06-30 | 157 | 2 | |
26172 | 26172 | Alpine | Alpine | 3 | 2020-06-30 | 1 | 0 | TRUE |
26173 | 26173 | Amador | Amador | 5 | 2020-06-30 | 22 | 0 | |
26174 | 26174 | Butte | Butte | 7 | 2020-06-30 | 163 | 2 | |
26175 | 26175 | Calaveras | Calaveras | 9 | 2020-06-30 | 40 | 0 | TRUE |
26176 | 26176 | Colusa | Colusa | 11 | 2020-06-30 | 50 | 0 | |
26177 | 26177 | Contra Costa | Contra Costa | 13 | 2020-06-30 | 3132 | 76 | |
26178 | 26178 | Del Norte | Del Norte | 15 | 2020-06-30 | 51 | 0 | |
26179 | 26179 | El Dorado | El Dorado | 17 | 2020-06-30 | 184 | 0 | |
26180 | 26180 | Fresno | Fresno | 19 | 2020-06-30 | 9764 | 73 | |
26181 | 26181 | Glenn | Glenn | 21 | 2020-06-30 | 112 | 0 | |
26182 | 26182 | Humboldt | Humboldt | 23 | 2020-06-30 | 133 | 4 | |
26183 | 26183 | Imperial | Imperial | 25 | 2020-06-30 | 6242 | 93 | |
26184 | 26184 | Inyo | Inyo | 27 | 2020-06-30 | 31 | 1 | |
26185 | 26185 | Kern | Kern | 29 | 2020-06-30 | 4655 | 70 | |
26186 | 26186 | Kings | Kings | 31 | 2020-06-30 | 2417 | 30 | |
26187 | 26187 | Lake | Lake | 33 | 2020-06-30 | 60 | 0 | |
26188 | 26188 | Lassen | Lassen | 35 | 2020-06-30 | 233 | 0 | |
26189 | 26189 | Long Beach | Los Angeles | 37 | 2020-06-30 | 4120 | 132 | |
26190 | 26190 | Los Angeles | Los Angeles | 37 | 2020-06-30 | 98424 | 3150 | |
26191 | 26191 | Pasadena | Los Angeles | 37 | 2020-06-30 | 1328 | 91 | |
26192 | 26192 | Madera | Madera | 39 | 2020-06-30 | 519 | 5 | |
26193 | 26193 | Marin | Marin | 41 | 2020-06-30 | 2289 | 18 | |
26194 | 26194 | Mariposa | Mariposa | 43 | 2020-06-30 | 26 | 1 | |
26195 | 26195 | Mendocino | Mendocino | 45 | 2020-06-30 | 83 | 0 | |
26196 | 26196 | Merced | Merced | 47 | 2020-06-30 | 1064 | 11 | |
26197 | 26197 | Modoc | Modoc | 49 | 2020-06-30 | 0 | 0 | TRUE |
26198 | 26198 | Mono | Mono | 51 | 2020-06-30 | 41 | 1 | |
26199 | 26199 | Monterey | Monterey | 53 | 2020-06-30 | 1642 | 15 | |
26200 | 26200 | Napa | Napa | 55 | 2020-06-30 | 317 | 4 | |
26201 | 26201 | Nevada | Nevada | 57 | 2020-06-30 | 116 | 1 | |
26202 | 26202 | Orange | Orange | 59 | 2020-06-30 | 13843 | 340 | |
26203 | 26203 | Placer | Placer | 61 | 2020-06-30 | 684 | 11 | |
26204 | 26204 | Plumas | Plumas | 63 | 2020-06-30 | 9 | 0 | |
26205 | 26205 | Riverside | Riverside | 65 | 2020-06-30 | 17296 | 457 | |
26206 | 26206 | Sacramento | Sacramento | 67 | 2020-06-30 | 3223 | 68 | |
26207 | 26207 | San Benito | San Benito | 69 | 2020-06-30 | 233 | 2 | |
26208 | 26208 | San Bernardino | San Bernardino | 71 | 2020-06-30 | 12550 | 330 | |
26209 | 26209 | San Diego | San Diego | 73 | 2020-06-30 | 14149 | 365 | |
26210 | 26210 | San Francisco | San Francisco | 75 | 2020-06-30 | 3603 | 50 | |
26211 | 26211 | San Joaquin | San Joaquin | 77 | 2020-06-30 | 3899 | 52 | |
26212 | 26212 | San Luis Obispo | San Luis Obispo | 79 | 2020-06-30 | 611 | 1 | |
26213 | 26213 | San Mateo | San Mateo | 81 | 2020-06-30 | 3232 | 108 | |
26214 | 26214 | Santa Barbara | Santa Barbara | 83 | 2020-06-30 | 2896 | 29 | TRUE |
26215 | 26215 | Santa Clara | Santa Clara | 85 | 2020-06-30 | 5107 | 156 | |
26216 | 26216 | Santa Cruz | Santa Cruz | 87 | 2020-06-30 | 379 | 3 | |
26217 | 26217 | Shasta | Shasta | 89 | 2020-06-30 | 118 | 4 | |
26218 | 26218 | Sierra | Sierra | 91 | 2020-06-30 | 1 | 0 | |
26219 | 26219 | Siskiyou | Siskiyou | 93 | 2020-06-30 | 29 | 0 | |
26220 | 26220 | Solano | Solano | 95 | 2020-06-30 | 1288 | 24 | |
26221 | 26221 | Sonoma | Sonoma | 97 | 2020-06-30 | 1185 | 7 | |
26222 | 26222 | Stanislaus | Stanislaus | 99 | 2020-06-30 | 2255 | 44 | |
26223 | 26223 | Sutter | Sutter | 101 | 2020-06-30 | 190 | 3 | |
26224 | 26224 | Tehama | Tehama | 103 | 2020-06-30 | 78 | 1 | |
26225 | 26225 | Trinity | Trinity | 105 | 2020-06-30 | 2 | 0 | |
26226 | 26226 | Tulare | Tulare | 107 | 2020-06-30 | 4156 | 126 | |
26227 | 26227 | Tuolumne | Tuolumne | 109 | 2020-06-30 | 30 | 0 | |
26228 | 26228 | Ventura | Ventura | 111 | 2020-06-30 | 2926 | 46 | |
26229 | 26229 | Yolo | Yolo | 113 | 2020-06-30 | 526 | 24 | |
26230 | 26230 | Yuba | Yuba | 115 | 2020-06-30 | 75 | 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 );