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-11-09 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 |
---|---|---|---|---|---|---|---|---|
18118 | 18118 | Alameda | Alameda | 1 | 2020-11-09 | 24228 | 459 | |
18119 | 18119 | Berkeley | Alameda | 1 | 2020-11-09 | 843 | 10 | |
18120 | 18120 | Alpine | Alpine | 3 | 2020-11-09 | 25 | 0 | |
18121 | 18121 | Amador | Amador | 5 | 2020-11-09 | 348 | 15 | |
18122 | 18122 | Butte | Butte | 7 | 2020-11-09 | 3301 | 56 | |
18123 | 18123 | Calaveras | Calaveras | 9 | 2020-11-09 | 366 | 21 | TRUE |
18124 | 18124 | Colusa | Colusa | 11 | 2020-11-09 | 584 | 6 | |
18125 | 18125 | Contra Costa | Contra Costa | 13 | 2020-11-09 | 20166 | 253 | |
18126 | 18126 | Del Norte | Del Norte | 15 | 2020-11-09 | 204 | 1 | |
18127 | 18127 | El Dorado | El Dorado | 17 | 2020-11-09 | 1537 | 4 | |
18128 | 18128 | Fresno | Fresno | 19 | 2020-11-09 | 36022 | 454 | |
18129 | 18129 | Glenn | Glenn | 21 | 2020-11-09 | 729 | 4 | |
18130 | 18130 | Humboldt | Humboldt | 23 | 2020-11-09 | 621 | 9 | |
18131 | 18131 | Imperial | Imperial | 25 | 2020-11-09 | 13490 | 341 | |
18132 | 18132 | Inyo | Inyo | 27 | 2020-11-09 | 256 | 15 | |
18133 | 18133 | Kern | Kern | 29 | 2020-11-09 | 35467 | 429 | |
18134 | 18134 | Kings | Kings | 31 | 2020-11-09 | 9070 | 86 | |
18135 | 18135 | Lake | Lake | 33 | 2020-11-09 | 756 | 17 | |
18136 | 18136 | Lassen | Lassen | 35 | 2020-11-09 | 797 | 1 | TRUE |
18137 | 18137 | Long Beach | Los Angeles | 37 | 2020-11-09 | 13770 | 261 | |
18138 | 18138 | Los Angeles | Los Angeles | 37 | 2020-11-09 | 307042 | 6787 | |
18139 | 18139 | Pasadena | Los Angeles | 37 | 2020-11-09 | 2953 | 129 | |
18140 | 18140 | Madera | Madera | 39 | 2020-11-09 | 5306 | 76 | |
18141 | 18141 | Marin | Marin | 41 | 2020-11-09 | 7270 | 127 | |
18142 | 18142 | Mariposa | Mariposa | 43 | 2020-11-09 | 88 | 2 | |
18143 | 18143 | Mendocino | Mendocino | 45 | 2020-11-09 | 1238 | 21 | |
18144 | 18144 | Merced | Merced | 47 | 2020-11-09 | 10140 | 164 | |
18145 | 18145 | Modoc | Modoc | 49 | 2020-11-09 | 79 | 0 | |
18146 | 18146 | Mono | Mono | 51 | 2020-11-09 | 462 | 2 | |
18147 | 18147 | Monterey | Monterey | 53 | 2020-11-09 | 12366 | 101 | |
18148 | 18148 | Napa | Napa | 55 | 2020-11-09 | 2299 | 15 | |
18149 | 18149 | Nevada | Nevada | 57 | 2020-11-09 | 726 | 9 | |
18150 | 18150 | Orange | Orange | 59 | 2020-11-09 | 62563 | 1509 | |
18151 | 18151 | Placer | Placer | 61 | 2020-11-09 | 4853 | 60 | |
18152 | 18152 | Plumas | Plumas | 63 | 2020-11-09 | 107 | 0 | |
18153 | 18153 | Riverside | Riverside | 65 | 2020-11-09 | 71620 | 1338 | |
18154 | 18154 | Sacramento | Sacramento | 67 | 2020-11-09 | 28237 | 513 | |
18155 | 18155 | San Benito | San Benito | 69 | 2020-11-09 | 1517 | 15 | TRUE |
18156 | 18156 | San Bernardino | San Bernardino | 71 | 2020-11-09 | 68865 | 1281 | |
18157 | 18157 | San Diego | San Diego | 73 | 2020-11-09 | 60570 | 908 | |
18158 | 18158 | San Francisco | San Francisco | 75 | 2020-11-09 | 13081 | 151 | |
18159 | 18159 | San Joaquin | San Joaquin | 77 | 2020-11-09 | 22740 | 497 | |
18160 | 18160 | San Luis Obispo | San Luis Obispo | 79 | 2020-11-09 | 4794 | 33 | |
18161 | 18161 | San Mateo | San Mateo | 81 | 2020-11-09 | 11937 | 162 | |
18162 | 18162 | Santa Barbara | Santa Barbara | 83 | 2020-11-09 | 10230 | 131 | |
18163 | 18163 | Santa Clara | Santa Clara | 85 | 2020-11-09 | 27477 | 385 | |
18164 | 18164 | Santa Cruz | Santa Cruz | 87 | 2020-11-09 | 3221 | 26 | |
18165 | 18165 | Shasta | Shasta | 89 | 2020-11-09 | 2630 | 34 | |
18166 | 18166 | Sierra | Sierra | 91 | 2020-11-09 | 9 | 0 | |
18167 | 18167 | Siskiyou | Siskiyou | 93 | 2020-11-09 | 314 | 0 | |
18168 | 18168 | Solano | Solano | 95 | 2020-11-09 | 8366 | 79 | |
18169 | 18169 | Sonoma | Sonoma | 97 | 2020-11-09 | 10424 | 146 | |
18170 | 18170 | Stanislaus | Stanislaus | 99 | 2020-11-09 | 18549 | 408 | |
18171 | 18171 | Sutter | Sutter | 101 | 2020-11-09 | 2067 | 12 | |
18172 | 18172 | Tehama | Tehama | 103 | 2020-11-09 | 1018 | 19 | TRUE |
18173 | 18173 | Trinity | Trinity | 105 | 2020-11-09 | 62 | 0 | |
18174 | 18174 | Tulare | Tulare | 107 | 2020-11-09 | 18429 | 299 | |
18175 | 18175 | Tuolumne | Tuolumne | 109 | 2020-11-09 | 360 | 8 | |
18176 | 18176 | Ventura | Ventura | 111 | 2020-11-09 | 15387 | 171 | |
18177 | 18177 | Yolo | Yolo | 113 | 2020-11-09 | 3527 | 63 | |
18178 | 18178 | Yuba | Yuba | 115 | 2020-11-09 | 1486 | 10 |
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 );