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 193,264
- Georgia 124,569
- Virginia 102,995
- Kentucky 92,452
- Missouri 89,483
- Illinois 79,296
- Kansas 79,188
- North Carolina 77,709
- Iowa 76,970
- Tennessee 74,623
- Indiana 71,821
- Nebraska 69,161
- Ohio 69,012
- Minnesota 67,795
- Michigan 65,118
- Mississippi 64,064
- Oklahoma 59,845
- Arkansas 58,880
- Puerto Rico 58,318
- Wisconsin 55,921
- Florida 53,226
- Pennsylvania 52,374
- Alabama 52,178
- Louisiana 50,837
- South Dakota 49,486
- Colorado 49,399
- New York 45,634
- California 45,577
- West Virginia 42,183
- Montana 40,600
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497029 | 2497029 | 2022-05-12 | Carroll | Indiana | 18015 | 4265 | 68 |
2497030 | 2497030 | 2022-05-12 | Cass | Indiana | 18017 | 11701 | 164 |
2497031 | 2497031 | 2022-05-12 | Clark | Indiana | 18019 | 31527 | 396 |
2497032 | 2497032 | 2022-05-12 | Clay | Indiana | 18021 | 6852 | 88 |
2497033 | 2497033 | 2022-05-12 | Clinton | Indiana | 18023 | 9247 | 127 |
2497034 | 2497034 | 2022-05-12 | Crawford | Indiana | 18025 | 2560 | 40 |
2497035 | 2497035 | 2022-05-12 | Daviess | Indiana | 18027 | 7493 | 154 |
2497036 | 2497036 | 2022-05-12 | DeKalb | Indiana | 18033 | 11400 | 152 |
2497037 | 2497037 | 2022-05-12 | Dearborn | Indiana | 18029 | 13541 | 140 |
2497038 | 2497038 | 2022-05-12 | Decatur | Indiana | 18031 | 7013 | 147 |
2497039 | 2497039 | 2022-05-12 | Delaware | Indiana | 18035 | 25067 | 444 |
2497040 | 2497040 | 2022-05-12 | Dubois | Indiana | 18037 | 12895 | 165 |
2497041 | 2497041 | 2022-05-12 | Elkhart | Indiana | 18039 | 54339 | 734 |
2497042 | 2497042 | 2022-05-12 | Fayette | Indiana | 18041 | 6750 | 146 |
2497043 | 2497043 | 2022-05-12 | Floyd | Indiana | 18043 | 19167 | 302 |
2497044 | 2497044 | 2022-05-12 | Fountain | Indiana | 18045 | 5481 | 103 |
2497045 | 2497045 | 2022-05-12 | Franklin | Indiana | 18047 | 4385 | 65 |
2497046 | 2497046 | 2022-05-12 | Fulton | Indiana | 18049 | 4934 | 103 |
2497047 | 2497047 | 2022-05-12 | Gibson | Indiana | 18051 | 11734 | 145 |
2497048 | 2497048 | 2022-05-12 | Grant | Indiana | 18053 | 17369 | 353 |
2497049 | 2497049 | 2022-05-12 | Greene | Indiana | 18055 | 7252 | 139 |
2497050 | 2497050 | 2022-05-12 | Hamilton | Indiana | 18057 | 83231 | 661 |
2497051 | 2497051 | 2022-05-12 | Hancock | Indiana | 18059 | 20849 | 258 |
2497052 | 2497052 | 2022-05-12 | Harrison | Indiana | 18061 | 10880 | 138 |
2497053 | 2497053 | 2022-05-12 | Hendricks | Indiana | 18063 | 41000 | 554 |
2497054 | 2497054 | 2022-05-12 | Henry | Indiana | 18065 | 13044 | 231 |
2497055 | 2497055 | 2022-05-12 | Howard | Indiana | 18067 | 25538 | 449 |
2497056 | 2497056 | 2022-05-12 | Huntington | Indiana | 18069 | 11562 | 157 |
2497057 | 2497057 | 2022-05-12 | Jackson | Indiana | 18071 | 12561 | 130 |
2497058 | 2497058 | 2022-05-12 | Jasper | Indiana | 18073 | 9141 | 149 |
2497059 | 2497059 | 2022-05-12 | Jay | Indiana | 18075 | 4862 | 78 |
2497060 | 2497060 | 2022-05-12 | Jefferson | Indiana | 18077 | 9373 | 159 |
2497061 | 2497061 | 2022-05-12 | Jennings | Indiana | 18079 | 6990 | 108 |
2497062 | 2497062 | 2022-05-12 | Johnson | Indiana | 18081 | 42751 | 615 |
2497063 | 2497063 | 2022-05-12 | Knox | Indiana | 18083 | 10792 | 153 |
2497064 | 2497064 | 2022-05-12 | Kosciusko | Indiana | 18085 | 19838 | 237 |
2497065 | 2497065 | 2022-05-12 | LaGrange | Indiana | 18087 | 5871 | 102 |
2497066 | 2497066 | 2022-05-12 | LaPorte | Indiana | 18091 | 25842 | 367 |
2497067 | 2497067 | 2022-05-12 | Lake | Indiana | 18089 | 108373 | 1833 |
2497068 | 2497068 | 2022-05-12 | Lawrence | Indiana | 18093 | 12000 | 261 |
2497069 | 2497069 | 2022-05-12 | Madison | Indiana | 18095 | 32850 | 653 |
2497070 | 2497070 | 2022-05-12 | Marion | Indiana | 18097 | 227159 | 3000 |
2497071 | 2497071 | 2022-05-12 | Marshall | Indiana | 18099 | 12427 | 197 |
2497072 | 2497072 | 2022-05-12 | Martin | Indiana | 18101 | 2172 | 25 |
2497073 | 2497073 | 2022-05-12 | Miami | Indiana | 18103 | 9285 | 159 |
2497074 | 2497074 | 2022-05-12 | Monroe | Indiana | 18105 | 28724 | 280 |
2497075 | 2497075 | 2022-05-12 | Montgomery | Indiana | 18107 | 10733 | 164 |
2497076 | 2497076 | 2022-05-12 | Morgan | Indiana | 18109 | 16575 | 287 |
2497077 | 2497077 | 2022-05-12 | Newton | Indiana | 18111 | 2589 | 68 |
2497078 | 2497078 | 2022-05-12 | Noble | Indiana | 18113 | 13126 | 157 |
2497079 | 2497079 | 2022-05-12 | Ohio | Indiana | 18115 | 1456 | 19 |
2497080 | 2497080 | 2022-05-12 | Orange | Indiana | 18117 | 5051 | 96 |
2497081 | 2497081 | 2022-05-12 | Owen | Indiana | 18119 | 5901 | 121 |
2497082 | 2497082 | 2022-05-12 | Parke | Indiana | 18121 | 3606 | 46 |
2497083 | 2497083 | 2022-05-12 | Perry | Indiana | 18123 | 4670 | 69 |
2497084 | 2497084 | 2022-05-12 | Pike | Indiana | 18125 | 3752 | 49 |
2497085 | 2497085 | 2022-05-12 | Porter | Indiana | 18127 | 38507 | 564 |
2497086 | 2497086 | 2022-05-12 | Posey | Indiana | 18129 | 6574 | 58 |
2497087 | 2497087 | 2022-05-12 | Pulaski | Indiana | 18131 | 3084 | 86 |
2497088 | 2497088 | 2022-05-12 | Putnam | Indiana | 18133 | 9414 | 129 |
2497089 | 2497089 | 2022-05-12 | Randolph | Indiana | 18135 | 5912 | 148 |
2497090 | 2497090 | 2022-05-12 | Ripley | Indiana | 18137 | 8352 | 138 |
2497091 | 2497091 | 2022-05-12 | Rush | Indiana | 18139 | 4857 | 58 |
2497092 | 2497092 | 2022-05-12 | Scott | Indiana | 18143 | 7929 | 106 |
2497093 | 2497093 | 2022-05-12 | Shelby | Indiana | 18145 | 13640 | 182 |
2497094 | 2497094 | 2022-05-12 | Spencer | Indiana | 18147 | 5248 | 61 |
2497095 | 2497095 | 2022-05-12 | St. Joseph | Indiana | 18141 | 71645 | 874 |
2497096 | 2497096 | 2022-05-12 | Starke | Indiana | 18149 | 4779 | 99 |
2497097 | 2497097 | 2022-05-12 | Steuben | Indiana | 18151 | 9677 | 121 |
2497098 | 2497098 | 2022-05-12 | Sullivan | Indiana | 18153 | 5292 | 76 |
2497099 | 2497099 | 2022-05-12 | Switzerland | Indiana | 18155 | 2320 | 20 |
2497100 | 2497100 | 2022-05-12 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2497101 | 2497101 | 2022-05-12 | Tipton | Indiana | 18159 | 3541 | 87 |
2497102 | 2497102 | 2022-05-12 | Union | Indiana | 18161 | 2025 | 21 |
2497103 | 2497103 | 2022-05-12 | Unknown | Indiana | 0 | 26 | |
2497104 | 2497104 | 2022-05-12 | Vanderburgh | Indiana | 18163 | 57756 | 640 |
2497105 | 2497105 | 2022-05-12 | Vermillion | Indiana | 18165 | 4116 | 75 |
2497106 | 2497106 | 2022-05-12 | Vigo | Indiana | 18167 | 29022 | 414 |
2497107 | 2497107 | 2022-05-12 | Wabash | Indiana | 18169 | 8749 | 157 |
2497108 | 2497108 | 2022-05-12 | Warren | Indiana | 18171 | 2109 | 30 |
2497109 | 2497109 | 2022-05-12 | Warrick | Indiana | 18173 | 20393 | 239 |
2497110 | 2497110 | 2022-05-12 | Washington | Indiana | 18175 | 6007 | 85 |
2497111 | 2497111 | 2022-05-12 | Wayne | Indiana | 18177 | 18886 | 337 |
2497112 | 2497112 | 2022-05-12 | Wells | Indiana | 18179 | 6509 | 132 |
2497113 | 2497113 | 2022-05-12 | White | Indiana | 18181 | 6928 | 96 |
2497114 | 2497114 | 2022-05-12 | Whitley | Indiana | 18183 | 9732 | 84 |
2497115 | 2497115 | 2022-05-12 | Adair | Iowa | 19001 | 1588 | 50 |
2497116 | 2497116 | 2022-05-12 | Adams | Iowa | 19003 | 820 | 14 |
2497117 | 2497117 | 2022-05-12 | Allamakee | Iowa | 19005 | 2890 | 60 |
2497118 | 2497118 | 2022-05-12 | Appanoose | Iowa | 19007 | 2927 | 68 |
2497119 | 2497119 | 2022-05-12 | Audubon | Iowa | 19009 | 1114 | 19 |
2497120 | 2497120 | 2022-05-12 | Benton | Iowa | 19011 | 6089 | 77 |
2497121 | 2497121 | 2022-05-12 | Black Hawk | Iowa | 19013 | 33140 | 480 |
2497122 | 2497122 | 2022-05-12 | Boone | Iowa | 19015 | 5519 | 54 |
2497123 | 2497123 | 2022-05-12 | Bremer | Iowa | 19017 | 5559 | 82 |
2497124 | 2497124 | 2022-05-12 | Buchanan | Iowa | 19019 | 4619 | 58 |
2497125 | 2497125 | 2022-05-12 | Buena Vista | Iowa | 19021 | 6404 | 58 |
2497126 | 2497126 | 2022-05-12 | Butler | Iowa | 19023 | 3252 | 53 |
2497127 | 2497127 | 2022-05-12 | Calhoun | Iowa | 19025 | 2608 | 25 |
2497128 | 2497128 | 2022-05-12 | Carroll | Iowa | 19027 | 4958 | 66 |
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);