ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 3641 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 9
- Missouri 9
- Tennessee 9
- Georgia 7
- Texas 7
- Arkansas 6
- Alabama 5
- Minnesota 5
- Montana 5
- North Carolina 5
- Wisconsin 5
- Indiana 4
- Kentucky 4
- New York 4
- Puerto Rico 4
- Colorado 3
- Kansas 3
- South Carolina 3
- Florida 2
- Iowa 2
- Louisiana 2
- Nebraska 2
- Ohio 2
- South Dakota 2
- Virginia 2
- Hawaii 1
- Illinois 1
- Maine 1
- Michigan 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475074 | 2475074 | 2022-05-05 | Macon | Missouri | 29121 | 3641 | 58 |
2417247 | 2417247 | 2022-04-17 | Aibonito | Puerto Rico | 72009 | 3641 | |
2292657 | 2292657 | 2022-03-10 | Renville | Minnesota | 27129 | 3641 | 56 |
2260346 | 2260346 | 2022-02-28 | Ste. Genevieve | Missouri | 29186 | 3641 | 39 |
2245483 | 2245483 | 2022-02-23 | King William | Virginia | 51101 | 3641 | 33 |
2196411 | 2196411 | 2022-02-08 | Falls | Texas | 48145 | 3641 | 57 |
2188708 | 2188708 | 2022-02-06 | Bates | Missouri | 29013 | 3641 | 73 |
2178974 | 2178974 | 2022-02-03 | Dallas | Missouri | 29059 | 3641 | 65 |
2164904 | 2164904 | 2022-01-30 | Jeff Davis | Georgia | 13161 | 3641 | 64 |
2166082 | 2166082 | 2022-01-30 | Park | Montana | 30067 | 3641 | 34 |
2161649 | 2161649 | 2022-01-29 | Jeff Davis | Georgia | 13161 | 3641 | 64 |
2162827 | 2162827 | 2022-01-29 | Park | Montana | 30067 | 3641 | 34 |
2158393 | 2158393 | 2022-01-28 | Jeff Davis | Georgia | 13161 | 3641 | 64 |
2159572 | 2159572 | 2022-01-28 | Park | Montana | 30067 | 3641 | 34 |
2123577 | 2123577 | 2022-01-17 | Holmes | Mississippi | 28051 | 3641 | 94 |
2120325 | 2120325 | 2022-01-16 | Holmes | Mississippi | 28051 | 3641 | 94 |
2117073 | 2117073 | 2022-01-15 | Holmes | Mississippi | 28051 | 3641 | 94 |
2113822 | 2113822 | 2022-01-14 | Holmes | Mississippi | 28051 | 3641 | 94 |
2088745 | 2088745 | 2022-01-06 | Las Piedras | Puerto Rico | 72085 | 3641 | |
2081290 | 2081290 | 2022-01-04 | Chickasaw | Mississippi | 28017 | 3641 | 74 |
2081991 | 2081991 | 2022-01-04 | Paulding | Ohio | 39125 | 3641 | 61 |
2078136 | 2078136 | 2022-01-03 | Clinton | Missouri | 29049 | 3641 | 100 |
2079794 | 2079794 | 2022-01-03 | Iowa | Wisconsin | 55049 | 3641 | 23 |
2063074 | 2063074 | 2021-12-29 | Gonzales | Texas | 48177 | 3641 | 88 |
2058752 | 2058752 | 2021-12-28 | Lincoln | Montana | 30053 | 3641 | 73 |
2010105 | 2010105 | 2021-12-13 | Saunders | Nebraska | 31155 | 3641 | 23 |
2011125 | 2011125 | 2021-12-13 | Lampasas | Texas | 48281 | 3641 | 70 |
2005870 | 2005870 | 2021-12-12 | Owen | Indiana | 18119 | 3641 | 81 |
2007874 | 2007874 | 2021-12-12 | Lampasas | Texas | 48281 | 3641 | 70 |
2002619 | 2002619 | 2021-12-11 | Owen | Indiana | 18119 | 3641 | 81 |
1999369 | 1999369 | 2021-12-10 | Owen | Indiana | 18119 | 3641 | 81 |
1995781 | 1995781 | 2021-12-09 | Cook | Georgia | 13075 | 3641 | 65 |
1986685 | 1986685 | 2021-12-06 | Meade | Kentucky | 21163 | 3641 | 47 |
1972053 | 1972053 | 2021-12-01 | Fayette | Texas | 48149 | 3641 | 93 |
1965966 | 1965966 | 2021-11-29 | Hampshire | West Virginia | 54027 | 3641 | 50 |
1915575 | 1915575 | 2021-11-14 | Stone | Mississippi | 28131 | 3641 | 66 |
1912325 | 1912325 | 2021-11-13 | Stone | Mississippi | 28131 | 3641 | 66 |
1909075 | 1909075 | 2021-11-12 | Stone | Mississippi | 28131 | 3641 | 66 |
1902363 | 1902363 | 2021-11-10 | Emmet | Michigan | 26047 | 3641 | 53 |
1860713 | 1860713 | 2021-10-28 | Delaware | New York | 36025 | 3641 | 48 |
1854319 | 1854319 | 2021-10-26 | Martin | North Carolina | 37117 | 3641 | 71 |
1854678 | 1854678 | 2021-10-26 | Susquehanna | Pennsylvania | 42115 | 3641 | 66 |
1855127 | 1855127 | 2021-10-26 | Limestone | Texas | 48293 | 3641 | 108 |
1814425 | 1814425 | 2021-10-14 | Johnson | Kentucky | 21115 | 3641 | 46 |
1810239 | 1810239 | 2021-10-13 | Cleburne | Arkansas | 5023 | 3641 | 89 |
1803877 | 1803877 | 2021-10-11 | Delta | Colorado | 8029 | 3641 | 80 |
1781943 | 1781943 | 2021-10-04 | Letcher | Kentucky | 21133 | 3641 | 58 |
1779126 | 1779126 | 2021-10-03 | Audrain | Missouri | 29007 | 3641 | 64 |
1742390 | 1742390 | 2021-09-22 | Pike | Georgia | 13231 | 3641 | 56 |
1741203 | 1741203 | 2021-09-21 | Haywood | Tennessee | 47075 | 3641 | 68 |
1737954 | 1737954 | 2021-09-20 | Haywood | Tennessee | 47075 | 3641 | 68 |
1697564 | 1697564 | 2021-09-08 | Plaquemines | Louisiana | 22075 | 3641 | 34 |
1689912 | 1689912 | 2021-09-06 | Bibb | Alabama | 1007 | 3641 | 74 |
1639780 | 1639780 | 2021-08-21 | Allegany | New York | 36003 | 3641 | 87 |
1607354 | 1607354 | 2021-08-11 | Wyoming | New York | 36121 | 3641 | 53 |
1588526 | 1588526 | 2021-08-05 | Henry | Tennessee | 47079 | 3641 | 76 |
1562307 | 1562307 | 2021-07-28 | Arecibo | Puerto Rico | 72013 | 3641 | |
1552140 | 1552140 | 2021-07-25 | Bladen | North Carolina | 37017 | 3641 | 53 |
1547533 | 1547533 | 2021-07-24 | Hawaii | Hawaii | 15001 | 3641 | 56 |
1548893 | 1548893 | 2021-07-24 | Bladen | North Carolina | 37017 | 3641 | 53 |
1545646 | 1545646 | 2021-07-23 | Bladen | North Carolina | 37017 | 3641 | 53 |
1470425 | 1470425 | 2021-06-30 | Lyon | Minnesota | 27083 | 3641 | 54 |
1459501 | 1459501 | 2021-06-27 | St. Francis | Arkansas | 5123 | 3641 | 44 |
1456256 | 1456256 | 2021-06-26 | St. Francis | Arkansas | 5123 | 3641 | 44 |
1453011 | 1453011 | 2021-06-25 | St. Francis | Arkansas | 5123 | 3641 | 44 |
1454027 | 1454027 | 2021-06-25 | Oxford | Maine | 23017 | 3641 | 67 |
1449765 | 1449765 | 2021-06-24 | St. Francis | Arkansas | 5123 | 3641 | 44 |
1424164 | 1424164 | 2021-06-16 | Wayne | Georgia | 13305 | 3641 | 91 |
1405708 | 1405708 | 2021-06-10 | Marion | Missouri | 29127 | 3641 | 53 |
1402462 | 1402462 | 2021-06-09 | Marion | Missouri | 29127 | 3641 | 53 |
1399217 | 1399217 | 2021-06-08 | Marion | Missouri | 29127 | 3641 | 53 |
1364355 | 1364355 | 2021-05-28 | Trujillo Alto | Puerto Rico | 72139 | 3641 | |
1361289 | 1361289 | 2021-05-27 | Macon | Tennessee | 47111 | 3641 | 78 |
1358637 | 1358637 | 2021-05-26 | Green | Wisconsin | 55045 | 3641 | 25 |
1348980 | 1348980 | 2021-05-24 | Chambers | Alabama | 1017 | 3641 | 123 |
1314189 | 1314189 | 2021-05-13 | Harvey | Kansas | 20079 | 3641 | 68 |
1310942 | 1310942 | 2021-05-12 | Harvey | Kansas | 20079 | 3641 | 68 |
1303920 | 1303920 | 2021-05-10 | Bryan | Georgia | 13029 | 3641 | 39 |
1302164 | 1302164 | 2021-05-09 | Tioga | New York | 36107 | 3641 | 61 |
1302889 | 1302889 | 2021-05-09 | White | Tennessee | 47185 | 3641 | 70 |
1299642 | 1299642 | 2021-05-08 | White | Tennessee | 47185 | 3641 | 70 |
1296395 | 1296395 | 2021-05-07 | White | Tennessee | 47185 | 3641 | 70 |
1296988 | 1296988 | 2021-05-07 | Trempealeau | Wisconsin | 55121 | 3641 | 44 |
1238883 | 1238883 | 2021-04-20 | Summit | Colorado | 8117 | 3641 | 7 |
1236732 | 1236732 | 2021-04-19 | Steele | Minnesota | 27147 | 3641 | 14 |
1229114 | 1229114 | 2021-04-17 | La Plata | Colorado | 8067 | 3641 | 38 |
1167077 | 1167077 | 2021-03-28 | Oneida | Wisconsin | 55085 | 3641 | 74 |
1155575 | 1155575 | 2021-03-25 | Hancock | Mississippi | 28045 | 3641 | 84 |
1149749 | 1149749 | 2021-03-23 | Logan | Ohio | 39091 | 3641 | 76 |
1076339 | 1076339 | 2021-03-01 | Boone | Arkansas | 5009 | 3641 | 73 |
1043488 | 1043488 | 2021-02-18 | Franklin | Virginia | 51067 | 3641 | 42 |
1009173 | 1009173 | 2021-02-08 | Scott | Kentucky | 21209 | 3641 | 26 |
1006727 | 1006727 | 2021-02-07 | Alexander | North Carolina | 37003 | 3641 | 59 |
995840 | 995840 | 2021-02-04 | Montgomery | Indiana | 18107 | 3641 | 79 |
978188 | 978188 | 2021-01-29 | Marshall | Tennessee | 47117 | 3641 | 42 |
929401 | 929401 | 2021-01-14 | Codington | South Dakota | 46029 | 3641 | 73 |
901789 | 901789 | 2021-01-06 | Des Moines | Iowa | 19057 | 3641 | 37 |
904132 | 904132 | 2021-01-06 | Douglas | Wisconsin | 55031 | 3641 | 30 |
895888 | 895888 | 2021-01-04 | Winona | Minnesota | 27169 | 3641 | 45 |
864457 | 864457 | 2020-12-25 | Georgetown | South Carolina | 45043 | 3641 | 73 |
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);