ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
593 rows where cases = 496 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 59
- Nebraska 53
- Kansas 33
- Kentucky 27
- Georgia 25
- Mississippi 24
- Virginia 24
- Minnesota 21
- North Dakota 21
- Missouri 20
- Montana 19
- Puerto Rico 17
- Indiana 15
- North Carolina 14
- Louisiana 13
- South Dakota 13
- Illinois 12
- Iowa 12
- Alabama 11
- Colorado 11
- Idaho 11
- Michigan 10
- Oklahoma 9
- Tennessee 9
- Wyoming 8
- Alaska 7
- Arkansas 7
- Ohio 7
- Pennsylvania 7
- Virgin Islands 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370824 | 2370824 | 2022-04-03 | Unknown | Mississippi | 496 | 16 | |
2367571 | 2367571 | 2022-04-02 | Unknown | Mississippi | 496 | 16 | |
2364318 | 2364318 | 2022-04-01 | Unknown | Mississippi | 496 | 16 | |
2324700 | 2324700 | 2022-03-20 | Clark | Kansas | 20025 | 496 | 7 |
2321446 | 2321446 | 2022-03-19 | Clark | Kansas | 20025 | 496 | 7 |
2318192 | 2318192 | 2022-03-18 | Clark | Kansas | 20025 | 496 | 7 |
2316869 | 2316869 | 2022-03-17 | Sherman | Texas | 48421 | 496 | 16 |
2248372 | 2248372 | 2022-02-24 | Armstrong | Texas | 48011 | 496 | 8 |
2228261 | 2228261 | 2022-02-18 | Kidder | North Dakota | 38043 | 496 | 13 |
2221446 | 2221446 | 2022-02-16 | Hitchcock | Nebraska | 31087 | 496 | 6 |
2217766 | 2217766 | 2022-02-15 | Keweenaw | Michigan | 26083 | 496 | 12 |
2218195 | 2218195 | 2022-02-15 | Hitchcock | Nebraska | 31087 | 496 | 6 |
2214515 | 2214515 | 2022-02-14 | Keweenaw | Michigan | 26083 | 496 | 12 |
2211263 | 2211263 | 2022-02-13 | Keweenaw | Michigan | 26083 | 496 | 12 |
2208010 | 2208010 | 2022-02-12 | Keweenaw | Michigan | 26083 | 496 | 12 |
2204757 | 2204757 | 2022-02-11 | Keweenaw | Michigan | 26083 | 496 | 12 |
2171518 | 2171518 | 2022-02-01 | Custer | Idaho | 16037 | 496 | 7 |
2166136 | 2166136 | 2022-01-30 | Frontier | Nebraska | 31063 | 496 | 2 |
2167117 | 2167117 | 2022-01-30 | Culberson | Texas | 48109 | 496 | 13 |
2162881 | 2162881 | 2022-01-29 | Frontier | Nebraska | 31063 | 496 | 2 |
2159626 | 2159626 | 2022-01-28 | Frontier | Nebraska | 31063 | 496 | 2 |
2160307 | 2160307 | 2022-01-28 | Maricao | Puerto Rico | 72093 | 496 | |
2153155 | 2153155 | 2022-01-26 | Perkins | Nebraska | 31135 | 496 | 12 |
2149903 | 2149903 | 2022-01-25 | Perkins | Nebraska | 31135 | 496 | 12 |
2127451 | 2127451 | 2022-01-18 | Unknown | Northern Mariana Islands | 496 | 3 | |
2111649 | 2111649 | 2022-01-13 | Sanborn | South Dakota | 46111 | 496 | 5 |
2108637 | 2108637 | 2022-01-12 | Kimble | Texas | 48267 | 496 | 11 |
2081699 | 2081699 | 2022-01-04 | Mora | New Mexico | 35033 | 496 | 14 |
2076136 | 2076136 | 2022-01-02 | Lipscomb | Texas | 48295 | 496 | 12 |
2072885 | 2072885 | 2022-01-01 | Lipscomb | Texas | 48295 | 496 | 12 |
2069634 | 2069634 | 2021-12-31 | Lipscomb | Texas | 48295 | 496 | 12 |
2066383 | 2066383 | 2021-12-30 | Lipscomb | Texas | 48295 | 496 | 12 |
2051600 | 2051600 | 2021-12-26 | Smith | Kansas | 20183 | 496 | 3 |
2048350 | 2048350 | 2021-12-25 | Smith | Kansas | 20183 | 496 | 3 |
2045100 | 2045100 | 2021-12-24 | Smith | Kansas | 20183 | 496 | 3 |
2041851 | 2041851 | 2021-12-23 | Smith | Kansas | 20183 | 496 | 3 |
2038601 | 2038601 | 2021-12-22 | Smith | Kansas | 20183 | 496 | 3 |
2035956 | 2035956 | 2021-12-21 | Scotland | Missouri | 29199 | 496 | 16 |
2036724 | 2036724 | 2021-12-21 | Guanica | Puerto Rico | 72055 | 496 | |
2024277 | 2024277 | 2021-12-17 | Grand Isle | Vermont | 50013 | 496 | 3 |
2019017 | 2019017 | 2021-12-16 | Cheyenne | Kansas | 20023 | 496 | 14 |
2015767 | 2015767 | 2021-12-15 | Cheyenne | Kansas | 20023 | 496 | 14 |
2012524 | 2012524 | 2021-12-14 | Decatur | Kansas | 20039 | 496 | 16 |
2009273 | 2009273 | 2021-12-13 | Decatur | Kansas | 20039 | 496 | 16 |
1985592 | 1985592 | 2021-12-05 | Niobrara | Wyoming | 56027 | 496 | 8 |
1982342 | 1982342 | 2021-12-04 | Niobrara | Wyoming | 56027 | 496 | 8 |
1979092 | 1979092 | 2021-12-03 | Niobrara | Wyoming | 56027 | 496 | 8 |
1922625 | 1922625 | 2021-11-16 | McIntosh | North Dakota | 38051 | 496 | 8 |
1919375 | 1919375 | 2021-11-15 | McIntosh | North Dakota | 38051 | 496 | 8 |
1915067 | 1915067 | 2021-11-14 | Rawlins | Kansas | 20153 | 496 | 7 |
1916125 | 1916125 | 2021-11-14 | McIntosh | North Dakota | 38051 | 496 | 8 |
1911817 | 1911817 | 2021-11-13 | Rawlins | Kansas | 20153 | 496 | 7 |
1912875 | 1912875 | 2021-11-13 | McIntosh | North Dakota | 38051 | 496 | 8 |
1908568 | 1908568 | 2021-11-12 | Rawlins | Kansas | 20153 | 496 | 7 |
1907282 | 1907282 | 2021-11-11 | Bath | Virginia | 51017 | 496 | 15 |
1904033 | 1904033 | 2021-11-10 | Bath | Virginia | 51017 | 496 | 15 |
1896350 | 1896350 | 2021-11-08 | Stanton | Nebraska | 31167 | 496 | 11 |
1882561 | 1882561 | 2021-11-04 | Ness | Kansas | 20135 | 496 | 17 |
1879312 | 1879312 | 2021-11-03 | Ness | Kansas | 20135 | 496 | 17 |
1869595 | 1869595 | 2021-10-31 | Trego | Kansas | 20195 | 496 | 8 |
1866346 | 1866346 | 2021-10-30 | Trego | Kansas | 20195 | 496 | 8 |
1867114 | 1867114 | 2021-10-30 | Webster | Nebraska | 31181 | 496 | 8 |
1863097 | 1863097 | 2021-10-29 | Trego | Kansas | 20195 | 496 | 8 |
1863865 | 1863865 | 2021-10-29 | Webster | Nebraska | 31181 | 496 | 8 |
1859848 | 1859848 | 2021-10-28 | Trego | Kansas | 20195 | 496 | 8 |
1855691 | 1855691 | 2021-10-27 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 496 | 6 |
1856599 | 1856599 | 2021-10-27 | Trego | Kansas | 20195 | 496 | 8 |
1852442 | 1852442 | 2021-10-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 496 | 6 |
1853256 | 1853256 | 2021-10-26 | Barber | Kansas | 20007 | 496 | 7 |
1850007 | 1850007 | 2021-10-25 | Barber | Kansas | 20007 | 496 | 7 |
1846763 | 1846763 | 2021-10-24 | Chautauqua | Kansas | 20019 | 496 | 9 |
1843513 | 1843513 | 2021-10-23 | Chautauqua | Kansas | 20019 | 496 | 9 |
1840263 | 1840263 | 2021-10-22 | Chautauqua | Kansas | 20019 | 496 | 9 |
1834519 | 1834519 | 2021-10-20 | Sheridan | Montana | 30091 | 496 | 7 |
1826920 | 1826920 | 2021-10-18 | Adams | Idaho | 16003 | 496 | 10 |
1806092 | 1806092 | 2021-10-11 | Clark | South Dakota | 46025 | 496 | 5 |
1802842 | 1802842 | 2021-10-10 | Clark | South Dakota | 46025 | 496 | 5 |
1799593 | 1799593 | 2021-10-09 | Clark | South Dakota | 46025 | 496 | 5 |
1796344 | 1796344 | 2021-10-08 | Clark | South Dakota | 46025 | 496 | 5 |
1787463 | 1787463 | 2021-10-06 | Unknown | Alaska | 496 | 0 | |
1788548 | 1788548 | 2021-10-06 | Tensas | Louisiana | 22107 | 496 | 8 |
1785299 | 1785299 | 2021-10-05 | Tensas | Louisiana | 22107 | 496 | 8 |
1782050 | 1782050 | 2021-10-04 | Tensas | Louisiana | 22107 | 496 | 8 |
1779645 | 1779645 | 2021-10-03 | Eddy | North Dakota | 38027 | 496 | 6 |
1776387 | 1776387 | 2021-10-02 | Bowman | North Dakota | 38011 | 496 | 7 |
1776395 | 1776395 | 2021-10-02 | Eddy | North Dakota | 38027 | 496 | 6 |
1763113 | 1763113 | 2021-09-28 | Nuckolls | Nebraska | 31129 | 496 | 12 |
1760612 | 1760612 | 2021-09-27 | Douglas | South Dakota | 46043 | 496 | 9 |
1757364 | 1757364 | 2021-09-26 | Douglas | South Dakota | 46043 | 496 | 9 |
1754116 | 1754116 | 2021-09-25 | Douglas | South Dakota | 46043 | 496 | 9 |
1750868 | 1750868 | 2021-09-24 | Douglas | South Dakota | 46043 | 496 | 9 |
1747619 | 1747619 | 2021-09-23 | Douglas | South Dakota | 46043 | 496 | 9 |
1733914 | 1733914 | 2021-09-19 | Mineral | Nevada | 32021 | 496 | 10 |
1730664 | 1730664 | 2021-09-18 | Mineral | Nevada | 32021 | 496 | 10 |
1727414 | 1727414 | 2021-09-17 | Mineral | Nevada | 32021 | 496 | 10 |
1718858 | 1718858 | 2021-09-14 | Falls Church city | Virginia | 51610 | 496 | 8 |
1714662 | 1714662 | 2021-09-13 | Dunn | North Dakota | 38025 | 496 | 7 |
1711416 | 1711416 | 2021-09-12 | Dunn | North Dakota | 38025 | 496 | 7 |
1669203 | 1669203 | 2021-08-30 | Nelson | North Dakota | 38063 | 496 | 15 |
1665956 | 1665956 | 2021-08-29 | Nelson | North Dakota | 38063 | 496 | 15 |
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);