ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
587 rows where cases = 500 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 48
- Nebraska 38
- Virginia 36
- Georgia 34
- Kansas 26
- Iowa 25
- Minnesota 25
- Missouri 20
- Puerto Rico 20
- South Dakota 18
- Illinois 17
- Kentucky 16
- North Carolina 16
- Oklahoma 16
- Montana 15
- Arkansas 14
- Mississippi 14
- North Dakota 14
- Indiana 12
- Wyoming 12
- Colorado 11
- Michigan 11
- Tennessee 11
- Ohio 10
- Alabama 9
- Nevada 9
- Louisiana 8
- West Virginia 8
- Wisconsin 8
- Florida 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2271131 | 2271131 | 2022-03-03 | Armstrong | Texas | 48011 | 500 | 8 |
2267879 | 2267879 | 2022-03-02 | Armstrong | Texas | 48011 | 500 | 8 |
2264626 | 2264626 | 2022-03-01 | Armstrong | Texas | 48011 | 500 | 8 |
2237701 | 2237701 | 2022-02-21 | Hitchcock | Nebraska | 31087 | 500 | 6 |
2234450 | 2234450 | 2022-02-20 | Hitchcock | Nebraska | 31087 | 500 | 6 |
2231199 | 2231199 | 2022-02-19 | Hitchcock | Nebraska | 31087 | 500 | 6 |
2227948 | 2227948 | 2022-02-18 | Hitchcock | Nebraska | 31087 | 500 | 6 |
2193291 | 2193291 | 2022-02-07 | Schleicher | Texas | 48413 | 500 | 9 |
2176577 | 2176577 | 2022-02-02 | Maricao | Puerto Rico | 72093 | 500 | |
2173453 | 2173453 | 2022-02-01 | Mellette | South Dakota | 46095 | 500 | 5 |
2155064 | 2155064 | 2022-01-27 | Baker | Georgia | 13007 | 500 | 14 |
2155599 | 2155599 | 2022-01-27 | Graham | Kansas | 20065 | 500 | 13 |
2152346 | 2152346 | 2022-01-26 | Graham | Kansas | 20065 | 500 | 13 |
2143344 | 2143344 | 2022-01-23 | Cherry | Nebraska | 31031 | 500 | 8 |
2140089 | 2140089 | 2022-01-22 | Cherry | Nebraska | 31031 | 500 | 8 |
2136833 | 2136833 | 2022-01-21 | Cherry | Nebraska | 31031 | 500 | 8 |
2103532 | 2103532 | 2022-01-11 | Chase | Kansas | 20017 | 500 | 6 |
2100281 | 2100281 | 2022-01-10 | Chase | Kansas | 20017 | 500 | 6 |
2063600 | 2063600 | 2021-12-29 | Niobrara | Wyoming | 56027 | 500 | 8 |
2060350 | 2060350 | 2021-12-28 | Niobrara | Wyoming | 56027 | 500 | 8 |
2053852 | 2053852 | 2021-12-26 | Niobrara | Wyoming | 56027 | 500 | 8 |
2050602 | 2050602 | 2021-12-25 | Niobrara | Wyoming | 56027 | 500 | 8 |
2047352 | 2047352 | 2021-12-24 | Niobrara | Wyoming | 56027 | 500 | 8 |
2044102 | 2044102 | 2021-12-23 | Niobrara | Wyoming | 56027 | 500 | 8 |
2020627 | 2020627 | 2021-12-16 | Potter | South Dakota | 46107 | 500 | 5 |
2017376 | 2017376 | 2021-12-15 | Potter | South Dakota | 46107 | 500 | 5 |
2013172 | 2013172 | 2021-12-14 | Mercer | Missouri | 29129 | 500 | 9 |
2014849 | 2014849 | 2021-12-14 | Niobrara | Wyoming | 56027 | 500 | 8 |
1997876 | 1997876 | 2021-12-09 | Stanley | South Dakota | 46117 | 500 | 3 |
1993695 | 1993695 | 2021-12-08 | Schuyler | Missouri | 29197 | 500 | 22 |
1943032 | 1943032 | 2021-11-22 | Bath | Virginia | 51017 | 500 | 15 |
1939782 | 1939782 | 2021-11-21 | Bath | Virginia | 51017 | 500 | 15 |
1936532 | 1936532 | 2021-11-20 | Bath | Virginia | 51017 | 500 | 15 |
1932211 | 1932211 | 2021-11-19 | Hamilton | New York | 36041 | 500 | 3 |
1933282 | 1933282 | 2021-11-19 | Bath | Virginia | 51017 | 500 | 15 |
1929124 | 1929124 | 2021-11-18 | McIntosh | North Dakota | 38051 | 500 | 8 |
1930030 | 1930030 | 2021-11-18 | Bath | Virginia | 51017 | 500 | 15 |
1915460 | 1915460 | 2021-11-14 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1912210 | 1912210 | 2021-11-13 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1908960 | 1908960 | 2021-11-12 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1905711 | 1905711 | 2021-11-11 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1902850 | 1902850 | 2021-11-10 | Stanton | Nebraska | 31167 | 500 | 11 |
1898810 | 1898810 | 2021-11-09 | Ness | Kansas | 20135 | 500 | 17 |
1895560 | 1895560 | 2021-11-08 | Ness | Kansas | 20135 | 500 | 17 |
1876861 | 1876861 | 2021-11-02 | Webster | Nebraska | 31181 | 500 | 8 |
1873612 | 1873612 | 2021-11-01 | Webster | Nebraska | 31181 | 500 | 8 |
1830589 | 1830589 | 2021-10-19 | Rush | Kansas | 20165 | 500 | 15 |
1827340 | 1827340 | 2021-10-18 | Rush | Kansas | 20165 | 500 | 15 |
1824517 | 1824517 | 2021-10-17 | Traverse | Minnesota | 27155 | 500 | 5 |
1821268 | 1821268 | 2021-10-16 | Traverse | Minnesota | 27155 | 500 | 5 |
1818019 | 1818019 | 2021-10-15 | Traverse | Minnesota | 27155 | 500 | 5 |
1812591 | 1812591 | 2021-10-13 | Clark | South Dakota | 46025 | 500 | 5 |
1790711 | 1790711 | 2021-10-07 | Unknown | Alaska | 500 | 0 | |
1789391 | 1789391 | 2021-10-06 | Eddy | North Dakota | 38027 | 500 | 6 |
1782886 | 1782886 | 2021-10-04 | Bowman | North Dakota | 38011 | 500 | 7 |
1783358 | 1783358 | 2021-10-04 | Douglas | South Dakota | 46043 | 500 | 9 |
1780109 | 1780109 | 2021-10-03 | Douglas | South Dakota | 46043 | 500 | 9 |
1776859 | 1776859 | 2021-10-02 | Douglas | South Dakota | 46043 | 500 | 9 |
1773609 | 1773609 | 2021-10-01 | Douglas | South Dakota | 46043 | 500 | 9 |
1759905 | 1759905 | 2021-09-27 | Mineral | Nevada | 32021 | 500 | 11 |
1760910 | 1760910 | 2021-09-27 | Mason | Texas | 48319 | 500 | 7 |
1756657 | 1756657 | 2021-09-26 | Mineral | Nevada | 32021 | 500 | 11 |
1757662 | 1757662 | 2021-09-26 | Mason | Texas | 48319 | 500 | 7 |
1753409 | 1753409 | 2021-09-25 | Mineral | Nevada | 32021 | 500 | 11 |
1750161 | 1750161 | 2021-09-24 | Mineral | Nevada | 32021 | 500 | 11 |
1746686 | 1746686 | 2021-09-23 | Knox | Missouri | 29103 | 500 | 3 |
1746911 | 1746911 | 2021-09-23 | Mineral | Nevada | 32021 | 500 | 11 |
1748166 | 1748166 | 2021-09-23 | Rappahannock | Virginia | 51157 | 500 | 4 |
1743662 | 1743662 | 2021-09-22 | Mineral | Nevada | 32021 | 500 | 11 |
1740413 | 1740413 | 2021-09-21 | Mineral | Nevada | 32021 | 500 | 11 |
1737164 | 1737164 | 2021-09-20 | Mineral | Nevada | 32021 | 500 | 11 |
1724852 | 1724852 | 2021-09-16 | Aurora | South Dakota | 46003 | 500 | 15 |
1725205 | 1725205 | 2021-09-16 | Reagan | Texas | 48383 | 500 | 9 |
1721956 | 1721956 | 2021-09-15 | Reagan | Texas | 48383 | 500 | 9 |
1722106 | 1722106 | 2021-09-15 | Falls Church city | Virginia | 51610 | 500 | 8 |
1716946 | 1716946 | 2021-09-14 | Hickman | Kentucky | 21105 | 500 | 16 |
1718046 | 1718046 | 2021-09-14 | Beaver | Oklahoma | 40007 | 500 | 6 |
1713700 | 1713700 | 2021-09-13 | Hickman | Kentucky | 21105 | 500 | 16 |
1714798 | 1714798 | 2021-09-13 | Beaver | Oklahoma | 40007 | 500 | 6 |
1711552 | 1711552 | 2021-09-12 | Beaver | Oklahoma | 40007 | 500 | 6 |
1708305 | 1708305 | 2021-09-11 | Beaver | Oklahoma | 40007 | 500 | 6 |
1704924 | 1704924 | 2021-09-10 | Emmons | North Dakota | 38029 | 500 | 14 |
1705058 | 1705058 | 2021-09-10 | Beaver | Oklahoma | 40007 | 500 | 6 |
1701808 | 1701808 | 2021-09-09 | Beaver | Oklahoma | 40007 | 500 | 6 |
1698559 | 1698559 | 2021-09-08 | Beaver | Oklahoma | 40007 | 500 | 6 |
1690181 | 1690181 | 2021-09-06 | Huerfano | Colorado | 8055 | 500 | 17 |
1692978 | 1692978 | 2021-09-06 | Ferry | Washington | 53019 | 500 | 9 |
1689729 | 1689729 | 2021-09-05 | Ferry | Washington | 53019 | 500 | 9 |
1686479 | 1686479 | 2021-09-04 | Ferry | Washington | 53019 | 500 | 9 |
1683228 | 1683228 | 2021-09-03 | Ferry | Washington | 53019 | 500 | 9 |
1656001 | 1656001 | 2021-08-26 | Hidalgo | New Mexico | 35023 | 500 | 10 |
1650567 | 1650567 | 2021-08-24 | Garfield | Utah | 49017 | 500 | 10 |
1643521 | 1643521 | 2021-08-22 | Arroyo | Puerto Rico | 72015 | 500 | |
1632740 | 1632740 | 2021-08-19 | Ontonagon | Michigan | 26131 | 500 | 22 |
1629493 | 1629493 | 2021-08-18 | Ontonagon | Michigan | 26131 | 500 | 22 |
1629546 | 1629546 | 2021-08-18 | Kittson | Minnesota | 27069 | 500 | 22 |
1619123 | 1619123 | 2021-08-15 | Putnam | Illinois | 17155 | 500 | 4 |
1615875 | 1615875 | 2021-08-14 | Putnam | Illinois | 17155 | 500 | 4 |
1612626 | 1612626 | 2021-08-13 | Putnam | Illinois | 17155 | 500 | 4 |
1614613 | 1614613 | 2021-08-13 | Coke | Texas | 48081 | 500 | 13 |
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);