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-01-30 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 |
---|---|---|---|---|---|---|---|---|
13116 | 13116 | Alameda | Alameda | 1 | 2021-01-30 | 71061 | 1114 | |
13117 | 13117 | Berkeley | Alameda | 1 | 2021-01-30 | 2669 | 43 | |
13118 | 13118 | Alpine | Alpine | 3 | 2021-01-30 | 74 | 0 | TRUE |
13119 | 13119 | Amador | Amador | 5 | 2021-01-30 | 3156 | 33 | |
13120 | 13120 | Butte | Butte | 7 | 2021-01-30 | 10177 | 138 | TRUE |
13121 | 13121 | Calaveras | Calaveras | 9 | 2021-01-30 | 1637 | 23 | TRUE |
13122 | 13122 | Colusa | Colusa | 11 | 2021-01-30 | 1935 | 10 | TRUE |
13123 | 13123 | Contra Costa | Contra Costa | 13 | 2021-01-30 | 57021 | 529 | |
13124 | 13124 | Del Norte | Del Norte | 15 | 2021-01-30 | 883 | 3 | TRUE |
13125 | 13125 | El Dorado | El Dorado | 17 | 2021-01-30 | 8359 | 79 | TRUE |
13126 | 13126 | Fresno | Fresno | 19 | 2021-01-30 | 90710 | 1137 | |
13127 | 13127 | Glenn | Glenn | 21 | 2021-01-30 | 1998 | 23 | TRUE |
13128 | 13128 | Humboldt | Humboldt | 23 | 2021-01-30 | 2754 | 30 | TRUE |
13129 | 13129 | Imperial | Imperial | 25 | 2021-01-30 | 25948 | 532 | TRUE |
13130 | 13130 | Inyo | Inyo | 27 | 2021-01-30 | 1083 | 29 | TRUE |
13131 | 13131 | Kern | Kern | 29 | 2021-01-30 | 93628 | 624 | |
13132 | 13132 | Kings | Kings | 31 | 2021-01-30 | 20668 | 171 | |
13133 | 13133 | Lake | Lake | 33 | 2021-01-30 | 2748 | 32 | TRUE |
13134 | 13134 | Lassen | Lassen | 35 | 2021-01-30 | 5393 | 16 | TRUE |
13135 | 13135 | Long Beach | Los Angeles | 37 | 2021-01-30 | 48096 | 666 | |
13136 | 13136 | Los Angeles | Los Angeles | 37 | 2021-01-30 | 1053139 | 15733 | |
13137 | 13137 | Pasadena | Los Angeles | 37 | 2021-01-30 | 10156 | 253 | |
13138 | 13138 | Madera | Madera | 39 | 2021-01-30 | 14250 | 175 | TRUE |
13139 | 13139 | Marin | Marin | 41 | 2021-01-30 | 12284 | 172 | |
13140 | 13140 | Mariposa | Mariposa | 43 | 2021-01-30 | 367 | 5 | |
13141 | 13141 | Mendocino | Mendocino | 45 | 2021-01-30 | 3392 | 37 | TRUE |
13142 | 13142 | Merced | Merced | 47 | 2021-01-30 | 26230 | 350 | TRUE |
13143 | 13143 | Modoc | Modoc | 49 | 2021-01-30 | 407 | 4 | TRUE |
13144 | 13144 | Mono | Mono | 51 | 2021-01-30 | 1164 | 4 | TRUE |
13145 | 13145 | Monterey | Monterey | 53 | 2021-01-30 | 39425 | 285 | |
13146 | 13146 | Napa | Napa | 55 | 2021-01-30 | 8198 | 52 | TRUE |
13147 | 13147 | Nevada | Nevada | 57 | 2021-01-30 | 3454 | 74 | TRUE |
13148 | 13148 | Orange | Orange | 59 | 2021-01-30 | 231036 | 3018 | |
13149 | 13149 | Placer | Placer | 61 | 2021-01-30 | 18399 | 199 | TRUE |
13150 | 13150 | Plumas | Plumas | 63 | 2021-01-30 | 626 | 6 | TRUE |
13151 | 13151 | Riverside | Riverside | 65 | 2021-01-30 | 271910 | 3091 | TRUE |
13152 | 13152 | Sacramento | Sacramento | 67 | 2021-01-30 | 85392 | 1239 | TRUE |
13153 | 13153 | San Benito | San Benito | 69 | 2021-01-30 | 5319 | 52 | |
13154 | 13154 | San Bernardino | San Bernardino | 71 | 2021-01-30 | 273520 | 4134 | |
13155 | 13155 | San Diego | San Diego | 73 | 2021-01-30 | 236768 | 2603 | |
13156 | 13156 | San Francisco | San Francisco | 75 | 2021-01-30 | 30943 | 323 | |
13157 | 13157 | San Joaquin | San Joaquin | 77 | 2021-01-30 | 61901 | 853 | TRUE |
13158 | 13158 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-30 | 17605 | 168 | TRUE |
13159 | 13159 | San Mateo | San Mateo | 81 | 2021-01-30 | 35466 | 382 | |
13160 | 13160 | Santa Barbara | Santa Barbara | 83 | 2021-01-30 | 28338 | 291 | |
13161 | 13161 | Santa Clara | Santa Clara | 85 | 2021-01-30 | 102290 | 1372 | |
13162 | 13162 | Santa Cruz | Santa Cruz | 87 | 2021-01-30 | 13321 | 148 | TRUE |
13163 | 13163 | Shasta | Shasta | 89 | 2021-01-30 | 10333 | 142 | TRUE |
13164 | 13164 | Sierra | Sierra | 91 | 2021-01-30 | 95 | 0 | TRUE |
13165 | 13165 | Siskiyou | Siskiyou | 93 | 2021-01-30 | 1532 | 13 | TRUE |
13166 | 13166 | Solano | Solano | 95 | 2021-01-30 | 27706 | 122 | TRUE |
13167 | 13167 | Sonoma | Sonoma | 97 | 2021-01-30 | 25992 | 260 | |
13168 | 13168 | Stanislaus | Stanislaus | 99 | 2021-01-30 | 45840 | 828 | |
13169 | 13169 | Sutter | Sutter | 101 | 2021-01-30 | 8264 | 86 | TRUE |
13170 | 13170 | Tehama | Tehama | 103 | 2021-01-30 | 4660 | 47 | |
13171 | 13171 | Trinity | Trinity | 105 | 2021-01-30 | 307 | 5 | TRUE |
13172 | 13172 | Tulare | Tulare | 107 | 2021-01-30 | 44518 | 588 | TRUE |
13173 | 13173 | Tuolumne | Tuolumne | 109 | 2021-01-30 | 3549 | 49 | TRUE |
13174 | 13174 | Ventura | Ventura | 111 | 2021-01-30 | 69050 | 598 | TRUE |
13175 | 13175 | Yolo | Yolo | 113 | 2021-01-30 | 11530 | 149 | |
13176 | 13176 | Yuba | Yuba | 115 | 2021-01-30 | 5324 | 31 | TRUE |
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 );