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-04-28 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
95491 | 95491 | 2020-04-28 | Alameda | California | 6001 | 1554 | 59 |
95492 | 95492 | 2020-04-28 | Alpine | California | 6003 | 1 | 0 |
95493 | 95493 | 2020-04-28 | Amador | California | 6005 | 7 | 0 |
95494 | 95494 | 2020-04-28 | Butte | California | 6007 | 16 | 0 |
95495 | 95495 | 2020-04-28 | Calaveras | California | 6009 | 13 | 0 |
95496 | 95496 | 2020-04-28 | Colusa | California | 6011 | 3 | 0 |
95497 | 95497 | 2020-04-28 | Contra Costa | California | 6013 | 843 | 25 |
95498 | 95498 | 2020-04-28 | Del Norte | California | 6015 | 3 | 0 |
95499 | 95499 | 2020-04-28 | El Dorado | California | 6017 | 44 | 0 |
95500 | 95500 | 2020-04-28 | Fresno | California | 6019 | 521 | 7 |
95501 | 95501 | 2020-04-28 | Glenn | California | 6021 | 5 | 0 |
95502 | 95502 | 2020-04-28 | Humboldt | California | 6023 | 53 | 0 |
95503 | 95503 | 2020-04-28 | Imperial | California | 6025 | 304 | 8 |
95504 | 95504 | 2020-04-28 | Inyo | California | 6027 | 20 | 1 |
95505 | 95505 | 2020-04-28 | Kern | California | 6029 | 865 | 5 |
95506 | 95506 | 2020-04-28 | Kings | California | 6031 | 79 | 1 |
95507 | 95507 | 2020-04-28 | Lake | California | 6033 | 6 | 0 |
95508 | 95508 | 2020-04-28 | Los Angeles | California | 6037 | 20976 | 1000 |
95509 | 95509 | 2020-04-28 | Madera | California | 6039 | 45 | 2 |
95510 | 95510 | 2020-04-28 | Marin | California | 6041 | 227 | 12 |
95511 | 95511 | 2020-04-28 | Mariposa | California | 6043 | 1 | 0 |
95512 | 95512 | 2020-04-28 | Mendocino | California | 6045 | 11 | 0 |
95513 | 95513 | 2020-04-28 | Merced | California | 6047 | 116 | 3 |
95514 | 95514 | 2020-04-28 | Mono | California | 6051 | 26 | 1 |
95515 | 95515 | 2020-04-28 | Monterey | California | 6053 | 191 | 5 |
95516 | 95516 | 2020-04-28 | Napa | California | 6055 | 67 | 2 |
95517 | 95517 | 2020-04-28 | Nevada | California | 6057 | 41 | 1 |
95518 | 95518 | 2020-04-28 | Orange | California | 6059 | 2198 | 42 |
95519 | 95519 | 2020-04-28 | Placer | California | 6061 | 145 | 8 |
95520 | 95520 | 2020-04-28 | Plumas | California | 6063 | 4 | 0 |
95521 | 95521 | 2020-04-28 | Riverside | California | 6065 | 3735 | 141 |
95522 | 95522 | 2020-04-28 | Sacramento | California | 6067 | 1053 | 41 |
95523 | 95523 | 2020-04-28 | San Benito | California | 6069 | 50 | 2 |
95524 | 95524 | 2020-04-28 | San Bernardino | California | 6071 | 1827 | 85 |
95525 | 95525 | 2020-04-28 | San Diego | California | 6073 | 3378 | 128 |
95526 | 95526 | 2020-04-28 | San Francisco | California | 6075 | 1471 | 23 |
95527 | 95527 | 2020-04-28 | San Joaquin | California | 6077 | 529 | 25 |
95528 | 95528 | 2020-04-28 | San Luis Obispo | California | 6079 | 173 | 1 |
95529 | 95529 | 2020-04-28 | San Mateo | California | 6081 | 1099 | 48 |
95530 | 95530 | 2020-04-28 | Santa Barbara | California | 6083 | 477 | 7 |
95531 | 95531 | 2020-04-28 | Santa Clara | California | 6085 | 2122 | 107 |
95532 | 95532 | 2020-04-28 | Santa Cruz | California | 6087 | 125 | 2 |
95533 | 95533 | 2020-04-28 | Shasta | California | 6089 | 31 | 4 |
95534 | 95534 | 2020-04-28 | Siskiyou | California | 6093 | 5 | 0 |
95535 | 95535 | 2020-04-28 | Solano | California | 6095 | 254 | 4 |
95536 | 95536 | 2020-04-28 | Sonoma | California | 6097 | 228 | 2 |
95537 | 95537 | 2020-04-28 | Stanislaus | California | 6099 | 324 | 10 |
95538 | 95538 | 2020-04-28 | Sutter | California | 6101 | 29 | 2 |
95539 | 95539 | 2020-04-28 | Tehama | California | 6103 | 1 | 1 |
95540 | 95540 | 2020-04-28 | Tulare | California | 6107 | 578 | 35 |
95541 | 95541 | 2020-04-28 | Tuolumne | California | 6109 | 4 | 0 |
95542 | 95542 | 2020-04-28 | Ventura | California | 6111 | 513 | 17 |
95543 | 95543 | 2020-04-28 | Yolo | California | 6113 | 162 | 16 |
95544 | 95544 | 2020-04-28 | Yuba | California | 6115 | 17 | 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);