ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 13
- North Carolina 12
- Illinois 7
- Indiana 7
- Kentucky 7
- Texas 6
- Kansas 5
- Virginia 5
- Alabama 4
- Iowa 4
- New York 4
- West Virginia 4
- Arkansas 3
- Idaho 3
- Louisiana 3
- Michigan 3
- Missouri 3
- Ohio 3
- Tennessee 3
- Wisconsin 3
- Colorado 2
- Georgia 2
- Maryland 2
- Puerto Rico 2
- South Carolina 2
- Alaska 1
- California 1
- Florida 1
- Hawaii 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500638 | 2500638 | 2022-05-13 | Knott | Kentucky | 21119 | 4233 | 64 |
2497380 | 2497380 | 2022-05-12 | Knott | Kentucky | 21119 | 4233 | 64 |
2494122 | 2494122 | 2022-05-11 | Knott | Kentucky | 21119 | 4233 | 64 |
2490392 | 2490392 | 2022-05-10 | Minidoka | Idaho | 16067 | 4233 | 64 |
2490864 | 2490864 | 2022-05-10 | Knott | Kentucky | 21119 | 4233 | 64 |
2487135 | 2487135 | 2022-05-09 | Minidoka | Idaho | 16067 | 4233 | 64 |
2487607 | 2487607 | 2022-05-09 | Knott | Kentucky | 21119 | 4233 | 64 |
2484715 | 2484715 | 2022-05-08 | Clarke | Mississippi | 28023 | 4233 | 108 |
2481457 | 2481457 | 2022-05-07 | Clarke | Mississippi | 28023 | 4233 | 108 |
2478199 | 2478199 | 2022-05-06 | Clarke | Mississippi | 28023 | 4233 | 108 |
2474941 | 2474941 | 2022-05-05 | Clarke | Mississippi | 28023 | 4233 | 108 |
2471684 | 2471684 | 2022-05-04 | Clarke | Mississippi | 28023 | 4233 | 108 |
2468428 | 2468428 | 2022-05-03 | Clarke | Mississippi | 28023 | 4233 | 108 |
2465173 | 2465173 | 2022-05-02 | Clarke | Mississippi | 28023 | 4233 | 108 |
2371251 | 2371251 | 2022-04-03 | Bertie | North Carolina | 37015 | 4233 | 67 |
2367998 | 2367998 | 2022-04-02 | Bertie | North Carolina | 37015 | 4233 | 67 |
2364745 | 2364745 | 2022-04-01 | Bertie | North Carolina | 37015 | 4233 | 67 |
2351730 | 2351730 | 2022-03-28 | Bertie | North Carolina | 37015 | 4233 | 67 |
2332709 | 2332709 | 2022-03-22 | Yabucoa | Puerto Rico | 72151 | 4233 | |
2329456 | 2329456 | 2022-03-21 | Yabucoa | Puerto Rico | 72151 | 4233 | |
2324400 | 2324400 | 2022-03-20 | Carroll | Illinois | 17015 | 4233 | 49 |
2321146 | 2321146 | 2022-03-19 | Carroll | Illinois | 17015 | 4233 | 49 |
2317892 | 2317892 | 2022-03-18 | Carroll | Illinois | 17015 | 4233 | 49 |
2314639 | 2314639 | 2022-03-17 | Carroll | Illinois | 17015 | 4233 | 48 |
2307814 | 2307814 | 2022-03-15 | Otero | Colorado | 8089 | 4233 | 125 |
2293715 | 2293715 | 2022-03-10 | Lee | South Carolina | 45061 | 4233 | 93 |
2246639 | 2246639 | 2022-02-24 | Atchison | Kansas | 20005 | 4233 | 33 |
2243388 | 2243388 | 2022-02-23 | Atchison | Kansas | 20005 | 4233 | 33 |
2215997 | 2215997 | 2022-02-14 | Lamb | Texas | 48279 | 4233 | 112 |
2131904 | 2131904 | 2022-01-20 | Cherokee | Alabama | 1019 | 4233 | 67 |
2125552 | 2125552 | 2022-01-18 | Phillips | Arkansas | 5107 | 4233 | 84 |
2039296 | 2039296 | 2021-12-22 | Cass | Nebraska | 31025 | 4233 | 23 |
1973823 | 1973823 | 2021-12-02 | Queen Anne's | Maryland | 24035 | 4233 | 77 |
1944936 | 1944936 | 2021-11-23 | Saline | Missouri | 29195 | 4233 | 83 |
1901287 | 1901287 | 2021-11-10 | Calaveras | California | 6009 | 4233 | 84 |
1900395 | 1900395 | 2021-11-09 | DeKalb | Tennessee | 47041 | 4233 | 75 |
1868465 | 1868465 | 2021-10-30 | Hancock | West Virginia | 54029 | 4233 | 115 |
1830342 | 1830342 | 2021-10-19 | Greene | Indiana | 18055 | 4233 | 100 |
1831473 | 1831473 | 2021-10-19 | Franklin | New York | 36033 | 4233 | 20 |
1790133 | 1790133 | 2021-10-06 | Kleberg | Texas | 48273 | 4233 | 125 |
1785555 | 1785555 | 2021-10-05 | Covington | Mississippi | 28031 | 4233 | 93 |
1755600 | 1755600 | 2021-09-26 | Daviess | Indiana | 18027 | 4233 | 110 |
1756378 | 1756378 | 2021-09-26 | Yazoo | Mississippi | 28163 | 4233 | 86 |
1752352 | 1752352 | 2021-09-25 | Daviess | Indiana | 18027 | 4233 | 110 |
1753130 | 1753130 | 2021-09-25 | Yazoo | Mississippi | 28163 | 4233 | 86 |
1753952 | 1753952 | 2021-09-25 | Snyder | Pennsylvania | 42109 | 4233 | 92 |
1749103 | 1749103 | 2021-09-24 | Daviess | Indiana | 18027 | 4233 | 110 |
1749882 | 1749882 | 2021-09-24 | Yazoo | Mississippi | 28163 | 4233 | 86 |
1750240 | 1750240 | 2021-09-24 | Chenango | New York | 36017 | 4233 | 86 |
1735336 | 1735336 | 2021-09-19 | Oneida | Wisconsin | 55085 | 4233 | 84 |
1732086 | 1732086 | 2021-09-18 | Oneida | Wisconsin | 55085 | 4233 | 84 |
1728836 | 1728836 | 2021-09-17 | Oneida | Wisconsin | 55085 | 4233 | 84 |
1724350 | 1724350 | 2021-09-16 | Macon | North Carolina | 37113 | 4233 | 49 |
1717047 | 1717047 | 2021-09-14 | Morehouse | Louisiana | 22067 | 4233 | 103 |
1709965 | 1709965 | 2021-09-12 | Bonner | Idaho | 16017 | 4233 | 51 |
1700837 | 1700837 | 2021-09-09 | West Baton Rouge | Louisiana | 22121 | 4233 | 71 |
1699528 | 1699528 | 2021-09-08 | Marshall | West Virginia | 54051 | 4233 | 90 |
1664098 | 1664098 | 2021-08-29 | St. Francis | Arkansas | 5123 | 4233 | 52 |
1660695 | 1660695 | 2021-08-28 | Dallas | Alabama | 1047 | 4233 | 167 |
1651000 | 1651000 | 2021-08-25 | Bethel Census Area | Alaska | 2050 | 4233 | 22 |
1646538 | 1646538 | 2021-08-23 | Logan | Ohio | 39091 | 4233 | 79 |
1629231 | 1629231 | 2021-08-18 | Greenup | Kentucky | 21089 | 4233 | 63 |
1606080 | 1606080 | 2021-08-11 | Fulton | Illinois | 17057 | 4233 | 68 |
1586753 | 1586753 | 2021-08-05 | Whitley | Indiana | 18183 | 4233 | 45 |
1555729 | 1555729 | 2021-07-26 | Polk | Oregon | 41053 | 4233 | 56 |
1539773 | 1539773 | 2021-07-21 | Campbell | Tennessee | 47013 | 4233 | 62 |
1497017 | 1497017 | 2021-07-08 | Stokes | North Carolina | 37169 | 4233 | 81 |
1493770 | 1493770 | 2021-07-07 | Stokes | North Carolina | 37169 | 4233 | 81 |
1494630 | 1494630 | 2021-07-07 | Titus | Texas | 48449 | 4233 | 84 |
1490523 | 1490523 | 2021-07-06 | Stokes | North Carolina | 37169 | 4233 | 81 |
1413500 | 1413500 | 2021-06-12 | Wharton | Texas | 48481 | 4233 | 117 |
1397191 | 1397191 | 2021-06-07 | Matagorda | Texas | 48321 | 4233 | 114 |
1379655 | 1379655 | 2021-06-02 | Pontotoc | Mississippi | 28115 | 4233 | 73 |
1344903 | 1344903 | 2021-05-22 | Chester | South Carolina | 45023 | 4233 | 76 |
1327365 | 1327365 | 2021-05-17 | Avoyelles | Louisiana | 22009 | 4233 | 123 |
1289152 | 1289152 | 2021-05-05 | Livingston | New York | 36051 | 4233 | 58 |
1284794 | 1284794 | 2021-05-04 | Montgomery | Indiana | 18107 | 4233 | 90 |
1285899 | 1285899 | 2021-05-04 | Fulton | New York | 36035 | 4233 | 90 |
1271079 | 1271079 | 2021-04-30 | Franklin | Alabama | 1059 | 4233 | 82 |
1262114 | 1262114 | 2021-04-27 | Buena Vista | Iowa | 19021 | 4233 | 40 |
1258617 | 1258617 | 2021-04-26 | Maui | Hawaii | 15009 | 4233 | 49 |
1256762 | 1256762 | 2021-04-25 | Haywood | North Carolina | 37087 | 4233 | 92 |
1253515 | 1253515 | 2021-04-24 | Haywood | North Carolina | 37087 | 4233 | 92 |
1254688 | 1254688 | 2021-04-24 | Marion | West Virginia | 54049 | 4233 | 50 |
1250268 | 1250268 | 2021-04-23 | Haywood | North Carolina | 37087 | 4233 | 92 |
1233036 | 1233036 | 2021-04-18 | Lyon | Kansas | 20111 | 4233 | 84 |
1229787 | 1229787 | 2021-04-17 | Lyon | Kansas | 20111 | 4233 | 84 |
1226539 | 1226539 | 2021-04-16 | Lyon | Kansas | 20111 | 4233 | 84 |
1219249 | 1219249 | 2021-04-14 | Miller | Arkansas | 5091 | 4233 | 36 |
1222052 | 1222052 | 2021-04-14 | Danville city | Virginia | 51590 | 4233 | 133 |
1200491 | 1200491 | 2021-04-08 | Wapello | Iowa | 19179 | 4233 | 120 |
1197090 | 1197090 | 2021-04-07 | Harrison | Indiana | 18061 | 4233 | 72 |
1180174 | 1180174 | 2021-04-02 | Russell | Alabama | 1113 | 4233 | 37 |
1169708 | 1169708 | 2021-03-29 | Lincoln | Tennessee | 47103 | 4233 | 63 |
1148271 | 1148271 | 2021-03-23 | Franklin | Illinois | 17055 | 4233 | 79 |
1148923 | 1148923 | 2021-03-23 | Isabella | Michigan | 26073 | 4233 | 76 |
1113342 | 1113342 | 2021-03-12 | Winona | Minnesota | 27169 | 4233 | 49 |
1113852 | 1113852 | 2021-03-12 | Chatham | North Carolina | 37037 | 4233 | 79 |
1086487 | 1086487 | 2021-03-04 | Thomas | Georgia | 13275 | 4233 | 114 |
1059801 | 1059801 | 2021-02-23 | Washington | Virginia | 51191 | 4233 | 93 |
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);