ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2022-01-13 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109316 | 2109316 | 2022-01-13 | Alameda | California | 6001 | 180353 | 1586 |
2109317 | 2109317 | 2022-01-13 | Alpine | California | 6003 | 117 | 0 |
2109318 | 2109318 | 2022-01-13 | Amador | California | 6005 | 6482 | 71 |
2109319 | 2109319 | 2022-01-13 | Butte | California | 6007 | 29391 | 348 |
2109320 | 2109320 | 2022-01-13 | Calaveras | California | 6009 | 5281 | 93 |
2109321 | 2109321 | 2022-01-13 | Colusa | California | 6011 | 3599 | 21 |
2109322 | 2109322 | 2022-01-13 | Contra Costa | California | 6013 | 139908 | 1077 |
2109323 | 2109323 | 2022-01-13 | Del Norte | California | 6015 | 4251 | 43 |
2109324 | 2109324 | 2022-01-13 | El Dorado | California | 6017 | 22358 | 175 |
2109325 | 2109325 | 2022-01-13 | Fresno | California | 6019 | 179628 | 2413 |
2109326 | 2109326 | 2022-01-13 | Glenn | California | 6021 | 5033 | 55 |
2109327 | 2109327 | 2022-01-13 | Humboldt | California | 6023 | 13463 | 128 |
2109328 | 2109328 | 2022-01-13 | Imperial | California | 6025 | 47613 | 813 |
2109329 | 2109329 | 2022-01-13 | Inyo | California | 6027 | 3407 | 49 |
2109330 | 2109330 | 2022-01-13 | Kern | California | 6029 | 179110 | 1958 |
2109331 | 2109331 | 2022-01-13 | Kings | California | 6031 | 39230 | 391 |
2109332 | 2109332 | 2022-01-13 | Lake | California | 6033 | 7861 | 117 |
2109333 | 2109333 | 2022-01-13 | Lassen | California | 6035 | 8535 | 61 |
2109334 | 2109334 | 2022-01-13 | Los Angeles | California | 6037 | 2132227 | 27985 |
2109335 | 2109335 | 2022-01-13 | Madera | California | 6039 | 29794 | 329 |
2109336 | 2109336 | 2022-01-13 | Marin | California | 6041 | 26028 | 251 |
2109337 | 2109337 | 2022-01-13 | Mariposa | California | 6043 | 2081 | 18 |
2109338 | 2109338 | 2022-01-13 | Mendocino | California | 6045 | 10417 | 109 |
2109339 | 2109339 | 2022-01-13 | Merced | California | 6047 | 52218 | 720 |
2109340 | 2109340 | 2022-01-13 | Modoc | California | 6049 | 1199 | 11 |
2109341 | 2109341 | 2022-01-13 | Mono | California | 6051 | 2552 | 4 |
2109342 | 2109342 | 2022-01-13 | Monterey | California | 6053 | 62561 | 653 |
2109343 | 2109343 | 2022-01-13 | Napa | California | 6055 | 17646 | 109 |
2109344 | 2109344 | 2022-01-13 | Nevada | California | 6057 | 12089 | 111 |
2109345 | 2109345 | 2022-01-13 | Orange | California | 6059 | 451612 | 5916 |
2109346 | 2109346 | 2022-01-13 | Placer | California | 6061 | 51997 | 501 |
2109347 | 2109347 | 2022-01-13 | Plumas | California | 6063 | 2232 | 12 |
2109348 | 2109348 | 2022-01-13 | Riverside | California | 6065 | 478326 | 5661 |
2109349 | 2109349 | 2022-01-13 | Sacramento | California | 6067 | 216000 | 2582 |
2109350 | 2109350 | 2022-01-13 | San Benito | California | 6069 | 10046 | 87 |
2109351 | 2109351 | 2022-01-13 | San Bernardino | California | 6071 | 463256 | 6222 |
2109352 | 2109352 | 2022-01-13 | San Diego | California | 6073 | 587767 | 4529 |
2109353 | 2109353 | 2022-01-13 | San Francisco | California | 6075 | 92571 | 691 |
2109354 | 2109354 | 2022-01-13 | San Joaquin | California | 6077 | 129868 | 1948 |
2109355 | 2109355 | 2022-01-13 | San Luis Obispo | California | 6079 | 39929 | 373 |
2109356 | 2109356 | 2022-01-13 | San Mateo | California | 6081 | 85171 | 638 |
2109357 | 2109357 | 2022-01-13 | Santa Barbara | California | 6083 | 63270 | 578 |
2109358 | 2109358 | 2022-01-13 | Santa Clara | California | 6085 | 218660 | 1972 |
2109359 | 2109359 | 2022-01-13 | Santa Cruz | California | 6087 | 29900 | 235 |
2109360 | 2109360 | 2022-01-13 | Shasta | California | 6089 | 28544 | 502 |
2109361 | 2109361 | 2022-01-13 | Sierra | California | 6091 | 253 | 0 |
2109362 | 2109362 | 2022-01-13 | Siskiyou | California | 6093 | 5337 | 81 |
2109363 | 2109363 | 2022-01-13 | Solano | California | 6095 | 59459 | 386 |
2109364 | 2109364 | 2022-01-13 | Sonoma | California | 6097 | 57381 | 422 |
2109365 | 2109365 | 2022-01-13 | Stanislaus | California | 6099 | 105299 | 1503 |
2109366 | 2109366 | 2022-01-13 | Sutter | California | 6101 | 16944 | 204 |
2109367 | 2109367 | 2022-01-13 | Tehama | California | 6103 | 11315 | 141 |
2109368 | 2109368 | 2022-01-13 | Trinity | California | 6105 | 1092 | 19 |
2109369 | 2109369 | 2022-01-13 | Tulare | California | 6107 | 96787 | 1192 |
2109370 | 2109370 | 2022-01-13 | Tuolumne | California | 6109 | 9266 | 152 |
2109371 | 2109371 | 2022-01-13 | Ventura | California | 6111 | 138203 | 1222 |
2109372 | 2109372 | 2022-01-13 | Yolo | California | 6113 | 28837 | 270 |
2109373 | 2109373 | 2022-01-13 | Yuba | California | 6115 | 12811 | 101 |
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);