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-10-29 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
677251 | 677251 | 2020-10-29 | Alameda | California | 6001 | 23657 | 463 |
677252 | 677252 | 2020-10-29 | Alpine | California | 6003 | 4 | 0 |
677253 | 677253 | 2020-10-29 | Amador | California | 6005 | 336 | 16 |
677254 | 677254 | 2020-10-29 | Butte | California | 6007 | 3134 | 53 |
677255 | 677255 | 2020-10-29 | Calaveras | California | 6009 | 347 | 21 |
677256 | 677256 | 2020-10-29 | Colusa | California | 6011 | 555 | 6 |
677257 | 677257 | 2020-10-29 | Contra Costa | California | 6013 | 18828 | 243 |
677258 | 677258 | 2020-10-29 | Del Norte | California | 6015 | 181 | 1 |
677259 | 677259 | 2020-10-29 | El Dorado | California | 6017 | 1363 | 4 |
677260 | 677260 | 2020-10-29 | Fresno | California | 6019 | 31251 | 439 |
677261 | 677261 | 2020-10-29 | Glenn | California | 6021 | 673 | 3 |
677262 | 677262 | 2020-10-29 | Humboldt | California | 6023 | 569 | 10 |
677263 | 677263 | 2020-10-29 | Imperial | California | 6025 | 13023 | 337 |
677264 | 677264 | 2020-10-29 | Inyo | California | 6027 | 238 | 15 |
677265 | 677265 | 2020-10-29 | Kern | California | 6029 | 34154 | 422 |
677266 | 677266 | 2020-10-29 | Kings | California | 6031 | 8486 | 83 |
677267 | 677267 | 2020-10-29 | Lake | California | 6033 | 700 | 16 |
677268 | 677268 | 2020-10-29 | Lassen | California | 6035 | 771 | 1 |
677269 | 677269 | 2020-10-29 | Los Angeles | California | 6037 | 305070 | 7044 |
677270 | 677270 | 2020-10-29 | Madera | California | 6039 | 5066 | 76 |
677271 | 677271 | 2020-10-29 | Marin | California | 6041 | 7121 | 127 |
677272 | 677272 | 2020-10-29 | Mariposa | California | 6043 | 81 | 2 |
677273 | 677273 | 2020-10-29 | Mendocino | California | 6045 | 1156 | 21 |
677274 | 677274 | 2020-10-29 | Merced | California | 6047 | 9623 | 155 |
677275 | 677275 | 2020-10-29 | Modoc | California | 6049 | 48 | 0 |
677276 | 677276 | 2020-10-29 | Mono | California | 6051 | 182 | 2 |
677277 | 677277 | 2020-10-29 | Monterey | California | 6053 | 11616 | 95 |
677278 | 677278 | 2020-10-29 | Napa | California | 6055 | 2003 | 16 |
677279 | 677279 | 2020-10-29 | Nevada | California | 6057 | 635 | 8 |
677280 | 677280 | 2020-10-29 | Orange | California | 6059 | 61358 | 1468 |
677281 | 677281 | 2020-10-29 | Placer | California | 6061 | 4290 | 59 |
677282 | 677282 | 2020-10-29 | Plumas | California | 6063 | 67 | 0 |
677283 | 677283 | 2020-10-29 | Riverside | California | 6065 | 67552 | 1306 |
677284 | 677284 | 2020-10-29 | Sacramento | California | 6067 | 26017 | 500 |
677285 | 677285 | 2020-10-29 | San Benito | California | 6069 | 1449 | 15 |
677286 | 677286 | 2020-10-29 | San Bernardino | California | 6071 | 64131 | 1073 |
677287 | 677287 | 2020-10-29 | San Diego | California | 6073 | 55961 | 885 |
677288 | 677288 | 2020-10-29 | San Francisco | California | 6075 | 12280 | 145 |
677289 | 677289 | 2020-10-29 | San Joaquin | California | 6077 | 21994 | 492 |
677290 | 677290 | 2020-10-29 | San Luis Obispo | California | 6079 | 4265 | 32 |
677291 | 677291 | 2020-10-29 | San Mateo | California | 6081 | 11278 | 159 |
677292 | 677292 | 2020-10-29 | Santa Barbara | California | 6083 | 9919 | 126 |
677293 | 677293 | 2020-10-29 | Santa Clara | California | 6085 | 24665 | 405 |
677294 | 677294 | 2020-10-29 | Santa Cruz | California | 6087 | 2861 | 25 |
677295 | 677295 | 2020-10-29 | Shasta | California | 6089 | 1999 | 31 |
677296 | 677296 | 2020-10-29 | Sierra | California | 6091 | 6 | 0 |
677297 | 677297 | 2020-10-29 | Siskiyou | California | 6093 | 221 | 0 |
677298 | 677298 | 2020-10-29 | Solano | California | 6095 | 7591 | 76 |
677299 | 677299 | 2020-10-29 | Sonoma | California | 6097 | 9601 | 136 |
677300 | 677300 | 2020-10-29 | Stanislaus | California | 6099 | 18594 | 400 |
677301 | 677301 | 2020-10-29 | Sutter | California | 6101 | 1897 | 12 |
677302 | 677302 | 2020-10-29 | Tehama | California | 6103 | 921 | 9 |
677303 | 677303 | 2020-10-29 | Trinity | California | 6105 | 29 | 0 |
677304 | 677304 | 2020-10-29 | Tulare | California | 6107 | 17800 | 292 |
677305 | 677305 | 2020-10-29 | Tuolumne | California | 6109 | 288 | 6 |
677306 | 677306 | 2020-10-29 | Ventura | California | 6111 | 14409 | 166 |
677307 | 677307 | 2020-10-29 | Yolo | California | 6113 | 3250 | 60 |
677308 | 677308 | 2020-10-29 | Yuba | California | 6115 | 1346 | 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);