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 2021-01-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 |
---|---|---|---|---|---|---|---|
910889 | 910889 | 2021-01-09 | Alameda | California | 6001 | 59193 | 732 |
910890 | 910890 | 2021-01-09 | Alpine | California | 6003 | 70 | 0 |
910891 | 910891 | 2021-01-09 | Amador | California | 6005 | 2791 | 26 |
910892 | 910892 | 2021-01-09 | Butte | California | 6007 | 8430 | 111 |
910893 | 910893 | 2021-01-09 | Calaveras | California | 6009 | 1385 | 22 |
910894 | 910894 | 2021-01-09 | Colusa | California | 6011 | 1565 | 9 |
910895 | 910895 | 2021-01-09 | Contra Costa | California | 6013 | 46618 | 389 |
910896 | 910896 | 2021-01-09 | Del Norte | California | 6015 | 816 | 2 |
910897 | 910897 | 2021-01-09 | El Dorado | California | 6017 | 6690 | 33 |
910898 | 910898 | 2021-01-09 | Fresno | California | 6019 | 73689 | 711 |
910899 | 910899 | 2021-01-09 | Glenn | California | 6021 | 1954 | 18 |
910900 | 910900 | 2021-01-09 | Humboldt | California | 6023 | 2031 | 23 |
910901 | 910901 | 2021-01-09 | Imperial | California | 6025 | 23751 | 445 |
910902 | 910902 | 2021-01-09 | Inyo | California | 6027 | 682 | 27 |
910903 | 910903 | 2021-01-09 | Kern | California | 6029 | 77875 | 542 |
910904 | 910904 | 2021-01-09 | Kings | California | 6031 | 17711 | 110 |
910905 | 910905 | 2021-01-09 | Lake | California | 6033 | 2098 | 26 |
910906 | 910906 | 2021-01-09 | Lassen | California | 6035 | 4972 | 11 |
910907 | 910907 | 2021-01-09 | Los Angeles | California | 6037 | 906554 | 12084 |
910908 | 910908 | 2021-01-09 | Madera | California | 6039 | 11846 | 126 |
910909 | 910909 | 2021-01-09 | Marin | California | 6041 | 10696 | 143 |
910910 | 910910 | 2021-01-09 | Mariposa | California | 6043 | 318 | 4 |
910911 | 910911 | 2021-01-09 | Mendocino | California | 6045 | 2886 | 31 |
910912 | 910912 | 2021-01-09 | Merced | California | 6047 | 21506 | 279 |
910913 | 910913 | 2021-01-09 | Modoc | California | 6049 | 357 | 3 |
910914 | 910914 | 2021-01-09 | Mono | California | 6051 | 951 | 4 |
910915 | 910915 | 2021-01-09 | Monterey | California | 6053 | 32394 | 242 |
910916 | 910916 | 2021-01-09 | Napa | California | 6055 | 6545 | 36 |
910917 | 910917 | 2021-01-09 | Nevada | California | 6057 | 2888 | 50 |
910918 | 910918 | 2021-01-09 | Orange | California | 6059 | 196024 | 2041 |
910919 | 910919 | 2021-01-09 | Placer | California | 6061 | 15454 | 159 |
910920 | 910920 | 2021-01-09 | Plumas | California | 6063 | 465 | 5 |
910921 | 910921 | 2021-01-09 | Riverside | California | 6065 | 212122 | 2218 |
910922 | 910922 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
910923 | 910923 | 2021-01-09 | San Benito | California | 6069 | 4363 | 36 |
910924 | 910924 | 2021-01-09 | San Bernardino | California | 6071 | 224350 | 1520 |
910925 | 910925 | 2021-01-09 | San Diego | California | 6073 | 188663 | 1824 |
910926 | 910926 | 2021-01-09 | San Francisco | California | 6075 | 26381 | 233 |
910927 | 910927 | 2021-01-09 | San Joaquin | California | 6077 | 51523 | 712 |
910928 | 910928 | 2021-01-09 | San Luis Obispo | California | 6079 | 13286 | 101 |
910929 | 910929 | 2021-01-09 | San Mateo | California | 6081 | 28072 | 255 |
910930 | 910930 | 2021-01-09 | Santa Barbara | California | 6083 | 20550 | 197 |
910931 | 910931 | 2021-01-09 | Santa Clara | California | 6085 | 82170 | 884 |
910932 | 910932 | 2021-01-09 | Santa Cruz | California | 6087 | 10486 | 104 |
910933 | 910933 | 2021-01-09 | Shasta | California | 6089 | 8917 | 99 |
910934 | 910934 | 2021-01-09 | Sierra | California | 6091 | 31 | 0 |
910935 | 910935 | 2021-01-09 | Siskiyou | California | 6093 | 1311 | 12 |
910936 | 910936 | 2021-01-09 | Solano | California | 6095 | 22237 | 102 |
910937 | 910937 | 2021-01-09 | Sonoma | California | 6097 | 21264 | 218 |
910938 | 910938 | 2021-01-09 | Stanislaus | California | 6099 | 42093 | 675 |
910939 | 910939 | 2021-01-09 | Sutter | California | 6101 | 7018 | 70 |
910940 | 910940 | 2021-01-09 | Tehama | California | 6103 | 3406 | 40 |
910941 | 910941 | 2021-01-09 | Trinity | California | 6105 | 248 | 4 |
910942 | 910942 | 2021-01-09 | Tulare | California | 6107 | 36946 | 455 |
910943 | 910943 | 2021-01-09 | Tuolumne | California | 6109 | 3180 | 33 |
910944 | 910944 | 2021-01-09 | Ventura | California | 6111 | 50553 | 334 |
910945 | 910945 | 2021-01-09 | Yolo | California | 6113 | 9391 | 127 |
910946 | 910946 | 2021-01-09 | Yuba | California | 6115 | 4440 | 25 |
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);