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 2021-10-26 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1852543 | 1852543 | 2021-10-26 | Alameda | California | 6001 | 121216 | 1418 |
1852544 | 1852544 | 2021-10-26 | Alpine | California | 6003 | 105 | 0 |
1852545 | 1852545 | 2021-10-26 | Amador | California | 6005 | 5515 | 64 |
1852546 | 1852546 | 2021-10-26 | Butte | California | 6007 | 24048 | 273 |
1852547 | 1852547 | 2021-10-26 | Calaveras | California | 6009 | 3991 | 82 |
1852548 | 1852548 | 2021-10-26 | Colusa | California | 6011 | 3089 | 18 |
1852549 | 1852549 | 2021-10-26 | Contra Costa | California | 6013 | 100430 | 1017 |
1852550 | 1852550 | 2021-10-26 | Del Norte | California | 6015 | 3703 | 42 |
1852551 | 1852551 | 2021-10-26 | El Dorado | California | 6017 | 17330 | 149 |
1852552 | 1852552 | 2021-10-26 | Fresno | California | 6019 | 147826 | 2112 |
1852553 | 1852553 | 2021-10-26 | Glenn | California | 6021 | 4406 | 42 |
1852554 | 1852554 | 2021-10-26 | Humboldt | California | 6023 | 9341 | 109 |
1852555 | 1852555 | 2021-10-26 | Imperial | California | 6025 | 36262 | 765 |
1852556 | 1852556 | 2021-10-26 | Inyo | California | 6027 | 2217 | 41 |
1852557 | 1852557 | 2021-10-26 | Kern | California | 6029 | 147784 | 1652 |
1852558 | 1852558 | 2021-10-26 | Kings | California | 6031 | 33325 | 335 |
1852559 | 1852559 | 2021-10-26 | Lake | California | 6033 | 6701 | 105 |
1852560 | 1852560 | 2021-10-26 | Lassen | California | 6035 | 7543 | 50 |
1852561 | 1852561 | 2021-10-26 | Los Angeles | California | 6037 | 1487318 | 26579 |
1852562 | 1852562 | 2021-10-26 | Madera | California | 6039 | 24218 | 285 |
1852563 | 1852563 | 2021-10-26 | Marin | California | 6041 | 17776 | 244 |
1852564 | 1852564 | 2021-10-26 | Mariposa | California | 6043 | 1373 | 17 |
1852565 | 1852565 | 2021-10-26 | Mendocino | California | 6045 | 7743 | 88 |
1852566 | 1852566 | 2021-10-26 | Merced | California | 6047 | 43167 | 588 |
1852567 | 1852567 | 2021-10-26 | Modoc | California | 6049 | 804 | 9 |
1852568 | 1852568 | 2021-10-26 | Mono | California | 6051 | 1694 | 3 |
1852569 | 1852569 | 2021-10-26 | Monterey | California | 6053 | 51002 | 592 |
1852570 | 1852570 | 2021-10-26 | Napa | California | 6055 | 12951 | 100 |
1852571 | 1852571 | 2021-10-26 | Nevada | California | 6057 | 9264 | 90 |
1852572 | 1852572 | 2021-10-26 | Orange | California | 6059 | 325252 | 5584 |
1852573 | 1852573 | 2021-10-26 | Placer | California | 6061 | 39766 | 431 |
1852574 | 1852574 | 2021-10-26 | Plumas | California | 6063 | 1678 | 7 |
1852575 | 1852575 | 2021-10-26 | Riverside | California | 6065 | 373363 | 5156 |
1852576 | 1852576 | 2021-10-26 | Sacramento | California | 6067 | 161026 | 2322 |
1852577 | 1852577 | 2021-10-26 | San Benito | California | 6069 | 7483 | 71 |
1852578 | 1852578 | 2021-10-26 | San Bernardino | California | 6071 | 360071 | 5754 |
1852579 | 1852579 | 2021-10-26 | San Diego | California | 6073 | 385221 | 4196 |
1852580 | 1852580 | 2021-10-26 | San Francisco | California | 6075 | 54664 | 649 |
1852581 | 1852581 | 2021-10-26 | San Joaquin | California | 6077 | 103316 | 1745 |
1852582 | 1852582 | 2021-10-26 | San Luis Obispo | California | 6079 | 30125 | 339 |
1852583 | 1852583 | 2021-10-26 | San Mateo | California | 6081 | 54376 | 623 |
1852584 | 1852584 | 2021-10-26 | Santa Barbara | California | 6083 | 45446 | 525 |
1852585 | 1852585 | 2021-10-26 | Santa Clara | California | 6085 | 146162 | 1902 |
1852586 | 1852586 | 2021-10-26 | Santa Cruz | California | 6087 | 21120 | 221 |
1852587 | 1852587 | 2021-10-26 | Shasta | California | 6089 | 24204 | 354 |
1852588 | 1852588 | 2021-10-26 | Sierra | California | 6091 | 188 | 0 |
1852589 | 1852589 | 2021-10-26 | Siskiyou | California | 6093 | 4687 | 64 |
1852590 | 1852590 | 2021-10-26 | Solano | California | 6095 | 46229 | 344 |
1852591 | 1852591 | 2021-10-26 | Sonoma | California | 6097 | 41267 | 404 |
1852592 | 1852592 | 2021-10-26 | Stanislaus | California | 6099 | 86874 | 1341 |
1852593 | 1852593 | 2021-10-26 | Sutter | California | 6101 | 14042 | 176 |
1852594 | 1852594 | 2021-10-26 | Tehama | California | 6103 | 9653 | 111 |
1852595 | 1852595 | 2021-10-26 | Trinity | California | 6105 | 884 | 11 |
1852596 | 1852596 | 2021-10-26 | Tulare | California | 6107 | 81147 | 986 |
1852597 | 1852597 | 2021-10-26 | Tuolumne | California | 6109 | 7178 | 118 |
1852598 | 1852598 | 2021-10-26 | Ventura | California | 6111 | 101306 | 1167 |
1852599 | 1852599 | 2021-10-26 | Yolo | California | 6113 | 20574 | 248 |
1852600 | 1852600 | 2021-10-26 | Yuba | California | 6115 | 10592 | 82 |
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);