ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4291 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 13
- Texas 10
- Illinois 8
- West Virginia 8
- Florida 7
- Mississippi 7
- Virginia 5
- Wisconsin 5
- Arkansas 4
- North Carolina 4
- Louisiana 3
- Michigan 3
- Alabama 2
- Indiana 2
- Kentucky 2
- New York 2
- Oklahoma 2
- South Carolina 2
- Washington 2
- Arizona 1
- California 1
- Colorado 1
- Georgia 1
- Idaho 1
- Iowa 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Nebraska 1
- North Dakota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499491 | 2499491 | 2022-05-12 | Crawford | Wisconsin | 55023 | 4291 | 28 |
2312025 | 2312025 | 2022-03-16 | Antrim | Michigan | 26009 | 4291 | 62 |
2308772 | 2308772 | 2022-03-15 | Antrim | Michigan | 26009 | 4291 | 62 |
2306271 | 2306271 | 2022-03-14 | Warren | North Carolina | 37185 | 4291 | 39 |
2303020 | 2303020 | 2022-03-13 | Warren | North Carolina | 37185 | 4291 | 39 |
2299768 | 2299768 | 2022-03-12 | Warren | North Carolina | 37185 | 4291 | 39 |
2296516 | 2296516 | 2022-03-11 | Warren | North Carolina | 37185 | 4291 | 39 |
2262599 | 2262599 | 2022-03-01 | Bond | Illinois | 17005 | 4291 | 35 |
2258997 | 2258997 | 2022-02-28 | Chaffee | Colorado | 8015 | 4291 | 42 |
2098758 | 2098758 | 2022-01-09 | Austin | Texas | 48015 | 4291 | 58 |
2088775 | 2088775 | 2022-01-06 | Vega Alta | Puerto Rico | 72143 | 4291 | |
2076465 | 2076465 | 2022-01-02 | Boone | West Virginia | 54005 | 4291 | 62 |
2073214 | 2073214 | 2022-01-01 | Boone | West Virginia | 54005 | 4291 | 62 |
2069963 | 2069963 | 2021-12-31 | Boone | West Virginia | 54005 | 4291 | 62 |
2066712 | 2066712 | 2021-12-30 | Boone | West Virginia | 54005 | 4291 | 62 |
2006032 | 2006032 | 2021-12-12 | Franklin | Kansas | 20059 | 4291 | 67 |
2002781 | 2002781 | 2021-12-11 | Franklin | Kansas | 20059 | 4291 | 67 |
1999531 | 1999531 | 2021-12-10 | Franklin | Kansas | 20059 | 4291 | 67 |
1972300 | 1972300 | 2021-12-01 | Caroline | Virginia | 51033 | 4291 | 55 |
1932667 | 1932667 | 2021-11-19 | Susquehanna | Pennsylvania | 42115 | 4291 | 72 |
1917927 | 1917927 | 2021-11-15 | Jefferson | Idaho | 16051 | 4291 | 47 |
1872489 | 1872489 | 2021-11-01 | Iroquois | Illinois | 17075 | 4291 | 81 |
1851609 | 1851609 | 2021-10-25 | Lawrence | South Dakota | 46081 | 4291 | 59 |
1842725 | 1842725 | 2021-10-23 | Carroll | Arkansas | 5015 | 4291 | 74 |
1837065 | 1837065 | 2021-10-21 | Miami | Kansas | 20121 | 4291 | 59 |
1833816 | 1833816 | 2021-10-20 | Miami | Kansas | 20121 | 4291 | 59 |
1835620 | 1835620 | 2021-10-20 | Kleberg | Texas | 48273 | 4291 | 125 |
1828413 | 1828413 | 2021-10-18 | Stutsman | North Dakota | 38093 | 4291 | 85 |
1807823 | 1807823 | 2021-10-12 | McPherson | Kansas | 20113 | 4291 | 93 |
1804572 | 1804572 | 2021-10-11 | McPherson | Kansas | 20113 | 4291 | 93 |
1801323 | 1801323 | 2021-10-10 | McPherson | Kansas | 20113 | 4291 | 92 |
1798074 | 1798074 | 2021-10-09 | McPherson | Kansas | 20113 | 4291 | 92 |
1794825 | 1794825 | 2021-10-08 | McPherson | Kansas | 20113 | 4291 | 92 |
1791577 | 1791577 | 2021-10-07 | McPherson | Kansas | 20113 | 4291 | 92 |
1755489 | 1755489 | 2021-09-26 | Bureau | Illinois | 17011 | 4291 | 101 |
1752241 | 1752241 | 2021-09-25 | Bureau | Illinois | 17011 | 4291 | 101 |
1748992 | 1748992 | 2021-09-24 | Bureau | Illinois | 17011 | 4291 | 101 |
1740116 | 1740116 | 2021-09-21 | Simpson | Mississippi | 28127 | 4291 | 112 |
1720584 | 1720584 | 2021-09-15 | Itawamba | Mississippi | 28057 | 4291 | 92 |
1717789 | 1717789 | 2021-09-14 | Tioga | New York | 36107 | 4291 | 65 |
1678046 | 1678046 | 2021-09-02 | De Soto | Louisiana | 22031 | 4291 | 98 |
1568338 | 1568338 | 2021-07-30 | Montgomery | New York | 36057 | 4291 | 128 |
1561176 | 1561176 | 2021-07-28 | Calvert | Maryland | 24009 | 4291 | 86 |
1558208 | 1558208 | 2021-07-27 | Union | Mississippi | 28145 | 4291 | 79 |
1554512 | 1554512 | 2021-07-26 | Franklin | Kentucky | 21073 | 4291 | 60 |
1530806 | 1530806 | 2021-07-19 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1527559 | 1527559 | 2021-07-18 | Tallapoosa | Alabama | 1123 | 4291 | 156 |
1518123 | 1518123 | 2021-07-15 | Okeechobee | Florida | 12093 | 4291 | 89 |
1514876 | 1514876 | 2021-07-14 | Okeechobee | Florida | 12093 | 4291 | 89 |
1511630 | 1511630 | 2021-07-13 | Okeechobee | Florida | 12093 | 4291 | 89 |
1508383 | 1508383 | 2021-07-12 | Okeechobee | Florida | 12093 | 4291 | 89 |
1510441 | 1510441 | 2021-07-12 | Chester | South Carolina | 45023 | 4291 | 76 |
1505137 | 1505137 | 2021-07-11 | Okeechobee | Florida | 12093 | 4291 | 89 |
1501891 | 1501891 | 2021-07-10 | Okeechobee | Florida | 12093 | 4291 | 89 |
1498645 | 1498645 | 2021-07-09 | Okeechobee | Florida | 12093 | 4291 | 89 |
1488150 | 1488150 | 2021-07-05 | Washington | Texas | 48477 | 4291 | 95 |
1473775 | 1473775 | 2021-07-01 | Pontotoc | Mississippi | 28115 | 4291 | 73 |
1434869 | 1434869 | 2021-06-19 | Camden | Missouri | 29029 | 4291 | 89 |
1415255 | 1415255 | 2021-06-13 | McLeod | Minnesota | 27085 | 4291 | 61 |
1395452 | 1395452 | 2021-06-07 | Graves | Kentucky | 21083 | 4291 | 96 |
1394295 | 1394295 | 2021-06-06 | Ohio | West Virginia | 54069 | 4291 | 86 |
1391050 | 1391050 | 2021-06-05 | Ohio | West Virginia | 54069 | 4291 | 86 |
1387805 | 1387805 | 2021-06-04 | Ohio | West Virginia | 54069 | 4291 | 86 |
1371891 | 1371891 | 2021-05-31 | Humboldt | California | 6023 | 4291 | 43 |
1336932 | 1336932 | 2021-05-20 | Lyon | Kansas | 20111 | 4291 | 85 |
1333685 | 1333685 | 2021-05-19 | Lyon | Kansas | 20111 | 4291 | 85 |
1330202 | 1330202 | 2021-05-18 | Clinton | Indiana | 18023 | 4291 | 58 |
1322495 | 1322495 | 2021-05-15 | Jim Wells | Texas | 48249 | 4291 | 102 |
1313895 | 1313895 | 2021-05-13 | Jefferson | Illinois | 17081 | 4291 | 121 |
1313103 | 1313103 | 2021-05-12 | Whitman | Washington | 53075 | 4291 | 48 |
1304401 | 1304401 | 2021-05-10 | Wapello | Iowa | 19179 | 4291 | 122 |
1296776 | 1296776 | 2021-05-07 | Manassas city | Virginia | 51683 | 4291 | 47 |
1277699 | 1277699 | 2021-05-02 | Miller | Arkansas | 5091 | 4291 | 38 |
1274452 | 1274452 | 2021-05-01 | Miller | Arkansas | 5091 | 4291 | 37 |
1251322 | 1251322 | 2021-04-23 | Manassas city | Virginia | 51683 | 4291 | 47 |
1194289 | 1194289 | 2021-04-06 | Washington | Louisiana | 22117 | 4291 | 127 |
1177559 | 1177559 | 2021-04-01 | Stephenson | Illinois | 17177 | 4291 | 98 |
1124837 | 1124837 | 2021-03-15 | Douglas | Wisconsin | 55031 | 4291 | 44 |
1106096 | 1106096 | 2021-03-10 | Marion | Illinois | 17121 | 4291 | 119 |
1102082 | 1102082 | 2021-03-08 | Putnam | West Virginia | 54079 | 4291 | 75 |
1089010 | 1089010 | 2021-03-04 | Washington | Virginia | 51191 | 4291 | 98 |
1037229 | 1037229 | 2021-02-16 | Pierce | Wisconsin | 55093 | 4291 | 39 |
966012 | 966012 | 2021-01-26 | Hot Spring | Arkansas | 5059 | 4291 | 62 |
966610 | 966610 | 2021-01-26 | Jackson | Indiana | 18071 | 4291 | 48 |
969038 | 969038 | 2021-01-26 | Dunn | Wisconsin | 55033 | 4291 | 26 |
963947 | 963947 | 2021-01-25 | St. Joseph | Michigan | 26149 | 4291 | 73 |
962117 | 962117 | 2021-01-24 | Howard | Texas | 48227 | 4291 | 84 |
948148 | 948148 | 2021-01-20 | Scotts Bluff | Nebraska | 31157 | 4291 | 84 |
938857 | 938857 | 2021-01-17 | McClain | Oklahoma | 40087 | 4291 | 32 |
932330 | 932330 | 2021-01-15 | Carter | Oklahoma | 40019 | 4291 | 19 |
913895 | 913895 | 2021-01-09 | Oconto | Wisconsin | 55083 | 4291 | 45 |
903053 | 903053 | 2021-01-06 | Geauga | Ohio | 39055 | 4291 | 54 |
898145 | 898145 | 2021-01-05 | Coffee | Georgia | 13069 | 4291 | 93 |
895927 | 895927 | 2021-01-04 | Lamar | Mississippi | 28073 | 4291 | 60 |
833958 | 833958 | 2020-12-16 | Iberia | Louisiana | 22045 | 4291 | 114 |
683160 | 683160 | 2020-10-30 | Victoria | Texas | 48469 | 4291 | 98 |
666543 | 666543 | 2020-10-25 | Pickens | South Carolina | 45077 | 4291 | 60 |
650770 | 650770 | 2020-10-20 | Washington | Utah | 49053 | 4291 | 39 |
642821 | 642821 | 2020-10-18 | Jackson | Mississippi | 28059 | 4291 | 78 |
644189 | 644189 | 2020-10-18 | Randall | Texas | 48381 | 4291 | 53 |
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);