ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-05-07 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
121459 | 121459 | 2020-05-07 | Alameda | California | 6001 | 1938 | 69 |
121460 | 121460 | 2020-05-07 | Alpine | California | 6003 | 2 | 0 |
121461 | 121461 | 2020-05-07 | Amador | California | 6005 | 7 | 0 |
121462 | 121462 | 2020-05-07 | Butte | California | 6007 | 19 | 0 |
121463 | 121463 | 2020-05-07 | Calaveras | California | 6009 | 13 | 0 |
121464 | 121464 | 2020-05-07 | Colusa | California | 6011 | 3 | 0 |
121465 | 121465 | 2020-05-07 | Contra Costa | California | 6013 | 999 | 29 |
121466 | 121466 | 2020-05-07 | Del Norte | California | 6015 | 3 | 0 |
121467 | 121467 | 2020-05-07 | El Dorado | California | 6017 | 54 | 0 |
121468 | 121468 | 2020-05-07 | Fresno | California | 6019 | 813 | 9 |
121469 | 121469 | 2020-05-07 | Glenn | California | 6021 | 6 | 0 |
121470 | 121470 | 2020-05-07 | Humboldt | California | 6023 | 55 | 0 |
121471 | 121471 | 2020-05-07 | Imperial | California | 6025 | 455 | 8 |
121472 | 121472 | 2020-05-07 | Inyo | California | 6027 | 20 | 1 |
121473 | 121473 | 2020-05-07 | Kern | California | 6029 | 1133 | 14 |
121474 | 121474 | 2020-05-07 | Kings | California | 6031 | 244 | 1 |
121475 | 121475 | 2020-05-07 | Lake | California | 6033 | 8 | 0 |
121476 | 121476 | 2020-05-07 | Los Angeles | California | 6037 | 29427 | 1418 |
121477 | 121477 | 2020-05-07 | Madera | California | 6039 | 62 | 2 |
121478 | 121478 | 2020-05-07 | Marin | California | 6041 | 244 | 14 |
121479 | 121479 | 2020-05-07 | Mariposa | California | 6043 | 15 | 0 |
121480 | 121480 | 2020-05-07 | Mendocino | California | 6045 | 12 | 0 |
121481 | 121481 | 2020-05-07 | Merced | California | 6047 | 155 | 3 |
121482 | 121482 | 2020-05-07 | Mono | California | 6051 | 28 | 1 |
121483 | 121483 | 2020-05-07 | Monterey | California | 6053 | 246 | 6 |
121484 | 121484 | 2020-05-07 | Napa | California | 6055 | 79 | 2 |
121485 | 121485 | 2020-05-07 | Nevada | California | 6057 | 41 | 1 |
121486 | 121486 | 2020-05-07 | Orange | California | 6059 | 3156 | 66 |
121487 | 121487 | 2020-05-07 | Placer | California | 6061 | 165 | 8 |
121488 | 121488 | 2020-05-07 | Plumas | California | 6063 | 4 | 0 |
121489 | 121489 | 2020-05-07 | Riverside | California | 6065 | 4756 | 194 |
121490 | 121490 | 2020-05-07 | Sacramento | California | 6067 | 1132 | 49 |
121491 | 121491 | 2020-05-07 | San Benito | California | 6069 | 54 | 2 |
121492 | 121492 | 2020-05-07 | San Bernardino | California | 6071 | 2562 | 108 |
121493 | 121493 | 2020-05-07 | San Diego | California | 6073 | 4492 | 186 |
121494 | 121494 | 2020-05-07 | San Francisco | California | 6075 | 1806 | 32 |
121495 | 121495 | 2020-05-07 | San Joaquin | California | 6077 | 581 | 28 |
121496 | 121496 | 2020-05-07 | San Luis Obispo | California | 6079 | 211 | 1 |
121497 | 121497 | 2020-05-07 | San Mateo | California | 6081 | 1377 | 56 |
121498 | 121498 | 2020-05-07 | Santa Barbara | California | 6083 | 722 | 11 |
121499 | 121499 | 2020-05-07 | Santa Clara | California | 6085 | 2281 | 122 |
121500 | 121500 | 2020-05-07 | Santa Cruz | California | 6087 | 139 | 2 |
121501 | 121501 | 2020-05-07 | Shasta | California | 6089 | 31 | 4 |
121502 | 121502 | 2020-05-07 | Siskiyou | California | 6093 | 5 | 0 |
121503 | 121503 | 2020-05-07 | Solano | California | 6095 | 347 | 7 |
121504 | 121504 | 2020-05-07 | Sonoma | California | 6097 | 292 | 4 |
121505 | 121505 | 2020-05-07 | Stanislaus | California | 6099 | 461 | 17 |
121506 | 121506 | 2020-05-07 | Sutter | California | 6101 | 31 | 2 |
121507 | 121507 | 2020-05-07 | Tehama | California | 6103 | 1 | 1 |
121508 | 121508 | 2020-05-07 | Tulare | California | 6107 | 969 | 43 |
121509 | 121509 | 2020-05-07 | Tuolumne | California | 6109 | 2 | 0 |
121510 | 121510 | 2020-05-07 | Ventura | California | 6111 | 631 | 19 |
121511 | 121511 | 2020-05-07 | Yolo | California | 6113 | 172 | 20 |
121512 | 121512 | 2020-05-07 | 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);