ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-08-30" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
482859 | 482859 | 2020-08-30 | Alameda | California | 6001 | 18061 | 258 |
482860 | 482860 | 2020-08-30 | Alpine | California | 6003 | 2 | 0 |
482861 | 482861 | 2020-08-30 | Amador | California | 6005 | 238 | 14 |
482862 | 482862 | 2020-08-30 | Butte | California | 6007 | 1948 | 23 |
482863 | 482863 | 2020-08-30 | Calaveras | California | 6009 | 236 | 2 |
482864 | 482864 | 2020-08-30 | Colusa | California | 6011 | 441 | 6 |
482865 | 482865 | 2020-08-30 | Contra Costa | California | 6013 | 13802 | 175 |
482866 | 482866 | 2020-08-30 | Del Norte | California | 6015 | 122 | 1 |
482867 | 482867 | 2020-08-30 | El Dorado | California | 6017 | 958 | 2 |
482868 | 482868 | 2020-08-30 | Fresno | California | 6019 | 24821 | 263 |
482869 | 482869 | 2020-08-30 | Glenn | California | 6021 | 437 | 3 |
482870 | 482870 | 2020-08-30 | Humboldt | California | 6023 | 368 | 4 |
482871 | 482871 | 2020-08-30 | Imperial | California | 6025 | 10667 | 292 |
482872 | 482872 | 2020-08-30 | Inyo | California | 6027 | 160 | 13 |
482873 | 482873 | 2020-08-30 | Kern | California | 6029 | 29230 | 286 |
482874 | 482874 | 2020-08-30 | Kings | California | 6031 | 6284 | 72 |
482875 | 482875 | 2020-08-30 | Lake | California | 6033 | 329 | 4 |
482876 | 482876 | 2020-08-30 | Lassen | California | 6035 | 715 | 0 |
482877 | 482877 | 2020-08-30 | Los Angeles | California | 6037 | 240749 | 5769 |
482878 | 482878 | 2020-08-30 | Madera | California | 6039 | 3674 | 54 |
482879 | 482879 | 2020-08-30 | Marin | California | 6041 | 6143 | 95 |
482880 | 482880 | 2020-08-30 | Mariposa | California | 6043 | 73 | 2 |
482881 | 482881 | 2020-08-30 | Mendocino | California | 6045 | 696 | 17 |
482882 | 482882 | 2020-08-30 | Merced | California | 6047 | 7890 | 115 |
482883 | 482883 | 2020-08-30 | Modoc | California | 6049 | 9 | 0 |
482884 | 482884 | 2020-08-30 | Mono | California | 6051 | 162 | 2 |
482885 | 482885 | 2020-08-30 | Monterey | California | 6053 | 7850 | 56 |
482886 | 482886 | 2020-08-30 | Napa | California | 6055 | 1414 | 13 |
482887 | 482887 | 2020-08-30 | Nevada | California | 6057 | 442 | 5 |
482888 | 482888 | 2020-08-30 | Orange | California | 6059 | 48444 | 979 |
482889 | 482889 | 2020-08-30 | Placer | California | 6061 | 2973 | 32 |
482890 | 482890 | 2020-08-30 | Plumas | California | 6063 | 39 | 0 |
482891 | 482891 | 2020-08-30 | Riverside | California | 6065 | 51918 | 1007 |
482892 | 482892 | 2020-08-30 | Sacramento | California | 6067 | 17587 | 274 |
482893 | 482893 | 2020-08-30 | San Benito | California | 6069 | 1090 | 8 |
482894 | 482894 | 2020-08-30 | San Bernardino | California | 6071 | 47373 | 716 |
482895 | 482895 | 2020-08-30 | San Diego | California | 6073 | 38363 | 682 |
482896 | 482896 | 2020-08-30 | San Francisco | California | 6075 | 9431 | 83 |
482897 | 482897 | 2020-08-30 | San Joaquin | California | 6077 | 17493 | 307 |
482898 | 482898 | 2020-08-30 | San Luis Obispo | California | 6079 | 2917 | 21 |
482899 | 482899 | 2020-08-30 | San Mateo | California | 6081 | 8074 | 131 |
482900 | 482900 | 2020-08-30 | Santa Barbara | California | 6083 | 8052 | 92 |
482901 | 482901 | 2020-08-30 | Santa Clara | California | 6085 | 17013 | 245 |
482902 | 482902 | 2020-08-30 | Santa Cruz | California | 6087 | 1746 | 7 |
482903 | 482903 | 2020-08-30 | Shasta | California | 6089 | 562 | 12 |
482904 | 482904 | 2020-08-30 | Sierra | California | 6091 | 6 | 0 |
482905 | 482905 | 2020-08-30 | Siskiyou | California | 6093 | 128 | 0 |
482906 | 482906 | 2020-08-30 | Solano | California | 6095 | 5393 | 46 |
482907 | 482907 | 2020-08-30 | Sonoma | California | 6097 | 5654 | 78 |
482908 | 482908 | 2020-08-30 | Stanislaus | California | 6099 | 14544 | 255 |
482909 | 482909 | 2020-08-30 | Sutter | California | 6101 | 1368 | 10 |
482910 | 482910 | 2020-08-30 | Tehama | California | 6103 | 417 | 1 |
482911 | 482911 | 2020-08-30 | Trinity | California | 6105 | 12 | 0 |
482912 | 482912 | 2020-08-30 | Tulare | California | 6107 | 13890 | 232 |
482913 | 482913 | 2020-08-30 | Tuolumne | California | 6109 | 181 | 2 |
482914 | 482914 | 2020-08-30 | Ventura | California | 6111 | 10705 | 115 |
482915 | 482915 | 2020-08-30 | Yolo | California | 6113 | 2386 | 52 |
482916 | 482916 | 2020-08-30 | 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);