ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
805 rows where cases = 292 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 73
- Texas 72
- Virginia 43
- Georgia 40
- Alaska 28
- Colorado 28
- Puerto Rico 28
- South Dakota 27
- Montana 25
- Iowa 24
- Mississippi 22
- Ohio 22
- Indiana 21
- Kentucky 21
- North Dakota 21
- Alabama 18
- Michigan 18
- Minnesota 18
- North Carolina 18
- Illinois 17
- California 16
- Missouri 16
- New York 15
- Nebraska 14
- West Virginia 14
- Arkansas 13
- Wisconsin 12
- Louisiana 10
- Idaho 9
- Oklahoma 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2286809 | 2286809 | 2022-03-08 | Sheridan | North Dakota | 38083 | 292 | 7 |
2176454 | 2176454 | 2022-02-02 | Sherman | Oregon | 41055 | 292 | 3 |
2166205 | 2166205 | 2022-01-30 | Eureka | Nevada | 32011 | 292 | 1 |
2162950 | 2162950 | 2022-01-29 | Eureka | Nevada | 32011 | 292 | 1 |
2159695 | 2159695 | 2022-01-28 | Eureka | Nevada | 32011 | 292 | 1 |
2130421 | 2130421 | 2022-01-19 | Storey | Nevada | 32029 | 292 | 9 |
2127040 | 2127040 | 2022-01-18 | Powder River | Montana | 30075 | 292 | 10 |
2123788 | 2123788 | 2022-01-17 | Powder River | Montana | 30075 | 292 | 10 |
2120536 | 2120536 | 2022-01-16 | Powder River | Montana | 30075 | 292 | 10 |
2117284 | 2117284 | 2022-01-15 | Powder River | Montana | 30075 | 292 | 10 |
2114033 | 2114033 | 2022-01-14 | Powder River | Montana | 30075 | 292 | 10 |
2110781 | 2110781 | 2022-01-13 | Powder River | Montana | 30075 | 292 | 10 |
2107530 | 2107530 | 2022-01-12 | Powder River | Montana | 30075 | 292 | 10 |
2096387 | 2096387 | 2022-01-09 | Dolores | Colorado | 8033 | 292 | 6 |
2098813 | 2098813 | 2022-01-09 | Dickens | Texas | 48125 | 292 | 15 |
2093135 | 2093135 | 2022-01-08 | Dolores | Colorado | 8033 | 292 | 6 |
2089883 | 2089883 | 2022-01-07 | Dolores | Colorado | 8033 | 292 | 6 |
2083380 | 2083380 | 2022-01-05 | Dolores | Colorado | 8033 | 292 | 6 |
2068923 | 2068923 | 2021-12-31 | Unknown | Northern Mariana Islands | 292 | 2 | |
2050684 | 2050684 | 2021-12-26 | Denali Borough | Alaska | 2068 | 292 | 1 |
2047434 | 2047434 | 2021-12-25 | Denali Borough | Alaska | 2068 | 292 | 1 |
2044184 | 2044184 | 2021-12-24 | Denali Borough | Alaska | 2068 | 292 | 1 |
2040935 | 2040935 | 2021-12-23 | Denali Borough | Alaska | 2068 | 292 | 1 |
2037685 | 2037685 | 2021-12-22 | Denali Borough | Alaska | 2068 | 292 | 1 |
2034435 | 2034435 | 2021-12-21 | Denali Borough | Alaska | 2068 | 292 | 1 |
2031185 | 2031185 | 2021-12-20 | Denali Borough | Alaska | 2068 | 292 | 1 |
2027934 | 2027934 | 2021-12-19 | Denali Borough | Alaska | 2068 | 292 | 1 |
2024683 | 2024683 | 2021-12-18 | Denali Borough | Alaska | 2068 | 292 | 1 |
2021432 | 2021432 | 2021-12-17 | Denali Borough | Alaska | 2068 | 292 | 1 |
2014017 | 2014017 | 2021-12-14 | Vieques | Puerto Rico | 72147 | 292 | |
2010766 | 2010766 | 2021-12-13 | Vieques | Puerto Rico | 72147 | 292 | |
2007515 | 2007515 | 2021-12-12 | Vieques | Puerto Rico | 72147 | 292 | |
2004264 | 2004264 | 2021-12-11 | Vieques | Puerto Rico | 72147 | 292 | |
2001013 | 2001013 | 2021-12-10 | Vieques | Puerto Rico | 72147 | 292 | |
1938187 | 1938187 | 2021-11-21 | Cook | Minnesota | 27031 | 292 | 0 |
1934937 | 1934937 | 2021-11-20 | Cook | Minnesota | 27031 | 292 | 0 |
1931687 | 1931687 | 2021-11-19 | Cook | Minnesota | 27031 | 292 | 0 |
1928436 | 1928436 | 2021-11-18 | Cook | Minnesota | 27031 | 292 | 0 |
1925486 | 1925486 | 2021-11-17 | McCone | Montana | 30055 | 292 | 3 |
1922237 | 1922237 | 2021-11-16 | McCone | Montana | 30055 | 292 | 3 |
1918968 | 1918968 | 2021-11-15 | Daniels | Montana | 30019 | 292 | 9 |
1915718 | 1915718 | 2021-11-14 | Daniels | Montana | 30019 | 292 | 9 |
1912468 | 1912468 | 2021-11-13 | Daniels | Montana | 30019 | 292 | 9 |
1909218 | 1909218 | 2021-11-12 | Daniels | Montana | 30019 | 292 | 9 |
1903727 | 1903727 | 2021-11-10 | Armstrong | Texas | 48011 | 292 | 7 |
1900477 | 1900477 | 2021-11-09 | Armstrong | Texas | 48011 | 292 | 7 |
1897227 | 1897227 | 2021-11-08 | Armstrong | Texas | 48011 | 292 | 7 |
1893977 | 1893977 | 2021-11-07 | Armstrong | Texas | 48011 | 292 | 7 |
1890727 | 1890727 | 2021-11-06 | Armstrong | Texas | 48011 | 292 | 7 |
1887477 | 1887477 | 2021-11-05 | Armstrong | Texas | 48011 | 292 | 7 |
1812129 | 1812129 | 2021-10-13 | Burke | North Dakota | 38013 | 292 | 3 |
1780124 | 1780124 | 2021-10-03 | Jerauld | South Dakota | 46073 | 292 | 17 |
1776874 | 1776874 | 2021-10-02 | Jerauld | South Dakota | 46073 | 292 | 17 |
1773624 | 1773624 | 2021-10-01 | Jerauld | South Dakota | 46073 | 292 | 17 |
1769709 | 1769709 | 2021-09-30 | Mora | New Mexico | 35033 | 292 | 10 |
1767714 | 1767714 | 2021-09-29 | San Juan | Washington | 53055 | 292 | 0 |
1763887 | 1763887 | 2021-09-28 | Mellette | South Dakota | 46095 | 292 | 2 |
1757388 | 1757388 | 2021-09-26 | McPherson | South Dakota | 46089 | 292 | 5 |
1754140 | 1754140 | 2021-09-25 | McPherson | South Dakota | 46089 | 292 | 5 |
1750892 | 1750892 | 2021-09-24 | McPherson | South Dakota | 46089 | 292 | 5 |
1746769 | 1746769 | 2021-09-23 | Granite | Montana | 30039 | 292 | 2 |
1746887 | 1746887 | 2021-09-23 | Sherman | Nebraska | 31163 | 292 | 4 |
1735053 | 1735053 | 2021-09-19 | Grand Isle | Vermont | 50013 | 292 | 2 |
1709975 | 1709975 | 2021-09-12 | Custer | Idaho | 16037 | 292 | 3 |
1699098 | 1699098 | 2021-09-08 | Edwards | Texas | 48137 | 292 | 6 |
1694118 | 1694118 | 2021-09-07 | Morton | Kansas | 20129 | 292 | 9 |
1690869 | 1690869 | 2021-09-06 | Morton | Kansas | 20129 | 292 | 9 |
1687619 | 1687619 | 2021-09-05 | Morton | Kansas | 20129 | 292 | 9 |
1684369 | 1684369 | 2021-09-04 | Morton | Kansas | 20129 | 292 | 9 |
1681118 | 1681118 | 2021-09-03 | Morton | Kansas | 20129 | 292 | 9 |
1678931 | 1678931 | 2021-09-02 | Golden Valley | North Dakota | 38033 | 292 | 4 |
1679398 | 1679398 | 2021-09-02 | Haakon | South Dakota | 46055 | 292 | 11 |
1674082 | 1674082 | 2021-09-01 | Clay | Georgia | 13061 | 292 | 3 |
1676150 | 1676150 | 2021-09-01 | Haakon | South Dakota | 46055 | 292 | 11 |
1671401 | 1671401 | 2021-08-31 | Smith | Kansas | 20183 | 292 | 3 |
1668154 | 1668154 | 2021-08-30 | Smith | Kansas | 20183 | 292 | 3 |
1664835 | 1664835 | 2021-08-29 | Decatur | Kansas | 20039 | 292 | 12 |
1664907 | 1664907 | 2021-08-29 | Smith | Kansas | 20183 | 292 | 3 |
1661587 | 1661587 | 2021-08-28 | Decatur | Kansas | 20039 | 292 | 12 |
1661659 | 1661659 | 2021-08-28 | Smith | Kansas | 20183 | 292 | 3 |
1658339 | 1658339 | 2021-08-27 | Decatur | Kansas | 20039 | 292 | 12 |
1658411 | 1658411 | 2021-08-27 | Smith | Kansas | 20183 | 292 | 3 |
1660254 | 1660254 | 2021-08-27 | Schleicher | Texas | 48413 | 292 | 7 |
1576478 | 1576478 | 2021-08-02 | Gilpin | Colorado | 8047 | 292 | 3 |
1562773 | 1562773 | 2021-07-28 | Oldham | Texas | 48359 | 292 | 4 |
1559525 | 1559525 | 2021-07-27 | Oldham | Texas | 48359 | 292 | 4 |
1551133 | 1551133 | 2021-07-25 | Chautauqua | Kansas | 20019 | 292 | 6 |
1547886 | 1547886 | 2021-07-24 | Chautauqua | Kansas | 20019 | 292 | 6 |
1544639 | 1544639 | 2021-07-23 | Chautauqua | Kansas | 20019 | 292 | 6 |
1501289 | 1501289 | 2021-07-09 | Norton city | Virginia | 51720 | 292 | 7 |
1498043 | 1498043 | 2021-07-08 | Norton city | Virginia | 51720 | 292 | 7 |
1494796 | 1494796 | 2021-07-07 | Norton city | Virginia | 51720 | 292 | 7 |
1491549 | 1491549 | 2021-07-06 | Norton city | Virginia | 51720 | 292 | 7 |
1488302 | 1488302 | 2021-07-05 | Norton city | Virginia | 51720 | 292 | 7 |
1465904 | 1465904 | 2021-06-29 | Unknown | Alaska | 292 | 0 | |
1462659 | 1462659 | 2021-06-28 | Unknown | Alaska | 292 | 0 | |
1459414 | 1459414 | 2021-06-27 | Unknown | Alaska | 292 | 0 | |
1460289 | 1460289 | 2021-06-27 | Osborne | Kansas | 20141 | 292 | 12 |
1456169 | 1456169 | 2021-06-26 | Unknown | Alaska | 292 | 0 | |
1457044 | 1457044 | 2021-06-26 | Osborne | Kansas | 20141 | 292 | 12 |
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);