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-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 |
---|---|---|---|---|---|---|---|
157421 | 157421 | 2020-05-19 | Alameda | California | 6001 | 2543 | 88 |
157422 | 157422 | 2020-05-19 | Alpine | California | 6003 | 2 | 0 |
157423 | 157423 | 2020-05-19 | Amador | California | 6005 | 8 | 0 |
157424 | 157424 | 2020-05-19 | Butte | California | 6007 | 26 | 0 |
157425 | 157425 | 2020-05-19 | Calaveras | California | 6009 | 13 | 0 |
157426 | 157426 | 2020-05-19 | Colusa | California | 6011 | 3 | 0 |
157427 | 157427 | 2020-05-19 | Contra Costa | California | 6013 | 1192 | 33 |
157428 | 157428 | 2020-05-19 | Del Norte | California | 6015 | 14 | 0 |
157429 | 157429 | 2020-05-19 | El Dorado | California | 6017 | 67 | 0 |
157430 | 157430 | 2020-05-19 | Fresno | California | 6019 | 1287 | 17 |
157431 | 157431 | 2020-05-19 | Glenn | California | 6021 | 12 | 0 |
157432 | 157432 | 2020-05-19 | Humboldt | California | 6023 | 86 | 0 |
157433 | 157433 | 2020-05-19 | Imperial | California | 6025 | 902 | 17 |
157434 | 157434 | 2020-05-19 | Inyo | California | 6027 | 20 | 1 |
157435 | 157435 | 2020-05-19 | Kern | California | 6029 | 1596 | 26 |
157436 | 157436 | 2020-05-19 | Kings | California | 6031 | 416 | 2 |
157437 | 157437 | 2020-05-19 | Lake | California | 6033 | 11 | 0 |
157438 | 157438 | 2020-05-19 | Los Angeles | California | 6037 | 39573 | 1913 |
157439 | 157439 | 2020-05-19 | Madera | California | 6039 | 81 | 2 |
157440 | 157440 | 2020-05-19 | Marin | California | 6041 | 336 | 14 |
157441 | 157441 | 2020-05-19 | Mariposa | California | 6043 | 15 | 1 |
157442 | 157442 | 2020-05-19 | Mendocino | California | 6045 | 15 | 0 |
157443 | 157443 | 2020-05-19 | Merced | California | 6047 | 222 | 6 |
157444 | 157444 | 2020-05-19 | Mono | California | 6051 | 34 | 1 |
157445 | 157445 | 2020-05-19 | Monterey | California | 6053 | 345 | 8 |
157446 | 157446 | 2020-05-19 | Napa | California | 6055 | 93 | 3 |
157447 | 157447 | 2020-05-19 | Nevada | California | 6057 | 41 | 1 |
157448 | 157448 | 2020-05-19 | Orange | California | 6059 | 4558 | 88 |
157449 | 157449 | 2020-05-19 | Placer | California | 6061 | 177 | 9 |
157450 | 157450 | 2020-05-19 | Plumas | California | 6063 | 5 | 0 |
157451 | 157451 | 2020-05-19 | Riverside | California | 6065 | 6053 | 270 |
157452 | 157452 | 2020-05-19 | Sacramento | California | 6067 | 1249 | 56 |
157453 | 157453 | 2020-05-19 | San Benito | California | 6069 | 63 | 2 |
157454 | 157454 | 2020-05-19 | San Bernardino | California | 6071 | 3707 | 157 |
157455 | 157455 | 2020-05-19 | San Diego | California | 6073 | 6089 | 242 |
157456 | 157456 | 2020-05-19 | San Francisco | California | 6075 | 2186 | 36 |
157457 | 157457 | 2020-05-19 | San Joaquin | California | 6077 | 709 | 33 |
157458 | 157458 | 2020-05-19 | San Luis Obispo | California | 6079 | 247 | 1 |
157459 | 157459 | 2020-05-19 | San Mateo | California | 6081 | 1701 | 68 |
157460 | 157460 | 2020-05-19 | Santa Barbara | California | 6083 | 1509 | 11 |
157461 | 157461 | 2020-05-19 | Santa Clara | California | 6085 | 2483 | 138 |
157462 | 157462 | 2020-05-19 | Santa Cruz | California | 6087 | 165 | 3 |
157463 | 157463 | 2020-05-19 | Shasta | California | 6089 | 34 | 4 |
157464 | 157464 | 2020-05-19 | Siskiyou | California | 6093 | 6 | 0 |
157465 | 157465 | 2020-05-19 | Solano | California | 6095 | 435 | 16 |
157466 | 157466 | 2020-05-19 | Sonoma | California | 6097 | 411 | 4 |
157467 | 157467 | 2020-05-19 | Stanislaus | California | 6099 | 593 | 26 |
157468 | 157468 | 2020-05-19 | Sutter | California | 6101 | 40 | 2 |
157469 | 157469 | 2020-05-19 | Tehama | California | 6103 | 2 | 1 |
157470 | 157470 | 2020-05-19 | Trinity | California | 6105 | 2 | 0 |
157471 | 157471 | 2020-05-19 | Tulare | California | 6107 | 1539 | 71 |
157472 | 157472 | 2020-05-19 | Tuolumne | California | 6109 | 2 | 0 |
157473 | 157473 | 2020-05-19 | Ventura | California | 6111 | 850 | 28 |
157474 | 157474 | 2020-05-19 | Yolo | California | 6113 | 185 | 22 |
157475 | 157475 | 2020-05-19 | Yuba | California | 6115 | 28 | 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);