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-02-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
12567 | 12567 | Alameda | Alameda | 1 | 2021-02-08 | 73911 | 1141 | |
12568 | 12568 | Berkeley | Alameda | 1 | 2021-02-08 | 2972 | 44 | |
12569 | 12569 | Alpine | Alpine | 3 | 2021-02-08 | 79 | 0 | |
12570 | 12570 | Amador | Amador | 5 | 2021-02-08 | 3297 | 36 | |
12571 | 12571 | Butte | Butte | 7 | 2021-02-08 | 10524 | 148 | |
12572 | 12572 | Calaveras | Calaveras | 9 | 2021-02-08 | 1811 | 23 | |
12573 | 12573 | Colusa | Colusa | 11 | 2021-02-08 | 2020 | 11 | |
12574 | 12574 | Contra Costa | Contra Costa | 13 | 2021-02-08 | 59313 | 560 | |
12575 | 12575 | Del Norte | Del Norte | 15 | 2021-02-08 | 904 | 3 | |
12576 | 12576 | El Dorado | El Dorado | 17 | 2021-02-08 | 8762 | 86 | |
12577 | 12577 | Fresno | Fresno | 19 | 2021-02-08 | 92797 | 1254 | |
12578 | 12578 | Glenn | Glenn | 21 | 2021-02-08 | 2078 | 23 | |
12579 | 12579 | Humboldt | Humboldt | 23 | 2021-02-08 | 2955 | 32 | |
12580 | 12580 | Imperial | Imperial | 25 | 2021-02-08 | 26489 | 561 | |
12581 | 12581 | Inyo | Inyo | 27 | 2021-02-08 | 1162 | 32 | |
12582 | 12582 | Kern | Kern | 29 | 2021-02-08 | 97522 | 659 | |
12583 | 12583 | Kings | Kings | 31 | 2021-02-08 | 21297 | 197 | |
12584 | 12584 | Lake | Lake | 33 | 2021-02-08 | 2885 | 35 | |
12585 | 12585 | Lassen | Lassen | 35 | 2021-02-08 | 5489 | 19 | |
12586 | 12586 | Long Beach | Los Angeles | 37 | 2021-02-08 | 49603 | 722 | |
12587 | 12587 | Los Angeles | Los Angeles | 37 | 2021-02-08 | 1089235 | 17146 | |
12588 | 12588 | Pasadena | Los Angeles | 37 | 2021-02-08 | 10508 | 278 | |
12589 | 12589 | Madera | Madera | 39 | 2021-02-08 | 14832 | 184 | |
12590 | 12590 | Marin | Marin | 41 | 2021-02-08 | 12657 | 176 | |
12591 | 12591 | Mariposa | Mariposa | 43 | 2021-02-08 | 380 | 5 | |
12592 | 12592 | Mendocino | Mendocino | 45 | 2021-02-08 | 3612 | 39 | |
12593 | 12593 | Merced | Merced | 47 | 2021-02-08 | 27424 | 367 | |
12594 | 12594 | Modoc | Modoc | 49 | 2021-02-08 | 436 | 4 | |
12595 | 12595 | Mono | Mono | 51 | 2021-02-08 | 1190 | 4 | |
12596 | 12596 | Monterey | Monterey | 53 | 2021-02-08 | 40532 | 289 | TRUE |
12597 | 12597 | Napa | Napa | 55 | 2021-02-08 | 8658 | 57 | |
12598 | 12598 | Nevada | Nevada | 57 | 2021-02-08 | 3676 | 74 | |
12599 | 12599 | Orange | Orange | 59 | 2021-02-08 | 239206 | 3383 | |
12600 | 12600 | Placer | Placer | 61 | 2021-02-08 | 18973 | 214 | |
12601 | 12601 | Plumas | Plumas | 63 | 2021-02-08 | 637 | 6 | |
12602 | 12602 | Riverside | Riverside | 65 | 2021-02-08 | 282736 | 3377 | |
12603 | 12603 | Sacramento | Sacramento | 67 | 2021-02-08 | 88775 | 1318 | |
12604 | 12604 | San Benito | San Benito | 69 | 2021-02-08 | 5470 | 55 | |
12605 | 12605 | San Bernardino | San Bernardino | 71 | 2021-02-08 | 278802 | 4358 | |
12606 | 12606 | San Diego | San Diego | 73 | 2021-02-08 | 247262 | 2821 | |
12607 | 12607 | San Francisco | San Francisco | 75 | 2021-02-08 | 32355 | 346 | |
12608 | 12608 | San Joaquin | San Joaquin | 77 | 2021-02-08 | 64138 | 923 | |
12609 | 12609 | San Luis Obispo | San Luis Obispo | 79 | 2021-02-08 | 18684 | 196 | |
12610 | 12610 | San Mateo | San Mateo | 81 | 2021-02-08 | 37058 | 436 | |
12611 | 12611 | Santa Barbara | Santa Barbara | 83 | 2021-02-08 | 30087 | 337 | |
12612 | 12612 | Santa Clara | Santa Clara | 85 | 2021-02-08 | 105627 | 1468 | |
12613 | 12613 | Santa Cruz | Santa Cruz | 87 | 2021-02-08 | 14011 | 159 | |
12614 | 12614 | Shasta | Shasta | 89 | 2021-02-08 | 10687 | 161 | |
12615 | 12615 | Sierra | Sierra | 91 | 2021-02-08 | 95 | 0 | TRUE |
12616 | 12616 | Siskiyou | Siskiyou | 93 | 2021-02-08 | 1629 | 13 | |
12617 | 12617 | Solano | Solano | 95 | 2021-02-08 | 28994 | 134 | |
12618 | 12618 | Sonoma | Sonoma | 97 | 2021-02-08 | 26909 | 277 | |
12619 | 12619 | Stanislaus | Stanislaus | 99 | 2021-02-08 | 47864 | 867 | |
12620 | 12620 | Sutter | Sutter | 101 | 2021-02-08 | 8582 | 92 | |
12621 | 12621 | Tehama | Tehama | 103 | 2021-02-08 | 4831 | 47 | TRUE |
12622 | 12622 | Trinity | Trinity | 105 | 2021-02-08 | 316 | 5 | |
12623 | 12623 | Tulare | Tulare | 107 | 2021-02-08 | 46133 | 651 | |
12624 | 12624 | Tuolumne | Tuolumne | 109 | 2021-02-08 | 3726 | 51 | |
12625 | 12625 | Ventura | Ventura | 111 | 2021-02-08 | 73618 | 678 | |
12626 | 12626 | Yolo | Yolo | 113 | 2021-02-08 | 12012 | 158 | |
12627 | 12627 | Yuba | Yuba | 115 | 2021-02-08 | 5513 | 36 |
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 );