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-06-25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
4210 | 4210 | Alameda | Alameda | 1 | 2021-06-25 | 86272 | 1217 | |
4211 | 4211 | Berkeley | Alameda | 1 | 2021-06-25 | 3664 | 50 | |
4212 | 4212 | Alpine | Alpine | 3 | 2021-06-25 | 89 | 0 | TRUE |
4213 | 4213 | Amador | Amador | 5 | 2021-06-25 | 3714 | 47 | |
4214 | 4214 | Butte | Butte | 7 | 2021-06-25 | 12682 | 194 | TRUE |
4215 | 4215 | Calaveras | Calaveras | 9 | 2021-06-25 | 2210 | 56 | |
4216 | 4216 | Colusa | Colusa | 11 | 2021-06-25 | 2288 | 18 | TRUE |
4217 | 4217 | Contra Costa | Contra Costa | 13 | 2021-06-25 | 70945 | 814 | |
4218 | 4218 | Del Norte | Del Norte | 15 | 2021-06-25 | 1468 | 7 | |
4219 | 4219 | El Dorado | El Dorado | 17 | 2021-06-25 | 10428 | 117 | |
4220 | 4220 | Fresno | Fresno | 19 | 2021-06-25 | 102442 | 1727 | |
4221 | 4221 | Glenn | Glenn | 21 | 2021-06-25 | 2365 | 27 | |
4222 | 4222 | Humboldt | Humboldt | 23 | 2021-06-25 | 4533 | 50 | |
4223 | 4223 | Imperial | Imperial | 25 | 2021-06-25 | 28348 | 741 | |
4224 | 4224 | Inyo | Inyo | 27 | 2021-06-25 | 1434 | 38 | TRUE |
4225 | 4225 | Kern | Kern | 29 | 2021-06-25 | 110948 | 1405 | |
4226 | 4226 | Kings | Kings | 31 | 2021-06-25 | 23093 | 247 | |
4227 | 4227 | Lake | Lake | 33 | 2021-06-25 | 3561 | 45 | TRUE |
4228 | 4228 | Lassen | Lassen | 35 | 2021-06-25 | 5809 | 26 | |
4229 | 4229 | Long Beach | Los Angeles | 37 | 2021-06-25 | 53607 | 945 | |
4230 | 4230 | Los Angeles | Los Angeles | 37 | 2021-06-25 | 1183829 | 23174 | |
4231 | 4231 | Pasadena | Los Angeles | 37 | 2021-06-25 | 11328 | 349 | |
4232 | 4232 | Madera | Madera | 39 | 2021-06-25 | 16544 | 245 | TRUE |
4233 | 4233 | Marin | Marin | 41 | 2021-06-25 | 14214 | 212 | |
4234 | 4234 | Mariposa | Mariposa | 43 | 2021-06-25 | 466 | 7 | |
4235 | 4235 | Mendocino | Mendocino | 45 | 2021-06-25 | 4363 | 50 | |
4236 | 4236 | Merced | Merced | 47 | 2021-06-25 | 32335 | 481 | |
4237 | 4237 | Modoc | Modoc | 49 | 2021-06-25 | 566 | 5 | TRUE |
4238 | 4238 | Mono | Mono | 51 | 2021-06-25 | 1298 | 4 | TRUE |
4239 | 4239 | Monterey | Monterey | 53 | 2021-06-25 | 43860 | 466 | |
4240 | 4240 | Napa | Napa | 55 | 2021-06-25 | 10027 | 80 | |
4241 | 4241 | Nevada | Nevada | 57 | 2021-06-25 | 4940 | 75 | |
4242 | 4242 | Orange | Orange | 59 | 2021-06-25 | 256052 | 5114 | |
4243 | 4243 | Placer | Placer | 61 | 2021-06-25 | 23673 | 300 | |
4244 | 4244 | Plumas | Plumas | 63 | 2021-06-25 | 742 | 6 | TRUE |
4245 | 4245 | Riverside | Riverside | 65 | 2021-06-25 | 301706 | 4627 | |
4246 | 4246 | Sacramento | Sacramento | 67 | 2021-06-25 | 108085 | 1738 | |
4247 | 4247 | San Benito | San Benito | 69 | 2021-06-25 | 6111 | 63 | |
4248 | 4248 | San Bernardino | San Bernardino | 71 | 2021-06-25 | 299480 | 4840 | |
4249 | 4249 | San Diego | San Diego | 73 | 2021-06-25 | 282156 | 3779 | |
4250 | 4250 | San Francisco | San Francisco | 75 | 2021-06-25 | 36966 | 554 | |
4251 | 4251 | San Joaquin | San Joaquin | 77 | 2021-06-25 | 74808 | 1440 | TRUE |
4252 | 4252 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-25 | 21448 | 261 | TRUE |
4253 | 4253 | San Mateo | San Mateo | 81 | 2021-06-25 | 42386 | 581 | TRUE |
4254 | 4254 | Santa Barbara | Santa Barbara | 83 | 2021-06-25 | 34626 | 455 | |
4255 | 4255 | Santa Clara | Santa Clara | 85 | 2021-06-25 | 119111 | 1696 | |
4256 | 4256 | Santa Cruz | Santa Cruz | 87 | 2021-06-25 | 16262 | 207 | TRUE |
4257 | 4257 | Shasta | Shasta | 89 | 2021-06-25 | 12605 | 235 | |
4258 | 4258 | Sierra | Sierra | 91 | 2021-06-25 | 118 | 0 | TRUE |
4259 | 4259 | Siskiyou | Siskiyou | 93 | 2021-06-25 | 2402 | 38 | |
4260 | 4260 | Solano | Solano | 95 | 2021-06-25 | 33846 | 244 | |
4261 | 4261 | Sonoma | Sonoma | 97 | 2021-06-25 | 30941 | 317 | |
4262 | 4262 | Stanislaus | Stanislaus | 99 | 2021-06-25 | 57000 | 1073 | |
4263 | 4263 | Sutter | Sutter | 101 | 2021-06-25 | 9684 | 107 | |
4264 | 4264 | Tehama | Tehama | 103 | 2021-06-25 | 5743 | 59 | |
4265 | 4265 | Trinity | Trinity | 105 | 2021-06-25 | 426 | 6 | |
4266 | 4266 | Tulare | Tulare | 107 | 2021-06-25 | 49823 | 850 | TRUE |
4267 | 4267 | Tuolumne | Tuolumne | 109 | 2021-06-25 | 4227 | 71 | |
4268 | 4268 | Ventura | Ventura | 111 | 2021-06-25 | 81750 | 1027 | |
4269 | 4269 | Yolo | Yolo | 113 | 2021-06-25 | 14122 | 210 | |
4270 | 4270 | Yuba | Yuba | 115 | 2021-06-25 | 6526 | 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 );