ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 2961 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 20
- Georgia 15
- Texas 14
- Ohio 12
- Louisiana 9
- Indiana 8
- Alabama 7
- Iowa 7
- New Mexico 7
- Minnesota 6
- North Carolina 6
- Wisconsin 6
- Arkansas 5
- Kansas 5
- Michigan 5
- Mississippi 5
- Colorado 4
- Idaho 4
- Pennsylvania 4
- Puerto Rico 4
- West Virginia 4
- Florida 3
- Nebraska 3
- South Dakota 3
- Tennessee 3
- Arizona 2
- Illinois 2
- Missouri 2
- Oregon 2
- Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445020 | 2445020 | 2022-04-26 | Cass | Iowa | 19029 | 2961 | 78 |
2441764 | 2441764 | 2022-04-25 | Cass | Iowa | 19029 | 2961 | 78 |
2438508 | 2438508 | 2022-04-24 | Cass | Iowa | 19029 | 2961 | 78 |
2435252 | 2435252 | 2022-04-23 | Cass | Iowa | 19029 | 2961 | 78 |
2431996 | 2431996 | 2022-04-22 | Cass | Iowa | 19029 | 2961 | 78 |
2428740 | 2428740 | 2022-04-21 | Cass | Iowa | 19029 | 2961 | 78 |
2425484 | 2425484 | 2022-04-20 | Cass | Iowa | 19029 | 2961 | 78 |
2416017 | 2416017 | 2022-04-17 | Todd | Kentucky | 21219 | 2961 | 43 |
2412761 | 2412761 | 2022-04-16 | Todd | Kentucky | 21219 | 2961 | 43 |
2409505 | 2409505 | 2022-04-15 | Todd | Kentucky | 21219 | 2961 | 43 |
2406249 | 2406249 | 2022-04-14 | Todd | Kentucky | 21219 | 2961 | 43 |
2402993 | 2402993 | 2022-04-13 | Todd | Kentucky | 21219 | 2961 | 43 |
2399739 | 2399739 | 2022-04-12 | Todd | Kentucky | 21219 | 2961 | 43 |
2396483 | 2396483 | 2022-04-11 | Todd | Kentucky | 21219 | 2961 | 43 |
2393228 | 2393228 | 2022-04-10 | Todd | Kentucky | 21219 | 2961 | 43 |
2389972 | 2389972 | 2022-04-09 | Todd | Kentucky | 21219 | 2961 | 43 |
2386716 | 2386716 | 2022-04-08 | Todd | Kentucky | 21219 | 2961 | 43 |
2383461 | 2383461 | 2022-04-07 | Todd | Kentucky | 21219 | 2961 | 43 |
2380206 | 2380206 | 2022-04-06 | Todd | Kentucky | 21219 | 2961 | 43 |
2376951 | 2376951 | 2022-04-05 | Todd | Kentucky | 21219 | 2961 | 43 |
2373699 | 2373699 | 2022-04-04 | Todd | Kentucky | 21219 | 2961 | 43 |
2313303 | 2313303 | 2022-03-16 | Todd | South Dakota | 46121 | 2961 | 51 |
2310050 | 2310050 | 2022-03-15 | Todd | South Dakota | 46121 | 2961 | 51 |
2305684 | 2305684 | 2022-03-14 | Watonwan | Minnesota | 27165 | 2961 | 23 |
2178883 | 2178883 | 2022-02-03 | Greene | Mississippi | 28041 | 2961 | 51 |
2142157 | 2142157 | 2022-01-23 | Oglethorpe | Georgia | 13221 | 2961 | 46 |
2138902 | 2138902 | 2022-01-22 | Oglethorpe | Georgia | 13221 | 2961 | 46 |
2135646 | 2135646 | 2022-01-21 | Oglethorpe | Georgia | 13221 | 2961 | 46 |
2109894 | 2109894 | 2022-01-13 | Parke | Indiana | 18121 | 2961 | 40 |
2109065 | 2109065 | 2022-01-12 | Lafayette | Wisconsin | 55065 | 2961 | 18 |
2087556 | 2087556 | 2022-01-06 | Winn | Louisiana | 22127 | 2961 | 58 |
2060940 | 2060940 | 2021-12-29 | Gem | Idaho | 16045 | 2961 | 72 |
2037524 | 2037524 | 2021-12-21 | Burnett | Wisconsin | 55013 | 2961 | 36 |
2014169 | 2014169 | 2021-12-14 | Grundy | Tennessee | 47061 | 2961 | 45 |
2011578 | 2011578 | 2021-12-13 | Washburn | Wisconsin | 55129 | 2961 | 33 |
2004685 | 2004685 | 2021-12-11 | San Jacinto | Texas | 48407 | 2961 | 82 |
1961439 | 1961439 | 2021-11-28 | San Miguel | New Mexico | 35047 | 2961 | 29 |
1958188 | 1958188 | 2021-11-27 | San Miguel | New Mexico | 35047 | 2961 | 29 |
1958211 | 1958211 | 2021-11-27 | Essex | New York | 36031 | 2961 | 37 |
1954937 | 1954937 | 2021-11-26 | San Miguel | New Mexico | 35047 | 2961 | 29 |
1951686 | 1951686 | 2021-11-25 | San Miguel | New Mexico | 35047 | 2961 | 29 |
1948435 | 1948435 | 2021-11-24 | San Miguel | New Mexico | 35047 | 2961 | 29 |
1932459 | 1932459 | 2021-11-19 | Meigs | Ohio | 39105 | 2961 | 57 |
1918453 | 1918453 | 2021-11-15 | Spencer | Kentucky | 21215 | 2961 | 35 |
1920167 | 1920167 | 2021-11-15 | Robertson | Texas | 48395 | 2961 | 66 |
1916917 | 1916917 | 2021-11-14 | Robertson | Texas | 48395 | 2961 | 66 |
1913667 | 1913667 | 2021-11-13 | Robertson | Texas | 48395 | 2961 | 66 |
1910417 | 1910417 | 2021-11-12 | Robertson | Texas | 48395 | 2961 | 66 |
1904816 | 1904816 | 2021-11-11 | Jeff Davis | Georgia | 13161 | 2961 | 60 |
1901566 | 1901566 | 2021-11-10 | Jeff Davis | Georgia | 13161 | 2961 | 60 |
1898316 | 1898316 | 2021-11-09 | Jeff Davis | Georgia | 13161 | 2961 | 60 |
1901076 | 1901076 | 2021-11-09 | Carbon | Wyoming | 56007 | 2961 | 40 |
1875404 | 1875404 | 2021-11-02 | Teller | Colorado | 8119 | 2961 | 34 |
1877867 | 1877867 | 2021-11-02 | Lee | Texas | 48287 | 2961 | 51 |
1853119 | 1853119 | 2021-10-26 | Orange | Indiana | 18117 | 2961 | 69 |
1849596 | 1849596 | 2021-10-25 | Meriwether | Georgia | 13199 | 2961 | 110 |
1842736 | 1842736 | 2021-10-23 | Cross | Arkansas | 5037 | 2961 | 64 |
1816781 | 1816781 | 2021-10-15 | Polk | Arkansas | 5113 | 2961 | 108 |
1797151 | 1797151 | 2021-10-09 | Hale | Alabama | 1065 | 2961 | 86 |
1784133 | 1784133 | 2021-10-05 | Cherokee | Alabama | 1019 | 2961 | 57 |
1779373 | 1779373 | 2021-10-03 | Saunders | Nebraska | 31155 | 2961 | 20 |
1776123 | 1776123 | 2021-10-02 | Saunders | Nebraska | 31155 | 2961 | 20 |
1772873 | 1772873 | 2021-10-01 | Saunders | Nebraska | 31155 | 2961 | 20 |
1760051 | 1760051 | 2021-09-27 | Caswell | North Carolina | 37033 | 2961 | 34 |
1751736 | 1751736 | 2021-09-25 | La Paz | Arizona | 4012 | 2961 | 86 |
1735421 | 1735421 | 2021-09-20 | Henry | Alabama | 1067 | 2961 | 56 |
1737755 | 1737755 | 2021-09-20 | Humacao | Puerto Rico | 72069 | 2961 | |
1733242 | 1733242 | 2021-09-19 | Rowan | Kentucky | 21205 | 2961 | 25 |
1729992 | 1729992 | 2021-09-18 | Rowan | Kentucky | 21205 | 2961 | 25 |
1726742 | 1726742 | 2021-09-17 | Rowan | Kentucky | 21205 | 2961 | 25 |
1728763 | 1728763 | 2021-09-17 | Mason | West Virginia | 54053 | 2961 | 45 |
1725505 | 1725505 | 2021-09-16 | Jackson | West Virginia | 54035 | 2961 | 65 |
1719194 | 1719194 | 2021-09-15 | Pickens | Alabama | 1107 | 2961 | 66 |
1714978 | 1714978 | 2021-09-13 | Aguadilla | Puerto Rico | 72005 | 2961 | |
1701599 | 1701599 | 2021-09-09 | Greene | North Carolina | 37079 | 2961 | 50 |
1691872 | 1691872 | 2021-09-06 | Martin | North Carolina | 37117 | 2961 | 53 |
1688622 | 1688622 | 2021-09-05 | Martin | North Carolina | 37117 | 2961 | 53 |
1685372 | 1685372 | 2021-09-04 | Martin | North Carolina | 37117 | 2961 | 53 |
1682121 | 1682121 | 2021-09-03 | Martin | North Carolina | 37117 | 2961 | 53 |
1677810 | 1677810 | 2021-09-02 | Barton | Kansas | 20009 | 2961 | 51 |
1674563 | 1674563 | 2021-09-01 | Barton | Kansas | 20009 | 2961 | 51 |
1675749 | 1675749 | 2021-09-01 | Gallia | Ohio | 39053 | 2961 | 53 |
1642508 | 1642508 | 2021-08-22 | Wexford | Michigan | 26165 | 2961 | 48 |
1639258 | 1639258 | 2021-08-21 | Wexford | Michigan | 26165 | 2961 | 48 |
1636008 | 1636008 | 2021-08-20 | Wexford | Michigan | 26165 | 2961 | 48 |
1631595 | 1631595 | 2021-08-19 | Ouachita | Arkansas | 5103 | 2961 | 67 |
1626275 | 1626275 | 2021-08-17 | Cass | Minnesota | 27021 | 2961 | 33 |
1618907 | 1618907 | 2021-08-15 | Harris | Georgia | 13145 | 2961 | 66 |
1615659 | 1615659 | 2021-08-14 | Harris | Georgia | 13145 | 2961 | 66 |
1612410 | 1612410 | 2021-08-13 | Harris | Georgia | 13145 | 2961 | 66 |
1608563 | 1608563 | 2021-08-11 | Greenbrier | West Virginia | 54025 | 2961 | 66 |
1605261 | 1605261 | 2021-08-10 | Wythe | Virginia | 51197 | 2961 | 82 |
1599445 | 1599445 | 2021-08-09 | Monroe | Georgia | 13207 | 2961 | 106 |
1566532 | 1566532 | 2021-07-30 | Winston | Alabama | 1133 | 2961 | 73 |
1563284 | 1563284 | 2021-07-29 | Winston | Alabama | 1133 | 2961 | 73 |
1537656 | 1537656 | 2021-07-21 | Chattooga | Georgia | 13055 | 2961 | 76 |
1512309 | 1512309 | 2021-07-13 | Harlan | Kentucky | 21095 | 2961 | 91 |
1508734 | 1508734 | 2021-07-12 | Decatur | Indiana | 18031 | 2961 | 96 |
1494587 | 1494587 | 2021-07-07 | Palo Pinto | Texas | 48363 | 2961 | 76 |
1491340 | 1491340 | 2021-07-06 | Palo Pinto | Texas | 48363 | 2961 | 76 |
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);