ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
744 rows where cases = 320 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 71
- Texas 71
- Nebraska 51
- Virginia 41
- South Dakota 39
- Puerto Rico 35
- North Carolina 27
- Georgia 26
- Missouri 26
- Minnesota 23
- Kentucky 22
- Kansas 20
- Indiana 19
- Colorado 17
- Iowa 16
- Mississippi 14
- Alabama 13
- Idaho 13
- New York 13
- Ohio 13
- Oregon 13
- Tennessee 12
- Alaska 11
- Arkansas 11
- Michigan 11
- Illinois 10
- Louisiana 10
- Florida 9
- Pennsylvania 9
- Montana 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469262 | 2469262 | 2022-05-03 | Sherman | Oregon | 41055 | 320 | 6 |
2466006 | 2466006 | 2022-05-02 | Sherman | Oregon | 41055 | 320 | 6 |
2462751 | 2462751 | 2022-05-01 | Sherman | Oregon | 41055 | 320 | 6 |
2459495 | 2459495 | 2022-04-30 | Sherman | Oregon | 41055 | 320 | 6 |
2456239 | 2456239 | 2022-04-29 | Sherman | Oregon | 41055 | 320 | 6 |
2452983 | 2452983 | 2022-04-28 | Sherman | Oregon | 41055 | 320 | 6 |
2449727 | 2449727 | 2022-04-27 | Sherman | Oregon | 41055 | 320 | 6 |
2446470 | 2446470 | 2022-04-26 | Sherman | Oregon | 41055 | 320 | 6 |
2426935 | 2426935 | 2022-04-20 | Sherman | Oregon | 41055 | 320 | 6 |
2200495 | 2200495 | 2022-02-10 | Kiowa | Colorado | 8061 | 320 | 6 |
2195490 | 2195490 | 2022-02-08 | Storey | Nevada | 32029 | 320 | 9 |
2154315 | 2154315 | 2022-01-26 | Rich | Utah | 49033 | 320 | 0 |
2146612 | 2146612 | 2022-01-24 | Dundy | Nebraska | 31057 | 320 | 6 |
2127095 | 2127095 | 2022-01-18 | Gosper | Nebraska | 31073 | 320 | 7 |
2102212 | 2102212 | 2022-01-10 | Sherman | Texas | 48421 | 320 | 16 |
2097803 | 2097803 | 2022-01-09 | Boyd | Nebraska | 31015 | 320 | 5 |
2098961 | 2098961 | 2022-01-09 | Sherman | Texas | 48421 | 320 | 16 |
2094551 | 2094551 | 2022-01-08 | Boyd | Nebraska | 31015 | 320 | 5 |
2091299 | 2091299 | 2022-01-07 | Boyd | Nebraska | 31015 | 320 | 5 |
2084824 | 2084824 | 2022-01-05 | Garfield | Nebraska | 31071 | 320 | 2 |
2058848 | 2058848 | 2021-12-28 | Pawnee | Nebraska | 31133 | 320 | 4 |
2055599 | 2055599 | 2021-12-27 | Pawnee | Nebraska | 31133 | 320 | 4 |
2052349 | 2052349 | 2021-12-26 | Pawnee | Nebraska | 31133 | 320 | 4 |
2049099 | 2049099 | 2021-12-25 | Pawnee | Nebraska | 31133 | 320 | 4 |
2045849 | 2045849 | 2021-12-24 | Pawnee | Nebraska | 31133 | 320 | 4 |
2042599 | 2042599 | 2021-12-23 | Pawnee | Nebraska | 31133 | 320 | 4 |
2039350 | 2039350 | 2021-12-22 | Pawnee | Nebraska | 31133 | 320 | 4 |
2036100 | 2036100 | 2021-12-21 | Pawnee | Nebraska | 31133 | 320 | 4 |
1989850 | 1989850 | 2021-12-07 | Wichita | Kansas | 20203 | 320 | 8 |
1986600 | 1986600 | 2021-12-06 | Wichita | Kansas | 20203 | 320 | 8 |
1921879 | 1921879 | 2021-11-16 | Keweenaw | Michigan | 26083 | 320 | 6 |
1918629 | 1918629 | 2021-11-15 | Keweenaw | Michigan | 26083 | 320 | 6 |
1896608 | 1896608 | 2021-11-08 | Burke | North Dakota | 38013 | 320 | 3 |
1893358 | 1893358 | 2021-11-07 | Burke | North Dakota | 38013 | 320 | 3 |
1880857 | 1880857 | 2021-11-03 | Mellette | South Dakota | 46095 | 320 | 3 |
1877608 | 1877608 | 2021-11-02 | Mellette | South Dakota | 46095 | 320 | 3 |
1867031 | 1867031 | 2021-10-30 | Brown | Nebraska | 31017 | 320 | 4 |
1867053 | 1867053 | 2021-10-30 | Franklin | Nebraska | 31061 | 320 | 6 |
1863782 | 1863782 | 2021-10-29 | Brown | Nebraska | 31017 | 320 | 4 |
1863804 | 1863804 | 2021-10-29 | Franklin | Nebraska | 31061 | 320 | 6 |
1860555 | 1860555 | 2021-10-28 | Franklin | Nebraska | 31061 | 320 | 6 |
1857306 | 1857306 | 2021-10-27 | Franklin | Nebraska | 31061 | 320 | 6 |
1854863 | 1854863 | 2021-10-26 | McPherson | South Dakota | 46089 | 320 | 7 |
1849410 | 1849410 | 2021-10-25 | Sedgwick | Colorado | 8115 | 320 | 4 |
1844631 | 1844631 | 2021-10-23 | Grant | North Dakota | 38037 | 320 | 7 |
1832099 | 1832099 | 2021-10-19 | Haakon | South Dakota | 46055 | 320 | 11 |
1828390 | 1828390 | 2021-10-18 | Logan | North Dakota | 38047 | 320 | 11 |
1813032 | 1813032 | 2021-10-13 | Grand Isle | Vermont | 50013 | 320 | 2 |
1805331 | 1805331 | 2021-10-11 | Hitchcock | Nebraska | 31087 | 320 | 5 |
1802082 | 1802082 | 2021-10-10 | Hitchcock | Nebraska | 31087 | 320 | 5 |
1798833 | 1798833 | 2021-10-09 | Hitchcock | Nebraska | 31087 | 320 | 5 |
1795584 | 1795584 | 2021-10-08 | Hitchcock | Nebraska | 31087 | 320 | 5 |
1792335 | 1792335 | 2021-10-07 | Hitchcock | Nebraska | 31087 | 320 | 5 |
1790611 | 1790611 | 2021-10-06 | Niobrara | Wyoming | 56027 | 320 | 5 |
1785226 | 1785226 | 2021-10-05 | Robertson | Kentucky | 21201 | 320 | 15 |
1762283 | 1762283 | 2021-09-28 | Chase | Kansas | 20017 | 320 | 3 |
1759035 | 1759035 | 2021-09-27 | Chase | Kansas | 20017 | 320 | 3 |
1743913 | 1743913 | 2021-09-22 | Kidder | North Dakota | 38043 | 320 | 10 |
1722065 | 1722065 | 2021-09-15 | St. John | Virgin Islands | 78020 | 320 | 3 |
1717485 | 1717485 | 2021-09-14 | Scotland | Missouri | 29199 | 320 | 4 |
1717898 | 1717898 | 2021-09-14 | Adams | North Dakota | 38001 | 320 | 3 |
1718817 | 1718817 | 2021-09-14 | St. John | Virgin Islands | 78020 | 320 | 3 |
1715569 | 1715569 | 2021-09-13 | St. John | Virgin Islands | 78020 | 320 | 3 |
1711908 | 1711908 | 2021-09-12 | Miner | South Dakota | 46097 | 320 | 10 |
1708661 | 1708661 | 2021-09-11 | Miner | South Dakota | 46097 | 320 | 10 |
1705414 | 1705414 | 2021-09-10 | Miner | South Dakota | 46097 | 320 | 10 |
1705708 | 1705708 | 2021-09-10 | Oldham | Texas | 48359 | 320 | 4 |
1677876 | 1677876 | 2021-09-02 | Osborne | Kansas | 20141 | 320 | 12 |
1674629 | 1674629 | 2021-09-01 | Osborne | Kansas | 20141 | 320 | 12 |
1664006 | 1664006 | 2021-08-29 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 320 | 5 |
1660758 | 1660758 | 2021-08-28 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 320 | 5 |
1657510 | 1657510 | 2021-08-27 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 320 | 5 |
1660336 | 1660336 | 2021-08-27 | Essex | Vermont | 50009 | 320 | 2 |
1655126 | 1655126 | 2021-08-26 | Logan | Kansas | 20109 | 320 | 7 |
1651879 | 1651879 | 2021-08-25 | Logan | Kansas | 20109 | 320 | 7 |
1610975 | 1610975 | 2021-08-12 | Cameron | Pennsylvania | 42023 | 320 | 10 |
1607727 | 1607727 | 2021-08-11 | Cameron | Pennsylvania | 42023 | 320 | 10 |
1587824 | 1587824 | 2021-08-05 | Hamilton | New York | 36041 | 320 | 2 |
1578967 | 1578967 | 2021-08-02 | Kimble | Texas | 48267 | 320 | 7 |
1566034 | 1566034 | 2021-07-29 | Real | Texas | 48385 | 320 | 13 |
1423871 | 1423871 | 2021-06-16 | Baca | Colorado | 8009 | 320 | 4 |
1420623 | 1420623 | 2021-06-15 | Baca | Colorado | 8009 | 320 | 4 |
1396783 | 1396783 | 2021-06-07 | Las Marias | Puerto Rico | 72083 | 320 | |
1380845 | 1380845 | 2021-06-02 | Cochran | Texas | 48079 | 320 | 15 |
1377600 | 1377600 | 2021-06-01 | Cochran | Texas | 48079 | 320 | 15 |
1374354 | 1374354 | 2021-05-31 | Cochran | Texas | 48079 | 320 | 15 |
1369003 | 1369003 | 2021-05-30 | Kauai | Hawaii | 15007 | 320 | 2 |
1371109 | 1371109 | 2021-05-30 | Cochran | Texas | 48079 | 320 | 15 |
1367863 | 1367863 | 2021-05-29 | Cochran | Texas | 48079 | 320 | 15 |
1364617 | 1364617 | 2021-05-28 | Cochran | Texas | 48079 | 320 | 15 |
1364909 | 1364909 | 2021-05-28 | Craig | Virginia | 51045 | 320 | 6 |
1361371 | 1361371 | 2021-05-27 | Cochran | Texas | 48079 | 320 | 15 |
1358125 | 1358125 | 2021-05-26 | Cochran | Texas | 48079 | 320 | 15 |
1354879 | 1354879 | 2021-05-25 | Cochran | Texas | 48079 | 320 | 15 |
1347717 | 1347717 | 2021-05-23 | Tyrrell | North Carolina | 37177 | 320 | 6 |
1344469 | 1344469 | 2021-05-22 | Tyrrell | North Carolina | 37177 | 320 | 6 |
1341221 | 1341221 | 2021-05-21 | Tyrrell | North Carolina | 37177 | 320 | 6 |
1337973 | 1337973 | 2021-05-20 | Tyrrell | North Carolina | 37177 | 320 | 6 |
1334317 | 1334317 | 2021-05-19 | Putnam | Missouri | 29171 | 320 | 4 |
1334726 | 1334726 | 2021-05-19 | Tyrrell | North Carolina | 37177 | 320 | 6 |
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);