ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-11-05" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
699955 | 699955 | 2020-11-05 | Alameda | California | 6001 | 24391 | 465 |
699956 | 699956 | 2020-11-05 | Alpine | California | 6003 | 5 | 0 |
699957 | 699957 | 2020-11-05 | Amador | California | 6005 | 361 | 16 |
699958 | 699958 | 2020-11-05 | Butte | California | 6007 | 3225 | 54 |
699959 | 699959 | 2020-11-05 | Calaveras | California | 6009 | 361 | 21 |
699960 | 699960 | 2020-11-05 | Colusa | California | 6011 | 576 | 6 |
699961 | 699961 | 2020-11-05 | Contra Costa | California | 6013 | 19472 | 248 |
699962 | 699962 | 2020-11-05 | Del Norte | California | 6015 | 201 | 1 |
699963 | 699963 | 2020-11-05 | El Dorado | California | 6017 | 1448 | 4 |
699964 | 699964 | 2020-11-05 | Fresno | California | 6019 | 32022 | 447 |
699965 | 699965 | 2020-11-05 | Glenn | California | 6021 | 701 | 3 |
699966 | 699966 | 2020-11-05 | Humboldt | California | 6023 | 599 | 10 |
699967 | 699967 | 2020-11-05 | Imperial | California | 6025 | 13330 | 339 |
699968 | 699968 | 2020-11-05 | Inyo | California | 6027 | 247 | 15 |
699969 | 699969 | 2020-11-05 | Kern | California | 6029 | 34973 | 428 |
699970 | 699970 | 2020-11-05 | Kings | California | 6031 | 8817 | 84 |
699971 | 699971 | 2020-11-05 | Lake | California | 6033 | 735 | 17 |
699972 | 699972 | 2020-11-05 | Lassen | California | 6035 | 781 | 1 |
699973 | 699973 | 2020-11-05 | Los Angeles | California | 6037 | 315634 | 7140 |
699974 | 699974 | 2020-11-05 | Madera | California | 6039 | 5219 | 76 |
699975 | 699975 | 2020-11-05 | Marin | California | 6041 | 7205 | 127 |
699976 | 699976 | 2020-11-05 | Mariposa | California | 6043 | 81 | 2 |
699977 | 699977 | 2020-11-05 | Mendocino | California | 6045 | 1213 | 21 |
699978 | 699978 | 2020-11-05 | Merced | California | 6047 | 9916 | 163 |
699979 | 699979 | 2020-11-05 | Modoc | California | 6049 | 68 | 0 |
699980 | 699980 | 2020-11-05 | Mono | California | 6051 | 336 | 2 |
699981 | 699981 | 2020-11-05 | Monterey | California | 6053 | 11998 | 99 |
699982 | 699982 | 2020-11-05 | Napa | California | 6055 | 2150 | 16 |
699983 | 699983 | 2020-11-05 | Nevada | California | 6057 | 688 | 9 |
699984 | 699984 | 2020-11-05 | Orange | California | 6059 | 63125 | 1494 |
699985 | 699985 | 2020-11-05 | Placer | California | 6061 | 4640 | 60 |
699986 | 699986 | 2020-11-05 | Plumas | California | 6063 | 88 | 0 |
699987 | 699987 | 2020-11-05 | Riverside | California | 6065 | 70309 | 1331 |
699988 | 699988 | 2020-11-05 | Sacramento | California | 6067 | 27277 | 506 |
699989 | 699989 | 2020-11-05 | San Benito | California | 6069 | 1491 | 15 |
699990 | 699990 | 2020-11-05 | San Bernardino | California | 6071 | 67196 | 1092 |
699991 | 699991 | 2020-11-05 | San Diego | California | 6073 | 58699 | 904 |
699992 | 699992 | 2020-11-05 | San Francisco | California | 6075 | 12669 | 149 |
699993 | 699993 | 2020-11-05 | San Joaquin | California | 6077 | 22556 | 494 |
699994 | 699994 | 2020-11-05 | San Luis Obispo | California | 6079 | 4496 | 33 |
699995 | 699995 | 2020-11-05 | San Mateo | California | 6081 | 11629 | 161 |
699996 | 699996 | 2020-11-05 | Santa Barbara | California | 6083 | 10089 | 130 |
699997 | 699997 | 2020-11-05 | Santa Clara | California | 6085 | 25705 | 425 |
699998 | 699998 | 2020-11-05 | Santa Cruz | California | 6087 | 3031 | 26 |
699999 | 699999 | 2020-11-05 | Shasta | California | 6089 | 2375 | 33 |
700000 | 700000 | 2020-11-05 | Sierra | California | 6091 | 6 | 0 |
700001 | 700001 | 2020-11-05 | Siskiyou | California | 6093 | 287 | 0 |
700002 | 700002 | 2020-11-05 | Solano | California | 6095 | 8001 | 76 |
700003 | 700003 | 2020-11-05 | Sonoma | California | 6097 | 10116 | 146 |
700004 | 700004 | 2020-11-05 | Stanislaus | California | 6099 | 19070 | 405 |
700005 | 700005 | 2020-11-05 | Sutter | California | 6101 | 1977 | 12 |
700006 | 700006 | 2020-11-05 | Tehama | California | 6103 | 997 | 15 |
700007 | 700007 | 2020-11-05 | Trinity | California | 6105 | 38 | 0 |
700008 | 700008 | 2020-11-05 | Tulare | California | 6107 | 18208 | 297 |
700009 | 700009 | 2020-11-05 | Tuolumne | California | 6109 | 318 | 7 |
700010 | 700010 | 2020-11-05 | Ventura | California | 6111 | 14936 | 169 |
700011 | 700011 | 2020-11-05 | Yolo | California | 6113 | 3395 | 62 |
700012 | 700012 | 2020-11-05 | Yuba | California | 6115 | 1428 | 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);