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-04-02 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1180304 | 1180304 | 2021-04-02 | Alameda | California | 6001 | 83595 | 1425 |
1180305 | 1180305 | 2021-04-02 | Alpine | California | 6003 | 88 | 0 |
1180306 | 1180306 | 2021-04-02 | Amador | California | 6005 | 3557 | 45 |
1180307 | 1180307 | 2021-04-02 | Butte | California | 6007 | 11328 | 193 |
1180308 | 1180308 | 2021-04-02 | Calaveras | California | 6009 | 2006 | 51 |
1180309 | 1180309 | 2021-04-02 | Colusa | California | 6011 | 2165 | 16 |
1180310 | 1180310 | 2021-04-02 | Contra Costa | California | 6013 | 65559 | 771 |
1180311 | 1180311 | 2021-04-02 | Del Norte | California | 6015 | 1213 | 6 |
1180312 | 1180312 | 2021-04-02 | El Dorado | California | 6017 | 9393 | 108 |
1180313 | 1180313 | 2021-04-02 | Fresno | California | 6019 | 99317 | 1616 |
1180314 | 1180314 | 2021-04-02 | Glenn | California | 6021 | 2832 | 25 |
1180315 | 1180315 | 2021-04-02 | Humboldt | California | 6023 | 3492 | 36 |
1180316 | 1180316 | 2021-04-02 | Imperial | California | 6025 | 27520 | 711 |
1180317 | 1180317 | 2021-04-02 | Inyo | California | 6027 | 1374 | 36 |
1180318 | 1180318 | 2021-04-02 | Kern | California | 6029 | 106329 | 1277 |
1180319 | 1180319 | 2021-04-02 | Kings | California | 6031 | 22659 | 241 |
1180320 | 1180320 | 2021-04-02 | Lake | California | 6033 | 3337 | 43 |
1180321 | 1180321 | 2021-04-02 | Lassen | California | 6035 | 5652 | 24 |
1180322 | 1180322 | 2021-04-02 | Los Angeles | California | 6037 | 1221506 | 23235 |
1180323 | 1180323 | 2021-04-02 | Madera | California | 6039 | 16023 | 234 |
1180324 | 1180324 | 2021-04-02 | Marin | California | 6041 | 13635 | 221 |
1180325 | 1180325 | 2021-04-02 | Mariposa | California | 6043 | 410 | 7 |
1180326 | 1180326 | 2021-04-02 | Mendocino | California | 6045 | 3949 | 46 |
1180327 | 1180327 | 2021-04-02 | Merced | California | 6047 | 30687 | 439 |
1180328 | 1180328 | 2021-04-02 | Modoc | California | 6049 | 474 | 4 |
1180329 | 1180329 | 2021-04-02 | Mono | California | 6051 | 1245 | 4 |
1180330 | 1180330 | 2021-04-02 | Monterey | California | 6053 | 42979 | 342 |
1180331 | 1180331 | 2021-04-02 | Napa | California | 6055 | 9454 | 78 |
1180332 | 1180332 | 2021-04-02 | Nevada | California | 6057 | 4316 | 74 |
1180333 | 1180333 | 2021-04-02 | Orange | California | 6059 | 266464 | 4761 |
1180334 | 1180334 | 2021-04-02 | Placer | California | 6061 | 21095 | 276 |
1180335 | 1180335 | 2021-04-02 | Plumas | California | 6063 | 664 | 4 |
1180336 | 1180336 | 2021-04-02 | Riverside | California | 6065 | 294736 | 4362 |
1180337 | 1180337 | 2021-04-02 | Sacramento | California | 6067 | 98487 | 1613 |
1180338 | 1180338 | 2021-04-02 | San Benito | California | 6069 | 5878 | 61 |
1180339 | 1180339 | 2021-04-02 | San Bernardino | California | 6071 | 291199 | 4404 |
1180340 | 1180340 | 2021-04-02 | San Diego | California | 6073 | 271098 | 3568 |
1180341 | 1180341 | 2021-04-02 | San Francisco | California | 6075 | 35389 | 488 |
1180342 | 1180342 | 2021-04-02 | San Joaquin | California | 6077 | 70117 | 1310 |
1180343 | 1180343 | 2021-04-02 | San Luis Obispo | California | 6079 | 20547 | 256 |
1180344 | 1180344 | 2021-04-02 | San Mateo | California | 6081 | 40462 | 553 |
1180345 | 1180345 | 2021-04-02 | Santa Barbara | California | 6083 | 33270 | 443 |
1180346 | 1180346 | 2021-04-02 | Santa Clara | California | 6085 | 114852 | 1950 |
1180347 | 1180347 | 2021-04-02 | Santa Cruz | California | 6087 | 15363 | 202 |
1180348 | 1180348 | 2021-04-02 | Shasta | California | 6089 | 11381 | 207 |
1180349 | 1180349 | 2021-04-02 | Sierra | California | 6091 | 50 | 0 |
1180350 | 1180350 | 2021-04-02 | Siskiyou | California | 6093 | 1885 | 16 |
1180351 | 1180351 | 2021-04-02 | Solano | California | 6095 | 31306 | 237 |
1180352 | 1180352 | 2021-04-02 | Sonoma | California | 6097 | 29310 | 311 |
1180353 | 1180353 | 2021-04-02 | Stanislaus | California | 6099 | 59271 | 1003 |
1180354 | 1180354 | 2021-04-02 | Sutter | California | 6101 | 9175 | 106 |
1180355 | 1180355 | 2021-04-02 | Tehama | California | 6103 | 4764 | 52 |
1180356 | 1180356 | 2021-04-02 | Trinity | California | 6105 | 320 | 3 |
1180357 | 1180357 | 2021-04-02 | Tulare | California | 6107 | 49100 | 817 |
1180358 | 1180358 | 2021-04-02 | Tuolumne | California | 6109 | 4043 | 62 |
1180359 | 1180359 | 2021-04-02 | Ventura | California | 6111 | 79774 | 986 |
1180360 | 1180360 | 2021-04-02 | Yolo | California | 6113 | 13342 | 198 |
1180361 | 1180361 | 2021-04-02 | Yuba | California | 6115 | 6021 | 44 |
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);