latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
57 rows where "date" is on date 2020-04-28 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 |
---|---|---|---|---|---|---|---|---|
30013 | 30013 | Alameda | Alameda | 1 | 2020-04-28 | 1500 | 93 | |
30014 | 30014 | Berkeley | Alameda | 1 | 2020-04-28 | 52 | 1 | |
30015 | 30015 | Alpine | Alpine | 3 | 2020-04-28 | 1 | 0 | TRUE |
30016 | 30016 | Amador | Amador | 5 | 2020-04-28 | 8 | 0 | |
30017 | 30017 | Butte | Butte | 7 | 2020-04-28 | 16 | 0 | |
30018 | 30018 | Calaveras | Calaveras | 9 | 2020-04-28 | 13 | 0 | TRUE |
30019 | 30019 | Colusa | Colusa | 11 | 2020-04-28 | 3 | 0 | |
30020 | 30020 | Contra Costa | Contra Costa | 13 | 2020-04-28 | 849 | 25 | |
30021 | 30021 | Del Norte | Del Norte | 15 | 2020-04-28 | 3 | 0 | |
30022 | 30022 | El Dorado | El Dorado | 17 | 2020-04-28 | 44 | 0 | |
30023 | 30023 | Fresno | Fresno | 19 | 2020-04-28 | 993 | 7 | |
30024 | 30024 | Glenn | Glenn | 21 | 2020-04-28 | 5 | 0 | |
30025 | 30025 | Humboldt | Humboldt | 23 | 2020-04-28 | 53 | 0 | |
30026 | 30026 | Imperial | Imperial | 25 | 2020-04-28 | 304 | 8 | |
30027 | 30027 | Inyo | Inyo | 27 | 2020-04-28 | 19 | 1 | |
30028 | 30028 | Kern | Kern | 29 | 2020-04-28 | 847 | 5 | |
30029 | 30029 | Kings | Kings | 31 | 2020-04-28 | 79 | 1 | |
30030 | 30030 | Lake | Lake | 33 | 2020-04-28 | 6 | 0 | |
30031 | 30031 | Long Beach | Los Angeles | 37 | 2020-04-28 | 602 | 33 | |
30032 | 30032 | Los Angeles | Los Angeles | 37 | 2020-04-28 | 20032 | 935 | |
30033 | 30033 | Pasadena | Los Angeles | 37 | 2020-04-28 | 383 | 36 | |
30034 | 30034 | Madera | Madera | 39 | 2020-04-28 | 45 | 2 | |
30035 | 30035 | Marin | Marin | 41 | 2020-04-28 | 226 | 12 | |
30036 | 30036 | Mariposa | Mariposa | 43 | 2020-04-28 | 1 | 0 | |
30037 | 30037 | Mendocino | Mendocino | 45 | 2020-04-28 | 11 | 0 | TRUE |
30038 | 30038 | Merced | Merced | 47 | 2020-04-28 | 116 | 3 | |
30039 | 30039 | Mono | Mono | 51 | 2020-04-28 | 26 | 1 | |
30040 | 30040 | Monterey | Monterey | 53 | 2020-04-28 | 191 | 5 | |
30041 | 30041 | Napa | Napa | 55 | 2020-04-28 | 66 | 2 | |
30042 | 30042 | Nevada | Nevada | 57 | 2020-04-28 | 41 | 1 | |
30043 | 30043 | Orange | Orange | 59 | 2020-04-28 | 2131 | 42 | |
30044 | 30044 | Placer | Placer | 61 | 2020-04-28 | 145 | 8 | |
30045 | 30045 | Plumas | Plumas | 63 | 2020-04-28 | 4 | 0 | |
30046 | 30046 | Riverside | Riverside | 65 | 2020-04-28 | 3735 | 141 | |
30047 | 30047 | Sacramento | Sacramento | 67 | 2020-04-28 | 1053 | 41 | |
30048 | 30048 | San Benito | San Benito | 69 | 2020-04-28 | 50 | 2 | |
30049 | 30049 | San Bernardino | San Bernardino | 71 | 2020-04-28 | 1827 | 99 | |
30050 | 30050 | San Diego | San Diego | 73 | 2020-04-28 | 3314 | 118 | |
30051 | 30051 | San Francisco | San Francisco | 75 | 2020-04-28 | 1468 | 23 | |
30052 | 30052 | San Joaquin | San Joaquin | 77 | 2020-04-28 | 525 | 25 | |
30053 | 30053 | San Luis Obispo | San Luis Obispo | 79 | 2020-04-28 | 173 | 1 | |
30054 | 30054 | San Mateo | San Mateo | 81 | 2020-04-28 | 1099 | 48 | |
30055 | 30055 | Santa Barbara | Santa Barbara | 83 | 2020-04-28 | 477 | 7 | |
30056 | 30056 | Santa Clara | Santa Clara | 85 | 2020-04-28 | 2184 | 109 | |
30057 | 30057 | Santa Cruz | Santa Cruz | 87 | 2020-04-28 | 125 | 2 | |
30058 | 30058 | Shasta | Shasta | 89 | 2020-04-28 | 31 | 4 | |
30059 | 30059 | Siskiyou | Siskiyou | 93 | 2020-04-28 | 5 | 0 | |
30060 | 30060 | Solano | Solano | 95 | 2020-04-28 | 249 | 4 | |
30061 | 30061 | Sonoma | Sonoma | 97 | 2020-04-28 | 228 | 2 | |
30062 | 30062 | Stanislaus | Stanislaus | 99 | 2020-04-28 | 324 | 10 | |
30063 | 30063 | Sutter | Sutter | 101 | 2020-04-28 | 29 | 2 | |
30064 | 30064 | Tehama | Tehama | 103 | 2020-04-28 | 1 | 1 | TRUE |
30065 | 30065 | Tulare | Tulare | 107 | 2020-04-28 | 578 | 35 | |
30066 | 30066 | Tuolumne | Tuolumne | 109 | 2020-04-28 | 2 | 0 | |
30067 | 30067 | Ventura | Ventura | 111 | 2020-04-28 | 508 | 17 | |
30068 | 30068 | Yolo | Yolo | 113 | 2020-04-28 | 162 | 16 | |
30069 | 30069 | Yuba | Yuba | 115 | 2020-04-28 | 17 | 1 |
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 );