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-12-28 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
871944 | 871944 | 2020-12-28 | Alameda | California | 6001 | 49817 | 625 |
871945 | 871945 | 2020-12-28 | Alpine | California | 6003 | 65 | 0 |
871946 | 871946 | 2020-12-28 | Amador | California | 6005 | 2217 | 23 |
871947 | 871947 | 2020-12-28 | Butte | California | 6007 | 7051 | 88 |
871948 | 871948 | 2020-12-28 | Calaveras | California | 6009 | 1097 | 22 |
871949 | 871949 | 2020-12-28 | Colusa | California | 6011 | 1264 | 8 |
871950 | 871950 | 2020-12-28 | Contra Costa | California | 6013 | 39029 | 323 |
871951 | 871951 | 2020-12-28 | Del Norte | California | 6015 | 729 | 2 |
871952 | 871952 | 2020-12-28 | El Dorado | California | 6017 | 5388 | 13 |
871953 | 871953 | 2020-12-28 | Fresno | California | 6019 | 63811 | 646 |
871954 | 871954 | 2020-12-28 | Glenn | California | 6021 | 1434 | 14 |
871955 | 871955 | 2020-12-28 | Humboldt | California | 6023 | 1647 | 20 |
871956 | 871956 | 2020-12-28 | Imperial | California | 6025 | 21934 | 405 |
871957 | 871957 | 2020-12-28 | Inyo | California | 6027 | 565 | 20 |
871958 | 871958 | 2020-12-28 | Kern | California | 6029 | 66526 | 502 |
871959 | 871959 | 2020-12-28 | Kings | California | 6031 | 15767 | 110 |
871960 | 871960 | 2020-12-28 | Lake | California | 6033 | 1769 | 23 |
871961 | 871961 | 2020-12-28 | Lassen | California | 6035 | 4573 | 8 |
871962 | 871962 | 2020-12-28 | Los Angeles | California | 6037 | 733612 | 9555 |
871963 | 871963 | 2020-12-28 | Madera | California | 6039 | 10015 | 116 |
871964 | 871964 | 2020-12-28 | Marin | California | 6041 | 9616 | 138 |
871965 | 871965 | 2020-12-28 | Mariposa | California | 6043 | 223 | 4 |
871966 | 871966 | 2020-12-28 | Mendocino | California | 6045 | 2425 | 26 |
871967 | 871967 | 2020-12-28 | Merced | California | 6047 | 18843 | 248 |
871968 | 871968 | 2020-12-28 | Modoc | California | 6049 | 292 | 0 |
871969 | 871969 | 2020-12-28 | Mono | California | 6051 | 849 | 4 |
871970 | 871970 | 2020-12-28 | Monterey | California | 6053 | 26723 | 189 |
871971 | 871971 | 2020-12-28 | Napa | California | 6055 | 5497 | 27 |
871972 | 871972 | 2020-12-28 | Nevada | California | 6057 | 2519 | 49 |
871973 | 871973 | 2020-12-28 | Orange | California | 6059 | 157926 | 1846 |
871974 | 871974 | 2020-12-28 | Placer | California | 6061 | 13055 | 125 |
871975 | 871975 | 2020-12-28 | Plumas | California | 6063 | 390 | 1 |
871976 | 871976 | 2020-12-28 | Riverside | California | 6065 | 174477 | 1870 |
871977 | 871977 | 2020-12-28 | Sacramento | California | 6067 | 63415 | 827 |
871978 | 871978 | 2020-12-28 | San Benito | California | 6069 | 3431 | 28 |
871979 | 871979 | 2020-12-28 | San Bernardino | California | 6071 | 186776 | 1437 |
871980 | 871980 | 2020-12-28 | San Diego | California | 6073 | 147593 | 1404 |
871981 | 871981 | 2020-12-28 | San Francisco | California | 6075 | 22517 | 182 |
871982 | 871982 | 2020-12-28 | San Joaquin | California | 6077 | 43930 | 625 |
871983 | 871983 | 2020-12-28 | San Luis Obispo | California | 6079 | 10154 | 70 |
871984 | 871984 | 2020-12-28 | San Mateo | California | 6081 | 23681 | 212 |
871985 | 871985 | 2020-12-28 | Santa Barbara | California | 6083 | 16476 | 153 |
871986 | 871986 | 2020-12-28 | Santa Clara | California | 6085 | 66270 | 653 |
871987 | 871987 | 2020-12-28 | Santa Cruz | California | 6087 | 8234 | 83 |
871988 | 871988 | 2020-12-28 | Shasta | California | 6089 | 7792 | 70 |
871989 | 871989 | 2020-12-28 | Sierra | California | 6091 | 24 | 0 |
871990 | 871990 | 2020-12-28 | Siskiyou | California | 6093 | 1111 | 9 |
871991 | 871991 | 2020-12-28 | Solano | California | 6095 | 18523 | 95 |
871992 | 871992 | 2020-12-28 | Sonoma | California | 6097 | 18649 | 182 |
871993 | 871993 | 2020-12-28 | Stanislaus | California | 6099 | 36529 | 586 |
871994 | 871994 | 2020-12-28 | Sutter | California | 6101 | 6290 | 49 |
871995 | 871995 | 2020-12-28 | Tehama | California | 6103 | 2922 | 34 |
871996 | 871996 | 2020-12-28 | Trinity | California | 6105 | 241 | 2 |
871997 | 871997 | 2020-12-28 | Tulare | California | 6107 | 32109 | 386 |
871998 | 871998 | 2020-12-28 | Tuolumne | California | 6109 | 2827 | 21 |
871999 | 871999 | 2020-12-28 | Ventura | California | 6111 | 36661 | 244 |
872000 | 872000 | 2020-12-28 | Yolo | California | 6113 | 7919 | 109 |
872001 | 872001 | 2020-12-28 | Yuba | California | 6115 | 3805 | 18 |
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);