ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where "date" is on date 2020-04-10 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
45961 | 45961 | 2020-04-10 | Alameda | California | 6001 | 766 | 20 |
45962 | 45962 | 2020-04-10 | Alpine | California | 6003 | 2 | 0 |
45963 | 45963 | 2020-04-10 | Amador | California | 6005 | 6 | 0 |
45964 | 45964 | 2020-04-10 | Butte | California | 6007 | 14 | 0 |
45965 | 45965 | 2020-04-10 | Calaveras | California | 6009 | 8 | 0 |
45966 | 45966 | 2020-04-10 | Colusa | California | 6011 | 3 | 0 |
45967 | 45967 | 2020-04-10 | Contra Costa | California | 6013 | 511 | 9 |
45968 | 45968 | 2020-04-10 | Del Norte | California | 6015 | 2 | 0 |
45969 | 45969 | 2020-04-10 | El Dorado | California | 6017 | 32 | 0 |
45970 | 45970 | 2020-04-10 | Fresno | California | 6019 | 191 | 5 |
45971 | 45971 | 2020-04-10 | Glenn | California | 6021 | 3 | 0 |
45972 | 45972 | 2020-04-10 | Humboldt | California | 6023 | 50 | 0 |
45973 | 45973 | 2020-04-10 | Imperial | California | 6025 | 79 | 2 |
45974 | 45974 | 2020-04-10 | Inyo | California | 6027 | 12 | 0 |
45975 | 45975 | 2020-04-10 | Kern | California | 6029 | 363 | 3 |
45976 | 45976 | 2020-04-10 | Kings | California | 6031 | 9 | 0 |
45977 | 45977 | 2020-04-10 | Lake | California | 6033 | 4 | 0 |
45978 | 45978 | 2020-04-10 | Los Angeles | California | 6037 | 8430 | 241 |
45979 | 45979 | 2020-04-10 | Madera | California | 6039 | 32 | 2 |
45980 | 45980 | 2020-04-10 | Marin | California | 6041 | 154 | 10 |
45981 | 45981 | 2020-04-10 | Mendocino | California | 6045 | 4 | 0 |
45982 | 45982 | 2020-04-10 | Merced | California | 6047 | 59 | 3 |
45983 | 45983 | 2020-04-10 | Mono | California | 6051 | 21 | 1 |
45984 | 45984 | 2020-04-10 | Monterey | California | 6053 | 79 | 3 |
45985 | 45985 | 2020-04-10 | Napa | California | 6055 | 33 | 2 |
45986 | 45986 | 2020-04-10 | Nevada | California | 6057 | 34 | 1 |
45987 | 45987 | 2020-04-10 | Orange | California | 6059 | 1138 | 17 |
45988 | 45988 | 2020-04-10 | Placer | California | 6061 | 123 | 4 |
45989 | 45989 | 2020-04-10 | Plumas | California | 6063 | 4 | 0 |
45990 | 45990 | 2020-04-10 | Riverside | California | 6065 | 1350 | 39 |
45991 | 45991 | 2020-04-10 | Sacramento | California | 6067 | 652 | 24 |
45992 | 45992 | 2020-04-10 | San Benito | California | 6069 | 35 | 2 |
45993 | 45993 | 2020-04-10 | San Bernardino | California | 6071 | 810 | 25 |
45994 | 45994 | 2020-04-10 | San Diego | California | 6073 | 1696 | 44 |
45995 | 45995 | 2020-04-10 | San Francisco | California | 6075 | 800 | 13 |
45996 | 45996 | 2020-04-10 | San Joaquin | California | 6077 | 257 | 14 |
45997 | 45997 | 2020-04-10 | San Luis Obispo | California | 6079 | 107 | 1 |
45998 | 45998 | 2020-04-10 | San Mateo | California | 6081 | 638 | 21 |
45999 | 45999 | 2020-04-10 | Santa Barbara | California | 6083 | 260 | 2 |
46000 | 46000 | 2020-04-10 | Santa Clara | California | 6085 | 1484 | 50 |
46001 | 46001 | 2020-04-10 | Santa Cruz | California | 6087 | 80 | 1 |
46002 | 46002 | 2020-04-10 | Shasta | California | 6089 | 24 | 3 |
46003 | 46003 | 2020-04-10 | Siskiyou | California | 6093 | 5 | 0 |
46004 | 46004 | 2020-04-10 | Solano | California | 6095 | 126 | 2 |
46005 | 46005 | 2020-04-10 | Sonoma | California | 6097 | 145 | 2 |
46006 | 46006 | 2020-04-10 | Stanislaus | California | 6099 | 116 | 1 |
46007 | 46007 | 2020-04-10 | Sutter | California | 6101 | 22 | 2 |
46008 | 46008 | 2020-04-10 | Tehama | California | 6103 | 1 | 0 |
46009 | 46009 | 2020-04-10 | Tulare | California | 6107 | 203 | 11 |
46010 | 46010 | 2020-04-10 | Tuolumne | California | 6109 | 1 | 0 |
46011 | 46011 | 2020-04-10 | Ventura | California | 6111 | 298 | 10 |
46012 | 46012 | 2020-04-10 | Yolo | California | 6113 | 75 | 3 |
46013 | 46013 | 2020-04-10 | Yuba | California | 6115 | 15 | 1 |
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);