ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 20
- Iowa 15
- Texas 14
- Indiana 12
- Virginia 12
- Missouri 11
- Arkansas 10
- Puerto Rico 10
- Illinois 9
- Kentucky 6
- Louisiana 6
- Ohio 6
- Tennessee 6
- Wisconsin 6
- Alabama 5
- Florida 5
- Georgia 5
- Minnesota 5
- Montana 5
- Vermont 5
- North Carolina 4
- South Dakota 4
- West Virginia 4
- Maryland 3
- Nevada 3
- North Dakota 3
- Pennsylvania 3
- Utah 3
- Arizona 2
- Hawaii 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426052 | 2426052 | 2022-04-20 | Murray | Minnesota | 27101 | 2029 | 16 |
2396814 | 2396814 | 2022-04-11 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2393559 | 2393559 | 2022-04-10 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2390303 | 2390303 | 2022-04-09 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2387047 | 2387047 | 2022-04-08 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2383792 | 2383792 | 2022-04-07 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2380537 | 2380537 | 2022-04-06 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2377282 | 2377282 | 2022-04-05 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2374030 | 2374030 | 2022-04-04 | Humphreys | Mississippi | 28053 | 2029 | 45 |
2285603 | 2285603 | 2022-03-08 | Howard | Iowa | 19089 | 2029 | 31 |
2282351 | 2282351 | 2022-03-07 | Howard | Iowa | 19089 | 2029 | 31 |
2279098 | 2279098 | 2022-03-06 | Howard | Iowa | 19089 | 2029 | 31 |
2280747 | 2280747 | 2022-03-06 | Grant | South Dakota | 46051 | 2029 | 50 |
2275845 | 2275845 | 2022-03-05 | Howard | Iowa | 19089 | 2029 | 31 |
2277494 | 2277494 | 2022-03-05 | Grant | South Dakota | 46051 | 2029 | 50 |
2272592 | 2272592 | 2022-03-04 | Howard | Iowa | 19089 | 2029 | 31 |
2274241 | 2274241 | 2022-03-04 | Grant | South Dakota | 46051 | 2029 | 50 |
2269340 | 2269340 | 2022-03-03 | Howard | Iowa | 19089 | 2029 | 31 |
2270988 | 2270988 | 2022-03-03 | Grant | South Dakota | 46051 | 2029 | 50 |
2266087 | 2266087 | 2022-03-02 | Howard | Iowa | 19089 | 2029 | 31 |
2241903 | 2241903 | 2022-02-22 | Clay | Texas | 48077 | 2029 | 31 |
2219592 | 2219592 | 2022-02-15 | Gilmer | West Virginia | 54021 | 2029 | 18 |
2216342 | 2216342 | 2022-02-14 | Gilmer | West Virginia | 54021 | 2029 | 17 |
2191470 | 2191470 | 2022-02-07 | Bracken | Kentucky | 21023 | 2029 | 23 |
2192879 | 2192879 | 2022-02-07 | Allendale | South Carolina | 45005 | 2029 | 23 |
2183538 | 2183538 | 2022-02-04 | Somervell | Texas | 48425 | 2029 | 31 |
2175308 | 2175308 | 2022-02-02 | Trimble | Kentucky | 21223 | 2029 | 34 |
2170692 | 2170692 | 2022-01-31 | Lunenburg | Virginia | 51111 | 2029 | 24 |
2163956 | 2163956 | 2022-01-29 | Live Oak | Texas | 48297 | 2029 | 40 |
2159492 | 2159492 | 2022-01-28 | Monroe | Missouri | 29137 | 2029 | 38 |
2155425 | 2155425 | 2022-01-27 | Martin | Indiana | 18101 | 2029 | 23 |
2075758 | 2075758 | 2022-01-02 | Salinas | Puerto Rico | 72123 | 2029 | |
2052268 | 2052268 | 2021-12-26 | Richland | Montana | 30083 | 2029 | 30 |
2052757 | 2052757 | 2021-12-26 | Vinton | Ohio | 39163 | 2029 | 43 |
2049018 | 2049018 | 2021-12-25 | Richland | Montana | 30083 | 2029 | 30 |
2045768 | 2045768 | 2021-12-24 | Richland | Montana | 30083 | 2029 | 30 |
2042518 | 2042518 | 2021-12-23 | Richland | Montana | 30083 | 2029 | 30 |
2039962 | 2039962 | 2021-12-22 | Catano | Puerto Rico | 72033 | 2029 | |
2014472 | 2014472 | 2021-12-14 | Ward | Texas | 48475 | 2029 | 35 |
2014503 | 2014503 | 2021-12-14 | Morgan | Utah | 49029 | 2029 | 13 |
1988179 | 1988179 | 2021-12-06 | Lake | Tennessee | 47095 | 2029 | 31 |
1979218 | 1979218 | 2021-12-04 | Bradley | Arkansas | 5011 | 2029 | 41 |
1944645 | 1944645 | 2021-11-23 | Missaukee | Michigan | 26113 | 2029 | 41 |
1941394 | 1941394 | 2021-11-22 | Missaukee | Michigan | 26113 | 2029 | 41 |
1927212 | 1927212 | 2021-11-18 | Chicot | Arkansas | 5017 | 2029 | 47 |
1923962 | 1923962 | 2021-11-17 | Chicot | Arkansas | 5017 | 2029 | 47 |
1920713 | 1920713 | 2021-11-16 | Chicot | Arkansas | 5017 | 2029 | 47 |
1917463 | 1917463 | 2021-11-15 | Chicot | Arkansas | 5017 | 2029 | 47 |
1903753 | 1903753 | 2021-11-10 | Camp | Texas | 48063 | 2029 | 67 |
1900503 | 1900503 | 2021-11-09 | Camp | Texas | 48063 | 2029 | 67 |
1895305 | 1895305 | 2021-11-08 | Blackford | Indiana | 18009 | 2029 | 45 |
1859793 | 1859793 | 2021-10-28 | Jackson | Kansas | 20085 | 2029 | 19 |
1856544 | 1856544 | 2021-10-27 | Jackson | Kansas | 20085 | 2029 | 19 |
1858624 | 1858624 | 2021-10-27 | Patrick | Virginia | 51141 | 2029 | 55 |
1854705 | 1854705 | 2021-10-26 | Cayey | Puerto Rico | 72035 | 2029 | |
1851456 | 1851456 | 2021-10-25 | Cayey | Puerto Rico | 72035 | 2029 | |
1847350 | 1847350 | 2021-10-24 | Webster | Mississippi | 28155 | 2029 | 46 |
1848206 | 1848206 | 2021-10-24 | Cayey | Puerto Rico | 72035 | 2029 | |
1844100 | 1844100 | 2021-10-23 | Webster | Mississippi | 28155 | 2029 | 46 |
1840850 | 1840850 | 2021-10-22 | Webster | Mississippi | 28155 | 2029 | 46 |
1813219 | 1813219 | 2021-10-13 | Braxton | West Virginia | 54007 | 2029 | 15 |
1809798 | 1809798 | 2021-10-12 | Alleghany | Virginia | 51005 | 2029 | 63 |
1804237 | 1804237 | 2021-10-11 | De Witt | Illinois | 17039 | 2029 | 37 |
1800988 | 1800988 | 2021-10-10 | De Witt | Illinois | 17039 | 2029 | 37 |
1797739 | 1797739 | 2021-10-09 | De Witt | Illinois | 17039 | 2029 | 37 |
1794490 | 1794490 | 2021-10-08 | De Witt | Illinois | 17039 | 2029 | 37 |
1785595 | 1785595 | 2021-10-05 | Perry | Mississippi | 28111 | 2029 | 54 |
1735943 | 1735943 | 2021-09-20 | Kauai | Hawaii | 15007 | 2029 | 8 |
1717451 | 1717451 | 2021-09-14 | Macon | Missouri | 29121 | 2029 | 19 |
1707685 | 1707685 | 2021-09-11 | Gasconade | Missouri | 29073 | 2029 | 48 |
1698403 | 1698403 | 2021-09-08 | Warren | North Carolina | 37185 | 2029 | 20 |
1695155 | 1695155 | 2021-09-07 | Warren | North Carolina | 37185 | 2029 | 20 |
1679537 | 1679537 | 2021-09-02 | Aransas | Texas | 48007 | 2029 | 50 |
1671909 | 1671909 | 2021-08-31 | Yalobusha | Mississippi | 28161 | 2029 | 45 |
1673267 | 1673267 | 2021-08-31 | Tyler | Texas | 48457 | 2029 | 53 |
1670048 | 1670048 | 2021-08-30 | Carbon | Utah | 49007 | 2029 | 20 |
1634402 | 1634402 | 2021-08-19 | Fluvanna | Virginia | 51065 | 2029 | 21 |
1629235 | 1629235 | 2021-08-18 | Harrison | Kentucky | 21097 | 2029 | 27 |
1625805 | 1625805 | 2021-08-17 | O'Brien | Iowa | 19141 | 2029 | 61 |
1622558 | 1622558 | 2021-08-16 | O'Brien | Iowa | 19141 | 2029 | 61 |
1624823 | 1624823 | 2021-08-16 | Nicholas | West Virginia | 54067 | 2029 | 25 |
1619311 | 1619311 | 2021-08-15 | O'Brien | Iowa | 19141 | 2029 | 61 |
1616063 | 1616063 | 2021-08-14 | O'Brien | Iowa | 19141 | 2029 | 61 |
1612814 | 1612814 | 2021-08-13 | O'Brien | Iowa | 19141 | 2029 | 61 |
1609566 | 1609566 | 2021-08-12 | O'Brien | Iowa | 19141 | 2029 | 61 |
1606317 | 1606317 | 2021-08-11 | O'Brien | Iowa | 19141 | 2029 | 61 |
1606806 | 1606806 | 2021-08-11 | Hubbard | Minnesota | 27057 | 2029 | 41 |
1608066 | 1608066 | 2021-08-11 | Union | Tennessee | 47173 | 2029 | 34 |
1588765 | 1588765 | 2021-08-05 | Panola | Texas | 48365 | 2029 | 78 |
1568863 | 1568863 | 2021-07-30 | San Sebastian | Puerto Rico | 72131 | 2029 | |
1555517 | 1555517 | 2021-07-26 | Richland | North Dakota | 38077 | 2029 | 17 |
1539471 | 1539471 | 2021-07-21 | Columbia | Oregon | 41009 | 2029 | 32 |
1520970 | 1520970 | 2021-07-15 | Vernon | Wisconsin | 55123 | 2029 | 43 |
1517340 | 1517340 | 2021-07-14 | Shelby | Texas | 48419 | 2029 | 72 |
1517722 | 1517722 | 2021-07-14 | Vernon | Wisconsin | 55123 | 2029 | 43 |
1514093 | 1514093 | 2021-07-13 | Shelby | Texas | 48419 | 2029 | 72 |
1486030 | 1486030 | 2021-07-05 | Jay | Indiana | 18075 | 2029 | 35 |
1482784 | 1482784 | 2021-07-04 | Jay | Indiana | 18075 | 2029 | 35 |
1485038 | 1485038 | 2021-07-04 | Louisa | Virginia | 51109 | 2029 | 34 |
1479537 | 1479537 | 2021-07-03 | Jay | Indiana | 18075 | 2029 | 35 |
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);