ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
317 rows where cases = 2027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 41
- Texas 22
- Minnesota 18
- Kentucky 15
- Montana 15
- South Dakota 15
- Arkansas 13
- Missouri 13
- Georgia 12
- Iowa 12
- North Carolina 11
- Colorado 10
- Virginia 10
- Wisconsin 9
- Puerto Rico 8
- Tennessee 8
- Nebraska 7
- Oklahoma 7
- West Virginia 7
- Illinois 6
- Michigan 6
- Florida 5
- Louisiana 5
- Nevada 5
- Pennsylvania 5
- Indiana 4
- Mississippi 4
- New York 4
- Ohio 4
- Alabama 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500360 | 2500360 | 2022-05-13 | Union | Indiana | 18161 | 2027 | 21 |
2416284 | 2416284 | 2022-04-17 | Murray | Minnesota | 27101 | 2027 | 16 |
2413028 | 2413028 | 2022-04-16 | Murray | Minnesota | 27101 | 2027 | 16 |
2409772 | 2409772 | 2022-04-15 | Murray | Minnesota | 27101 | 2027 | 16 |
2406516 | 2406516 | 2022-04-14 | Murray | Minnesota | 27101 | 2027 | 16 |
2403260 | 2403260 | 2022-04-13 | Murray | Minnesota | 27101 | 2027 | 16 |
2400006 | 2400006 | 2022-04-12 | Murray | Minnesota | 27101 | 2027 | 16 |
2401110 | 2401110 | 2022-04-12 | Custer | South Dakota | 46033 | 2027 | 25 |
2396750 | 2396750 | 2022-04-11 | Murray | Minnesota | 27101 | 2027 | 16 |
2397855 | 2397855 | 2022-04-11 | Custer | South Dakota | 46033 | 2027 | 25 |
2393495 | 2393495 | 2022-04-10 | Murray | Minnesota | 27101 | 2027 | 16 |
2394600 | 2394600 | 2022-04-10 | Custer | South Dakota | 46033 | 2027 | 25 |
2390239 | 2390239 | 2022-04-09 | Murray | Minnesota | 27101 | 2027 | 16 |
2391344 | 2391344 | 2022-04-09 | Custer | South Dakota | 46033 | 2027 | 25 |
2386983 | 2386983 | 2022-04-08 | Murray | Minnesota | 27101 | 2027 | 16 |
2388088 | 2388088 | 2022-04-08 | Custer | South Dakota | 46033 | 2027 | 25 |
2383728 | 2383728 | 2022-04-07 | Murray | Minnesota | 27101 | 2027 | 16 |
2384833 | 2384833 | 2022-04-07 | Custer | South Dakota | 46033 | 2027 | 25 |
2381578 | 2381578 | 2022-04-06 | Custer | South Dakota | 46033 | 2027 | 25 |
2378323 | 2378323 | 2022-04-05 | Custer | South Dakota | 46033 | 2027 | 24 |
2375069 | 2375069 | 2022-04-04 | Custer | South Dakota | 46033 | 2027 | 24 |
2371817 | 2371817 | 2022-04-03 | Custer | South Dakota | 46033 | 2027 | 24 |
2368564 | 2368564 | 2022-04-02 | Custer | South Dakota | 46033 | 2027 | 24 |
2365311 | 2365311 | 2022-04-01 | Custer | South Dakota | 46033 | 2027 | 24 |
2362058 | 2362058 | 2022-03-31 | Custer | South Dakota | 46033 | 2027 | 24 |
2358804 | 2358804 | 2022-03-30 | Custer | South Dakota | 46033 | 2027 | 24 |
2308394 | 2308394 | 2022-03-15 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2305143 | 2305143 | 2022-03-14 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2301891 | 2301891 | 2022-03-13 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2298639 | 2298639 | 2022-03-12 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2295387 | 2295387 | 2022-03-11 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2292135 | 2292135 | 2022-03-10 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2288883 | 2288883 | 2022-03-09 | Palo Alto | Iowa | 19147 | 2027 | 37 |
2282875 | 2282875 | 2022-03-07 | Lake | Minnesota | 27075 | 2027 | 28 |
2283129 | 2283129 | 2022-03-07 | Carbon | Montana | 30009 | 2027 | 28 |
2256864 | 2256864 | 2022-02-27 | Marshall | Minnesota | 27089 | 2027 | 23 |
2253613 | 2253613 | 2022-02-26 | Marshall | Minnesota | 27089 | 2027 | 23 |
2250362 | 2250362 | 2022-02-25 | Marshall | Minnesota | 27089 | 2027 | 23 |
2246022 | 2246022 | 2022-02-24 | Lincoln | Colorado | 8073 | 2027 | 9 |
2228899 | 2228899 | 2022-02-18 | Clay | Texas | 48077 | 2027 | 30 |
2223508 | 2223508 | 2022-02-17 | Terrell | Georgia | 13273 | 2027 | 60 |
2218852 | 2218852 | 2022-02-15 | Jayuya | Puerto Rico | 72073 | 2027 | |
2215601 | 2215601 | 2022-02-14 | Jayuya | Puerto Rico | 72073 | 2027 | |
2212350 | 2212350 | 2022-02-13 | Jayuya | Puerto Rico | 72073 | 2027 | |
2196418 | 2196418 | 2022-02-08 | Franklin | Texas | 48159 | 2027 | 37 |
2187722 | 2187722 | 2022-02-06 | Stewart | Georgia | 13259 | 2027 | 31 |
2184469 | 2184469 | 2022-02-05 | Stewart | Georgia | 13259 | 2027 | 31 |
2181217 | 2181217 | 2022-02-04 | Stewart | Georgia | 13259 | 2027 | 31 |
2176827 | 2176827 | 2022-02-02 | Archer | Texas | 48009 | 2027 | 24 |
2168851 | 2168851 | 2022-01-31 | Red River | Louisiana | 22081 | 2027 | 49 |
2159979 | 2159979 | 2022-01-28 | Traill | North Dakota | 38097 | 2027 | 22 |
2131668 | 2131668 | 2022-01-19 | Poquoson city | Virginia | 51735 | 2027 | 24 |
2087733 | 2087733 | 2022-01-06 | Koochiching | Minnesota | 27071 | 2027 | 31 |
2063745 | 2063745 | 2021-12-30 | Fulton | Arkansas | 5049 | 2027 | 78 |
2059801 | 2059801 | 2021-12-28 | Duval | Texas | 48131 | 2027 | 61 |
2050860 | 2050860 | 2021-12-26 | Archuleta | Colorado | 8007 | 2027 | 9 |
2047610 | 2047610 | 2021-12-25 | Archuleta | Colorado | 8007 | 2027 | 9 |
2044360 | 2044360 | 2021-12-24 | Archuleta | Colorado | 8007 | 2027 | 9 |
2034658 | 2034658 | 2021-12-21 | Prowers | Colorado | 8099 | 2027 | 42 |
2004719 | 2004719 | 2021-12-11 | Ward | Texas | 48475 | 2027 | 35 |
1984929 | 1984929 | 2021-12-05 | Lake | Tennessee | 47095 | 2027 | 31 |
1981679 | 1981679 | 2021-12-04 | Lake | Tennessee | 47095 | 2027 | 31 |
1975968 | 1975968 | 2021-12-03 | Bradley | Arkansas | 5011 | 2027 | 41 |
1978429 | 1978429 | 2021-12-03 | Lake | Tennessee | 47095 | 2027 | 31 |
1975179 | 1975179 | 2021-12-02 | Lake | Tennessee | 47095 | 2027 | 31 |
1971930 | 1971930 | 2021-12-01 | Lake | Tennessee | 47095 | 2027 | 31 |
1968297 | 1968297 | 2021-11-30 | Love | Oklahoma | 40085 | 2027 | 29 |
1965046 | 1965046 | 2021-11-29 | Love | Oklahoma | 40085 | 2027 | 29 |
1961592 | 1961592 | 2021-11-28 | Swain | North Carolina | 37173 | 2027 | 28 |
1961794 | 1961794 | 2021-11-28 | Love | Oklahoma | 40085 | 2027 | 29 |
1958341 | 1958341 | 2021-11-27 | Swain | North Carolina | 37173 | 2027 | 28 |
1958543 | 1958543 | 2021-11-27 | Love | Oklahoma | 40085 | 2027 | 29 |
1955090 | 1955090 | 2021-11-26 | Swain | North Carolina | 37173 | 2027 | 28 |
1955292 | 1955292 | 2021-11-26 | Love | Oklahoma | 40085 | 2027 | 29 |
1951839 | 1951839 | 2021-11-25 | Swain | North Carolina | 37173 | 2027 | 28 |
1952041 | 1952041 | 2021-11-25 | Love | Oklahoma | 40085 | 2027 | 29 |
1948588 | 1948588 | 2021-11-24 | Swain | North Carolina | 37173 | 2027 | 28 |
1948790 | 1948790 | 2021-11-24 | Love | Oklahoma | 40085 | 2027 | 29 |
1941684 | 1941684 | 2021-11-22 | Ripley | Missouri | 29181 | 2027 | 48 |
1938434 | 1938434 | 2021-11-21 | Ripley | Missouri | 29181 | 2027 | 48 |
1876113 | 1876113 | 2021-11-02 | Breathitt | Kentucky | 21025 | 2027 | 29 |
1853453 | 1853453 | 2021-10-26 | Pendleton | Kentucky | 21191 | 2027 | 18 |
1837601 | 1837601 | 2021-10-21 | Webster | Mississippi | 28155 | 2027 | 46 |
1813948 | 1813948 | 2021-10-14 | Idaho | Idaho | 16049 | 2027 | 31 |
1809903 | 1809903 | 2021-10-12 | Rockbridge | Virginia | 51163 | 2027 | 56 |
1748534 | 1748534 | 2021-09-24 | Lee | Arkansas | 5077 | 2027 | 44 |
1745284 | 1745284 | 2021-09-23 | Lee | Arkansas | 5077 | 2027 | 44 |
1746959 | 1746959 | 2021-09-23 | Grant | New Mexico | 35017 | 2027 | 48 |
1738070 | 1738070 | 2021-09-20 | Dawson | Texas | 48115 | 2027 | 73 |
1732391 | 1732391 | 2021-09-19 | Chaffee | Colorado | 8015 | 2027 | 27 |
1733396 | 1733396 | 2021-09-19 | Charlevoix | Michigan | 26029 | 2027 | 29 |
1734820 | 1734820 | 2021-09-19 | Dawson | Texas | 48115 | 2027 | 73 |
1729141 | 1729141 | 2021-09-18 | Chaffee | Colorado | 8015 | 2027 | 27 |
1730146 | 1730146 | 2021-09-18 | Charlevoix | Michigan | 26029 | 2027 | 29 |
1730454 | 1730454 | 2021-09-18 | Mississippi | Missouri | 29133 | 2027 | 33 |
1731570 | 1731570 | 2021-09-18 | Dawson | Texas | 48115 | 2027 | 73 |
1725891 | 1725891 | 2021-09-17 | Chaffee | Colorado | 8015 | 2027 | 27 |
1726896 | 1726896 | 2021-09-17 | Charlevoix | Michigan | 26029 | 2027 | 29 |
1728320 | 1728320 | 2021-09-17 | Dawson | Texas | 48115 | 2027 | 73 |
1723744 | 1723744 | 2021-09-16 | Houston | Minnesota | 27055 | 2027 | 16 |
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);