ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
359 rows where cases = 1186 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 33
- Texas 24
- Mississippi 20
- Georgia 19
- Virginia 19
- Nebraska 18
- Kentucky 16
- Missouri 14
- Puerto Rico 14
- Kansas 12
- Arkansas 11
- Minnesota 10
- North Carolina 9
- Tennessee 9
- Alaska 8
- Illinois 8
- South Dakota 8
- Washington 8
- Oregon 7
- Alabama 6
- Colorado 6
- Michigan 6
- Montana 6
- West Virginia 6
- Ohio 5
- California 4
- Idaho 4
- Indiana 4
- Louisiana 4
- Oklahoma 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492757 | 2492757 | 2022-05-10 | Charles City | Virginia | 51036 | 1186 | 27 |
2418460 | 2418460 | 2022-04-18 | Saguache | Colorado | 8109 | 1186 | 12 |
2400345 | 2400345 | 2022-04-12 | Howard | Nebraska | 31093 | 1186 | 15 |
2397090 | 2397090 | 2022-04-11 | Howard | Nebraska | 31093 | 1186 | 15 |
2393835 | 2393835 | 2022-04-10 | Howard | Nebraska | 31093 | 1186 | 15 |
2390579 | 2390579 | 2022-04-09 | Howard | Nebraska | 31093 | 1186 | 15 |
2387323 | 2387323 | 2022-04-08 | Howard | Nebraska | 31093 | 1186 | 15 |
2384068 | 2384068 | 2022-04-07 | Howard | Nebraska | 31093 | 1186 | 15 |
2380813 | 2380813 | 2022-04-06 | Howard | Nebraska | 31093 | 1186 | 15 |
2377558 | 2377558 | 2022-04-05 | Howard | Nebraska | 31093 | 1186 | 15 |
2374305 | 2374305 | 2022-04-04 | Howard | Nebraska | 31093 | 1186 | 15 |
2371053 | 2371053 | 2022-04-03 | Howard | Nebraska | 31093 | 1186 | 15 |
2367800 | 2367800 | 2022-04-02 | Howard | Nebraska | 31093 | 1186 | 15 |
2364547 | 2364547 | 2022-04-01 | Howard | Nebraska | 31093 | 1186 | 15 |
2361293 | 2361293 | 2022-03-31 | Howard | Nebraska | 31093 | 1186 | 15 |
2362360 | 2362360 | 2022-03-31 | Martin | Texas | 48317 | 1186 | 26 |
2359106 | 2359106 | 2022-03-30 | Martin | Texas | 48317 | 1186 | 26 |
2333388 | 2333388 | 2022-03-22 | San Juan | Washington | 53055 | 1186 | 2 |
2330134 | 2330134 | 2022-03-21 | San Juan | Washington | 53055 | 1186 | 2 |
2325509 | 2325509 | 2022-03-20 | Howard | Nebraska | 31093 | 1186 | 15 |
2326882 | 2326882 | 2022-03-20 | San Juan | Washington | 53055 | 1186 | 2 |
2322255 | 2322255 | 2022-03-19 | Howard | Nebraska | 31093 | 1186 | 15 |
2323629 | 2323629 | 2022-03-19 | San Juan | Washington | 53055 | 1186 | 2 |
2320375 | 2320375 | 2022-03-18 | San Juan | Washington | 53055 | 1186 | 2 |
2287476 | 2287476 | 2022-03-08 | Goliad | Texas | 48175 | 1186 | 32 |
2284224 | 2284224 | 2022-03-07 | Goliad | Texas | 48175 | 1186 | 32 |
2241011 | 2241011 | 2022-02-22 | Lander | Nevada | 32015 | 1186 | 17 |
2211346 | 2211346 | 2022-02-13 | Lincoln | Minnesota | 27081 | 1186 | 6 |
2212940 | 2212940 | 2022-02-13 | Cumberland | Virginia | 51049 | 1186 | 22 |
2208093 | 2208093 | 2022-02-12 | Lincoln | Minnesota | 27081 | 1186 | 6 |
2209687 | 2209687 | 2022-02-12 | Cumberland | Virginia | 51049 | 1186 | 22 |
2204840 | 2204840 | 2022-02-11 | Lincoln | Minnesota | 27081 | 1186 | 6 |
2206434 | 2206434 | 2022-02-11 | Cumberland | Virginia | 51049 | 1186 | 22 |
2201837 | 2201837 | 2022-02-10 | Broadwater | Montana | 30007 | 1186 | 18 |
2194601 | 2194601 | 2022-02-08 | Wayne | Iowa | 19185 | 1186 | 31 |
2195974 | 2195974 | 2022-02-08 | Wallowa | Oregon | 41063 | 1186 | 14 |
2191347 | 2191347 | 2022-02-07 | Wayne | Iowa | 19185 | 1186 | 31 |
2188094 | 2188094 | 2022-02-06 | Wayne | Iowa | 19185 | 1186 | 31 |
2184841 | 2184841 | 2022-02-05 | Wayne | Iowa | 19185 | 1186 | 31 |
2181589 | 2181589 | 2022-02-04 | Wayne | Iowa | 19185 | 1186 | 31 |
2178338 | 2178338 | 2022-02-03 | Wayne | Iowa | 19185 | 1186 | 31 |
2175085 | 2175085 | 2022-02-02 | Wayne | Iowa | 19185 | 1186 | 31 |
2165934 | 2165934 | 2022-01-30 | Atchison | Missouri | 29005 | 1186 | 19 |
2166388 | 2166388 | 2022-01-30 | Hyde | North Carolina | 37095 | 1186 | 13 |
2162679 | 2162679 | 2022-01-29 | Atchison | Missouri | 29005 | 1186 | 19 |
2163133 | 2163133 | 2022-01-29 | Hyde | North Carolina | 37095 | 1186 | 13 |
2159878 | 2159878 | 2022-01-28 | Hyde | North Carolina | 37095 | 1186 | 13 |
2154203 | 2154203 | 2022-01-26 | McCulloch | Texas | 48307 | 1186 | 42 |
2154219 | 2154219 | 2022-01-26 | Newton | Texas | 48351 | 1186 | 56 |
2132892 | 2132892 | 2022-01-20 | Washington | Kansas | 20201 | 1186 | 20 |
2133421 | 2133421 | 2022-01-20 | Dade | Missouri | 29057 | 1186 | 38 |
2129639 | 2129639 | 2022-01-19 | Washington | Kansas | 20201 | 1186 | 20 |
2126741 | 2126741 | 2022-01-18 | Grant | Minnesota | 27051 | 1186 | 12 |
2115110 | 2115110 | 2022-01-14 | Hartley | Texas | 48205 | 1186 | 3 |
2084839 | 2084839 | 2022-01-05 | Keith | Nebraska | 31101 | 1186 | 12 |
2081177 | 2081177 | 2022-01-04 | Oscoda | Michigan | 26135 | 1186 | 51 |
2077925 | 2077925 | 2022-01-03 | Oscoda | Michigan | 26135 | 1186 | 51 |
2068871 | 2068871 | 2021-12-31 | Bottineau | North Dakota | 38009 | 1186 | 24 |
2065626 | 2065626 | 2021-12-30 | Dickey | North Dakota | 38021 | 1186 | 38 |
2057367 | 2057367 | 2021-12-28 | Conejos | Colorado | 8021 | 1186 | 44 |
2051072 | 2051072 | 2021-12-26 | Hancock | Georgia | 13141 | 1186 | 82 |
2047822 | 2047822 | 2021-12-25 | Hancock | Georgia | 13141 | 1186 | 82 |
2044572 | 2044572 | 2021-12-24 | Hancock | Georgia | 13141 | 1186 | 82 |
1989537 | 1989537 | 2021-12-07 | Schuyler | Illinois | 17169 | 1186 | 24 |
1990630 | 1990630 | 2021-12-07 | Pershing | Nevada | 32027 | 1186 | 27 |
1968599 | 1968599 | 2021-11-30 | Hutchinson | South Dakota | 46067 | 1186 | 28 |
1943642 | 1943642 | 2021-11-23 | Rio Blanco | Colorado | 8103 | 1186 | 9 |
1944217 | 1944217 | 2021-11-23 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1940967 | 1940967 | 2021-11-22 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1937717 | 1937717 | 2021-11-21 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1939086 | 1939086 | 2021-11-21 | Harney | Oregon | 41025 | 1186 | 31 |
1934467 | 1934467 | 2021-11-20 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1935836 | 1935836 | 2021-11-20 | Harney | Oregon | 41025 | 1186 | 31 |
1931216 | 1931216 | 2021-11-19 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1932586 | 1932586 | 2021-11-19 | Harney | Oregon | 41025 | 1186 | 31 |
1927965 | 1927965 | 2021-11-18 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1929335 | 1929335 | 2021-11-18 | Harney | Oregon | 41025 | 1186 | 31 |
1930342 | 1930342 | 2021-11-18 | Weston | Wyoming | 56045 | 1186 | 13 |
1924715 | 1924715 | 2021-11-17 | Pocahontas | Iowa | 19151 | 1186 | 24 |
1920344 | 1920344 | 2021-11-15 | Lunenburg | Virginia | 51111 | 1186 | 22 |
1914255 | 1914255 | 2021-11-14 | Newton | Arkansas | 5101 | 1186 | 37 |
1903876 | 1903876 | 2021-11-10 | Marion | Texas | 48315 | 1186 | 50 |
1900626 | 1900626 | 2021-11-09 | Marion | Texas | 48315 | 1186 | 50 |
1900983 | 1900983 | 2021-11-09 | Pocahontas | West Virginia | 54075 | 1186 | 18 |
1878435 | 1878435 | 2021-11-03 | Sitka City and Borough | Alaska | 2220 | 1186 | 4 |
1881403 | 1881403 | 2021-11-03 | Williamsburg city | Virginia | 51830 | 1186 | 14 |
1875186 | 1875186 | 2021-11-02 | Sitka City and Borough | Alaska | 2220 | 1186 | 4 |
1878248 | 1878248 | 2021-11-02 | Webster | West Virginia | 54101 | 1186 | 18 |
1856085 | 1856085 | 2021-10-27 | Lincoln | Georgia | 13181 | 1186 | 33 |
1853476 | 1853476 | 2021-10-26 | Wolfe | Kentucky | 21237 | 1186 | 11 |
1835199 | 1835199 | 2021-10-20 | Barceloneta | Puerto Rico | 72017 | 1186 | |
1831950 | 1831950 | 2021-10-19 | Barceloneta | Puerto Rico | 72017 | 1186 | |
1826519 | 1826519 | 2021-10-18 | Monroe | Arkansas | 5095 | 1186 | 24 |
1828701 | 1828701 | 2021-10-18 | Barceloneta | Puerto Rico | 72017 | 1186 | |
1823270 | 1823270 | 2021-10-17 | Monroe | Arkansas | 5095 | 1186 | 24 |
1820021 | 1820021 | 2021-10-16 | Monroe | Arkansas | 5095 | 1186 | 24 |
1816772 | 1816772 | 2021-10-15 | Monroe | Arkansas | 5095 | 1186 | 24 |
1813524 | 1813524 | 2021-10-14 | Monroe | Arkansas | 5095 | 1186 | 24 |
1813838 | 1813838 | 2021-10-14 | Jenkins | Georgia | 13165 | 1186 | 54 |
1814982 | 1814982 | 2021-10-14 | Blaine | Montana | 30005 | 1186 | 24 |
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);