ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where cases = 482 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 104
- North Dakota 73
- Texas 53
- Michigan 43
- Virginia 34
- Georgia 33
- Colorado 31
- Illinois 26
- Kentucky 24
- Minnesota 23
- South Dakota 23
- Kansas 22
- Iowa 20
- Missouri 20
- Idaho 19
- Indiana 18
- Oklahoma 15
- California 14
- Mississippi 14
- Nevada 13
- Pennsylvania 13
- Tennessee 13
- Louisiana 11
- Oregon 11
- Puerto Rico 11
- Arkansas 10
- West Virginia 10
- Montana 9
- North Carolina 9
- Ohio 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392418 | 2392418 | 2022-04-10 | Sedgwick | Colorado | 8115 | 482 | 9 |
2389162 | 2389162 | 2022-04-09 | Sedgwick | Colorado | 8115 | 482 | 9 |
2385907 | 2385907 | 2022-04-08 | Sedgwick | Colorado | 8115 | 482 | 9 |
2379397 | 2379397 | 2022-04-06 | Sedgwick | Colorado | 8115 | 482 | 9 |
2376143 | 2376143 | 2022-04-05 | Sedgwick | Colorado | 8115 | 482 | 9 |
2372891 | 2372891 | 2022-04-04 | Sedgwick | Colorado | 8115 | 482 | 9 |
2369638 | 2369638 | 2022-04-03 | Sedgwick | Colorado | 8115 | 482 | 9 |
2366385 | 2366385 | 2022-04-02 | Sedgwick | Colorado | 8115 | 482 | 9 |
2363132 | 2363132 | 2022-04-01 | Sedgwick | Colorado | 8115 | 482 | 9 |
2359878 | 2359878 | 2022-03-31 | Sedgwick | Colorado | 8115 | 482 | 9 |
2356624 | 2356624 | 2022-03-30 | Sedgwick | Colorado | 8115 | 482 | 9 |
2353371 | 2353371 | 2022-03-29 | Sedgwick | Colorado | 8115 | 482 | 9 |
2215994 | 2215994 | 2022-02-14 | Knox | Texas | 48275 | 482 | 23 |
2212743 | 2212743 | 2022-02-13 | Knox | Texas | 48275 | 482 | 23 |
2194620 | 2194620 | 2022-02-08 | Clark | Kansas | 20025 | 482 | 7 |
2196344 | 2196344 | 2022-02-08 | Armstrong | Texas | 48011 | 482 | 8 |
2191366 | 2191366 | 2022-02-07 | Clark | Kansas | 20025 | 482 | 7 |
2186741 | 2186741 | 2022-02-05 | Menard | Texas | 48327 | 482 | 12 |
2172227 | 2172227 | 2022-02-01 | Keweenaw | Michigan | 26083 | 482 | 12 |
2168974 | 2168974 | 2022-01-31 | Keweenaw | Michigan | 26083 | 482 | 12 |
2165777 | 2165777 | 2022-01-30 | Cook | Minnesota | 27031 | 482 | 2 |
2162522 | 2162522 | 2022-01-29 | Cook | Minnesota | 27031 | 482 | 2 |
2164014 | 2164014 | 2022-01-29 | Schleicher | Texas | 48413 | 482 | 9 |
2159267 | 2159267 | 2022-01-28 | Cook | Minnesota | 27031 | 482 | 2 |
2146547 | 2146547 | 2022-01-24 | Granite | Montana | 30039 | 482 | 6 |
2114425 | 2114425 | 2022-01-14 | Renville | North Dakota | 38075 | 482 | 15 |
2106980 | 2106980 | 2022-01-12 | Robertson | Kentucky | 21201 | 482 | 19 |
2107884 | 2107884 | 2022-01-12 | Adams | North Dakota | 38001 | 482 | 9 |
2103079 | 2103079 | 2022-01-11 | Glascock | Georgia | 13125 | 482 | 21 |
2101401 | 2101401 | 2022-01-10 | Griggs | North Dakota | 38039 | 482 | 2 |
2089038 | 2089038 | 2022-01-06 | Collingsworth | Texas | 48087 | 482 | 11 |
2078667 | 2078667 | 2022-01-03 | Towner | North Dakota | 38095 | 482 | 11 |
2058072 | 2058072 | 2021-12-28 | Morton | Kansas | 20129 | 482 | 10 |
2054823 | 2054823 | 2021-12-27 | Morton | Kansas | 20129 | 482 | 10 |
2028121 | 2028121 | 2021-12-19 | Custer | Colorado | 8027 | 482 | 13 |
2024870 | 2024870 | 2021-12-18 | Custer | Colorado | 8027 | 482 | 13 |
2026204 | 2026204 | 2021-12-18 | Scotland | Missouri | 29199 | 482 | 15 |
2021619 | 2021619 | 2021-12-17 | Custer | Colorado | 8027 | 482 | 13 |
2018368 | 2018368 | 2021-12-16 | Custer | Colorado | 8027 | 482 | 13 |
2015118 | 2015118 | 2021-12-15 | Custer | Colorado | 8027 | 482 | 13 |
2011867 | 2011867 | 2021-12-14 | Custer | Colorado | 8027 | 482 | 13 |
1996342 | 1996342 | 2021-12-09 | Smith | Kansas | 20183 | 482 | 3 |
1993091 | 1993091 | 2021-12-08 | Smith | Kansas | 20183 | 482 | 3 |
1980694 | 1980694 | 2021-12-04 | Schuyler | Missouri | 29197 | 482 | 22 |
1942759 | 1942759 | 2021-11-22 | Cochran | Texas | 48079 | 482 | 19 |
1939509 | 1939509 | 2021-11-21 | Cochran | Texas | 48079 | 482 | 19 |
1936259 | 1936259 | 2021-11-20 | Cochran | Texas | 48079 | 482 | 19 |
1911165 | 1911165 | 2021-11-13 | Unknown | Delaware | 482 | 0 | |
1898137 | 1898137 | 2021-11-09 | Ouray | Colorado | 8091 | 482 | 5 |
1893812 | 1893812 | 2021-11-07 | Bennett | South Dakota | 46007 | 482 | 9 |
1890127 | 1890127 | 2021-11-06 | McIntosh | North Dakota | 38051 | 482 | 8 |
1890562 | 1890562 | 2021-11-06 | Bennett | South Dakota | 46007 | 482 | 9 |
1887312 | 1887312 | 2021-11-05 | Bennett | South Dakota | 46007 | 482 | 9 |
1882525 | 1882525 | 2021-11-04 | Gove | Kansas | 20063 | 482 | 22 |
1879276 | 1879276 | 2021-11-03 | Gove | Kansas | 20063 | 482 | 22 |
1855676 | 1855676 | 2021-10-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 482 | 0 |
1856971 | 1856971 | 2021-10-27 | Lake of the Woods | Minnesota | 27077 | 482 | 4 |
1853722 | 1853722 | 2021-10-26 | Lake of the Woods | Minnesota | 27077 | 482 | 4 |
1852043 | 1852043 | 2021-10-25 | Bath | Virginia | 51017 | 482 | 14 |
1830604 | 1830604 | 2021-10-19 | Trego | Kansas | 20195 | 482 | 8 |
1827355 | 1827355 | 2021-10-18 | Trego | Kansas | 20195 | 482 | 8 |
1807666 | 1807666 | 2021-10-12 | Adams | Iowa | 19003 | 482 | 4 |
1804415 | 1804415 | 2021-10-11 | Adams | Iowa | 19003 | 482 | 4 |
1801166 | 1801166 | 2021-10-10 | Adams | Iowa | 19003 | 482 | 4 |
1801773 | 1801773 | 2021-10-10 | Traverse | Minnesota | 27155 | 482 | 5 |
1797917 | 1797917 | 2021-10-09 | Adams | Iowa | 19003 | 482 | 4 |
1798524 | 1798524 | 2021-10-09 | Traverse | Minnesota | 27155 | 482 | 5 |
1794668 | 1794668 | 2021-10-08 | Adams | Iowa | 19003 | 482 | 4 |
1795275 | 1795275 | 2021-10-08 | Traverse | Minnesota | 27155 | 482 | 5 |
1790915 | 1790915 | 2021-10-07 | Phillips | Colorado | 8095 | 482 | 14 |
1791420 | 1791420 | 2021-10-07 | Adams | Iowa | 19003 | 482 | 4 |
1788171 | 1788171 | 2021-10-06 | Adams | Iowa | 19003 | 482 | 4 |
1783831 | 1783831 | 2021-10-04 | Craig | Virginia | 51045 | 482 | 6 |
1779285 | 1779285 | 2021-10-03 | Sheridan | Montana | 30091 | 482 | 7 |
1776035 | 1776035 | 2021-10-02 | Sheridan | Montana | 30091 | 482 | 7 |
1772785 | 1772785 | 2021-10-01 | Sheridan | Montana | 30091 | 482 | 7 |
1766360 | 1766360 | 2021-09-29 | Nance | Nebraska | 31125 | 482 | 10 |
1757896 | 1757896 | 2021-09-26 | Norton city | Virginia | 51720 | 482 | 8 |
1754648 | 1754648 | 2021-09-25 | Norton city | Virginia | 51720 | 482 | 8 |
1751400 | 1751400 | 2021-09-24 | Norton city | Virginia | 51720 | 482 | 8 |
1740322 | 1740322 | 2021-09-21 | Chase | Nebraska | 31029 | 482 | 5 |
1737073 | 1737073 | 2021-09-20 | Chase | Nebraska | 31029 | 482 | 5 |
1733841 | 1733841 | 2021-09-19 | Furnas | Nebraska | 31065 | 482 | 5 |
1730591 | 1730591 | 2021-09-18 | Furnas | Nebraska | 31065 | 482 | 5 |
1727341 | 1727341 | 2021-09-17 | Furnas | Nebraska | 31065 | 482 | 5 |
1724092 | 1724092 | 2021-09-16 | Furnas | Nebraska | 31065 | 482 | 5 |
1725025 | 1725025 | 2021-09-16 | Baylor | Texas | 48023 | 482 | 14 |
1720843 | 1720843 | 2021-09-15 | Furnas | Nebraska | 31065 | 482 | 5 |
1717595 | 1717595 | 2021-09-14 | Furnas | Nebraska | 31065 | 482 | 5 |
1714347 | 1714347 | 2021-09-13 | Furnas | Nebraska | 31065 | 482 | 5 |
1711101 | 1711101 | 2021-09-12 | Furnas | Nebraska | 31065 | 482 | 5 |
1707854 | 1707854 | 2021-09-11 | Furnas | Nebraska | 31065 | 482 | 5 |
1704607 | 1704607 | 2021-09-10 | Furnas | Nebraska | 31065 | 482 | 5 |
1701357 | 1701357 | 2021-09-09 | Furnas | Nebraska | 31065 | 482 | 5 |
1701712 | 1701712 | 2021-09-09 | Wells | North Dakota | 38103 | 482 | 8 |
1698108 | 1698108 | 2021-09-08 | Furnas | Nebraska | 31065 | 482 | 5 |
1698726 | 1698726 | 2021-09-08 | Sullivan | Pennsylvania | 42113 | 482 | 22 |
1694860 | 1694860 | 2021-09-07 | Furnas | Nebraska | 31065 | 482 | 5 |
1691611 | 1691611 | 2021-09-06 | Furnas | Nebraska | 31065 | 482 | 5 |
1692230 | 1692230 | 2021-09-06 | Sullivan | Pennsylvania | 42113 | 482 | 22 |
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);