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-03-03 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 |
---|---|---|---|---|---|---|---|---|
11164 | 11164 | Alameda | Alameda | 1 | 2021-03-03 | 78066 | 1179 | |
11165 | 11165 | Berkeley | Alameda | 1 | 2021-03-03 | 3287 | 45 | |
11166 | 11166 | Alpine | Alpine | 3 | 2021-03-03 | 82 | 0 | TRUE |
11167 | 11167 | Amador | Amador | 5 | 2021-03-03 | 3444 | 41 | |
11168 | 11168 | Butte | Butte | 7 | 2021-03-03 | 11014 | 167 | |
11169 | 11169 | Calaveras | Calaveras | 9 | 2021-03-03 | 1918 | 49 | |
11170 | 11170 | Colusa | Colusa | 11 | 2021-03-03 | 2140 | 13 | |
11171 | 11171 | Contra Costa | Contra Costa | 13 | 2021-03-03 | 62931 | 695 | |
11172 | 11172 | Del Norte | Del Norte | 15 | 2021-03-03 | 1008 | 5 | |
11173 | 11173 | El Dorado | El Dorado | 17 | 2021-03-03 | 9195 | 100 | |
11174 | 11174 | Fresno | Fresno | 19 | 2021-03-03 | 96269 | 1451 | |
11175 | 11175 | Glenn | Glenn | 21 | 2021-03-03 | 2192 | 23 | |
11176 | 11176 | Humboldt | Humboldt | 23 | 2021-03-03 | 3230 | 33 | |
11177 | 11177 | Imperial | Imperial | 25 | 2021-03-03 | 26674 | 638 | |
11178 | 11178 | Inyo | Inyo | 27 | 2021-03-03 | 1321 | 37 | |
11179 | 11179 | Kern | Kern | 29 | 2021-03-03 | 103756 | 915 | |
11180 | 11180 | Kings | Kings | 31 | 2021-03-03 | 22091 | 220 | TRUE |
11181 | 11181 | Lake | Lake | 33 | 2021-03-03 | 3144 | 41 | |
11182 | 11182 | Lassen | Lassen | 35 | 2021-03-03 | 5623 | 24 | |
11183 | 11183 | Long Beach | Los Angeles | 37 | 2021-03-03 | 51412 | 856 | |
11184 | 11184 | Los Angeles | Los Angeles | 37 | 2021-03-03 | 1133656 | 20503 | |
11185 | 11185 | Pasadena | Los Angeles | 37 | 2021-03-03 | 10949 | 317 | |
11186 | 11186 | Madera | Madera | 39 | 2021-03-03 | 15472 | 214 | |
11187 | 11187 | Marin | Marin | 41 | 2021-03-03 | 13285 | 198 | |
11188 | 11188 | Mariposa | Mariposa | 43 | 2021-03-03 | 395 | 7 | |
11189 | 11189 | Mendocino | Mendocino | 45 | 2021-03-03 | 3826 | 43 | |
11190 | 11190 | Merced | Merced | 47 | 2021-03-03 | 29264 | 407 | |
11191 | 11191 | Modoc | Modoc | 49 | 2021-03-03 | 460 | 4 | |
11192 | 11192 | Mono | Mono | 51 | 2021-03-03 | 1214 | 4 | |
11193 | 11193 | Monterey | Monterey | 53 | 2021-03-03 | 42335 | 329 | |
11194 | 11194 | Napa | Napa | 55 | 2021-03-03 | 9054 | 71 | |
11195 | 11195 | Nevada | Nevada | 57 | 2021-03-03 | 3988 | 74 | |
11196 | 11196 | Orange | Orange | 59 | 2021-03-03 | 246980 | 3966 | |
11197 | 11197 | Placer | Placer | 61 | 2021-03-03 | 19911 | 232 | |
11198 | 11198 | Plumas | Plumas | 63 | 2021-03-03 | 653 | 6 | TRUE |
11199 | 11199 | Riverside | Riverside | 65 | 2021-03-03 | 290498 | 3849 | |
11200 | 11200 | Sacramento | Sacramento | 67 | 2021-03-03 | 93790 | 1498 | |
11201 | 11201 | San Benito | San Benito | 69 | 2021-03-03 | 5695 | 61 | |
11202 | 11202 | San Bernardino | San Bernardino | 71 | 2021-03-03 | 287055 | 4636 | |
11203 | 11203 | San Diego | San Diego | 73 | 2021-03-03 | 261353 | 3342 | |
11204 | 11204 | San Francisco | San Francisco | 75 | 2021-03-03 | 34153 | 422 | |
11205 | 11205 | San Joaquin | San Joaquin | 77 | 2021-03-03 | 67123 | 1150 | |
11206 | 11206 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-03 | 19751 | 238 | |
11207 | 11207 | San Mateo | San Mateo | 81 | 2021-03-03 | 38912 | 521 | |
11208 | 11208 | Santa Barbara | Santa Barbara | 83 | 2021-03-03 | 32147 | 420 | |
11209 | 11209 | Santa Clara | Santa Clara | 85 | 2021-03-03 | 110755 | 1598 | |
11210 | 11210 | Santa Cruz | Santa Cruz | 87 | 2021-03-03 | 14736 | 183 | |
11211 | 11211 | Shasta | Shasta | 89 | 2021-03-03 | 11054 | 179 | |
11212 | 11212 | Sierra | Sierra | 91 | 2021-03-03 | 100 | 0 | |
11213 | 11213 | Siskiyou | Siskiyou | 93 | 2021-03-03 | 1784 | 14 | |
11214 | 11214 | Solano | Solano | 95 | 2021-03-03 | 30216 | 165 | |
11215 | 11215 | Sonoma | Sonoma | 97 | 2021-03-03 | 28185 | 301 | |
11216 | 11216 | Stanislaus | Stanislaus | 99 | 2021-03-03 | 50727 | 953 | |
11217 | 11217 | Sutter | Sutter | 101 | 2021-03-03 | 8899 | 98 | |
11218 | 11218 | Tehama | Tehama | 103 | 2021-03-03 | 5104 | 52 | TRUE |
11219 | 11219 | Trinity | Trinity | 105 | 2021-03-03 | 373 | 5 | |
11220 | 11220 | Tulare | Tulare | 107 | 2021-03-03 | 48114 | 768 | |
11221 | 11221 | Tuolumne | Tuolumne | 109 | 2021-03-03 | 3966 | 59 | |
11222 | 11222 | Ventura | Ventura | 111 | 2021-03-03 | 77783 | 870 | |
11223 | 11223 | Yolo | Yolo | 113 | 2021-03-03 | 12747 | 185 | |
11224 | 11224 | Yuba | Yuba | 115 | 2021-03-03 | 5776 | 38 |
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 );