ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
562 rows where cases = 1135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 165
- Iowa 63
- Virginia 29
- Missouri 23
- Kentucky 18
- Georgia 16
- Texas 15
- Indiana 14
- Tennessee 14
- Arkansas 11
- Ohio 11
- Oklahoma 11
- Puerto Rico 11
- Mississippi 10
- Illinois 9
- Louisiana 9
- Minnesota 8
- Montana 8
- New Mexico 8
- Colorado 7
- Nebraska 7
- Washington 7
- West Virginia 7
- New York 6
- North Dakota 6
- Wisconsin 6
- Alabama 5
- California 5
- Idaho 5
- Michigan 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500452 | 2500452 | 2022-05-13 | Ringgold | Iowa | 19159 | 1135 | 34 |
2497194 | 2497194 | 2022-05-12 | Ringgold | Iowa | 19159 | 1135 | 34 |
2493936 | 2493936 | 2022-05-11 | Ringgold | Iowa | 19159 | 1135 | 34 |
2467876 | 2467876 | 2022-05-03 | Ringgold | Iowa | 19159 | 1135 | 34 |
2464621 | 2464621 | 2022-05-02 | Ringgold | Iowa | 19159 | 1135 | 34 |
2461365 | 2461365 | 2022-05-01 | Ringgold | Iowa | 19159 | 1135 | 34 |
2458109 | 2458109 | 2022-04-30 | Ringgold | Iowa | 19159 | 1135 | 34 |
2454853 | 2454853 | 2022-04-29 | Ringgold | Iowa | 19159 | 1135 | 34 |
2451597 | 2451597 | 2022-04-28 | Ringgold | Iowa | 19159 | 1135 | 34 |
2448341 | 2448341 | 2022-04-27 | Ringgold | Iowa | 19159 | 1135 | 34 |
2445085 | 2445085 | 2022-04-26 | Ringgold | Iowa | 19159 | 1135 | 34 |
2441829 | 2441829 | 2022-04-25 | Ringgold | Iowa | 19159 | 1135 | 34 |
2438573 | 2438573 | 2022-04-24 | Ringgold | Iowa | 19159 | 1135 | 34 |
2435317 | 2435317 | 2022-04-23 | Ringgold | Iowa | 19159 | 1135 | 34 |
2432061 | 2432061 | 2022-04-22 | Ringgold | Iowa | 19159 | 1135 | 34 |
2428805 | 2428805 | 2022-04-21 | Ringgold | Iowa | 19159 | 1135 | 34 |
2425549 | 2425549 | 2022-04-20 | Ringgold | Iowa | 19159 | 1135 | 34 |
2422293 | 2422293 | 2022-04-19 | Ringgold | Iowa | 19159 | 1135 | 34 |
2419037 | 2419037 | 2022-04-18 | Ringgold | Iowa | 19159 | 1135 | 34 |
2415781 | 2415781 | 2022-04-17 | Ringgold | Iowa | 19159 | 1135 | 34 |
2412525 | 2412525 | 2022-04-16 | Ringgold | Iowa | 19159 | 1135 | 34 |
2409269 | 2409269 | 2022-04-15 | Ringgold | Iowa | 19159 | 1135 | 34 |
2406013 | 2406013 | 2022-04-14 | Ringgold | Iowa | 19159 | 1135 | 34 |
2402757 | 2402757 | 2022-04-13 | Ringgold | Iowa | 19159 | 1135 | 34 |
2392794 | 2392794 | 2022-04-10 | Putnam | Illinois | 17155 | 1135 | 10 |
2389538 | 2389538 | 2022-04-09 | Putnam | Illinois | 17155 | 1135 | 10 |
2386283 | 2386283 | 2022-04-08 | Putnam | Illinois | 17155 | 1135 | 10 |
2383028 | 2383028 | 2022-04-07 | Putnam | Illinois | 17155 | 1135 | 10 |
2331285 | 2331285 | 2022-03-22 | Stafford | Kansas | 20185 | 1135 | 26 |
2328033 | 2328033 | 2022-03-21 | Stafford | Kansas | 20185 | 1135 | 26 |
2324780 | 2324780 | 2022-03-20 | Stafford | Kansas | 20185 | 1135 | 26 |
2321526 | 2321526 | 2022-03-19 | Stafford | Kansas | 20185 | 1135 | 26 |
2318272 | 2318272 | 2022-03-18 | Stafford | Kansas | 20185 | 1135 | 26 |
2255793 | 2255793 | 2022-02-27 | Saguache | Colorado | 8109 | 1135 | 12 |
2252542 | 2252542 | 2022-02-26 | Saguache | Colorado | 8109 | 1135 | 12 |
2249291 | 2249291 | 2022-02-25 | Saguache | Colorado | 8109 | 1135 | 12 |
2242188 | 2242188 | 2022-02-22 | Charles City | Virginia | 51036 | 1135 | 26 |
2217001 | 2217001 | 2022-02-15 | Talbot | Georgia | 13263 | 1135 | 31 |
2217520 | 2217520 | 2022-02-15 | Fulton | Kentucky | 21075 | 1135 | 23 |
2214269 | 2214269 | 2022-02-14 | Fulton | Kentucky | 21075 | 1135 | 23 |
2199680 | 2199680 | 2022-02-09 | Goliad | Texas | 48175 | 1135 | 29 |
2166099 | 2166099 | 2022-01-30 | Toole | Montana | 30101 | 1135 | 22 |
2162844 | 2162844 | 2022-01-29 | Toole | Montana | 30101 | 1135 | 22 |
2159589 | 2159589 | 2022-01-28 | Toole | Montana | 30101 | 1135 | 22 |
2127437 | 2127437 | 2022-01-18 | Sioux | North Dakota | 38085 | 1135 | 18 |
2119646 | 2119646 | 2022-01-16 | Ohio | Indiana | 18115 | 1135 | 16 |
2120915 | 2120915 | 2022-01-16 | McHenry | North Dakota | 38049 | 1135 | 28 |
2116394 | 2116394 | 2022-01-15 | Ohio | Indiana | 18115 | 1135 | 16 |
2113143 | 2113143 | 2022-01-14 | Ohio | Indiana | 18115 | 1135 | 16 |
2087723 | 2087723 | 2022-01-06 | Grant | Minnesota | 27051 | 1135 | 12 |
2081696 | 2081696 | 2022-01-04 | Los Alamos | New Mexico | 35028 | 1135 | 11 |
2061835 | 2061835 | 2021-12-29 | Quitman | Mississippi | 28119 | 1135 | 28 |
2037358 | 2037358 | 2021-12-21 | Lancaster | Virginia | 51103 | 1135 | 24 |
2019830 | 2019830 | 2021-12-16 | Keith | Nebraska | 31101 | 1135 | 11 |
2010114 | 2010114 | 2021-12-13 | Thurston | Nebraska | 31173 | 1135 | 17 |
2007705 | 2007705 | 2021-12-12 | Pickett | Tennessee | 47137 | 1135 | 26 |
2004454 | 2004454 | 2021-12-11 | Pickett | Tennessee | 47137 | 1135 | 26 |
2001203 | 2001203 | 2021-12-10 | Pickett | Tennessee | 47137 | 1135 | 26 |
1997953 | 1997953 | 2021-12-09 | Pickett | Tennessee | 47137 | 1135 | 26 |
1994702 | 1994702 | 2021-12-08 | Pickett | Tennessee | 47137 | 1135 | 26 |
1994753 | 1994753 | 2021-12-08 | Brooks | Texas | 48047 | 1135 | 47 |
1974618 | 1974618 | 2021-12-02 | Dickey | North Dakota | 38021 | 1135 | 37 |
1945831 | 1945831 | 2021-11-23 | Fall River | South Dakota | 46047 | 1135 | 24 |
1918129 | 1918129 | 2021-11-15 | Union | Indiana | 18161 | 1135 | 17 |
1906187 | 1906187 | 2021-11-11 | Sierra | New Mexico | 35051 | 1135 | 57 |
1902938 | 1902938 | 2021-11-10 | Sierra | New Mexico | 35051 | 1135 | 57 |
1896134 | 1896134 | 2021-11-08 | Harrison | Missouri | 29081 | 1135 | 17 |
1892244 | 1892244 | 2021-11-07 | Anderson | Kansas | 20003 | 1135 | 22 |
1888994 | 1888994 | 2021-11-06 | Anderson | Kansas | 20003 | 1135 | 22 |
1885744 | 1885744 | 2021-11-05 | Anderson | Kansas | 20003 | 1135 | 22 |
1878244 | 1878244 | 2021-11-02 | Tucker | West Virginia | 54093 | 1135 | 29 |
1863613 | 1863613 | 2021-10-29 | Caldwell | Missouri | 29025 | 1135 | 20 |
1857115 | 1857115 | 2021-10-27 | Caldwell | Missouri | 29025 | 1135 | 20 |
1857525 | 1857525 | 2021-10-27 | Camden | North Carolina | 37029 | 1135 | 8 |
1854544 | 1854544 | 2021-10-26 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1854751 | 1854751 | 2021-10-26 | San German | Puerto Rico | 72125 | 1135 | |
1851295 | 1851295 | 2021-10-25 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1851502 | 1851502 | 2021-10-25 | San German | Puerto Rico | 72125 | 1135 | |
1852256 | 1852256 | 2021-10-25 | Webster | West Virginia | 54101 | 1135 | 17 |
1848045 | 1848045 | 2021-10-24 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1844795 | 1844795 | 2021-10-23 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1839487 | 1839487 | 2021-10-22 | Dallas | Arkansas | 5039 | 1135 | 19 |
1841545 | 1841545 | 2021-10-22 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1836238 | 1836238 | 2021-10-21 | Dallas | Arkansas | 5039 | 1135 | 19 |
1838296 | 1838296 | 2021-10-21 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1833421 | 1833421 | 2021-10-20 | Benewah | Idaho | 16009 | 1135 | 19 |
1835047 | 1835047 | 2021-10-20 | Kiowa | Oklahoma | 40075 | 1135 | 39 |
1835914 | 1835914 | 2021-10-20 | Williamsburg city | Virginia | 51830 | 1135 | 14 |
1831300 | 1831300 | 2021-10-19 | Cuming | Nebraska | 31039 | 1135 | 15 |
1824802 | 1824802 | 2021-10-17 | Cuming | Nebraska | 31039 | 1135 | 15 |
1826125 | 1826125 | 2021-10-17 | Northampton | Virginia | 51131 | 1135 | 41 |
1821553 | 1821553 | 2021-10-16 | Cuming | Nebraska | 31039 | 1135 | 15 |
1822876 | 1822876 | 2021-10-16 | Northampton | Virginia | 51131 | 1135 | 41 |
1818304 | 1818304 | 2021-10-15 | Cuming | Nebraska | 31039 | 1135 | 15 |
1819627 | 1819627 | 2021-10-15 | Northampton | Virginia | 51131 | 1135 | 41 |
1813317 | 1813317 | 2021-10-13 | Pepin | Wisconsin | 55091 | 1135 | 10 |
1813352 | 1813352 | 2021-10-13 | Johnson | Wyoming | 56019 | 1135 | 15 |
1796787 | 1796787 | 2021-10-08 | Orange | Vermont | 50017 | 1135 | 4 |
1787675 | 1787675 | 2021-10-06 | San Miguel | Colorado | 8113 | 1135 | 3 |
1782277 | 1782277 | 2021-10-04 | Stevens | Minnesota | 27149 | 1135 | 11 |
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);