ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-05-01 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
104041 | 104041 | 2020-05-01 | Alameda | California | 6001 | 1657 | 63 |
104042 | 104042 | 2020-05-01 | Alpine | California | 6003 | 1 | 0 |
104043 | 104043 | 2020-05-01 | Amador | California | 6005 | 7 | 0 |
104044 | 104044 | 2020-05-01 | Butte | California | 6007 | 16 | 0 |
104045 | 104045 | 2020-05-01 | Calaveras | California | 6009 | 13 | 0 |
104046 | 104046 | 2020-05-01 | Colusa | California | 6011 | 3 | 0 |
104047 | 104047 | 2020-05-01 | Contra Costa | California | 6013 | 907 | 28 |
104048 | 104048 | 2020-05-01 | Del Norte | California | 6015 | 3 | 0 |
104049 | 104049 | 2020-05-01 | El Dorado | California | 6017 | 47 | 0 |
104050 | 104050 | 2020-05-01 | Fresno | California | 6019 | 615 | 8 |
104051 | 104051 | 2020-05-01 | Glenn | California | 6021 | 5 | 0 |
104052 | 104052 | 2020-05-01 | Humboldt | California | 6023 | 54 | 0 |
104053 | 104053 | 2020-05-01 | Imperial | California | 6025 | 358 | 8 |
104054 | 104054 | 2020-05-01 | Inyo | California | 6027 | 20 | 1 |
104055 | 104055 | 2020-05-01 | Kern | California | 6029 | 941 | 8 |
104056 | 104056 | 2020-05-01 | Kings | California | 6031 | 123 | 1 |
104057 | 104057 | 2020-05-01 | Lake | California | 6033 | 7 | 0 |
104058 | 104058 | 2020-05-01 | Los Angeles | California | 6037 | 24215 | 1172 |
104059 | 104059 | 2020-05-01 | Madera | California | 6039 | 46 | 2 |
104060 | 104060 | 2020-05-01 | Marin | California | 6041 | 240 | 13 |
104061 | 104061 | 2020-05-01 | Mariposa | California | 6043 | 13 | 0 |
104062 | 104062 | 2020-05-01 | Mendocino | California | 6045 | 12 | 0 |
104063 | 104063 | 2020-05-01 | Merced | California | 6047 | 134 | 3 |
104064 | 104064 | 2020-05-01 | Mono | California | 6051 | 26 | 1 |
104065 | 104065 | 2020-05-01 | Monterey | California | 6053 | 222 | 5 |
104066 | 104066 | 2020-05-01 | Napa | California | 6055 | 69 | 2 |
104067 | 104067 | 2020-05-01 | Nevada | California | 6057 | 41 | 1 |
104068 | 104068 | 2020-05-01 | Orange | California | 6059 | 2591 | 50 |
104069 | 104069 | 2020-05-01 | Placer | California | 6061 | 150 | 8 |
104070 | 104070 | 2020-05-01 | Plumas | California | 6063 | 4 | 0 |
104071 | 104071 | 2020-05-01 | Riverside | California | 6065 | 4079 | 156 |
104072 | 104072 | 2020-05-01 | Sacramento | California | 6067 | 1090 | 43 |
104073 | 104073 | 2020-05-01 | San Benito | California | 6069 | 51 | 2 |
104074 | 104074 | 2020-05-01 | San Bernardino | California | 6071 | 2113 | 96 |
104075 | 104075 | 2020-05-01 | San Diego | California | 6073 | 3774 | 143 |
104076 | 104076 | 2020-05-01 | San Francisco | California | 6075 | 1526 | 28 |
104077 | 104077 | 2020-05-01 | San Joaquin | California | 6077 | 557 | 25 |
104078 | 104078 | 2020-05-01 | San Luis Obispo | California | 6079 | 188 | 1 |
104079 | 104079 | 2020-05-01 | San Mateo | California | 6081 | 1197 | 52 |
104080 | 104080 | 2020-05-01 | Santa Barbara | California | 6083 | 506 | 8 |
104081 | 104081 | 2020-05-01 | Santa Clara | California | 6085 | 2179 | 114 |
104082 | 104082 | 2020-05-01 | Santa Cruz | California | 6087 | 132 | 2 |
104083 | 104083 | 2020-05-01 | Shasta | California | 6089 | 31 | 4 |
104084 | 104084 | 2020-05-01 | Siskiyou | California | 6093 | 5 | 0 |
104085 | 104085 | 2020-05-01 | Solano | California | 6095 | 271 | 5 |
104086 | 104086 | 2020-05-01 | Sonoma | California | 6097 | 248 | 3 |
104087 | 104087 | 2020-05-01 | Stanislaus | California | 6099 | 380 | 13 |
104088 | 104088 | 2020-05-01 | Sutter | California | 6101 | 31 | 2 |
104089 | 104089 | 2020-05-01 | Tehama | California | 6103 | 1 | 1 |
104090 | 104090 | 2020-05-01 | Tulare | California | 6107 | 680 | 40 |
104091 | 104091 | 2020-05-01 | Tuolumne | California | 6109 | 4 | 0 |
104092 | 104092 | 2020-05-01 | Ventura | California | 6111 | 547 | 18 |
104093 | 104093 | 2020-05-01 | Yolo | California | 6113 | 169 | 16 |
104094 | 104094 | 2020-05-01 | Yuba | California | 6115 | 19 | 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);