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-12-07 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 |
---|---|---|---|---|---|---|---|---|
16410 | 16410 | Alameda | Alameda | 1 | 2020-12-07 | 32766 | 574 | |
16411 | 16411 | Berkeley | Alameda | 1 | 2020-12-07 | 1366 | 14 | |
16412 | 16412 | Alpine | Alpine | 3 | 2020-12-07 | 57 | 0 | TRUE |
16413 | 16413 | Amador | Amador | 5 | 2020-12-07 | 1137 | 17 | |
16414 | 16414 | Butte | Butte | 7 | 2020-12-07 | 4604 | 62 | |
16415 | 16415 | Calaveras | Calaveras | 9 | 2020-12-07 | 556 | 22 | TRUE |
16416 | 16416 | Colusa | Colusa | 11 | 2020-12-07 | 823 | 7 | |
16417 | 16417 | Contra Costa | Contra Costa | 13 | 2020-12-07 | 27455 | 267 | |
16418 | 16418 | Del Norte | Del Norte | 15 | 2020-12-07 | 474 | 1 | |
16419 | 16419 | El Dorado | El Dorado | 17 | 2020-12-07 | 2882 | 8 | |
16420 | 16420 | Fresno | Fresno | 19 | 2020-12-07 | 49873 | 506 | |
16421 | 16421 | Glenn | Glenn | 21 | 2020-12-07 | 1089 | 11 | |
16422 | 16422 | Humboldt | Humboldt | 23 | 2020-12-07 | 1102 | 9 | |
16423 | 16423 | Imperial | Imperial | 25 | 2020-12-07 | 17084 | 360 | |
16424 | 16424 | Inyo | Inyo | 27 | 2020-12-07 | 350 | 16 | |
16425 | 16425 | Kern | Kern | 29 | 2020-12-07 | 45342 | 456 | |
16426 | 16426 | Kings | Kings | 31 | 2020-12-07 | 12412 | 95 | |
16427 | 16427 | Lake | Lake | 33 | 2020-12-07 | 1092 | 21 | |
16428 | 16428 | Lassen | Lassen | 35 | 2020-12-07 | 2812 | 5 | |
16429 | 16429 | Long Beach | Los Angeles | 37 | 2020-12-07 | 18370 | 282 | |
16430 | 16430 | Los Angeles | Los Angeles | 37 | 2020-12-07 | 435608 | 7518 | |
16431 | 16431 | Pasadena | Los Angeles | 37 | 2020-12-07 | 4277 | 136 | |
16432 | 16432 | Madera | Madera | 39 | 2020-12-07 | 6940 | 90 | |
16433 | 16433 | Marin | Marin | 41 | 2020-12-07 | 8102 | 132 | |
16434 | 16434 | Mariposa | Mariposa | 43 | 2020-12-07 | 162 | 3 | |
16435 | 16435 | Mendocino | Mendocino | 45 | 2020-12-07 | 1759 | 23 | TRUE |
16436 | 16436 | Merced | Merced | 47 | 2020-12-07 | 13637 | 194 | |
16437 | 16437 | Modoc | Modoc | 49 | 2020-12-07 | 197 | 0 | |
16438 | 16438 | Mono | Mono | 51 | 2020-12-07 | 625 | 3 | |
16439 | 16439 | Monterey | Monterey | 53 | 2020-12-07 | 16602 | 136 | |
16440 | 16440 | Napa | Napa | 55 | 2020-12-07 | 3650 | 20 | |
16441 | 16441 | Nevada | Nevada | 57 | 2020-12-07 | 1776 | 17 | |
16442 | 16442 | Orange | Orange | 59 | 2020-12-07 | 88842 | 1633 | |
16443 | 16443 | Placer | Placer | 61 | 2020-12-07 | 7979 | 81 | |
16444 | 16444 | Plumas | Plumas | 63 | 2020-12-07 | 294 | 0 | |
16445 | 16445 | Riverside | Riverside | 65 | 2020-12-07 | 92272 | 1488 | |
16446 | 16446 | Sacramento | Sacramento | 67 | 2020-12-07 | 43426 | 620 | |
16447 | 16447 | San Benito | San Benito | 69 | 2020-12-07 | 2177 | 19 | |
16448 | 16448 | San Bernardino | San Bernardino | 71 | 2020-12-07 | 107928 | 1643 | |
16449 | 16449 | San Diego | San Diego | 73 | 2020-12-07 | 94169 | 1062 | |
16450 | 16450 | San Francisco | San Francisco | 75 | 2020-12-07 | 17068 | 164 | |
16451 | 16451 | San Joaquin | San Joaquin | 77 | 2020-12-07 | 27844 | 530 | |
16452 | 16452 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-07 | 6873 | 42 | |
16453 | 16453 | San Mateo | San Mateo | 81 | 2020-12-07 | 16101 | 176 | |
16454 | 16454 | Santa Barbara | Santa Barbara | 83 | 2020-12-07 | 12379 | 138 | |
16455 | 16455 | Santa Clara | Santa Clara | 85 | 2020-12-07 | 45159 | 488 | |
16456 | 16456 | Santa Cruz | Santa Cruz | 87 | 2020-12-07 | 5157 | 44 | |
16457 | 16457 | Shasta | Shasta | 89 | 2020-12-07 | 5824 | 53 | |
16458 | 16458 | Sierra | Sierra | 91 | 2020-12-07 | 24 | 0 | |
16459 | 16459 | Siskiyou | Siskiyou | 93 | 2020-12-07 | 828 | 7 | |
16460 | 16460 | Solano | Solano | 95 | 2020-12-07 | 11747 | 85 | |
16461 | 16461 | Sonoma | Sonoma | 97 | 2020-12-07 | 13439 | 160 | |
16462 | 16462 | Stanislaus | Stanislaus | 99 | 2020-12-07 | 24461 | 446 | |
16463 | 16463 | Sutter | Sutter | 101 | 2020-12-07 | 4234 | 25 | |
16464 | 16464 | Tehama | Tehama | 103 | 2020-12-07 | 1945 | 28 | TRUE |
16465 | 16465 | Trinity | Trinity | 105 | 2020-12-07 | 207 | 1 | |
16466 | 16466 | Tulare | Tulare | 107 | 2020-12-07 | 22857 | 317 | |
16467 | 16467 | Tuolumne | Tuolumne | 109 | 2020-12-07 | 1260 | 14 | |
16468 | 16468 | Ventura | Ventura | 111 | 2020-12-07 | 23165 | 189 | |
16469 | 16469 | Yolo | Yolo | 113 | 2020-12-07 | 5492 | 84 | |
16470 | 16470 | Yuba | Yuba | 115 | 2020-12-07 | 2572 | 10 |
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 );