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-07 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1592642 | 1592642 | 2021-08-07 | Alameda | California | 6001 | 100448 | 1291 |
1592643 | 1592643 | 2021-08-07 | Alpine | California | 6003 | 91 | 0 |
1592644 | 1592644 | 2021-08-07 | Amador | California | 6005 | 4027 | 48 |
1592645 | 1592645 | 2021-08-07 | Butte | California | 6007 | 15702 | 206 |
1592646 | 1592646 | 2021-08-07 | Calaveras | California | 6009 | 2415 | 58 |
1592647 | 1592647 | 2021-08-07 | Colusa | California | 6011 | 2402 | 18 |
1592648 | 1592648 | 2021-08-07 | Contra Costa | California | 6013 | 80099 | 840 |
1592649 | 1592649 | 2021-08-07 | Del Norte | California | 6015 | 1799 | 10 |
1592650 | 1592650 | 2021-08-07 | El Dorado | California | 6017 | 12364 | 121 |
1592651 | 1592651 | 2021-08-07 | Fresno | California | 6019 | 115897 | 1747 |
1592652 | 1592652 | 2021-08-07 | Glenn | California | 6021 | 3104 | 27 |
1592653 | 1592653 | 2021-08-07 | Humboldt | California | 6023 | 5504 | 56 |
1592654 | 1592654 | 2021-08-07 | Imperial | California | 6025 | 32301 | 744 |
1592655 | 1592655 | 2021-08-07 | Inyo | California | 6027 | 1482 | 38 |
1592656 | 1592656 | 2021-08-07 | Kern | California | 6029 | 115007 | 1429 |
1592657 | 1592657 | 2021-08-07 | Kings | California | 6031 | 25229 | 252 |
1592658 | 1592658 | 2021-08-07 | Lake | California | 6033 | 4503 | 66 |
1592659 | 1592659 | 2021-08-07 | Lassen | California | 6035 | 5935 | 26 |
1592660 | 1592660 | 2021-08-07 | Los Angeles | California | 6037 | 1324042 | 24769 |
1592661 | 1592661 | 2021-08-07 | Madera | California | 6039 | 18362 | 249 |
1592662 | 1592662 | 2021-08-07 | Marin | California | 6041 | 15308 | 239 |
1592663 | 1592663 | 2021-08-07 | Mariposa | California | 6043 | 559 | 7 |
1592664 | 1592664 | 2021-08-07 | Mendocino | California | 6045 | 4892 | 52 |
1592665 | 1592665 | 2021-08-07 | Merced | California | 6047 | 33761 | 488 |
1592666 | 1592666 | 2021-08-07 | Modoc | California | 6049 | 577 | 7 |
1592667 | 1592667 | 2021-08-07 | Mono | California | 6051 | 1339 | 5 |
1592668 | 1592668 | 2021-08-07 | Monterey | California | 6053 | 46066 | 530 |
1592669 | 1592669 | 2021-08-07 | Napa | California | 6055 | 10645 | 83 |
1592670 | 1592670 | 2021-08-07 | Nevada | California | 6057 | 5995 | 75 |
1592671 | 1592671 | 2021-08-07 | Orange | California | 6059 | 287661 | 5149 |
1592672 | 1592672 | 2021-08-07 | Placer | California | 6061 | 27998 | 307 |
1592673 | 1592673 | 2021-08-07 | Plumas | California | 6063 | 802 | 6 |
1592674 | 1592674 | 2021-08-07 | Riverside | California | 6065 | 320983 | 4667 |
1592675 | 1592675 | 2021-08-07 | Sacramento | California | 6067 | 121019 | 1797 |
1592676 | 1592676 | 2021-08-07 | San Benito | California | 6069 | 6426 | 63 |
1592677 | 1592677 | 2021-08-07 | San Bernardino | California | 6071 | 314701 | 5284 |
1592678 | 1592678 | 2021-08-07 | San Diego | California | 6073 | 319055 | 3806 |
1592679 | 1592679 | 2021-08-07 | San Francisco | California | 6075 | 44062 | 564 |
1592680 | 1592680 | 2021-08-07 | San Joaquin | California | 6077 | 82371 | 1474 |
1592681 | 1592681 | 2021-08-07 | San Luis Obispo | California | 6079 | 23233 | 267 |
1592682 | 1592682 | 2021-08-07 | San Mateo | California | 6081 | 46180 | 588 |
1592683 | 1592683 | 2021-08-07 | Santa Barbara | California | 6083 | 37538 | 470 |
1592684 | 1592684 | 2021-08-07 | Santa Clara | California | 6085 | 125415 | 2186 |
1592685 | 1592685 | 2021-08-07 | Santa Cruz | California | 6087 | 17754 | 207 |
1592686 | 1592686 | 2021-08-07 | Shasta | California | 6089 | 15237 | 243 |
1592687 | 1592687 | 2021-08-07 | Sierra | California | 6091 | 87 | 0 |
1592688 | 1592688 | 2021-08-07 | Siskiyou | California | 6093 | 2634 | 40 |
1592689 | 1592689 | 2021-08-07 | Solano | California | 6095 | 37019 | 262 |
1592690 | 1592690 | 2021-08-07 | Sonoma | California | 6097 | 33875 | 334 |
1592691 | 1592691 | 2021-08-07 | Stanislaus | California | 6099 | 67115 | 1099 |
1592692 | 1592692 | 2021-08-07 | Sutter | California | 6101 | 10459 | 127 |
1592693 | 1592693 | 2021-08-07 | Tehama | California | 6103 | 5983 | 66 |
1592694 | 1592694 | 2021-08-07 | Trinity | California | 6105 | 443 | 3 |
1592695 | 1592695 | 2021-08-07 | Tulare | California | 6107 | 61237 | 854 |
1592696 | 1592696 | 2021-08-07 | Tuolumne | California | 6109 | 4817 | 73 |
1592697 | 1592697 | 2021-08-07 | Ventura | California | 6111 | 88574 | 1047 |
1592698 | 1592698 | 2021-08-07 | Yolo | California | 6113 | 15776 | 218 |
1592699 | 1592699 | 2021-08-07 | Yuba | California | 6115 | 7213 | 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);