ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
294 rows where cases = 1913 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 37
- North Carolina 17
- Iowa 16
- Louisiana 16
- Arkansas 13
- Georgia 12
- Mississippi 11
- Oklahoma 11
- Idaho 10
- Indiana 10
- Kentucky 10
- Missouri 10
- Puerto Rico 10
- Illinois 9
- Virginia 9
- Florida 8
- Texas 7
- Minnesota 6
- Wyoming 6
- Kansas 5
- Michigan 5
- Ohio 5
- Tennessee 5
- West Virginia 5
- Alabama 4
- Colorado 4
- Montana 4
- Oregon 4
- Pennsylvania 4
- Alaska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491748 | 2491748 | 2022-05-10 | Gates | North Carolina | 37073 | 1913 | 20 |
2488490 | 2488490 | 2022-05-09 | Gates | North Carolina | 37073 | 1913 | 20 |
2485233 | 2485233 | 2022-05-08 | Gates | North Carolina | 37073 | 1913 | 20 |
2481975 | 2481975 | 2022-05-07 | Gates | North Carolina | 37073 | 1913 | 20 |
2478717 | 2478717 | 2022-05-06 | Gates | North Carolina | 37073 | 1913 | 20 |
2475459 | 2475459 | 2022-05-05 | Gates | North Carolina | 37073 | 1913 | 20 |
2472202 | 2472202 | 2022-05-04 | Gates | North Carolina | 37073 | 1913 | 20 |
2464913 | 2464913 | 2022-05-02 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2461657 | 2461657 | 2022-05-01 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2458401 | 2458401 | 2022-04-30 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2455145 | 2455145 | 2022-04-29 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2451889 | 2451889 | 2022-04-28 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2448633 | 2448633 | 2022-04-27 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2445377 | 2445377 | 2022-04-26 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2442121 | 2442121 | 2022-04-25 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2438865 | 2438865 | 2022-04-24 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2435609 | 2435609 | 2022-04-23 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2432353 | 2432353 | 2022-04-22 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2429097 | 2429097 | 2022-04-21 | St. Helena | Louisiana | 22091 | 1913 | 23 |
2265404 | 2265404 | 2022-03-02 | Monroe | Arkansas | 5095 | 1913 | 31 |
2255651 | 2255651 | 2022-02-27 | Monroe | Arkansas | 5095 | 1913 | 31 |
2258738 | 2258738 | 2022-02-27 | Sublette | Wyoming | 56035 | 1913 | 27 |
2255487 | 2255487 | 2022-02-26 | Sublette | Wyoming | 56035 | 1913 | 27 |
2252236 | 2252236 | 2022-02-25 | Sublette | Wyoming | 56035 | 1913 | 27 |
2248985 | 2248985 | 2022-02-24 | Sublette | Wyoming | 56035 | 1913 | 27 |
2240210 | 2240210 | 2022-02-22 | Pratt | Kansas | 20151 | 1913 | 30 |
2242206 | 2242206 | 2022-02-22 | Falls Church city | Virginia | 51610 | 1913 | 16 |
2242374 | 2242374 | 2022-02-22 | Pendleton | West Virginia | 54071 | 1913 | 16 |
2236959 | 2236959 | 2022-02-21 | Pratt | Kansas | 20151 | 1913 | 30 |
2238955 | 2238955 | 2022-02-21 | Falls Church city | Virginia | 51610 | 1913 | 16 |
2218489 | 2218489 | 2022-02-15 | Benson | North Dakota | 38005 | 1913 | 22 |
2218671 | 2218671 | 2022-02-15 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2215420 | 2215420 | 2022-02-14 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2212169 | 2212169 | 2022-02-13 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2208916 | 2208916 | 2022-02-12 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2205663 | 2205663 | 2022-02-11 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2202410 | 2202410 | 2022-02-10 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2199156 | 2199156 | 2022-02-09 | Kiowa | Oklahoma | 40075 | 1913 | 49 |
2191019 | 2191019 | 2022-02-07 | Benewah | Idaho | 16009 | 1913 | 35 |
2189593 | 2189593 | 2022-02-06 | Patillas | Puerto Rico | 72109 | 1913 | |
2164521 | 2164521 | 2022-01-30 | Sitka City and Borough | Alaska | 2220 | 1913 | 5 |
2161266 | 2161266 | 2022-01-29 | Sitka City and Borough | Alaska | 2220 | 1913 | 5 |
2158010 | 2158010 | 2022-01-28 | Sitka City and Borough | Alaska | 2220 | 1913 | 5 |
2159522 | 2159522 | 2022-01-28 | St. Clair | Missouri | 29185 | 1913 | 29 |
2128533 | 2128533 | 2022-01-18 | Ritchie | West Virginia | 54085 | 1913 | 26 |
2108230 | 2108230 | 2022-01-12 | Ciales | Puerto Rico | 72039 | 1913 | |
2100987 | 2100987 | 2022-01-10 | Wayne | Missouri | 29223 | 1913 | 37 |
2097750 | 2097750 | 2022-01-09 | Dawson | Montana | 30021 | 1913 | 52 |
2094498 | 2094498 | 2022-01-08 | Dawson | Montana | 30021 | 1913 | 52 |
2091246 | 2091246 | 2022-01-07 | Dawson | Montana | 30021 | 1913 | 52 |
2061824 | 2061824 | 2021-12-29 | Montgomery | Mississippi | 28097 | 1913 | 57 |
2058578 | 2058578 | 2021-12-28 | Noxubee | Mississippi | 28103 | 1913 | 44 |
2015298 | 2015298 | 2021-12-15 | Early | Georgia | 13099 | 1913 | 58 |
2016222 | 2016222 | 2021-12-15 | Koochiching | Minnesota | 27071 | 1913 | 27 |
2006009 | 2006009 | 2021-12-12 | Brown | Kansas | 20013 | 1913 | 42 |
2002758 | 2002758 | 2021-12-11 | Brown | Kansas | 20013 | 1913 | 42 |
1999508 | 1999508 | 2021-12-10 | Brown | Kansas | 20013 | 1913 | 42 |
1966704 | 1966704 | 2021-11-30 | Washington | Idaho | 16087 | 1913 | 47 |
1960201 | 1960201 | 2021-11-28 | Washington | Idaho | 16087 | 1913 | 47 |
1956950 | 1956950 | 2021-11-27 | Washington | Idaho | 16087 | 1913 | 47 |
1953699 | 1953699 | 2021-11-26 | Washington | Idaho | 16087 | 1913 | 47 |
1950448 | 1950448 | 2021-11-25 | Washington | Idaho | 16087 | 1913 | 47 |
1947197 | 1947197 | 2021-11-24 | Washington | Idaho | 16087 | 1913 | 47 |
1943946 | 1943946 | 2021-11-23 | Washington | Idaho | 16087 | 1913 | 47 |
1926209 | 1926209 | 2021-11-17 | Hatillo | Puerto Rico | 72065 | 1913 | |
1917361 | 1917361 | 2021-11-15 | Conecuh | Alabama | 1035 | 1913 | 60 |
1919189 | 1919189 | 2021-11-15 | Torrance | New Mexico | 35057 | 1913 | 20 |
1915377 | 1915377 | 2021-11-14 | Kalkaska | Michigan | 26079 | 1913 | 40 |
1912127 | 1912127 | 2021-11-13 | Kalkaska | Michigan | 26079 | 1913 | 40 |
1908877 | 1908877 | 2021-11-12 | Kalkaska | Michigan | 26079 | 1913 | 40 |
1907400 | 1907400 | 2021-11-11 | Westmoreland | Virginia | 51193 | 1913 | 37 |
1895790 | 1895790 | 2021-11-08 | Lincoln | Maine | 23015 | 1913 | 7 |
1892540 | 1892540 | 2021-11-07 | Lincoln | Maine | 23015 | 1913 | 7 |
1889290 | 1889290 | 2021-11-06 | Lincoln | Maine | 23015 | 1913 | 7 |
1884977 | 1884977 | 2021-11-05 | Desha | Arkansas | 5041 | 1913 | 33 |
1857948 | 1857948 | 2021-10-27 | Cabo Rojo | Puerto Rico | 72023 | 1913 | |
1854699 | 1854699 | 2021-10-26 | Cabo Rojo | Puerto Rico | 72023 | 1913 | |
1851450 | 1851450 | 2021-10-25 | Cabo Rojo | Puerto Rico | 72023 | 1913 | |
1837468 | 1837468 | 2021-10-21 | Kanabec | Minnesota | 27065 | 1913 | 30 |
1818962 | 1818962 | 2021-10-15 | Catano | Puerto Rico | 72033 | 1913 | |
1805609 | 1805609 | 2021-10-11 | Swain | North Carolina | 37173 | 1913 | 22 |
1791636 | 1791636 | 2021-10-07 | Breathitt | Kentucky | 21025 | 1913 | 24 |
1770566 | 1770566 | 2021-09-30 | Duval | Texas | 48131 | 1913 | 52 |
1771106 | 1771106 | 2021-09-30 | Converse | Wyoming | 56009 | 1913 | 30 |
1692141 | 1692141 | 2021-09-06 | Clatsop | Oregon | 41007 | 1913 | 21 |
1688892 | 1688892 | 2021-09-05 | Clatsop | Oregon | 41007 | 1913 | 21 |
1685642 | 1685642 | 2021-09-04 | Clatsop | Oregon | 41007 | 1913 | 21 |
1682391 | 1682391 | 2021-09-03 | Clatsop | Oregon | 41007 | 1913 | 21 |
1677249 | 1677249 | 2021-09-02 | Franklin | Florida | 12037 | 1913 | 20 |
1679292 | 1679292 | 2021-09-02 | Morovis | Puerto Rico | 72101 | 1913 | |
1674002 | 1674002 | 2021-09-01 | Franklin | Florida | 12037 | 1913 | 20 |
1675150 | 1675150 | 2021-09-01 | Walthall | Mississippi | 28147 | 1913 | 53 |
1670754 | 1670754 | 2021-08-31 | Franklin | Florida | 12037 | 1913 | 20 |
1667507 | 1667507 | 2021-08-30 | Franklin | Florida | 12037 | 1913 | 20 |
1664260 | 1664260 | 2021-08-29 | Franklin | Florida | 12037 | 1913 | 20 |
1661012 | 1661012 | 2021-08-28 | Franklin | Florida | 12037 | 1913 | 20 |
1657467 | 1657467 | 2021-08-27 | Macon | Alabama | 1087 | 1913 | 54 |
1657764 | 1657764 | 2021-08-27 | Franklin | Florida | 12037 | 1913 | 20 |
1655199 | 1655199 | 2021-08-26 | Casey | Kentucky | 21045 | 1913 | 43 |
1652486 | 1652486 | 2021-08-25 | Macon | Missouri | 29121 | 1913 | 19 |
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);