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-08-13 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
427971 | 427971 | 2020-08-13 | Alameda | California | 6001 | 14250 | 216 |
427972 | 427972 | 2020-08-13 | Alpine | California | 6003 | 2 | 0 |
427973 | 427973 | 2020-08-13 | Amador | California | 6005 | 205 | 11 |
427974 | 427974 | 2020-08-13 | Butte | California | 6007 | 1321 | 12 |
427975 | 427975 | 2020-08-13 | Calaveras | California | 6009 | 161 | 1 |
427976 | 427976 | 2020-08-13 | Colusa | California | 6011 | 401 | 5 |
427977 | 427977 | 2020-08-13 | Contra Costa | California | 6013 | 10482 | 151 |
427978 | 427978 | 2020-08-13 | Del Norte | California | 6015 | 105 | 0 |
427979 | 427979 | 2020-08-13 | El Dorado | California | 6017 | 802 | 2 |
427980 | 427980 | 2020-08-13 | Fresno | California | 6019 | 18690 | 191 |
427981 | 427981 | 2020-08-13 | Glenn | California | 6021 | 388 | 3 |
427982 | 427982 | 2020-08-13 | Humboldt | California | 6023 | 302 | 4 |
427983 | 427983 | 2020-08-13 | Imperial | California | 6025 | 9957 | 256 |
427984 | 427984 | 2020-08-13 | Inyo | California | 6027 | 97 | 3 |
427985 | 427985 | 2020-08-13 | Kern | California | 6029 | 25499 | 187 |
427986 | 427986 | 2020-08-13 | Kings | California | 6031 | 5243 | 64 |
427987 | 427987 | 2020-08-13 | Lake | California | 6033 | 253 | 2 |
427988 | 427988 | 2020-08-13 | Lassen | California | 6035 | 694 | 0 |
427989 | 427989 | 2020-08-13 | Los Angeles | California | 6037 | 216139 | 5171 |
427990 | 427990 | 2020-08-13 | Madera | California | 6039 | 2853 | 46 |
427991 | 427991 | 2020-08-13 | Marin | California | 6041 | 5674 | 81 |
427992 | 427992 | 2020-08-13 | Mariposa | California | 6043 | 63 | 2 |
427993 | 427993 | 2020-08-13 | Mendocino | California | 6045 | 513 | 10 |
427994 | 427994 | 2020-08-13 | Merced | California | 6047 | 6561 | 89 |
427995 | 427995 | 2020-08-13 | Modoc | California | 6049 | 5 | 0 |
427996 | 427996 | 2020-08-13 | Mono | California | 6051 | 160 | 1 |
427997 | 427997 | 2020-08-13 | Monterey | California | 6053 | 5919 | 40 |
427998 | 427998 | 2020-08-13 | Napa | California | 6055 | 1171 | 11 |
427999 | 427999 | 2020-08-13 | Nevada | California | 6057 | 362 | 1 |
428000 | 428000 | 2020-08-13 | Orange | California | 6059 | 42171 | 769 |
428001 | 428001 | 2020-08-13 | Placer | California | 6061 | 2486 | 27 |
428002 | 428002 | 2020-08-13 | Plumas | California | 6063 | 31 | 0 |
428003 | 428003 | 2020-08-13 | Riverside | California | 6065 | 44747 | 879 |
428004 | 428004 | 2020-08-13 | Sacramento | California | 6067 | 13215 | 194 |
428005 | 428005 | 2020-08-13 | San Benito | California | 6069 | 792 | 4 |
428006 | 428006 | 2020-08-13 | San Bernardino | California | 6071 | 38811 | 558 |
428007 | 428007 | 2020-08-13 | San Diego | California | 6073 | 33722 | 615 |
428008 | 428008 | 2020-08-13 | San Francisco | California | 6075 | 7947 | 67 |
428009 | 428009 | 2020-08-13 | San Joaquin | California | 6077 | 14276 | 245 |
428010 | 428010 | 2020-08-13 | San Luis Obispo | California | 6079 | 2324 | 18 |
428011 | 428011 | 2020-08-13 | San Mateo | California | 6081 | 6640 | 122 |
428012 | 428012 | 2020-08-13 | Santa Barbara | California | 6083 | 7148 | 75 |
428013 | 428013 | 2020-08-13 | Santa Clara | California | 6085 | 13340 | 209 |
428014 | 428014 | 2020-08-13 | Santa Cruz | California | 6087 | 1382 | 6 |
428015 | 428015 | 2020-08-13 | Shasta | California | 6089 | 479 | 10 |
428016 | 428016 | 2020-08-13 | Sierra | California | 6091 | 4 | 0 |
428017 | 428017 | 2020-08-13 | Siskiyou | California | 6093 | 109 | 0 |
428018 | 428018 | 2020-08-13 | Solano | California | 6095 | 4539 | 41 |
428019 | 428019 | 2020-08-13 | Sonoma | California | 6097 | 4063 | 51 |
428020 | 428020 | 2020-08-13 | Stanislaus | California | 6099 | 11682 | 187 |
428021 | 428021 | 2020-08-13 | Sutter | California | 6101 | 1070 | 7 |
428022 | 428022 | 2020-08-13 | Tehama | California | 6103 | 289 | 1 |
428023 | 428023 | 2020-08-13 | Trinity | California | 6105 | 7 | 0 |
428024 | 428024 | 2020-08-13 | Tulare | California | 6107 | 11847 | 205 |
428025 | 428025 | 2020-08-13 | Tuolumne | California | 6109 | 160 | 2 |
428026 | 428026 | 2020-08-13 | Ventura | California | 6111 | 9005 | 94 |
428027 | 428027 | 2020-08-13 | Yolo | California | 6113 | 1927 | 45 |
428028 | 428028 | 2020-08-13 | Yuba | California | 6115 | 727 | 4 |
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);