ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
257 rows where cases = 1898 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 24
- Georgia 22
- Vermont 18
- Illinois 16
- North Carolina 13
- Kansas 12
- Oklahoma 12
- Tennessee 11
- Texas 10
- Virginia 10
- Alabama 8
- Louisiana 8
- Minnesota 8
- Wyoming 8
- Idaho 6
- Indiana 6
- Kentucky 6
- Missouri 6
- Ohio 5
- Pennsylvania 5
- Puerto Rico 5
- Arkansas 4
- Iowa 3
- Montana 3
- New York 3
- South Carolina 3
- Colorado 2
- Florida 2
- Maine 2
- Massachusetts 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423363 | 2423363 | 2022-04-19 | Gates | North Carolina | 37073 | 1898 | 19 |
2420106 | 2420106 | 2022-04-18 | Gates | North Carolina | 37073 | 1898 | 19 |
2416851 | 2416851 | 2022-04-17 | Gates | North Carolina | 37073 | 1898 | 19 |
2413595 | 2413595 | 2022-04-16 | Gates | North Carolina | 37073 | 1898 | 19 |
2410339 | 2410339 | 2022-04-15 | Gates | North Carolina | 37073 | 1898 | 19 |
2407083 | 2407083 | 2022-04-14 | Gates | North Carolina | 37073 | 1898 | 19 |
2403827 | 2403827 | 2022-04-13 | Gates | North Carolina | 37073 | 1898 | 19 |
2294509 | 2294509 | 2022-03-10 | Platte | Wyoming | 56031 | 1898 | 39 |
2291257 | 2291257 | 2022-03-09 | Platte | Wyoming | 56031 | 1898 | 39 |
2288005 | 2288005 | 2022-03-08 | Platte | Wyoming | 56031 | 1898 | 39 |
2261447 | 2261447 | 2022-02-28 | Floyd | Texas | 48153 | 1898 | 47 |
2214664 | 2214664 | 2022-02-14 | Franklin | Mississippi | 28037 | 1898 | 35 |
2213225 | 2213225 | 2022-02-13 | Sublette | Wyoming | 56035 | 1898 | 26 |
2209972 | 2209972 | 2022-02-12 | Sublette | Wyoming | 56035 | 1898 | 26 |
2206719 | 2206719 | 2022-02-11 | Sublette | Wyoming | 56035 | 1898 | 26 |
2177995 | 2177995 | 2022-02-03 | Wilcox | Georgia | 13315 | 1898 | 62 |
2175814 | 2175814 | 2022-02-02 | Carbon | Montana | 30009 | 1898 | 27 |
2172328 | 2172328 | 2022-02-01 | Pipestone | Minnesota | 27117 | 1898 | 32 |
2167159 | 2167159 | 2022-01-30 | Hamilton | Texas | 48193 | 1898 | 29 |
2157376 | 2157376 | 2022-01-27 | Franklin | Texas | 48159 | 1898 | 37 |
2149134 | 2149134 | 2022-01-25 | Pawnee | Kansas | 20145 | 1898 | 21 |
2145882 | 2145882 | 2022-01-24 | Pawnee | Kansas | 20145 | 1898 | 21 |
2142972 | 2142972 | 2022-01-23 | Presque Isle | Michigan | 26141 | 1898 | 53 |
2143017 | 2143017 | 2022-01-23 | Jackson | Minnesota | 27063 | 1898 | 16 |
2139717 | 2139717 | 2022-01-22 | Presque Isle | Michigan | 26141 | 1898 | 53 |
2139762 | 2139762 | 2022-01-22 | Jackson | Minnesota | 27063 | 1898 | 16 |
2136461 | 2136461 | 2022-01-21 | Presque Isle | Michigan | 26141 | 1898 | 53 |
2136506 | 2136506 | 2022-01-21 | Jackson | Minnesota | 27063 | 1898 | 16 |
2121526 | 2121526 | 2022-01-16 | Blanco | Texas | 48031 | 1898 | 28 |
2096606 | 2096606 | 2022-01-09 | Long | Georgia | 13183 | 1898 | 29 |
2093354 | 2093354 | 2022-01-08 | Long | Georgia | 13183 | 1898 | 29 |
2090102 | 2090102 | 2022-01-07 | Long | Georgia | 13183 | 1898 | 29 |
2086851 | 2086851 | 2022-01-06 | Long | Georgia | 13183 | 1898 | 29 |
2083599 | 2083599 | 2022-01-05 | Long | Georgia | 13183 | 1898 | 29 |
2080398 | 2080398 | 2022-01-04 | Turner | Georgia | 13287 | 1898 | 50 |
2074654 | 2074654 | 2022-01-02 | Luce | Michigan | 26095 | 1898 | 6 |
2071403 | 2071403 | 2022-01-01 | Luce | Michigan | 26095 | 1898 | 6 |
2068152 | 2068152 | 2021-12-31 | Luce | Michigan | 26095 | 1898 | 6 |
2064901 | 2064901 | 2021-12-30 | Luce | Michigan | 26095 | 1898 | 6 |
2061651 | 2061651 | 2021-12-29 | Luce | Michigan | 26095 | 1898 | 6 |
2040881 | 2040881 | 2021-12-23 | Coosa | Alabama | 1037 | 1898 | 48 |
2012562 | 2012562 | 2021-12-14 | Marshall | Kansas | 20117 | 1898 | 34 |
2009311 | 2009311 | 2021-12-13 | Marshall | Kansas | 20117 | 1898 | 34 |
1968758 | 1968758 | 2021-11-30 | Callahan | Texas | 48059 | 1898 | 57 |
1953277 | 1953277 | 2021-11-26 | Stone | Arkansas | 5137 | 1898 | 45 |
1928749 | 1928749 | 2021-11-18 | Richland | Montana | 30083 | 1898 | 24 |
1911445 | 1911445 | 2021-11-13 | Washington | Idaho | 16087 | 1898 | 47 |
1888113 | 1888113 | 2021-11-06 | Conecuh | Alabama | 1035 | 1898 | 60 |
1886040 | 1886040 | 2021-11-05 | Lincoln | Maine | 23015 | 1898 | 7 |
1864139 | 1864139 | 2021-10-29 | Mountrail | North Dakota | 38061 | 1898 | 27 |
1859876 | 1859876 | 2021-10-28 | Carroll | Kentucky | 21041 | 1898 | 27 |
1846819 | 1846819 | 2021-10-24 | Nemaha | Kansas | 20131 | 1898 | 56 |
1843569 | 1843569 | 2021-10-23 | Nemaha | Kansas | 20131 | 1898 | 56 |
1840319 | 1840319 | 2021-10-22 | Nemaha | Kansas | 20131 | 1898 | 56 |
1828713 | 1828713 | 2021-10-18 | Cidra | Puerto Rico | 72041 | 1898 | |
1818204 | 1818204 | 2021-10-15 | Ripley | Missouri | 29181 | 1898 | 24 |
1799241 | 1799241 | 2021-10-09 | Noble | Ohio | 39121 | 1898 | 44 |
1792878 | 1792878 | 2021-10-07 | Tillamook | Oregon | 41057 | 1898 | 24 |
1790349 | 1790349 | 2021-10-06 | Goochland | Virginia | 51075 | 1898 | 28 |
1785308 | 1785308 | 2021-10-05 | West Carroll | Louisiana | 22123 | 1898 | 46 |
1785362 | 1785362 | 2021-10-05 | Nantucket | Massachusetts | 25019 | 1898 | 0 |
1767857 | 1767857 | 2021-09-29 | Converse | Wyoming | 56009 | 1898 | 30 |
1736063 | 1736063 | 2021-09-20 | Piatt | Illinois | 17147 | 1898 | 20 |
1708265 | 1708265 | 2021-09-11 | Meigs | Ohio | 39105 | 1898 | 42 |
1697066 | 1697066 | 2021-09-08 | Mason | Illinois | 17125 | 1898 | 50 |
1697540 | 1697540 | 2021-09-08 | Claiborne | Louisiana | 22027 | 1898 | 58 |
1693028 | 1693028 | 2021-09-06 | Lewis | West Virginia | 54041 | 1898 | 27 |
1673677 | 1673677 | 2021-09-01 | Cleburne | Alabama | 1029 | 1898 | 46 |
1644581 | 1644581 | 2021-08-23 | Lee | Arkansas | 5077 | 1898 | 40 |
1645989 | 1645989 | 2021-08-23 | Macon | Missouri | 29121 | 1898 | 19 |
1646392 | 1646392 | 2021-08-23 | Madison | North Carolina | 37115 | 1898 | 43 |
1624049 | 1624049 | 2021-08-16 | Fajardo | Puerto Rico | 72053 | 1898 | |
1604659 | 1604659 | 2021-08-10 | Saluda | South Carolina | 45081 | 1898 | 48 |
1581059 | 1581059 | 2021-08-03 | Ste. Genevieve | Missouri | 29186 | 1898 | 17 |
1556513 | 1556513 | 2021-07-26 | Scott | Virginia | 51169 | 1898 | 60 |
1541120 | 1541120 | 2021-07-22 | Hancock | Illinois | 17067 | 1898 | 42 |
1514517 | 1514517 | 2021-07-14 | Cherokee | Alabama | 1019 | 1898 | 47 |
1505530 | 1505530 | 2021-07-11 | Orange | Indiana | 18117 | 1898 | 59 |
1502284 | 1502284 | 2021-07-10 | Orange | Indiana | 18117 | 1898 | 59 |
1499038 | 1499038 | 2021-07-09 | Orange | Indiana | 18117 | 1898 | 59 |
1497949 | 1497949 | 2021-07-08 | Washington | Vermont | 50023 | 1898 | 15 |
1488208 | 1488208 | 2021-07-05 | Washington | Vermont | 50023 | 1898 | 15 |
1484961 | 1484961 | 2021-07-04 | Washington | Vermont | 50023 | 1898 | 15 |
1481715 | 1481715 | 2021-07-03 | Washington | Vermont | 50023 | 1898 | 15 |
1478468 | 1478468 | 2021-07-02 | Washington | Vermont | 50023 | 1898 | 15 |
1475222 | 1475222 | 2021-07-01 | Washington | Vermont | 50023 | 1898 | 15 |
1471026 | 1471026 | 2021-06-30 | Northampton | North Carolina | 37131 | 1898 | 61 |
1471976 | 1471976 | 2021-06-30 | Washington | Vermont | 50023 | 1898 | 15 |
1466213 | 1466213 | 2021-06-29 | Berrien | Georgia | 13019 | 1898 | 46 |
1468731 | 1468731 | 2021-06-29 | Washington | Vermont | 50023 | 1898 | 15 |
1462968 | 1462968 | 2021-06-28 | Berrien | Georgia | 13019 | 1898 | 46 |
1465486 | 1465486 | 2021-06-28 | Washington | Vermont | 50023 | 1898 | 15 |
1462241 | 1462241 | 2021-06-27 | Washington | Vermont | 50023 | 1898 | 15 |
1458996 | 1458996 | 2021-06-26 | Washington | Vermont | 50023 | 1898 | 15 |
1455751 | 1455751 | 2021-06-25 | Washington | Vermont | 50023 | 1898 | 15 |
1450901 | 1450901 | 2021-06-24 | Roscommon | Michigan | 26143 | 1898 | 54 |
1452506 | 1452506 | 2021-06-24 | Washington | Vermont | 50023 | 1898 | 15 |
1447655 | 1447655 | 2021-06-23 | Roscommon | Michigan | 26143 | 1898 | 54 |
1449260 | 1449260 | 2021-06-23 | Washington | Vermont | 50023 | 1898 | 15 |
1444410 | 1444410 | 2021-06-22 | Roscommon | Michigan | 26143 | 1898 | 54 |
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);