ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
325 rows where cases = 1713 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 21
- Missouri 21
- Georgia 18
- Kentucky 17
- Texas 17
- Oklahoma 16
- Arkansas 15
- Illinois 15
- Kansas 14
- North Carolina 14
- Louisiana 11
- Minnesota 11
- Virginia 11
- Florida 10
- Alabama 9
- Michigan 9
- Tennessee 9
- Wisconsin 9
- Indiana 8
- Mississippi 7
- Ohio 6
- South Dakota 6
- Alaska 5
- Idaho 5
- Nebraska 4
- South Carolina 4
- Colorado 3
- New York 3
- North Dakota 3
- Puerto Rico 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2354371 | 2354371 | 2022-03-29 | Montmorency | Michigan | 26119 | 1713 | 46 |
2351119 | 2351119 | 2022-03-28 | Montmorency | Michigan | 26119 | 1713 | 46 |
2348092 | 2348092 | 2022-03-27 | Daviess | Missouri | 29061 | 1713 | 27 |
2344839 | 2344839 | 2022-03-26 | Daviess | Missouri | 29061 | 1713 | 27 |
2341586 | 2341586 | 2022-03-25 | Daviess | Missouri | 29061 | 1713 | 27 |
2335706 | 2335706 | 2022-03-23 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2332452 | 2332452 | 2022-03-22 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2327205 | 2327205 | 2022-03-21 | Newton | Arkansas | 5101 | 1713 | 47 |
2329199 | 2329199 | 2022-03-21 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2323952 | 2323952 | 2022-03-20 | Newton | Arkansas | 5101 | 1713 | 47 |
2325094 | 2325094 | 2022-03-20 | Montmorency | Michigan | 26119 | 1713 | 47 |
2325947 | 2325947 | 2022-03-20 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2320698 | 2320698 | 2022-03-19 | Newton | Arkansas | 5101 | 1713 | 46 |
2321840 | 2321840 | 2022-03-19 | Montmorency | Michigan | 26119 | 1713 | 47 |
2322694 | 2322694 | 2022-03-19 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2317444 | 2317444 | 2022-03-18 | Newton | Arkansas | 5101 | 1713 | 46 |
2318586 | 2318586 | 2022-03-18 | Montmorency | Michigan | 26119 | 1713 | 47 |
2319440 | 2319440 | 2022-03-18 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2315333 | 2315333 | 2022-03-17 | Montmorency | Michigan | 26119 | 1713 | 47 |
2316186 | 2316186 | 2022-03-17 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2312080 | 2312080 | 2022-03-16 | Montmorency | Michigan | 26119 | 1713 | 47 |
2312933 | 2312933 | 2022-03-16 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2309680 | 2309680 | 2022-03-15 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2306427 | 2306427 | 2022-03-14 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2303176 | 2303176 | 2022-03-13 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2299924 | 2299924 | 2022-03-12 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2296672 | 2296672 | 2022-03-11 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2293420 | 2293420 | 2022-03-10 | Alfalfa | Oklahoma | 40003 | 1713 | 14 |
2285252 | 2285252 | 2022-03-08 | Miller | Georgia | 13201 | 1713 | 30 |
2265924 | 2265924 | 2022-03-02 | Pulaski | Illinois | 17153 | 1713 | 18 |
2262673 | 2262673 | 2022-03-01 | Pulaski | Illinois | 17153 | 1713 | 18 |
2202717 | 2202717 | 2022-02-10 | Hutchinson | South Dakota | 46067 | 1713 | 33 |
2199463 | 2199463 | 2022-02-09 | Hutchinson | South Dakota | 46067 | 1713 | 33 |
2192955 | 2192955 | 2022-02-07 | Hutchinson | South Dakota | 46067 | 1713 | 33 |
2172480 | 2172480 | 2022-02-01 | Harrison | Missouri | 29081 | 1713 | 27 |
2129672 | 2129672 | 2022-01-19 | Cumberland | Kentucky | 21057 | 1713 | 23 |
2122558 | 2122558 | 2022-01-17 | Clinch | Georgia | 13065 | 1713 | 36 |
2110291 | 2110291 | 2022-01-13 | Red River | Louisiana | 22081 | 1713 | 49 |
2110507 | 2110507 | 2022-01-13 | Murray | Minnesota | 27101 | 1713 | 14 |
2107040 | 2107040 | 2022-01-12 | Red River | Louisiana | 22081 | 1713 | 49 |
2107589 | 2107589 | 2022-01-12 | Hamilton | Nebraska | 31081 | 1713 | 21 |
2103038 | 2103038 | 2022-01-11 | Candler | Georgia | 13043 | 1713 | 91 |
2103789 | 2103789 | 2022-01-11 | Red River | Louisiana | 22081 | 1713 | 49 |
2105079 | 2105079 | 2022-01-11 | McCormick | South Carolina | 45065 | 1713 | 32 |
2105291 | 2105291 | 2022-01-11 | Clay | Texas | 48077 | 1713 | 26 |
2097055 | 2097055 | 2022-01-09 | Grant | Kansas | 20067 | 1713 | 33 |
2097090 | 2097090 | 2022-01-09 | Norton | Kansas | 20137 | 1713 | 35 |
2093803 | 2093803 | 2022-01-08 | Grant | Kansas | 20067 | 1713 | 33 |
2093838 | 2093838 | 2022-01-08 | Norton | Kansas | 20137 | 1713 | 35 |
2090551 | 2090551 | 2022-01-07 | Grant | Kansas | 20067 | 1713 | 33 |
2090586 | 2090586 | 2022-01-07 | Norton | Kansas | 20137 | 1713 | 35 |
2087712 | 2087712 | 2022-01-06 | Clearwater | Minnesota | 27029 | 1713 | 25 |
2080731 | 2080731 | 2022-01-04 | Montgomery | Iowa | 19137 | 1713 | 48 |
2077479 | 2077479 | 2022-01-03 | Montgomery | Iowa | 19137 | 1713 | 48 |
2074228 | 2074228 | 2022-01-02 | Montgomery | Iowa | 19137 | 1713 | 48 |
2070977 | 2070977 | 2022-01-01 | Montgomery | Iowa | 19137 | 1713 | 48 |
2067726 | 2067726 | 2021-12-31 | Montgomery | Iowa | 19137 | 1713 | 48 |
2064475 | 2064475 | 2021-12-30 | Montgomery | Iowa | 19137 | 1713 | 48 |
2061225 | 2061225 | 2021-12-29 | Montgomery | Iowa | 19137 | 1713 | 48 |
2043831 | 2043831 | 2021-12-23 | Floyd | Virginia | 51063 | 1713 | 32 |
1986170 | 1986170 | 2021-12-06 | Boundary | Idaho | 16021 | 1713 | 48 |
1961137 | 1961137 | 2021-11-28 | Grundy | Missouri | 29079 | 1713 | 55 |
1957886 | 1957886 | 2021-11-27 | Grundy | Missouri | 29079 | 1713 | 55 |
1954635 | 1954635 | 2021-11-26 | Grundy | Missouri | 29079 | 1713 | 55 |
1951384 | 1951384 | 2021-11-25 | Grundy | Missouri | 29079 | 1713 | 55 |
1948133 | 1948133 | 2021-11-24 | Grundy | Missouri | 29079 | 1713 | 55 |
1929001 | 1929001 | 2021-11-18 | Alleghany | North Carolina | 37005 | 1713 | 6 |
1895128 | 1895128 | 2021-11-08 | Turner | Georgia | 13287 | 1713 | 49 |
1891878 | 1891878 | 2021-11-07 | Turner | Georgia | 13287 | 1713 | 49 |
1888628 | 1888628 | 2021-11-06 | Turner | Georgia | 13287 | 1713 | 49 |
1885378 | 1885378 | 2021-11-05 | Turner | Georgia | 13287 | 1713 | 49 |
1882129 | 1882129 | 2021-11-04 | Turner | Georgia | 13287 | 1713 | 49 |
1868679 | 1868679 | 2021-10-31 | Ketchikan Gateway Borough | Alaska | 2130 | 1713 | 9 |
1870156 | 1870156 | 2021-10-31 | Lewis | Missouri | 29111 | 1713 | 22 |
1865430 | 1865430 | 2021-10-30 | Ketchikan Gateway Borough | Alaska | 2130 | 1713 | 9 |
1867257 | 1867257 | 2021-10-30 | Yates | New York | 36123 | 1713 | 29 |
1862181 | 1862181 | 2021-10-29 | Ketchikan Gateway Borough | Alaska | 2130 | 1713 | 9 |
1849190 | 1849190 | 2021-10-25 | Northwest Arctic Borough | Alaska | 2188 | 1713 | 7 |
1850325 | 1850325 | 2021-10-25 | Kent | Maryland | 24029 | 1713 | 56 |
1851141 | 1851141 | 2021-10-25 | Mercer | North Dakota | 38057 | 1713 | 12 |
1848330 | 1848330 | 2021-10-24 | Charles Mix | South Dakota | 46023 | 1713 | 26 |
1845080 | 1845080 | 2021-10-23 | Charles Mix | South Dakota | 46023 | 1713 | 26 |
1841830 | 1841830 | 2021-10-22 | Charles Mix | South Dakota | 46023 | 1713 | 26 |
1837219 | 1837219 | 2021-10-21 | Todd | Kentucky | 21219 | 1713 | 30 |
1831058 | 1831058 | 2021-10-19 | Jefferson Davis | Mississippi | 28065 | 1713 | 42 |
1815123 | 1815123 | 2021-10-14 | Unknown | Nebraska | 1713 | 124 | |
1811623 | 1811623 | 2021-10-13 | Bollinger | Missouri | 29017 | 1713 | 19 |
1806823 | 1806823 | 2021-10-11 | Price | Wisconsin | 55099 | 1713 | 9 |
1803452 | 1803452 | 2021-10-10 | Pacific | Washington | 53049 | 1713 | 28 |
1800203 | 1800203 | 2021-10-09 | Pacific | Washington | 53049 | 1713 | 28 |
1796954 | 1796954 | 2021-10-08 | Pacific | Washington | 53049 | 1713 | 28 |
1792716 | 1792716 | 2021-10-07 | Harrison | Ohio | 39067 | 1713 | 41 |
1790426 | 1790426 | 2021-10-06 | Westmoreland | Virginia | 51193 | 1713 | 31 |
1766863 | 1766863 | 2021-09-29 | Curry | Oregon | 41015 | 1713 | 18 |
1758330 | 1758330 | 2021-09-27 | Inyo | California | 6027 | 1713 | 39 |
1755411 | 1755411 | 2021-09-26 | Towns | Georgia | 13281 | 1713 | 71 |
1755979 | 1755979 | 2021-09-26 | Pendleton | Kentucky | 21191 | 1713 | 12 |
1752163 | 1752163 | 2021-09-25 | Towns | Georgia | 13281 | 1713 | 71 |
1752731 | 1752731 | 2021-09-25 | Pendleton | Kentucky | 21191 | 1713 | 12 |
1748914 | 1748914 | 2021-09-24 | Towns | Georgia | 13281 | 1713 | 71 |
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);