ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
240 rows where cases = 2581 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Indiana 16
- Montana 15
- Tennessee 13
- Georgia 12
- Kentucky 12
- Iowa 10
- Alabama 8
- Illinois 8
- Kansas 8
- Missouri 8
- North Carolina 8
- Idaho 7
- Louisiana 7
- Oklahoma 7
- Wisconsin 7
- Puerto Rico 6
- Virginia 6
- Mississippi 5
- West Virginia 5
- Alaska 4
- Arkansas 4
- Colorado 4
- Massachusetts 4
- Minnesota 4
- Oregon 4
- Michigan 3
- Nebraska 3
- Nevada 3
- New York 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484046 | 2484046 | 2022-05-08 | Newton | Indiana | 18111 | 2581 | 68 |
2480788 | 2480788 | 2022-05-07 | Newton | Indiana | 18111 | 2581 | 68 |
2477530 | 2477530 | 2022-05-06 | Newton | Indiana | 18111 | 2581 | 68 |
2474272 | 2474272 | 2022-05-05 | Newton | Indiana | 18111 | 2581 | 68 |
2471015 | 2471015 | 2022-05-04 | Newton | Indiana | 18111 | 2581 | 68 |
2437755 | 2437755 | 2022-04-24 | Sumter | Alabama | 1119 | 2581 | 51 |
2434499 | 2434499 | 2022-04-23 | Sumter | Alabama | 1119 | 2581 | 51 |
2431243 | 2431243 | 2022-04-22 | Sumter | Alabama | 1119 | 2581 | 51 |
2427987 | 2427987 | 2022-04-21 | Sumter | Alabama | 1119 | 2581 | 51 |
2426861 | 2426861 | 2022-04-20 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2423605 | 2423605 | 2022-04-19 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2420348 | 2420348 | 2022-04-18 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2417093 | 2417093 | 2022-04-17 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2413837 | 2413837 | 2022-04-16 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2410581 | 2410581 | 2022-04-15 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2407325 | 2407325 | 2022-04-14 | Hughes | Oklahoma | 40063 | 2581 | 62 |
2304984 | 2304984 | 2022-03-14 | Brown | Indiana | 18013 | 2581 | 62 |
2301621 | 2301621 | 2022-03-13 | Valley | Idaho | 16085 | 2581 | 16 |
2301732 | 2301732 | 2022-03-13 | Brown | Indiana | 18013 | 2581 | 62 |
2298369 | 2298369 | 2022-03-12 | Valley | Idaho | 16085 | 2581 | 16 |
2298480 | 2298480 | 2022-03-12 | Brown | Indiana | 18013 | 2581 | 62 |
2295117 | 2295117 | 2022-03-11 | Valley | Idaho | 16085 | 2581 | 16 |
2295228 | 2295228 | 2022-03-11 | Brown | Indiana | 18013 | 2581 | 62 |
2284443 | 2284443 | 2022-03-07 | Amelia | Virginia | 51007 | 2581 | 58 |
2278968 | 2278968 | 2022-03-06 | Brown | Indiana | 18013 | 2581 | 62 |
2279893 | 2279893 | 2022-03-06 | Jefferson | Montana | 30043 | 2581 | 23 |
2275715 | 2275715 | 2022-03-05 | Brown | Indiana | 18013 | 2581 | 62 |
2276640 | 2276640 | 2022-03-05 | Jefferson | Montana | 30043 | 2581 | 23 |
2272462 | 2272462 | 2022-03-04 | Brown | Indiana | 18013 | 2581 | 62 |
2273387 | 2273387 | 2022-03-04 | Jefferson | Montana | 30043 | 2581 | 23 |
2261408 | 2261408 | 2022-02-28 | Childress | Texas | 48075 | 2581 | 28 |
2258157 | 2258157 | 2022-02-27 | Childress | Texas | 48075 | 2581 | 28 |
2254906 | 2254906 | 2022-02-26 | Childress | Texas | 48075 | 2581 | 28 |
2251655 | 2251655 | 2022-02-25 | Childress | Texas | 48075 | 2581 | 28 |
2224813 | 2224813 | 2022-02-17 | Los Alamos | New Mexico | 35028 | 2581 | 13 |
2224910 | 2224910 | 2022-02-17 | Clay | North Carolina | 37043 | 2581 | 38 |
2194595 | 2194595 | 2022-02-08 | Union | Iowa | 19175 | 2581 | 46 |
2196290 | 2196290 | 2022-02-08 | Lake | Tennessee | 47095 | 2581 | 34 |
2191341 | 2191341 | 2022-02-07 | Union | Iowa | 19175 | 2581 | 46 |
2193036 | 2193036 | 2022-02-07 | Lake | Tennessee | 47095 | 2581 | 34 |
2188088 | 2188088 | 2022-02-06 | Union | Iowa | 19175 | 2581 | 46 |
2189782 | 2189782 | 2022-02-06 | Lake | Tennessee | 47095 | 2581 | 34 |
2190381 | 2190381 | 2022-02-06 | Forest | Wisconsin | 55041 | 2581 | 47 |
2184835 | 2184835 | 2022-02-05 | Union | Iowa | 19175 | 2581 | 46 |
2185506 | 2185506 | 2022-02-05 | Lewis | Missouri | 29111 | 2581 | 31 |
2186529 | 2186529 | 2022-02-05 | Lake | Tennessee | 47095 | 2581 | 34 |
2187128 | 2187128 | 2022-02-05 | Forest | Wisconsin | 55041 | 2581 | 47 |
2181583 | 2181583 | 2022-02-04 | Union | Iowa | 19175 | 2581 | 46 |
2183277 | 2183277 | 2022-02-04 | Lake | Tennessee | 47095 | 2581 | 34 |
2183875 | 2183875 | 2022-02-04 | Forest | Wisconsin | 55041 | 2581 | 47 |
2178332 | 2178332 | 2022-02-03 | Union | Iowa | 19175 | 2581 | 46 |
2178582 | 2178582 | 2022-02-03 | Catahoula | Louisiana | 22025 | 2581 | 51 |
2180025 | 2180025 | 2022-02-03 | Lake | Tennessee | 47095 | 2581 | 34 |
2175079 | 2175079 | 2022-02-02 | Union | Iowa | 19175 | 2581 | 46 |
2176774 | 2176774 | 2022-02-02 | Lake | Tennessee | 47095 | 2581 | 34 |
2173941 | 2173941 | 2022-02-01 | Lexington city | Virginia | 51678 | 2581 | 38 |
2165032 | 2165032 | 2022-01-30 | Teton | Idaho | 16081 | 2581 | 8 |
2161777 | 2161777 | 2022-01-29 | Teton | Idaho | 16081 | 2581 | 8 |
2141906 | 2141906 | 2022-01-23 | Archuleta | Colorado | 8007 | 2581 | 9 |
2138651 | 2138651 | 2022-01-22 | Archuleta | Colorado | 8007 | 2581 | 9 |
2135395 | 2135395 | 2022-01-21 | Archuleta | Colorado | 8007 | 2581 | 9 |
2105663 | 2105663 | 2022-01-11 | Rockbridge | Virginia | 51163 | 2581 | 71 |
2072430 | 2072430 | 2022-01-01 | Potter | Pennsylvania | 42105 | 2581 | 79 |
2063653 | 2063653 | 2021-12-30 | Macon | Alabama | 1087 | 2581 | 69 |
2063229 | 2063229 | 2021-12-29 | Wilbarger | Texas | 48487 | 2581 | 72 |
2056992 | 2056992 | 2021-12-27 | Monroe | West Virginia | 54063 | 2581 | 30 |
2040877 | 2040877 | 2021-12-23 | Cleburne | Alabama | 1029 | 2581 | 60 |
2037677 | 2037677 | 2021-12-22 | Washington | Alabama | 1129 | 2581 | 51 |
2032672 | 2032672 | 2021-12-20 | Macon | Missouri | 29121 | 2581 | 36 |
2033154 | 2033154 | 2021-12-20 | Ramsey | North Dakota | 38071 | 2581 | 42 |
2028896 | 2028896 | 2021-12-19 | Estill | Kentucky | 21065 | 2581 | 35 |
2029904 | 2029904 | 2021-12-19 | Ramsey | North Dakota | 38071 | 2581 | 42 |
2030219 | 2030219 | 2021-12-19 | Corozal | Puerto Rico | 72047 | 2581 | |
2025645 | 2025645 | 2021-12-18 | Estill | Kentucky | 21065 | 2581 | 35 |
2022394 | 2022394 | 2021-12-17 | Estill | Kentucky | 21065 | 2581 | 35 |
2019126 | 2019126 | 2021-12-16 | Butler | Kentucky | 21031 | 2581 | 43 |
2015504 | 2015504 | 2021-12-15 | Johnson | Illinois | 17087 | 2581 | 38 |
1998746 | 1998746 | 2021-12-10 | Howard | Arkansas | 5061 | 2581 | 39 |
1966747 | 1966747 | 2021-11-30 | Jo Daviess | Illinois | 17085 | 2581 | 32 |
1940249 | 1940249 | 2021-11-22 | Madison | Arkansas | 5087 | 2581 | 40 |
1904489 | 1904489 | 2021-11-11 | Izard | Arkansas | 5065 | 2581 | 55 |
1878249 | 1878249 | 2021-11-02 | Wetzel | West Virginia | 54103 | 2581 | 53 |
1872929 | 1872929 | 2021-11-01 | Mason | Kentucky | 21161 | 2581 | 68 |
1873200 | 1873200 | 2021-11-01 | Fillmore | Minnesota | 27045 | 2581 | 14 |
1860112 | 1860112 | 2021-10-28 | Charlevoix | Michigan | 26029 | 2581 | 34 |
1852960 | 1852960 | 2021-10-26 | Bond | Illinois | 17005 | 2581 | 31 |
1853296 | 1853296 | 2021-10-26 | Jefferson | Kansas | 20087 | 2581 | 47 |
1850047 | 1850047 | 2021-10-25 | Jefferson | Kansas | 20087 | 2581 | 47 |
1845939 | 1845939 | 2021-10-24 | North Slope Borough | Alaska | 2185 | 2581 | 6 |
1842689 | 1842689 | 2021-10-23 | North Slope Borough | Alaska | 2185 | 2581 | 6 |
1844174 | 1844174 | 2021-10-23 | Moniteau | Missouri | 29135 | 2581 | 38 |
1839440 | 1839440 | 2021-10-22 | North Slope Borough | Alaska | 2185 | 2581 | 6 |
1833915 | 1833915 | 2021-10-20 | Jackson | Kentucky | 21109 | 2581 | 50 |
1830675 | 1830675 | 2021-10-19 | Lawrence | Kentucky | 21127 | 2581 | 38 |
1831581 | 1831581 | 2021-10-19 | Northampton | North Carolina | 37131 | 2581 | 62 |
1815993 | 1815993 | 2021-10-14 | Aransas | Texas | 48007 | 2581 | 60 |
1795440 | 1795440 | 2021-10-08 | Morgan | Missouri | 29141 | 2581 | 57 |
1769838 | 1769838 | 2021-09-30 | Madison | North Carolina | 37115 | 2581 | 55 |
1756641 | 1756641 | 2021-09-26 | Washington | Nebraska | 31177 | 2581 | 29 |
1753393 | 1753393 | 2021-09-25 | Washington | Nebraska | 31177 | 2581 | 29 |
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);