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-06-27 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 |
---|---|---|---|---|---|---|---|---|
4088 | 4088 | Alameda | Alameda | 1 | 2021-06-27 | 86432 | 1217 | |
4089 | 4089 | Berkeley | Alameda | 1 | 2021-06-27 | 3671 | 50 | |
4090 | 4090 | Alpine | Alpine | 3 | 2021-06-27 | 89 | 0 | TRUE |
4091 | 4091 | Amador | Amador | 5 | 2021-06-27 | 3714 | 47 | TRUE |
4092 | 4092 | Butte | Butte | 7 | 2021-06-27 | 12696 | 194 | TRUE |
4093 | 4093 | Calaveras | Calaveras | 9 | 2021-06-27 | 2210 | 56 | TRUE |
4094 | 4094 | Colusa | Colusa | 11 | 2021-06-27 | 2288 | 18 | TRUE |
4095 | 4095 | Contra Costa | Contra Costa | 13 | 2021-06-27 | 71048 | 815 | |
4096 | 4096 | Del Norte | Del Norte | 15 | 2021-06-27 | 1468 | 7 | TRUE |
4097 | 4097 | El Dorado | El Dorado | 17 | 2021-06-27 | 10428 | 117 | TRUE |
4098 | 4098 | Fresno | Fresno | 19 | 2021-06-27 | 102471 | 1727 | |
4099 | 4099 | Glenn | Glenn | 21 | 2021-06-27 | 2365 | 27 | TRUE |
4100 | 4100 | Humboldt | Humboldt | 23 | 2021-06-27 | 4533 | 50 | TRUE |
4101 | 4101 | Imperial | Imperial | 25 | 2021-06-27 | 28348 | 741 | TRUE |
4102 | 4102 | Inyo | Inyo | 27 | 2021-06-27 | 1434 | 38 | TRUE |
4103 | 4103 | Kern | Kern | 29 | 2021-06-27 | 110948 | 1405 | TRUE |
4104 | 4104 | Kings | Kings | 31 | 2021-06-27 | 23093 | 247 | |
4105 | 4105 | Lake | Lake | 33 | 2021-06-27 | 3561 | 45 | TRUE |
4106 | 4106 | Lassen | Lassen | 35 | 2021-06-27 | 5809 | 26 | TRUE |
4107 | 4107 | Long Beach | Los Angeles | 37 | 2021-06-27 | 53607 | 945 | TRUE |
4108 | 4108 | Los Angeles | Los Angeles | 37 | 2021-06-27 | 1184369 | 23183 | |
4109 | 4109 | Pasadena | Los Angeles | 37 | 2021-06-27 | 11328 | 349 | TRUE |
4110 | 4110 | Madera | Madera | 39 | 2021-06-27 | 16544 | 245 | TRUE |
4111 | 4111 | Marin | Marin | 41 | 2021-06-27 | 14224 | 212 | |
4112 | 4112 | Mariposa | Mariposa | 43 | 2021-06-27 | 466 | 7 | TRUE |
4113 | 4113 | Mendocino | Mendocino | 45 | 2021-06-27 | 4363 | 50 | TRUE |
4114 | 4114 | Merced | Merced | 47 | 2021-06-27 | 32335 | 481 | TRUE |
4115 | 4115 | Modoc | Modoc | 49 | 2021-06-27 | 566 | 5 | TRUE |
4116 | 4116 | Mono | Mono | 51 | 2021-06-27 | 1298 | 4 | TRUE |
4117 | 4117 | Monterey | Monterey | 53 | 2021-06-27 | 43860 | 466 | TRUE |
4118 | 4118 | Napa | Napa | 55 | 2021-06-27 | 10027 | 80 | TRUE |
4119 | 4119 | Nevada | Nevada | 57 | 2021-06-27 | 4940 | 75 | TRUE |
4120 | 4120 | Orange | Orange | 59 | 2021-06-27 | 256052 | 5114 | TRUE |
4121 | 4121 | Placer | Placer | 61 | 2021-06-27 | 23673 | 300 | TRUE |
4122 | 4122 | Plumas | Plumas | 63 | 2021-06-27 | 742 | 6 | TRUE |
4123 | 4123 | Riverside | Riverside | 65 | 2021-06-27 | 301706 | 4627 | TRUE |
4124 | 4124 | Sacramento | Sacramento | 67 | 2021-06-27 | 108085 | 1738 | TRUE |
4125 | 4125 | San Benito | San Benito | 69 | 2021-06-27 | 6111 | 63 | TRUE |
4126 | 4126 | San Bernardino | San Bernardino | 71 | 2021-06-27 | 299604 | 4841 | |
4127 | 4127 | San Diego | San Diego | 73 | 2021-06-27 | 282358 | 3780 | |
4128 | 4128 | San Francisco | San Francisco | 75 | 2021-06-27 | 37003 | 555 | |
4129 | 4129 | San Joaquin | San Joaquin | 77 | 2021-06-27 | 74808 | 1440 | TRUE |
4130 | 4130 | San Luis Obispo | San Luis Obispo | 79 | 2021-06-27 | 21448 | 261 | TRUE |
4131 | 4131 | San Mateo | San Mateo | 81 | 2021-06-27 | 42386 | 581 | TRUE |
4132 | 4132 | Santa Barbara | Santa Barbara | 83 | 2021-06-27 | 34626 | 455 | TRUE |
4133 | 4133 | Santa Clara | Santa Clara | 85 | 2021-06-27 | 119150 | 1696 | |
4134 | 4134 | Santa Cruz | Santa Cruz | 87 | 2021-06-27 | 16262 | 207 | TRUE |
4135 | 4135 | Shasta | Shasta | 89 | 2021-06-27 | 12605 | 235 | TRUE |
4136 | 4136 | Sierra | Sierra | 91 | 2021-06-27 | 118 | 0 | TRUE |
4137 | 4137 | Siskiyou | Siskiyou | 93 | 2021-06-27 | 2402 | 38 | TRUE |
4138 | 4138 | Solano | Solano | 95 | 2021-06-27 | 33846 | 244 | TRUE |
4139 | 4139 | Sonoma | Sonoma | 97 | 2021-06-27 | 30941 | 317 | TRUE |
4140 | 4140 | Stanislaus | Stanislaus | 99 | 2021-06-27 | 57000 | 1073 | TRUE |
4141 | 4141 | Sutter | Sutter | 101 | 2021-06-27 | 9684 | 107 | TRUE |
4142 | 4142 | Tehama | Tehama | 103 | 2021-06-27 | 5750 | 59 | TRUE |
4143 | 4143 | Trinity | Trinity | 105 | 2021-06-27 | 426 | 6 | TRUE |
4144 | 4144 | Tulare | Tulare | 107 | 2021-06-27 | 49823 | 850 | TRUE |
4145 | 4145 | Tuolumne | Tuolumne | 109 | 2021-06-27 | 4227 | 71 | TRUE |
4146 | 4146 | Ventura | Ventura | 111 | 2021-06-27 | 81750 | 1027 | TRUE |
4147 | 4147 | Yolo | Yolo | 113 | 2021-06-27 | 14122 | 210 | TRUE |
4148 | 4148 | Yuba | Yuba | 115 | 2021-06-27 | 6526 | 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 );