ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-06-16 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
243428 | 243428 | 2020-06-16 | Alameda | California | 6001 | 4502 | 112 |
243429 | 243429 | 2020-06-16 | Alpine | California | 6003 | 1 | 0 |
243430 | 243430 | 2020-06-16 | Amador | California | 6005 | 11 | 0 |
243431 | 243431 | 2020-06-16 | Butte | California | 6007 | 88 | 1 |
243432 | 243432 | 2020-06-16 | Calaveras | California | 6009 | 26 | 0 |
243433 | 243433 | 2020-06-16 | Colusa | California | 6011 | 7 | 0 |
243434 | 243434 | 2020-06-16 | Contra Costa | California | 6013 | 2026 | 49 |
243435 | 243435 | 2020-06-16 | Del Norte | California | 6015 | 48 | 0 |
243436 | 243436 | 2020-06-16 | El Dorado | California | 6017 | 118 | 0 |
243437 | 243437 | 2020-06-16 | Fresno | California | 6019 | 2788 | 57 |
243438 | 243438 | 2020-06-16 | Glenn | California | 6021 | 34 | 0 |
243439 | 243439 | 2020-06-16 | Humboldt | California | 6023 | 107 | 4 |
243440 | 243440 | 2020-06-16 | Imperial | California | 6025 | 4389 | 51 |
243441 | 243441 | 2020-06-16 | Inyo | California | 6027 | 23 | 1 |
243442 | 243442 | 2020-06-16 | Kern | California | 6029 | 3462 | 57 |
243443 | 243443 | 2020-06-16 | Kings | California | 6031 | 1870 | 9 |
243444 | 243444 | 2020-06-16 | Lake | California | 6033 | 34 | 0 |
243445 | 243445 | 2020-06-16 | Lassen | California | 6035 | 9 | 0 |
243446 | 243446 | 2020-06-16 | Los Angeles | California | 6037 | 75084 | 2959 |
243447 | 243447 | 2020-06-16 | Madera | California | 6039 | 250 | 4 |
243448 | 243448 | 2020-06-16 | Marin | California | 6041 | 805 | 18 |
243449 | 243449 | 2020-06-16 | Mariposa | California | 6043 | 17 | 1 |
243450 | 243450 | 2020-06-16 | Mendocino | California | 6045 | 47 | 0 |
243451 | 243451 | 2020-06-16 | Merced | California | 6047 | 470 | 7 |
243452 | 243452 | 2020-06-16 | Mono | California | 6051 | 37 | 1 |
243453 | 243453 | 2020-06-16 | Monterey | California | 6053 | 1015 | 12 |
243454 | 243454 | 2020-06-16 | Napa | California | 6055 | 200 | 3 |
243455 | 243455 | 2020-06-16 | Nevada | California | 6057 | 57 | 1 |
243456 | 243456 | 2020-06-16 | Orange | California | 6059 | 8999 | 233 |
243457 | 243457 | 2020-06-16 | Placer | California | 6061 | 411 | 9 |
243458 | 243458 | 2020-06-16 | Plumas | California | 6063 | 4 | 0 |
243459 | 243459 | 2020-06-16 | Riverside | California | 6065 | 11694 | 395 |
243460 | 243460 | 2020-06-16 | Sacramento | California | 6067 | 1824 | 63 |
243461 | 243461 | 2020-06-16 | San Benito | California | 6069 | 136 | 2 |
243462 | 243462 | 2020-06-16 | San Bernardino | California | 6071 | 7796 | 229 |
243463 | 243463 | 2020-06-16 | San Diego | California | 6073 | 9793 | 323 |
243464 | 243464 | 2020-06-16 | San Francisco | California | 6075 | 2974 | 46 |
243465 | 243465 | 2020-06-16 | San Joaquin | California | 6077 | 1749 | 47 |
243466 | 243466 | 2020-06-16 | San Luis Obispo | California | 6079 | 356 | 1 |
243467 | 243467 | 2020-06-16 | San Mateo | California | 6081 | 2591 | 99 |
243468 | 243468 | 2020-06-16 | Santa Barbara | California | 6083 | 2100 | 18 |
243469 | 243469 | 2020-06-16 | Santa Clara | California | 6085 | 3254 | 153 |
243470 | 243470 | 2020-06-16 | Santa Cruz | California | 6087 | 260 | 3 |
243471 | 243471 | 2020-06-16 | Shasta | California | 6089 | 51 | 4 |
243472 | 243472 | 2020-06-16 | Sierra | California | 6091 | 1 | 0 |
243473 | 243473 | 2020-06-16 | Siskiyou | California | 6093 | 20 | 0 |
243474 | 243474 | 2020-06-16 | Solano | California | 6095 | 692 | 23 |
243475 | 243475 | 2020-06-16 | Sonoma | California | 6097 | 774 | 4 |
243476 | 243476 | 2020-06-16 | Stanislaus | California | 6099 | 1253 | 35 |
243477 | 243477 | 2020-06-16 | Sutter | California | 6101 | 89 | 3 |
243478 | 243478 | 2020-06-16 | Tehama | California | 6103 | 17 | 1 |
243479 | 243479 | 2020-06-16 | Trinity | California | 6105 | 3 | 0 |
243480 | 243480 | 2020-06-16 | Tulare | California | 6107 | 2798 | 98 |
243481 | 243481 | 2020-06-16 | Tuolumne | California | 6109 | 9 | 0 |
243482 | 243482 | 2020-06-16 | Ventura | California | 6111 | 1656 | 41 |
243483 | 243483 | 2020-06-16 | Yolo | California | 6113 | 265 | 24 |
243484 | 243484 | 2020-06-16 | Yuba | California | 6115 | 37 | 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);