ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-09-10" 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 |
---|---|---|---|---|---|---|---|
1703091 | 1703091 | 2021-09-10 | Alameda | California | 6001 | 113753 | 1321 |
1703092 | 1703092 | 2021-09-10 | Alpine | California | 6003 | 94 | 0 |
1703093 | 1703093 | 2021-09-10 | Amador | California | 6005 | 4742 | 56 |
1703094 | 1703094 | 2021-09-10 | Butte | California | 6007 | 19878 | 221 |
1703095 | 1703095 | 2021-09-10 | Calaveras | California | 6009 | 3188 | 65 |
1703096 | 1703096 | 2021-09-10 | Colusa | California | 6011 | 2834 | 18 |
1703097 | 1703097 | 2021-09-10 | Contra Costa | California | 6013 | 93567 | 906 |
1703098 | 1703098 | 2021-09-10 | Del Norte | California | 6015 | 3201 | 31 |
1703099 | 1703099 | 2021-09-10 | El Dorado | California | 6017 | 15337 | 122 |
1703100 | 1703100 | 2021-09-10 | Fresno | California | 6019 | 131662 | 1838 |
1703101 | 1703101 | 2021-09-10 | Glenn | California | 6021 | 3763 | 31 |
1703102 | 1703102 | 2021-09-10 | Humboldt | California | 6023 | 7781 | 81 |
1703103 | 1703103 | 2021-09-10 | Imperial | California | 6025 | 33708 | 750 |
1703104 | 1703104 | 2021-09-10 | Inyo | California | 6027 | 1595 | 39 |
1703105 | 1703105 | 2021-09-10 | Kern | California | 6029 | 130375 | 1496 |
1703106 | 1703106 | 2021-09-10 | Kings | California | 6031 | 28887 | 274 |
1703107 | 1703107 | 2021-09-10 | Lake | California | 6033 | 5716 | 79 |
1703108 | 1703108 | 2021-09-10 | Lassen | California | 6035 | 6577 | 31 |
1703109 | 1703109 | 2021-09-10 | Los Angeles | California | 6037 | 1428526 | 25611 |
1703110 | 1703110 | 2021-09-10 | Madera | California | 6039 | 20875 | 254 |
1703111 | 1703111 | 2021-09-10 | Marin | California | 6041 | 16803 | 242 |
1703112 | 1703112 | 2021-09-10 | Mariposa | California | 6043 | 889 | 10 |
1703113 | 1703113 | 2021-09-10 | Mendocino | California | 6045 | 6423 | 67 |
1703114 | 1703114 | 2021-09-10 | Merced | California | 6047 | 38304 | 527 |
1703115 | 1703115 | 2021-09-10 | Modoc | California | 6049 | 647 | 8 |
1703116 | 1703116 | 2021-09-10 | Mono | California | 6051 | 1461 | 5 |
1703117 | 1703117 | 2021-09-10 | Monterey | California | 6053 | 48725 | 562 |
1703118 | 1703118 | 2021-09-10 | Napa | California | 6055 | 11956 | 90 |
1703119 | 1703119 | 2021-09-10 | Nevada | California | 6057 | 8117 | 85 |
1703120 | 1703120 | 2021-09-10 | Orange | California | 6059 | 310195 | 5299 |
1703121 | 1703121 | 2021-09-10 | Placer | California | 6061 | 34981 | 342 |
1703122 | 1703122 | 2021-09-10 | Plumas | California | 6063 | 1123 | 6 |
1703123 | 1703123 | 2021-09-10 | Riverside | California | 6065 | 351053 | 4826 |
1703124 | 1703124 | 2021-09-10 | Sacramento | California | 6067 | 146129 | 2010 |
1703125 | 1703125 | 2021-09-10 | San Benito | California | 6069 | 6962 | 64 |
1703126 | 1703126 | 2021-09-10 | San Bernardino | California | 6071 | 341394 | 5417 |
1703127 | 1703127 | 2021-09-10 | San Diego | California | 6073 | 358984 | 3929 |
1703128 | 1703128 | 2021-09-10 | San Francisco | California | 6075 | 50786 | 597 |
1703129 | 1703129 | 2021-09-10 | San Joaquin | California | 6077 | 94607 | 1570 |
1703130 | 1703130 | 2021-09-10 | San Luis Obispo | California | 6079 | 27531 | 296 |
1703131 | 1703131 | 2021-09-10 | San Mateo | California | 6081 | 51247 | 603 |
1703132 | 1703132 | 2021-09-10 | Santa Barbara | California | 6083 | 41731 | 490 |
1703133 | 1703133 | 2021-09-10 | Santa Clara | California | 6085 | 138094 | 1817 |
1703134 | 1703134 | 2021-09-10 | Santa Cruz | California | 6087 | 19762 | 210 |
1703135 | 1703135 | 2021-09-10 | Shasta | California | 6089 | 18943 | 265 |
1703136 | 1703136 | 2021-09-10 | Sierra | California | 6091 | 130 | 0 |
1703137 | 1703137 | 2021-09-10 | Siskiyou | California | 6093 | 3766 | 43 |
1703138 | 1703138 | 2021-09-10 | Solano | California | 6095 | 43155 | 303 |
1703139 | 1703139 | 2021-09-10 | Sonoma | California | 6097 | 38642 | 368 |
1703140 | 1703140 | 2021-09-10 | Stanislaus | California | 6099 | 78021 | 1194 |
1703141 | 1703141 | 2021-09-10 | Sutter | California | 6101 | 12584 | 144 |
1703142 | 1703142 | 2021-09-10 | Tehama | California | 6103 | 7590 | 75 |
1703143 | 1703143 | 2021-09-10 | Trinity | California | 6105 | 667 | 6 |
1703144 | 1703144 | 2021-09-10 | Tulare | California | 6107 | 69723 | 880 |
1703145 | 1703145 | 2021-09-10 | Tuolumne | California | 6109 | 5996 | 96 |
1703146 | 1703146 | 2021-09-10 | Ventura | California | 6111 | 95771 | 1098 |
1703147 | 1703147 | 2021-09-10 | Yolo | California | 6113 | 18573 | 239 |
1703148 | 1703148 | 2021-09-10 | Yuba | California | 6115 | 9222 | 55 |
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);