latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
56 rows where "date" is on date 2020-04-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
31134 | 31134 | Alameda | Alameda | 1 | 2020-04-08 | 679 | 54 | |
31135 | 31135 | Berkeley | Alameda | 1 | 2020-04-08 | 33 | 1 | |
31136 | 31136 | Alpine | Alpine | 3 | 2020-04-08 | 1 | 0 | |
31137 | 31137 | Amador | Amador | 5 | 2020-04-08 | 3 | 0 | |
31138 | 31138 | Butte | Butte | 7 | 2020-04-08 | 11 | 0 | |
31139 | 31139 | Calaveras | Calaveras | 9 | 2020-04-08 | 5 | 0 | |
31140 | 31140 | Colusa | Colusa | 11 | 2020-04-08 | 3 | 0 | |
31141 | 31141 | Contra Costa | Contra Costa | 13 | 2020-04-08 | 482 | 7 | |
31142 | 31142 | Del Norte | Del Norte | 15 | 2020-04-08 | 2 | 0 | |
31143 | 31143 | El Dorado | El Dorado | 17 | 2020-04-08 | 29 | 0 | |
31144 | 31144 | Fresno | Fresno | 19 | 2020-04-08 | 372 | 3 | |
31145 | 31145 | Glenn | Glenn | 21 | 2020-04-08 | 2 | 0 | |
31146 | 31146 | Humboldt | Humboldt | 23 | 2020-04-08 | 50 | 0 | |
31147 | 31147 | Imperial | Imperial | 25 | 2020-04-08 | 75 | 3 | |
31148 | 31148 | Inyo | Inyo | 27 | 2020-04-08 | 11 | 0 | |
31149 | 31149 | Kern | Kern | 29 | 2020-04-08 | 303 | 2 | |
31150 | 31150 | Kings | Kings | 31 | 2020-04-08 | 8 | 0 | |
31151 | 31151 | Lake | Lake | 33 | 2020-04-08 | 3 | 0 | |
31152 | 31152 | Long Beach | Los Angeles | 37 | 2020-04-08 | 285 | 7 | |
31153 | 31153 | Los Angeles | Los Angeles | 37 | 2020-04-08 | 7194 | 189 | |
31154 | 31154 | Pasadena | Los Angeles | 37 | 2020-04-08 | 94 | 4 | |
31155 | 31155 | Madera | Madera | 39 | 2020-04-08 | 28 | 1 | |
31156 | 31156 | Marin | Marin | 41 | 2020-04-08 | 149 | 10 | |
31157 | 31157 | Mendocino | Mendocino | 45 | 2020-04-08 | 4 | 0 | |
31158 | 31158 | Merced | Merced | 47 | 2020-04-08 | 40 | 3 | |
31159 | 31159 | Mono | Mono | 51 | 2020-04-08 | 20 | 1 | |
31160 | 31160 | Monterey | Monterey | 53 | 2020-04-08 | 69 | 3 | |
31161 | 31161 | Napa | Napa | 55 | 2020-04-08 | 25 | 2 | |
31162 | 31162 | Nevada | Nevada | 57 | 2020-04-08 | 34 | 1 | |
31163 | 31163 | Orange | Orange | 59 | 2020-04-08 | 998 | 17 | |
31164 | 31164 | Placer | Placer | 61 | 2020-04-08 | 117 | 4 | |
31165 | 31165 | Plumas | Plumas | 63 | 2020-04-08 | 3 | 0 | |
31166 | 31166 | Riverside | Riverside | 65 | 2020-04-08 | 1179 | 32 | |
31167 | 31167 | Sacramento | Sacramento | 67 | 2020-04-08 | 580 | 22 | |
31168 | 31168 | San Benito | San Benito | 69 | 2020-04-08 | 33 | 2 | |
31169 | 31169 | San Bernardino | San Bernardino | 71 | 2020-04-08 | 641 | 26 | |
31170 | 31170 | San Diego | San Diego | 73 | 2020-04-08 | 1530 | 36 | |
31171 | 31171 | San Francisco | San Francisco | 75 | 2020-04-08 | 676 | 10 | |
31172 | 31172 | San Joaquin | San Joaquin | 77 | 2020-04-08 | 224 | 14 | |
31173 | 31173 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-08 | 102 | 1 | |
31174 | 31174 | San Mateo | San Mateo | 81 | 2020-04-08 | 617 | 21 | |
31175 | 31175 | Santa Barbara | Santa Barbara | 83 | 2020-04-08 | 228 | 2 | |
31176 | 31176 | Santa Clara | Santa Clara | 85 | 2020-04-08 | 1535 | 51 | |
31177 | 31177 | Santa Cruz | Santa Cruz | 87 | 2020-04-08 | 76 | 1 | TRUE |
31178 | 31178 | Shasta | Shasta | 89 | 2020-04-08 | 24 | 3 | |
31179 | 31179 | Siskiyou | Siskiyou | 93 | 2020-04-08 | 4 | 0 | |
31180 | 31180 | Solano | Solano | 95 | 2020-04-08 | 112 | 2 | |
31181 | 31181 | Sonoma | Sonoma | 97 | 2020-04-08 | 136 | 1 | |
31182 | 31182 | Stanislaus | Stanislaus | 99 | 2020-04-08 | 95 | 0 | |
31183 | 31183 | Sutter | Sutter | 101 | 2020-04-08 | 20 | 2 | |
31184 | 31184 | Tehama | Tehama | 103 | 2020-04-08 | 1 | 0 | TRUE |
31185 | 31185 | Tulare | Tulare | 107 | 2020-04-08 | 168 | 9 | |
31186 | 31186 | Tuolumne | Tuolumne | 109 | 2020-04-08 | 1 | 0 | TRUE |
31187 | 31187 | Ventura | Ventura | 111 | 2020-04-08 | 263 | 7 | |
31188 | 31188 | Yolo | Yolo | 113 | 2020-04-08 | 67 | 3 | |
31189 | 31189 | Yuba | Yuba | 115 | 2020-04-08 | 15 | 0 |
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 );