ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
244 rows where cases = 1918 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 28
- Georgia 23
- Iowa 22
- Puerto Rico 13
- Texas 13
- Kansas 11
- Nebraska 11
- Arkansas 8
- Mississippi 8
- Indiana 7
- Kentucky 7
- Oklahoma 7
- Tennessee 7
- Illinois 6
- Ohio 6
- Wisconsin 6
- West Virginia 5
- Alabama 4
- Colorado 4
- Louisiana 4
- Michigan 4
- Missouri 4
- Minnesota 3
- Alaska 2
- California 2
- Maryland 2
- Massachusetts 2
- Montana 2
- New Hampshire 2
- New Jersey 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494228 | 2494228 | 2022-05-11 | St. Helena | Louisiana | 22091 | 1918 | 23 |
2439457 | 2439457 | 2022-04-24 | Unknown | Nebraska | 1918 | 461 | |
2317441 | 2317441 | 2022-03-18 | Monroe | Arkansas | 5095 | 1918 | 32 |
2271635 | 2271635 | 2022-03-03 | Pendleton | West Virginia | 54071 | 1918 | 17 |
2271744 | 2271744 | 2022-03-03 | Sublette | Wyoming | 56035 | 1918 | 27 |
2262967 | 2262967 | 2022-03-01 | Pratt | Kansas | 20151 | 1918 | 30 |
2265130 | 2265130 | 2022-03-01 | Pendleton | West Virginia | 54071 | 1918 | 16 |
2259716 | 2259716 | 2022-02-28 | Pratt | Kansas | 20151 | 1918 | 30 |
2261712 | 2261712 | 2022-02-28 | Falls Church city | Virginia | 51610 | 1918 | 16 |
2256465 | 2256465 | 2022-02-27 | Pratt | Kansas | 20151 | 1918 | 30 |
2256927 | 2256927 | 2022-02-27 | Franklin | Mississippi | 28037 | 1918 | 37 |
2253214 | 2253214 | 2022-02-26 | Pratt | Kansas | 20151 | 1918 | 30 |
2253676 | 2253676 | 2022-02-26 | Franklin | Mississippi | 28037 | 1918 | 37 |
2249963 | 2249963 | 2022-02-25 | Pratt | Kansas | 20151 | 1918 | 30 |
2250425 | 2250425 | 2022-02-25 | Franklin | Mississippi | 28037 | 1918 | 37 |
2246712 | 2246712 | 2022-02-24 | Pratt | Kansas | 20151 | 1918 | 30 |
2243461 | 2243461 | 2022-02-23 | Pratt | Kansas | 20151 | 1918 | 30 |
2187727 | 2187727 | 2022-02-06 | Taylor | Georgia | 13269 | 1918 | 48 |
2184474 | 2184474 | 2022-02-05 | Taylor | Georgia | 13269 | 1918 | 48 |
2181222 | 2181222 | 2022-02-04 | Taylor | Georgia | 13269 | 1918 | 48 |
2179282 | 2179282 | 2022-02-03 | Quay | New Mexico | 35037 | 1918 | 39 |
2179811 | 2179811 | 2022-02-03 | Guayanilla | Puerto Rico | 72059 | 1918 | |
2177163 | 2177163 | 2022-02-02 | Fairfax city | Virginia | 51600 | 1918 | 37 |
2177199 | 2177199 | 2022-02-02 | Madison | Virginia | 51113 | 1918 | 28 |
2149030 | 2149030 | 2022-01-25 | Montgomery | Iowa | 19137 | 1918 | 49 |
2149063 | 2149063 | 2022-01-25 | Anderson | Kansas | 20003 | 1918 | 23 |
2145431 | 2145431 | 2022-01-24 | Stewart | Georgia | 13259 | 1918 | 31 |
2145778 | 2145778 | 2022-01-24 | Montgomery | Iowa | 19137 | 1918 | 49 |
2145811 | 2145811 | 2022-01-24 | Anderson | Kansas | 20003 | 1918 | 23 |
2142523 | 2142523 | 2022-01-23 | Montgomery | Iowa | 19137 | 1918 | 49 |
2139268 | 2139268 | 2022-01-22 | Montgomery | Iowa | 19137 | 1918 | 49 |
2136012 | 2136012 | 2022-01-21 | Montgomery | Iowa | 19137 | 1918 | 49 |
2137923 | 2137923 | 2022-01-21 | Live Oak | Texas | 48297 | 1918 | 39 |
2132760 | 2132760 | 2022-01-20 | Montgomery | Iowa | 19137 | 1918 | 49 |
2129507 | 2129507 | 2022-01-19 | Montgomery | Iowa | 19137 | 1918 | 49 |
2130381 | 2130381 | 2022-01-19 | Phelps | Nebraska | 31137 | 1918 | 11 |
2062770 | 2062770 | 2021-12-29 | Yabucoa | Puerto Rico | 72151 | 1918 | |
2036106 | 2036106 | 2021-12-21 | Red Willow | Nebraska | 31145 | 1918 | 17 |
2032856 | 2032856 | 2021-12-20 | Red Willow | Nebraska | 31145 | 1918 | 17 |
2011699 | 2011699 | 2021-12-14 | Valdez-Cordova Census Area | Alaska | 2261 | 1918 | 9 |
2008448 | 2008448 | 2021-12-13 | Valdez-Cordova Census Area | Alaska | 2261 | 1918 | 9 |
1995604 | 1995604 | 2021-12-09 | Bent | Colorado | 8011 | 1918 | 33 |
1994138 | 1994138 | 2021-12-08 | Mercer | North Dakota | 38057 | 1918 | 19 |
1975987 | 1975987 | 2021-12-03 | Fulton | Arkansas | 5049 | 1918 | 68 |
1969648 | 1969648 | 2021-12-01 | Prowers | Colorado | 8099 | 1918 | 38 |
1958715 | 1958715 | 2021-11-27 | Hatillo | Puerto Rico | 72065 | 1918 | |
1955464 | 1955464 | 2021-11-26 | Hatillo | Puerto Rico | 72065 | 1918 | |
1944851 | 1944851 | 2021-11-23 | Bollinger | Missouri | 29017 | 1918 | 30 |
1938749 | 1938749 | 2021-11-21 | Yates | New York | 36123 | 1918 | 33 |
1925686 | 1925686 | 2021-11-17 | Socorro | New Mexico | 35053 | 1918 | 64 |
1905594 | 1905594 | 2021-11-11 | Arenac | Michigan | 26011 | 1918 | 38 |
1902345 | 1902345 | 2021-11-10 | Arenac | Michigan | 26011 | 1918 | 38 |
1898646 | 1898646 | 2021-11-09 | Appanoose | Iowa | 19007 | 1918 | 52 |
1895396 | 1895396 | 2021-11-08 | Appanoose | Iowa | 19007 | 1918 | 52 |
1892146 | 1892146 | 2021-11-07 | Appanoose | Iowa | 19007 | 1918 | 52 |
1894327 | 1894327 | 2021-11-07 | Greensville | Virginia | 51081 | 1918 | 26 |
1888896 | 1888896 | 2021-11-06 | Appanoose | Iowa | 19007 | 1918 | 52 |
1890440 | 1890440 | 2021-11-06 | Cabo Rojo | Puerto Rico | 72023 | 1918 | |
1891077 | 1891077 | 2021-11-06 | Greensville | Virginia | 51081 | 1918 | 26 |
1885646 | 1885646 | 2021-11-05 | Appanoose | Iowa | 19007 | 1918 | 52 |
1887190 | 1887190 | 2021-11-05 | Cabo Rojo | Puerto Rico | 72023 | 1918 | |
1887827 | 1887827 | 2021-11-05 | Greensville | Virginia | 51081 | 1918 | 26 |
1882397 | 1882397 | 2021-11-04 | Appanoose | Iowa | 19007 | 1918 | 52 |
1884459 | 1884459 | 2021-11-04 | Ward | Texas | 48475 | 1918 | 30 |
1879148 | 1879148 | 2021-11-03 | Appanoose | Iowa | 19007 | 1918 | 52 |
1864455 | 1864455 | 2021-10-29 | Cidra | Puerto Rico | 72041 | 1918 | |
1834057 | 1834057 | 2021-10-20 | Sagadahoc | Maine | 23023 | 1918 | 12 |
1831958 | 1831958 | 2021-10-19 | Catano | Puerto Rico | 72033 | 1918 | |
1810317 | 1810317 | 2021-10-13 | Inyo | California | 6027 | 1918 | 39 |
1811461 | 1811461 | 2021-10-13 | Cottonwood | Minnesota | 27033 | 1918 | 27 |
1807807 | 1807807 | 2021-10-12 | Jackson | Kansas | 20085 | 1918 | 19 |
1804556 | 1804556 | 2021-10-11 | Jackson | Kansas | 20085 | 1918 | 19 |
1790391 | 1790391 | 2021-10-06 | Patrick | Virginia | 51141 | 1918 | 52 |
1770854 | 1770854 | 2021-09-30 | Grayson | Virginia | 51077 | 1918 | 43 |
1764743 | 1764743 | 2021-09-29 | Bradley | Arkansas | 5011 | 1918 | 37 |
1764508 | 1764508 | 2021-09-28 | Monroe | West Virginia | 54063 | 1918 | 23 |
1748322 | 1748322 | 2021-09-23 | Lafayette | Wisconsin | 55065 | 1918 | 11 |
1744577 | 1744577 | 2021-09-22 | Eastland | Texas | 48133 | 1918 | 62 |
1740986 | 1740986 | 2021-09-21 | Cayey | Puerto Rico | 72035 | 1918 | |
1737737 | 1737737 | 2021-09-20 | Cayey | Puerto Rico | 72035 | 1918 | |
1717469 | 1717469 | 2021-09-14 | Pemiscot | Missouri | 29155 | 1918 | 40 |
1715491 | 1715491 | 2021-09-13 | Terry | Texas | 48445 | 1918 | 61 |
1712245 | 1712245 | 2021-09-12 | Terry | Texas | 48445 | 1918 | 61 |
1708998 | 1708998 | 2021-09-11 | Terry | Texas | 48445 | 1918 | 61 |
1705751 | 1705751 | 2021-09-10 | Terry | Texas | 48445 | 1918 | 61 |
1697422 | 1697422 | 2021-09-08 | Butler | Kentucky | 21031 | 1918 | 28 |
1693588 | 1693588 | 2021-09-07 | Dade | Georgia | 13083 | 1918 | 15 |
1677974 | 1677974 | 2021-09-02 | Lawrence | Kentucky | 21127 | 1918 | 31 |
1675016 | 1675016 | 2021-09-01 | Houston | Minnesota | 27055 | 1918 | 16 |
1648323 | 1648323 | 2021-08-24 | Jo Daviess | Illinois | 17085 | 1918 | 27 |
1630309 | 1630309 | 2021-08-18 | Paulding | Ohio | 39125 | 1918 | 42 |
1614590 | 1614590 | 2021-08-13 | Bosque | Texas | 48035 | 1918 | 39 |
1608056 | 1608056 | 2021-08-11 | Sequatchie | Tennessee | 47153 | 1918 | 30 |
1603681 | 1603681 | 2021-08-10 | Smith | Mississippi | 28129 | 1918 | 37 |
1591262 | 1591262 | 2021-08-06 | Walsh | North Dakota | 38099 | 1918 | 27 |
1560112 | 1560112 | 2021-07-28 | Izard | Arkansas | 5065 | 1918 | 45 |
1554978 | 1554978 | 2021-07-26 | Benton | Missouri | 29015 | 1918 | 36 |
1547031 | 1547031 | 2021-07-24 | Monroe | Alabama | 1099 | 1918 | 41 |
1533664 | 1533664 | 2021-07-19 | Washington | Vermont | 50023 | 1918 | 15 |
1514333 | 1514333 | 2021-07-13 | Island | Washington | 53029 | 1918 | 30 |
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);