ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
636 rows where cases = 502 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 56
- Georgia 39
- North Dakota 36
- Kansas 31
- Mississippi 30
- Virginia 30
- Missouri 27
- Nebraska 27
- Puerto Rico 24
- South Dakota 23
- Kentucky 21
- Oklahoma 19
- Montana 18
- Colorado 17
- Indiana 15
- Iowa 15
- Minnesota 15
- Illinois 14
- Louisiana 14
- Michigan 12
- North Carolina 12
- Wisconsin 12
- Alabama 9
- Arkansas 9
- New Mexico 9
- Ohio 8
- Alaska 7
- Maine 7
- New York 7
- Rhode Island 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337713 | 2337713 | 2022-03-24 | Clark | Kansas | 20025 | 502 | 7 |
2334459 | 2334459 | 2022-03-23 | Clark | Kansas | 20025 | 502 | 7 |
2283537 | 2283537 | 2022-03-07 | Kidder | North Dakota | 38043 | 502 | 13 |
2280285 | 2280285 | 2022-03-06 | Kidder | North Dakota | 38043 | 502 | 13 |
2277032 | 2277032 | 2022-03-05 | Kidder | North Dakota | 38043 | 502 | 13 |
2274384 | 2274384 | 2022-03-04 | Armstrong | Texas | 48011 | 502 | 8 |
2196545 | 2196545 | 2022-02-08 | Schleicher | Texas | 48413 | 502 | 9 |
2193139 | 2193139 | 2022-02-07 | Culberson | Texas | 48109 | 502 | 13 |
2189885 | 2189885 | 2022-02-06 | Culberson | Texas | 48109 | 502 | 13 |
2186632 | 2186632 | 2022-02-05 | Culberson | Texas | 48109 | 502 | 13 |
2172644 | 2172644 | 2022-02-01 | Frontier | Nebraska | 31063 | 502 | 2 |
2173107 | 2173107 | 2022-02-01 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2169391 | 2169391 | 2022-01-31 | Frontier | Nebraska | 31063 | 502 | 2 |
2169855 | 2169855 | 2022-01-31 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2166600 | 2166600 | 2022-01-30 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2163345 | 2163345 | 2022-01-29 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2160090 | 2160090 | 2022-01-28 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2156835 | 2156835 | 2022-01-27 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2153582 | 2153582 | 2022-01-26 | Cimarron | Oklahoma | 40025 | 502 | 0 |
2147401 | 2147401 | 2022-01-24 | Faulk | South Dakota | 46049 | 502 | 16 |
2143479 | 2143479 | 2022-01-23 | De Baca | New Mexico | 35011 | 502 | 4 |
2140224 | 2140224 | 2022-01-22 | De Baca | New Mexico | 35011 | 502 | 4 |
2136968 | 2136968 | 2022-01-21 | De Baca | New Mexico | 35011 | 502 | 4 |
2137191 | 2137191 | 2022-01-21 | Renville | North Dakota | 38075 | 502 | 15 |
2114407 | 2114407 | 2022-01-14 | Griggs | North Dakota | 38039 | 502 | 2 |
2110049 | 2110049 | 2022-01-13 | Edwards | Kansas | 20047 | 502 | 13 |
2106798 | 2106798 | 2022-01-12 | Edwards | Kansas | 20047 | 502 | 13 |
2105296 | 2105296 | 2022-01-11 | Collingsworth | Texas | 48087 | 502 | 12 |
2079855 | 2079855 | 2022-01-03 | Niobrara | Wyoming | 56027 | 502 | 8 |
2057101 | 2057101 | 2021-12-27 | Niobrara | Wyoming | 56027 | 502 | 8 |
2053105 | 2053105 | 2021-12-26 | Hanson | South Dakota | 46061 | 502 | 5 |
2049855 | 2049855 | 2021-12-25 | Hanson | South Dakota | 46061 | 502 | 5 |
2046605 | 2046605 | 2021-12-24 | Hanson | South Dakota | 46061 | 502 | 5 |
2043355 | 2043355 | 2021-12-23 | Hanson | South Dakota | 46061 | 502 | 5 |
2035271 | 2035271 | 2021-12-21 | Cheyenne | Kansas | 20023 | 502 | 14 |
2032021 | 2032021 | 2021-12-20 | Cheyenne | Kansas | 20023 | 502 | 14 |
2030380 | 2030380 | 2021-12-19 | Potter | South Dakota | 46107 | 502 | 5 |
2027129 | 2027129 | 2021-12-18 | Potter | South Dakota | 46107 | 502 | 5 |
2023878 | 2023878 | 2021-12-17 | Potter | South Dakota | 46107 | 502 | 5 |
2016423 | 2016423 | 2021-12-15 | Mercer | Missouri | 29129 | 502 | 9 |
2010879 | 2010879 | 2021-12-13 | Stanley | South Dakota | 46117 | 502 | 3 |
2001270 | 2001270 | 2021-12-10 | Cochran | Texas | 48079 | 502 | 19 |
1944296 | 1944296 | 2021-11-23 | Logan | Kansas | 20109 | 502 | 9 |
1945811 | 1945811 | 2021-11-23 | Bennett | South Dakota | 46007 | 502 | 9 |
1940386 | 1940386 | 2021-11-22 | Ouray | Colorado | 8091 | 502 | 6 |
1941046 | 1941046 | 2021-11-22 | Logan | Kansas | 20109 | 502 | 9 |
1942560 | 1942560 | 2021-11-22 | Bennett | South Dakota | 46007 | 502 | 9 |
1932375 | 1932375 | 2021-11-19 | McIntosh | North Dakota | 38051 | 502 | 8 |
1929559 | 1929559 | 2021-11-18 | Bennett | South Dakota | 46007 | 502 | 9 |
1894845 | 1894845 | 2021-11-08 | Baca | Colorado | 8009 | 502 | 5 |
1893108 | 1893108 | 2021-11-07 | Webster | Nebraska | 31181 | 502 | 8 |
1889858 | 1889858 | 2021-11-06 | Webster | Nebraska | 31181 | 502 | 8 |
1886608 | 1886608 | 2021-11-05 | Webster | Nebraska | 31181 | 502 | 8 |
1882591 | 1882591 | 2021-11-04 | Trego | Kansas | 20195 | 502 | 8 |
1883359 | 1883359 | 2021-11-04 | Webster | Nebraska | 31181 | 502 | 8 |
1878419 | 1878419 | 2021-11-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 502 | 0 |
1879342 | 1879342 | 2021-11-03 | Trego | Kansas | 20195 | 502 | 8 |
1880110 | 1880110 | 2021-11-03 | Webster | Nebraska | 31181 | 502 | 8 |
1875170 | 1875170 | 2021-11-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 502 | 0 |
1875999 | 1875999 | 2021-11-02 | Barber | Kansas | 20007 | 502 | 7 |
1872750 | 1872750 | 2021-11-01 | Barber | Kansas | 20007 | 502 | 7 |
1854016 | 1854016 | 2021-10-26 | Sheridan | Montana | 30091 | 502 | 7 |
1828835 | 1828835 | 2021-10-18 | Clark | South Dakota | 46025 | 502 | 5 |
1825586 | 1825586 | 2021-10-17 | Clark | South Dakota | 46025 | 502 | 5 |
1822337 | 1822337 | 2021-10-16 | Clark | South Dakota | 46025 | 502 | 5 |
1819088 | 1819088 | 2021-10-15 | Clark | South Dakota | 46025 | 502 | 5 |
1810207 | 1810207 | 2021-10-13 | Unknown | Alaska | 502 | 1 | |
1806958 | 1806958 | 2021-10-12 | Unknown | Alaska | 502 | 1 | |
1808601 | 1808601 | 2021-10-12 | Nance | Nebraska | 31125 | 502 | 10 |
1803707 | 1803707 | 2021-10-11 | Unknown | Alaska | 502 | 1 | |
1805302 | 1805302 | 2021-10-11 | Chase | Nebraska | 31029 | 502 | 5 |
1801543 | 1801543 | 2021-10-10 | Tensas | Louisiana | 22107 | 502 | 8 |
1802053 | 1802053 | 2021-10-10 | Chase | Nebraska | 31029 | 502 | 5 |
1798294 | 1798294 | 2021-10-09 | Tensas | Louisiana | 22107 | 502 | 8 |
1798804 | 1798804 | 2021-10-09 | Chase | Nebraska | 31029 | 502 | 5 |
1795045 | 1795045 | 2021-10-08 | Tensas | Louisiana | 22107 | 502 | 8 |
1795555 | 1795555 | 2021-10-08 | Chase | Nebraska | 31029 | 502 | 5 |
1792640 | 1792640 | 2021-10-07 | Eddy | North Dakota | 38027 | 502 | 6 |
1786607 | 1786607 | 2021-10-05 | Douglas | South Dakota | 46043 | 502 | 9 |
1762929 | 1762929 | 2021-09-28 | Knox | Missouri | 29103 | 502 | 3 |
1759680 | 1759680 | 2021-09-27 | Knox | Missouri | 29103 | 502 | 3 |
1756432 | 1756432 | 2021-09-26 | Knox | Missouri | 29103 | 502 | 3 |
1753184 | 1753184 | 2021-09-25 | Knox | Missouri | 29103 | 502 | 3 |
1749936 | 1749936 | 2021-09-24 | Knox | Missouri | 29103 | 502 | 3 |
1746124 | 1746124 | 2021-09-23 | Stafford | Kansas | 20185 | 502 | 13 |
1742875 | 1742875 | 2021-09-22 | Stafford | Kansas | 20185 | 502 | 13 |
1740360 | 1740360 | 2021-09-21 | Kimball | Nebraska | 31105 | 502 | 7 |
1738354 | 1738354 | 2021-09-20 | Falls Church city | Virginia | 51610 | 502 | 8 |
1735105 | 1735105 | 2021-09-19 | Falls Church city | Virginia | 51610 | 502 | 8 |
1731855 | 1731855 | 2021-09-18 | Falls Church city | Virginia | 51610 | 502 | 8 |
1728605 | 1728605 | 2021-09-17 | Falls Church city | Virginia | 51610 | 502 | 8 |
1708171 | 1708171 | 2021-09-11 | Emmons | North Dakota | 38029 | 502 | 14 |
1699954 | 1699954 | 2021-09-09 | Saguache | Colorado | 8109 | 502 | 8 |
1693722 | 1693722 | 2021-09-07 | Boise | Idaho | 16015 | 502 | 4 |
1691226 | 1691226 | 2021-09-06 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1691946 | 1691946 | 2021-09-06 | Nelson | North Dakota | 38063 | 502 | 15 |
1687976 | 1687976 | 2021-09-05 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1684726 | 1684726 | 2021-09-04 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1681475 | 1681475 | 2021-09-03 | Schoolcraft | Michigan | 26153 | 502 | 5 |
1665746 | 1665746 | 2021-08-29 | Hidalgo | New Mexico | 35023 | 502 | 10 |
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);