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-07-10 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 |
---|---|---|---|---|---|---|---|---|
3295 | 3295 | Alameda | Alameda | 1 | 2021-07-10 | 87325 | 1218 | |
3296 | 3296 | Berkeley | Alameda | 1 | 2021-07-10 | 3691 | 50 | |
3297 | 3297 | Alpine | Alpine | 3 | 2021-07-10 | 89 | 0 | TRUE |
3298 | 3298 | Amador | Amador | 5 | 2021-07-10 | 3747 | 48 | TRUE |
3299 | 3299 | Butte | Butte | 7 | 2021-07-10 | 12764 | 198 | TRUE |
3300 | 3300 | Calaveras | Calaveras | 9 | 2021-07-10 | 2233 | 58 | TRUE |
3301 | 3301 | Colusa | Colusa | 11 | 2021-07-10 | 2308 | 18 | TRUE |
3302 | 3302 | Contra Costa | Contra Costa | 13 | 2021-07-10 | 71981 | 821 | |
3303 | 3303 | Del Norte | Del Norte | 15 | 2021-07-10 | 1502 | 8 | TRUE |
3304 | 3304 | El Dorado | El Dorado | 17 | 2021-07-10 | 10558 | 118 | TRUE |
3305 | 3305 | Fresno | Fresno | 19 | 2021-07-10 | 102811 | 1730 | TRUE |
3306 | 3306 | Glenn | Glenn | 21 | 2021-07-10 | 2375 | 27 | TRUE |
3307 | 3307 | Humboldt | Humboldt | 23 | 2021-07-10 | 4647 | 51 | TRUE |
3308 | 3308 | Imperial | Imperial | 25 | 2021-07-10 | 28483 | 742 | TRUE |
3309 | 3309 | Inyo | Inyo | 27 | 2021-07-10 | 1444 | 38 | TRUE |
3310 | 3310 | Kern | Kern | 29 | 2021-07-10 | 111341 | 1409 | TRUE |
3311 | 3311 | Kings | Kings | 31 | 2021-07-10 | 23146 | 248 | TRUE |
3312 | 3312 | Lake | Lake | 33 | 2021-07-10 | 3654 | 63 | TRUE |
3313 | 3313 | Lassen | Lassen | 35 | 2021-07-10 | 5843 | 26 | TRUE |
3314 | 3314 | Long Beach | Los Angeles | 37 | 2021-07-10 | 53843 | 947 | TRUE |
3315 | 3315 | Los Angeles | Los Angeles | 37 | 2021-07-10 | 1191247 | 23241 | |
3316 | 3316 | Pasadena | Los Angeles | 37 | 2021-07-10 | 11425 | 350 | TRUE |
3317 | 3317 | Madera | Madera | 39 | 2021-07-10 | 16622 | 246 | TRUE |
3318 | 3318 | Marin | Marin | 41 | 2021-07-10 | 14329 | 213 | |
3319 | 3319 | Mariposa | Mariposa | 43 | 2021-07-10 | 468 | 7 | TRUE |
3320 | 3320 | Mendocino | Mendocino | 45 | 2021-07-10 | 4429 | 50 | TRUE |
3321 | 3321 | Merced | Merced | 47 | 2021-07-10 | 32479 | 483 | TRUE |
3322 | 3322 | Modoc | Modoc | 49 | 2021-07-10 | 571 | 6 | TRUE |
3323 | 3323 | Mono | Mono | 51 | 2021-07-10 | 1304 | 5 | TRUE |
3324 | 3324 | Monterey | Monterey | 53 | 2021-07-10 | 43993 | 507 | TRUE |
3325 | 3325 | Napa | Napa | 55 | 2021-07-10 | 10117 | 80 | TRUE |
3326 | 3326 | Nevada | Nevada | 57 | 2021-07-10 | 5023 | 75 | TRUE |
3327 | 3327 | Orange | Orange | 59 | 2021-07-10 | 256776 | 5124 | TRUE |
3328 | 3328 | Placer | Placer | 61 | 2021-07-10 | 23943 | 303 | TRUE |
3329 | 3329 | Plumas | Plumas | 63 | 2021-07-10 | 742 | 6 | TRUE |
3330 | 3330 | Riverside | Riverside | 65 | 2021-07-10 | 302069 | 4647 | TRUE |
3331 | 3331 | Sacramento | Sacramento | 67 | 2021-07-10 | 109719 | 1752 | TRUE |
3332 | 3332 | San Benito | San Benito | 69 | 2021-07-10 | 6173 | 63 | TRUE |
3333 | 3333 | San Bernardino | San Bernardino | 71 | 2021-07-10 | 300636 | 4850 | TRUE |
3334 | 3334 | San Diego | San Diego | 73 | 2021-07-10 | 283818 | 3784 | TRUE |
3335 | 3335 | San Francisco | San Francisco | 75 | 2021-07-10 | 37323 | 557 | |
3336 | 3336 | San Joaquin | San Joaquin | 77 | 2021-07-10 | 75133 | 1442 | TRUE |
3337 | 3337 | San Luis Obispo | San Luis Obispo | 79 | 2021-07-10 | 21518 | 261 | TRUE |
3338 | 3338 | San Mateo | San Mateo | 81 | 2021-07-10 | 42714 | 583 | TRUE |
3339 | 3339 | Santa Barbara | Santa Barbara | 83 | 2021-07-10 | 34719 | 458 | TRUE |
3340 | 3340 | Santa Clara | Santa Clara | 85 | 2021-07-10 | 119857 | 1702 | |
3341 | 3341 | Santa Cruz | Santa Cruz | 87 | 2021-07-10 | 16317 | 207 | TRUE |
3342 | 3342 | Shasta | Shasta | 89 | 2021-07-10 | 12614 | 238 | TRUE |
3343 | 3343 | Sierra | Sierra | 91 | 2021-07-10 | 122 | 0 | TRUE |
3344 | 3344 | Siskiyou | Siskiyou | 93 | 2021-07-10 | 2442 | 40 | TRUE |
3345 | 3345 | Solano | Solano | 95 | 2021-07-10 | 34240 | 245 | |
3346 | 3346 | Sonoma | Sonoma | 97 | 2021-07-10 | 31374 | 323 | |
3347 | 3347 | Stanislaus | Stanislaus | 99 | 2021-07-10 | 57365 | 1078 | TRUE |
3348 | 3348 | Sutter | Sutter | 101 | 2021-07-10 | 9769 | 108 | TRUE |
3349 | 3349 | Tehama | Tehama | 103 | 2021-07-10 | 5777 | 59 | |
3350 | 3350 | Trinity | Trinity | 105 | 2021-07-10 | 428 | 6 | TRUE |
3351 | 3351 | Tulare | Tulare | 107 | 2021-07-10 | 49915 | 852 | TRUE |
3352 | 3352 | Tuolumne | Tuolumne | 109 | 2021-07-10 | 4262 | 72 | TRUE |
3353 | 3353 | Ventura | Ventura | 111 | 2021-07-10 | 81972 | 1032 | TRUE |
3354 | 3354 | Yolo | Yolo | 113 | 2021-07-10 | 14219 | 210 | TRUE |
3355 | 3355 | Yuba | Yuba | 115 | 2021-07-10 | 6598 | 41 | TRUE |
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 );