ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 4581 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 22
- Ohio 11
- Tennessee 10
- Mississippi 9
- Michigan 8
- New Mexico 8
- Georgia 7
- Texas 5
- Wisconsin 5
- Alabama 4
- California 4
- Illinois 4
- Louisiana 4
- Virginia 4
- Minnesota 3
- Pennsylvania 3
- Iowa 2
- Kentucky 2
- North Carolina 2
- Utah 2
- Alaska 1
- Arkansas 1
- Maine 1
- Massachusetts 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- New York 1
- North Dakota 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493092 | 2493092 | 2022-05-11 | Henry | Alabama | 1067 | 4581 | 76 |
2466960 | 2466960 | 2022-05-02 | Sawyer | Wisconsin | 55113 | 4581 | 62 |
2338063 | 2338063 | 2022-03-24 | Cheboygan | Michigan | 26031 | 4581 | 102 |
2334809 | 2334809 | 2022-03-23 | Cheboygan | Michigan | 26031 | 4581 | 102 |
2325050 | 2325050 | 2022-03-20 | Cheboygan | Michigan | 26031 | 4581 | 102 |
2321796 | 2321796 | 2022-03-19 | Cheboygan | Michigan | 26031 | 4581 | 102 |
2318542 | 2318542 | 2022-03-18 | Cheboygan | Michigan | 26031 | 4581 | 102 |
2293382 | 2293382 | 2022-03-10 | Meigs | Ohio | 39105 | 4581 | 80 |
2282120 | 2282120 | 2022-03-07 | Cass | Illinois | 17017 | 4581 | 44 |
2254368 | 2254368 | 2022-02-26 | Paulding | Ohio | 39125 | 4581 | 71 |
2222527 | 2222527 | 2022-02-16 | Montague | Texas | 48337 | 4581 | 120 |
2198971 | 2198971 | 2022-02-09 | Yancey | North Carolina | 37199 | 4581 | 49 |
2190887 | 2190887 | 2022-02-07 | Crisp | Georgia | 13081 | 4581 | 129 |
2193159 | 2193159 | 2022-02-07 | Fayette | Texas | 48149 | 4581 | 98 |
2145964 | 2145964 | 2022-01-24 | Hart | Kentucky | 21099 | 4581 | 85 |
2106339 | 2106339 | 2022-01-12 | Haralson | Georgia | 13143 | 4581 | 137 |
2105071 | 2105071 | 2022-01-11 | Jasper | South Carolina | 45053 | 4581 | 82 |
2105176 | 2105176 | 2022-01-11 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2101925 | 2101925 | 2022-01-10 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2102557 | 2102557 | 2022-01-10 | Jackson | Wisconsin | 55053 | 4581 | 40 |
2098674 | 2098674 | 2022-01-09 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2095422 | 2095422 | 2022-01-08 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2092170 | 2092170 | 2022-01-07 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2088918 | 2088918 | 2022-01-06 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2084942 | 2084942 | 2022-01-05 | Grant | New Mexico | 35017 | 4581 | 65 |
2085667 | 2085667 | 2022-01-05 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2082415 | 2082415 | 2022-01-04 | DeKalb | Tennessee | 47041 | 4581 | 87 |
2036148 | 2036148 | 2021-12-21 | Coos | New Hampshire | 33007 | 4581 | 82 |
2027347 | 2027347 | 2021-12-18 | Hockley | Texas | 48219 | 4581 | 139 |
1983782 | 1983782 | 2021-12-05 | Copiah | Mississippi | 28029 | 4581 | 95 |
1980532 | 1980532 | 2021-12-04 | Copiah | Mississippi | 28029 | 4581 | 95 |
1977282 | 1977282 | 2021-12-03 | Copiah | Mississippi | 28029 | 4581 | 95 |
1968426 | 1968426 | 2021-11-30 | Susquehanna | Pennsylvania | 42115 | 4581 | 76 |
1939835 | 1939835 | 2021-11-21 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1936585 | 1936585 | 2021-11-20 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1933335 | 1933335 | 2021-11-19 | Isle of Wight | Virginia | 51093 | 4581 | 91 |
1915912 | 1915912 | 2021-11-14 | Cibola | New Mexico | 35006 | 4581 | 145 |
1916180 | 1916180 | 2021-11-14 | Fayette | Ohio | 39047 | 4581 | 67 |
1912662 | 1912662 | 2021-11-13 | Cibola | New Mexico | 35006 | 4581 | 145 |
1909412 | 1909412 | 2021-11-12 | Cibola | New Mexico | 35006 | 4581 | 145 |
1899184 | 1899184 | 2021-11-09 | Cass | Minnesota | 27021 | 4581 | 47 |
1841477 | 1841477 | 2021-10-22 | Morrow | Ohio | 39117 | 4581 | 58 |
1823345 | 1823345 | 2021-10-17 | Siskiyou | California | 6093 | 4581 | 59 |
1820096 | 1820096 | 2021-10-16 | Siskiyou | California | 6093 | 4581 | 59 |
1816847 | 1816847 | 2021-10-15 | Siskiyou | California | 6093 | 4581 | 59 |
1805453 | 1805453 | 2021-10-11 | Rio Arriba | New Mexico | 35039 | 4581 | 83 |
1802204 | 1802204 | 2021-10-10 | Rio Arriba | New Mexico | 35039 | 4581 | 83 |
1798955 | 1798955 | 2021-10-09 | Rio Arriba | New Mexico | 35039 | 4581 | 83 |
1795706 | 1795706 | 2021-10-08 | Rio Arriba | New Mexico | 35039 | 4581 | 83 |
1793784 | 1793784 | 2021-10-07 | Clark | Wisconsin | 55019 | 4581 | 73 |
1788568 | 1788568 | 2021-10-06 | Oxford | Maine | 23017 | 4581 | 74 |
1781353 | 1781353 | 2021-10-04 | Lee | Georgia | 13177 | 4581 | 76 |
1782349 | 1782349 | 2021-10-04 | Prentiss | Mississippi | 28117 | 4581 | 81 |
1742539 | 1742539 | 2021-09-22 | Lee | Illinois | 17103 | 4581 | 95 |
1739120 | 1739120 | 2021-09-21 | Lumpkin | Georgia | 13187 | 4581 | 88 |
1738509 | 1738509 | 2021-09-20 | Logan | West Virginia | 54045 | 4581 | 112 |
1722934 | 1722934 | 2021-09-16 | White | Georgia | 13311 | 4581 | 108 |
1700673 | 1700673 | 2021-09-09 | Calloway | Kentucky | 21035 | 4581 | 56 |
1695720 | 1695720 | 2021-09-07 | Hardeman | Tennessee | 47069 | 4581 | 70 |
1672612 | 1672612 | 2021-08-31 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1669364 | 1669364 | 2021-08-30 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1666117 | 1666117 | 2021-08-29 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1662255 | 1662255 | 2021-08-28 | Pulaski | Missouri | 29169 | 4581 | 62 |
1662869 | 1662869 | 2021-08-28 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1659621 | 1659621 | 2021-08-27 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1656372 | 1656372 | 2021-08-26 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1653125 | 1653125 | 2021-08-25 | McCurtain | Oklahoma | 40089 | 4581 | 95 |
1649886 | 1649886 | 2021-08-24 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1646637 | 1646637 | 2021-08-23 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1643388 | 1643388 | 2021-08-22 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1640138 | 1640138 | 2021-08-21 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1636888 | 1636888 | 2021-08-20 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1633638 | 1633638 | 2021-08-19 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1630391 | 1630391 | 2021-08-18 | Okmulgee | Oklahoma | 40111 | 4581 | 89 |
1615377 | 1615377 | 2021-08-14 | Union | Arkansas | 5139 | 4581 | 116 |
1594326 | 1594326 | 2021-08-07 | Livingston | New York | 36051 | 4581 | 60 |
1572991 | 1572991 | 2021-08-01 | Franklin | Alabama | 1059 | 4581 | 81 |
1539781 | 1539781 | 2021-07-21 | Cocke | Tennessee | 47029 | 4581 | 101 |
1500377 | 1500377 | 2021-07-09 | Knox | Ohio | 39083 | 4581 | 112 |
1495657 | 1495657 | 2021-07-08 | Franklin | Illinois | 17055 | 4581 | 90 |
1490637 | 1490637 | 2021-07-06 | Knox | Ohio | 39083 | 4581 | 112 |
1487390 | 1487390 | 2021-07-05 | Knox | Ohio | 39083 | 4581 | 112 |
1460783 | 1460783 | 2021-06-27 | Marshall | Mississippi | 28093 | 4581 | 105 |
1457538 | 1457538 | 2021-06-26 | Marshall | Mississippi | 28093 | 4581 | 105 |
1454293 | 1454293 | 2021-06-25 | Marshall | Mississippi | 28093 | 4581 | 105 |
1446039 | 1446039 | 2021-06-22 | Campbell | Virginia | 51031 | 4581 | 87 |
1378579 | 1378579 | 2021-06-02 | Baldwin | Georgia | 13009 | 4581 | 132 |
1372844 | 1372844 | 2021-05-31 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1369599 | 1369599 | 2021-05-30 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1366353 | 1366353 | 2021-05-29 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1363107 | 1363107 | 2021-05-28 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1347136 | 1347136 | 2021-05-23 | Winona | Minnesota | 27169 | 4581 | 50 |
1311475 | 1311475 | 2021-05-12 | Panola | Mississippi | 28107 | 4581 | 107 |
1270277 | 1270277 | 2021-04-29 | Codington | South Dakota | 46029 | 4581 | 81 |
1210601 | 1210601 | 2021-04-11 | Barry | Michigan | 26015 | 4581 | 53 |
1207352 | 1207352 | 2021-04-10 | Barry | Michigan | 26015 | 4581 | 53 |
1195318 | 1195318 | 2021-04-06 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1192070 | 1192070 | 2021-04-05 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1188821 | 1188821 | 2021-04-04 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1185574 | 1185574 | 2021-04-03 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
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);