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-12 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1807055 | 1807055 | 2021-10-12 | Alameda | California | 6001 | 119617 | 1358 |
1807056 | 1807056 | 2021-10-12 | Alpine | California | 6003 | 102 | 0 |
1807057 | 1807057 | 2021-10-12 | Amador | California | 6005 | 5344 | 62 |
1807058 | 1807058 | 2021-10-12 | Butte | California | 6007 | 23075 | 253 |
1807059 | 1807059 | 2021-10-12 | Calaveras | California | 6009 | 3795 | 75 |
1807060 | 1807060 | 2021-10-12 | Colusa | California | 6011 | 3001 | 18 |
1807061 | 1807061 | 2021-10-12 | Contra Costa | California | 6013 | 98924 | 960 |
1807062 | 1807062 | 2021-10-12 | Del Norte | California | 6015 | 3647 | 39 |
1807063 | 1807063 | 2021-10-12 | El Dorado | California | 6017 | 16888 | 146 |
1807064 | 1807064 | 2021-10-12 | Fresno | California | 6019 | 143220 | 2036 |
1807065 | 1807065 | 2021-10-12 | Glenn | California | 6021 | 4259 | 39 |
1807066 | 1807066 | 2021-10-12 | Humboldt | California | 6023 | 9026 | 106 |
1807067 | 1807067 | 2021-10-12 | Imperial | California | 6025 | 35443 | 761 |
1807068 | 1807068 | 2021-10-12 | Inyo | California | 6027 | 1891 | 39 |
1807069 | 1807069 | 2021-10-12 | Kern | California | 6029 | 142932 | 1596 |
1807070 | 1807070 | 2021-10-12 | Kings | California | 6031 | 32073 | 309 |
1807071 | 1807071 | 2021-10-12 | Lake | California | 6033 | 6489 | 97 |
1807072 | 1807072 | 2021-10-12 | Lassen | California | 6035 | 7318 | 43 |
1807073 | 1807073 | 2021-10-12 | Los Angeles | California | 6037 | 1473123 | 26346 |
1807074 | 1807074 | 2021-10-12 | Madera | California | 6039 | 23300 | 275 |
1807075 | 1807075 | 2021-10-12 | Marin | California | 6041 | 17546 | 242 |
1807076 | 1807076 | 2021-10-12 | Mariposa | California | 6043 | 1223 | 15 |
1807077 | 1807077 | 2021-10-12 | Mendocino | California | 6045 | 7467 | 86 |
1807078 | 1807078 | 2021-10-12 | Merced | California | 6047 | 41855 | 571 |
1807079 | 1807079 | 2021-10-12 | Modoc | California | 6049 | 763 | 8 |
1807080 | 1807080 | 2021-10-12 | Mono | California | 6051 | 1620 | 5 |
1807081 | 1807081 | 2021-10-12 | Monterey | California | 6053 | 50579 | 586 |
1807082 | 1807082 | 2021-10-12 | Napa | California | 6055 | 12752 | 96 |
1807083 | 1807083 | 2021-10-12 | Nevada | California | 6057 | 9004 | 90 |
1807084 | 1807084 | 2021-10-12 | Orange | California | 6059 | 322084 | 5504 |
1807085 | 1807085 | 2021-10-12 | Placer | California | 6061 | 38673 | 404 |
1807086 | 1807086 | 2021-10-12 | Plumas | California | 6063 | 1499 | 6 |
1807087 | 1807087 | 2021-10-12 | Riverside | California | 6065 | 368263 | 5063 |
1807088 | 1807088 | 2021-10-12 | Sacramento | California | 6067 | 156888 | 2245 |
1807089 | 1807089 | 2021-10-12 | San Benito | California | 6069 | 7341 | 71 |
1807090 | 1807090 | 2021-10-12 | San Bernardino | California | 6071 | 355472 | 5557 |
1807091 | 1807091 | 2021-10-12 | San Diego | California | 6073 | 378547 | 4124 |
1807092 | 1807092 | 2021-10-12 | San Francisco | California | 6075 | 53834 | 643 |
1807093 | 1807093 | 2021-10-12 | San Joaquin | California | 6077 | 101376 | 1687 |
1807094 | 1807094 | 2021-10-12 | San Luis Obispo | California | 6079 | 29538 | 331 |
1807095 | 1807095 | 2021-10-12 | San Mateo | California | 6081 | 53694 | 618 |
1807096 | 1807096 | 2021-10-12 | Santa Barbara | California | 6083 | 44662 | 515 |
1807097 | 1807097 | 2021-10-12 | Santa Clara | California | 6085 | 144036 | 1883 |
1807098 | 1807098 | 2021-10-12 | Santa Cruz | California | 6087 | 20807 | 217 |
1807099 | 1807099 | 2021-10-12 | Shasta | California | 6089 | 23014 | 329 |
1807100 | 1807100 | 2021-10-12 | Sierra | California | 6091 | 163 | 0 |
1807101 | 1807101 | 2021-10-12 | Siskiyou | California | 6093 | 4546 | 56 |
1807102 | 1807102 | 2021-10-12 | Solano | California | 6095 | 45644 | 329 |
1807103 | 1807103 | 2021-10-12 | Sonoma | California | 6097 | 40575 | 398 |
1807104 | 1807104 | 2021-10-12 | Stanislaus | California | 6099 | 84566 | 1302 |
1807105 | 1807105 | 2021-10-12 | Sutter | California | 6101 | 13712 | 165 |
1807106 | 1807106 | 2021-10-12 | Tehama | California | 6103 | 9131 | 102 |
1807107 | 1807107 | 2021-10-12 | Trinity | California | 6105 | 853 | 11 |
1807108 | 1807108 | 2021-10-12 | Tulare | California | 6107 | 78224 | 942 |
1807109 | 1807109 | 2021-10-12 | Tuolumne | California | 6109 | 6823 | 106 |
1807110 | 1807110 | 2021-10-12 | Ventura | California | 6111 | 100191 | 1160 |
1807111 | 1807111 | 2021-10-12 | Yolo | California | 6113 | 20018 | 247 |
1807112 | 1807112 | 2021-10-12 | Yuba | California | 6115 | 10265 | 71 |
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);