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-10-07 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
605884 | 605884 | 2020-10-07 | Alameda | California | 6001 | 21866 | 440 |
605885 | 605885 | 2020-10-07 | Alpine | California | 6003 | 3 | 0 |
605886 | 605886 | 2020-10-07 | Amador | California | 6005 | 300 | 16 |
605887 | 605887 | 2020-10-07 | Butte | California | 6007 | 2925 | 45 |
605888 | 605888 | 2020-10-07 | Calaveras | California | 6009 | 329 | 14 |
605889 | 605889 | 2020-10-07 | Colusa | California | 6011 | 541 | 6 |
605890 | 605890 | 2020-10-07 | Contra Costa | California | 6013 | 17322 | 218 |
605891 | 605891 | 2020-10-07 | Del Norte | California | 6015 | 160 | 1 |
605892 | 605892 | 2020-10-07 | El Dorado | California | 6017 | 1211 | 4 |
605893 | 605893 | 2020-10-07 | Fresno | California | 6019 | 29022 | 406 |
605894 | 605894 | 2020-10-07 | Glenn | California | 6021 | 604 | 3 |
605895 | 605895 | 2020-10-07 | Humboldt | California | 6023 | 527 | 8 |
605896 | 605896 | 2020-10-07 | Imperial | California | 6025 | 12120 | 326 |
605897 | 605897 | 2020-10-07 | Inyo | California | 6027 | 198 | 15 |
605898 | 605898 | 2020-10-07 | Kern | California | 6029 | 32674 | 387 |
605899 | 605899 | 2020-10-07 | Kings | California | 6031 | 7943 | 82 |
605900 | 605900 | 2020-10-07 | Lake | California | 6033 | 596 | 12 |
605901 | 605901 | 2020-10-07 | Lassen | California | 6035 | 748 | 0 |
605902 | 605902 | 2020-10-07 | Los Angeles | California | 6037 | 277445 | 6709 |
605903 | 605903 | 2020-10-07 | Madera | California | 6039 | 4706 | 70 |
605904 | 605904 | 2020-10-07 | Marin | California | 6041 | 6831 | 123 |
605905 | 605905 | 2020-10-07 | Mariposa | California | 6043 | 77 | 2 |
605906 | 605906 | 2020-10-07 | Mendocino | California | 6045 | 1025 | 21 |
605907 | 605907 | 2020-10-07 | Merced | California | 6047 | 9111 | 149 |
605908 | 605908 | 2020-10-07 | Modoc | California | 6049 | 28 | 0 |
605909 | 605909 | 2020-10-07 | Mono | California | 6051 | 169 | 2 |
605910 | 605910 | 2020-10-07 | Monterey | California | 6053 | 10475 | 78 |
605911 | 605911 | 2020-10-07 | Napa | California | 6055 | 1771 | 13 |
605912 | 605912 | 2020-10-07 | Nevada | California | 6057 | 554 | 7 |
605913 | 605913 | 2020-10-07 | Orange | California | 6059 | 56652 | 1292 |
605914 | 605914 | 2020-10-07 | Placer | California | 6061 | 3710 | 51 |
605915 | 605915 | 2020-10-07 | Plumas | California | 6063 | 49 | 0 |
605916 | 605916 | 2020-10-07 | Riverside | California | 6065 | 61133 | 1247 |
605917 | 605917 | 2020-10-07 | Sacramento | California | 6067 | 23419 | 445 |
605918 | 605918 | 2020-10-07 | San Benito | California | 6069 | 1372 | 13 |
605919 | 605919 | 2020-10-07 | San Bernardino | California | 6071 | 56823 | 967 |
605920 | 605920 | 2020-10-07 | San Diego | California | 6073 | 49238 | 813 |
605921 | 605921 | 2020-10-07 | San Francisco | California | 6075 | 11536 | 114 |
605922 | 605922 | 2020-10-07 | San Joaquin | California | 6077 | 20779 | 473 |
605923 | 605923 | 2020-10-07 | San Luis Obispo | California | 6079 | 3779 | 31 |
605924 | 605924 | 2020-10-07 | San Mateo | California | 6081 | 10347 | 154 |
605925 | 605925 | 2020-10-07 | Santa Barbara | California | 6083 | 9363 | 115 |
605926 | 605926 | 2020-10-07 | Santa Clara | California | 6085 | 22056 | 354 |
605927 | 605927 | 2020-10-07 | Santa Cruz | California | 6087 | 2535 | 18 |
605928 | 605928 | 2020-10-07 | Shasta | California | 6089 | 1242 | 22 |
605929 | 605929 | 2020-10-07 | Sierra | California | 6091 | 6 | 0 |
605930 | 605930 | 2020-10-07 | Siskiyou | California | 6093 | 172 | 0 |
605931 | 605931 | 2020-10-07 | Solano | California | 6095 | 6663 | 74 |
605932 | 605932 | 2020-10-07 | Sonoma | California | 6097 | 8083 | 126 |
605933 | 605933 | 2020-10-07 | Stanislaus | California | 6099 | 16804 | 379 |
605934 | 605934 | 2020-10-07 | Sutter | California | 6101 | 1770 | 12 |
605935 | 605935 | 2020-10-07 | Tehama | California | 6103 | 660 | 7 |
605936 | 605936 | 2020-10-07 | Trinity | California | 6105 | 26 | 0 |
605937 | 605937 | 2020-10-07 | Tulare | California | 6107 | 16634 | 267 |
605938 | 605938 | 2020-10-07 | Tuolumne | California | 6109 | 234 | 4 |
605939 | 605939 | 2020-10-07 | Ventura | California | 6111 | 13242 | 157 |
605940 | 605940 | 2020-10-07 | Yolo | California | 6113 | 2909 | 56 |
605941 | 605941 | 2020-10-07 | Yuba | California | 6115 | 1217 | 10 |
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);