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 2021-01-19 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
943340 | 943340 | 2021-01-19 | Alameda | California | 6001 | 67973 | 765 |
943341 | 943341 | 2021-01-19 | Alpine | California | 6003 | 71 | 0 |
943342 | 943342 | 2021-01-19 | Amador | California | 6005 | 3015 | 29 |
943343 | 943343 | 2021-01-19 | Butte | California | 6007 | 9474 | 121 |
943344 | 943344 | 2021-01-19 | Calaveras | California | 6009 | 1617 | 23 |
943345 | 943345 | 2021-01-19 | Colusa | California | 6011 | 1733 | 9 |
943346 | 943346 | 2021-01-19 | Contra Costa | California | 6013 | 52965 | 450 |
943347 | 943347 | 2021-01-19 | Del Norte | California | 6015 | 866 | 2 |
943348 | 943348 | 2021-01-19 | El Dorado | California | 6017 | 7707 | 44 |
943349 | 943349 | 2021-01-19 | Fresno | California | 6019 | 82485 | 932 |
943350 | 943350 | 2021-01-19 | Glenn | California | 6021 | 2177 | 19 |
943351 | 943351 | 2021-01-19 | Humboldt | California | 6023 | 2393 | 24 |
943352 | 943352 | 2021-01-19 | Imperial | California | 6025 | 25317 | 464 |
943353 | 943353 | 2021-01-19 | Inyo | California | 6027 | 872 | 29 |
943354 | 943354 | 2021-01-19 | Kern | California | 6029 | 86718 | 565 |
943355 | 943355 | 2021-01-19 | Kings | California | 6031 | 19435 | 145 |
943356 | 943356 | 2021-01-19 | Lake | California | 6033 | 2591 | 30 |
943357 | 943357 | 2021-01-19 | Lassen | California | 6035 | 5195 | 13 |
943358 | 943358 | 2021-01-19 | Los Angeles | California | 6037 | 1032277 | 14122 |
943359 | 943359 | 2021-01-19 | Madera | California | 6039 | 13443 | 151 |
943360 | 943360 | 2021-01-19 | Marin | California | 6041 | 11691 | 154 |
943361 | 943361 | 2021-01-19 | Mariposa | California | 6043 | 346 | 4 |
943362 | 943362 | 2021-01-19 | Mendocino | California | 6045 | 3114 | 32 |
943363 | 943363 | 2021-01-19 | Merced | California | 6047 | 24452 | 308 |
943364 | 943364 | 2021-01-19 | Modoc | California | 6049 | 385 | 3 |
943365 | 943365 | 2021-01-19 | Mono | California | 6051 | 1101 | 4 |
943366 | 943366 | 2021-01-19 | Monterey | California | 6053 | 36126 | 255 |
943367 | 943367 | 2021-01-19 | Napa | California | 6055 | 7602 | 40 |
943368 | 943368 | 2021-01-19 | Nevada | California | 6057 | 3206 | 73 |
943369 | 943369 | 2021-01-19 | Orange | California | 6059 | 227321 | 2477 |
943370 | 943370 | 2021-01-19 | Placer | California | 6061 | 17380 | 180 |
943371 | 943371 | 2021-01-19 | Plumas | California | 6063 | 506 | 5 |
943372 | 943372 | 2021-01-19 | Riverside | California | 6065 | 250436 | 2645 |
943373 | 943373 | 2021-01-19 | Sacramento | California | 6067 | 80677 | 1111 |
943374 | 943374 | 2021-01-19 | San Benito | California | 6069 | 4963 | 43 |
943375 | 943375 | 2021-01-19 | San Bernardino | California | 6071 | 256109 | 1560 |
943376 | 943376 | 2021-01-19 | San Diego | California | 6073 | 216898 | 2109 |
943377 | 943377 | 2021-01-19 | San Francisco | California | 6075 | 29324 | 262 |
943378 | 943378 | 2021-01-19 | San Joaquin | California | 6077 | 58290 | 786 |
943379 | 943379 | 2021-01-19 | San Luis Obispo | California | 6079 | 15929 | 136 |
943380 | 943380 | 2021-01-19 | San Mateo | California | 6081 | 32596 | 309 |
943381 | 943381 | 2021-01-19 | Santa Barbara | California | 6083 | 25083 | 236 |
943382 | 943382 | 2021-01-19 | Santa Clara | California | 6085 | 94366 | 1110 |
943383 | 943383 | 2021-01-19 | Santa Cruz | California | 6087 | 12298 | 113 |
943384 | 943384 | 2021-01-19 | Shasta | California | 6089 | 9600 | 117 |
943385 | 943385 | 2021-01-19 | Sierra | California | 6091 | 40 | 0 |
943386 | 943386 | 2021-01-19 | Siskiyou | California | 6093 | 1446 | 13 |
943387 | 943387 | 2021-01-19 | Solano | California | 6095 | 25811 | 106 |
943388 | 943388 | 2021-01-19 | Sonoma | California | 6097 | 24068 | 240 |
943389 | 943389 | 2021-01-19 | Stanislaus | California | 6099 | 47187 | 758 |
943390 | 943390 | 2021-01-19 | Sutter | California | 6101 | 7754 | 78 |
943391 | 943391 | 2021-01-19 | Tehama | California | 6103 | 3854 | 42 |
943392 | 943392 | 2021-01-19 | Trinity | California | 6105 | 261 | 4 |
943393 | 943393 | 2021-01-19 | Tulare | California | 6107 | 41867 | 506 |
943394 | 943394 | 2021-01-19 | Tuolumne | California | 6109 | 3382 | 40 |
943395 | 943395 | 2021-01-19 | Ventura | California | 6111 | 62101 | 436 |
943396 | 943396 | 2021-01-19 | Yolo | California | 6113 | 10620 | 131 |
943397 | 943397 | 2021-01-19 | Yuba | California | 6115 | 4951 | 27 |
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);