ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where date = "2020-07-22" 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 |
---|---|---|---|---|---|---|---|
357219 | 357219 | 2020-07-22 | Alameda | California | 6001 | 9664 | 171 |
357220 | 357220 | 2020-07-22 | Alpine | California | 6003 | 2 | 0 |
357221 | 357221 | 2020-07-22 | Amador | California | 6005 | 63 | 0 |
357222 | 357222 | 2020-07-22 | Butte | California | 6007 | 683 | 5 |
357223 | 357223 | 2020-07-22 | Calaveras | California | 6009 | 96 | 1 |
357224 | 357224 | 2020-07-22 | Colusa | California | 6011 | 242 | 2 |
357225 | 357225 | 2020-07-22 | Contra Costa | California | 6013 | 6210 | 102 |
357226 | 357226 | 2020-07-22 | Del Norte | California | 6015 | 79 | 0 |
357227 | 357227 | 2020-07-22 | El Dorado | California | 6017 | 486 | 1 |
357228 | 357228 | 2020-07-22 | Fresno | California | 6019 | 11412 | 104 |
357229 | 357229 | 2020-07-22 | Glenn | California | 6021 | 229 | 0 |
357230 | 357230 | 2020-07-22 | Humboldt | California | 6023 | 200 | 4 |
357231 | 357231 | 2020-07-22 | Imperial | California | 6025 | 8799 | 164 |
357232 | 357232 | 2020-07-22 | Inyo | California | 6027 | 38 | 1 |
357233 | 357233 | 2020-07-22 | Kern | California | 6029 | 11998 | 115 |
357234 | 357234 | 2020-07-22 | Kings | California | 6031 | 3600 | 45 |
357235 | 357235 | 2020-07-22 | Lake | California | 6033 | 157 | 1 |
357236 | 357236 | 2020-07-22 | Lassen | California | 6035 | 515 | 0 |
357237 | 357237 | 2020-07-22 | Los Angeles | California | 6037 | 164870 | 4213 |
357238 | 357238 | 2020-07-22 | Madera | California | 6039 | 1530 | 16 |
357239 | 357239 | 2020-07-22 | Marin | California | 6041 | 4490 | 40 |
357240 | 357240 | 2020-07-22 | Mariposa | California | 6043 | 41 | 1 |
357241 | 357241 | 2020-07-22 | Mendocino | California | 6045 | 227 | 3 |
357242 | 357242 | 2020-07-22 | Merced | California | 6047 | 2994 | 26 |
357243 | 357243 | 2020-07-22 | Mono | California | 6051 | 91 | 1 |
357244 | 357244 | 2020-07-22 | Monterey | California | 6053 | 3545 | 21 |
357245 | 357245 | 2020-07-22 | Napa | California | 6055 | 686 | 7 |
357246 | 357246 | 2020-07-22 | Nevada | California | 6057 | 242 | 1 |
357247 | 357247 | 2020-07-22 | Orange | California | 6059 | 31743 | 521 |
357248 | 357248 | 2020-07-22 | Placer | California | 6061 | 1479 | 12 |
357249 | 357249 | 2020-07-22 | Plumas | California | 6063 | 19 | 0 |
357250 | 357250 | 2020-07-22 | Riverside | California | 6065 | 32231 | 617 |
357251 | 357251 | 2020-07-22 | Sacramento | California | 6067 | 7970 | 96 |
357252 | 357252 | 2020-07-22 | San Benito | California | 6069 | 494 | 2 |
357253 | 357253 | 2020-07-22 | San Bernardino | California | 6071 | 25775 | 337 |
357254 | 357254 | 2020-07-22 | San Diego | California | 6073 | 25170 | 505 |
357255 | 357255 | 2020-07-22 | San Francisco | California | 6075 | 5462 | 53 |
357256 | 357256 | 2020-07-22 | San Joaquin | California | 6077 | 9595 | 98 |
357257 | 357257 | 2020-07-22 | San Luis Obispo | California | 6079 | 1393 | 7 |
357258 | 357258 | 2020-07-22 | San Mateo | California | 6081 | 4776 | 114 |
357259 | 357259 | 2020-07-22 | Santa Barbara | California | 6083 | 5422 | 32 |
357260 | 357260 | 2020-07-22 | Santa Clara | California | 6085 | 8321 | 181 |
357261 | 357261 | 2020-07-22 | Santa Cruz | California | 6087 | 848 | 3 |
357262 | 357262 | 2020-07-22 | Shasta | California | 6089 | 268 | 7 |
357263 | 357263 | 2020-07-22 | Sierra | California | 6091 | 1 | 0 |
357264 | 357264 | 2020-07-22 | Siskiyou | California | 6093 | 53 | 0 |
357265 | 357265 | 2020-07-22 | Solano | California | 6095 | 2987 | 35 |
357266 | 357266 | 2020-07-22 | Sonoma | California | 6097 | 2241 | 22 |
357267 | 357267 | 2020-07-22 | Stanislaus | California | 6099 | 6984 | 77 |
357268 | 357268 | 2020-07-22 | Sutter | California | 6101 | 567 | 4 |
357269 | 357269 | 2020-07-22 | Tehama | California | 6103 | 150 | 1 |
357270 | 357270 | 2020-07-22 | Trinity | California | 6105 | 3 | 0 |
357271 | 357271 | 2020-07-22 | Tulare | California | 6107 | 7603 | 168 |
357272 | 357272 | 2020-07-22 | Tuolumne | California | 6109 | 109 | 0 |
357273 | 357273 | 2020-07-22 | Ventura | California | 6111 | 6131 | 63 |
357274 | 357274 | 2020-07-22 | Yolo | California | 6113 | 1225 | 35 |
357275 | 357275 | 2020-07-22 | Yuba | California | 6115 | 319 | 3 |
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);