ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45,693 rows where state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 160
- Los Angeles 159
- Santa Clara 154
- San Francisco 152
- San Diego 144
- Humboldt 134
- Sacramento 133
- Solano 130
- Marin 128
- Napa 128
- Sonoma 128
- Alameda 124
- Placer 123
- San Mateo 123
- Contra Costa 122
- Yolo 119
- Fresno 118
- Madera 118
- Riverside 118
- Santa Cruz 118
- Shasta 116
- San Joaquin 115
- Ventura 115
- Stanislaus 114
- Tulare 113
- San Benito 112
- San Luis Obispo 111
- San Bernardino 110
- Santa Barbara 110
- Nevada 109
- …
state 1
- California · 6,271 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293566 | 293566 | 2020-07-02 | Alameda | California | 6001 | 6405 | 138 |
293567 | 293567 | 2020-07-02 | Alpine | California | 6003 | 1 | 0 |
293568 | 293568 | 2020-07-02 | Amador | California | 6005 | 24 | 0 |
293569 | 293569 | 2020-07-02 | Butte | California | 6007 | 206 | 3 |
293570 | 293570 | 2020-07-02 | Calaveras | California | 6009 | 53 | 0 |
293571 | 293571 | 2020-07-02 | Colusa | California | 6011 | 70 | 0 |
293572 | 293572 | 2020-07-02 | Contra Costa | California | 6013 | 3326 | 78 |
293573 | 293573 | 2020-07-02 | Del Norte | California | 6015 | 51 | 0 |
293574 | 293574 | 2020-07-02 | El Dorado | California | 6017 | 198 | 0 |
293575 | 293575 | 2020-07-02 | Fresno | California | 6019 | 5626 | 77 |
293576 | 293576 | 2020-07-02 | Glenn | California | 6021 | 122 | 0 |
293577 | 293577 | 2020-07-02 | Humboldt | California | 6023 | 138 | 4 |
293578 | 293578 | 2020-07-02 | Imperial | California | 6025 | 6824 | 99 |
293579 | 293579 | 2020-07-02 | Inyo | California | 6027 | 30 | 1 |
293580 | 293580 | 2020-07-02 | Kern | California | 6029 | 4949 | 77 |
293581 | 293581 | 2020-07-02 | Kings | California | 6031 | 2583 | 32 |
293582 | 293582 | 2020-07-02 | Lake | California | 6033 | 87 | 0 |
293583 | 293583 | 2020-07-02 | Lassen | California | 6035 | 234 | 0 |
293584 | 293584 | 2020-07-02 | Los Angeles | California | 6037 | 107667 | 3454 |
293585 | 293585 | 2020-07-02 | Madera | California | 6039 | 566 | 5 |
293586 | 293586 | 2020-07-02 | Marin | California | 6041 | 2446 | 19 |
293587 | 293587 | 2020-07-02 | Mariposa | California | 6043 | 29 | 1 |
293588 | 293588 | 2020-07-02 | Mendocino | California | 6045 | 85 | 0 |
293589 | 293589 | 2020-07-02 | Merced | California | 6047 | 1208 | 11 |
293590 | 293590 | 2020-07-02 | Mono | California | 6051 | 41 | 1 |
293591 | 293591 | 2020-07-02 | Monterey | California | 6053 | 1748 | 15 |
293592 | 293592 | 2020-07-02 | Napa | California | 6055 | 348 | 4 |
293593 | 293593 | 2020-07-02 | Nevada | California | 6057 | 123 | 1 |
293594 | 293594 | 2020-07-02 | Orange | California | 6059 | 15662 | 354 |
293595 | 293595 | 2020-07-02 | Placer | California | 6061 | 754 | 11 |
293596 | 293596 | 2020-07-02 | Plumas | California | 6063 | 8 | 0 |
293597 | 293597 | 2020-07-02 | Riverside | California | 6065 | 19537 | 465 |
293598 | 293598 | 2020-07-02 | Sacramento | California | 6067 | 3558 | 69 |
293599 | 293599 | 2020-07-02 | San Benito | California | 6069 | 257 | 2 |
293600 | 293600 | 2020-07-02 | San Bernardino | California | 6071 | 13152 | 265 |
293601 | 293601 | 2020-07-02 | San Diego | California | 6073 | 15270 | 377 |
293602 | 293602 | 2020-07-02 | San Francisco | California | 6075 | 3722 | 50 |
293603 | 293603 | 2020-07-02 | San Joaquin | California | 6077 | 4298 | 55 |
293604 | 293604 | 2020-07-02 | San Luis Obispo | California | 6079 | 675 | 2 |
293605 | 293605 | 2020-07-02 | San Mateo | California | 6081 | 3376 | 108 |
293606 | 293606 | 2020-07-02 | Santa Barbara | California | 6083 | 3268 | 29 |
293607 | 293607 | 2020-07-02 | Santa Clara | California | 6085 | 4750 | 160 |
293608 | 293608 | 2020-07-02 | Santa Cruz | California | 6087 | 410 | 3 |
293609 | 293609 | 2020-07-02 | Shasta | California | 6089 | 135 | 5 |
293610 | 293610 | 2020-07-02 | Sierra | California | 6091 | 1 | 0 |
293611 | 293611 | 2020-07-02 | Siskiyou | California | 6093 | 31 | 0 |
293612 | 293612 | 2020-07-02 | Solano | California | 6095 | 1481 | 25 |
293613 | 293613 | 2020-07-02 | Sonoma | California | 6097 | 1267 | 10 |
293614 | 293614 | 2020-07-02 | Stanislaus | California | 6099 | 2619 | 44 |
293615 | 293615 | 2020-07-02 | Sutter | California | 6101 | 206 | 3 |
293616 | 293616 | 2020-07-02 | Tehama | California | 6103 | 80 | 1 |
293617 | 293617 | 2020-07-02 | Trinity | California | 6105 | 3 | 0 |
293618 | 293618 | 2020-07-02 | Tulare | California | 6107 | 4521 | 133 |
293619 | 293619 | 2020-07-02 | Tuolumne | California | 6109 | 43 | 0 |
293620 | 293620 | 2020-07-02 | Ventura | California | 6111 | 3240 | 47 |
293621 | 293621 | 2020-07-02 | Yolo | California | 6113 | 583 | 24 |
293622 | 293622 | 2020-07-02 | Yuba | California | 6115 | 103 | 1 |
290412 | 290412 | 2020-07-01 | Alameda | California | 6001 | 6177 | 136 |
290413 | 290413 | 2020-07-01 | Alpine | California | 6003 | 1 | 0 |
290414 | 290414 | 2020-07-01 | Amador | California | 6005 | 22 | 0 |
290415 | 290415 | 2020-07-01 | Butte | California | 6007 | 189 | 2 |
290416 | 290416 | 2020-07-01 | Calaveras | California | 6009 | 40 | 0 |
290417 | 290417 | 2020-07-01 | Colusa | California | 6011 | 59 | 0 |
290418 | 290418 | 2020-07-01 | Contra Costa | California | 6013 | 3248 | 77 |
290419 | 290419 | 2020-07-01 | Del Norte | California | 6015 | 51 | 0 |
290420 | 290420 | 2020-07-01 | El Dorado | California | 6017 | 184 | 0 |
290421 | 290421 | 2020-07-01 | Fresno | California | 6019 | 5289 | 75 |
290422 | 290422 | 2020-07-01 | Glenn | California | 6021 | 112 | 0 |
290423 | 290423 | 2020-07-01 | Humboldt | California | 6023 | 136 | 4 |
290424 | 290424 | 2020-07-01 | Imperial | California | 6025 | 6523 | 96 |
290425 | 290425 | 2020-07-01 | Inyo | California | 6027 | 30 | 1 |
290426 | 290426 | 2020-07-01 | Kern | California | 6029 | 4778 | 76 |
290427 | 290427 | 2020-07-01 | Kings | California | 6031 | 2504 | 32 |
290428 | 290428 | 2020-07-01 | Lake | California | 6033 | 81 | 0 |
290429 | 290429 | 2020-07-01 | Lassen | California | 6035 | 233 | 0 |
290430 | 290430 | 2020-07-01 | Los Angeles | California | 6037 | 105507 | 3402 |
290431 | 290431 | 2020-07-01 | Madera | California | 6039 | 541 | 5 |
290432 | 290432 | 2020-07-01 | Marin | California | 6041 | 2394 | 19 |
290433 | 290433 | 2020-07-01 | Mariposa | California | 6043 | 27 | 1 |
290434 | 290434 | 2020-07-01 | Mendocino | California | 6045 | 85 | 0 |
290435 | 290435 | 2020-07-01 | Merced | California | 6047 | 1131 | 11 |
290436 | 290436 | 2020-07-01 | Mono | California | 6051 | 41 | 1 |
290437 | 290437 | 2020-07-01 | Monterey | California | 6053 | 1691 | 15 |
290438 | 290438 | 2020-07-01 | Napa | California | 6055 | 343 | 4 |
290439 | 290439 | 2020-07-01 | Nevada | California | 6057 | 117 | 1 |
290440 | 290440 | 2020-07-01 | Orange | California | 6059 | 14413 | 345 |
290441 | 290441 | 2020-07-01 | Placer | California | 6061 | 724 | 11 |
290442 | 290442 | 2020-07-01 | Plumas | California | 6063 | 8 | 0 |
290443 | 290443 | 2020-07-01 | Riverside | California | 6065 | 18656 | 463 |
290444 | 290444 | 2020-07-01 | Sacramento | California | 6067 | 3396 | 68 |
290445 | 290445 | 2020-07-01 | San Benito | California | 6069 | 239 | 2 |
290446 | 290446 | 2020-07-01 | San Bernardino | California | 6071 | 12746 | 258 |
290447 | 290447 | 2020-07-01 | San Diego | California | 6073 | 14686 | 372 |
290448 | 290448 | 2020-07-01 | San Francisco | California | 6075 | 3651 | 50 |
290449 | 290449 | 2020-07-01 | San Joaquin | California | 6077 | 3914 | 54 |
290450 | 290450 | 2020-07-01 | San Luis Obispo | California | 6079 | 642 | 2 |
290451 | 290451 | 2020-07-01 | San Mateo | California | 6081 | 3268 | 108 |
290452 | 290452 | 2020-07-01 | Santa Barbara | California | 6083 | 3164 | 29 |
290453 | 290453 | 2020-07-01 | Santa Clara | California | 6085 | 4572 | 159 |
290454 | 290454 | 2020-07-01 | Santa Cruz | California | 6087 | 399 | 3 |
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);