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-08-11 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1605638 | 1605638 | 2021-08-11 | Alameda | California | 6001 | 102167 | 1296 |
1605639 | 1605639 | 2021-08-11 | Alpine | California | 6003 | 91 | 0 |
1605640 | 1605640 | 2021-08-11 | Amador | California | 6005 | 4128 | 49 |
1605641 | 1605641 | 2021-08-11 | Butte | California | 6007 | 15991 | 205 |
1605642 | 1605642 | 2021-08-11 | Calaveras | California | 6009 | 2509 | 58 |
1605643 | 1605643 | 2021-08-11 | Colusa | California | 6011 | 2459 | 18 |
1605644 | 1605644 | 2021-08-11 | Contra Costa | California | 6013 | 81603 | 841 |
1605645 | 1605645 | 2021-08-11 | Del Norte | California | 6015 | 1972 | 10 |
1605646 | 1605646 | 2021-08-11 | El Dorado | California | 6017 | 12690 | 121 |
1605647 | 1605647 | 2021-08-11 | Fresno | California | 6019 | 117294 | 1747 |
1605648 | 1605648 | 2021-08-11 | Glenn | California | 6021 | 3148 | 27 |
1605649 | 1605649 | 2021-08-11 | Humboldt | California | 6023 | 5894 | 57 |
1605650 | 1605650 | 2021-08-11 | Imperial | California | 6025 | 32440 | 744 |
1605651 | 1605651 | 2021-08-11 | Inyo | California | 6027 | 1498 | 39 |
1605652 | 1605652 | 2021-08-11 | Kern | California | 6029 | 116475 | 1433 |
1605653 | 1605653 | 2021-08-11 | Kings | California | 6031 | 25575 | 253 |
1605654 | 1605654 | 2021-08-11 | Lake | California | 6033 | 4713 | 67 |
1605655 | 1605655 | 2021-08-11 | Lassen | California | 6035 | 5970 | 26 |
1605656 | 1605656 | 2021-08-11 | Los Angeles | California | 6037 | 1336029 | 24833 |
1605657 | 1605657 | 2021-08-11 | Madera | California | 6039 | 18542 | 249 |
1605658 | 1605658 | 2021-08-11 | Marin | California | 6041 | 15497 | 239 |
1605659 | 1605659 | 2021-08-11 | Mariposa | California | 6043 | 601 | 7 |
1605660 | 1605660 | 2021-08-11 | Mendocino | California | 6045 | 5077 | 54 |
1605661 | 1605661 | 2021-08-11 | Merced | California | 6047 | 33785 | 488 |
1605662 | 1605662 | 2021-08-11 | Modoc | California | 6049 | 577 | 7 |
1605663 | 1605663 | 2021-08-11 | Mono | California | 6051 | 1363 | 5 |
1605664 | 1605664 | 2021-08-11 | Monterey | California | 6053 | 46333 | 530 |
1605665 | 1605665 | 2021-08-11 | Napa | California | 6055 | 10757 | 83 |
1605666 | 1605666 | 2021-08-11 | Nevada | California | 6057 | 6368 | 76 |
1605667 | 1605667 | 2021-08-11 | Orange | California | 6059 | 291283 | 5155 |
1605668 | 1605668 | 2021-08-11 | Placer | California | 6061 | 28594 | 307 |
1605669 | 1605669 | 2021-08-11 | Plumas | California | 6063 | 831 | 6 |
1605670 | 1605670 | 2021-08-11 | Riverside | California | 6065 | 325097 | 4674 |
1605671 | 1605671 | 2021-08-11 | Sacramento | California | 6067 | 123588 | 1808 |
1605672 | 1605672 | 2021-08-11 | San Benito | California | 6069 | 6492 | 64 |
1605673 | 1605673 | 2021-08-11 | San Bernardino | California | 6071 | 318417 | 5295 |
1605674 | 1605674 | 2021-08-11 | San Diego | California | 6073 | 325123 | 3815 |
1605675 | 1605675 | 2021-08-11 | San Francisco | California | 6075 | 45150 | 564 |
1605676 | 1605676 | 2021-08-11 | San Joaquin | California | 6077 | 83611 | 1491 |
1605677 | 1605677 | 2021-08-11 | San Luis Obispo | California | 6079 | 23647 | 269 |
1605678 | 1605678 | 2021-08-11 | San Mateo | California | 6081 | 46810 | 588 |
1605679 | 1605679 | 2021-08-11 | Santa Barbara | California | 6083 | 38000 | 472 |
1605680 | 1605680 | 2021-08-11 | Santa Clara | California | 6085 | 126944 | 1771 |
1605681 | 1605681 | 2021-08-11 | Santa Cruz | California | 6087 | 18029 | 209 |
1605682 | 1605682 | 2021-08-11 | Shasta | California | 6089 | 15481 | 244 |
1605683 | 1605683 | 2021-08-11 | Sierra | California | 6091 | 90 | 0 |
1605684 | 1605684 | 2021-08-11 | Siskiyou | California | 6093 | 2735 | 40 |
1605685 | 1605685 | 2021-08-11 | Solano | California | 6095 | 37536 | 262 |
1605686 | 1605686 | 2021-08-11 | Sonoma | California | 6097 | 34474 | 337 |
1605687 | 1605687 | 2021-08-11 | Stanislaus | California | 6099 | 68119 | 1102 |
1605688 | 1605688 | 2021-08-11 | Sutter | California | 6101 | 10681 | 130 |
1605689 | 1605689 | 2021-08-11 | Tehama | California | 6103 | 6070 | 66 |
1605690 | 1605690 | 2021-08-11 | Trinity | California | 6105 | 460 | 3 |
1605691 | 1605691 | 2021-08-11 | Tulare | California | 6107 | 61738 | 854 |
1605692 | 1605692 | 2021-08-11 | Tuolumne | California | 6109 | 4978 | 74 |
1605693 | 1605693 | 2021-08-11 | Ventura | California | 6111 | 89451 | 1051 |
1605694 | 1605694 | 2021-08-11 | Yolo | California | 6113 | 16094 | 218 |
1605695 | 1605695 | 2021-08-11 | Yuba | California | 6115 | 7448 | 50 |
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);