ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-09-26" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
570228 | 570228 | 2020-09-26 | Alameda | California | 6001 | 21157 | 406 |
570229 | 570229 | 2020-09-26 | Alpine | California | 6003 | 2 | 0 |
570230 | 570230 | 2020-09-26 | Amador | California | 6005 | 288 | 16 |
570231 | 570231 | 2020-09-26 | Butte | California | 6007 | 2819 | 44 |
570232 | 570232 | 2020-09-26 | Calaveras | California | 6009 | 317 | 14 |
570233 | 570233 | 2020-09-26 | Colusa | California | 6011 | 529 | 6 |
570234 | 570234 | 2020-09-26 | Contra Costa | California | 6013 | 16572 | 205 |
570235 | 570235 | 2020-09-26 | Del Norte | California | 6015 | 139 | 1 |
570236 | 570236 | 2020-09-26 | El Dorado | California | 6017 | 1109 | 4 |
570237 | 570237 | 2020-09-26 | Fresno | California | 6019 | 28199 | 382 |
570238 | 570238 | 2020-09-26 | Glenn | California | 6021 | 570 | 3 |
570239 | 570239 | 2020-09-26 | Humboldt | California | 6023 | 501 | 7 |
570240 | 570240 | 2020-09-26 | Imperial | California | 6025 | 11835 | 316 |
570241 | 570241 | 2020-09-26 | Inyo | California | 6027 | 187 | 15 |
570242 | 570242 | 2020-09-26 | Kern | California | 6029 | 31947 | 369 |
570243 | 570243 | 2020-09-26 | Kings | California | 6031 | 7561 | 80 |
570244 | 570244 | 2020-09-26 | Lake | California | 6033 | 539 | 11 |
570245 | 570245 | 2020-09-26 | Lassen | California | 6035 | 740 | 0 |
570246 | 570246 | 2020-09-26 | Los Angeles | California | 6037 | 266988 | 6504 |
570247 | 570247 | 2020-09-26 | Madera | California | 6039 | 4458 | 65 |
570248 | 570248 | 2020-09-26 | Marin | California | 6041 | 6716 | 117 |
570249 | 570249 | 2020-09-26 | Mariposa | California | 6043 | 75 | 2 |
570250 | 570250 | 2020-09-26 | Mendocino | California | 6045 | 931 | 18 |
570251 | 570251 | 2020-09-26 | Merced | California | 6047 | 8872 | 142 |
570252 | 570252 | 2020-09-26 | Modoc | California | 6049 | 27 | 0 |
570253 | 570253 | 2020-09-26 | Mono | California | 6051 | 165 | 2 |
570254 | 570254 | 2020-09-26 | Monterey | California | 6053 | 9884 | 71 |
570255 | 570255 | 2020-09-26 | Napa | California | 6055 | 1670 | 13 |
570256 | 570256 | 2020-09-26 | Nevada | California | 6057 | 533 | 7 |
570257 | 570257 | 2020-09-26 | Orange | California | 6059 | 54527 | 1214 |
570258 | 570258 | 2020-09-26 | Placer | California | 6061 | 3567 | 45 |
570259 | 570259 | 2020-09-26 | Plumas | California | 6063 | 48 | 0 |
570260 | 570260 | 2020-09-26 | Riverside | California | 6065 | 58178 | 1189 |
570261 | 570261 | 2020-09-26 | Sacramento | California | 6067 | 22182 | 406 |
570262 | 570262 | 2020-09-26 | San Benito | California | 6069 | 1340 | 11 |
570263 | 570263 | 2020-09-26 | San Bernardino | California | 6071 | 54386 | 925 |
570264 | 570264 | 2020-09-26 | San Diego | California | 6073 | 46394 | 775 |
570265 | 570265 | 2020-09-26 | San Francisco | California | 6075 | 11079 | 101 |
570266 | 570266 | 2020-09-26 | San Joaquin | California | 6077 | 20194 | 441 |
570267 | 570267 | 2020-09-26 | San Luis Obispo | California | 6079 | 3544 | 29 |
570268 | 570268 | 2020-09-26 | San Mateo | California | 6081 | 9843 | 150 |
570269 | 570269 | 2020-09-26 | Santa Barbara | California | 6083 | 9037 | 113 |
570270 | 570270 | 2020-09-26 | Santa Clara | California | 6085 | 21030 | 312 |
570271 | 570271 | 2020-09-26 | Santa Cruz | California | 6087 | 2358 | 9 |
570272 | 570272 | 2020-09-26 | Shasta | California | 6089 | 806 | 17 |
570273 | 570273 | 2020-09-26 | Sierra | California | 6091 | 6 | 0 |
570274 | 570274 | 2020-09-26 | Siskiyou | California | 6093 | 165 | 0 |
570275 | 570275 | 2020-09-26 | Solano | California | 6095 | 6314 | 63 |
570276 | 570276 | 2020-09-26 | Sonoma | California | 6097 | 7369 | 122 |
570277 | 570277 | 2020-09-26 | Stanislaus | California | 6099 | 16442 | 351 |
570278 | 570278 | 2020-09-26 | Sutter | California | 6101 | 1705 | 11 |
570279 | 570279 | 2020-09-26 | Tehama | California | 6103 | 546 | 5 |
570280 | 570280 | 2020-09-26 | Trinity | California | 6105 | 16 | 0 |
570281 | 570281 | 2020-09-26 | Tulare | California | 6107 | 15970 | 263 |
570282 | 570282 | 2020-09-26 | Tuolumne | California | 6109 | 227 | 4 |
570283 | 570283 | 2020-09-26 | Ventura | California | 6111 | 12664 | 150 |
570284 | 570284 | 2020-09-26 | Yolo | California | 6113 | 2795 | 55 |
570285 | 570285 | 2020-09-26 | Yuba | California | 6115 | 1153 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);