ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-12-05" 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 |
---|---|---|---|---|---|---|---|
1982539 | 1982539 | 2021-12-05 | Alameda | California | 6001 | 125649 | 1512 |
1982540 | 1982540 | 2021-12-05 | Alpine | California | 6003 | 108 | 0 |
1982541 | 1982541 | 2021-12-05 | Amador | California | 6005 | 5799 | 67 |
1982542 | 1982542 | 2021-12-05 | Butte | California | 6007 | 25608 | 318 |
1982543 | 1982543 | 2021-12-05 | Calaveras | California | 6009 | 4457 | 88 |
1982544 | 1982544 | 2021-12-05 | Colusa | California | 6011 | 3283 | 21 |
1982545 | 1982545 | 2021-12-05 | Contra Costa | California | 6013 | 104218 | 1056 |
1982546 | 1982546 | 2021-12-05 | Del Norte | California | 6015 | 3885 | 42 |
1982547 | 1982547 | 2021-12-05 | El Dorado | California | 6017 | 18448 | 168 |
1982548 | 1982548 | 2021-12-05 | Fresno | California | 6019 | 157469 | 2270 |
1982549 | 1982549 | 2021-12-05 | Glenn | California | 6021 | 4585 | 51 |
1982550 | 1982550 | 2021-12-05 | Humboldt | California | 6023 | 10294 | 119 |
1982551 | 1982551 | 2021-12-05 | Imperial | California | 6025 | 38932 | 775 |
1982552 | 1982552 | 2021-12-05 | Inyo | California | 6027 | 2573 | 46 |
1982553 | 1982553 | 2021-12-05 | Kern | California | 6029 | 158270 | 1828 |
1982554 | 1982554 | 2021-12-05 | Kings | California | 6031 | 35370 | 369 |
1982555 | 1982555 | 2021-12-05 | Lake | California | 6033 | 7057 | 113 |
1982556 | 1982556 | 2021-12-05 | Lassen | California | 6035 | 7987 | 58 |
1982557 | 1982557 | 2021-12-05 | Los Angeles | California | 6037 | 1537055 | 27246 |
1982558 | 1982558 | 2021-12-05 | Madera | California | 6039 | 26388 | 311 |
1982559 | 1982559 | 2021-12-05 | Marin | California | 6041 | 18587 | 249 |
1982560 | 1982560 | 2021-12-05 | Mariposa | California | 6043 | 1622 | 18 |
1982561 | 1982561 | 2021-12-05 | Mendocino | California | 6045 | 8649 | 99 |
1982562 | 1982562 | 2021-12-05 | Merced | California | 6047 | 45699 | 675 |
1982563 | 1982563 | 2021-12-05 | Modoc | California | 6049 | 1056 | 10 |
1982564 | 1982564 | 2021-12-05 | Mono | California | 6051 | 1903 | 4 |
1982565 | 1982565 | 2021-12-05 | Monterey | California | 6053 | 52842 | 632 |
1982566 | 1982566 | 2021-12-05 | Napa | California | 6055 | 13447 | 106 |
1982567 | 1982567 | 2021-12-05 | Nevada | California | 6057 | 10112 | 105 |
1982568 | 1982568 | 2021-12-05 | Orange | California | 6059 | 335296 | 5756 |
1982569 | 1982569 | 2021-12-05 | Placer | California | 6061 | 42458 | 473 |
1982570 | 1982570 | 2021-12-05 | Plumas | California | 6063 | 1957 | 7 |
1982571 | 1982571 | 2021-12-05 | Riverside | California | 6065 | 389236 | 5476 |
1982572 | 1982572 | 2021-12-05 | Sacramento | California | 6067 | 169094 | 2452 |
1982573 | 1982573 | 2021-12-05 | San Benito | California | 6069 | 7879 | 78 |
1982574 | 1982574 | 2021-12-05 | San Bernardino | California | 6071 | 376280 | 5983 |
1982575 | 1982575 | 2021-12-05 | San Diego | California | 6073 | 409245 | 4350 |
1982576 | 1982576 | 2021-12-05 | San Francisco | California | 6075 | 57144 | 674 |
1982577 | 1982577 | 2021-12-05 | San Joaquin | California | 6077 | 108079 | 1839 |
1982578 | 1982578 | 2021-12-05 | San Luis Obispo | California | 6079 | 31667 | 365 |
1982579 | 1982579 | 2021-12-05 | San Mateo | California | 6081 | 56585 | 631 |
1982580 | 1982580 | 2021-12-05 | Santa Barbara | California | 6083 | 47523 | 555 |
1982581 | 1982581 | 2021-12-05 | Santa Clara | California | 6085 | 152857 | 1929 |
1982582 | 1982582 | 2021-12-05 | Santa Cruz | California | 6087 | 22402 | 224 |
1982583 | 1982583 | 2021-12-05 | Shasta | California | 6089 | 26221 | 461 |
1982584 | 1982584 | 2021-12-05 | Sierra | California | 6091 | 219 | 0 |
1982585 | 1982585 | 2021-12-05 | Siskiyou | California | 6093 | 4947 | 74 |
1982586 | 1982586 | 2021-12-05 | Solano | California | 6095 | 47833 | 360 |
1982587 | 1982587 | 2021-12-05 | Sonoma | California | 6097 | 43349 | 414 |
1982588 | 1982588 | 2021-12-05 | Stanislaus | California | 6099 | 91964 | 1429 |
1982589 | 1982589 | 2021-12-05 | Sutter | California | 6101 | 14646 | 186 |
1982590 | 1982590 | 2021-12-05 | Tehama | California | 6103 | 10316 | 131 |
1982591 | 1982591 | 2021-12-05 | Trinity | California | 6105 | 1008 | 17 |
1982592 | 1982592 | 2021-12-05 | Tulare | California | 6107 | 86739 | 1100 |
1982593 | 1982593 | 2021-12-05 | Tuolumne | California | 6109 | 7908 | 144 |
1982594 | 1982594 | 2021-12-05 | Ventura | California | 6111 | 104309 | 1192 |
1982595 | 1982595 | 2021-12-05 | Yolo | California | 6113 | 21722 | 261 |
1982596 | 1982596 | 2021-12-05 | Yuba | California | 6115 | 11234 | 91 |
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);