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-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
agency 61
- Alameda 1
- Alpine 1
- Amador 1
- Berkeley 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Long Beach 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Pasadena 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
fips 58
county 58
- Los Angeles 3
- Alameda 2
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
16532 | 16532 | Alameda | Alameda | 1 | 2020-12-05 | 31774 | 560 | |
16533 | 16533 | Berkeley | Alameda | 1 | 2020-12-05 | 1334 | 13 | |
16534 | 16534 | Alpine | Alpine | 3 | 2020-12-05 | 57 | 0 | TRUE |
16535 | 16535 | Amador | Amador | 5 | 2020-12-05 | 991 | 17 | |
16536 | 16536 | Butte | Butte | 7 | 2020-12-05 | 4455 | 60 | TRUE |
16537 | 16537 | Calaveras | Calaveras | 9 | 2020-12-05 | 556 | 22 | TRUE |
16538 | 16538 | Colusa | Colusa | 11 | 2020-12-05 | 789 | 6 | TRUE |
16539 | 16539 | Contra Costa | Contra Costa | 13 | 2020-12-05 | 26355 | 267 | |
16540 | 16540 | Del Norte | Del Norte | 15 | 2020-12-05 | 411 | 1 | TRUE |
16541 | 16541 | El Dorado | El Dorado | 17 | 2020-12-05 | 2822 | 8 | TRUE |
16542 | 16542 | Fresno | Fresno | 19 | 2020-12-05 | 48610 | 506 | |
16543 | 16543 | Glenn | Glenn | 21 | 2020-12-05 | 1018 | 11 | TRUE |
16544 | 16544 | Humboldt | Humboldt | 23 | 2020-12-05 | 1014 | 9 | TRUE |
16545 | 16545 | Imperial | Imperial | 25 | 2020-12-05 | 16555 | 360 | TRUE |
16546 | 16546 | Inyo | Inyo | 27 | 2020-12-05 | 328 | 16 | TRUE |
16547 | 16547 | Kern | Kern | 29 | 2020-12-05 | 44327 | 456 | |
16548 | 16548 | Kings | Kings | 31 | 2020-12-05 | 11911 | 93 | |
16549 | 16549 | Lake | Lake | 33 | 2020-12-05 | 1022 | 21 | |
16550 | 16550 | Lassen | Lassen | 35 | 2020-12-05 | 2422 | 3 | TRUE |
16551 | 16551 | Long Beach | Los Angeles | 37 | 2020-12-05 | 18075 | 282 | |
16552 | 16552 | Los Angeles | Los Angeles | 37 | 2020-12-05 | 417890 | 7468 | |
16553 | 16553 | Pasadena | Los Angeles | 37 | 2020-12-05 | 4077 | 136 | |
16554 | 16554 | Madera | Madera | 39 | 2020-12-05 | 6537 | 90 | TRUE |
16555 | 16555 | Marin | Marin | 41 | 2020-12-05 | 8016 | 131 | |
16556 | 16556 | Mariposa | Mariposa | 43 | 2020-12-05 | 155 | 3 | |
16557 | 16557 | Mendocino | Mendocino | 45 | 2020-12-05 | 1697 | 23 | TRUE |
16558 | 16558 | Merced | Merced | 47 | 2020-12-05 | 12891 | 191 | TRUE |
16559 | 16559 | Modoc | Modoc | 49 | 2020-12-05 | 181 | 0 | |
16560 | 16560 | Mono | Mono | 51 | 2020-12-05 | 614 | 3 | |
16561 | 16561 | Monterey | Monterey | 53 | 2020-12-05 | 16190 | 130 | |
16562 | 16562 | Napa | Napa | 55 | 2020-12-05 | 3388 | 18 | TRUE |
16563 | 16563 | Nevada | Nevada | 57 | 2020-12-05 | 1569 | 16 | TRUE |
16564 | 16564 | Orange | Orange | 59 | 2020-12-05 | 84853 | 1618 | |
16565 | 16565 | Placer | Placer | 61 | 2020-12-05 | 6910 | 74 | TRUE |
16566 | 16566 | Plumas | Plumas | 63 | 2020-12-05 | 268 | 0 | TRUE |
16567 | 16567 | Riverside | Riverside | 65 | 2020-12-05 | 87945 | 1472 | TRUE |
16568 | 16568 | Sacramento | Sacramento | 67 | 2020-12-05 | 41096 | 614 | TRUE |
16569 | 16569 | San Benito | San Benito | 69 | 2020-12-05 | 2124 | 18 | |
16570 | 16570 | San Bernardino | San Bernardino | 71 | 2020-12-05 | 103911 | 1588 | |
16571 | 16571 | San Diego | San Diego | 73 | 2020-12-05 | 90468 | 1055 | |
16572 | 16572 | San Francisco | San Francisco | 75 | 2020-12-05 | 16479 | 164 | |
16573 | 16573 | San Joaquin | San Joaquin | 77 | 2020-12-05 | 27469 | 522 | TRUE |
16574 | 16574 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-05 | 6540 | 42 | TRUE |
16575 | 16575 | San Mateo | San Mateo | 81 | 2020-12-05 | 15468 | 176 | |
16576 | 16576 | Santa Barbara | Santa Barbara | 83 | 2020-12-05 | 11917 | 138 | TRUE |
16577 | 16577 | Santa Clara | Santa Clara | 85 | 2020-12-05 | 43378 | 470 | |
16578 | 16578 | Santa Cruz | Santa Cruz | 87 | 2020-12-05 | 4797 | 40 | TRUE |
16579 | 16579 | Shasta | Shasta | 89 | 2020-12-05 | 5490 | 53 | TRUE |
16580 | 16580 | Sierra | Sierra | 91 | 2020-12-05 | 24 | 0 | TRUE |
16581 | 16581 | Siskiyou | Siskiyou | 93 | 2020-12-05 | 786 | 5 | TRUE |
16582 | 16582 | Solano | Solano | 95 | 2020-12-05 | 11413 | 85 | TRUE |
16583 | 16583 | Sonoma | Sonoma | 97 | 2020-12-05 | 13281 | 160 | |
16584 | 16584 | Stanislaus | Stanislaus | 99 | 2020-12-05 | 23763 | 439 | |
16585 | 16585 | Sutter | Sutter | 101 | 2020-12-05 | 3915 | 20 | TRUE |
16586 | 16586 | Tehama | Tehama | 103 | 2020-12-05 | 1945 | 28 | |
16587 | 16587 | Trinity | Trinity | 105 | 2020-12-05 | 186 | 0 | TRUE |
16588 | 16588 | Tulare | Tulare | 107 | 2020-12-05 | 22386 | 317 | TRUE |
16589 | 16589 | Tuolumne | Tuolumne | 109 | 2020-12-05 | 1190 | 12 | TRUE |
16590 | 16590 | Ventura | Ventura | 111 | 2020-12-05 | 21876 | 188 | TRUE |
16591 | 16591 | Yolo | Yolo | 113 | 2020-12-05 | 5310 | 84 | |
16592 | 16592 | Yuba | Yuba | 115 | 2020-12-05 | 2403 | 10 | 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 );