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-05 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 |
---|---|---|---|---|---|---|---|---|
11042 | 11042 | Alameda | Alameda | 1 | 2021-03-05 | 78319 | 1181 | |
11043 | 11043 | Berkeley | Alameda | 1 | 2021-03-05 | 3304 | 45 | |
11044 | 11044 | Alpine | Alpine | 3 | 2021-03-05 | 84 | 0 | |
11045 | 11045 | Amador | Amador | 5 | 2021-03-05 | 3455 | 41 | |
11046 | 11046 | Butte | Butte | 7 | 2021-03-05 | 11050 | 169 | |
11047 | 11047 | Calaveras | Calaveras | 9 | 2021-03-05 | 1928 | 49 | |
11048 | 11048 | Colusa | Colusa | 11 | 2021-03-05 | 2142 | 13 | |
11049 | 11049 | Contra Costa | Contra Costa | 13 | 2021-03-05 | 63142 | 701 | |
11050 | 11050 | Del Norte | Del Norte | 15 | 2021-03-05 | 1020 | 5 | |
11051 | 11051 | El Dorado | El Dorado | 17 | 2021-03-05 | 9204 | 100 | |
11052 | 11052 | Fresno | Fresno | 19 | 2021-03-05 | 96573 | 1466 | |
11053 | 11053 | Glenn | Glenn | 21 | 2021-03-05 | 2196 | 23 | |
11054 | 11054 | Humboldt | Humboldt | 23 | 2021-03-05 | 3266 | 33 | |
11055 | 11055 | Imperial | Imperial | 25 | 2021-03-05 | 26708 | 641 | |
11056 | 11056 | Inyo | Inyo | 27 | 2021-03-05 | 1334 | 37 | |
11057 | 11057 | Kern | Kern | 29 | 2021-03-05 | 104057 | 937 | |
11058 | 11058 | Kings | Kings | 31 | 2021-03-05 | 22150 | 227 | |
11059 | 11059 | Lake | Lake | 33 | 2021-03-05 | 3160 | 41 | |
11060 | 11060 | Lassen | Lassen | 35 | 2021-03-05 | 5623 | 24 | TRUE |
11061 | 11061 | Long Beach | Los Angeles | 37 | 2021-03-05 | 51475 | 857 | |
11062 | 11062 | Los Angeles | Los Angeles | 37 | 2021-03-05 | 1137679 | 20735 | |
11063 | 11063 | Pasadena | Los Angeles | 37 | 2021-03-05 | 10962 | 318 | |
11064 | 11064 | Madera | Madera | 39 | 2021-03-05 | 15540 | 214 | TRUE |
11065 | 11065 | Marin | Marin | 41 | 2021-03-05 | 13358 | 198 | |
11066 | 11066 | Mariposa | Mariposa | 43 | 2021-03-05 | 395 | 7 | |
11067 | 11067 | Mendocino | Mendocino | 45 | 2021-03-05 | 3834 | 44 | |
11068 | 11068 | Merced | Merced | 47 | 2021-03-05 | 29376 | 413 | |
11069 | 11069 | Modoc | Modoc | 49 | 2021-03-05 | 460 | 4 | |
11070 | 11070 | Mono | Mono | 51 | 2021-03-05 | 1219 | 4 | |
11071 | 11071 | Monterey | Monterey | 53 | 2021-03-05 | 42373 | 329 | |
11072 | 11072 | Napa | Napa | 55 | 2021-03-05 | 9073 | 72 | |
11073 | 11073 | Nevada | Nevada | 57 | 2021-03-05 | 4022 | 74 | |
11074 | 11074 | Orange | Orange | 59 | 2021-03-05 | 247372 | 4075 | |
11075 | 11075 | Placer | Placer | 61 | 2021-03-05 | 20035 | 232 | |
11076 | 11076 | Plumas | Plumas | 63 | 2021-03-05 | 654 | 6 | |
11077 | 11077 | Riverside | Riverside | 65 | 2021-03-05 | 290904 | 3892 | |
11078 | 11078 | Sacramento | Sacramento | 67 | 2021-03-05 | 94129 | 1510 | |
11079 | 11079 | San Benito | San Benito | 69 | 2021-03-05 | 5716 | 61 | |
11080 | 11080 | San Bernardino | San Bernardino | 71 | 2021-03-05 | 287513 | 4648 | |
11081 | 11081 | San Diego | San Diego | 73 | 2021-03-05 | 262360 | 3371 | |
11082 | 11082 | San Francisco | San Francisco | 75 | 2021-03-05 | 34245 | 426 | |
11083 | 11083 | San Joaquin | San Joaquin | 77 | 2021-03-05 | 67284 | 1182 | |
11084 | 11084 | San Luis Obispo | San Luis Obispo | 79 | 2021-03-05 | 19835 | 246 | |
11085 | 11085 | San Mateo | San Mateo | 81 | 2021-03-05 | 39010 | 525 | |
11086 | 11086 | Santa Barbara | Santa Barbara | 83 | 2021-03-05 | 32267 | 422 | |
11087 | 11087 | Santa Clara | Santa Clara | 85 | 2021-03-05 | 111072 | 1605 | |
11088 | 11088 | Santa Cruz | Santa Cruz | 87 | 2021-03-05 | 14790 | 187 | |
11089 | 11089 | Shasta | Shasta | 89 | 2021-03-05 | 11084 | 179 | |
11090 | 11090 | Sierra | Sierra | 91 | 2021-03-05 | 100 | 0 | |
11091 | 11091 | Siskiyou | Siskiyou | 93 | 2021-03-05 | 1790 | 14 | |
11092 | 11092 | Solano | Solano | 95 | 2021-03-05 | 30305 | 167 | |
11093 | 11093 | Sonoma | Sonoma | 97 | 2021-03-05 | 28281 | 301 | |
11094 | 11094 | Stanislaus | Stanislaus | 99 | 2021-03-05 | 50926 | 957 | |
11095 | 11095 | Sutter | Sutter | 101 | 2021-03-05 | 8923 | 98 | |
11096 | 11096 | Tehama | Tehama | 103 | 2021-03-05 | 5118 | 52 | |
11097 | 11097 | Trinity | Trinity | 105 | 2021-03-05 | 373 | 5 | |
11098 | 11098 | Tulare | Tulare | 107 | 2021-03-05 | 48203 | 770 | |
11099 | 11099 | Tuolumne | Tuolumne | 109 | 2021-03-05 | 3972 | 59 | |
11100 | 11100 | Ventura | Ventura | 111 | 2021-03-05 | 78050 | 883 | |
11101 | 11101 | Yolo | Yolo | 113 | 2021-03-05 | 12778 | 185 | |
11102 | 11102 | Yuba | Yuba | 115 | 2021-03-05 | 5795 | 39 |
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 );