ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
394 rows where cases = 1114 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 37
- Texas 30
- Illinois 24
- Missouri 23
- Puerto Rico 18
- Kansas 16
- Alaska 15
- Georgia 14
- Michigan 14
- Virginia 13
- Minnesota 12
- Kentucky 11
- Indiana 10
- Tennessee 10
- Alabama 9
- Idaho 9
- Oklahoma 9
- Mississippi 8
- Montana 8
- West Virginia 8
- Wisconsin 7
- Arkansas 6
- Louisiana 6
- Nevada 6
- North Carolina 6
- Ohio 6
- South Carolina 6
- Utah 6
- Oregon 5
- Wyoming 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500377 | 2500377 | 2022-05-13 | Audubon | Iowa | 19009 | 1114 | 19 |
2497119 | 2497119 | 2022-05-12 | Audubon | Iowa | 19009 | 1114 | 19 |
2493861 | 2493861 | 2022-05-11 | Audubon | Iowa | 19009 | 1114 | 19 |
2490603 | 2490603 | 2022-05-10 | Audubon | Iowa | 19009 | 1114 | 19 |
2487346 | 2487346 | 2022-05-09 | Audubon | Iowa | 19009 | 1114 | 19 |
2484088 | 2484088 | 2022-05-08 | Audubon | Iowa | 19009 | 1114 | 19 |
2480830 | 2480830 | 2022-05-07 | Audubon | Iowa | 19009 | 1114 | 19 |
2477572 | 2477572 | 2022-05-06 | Audubon | Iowa | 19009 | 1114 | 19 |
2474314 | 2474314 | 2022-05-05 | Audubon | Iowa | 19009 | 1114 | 19 |
2471057 | 2471057 | 2022-05-04 | Audubon | Iowa | 19009 | 1114 | 19 |
2467801 | 2467801 | 2022-05-03 | Audubon | Iowa | 19009 | 1114 | 19 |
2464546 | 2464546 | 2022-05-02 | Audubon | Iowa | 19009 | 1114 | 19 |
2461290 | 2461290 | 2022-05-01 | Audubon | Iowa | 19009 | 1114 | 19 |
2458034 | 2458034 | 2022-04-30 | Audubon | Iowa | 19009 | 1114 | 19 |
2454778 | 2454778 | 2022-04-29 | Audubon | Iowa | 19009 | 1114 | 19 |
2451522 | 2451522 | 2022-04-28 | Audubon | Iowa | 19009 | 1114 | 19 |
2448266 | 2448266 | 2022-04-27 | Audubon | Iowa | 19009 | 1114 | 19 |
2421087 | 2421087 | 2022-04-18 | Unknown | Vermont | 1114 | 1 | |
2304017 | 2304017 | 2022-03-13 | King and Queen | Virginia | 51097 | 1114 | 11 |
2300765 | 2300765 | 2022-03-12 | King and Queen | Virginia | 51097 | 1114 | 11 |
2297513 | 2297513 | 2022-03-11 | King and Queen | Virginia | 51097 | 1114 | 11 |
2294261 | 2294261 | 2022-03-10 | King and Queen | Virginia | 51097 | 1114 | 11 |
2241970 | 2241970 | 2022-02-22 | Hemphill | Texas | 48211 | 1114 | 6 |
2238719 | 2238719 | 2022-02-21 | Hemphill | Texas | 48211 | 1114 | 6 |
2235468 | 2235468 | 2022-02-20 | Hemphill | Texas | 48211 | 1114 | 6 |
2232217 | 2232217 | 2022-02-19 | Hemphill | Texas | 48211 | 1114 | 6 |
2228966 | 2228966 | 2022-02-18 | Hemphill | Texas | 48211 | 1114 | 6 |
2211567 | 2211567 | 2022-02-13 | Reynolds | Missouri | 29179 | 1114 | 20 |
2213216 | 2213216 | 2022-02-13 | Hot Springs | Wyoming | 56017 | 1114 | 14 |
2208314 | 2208314 | 2022-02-12 | Reynolds | Missouri | 29179 | 1114 | 20 |
2209963 | 2209963 | 2022-02-12 | Hot Springs | Wyoming | 56017 | 1114 | 14 |
2205061 | 2205061 | 2022-02-11 | Reynolds | Missouri | 29179 | 1114 | 20 |
2206710 | 2206710 | 2022-02-11 | Hot Springs | Wyoming | 56017 | 1114 | 14 |
2201808 | 2201808 | 2022-02-10 | Reynolds | Missouri | 29179 | 1114 | 20 |
2197602 | 2197602 | 2022-02-09 | Henderson | Illinois | 17071 | 1114 | 26 |
2194348 | 2194348 | 2022-02-08 | Henderson | Illinois | 17071 | 1114 | 26 |
2191496 | 2191496 | 2022-02-07 | Fulton | Kentucky | 21075 | 1114 | 23 |
2171036 | 2171036 | 2022-02-01 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1114 | 8 |
2167783 | 2167783 | 2022-01-31 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1114 | 8 |
2145457 | 2145457 | 2022-01-24 | Wheeler | Georgia | 13309 | 1114 | 36 |
2139628 | 2139628 | 2022-01-22 | Unknown | Maryland | 1114 | 286 | |
2109058 | 2109058 | 2022-01-12 | Iron | Wisconsin | 55051 | 1114 | 44 |
2094915 | 2094915 | 2022-01-08 | Ransom | North Dakota | 38073 | 1114 | 23 |
2066618 | 2066618 | 2021-12-30 | Middlesex | Virginia | 51119 | 1114 | 34 |
2059757 | 2059757 | 2021-12-28 | Brewster | Texas | 48043 | 1114 | 24 |
2056508 | 2056508 | 2021-12-27 | Brewster | Texas | 48043 | 1114 | 23 |
2011353 | 2011353 | 2021-12-13 | Lancaster | Virginia | 51103 | 1114 | 24 |
1996672 | 1996672 | 2021-12-09 | Schoolcraft | Michigan | 26153 | 1114 | 7 |
1992781 | 1992781 | 2021-12-08 | Pulaski | Illinois | 17153 | 1114 | 13 |
1993421 | 1993421 | 2021-12-08 | Schoolcraft | Michigan | 26153 | 1114 | 7 |
1995210 | 1995210 | 2021-12-08 | Calhoun | West Virginia | 54013 | 1114 | 9 |
1982948 | 1982948 | 2021-12-05 | Power | Idaho | 16077 | 1114 | 16 |
1979698 | 1979698 | 2021-12-04 | Power | Idaho | 16077 | 1114 | 16 |
1976448 | 1976448 | 2021-12-03 | Power | Idaho | 16077 | 1114 | 16 |
1943970 | 1943970 | 2021-11-23 | Edwards | Illinois | 17047 | 1114 | 20 |
1944142 | 1944142 | 2021-11-23 | Adair | Iowa | 19001 | 1114 | 37 |
1940892 | 1940892 | 2021-11-22 | Adair | Iowa | 19001 | 1114 | 37 |
1937642 | 1937642 | 2021-11-21 | Adair | Iowa | 19001 | 1114 | 37 |
1934392 | 1934392 | 2021-11-20 | Adair | Iowa | 19001 | 1114 | 37 |
1931141 | 1931141 | 2021-11-19 | Adair | Iowa | 19001 | 1114 | 37 |
1927890 | 1927890 | 2021-11-18 | Adair | Iowa | 19001 | 1114 | 37 |
1924640 | 1924640 | 2021-11-17 | Adair | Iowa | 19001 | 1114 | 37 |
1898143 | 1898143 | 2021-11-09 | Rio Blanco | Colorado | 8103 | 1114 | 9 |
1892758 | 1892758 | 2021-11-07 | Wilkin | Minnesota | 27167 | 1114 | 15 |
1889508 | 1889508 | 2021-11-06 | Wilkin | Minnesota | 27167 | 1114 | 15 |
1886258 | 1886258 | 2021-11-05 | Wilkin | Minnesota | 27167 | 1114 | 15 |
1887981 | 1887981 | 2021-11-05 | Pendleton | West Virginia | 54071 | 1114 | 15 |
1879133 | 1879133 | 2021-11-03 | Union | Indiana | 18161 | 1114 | 17 |
1881482 | 1881482 | 2021-11-03 | Pendleton | West Virginia | 54071 | 1114 | 15 |
1874849 | 1874849 | 2021-11-01 | Lunenburg | Virginia | 51111 | 1114 | 20 |
1870379 | 1870379 | 2021-10-31 | Pershing | Nevada | 32027 | 1114 | 27 |
1867130 | 1867130 | 2021-10-30 | Pershing | Nevada | 32027 | 1114 | 27 |
1863881 | 1863881 | 2021-10-29 | Pershing | Nevada | 32027 | 1114 | 27 |
1860219 | 1860219 | 2021-10-28 | Lake | Minnesota | 27075 | 1114 | 22 |
1860632 | 1860632 | 2021-10-28 | Pershing | Nevada | 32027 | 1114 | 27 |
1857383 | 1857383 | 2021-10-27 | Pershing | Nevada | 32027 | 1114 | 27 |
1853228 | 1853228 | 2021-10-26 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1854134 | 1854134 | 2021-10-26 | Pershing | Nevada | 32027 | 1114 | 27 |
1849979 | 1849979 | 2021-10-25 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1846729 | 1846729 | 2021-10-24 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1843479 | 1843479 | 2021-10-23 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1840229 | 1840229 | 2021-10-22 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1836980 | 1836980 | 2021-10-21 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1833731 | 1833731 | 2021-10-20 | Pocahontas | Iowa | 19151 | 1114 | 23 |
1832332 | 1832332 | 2021-10-19 | Hansford | Texas | 48195 | 1114 | 26 |
1826923 | 1826923 | 2021-10-18 | Benewah | Idaho | 16009 | 1114 | 19 |
1809516 | 1809516 | 2021-10-12 | Brooks | Texas | 48047 | 1114 | 47 |
1806266 | 1806266 | 2021-10-11 | Brooks | Texas | 48047 | 1114 | 47 |
1803016 | 1803016 | 2021-10-10 | Brooks | Texas | 48047 | 1114 | 47 |
1798629 | 1798629 | 2021-10-09 | Caldwell | Missouri | 29025 | 1114 | 19 |
1799767 | 1799767 | 2021-10-09 | Brooks | Texas | 48047 | 1114 | 47 |
1796518 | 1796518 | 2021-10-08 | Brooks | Texas | 48047 | 1114 | 47 |
1793269 | 1793269 | 2021-10-07 | Brooks | Texas | 48047 | 1114 | 47 |
1793821 | 1793821 | 2021-10-07 | Pepin | Wisconsin | 55091 | 1114 | 10 |
1789411 | 1789411 | 2021-10-06 | Pembina | North Dakota | 38067 | 1114 | 11 |
1790020 | 1790020 | 2021-10-06 | Brooks | Texas | 48047 | 1114 | 47 |
1784206 | 1784206 | 2021-10-05 | Nome Census Area | Alaska | 2180 | 1114 | 0 |
1786519 | 1786519 | 2021-10-05 | San German | Puerto Rico | 72125 | 1114 | |
1770655 | 1770655 | 2021-09-30 | Marion | Texas | 48315 | 1114 | 41 |
1765087 | 1765087 | 2021-09-29 | Hancock | Georgia | 13141 | 1114 | 75 |
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);