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-05-28 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 |
---|---|---|---|---|---|---|---|---|
5918 | 5918 | Alameda | Alameda | 1 | 2021-05-28 | 85217 | 1217 | |
5919 | 5919 | Berkeley | Alameda | 1 | 2021-05-28 | 3620 | 46 | |
5920 | 5920 | Alpine | Alpine | 3 | 2021-05-28 | 89 | 0 | TRUE |
5921 | 5921 | Amador | Amador | 5 | 2021-05-28 | 3648 | 47 | |
5922 | 5922 | Butte | Butte | 7 | 2021-05-28 | 12407 | 189 | |
5923 | 5923 | Calaveras | Calaveras | 9 | 2021-05-28 | 2174 | 56 | |
5924 | 5924 | Colusa | Colusa | 11 | 2021-05-28 | 2265 | 18 | |
5925 | 5925 | Contra Costa | Contra Costa | 13 | 2021-05-28 | 69574 | 799 | |
5926 | 5926 | Del Norte | Del Norte | 15 | 2021-05-28 | 1431 | 7 | |
5927 | 5927 | El Dorado | El Dorado | 17 | 2021-05-28 | 10296 | 113 | |
5928 | 5928 | Fresno | Fresno | 19 | 2021-05-28 | 101841 | 1704 | |
5929 | 5929 | Glenn | Glenn | 21 | 2021-05-28 | 2349 | 26 | |
5930 | 5930 | Humboldt | Humboldt | 23 | 2021-05-28 | 4285 | 43 | |
5931 | 5931 | Imperial | Imperial | 25 | 2021-05-28 | 28131 | 733 | |
5932 | 5932 | Inyo | Inyo | 27 | 2021-05-28 | 1431 | 38 | |
5933 | 5933 | Kern | Kern | 29 | 2021-05-28 | 109999 | 1388 | |
5934 | 5934 | Kings | Kings | 31 | 2021-05-28 | 23059 | 247 | |
5935 | 5935 | Lake | Lake | 33 | 2021-05-28 | 3492 | 43 | |
5936 | 5936 | Lassen | Lassen | 35 | 2021-05-28 | 5736 | 24 | TRUE |
5937 | 5937 | Long Beach | Los Angeles | 37 | 2021-05-28 | 53378 | 939 | |
5938 | 5938 | Los Angeles | Los Angeles | 37 | 2021-05-28 | 1178863 | 23047 | |
5939 | 5939 | Pasadena | Los Angeles | 37 | 2021-05-28 | 11290 | 347 | |
5940 | 5940 | Madera | Madera | 39 | 2021-05-28 | 16430 | 244 | |
5941 | 5941 | Marin | Marin | 41 | 2021-05-28 | 14122 | 213 | |
5942 | 5942 | Mariposa | Mariposa | 43 | 2021-05-28 | 454 | 7 | |
5943 | 5943 | Mendocino | Mendocino | 45 | 2021-05-28 | 4197 | 49 | |
5944 | 5944 | Merced | Merced | 47 | 2021-05-28 | 32142 | 469 | |
5945 | 5945 | Modoc | Modoc | 49 | 2021-05-28 | 514 | 4 | TRUE |
5946 | 5946 | Mono | Mono | 51 | 2021-05-28 | 1294 | 4 | |
5947 | 5947 | Monterey | Monterey | 53 | 2021-05-28 | 43730 | 385 | |
5948 | 5948 | Napa | Napa | 55 | 2021-05-28 | 9929 | 78 | |
5949 | 5949 | Nevada | Nevada | 57 | 2021-05-28 | 4812 | 75 | |
5950 | 5950 | Orange | Orange | 59 | 2021-05-28 | 255164 | 5059 | |
5951 | 5951 | Placer | Placer | 61 | 2021-05-28 | 23004 | 297 | |
5952 | 5952 | Plumas | Plumas | 63 | 2021-05-28 | 723 | 6 | |
5953 | 5953 | Riverside | Riverside | 65 | 2021-05-28 | 300701 | 4608 | |
5954 | 5954 | Sacramento | Sacramento | 67 | 2021-05-28 | 106265 | 1707 | |
5955 | 5955 | San Benito | San Benito | 69 | 2021-05-28 | 6088 | 63 | |
5956 | 5956 | San Bernardino | San Bernardino | 71 | 2021-05-28 | 298289 | 4827 | |
5957 | 5957 | San Diego | San Diego | 73 | 2021-05-28 | 280042 | 3756 | |
5958 | 5958 | San Francisco | San Francisco | 75 | 2021-05-28 | 36633 | 542 | |
5959 | 5959 | San Joaquin | San Joaquin | 77 | 2021-05-28 | 73794 | 1419 | |
5960 | 5960 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-28 | 21315 | 261 | |
5961 | 5961 | San Mateo | San Mateo | 81 | 2021-05-28 | 42069 | 576 | |
5962 | 5962 | Santa Barbara | Santa Barbara | 83 | 2021-05-28 | 34488 | 450 | |
5963 | 5963 | Santa Clara | Santa Clara | 85 | 2021-05-28 | 118329 | 1690 | |
5964 | 5964 | Santa Cruz | Santa Cruz | 87 | 2021-05-28 | 16169 | 206 | |
5965 | 5965 | Shasta | Shasta | 89 | 2021-05-28 | 12413 | 230 | |
5966 | 5966 | Sierra | Sierra | 91 | 2021-05-28 | 113 | 0 | |
5967 | 5967 | Siskiyou | Siskiyou | 93 | 2021-05-28 | 2352 | 33 | |
5968 | 5968 | Solano | Solano | 95 | 2021-05-28 | 33293 | 238 | |
5969 | 5969 | Sonoma | Sonoma | 97 | 2021-05-28 | 30269 | 315 | |
5970 | 5970 | Stanislaus | Stanislaus | 99 | 2021-05-28 | 56152 | 1066 | |
5971 | 5971 | Sutter | Sutter | 101 | 2021-05-28 | 9527 | 106 | |
5972 | 5972 | Tehama | Tehama | 103 | 2021-05-28 | 5678 | 59 | |
5973 | 5973 | Trinity | Trinity | 105 | 2021-05-28 | 411 | 5 | |
5974 | 5974 | Tulare | Tulare | 107 | 2021-05-28 | 49758 | 846 | |
5975 | 5975 | Tuolumne | Tuolumne | 109 | 2021-05-28 | 4168 | 67 | |
5976 | 5976 | Ventura | Ventura | 111 | 2021-05-28 | 81344 | 1018 | |
5977 | 5977 | Yolo | Yolo | 113 | 2021-05-28 | 13982 | 208 | |
5978 | 5978 | Yuba | Yuba | 115 | 2021-05-28 | 6371 | 41 |
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 );