ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where cases = 2116 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 28
- Arkansas 17
- Georgia 16
- Virginia 13
- Iowa 12
- Missouri 12
- Kentucky 11
- Minnesota 11
- Kansas 10
- Illinois 9
- Indiana 9
- North Carolina 9
- Florida 8
- Oklahoma 8
- Michigan 7
- Puerto Rico 7
- Alabama 5
- Colorado 5
- Montana 5
- South Carolina 5
- Tennessee 5
- West Virginia 5
- Wisconsin 5
- South Dakota 4
- Connecticut 3
- Mississippi 3
- Ohio 3
- California 2
- Louisiana 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502420 | 2502420 | 2022-05-13 | Somervell | Texas | 48425 | 2116 | 36 |
2499162 | 2499162 | 2022-05-12 | Somervell | Texas | 48425 | 2116 | 36 |
2495904 | 2495904 | 2022-05-11 | Somervell | Texas | 48425 | 2116 | 36 |
2492646 | 2492646 | 2022-05-10 | Somervell | Texas | 48425 | 2116 | 36 |
2441126 | 2441126 | 2022-04-25 | Searcy | Arkansas | 5129 | 2116 | 48 |
2437870 | 2437870 | 2022-04-24 | Searcy | Arkansas | 5129 | 2116 | 48 |
2434614 | 2434614 | 2022-04-23 | Searcy | Arkansas | 5129 | 2116 | 48 |
2428898 | 2428898 | 2022-04-21 | Pawnee | Kansas | 20145 | 2116 | 24 |
2425642 | 2425642 | 2022-04-20 | Pawnee | Kansas | 20145 | 2116 | 24 |
2422386 | 2422386 | 2022-04-19 | Pawnee | Kansas | 20145 | 2116 | 24 |
2419130 | 2419130 | 2022-04-18 | Pawnee | Kansas | 20145 | 2116 | 24 |
2415874 | 2415874 | 2022-04-17 | Pawnee | Kansas | 20145 | 2116 | 24 |
2412618 | 2412618 | 2022-04-16 | Pawnee | Kansas | 20145 | 2116 | 24 |
2409362 | 2409362 | 2022-04-15 | Pawnee | Kansas | 20145 | 2116 | 24 |
2401001 | 2401001 | 2022-04-12 | Jayuya | Puerto Rico | 72073 | 2116 | |
2397746 | 2397746 | 2022-04-11 | Jayuya | Puerto Rico | 72073 | 2116 | |
2394491 | 2394491 | 2022-04-10 | Jayuya | Puerto Rico | 72073 | 2116 | |
2293897 | 2293897 | 2022-03-10 | Archer | Texas | 48009 | 2116 | 28 |
2279872 | 2279872 | 2022-03-06 | Beaverhead | Montana | 30001 | 2116 | 28 |
2280964 | 2280964 | 2022-03-06 | Franklin | Texas | 48159 | 2116 | 40 |
2276619 | 2276619 | 2022-03-05 | Beaverhead | Montana | 30001 | 2116 | 28 |
2273366 | 2273366 | 2022-03-04 | Beaverhead | Montana | 30001 | 2116 | 28 |
2260403 | 2260403 | 2022-02-28 | Sanders | Montana | 30089 | 2116 | 46 |
2256523 | 2256523 | 2022-02-27 | Cumberland | Kentucky | 21057 | 2116 | 28 |
2253272 | 2253272 | 2022-02-26 | Cumberland | Kentucky | 21057 | 2116 | 28 |
2250021 | 2250021 | 2022-02-25 | Cumberland | Kentucky | 21057 | 2116 | 28 |
2240773 | 2240773 | 2022-02-22 | Gentry | Missouri | 29075 | 2116 | 29 |
2224096 | 2224096 | 2022-02-17 | Trimble | Kentucky | 21223 | 2116 | 35 |
2222507 | 2222507 | 2022-02-16 | Live Oak | Texas | 48297 | 2116 | 40 |
2222747 | 2222747 | 2022-02-16 | Northampton | Virginia | 51131 | 2116 | 54 |
2218815 | 2218815 | 2022-02-15 | Adjuntas | Puerto Rico | 72001 | 2116 | |
2210138 | 2210138 | 2022-02-13 | Nevada | Arkansas | 5099 | 2116 | 43 |
2183519 | 2183519 | 2022-02-04 | Red River | Texas | 48387 | 2116 | 61 |
2164326 | 2164326 | 2022-01-29 | Ritchie | West Virginia | 54085 | 2116 | 27 |
2151861 | 2151861 | 2022-01-26 | Evans | Georgia | 13109 | 2116 | 61 |
2148641 | 2148641 | 2022-01-25 | Lanier | Georgia | 13173 | 2116 | 17 |
2113938 | 2113938 | 2022-01-14 | Linn | Missouri | 29115 | 2116 | 59 |
2110544 | 2110544 | 2022-01-13 | Yellow Medicine | Minnesota | 27173 | 2116 | 25 |
2089756 | 2089756 | 2022-01-07 | Fulton | Arkansas | 5049 | 2116 | 79 |
2083366 | 2083366 | 2022-01-05 | Archuleta | Colorado | 8007 | 2116 | 9 |
2086262 | 2086262 | 2022-01-05 | Roane | West Virginia | 54087 | 2116 | 28 |
2022950 | 2022950 | 2021-12-17 | Ripley | Missouri | 29181 | 2116 | 50 |
2019699 | 2019699 | 2021-12-16 | Ripley | Missouri | 29181 | 2116 | 50 |
1990240 | 1990240 | 2021-12-07 | Pope | Minnesota | 27121 | 2116 | 10 |
1990886 | 1990886 | 2021-12-07 | McLean | North Dakota | 38055 | 2116 | 45 |
1938183 | 1938183 | 2021-11-21 | Chippewa | Minnesota | 27023 | 2116 | 41 |
1934933 | 1934933 | 2021-11-20 | Chippewa | Minnesota | 27023 | 2116 | 41 |
1931683 | 1931683 | 2021-11-19 | Chippewa | Minnesota | 27023 | 2116 | 41 |
1927244 | 1927244 | 2021-11-18 | Little River | Arkansas | 5081 | 2116 | 80 |
1924475 | 1924475 | 2021-11-17 | Greene | Illinois | 17061 | 2116 | 53 |
1875910 | 1875910 | 2021-11-02 | Cass | Iowa | 19029 | 2116 | 59 |
1872661 | 1872661 | 2021-11-01 | Cass | Iowa | 19029 | 2116 | 59 |
1869412 | 1869412 | 2021-10-31 | Cass | Iowa | 19029 | 2116 | 59 |
1865501 | 1865501 | 2021-10-30 | Lee | Arkansas | 5077 | 2116 | 49 |
1866163 | 1866163 | 2021-10-30 | Cass | Iowa | 19029 | 2116 | 59 |
1862914 | 1862914 | 2021-10-29 | Cass | Iowa | 19029 | 2116 | 59 |
1859665 | 1859665 | 2021-10-28 | Cass | Iowa | 19029 | 2116 | 59 |
1856416 | 1856416 | 2021-10-27 | Cass | Iowa | 19029 | 2116 | 59 |
1858535 | 1858535 | 2021-10-27 | Alleghany | Virginia | 51005 | 2116 | 74 |
1850143 | 1850143 | 2021-10-25 | Fleming | Kentucky | 21069 | 2116 | 34 |
1847255 | 1847255 | 2021-10-24 | Sibley | Minnesota | 27143 | 2116 | 12 |
1844005 | 1844005 | 2021-10-23 | Sibley | Minnesota | 27143 | 2116 | 12 |
1840755 | 1840755 | 2021-10-22 | Sibley | Minnesota | 27143 | 2116 | 12 |
1827058 | 1827058 | 2021-10-18 | Washington | Illinois | 17189 | 2116 | 34 |
1823773 | 1823773 | 2021-10-17 | Mason | Illinois | 17125 | 2116 | 53 |
1820524 | 1820524 | 2021-10-16 | Mason | Illinois | 17125 | 2116 | 53 |
1817275 | 1817275 | 2021-10-15 | Mason | Illinois | 17125 | 2116 | 53 |
1811184 | 1811184 | 2021-10-13 | Leslie | Kentucky | 21131 | 2116 | 18 |
1812538 | 1812538 | 2021-10-13 | Bamberg | South Carolina | 45009 | 2116 | 63 |
1793096 | 1793096 | 2021-10-07 | Clay | South Dakota | 46027 | 2116 | 18 |
1784623 | 1784623 | 2021-10-05 | Oglethorpe | Georgia | 13221 | 2116 | 38 |
1770886 | 1770886 | 2021-09-30 | New Kent | Virginia | 51127 | 2116 | 20 |
1761624 | 1761624 | 2021-09-28 | Alamosa | Colorado | 8003 | 2116 | 42 |
1759262 | 1759262 | 2021-09-27 | Caldwell | Louisiana | 22021 | 2116 | 38 |
1760019 | 1760019 | 2021-09-27 | Schoharie | New York | 36095 | 2116 | 20 |
1757821 | 1757821 | 2021-09-26 | Bristol city | Virginia | 51520 | 2116 | 43 |
1754573 | 1754573 | 2021-09-25 | Bristol city | Virginia | 51520 | 2116 | 43 |
1751325 | 1751325 | 2021-09-24 | Bristol city | Virginia | 51520 | 2116 | 43 |
1741271 | 1741271 | 2021-09-21 | Bandera | Texas | 48019 | 2116 | 43 |
1722377 | 1722377 | 2021-09-15 | Lincoln | Wyoming | 56023 | 2116 | 14 |
1695785 | 1695785 | 2021-09-07 | Aransas | Texas | 48007 | 2116 | 52 |
1692537 | 1692537 | 2021-09-06 | Aransas | Texas | 48007 | 2116 | 51 |
1688971 | 1688971 | 2021-09-05 | Montour | Pennsylvania | 42093 | 2116 | 67 |
1689288 | 1689288 | 2021-09-05 | Aransas | Texas | 48007 | 2116 | 51 |
1675632 | 1675632 | 2021-09-01 | Northampton | North Carolina | 37131 | 2116 | 62 |
1642459 | 1642459 | 2021-08-22 | Iosco | Michigan | 26069 | 2116 | 77 |
1639209 | 1639209 | 2021-08-21 | Iosco | Michigan | 26069 | 2116 | 77 |
1635959 | 1635959 | 2021-08-20 | Iosco | Michigan | 26069 | 2116 | 77 |
1625636 | 1625636 | 2021-08-17 | Wayne | Illinois | 17191 | 2116 | 55 |
1618735 | 1618735 | 2021-08-15 | Otero | Colorado | 8089 | 2116 | 68 |
1618916 | 1618916 | 2021-08-15 | Jefferson | Georgia | 13163 | 2116 | 69 |
1619186 | 1619186 | 2021-08-15 | Jay | Indiana | 18075 | 2116 | 35 |
1615487 | 1615487 | 2021-08-14 | Otero | Colorado | 8089 | 2116 | 68 |
1615668 | 1615668 | 2021-08-14 | Jefferson | Georgia | 13163 | 2116 | 69 |
1615938 | 1615938 | 2021-08-14 | Jay | Indiana | 18075 | 2116 | 35 |
1612238 | 1612238 | 2021-08-13 | Otero | Colorado | 8089 | 2116 | 68 |
1612419 | 1612419 | 2021-08-13 | Jefferson | Georgia | 13163 | 2116 | 69 |
1612689 | 1612689 | 2021-08-13 | Jay | Indiana | 18075 | 2116 | 35 |
1614316 | 1614316 | 2021-08-13 | Isabela | Puerto Rico | 72071 | 2116 | |
1604389 | 1604389 | 2021-08-10 | Kingfisher | Oklahoma | 40073 | 2116 | 42 |
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);