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-29 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 |
---|---|---|---|---|---|---|---|---|
13177 | 13177 | Alameda | Alameda | 1 | 2021-01-29 | 70676 | 1110 | |
13178 | 13178 | Berkeley | Alameda | 1 | 2021-01-29 | 2645 | 42 | |
13179 | 13179 | Alpine | Alpine | 3 | 2021-01-29 | 74 | 0 | |
13180 | 13180 | Amador | Amador | 5 | 2021-01-29 | 3147 | 33 | |
13181 | 13181 | Butte | Butte | 7 | 2021-01-29 | 10122 | 138 | |
13182 | 13182 | Calaveras | Calaveras | 9 | 2021-01-29 | 1637 | 23 | |
13183 | 13183 | Colusa | Colusa | 11 | 2021-01-29 | 1935 | 10 | |
13184 | 13184 | Contra Costa | Contra Costa | 13 | 2021-01-29 | 56575 | 528 | |
13185 | 13185 | Del Norte | Del Norte | 15 | 2021-01-29 | 883 | 3 | |
13186 | 13186 | El Dorado | El Dorado | 17 | 2021-01-29 | 8359 | 79 | |
13187 | 13187 | Fresno | Fresno | 19 | 2021-01-29 | 90500 | 1137 | |
13188 | 13188 | Glenn | Glenn | 21 | 2021-01-29 | 1998 | 23 | |
13189 | 13189 | Humboldt | Humboldt | 23 | 2021-01-29 | 2754 | 30 | |
13190 | 13190 | Imperial | Imperial | 25 | 2021-01-29 | 25948 | 532 | |
13191 | 13191 | Inyo | Inyo | 27 | 2021-01-29 | 1083 | 29 | |
13192 | 13192 | Kern | Kern | 29 | 2021-01-29 | 92992 | 616 | |
13193 | 13193 | Kings | Kings | 31 | 2021-01-29 | 20292 | 169 | TRUE |
13194 | 13194 | Lake | Lake | 33 | 2021-01-29 | 2748 | 32 | |
13195 | 13195 | Lassen | Lassen | 35 | 2021-01-29 | 5393 | 16 | |
13196 | 13196 | Long Beach | Los Angeles | 37 | 2021-01-29 | 47844 | 663 | |
13197 | 13197 | Los Angeles | Los Angeles | 37 | 2021-01-29 | 1046730 | 15439 | |
13198 | 13198 | Pasadena | Los Angeles | 37 | 2021-01-29 | 10106 | 251 | |
13199 | 13199 | Madera | Madera | 39 | 2021-01-29 | 14250 | 175 | |
13200 | 13200 | Marin | Marin | 41 | 2021-01-29 | 12157 | 172 | |
13201 | 13201 | Mariposa | Mariposa | 43 | 2021-01-29 | 358 | 5 | |
13202 | 13202 | Mendocino | Mendocino | 45 | 2021-01-29 | 3392 | 37 | |
13203 | 13203 | Merced | Merced | 47 | 2021-01-29 | 26230 | 350 | |
13204 | 13204 | Modoc | Modoc | 49 | 2021-01-29 | 407 | 4 | |
13205 | 13205 | Mono | Mono | 51 | 2021-01-29 | 1164 | 4 | |
13206 | 13206 | Monterey | Monterey | 53 | 2021-01-29 | 39040 | 284 | |
13207 | 13207 | Napa | Napa | 55 | 2021-01-29 | 8198 | 52 | |
13208 | 13208 | Nevada | Nevada | 57 | 2021-01-29 | 3454 | 74 | |
13209 | 13209 | Orange | Orange | 59 | 2021-01-29 | 229757 | 2975 | |
13210 | 13210 | Placer | Placer | 61 | 2021-01-29 | 18399 | 199 | |
13211 | 13211 | Plumas | Plumas | 63 | 2021-01-29 | 626 | 6 | |
13212 | 13212 | Riverside | Riverside | 65 | 2021-01-29 | 271910 | 3091 | |
13213 | 13213 | Sacramento | Sacramento | 67 | 2021-01-29 | 85392 | 1239 | |
13214 | 13214 | San Benito | San Benito | 69 | 2021-01-29 | 5300 | 52 | |
13215 | 13215 | San Bernardino | San Bernardino | 71 | 2021-01-29 | 272198 | 4114 | |
13216 | 13216 | San Diego | San Diego | 73 | 2021-01-29 | 234640 | 2571 | |
13217 | 13217 | San Francisco | San Francisco | 75 | 2021-01-29 | 30814 | 317 | |
13218 | 13218 | San Joaquin | San Joaquin | 77 | 2021-01-29 | 61901 | 853 | |
13219 | 13219 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-29 | 17605 | 168 | |
13220 | 13220 | San Mateo | San Mateo | 81 | 2021-01-29 | 35235 | 382 | |
13221 | 13221 | Santa Barbara | Santa Barbara | 83 | 2021-01-29 | 28150 | 289 | |
13222 | 13222 | Santa Clara | Santa Clara | 85 | 2021-01-29 | 101909 | 1368 | |
13223 | 13223 | Santa Cruz | Santa Cruz | 87 | 2021-01-29 | 13321 | 148 | |
13224 | 13224 | Shasta | Shasta | 89 | 2021-01-29 | 10333 | 142 | |
13225 | 13225 | Sierra | Sierra | 91 | 2021-01-29 | 95 | 0 | |
13226 | 13226 | Siskiyou | Siskiyou | 93 | 2021-01-29 | 1532 | 13 | |
13227 | 13227 | Solano | Solano | 95 | 2021-01-29 | 27706 | 122 | |
13228 | 13228 | Sonoma | Sonoma | 97 | 2021-01-29 | 25825 | 260 | |
13229 | 13229 | Stanislaus | Stanislaus | 99 | 2021-01-29 | 45264 | 815 | |
13230 | 13230 | Sutter | Sutter | 101 | 2021-01-29 | 8264 | 86 | |
13231 | 13231 | Tehama | Tehama | 103 | 2021-01-29 | 4626 | 46 | |
13232 | 13232 | Trinity | Trinity | 105 | 2021-01-29 | 307 | 5 | |
13233 | 13233 | Tulare | Tulare | 107 | 2021-01-29 | 44518 | 588 | |
13234 | 13234 | Tuolumne | Tuolumne | 109 | 2021-01-29 | 3549 | 49 | |
13235 | 13235 | Ventura | Ventura | 111 | 2021-01-29 | 69050 | 598 | |
13236 | 13236 | Yolo | Yolo | 113 | 2021-01-29 | 11434 | 149 | |
13237 | 13237 | Yuba | Yuba | 115 | 2021-01-29 | 5324 | 31 |
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 );