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 351
- Los Angeles 350
- Santa Clara 345
- San Francisco 343
- San Diego 335
- Humboldt 325
- Sacramento 324
- Solano 321
- Marin 319
- Napa 319
- Sonoma 319
- Alameda 315
- Placer 314
- San Mateo 314
- Contra Costa 313
- Yolo 310
- Fresno 309
- Madera 309
- Riverside 309
- Santa Cruz 309
- Shasta 307
- San Joaquin 306
- Ventura 306
- Stanislaus 305
- Tulare 304
- San Benito 303
- San Luis Obispo 302
- San Bernardino 301
- Santa Barbara 301
- Nevada 300
- …
state 1
- California · 17,323 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
910889 | 910889 | 2021-01-09 | Alameda | California | 6001 | 59193 | 732 |
910890 | 910890 | 2021-01-09 | Alpine | California | 6003 | 70 | 0 |
910891 | 910891 | 2021-01-09 | Amador | California | 6005 | 2791 | 26 |
910892 | 910892 | 2021-01-09 | Butte | California | 6007 | 8430 | 111 |
910893 | 910893 | 2021-01-09 | Calaveras | California | 6009 | 1385 | 22 |
910894 | 910894 | 2021-01-09 | Colusa | California | 6011 | 1565 | 9 |
910895 | 910895 | 2021-01-09 | Contra Costa | California | 6013 | 46618 | 389 |
910896 | 910896 | 2021-01-09 | Del Norte | California | 6015 | 816 | 2 |
910897 | 910897 | 2021-01-09 | El Dorado | California | 6017 | 6690 | 33 |
910898 | 910898 | 2021-01-09 | Fresno | California | 6019 | 73689 | 711 |
910899 | 910899 | 2021-01-09 | Glenn | California | 6021 | 1954 | 18 |
910900 | 910900 | 2021-01-09 | Humboldt | California | 6023 | 2031 | 23 |
910901 | 910901 | 2021-01-09 | Imperial | California | 6025 | 23751 | 445 |
910902 | 910902 | 2021-01-09 | Inyo | California | 6027 | 682 | 27 |
910903 | 910903 | 2021-01-09 | Kern | California | 6029 | 77875 | 542 |
910904 | 910904 | 2021-01-09 | Kings | California | 6031 | 17711 | 110 |
910905 | 910905 | 2021-01-09 | Lake | California | 6033 | 2098 | 26 |
910906 | 910906 | 2021-01-09 | Lassen | California | 6035 | 4972 | 11 |
910907 | 910907 | 2021-01-09 | Los Angeles | California | 6037 | 906554 | 12084 |
910908 | 910908 | 2021-01-09 | Madera | California | 6039 | 11846 | 126 |
910909 | 910909 | 2021-01-09 | Marin | California | 6041 | 10696 | 143 |
910910 | 910910 | 2021-01-09 | Mariposa | California | 6043 | 318 | 4 |
910911 | 910911 | 2021-01-09 | Mendocino | California | 6045 | 2886 | 31 |
910912 | 910912 | 2021-01-09 | Merced | California | 6047 | 21506 | 279 |
910913 | 910913 | 2021-01-09 | Modoc | California | 6049 | 357 | 3 |
910914 | 910914 | 2021-01-09 | Mono | California | 6051 | 951 | 4 |
910915 | 910915 | 2021-01-09 | Monterey | California | 6053 | 32394 | 242 |
910916 | 910916 | 2021-01-09 | Napa | California | 6055 | 6545 | 36 |
910917 | 910917 | 2021-01-09 | Nevada | California | 6057 | 2888 | 50 |
910918 | 910918 | 2021-01-09 | Orange | California | 6059 | 196024 | 2041 |
910919 | 910919 | 2021-01-09 | Placer | California | 6061 | 15454 | 159 |
910920 | 910920 | 2021-01-09 | Plumas | California | 6063 | 465 | 5 |
910921 | 910921 | 2021-01-09 | Riverside | California | 6065 | 212122 | 2218 |
910922 | 910922 | 2021-01-09 | Sacramento | California | 6067 | 73244 | 977 |
910923 | 910923 | 2021-01-09 | San Benito | California | 6069 | 4363 | 36 |
910924 | 910924 | 2021-01-09 | San Bernardino | California | 6071 | 224350 | 1520 |
910925 | 910925 | 2021-01-09 | San Diego | California | 6073 | 188663 | 1824 |
910926 | 910926 | 2021-01-09 | San Francisco | California | 6075 | 26381 | 233 |
910927 | 910927 | 2021-01-09 | San Joaquin | California | 6077 | 51523 | 712 |
910928 | 910928 | 2021-01-09 | San Luis Obispo | California | 6079 | 13286 | 101 |
910929 | 910929 | 2021-01-09 | San Mateo | California | 6081 | 28072 | 255 |
910930 | 910930 | 2021-01-09 | Santa Barbara | California | 6083 | 20550 | 197 |
910931 | 910931 | 2021-01-09 | Santa Clara | California | 6085 | 82170 | 884 |
910932 | 910932 | 2021-01-09 | Santa Cruz | California | 6087 | 10486 | 104 |
910933 | 910933 | 2021-01-09 | Shasta | California | 6089 | 8917 | 99 |
910934 | 910934 | 2021-01-09 | Sierra | California | 6091 | 31 | 0 |
910935 | 910935 | 2021-01-09 | Siskiyou | California | 6093 | 1311 | 12 |
910936 | 910936 | 2021-01-09 | Solano | California | 6095 | 22237 | 102 |
910937 | 910937 | 2021-01-09 | Sonoma | California | 6097 | 21264 | 218 |
910938 | 910938 | 2021-01-09 | Stanislaus | California | 6099 | 42093 | 675 |
910939 | 910939 | 2021-01-09 | Sutter | California | 6101 | 7018 | 70 |
910940 | 910940 | 2021-01-09 | Tehama | California | 6103 | 3406 | 40 |
910941 | 910941 | 2021-01-09 | Trinity | California | 6105 | 248 | 4 |
910942 | 910942 | 2021-01-09 | Tulare | California | 6107 | 36946 | 455 |
910943 | 910943 | 2021-01-09 | Tuolumne | California | 6109 | 3180 | 33 |
910944 | 910944 | 2021-01-09 | Ventura | California | 6111 | 50553 | 334 |
910945 | 910945 | 2021-01-09 | Yolo | California | 6113 | 9391 | 127 |
910946 | 910946 | 2021-01-09 | Yuba | California | 6115 | 4440 | 25 |
907644 | 907644 | 2021-01-08 | Alameda | California | 6001 | 57942 | 729 |
907645 | 907645 | 2021-01-08 | Alpine | California | 6003 | 70 | 0 |
907646 | 907646 | 2021-01-08 | Amador | California | 6005 | 2739 | 26 |
907647 | 907647 | 2021-01-08 | Butte | California | 6007 | 8359 | 102 |
907648 | 907648 | 2021-01-08 | Calaveras | California | 6009 | 1342 | 22 |
907649 | 907649 | 2021-01-08 | Colusa | California | 6011 | 1565 | 9 |
907650 | 907650 | 2021-01-08 | Contra Costa | California | 6013 | 45874 | 376 |
907651 | 907651 | 2021-01-08 | Del Norte | California | 6015 | 807 | 2 |
907652 | 907652 | 2021-01-08 | El Dorado | California | 6017 | 6545 | 33 |
907653 | 907653 | 2021-01-08 | Fresno | California | 6019 | 72557 | 711 |
907654 | 907654 | 2021-01-08 | Glenn | California | 6021 | 1954 | 16 |
907655 | 907655 | 2021-01-08 | Humboldt | California | 6023 | 2031 | 23 |
907656 | 907656 | 2021-01-08 | Imperial | California | 6025 | 23608 | 445 |
907657 | 907657 | 2021-01-08 | Inyo | California | 6027 | 656 | 27 |
907658 | 907658 | 2021-01-08 | Kern | California | 6029 | 76673 | 539 |
907659 | 907659 | 2021-01-08 | Kings | California | 6031 | 17238 | 110 |
907660 | 907660 | 2021-01-08 | Lake | California | 6033 | 2054 | 25 |
907661 | 907661 | 2021-01-08 | Lassen | California | 6035 | 4972 | 11 |
907662 | 907662 | 2021-01-08 | Los Angeles | California | 6037 | 889787 | 11863 |
907663 | 907663 | 2021-01-08 | Madera | California | 6039 | 11645 | 126 |
907664 | 907664 | 2021-01-08 | Marin | California | 6041 | 10588 | 143 |
907665 | 907665 | 2021-01-08 | Mariposa | California | 6043 | 308 | 4 |
907666 | 907666 | 2021-01-08 | Mendocino | California | 6045 | 2846 | 31 |
907667 | 907667 | 2021-01-08 | Merced | California | 6047 | 21506 | 279 |
907668 | 907668 | 2021-01-08 | Modoc | California | 6049 | 357 | 3 |
907669 | 907669 | 2021-01-08 | Mono | California | 6051 | 905 | 4 |
907670 | 907670 | 2021-01-08 | Monterey | California | 6053 | 31802 | 232 |
907671 | 907671 | 2021-01-08 | Napa | California | 6055 | 6477 | 35 |
907672 | 907672 | 2021-01-08 | Nevada | California | 6057 | 2888 | 50 |
907673 | 907673 | 2021-01-08 | Orange | California | 6059 | 191804 | 1998 |
907674 | 907674 | 2021-01-08 | Placer | California | 6061 | 15454 | 159 |
907675 | 907675 | 2021-01-08 | Plumas | California | 6063 | 454 | 5 |
907676 | 907676 | 2021-01-08 | Riverside | California | 6065 | 208177 | 2218 |
907677 | 907677 | 2021-01-08 | Sacramento | California | 6067 | 72341 | 977 |
907678 | 907678 | 2021-01-08 | San Benito | California | 6069 | 4266 | 36 |
907679 | 907679 | 2021-01-08 | San Bernardino | California | 6071 | 219691 | 1486 |
907680 | 907680 | 2021-01-08 | San Diego | California | 6073 | 185125 | 1771 |
907681 | 907681 | 2021-01-08 | San Francisco | California | 6075 | 25888 | 218 |
907682 | 907682 | 2021-01-08 | San Joaquin | California | 6077 | 51523 | 712 |
907683 | 907683 | 2021-01-08 | San Luis Obispo | California | 6079 | 12891 | 101 |
907684 | 907684 | 2021-01-08 | San Mateo | California | 6081 | 27494 | 255 |
907685 | 907685 | 2021-01-08 | Santa Barbara | California | 6083 | 19953 | 185 |
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);