ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-12-20" 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 |
---|---|---|---|---|---|---|---|
2031300 | 2031300 | 2021-12-20 | Alameda | California | 6001 | 128701 | 1532 |
2031301 | 2031301 | 2021-12-20 | Alpine | California | 6003 | 112 | 0 |
2031302 | 2031302 | 2021-12-20 | Amador | California | 6005 | 5908 | 70 |
2031303 | 2031303 | 2021-12-20 | Butte | California | 6007 | 26045 | 329 |
2031304 | 2031304 | 2021-12-20 | Calaveras | California | 6009 | 4634 | 91 |
2031305 | 2031305 | 2021-12-20 | Colusa | California | 6011 | 3349 | 21 |
2031306 | 2031306 | 2021-12-20 | Contra Costa | California | 6013 | 106402 | 1068 |
2031307 | 2031307 | 2021-12-20 | Del Norte | California | 6015 | 3933 | 43 |
2031308 | 2031308 | 2021-12-20 | El Dorado | California | 6017 | 18925 | 172 |
2031309 | 2031309 | 2021-12-20 | Fresno | California | 6019 | 160392 | 2341 |
2031310 | 2031310 | 2021-12-20 | Glenn | California | 6021 | 4640 | 53 |
2031311 | 2031311 | 2021-12-20 | Humboldt | California | 6023 | 10712 | 121 |
2031312 | 2031312 | 2021-12-20 | Imperial | California | 6025 | 40524 | 791 |
2031313 | 2031313 | 2021-12-20 | Inyo | California | 6027 | 2649 | 47 |
2031314 | 2031314 | 2021-12-20 | Kern | California | 6029 | 161540 | 1897 |
2031315 | 2031315 | 2021-12-20 | Kings | California | 6031 | 36091 | 378 |
2031316 | 2031316 | 2021-12-20 | Lake | California | 6033 | 7167 | 116 |
2031317 | 2031317 | 2021-12-20 | Lassen | California | 6035 | 8044 | 61 |
2031318 | 2031318 | 2021-12-20 | Los Angeles | California | 6037 | 1567837 | 27448 |
2031319 | 2031319 | 2021-12-20 | Madera | California | 6039 | 26918 | 317 |
2031320 | 2031320 | 2021-12-20 | Marin | California | 6041 | 19286 | 249 |
2031321 | 2031321 | 2021-12-20 | Mariposa | California | 6043 | 1678 | 18 |
2031322 | 2031322 | 2021-12-20 | Mendocino | California | 6045 | 8948 | 103 |
2031323 | 2031323 | 2021-12-20 | Merced | California | 6047 | 46474 | 692 |
2031324 | 2031324 | 2021-12-20 | Modoc | California | 6049 | 1093 | 11 |
2031325 | 2031325 | 2021-12-20 | Mono | California | 6051 | 1988 | 4 |
2031326 | 2031326 | 2021-12-20 | Monterey | California | 6053 | 54003 | 641 |
2031327 | 2031327 | 2021-12-20 | Napa | California | 6055 | 13790 | 107 |
2031328 | 2031328 | 2021-12-20 | Nevada | California | 6057 | 10420 | 109 |
2031329 | 2031329 | 2021-12-20 | Orange | California | 6059 | 341739 | 5853 |
2031330 | 2031330 | 2021-12-20 | Placer | California | 6061 | 43592 | 486 |
2031331 | 2031331 | 2021-12-20 | Plumas | California | 6063 | 2030 | 12 |
2031332 | 2031332 | 2021-12-20 | Riverside | California | 6065 | 398960 | 5536 |
2031333 | 2031333 | 2021-12-20 | Sacramento | California | 6067 | 173347 | 2509 |
2031334 | 2031334 | 2021-12-20 | San Benito | California | 6069 | 8125 | 79 |
2031335 | 2031335 | 2021-12-20 | San Bernardino | California | 6071 | 385841 | 6023 |
2031336 | 2031336 | 2021-12-20 | San Diego | California | 6073 | 421267 | 4406 |
2031337 | 2031337 | 2021-12-20 | San Francisco | California | 6075 | 59294 | 681 |
2031338 | 2031338 | 2021-12-20 | San Joaquin | California | 6077 | 110023 | 1865 |
2031339 | 2031339 | 2021-12-20 | San Luis Obispo | California | 6079 | 32429 | 367 |
2031340 | 2031340 | 2021-12-20 | San Mateo | California | 6081 | 58105 | 635 |
2031341 | 2031341 | 2021-12-20 | Santa Barbara | California | 6083 | 48861 | 562 |
2031342 | 2031342 | 2021-12-20 | Santa Clara | California | 6085 | 156837 | 1951 |
2031343 | 2031343 | 2021-12-20 | Santa Cruz | California | 6087 | 23095 | 227 |
2031344 | 2031344 | 2021-12-20 | Shasta | California | 6089 | 26712 | 481 |
2031345 | 2031345 | 2021-12-20 | Sierra | California | 6091 | 224 | 0 |
2031346 | 2031346 | 2021-12-20 | Siskiyou | California | 6093 | 5031 | 76 |
2031347 | 2031347 | 2021-12-20 | Solano | California | 6095 | 48671 | 370 |
2031348 | 2031348 | 2021-12-20 | Sonoma | California | 6097 | 44545 | 416 |
2031349 | 2031349 | 2021-12-20 | Stanislaus | California | 6099 | 93694 | 1462 |
2031350 | 2031350 | 2021-12-20 | Sutter | California | 6101 | 14897 | 190 |
2031351 | 2031351 | 2021-12-20 | Tehama | California | 6103 | 10440 | 136 |
2031352 | 2031352 | 2021-12-20 | Trinity | California | 6105 | 1035 | 17 |
2031353 | 2031353 | 2021-12-20 | Tulare | California | 6107 | 88294 | 1129 |
2031354 | 2031354 | 2021-12-20 | Tuolumne | California | 6109 | 8090 | 148 |
2031355 | 2031355 | 2021-12-20 | Ventura | California | 6111 | 106810 | 1203 |
2031356 | 2031356 | 2021-12-20 | Yolo | California | 6113 | 22213 | 267 |
2031357 | 2031357 | 2021-12-20 | Yuba | California | 6115 | 11527 | 97 |
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);