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-01-15 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 |
---|---|---|---|---|---|---|---|---|
14031 | 14031 | Alameda | Alameda | 1 | 2021-01-15 | 63188 | 1002 | |
14032 | 14032 | Berkeley | Alameda | 1 | 2021-01-15 | 2312 | 41 | |
14033 | 14033 | Alpine | Alpine | 3 | 2021-01-15 | 73 | 0 | |
14034 | 14034 | Amador | Amador | 5 | 2021-01-15 | 2951 | 29 | |
14035 | 14035 | Butte | Butte | 7 | 2021-01-15 | 9233 | 121 | |
14036 | 14036 | Calaveras | Calaveras | 9 | 2021-01-15 | 1240 | 23 | |
14037 | 14037 | Colusa | Colusa | 11 | 2021-01-15 | 1691 | 9 | |
14038 | 14038 | Contra Costa | Contra Costa | 13 | 2021-01-15 | 50627 | 430 | |
14039 | 14039 | Del Norte | Del Norte | 15 | 2021-01-15 | 847 | 2 | |
14040 | 14040 | El Dorado | El Dorado | 17 | 2021-01-15 | 7515 | 44 | |
14041 | 14041 | Fresno | Fresno | 19 | 2021-01-15 | 84934 | 932 | |
14042 | 14042 | Glenn | Glenn | 21 | 2021-01-15 | 1798 | 19 | |
14043 | 14043 | Humboldt | Humboldt | 23 | 2021-01-15 | 2263 | 24 | |
14044 | 14044 | Imperial | Imperial | 25 | 2021-01-15 | 24620 | 463 | |
14045 | 14045 | Inyo | Inyo | 27 | 2021-01-15 | 924 | 29 | |
14046 | 14046 | Kern | Kern | 29 | 2021-01-15 | 83547 | 558 | |
14047 | 14047 | Kings | Kings | 31 | 2021-01-15 | 18453 | 110 | TRUE |
14048 | 14048 | Lake | Lake | 33 | 2021-01-15 | 2417 | 28 | |
14049 | 14049 | Lassen | Lassen | 35 | 2021-01-15 | 5094 | 13 | |
14050 | 14050 | Long Beach | Los Angeles | 37 | 2021-01-15 | 42888 | 520 | |
14051 | 14051 | Los Angeles | Los Angeles | 37 | 2021-01-15 | 938706 | 12794 | |
14052 | 14052 | Pasadena | Los Angeles | 37 | 2021-01-15 | 9038 | 190 | |
14053 | 14053 | Madera | Madera | 39 | 2021-01-15 | 12778 | 130 | |
14054 | 14054 | Marin | Marin | 41 | 2021-01-15 | 11345 | 153 | |
14055 | 14055 | Mariposa | Mariposa | 43 | 2021-01-15 | 341 | 4 | |
14056 | 14056 | Mendocino | Mendocino | 45 | 2021-01-15 | 3076 | 31 | |
14057 | 14057 | Merced | Merced | 47 | 2021-01-15 | 23492 | 296 | |
14058 | 14058 | Modoc | Modoc | 49 | 2021-01-15 | 378 | 3 | TRUE |
14059 | 14059 | Mono | Mono | 51 | 2021-01-15 | 1083 | 4 | |
14060 | 14060 | Monterey | Monterey | 53 | 2021-01-15 | 34959 | 249 | |
14061 | 14061 | Napa | Napa | 55 | 2021-01-15 | 7157 | 38 | |
14062 | 14062 | Nevada | Nevada | 57 | 2021-01-15 | 3099 | 73 | |
14063 | 14063 | Orange | Orange | 59 | 2021-01-15 | 205911 | 2277 | |
14064 | 14064 | Placer | Placer | 61 | 2021-01-15 | 16761 | 173 | |
14065 | 14065 | Plumas | Plumas | 63 | 2021-01-15 | 573 | 5 | |
14066 | 14066 | Riverside | Riverside | 65 | 2021-01-15 | 233899 | 2517 | |
14067 | 14067 | Sacramento | Sacramento | 67 | 2021-01-15 | 77940 | 1080 | |
14068 | 14068 | San Benito | San Benito | 69 | 2021-01-15 | 4778 | 43 | |
14069 | 14069 | San Bernardino | San Bernardino | 71 | 2021-01-15 | 245033 | 3567 | |
14070 | 14070 | San Diego | San Diego | 73 | 2021-01-15 | 206870 | 2037 | |
14071 | 14071 | San Francisco | San Francisco | 75 | 2021-01-15 | 27878 | 241 | |
14072 | 14072 | San Joaquin | San Joaquin | 77 | 2021-01-15 | 56484 | 748 | |
14073 | 14073 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-15 | 15102 | 128 | |
14074 | 14074 | San Mateo | San Mateo | 81 | 2021-01-15 | 30650 | 294 | |
14075 | 14075 | Santa Barbara | Santa Barbara | 83 | 2021-01-15 | 23538 | 228 | |
14076 | 14076 | Santa Clara | Santa Clara | 85 | 2021-01-15 | 93386 | 1152 | |
14077 | 14077 | Santa Cruz | Santa Cruz | 87 | 2021-01-15 | 11715 | 113 | |
14078 | 14078 | Shasta | Shasta | 89 | 2021-01-15 | 9594 | 117 | |
14079 | 14079 | Sierra | Sierra | 91 | 2021-01-15 | 70 | 0 | |
14080 | 14080 | Siskiyou | Siskiyou | 93 | 2021-01-15 | 1408 | 13 | |
14081 | 14081 | Solano | Solano | 95 | 2021-01-15 | 24654 | 105 | |
14082 | 14082 | Sonoma | Sonoma | 97 | 2021-01-15 | 23089 | 234 | |
14083 | 14083 | Stanislaus | Stanislaus | 99 | 2021-01-15 | 41270 | 730 | |
14084 | 14084 | Sutter | Sutter | 101 | 2021-01-15 | 7484 | 77 | |
14085 | 14085 | Tehama | Tehama | 103 | 2021-01-15 | 3971 | 42 | |
14086 | 14086 | Trinity | Trinity | 105 | 2021-01-15 | 302 | 4 | |
14087 | 14087 | Tulare | Tulare | 107 | 2021-01-15 | 40176 | 501 | |
14088 | 14088 | Tuolumne | Tuolumne | 109 | 2021-01-15 | 3304 | 38 | |
14089 | 14089 | Ventura | Ventura | 111 | 2021-01-15 | 57611 | 412 | |
14090 | 14090 | Yolo | Yolo | 113 | 2021-01-15 | 9747 | 131 | |
14091 | 14091 | Yuba | Yuba | 115 | 2021-01-15 | 4818 | 27 |
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 );