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 2020-08-29 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
479625 | 479625 | 2020-08-29 | Alameda | California | 6001 | 17868 | 247 |
479626 | 479626 | 2020-08-29 | Alpine | California | 6003 | 2 | 0 |
479627 | 479627 | 2020-08-29 | Amador | California | 6005 | 233 | 14 |
479628 | 479628 | 2020-08-29 | Butte | California | 6007 | 1886 | 23 |
479629 | 479629 | 2020-08-29 | Calaveras | California | 6009 | 236 | 2 |
479630 | 479630 | 2020-08-29 | Colusa | California | 6011 | 441 | 6 |
479631 | 479631 | 2020-08-29 | Contra Costa | California | 6013 | 13700 | 173 |
479632 | 479632 | 2020-08-29 | Del Norte | California | 6015 | 122 | 1 |
479633 | 479633 | 2020-08-29 | El Dorado | California | 6017 | 951 | 2 |
479634 | 479634 | 2020-08-29 | Fresno | California | 6019 | 24612 | 263 |
479635 | 479635 | 2020-08-29 | Glenn | California | 6021 | 429 | 3 |
479636 | 479636 | 2020-08-29 | Humboldt | California | 6023 | 368 | 4 |
479637 | 479637 | 2020-08-29 | Imperial | California | 6025 | 10667 | 292 |
479638 | 479638 | 2020-08-29 | Inyo | California | 6027 | 160 | 13 |
479639 | 479639 | 2020-08-29 | Kern | California | 6029 | 29105 | 286 |
479640 | 479640 | 2020-08-29 | Kings | California | 6031 | 6142 | 72 |
479641 | 479641 | 2020-08-29 | Lake | California | 6033 | 320 | 3 |
479642 | 479642 | 2020-08-29 | Lassen | California | 6035 | 715 | 0 |
479643 | 479643 | 2020-08-29 | Los Angeles | California | 6037 | 239756 | 5759 |
479644 | 479644 | 2020-08-29 | Madera | California | 6039 | 3674 | 54 |
479645 | 479645 | 2020-08-29 | Marin | California | 6041 | 6118 | 94 |
479646 | 479646 | 2020-08-29 | Mariposa | California | 6043 | 73 | 2 |
479647 | 479647 | 2020-08-29 | Mendocino | California | 6045 | 689 | 17 |
479648 | 479648 | 2020-08-29 | Merced | California | 6047 | 7890 | 115 |
479649 | 479649 | 2020-08-29 | Modoc | California | 6049 | 7 | 0 |
479650 | 479650 | 2020-08-29 | Mono | California | 6051 | 162 | 2 |
479651 | 479651 | 2020-08-29 | Monterey | California | 6053 | 7685 | 55 |
479652 | 479652 | 2020-08-29 | Napa | California | 6055 | 1404 | 13 |
479653 | 479653 | 2020-08-29 | Nevada | California | 6057 | 438 | 5 |
479654 | 479654 | 2020-08-29 | Orange | California | 6059 | 48190 | 975 |
479655 | 479655 | 2020-08-29 | Placer | California | 6061 | 2947 | 32 |
479656 | 479656 | 2020-08-29 | Plumas | California | 6063 | 39 | 0 |
479657 | 479657 | 2020-08-29 | Riverside | California | 6065 | 51860 | 1007 |
479658 | 479658 | 2020-08-29 | Sacramento | California | 6067 | 17149 | 274 |
479659 | 479659 | 2020-08-29 | San Benito | California | 6069 | 1081 | 8 |
479660 | 479660 | 2020-08-29 | San Bernardino | California | 6071 | 47145 | 716 |
479661 | 479661 | 2020-08-29 | San Diego | California | 6073 | 38110 | 679 |
479662 | 479662 | 2020-08-29 | San Francisco | California | 6075 | 9352 | 83 |
479663 | 479663 | 2020-08-29 | San Joaquin | California | 6077 | 17114 | 307 |
479664 | 479664 | 2020-08-29 | San Luis Obispo | California | 6079 | 2882 | 21 |
479665 | 479665 | 2020-08-29 | San Mateo | California | 6081 | 8074 | 131 |
479666 | 479666 | 2020-08-29 | Santa Barbara | California | 6083 | 8014 | 92 |
479667 | 479667 | 2020-08-29 | Santa Clara | California | 6085 | 17013 | 246 |
479668 | 479668 | 2020-08-29 | Santa Cruz | California | 6087 | 1747 | 7 |
479669 | 479669 | 2020-08-29 | Shasta | California | 6089 | 562 | 12 |
479670 | 479670 | 2020-08-29 | Sierra | California | 6091 | 6 | 0 |
479671 | 479671 | 2020-08-29 | Siskiyou | California | 6093 | 128 | 0 |
479672 | 479672 | 2020-08-29 | Solano | California | 6095 | 5393 | 46 |
479673 | 479673 | 2020-08-29 | Sonoma | California | 6097 | 5654 | 78 |
479674 | 479674 | 2020-08-29 | Stanislaus | California | 6099 | 14482 | 255 |
479675 | 479675 | 2020-08-29 | Sutter | California | 6101 | 1368 | 10 |
479676 | 479676 | 2020-08-29 | Tehama | California | 6103 | 410 | 1 |
479677 | 479677 | 2020-08-29 | Trinity | California | 6105 | 12 | 0 |
479678 | 479678 | 2020-08-29 | Tulare | California | 6107 | 13884 | 232 |
479679 | 479679 | 2020-08-29 | Tuolumne | California | 6109 | 181 | 2 |
479680 | 479680 | 2020-08-29 | Ventura | California | 6111 | 10606 | 115 |
479681 | 479681 | 2020-08-29 | Yolo | California | 6113 | 2335 | 51 |
479682 | 479682 | 2020-08-29 | Yuba | California | 6115 | 909 | 6 |
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);