ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where cases = 373 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 79
- Kansas 52
- Nebraska 52
- South Dakota 45
- Idaho 40
- Georgia 39
- Virginia 31
- Kentucky 28
- Minnesota 27
- North Dakota 26
- Puerto Rico 23
- Wyoming 22
- Mississippi 21
- Iowa 20
- Missouri 19
- Oklahoma 19
- Arkansas 17
- Illinois 16
- Ohio 16
- Colorado 15
- Louisiana 15
- Michigan 14
- North Carolina 14
- Alaska 13
- Indiana 13
- Montana 13
- New Mexico 10
- Oregon 10
- Tennessee 10
- New York 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429638 | 2429638 | 2022-04-21 | Gosper | Nebraska | 31073 | 373 | 7 |
2426382 | 2426382 | 2022-04-20 | Gosper | Nebraska | 31073 | 373 | 7 |
2423126 | 2423126 | 2022-04-19 | Gosper | Nebraska | 31073 | 373 | 7 |
2419869 | 2419869 | 2022-04-18 | Gosper | Nebraska | 31073 | 373 | 7 |
2416614 | 2416614 | 2022-04-17 | Gosper | Nebraska | 31073 | 373 | 7 |
2413358 | 2413358 | 2022-04-16 | Gosper | Nebraska | 31073 | 373 | 7 |
2410102 | 2410102 | 2022-04-15 | Gosper | Nebraska | 31073 | 373 | 7 |
2406846 | 2406846 | 2022-04-14 | Gosper | Nebraska | 31073 | 373 | 7 |
2403590 | 2403590 | 2022-04-13 | Gosper | Nebraska | 31073 | 373 | 7 |
2266958 | 2266958 | 2022-03-02 | Harlan | Nebraska | 31083 | 373 | 2 |
2263707 | 2263707 | 2022-03-01 | Harlan | Nebraska | 31083 | 373 | 2 |
2260456 | 2260456 | 2022-02-28 | Harlan | Nebraska | 31083 | 373 | 2 |
2216554 | 2216554 | 2022-02-15 | Denali Borough | Alaska | 2068 | 373 | 1 |
2213303 | 2213303 | 2022-02-14 | Denali Borough | Alaska | 2068 | 373 | 1 |
2201843 | 2201843 | 2022-02-10 | Daniels | Montana | 30019 | 373 | 9 |
2192135 | 2192135 | 2022-02-07 | Boyd | Nebraska | 31015 | 373 | 6 |
2175907 | 2175907 | 2022-02-02 | Harlan | Nebraska | 31083 | 373 | 2 |
2172994 | 2172994 | 2022-02-01 | Steele | North Dakota | 38091 | 373 | 2 |
2169333 | 2169333 | 2022-01-31 | Meagher | Montana | 30059 | 373 | 10 |
2132833 | 2132833 | 2022-01-20 | Hodgeman | Kansas | 20083 | 373 | 10 |
2129580 | 2129580 | 2022-01-19 | Hodgeman | Kansas | 20083 | 373 | 10 |
2130343 | 2130343 | 2022-01-19 | Franklin | Nebraska | 31061 | 373 | 8 |
2126384 | 2126384 | 2022-01-18 | Wallace | Kansas | 20199 | 373 | 5 |
2123132 | 2123132 | 2022-01-17 | Wallace | Kansas | 20199 | 373 | 5 |
2119880 | 2119880 | 2022-01-16 | Wallace | Kansas | 20199 | 373 | 5 |
2116628 | 2116628 | 2022-01-15 | Wallace | Kansas | 20199 | 373 | 5 |
2113377 | 2113377 | 2022-01-14 | Wallace | Kansas | 20199 | 373 | 5 |
2102930 | 2102930 | 2022-01-11 | Sedgwick | Colorado | 8115 | 373 | 6 |
2103540 | 2103540 | 2022-01-11 | Comanche | Kansas | 20033 | 373 | 13 |
2099679 | 2099679 | 2022-01-10 | Sedgwick | Colorado | 8115 | 373 | 6 |
2100289 | 2100289 | 2022-01-10 | Comanche | Kansas | 20033 | 373 | 13 |
2084461 | 2084461 | 2022-01-05 | Cook | Minnesota | 27031 | 373 | 1 |
2062870 | 2062870 | 2021-12-29 | Mellette | South Dakota | 46095 | 373 | 4 |
2028791 | 2028791 | 2021-12-19 | Graham | Kansas | 20065 | 373 | 12 |
2025540 | 2025540 | 2021-12-18 | Graham | Kansas | 20065 | 373 | 12 |
2022289 | 2022289 | 2021-12-17 | Graham | Kansas | 20065 | 373 | 12 |
2013773 | 2013773 | 2021-12-14 | Cimarron | Oklahoma | 40025 | 373 | 0 |
2014120 | 2014120 | 2021-12-14 | Miner | South Dakota | 46097 | 373 | 11 |
2010178 | 2010178 | 2021-12-13 | De Baca | New Mexico | 35011 | 373 | 3 |
2010522 | 2010522 | 2021-12-13 | Cimarron | Oklahoma | 40025 | 373 | 0 |
2007271 | 2007271 | 2021-12-12 | Cimarron | Oklahoma | 40025 | 373 | 0 |
2004020 | 2004020 | 2021-12-11 | Cimarron | Oklahoma | 40025 | 373 | 0 |
2000769 | 2000769 | 2021-12-10 | Cimarron | Oklahoma | 40025 | 373 | 0 |
1997519 | 1997519 | 2021-12-09 | Cimarron | Oklahoma | 40025 | 373 | 0 |
1998118 | 1998118 | 2021-12-09 | Knox | Texas | 48275 | 373 | 22 |
1994268 | 1994268 | 2021-12-08 | Cimarron | Oklahoma | 40025 | 373 | 0 |
1994867 | 1994867 | 2021-12-08 | Knox | Texas | 48275 | 373 | 22 |
1989773 | 1989773 | 2021-12-07 | Elk | Kansas | 20049 | 373 | 6 |
1991616 | 1991616 | 2021-12-07 | Knox | Texas | 48275 | 373 | 22 |
1986523 | 1986523 | 2021-12-06 | Elk | Kansas | 20049 | 373 | 6 |
1988365 | 1988365 | 2021-12-06 | Knox | Texas | 48275 | 373 | 22 |
1966497 | 1966497 | 2021-11-30 | Baker | Georgia | 13007 | 373 | 14 |
1943739 | 1943739 | 2021-11-23 | Baker | Georgia | 13007 | 373 | 14 |
1940489 | 1940489 | 2021-11-22 | Baker | Georgia | 13007 | 373 | 14 |
1941197 | 1941197 | 2021-11-22 | Robertson | Kentucky | 21201 | 373 | 16 |
1942116 | 1942116 | 2021-11-22 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1937239 | 1937239 | 2021-11-21 | Baker | Georgia | 13007 | 373 | 14 |
1938866 | 1938866 | 2021-11-21 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1933989 | 1933989 | 2021-11-20 | Baker | Georgia | 13007 | 373 | 14 |
1935616 | 1935616 | 2021-11-20 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1930737 | 1930737 | 2021-11-19 | Baker | Georgia | 13007 | 373 | 14 |
1932366 | 1932366 | 2021-11-19 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1929115 | 1929115 | 2021-11-18 | Golden Valley | North Dakota | 38033 | 373 | 4 |
1920988 | 1920988 | 2021-11-16 | Baker | Georgia | 13007 | 373 | 14 |
1922621 | 1922621 | 2021-11-16 | Kidder | North Dakota | 38043 | 373 | 12 |
1920411 | 1920411 | 2021-11-15 | Columbia | Washington | 53013 | 373 | 8 |
1920432 | 1920432 | 2021-11-15 | San Juan | Washington | 53055 | 373 | 0 |
1915832 | 1915832 | 2021-11-14 | Perkins | Nebraska | 31135 | 373 | 12 |
1912582 | 1912582 | 2021-11-13 | Perkins | Nebraska | 31135 | 373 | 12 |
1909332 | 1909332 | 2021-11-12 | Perkins | Nebraska | 31135 | 373 | 12 |
1906024 | 1906024 | 2021-11-11 | Brown | Nebraska | 31017 | 373 | 4 |
1869177 | 1869177 | 2021-10-31 | Custer | Idaho | 16037 | 373 | 6 |
1865928 | 1865928 | 2021-10-30 | Custer | Idaho | 16037 | 373 | 6 |
1862679 | 1862679 | 2021-10-29 | Custer | Idaho | 16037 | 373 | 6 |
1849096 | 1849096 | 2021-10-24 | Niobrara | Wyoming | 56027 | 373 | 5 |
1845846 | 1845846 | 2021-10-23 | Niobrara | Wyoming | 56027 | 373 | 5 |
1842596 | 1842596 | 2021-10-22 | Niobrara | Wyoming | 56027 | 373 | 5 |
1838114 | 1838114 | 2021-10-21 | Adams | North Dakota | 38001 | 373 | 4 |
1839347 | 1839347 | 2021-10-21 | Niobrara | Wyoming | 56027 | 373 | 5 |
1834865 | 1834865 | 2021-10-20 | Adams | North Dakota | 38001 | 373 | 4 |
1831653 | 1831653 | 2021-10-19 | Renville | North Dakota | 38075 | 373 | 14 |
1828404 | 1828404 | 2021-10-18 | Renville | North Dakota | 38075 | 373 | 14 |
1813687 | 1813687 | 2021-10-14 | Unknown | Delaware | 373 | 0 | |
1808921 | 1808921 | 2021-10-12 | Towner | North Dakota | 38095 | 373 | 11 |
1805670 | 1805670 | 2021-10-11 | Towner | North Dakota | 38095 | 373 | 11 |
1802421 | 1802421 | 2021-10-10 | Towner | North Dakota | 38095 | 373 | 11 |
1799172 | 1799172 | 2021-10-09 | Towner | North Dakota | 38095 | 373 | 11 |
1793118 | 1793118 | 2021-10-07 | Jackson | South Dakota | 46071 | 373 | 15 |
1773898 | 1773898 | 2021-10-01 | Lipscomb | Texas | 48295 | 373 | 12 |
1770648 | 1770648 | 2021-09-30 | Lipscomb | Texas | 48295 | 373 | 12 |
1767399 | 1767399 | 2021-09-29 | Lipscomb | Texas | 48295 | 373 | 12 |
1764150 | 1764150 | 2021-09-28 | Lipscomb | Texas | 48295 | 373 | 12 |
1737916 | 1737916 | 2021-09-20 | Ziebach | South Dakota | 46137 | 373 | 9 |
1732429 | 1732429 | 2021-09-19 | Ouray | Colorado | 8091 | 373 | 5 |
1734666 | 1734666 | 2021-09-19 | Ziebach | South Dakota | 46137 | 373 | 9 |
1735075 | 1735075 | 2021-09-19 | Bath | Virginia | 51017 | 373 | 12 |
1729179 | 1729179 | 2021-09-18 | Ouray | Colorado | 8091 | 373 | 5 |
1731416 | 1731416 | 2021-09-18 | Ziebach | South Dakota | 46137 | 373 | 9 |
1731825 | 1731825 | 2021-09-18 | Bath | Virginia | 51017 | 373 | 12 |
1725929 | 1725929 | 2021-09-17 | Ouray | Colorado | 8091 | 373 | 5 |
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);