ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2021-01-24 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959569 | 959569 | 2021-01-24 | Alameda | California | 6001 | 70355 | 894 |
959570 | 959570 | 2021-01-24 | Alpine | California | 6003 | 72 | 0 |
959571 | 959571 | 2021-01-24 | Amador | California | 6005 | 3048 | 32 |
959572 | 959572 | 2021-01-24 | Butte | California | 6007 | 9757 | 134 |
959573 | 959573 | 2021-01-24 | Calaveras | California | 6009 | 1695 | 23 |
959574 | 959574 | 2021-01-24 | Colusa | California | 6011 | 1854 | 9 |
959575 | 959575 | 2021-01-24 | Contra Costa | California | 6013 | 54951 | 488 |
959576 | 959576 | 2021-01-24 | Del Norte | California | 6015 | 873 | 2 |
959577 | 959577 | 2021-01-24 | El Dorado | California | 6017 | 7984 | 59 |
959578 | 959578 | 2021-01-24 | Fresno | California | 6019 | 85274 | 1043 |
959579 | 959579 | 2021-01-24 | Glenn | California | 6021 | 2339 | 22 |
959580 | 959580 | 2021-01-24 | Humboldt | California | 6023 | 2494 | 25 |
959581 | 959581 | 2021-01-24 | Imperial | California | 6025 | 25581 | 492 |
959582 | 959582 | 2021-01-24 | Inyo | California | 6027 | 987 | 29 |
959583 | 959583 | 2021-01-24 | Kern | California | 6029 | 90213 | 590 |
959584 | 959584 | 2021-01-24 | Kings | California | 6031 | 19904 | 160 |
959585 | 959585 | 2021-01-24 | Lake | California | 6033 | 2673 | 32 |
959586 | 959586 | 2021-01-24 | Lassen | California | 6035 | 5269 | 16 |
959587 | 959587 | 2021-01-24 | Los Angeles | California | 6037 | 1073533 | 15260 |
959588 | 959588 | 2021-01-24 | Madera | California | 6039 | 13858 | 151 |
959589 | 959589 | 2021-01-24 | Marin | California | 6041 | 11953 | 163 |
959590 | 959590 | 2021-01-24 | Mariposa | California | 6043 | 351 | 4 |
959591 | 959591 | 2021-01-24 | Mendocino | California | 6045 | 3277 | 36 |
959592 | 959592 | 2021-01-24 | Merced | California | 6047 | 25048 | 324 |
959593 | 959593 | 2021-01-24 | Modoc | California | 6049 | 385 | 3 |
959594 | 959594 | 2021-01-24 | Mono | California | 6051 | 1111 | 4 |
959595 | 959595 | 2021-01-24 | Monterey | California | 6053 | 37285 | 259 |
959596 | 959596 | 2021-01-24 | Napa | California | 6055 | 7894 | 47 |
959597 | 959597 | 2021-01-24 | Nevada | California | 6057 | 3332 | 74 |
959598 | 959598 | 2021-01-24 | Orange | California | 6059 | 236312 | 2638 |
959599 | 959599 | 2021-01-24 | Placer | California | 6061 | 17675 | 188 |
959600 | 959600 | 2021-01-24 | Plumas | California | 6063 | 528 | 5 |
959601 | 959601 | 2021-01-24 | Riverside | California | 6065 | 258352 | 2777 |
959602 | 959602 | 2021-01-24 | Sacramento | California | 6067 | 83407 | 1157 |
959603 | 959603 | 2021-01-24 | San Benito | California | 6069 | 5166 | 48 |
959604 | 959604 | 2021-01-24 | San Bernardino | California | 6071 | 264457 | 1667 |
959605 | 959605 | 2021-01-24 | San Diego | California | 6073 | 227258 | 2375 |
959606 | 959606 | 2021-01-24 | San Francisco | California | 6075 | 30311 | 293 |
959607 | 959607 | 2021-01-24 | San Joaquin | California | 6077 | 59395 | 808 |
959608 | 959608 | 2021-01-24 | San Luis Obispo | California | 6079 | 16652 | 151 |
959609 | 959609 | 2021-01-24 | San Mateo | California | 6081 | 33731 | 340 |
959610 | 959610 | 2021-01-24 | Santa Barbara | California | 6083 | 26820 | 265 |
959611 | 959611 | 2021-01-24 | Santa Clara | California | 6085 | 98057 | 1235 |
959612 | 959612 | 2021-01-24 | Santa Cruz | California | 6087 | 12771 | 130 |
959613 | 959613 | 2021-01-24 | Shasta | California | 6089 | 9951 | 129 |
959614 | 959614 | 2021-01-24 | Sierra | California | 6091 | 41 | 0 |
959615 | 959615 | 2021-01-24 | Siskiyou | California | 6093 | 1484 | 13 |
959616 | 959616 | 2021-01-24 | Solano | California | 6095 | 26499 | 111 |
959617 | 959617 | 2021-01-24 | Sonoma | California | 6097 | 24935 | 247 |
959618 | 959618 | 2021-01-24 | Stanislaus | California | 6099 | 48753 | 788 |
959619 | 959619 | 2021-01-24 | Sutter | California | 6101 | 7943 | 83 |
959620 | 959620 | 2021-01-24 | Tehama | California | 6103 | 4006 | 46 |
959621 | 959621 | 2021-01-24 | Trinity | California | 6105 | 263 | 4 |
959622 | 959622 | 2021-01-24 | Tulare | California | 6107 | 42759 | 531 |
959623 | 959623 | 2021-01-24 | Tuolumne | California | 6109 | 3443 | 40 |
959624 | 959624 | 2021-01-24 | Ventura | California | 6111 | 65581 | 507 |
959625 | 959625 | 2021-01-24 | Yolo | California | 6113 | 11087 | 138 |
959626 | 959626 | 2021-01-24 | Yuba | California | 6115 | 5049 | 29 |
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);