ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
626 rows where cases = 515 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 59
- South Dakota 56
- Kansas 35
- Georgia 29
- Illinois 27
- Michigan 24
- Minnesota 23
- Nebraska 23
- Mississippi 22
- Missouri 19
- Virginia 19
- Indiana 18
- Kentucky 18
- Iowa 15
- Arkansas 14
- Tennessee 14
- Alabama 13
- Idaho 13
- Montana 13
- South Carolina 13
- Louisiana 12
- Alaska 11
- North Carolina 11
- North Dakota 11
- Oklahoma 11
- Puerto Rico 11
- Colorado 10
- New York 10
- Ohio 9
- Pennsylvania 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500461 | 2500461 | 2022-05-13 | Unknown | Iowa | 515 | 1 | |
2501257 | 2501257 | 2022-05-13 | Brown | Nebraska | 31017 | 515 | 4 |
2497203 | 2497203 | 2022-05-12 | Unknown | Iowa | 515 | 1 | |
2468286 | 2468286 | 2022-05-03 | Keweenaw | Michigan | 26083 | 515 | 14 |
2465031 | 2465031 | 2022-05-02 | Keweenaw | Michigan | 26083 | 515 | 14 |
2461775 | 2461775 | 2022-05-01 | Keweenaw | Michigan | 26083 | 515 | 14 |
2458519 | 2458519 | 2022-04-30 | Keweenaw | Michigan | 26083 | 515 | 14 |
2455263 | 2455263 | 2022-04-29 | Keweenaw | Michigan | 26083 | 515 | 14 |
2452007 | 2452007 | 2022-04-28 | Keweenaw | Michigan | 26083 | 515 | 14 |
2448751 | 2448751 | 2022-04-27 | Keweenaw | Michigan | 26083 | 515 | 14 |
2398718 | 2398718 | 2022-04-12 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2395463 | 2395463 | 2022-04-11 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2392207 | 2392207 | 2022-04-10 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2388951 | 2388951 | 2022-04-09 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2385696 | 2385696 | 2022-04-08 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2382441 | 2382441 | 2022-04-07 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2379186 | 2379186 | 2022-04-06 | Wrangell City and Borough | Alaska | 2275 | 515 | 1 |
2290195 | 2290195 | 2022-03-09 | Harmon | Oklahoma | 40057 | 515 | 11 |
2286943 | 2286943 | 2022-03-08 | Harmon | Oklahoma | 40057 | 515 | 11 |
2283691 | 2283691 | 2022-03-07 | Harmon | Oklahoma | 40057 | 515 | 11 |
2280439 | 2280439 | 2022-03-06 | Harmon | Oklahoma | 40057 | 515 | 11 |
2277186 | 2277186 | 2022-03-05 | Harmon | Oklahoma | 40057 | 515 | 11 |
2273933 | 2273933 | 2022-03-04 | Harmon | Oklahoma | 40057 | 515 | 11 |
2270680 | 2270680 | 2022-03-03 | Harmon | Oklahoma | 40057 | 515 | 11 |
2267428 | 2267428 | 2022-03-02 | Harmon | Oklahoma | 40057 | 515 | 11 |
2265090 | 2265090 | 2022-03-01 | Wahkiakum | Washington | 53069 | 515 | 6 |
2261840 | 2261840 | 2022-02-28 | Wahkiakum | Washington | 53069 | 515 | 6 |
2222243 | 2222243 | 2022-02-16 | Mellette | South Dakota | 46095 | 515 | 6 |
2218992 | 2218992 | 2022-02-15 | Mellette | South Dakota | 46095 | 515 | 6 |
2190010 | 2190010 | 2022-02-06 | Oldham | Texas | 48359 | 515 | 6 |
2186757 | 2186757 | 2022-02-05 | Oldham | Texas | 48359 | 515 | 6 |
2183505 | 2183505 | 2022-02-04 | Oldham | Texas | 48359 | 515 | 6 |
2166924 | 2166924 | 2022-01-30 | Faulk | South Dakota | 46049 | 515 | 16 |
2163669 | 2163669 | 2022-01-29 | Faulk | South Dakota | 46049 | 515 | 16 |
2159968 | 2159968 | 2022-01-28 | Renville | North Dakota | 38075 | 515 | 15 |
2160414 | 2160414 | 2022-01-28 | Faulk | South Dakota | 46049 | 515 | 16 |
2131162 | 2131162 | 2022-01-19 | Sanborn | South Dakota | 46111 | 515 | 5 |
2128113 | 2128113 | 2022-01-18 | Hardeman | Texas | 48197 | 515 | 14 |
2085589 | 2085589 | 2022-01-05 | Buffalo | South Dakota | 46017 | 515 | 16 |
2035279 | 2035279 | 2021-12-21 | Decatur | Kansas | 20039 | 515 | 16 |
2032029 | 2032029 | 2021-12-20 | Decatur | Kansas | 20039 | 515 | 16 |
2030384 | 2030384 | 2021-12-19 | Stanley | South Dakota | 46117 | 515 | 3 |
2026175 | 2026175 | 2021-12-18 | Mercer | Missouri | 29129 | 515 | 9 |
2027133 | 2027133 | 2021-12-18 | Stanley | South Dakota | 46117 | 515 | 3 |
2023882 | 2023882 | 2021-12-17 | Stanley | South Dakota | 46117 | 515 | 3 |
2017375 | 2017375 | 2021-12-15 | Perkins | South Dakota | 46105 | 515 | 16 |
2013200 | 2013200 | 2021-12-14 | Schuyler | Missouri | 29197 | 515 | 22 |
1985893 | 1985893 | 2021-12-06 | Ouray | Colorado | 8091 | 515 | 6 |
1988068 | 1988068 | 2021-12-06 | Bennett | South Dakota | 46007 | 515 | 9 |
1982643 | 1982643 | 2021-12-05 | Ouray | Colorado | 8091 | 515 | 6 |
1979393 | 1979393 | 2021-12-04 | Ouray | Colorado | 8091 | 515 | 6 |
1976143 | 1976143 | 2021-12-03 | Ouray | Colorado | 8091 | 515 | 6 |
1972894 | 1972894 | 2021-12-02 | Ouray | Colorado | 8091 | 515 | 6 |
1971384 | 1971384 | 2021-12-01 | McIntosh | North Dakota | 38051 | 515 | 9 |
1938598 | 1938598 | 2021-11-21 | Stanton | Nebraska | 31167 | 515 | 11 |
1935348 | 1935348 | 2021-11-20 | Stanton | Nebraska | 31167 | 515 | 11 |
1932098 | 1932098 | 2021-11-19 | Stanton | Nebraska | 31167 | 515 | 11 |
1928459 | 1928459 | 2021-11-18 | Lake of the Woods | Minnesota | 27077 | 515 | 5 |
1884071 | 1884071 | 2021-11-04 | Clark | South Dakota | 46025 | 515 | 5 |
1880822 | 1880822 | 2021-11-03 | Clark | South Dakota | 46025 | 515 | 5 |
1876078 | 1876078 | 2021-11-02 | Rush | Kansas | 20165 | 515 | 16 |
1877582 | 1877582 | 2021-11-02 | Douglas | South Dakota | 46043 | 515 | 9 |
1872829 | 1872829 | 2021-11-01 | Rush | Kansas | 20165 | 515 | 16 |
1869580 | 1869580 | 2021-10-31 | Rush | Kansas | 20165 | 515 | 16 |
1866331 | 1866331 | 2021-10-30 | Rush | Kansas | 20165 | 515 | 16 |
1863082 | 1863082 | 2021-10-29 | Rush | Kansas | 20165 | 515 | 16 |
1845946 | 1845946 | 2021-10-24 | Unknown | Alaska | 515 | 1 | |
1842696 | 1842696 | 2021-10-23 | Unknown | Alaska | 515 | 1 | |
1839447 | 1839447 | 2021-10-22 | Unknown | Alaska | 515 | 1 | |
1836198 | 1836198 | 2021-10-21 | Unknown | Alaska | 515 | 1 | |
1828135 | 1828135 | 2021-10-18 | Lincoln | Nevada | 32017 | 515 | 5 |
1818633 | 1818633 | 2021-10-15 | Eddy | North Dakota | 38027 | 515 | 6 |
1805340 | 1805340 | 2021-10-11 | Kimball | Nebraska | 31105 | 515 | 9 |
1802091 | 1802091 | 2021-10-10 | Kimball | Nebraska | 31105 | 515 | 9 |
1798842 | 1798842 | 2021-10-09 | Kimball | Nebraska | 31105 | 515 | 9 |
1795593 | 1795593 | 2021-10-08 | Kimball | Nebraska | 31105 | 515 | 9 |
1777157 | 1777157 | 2021-10-02 | Mason | Texas | 48319 | 515 | 7 |
1768553 | 1768553 | 2021-09-30 | Pope | Illinois | 17151 | 515 | 5 |
1757344 | 1757344 | 2021-09-26 | Aurora | South Dakota | 46003 | 515 | 15 |
1754096 | 1754096 | 2021-09-25 | Aurora | South Dakota | 46003 | 515 | 15 |
1750848 | 1750848 | 2021-09-24 | Aurora | South Dakota | 46003 | 515 | 15 |
1741453 | 1741453 | 2021-09-21 | Reagan | Texas | 48383 | 515 | 9 |
1727656 | 1727656 | 2021-09-17 | Dunn | North Dakota | 38025 | 515 | 7 |
1727675 | 1727675 | 2021-09-17 | Nelson | North Dakota | 38063 | 515 | 16 |
1715329 | 1715329 | 2021-09-13 | Delta | Texas | 48119 | 515 | 16 |
1712083 | 1712083 | 2021-09-12 | Delta | Texas | 48119 | 515 | 16 |
1708836 | 1708836 | 2021-09-11 | Delta | Texas | 48119 | 515 | 16 |
1700972 | 1700972 | 2021-09-09 | Schoolcraft | Michigan | 26153 | 515 | 5 |
1697723 | 1697723 | 2021-09-08 | Schoolcraft | Michigan | 26153 | 515 | 5 |
1695877 | 1695877 | 2021-09-07 | Hall | Texas | 48191 | 515 | 15 |
1692629 | 1692629 | 2021-09-06 | Hall | Texas | 48191 | 515 | 15 |
1692796 | 1692796 | 2021-09-06 | Garfield | Utah | 49017 | 515 | 10 |
1689380 | 1689380 | 2021-09-05 | Hall | Texas | 48191 | 515 | 15 |
1689547 | 1689547 | 2021-09-05 | Garfield | Utah | 49017 | 515 | 10 |
1686130 | 1686130 | 2021-09-04 | Hall | Texas | 48191 | 515 | 15 |
1686297 | 1686297 | 2021-09-04 | Garfield | Utah | 49017 | 515 | 10 |
1683046 | 1683046 | 2021-09-03 | Garfield | Utah | 49017 | 515 | 10 |
1677422 | 1677422 | 2021-09-02 | Schley | Georgia | 13249 | 515 | 5 |
1679956 | 1679956 | 2021-09-02 | Surry | Virginia | 51181 | 515 | 9 |
1673565 | 1673565 | 2021-08-31 | Wirt | West Virginia | 54105 | 515 | 4 |
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);