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-07 and state = "California" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
408645 | 408645 | 2020-08-07 | Alameda | California | 6001 | 12161 | 193 |
408646 | 408646 | 2020-08-07 | Alpine | California | 6003 | 2 | 0 |
408647 | 408647 | 2020-08-07 | Amador | California | 6005 | 162 | 2 |
408648 | 408648 | 2020-08-07 | Butte | California | 6007 | 1095 | 8 |
408649 | 408649 | 2020-08-07 | Calaveras | California | 6009 | 136 | 1 |
408650 | 408650 | 2020-08-07 | Colusa | California | 6011 | 362 | 4 |
408651 | 408651 | 2020-08-07 | Contra Costa | California | 6013 | 8760 | 136 |
408652 | 408652 | 2020-08-07 | Del Norte | California | 6015 | 99 | 0 |
408653 | 408653 | 2020-08-07 | El Dorado | California | 6017 | 729 | 1 |
408654 | 408654 | 2020-08-07 | Fresno | California | 6019 | 16641 | 171 |
408655 | 408655 | 2020-08-07 | Glenn | California | 6021 | 330 | 3 |
408656 | 408656 | 2020-08-07 | Humboldt | California | 6023 | 282 | 4 |
408657 | 408657 | 2020-08-07 | Imperial | California | 6025 | 9629 | 241 |
408658 | 408658 | 2020-08-07 | Inyo | California | 6027 | 62 | 1 |
408659 | 408659 | 2020-08-07 | Kern | California | 6029 | 22009 | 160 |
408660 | 408660 | 2020-08-07 | Kings | California | 6031 | 4453 | 56 |
408661 | 408661 | 2020-08-07 | Lake | California | 6033 | 209 | 2 |
408662 | 408662 | 2020-08-07 | Lassen | California | 6035 | 638 | 0 |
408663 | 408663 | 2020-08-07 | Los Angeles | California | 6037 | 204167 | 4918 |
408664 | 408664 | 2020-08-07 | Madera | California | 6039 | 2302 | 39 |
408665 | 408665 | 2020-08-07 | Marin | California | 6041 | 5286 | 77 |
408666 | 408666 | 2020-08-07 | Mariposa | California | 6043 | 60 | 2 |
408667 | 408667 | 2020-08-07 | Mendocino | California | 6045 | 380 | 10 |
408668 | 408668 | 2020-08-07 | Merced | California | 6047 | 5012 | 64 |
408669 | 408669 | 2020-08-07 | Modoc | California | 6049 | 5 | 0 |
408670 | 408670 | 2020-08-07 | Mono | California | 6051 | 153 | 1 |
408671 | 408671 | 2020-08-07 | Monterey | California | 6053 | 5156 | 35 |
408672 | 408672 | 2020-08-07 | Napa | California | 6055 | 1047 | 9 |
408673 | 408673 | 2020-08-07 | Nevada | California | 6057 | 327 | 1 |
408674 | 408674 | 2020-08-07 | Orange | California | 6059 | 38754 | 704 |
408675 | 408675 | 2020-08-07 | Placer | California | 6061 | 2099 | 20 |
408676 | 408676 | 2020-08-07 | Plumas | California | 6063 | 25 | 0 |
408677 | 408677 | 2020-08-07 | Riverside | California | 6065 | 40452 | 799 |
408678 | 408678 | 2020-08-07 | Sacramento | California | 6067 | 10794 | 161 |
408679 | 408679 | 2020-08-07 | San Benito | California | 6069 | 709 | 4 |
408680 | 408680 | 2020-08-07 | San Bernardino | California | 6071 | 34939 | 497 |
408681 | 408681 | 2020-08-07 | San Diego | California | 6073 | 31842 | 586 |
408682 | 408682 | 2020-08-07 | San Francisco | California | 6075 | 7329 | 64 |
408683 | 408683 | 2020-08-07 | San Joaquin | California | 6077 | 12303 | 211 |
408684 | 408684 | 2020-08-07 | San Luis Obispo | California | 6079 | 2093 | 16 |
408685 | 408685 | 2020-08-07 | San Mateo | California | 6081 | 5978 | 120 |
408686 | 408686 | 2020-08-07 | Santa Barbara | California | 6083 | 6704 | 69 |
408687 | 408687 | 2020-08-07 | Santa Clara | California | 6085 | 11475 | 204 |
408688 | 408688 | 2020-08-07 | Santa Cruz | California | 6087 | 1229 | 4 |
408689 | 408689 | 2020-08-07 | Shasta | California | 6089 | 411 | 9 |
408690 | 408690 | 2020-08-07 | Sierra | California | 6091 | 3 | 0 |
408691 | 408691 | 2020-08-07 | Siskiyou | California | 6093 | 93 | 0 |
408692 | 408692 | 2020-08-07 | Solano | California | 6095 | 4034 | 40 |
408693 | 408693 | 2020-08-07 | Sonoma | California | 6097 | 3431 | 47 |
408694 | 408694 | 2020-08-07 | Stanislaus | California | 6099 | 9566 | 161 |
408695 | 408695 | 2020-08-07 | Sutter | California | 6101 | 921 | 7 |
408696 | 408696 | 2020-08-07 | Tehama | California | 6103 | 231 | 1 |
408697 | 408697 | 2020-08-07 | Trinity | California | 6105 | 6 | 0 |
408698 | 408698 | 2020-08-07 | Tulare | California | 6107 | 10475 | 196 |
408699 | 408699 | 2020-08-07 | Tuolumne | California | 6109 | 152 | 2 |
408700 | 408700 | 2020-08-07 | Ventura | California | 6111 | 8162 | 89 |
408701 | 408701 | 2020-08-07 | Yolo | California | 6113 | 1690 | 43 |
408702 | 408702 | 2020-08-07 | Yuba | California | 6115 | 588 | 4 |
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);