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-04 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 |
---|---|---|---|---|---|---|---|---|
16593 | 16593 | Alameda | Alameda | 1 | 2020-12-04 | 31149 | 555 | |
16594 | 16594 | Berkeley | Alameda | 1 | 2020-12-04 | 1279 | 13 | |
16595 | 16595 | Alpine | Alpine | 3 | 2020-12-04 | 57 | 0 | TRUE |
16596 | 16596 | Amador | Amador | 5 | 2020-12-04 | 917 | 17 | |
16597 | 16597 | Butte | Butte | 7 | 2020-12-04 | 4336 | 60 | |
16598 | 16598 | Calaveras | Calaveras | 9 | 2020-12-04 | 556 | 22 | |
16599 | 16599 | Colusa | Colusa | 11 | 2020-12-04 | 789 | 6 | |
16600 | 16600 | Contra Costa | Contra Costa | 13 | 2020-12-04 | 25768 | 262 | |
16601 | 16601 | Del Norte | Del Norte | 15 | 2020-12-04 | 411 | 1 | |
16602 | 16602 | El Dorado | El Dorado | 17 | 2020-12-04 | 2822 | 8 | |
16603 | 16603 | Fresno | Fresno | 19 | 2020-12-04 | 47900 | 506 | |
16604 | 16604 | Glenn | Glenn | 21 | 2020-12-04 | 1018 | 11 | |
16605 | 16605 | Humboldt | Humboldt | 23 | 2020-12-04 | 1014 | 9 | |
16606 | 16606 | Imperial | Imperial | 25 | 2020-12-04 | 16555 | 360 | |
16607 | 16607 | Inyo | Inyo | 27 | 2020-12-04 | 328 | 16 | |
16608 | 16608 | Kern | Kern | 29 | 2020-12-04 | 43860 | 455 | |
16609 | 16609 | Kings | Kings | 31 | 2020-12-04 | 11751 | 91 | |
16610 | 16610 | Lake | Lake | 33 | 2020-12-04 | 1022 | 21 | |
16611 | 16611 | Lassen | Lassen | 35 | 2020-12-04 | 2422 | 3 | |
16612 | 16612 | Long Beach | Los Angeles | 37 | 2020-12-04 | 17550 | 282 | |
16613 | 16613 | Los Angeles | Los Angeles | 37 | 2020-12-04 | 409306 | 7425 | |
16614 | 16614 | Pasadena | Los Angeles | 37 | 2020-12-04 | 3968 | 136 | |
16615 | 16615 | Madera | Madera | 39 | 2020-12-04 | 6537 | 90 | |
16616 | 16616 | Marin | Marin | 41 | 2020-12-04 | 7962 | 131 | |
16617 | 16617 | Mariposa | Mariposa | 43 | 2020-12-04 | 149 | 3 | |
16618 | 16618 | Mendocino | Mendocino | 45 | 2020-12-04 | 1697 | 23 | |
16619 | 16619 | Merced | Merced | 47 | 2020-12-04 | 12891 | 191 | |
16620 | 16620 | Modoc | Modoc | 49 | 2020-12-04 | 174 | 0 | |
16621 | 16621 | Mono | Mono | 51 | 2020-12-04 | 593 | 3 | |
16622 | 16622 | Monterey | Monterey | 53 | 2020-12-04 | 15991 | 130 | |
16623 | 16623 | Napa | Napa | 55 | 2020-12-04 | 3388 | 18 | |
16624 | 16624 | Nevada | Nevada | 57 | 2020-12-04 | 1569 | 16 | |
16625 | 16625 | Orange | Orange | 59 | 2020-12-04 | 82887 | 1603 | |
16626 | 16626 | Placer | Placer | 61 | 2020-12-04 | 6910 | 74 | |
16627 | 16627 | Plumas | Plumas | 63 | 2020-12-04 | 268 | 0 | |
16628 | 16628 | Riverside | Riverside | 65 | 2020-12-04 | 87945 | 1472 | |
16629 | 16629 | Sacramento | Sacramento | 67 | 2020-12-04 | 41096 | 614 | |
16630 | 16630 | San Benito | San Benito | 69 | 2020-12-04 | 2051 | 18 | |
16631 | 16631 | San Bernardino | San Bernardino | 71 | 2020-12-04 | 100733 | 1556 | |
16632 | 16632 | San Diego | San Diego | 73 | 2020-12-04 | 88181 | 1047 | |
16633 | 16633 | San Francisco | San Francisco | 75 | 2020-12-04 | 16208 | 162 | |
16634 | 16634 | San Joaquin | San Joaquin | 77 | 2020-12-04 | 27469 | 522 | |
16635 | 16635 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-04 | 6540 | 42 | |
16636 | 16636 | San Mateo | San Mateo | 81 | 2020-12-04 | 15217 | 176 | |
16637 | 16637 | Santa Barbara | Santa Barbara | 83 | 2020-12-04 | 11917 | 138 | |
16638 | 16638 | Santa Clara | Santa Clara | 85 | 2020-12-04 | 42564 | 465 | |
16639 | 16639 | Santa Cruz | Santa Cruz | 87 | 2020-12-04 | 4797 | 40 | |
16640 | 16640 | Shasta | Shasta | 89 | 2020-12-04 | 5490 | 53 | |
16641 | 16641 | Sierra | Sierra | 91 | 2020-12-04 | 24 | 0 | |
16642 | 16642 | Siskiyou | Siskiyou | 93 | 2020-12-04 | 786 | 5 | |
16643 | 16643 | Solano | Solano | 95 | 2020-12-04 | 11413 | 85 | |
16644 | 16644 | Sonoma | Sonoma | 97 | 2020-12-04 | 13098 | 160 | |
16645 | 16645 | Stanislaus | Stanislaus | 99 | 2020-12-04 | 23274 | 436 | |
16646 | 16646 | Sutter | Sutter | 101 | 2020-12-04 | 3915 | 20 | |
16647 | 16647 | Tehama | Tehama | 103 | 2020-12-04 | 1886 | 26 | |
16648 | 16648 | Trinity | Trinity | 105 | 2020-12-04 | 186 | 0 | |
16649 | 16649 | Tulare | Tulare | 107 | 2020-12-04 | 22386 | 317 | |
16650 | 16650 | Tuolumne | Tuolumne | 109 | 2020-12-04 | 1190 | 12 | |
16651 | 16651 | Ventura | Ventura | 111 | 2020-12-04 | 21876 | 188 | |
16652 | 16652 | Yolo | Yolo | 113 | 2020-12-04 | 5167 | 81 | |
16653 | 16653 | Yuba | Yuba | 115 | 2020-12-04 | 2403 | 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 );