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-07-09 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315725 | 315725 | 2020-07-09 | Alameda | California | 6001 | 7428 | 146 |
315726 | 315726 | 2020-07-09 | Alpine | California | 6003 | 1 | 0 |
315727 | 315727 | 2020-07-09 | Amador | California | 6005 | 34 | 0 |
315728 | 315728 | 2020-07-09 | Butte | California | 6007 | 319 | 4 |
315729 | 315729 | 2020-07-09 | Calaveras | California | 6009 | 61 | 0 |
315730 | 315730 | 2020-07-09 | Colusa | California | 6011 | 103 | 0 |
315731 | 315731 | 2020-07-09 | Contra Costa | California | 6013 | 4357 | 88 |
315732 | 315732 | 2020-07-09 | Del Norte | California | 6015 | 58 | 0 |
315733 | 315733 | 2020-07-09 | El Dorado | California | 6017 | 292 | 0 |
315734 | 315734 | 2020-07-09 | Fresno | California | 6019 | 7627 | 87 |
315735 | 315735 | 2020-07-09 | Glenn | California | 6021 | 146 | 0 |
315736 | 315736 | 2020-07-09 | Humboldt | California | 6023 | 162 | 4 |
315737 | 315737 | 2020-07-09 | Imperial | California | 6025 | 7654 | 126 |
315738 | 315738 | 2020-07-09 | Inyo | California | 6027 | 35 | 1 |
315739 | 315739 | 2020-07-09 | Kern | California | 6029 | 5989 | 89 |
315740 | 315740 | 2020-07-09 | Kings | California | 6031 | 2855 | 39 |
315741 | 315741 | 2020-07-09 | Lake | California | 6033 | 101 | 1 |
315742 | 315742 | 2020-07-09 | Lassen | California | 6035 | 261 | 0 |
315743 | 315743 | 2020-07-09 | Los Angeles | California | 6037 | 124738 | 3689 |
315744 | 315744 | 2020-07-09 | Madera | California | 6039 | 857 | 8 |
315745 | 315745 | 2020-07-09 | Marin | California | 6041 | 2965 | 23 |
315746 | 315746 | 2020-07-09 | Mariposa | California | 6043 | 31 | 1 |
315747 | 315747 | 2020-07-09 | Mendocino | California | 6045 | 107 | 0 |
315748 | 315748 | 2020-07-09 | Merced | California | 6047 | 1793 | 12 |
315749 | 315749 | 2020-07-09 | Mono | California | 6051 | 49 | 1 |
315750 | 315750 | 2020-07-09 | Monterey | California | 6053 | 2343 | 17 |
315751 | 315751 | 2020-07-09 | Napa | California | 6055 | 469 | 4 |
315752 | 315752 | 2020-07-09 | Nevada | California | 6057 | 159 | 1 |
315753 | 315753 | 2020-07-09 | Orange | California | 6059 | 22088 | 376 |
315754 | 315754 | 2020-07-09 | Placer | California | 6061 | 993 | 11 |
315755 | 315755 | 2020-07-09 | Plumas | California | 6063 | 12 | 0 |
315756 | 315756 | 2020-07-09 | Riverside | California | 6065 | 24042 | 533 |
315757 | 315757 | 2020-07-09 | Sacramento | California | 6067 | 4931 | 78 |
315758 | 315758 | 2020-07-09 | San Benito | California | 6069 | 311 | 2 |
315759 | 315759 | 2020-07-09 | San Bernardino | California | 6071 | 17414 | 304 |
315760 | 315760 | 2020-07-09 | San Diego | California | 6073 | 18465 | 415 |
315761 | 315761 | 2020-07-09 | San Francisco | California | 6075 | 4148 | 50 |
315762 | 315762 | 2020-07-09 | San Joaquin | California | 6077 | 6065 | 67 |
315763 | 315763 | 2020-07-09 | San Luis Obispo | California | 6079 | 877 | 4 |
315764 | 315764 | 2020-07-09 | San Mateo | California | 6081 | 3787 | 111 |
315765 | 315765 | 2020-07-09 | Santa Barbara | California | 6083 | 3985 | 29 |
315766 | 315766 | 2020-07-09 | Santa Clara | California | 6085 | 5678 | 167 |
315767 | 315767 | 2020-07-09 | Santa Cruz | California | 6087 | 509 | 3 |
315768 | 315768 | 2020-07-09 | Shasta | California | 6089 | 176 | 6 |
315769 | 315769 | 2020-07-09 | Sierra | California | 6091 | 1 | 0 |
315770 | 315770 | 2020-07-09 | Siskiyou | California | 6093 | 33 | 0 |
315771 | 315771 | 2020-07-09 | Solano | California | 6095 | 1990 | 27 |
315772 | 315772 | 2020-07-09 | Sonoma | California | 6097 | 1561 | 14 |
315773 | 315773 | 2020-07-09 | Stanislaus | California | 6099 | 4344 | 50 |
315774 | 315774 | 2020-07-09 | Sutter | California | 6101 | 337 | 4 |
315775 | 315775 | 2020-07-09 | Tehama | California | 6103 | 100 | 1 |
315776 | 315776 | 2020-07-09 | Trinity | California | 6105 | 3 | 0 |
315777 | 315777 | 2020-07-09 | Tulare | California | 6107 | 5509 | 148 |
315778 | 315778 | 2020-07-09 | Tuolumne | California | 6109 | 59 | 0 |
315779 | 315779 | 2020-07-09 | Ventura | California | 6111 | 4139 | 53 |
315780 | 315780 | 2020-07-09 | Yolo | California | 6113 | 802 | 28 |
315781 | 315781 | 2020-07-09 | Yuba | California | 6115 | 163 | 3 |
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);