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-08 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 |
---|---|---|---|---|---|---|---|---|
7138 | 7138 | Alameda | Alameda | 1 | 2021-05-08 | 84124 | 1217 | |
7139 | 7139 | Berkeley | Alameda | 1 | 2021-05-08 | 3593 | 46 | |
7140 | 7140 | Alpine | Alpine | 3 | 2021-05-08 | 88 | 0 | TRUE |
7141 | 7141 | Amador | Amador | 5 | 2021-05-08 | 3617 | 47 | TRUE |
7142 | 7142 | Butte | Butte | 7 | 2021-05-08 | 11962 | 182 | TRUE |
7143 | 7143 | Calaveras | Calaveras | 9 | 2021-05-08 | 2121 | 53 | TRUE |
7144 | 7144 | Colusa | Colusa | 11 | 2021-05-08 | 2230 | 16 | TRUE |
7145 | 7145 | Contra Costa | Contra Costa | 13 | 2021-05-08 | 68503 | 789 | |
7146 | 7146 | Del Norte | Del Norte | 15 | 2021-05-08 | 1367 | 7 | TRUE |
7147 | 7147 | El Dorado | El Dorado | 17 | 2021-05-08 | 10111 | 112 | TRUE |
7148 | 7148 | Fresno | Fresno | 19 | 2021-05-08 | 101188 | 1682 | |
7149 | 7149 | Glenn | Glenn | 21 | 2021-05-08 | 2321 | 25 | TRUE |
7150 | 7150 | Humboldt | Humboldt | 23 | 2021-05-08 | 3935 | 39 | TRUE |
7151 | 7151 | Imperial | Imperial | 25 | 2021-05-08 | 27837 | 718 | TRUE |
7152 | 7152 | Inyo | Inyo | 27 | 2021-05-08 | 1426 | 38 | TRUE |
7153 | 7153 | Kern | Kern | 29 | 2021-05-08 | 108993 | 1373 | |
7154 | 7154 | Kings | Kings | 31 | 2021-05-08 | 22965 | 246 | |
7155 | 7155 | Lake | Lake | 33 | 2021-05-08 | 3447 | 43 | TRUE |
7156 | 7156 | Lassen | Lassen | 35 | 2021-05-08 | 5698 | 24 | TRUE |
7157 | 7157 | Long Beach | Los Angeles | 37 | 2021-05-08 | 53082 | 932 | TRUE |
7158 | 7158 | Los Angeles | Los Angeles | 37 | 2021-05-08 | 1171088 | 22717 | TRUE |
7159 | 7159 | Pasadena | Los Angeles | 37 | 2021-05-08 | 11252 | 346 | TRUE |
7160 | 7160 | Madera | Madera | 39 | 2021-05-08 | 16337 | 242 | |
7161 | 7161 | Marin | Marin | 41 | 2021-05-08 | 14034 | 210 | |
7162 | 7162 | Mariposa | Mariposa | 43 | 2021-05-08 | 445 | 7 | TRUE |
7163 | 7163 | Mendocino | Mendocino | 45 | 2021-05-08 | 4061 | 49 | TRUE |
7164 | 7164 | Merced | Merced | 47 | 2021-05-08 | 31743 | 458 | TRUE |
7165 | 7165 | Modoc | Modoc | 49 | 2021-05-08 | 495 | 4 | TRUE |
7166 | 7166 | Mono | Mono | 51 | 2021-05-08 | 1280 | 4 | TRUE |
7167 | 7167 | Monterey | Monterey | 53 | 2021-05-08 | 43563 | 382 | TRUE |
7168 | 7168 | Napa | Napa | 55 | 2021-05-08 | 9846 | 77 | TRUE |
7169 | 7169 | Nevada | Nevada | 57 | 2021-05-08 | 4707 | 75 | TRUE |
7170 | 7170 | Orange | Orange | 59 | 2021-05-08 | 254278 | 5005 | |
7171 | 7171 | Placer | Placer | 61 | 2021-05-08 | 22550 | 290 | TRUE |
7172 | 7172 | Plumas | Plumas | 63 | 2021-05-08 | 706 | 6 | TRUE |
7173 | 7173 | Riverside | Riverside | 65 | 2021-05-08 | 299064 | 4587 | TRUE |
7174 | 7174 | Sacramento | Sacramento | 67 | 2021-05-08 | 104176 | 1672 | TRUE |
7175 | 7175 | San Benito | San Benito | 69 | 2021-05-08 | 6045 | 63 | TRUE |
7176 | 7176 | San Bernardino | San Bernardino | 71 | 2021-05-08 | 296514 | 4802 | |
7177 | 7177 | San Diego | San Diego | 73 | 2021-05-08 | 277759 | 3725 | |
7178 | 7178 | San Francisco | San Francisco | 75 | 2021-05-08 | 36284 | 538 | |
7179 | 7179 | San Joaquin | San Joaquin | 77 | 2021-05-08 | 73009 | 1391 | |
7180 | 7180 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-08 | 21208 | 260 | |
7181 | 7181 | San Mateo | San Mateo | 81 | 2021-05-08 | 41747 | 568 | |
7182 | 7182 | Santa Barbara | Santa Barbara | 83 | 2021-05-08 | 34306 | 450 | |
7183 | 7183 | Santa Clara | Santa Clara | 85 | 2021-05-08 | 117649 | 1686 | |
7184 | 7184 | Santa Cruz | Santa Cruz | 87 | 2021-05-08 | 16125 | 205 | |
7185 | 7185 | Shasta | Shasta | 89 | 2021-05-08 | 12071 | 226 | TRUE |
7186 | 7186 | Sierra | Sierra | 91 | 2021-05-08 | 112 | 0 | TRUE |
7187 | 7187 | Siskiyou | Siskiyou | 93 | 2021-05-08 | 2181 | 23 | TRUE |
7188 | 7188 | Solano | Solano | 95 | 2021-05-08 | 32752 | 216 | TRUE |
7189 | 7189 | Sonoma | Sonoma | 97 | 2021-05-08 | 29975 | 312 | |
7190 | 7190 | Stanislaus | Stanislaus | 99 | 2021-05-08 | 55338 | 1055 | |
7191 | 7191 | Sutter | Sutter | 101 | 2021-05-08 | 9411 | 105 | |
7192 | 7192 | Tehama | Tehama | 103 | 2021-05-08 | 5553 | 58 | TRUE |
7193 | 7193 | Trinity | Trinity | 105 | 2021-05-08 | 399 | 5 | TRUE |
7194 | 7194 | Tulare | Tulare | 107 | 2021-05-08 | 49554 | 839 | TRUE |
7195 | 7195 | Tuolumne | Tuolumne | 109 | 2021-05-08 | 4123 | 64 | TRUE |
7196 | 7196 | Ventura | Ventura | 111 | 2021-05-08 | 80842 | 1011 | |
7197 | 7197 | Yolo | Yolo | 113 | 2021-05-08 | 13793 | 207 | TRUE |
7198 | 7198 | Yuba | Yuba | 115 | 2021-05-08 | 6221 | 41 | 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 );