ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
882 rows where cases = 270 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 100
- Texas 91
- North Dakota 80
- Virginia 43
- Nebraska 40
- Georgia 36
- Kentucky 29
- Puerto Rico 27
- Indiana 25
- Illinois 24
- Colorado 23
- Iowa 21
- Missouri 21
- New York 21
- Arkansas 19
- Mississippi 19
- South Dakota 19
- Michigan 17
- Minnesota 17
- North Carolina 16
- West Virginia 15
- Montana 14
- Oklahoma 14
- Ohio 12
- South Carolina 12
- Alabama 11
- Louisiana 11
- Oregon 10
- Wisconsin 10
- Florida 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489399 | 2489399 | 2022-05-09 | Throckmorton | Texas | 48447 | 270 | 8 |
2486141 | 2486141 | 2022-05-08 | Throckmorton | Texas | 48447 | 270 | 8 |
2482883 | 2482883 | 2022-05-07 | Throckmorton | Texas | 48447 | 270 | 8 |
2479625 | 2479625 | 2022-05-06 | Throckmorton | Texas | 48447 | 270 | 8 |
2476367 | 2476367 | 2022-05-05 | Throckmorton | Texas | 48447 | 270 | 8 |
2473110 | 2473110 | 2022-05-04 | Throckmorton | Texas | 48447 | 270 | 8 |
2469854 | 2469854 | 2022-05-03 | Throckmorton | Texas | 48447 | 270 | 8 |
2466598 | 2466598 | 2022-05-02 | Throckmorton | Texas | 48447 | 270 | 8 |
2463343 | 2463343 | 2022-05-01 | Throckmorton | Texas | 48447 | 270 | 8 |
2460087 | 2460087 | 2022-04-30 | Throckmorton | Texas | 48447 | 270 | 8 |
2456831 | 2456831 | 2022-04-29 | Throckmorton | Texas | 48447 | 270 | 8 |
2287561 | 2287561 | 2022-03-08 | Motley | Texas | 48345 | 270 | 12 |
2284309 | 2284309 | 2022-03-07 | Motley | Texas | 48345 | 270 | 12 |
2281057 | 2281057 | 2022-03-06 | Motley | Texas | 48345 | 270 | 12 |
2277804 | 2277804 | 2022-03-05 | Motley | Texas | 48345 | 270 | 12 |
2274551 | 2274551 | 2022-03-04 | Motley | Texas | 48345 | 270 | 12 |
2271298 | 2271298 | 2022-03-03 | Motley | Texas | 48345 | 270 | 12 |
2268046 | 2268046 | 2022-03-02 | Motley | Texas | 48345 | 270 | 12 |
2264793 | 2264793 | 2022-03-01 | Motley | Texas | 48345 | 270 | 12 |
2261543 | 2261543 | 2022-02-28 | Motley | Texas | 48345 | 270 | 12 |
2258292 | 2258292 | 2022-02-27 | Motley | Texas | 48345 | 270 | 12 |
2255041 | 2255041 | 2022-02-26 | Motley | Texas | 48345 | 270 | 12 |
2251790 | 2251790 | 2022-02-25 | Motley | Texas | 48345 | 270 | 12 |
2248539 | 2248539 | 2022-02-24 | Motley | Texas | 48345 | 270 | 12 |
2245288 | 2245288 | 2022-02-23 | Motley | Texas | 48345 | 270 | 12 |
2215471 | 2215471 | 2022-02-14 | Gilliam | Oregon | 41021 | 270 | 4 |
2212220 | 2212220 | 2022-02-13 | Gilliam | Oregon | 41021 | 270 | 4 |
2208967 | 2208967 | 2022-02-12 | Gilliam | Oregon | 41021 | 270 | 4 |
2205714 | 2205714 | 2022-02-11 | Gilliam | Oregon | 41021 | 270 | 4 |
2160603 | 2160603 | 2022-01-28 | Cottle | Texas | 48101 | 270 | 9 |
2147171 | 2147171 | 2022-01-24 | Sherman | Oregon | 41055 | 270 | 3 |
2107916 | 2107916 | 2022-01-12 | Oliver | North Dakota | 38065 | 270 | 4 |
2108866 | 2108866 | 2022-01-12 | Highland | Virginia | 51091 | 270 | 4 |
2105615 | 2105615 | 2022-01-11 | Highland | Virginia | 51091 | 270 | 4 |
2081571 | 2081571 | 2022-01-04 | Garden | Nebraska | 31069 | 270 | 1 |
2017931 | 2017931 | 2021-12-15 | Garfield | Washington | 53023 | 270 | 7 |
2012546 | 2012546 | 2021-12-14 | Hodgeman | Kansas | 20083 | 270 | 10 |
2014681 | 2014681 | 2021-12-14 | Garfield | Washington | 53023 | 270 | 7 |
2009295 | 2009295 | 2021-12-13 | Hodgeman | Kansas | 20083 | 270 | 10 |
2006044 | 2006044 | 2021-12-12 | Hodgeman | Kansas | 20083 | 270 | 10 |
2006805 | 2006805 | 2021-12-12 | Dundy | Nebraska | 31057 | 270 | 5 |
2002793 | 2002793 | 2021-12-11 | Hodgeman | Kansas | 20083 | 270 | 10 |
2003554 | 2003554 | 2021-12-11 | Dundy | Nebraska | 31057 | 270 | 5 |
1999543 | 1999543 | 2021-12-10 | Hodgeman | Kansas | 20083 | 270 | 10 |
2000304 | 2000304 | 2021-12-10 | Dundy | Nebraska | 31057 | 270 | 5 |
1997053 | 1997053 | 2021-12-09 | Dundy | Nebraska | 31057 | 270 | 5 |
1993802 | 1993802 | 2021-12-08 | Dundy | Nebraska | 31057 | 270 | 5 |
1990551 | 1990551 | 2021-12-07 | Dundy | Nebraska | 31057 | 270 | 5 |
1985878 | 1985878 | 2021-12-06 | Kiowa | Colorado | 8061 | 270 | 4 |
1951491 | 1951491 | 2021-11-25 | Meagher | Montana | 30059 | 270 | 9 |
1948240 | 1948240 | 2021-11-24 | Meagher | Montana | 30059 | 270 | 9 |
1927186 | 1927186 | 2021-11-18 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 270 | 3 |
1928799 | 1928799 | 2021-11-18 | Garfield | Nebraska | 31071 | 270 | 2 |
1925549 | 1925549 | 2021-11-17 | Garfield | Nebraska | 31071 | 270 | 2 |
1925894 | 1925894 | 2021-11-17 | Steele | North Dakota | 38091 | 270 | 2 |
1922300 | 1922300 | 2021-11-16 | Garfield | Nebraska | 31071 | 270 | 2 |
1922645 | 1922645 | 2021-11-16 | Steele | North Dakota | 38091 | 270 | 2 |
1917887 | 1917887 | 2021-11-15 | Webster | Georgia | 13307 | 270 | 6 |
1919050 | 1919050 | 2021-11-15 | Garfield | Nebraska | 31071 | 270 | 2 |
1915800 | 1915800 | 2021-11-14 | Garfield | Nebraska | 31071 | 270 | 2 |
1912550 | 1912550 | 2021-11-13 | Garfield | Nebraska | 31071 | 270 | 2 |
1909300 | 1909300 | 2021-11-12 | Garfield | Nebraska | 31071 | 270 | 2 |
1905342 | 1905342 | 2021-11-11 | Wallace | Kansas | 20199 | 270 | 4 |
1905688 | 1905688 | 2021-11-11 | Cook | Minnesota | 27031 | 270 | 0 |
1902092 | 1902092 | 2021-11-10 | Wallace | Kansas | 20199 | 270 | 4 |
1881669 | 1881669 | 2021-11-04 | Denali Borough | Alaska | 2068 | 270 | 1 |
1882882 | 1882882 | 2021-11-04 | Keweenaw | Michigan | 26083 | 270 | 5 |
1879633 | 1879633 | 2021-11-03 | Keweenaw | Michigan | 26083 | 270 | 5 |
1867369 | 1867369 | 2021-10-30 | Divide | North Dakota | 38023 | 270 | 3 |
1864510 | 1864510 | 2021-10-29 | Vieques | Puerto Rico | 72147 | 270 | |
1857248 | 1857248 | 2021-10-27 | McCone | Montana | 30055 | 270 | 3 |
1853999 | 1853999 | 2021-10-26 | McCone | Montana | 30055 | 270 | 3 |
1834511 | 1834511 | 2021-10-20 | Powder River | Montana | 30075 | 270 | 9 |
1834571 | 1834571 | 2021-10-20 | Harlan | Nebraska | 31083 | 270 | 0 |
1830544 | 1830544 | 2021-10-19 | Hamilton | Kansas | 20075 | 270 | 1 |
1831262 | 1831262 | 2021-10-19 | Powder River | Montana | 30075 | 270 | 9 |
1831322 | 1831322 | 2021-10-19 | Harlan | Nebraska | 31083 | 270 | 0 |
1827295 | 1827295 | 2021-10-18 | Hamilton | Kansas | 20075 | 270 | 1 |
1828073 | 1828073 | 2021-10-18 | Harlan | Nebraska | 31083 | 270 | 0 |
1824110 | 1824110 | 2021-10-17 | Wichita | Kansas | 20203 | 270 | 6 |
1820861 | 1820861 | 2021-10-16 | Wichita | Kansas | 20203 | 270 | 6 |
1817612 | 1817612 | 2021-10-15 | Wichita | Kansas | 20203 | 270 | 6 |
1814356 | 1814356 | 2021-10-14 | Stanton | Kansas | 20187 | 270 | 6 |
1811107 | 1811107 | 2021-10-13 | Stanton | Kansas | 20187 | 270 | 6 |
1807858 | 1807858 | 2021-10-12 | Stanton | Kansas | 20187 | 270 | 6 |
1804607 | 1804607 | 2021-10-11 | Stanton | Kansas | 20187 | 270 | 6 |
1801289 | 1801289 | 2021-10-10 | Elk | Kansas | 20049 | 270 | 6 |
1798040 | 1798040 | 2021-10-09 | Elk | Kansas | 20049 | 270 | 6 |
1794791 | 1794791 | 2021-10-08 | Elk | Kansas | 20049 | 270 | 6 |
1793251 | 1793251 | 2021-10-07 | Armstrong | Texas | 48011 | 270 | 7 |
1732441 | 1732441 | 2021-09-19 | Sedgwick | Colorado | 8115 | 270 | 4 |
1729191 | 1729191 | 2021-09-18 | Sedgwick | Colorado | 8115 | 270 | 4 |
1725941 | 1725941 | 2021-09-17 | Sedgwick | Colorado | 8115 | 270 | 4 |
1717526 | 1717526 | 2021-09-14 | Granite | Montana | 30039 | 270 | 2 |
1686325 | 1686325 | 2021-09-04 | Grand Isle | Vermont | 50013 | 270 | 2 |
1678011 | 1678011 | 2021-09-02 | Robertson | Kentucky | 21201 | 270 | 14 |
1679744 | 1679744 | 2021-09-02 | Sherman | Texas | 48421 | 270 | 12 |
1673919 | 1673919 | 2021-09-01 | Costilla | Colorado | 8023 | 270 | 6 |
1676496 | 1676496 | 2021-09-01 | Sherman | Texas | 48421 | 270 | 12 |
1672923 | 1672923 | 2021-08-31 | Mellette | South Dakota | 46095 | 270 | 2 |
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);