ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where deaths = 713 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Florida 16
- Pennsylvania 14
- Indiana 8
- Tennessee 8
- Louisiana 7
- Missouri 6
- North Carolina 6
- South Carolina 6
- Michigan 5
- California 4
- New York 4
- Texas 4
- Washington 4
- Arizona 3
- Mississippi 3
- New Jersey 3
- Ohio 3
- Alabama 2
- Arkansas 2
- Colorado 2
- Illinois 2
- District of Columbia 1
- Kansas 1
- Massachusetts 1
- Minnesota 1
- Nevada 1
- Oregon 1
- Utah 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427797 | 2427797 | 2022-04-20 | Kanawha | West Virginia | 54039 | 47169 | 713 |
2381912 | 2381912 | 2022-04-06 | Potter | Texas | 48375 | 35677 | 713 |
2355683 | 2355683 | 2022-03-29 | Sumner | Tennessee | 47165 | 53057 | 713 |
2352430 | 2352430 | 2022-03-28 | Sumner | Tennessee | 47165 | 53057 | 713 |
2349178 | 2349178 | 2022-03-27 | Sumner | Tennessee | 47165 | 53057 | 713 |
2345925 | 2345925 | 2022-03-26 | Sumner | Tennessee | 47165 | 53057 | 713 |
2342672 | 2342672 | 2022-03-25 | Sumner | Tennessee | 47165 | 53057 | 713 |
2339419 | 2339419 | 2022-03-24 | Sumner | Tennessee | 47165 | 53057 | 713 |
2336165 | 2336165 | 2022-03-23 | Sumner | Tennessee | 47165 | 53057 | 713 |
2329892 | 2329892 | 2022-03-21 | Taylor | Texas | 48441 | 33673 | 713 |
2290284 | 2290284 | 2022-03-09 | Beaver | Pennsylvania | 42007 | 39911 | 713 |
2287032 | 2287032 | 2022-03-08 | Beaver | Pennsylvania | 42007 | 39893 | 713 |
2279415 | 2279415 | 2022-03-06 | Ouachita | Louisiana | 22073 | 50351 | 713 |
2276162 | 2276162 | 2022-03-05 | Ouachita | Louisiana | 22073 | 50351 | 713 |
2272909 | 2272909 | 2022-03-04 | Ouachita | Louisiana | 22073 | 50351 | 713 |
2269657 | 2269657 | 2022-03-03 | Ouachita | Louisiana | 22073 | 50335 | 713 |
2266404 | 2266404 | 2022-03-02 | Ouachita | Louisiana | 22073 | 50292 | 713 |
2223707 | 2223707 | 2022-02-17 | Elkhart | Indiana | 18039 | 53801 | 713 |
2203321 | 2203321 | 2022-02-10 | Yakima | Washington | 53077 | 69874 | 713 |
2200067 | 2200067 | 2022-02-09 | Yakima | Washington | 53077 | 69874 | 713 |
2188644 | 2188644 | 2022-02-06 | Hinds | Mississippi | 28049 | 50531 | 713 |
2189145 | 2189145 | 2022-02-06 | Gaston | North Carolina | 37071 | 61976 | 713 |
2185391 | 2185391 | 2022-02-05 | Hinds | Mississippi | 28049 | 50531 | 713 |
2185892 | 2185892 | 2022-02-05 | Gaston | North Carolina | 37071 | 61976 | 713 |
2182139 | 2182139 | 2022-02-04 | Hinds | Mississippi | 28049 | 50531 | 713 |
2182640 | 2182640 | 2022-02-04 | Gaston | North Carolina | 37071 | 61976 | 713 |
2179388 | 2179388 | 2022-02-03 | Gaston | North Carolina | 37071 | 61700 | 713 |
2174419 | 2174419 | 2022-02-02 | San Francisco | California | 6075 | 122878 | 713 |
2177102 | 2177102 | 2022-02-02 | Utah | Utah | 49049 | 195204 | 713 |
2171267 | 2171267 | 2022-02-01 | Bay | Florida | 12005 | 42327 | 713 |
2168014 | 2168014 | 2022-01-31 | Bay | Florida | 12005 | 42327 | 713 |
2164759 | 2164759 | 2022-01-30 | Bay | Florida | 12005 | 42327 | 713 |
2161504 | 2161504 | 2022-01-29 | Bay | Florida | 12005 | 42327 | 713 |
2158248 | 2158248 | 2022-01-28 | Bay | Florida | 12005 | 42327 | 713 |
2154995 | 2154995 | 2022-01-27 | Bay | Florida | 12005 | 39904 | 713 |
2151742 | 2151742 | 2022-01-26 | Bay | Florida | 12005 | 39904 | 713 |
2138517 | 2138517 | 2022-01-22 | Benton | Arkansas | 5007 | 58617 | 713 |
2135261 | 2135261 | 2022-01-21 | Benton | Arkansas | 5007 | 57907 | 713 |
2102837 | 2102837 | 2022-01-11 | Merced | California | 6047 | 50999 | 713 |
2054640 | 2054640 | 2021-12-27 | St. Joseph | Indiana | 18141 | 54480 | 713 |
2035021 | 2035021 | 2021-12-21 | Madison | Illinois | 17119 | 46080 | 713 |
2014964 | 2014964 | 2021-12-15 | Navajo | Arizona | 4017 | 25897 | 713 |
1994813 | 1994813 | 2021-12-08 | Galveston | Texas | 48167 | 65450 | 713 |
1988164 | 1988164 | 2021-12-06 | Hamilton | Tennessee | 47065 | 65970 | 713 |
1960916 | 1960916 | 2021-11-28 | Saginaw | Michigan | 26145 | 32330 | 713 |
1957665 | 1957665 | 2021-11-27 | Saginaw | Michigan | 26145 | 32330 | 713 |
1954414 | 1954414 | 2021-11-26 | Saginaw | Michigan | 26145 | 32330 | 713 |
1951163 | 1951163 | 2021-11-25 | Saginaw | Michigan | 26145 | 32330 | 713 |
1947912 | 1947912 | 2021-11-24 | Saginaw | Michigan | 26145 | 32330 | 713 |
1909139 | 1909139 | 2021-11-12 | Jackson | Missouri | 29095 | 57067 | 713 |
1905890 | 1905890 | 2021-11-11 | Jackson | Missouri | 29095 | 56856 | 713 |
1902641 | 1902641 | 2021-11-10 | Jackson | Missouri | 29095 | 56856 | 713 |
1894705 | 1894705 | 2021-11-08 | Yavapai | Arizona | 4025 | 29374 | 713 |
1891455 | 1891455 | 2021-11-07 | Yavapai | Arizona | 4025 | 29290 | 713 |
1881641 | 1881641 | 2021-11-04 | Madison | Alabama | 1089 | 52915 | 713 |
1871027 | 1871027 | 2021-10-31 | Charleston | South Carolina | 45019 | 65233 | 713 |
1867778 | 1867778 | 2021-10-30 | Charleston | South Carolina | 45019 | 65233 | 713 |
1864529 | 1864529 | 2021-10-29 | Charleston | South Carolina | 45019 | 65233 | 713 |
1857859 | 1857859 | 2021-10-27 | Multnomah | Oregon | 41051 | 56445 | 713 |
1855341 | 1855341 | 2021-10-26 | Henrico | Virginia | 51087 | 34308 | 713 |
1830783 | 1830783 | 2021-10-19 | St. Tammany | Louisiana | 22103 | 43315 | 713 |
1825532 | 1825532 | 2021-10-17 | Anderson | South Carolina | 45007 | 35853 | 713 |
1822283 | 1822283 | 2021-10-16 | Anderson | South Carolina | 45007 | 35853 | 713 |
1819034 | 1819034 | 2021-10-15 | Anderson | South Carolina | 45007 | 35853 | 713 |
1810167 | 1810167 | 2021-10-13 | Montgomery | Alabama | 1101 | 33845 | 713 |
1796706 | 1796706 | 2021-10-08 | Smith | Texas | 48423 | 35383 | 713 |
1740516 | 1740516 | 2021-09-21 | Onondaga | New York | 36067 | 45732 | 713 |
1725971 | 1725971 | 2021-09-17 | Collier | Florida | 12021 | 53857 | 713 |
1726017 | 1726017 | 2021-09-17 | Seminole | Florida | 12117 | 59182 | 713 |
1722722 | 1722722 | 2021-09-16 | Collier | Florida | 12021 | 52526 | 713 |
1722768 | 1722768 | 2021-09-16 | Seminole | Florida | 12117 | 57731 | 713 |
1719473 | 1719473 | 2021-09-15 | Collier | Florida | 12021 | 52526 | 713 |
1719519 | 1719519 | 2021-09-15 | Seminole | Florida | 12117 | 57731 | 713 |
1716225 | 1716225 | 2021-09-14 | Collier | Florida | 12021 | 52526 | 713 |
1716271 | 1716271 | 2021-09-14 | Seminole | Florida | 12117 | 57731 | 713 |
1698198 | 1698198 | 2021-09-08 | Atlantic | New Jersey | 34001 | 35207 | 713 |
1646210 | 1646210 | 2021-08-23 | Washoe | Nevada | 32031 | 51923 | 713 |
1443802 | 1443802 | 2021-06-22 | Allen | Indiana | 18003 | 41776 | 713 |
1440557 | 1440557 | 2021-06-21 | Allen | Indiana | 18003 | 41765 | 713 |
1437310 | 1437310 | 2021-06-20 | Allen | Indiana | 18003 | 41747 | 713 |
1434063 | 1434063 | 2021-06-19 | Allen | Indiana | 18003 | 41747 | 713 |
1396721 | 1396721 | 2021-06-07 | Northampton | Pennsylvania | 42095 | 35742 | 713 |
1393474 | 1393474 | 2021-06-06 | Northampton | Pennsylvania | 42095 | 35734 | 713 |
1390229 | 1390229 | 2021-06-05 | Northampton | Pennsylvania | 42095 | 35728 | 713 |
1386984 | 1386984 | 2021-06-04 | Northampton | Pennsylvania | 42095 | 35722 | 713 |
1380127 | 1380127 | 2021-06-02 | Guilford | North Carolina | 37081 | 48278 | 713 |
1237328 | 1237328 | 2021-04-19 | Wake | North Carolina | 37183 | 84724 | 713 |
1216218 | 1216218 | 2021-04-13 | Pasco | Florida | 12101 | 38199 | 713 |
1214926 | 1214926 | 2021-04-12 | Westmoreland | Pennsylvania | 42129 | 30666 | 713 |
1211679 | 1211679 | 2021-04-11 | Westmoreland | Pennsylvania | 42129 | 30605 | 713 |
1162519 | 1162519 | 2021-03-27 | Rockland | New York | 36087 | 42932 | 713 |
1159270 | 1159270 | 2021-03-26 | Rockland | New York | 36087 | 42741 | 713 |
1156023 | 1156023 | 2021-03-25 | Rockland | New York | 36087 | 42556 | 713 |
1145526 | 1145526 | 2021-03-22 | Caddo | Louisiana | 22017 | 25017 | 713 |
1105631 | 1105631 | 2021-03-10 | Contra Costa | California | 6013 | 63626 | 713 |
1060272 | 1060272 | 2021-02-24 | Jefferson | Colorado | 8059 | 36750 | 713 |
1062325 | 1062325 | 2021-02-24 | York | Pennsylvania | 42133 | 35447 | 713 |
1052536 | 1052536 | 2021-02-21 | Chester | Pennsylvania | 42029 | 29912 | 713 |
1049289 | 1049289 | 2021-02-20 | Chester | Pennsylvania | 42029 | 29843 | 713 |
1049314 | 1049314 | 2021-02-20 | Luzerne | Pennsylvania | 42079 | 24461 | 713 |
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);