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-08-02 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 |
---|---|---|---|---|---|---|---|---|
24157 | 24157 | Alameda | Alameda | 1 | 2020-08-02 | 11446 | 234 | |
24158 | 24158 | Berkeley | Alameda | 1 | 2020-08-02 | 408 | 8 | |
24159 | 24159 | Alpine | Alpine | 3 | 2020-08-02 | 2 | 0 | TRUE |
24160 | 24160 | Amador | Amador | 5 | 2020-08-02 | 126 | 0 | TRUE |
24161 | 24161 | Butte | Butte | 7 | 2020-08-02 | 987 | 7 | TRUE |
24162 | 24162 | Calaveras | Calaveras | 9 | 2020-08-02 | 125 | 1 | TRUE |
24163 | 24163 | Colusa | Colusa | 11 | 2020-08-02 | 323 | 4 | TRUE |
24164 | 24164 | Contra Costa | Contra Costa | 13 | 2020-08-02 | 7966 | 125 | |
24165 | 24165 | Del Norte | Del Norte | 15 | 2020-08-02 | 88 | 0 | TRUE |
24166 | 24166 | El Dorado | El Dorado | 17 | 2020-08-02 | 637 | 1 | TRUE |
24167 | 24167 | Fresno | Fresno | 19 | 2020-08-02 | 22000 | 138 | TRUE |
24168 | 24168 | Glenn | Glenn | 21 | 2020-08-02 | 325 | 1 | TRUE |
24169 | 24169 | Humboldt | Humboldt | 23 | 2020-08-02 | 233 | 4 | TRUE |
24170 | 24170 | Imperial | Imperial | 25 | 2020-08-02 | 9409 | 220 | TRUE |
24171 | 24171 | Inyo | Inyo | 27 | 2020-08-02 | 61 | 1 | |
24172 | 24172 | Kern | Kern | 29 | 2020-08-02 | 20545 | 144 | |
24173 | 24173 | Kings | Kings | 31 | 2020-08-02 | 4453 | 56 | |
24174 | 24174 | Lake | Lake | 33 | 2020-08-02 | 195 | 1 | TRUE |
24175 | 24175 | Lassen | Lassen | 35 | 2020-08-02 | 598 | 0 | TRUE |
24176 | 24176 | Long Beach | Los Angeles | 37 | 2020-08-02 | 8285 | 177 | TRUE |
24177 | 24177 | Los Angeles | Los Angeles | 37 | 2020-08-02 | 181888 | 4407 | |
24178 | 24178 | Pasadena | Los Angeles | 37 | 2020-08-02 | 2004 | 109 | |
24179 | 24179 | Madera | Madera | 39 | 2020-08-02 | 1943 | 30 | TRUE |
24180 | 24180 | Marin | Marin | 41 | 2020-08-02 | 4938 | 70 | |
24181 | 24181 | Mariposa | Mariposa | 43 | 2020-08-02 | 57 | 2 | |
24182 | 24182 | Mendocino | Mendocino | 45 | 2020-08-02 | 322 | 9 | |
24183 | 24183 | Merced | Merced | 47 | 2020-08-02 | 4285 | 50 | TRUE |
24184 | 24184 | Modoc | Modoc | 49 | 2020-08-02 | 2 | 0 | TRUE |
24185 | 24185 | Mono | Mono | 51 | 2020-08-02 | 145 | 1 | |
24186 | 24186 | Monterey | Monterey | 53 | 2020-08-02 | 4822 | 30 | |
24187 | 24187 | Napa | Napa | 55 | 2020-08-02 | 888 | 8 | TRUE |
24188 | 24188 | Nevada | Nevada | 57 | 2020-08-02 | 299 | 1 | TRUE |
24189 | 24189 | Orange | Orange | 59 | 2020-08-02 | 37391 | 651 | |
24190 | 24190 | Placer | Placer | 61 | 2020-08-02 | 1925 | 16 | |
24191 | 24191 | Plumas | Plumas | 63 | 2020-08-02 | 33 | 0 | TRUE |
24192 | 24192 | Riverside | Riverside | 65 | 2020-08-02 | 37011 | 695 | TRUE |
24193 | 24193 | Sacramento | Sacramento | 67 | 2020-08-02 | 10067 | 142 | |
24194 | 24194 | San Benito | San Benito | 69 | 2020-08-02 | 647 | 4 | |
24195 | 24195 | San Bernardino | San Bernardino | 71 | 2020-08-02 | 32980 | 724 | |
24196 | 24196 | San Diego | San Diego | 73 | 2020-08-02 | 29883 | 565 | |
24197 | 24197 | San Francisco | San Francisco | 75 | 2020-08-02 | 6811 | 61 | |
24198 | 24198 | San Joaquin | San Joaquin | 77 | 2020-08-02 | 11483 | 168 | TRUE |
24199 | 24199 | San Luis Obispo | San Luis Obispo | 79 | 2020-08-02 | 1783 | 15 | TRUE |
24200 | 24200 | San Mateo | San Mateo | 81 | 2020-08-02 | 5544 | 119 | TRUE |
24201 | 24201 | Santa Barbara | Santa Barbara | 83 | 2020-08-02 | 6167 | 60 | TRUE |
24202 | 24202 | Santa Clara | Santa Clara | 85 | 2020-08-02 | 12276 | 199 | |
24203 | 24203 | Santa Cruz | Santa Cruz | 87 | 2020-08-02 | 1152 | 4 | TRUE |
24204 | 24204 | Shasta | Shasta | 89 | 2020-08-02 | 369 | 9 | TRUE |
24205 | 24205 | Sierra | Sierra | 91 | 2020-08-02 | 2 | 0 | TRUE |
24206 | 24206 | Siskiyou | Siskiyou | 93 | 2020-08-02 | 73 | 0 | TRUE |
24207 | 24207 | Solano | Solano | 95 | 2020-08-02 | 3611 | 37 | TRUE |
24208 | 24208 | Sonoma | Sonoma | 97 | 2020-08-02 | 3113 | 39 | |
24209 | 24209 | Stanislaus | Stanislaus | 99 | 2020-08-02 | 9221 | 112 | |
24210 | 24210 | Sutter | Sutter | 101 | 2020-08-02 | 795 | 6 | |
24211 | 24211 | Tehama | Tehama | 103 | 2020-08-02 | 234 | 1 | TRUE |
24212 | 24212 | Trinity | Trinity | 105 | 2020-08-02 | 5 | 0 | TRUE |
24213 | 24213 | Tulare | Tulare | 107 | 2020-08-02 | 9454 | 178 | TRUE |
24214 | 24214 | Tuolumne | Tuolumne | 109 | 2020-08-02 | 141 | 2 | TRUE |
24215 | 24215 | Ventura | Ventura | 111 | 2020-08-02 | 7344 | 76 | TRUE |
24216 | 24216 | Yolo | Yolo | 113 | 2020-08-02 | 1572 | 42 | |
24217 | 24217 | Yuba | Yuba | 115 | 2020-08-02 | 501 | 4 |
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 );