ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 3865 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 16
- Texas 12
- Georgia 11
- Minnesota 10
- Alabama 8
- Kentucky 7
- Louisiana 7
- Missouri 6
- West Virginia 6
- Indiana 5
- North Carolina 5
- Ohio 5
- New Mexico 4
- Illinois 3
- Wisconsin 3
- Arkansas 2
- California 2
- Colorado 2
- Idaho 2
- Michigan 2
- Mississippi 2
- New York 2
- Pennsylvania 2
- South Carolina 2
- Virginia 2
- Washington 2
- Iowa 1
- Maine 1
- New Hampshire 1
- North Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437739 | 2437739 | 2022-04-24 | Macon | Alabama | 1087 | 3865 | 84 |
2434483 | 2434483 | 2022-04-23 | Macon | Alabama | 1087 | 3865 | 84 |
2431227 | 2431227 | 2022-04-22 | Macon | Alabama | 1087 | 3865 | 84 |
2427971 | 2427971 | 2022-04-21 | Macon | Alabama | 1087 | 3865 | 84 |
2424715 | 2424715 | 2022-04-20 | Macon | Alabama | 1087 | 3865 | 84 |
2424629 | 2424629 | 2022-04-19 | Richland | Wisconsin | 55103 | 3865 | 48 |
2421373 | 2421373 | 2022-04-18 | Richland | Wisconsin | 55103 | 3865 | 48 |
2371318 | 2371318 | 2022-04-03 | Polk | North Carolina | 37149 | 3865 | 54 |
2368065 | 2368065 | 2022-04-02 | Polk | North Carolina | 37149 | 3865 | 54 |
2364812 | 2364812 | 2022-04-01 | Polk | North Carolina | 37149 | 3865 | 54 |
2323316 | 2323316 | 2022-03-19 | Llano | Texas | 48299 | 3865 | 97 |
2320062 | 2320062 | 2022-03-18 | Llano | Texas | 48299 | 3865 | 97 |
2238967 | 2238967 | 2022-02-21 | Grayson | Virginia | 51077 | 3865 | 75 |
2183579 | 2183579 | 2022-02-04 | Zavala | Texas | 48507 | 3865 | 59 |
2171109 | 2171109 | 2022-02-01 | Polk | Arkansas | 5113 | 3865 | 131 |
2168298 | 2168298 | 2022-01-31 | Carroll | Illinois | 17015 | 3865 | 45 |
2089745 | 2089745 | 2022-01-07 | Columbia | Arkansas | 5027 | 3865 | 77 |
2084599 | 2084599 | 2022-01-05 | Stone | Mississippi | 28131 | 3865 | 67 |
2063049 | 2063049 | 2021-12-29 | Dimmit | Texas | 48127 | 3865 | 47 |
2035142 | 2035142 | 2021-12-21 | Starke | Indiana | 18149 | 3865 | 80 |
2028979 | 2028979 | 2021-12-19 | Wayne | Kentucky | 21231 | 3865 | 72 |
2025728 | 2025728 | 2021-12-18 | Wayne | Kentucky | 21231 | 3865 | 72 |
2022477 | 2022477 | 2021-12-17 | Wayne | Kentucky | 21231 | 3865 | 72 |
1996623 | 1996623 | 2021-12-09 | Gladwin | Michigan | 26051 | 3865 | 85 |
1993372 | 1993372 | 2021-12-08 | Gladwin | Michigan | 26051 | 3865 | 85 |
1982874 | 1982874 | 2021-12-05 | Tattnall | Georgia | 13267 | 3865 | 115 |
1979624 | 1979624 | 2021-12-04 | Tattnall | Georgia | 13267 | 3865 | 115 |
1976374 | 1976374 | 2021-12-03 | Tattnall | Georgia | 13267 | 3865 | 115 |
1970725 | 1970725 | 2021-12-01 | Martin | Minnesota | 27091 | 3865 | 44 |
1964438 | 1964438 | 2021-11-29 | Randolph | Missouri | 29175 | 3865 | 79 |
1959887 | 1959887 | 2021-11-28 | Montezuma | Colorado | 8083 | 3865 | 47 |
1962755 | 1962755 | 2021-11-28 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1959504 | 1959504 | 2021-11-27 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1956253 | 1956253 | 2021-11-26 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1953002 | 1953002 | 2021-11-25 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1949751 | 1949751 | 2021-11-24 | Wyoming | West Virginia | 54109 | 3865 | 67 |
1937349 | 1937349 | 2021-11-21 | Pike | Georgia | 13231 | 3865 | 70 |
1938944 | 1938944 | 2021-11-21 | Holmes | Ohio | 39075 | 3865 | 137 |
1934099 | 1934099 | 2021-11-20 | Pike | Georgia | 13231 | 3865 | 70 |
1930847 | 1930847 | 2021-11-19 | Pike | Georgia | 13231 | 3865 | 70 |
1918347 | 1918347 | 2021-11-15 | Allen | Kentucky | 21003 | 3865 | 70 |
1916688 | 1916688 | 2021-11-14 | Morgan | Tennessee | 47129 | 3865 | 49 |
1912345 | 1912345 | 2021-11-13 | Audrain | Missouri | 29007 | 3865 | 64 |
1913438 | 1913438 | 2021-11-13 | Morgan | Tennessee | 47129 | 3865 | 49 |
1910188 | 1910188 | 2021-11-12 | Morgan | Tennessee | 47129 | 3865 | 49 |
1829801 | 1829801 | 2021-10-19 | Calaveras | California | 6009 | 3865 | 80 |
1820440 | 1820440 | 2021-10-16 | Elmore | Idaho | 16039 | 3865 | 42 |
1820458 | 1820458 | 2021-10-16 | Payette | Idaho | 16075 | 3865 | 57 |
1811948 | 1811948 | 2021-10-13 | Luna | New Mexico | 35029 | 3865 | 94 |
1765804 | 1765804 | 2021-09-29 | Union | Louisiana | 22111 | 3865 | 99 |
1735907 | 1735907 | 2021-09-20 | Sumter | Georgia | 13261 | 3865 | 116 |
1736120 | 1736120 | 2021-09-20 | Greene | Indiana | 18055 | 3865 | 93 |
1733956 | 1733956 | 2021-09-19 | Cibola | New Mexico | 35006 | 3865 | 132 |
1735266 | 1735266 | 2021-09-19 | Mineral | West Virginia | 54057 | 3865 | 97 |
1730706 | 1730706 | 2021-09-18 | Cibola | New Mexico | 35006 | 3865 | 132 |
1727456 | 1727456 | 2021-09-17 | Cibola | New Mexico | 35006 | 3865 | 132 |
1723016 | 1723016 | 2021-09-16 | Fayette | Illinois | 17051 | 3865 | 59 |
1717944 | 1717944 | 2021-09-14 | Stutsman | North Dakota | 38093 | 3865 | 82 |
1667650 | 1667650 | 2021-08-30 | Lumpkin | Georgia | 13187 | 3865 | 85 |
1665421 | 1665421 | 2021-08-29 | Barry | Missouri | 29009 | 3865 | 55 |
1658618 | 1658618 | 2021-08-27 | Oxford | Maine | 23017 | 3865 | 71 |
1654610 | 1654610 | 2021-08-26 | Decatur | Georgia | 13087 | 3865 | 81 |
1647647 | 1647647 | 2021-08-23 | Trempealeau | Wisconsin | 55121 | 3865 | 49 |
1627061 | 1627061 | 2021-08-17 | Ottawa | Ohio | 39123 | 3865 | 82 |
1607900 | 1607900 | 2021-08-11 | Marion | South Carolina | 45067 | 3865 | 108 |
1595310 | 1595310 | 2021-08-07 | Upshur | Texas | 48459 | 3865 | 78 |
1586485 | 1586485 | 2021-08-05 | Toombs | Georgia | 13279 | 3865 | 121 |
1565531 | 1565531 | 2021-07-29 | Perry | Pennsylvania | 42099 | 3865 | 101 |
1543731 | 1543731 | 2021-07-22 | Teton | Wyoming | 56039 | 3865 | 11 |
1487854 | 1487854 | 2021-07-05 | Henderson | Tennessee | 47077 | 3865 | 79 |
1484607 | 1484607 | 2021-07-04 | Henderson | Tennessee | 47077 | 3865 | 79 |
1481361 | 1481361 | 2021-07-03 | Henderson | Tennessee | 47077 | 3865 | 79 |
1478114 | 1478114 | 2021-07-02 | Henderson | Tennessee | 47077 | 3865 | 79 |
1474868 | 1474868 | 2021-07-01 | Henderson | Tennessee | 47077 | 3865 | 79 |
1471622 | 1471622 | 2021-06-30 | Henderson | Tennessee | 47077 | 3865 | 79 |
1468377 | 1468377 | 2021-06-29 | Henderson | Tennessee | 47077 | 3865 | 79 |
1465132 | 1465132 | 2021-06-28 | Henderson | Tennessee | 47077 | 3865 | 79 |
1447510 | 1447510 | 2021-06-23 | St. John the Baptist | Louisiana | 22095 | 3865 | 141 |
1424950 | 1424950 | 2021-06-16 | Becker | Minnesota | 27005 | 3865 | 55 |
1421702 | 1421702 | 2021-06-15 | Becker | Minnesota | 27005 | 3865 | 55 |
1418457 | 1418457 | 2021-06-14 | Becker | Minnesota | 27005 | 3865 | 55 |
1415212 | 1415212 | 2021-06-13 | Becker | Minnesota | 27005 | 3865 | 55 |
1411966 | 1411966 | 2021-06-12 | Becker | Minnesota | 27005 | 3865 | 55 |
1408721 | 1408721 | 2021-06-11 | Becker | Minnesota | 27005 | 3865 | 55 |
1405476 | 1405476 | 2021-06-10 | Becker | Minnesota | 27005 | 3865 | 55 |
1396397 | 1396397 | 2021-06-07 | Scotland | North Carolina | 37165 | 3865 | 87 |
1383534 | 1383534 | 2021-06-03 | Logan | Ohio | 39091 | 3865 | 76 |
1350115 | 1350115 | 2021-05-24 | Iberville | Louisiana | 22047 | 3865 | 100 |
1346479 | 1346479 | 2021-05-23 | Miami | Indiana | 18103 | 3865 | 69 |
1337559 | 1337559 | 2021-05-20 | Phelps | Missouri | 29161 | 3865 | 130 |
1295559 | 1295559 | 2021-05-07 | Grafton | New Hampshire | 33009 | 3865 | 26 |
1270129 | 1270129 | 2021-04-29 | Wayne | Pennsylvania | 42127 | 3865 | 77 |
1256670 | 1256670 | 2021-04-25 | Columbia | New York | 36021 | 3865 | 100 |
1186638 | 1186638 | 2021-04-04 | Escambia | Alabama | 1053 | 3865 | 74 |
1189166 | 1189166 | 2021-04-04 | Giles | Tennessee | 47055 | 3865 | 98 |
1185919 | 1185919 | 2021-04-03 | Giles | Tennessee | 47055 | 3865 | 98 |
1182672 | 1182672 | 2021-04-02 | Giles | Tennessee | 47055 | 3865 | 98 |
1182977 | 1182977 | 2021-04-02 | Waller | Texas | 48473 | 3865 | 45 |
1179425 | 1179425 | 2021-04-01 | Giles | Tennessee | 47055 | 3865 | 98 |
1176719 | 1176719 | 2021-03-31 | Whitman | Washington | 53075 | 3865 | 46 |
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);