ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 47,729
- Georgia 33,049
- Virginia 26,778
- Kentucky 23,692
- Missouri 22,441
- Illinois 20,464
- North Carolina 20,408
- Iowa 19,670
- Tennessee 19,627
- Indiana 19,078
- Kansas 18,809
- Ohio 18,154
- Minnesota 17,371
- Mississippi 17,021
- Michigan 16,986
- Nebraska 15,498
- Arkansas 15,363
- Oklahoma 15,152
- Wisconsin 14,659
- Florida 14,330
- Pennsylvania 13,983
- Alabama 13,787
- Louisiana 13,593
- Puerto Rico 13,051
- Colorado 12,791
- New York 12,400
- California 12,393
- South Dakota 11,668
- West Virginia 10,666
- South Carolina 9,687
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635040 | 635040 | 2020-10-16 | Miller | Arkansas | 5091 | 1146 | 15 |
635041 | 635041 | 2020-10-16 | Mississippi | Arkansas | 5093 | 1991 | 58 |
635042 | 635042 | 2020-10-16 | Monroe | Arkansas | 5095 | 194 | 0 |
635043 | 635043 | 2020-10-16 | Montgomery | Arkansas | 5097 | 178 | 8 |
635044 | 635044 | 2020-10-16 | Nevada | Arkansas | 5099 | 260 | 14 |
635045 | 635045 | 2020-10-16 | Newton | Arkansas | 5101 | 282 | 19 |
635046 | 635046 | 2020-10-16 | Ouachita | Arkansas | 5103 | 326 | 7 |
635047 | 635047 | 2020-10-16 | Perry | Arkansas | 5105 | 124 | 0 |
635048 | 635048 | 2020-10-16 | Phillips | Arkansas | 5107 | 671 | 15 |
635049 | 635049 | 2020-10-16 | Pike | Arkansas | 5109 | 253 | 2 |
635050 | 635050 | 2020-10-16 | Poinsett | Arkansas | 5111 | 883 | 16 |
635051 | 635051 | 2020-10-16 | Polk | Arkansas | 5113 | 332 | 4 |
635052 | 635052 | 2020-10-16 | Pope | Arkansas | 5115 | 2511 | 36 |
635053 | 635053 | 2020-10-16 | Prairie | Arkansas | 5117 | 191 | 4 |
635054 | 635054 | 2020-10-16 | Pulaski | Arkansas | 5119 | 10954 | 193 |
635055 | 635055 | 2020-10-16 | Randolph | Arkansas | 5121 | 572 | 23 |
635056 | 635056 | 2020-10-16 | Saline | Arkansas | 5125 | 2544 | 28 |
635057 | 635057 | 2020-10-16 | Scott | Arkansas | 5127 | 146 | 1 |
635058 | 635058 | 2020-10-16 | Searcy | Arkansas | 5129 | 173 | 1 |
635059 | 635059 | 2020-10-16 | Sebastian | Arkansas | 5131 | 4457 | 87 |
635060 | 635060 | 2020-10-16 | Sevier | Arkansas | 5133 | 1256 | 19 |
635061 | 635061 | 2020-10-16 | Sharp | Arkansas | 5135 | 293 | 9 |
635062 | 635062 | 2020-10-16 | St. Francis | Arkansas | 5123 | 1643 | 9 |
635063 | 635063 | 2020-10-16 | Stone | Arkansas | 5137 | 389 | 20 |
635064 | 635064 | 2020-10-16 | Union | Arkansas | 5139 | 1057 | 47 |
635065 | 635065 | 2020-10-16 | Unknown | Arkansas | 1982 | 0 | |
635066 | 635066 | 2020-10-16 | Van Buren | Arkansas | 5141 | 198 | 3 |
635067 | 635067 | 2020-10-16 | Washington | Arkansas | 5143 | 10748 | 131 |
635068 | 635068 | 2020-10-16 | White | Arkansas | 5145 | 1248 | 32 |
635069 | 635069 | 2020-10-16 | Woodruff | Arkansas | 5147 | 82 | 0 |
635070 | 635070 | 2020-10-16 | Yell | Arkansas | 5149 | 1310 | 30 |
635071 | 635071 | 2020-10-16 | Alameda | California | 6001 | 22429 | 439 |
635072 | 635072 | 2020-10-16 | Alpine | California | 6003 | 3 | 0 |
635073 | 635073 | 2020-10-16 | Amador | California | 6005 | 308 | 16 |
635074 | 635074 | 2020-10-16 | Butte | California | 6007 | 3000 | 50 |
635075 | 635075 | 2020-10-16 | Calaveras | California | 6009 | 333 | 17 |
635076 | 635076 | 2020-10-16 | Colusa | California | 6011 | 545 | 6 |
635077 | 635077 | 2020-10-16 | Contra Costa | California | 6013 | 17893 | 234 |
635078 | 635078 | 2020-10-16 | Del Norte | California | 6015 | 173 | 1 |
635079 | 635079 | 2020-10-16 | El Dorado | California | 6017 | 1265 | 4 |
635080 | 635080 | 2020-10-16 | Fresno | California | 6019 | 29727 | 429 |
635081 | 635081 | 2020-10-16 | Glenn | California | 6021 | 632 | 3 |
635082 | 635082 | 2020-10-16 | Humboldt | California | 6023 | 544 | 8 |
635083 | 635083 | 2020-10-16 | Imperial | California | 6025 | 12410 | 334 |
635084 | 635084 | 2020-10-16 | Inyo | California | 6027 | 210 | 15 |
635085 | 635085 | 2020-10-16 | Kern | California | 6029 | 33286 | 408 |
635086 | 635086 | 2020-10-16 | Kings | California | 6031 | 8134 | 83 |
635087 | 635087 | 2020-10-16 | Lake | California | 6033 | 642 | 14 |
635088 | 635088 | 2020-10-16 | Lassen | California | 6035 | 752 | 1 |
635089 | 635089 | 2020-10-16 | Los Angeles | California | 6037 | 287222 | 6855 |
635090 | 635090 | 2020-10-16 | Madera | California | 6039 | 4836 | 73 |
635091 | 635091 | 2020-10-16 | Marin | California | 6041 | 6982 | 124 |
635092 | 635092 | 2020-10-16 | Mariposa | California | 6043 | 78 | 2 |
635093 | 635093 | 2020-10-16 | Mendocino | California | 6045 | 1080 | 21 |
635094 | 635094 | 2020-10-16 | Merced | California | 6047 | 9314 | 152 |
635095 | 635095 | 2020-10-16 | Modoc | California | 6049 | 27 | 0 |
635096 | 635096 | 2020-10-16 | Mono | California | 6051 | 175 | 2 |
635097 | 635097 | 2020-10-16 | Monterey | California | 6053 | 10943 | 82 |
635098 | 635098 | 2020-10-16 | Napa | California | 6055 | 1852 | 14 |
635099 | 635099 | 2020-10-16 | Nevada | California | 6057 | 581 | 8 |
635100 | 635100 | 2020-10-16 | Orange | California | 6059 | 58354 | 1401 |
635101 | 635101 | 2020-10-16 | Placer | California | 6061 | 3880 | 52 |
635102 | 635102 | 2020-10-16 | Plumas | California | 6063 | 52 | 0 |
635103 | 635103 | 2020-10-16 | Riverside | California | 6065 | 63284 | 1269 |
635104 | 635104 | 2020-10-16 | Sacramento | California | 6067 | 24191 | 468 |
635105 | 635105 | 2020-10-16 | San Benito | California | 6069 | 1396 | 14 |
635106 | 635106 | 2020-10-16 | San Bernardino | California | 6071 | 59463 | 989 |
635107 | 635107 | 2020-10-16 | San Diego | California | 6073 | 51844 | 847 |
635108 | 635108 | 2020-10-16 | San Francisco | California | 6075 | 11811 | 131 |
635109 | 635109 | 2020-10-16 | San Joaquin | California | 6077 | 21187 | 484 |
635110 | 635110 | 2020-10-16 | San Luis Obispo | California | 6079 | 3985 | 32 |
635111 | 635111 | 2020-10-16 | San Mateo | California | 6081 | 10687 | 155 |
635112 | 635112 | 2020-10-16 | Santa Barbara | California | 6083 | 9560 | 119 |
635113 | 635113 | 2020-10-16 | Santa Clara | California | 6085 | 22974 | 374 |
635114 | 635114 | 2020-10-16 | Santa Cruz | California | 6087 | 2682 | 23 |
635115 | 635115 | 2020-10-16 | Shasta | California | 6089 | 1666 | 29 |
635116 | 635116 | 2020-10-16 | Sierra | California | 6091 | 6 | 0 |
635117 | 635117 | 2020-10-16 | Siskiyou | California | 6093 | 184 | 0 |
635118 | 635118 | 2020-10-16 | Solano | California | 6095 | 7014 | 74 |
635119 | 635119 | 2020-10-16 | Sonoma | California | 6097 | 8717 | 129 |
635120 | 635120 | 2020-10-16 | Stanislaus | California | 6099 | 17840 | 391 |
635121 | 635121 | 2020-10-16 | Sutter | California | 6101 | 1796 | 12 |
635122 | 635122 | 2020-10-16 | Tehama | California | 6103 | 726 | 8 |
635123 | 635123 | 2020-10-16 | Trinity | California | 6105 | 21 | 0 |
635124 | 635124 | 2020-10-16 | Tulare | California | 6107 | 17120 | 275 |
635125 | 635125 | 2020-10-16 | Tuolumne | California | 6109 | 249 | 4 |
635126 | 635126 | 2020-10-16 | Ventura | California | 6111 | 13750 | 160 |
635127 | 635127 | 2020-10-16 | Yolo | California | 6113 | 3034 | 56 |
635128 | 635128 | 2020-10-16 | Yuba | California | 6115 | 1253 | 10 |
635129 | 635129 | 2020-10-16 | Adams | Colorado | 8001 | 11507 | 247 |
635130 | 635130 | 2020-10-16 | Alamosa | Colorado | 8003 | 272 | 9 |
635131 | 635131 | 2020-10-16 | Arapahoe | Colorado | 8005 | 11017 | 390 |
635132 | 635132 | 2020-10-16 | Archuleta | Colorado | 8007 | 58 | 0 |
635133 | 635133 | 2020-10-16 | Baca | Colorado | 8009 | 23 | 0 |
635134 | 635134 | 2020-10-16 | Bent | Colorado | 8011 | 12 | 0 |
635135 | 635135 | 2020-10-16 | Boulder | Colorado | 8013 | 4998 | 84 |
635136 | 635136 | 2020-10-16 | Broomfield | Colorado | 8014 | 767 | 39 |
635137 | 635137 | 2020-10-16 | Chaffee | Colorado | 8015 | 359 | 20 |
635138 | 635138 | 2020-10-16 | Cheyenne | Colorado | 8017 | 14 | 0 |
635139 | 635139 | 2020-10-16 | Clear Creek | Colorado | 8019 | 61 | 1 |
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);