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-08-29 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 |
---|---|---|---|---|---|---|---|---|
22510 | 22510 | Alameda | Alameda | 1 | 2020-08-29 | 17566 | 371 | TRUE |
22511 | 22511 | Berkeley | Alameda | 1 | 2020-08-29 | 541 | 10 | TRUE |
22512 | 22512 | Alpine | Alpine | 3 | 2020-08-29 | 2 | 0 | TRUE |
22513 | 22513 | Amador | Amador | 5 | 2020-08-29 | 234 | 13 | TRUE |
22514 | 22514 | Butte | Butte | 7 | 2020-08-29 | 1948 | 23 | TRUE |
22515 | 22515 | Calaveras | Calaveras | 9 | 2020-08-29 | 236 | 2 | TRUE |
22516 | 22516 | Colusa | Colusa | 11 | 2020-08-29 | 441 | 6 | TRUE |
22517 | 22517 | Contra Costa | Contra Costa | 13 | 2020-08-29 | 13700 | 173 | |
22518 | 22518 | Del Norte | Del Norte | 15 | 2020-08-29 | 122 | 1 | TRUE |
22519 | 22519 | El Dorado | El Dorado | 17 | 2020-08-29 | 951 | 2 | TRUE |
22520 | 22520 | Fresno | Fresno | 19 | 2020-08-29 | 27605 | 263 | |
22521 | 22521 | Glenn | Glenn | 21 | 2020-08-29 | 440 | 3 | TRUE |
22522 | 22522 | Humboldt | Humboldt | 23 | 2020-08-29 | 368 | 4 | TRUE |
22523 | 22523 | Imperial | Imperial | 25 | 2020-08-29 | 10667 | 293 | |
22524 | 22524 | Inyo | Inyo | 27 | 2020-08-29 | 174 | 13 | TRUE |
22525 | 22525 | Kern | Kern | 29 | 2020-08-29 | 29105 | 286 | |
22526 | 22526 | Kings | Kings | 31 | 2020-08-29 | 6142 | 72 | |
22527 | 22527 | Lake | Lake | 33 | 2020-08-29 | 332 | 4 | |
22528 | 22528 | Lassen | Lassen | 35 | 2020-08-29 | 715 | 0 | TRUE |
22529 | 22529 | Long Beach | Los Angeles | 37 | 2020-08-29 | 10492 | 216 | |
22530 | 22530 | Los Angeles | Los Angeles | 37 | 2020-08-29 | 226974 | 5436 | |
22531 | 22531 | Pasadena | Los Angeles | 37 | 2020-08-29 | 2362 | 111 | |
22532 | 22532 | Madera | Madera | 39 | 2020-08-29 | 3674 | 54 | TRUE |
22533 | 22533 | Marin | Marin | 41 | 2020-08-29 | 6071 | 95 | TRUE |
22534 | 22534 | Mariposa | Mariposa | 43 | 2020-08-29 | 71 | 2 | TRUE |
22535 | 22535 | Mendocino | Mendocino | 45 | 2020-08-29 | 689 | 17 | |
22536 | 22536 | Merced | Merced | 47 | 2020-08-29 | 7890 | 115 | TRUE |
22537 | 22537 | Modoc | Modoc | 49 | 2020-08-29 | 10 | 0 | |
22538 | 22538 | Mono | Mono | 51 | 2020-08-29 | 162 | 2 | TRUE |
22539 | 22539 | Monterey | Monterey | 53 | 2020-08-29 | 7685 | 55 | |
22540 | 22540 | Napa | Napa | 55 | 2020-08-29 | 1397 | 12 | TRUE |
22541 | 22541 | Nevada | Nevada | 57 | 2020-08-29 | 435 | 5 | TRUE |
22542 | 22542 | Orange | Orange | 59 | 2020-08-29 | 48190 | 975 | |
22543 | 22543 | Placer | Placer | 61 | 2020-08-29 | 2947 | 32 | |
22544 | 22544 | Plumas | Plumas | 63 | 2020-08-29 | 40 | 0 | TRUE |
22545 | 22545 | Riverside | Riverside | 65 | 2020-08-29 | 51860 | 1007 | TRUE |
22546 | 22546 | Sacramento | Sacramento | 67 | 2020-08-29 | 17150 | 274 | TRUE |
22547 | 22547 | San Benito | San Benito | 69 | 2020-08-29 | 1081 | 8 | |
22548 | 22548 | San Bernardino | San Bernardino | 71 | 2020-08-29 | 47145 | 978 | |
22549 | 22549 | San Diego | San Diego | 73 | 2020-08-29 | 38047 | 679 | |
22550 | 22550 | San Francisco | San Francisco | 75 | 2020-08-29 | 9349 | 83 | |
22551 | 22551 | San Joaquin | San Joaquin | 77 | 2020-08-29 | 16913 | 307 | TRUE |
22552 | 22552 | San Luis Obispo | San Luis Obispo | 79 | 2020-08-29 | 2882 | 20 | TRUE |
22553 | 22553 | San Mateo | San Mateo | 81 | 2020-08-29 | 8074 | 131 | |
22554 | 22554 | Santa Barbara | Santa Barbara | 83 | 2020-08-29 | 8014 | 92 | TRUE |
22555 | 22555 | Santa Clara | Santa Clara | 85 | 2020-08-29 | 17821 | 251 | |
22556 | 22556 | Santa Cruz | Santa Cruz | 87 | 2020-08-29 | 1736 | 7 | |
22557 | 22557 | Shasta | Shasta | 89 | 2020-08-29 | 562 | 12 | TRUE |
22558 | 22558 | Sierra | Sierra | 91 | 2020-08-29 | 6 | 0 | TRUE |
22559 | 22559 | Siskiyou | Siskiyou | 93 | 2020-08-29 | 128 | 0 | TRUE |
22560 | 22560 | Solano | Solano | 95 | 2020-08-29 | 5388 | 46 | TRUE |
22561 | 22561 | Sonoma | Sonoma | 97 | 2020-08-29 | 5588 | 78 | TRUE |
22562 | 22562 | Stanislaus | Stanislaus | 99 | 2020-08-29 | 14482 | 255 | |
22563 | 22563 | Sutter | Sutter | 101 | 2020-08-29 | 1368 | 10 | |
22564 | 22564 | Tehama | Tehama | 103 | 2020-08-29 | 412 | 1 | |
22565 | 22565 | Trinity | Trinity | 105 | 2020-08-29 | 13 | 0 | |
22566 | 22566 | Tulare | Tulare | 107 | 2020-08-29 | 13884 | 232 | TRUE |
22567 | 22567 | Tuolumne | Tuolumne | 109 | 2020-08-29 | 181 | 2 | TRUE |
22568 | 22568 | Ventura | Ventura | 111 | 2020-08-29 | 10346 | 115 | TRUE |
22569 | 22569 | Yolo | Yolo | 113 | 2020-08-29 | 2335 | 51 | |
22570 | 22570 | Yuba | Yuba | 115 | 2020-08-29 | 915 | 6 |
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 );