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-03-31 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 |
---|---|---|---|---|---|---|---|---|
9456 | 9456 | Alameda | Alameda | 1 | 2021-03-31 | 80512 | 1204 | |
9457 | 9457 | Berkeley | Alameda | 1 | 2021-03-31 | 3445 | 46 | |
9458 | 9458 | Alpine | Alpine | 3 | 2021-03-31 | 88 | 0 | |
9459 | 9459 | Amador | Amador | 5 | 2021-03-31 | 3522 | 45 | |
9460 | 9460 | Butte | Butte | 7 | 2021-03-31 | 11321 | 178 | TRUE |
9461 | 9461 | Calaveras | Calaveras | 9 | 2021-03-31 | 2011 | 51 | |
9462 | 9462 | Colusa | Colusa | 11 | 2021-03-31 | 2165 | 16 | |
9463 | 9463 | Contra Costa | Contra Costa | 13 | 2021-03-31 | 65370 | 757 | |
9464 | 9464 | Del Norte | Del Norte | 15 | 2021-03-31 | 1163 | 5 | |
9465 | 9465 | El Dorado | El Dorado | 17 | 2021-03-31 | 9448 | 108 | |
9466 | 9466 | Fresno | Fresno | 19 | 2021-03-31 | 99101 | 1593 | |
9467 | 9467 | Glenn | Glenn | 21 | 2021-03-31 | 2258 | 25 | TRUE |
9468 | 9468 | Humboldt | Humboldt | 23 | 2021-03-31 | 3476 | 36 | TRUE |
9469 | 9469 | Imperial | Imperial | 25 | 2021-03-31 | 27116 | 715 | TRUE |
9470 | 9470 | Inyo | Inyo | 27 | 2021-03-31 | 1399 | 38 | |
9471 | 9471 | Kern | Kern | 29 | 2021-03-31 | 106239 | 1253 | |
9472 | 9472 | Kings | Kings | 31 | 2021-03-31 | 22620 | 241 | |
9473 | 9473 | Lake | Lake | 33 | 2021-03-31 | 3311 | 43 | |
9474 | 9474 | Lassen | Lassen | 35 | 2021-03-31 | 5652 | 24 | |
9475 | 9475 | Long Beach | Los Angeles | 37 | 2021-03-31 | 52213 | 910 | |
9476 | 9476 | Los Angeles | Los Angeles | 37 | 2021-03-31 | 1156262 | 21899 | |
9477 | 9477 | Pasadena | Los Angeles | 37 | 2021-03-31 | 11139 | 335 | |
9478 | 9478 | Madera | Madera | 39 | 2021-03-31 | 15924 | 234 | |
9479 | 9479 | Marin | Marin | 41 | 2021-03-31 | 13687 | 203 | |
9480 | 9480 | Mariposa | Mariposa | 43 | 2021-03-31 | 410 | 7 | |
9481 | 9481 | Mendocino | Mendocino | 45 | 2021-03-31 | 3941 | 46 | TRUE |
9482 | 9482 | Merced | Merced | 47 | 2021-03-31 | 30593 | 436 | |
9483 | 9483 | Modoc | Modoc | 49 | 2021-03-31 | 474 | 4 | |
9484 | 9484 | Mono | Mono | 51 | 2021-03-31 | 1264 | 4 | |
9485 | 9485 | Monterey | Monterey | 53 | 2021-03-31 | 42935 | 341 | |
9486 | 9486 | Napa | Napa | 55 | 2021-03-31 | 9394 | 78 | TRUE |
9487 | 9487 | Nevada | Nevada | 57 | 2021-03-31 | 4281 | 74 | |
9488 | 9488 | Orange | Orange | 59 | 2021-03-31 | 250683 | 4744 | |
9489 | 9489 | Placer | Placer | 61 | 2021-03-31 | 20952 | 274 | |
9490 | 9490 | Plumas | Plumas | 63 | 2021-03-31 | 682 | 6 | TRUE |
9491 | 9491 | Riverside | Riverside | 65 | 2021-03-31 | 294461 | 4315 | |
9492 | 9492 | Sacramento | Sacramento | 67 | 2021-03-31 | 97617 | 1603 | TRUE |
9493 | 9493 | San Benito | San Benito | 69 | 2021-03-31 | 5860 | 61 | |
9494 | 9494 | San Bernardino | San Bernardino | 71 | 2021-03-31 | 290954 | 4740 | |
9495 | 9495 | San Diego | San Diego | 73 | 2021-03-31 | 270287 | 3555 | |
9496 | 9496 | San Francisco | San Francisco | 75 | 2021-03-31 | 35083 | 463 | |
9497 | 9497 | San Joaquin | San Joaquin | 77 | 2021-03-31 | 69846 | 1300 | |
9498 | 9498 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-31 | 20505 | 256 | |
9499 | 9499 | San Mateo | San Mateo | 81 | 2021-03-31 | 40385 | 547 | |
9500 | 9500 | Santa Barbara | Santa Barbara | 83 | 2021-03-31 | 33174 | 439 | |
9501 | 9501 | Santa Clara | Santa Clara | 85 | 2021-03-31 | 113955 | 1653 | |
9502 | 9502 | Santa Cruz | Santa Cruz | 87 | 2021-03-31 | 15247 | 200 | TRUE |
9503 | 9503 | Shasta | Shasta | 89 | 2021-03-31 | 11353 | 207 | |
9504 | 9504 | Sierra | Sierra | 91 | 2021-03-31 | 106 | 0 | |
9505 | 9505 | Siskiyou | Siskiyou | 93 | 2021-03-31 | 1878 | 16 | TRUE |
9506 | 9506 | Solano | Solano | 95 | 2021-03-31 | 31189 | 197 | |
9507 | 9507 | Sonoma | Sonoma | 97 | 2021-03-31 | 29235 | 308 | TRUE |
9508 | 9508 | Stanislaus | Stanislaus | 99 | 2021-03-31 | 52621 | 1000 | |
9509 | 9509 | Sutter | Sutter | 101 | 2021-03-31 | 9140 | 102 | |
9510 | 9510 | Tehama | Tehama | 103 | 2021-03-31 | 5292 | 54 | |
9511 | 9511 | Trinity | Trinity | 105 | 2021-03-31 | 392 | 5 | |
9512 | 9512 | Tulare | Tulare | 107 | 2021-03-31 | 49054 | 811 | |
9513 | 9513 | Tuolumne | Tuolumne | 109 | 2021-03-31 | 4036 | 62 | |
9514 | 9514 | Ventura | Ventura | 111 | 2021-03-31 | 79668 | 981 | |
9515 | 9515 | Yolo | Yolo | 113 | 2021-03-31 | 13221 | 198 | |
9516 | 9516 | Yuba | Yuba | 115 | 2021-03-31 | 5999 | 40 |
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 );