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-09-12 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 |
---|---|---|---|---|---|---|---|---|
21656 | 21656 | Alameda | Alameda | 1 | 2020-09-12 | 19226 | 404 | TRUE |
21657 | 21657 | Berkeley | Alameda | 1 | 2020-09-12 | 636 | 10 | |
21658 | 21658 | Alpine | Alpine | 3 | 2020-09-12 | 2 | 0 | TRUE |
21659 | 21659 | Amador | Amador | 5 | 2020-09-12 | 242 | 15 | TRUE |
21660 | 21660 | Butte | Butte | 7 | 2020-09-12 | 2629 | 28 | TRUE |
21661 | 21661 | Calaveras | Calaveras | 9 | 2020-09-12 | 298 | 10 | TRUE |
21662 | 21662 | Colusa | Colusa | 11 | 2020-09-12 | 489 | 6 | TRUE |
21663 | 21663 | Contra Costa | Contra Costa | 13 | 2020-09-12 | 15203 | 191 | |
21664 | 21664 | Del Norte | Del Norte | 15 | 2020-09-12 | 129 | 1 | TRUE |
21665 | 21665 | El Dorado | El Dorado | 17 | 2020-09-12 | 1032 | 2 | TRUE |
21666 | 21666 | Fresno | Fresno | 19 | 2020-09-12 | 29157 | 337 | |
21667 | 21667 | Glenn | Glenn | 21 | 2020-09-12 | 522 | 3 | TRUE |
21668 | 21668 | Humboldt | Humboldt | 23 | 2020-09-12 | 447 | 5 | TRUE |
21669 | 21669 | Imperial | Imperial | 25 | 2020-09-12 | 11274 | 308 | |
21670 | 21670 | Inyo | Inyo | 27 | 2020-09-12 | 186 | 14 | TRUE |
21671 | 21671 | Kern | Kern | 29 | 2020-09-12 | 30622 | 326 | |
21672 | 21672 | Kings | Kings | 31 | 2020-09-12 | 7057 | 77 | |
21673 | 21673 | Lake | Lake | 33 | 2020-09-12 | 390 | 7 | TRUE |
21674 | 21674 | Lassen | Lassen | 35 | 2020-09-12 | 727 | 0 | TRUE |
21675 | 21675 | Long Beach | Los Angeles | 37 | 2020-09-12 | 11170 | 234 | |
21676 | 21676 | Los Angeles | Los Angeles | 37 | 2020-09-12 | 239574 | 5844 | |
21677 | 21677 | Pasadena | Los Angeles | 37 | 2020-09-12 | 2476 | 120 | |
21678 | 21678 | Madera | Madera | 39 | 2020-09-12 | 4150 | 58 | TRUE |
21679 | 21679 | Marin | Marin | 41 | 2020-09-12 | 6450 | 99 | |
21680 | 21680 | Mariposa | Mariposa | 43 | 2020-09-12 | 75 | 2 | |
21681 | 21681 | Mendocino | Mendocino | 45 | 2020-09-12 | 785 | 17 | |
21682 | 21682 | Merced | Merced | 47 | 2020-09-12 | 8541 | 127 | TRUE |
21683 | 21683 | Modoc | Modoc | 49 | 2020-09-12 | 22 | 0 | TRUE |
21684 | 21684 | Mono | Mono | 51 | 2020-09-12 | 163 | 2 | TRUE |
21685 | 21685 | Monterey | Monterey | 53 | 2020-09-12 | 8904 | 64 | |
21686 | 21686 | Napa | Napa | 55 | 2020-09-12 | 1540 | 12 | TRUE |
21687 | 21687 | Nevada | Nevada | 57 | 2020-09-12 | 482 | 5 | TRUE |
21688 | 21688 | Orange | Orange | 59 | 2020-09-12 | 50760 | 1093 | |
21689 | 21689 | Placer | Placer | 61 | 2020-09-12 | 3301 | 39 | |
21690 | 21690 | Plumas | Plumas | 63 | 2020-09-12 | 48 | 0 | TRUE |
21691 | 21691 | Riverside | Riverside | 65 | 2020-09-12 | 55073 | 1103 | TRUE |
21692 | 21692 | Sacramento | Sacramento | 67 | 2020-09-12 | 20063 | 350 | TRUE |
21693 | 21693 | San Benito | San Benito | 69 | 2020-09-12 | 1223 | 10 | |
21694 | 21694 | San Bernardino | San Bernardino | 71 | 2020-09-12 | 50543 | 1049 | |
21695 | 21695 | San Diego | San Diego | 73 | 2020-09-12 | 42414 | 734 | |
21696 | 21696 | San Francisco | San Francisco | 75 | 2020-09-12 | 10263 | 90 | |
21697 | 21697 | San Joaquin | San Joaquin | 77 | 2020-09-12 | 18687 | 383 | TRUE |
21698 | 21698 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-12 | 3222 | 23 | TRUE |
21699 | 21699 | San Mateo | San Mateo | 81 | 2020-09-12 | 9077 | 139 | |
21700 | 21700 | Santa Barbara | Santa Barbara | 83 | 2020-09-12 | 8608 | 105 | TRUE |
21701 | 21701 | Santa Clara | Santa Clara | 85 | 2020-09-12 | 19772 | 274 | |
21702 | 21702 | Santa Cruz | Santa Cruz | 87 | 2020-09-12 | 2043 | 7 | |
21703 | 21703 | Shasta | Shasta | 89 | 2020-09-12 | 612 | 12 | TRUE |
21704 | 21704 | Sierra | Sierra | 91 | 2020-09-12 | 6 | 0 | TRUE |
21705 | 21705 | Siskiyou | Siskiyou | 93 | 2020-09-12 | 155 | 0 | TRUE |
21706 | 21706 | Solano | Solano | 95 | 2020-09-12 | 5820 | 48 | TRUE |
21707 | 21707 | Sonoma | Sonoma | 97 | 2020-09-12 | 6666 | 108 | |
21708 | 21708 | Stanislaus | Stanislaus | 99 | 2020-09-12 | 15926 | 310 | |
21709 | 21709 | Sutter | Sutter | 101 | 2020-09-12 | 1564 | 10 | TRUE |
21710 | 21710 | Tehama | Tehama | 103 | 2020-09-12 | 465 | 1 | |
21711 | 21711 | Trinity | Trinity | 105 | 2020-09-12 | 14 | 0 | TRUE |
21712 | 21712 | Tulare | Tulare | 107 | 2020-09-12 | 15114 | 247 | TRUE |
21713 | 21713 | Tuolumne | Tuolumne | 109 | 2020-09-12 | 213 | 3 | TRUE |
21714 | 21714 | Ventura | Ventura | 111 | 2020-09-12 | 11482 | 129 | TRUE |
21715 | 21715 | Yolo | Yolo | 113 | 2020-09-12 | 2650 | 53 | |
21716 | 21716 | Yuba | Yuba | 115 | 2020-09-12 | 1057 | 7 | 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 );