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-06-22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
26658 | 26658 | Alameda | Alameda | 1 | 2020-06-22 | 5036 | 170 | |
26659 | 26659 | Berkeley | Alameda | 1 | 2020-06-22 | 126 | 2 | |
26660 | 26660 | Alpine | Alpine | 3 | 2020-06-22 | 1 | 0 | TRUE |
26661 | 26661 | Amador | Amador | 5 | 2020-06-22 | 14 | 0 | |
26662 | 26662 | Butte | Butte | 7 | 2020-06-22 | 104 | 1 | |
26663 | 26663 | Calaveras | Calaveras | 9 | 2020-06-22 | 28 | 0 | TRUE |
26664 | 26664 | Colusa | Colusa | 11 | 2020-06-22 | 7 | 0 | |
26665 | 26665 | Contra Costa | Contra Costa | 13 | 2020-06-22 | 2368 | 62 | |
26666 | 26666 | Del Norte | Del Norte | 15 | 2020-06-22 | 48 | 0 | |
26667 | 26667 | El Dorado | El Dorado | 17 | 2020-06-22 | 145 | 0 | |
26668 | 26668 | Fresno | Fresno | 19 | 2020-06-22 | 6764 | 67 | |
26669 | 26669 | Glenn | Glenn | 21 | 2020-06-22 | 42 | 0 | TRUE |
26670 | 26670 | Humboldt | Humboldt | 23 | 2020-06-22 | 112 | 4 | |
26671 | 26671 | Imperial | Imperial | 25 | 2020-06-22 | 4800 | 64 | TRUE |
26672 | 26672 | Inyo | Inyo | 27 | 2020-06-22 | 27 | 1 | |
26673 | 26673 | Kern | Kern | 29 | 2020-06-22 | 3965 | 60 | |
26674 | 26674 | Kings | Kings | 31 | 2020-06-22 | 2158 | 18 | |
26675 | 26675 | Lake | Lake | 33 | 2020-06-22 | 40 | 0 | |
26676 | 26676 | Lassen | Lassen | 35 | 2020-06-22 | 11 | 0 | TRUE |
26677 | 26677 | Long Beach | Los Angeles | 37 | 2020-06-22 | 3042 | 120 | |
26678 | 26678 | Los Angeles | Los Angeles | 37 | 2020-06-22 | 81798 | 2929 | |
26679 | 26679 | Pasadena | Los Angeles | 37 | 2020-06-22 | 1177 | 88 | |
26680 | 26680 | Madera | Madera | 39 | 2020-06-22 | 334 | 5 | |
26681 | 26681 | Marin | Marin | 41 | 2020-06-22 | 1250 | 18 | |
26682 | 26682 | Mariposa | Mariposa | 43 | 2020-06-22 | 18 | 1 | |
26683 | 26683 | Mendocino | Mendocino | 45 | 2020-06-22 | 62 | 0 | |
26684 | 26684 | Merced | Merced | 47 | 2020-06-22 | 661 | 9 | |
26685 | 26685 | Modoc | Modoc | 49 | 2020-06-22 | 0 | 0 | TRUE |
26686 | 26686 | Mono | Mono | 51 | 2020-06-22 | 39 | 1 | |
26687 | 26687 | Monterey | Monterey | 53 | 2020-06-22 | 1291 | 12 | |
26688 | 26688 | Napa | Napa | 55 | 2020-06-22 | 239 | 4 | |
26689 | 26689 | Nevada | Nevada | 57 | 2020-06-22 | 82 | 1 | |
26690 | 26690 | Orange | Orange | 59 | 2020-06-22 | 10595 | 269 | |
26691 | 26691 | Placer | Placer | 61 | 2020-06-22 | 519 | 9 | |
26692 | 26692 | Plumas | Plumas | 63 | 2020-06-22 | 6 | 0 | |
26693 | 26693 | Riverside | Riverside | 65 | 2020-06-22 | 13800 | 424 | |
26694 | 26694 | Sacramento | Sacramento | 67 | 2020-06-22 | 2243 | 66 | |
26695 | 26695 | San Benito | San Benito | 69 | 2020-06-22 | 181 | 2 | |
26696 | 26696 | San Bernardino | San Bernardino | 71 | 2020-06-22 | 9361 | 277 | |
26697 | 26697 | San Diego | San Diego | 73 | 2020-06-22 | 11096 | 338 | |
26698 | 26698 | San Francisco | San Francisco | 75 | 2020-06-22 | 3185 | 48 | |
26699 | 26699 | San Joaquin | San Joaquin | 77 | 2020-06-22 | 2458 | 48 | |
26700 | 26700 | San Luis Obispo | San Luis Obispo | 79 | 2020-06-22 | 442 | 1 | |
26701 | 26701 | San Mateo | San Mateo | 81 | 2020-06-22 | 2825 | 103 | |
26702 | 26702 | Santa Barbara | Santa Barbara | 83 | 2020-06-22 | 2446 | 27 | |
26703 | 26703 | Santa Clara | Santa Clara | 85 | 2020-06-22 | 3997 | 151 | |
26704 | 26704 | Santa Cruz | Santa Cruz | 87 | 2020-06-22 | 296 | 2 | |
26705 | 26705 | Shasta | Shasta | 89 | 2020-06-22 | 86 | 4 | |
26706 | 26706 | Sierra | Sierra | 91 | 2020-06-22 | 1 | 0 | |
26707 | 26707 | Siskiyou | Siskiyou | 93 | 2020-06-22 | 24 | 0 | |
26708 | 26708 | Solano | Solano | 95 | 2020-06-22 | 933 | 23 | |
26709 | 26709 | Sonoma | Sonoma | 97 | 2020-06-22 | 935 | 5 | TRUE |
26710 | 26710 | Stanislaus | Stanislaus | 99 | 2020-06-22 | 1639 | 37 | |
26711 | 26711 | Sutter | Sutter | 101 | 2020-06-22 | 118 | 3 | |
26712 | 26712 | Tehama | Tehama | 103 | 2020-06-22 | 53 | 1 | |
26713 | 26713 | Trinity | Trinity | 105 | 2020-06-22 | 2 | 0 | |
26714 | 26714 | Tulare | Tulare | 107 | 2020-06-22 | 3177 | 113 | |
26715 | 26715 | Tuolumne | Tuolumne | 109 | 2020-06-22 | 12 | 0 | TRUE |
26716 | 26716 | Ventura | Ventura | 111 | 2020-06-22 | 2030 | 43 | |
26717 | 26717 | Yolo | Yolo | 113 | 2020-06-22 | 347 | 24 | |
26718 | 26718 | Yuba | Yuba | 115 | 2020-06-22 | 43 | 1 |
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 );