ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 4578 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 9
- Mississippi 9
- Texas 9
- Iowa 8
- Virginia 8
- Ohio 7
- Michigan 6
- Wisconsin 6
- Georgia 5
- Minnesota 5
- North Carolina 5
- Puerto Rico 5
- South Dakota 5
- Tennessee 5
- Pennsylvania 4
- Idaho 3
- West Virginia 3
- Florida 2
- Kansas 2
- Nebraska 2
- New York 2
- Alabama 1
- Arkansas 1
- California 1
- Colorado 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399433 | 2399433 | 2022-04-12 | Buchanan | Iowa | 19019 | 4578 | 58 |
2396177 | 2396177 | 2022-04-11 | Buchanan | Iowa | 19019 | 4578 | 58 |
2392922 | 2392922 | 2022-04-10 | Buchanan | Iowa | 19019 | 4578 | 58 |
2389666 | 2389666 | 2022-04-09 | Buchanan | Iowa | 19019 | 4578 | 58 |
2386410 | 2386410 | 2022-04-08 | Buchanan | Iowa | 19019 | 4578 | 58 |
2383156 | 2383156 | 2022-04-07 | Buchanan | Iowa | 19019 | 4578 | 58 |
2379901 | 2379901 | 2022-04-06 | Buchanan | Iowa | 19019 | 4578 | 58 |
2332764 | 2332764 | 2022-03-22 | Beadle | South Dakota | 46005 | 4578 | 58 |
2329511 | 2329511 | 2022-03-21 | Beadle | South Dakota | 46005 | 4578 | 58 |
2326259 | 2326259 | 2022-03-20 | Beadle | South Dakota | 46005 | 4578 | 58 |
2323006 | 2323006 | 2022-03-19 | Beadle | South Dakota | 46005 | 4578 | 58 |
2319752 | 2319752 | 2022-03-18 | Beadle | South Dakota | 46005 | 4578 | 58 |
2297204 | 2297204 | 2022-03-11 | Deaf Smith | Texas | 48117 | 4578 | 111 |
2268676 | 2268676 | 2022-03-03 | Sharp | Arkansas | 5135 | 4578 | 100 |
2267590 | 2267590 | 2022-03-02 | Barranquitas | Puerto Rico | 72019 | 4578 | |
2258649 | 2258649 | 2022-02-27 | Adams | Wisconsin | 55001 | 4578 | 51 |
2255398 | 2255398 | 2022-02-26 | Adams | Wisconsin | 55001 | 4578 | 51 |
2252147 | 2252147 | 2022-02-25 | Adams | Wisconsin | 55001 | 4578 | 51 |
2241364 | 2241364 | 2022-02-22 | Paulding | Ohio | 39125 | 4578 | 70 |
2242182 | 2242182 | 2022-02-22 | Buchanan | Virginia | 51027 | 4578 | 95 |
2237337 | 2237337 | 2022-02-21 | Fillmore | Minnesota | 27045 | 4578 | 22 |
2238113 | 2238113 | 2022-02-21 | Paulding | Ohio | 39125 | 4578 | 69 |
2234086 | 2234086 | 2022-02-20 | Fillmore | Minnesota | 27045 | 4578 | 22 |
2230835 | 2230835 | 2022-02-19 | Fillmore | Minnesota | 27045 | 4578 | 22 |
2231611 | 2231611 | 2022-02-19 | Paulding | Ohio | 39125 | 4578 | 69 |
2227584 | 2227584 | 2022-02-18 | Fillmore | Minnesota | 27045 | 4578 | 22 |
2213996 | 2213996 | 2022-02-14 | Perry | Indiana | 18123 | 4578 | 64 |
2188482 | 2188482 | 2022-02-06 | Iosco | Michigan | 26069 | 4578 | 129 |
2185229 | 2185229 | 2022-02-05 | Iosco | Michigan | 26069 | 4578 | 129 |
2181977 | 2181977 | 2022-02-04 | Iosco | Michigan | 26069 | 4578 | 129 |
2156418 | 2156418 | 2022-01-27 | Saunders | Nebraska | 31155 | 4578 | 25 |
2142435 | 2142435 | 2022-01-23 | Spencer | Indiana | 18147 | 4578 | 58 |
2139180 | 2139180 | 2022-01-22 | Spencer | Indiana | 18147 | 4578 | 58 |
2135924 | 2135924 | 2022-01-21 | Spencer | Indiana | 18147 | 4578 | 58 |
2096702 | 2096702 | 2022-01-09 | Elmore | Idaho | 16039 | 4578 | 54 |
2093450 | 2093450 | 2022-01-08 | Elmore | Idaho | 16039 | 4578 | 54 |
2090198 | 2090198 | 2022-01-07 | Elmore | Idaho | 16039 | 4578 | 54 |
2084728 | 2084728 | 2022-01-05 | Washington | Missouri | 29221 | 4578 | 106 |
2005004 | 2005004 | 2021-12-11 | Upshur | West Virginia | 54097 | 4578 | 71 |
1998430 | 1998430 | 2021-12-09 | Island | Washington | 53029 | 4578 | 52 |
1974099 | 1974099 | 2021-12-02 | Yazoo | Mississippi | 28163 | 4578 | 92 |
1958477 | 1958477 | 2021-11-27 | Pike | Ohio | 39131 | 4578 | 76 |
1926132 | 1926132 | 2021-11-17 | Elk | Pennsylvania | 42047 | 4578 | 65 |
1916497 | 1916497 | 2021-11-14 | Trujillo Alto | Puerto Rico | 72139 | 4578 | |
1893313 | 1893313 | 2021-11-07 | Montgomery | North Carolina | 37123 | 4578 | 108 |
1890063 | 1890063 | 2021-11-06 | Montgomery | North Carolina | 37123 | 4578 | 108 |
1886813 | 1886813 | 2021-11-05 | Montgomery | North Carolina | 37123 | 4578 | 108 |
1856022 | 1856022 | 2021-10-27 | Chattooga | Georgia | 13055 | 4578 | 103 |
1852234 | 1852234 | 2021-10-25 | Mineral | West Virginia | 54057 | 4578 | 111 |
1835139 | 1835139 | 2021-10-20 | Clarion | Pennsylvania | 42031 | 4578 | 120 |
1809206 | 1809206 | 2021-10-12 | Arecibo | Puerto Rico | 72013 | 4578 | |
1761269 | 1761269 | 2021-09-27 | Randolph | West Virginia | 54083 | 4578 | 29 |
1733573 | 1733573 | 2021-09-19 | George | Mississippi | 28039 | 4578 | 68 |
1730323 | 1730323 | 2021-09-18 | George | Mississippi | 28039 | 4578 | 68 |
1727073 | 1727073 | 2021-09-17 | George | Mississippi | 28039 | 4578 | 68 |
1701979 | 1701979 | 2021-09-09 | Venango | Pennsylvania | 42121 | 4578 | 108 |
1672199 | 1672199 | 2021-08-31 | Grafton | New Hampshire | 33009 | 4578 | 30 |
1652135 | 1652135 | 2021-08-25 | Calvert | Maryland | 24009 | 4578 | 87 |
1606130 | 1606130 | 2021-08-11 | Randolph | Illinois | 17157 | 4578 | 94 |
1578642 | 1578642 | 2021-08-02 | Dillon | South Carolina | 45033 | 4578 | 85 |
1554232 | 1554232 | 2021-07-26 | Montgomery | Indiana | 18107 | 4578 | 94 |
1543311 | 1543311 | 2021-07-22 | Rusk | Texas | 48401 | 4578 | 110 |
1474404 | 1474404 | 2021-07-01 | Knox | Ohio | 39083 | 4578 | 112 |
1466339 | 1466339 | 2021-06-29 | Thomas | Georgia | 13275 | 4578 | 126 |
1463094 | 1463094 | 2021-06-28 | Thomas | Georgia | 13275 | 4578 | 126 |
1459849 | 1459849 | 2021-06-27 | Thomas | Georgia | 13275 | 4578 | 126 |
1451048 | 1451048 | 2021-06-24 | Marshall | Mississippi | 28093 | 4578 | 105 |
1442794 | 1442794 | 2021-06-21 | Campbell | Virginia | 51031 | 4578 | 87 |
1439549 | 1439549 | 2021-06-20 | Campbell | Virginia | 51031 | 4578 | 87 |
1436302 | 1436302 | 2021-06-19 | Campbell | Virginia | 51031 | 4578 | 87 |
1399125 | 1399125 | 2021-06-08 | Pearl River | Mississippi | 28109 | 4578 | 146 |
1397166 | 1397166 | 2021-06-07 | Kerr | Texas | 48265 | 4578 | 89 |
1393919 | 1393919 | 2021-06-06 | Kerr | Texas | 48265 | 4578 | 89 |
1390674 | 1390674 | 2021-06-05 | Kerr | Texas | 48265 | 4578 | 89 |
1354809 | 1354809 | 2021-05-25 | Obion | Tennessee | 47131 | 4578 | 96 |
1351767 | 1351767 | 2021-05-24 | Nacogdoches | Texas | 48347 | 4578 | 171 |
1325531 | 1325531 | 2021-05-16 | Cheatham | Tennessee | 47021 | 4578 | 56 |
1322285 | 1322285 | 2021-05-15 | Cheatham | Tennessee | 47021 | 4578 | 56 |
1319039 | 1319039 | 2021-05-14 | Cheatham | Tennessee | 47021 | 4578 | 56 |
1291832 | 1291832 | 2021-05-06 | Newaygo | Michigan | 26123 | 4578 | 60 |
1282137 | 1282137 | 2021-05-03 | Douglas | Minnesota | 27041 | 4578 | 74 |
1276695 | 1276695 | 2021-05-01 | Toa Alta | Puerto Rico | 72135 | 4578 | |
1259167 | 1259167 | 2021-04-26 | Shelby | Kentucky | 21211 | 4578 | 70 |
1258008 | 1258008 | 2021-04-25 | Monroe | Wisconsin | 55081 | 4578 | 38 |
1223206 | 1223206 | 2021-04-15 | Muscatine | Iowa | 19139 | 4578 | 96 |
1218583 | 1218583 | 2021-04-13 | Howard | Texas | 48227 | 4578 | 101 |
1200797 | 1200797 | 2021-04-08 | Kennebec | Maine | 23011 | 4578 | 58 |
1188973 | 1188973 | 2021-04-04 | Guaynabo | Puerto Rico | 72061 | 4578 | |
1125830 | 1125830 | 2021-03-16 | Crawford | Kansas | 20037 | 4578 | 80 |
1126835 | 1126835 | 2021-03-16 | Carteret | North Carolina | 37031 | 4578 | 45 |
1122584 | 1122584 | 2021-03-15 | Crawford | Kansas | 20037 | 4578 | 80 |
1123735 | 1123735 | 2021-03-15 | Auglaize | Ohio | 39011 | 4578 | 84 |
1120489 | 1120489 | 2021-03-14 | Auglaize | Ohio | 39011 | 4578 | 84 |
1087827 | 1087827 | 2021-03-04 | Herkimer | New York | 36043 | 4578 | 107 |
1066725 | 1066725 | 2021-02-26 | Tehama | California | 6103 | 4578 | 52 |
1063164 | 1063164 | 2021-02-24 | Dunn | Wisconsin | 55033 | 4578 | 28 |
1041841 | 1041841 | 2021-02-18 | St. Joseph | Michigan | 26149 | 4578 | 82 |
1023010 | 1023010 | 2021-02-12 | McDowell | North Carolina | 37111 | 4578 | 55 |
1001839 | 1001839 | 2021-02-06 | Eagle | Colorado | 8037 | 4578 | 20 |
986604 | 986604 | 2021-02-01 | Chippewa | Michigan | 26033 | 4578 | 36 |
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);