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-07-23 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1543921 | 1543921 | 2021-07-23 | Alameda | California | 6001 | 95482 | 1272 |
1543922 | 1543922 | 2021-07-23 | Alpine | California | 6003 | 89 | 0 |
1543923 | 1543923 | 2021-07-23 | Amador | California | 6005 | 3851 | 48 |
1543924 | 1543924 | 2021-07-23 | Butte | California | 6007 | 15024 | 203 |
1543925 | 1543925 | 2021-07-23 | Calaveras | California | 6009 | 2286 | 58 |
1543926 | 1543926 | 2021-07-23 | Colusa | California | 6011 | 2340 | 18 |
1543927 | 1543927 | 2021-07-23 | Contra Costa | California | 6013 | 75186 | 830 |
1543928 | 1543928 | 2021-07-23 | Del Norte | California | 6015 | 1554 | 8 |
1543929 | 1543929 | 2021-07-23 | El Dorado | California | 6017 | 11636 | 120 |
1543930 | 1543930 | 2021-07-23 | Fresno | California | 6019 | 113113 | 1736 |
1543931 | 1543931 | 2021-07-23 | Glenn | California | 6021 | 3049 | 27 |
1543932 | 1543932 | 2021-07-23 | Humboldt | California | 6023 | 4928 | 53 |
1543933 | 1543933 | 2021-07-23 | Imperial | California | 6025 | 31944 | 741 |
1543934 | 1543934 | 2021-07-23 | Inyo | California | 6027 | 1446 | 38 |
1543935 | 1543935 | 2021-07-23 | Kern | California | 6029 | 112318 | 1417 |
1543936 | 1543936 | 2021-07-23 | Kings | California | 6031 | 24543 | 248 |
1543937 | 1543937 | 2021-07-23 | Lake | California | 6033 | 3976 | 64 |
1543938 | 1543938 | 2021-07-23 | Lassen | California | 6035 | 5868 | 28 |
1543939 | 1543939 | 2021-07-23 | Los Angeles | California | 6037 | 1279856 | 24623 |
1543940 | 1543940 | 2021-07-23 | Madera | California | 6039 | 17885 | 249 |
1543941 | 1543941 | 2021-07-23 | Marin | California | 6041 | 14745 | 238 |
1543942 | 1543942 | 2021-07-23 | Mariposa | California | 6043 | 486 | 7 |
1543943 | 1543943 | 2021-07-23 | Mendocino | California | 6045 | 4571 | 50 |
1543944 | 1543944 | 2021-07-23 | Merced | California | 6047 | 32961 | 484 |
1543945 | 1543945 | 2021-07-23 | Modoc | California | 6049 | 573 | 7 |
1543946 | 1543946 | 2021-07-23 | Mono | California | 6051 | 1311 | 5 |
1543947 | 1543947 | 2021-07-23 | Monterey | California | 6053 | 45520 | 524 |
1543948 | 1543948 | 2021-07-23 | Napa | California | 6055 | 10277 | 81 |
1543949 | 1543949 | 2021-07-23 | Nevada | California | 6057 | 5390 | 75 |
1543950 | 1543950 | 2021-07-23 | Orange | California | 6059 | 278720 | 5141 |
1543951 | 1543951 | 2021-07-23 | Placer | California | 6061 | 26337 | 304 |
1543952 | 1543952 | 2021-07-23 | Plumas | California | 6063 | 761 | 6 |
1543953 | 1543953 | 2021-07-23 | Riverside | California | 6065 | 312238 | 4658 |
1543954 | 1543954 | 2021-07-23 | Sacramento | California | 6067 | 114630 | 1770 |
1543955 | 1543955 | 2021-07-23 | San Benito | California | 6069 | 6321 | 63 |
1543956 | 1543956 | 2021-07-23 | San Bernardino | California | 6071 | 307469 | 5236 |
1543957 | 1543957 | 2021-07-23 | San Diego | California | 6073 | 305671 | 3788 |
1543958 | 1543958 | 2021-07-23 | San Francisco | California | 6075 | 40466 | 561 |
1543959 | 1543959 | 2021-07-23 | San Joaquin | California | 6077 | 79494 | 1446 |
1543960 | 1543960 | 2021-07-23 | San Luis Obispo | California | 6079 | 22438 | 264 |
1543961 | 1543961 | 2021-07-23 | San Mateo | California | 6081 | 44416 | 588 |
1543962 | 1543962 | 2021-07-23 | Santa Barbara | California | 6083 | 36463 | 465 |
1543963 | 1543963 | 2021-07-23 | Santa Clara | California | 6085 | 121959 | 2100 |
1543964 | 1543964 | 2021-07-23 | Santa Cruz | California | 6087 | 17299 | 207 |
1543965 | 1543965 | 2021-07-23 | Shasta | California | 6089 | 14678 | 242 |
1543966 | 1543966 | 2021-07-23 | Sierra | California | 6091 | 78 | 0 |
1543967 | 1543967 | 2021-07-23 | Siskiyou | California | 6093 | 2537 | 40 |
1543968 | 1543968 | 2021-07-23 | Solano | California | 6095 | 35198 | 259 |
1543969 | 1543969 | 2021-07-23 | Sonoma | California | 6097 | 32321 | 328 |
1543970 | 1543970 | 2021-07-23 | Stanislaus | California | 6099 | 65019 | 1085 |
1543971 | 1543971 | 2021-07-23 | Sutter | California | 6101 | 9988 | 115 |
1543972 | 1543972 | 2021-07-23 | Tehama | California | 6103 | 5819 | 65 |
1543973 | 1543973 | 2021-07-23 | Trinity | California | 6105 | 411 | 3 |
1543974 | 1543974 | 2021-07-23 | Tulare | California | 6107 | 60019 | 854 |
1543975 | 1543975 | 2021-07-23 | Tuolumne | California | 6109 | 4409 | 73 |
1543976 | 1543976 | 2021-07-23 | Ventura | California | 6111 | 86187 | 1041 |
1543977 | 1543977 | 2021-07-23 | Yolo | California | 6113 | 15005 | 214 |
1543978 | 1543978 | 2021-07-23 | Yuba | California | 6115 | 6843 | 51 |
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);