ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
143 rows where cases = 4341 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 19
- Texas 13
- Iowa 11
- Michigan 10
- Indiana 9
- Wisconsin 8
- Minnesota 6
- Alabama 5
- Ohio 5
- Tennessee 5
- Virginia 5
- Illinois 4
- Louisiana 4
- Colorado 3
- Georgia 3
- Maine 3
- Mississippi 3
- New York 3
- Florida 2
- Kansas 2
- North Carolina 2
- Oklahoma 2
- Pennsylvania 2
- Puerto Rico 2
- Washington 2
- Arkansas 1
- California 1
- Hawaii 1
- Maryland 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500691 | 2500691 | 2022-05-13 | Union | Kentucky | 21225 | 4341 | 57 |
2497433 | 2497433 | 2022-05-12 | Union | Kentucky | 21225 | 4341 | 57 |
2494175 | 2494175 | 2022-05-11 | Union | Kentucky | 21225 | 4341 | 57 |
2490917 | 2490917 | 2022-05-10 | Union | Kentucky | 21225 | 4341 | 57 |
2487660 | 2487660 | 2022-05-09 | Union | Kentucky | 21225 | 4341 | 57 |
2484402 | 2484402 | 2022-05-08 | Union | Kentucky | 21225 | 4341 | 57 |
2481144 | 2481144 | 2022-05-07 | Union | Kentucky | 21225 | 4341 | 57 |
2477886 | 2477886 | 2022-05-06 | Union | Kentucky | 21225 | 4341 | 57 |
2474628 | 2474628 | 2022-05-05 | Union | Kentucky | 21225 | 4341 | 57 |
2471371 | 2471371 | 2022-05-04 | Union | Kentucky | 21225 | 4341 | 57 |
2468115 | 2468115 | 2022-05-03 | Union | Kentucky | 21225 | 4341 | 57 |
2464860 | 2464860 | 2022-05-02 | Union | Kentucky | 21225 | 4341 | 57 |
2441556 | 2441556 | 2022-04-25 | Bond | Illinois | 17005 | 4341 | 37 |
2438300 | 2438300 | 2022-04-24 | Bond | Illinois | 17005 | 4341 | 37 |
2435044 | 2435044 | 2022-04-23 | Bond | Illinois | 17005 | 4341 | 37 |
2431788 | 2431788 | 2022-04-22 | Bond | Illinois | 17005 | 4341 | 37 |
2420932 | 2420932 | 2022-04-18 | Lamb | Texas | 48279 | 4341 | 122 |
2417676 | 2417676 | 2022-04-17 | Lamb | Texas | 48279 | 4341 | 122 |
2414420 | 2414420 | 2022-04-16 | Lamb | Texas | 48279 | 4341 | 122 |
2411164 | 2411164 | 2022-04-15 | Lamb | Texas | 48279 | 4341 | 122 |
2407908 | 2407908 | 2022-04-14 | Lamb | Texas | 48279 | 4341 | 122 |
2261686 | 2261686 | 2022-02-28 | Bristol city | Virginia | 51520 | 4341 | 71 |
2230779 | 2230779 | 2022-02-19 | Manistee | Michigan | 26101 | 4341 | 80 |
2227528 | 2227528 | 2022-02-18 | Manistee | Michigan | 26101 | 4341 | 80 |
2223885 | 2223885 | 2022-02-17 | Bourbon | Kansas | 20011 | 4341 | 46 |
2224277 | 2224277 | 2022-02-17 | Manistee | Michigan | 26101 | 4341 | 80 |
2220634 | 2220634 | 2022-02-16 | Bourbon | Kansas | 20011 | 4341 | 46 |
2221026 | 2221026 | 2022-02-16 | Manistee | Michigan | 26101 | 4341 | 80 |
2193742 | 2193742 | 2022-02-08 | Henry | Alabama | 1067 | 4341 | 67 |
2168890 | 2168890 | 2022-01-31 | Waldo | Maine | 23027 | 4341 | 48 |
2165635 | 2165635 | 2022-01-30 | Waldo | Maine | 23027 | 4341 | 48 |
2162380 | 2162380 | 2022-01-29 | Waldo | Maine | 23027 | 4341 | 48 |
2145655 | 2145655 | 2022-01-24 | Jay | Indiana | 18075 | 4341 | 71 |
2141703 | 2141703 | 2022-01-23 | Marengo | Alabama | 1091 | 4341 | 93 |
2126169 | 2126169 | 2022-01-18 | Sullivan | Indiana | 18153 | 4341 | 67 |
2080421 | 2080421 | 2022-01-04 | Kauai | Hawaii | 15007 | 4341 | 18 |
2074468 | 2074468 | 2022-01-02 | Russell | Kentucky | 21207 | 4341 | 66 |
2071217 | 2071217 | 2022-01-01 | Russell | Kentucky | 21207 | 4341 | 66 |
2067966 | 2067966 | 2021-12-31 | Russell | Kentucky | 21207 | 4341 | 66 |
2064715 | 2064715 | 2021-12-30 | Russell | Kentucky | 21207 | 4341 | 66 |
2061465 | 2061465 | 2021-12-29 | Russell | Kentucky | 21207 | 4341 | 66 |
2040631 | 2040631 | 2021-12-22 | Orange | Virginia | 51137 | 4341 | 68 |
2036972 | 2036972 | 2021-12-21 | Smith | Tennessee | 47159 | 4341 | 55 |
2031048 | 2031048 | 2021-12-19 | Kewaunee | Wisconsin | 55061 | 4341 | 49 |
2027797 | 2027797 | 2021-12-18 | Kewaunee | Wisconsin | 55061 | 4341 | 49 |
2024546 | 2024546 | 2021-12-17 | Kewaunee | Wisconsin | 55061 | 4341 | 49 |
1998524 | 1998524 | 2021-12-09 | Door | Wisconsin | 55029 | 4341 | 43 |
1991970 | 1991970 | 2021-12-07 | Jackson | West Virginia | 54035 | 4341 | 94 |
1973106 | 1973106 | 2021-12-02 | Pierce | Georgia | 13229 | 4341 | 106 |
1943124 | 1943124 | 2021-11-22 | Pulaski | Virginia | 51155 | 4341 | 92 |
1938105 | 1938105 | 2021-11-21 | Clare | Michigan | 26035 | 4341 | 113 |
1934855 | 1934855 | 2021-11-20 | Clare | Michigan | 26035 | 4341 | 113 |
1931605 | 1931605 | 2021-11-19 | Clare | Michigan | 26035 | 4341 | 113 |
1890185 | 1890185 | 2021-11-06 | Gallia | Ohio | 39053 | 4341 | 73 |
1881741 | 1881741 | 2021-11-04 | Jackson | Arkansas | 5067 | 4341 | 45 |
1882871 | 1882871 | 2021-11-04 | Houghton | Michigan | 26061 | 4341 | 56 |
1879142 | 1879142 | 2021-11-03 | Wells | Indiana | 18179 | 4341 | 91 |
1879622 | 1879622 | 2021-11-03 | Houghton | Michigan | 26061 | 4341 | 56 |
1860939 | 1860939 | 2021-10-28 | Fayette | Ohio | 39047 | 4341 | 64 |
1852295 | 1852295 | 2021-10-25 | Lincoln | Wisconsin | 55069 | 4341 | 110 |
1837990 | 1837990 | 2021-10-21 | Orleans | New York | 36073 | 4341 | 87 |
1811202 | 1811202 | 2021-10-13 | Mercer | Kentucky | 21167 | 4341 | 72 |
1768594 | 1768594 | 2021-09-30 | Daviess | Indiana | 18027 | 4341 | 111 |
1759784 | 1759784 | 2021-09-27 | Ravalli | Montana | 30081 | 4341 | 56 |
1747542 | 1747542 | 2021-09-23 | Vega Baja | Puerto Rico | 72145 | 4341 | |
1743237 | 1743237 | 2021-09-22 | Freeborn | Minnesota | 27047 | 4341 | 40 |
1739508 | 1739508 | 2021-09-21 | Plymouth | Iowa | 19149 | 4341 | 83 |
1736259 | 1736259 | 2021-09-20 | Plymouth | Iowa | 19149 | 4341 | 83 |
1733009 | 1733009 | 2021-09-19 | Plymouth | Iowa | 19149 | 4341 | 83 |
1729759 | 1729759 | 2021-09-18 | Plymouth | Iowa | 19149 | 4341 | 83 |
1726509 | 1726509 | 2021-09-17 | Plymouth | Iowa | 19149 | 4341 | 83 |
1723260 | 1723260 | 2021-09-16 | Plymouth | Iowa | 19149 | 4341 | 83 |
1720011 | 1720011 | 2021-09-15 | Plymouth | Iowa | 19149 | 4341 | 83 |
1722009 | 1722009 | 2021-09-15 | Willacy | Texas | 48489 | 4341 | 100 |
1697633 | 1697633 | 2021-09-08 | Worcester | Maryland | 24047 | 4341 | 110 |
1695911 | 1695911 | 2021-09-07 | Kendall | Texas | 48259 | 4341 | 80 |
1690196 | 1690196 | 2021-09-06 | Montrose | Colorado | 8085 | 4341 | 74 |
1692663 | 1692663 | 2021-09-06 | Kendall | Texas | 48259 | 4341 | 80 |
1689414 | 1689414 | 2021-09-05 | Kendall | Texas | 48259 | 4341 | 80 |
1686164 | 1686164 | 2021-09-04 | Kendall | Texas | 48259 | 4341 | 79 |
1645847 | 1645847 | 2021-08-23 | Alcorn | Mississippi | 28003 | 4341 | 78 |
1642512 | 1642512 | 2021-08-22 | Beltrami | Minnesota | 27007 | 4341 | 65 |
1639262 | 1639262 | 2021-08-21 | Beltrami | Minnesota | 27007 | 4341 | 65 |
1636012 | 1636012 | 2021-08-20 | Beltrami | Minnesota | 27007 | 4341 | 65 |
1632212 | 1632212 | 2021-08-19 | Steuben | Indiana | 18151 | 4341 | 65 |
1626065 | 1626065 | 2021-08-17 | Beauregard | Louisiana | 22011 | 4341 | 84 |
1582985 | 1582985 | 2021-08-04 | La Plata | Colorado | 8067 | 4341 | 44 |
1578830 | 1578830 | 2021-08-02 | Weakley | Tennessee | 47183 | 4341 | 69 |
1536121 | 1536121 | 2021-07-20 | Putnam | Ohio | 39137 | 4341 | 104 |
1460209 | 1460209 | 2021-06-27 | Wapello | Iowa | 19179 | 4341 | 122 |
1460448 | 1460448 | 2021-06-27 | Avoyelles | Louisiana | 22009 | 4341 | 124 |
1456964 | 1456964 | 2021-06-26 | Wapello | Iowa | 19179 | 4341 | 122 |
1457203 | 1457203 | 2021-06-26 | Avoyelles | Louisiana | 22009 | 4341 | 124 |
1453958 | 1453958 | 2021-06-25 | Avoyelles | Louisiana | 22009 | 4341 | 124 |
1414640 | 1414640 | 2021-06-13 | Montgomery | Indiana | 18107 | 4341 | 92 |
1411395 | 1411395 | 2021-06-12 | Montgomery | Indiana | 18107 | 4341 | 92 |
1399552 | 1399552 | 2021-06-08 | Tompkins | New York | 36109 | 4341 | 52 |
1396307 | 1396307 | 2021-06-07 | Tompkins | New York | 36109 | 4341 | 52 |
1362671 | 1362671 | 2021-05-28 | Clinton | Indiana | 18023 | 4341 | 58 |
1360064 | 1360064 | 2021-05-27 | Isanti | Minnesota | 27059 | 4341 | 64 |
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);