ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where cases = 419 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 78
- Kansas 68
- Texas 62
- Georgia 39
- Virginia 34
- South Dakota 27
- Kentucky 24
- North Dakota 24
- Oklahoma 24
- Puerto Rico 24
- Iowa 18
- Mississippi 18
- Missouri 18
- Louisiana 15
- Michigan 15
- New Mexico 15
- Minnesota 14
- Colorado 13
- Pennsylvania 13
- West Virginia 13
- Illinois 12
- Oregon 12
- California 11
- Ohio 11
- Wisconsin 10
- Idaho 9
- Indiana 9
- North Carolina 9
- Tennessee 9
- Nevada 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393935 | 2393935 | 2022-04-10 | Catron | New Mexico | 35003 | 419 | 13 |
2390679 | 2390679 | 2022-04-09 | Catron | New Mexico | 35003 | 419 | 13 |
2387423 | 2387423 | 2022-04-08 | Catron | New Mexico | 35003 | 419 | 13 |
2384168 | 2384168 | 2022-04-07 | Catron | New Mexico | 35003 | 419 | 13 |
2380913 | 2380913 | 2022-04-06 | Catron | New Mexico | 35003 | 419 | 13 |
2377658 | 2377658 | 2022-04-05 | Catron | New Mexico | 35003 | 419 | 13 |
2374405 | 2374405 | 2022-04-04 | Catron | New Mexico | 35003 | 419 | 13 |
2312479 | 2312479 | 2022-03-16 | Franklin | Nebraska | 31061 | 419 | 10 |
2309226 | 2309226 | 2022-03-15 | Franklin | Nebraska | 31061 | 419 | 10 |
2305974 | 2305974 | 2022-03-14 | Franklin | Nebraska | 31061 | 419 | 10 |
2302723 | 2302723 | 2022-03-13 | Franklin | Nebraska | 31061 | 419 | 10 |
2299471 | 2299471 | 2022-03-12 | Franklin | Nebraska | 31061 | 419 | 10 |
2296219 | 2296219 | 2022-03-11 | Franklin | Nebraska | 31061 | 419 | 10 |
2292967 | 2292967 | 2022-03-10 | Franklin | Nebraska | 31061 | 419 | 10 |
2289715 | 2289715 | 2022-03-09 | Franklin | Nebraska | 31061 | 419 | 10 |
2286463 | 2286463 | 2022-03-08 | Franklin | Nebraska | 31061 | 419 | 10 |
2283211 | 2283211 | 2022-03-07 | Franklin | Nebraska | 31061 | 419 | 10 |
2279958 | 2279958 | 2022-03-06 | Franklin | Nebraska | 31061 | 419 | 10 |
2276705 | 2276705 | 2022-03-05 | Franklin | Nebraska | 31061 | 419 | 10 |
2273452 | 2273452 | 2022-03-04 | Franklin | Nebraska | 31061 | 419 | 10 |
2270200 | 2270200 | 2022-03-03 | Franklin | Nebraska | 31061 | 419 | 10 |
2266947 | 2266947 | 2022-03-02 | Franklin | Nebraska | 31061 | 419 | 10 |
2263696 | 2263696 | 2022-03-01 | Franklin | Nebraska | 31061 | 419 | 10 |
2215739 | 2215739 | 2022-02-14 | McPherson | South Dakota | 46089 | 419 | 9 |
2186695 | 2186695 | 2022-02-05 | Irion | Texas | 48235 | 419 | 3 |
2183443 | 2183443 | 2022-02-04 | Irion | Texas | 48235 | 419 | 3 |
2169702 | 2169702 | 2022-01-31 | Burke | North Dakota | 38013 | 419 | 3 |
2164527 | 2164527 | 2022-01-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 419 | 5 |
2166447 | 2166447 | 2022-01-30 | Burke | North Dakota | 38013 | 419 | 3 |
2161272 | 2161272 | 2022-01-29 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 419 | 5 |
2158016 | 2158016 | 2022-01-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 419 | 5 |
2156682 | 2156682 | 2022-01-27 | Burke | North Dakota | 38013 | 419 | 3 |
2142571 | 2142571 | 2022-01-23 | Comanche | Kansas | 20033 | 419 | 13 |
2139316 | 2139316 | 2022-01-22 | Comanche | Kansas | 20033 | 419 | 13 |
2136060 | 2136060 | 2022-01-21 | Comanche | Kansas | 20033 | 419 | 13 |
2137170 | 2137170 | 2022-01-21 | Golden Valley | North Dakota | 38033 | 419 | 4 |
2126673 | 2126673 | 2022-01-18 | Keweenaw | Michigan | 26083 | 419 | 11 |
2123421 | 2123421 | 2022-01-17 | Keweenaw | Michigan | 26083 | 419 | 11 |
2120169 | 2120169 | 2022-01-16 | Keweenaw | Michigan | 26083 | 419 | 11 |
2116917 | 2116917 | 2022-01-15 | Keweenaw | Michigan | 26083 | 419 | 11 |
2113666 | 2113666 | 2022-01-14 | Keweenaw | Michigan | 26083 | 419 | 11 |
2107902 | 2107902 | 2022-01-12 | Grant | North Dakota | 38037 | 419 | 11 |
2099770 | 2099770 | 2022-01-10 | Baker | Georgia | 13007 | 419 | 14 |
2084939 | 2084939 | 2022-01-05 | De Baca | New Mexico | 35011 | 419 | 3 |
2080442 | 2080442 | 2022-01-04 | Custer | Idaho | 16037 | 419 | 7 |
2062098 | 2062098 | 2021-12-29 | Perkins | Nebraska | 31135 | 419 | 12 |
2058849 | 2058849 | 2021-12-28 | Perkins | Nebraska | 31135 | 419 | 12 |
2010095 | 2010095 | 2021-12-13 | Perkins | Nebraska | 31135 | 419 | 12 |
1997874 | 1997874 | 2021-12-09 | Sanborn | South Dakota | 46111 | 419 | 3 |
1994623 | 1994623 | 2021-12-08 | Sanborn | South Dakota | 46111 | 419 | 3 |
1967817 | 1967817 | 2021-11-30 | Hitchcock | Nebraska | 31087 | 419 | 5 |
1968601 | 1968601 | 2021-11-30 | Jackson | South Dakota | 46071 | 419 | 18 |
1965350 | 1965350 | 2021-11-29 | Jackson | South Dakota | 46071 | 419 | 18 |
1962098 | 1962098 | 2021-11-28 | Jackson | South Dakota | 46071 | 419 | 18 |
1958847 | 1958847 | 2021-11-27 | Jackson | South Dakota | 46071 | 419 | 18 |
1955596 | 1955596 | 2021-11-26 | Jackson | South Dakota | 46071 | 419 | 18 |
1951872 | 1951872 | 2021-11-25 | Griggs | North Dakota | 38039 | 419 | 2 |
1952345 | 1952345 | 2021-11-25 | Jackson | South Dakota | 46071 | 419 | 18 |
1949094 | 1949094 | 2021-11-24 | Jackson | South Dakota | 46071 | 419 | 18 |
1941780 | 1941780 | 2021-11-22 | Cherry | Nebraska | 31031 | 419 | 8 |
1938530 | 1938530 | 2021-11-21 | Cherry | Nebraska | 31031 | 419 | 8 |
1935280 | 1935280 | 2021-11-20 | Cherry | Nebraska | 31031 | 419 | 8 |
1932030 | 1932030 | 2021-11-19 | Cherry | Nebraska | 31031 | 419 | 8 |
1922600 | 1922600 | 2021-11-16 | Adams | North Dakota | 38001 | 419 | 5 |
1912887 | 1912887 | 2021-11-13 | Renville | North Dakota | 38075 | 419 | 14 |
1905307 | 1905307 | 2021-11-11 | Morton | Kansas | 20129 | 419 | 9 |
1902057 | 1902057 | 2021-11-10 | Morton | Kansas | 20129 | 419 | 9 |
1897297 | 1897297 | 2021-11-08 | Fisher | Texas | 48151 | 419 | 17 |
1894047 | 1894047 | 2021-11-07 | Fisher | Texas | 48151 | 419 | 17 |
1890797 | 1890797 | 2021-11-06 | Fisher | Texas | 48151 | 419 | 17 |
1886439 | 1886439 | 2021-11-05 | Scotland | Missouri | 29199 | 419 | 4 |
1887547 | 1887547 | 2021-11-05 | Fisher | Texas | 48151 | 419 | 17 |
1883190 | 1883190 | 2021-11-04 | Scotland | Missouri | 29199 | 419 | 4 |
1884297 | 1884297 | 2021-11-04 | Fisher | Texas | 48151 | 419 | 16 |
1881048 | 1881048 | 2021-11-03 | Fisher | Texas | 48151 | 419 | 16 |
1877614 | 1877614 | 2021-11-02 | Perkins | South Dakota | 46105 | 419 | 15 |
1829879 | 1829879 | 2021-10-19 | Gilpin | Colorado | 8047 | 419 | 3 |
1832130 | 1832130 | 2021-10-19 | Stanley | South Dakota | 46117 | 419 | 3 |
1809041 | 1809041 | 2021-10-12 | Ellis | Oklahoma | 40045 | 419 | 6 |
1805791 | 1805791 | 2021-10-11 | Ellis | Oklahoma | 40045 | 419 | 6 |
1802541 | 1802541 | 2021-10-10 | Ellis | Oklahoma | 40045 | 419 | 6 |
1799292 | 1799292 | 2021-10-09 | Ellis | Oklahoma | 40045 | 419 | 6 |
1796043 | 1796043 | 2021-10-08 | Ellis | Oklahoma | 40045 | 419 | 6 |
1791530 | 1791530 | 2021-10-07 | Cheyenne | Kansas | 20023 | 419 | 13 |
1792794 | 1792794 | 2021-10-07 | Ellis | Oklahoma | 40045 | 419 | 6 |
1793126 | 1793126 | 2021-10-07 | Marshall | South Dakota | 46091 | 419 | 6 |
1788281 | 1788281 | 2021-10-06 | Cheyenne | Kansas | 20023 | 419 | 13 |
1789545 | 1789545 | 2021-10-06 | Ellis | Oklahoma | 40045 | 419 | 6 |
1785032 | 1785032 | 2021-10-05 | Cheyenne | Kansas | 20023 | 419 | 13 |
1781783 | 1781783 | 2021-10-04 | Cheyenne | Kansas | 20023 | 419 | 13 |
1764136 | 1764136 | 2021-09-28 | Kimble | Texas | 48267 | 419 | 11 |
1760793 | 1760793 | 2021-09-27 | Cochran | Texas | 48079 | 419 | 16 |
1757545 | 1757545 | 2021-09-26 | Cochran | Texas | 48079 | 419 | 16 |
1754297 | 1754297 | 2021-09-25 | Cochran | Texas | 48079 | 419 | 16 |
1746501 | 1746501 | 2021-09-23 | Lake of the Woods | Minnesota | 27077 | 419 | 4 |
1724854 | 1724854 | 2021-09-16 | Bennett | South Dakota | 46007 | 419 | 9 |
1717297 | 1717297 | 2021-09-14 | Traverse | Minnesota | 27155 | 419 | 5 |
1710327 | 1710327 | 2021-09-12 | Gove | Kansas | 20063 | 419 | 21 |
1707080 | 1707080 | 2021-09-11 | Gove | Kansas | 20063 | 419 | 21 |
1703832 | 1703832 | 2021-09-10 | Gove | Kansas | 20063 | 419 | 21 |
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);