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-02-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 |
---|---|---|---|---|---|---|---|
1021235 | 1021235 | 2021-02-12 | Alameda | California | 6001 | 77947 | 1088 |
1021236 | 1021236 | 2021-02-12 | Alpine | California | 6003 | 76 | 0 |
1021237 | 1021237 | 2021-02-12 | Amador | California | 6005 | 3367 | 37 |
1021238 | 1021238 | 2021-02-12 | Butte | California | 6007 | 10624 | 149 |
1021239 | 1021239 | 2021-02-12 | Calaveras | California | 6009 | 1856 | 25 |
1021240 | 1021240 | 2021-02-12 | Colusa | California | 6011 | 2069 | 11 |
1021241 | 1021241 | 2021-02-12 | Contra Costa | California | 6013 | 60142 | 610 |
1021242 | 1021242 | 2021-02-12 | Del Norte | California | 6015 | 922 | 4 |
1021243 | 1021243 | 2021-02-12 | El Dorado | California | 6017 | 8698 | 88 |
1021244 | 1021244 | 2021-02-12 | Fresno | California | 6019 | 92168 | 1291 |
1021245 | 1021245 | 2021-02-12 | Glenn | California | 6021 | 2615 | 23 |
1021246 | 1021246 | 2021-02-12 | Humboldt | California | 6023 | 3009 | 32 |
1021247 | 1021247 | 2021-02-12 | Imperial | California | 6025 | 26616 | 583 |
1021248 | 1021248 | 2021-02-12 | Inyo | California | 6027 | 1144 | 34 |
1021249 | 1021249 | 2021-02-12 | Kern | California | 6029 | 99570 | 677 |
1021250 | 1021250 | 2021-02-12 | Kings | California | 6031 | 21533 | 205 |
1021251 | 1021251 | 2021-02-12 | Lake | California | 6033 | 3002 | 36 |
1021252 | 1021252 | 2021-02-12 | Lassen | California | 6035 | 5498 | 19 |
1021253 | 1021253 | 2021-02-12 | Los Angeles | California | 6037 | 1162294 | 18789 |
1021254 | 1021254 | 2021-02-12 | Madera | California | 6039 | 14984 | 189 |
1021255 | 1021255 | 2021-02-12 | Marin | California | 6041 | 12682 | 182 |
1021256 | 1021256 | 2021-02-12 | Mariposa | California | 6043 | 386 | 5 |
1021257 | 1021257 | 2021-02-12 | Mendocino | California | 6045 | 3681 | 40 |
1021258 | 1021258 | 2021-02-12 | Merced | California | 6047 | 27701 | 375 |
1021259 | 1021259 | 2021-02-12 | Modoc | California | 6049 | 441 | 4 |
1021260 | 1021260 | 2021-02-12 | Mono | California | 6051 | 1173 | 4 |
1021261 | 1021261 | 2021-02-12 | Monterey | California | 6053 | 41246 | 303 |
1021262 | 1021262 | 2021-02-12 | Napa | California | 6055 | 8778 | 62 |
1021263 | 1021263 | 2021-02-12 | Nevada | California | 6057 | 3729 | 74 |
1021264 | 1021264 | 2021-02-12 | Orange | California | 6059 | 255254 | 3493 |
1021265 | 1021265 | 2021-02-12 | Placer | California | 6061 | 19175 | 222 |
1021266 | 1021266 | 2021-02-12 | Plumas | California | 6063 | 592 | 6 |
1021267 | 1021267 | 2021-02-12 | Riverside | California | 6065 | 285414 | 3524 |
1021268 | 1021268 | 2021-02-12 | Sacramento | California | 6067 | 89987 | 1372 |
1021269 | 1021269 | 2021-02-12 | San Benito | California | 6069 | 5609 | 57 |
1021270 | 1021270 | 2021-02-12 | San Bernardino | California | 6071 | 280949 | 2308 |
1021271 | 1021271 | 2021-02-12 | San Diego | California | 6073 | 250854 | 2979 |
1021272 | 1021272 | 2021-02-12 | San Francisco | California | 6075 | 33079 | 359 |
1021273 | 1021273 | 2021-02-12 | San Joaquin | California | 6077 | 64969 | 992 |
1021274 | 1021274 | 2021-02-12 | San Luis Obispo | California | 6079 | 18889 | 205 |
1021275 | 1021275 | 2021-02-12 | San Mateo | California | 6081 | 37548 | 474 |
1021276 | 1021276 | 2021-02-12 | Santa Barbara | California | 6083 | 30586 | 367 |
1021277 | 1021277 | 2021-02-12 | Santa Clara | California | 6085 | 106749 | 1644 |
1021278 | 1021278 | 2021-02-12 | Santa Cruz | California | 6087 | 14232 | 168 |
1021279 | 1021279 | 2021-02-12 | Shasta | California | 6089 | 10718 | 170 |
1021280 | 1021280 | 2021-02-12 | Sierra | California | 6091 | 45 | 0 |
1021281 | 1021281 | 2021-02-12 | Siskiyou | California | 6093 | 1664 | 13 |
1021282 | 1021282 | 2021-02-12 | Solano | California | 6095 | 29256 | 140 |
1021283 | 1021283 | 2021-02-12 | Sonoma | California | 6097 | 27133 | 287 |
1021284 | 1021284 | 2021-02-12 | Stanislaus | California | 6099 | 53842 | 894 |
1021285 | 1021285 | 2021-02-12 | Sutter | California | 6101 | 8656 | 93 |
1021286 | 1021286 | 2021-02-12 | Tehama | California | 6103 | 4463 | 48 |
1021287 | 1021287 | 2021-02-12 | Trinity | California | 6105 | 270 | 5 |
1021288 | 1021288 | 2021-02-12 | Tulare | California | 6107 | 45897 | 684 |
1021289 | 1021289 | 2021-02-12 | Tuolumne | California | 6109 | 3800 | 52 |
1021290 | 1021290 | 2021-02-12 | Ventura | California | 6111 | 74959 | 732 |
1021291 | 1021291 | 2021-02-12 | Yolo | California | 6113 | 12303 | 172 |
1021292 | 1021292 | 2021-02-12 | Yuba | California | 6115 | 5583 | 36 |
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);