ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
655 rows where cases = 393 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 69
- Georgia 42
- South Dakota 39
- Virginia 33
- Puerto Rico 28
- Kansas 24
- Illinois 23
- Iowa 23
- Nebraska 20
- Arkansas 19
- Oklahoma 18
- Alaska 17
- Mississippi 17
- Missouri 17
- Kentucky 16
- Louisiana 16
- Colorado 15
- Montana 15
- Pennsylvania 14
- Indiana 13
- Minnesota 12
- Oregon 12
- Idaho 11
- Washington 11
- New York 10
- North Carolina 10
- North Dakota 10
- Michigan 9
- New Mexico 9
- Ohio 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314102 | 2314102 | 2022-03-17 | Denali Borough | Alaska | 2068 | 393 | 1 |
2310849 | 2310849 | 2022-03-16 | Denali Borough | Alaska | 2068 | 393 | 1 |
2279897 | 2279897 | 2022-03-06 | Liberty | Montana | 30051 | 393 | 4 |
2276644 | 2276644 | 2022-03-05 | Liberty | Montana | 30051 | 393 | 4 |
2273391 | 2273391 | 2022-03-04 | Liberty | Montana | 30051 | 393 | 4 |
2270139 | 2270139 | 2022-03-03 | Liberty | Montana | 30051 | 393 | 4 |
2192070 | 2192070 | 2022-02-07 | Worth | Missouri | 29227 | 393 | 3 |
2188817 | 2188817 | 2022-02-06 | Worth | Missouri | 29227 | 393 | 3 |
2164942 | 2164942 | 2022-01-30 | Quitman | Georgia | 13239 | 393 | 4 |
2161687 | 2161687 | 2022-01-29 | Quitman | Georgia | 13239 | 393 | 4 |
2163925 | 2163925 | 2022-01-29 | Irion | Texas | 48235 | 393 | 3 |
2158431 | 2158431 | 2022-01-28 | Quitman | Georgia | 13239 | 393 | 4 |
2146942 | 2146942 | 2022-01-24 | Logan | North Dakota | 38047 | 393 | 11 |
2143688 | 2143688 | 2022-01-23 | Logan | North Dakota | 38047 | 393 | 11 |
2099796 | 2099796 | 2022-01-10 | Clay | Georgia | 13061 | 393 | 4 |
2091643 | 2091643 | 2022-01-07 | Golden Valley | North Dakota | 38033 | 393 | 4 |
2087279 | 2087279 | 2022-01-06 | Clark | Kansas | 20025 | 393 | 7 |
2088392 | 2088392 | 2022-01-06 | Golden Valley | North Dakota | 38033 | 393 | 4 |
2083687 | 2083687 | 2022-01-05 | Butte | Idaho | 16023 | 393 | 7 |
2084027 | 2084027 | 2022-01-05 | Clark | Kansas | 20025 | 393 | 7 |
2085140 | 2085140 | 2022-01-05 | Golden Valley | North Dakota | 38033 | 393 | 4 |
2085628 | 2085628 | 2022-01-05 | Mellette | South Dakota | 46095 | 393 | 4 |
2085950 | 2085950 | 2022-01-05 | Schleicher | Texas | 48413 | 393 | 9 |
2080787 | 2080787 | 2022-01-04 | Elk | Kansas | 20049 | 393 | 7 |
2081888 | 2081888 | 2022-01-04 | Golden Valley | North Dakota | 38033 | 393 | 4 |
2077535 | 2077535 | 2022-01-03 | Elk | Kansas | 20049 | 393 | 7 |
2036527 | 2036527 | 2021-12-21 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2033277 | 2033277 | 2021-12-20 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2030027 | 2030027 | 2021-12-19 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2026776 | 2026776 | 2021-12-18 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2023525 | 2023525 | 2021-12-17 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2020274 | 2020274 | 2021-12-16 | Cimarron | Oklahoma | 40025 | 393 | 0 |
2017023 | 2017023 | 2021-12-15 | Cimarron | Oklahoma | 40025 | 393 | 0 |
1985419 | 1985419 | 2021-12-05 | Columbia | Washington | 53013 | 393 | 9 |
1982169 | 1982169 | 2021-12-04 | Columbia | Washington | 53013 | 393 | 9 |
1978919 | 1978919 | 2021-12-03 | Columbia | Washington | 53013 | 393 | 9 |
1967782 | 1967782 | 2021-11-30 | Brown | Nebraska | 31017 | 393 | 4 |
1941808 | 1941808 | 2021-11-22 | Hitchcock | Nebraska | 31087 | 393 | 5 |
1941927 | 1941927 | 2021-11-22 | Mora | New Mexico | 35033 | 393 | 12 |
1938558 | 1938558 | 2021-11-21 | Hitchcock | Nebraska | 31087 | 393 | 5 |
1935308 | 1935308 | 2021-11-20 | Hitchcock | Nebraska | 31087 | 393 | 5 |
1932058 | 1932058 | 2021-11-19 | Hitchcock | Nebraska | 31087 | 393 | 5 |
1927998 | 1927998 | 2021-11-18 | Chase | Kansas | 20017 | 393 | 4 |
1924748 | 1924748 | 2021-11-17 | Chase | Kansas | 20017 | 393 | 4 |
1906047 | 1906047 | 2021-11-11 | Frontier | Nebraska | 31063 | 393 | 2 |
1902798 | 1902798 | 2021-11-10 | Frontier | Nebraska | 31063 | 393 | 2 |
1899548 | 1899548 | 2021-11-09 | Frontier | Nebraska | 31063 | 393 | 2 |
1890776 | 1890776 | 2021-11-06 | Culberson | Texas | 48109 | 393 | 11 |
1887526 | 1887526 | 2021-11-05 | Culberson | Texas | 48109 | 393 | 11 |
1882517 | 1882517 | 2021-11-04 | Edwards | Kansas | 20047 | 393 | 13 |
1879268 | 1879268 | 2021-11-03 | Edwards | Kansas | 20047 | 393 | 13 |
1875089 | 1875089 | 2021-11-01 | Niobrara | Wyoming | 56027 | 393 | 5 |
1858096 | 1858096 | 2021-10-27 | Hand | South Dakota | 46059 | 393 | 6 |
1853344 | 1853344 | 2021-10-26 | Smith | Kansas | 20183 | 393 | 3 |
1854847 | 1854847 | 2021-10-26 | Hand | South Dakota | 46059 | 393 | 6 |
1850095 | 1850095 | 2021-10-25 | Smith | Kansas | 20183 | 393 | 3 |
1848348 | 1848348 | 2021-10-24 | Hand | South Dakota | 46059 | 393 | 6 |
1845098 | 1845098 | 2021-10-23 | Hand | South Dakota | 46059 | 393 | 6 |
1840950 | 1840950 | 2021-10-22 | Scotland | Missouri | 29199 | 393 | 4 |
1841848 | 1841848 | 2021-10-22 | Hand | South Dakota | 46059 | 393 | 6 |
1837108 | 1837108 | 2021-10-21 | Woodson | Kansas | 20207 | 393 | 9 |
1838599 | 1838599 | 2021-10-21 | Hand | South Dakota | 46059 | 393 | 6 |
1833859 | 1833859 | 2021-10-20 | Woodson | Kansas | 20207 | 393 | 9 |
1835350 | 1835350 | 2021-10-20 | Hand | South Dakota | 46059 | 393 | 6 |
1832101 | 1832101 | 2021-10-19 | Hand | South Dakota | 46059 | 393 | 6 |
1814333 | 1814333 | 2021-10-14 | Osborne | Kansas | 20141 | 393 | 14 |
1811084 | 1811084 | 2021-10-13 | Osborne | Kansas | 20141 | 393 | 14 |
1808554 | 1808554 | 2021-10-12 | Cherry | Nebraska | 31031 | 393 | 8 |
1809354 | 1809354 | 2021-10-12 | Faulk | South Dakota | 46049 | 393 | 14 |
1806104 | 1806104 | 2021-10-11 | Faulk | South Dakota | 46049 | 393 | 14 |
1800439 | 1800439 | 2021-10-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 393 | 0 |
1802854 | 1802854 | 2021-10-10 | Faulk | South Dakota | 46049 | 393 | 14 |
1797190 | 1797190 | 2021-10-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 393 | 0 |
1799605 | 1799605 | 2021-10-09 | Faulk | South Dakota | 46049 | 393 | 14 |
1793941 | 1793941 | 2021-10-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 393 | 0 |
1796356 | 1796356 | 2021-10-08 | Faulk | South Dakota | 46049 | 393 | 14 |
1793107 | 1793107 | 2021-10-07 | Faulk | South Dakota | 46049 | 393 | 14 |
1783390 | 1783390 | 2021-10-04 | Perkins | South Dakota | 46105 | 393 | 14 |
1755334 | 1755334 | 2021-09-26 | Glascock | Georgia | 13125 | 393 | 19 |
1752086 | 1752086 | 2021-09-25 | Glascock | Georgia | 13125 | 393 | 19 |
1748837 | 1748837 | 2021-09-24 | Glascock | Georgia | 13125 | 393 | 19 |
1745587 | 1745587 | 2021-09-23 | Glascock | Georgia | 13125 | 393 | 19 |
1742338 | 1742338 | 2021-09-22 | Glascock | Georgia | 13125 | 393 | 19 |
1741157 | 1741157 | 2021-09-21 | Stanley | South Dakota | 46117 | 393 | 2 |
1741337 | 1741337 | 2021-09-21 | Fisher | Texas | 48151 | 393 | 16 |
1741573 | 1741573 | 2021-09-21 | Bath | Virginia | 51017 | 393 | 12 |
1737908 | 1737908 | 2021-09-20 | Stanley | South Dakota | 46117 | 393 | 2 |
1732224 | 1732224 | 2021-09-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 393 | 5 |
1728974 | 1728974 | 2021-09-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 393 | 5 |
1725724 | 1725724 | 2021-09-17 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 393 | 5 |
1722479 | 1722479 | 2021-09-16 | Unknown | Alaska | 393 | 0 | |
1719231 | 1719231 | 2021-09-15 | Unknown | Alaska | 393 | 0 | |
1702318 | 1702318 | 2021-09-09 | Cochran | Texas | 48079 | 393 | 15 |
1697997 | 1697997 | 2021-09-08 | Schuyler | Missouri | 29197 | 393 | 7 |
1694749 | 1694749 | 2021-09-07 | Schuyler | Missouri | 29197 | 393 | 7 |
1691500 | 1691500 | 2021-09-06 | Schuyler | Missouri | 29197 | 393 | 7 |
1679669 | 1679669 | 2021-09-02 | Kinney | Texas | 48271 | 393 | 7 |
1668813 | 1668813 | 2021-08-30 | Musselshell | Montana | 30065 | 393 | 14 |
1665566 | 1665566 | 2021-08-29 | Musselshell | Montana | 30065 | 393 | 14 |
1666875 | 1666875 | 2021-08-29 | Craig | Virginia | 51045 | 393 | 6 |
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);