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-25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
agency >30
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
6101 | 6101 | Alameda | Alameda | 1 | 2021-05-25 | 85047 | 1217 | |
6102 | 6102 | Berkeley | Alameda | 1 | 2021-05-25 | 3618 | 46 | |
6103 | 6103 | Alpine | Alpine | 3 | 2021-05-25 | 89 | 0 | TRUE |
6104 | 6104 | Amador | Amador | 5 | 2021-05-25 | 3643 | 47 | |
6105 | 6105 | Butte | Butte | 7 | 2021-05-25 | 12295 | 188 | |
6106 | 6106 | Calaveras | Calaveras | 9 | 2021-05-25 | 2161 | 56 | |
6107 | 6107 | Colusa | Colusa | 11 | 2021-05-25 | 2259 | 18 | |
6108 | 6108 | Contra Costa | Contra Costa | 13 | 2021-05-25 | 69454 | 796 | |
6109 | 6109 | Del Norte | Del Norte | 15 | 2021-05-25 | 1425 | 7 | |
6110 | 6110 | El Dorado | El Dorado | 17 | 2021-05-25 | 10278 | 113 | |
6111 | 6111 | Fresno | Fresno | 19 | 2021-05-25 | 101771 | 1698 | |
6112 | 6112 | Glenn | Glenn | 21 | 2021-05-25 | 2341 | 25 | TRUE |
6113 | 6113 | Humboldt | Humboldt | 23 | 2021-05-25 | 4253 | 43 | |
6114 | 6114 | Imperial | Imperial | 25 | 2021-05-25 | 28088 | 731 | |
6115 | 6115 | Inyo | Inyo | 27 | 2021-05-25 | 1429 | 38 | |
6116 | 6116 | Kern | Kern | 29 | 2021-05-25 | 109738 | 1385 | |
6117 | 6117 | Kings | Kings | 31 | 2021-05-25 | 23042 | 247 | |
6118 | 6118 | Lake | Lake | 33 | 2021-05-25 | 3491 | 43 | |
6119 | 6119 | Lassen | Lassen | 35 | 2021-05-25 | 5726 | 24 | TRUE |
6120 | 6120 | Long Beach | Los Angeles | 37 | 2021-05-25 | 53328 | 937 | |
6121 | 6121 | Los Angeles | Los Angeles | 37 | 2021-05-25 | 1174513 | 22903 | |
6122 | 6122 | Pasadena | Los Angeles | 37 | 2021-05-25 | 11286 | 346 | |
6123 | 6123 | Madera | Madera | 39 | 2021-05-25 | 16420 | 244 | |
6124 | 6124 | Marin | Marin | 41 | 2021-05-25 | 14114 | 211 | |
6125 | 6125 | Mariposa | Mariposa | 43 | 2021-05-25 | 454 | 7 | |
6126 | 6126 | Mendocino | Mendocino | 45 | 2021-05-25 | 4182 | 49 | |
6127 | 6127 | Merced | Merced | 47 | 2021-05-25 | 32093 | 468 | |
6128 | 6128 | Modoc | Modoc | 49 | 2021-05-25 | 511 | 4 | |
6129 | 6129 | Mono | Mono | 51 | 2021-05-25 | 1293 | 4 | |
6130 | 6130 | Monterey | Monterey | 53 | 2021-05-25 | 43698 | 385 | |
6131 | 6131 | Napa | Napa | 55 | 2021-05-25 | 9926 | 78 | |
6132 | 6132 | Nevada | Nevada | 57 | 2021-05-25 | 4798 | 75 | |
6133 | 6133 | Orange | Orange | 59 | 2021-05-25 | 255070 | 5054 | |
6134 | 6134 | Placer | Placer | 61 | 2021-05-25 | 22942 | 295 | |
6135 | 6135 | Plumas | Plumas | 63 | 2021-05-25 | 723 | 6 | TRUE |
6136 | 6136 | Riverside | Riverside | 65 | 2021-05-25 | 300476 | 4608 | |
6137 | 6137 | Sacramento | Sacramento | 67 | 2021-05-25 | 105963 | 1700 | |
6138 | 6138 | San Benito | San Benito | 69 | 2021-05-25 | 6088 | 63 | |
6139 | 6139 | San Bernardino | San Bernardino | 71 | 2021-05-25 | 297688 | 4823 | |
6140 | 6140 | San Diego | San Diego | 73 | 2021-05-25 | 279785 | 3753 | |
6141 | 6141 | San Francisco | San Francisco | 75 | 2021-05-25 | 36605 | 542 | |
6142 | 6142 | San Joaquin | San Joaquin | 77 | 2021-05-25 | 73717 | 1419 | |
6143 | 6143 | San Luis Obispo | San Luis Obispo | 79 | 2021-05-25 | 21284 | 261 | |
6144 | 6144 | San Mateo | San Mateo | 81 | 2021-05-25 | 42029 | 573 | |
6145 | 6145 | Santa Barbara | Santa Barbara | 83 | 2021-05-25 | 34462 | 450 | |
6146 | 6146 | Santa Clara | Santa Clara | 85 | 2021-05-25 | 118253 | 1689 | |
6147 | 6147 | Santa Cruz | Santa Cruz | 87 | 2021-05-25 | 16169 | 206 | |
6148 | 6148 | Shasta | Shasta | 89 | 2021-05-25 | 12382 | 228 | |
6149 | 6149 | Sierra | Sierra | 91 | 2021-05-25 | 112 | 0 | |
6150 | 6150 | Siskiyou | Siskiyou | 93 | 2021-05-25 | 2337 | 29 | |
6151 | 6151 | Solano | Solano | 95 | 2021-05-25 | 33202 | 234 | |
6152 | 6152 | Sonoma | Sonoma | 97 | 2021-05-25 | 30170 | 315 | |
6153 | 6153 | Stanislaus | Stanislaus | 99 | 2021-05-25 | 56043 | 1066 | |
6154 | 6154 | Sutter | Sutter | 101 | 2021-05-25 | 9509 | 106 | |
6155 | 6155 | Tehama | Tehama | 103 | 2021-05-25 | 5648 | 59 | |
6156 | 6156 | Trinity | Trinity | 105 | 2021-05-25 | 410 | 5 | |
6157 | 6157 | Tulare | Tulare | 107 | 2021-05-25 | 49758 | 842 | |
6158 | 6158 | Tuolumne | Tuolumne | 109 | 2021-05-25 | 4161 | 67 | |
6159 | 6159 | Ventura | Ventura | 111 | 2021-05-25 | 81280 | 1018 | |
6160 | 6160 | Yolo | Yolo | 113 | 2021-05-25 | 13939 | 208 | |
6161 | 6161 | Yuba | Yuba | 115 | 2021-05-25 | 6344 | 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 );