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-04 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
22144 | 22144 | Alameda | Alameda | 1 | 2020-09-04 | 18423 | 388 | |
22145 | 22145 | Berkeley | Alameda | 1 | 2020-09-04 | 574 | 10 | |
22146 | 22146 | Alpine | Alpine | 3 | 2020-09-04 | 2 | 0 | TRUE |
22147 | 22147 | Amador | Amador | 5 | 2020-09-04 | 237 | 15 | |
22148 | 22148 | Butte | Butte | 7 | 2020-09-04 | 2325 | 23 | |
22149 | 22149 | Calaveras | Calaveras | 9 | 2020-09-04 | 273 | 2 | |
22150 | 22150 | Colusa | Colusa | 11 | 2020-09-04 | 470 | 6 | |
22151 | 22151 | Contra Costa | Contra Costa | 13 | 2020-09-04 | 14411 | 186 | |
22152 | 22152 | Del Norte | Del Norte | 15 | 2020-09-04 | 124 | 1 | |
22153 | 22153 | El Dorado | El Dorado | 17 | 2020-09-04 | 1001 | 2 | |
22154 | 22154 | Fresno | Fresno | 19 | 2020-09-04 | 28409 | 312 | |
22155 | 22155 | Glenn | Glenn | 21 | 2020-09-04 | 475 | 3 | |
22156 | 22156 | Humboldt | Humboldt | 23 | 2020-09-04 | 409 | 4 | |
22157 | 22157 | Imperial | Imperial | 25 | 2020-09-04 | 11001 | 296 | |
22158 | 22158 | Inyo | Inyo | 27 | 2020-09-04 | 183 | 13 | |
22159 | 22159 | Kern | Kern | 29 | 2020-09-04 | 29858 | 296 | |
22160 | 22160 | Kings | Kings | 31 | 2020-09-04 | 6688 | 76 | |
22161 | 22161 | Lake | Lake | 33 | 2020-09-04 | 360 | 5 | |
22162 | 22162 | Lassen | Lassen | 35 | 2020-09-04 | 720 | 0 | |
22163 | 22163 | Long Beach | Los Angeles | 37 | 2020-09-04 | 10852 | 227 | |
22164 | 22164 | Los Angeles | Los Angeles | 37 | 2020-09-04 | 233181 | 5637 | |
22165 | 22165 | Pasadena | Los Angeles | 37 | 2020-09-04 | 2424 | 117 | |
22166 | 22166 | Madera | Madera | 39 | 2020-09-04 | 3953 | 58 | |
22167 | 22167 | Marin | Marin | 41 | 2020-09-04 | 6297 | 96 | |
22168 | 22168 | Mariposa | Mariposa | 43 | 2020-09-04 | 74 | 2 | |
22169 | 22169 | Mendocino | Mendocino | 45 | 2020-09-04 | 737 | 17 | |
22170 | 22170 | Merced | Merced | 47 | 2020-09-04 | 8277 | 120 | |
22171 | 22171 | Modoc | Modoc | 49 | 2020-09-04 | 21 | 0 | |
22172 | 22172 | Mono | Mono | 51 | 2020-09-04 | 162 | 2 | |
22173 | 22173 | Monterey | Monterey | 53 | 2020-09-04 | 8326 | 58 | |
22174 | 22174 | Napa | Napa | 55 | 2020-09-04 | 1465 | 12 | |
22175 | 22175 | Nevada | Nevada | 57 | 2020-09-04 | 456 | 5 | |
22176 | 22176 | Orange | Orange | 59 | 2020-09-04 | 49258 | 1042 | |
22177 | 22177 | Placer | Placer | 61 | 2020-09-04 | 3115 | 35 | |
22178 | 22178 | Plumas | Plumas | 63 | 2020-09-04 | 45 | 0 | |
22179 | 22179 | Riverside | Riverside | 65 | 2020-09-04 | 53987 | 1067 | |
22180 | 22180 | Sacramento | Sacramento | 67 | 2020-09-04 | 18813 | 327 | |
22181 | 22181 | San Benito | San Benito | 69 | 2020-09-04 | 1162 | 8 | |
22182 | 22182 | San Bernardino | San Bernardino | 71 | 2020-09-04 | 48615 | 1010 | |
22183 | 22183 | San Diego | San Diego | 73 | 2020-09-04 | 39899 | 701 | |
22184 | 22184 | San Francisco | San Francisco | 75 | 2020-09-04 | 9755 | 84 | |
22185 | 22185 | San Joaquin | San Joaquin | 77 | 2020-09-04 | 18099 | 368 | |
22186 | 22186 | San Luis Obispo | San Luis Obispo | 79 | 2020-09-04 | 3074 | 22 | |
22187 | 22187 | San Mateo | San Mateo | 81 | 2020-09-04 | 8452 | 135 | |
22188 | 22188 | Santa Barbara | Santa Barbara | 83 | 2020-09-04 | 8361 | 97 | |
22189 | 22189 | Santa Clara | Santa Clara | 85 | 2020-09-04 | 18835 | 262 | |
22190 | 22190 | Santa Cruz | Santa Cruz | 87 | 2020-09-04 | 1923 | 7 | |
22191 | 22191 | Shasta | Shasta | 89 | 2020-09-04 | 581 | 12 | |
22192 | 22192 | Sierra | Sierra | 91 | 2020-09-04 | 6 | 0 | |
22193 | 22193 | Siskiyou | Siskiyou | 93 | 2020-09-04 | 144 | 0 | |
22194 | 22194 | Solano | Solano | 95 | 2020-09-04 | 5671 | 48 | |
22195 | 22195 | Sonoma | Sonoma | 97 | 2020-09-04 | 6142 | 93 | TRUE |
22196 | 22196 | Stanislaus | Stanislaus | 99 | 2020-09-04 | 15162 | 282 | |
22197 | 22197 | Sutter | Sutter | 101 | 2020-09-04 | 1465 | 10 | |
22198 | 22198 | Tehama | Tehama | 103 | 2020-09-04 | 436 | 1 | |
22199 | 22199 | Trinity | Trinity | 105 | 2020-09-04 | 13 | 0 | |
22200 | 22200 | Tulare | Tulare | 107 | 2020-09-04 | 14677 | 243 | |
22201 | 22201 | Tuolumne | Tuolumne | 109 | 2020-09-04 | 188 | 2 | |
22202 | 22202 | Ventura | Ventura | 111 | 2020-09-04 | 10943 | 118 | |
22203 | 22203 | Yolo | Yolo | 113 | 2020-09-04 | 2495 | 53 | |
22204 | 22204 | Yuba | Yuba | 115 | 2020-09-04 | 994 | 6 |
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 );