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 2020-12-31 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 58
- 6001 1
- 6003 1
- 6005 1
- 6007 1
- 6009 1
- 6011 1
- 6013 1
- 6015 1
- 6017 1
- 6019 1
- 6021 1
- 6023 1
- 6025 1
- 6027 1
- 6029 1
- 6031 1
- 6033 1
- 6035 1
- 6037 1
- 6039 1
- 6041 1
- 6043 1
- 6045 1
- 6047 1
- 6049 1
- 6051 1
- 6053 1
- 6055 1
- 6057 1
- 6059 1
- 6061 1
- 6063 1
- 6065 1
- 6067 1
- 6069 1
- 6071 1
- 6073 1
- 6075 1
- 6077 1
- 6079 1
- 6081 1
- 6083 1
- 6085 1
- 6087 1
- 6089 1
- 6091 1
- 6093 1
- 6095 1
- 6097 1
- 6099 1
- 6101 1
- 6103 1
- 6105 1
- 6107 1
- 6109 1
- 6111 1
- 6113 1
- 6115 1
county 58
- Alameda 1
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Modoc 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
state 1
- California · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
881679 | 881679 | 2020-12-31 | Alameda | California | 6001 | 51611 | 657 |
881680 | 881680 | 2020-12-31 | Alpine | California | 6003 | 65 | 0 |
881681 | 881681 | 2020-12-31 | Amador | California | 6005 | 2417 | 24 |
881682 | 881682 | 2020-12-31 | Butte | California | 6007 | 7390 | 96 |
881683 | 881683 | 2020-12-31 | Calaveras | California | 6009 | 1131 | 22 |
881684 | 881684 | 2020-12-31 | Colusa | California | 6011 | 1351 | 8 |
881685 | 881685 | 2020-12-31 | Contra Costa | California | 6013 | 40697 | 335 |
881686 | 881686 | 2020-12-31 | Del Norte | California | 6015 | 760 | 2 |
881687 | 881687 | 2020-12-31 | El Dorado | California | 6017 | 5590 | 22 |
881688 | 881688 | 2020-12-31 | Fresno | California | 6019 | 65400 | 646 |
881689 | 881689 | 2020-12-31 | Glenn | California | 6021 | 1458 | 14 |
881690 | 881690 | 2020-12-31 | Humboldt | California | 6023 | 1764 | 22 |
881691 | 881691 | 2020-12-31 | Imperial | California | 6025 | 22267 | 419 |
881692 | 881692 | 2020-12-31 | Inyo | California | 6027 | 571 | 20 |
881693 | 881693 | 2020-12-31 | Kern | California | 6029 | 68969 | 512 |
881694 | 881694 | 2020-12-31 | Kings | California | 6031 | 16114 | 110 |
881695 | 881695 | 2020-12-31 | Lake | California | 6033 | 1817 | 23 |
881696 | 881696 | 2020-12-31 | Lassen | California | 6035 | 4691 | 9 |
881697 | 881697 | 2020-12-31 | Los Angeles | California | 6037 | 770915 | 10345 |
881698 | 881698 | 2020-12-31 | Madera | California | 6039 | 10491 | 117 |
881699 | 881699 | 2020-12-31 | Marin | California | 6041 | 9800 | 139 |
881700 | 881700 | 2020-12-31 | Mariposa | California | 6043 | 252 | 4 |
881701 | 881701 | 2020-12-31 | Mendocino | California | 6045 | 2558 | 26 |
881702 | 881702 | 2020-12-31 | Merced | California | 6047 | 19444 | 260 |
881703 | 881703 | 2020-12-31 | Modoc | California | 6049 | 323 | 1 |
881704 | 881704 | 2020-12-31 | Mono | California | 6051 | 868 | 4 |
881705 | 881705 | 2020-12-31 | Monterey | California | 6053 | 27859 | 193 |
881706 | 881706 | 2020-12-31 | Napa | California | 6055 | 5742 | 28 |
881707 | 881707 | 2020-12-31 | Nevada | California | 6057 | 2609 | 50 |
881708 | 881708 | 2020-12-31 | Orange | California | 6059 | 166196 | 1875 |
881709 | 881709 | 2020-12-31 | Placer | California | 6061 | 13755 | 125 |
881710 | 881710 | 2020-12-31 | Plumas | California | 6063 | 398 | 1 |
881711 | 881711 | 2020-12-31 | Riverside | California | 6065 | 180553 | 1985 |
881712 | 881712 | 2020-12-31 | Sacramento | California | 6067 | 65540 | 857 |
881713 | 881713 | 2020-12-31 | San Benito | California | 6069 | 3673 | 29 |
881714 | 881714 | 2020-12-31 | San Bernardino | California | 6071 | 194377 | 1445 |
881715 | 881715 | 2020-12-31 | San Diego | California | 6073 | 155658 | 1534 |
881716 | 881716 | 2020-12-31 | San Francisco | California | 6075 | 23227 | 186 |
881717 | 881717 | 2020-12-31 | San Joaquin | California | 6077 | 45583 | 651 |
881718 | 881718 | 2020-12-31 | San Luis Obispo | California | 6079 | 10490 | 82 |
881719 | 881719 | 2020-12-31 | San Mateo | California | 6081 | 24589 | 227 |
881720 | 881720 | 2020-12-31 | Santa Barbara | California | 6083 | 17391 | 160 |
881721 | 881721 | 2020-12-31 | Santa Clara | California | 6085 | 69879 | 710 |
881722 | 881722 | 2020-12-31 | Santa Cruz | California | 6087 | 8749 | 83 |
881723 | 881723 | 2020-12-31 | Shasta | California | 6089 | 8060 | 78 |
881724 | 881724 | 2020-12-31 | Sierra | California | 6091 | 24 | 0 |
881725 | 881725 | 2020-12-31 | Siskiyou | California | 6093 | 1176 | 11 |
881726 | 881726 | 2020-12-31 | Solano | California | 6095 | 19216 | 98 |
881727 | 881727 | 2020-12-31 | Sonoma | California | 6097 | 19055 | 192 |
881728 | 881728 | 2020-12-31 | Stanislaus | California | 6099 | 37524 | 616 |
881729 | 881729 | 2020-12-31 | Sutter | California | 6101 | 6505 | 52 |
881730 | 881730 | 2020-12-31 | Tehama | California | 6103 | 2967 | 36 |
881731 | 881731 | 2020-12-31 | Trinity | California | 6105 | 251 | 4 |
881732 | 881732 | 2020-12-31 | Tulare | California | 6107 | 33443 | 406 |
881733 | 881733 | 2020-12-31 | Tuolumne | California | 6109 | 2962 | 21 |
881734 | 881734 | 2020-12-31 | Ventura | California | 6111 | 39559 | 263 |
881735 | 881735 | 2020-12-31 | Yolo | California | 6113 | 8238 | 111 |
881736 | 881736 | 2020-12-31 | Yuba | California | 6115 | 3898 | 19 |
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);