ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
530 rows where cases = 797 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 54
- Wisconsin 45
- South Dakota 34
- Iowa 27
- Nebraska 26
- Virginia 25
- Georgia 23
- Minnesota 23
- Wyoming 17
- Alaska 16
- Missouri 16
- Puerto Rico 16
- Oklahoma 15
- Illinois 13
- Kentucky 12
- North Carolina 12
- Colorado 10
- Louisiana 9
- Michigan 9
- Mississippi 9
- Tennessee 9
- North Dakota 8
- Arkansas 7
- Idaho 7
- New Mexico 7
- Pennsylvania 7
- Rhode Island 7
- Montana 6
- Utah 6
- Alabama 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473187 | 2473187 | 2022-05-04 | St. John | Virgin Islands | 78020 | 797 | 5 |
2469931 | 2469931 | 2022-05-03 | St. John | Virgin Islands | 78020 | 797 | 5 |
2466675 | 2466675 | 2022-05-02 | St. John | Virgin Islands | 78020 | 797 | 5 |
2401106 | 2401106 | 2022-04-12 | Clark | South Dakota | 46025 | 797 | 9 |
2397851 | 2397851 | 2022-04-11 | Clark | South Dakota | 46025 | 797 | 9 |
2394596 | 2394596 | 2022-04-10 | Clark | South Dakota | 46025 | 797 | 9 |
2391340 | 2391340 | 2022-04-09 | Clark | South Dakota | 46025 | 797 | 9 |
2388084 | 2388084 | 2022-04-08 | Clark | South Dakota | 46025 | 797 | 9 |
2384829 | 2384829 | 2022-04-07 | Clark | South Dakota | 46025 | 797 | 9 |
2381574 | 2381574 | 2022-04-06 | Clark | South Dakota | 46025 | 797 | 9 |
2309258 | 2309258 | 2022-03-15 | Nance | Nebraska | 31125 | 797 | 10 |
2284832 | 2284832 | 2022-03-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 797 | 1 |
2281580 | 2281580 | 2022-03-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 797 | 1 |
2278327 | 2278327 | 2022-03-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 797 | 1 |
2275074 | 2275074 | 2022-03-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 797 | 1 |
2271821 | 2271821 | 2022-03-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 797 | 1 |
2217279 | 2217279 | 2022-02-15 | Adams | Iowa | 19003 | 797 | 13 |
2213479 | 2213479 | 2022-02-14 | Baca | Colorado | 8009 | 797 | 8 |
2214028 | 2214028 | 2022-02-14 | Adams | Iowa | 19003 | 797 | 13 |
2210776 | 2210776 | 2022-02-13 | Adams | Iowa | 19003 | 797 | 13 |
2211383 | 2211383 | 2022-02-13 | Traverse | Minnesota | 27155 | 797 | 10 |
2207523 | 2207523 | 2022-02-12 | Adams | Iowa | 19003 | 797 | 13 |
2208130 | 2208130 | 2022-02-12 | Traverse | Minnesota | 27155 | 797 | 10 |
2204270 | 2204270 | 2022-02-11 | Adams | Iowa | 19003 | 797 | 13 |
2204877 | 2204877 | 2022-02-11 | Traverse | Minnesota | 27155 | 797 | 10 |
2201017 | 2201017 | 2022-02-10 | Adams | Iowa | 19003 | 797 | 13 |
2201273 | 2201273 | 2022-02-10 | Hickman | Kentucky | 21105 | 797 | 22 |
2197763 | 2197763 | 2022-02-09 | Adams | Iowa | 19003 | 797 | 13 |
2199823 | 2199823 | 2022-02-09 | Upton | Texas | 48461 | 797 | 17 |
2196556 | 2196556 | 2022-02-08 | Sutton | Texas | 48435 | 797 | 12 |
2187293 | 2187293 | 2022-02-06 | Unknown | Alaska | 797 | 1 | |
2184040 | 2184040 | 2022-02-05 | Unknown | Alaska | 797 | 1 | |
2180788 | 2180788 | 2022-02-04 | Unknown | Alaska | 797 | 1 | |
2179314 | 2179314 | 2022-02-03 | Hamilton | New York | 36041 | 797 | 5 |
2157337 | 2157337 | 2022-01-27 | Coke | Texas | 48081 | 797 | 18 |
2130193 | 2130193 | 2022-01-19 | Knox | Missouri | 29103 | 797 | 10 |
2101095 | 2101095 | 2022-01-10 | Johnson | Nebraska | 31097 | 797 | 10 |
2098835 | 2098835 | 2022-01-09 | Garza | Texas | 48169 | 797 | 25 |
2090210 | 2090210 | 2022-01-07 | Lincoln | Idaho | 16063 | 797 | 14 |
2088416 | 2088416 | 2022-01-06 | Sargent | North Dakota | 38081 | 797 | 9 |
2069183 | 2069183 | 2021-12-31 | Sullivan | Pennsylvania | 42113 | 797 | 28 |
2062418 | 2062418 | 2021-12-29 | Wells | North Dakota | 38103 | 797 | 11 |
2056810 | 2056810 | 2021-12-27 | Charles City | Virginia | 51036 | 797 | 22 |
2053290 | 2053290 | 2021-12-26 | Crockett | Texas | 48105 | 797 | 17 |
2050040 | 2050040 | 2021-12-25 | Crockett | Texas | 48105 | 797 | 17 |
2046790 | 2046790 | 2021-12-24 | Crockett | Texas | 48105 | 797 | 17 |
2043540 | 2043540 | 2021-12-23 | Crockett | Texas | 48105 | 797 | 17 |
2040291 | 2040291 | 2021-12-22 | Crockett | Texas | 48105 | 797 | 17 |
2034072 | 2034072 | 2021-12-20 | Cumberland | Virginia | 51049 | 797 | 19 |
2029617 | 2029617 | 2021-12-19 | Thayer | Nebraska | 31169 | 797 | 8 |
2030345 | 2030345 | 2021-12-19 | Deuel | South Dakota | 46039 | 797 | 12 |
2026366 | 2026366 | 2021-12-18 | Thayer | Nebraska | 31169 | 797 | 8 |
2027094 | 2027094 | 2021-12-18 | Deuel | South Dakota | 46039 | 797 | 12 |
2023115 | 2023115 | 2021-12-17 | Thayer | Nebraska | 31169 | 797 | 8 |
2023843 | 2023843 | 2021-12-17 | Deuel | South Dakota | 46039 | 797 | 12 |
2021066 | 2021066 | 2021-12-16 | Covington city | Virginia | 51580 | 797 | 19 |
2012409 | 2012409 | 2021-12-14 | Audubon | Iowa | 19009 | 797 | 17 |
2013788 | 2013788 | 2021-12-14 | Greer | Oklahoma | 40055 | 797 | 26 |
2009158 | 2009158 | 2021-12-13 | Audubon | Iowa | 19009 | 797 | 17 |
2010537 | 2010537 | 2021-12-13 | Greer | Oklahoma | 40055 | 797 | 26 |
2005907 | 2005907 | 2021-12-12 | Audubon | Iowa | 19009 | 797 | 17 |
2007286 | 2007286 | 2021-12-12 | Greer | Oklahoma | 40055 | 797 | 26 |
2002656 | 2002656 | 2021-12-11 | Audubon | Iowa | 19009 | 797 | 17 |
2004035 | 2004035 | 2021-12-11 | Greer | Oklahoma | 40055 | 797 | 26 |
1999406 | 1999406 | 2021-12-10 | Audubon | Iowa | 19009 | 797 | 17 |
2000784 | 2000784 | 2021-12-10 | Greer | Oklahoma | 40055 | 797 | 26 |
1996155 | 1996155 | 2021-12-09 | Audubon | Iowa | 19009 | 797 | 17 |
1997534 | 1997534 | 2021-12-09 | Greer | Oklahoma | 40055 | 797 | 26 |
1992904 | 1992904 | 2021-12-08 | Audubon | Iowa | 19009 | 797 | 17 |
1994283 | 1994283 | 2021-12-08 | Greer | Oklahoma | 40055 | 797 | 26 |
1969653 | 1969653 | 2021-12-01 | Saguache | Colorado | 8109 | 797 | 9 |
1959694 | 1959694 | 2021-11-28 | Yukon-Koyukuk Census Area | Alaska | 2290 | 797 | 7 |
1956443 | 1956443 | 2021-11-27 | Yukon-Koyukuk Census Area | Alaska | 2290 | 797 | 7 |
1953192 | 1953192 | 2021-11-26 | Yukon-Koyukuk Census Area | Alaska | 2290 | 797 | 7 |
1948614 | 1948614 | 2021-11-24 | Dunn | North Dakota | 38025 | 797 | 7 |
1900359 | 1900359 | 2021-11-09 | Moody | South Dakota | 46101 | 797 | 21 |
1878603 | 1878603 | 2021-11-03 | Clear Creek | Colorado | 8019 | 797 | 5 |
1869232 | 1869232 | 2021-10-31 | Gallatin | Illinois | 17059 | 797 | 10 |
1865983 | 1865983 | 2021-10-30 | Gallatin | Illinois | 17059 | 797 | 10 |
1862734 | 1862734 | 2021-10-29 | Gallatin | Illinois | 17059 | 797 | 10 |
1859485 | 1859485 | 2021-10-28 | Gallatin | Illinois | 17059 | 797 | 10 |
1860504 | 1860504 | 2021-10-28 | Phillips | Montana | 30071 | 797 | 23 |
1847190 | 1847190 | 2021-10-24 | Big Stone | Minnesota | 27011 | 797 | 4 |
1847630 | 1847630 | 2021-10-24 | Lander | Nevada | 32015 | 797 | 14 |
1843940 | 1843940 | 2021-10-23 | Big Stone | Minnesota | 27011 | 797 | 4 |
1844380 | 1844380 | 2021-10-23 | Lander | Nevada | 32015 | 797 | 14 |
1840690 | 1840690 | 2021-10-22 | Big Stone | Minnesota | 27011 | 797 | 4 |
1841130 | 1841130 | 2021-10-22 | Lander | Nevada | 32015 | 797 | 14 |
1837441 | 1837441 | 2021-10-21 | Big Stone | Minnesota | 27011 | 797 | 4 |
1837881 | 1837881 | 2021-10-21 | Lander | Nevada | 32015 | 797 | 14 |
1824830 | 1824830 | 2021-10-17 | Jefferson | Nebraska | 31095 | 797 | 3 |
1821581 | 1821581 | 2021-10-16 | Jefferson | Nebraska | 31095 | 797 | 3 |
1818332 | 1818332 | 2021-10-15 | Jefferson | Nebraska | 31095 | 797 | 3 |
1812586 | 1812586 | 2021-10-13 | Brule | South Dakota | 46015 | 797 | 11 |
1801749 | 1801749 | 2021-10-10 | Norman | Minnesota | 27107 | 797 | 9 |
1798500 | 1798500 | 2021-10-09 | Norman | Minnesota | 27107 | 797 | 9 |
1795251 | 1795251 | 2021-10-08 | Norman | Minnesota | 27107 | 797 | 9 |
1796242 | 1796242 | 2021-10-08 | Lajas | Puerto Rico | 72079 | 797 | |
1791311 | 1791311 | 2021-10-07 | Stark | Illinois | 17175 | 797 | 27 |
1789402 | 1789402 | 2021-10-06 | McHenry | North Dakota | 38049 | 797 | 23 |
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);