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 2020-12-12 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 |
---|---|---|---|---|---|---|---|---|
16105 | 16105 | Alameda | Alameda | 1 | 2020-12-12 | 36252 | 617 | |
16106 | 16106 | Berkeley | Alameda | 1 | 2020-12-12 | 1532 | 20 | TRUE |
16107 | 16107 | Alpine | Alpine | 3 | 2020-12-12 | 63 | 0 | TRUE |
16108 | 16108 | Amador | Amador | 5 | 2020-12-12 | 1513 | 19 | |
16109 | 16109 | Butte | Butte | 7 | 2020-12-12 | 4972 | 67 | TRUE |
16110 | 16110 | Calaveras | Calaveras | 9 | 2020-12-12 | 642 | 22 | TRUE |
16111 | 16111 | Colusa | Colusa | 11 | 2020-12-12 | 921 | 8 | TRUE |
16112 | 16112 | Contra Costa | Contra Costa | 13 | 2020-12-12 | 29599 | 279 | |
16113 | 16113 | Del Norte | Del Norte | 15 | 2020-12-12 | 536 | 1 | TRUE |
16114 | 16114 | El Dorado | El Dorado | 17 | 2020-12-12 | 3754 | 8 | TRUE |
16115 | 16115 | Fresno | Fresno | 19 | 2020-12-12 | 55568 | 542 | |
16116 | 16116 | Glenn | Glenn | 21 | 2020-12-12 | 1136 | 12 | TRUE |
16117 | 16117 | Humboldt | Humboldt | 23 | 2020-12-12 | 1231 | 10 | TRUE |
16118 | 16118 | Imperial | Imperial | 25 | 2020-12-12 | 18289 | 373 | TRUE |
16119 | 16119 | Inyo | Inyo | 27 | 2020-12-12 | 388 | 17 | TRUE |
16120 | 16120 | Kern | Kern | 29 | 2020-12-12 | 49939 | 467 | |
16121 | 16121 | Kings | Kings | 31 | 2020-12-12 | 13198 | 98 | |
16122 | 16122 | Lake | Lake | 33 | 2020-12-12 | 1215 | 21 | TRUE |
16123 | 16123 | Lassen | Lassen | 35 | 2020-12-12 | 3127 | 6 | TRUE |
16124 | 16124 | Long Beach | Los Angeles | 37 | 2020-12-12 | 20697 | 295 | |
16125 | 16125 | Los Angeles | Los Angeles | 37 | 2020-12-12 | 487857 | 7839 | |
16126 | 16126 | Pasadena | Los Angeles | 37 | 2020-12-12 | 4729 | 139 | |
16127 | 16127 | Madera | Madera | 39 | 2020-12-12 | 7612 | 107 | TRUE |
16128 | 16128 | Marin | Marin | 41 | 2020-12-12 | 8410 | 132 | |
16129 | 16129 | Mariposa | Mariposa | 43 | 2020-12-12 | 174 | 4 | |
16130 | 16130 | Mendocino | Mendocino | 45 | 2020-12-12 | 1931 | 24 | TRUE |
16131 | 16131 | Merced | Merced | 47 | 2020-12-12 | 14483 | 207 | TRUE |
16132 | 16132 | Modoc | Modoc | 49 | 2020-12-12 | 240 | 0 | |
16133 | 16133 | Mono | Mono | 51 | 2020-12-12 | 700 | 3 | TRUE |
16134 | 16134 | Monterey | Monterey | 53 | 2020-12-12 | 17546 | 154 | |
16135 | 16135 | Napa | Napa | 55 | 2020-12-12 | 4013 | 22 | TRUE |
16136 | 16136 | Nevada | Nevada | 57 | 2020-12-12 | 1962 | 21 | TRUE |
16137 | 16137 | Orange | Orange | 59 | 2020-12-12 | 99393 | 1680 | |
16138 | 16138 | Placer | Placer | 61 | 2020-12-12 | 8879 | 92 | TRUE |
16139 | 16139 | Plumas | Plumas | 63 | 2020-12-12 | 340 | 0 | |
16140 | 16140 | Riverside | Riverside | 65 | 2020-12-12 | 112950 | 1573 | TRUE |
16141 | 16141 | Sacramento | Sacramento | 67 | 2020-12-12 | 47473 | 670 | TRUE |
16142 | 16142 | San Benito | San Benito | 69 | 2020-12-12 | 2401 | 19 | |
16143 | 16143 | San Bernardino | San Bernardino | 71 | 2020-12-12 | 124264 | 1783 | |
16144 | 16144 | San Diego | San Diego | 73 | 2020-12-12 | 104956 | 1151 | |
16145 | 16145 | San Francisco | San Francisco | 75 | 2020-12-12 | 18201 | 167 | |
16146 | 16146 | San Joaquin | San Joaquin | 77 | 2020-12-12 | 31720 | 534 | TRUE |
16147 | 16147 | San Luis Obispo | San Luis Obispo | 79 | 2020-12-12 | 7452 | 46 | TRUE |
16148 | 16148 | San Mateo | San Mateo | 81 | 2020-12-12 | 17724 | 179 | |
16149 | 16149 | Santa Barbara | Santa Barbara | 83 | 2020-12-12 | 13056 | 140 | |
16150 | 16150 | Santa Clara | Santa Clara | 85 | 2020-12-12 | 51525 | 530 | |
16151 | 16151 | Santa Cruz | Santa Cruz | 87 | 2020-12-12 | 5642 | 53 | TRUE |
16152 | 16152 | Shasta | Shasta | 89 | 2020-12-12 | 6777 | 58 | TRUE |
16153 | 16153 | Sierra | Sierra | 91 | 2020-12-12 | 27 | 0 | TRUE |
16154 | 16154 | Siskiyou | Siskiyou | 93 | 2020-12-12 | 914 | 7 | TRUE |
16155 | 16155 | Solano | Solano | 95 | 2020-12-12 | 12733 | 91 | TRUE |
16156 | 16156 | Sonoma | Sonoma | 97 | 2020-12-12 | 14475 | 162 | |
16157 | 16157 | Stanislaus | Stanislaus | 99 | 2020-12-12 | 26361 | 468 | |
16158 | 16158 | Sutter | Sutter | 101 | 2020-12-12 | 4657 | 33 | TRUE |
16159 | 16159 | Tehama | Tehama | 103 | 2020-12-12 | 2357 | 30 | |
16160 | 16160 | Trinity | Trinity | 105 | 2020-12-12 | 225 | 1 | TRUE |
16161 | 16161 | Tulare | Tulare | 107 | 2020-12-12 | 25042 | 327 | TRUE |
16162 | 16162 | Tuolumne | Tuolumne | 109 | 2020-12-12 | 1547 | 17 | TRUE |
16163 | 16163 | Ventura | Ventura | 111 | 2020-12-12 | 24276 | 198 | TRUE |
16164 | 16164 | Yolo | Yolo | 113 | 2020-12-12 | 6049 | 89 | |
16165 | 16165 | Yuba | Yuba | 115 | 2020-12-12 | 2820 | 10 | 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 );