ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3998 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 18
- Oklahoma 14
- Iowa 8
- Mississippi 8
- Texas 8
- Illinois 7
- Kansas 7
- Nebraska 7
- West Virginia 7
- Indiana 6
- Louisiana 6
- Tennessee 6
- Kentucky 5
- Georgia 4
- Ohio 4
- Alabama 3
- Utah 3
- Colorado 2
- Maryland 2
- Minnesota 2
- Missouri 2
- New York 2
- North Dakota 2
- Oregon 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- California 1
- Connecticut 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502141 | 2502141 | 2022-05-13 | Grundy | Tennessee | 47061 | 3998 | 73 |
2498883 | 2498883 | 2022-05-12 | Grundy | Tennessee | 47061 | 3998 | 73 |
2495625 | 2495625 | 2022-05-11 | Grundy | Tennessee | 47061 | 3998 | 73 |
2383045 | 2383045 | 2022-04-07 | Warren | Illinois | 17187 | 3998 | 87 |
2379790 | 2379790 | 2022-04-06 | Warren | Illinois | 17187 | 3998 | 87 |
2353735 | 2353735 | 2022-03-29 | Mercer | Illinois | 17131 | 3998 | 47 |
2355597 | 2355597 | 2022-03-29 | Union | South Dakota | 46127 | 3998 | 52 |
2352344 | 2352344 | 2022-03-28 | Union | South Dakota | 46127 | 3998 | 52 |
2349092 | 2349092 | 2022-03-27 | Union | South Dakota | 46127 | 3998 | 52 |
2345839 | 2345839 | 2022-03-26 | Union | South Dakota | 46127 | 3998 | 52 |
2342586 | 2342586 | 2022-03-25 | Union | South Dakota | 46127 | 3998 | 52 |
2339333 | 2339333 | 2022-03-24 | Union | South Dakota | 46127 | 3998 | 52 |
2336079 | 2336079 | 2022-03-23 | Union | South Dakota | 46127 | 3998 | 52 |
2332825 | 2332825 | 2022-03-22 | Union | South Dakota | 46127 | 3998 | 52 |
2329572 | 2329572 | 2022-03-21 | Union | South Dakota | 46127 | 3998 | 52 |
2326320 | 2326320 | 2022-03-20 | Union | South Dakota | 46127 | 3998 | 52 |
2323067 | 2323067 | 2022-03-19 | Union | South Dakota | 46127 | 3998 | 52 |
2319813 | 2319813 | 2022-03-18 | Union | South Dakota | 46127 | 3998 | 52 |
2316559 | 2316559 | 2022-03-17 | Union | South Dakota | 46127 | 3998 | 52 |
2313306 | 2313306 | 2022-03-16 | Union | South Dakota | 46127 | 3998 | 52 |
2310053 | 2310053 | 2022-03-15 | Union | South Dakota | 46127 | 3998 | 52 |
2306800 | 2306800 | 2022-03-14 | Union | South Dakota | 46127 | 3998 | 52 |
2293793 | 2293793 | 2022-03-10 | Union | South Dakota | 46127 | 3998 | 52 |
2287289 | 2287289 | 2022-03-08 | Union | South Dakota | 46127 | 3998 | 52 |
2248651 | 2248651 | 2022-02-24 | Addison | Vermont | 50001 | 3998 | 15 |
2242118 | 2242118 | 2022-02-22 | Zavala | Texas | 48507 | 3998 | 64 |
2238031 | 2238031 | 2022-02-21 | Richland | North Dakota | 38077 | 3998 | 21 |
2238867 | 2238867 | 2022-02-21 | Zavala | Texas | 48507 | 3998 | 64 |
2234780 | 2234780 | 2022-02-20 | Richland | North Dakota | 38077 | 3998 | 21 |
2217319 | 2217319 | 2022-02-15 | Hardin | Iowa | 19083 | 3998 | 57 |
2214068 | 2214068 | 2022-02-14 | Hardin | Iowa | 19083 | 3998 | 57 |
2210816 | 2210816 | 2022-02-13 | Hardin | Iowa | 19083 | 3998 | 57 |
2207563 | 2207563 | 2022-02-12 | Hardin | Iowa | 19083 | 3998 | 57 |
2204310 | 2204310 | 2022-02-11 | Hardin | Iowa | 19083 | 3998 | 57 |
2201057 | 2201057 | 2022-02-10 | Hardin | Iowa | 19083 | 3998 | 57 |
2197803 | 2197803 | 2022-02-09 | Hardin | Iowa | 19083 | 3998 | 57 |
2196124 | 2196124 | 2022-02-08 | Yauco | Puerto Rico | 72153 | 3998 | |
2192870 | 2192870 | 2022-02-07 | Yauco | Puerto Rico | 72153 | 3998 | |
2180563 | 2180563 | 2022-02-03 | Hardy | West Virginia | 54031 | 3998 | 44 |
2172011 | 2172011 | 2022-02-01 | Lewis | Kentucky | 21135 | 3998 | 72 |
2131800 | 2131800 | 2022-01-19 | Adams | Wisconsin | 55001 | 3998 | 45 |
2106372 | 2106372 | 2022-01-12 | Morgan | Georgia | 13211 | 3998 | 52 |
2097713 | 2097713 | 2022-01-09 | Ray | Missouri | 29177 | 3998 | 72 |
2041308 | 2041308 | 2021-12-23 | Fannin | Georgia | 13111 | 3998 | 116 |
2028866 | 2028866 | 2021-12-19 | Anderson | Kentucky | 21005 | 3998 | 56 |
2025615 | 2025615 | 2021-12-18 | Anderson | Kentucky | 21005 | 3998 | 56 |
2022364 | 2022364 | 2021-12-17 | Anderson | Kentucky | 21005 | 3998 | 56 |
2018836 | 2018836 | 2021-12-16 | Fountain | Indiana | 18045 | 3998 | 70 |
1988020 | 1988020 | 2021-12-06 | Abbeville | South Carolina | 45001 | 3998 | 52 |
1982227 | 1982227 | 2021-12-04 | Mason | West Virginia | 54053 | 3998 | 62 |
1917227 | 1917227 | 2021-11-14 | Nicholas | West Virginia | 54067 | 3998 | 54 |
1876258 | 1876258 | 2021-11-02 | Plaquemines | Louisiana | 22075 | 3998 | 40 |
1873009 | 1873009 | 2021-11-01 | Plaquemines | Louisiana | 22075 | 3998 | 40 |
1831830 | 1831830 | 2021-10-19 | Texas | Oklahoma | 40139 | 3998 | 37 |
1828581 | 1828581 | 2021-10-18 | Texas | Oklahoma | 40139 | 3998 | 37 |
1825332 | 1825332 | 2021-10-17 | Texas | Oklahoma | 40139 | 3998 | 37 |
1822083 | 1822083 | 2021-10-16 | Texas | Oklahoma | 40139 | 3998 | 37 |
1817827 | 1817827 | 2021-10-15 | Dorchester | Maryland | 24019 | 3998 | 77 |
1818834 | 1818834 | 2021-10-15 | Texas | Oklahoma | 40139 | 3998 | 37 |
1815585 | 1815585 | 2021-10-14 | Texas | Oklahoma | 40139 | 3998 | 37 |
1810618 | 1810618 | 2021-10-13 | Peach | Georgia | 13225 | 3998 | 92 |
1812337 | 1812337 | 2021-10-13 | Texas | Oklahoma | 40139 | 3998 | 37 |
1762833 | 1762833 | 2021-09-28 | Leake | Mississippi | 28079 | 3998 | 86 |
1757429 | 1757429 | 2021-09-26 | DeKalb | Tennessee | 47041 | 3998 | 60 |
1754181 | 1754181 | 2021-09-25 | DeKalb | Tennessee | 47041 | 3998 | 60 |
1750251 | 1750251 | 2021-09-24 | Greene | New York | 36039 | 3998 | 83 |
1750286 | 1750286 | 2021-09-24 | Washington | New York | 36115 | 3998 | 65 |
1750933 | 1750933 | 2021-09-24 | DeKalb | Tennessee | 47041 | 3998 | 60 |
1743255 | 1743255 | 2021-09-22 | Lyon | Minnesota | 27083 | 3998 | 54 |
1721575 | 1721575 | 2021-09-15 | Edgefield | South Carolina | 45037 | 3998 | 50 |
1696278 | 1696278 | 2021-09-07 | Logan | West Virginia | 54045 | 3998 | 107 |
1677341 | 1677341 | 2021-09-02 | Dawson | Georgia | 13085 | 3998 | 51 |
1668601 | 1668601 | 2021-08-30 | George | Mississippi | 28039 | 3998 | 60 |
1663794 | 1663794 | 2021-08-28 | Marshall | West Virginia | 54051 | 3998 | 84 |
1660546 | 1660546 | 2021-08-27 | Marshall | West Virginia | 54051 | 3998 | 84 |
1645443 | 1645443 | 2021-08-23 | Boyle | Kentucky | 21021 | 3998 | 80 |
1600866 | 1600866 | 2021-08-09 | Bladen | North Carolina | 37017 | 3998 | 61 |
1588087 | 1588087 | 2021-08-05 | Preble | Ohio | 39135 | 3998 | 107 |
1550968 | 1550968 | 2021-07-25 | Jasper | Indiana | 18073 | 3998 | 57 |
1547721 | 1547721 | 2021-07-24 | Jasper | Indiana | 18073 | 3998 | 57 |
1544474 | 1544474 | 2021-07-23 | Jasper | Indiana | 18073 | 3998 | 57 |
1540136 | 1540136 | 2021-07-21 | Sanpete | Utah | 49039 | 3998 | 24 |
1515906 | 1515906 | 2021-07-14 | Steele | Minnesota | 27147 | 3998 | 19 |
1468008 | 1468008 | 2021-06-29 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1464763 | 1464763 | 2021-06-28 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1461518 | 1461518 | 2021-06-27 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1458273 | 1458273 | 2021-06-26 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1455028 | 1455028 | 2021-06-25 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1451783 | 1451783 | 2021-06-24 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1448537 | 1448537 | 2021-06-23 | McCurtain | Oklahoma | 40089 | 3998 | 94 |
1417908 | 1417908 | 2021-06-14 | Steuben | Indiana | 18151 | 3998 | 61 |
1379640 | 1379640 | 2021-06-02 | Lincoln | Mississippi | 28085 | 3998 | 111 |
1375851 | 1375851 | 2021-06-01 | Cowley | Kansas | 20035 | 3998 | 109 |
1372606 | 1372606 | 2021-05-31 | Cowley | Kansas | 20035 | 3998 | 109 |
1369361 | 1369361 | 2021-05-30 | Cowley | Kansas | 20035 | 3998 | 109 |
1366115 | 1366115 | 2021-05-29 | Cowley | Kansas | 20035 | 3998 | 109 |
1362869 | 1362869 | 2021-05-28 | Cowley | Kansas | 20035 | 3998 | 109 |
1364022 | 1364022 | 2021-05-28 | Brown | Ohio | 39015 | 3998 | 59 |
1359622 | 1359622 | 2021-05-27 | Cowley | Kansas | 20035 | 3998 | 108 |
1356376 | 1356376 | 2021-05-26 | Cowley | Kansas | 20035 | 3998 | 108 |
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);