ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-05-09 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
127424 | 127424 | 2020-05-09 | Alameda | California | 6001 | 2044 | 72 |
127425 | 127425 | 2020-05-09 | Alpine | California | 6003 | 2 | 0 |
127426 | 127426 | 2020-05-09 | Amador | California | 6005 | 7 | 0 |
127427 | 127427 | 2020-05-09 | Butte | California | 6007 | 18 | 0 |
127428 | 127428 | 2020-05-09 | Calaveras | California | 6009 | 13 | 0 |
127429 | 127429 | 2020-05-09 | Colusa | California | 6011 | 3 | 0 |
127430 | 127430 | 2020-05-09 | Contra Costa | California | 6013 | 1036 | 32 |
127431 | 127431 | 2020-05-09 | Del Norte | California | 6015 | 3 | 0 |
127432 | 127432 | 2020-05-09 | El Dorado | California | 6017 | 54 | 0 |
127433 | 127433 | 2020-05-09 | Fresno | California | 6019 | 885 | 9 |
127434 | 127434 | 2020-05-09 | Glenn | California | 6021 | 6 | 0 |
127435 | 127435 | 2020-05-09 | Humboldt | California | 6023 | 57 | 0 |
127436 | 127436 | 2020-05-09 | Imperial | California | 6025 | 512 | 11 |
127437 | 127437 | 2020-05-09 | Inyo | California | 6027 | 20 | 1 |
127438 | 127438 | 2020-05-09 | Kern | California | 6029 | 1238 | 16 |
127439 | 127439 | 2020-05-09 | Kings | California | 6031 | 275 | 1 |
127440 | 127440 | 2020-05-09 | Lake | California | 6033 | 8 | 0 |
127441 | 127441 | 2020-05-09 | Los Angeles | California | 6037 | 31197 | 1512 |
127442 | 127442 | 2020-05-09 | Madera | California | 6039 | 67 | 2 |
127443 | 127443 | 2020-05-09 | Marin | California | 6041 | 257 | 14 |
127444 | 127444 | 2020-05-09 | Mariposa | California | 6043 | 15 | 0 |
127445 | 127445 | 2020-05-09 | Mendocino | California | 6045 | 12 | 0 |
127446 | 127446 | 2020-05-09 | Merced | California | 6047 | 163 | 3 |
127447 | 127447 | 2020-05-09 | Mono | California | 6051 | 29 | 1 |
127448 | 127448 | 2020-05-09 | Monterey | California | 6053 | 265 | 6 |
127449 | 127449 | 2020-05-09 | Napa | California | 6055 | 79 | 2 |
127450 | 127450 | 2020-05-09 | Nevada | California | 6057 | 41 | 1 |
127451 | 127451 | 2020-05-09 | Orange | California | 6059 | 3395 | 74 |
127452 | 127452 | 2020-05-09 | Placer | California | 6061 | 168 | 8 |
127453 | 127453 | 2020-05-09 | Plumas | California | 6063 | 4 | 0 |
127454 | 127454 | 2020-05-09 | Riverside | California | 6065 | 4992 | 210 |
127455 | 127455 | 2020-05-09 | Sacramento | California | 6067 | 1164 | 51 |
127456 | 127456 | 2020-05-09 | San Benito | California | 6069 | 55 | 2 |
127457 | 127457 | 2020-05-09 | San Bernardino | California | 6071 | 2902 | 119 |
127458 | 127458 | 2020-05-09 | San Diego | California | 6073 | 4839 | 194 |
127459 | 127459 | 2020-05-09 | San Francisco | California | 6075 | 1894 | 33 |
127460 | 127460 | 2020-05-09 | San Joaquin | California | 6077 | 605 | 28 |
127461 | 127461 | 2020-05-09 | San Luis Obispo | California | 6079 | 214 | 1 |
127462 | 127462 | 2020-05-09 | San Mateo | California | 6081 | 1425 | 62 |
127463 | 127463 | 2020-05-09 | Santa Barbara | California | 6083 | 1250 | 11 |
127464 | 127464 | 2020-05-09 | Santa Clara | California | 6085 | 2307 | 131 |
127465 | 127465 | 2020-05-09 | Santa Cruz | California | 6087 | 141 | 2 |
127466 | 127466 | 2020-05-09 | Shasta | California | 6089 | 31 | 4 |
127467 | 127467 | 2020-05-09 | Siskiyou | California | 6093 | 5 | 0 |
127468 | 127468 | 2020-05-09 | Solano | California | 6095 | 356 | 7 |
127469 | 127469 | 2020-05-09 | Sonoma | California | 6097 | 309 | 4 |
127470 | 127470 | 2020-05-09 | Stanislaus | California | 6099 | 488 | 19 |
127471 | 127471 | 2020-05-09 | Sutter | California | 6101 | 33 | 2 |
127472 | 127472 | 2020-05-09 | Tehama | California | 6103 | 1 | 1 |
127473 | 127473 | 2020-05-09 | Tulare | California | 6107 | 1079 | 46 |
127474 | 127474 | 2020-05-09 | Tuolumne | California | 6109 | 2 | 0 |
127475 | 127475 | 2020-05-09 | Unknown | California | 1 | 0 | |
127476 | 127476 | 2020-05-09 | Ventura | California | 6111 | 666 | 19 |
127477 | 127477 | 2020-05-09 | Yolo | California | 6113 | 172 | 20 |
127478 | 127478 | 2020-05-09 | Yuba | California | 6115 | 20 | 1 |
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);