ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where cases = 3220 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Iowa 14
- Georgia 11
- Arkansas 10
- Illinois 8
- Ohio 8
- Virginia 8
- Louisiana 7
- North Dakota 7
- Michigan 6
- Minnesota 6
- Missouri 5
- South Carolina 5
- Wyoming 5
- Indiana 4
- Mississippi 4
- North Carolina 4
- Wisconsin 4
- Florida 3
- Kentucky 3
- New Mexico 3
- New York 3
- Oregon 3
- Pennsylvania 3
- Washington 3
- West Virginia 3
- Colorado 2
- Idaho 2
- Puerto Rico 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501704 | 2501704 | 2022-05-13 | Noble | Ohio | 39121 | 3220 | 58 |
2498446 | 2498446 | 2022-05-12 | Noble | Ohio | 39121 | 3220 | 58 |
2475748 | 2475748 | 2022-05-05 | Baker | Oregon | 41001 | 3220 | 48 |
2422225 | 2422225 | 2022-04-19 | Butler | Iowa | 19023 | 3220 | 53 |
2418969 | 2418969 | 2022-04-18 | Butler | Iowa | 19023 | 3220 | 53 |
2415713 | 2415713 | 2022-04-17 | Butler | Iowa | 19023 | 3220 | 53 |
2412457 | 2412457 | 2022-04-16 | Butler | Iowa | 19023 | 3220 | 53 |
2409201 | 2409201 | 2022-04-15 | Butler | Iowa | 19023 | 3220 | 53 |
2405945 | 2405945 | 2022-04-14 | Butler | Iowa | 19023 | 3220 | 53 |
2402689 | 2402689 | 2022-04-13 | Butler | Iowa | 19023 | 3220 | 53 |
2399435 | 2399435 | 2022-04-12 | Butler | Iowa | 19023 | 3220 | 53 |
2396179 | 2396179 | 2022-04-11 | Butler | Iowa | 19023 | 3220 | 53 |
2396716 | 2396716 | 2022-04-11 | Cottonwood | Minnesota | 27033 | 3220 | 41 |
2392924 | 2392924 | 2022-04-10 | Butler | Iowa | 19023 | 3220 | 53 |
2389668 | 2389668 | 2022-04-09 | Butler | Iowa | 19023 | 3220 | 53 |
2386412 | 2386412 | 2022-04-08 | Butler | Iowa | 19023 | 3220 | 53 |
2382848 | 2382848 | 2022-04-07 | Oglethorpe | Georgia | 13221 | 3220 | 55 |
2383158 | 2383158 | 2022-04-07 | Butler | Iowa | 19023 | 3220 | 53 |
2379903 | 2379903 | 2022-04-06 | Butler | Iowa | 19023 | 3220 | 53 |
2333981 | 2333981 | 2022-03-23 | Dade | Georgia | 13083 | 3220 | 28 |
2313785 | 2313785 | 2022-03-16 | Martinsville city | Virginia | 51690 | 3220 | 114 |
2309562 | 2309562 | 2022-03-15 | Mountrail | North Dakota | 38061 | 3220 | 36 |
2306309 | 2306309 | 2022-03-14 | Mountrail | North Dakota | 38061 | 3220 | 36 |
2303058 | 2303058 | 2022-03-13 | Mountrail | North Dakota | 38061 | 3220 | 36 |
2296554 | 2296554 | 2022-03-11 | Mountrail | North Dakota | 38061 | 3220 | 36 |
2293672 | 2293672 | 2022-03-10 | Utuado | Puerto Rico | 72141 | 3220 | |
2284669 | 2284669 | 2022-03-07 | Bayfield | Wisconsin | 55007 | 3220 | 38 |
2267993 | 2267993 | 2022-03-02 | Jackson | Texas | 48239 | 3220 | 59 |
2258895 | 2258895 | 2022-02-28 | Little River | Arkansas | 5081 | 3220 | 87 |
2241204 | 2241204 | 2022-02-22 | Mitchell | North Carolina | 37121 | 3220 | 33 |
2238108 | 2238108 | 2022-02-21 | Morgan | Ohio | 39115 | 3220 | 52 |
2239193 | 2239193 | 2022-02-21 | Price | Wisconsin | 55099 | 3220 | 28 |
2234768 | 2234768 | 2022-02-20 | McKenzie | North Dakota | 38053 | 3220 | 25 |
2222424 | 2222424 | 2022-02-16 | Duval | Texas | 48131 | 3220 | 67 |
2195245 | 2195245 | 2022-02-08 | Gasconade | Missouri | 29073 | 3220 | 93 |
2189260 | 2189260 | 2022-02-06 | Walsh | North Dakota | 38099 | 3220 | 34 |
2186007 | 2186007 | 2022-02-05 | Walsh | North Dakota | 38099 | 3220 | 34 |
2171561 | 2171561 | 2022-02-01 | Cumberland | Illinois | 17035 | 3220 | 48 |
2166326 | 2166326 | 2022-01-30 | Schuyler | New York | 36097 | 3220 | 23 |
2157306 | 2157306 | 2022-01-27 | Bandera | Texas | 48019 | 3220 | 67 |
2144655 | 2144655 | 2022-01-23 | King William | Virginia | 51101 | 3220 | 27 |
2141400 | 2141400 | 2022-01-22 | King William | Virginia | 51101 | 3220 | 27 |
2138144 | 2138144 | 2022-01-21 | King William | Virginia | 51101 | 3220 | 27 |
2131623 | 2131623 | 2022-01-19 | Goochland | Virginia | 51075 | 3220 | 36 |
2114718 | 2114718 | 2022-01-14 | Aguas Buenas | Puerto Rico | 72007 | 3220 | |
2095557 | 2095557 | 2022-01-08 | DeWitt | Texas | 48123 | 3220 | 86 |
2058635 | 2058635 | 2021-12-28 | Cooper | Missouri | 29053 | 3220 | 58 |
2035858 | 2035858 | 2021-12-21 | Winston | Mississippi | 28159 | 3220 | 92 |
2016060 | 2016060 | 2021-12-15 | Waldo | Maine | 23027 | 3220 | 36 |
2008534 | 2008534 | 2021-12-13 | Sharp | Arkansas | 5135 | 3220 | 75 |
2010196 | 2010196 | 2021-12-13 | San Miguel | New Mexico | 35047 | 3220 | 31 |
1996853 | 1996853 | 2021-12-09 | Andrew | Missouri | 29003 | 3220 | 40 |
1960298 | 1960298 | 2021-11-28 | Wayne | Illinois | 17191 | 3220 | 66 |
1957047 | 1957047 | 2021-11-27 | Wayne | Illinois | 17191 | 3220 | 66 |
1953796 | 1953796 | 2021-11-26 | Wayne | Illinois | 17191 | 3220 | 66 |
1950545 | 1950545 | 2021-11-25 | Wayne | Illinois | 17191 | 3220 | 66 |
1947294 | 1947294 | 2021-11-24 | Wayne | Illinois | 17191 | 3220 | 66 |
1944604 | 1944604 | 2021-11-23 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1941353 | 1941353 | 2021-11-22 | Cheboygan | Michigan | 26031 | 3220 | 72 |
1926676 | 1926676 | 2021-11-17 | Scurry | Texas | 48415 | 3220 | 83 |
1926947 | 1926947 | 2021-11-17 | Brooke | West Virginia | 54009 | 3220 | 75 |
1921185 | 1921185 | 2021-11-16 | Minidoka | Idaho | 16067 | 3220 | 49 |
1923426 | 1923426 | 2021-11-16 | Scurry | Texas | 48415 | 3220 | 83 |
1920177 | 1920177 | 2021-11-15 | Scurry | Texas | 48415 | 3220 | 82 |
1920263 | 1920263 | 2021-11-15 | Orleans | Vermont | 50019 | 3220 | 20 |
1916927 | 1916927 | 2021-11-14 | Scurry | Texas | 48415 | 3220 | 82 |
1913677 | 1913677 | 2021-11-13 | Scurry | Texas | 48415 | 3220 | 82 |
1901260 | 1901260 | 2021-11-10 | Phillips | Arkansas | 5107 | 3220 | 77 |
1878450 | 1878450 | 2021-11-03 | La Paz | Arizona | 4012 | 3220 | 99 |
1869737 | 1869737 | 2021-10-31 | Concordia | Louisiana | 22029 | 3220 | 79 |
1871661 | 1871661 | 2021-10-31 | Adams | Washington | 53001 | 3220 | 32 |
1866488 | 1866488 | 2021-10-30 | Concordia | Louisiana | 22029 | 3220 | 79 |
1868412 | 1868412 | 2021-10-30 | Adams | Washington | 53001 | 3220 | 32 |
1863239 | 1863239 | 2021-10-29 | Concordia | Louisiana | 22029 | 3220 | 79 |
1865163 | 1865163 | 2021-10-29 | Adams | Washington | 53001 | 3220 | 32 |
1839477 | 1839477 | 2021-10-22 | Clark | Arkansas | 5019 | 3220 | 55 |
1827411 | 1827411 | 2021-10-18 | Harrison | Kentucky | 21097 | 3220 | 36 |
1810265 | 1810265 | 2021-10-13 | Lawrence | Arkansas | 5075 | 3220 | 55 |
1803906 | 1803906 | 2021-10-11 | Morgan | Colorado | 8087 | 3220 | 98 |
1802804 | 1802804 | 2021-10-10 | Fairfield | South Carolina | 45039 | 3220 | 94 |
1799555 | 1799555 | 2021-10-09 | Fairfield | South Carolina | 45039 | 3220 | 94 |
1796306 | 1796306 | 2021-10-08 | Fairfield | South Carolina | 45039 | 3220 | 94 |
1746818 | 1746818 | 2021-09-23 | Cass | Nebraska | 31025 | 3220 | 18 |
1734237 | 1734237 | 2021-09-19 | Holmes | Ohio | 39075 | 3220 | 108 |
1725762 | 1725762 | 2021-09-17 | Columbia | Arkansas | 5027 | 3220 | 65 |
1708439 | 1708439 | 2021-09-11 | Elk | Pennsylvania | 42047 | 3220 | 44 |
1677482 | 1677482 | 2021-09-02 | Cassia | Idaho | 16031 | 3220 | 29 |
1660122 | 1660122 | 2021-08-27 | Fayette | Texas | 48149 | 3220 | 76 |
1656919 | 1656919 | 2021-08-26 | Jasper | Texas | 48241 | 3220 | 102 |
1653672 | 1653672 | 2021-08-25 | Jasper | Texas | 48241 | 3220 | 101 |
1646933 | 1646933 | 2021-08-23 | Lawrence | South Dakota | 46081 | 3220 | 50 |
1642516 | 1642516 | 2021-08-22 | Brown | Minnesota | 27015 | 3220 | 40 |
1644423 | 1644423 | 2021-08-22 | Park | Wyoming | 56029 | 3220 | 35 |
1639266 | 1639266 | 2021-08-21 | Brown | Minnesota | 27015 | 3220 | 40 |
1641173 | 1641173 | 2021-08-21 | Park | Wyoming | 56029 | 3220 | 35 |
1636016 | 1636016 | 2021-08-20 | Brown | Minnesota | 27015 | 3220 | 40 |
1637923 | 1637923 | 2021-08-20 | Park | Wyoming | 56029 | 3220 | 35 |
1631925 | 1631925 | 2021-08-19 | Monroe | Georgia | 13207 | 3220 | 109 |
1564695 | 1564695 | 2021-07-29 | Simpson | Mississippi | 28127 | 3220 | 90 |
1559156 | 1559156 | 2021-07-27 | Edgefield | South Carolina | 45037 | 3220 | 43 |
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);