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-01-14 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 |
---|---|---|---|---|---|---|---|---|
14092 | 14092 | Alameda | Alameda | 1 | 2021-01-14 | 62183 | 988 | |
14093 | 14093 | Berkeley | Alameda | 1 | 2021-01-14 | 2282 | 41 | |
14094 | 14094 | Alpine | Alpine | 3 | 2021-01-14 | 73 | 0 | |
14095 | 14095 | Amador | Amador | 5 | 2021-01-14 | 2921 | 29 | |
14096 | 14096 | Butte | Butte | 7 | 2021-01-14 | 9127 | 120 | |
14097 | 14097 | Calaveras | Calaveras | 9 | 2021-01-14 | 945 | 22 | TRUE |
14098 | 14098 | Colusa | Colusa | 11 | 2021-01-14 | 1684 | 9 | |
14099 | 14099 | Contra Costa | Contra Costa | 13 | 2021-01-14 | 49759 | 410 | |
14100 | 14100 | Del Norte | Del Norte | 15 | 2021-01-14 | 844 | 2 | |
14101 | 14101 | El Dorado | El Dorado | 17 | 2021-01-14 | 7394 | 41 | |
14102 | 14102 | Fresno | Fresno | 19 | 2021-01-14 | 84302 | 904 | |
14103 | 14103 | Glenn | Glenn | 21 | 2021-01-14 | 1794 | 19 | |
14104 | 14104 | Humboldt | Humboldt | 23 | 2021-01-14 | 2220 | 24 | |
14105 | 14105 | Imperial | Imperial | 25 | 2021-01-14 | 24483 | 460 | |
14106 | 14106 | Inyo | Inyo | 27 | 2021-01-14 | 883 | 27 | |
14107 | 14107 | Kern | Kern | 29 | 2021-01-14 | 82398 | 551 | |
14108 | 14108 | Kings | Kings | 31 | 2021-01-14 | 18453 | 110 | |
14109 | 14109 | Lake | Lake | 33 | 2021-01-14 | 2343 | 28 | |
14110 | 14110 | Lassen | Lassen | 35 | 2021-01-14 | 5067 | 13 | |
14111 | 14111 | Long Beach | Los Angeles | 37 | 2021-01-14 | 42281 | 506 | |
14112 | 14112 | Los Angeles | Los Angeles | 37 | 2021-01-14 | 924853 | 12549 | |
14113 | 14113 | Pasadena | Los Angeles | 37 | 2021-01-14 | 8941 | 189 | |
14114 | 14114 | Madera | Madera | 39 | 2021-01-14 | 12549 | 130 | |
14115 | 14115 | Marin | Marin | 41 | 2021-01-14 | 11244 | 149 | |
14116 | 14116 | Mariposa | Mariposa | 43 | 2021-01-14 | 334 | 4 | |
14117 | 14117 | Mendocino | Mendocino | 45 | 2021-01-14 | 3055 | 31 | |
14118 | 14118 | Merced | Merced | 47 | 2021-01-14 | 23199 | 290 | |
14119 | 14119 | Modoc | Modoc | 49 | 2021-01-14 | 378 | 3 | |
14120 | 14120 | Mono | Mono | 51 | 2021-01-14 | 1080 | 4 | |
14121 | 14121 | Monterey | Monterey | 53 | 2021-01-14 | 34482 | 248 | |
14122 | 14122 | Napa | Napa | 55 | 2021-01-14 | 7039 | 37 | |
14123 | 14123 | Nevada | Nevada | 57 | 2021-01-14 | 3072 | 71 | |
14124 | 14124 | Orange | Orange | 59 | 2021-01-14 | 202753 | 2195 | |
14125 | 14125 | Placer | Placer | 61 | 2021-01-14 | 16532 | 172 | |
14126 | 14126 | Plumas | Plumas | 63 | 2021-01-14 | 573 | 5 | |
14127 | 14127 | Riverside | Riverside | 65 | 2021-01-14 | 233480 | 2399 | |
14128 | 14128 | Sacramento | Sacramento | 67 | 2021-01-14 | 77002 | 1062 | |
14129 | 14129 | San Benito | San Benito | 69 | 2021-01-14 | 4698 | 41 | |
14130 | 14130 | San Bernardino | San Bernardino | 71 | 2021-01-14 | 241523 | 3507 | |
14131 | 14131 | San Diego | San Diego | 73 | 2021-01-14 | 204175 | 2005 | |
14132 | 14132 | San Francisco | San Francisco | 75 | 2021-01-14 | 27535 | 237 | |
14133 | 14133 | San Joaquin | San Joaquin | 77 | 2021-01-14 | 55580 | 738 | |
14134 | 14134 | San Luis Obispo | San Luis Obispo | 79 | 2021-01-14 | 14778 | 125 | |
14135 | 14135 | San Mateo | San Mateo | 81 | 2021-01-14 | 30196 | 268 | |
14136 | 14136 | Santa Barbara | Santa Barbara | 83 | 2021-01-14 | 23184 | 223 | |
14137 | 14137 | Santa Clara | Santa Clara | 85 | 2021-01-14 | 92387 | 1129 | |
14138 | 14138 | Santa Cruz | Santa Cruz | 87 | 2021-01-14 | 11447 | 111 | |
14139 | 14139 | Shasta | Shasta | 89 | 2021-01-14 | 9450 | 111 | |
14140 | 14140 | Sierra | Sierra | 91 | 2021-01-14 | 69 | 0 | |
14141 | 14141 | Siskiyou | Siskiyou | 93 | 2021-01-14 | 1388 | 12 | |
14142 | 14142 | Solano | Solano | 95 | 2021-01-14 | 24291 | 105 | |
14143 | 14143 | Sonoma | Sonoma | 97 | 2021-01-14 | 22531 | 227 | |
14144 | 14144 | Stanislaus | Stanislaus | 99 | 2021-01-14 | 40695 | 720 | |
14145 | 14145 | Sutter | Sutter | 101 | 2021-01-14 | 7439 | 76 | |
14146 | 14146 | Tehama | Tehama | 103 | 2021-01-14 | 3917 | 42 | |
14147 | 14147 | Trinity | Trinity | 105 | 2021-01-14 | 299 | 4 | |
14148 | 14148 | Tulare | Tulare | 107 | 2021-01-14 | 39723 | 494 | |
14149 | 14149 | Tuolumne | Tuolumne | 109 | 2021-01-14 | 3279 | 36 | |
14150 | 14150 | Ventura | Ventura | 111 | 2021-01-14 | 55848 | 401 | |
14151 | 14151 | Yolo | Yolo | 113 | 2021-01-14 | 9598 | 131 | |
14152 | 14152 | Yuba | Yuba | 115 | 2021-01-14 | 4766 | 26 |
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 );