ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
244 rows where cases = 2101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 24
- Kentucky 19
- Missouri 17
- Texas 16
- Georgia 12
- Mississippi 12
- Arkansas 11
- North Carolina 11
- Illinois 10
- Indiana 10
- Wisconsin 10
- Tennessee 9
- Virginia 9
- Michigan 7
- Minnesota 7
- Colorado 6
- Idaho 6
- Ohio 5
- Puerto Rico 5
- Florida 4
- Washington 4
- West Virginia 4
- Louisiana 3
- Montana 3
- North Dakota 3
- Oklahoma 3
- Alabama 2
- Nebraska 2
- Pennsylvania 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502693 | 2502693 | 2022-05-13 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2497918 | 2497918 | 2022-05-12 | St. Clair | Missouri | 29185 | 2101 | 36 |
2499435 | 2499435 | 2022-05-12 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2494660 | 2494660 | 2022-05-11 | St. Clair | Missouri | 29185 | 2101 | 36 |
2496177 | 2496177 | 2022-05-11 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2491402 | 2491402 | 2022-05-10 | St. Clair | Missouri | 29185 | 2101 | 36 |
2488144 | 2488144 | 2022-05-09 | St. Clair | Missouri | 29185 | 2101 | 36 |
2484653 | 2484653 | 2022-05-08 | Lake | Minnesota | 27075 | 2101 | 28 |
2484887 | 2484887 | 2022-05-08 | St. Clair | Missouri | 29185 | 2101 | 36 |
2481395 | 2481395 | 2022-05-07 | Lake | Minnesota | 27075 | 2101 | 28 |
2481629 | 2481629 | 2022-05-07 | St. Clair | Missouri | 29185 | 2101 | 36 |
2478137 | 2478137 | 2022-05-06 | Lake | Minnesota | 27075 | 2101 | 28 |
2478371 | 2478371 | 2022-05-06 | St. Clair | Missouri | 29185 | 2101 | 36 |
2474879 | 2474879 | 2022-05-05 | Lake | Minnesota | 27075 | 2101 | 28 |
2465504 | 2465504 | 2022-05-02 | Unknown | Nebraska | 2101 | 459 | |
2451511 | 2451511 | 2022-04-28 | Warren | Indiana | 18171 | 2101 | 30 |
2448255 | 2448255 | 2022-04-27 | Warren | Indiana | 18171 | 2101 | 30 |
2443298 | 2443298 | 2022-04-25 | Arroyo | Puerto Rico | 72015 | 2101 | |
2348162 | 2348162 | 2022-03-27 | St. Clair | Missouri | 29185 | 2101 | 34 |
2344909 | 2344909 | 2022-03-26 | St. Clair | Missouri | 29185 | 2101 | 34 |
2341656 | 2341656 | 2022-03-25 | St. Clair | Missouri | 29185 | 2101 | 34 |
2337215 | 2337215 | 2022-03-24 | Candler | Georgia | 13043 | 2101 | 94 |
2333961 | 2333961 | 2022-03-23 | Candler | Georgia | 13043 | 2101 | 94 |
2330470 | 2330470 | 2022-03-22 | Searcy | Arkansas | 5129 | 2101 | 46 |
2319657 | 2319657 | 2022-03-18 | Jayuya | Puerto Rico | 72073 | 2101 | |
2302034 | 2302034 | 2022-03-13 | Bracken | Kentucky | 21023 | 2101 | 24 |
2298782 | 2298782 | 2022-03-12 | Bracken | Kentucky | 21023 | 2101 | 24 |
2295530 | 2295530 | 2022-03-11 | Bracken | Kentucky | 21023 | 2101 | 24 |
2292278 | 2292278 | 2022-03-10 | Bracken | Kentucky | 21023 | 2101 | 24 |
2289026 | 2289026 | 2022-03-09 | Bracken | Kentucky | 21023 | 2101 | 24 |
2285775 | 2285775 | 2022-03-08 | Bracken | Kentucky | 21023 | 2101 | 24 |
2282523 | 2282523 | 2022-03-07 | Bracken | Kentucky | 21023 | 2101 | 24 |
2281097 | 2281097 | 2022-03-06 | Somervell | Texas | 48425 | 2101 | 35 |
2277844 | 2277844 | 2022-03-05 | Somervell | Texas | 48425 | 2101 | 35 |
2274591 | 2274591 | 2022-03-04 | Somervell | Texas | 48425 | 2101 | 35 |
2271338 | 2271338 | 2022-03-03 | Somervell | Texas | 48425 | 2101 | 35 |
2268086 | 2268086 | 2022-03-02 | Somervell | Texas | 48425 | 2101 | 35 |
2258199 | 2258199 | 2022-02-27 | Franklin | Texas | 48159 | 2101 | 40 |
2237412 | 2237412 | 2022-02-21 | Choctaw | Mississippi | 28019 | 2101 | 31 |
2234161 | 2234161 | 2022-02-20 | Choctaw | Mississippi | 28019 | 2101 | 31 |
2230910 | 2230910 | 2022-02-19 | Choctaw | Mississippi | 28019 | 2101 | 31 |
2227659 | 2227659 | 2022-02-18 | Choctaw | Mississippi | 28019 | 2101 | 31 |
2221391 | 2221391 | 2022-02-16 | Sanders | Montana | 30089 | 2101 | 44 |
2205527 | 2205527 | 2022-02-11 | Traill | North Dakota | 38097 | 2101 | 23 |
2173692 | 2173692 | 2022-02-01 | Jim Hogg | Texas | 48247 | 2101 | 20 |
2145945 | 2145945 | 2022-01-24 | Edmonson | Kentucky | 21061 | 2101 | 35 |
2129220 | 2129220 | 2022-01-19 | Franklin | Idaho | 16041 | 2101 | 27 |
2128388 | 2128388 | 2022-01-18 | Lexington city | Virginia | 51678 | 2101 | 38 |
2110686 | 2110686 | 2022-01-13 | Linn | Missouri | 29115 | 2101 | 59 |
2099671 | 2099671 | 2022-01-10 | Prowers | Colorado | 8099 | 2101 | 43 |
2086204 | 2086204 | 2022-01-05 | Pacific | Washington | 53049 | 2101 | 40 |
2054997 | 2054997 | 2021-12-27 | Claiborne | Louisiana | 22027 | 2101 | 66 |
2051278 | 2051278 | 2021-12-26 | Menard | Illinois | 17129 | 2101 | 19 |
2048028 | 2048028 | 2021-12-25 | Menard | Illinois | 17129 | 2101 | 19 |
2044778 | 2044778 | 2021-12-24 | Menard | Illinois | 17129 | 2101 | 19 |
2041529 | 2041529 | 2021-12-23 | Menard | Illinois | 17129 | 2101 | 19 |
2037418 | 2037418 | 2021-12-21 | Westmoreland | Virginia | 51193 | 2101 | 39 |
2016449 | 2016449 | 2021-12-15 | Ripley | Missouri | 29181 | 2101 | 51 |
1967373 | 1967373 | 2021-11-30 | Gogebic | Michigan | 26053 | 2101 | 56 |
1967391 | 1967391 | 2021-11-30 | Leelanau | Michigan | 26089 | 2101 | 34 |
1964121 | 1964121 | 2021-11-29 | Gogebic | Michigan | 26053 | 2101 | 56 |
1964139 | 1964139 | 2021-11-29 | Leelanau | Michigan | 26089 | 2101 | 34 |
1964972 | 1964972 | 2021-11-29 | Morgan | Ohio | 39115 | 2101 | 38 |
1944182 | 1944182 | 2021-11-23 | Hancock | Iowa | 19081 | 2101 | 39 |
1940932 | 1940932 | 2021-11-22 | Hancock | Iowa | 19081 | 2101 | 39 |
1937682 | 1937682 | 2021-11-21 | Hancock | Iowa | 19081 | 2101 | 39 |
1934432 | 1934432 | 2021-11-20 | Hancock | Iowa | 19081 | 2101 | 39 |
1931181 | 1931181 | 2021-11-19 | Hancock | Iowa | 19081 | 2101 | 39 |
1927930 | 1927930 | 2021-11-18 | Hancock | Iowa | 19081 | 2101 | 39 |
1924680 | 1924680 | 2021-11-17 | Hancock | Iowa | 19081 | 2101 | 39 |
1901247 | 1901247 | 2021-11-10 | Little River | Arkansas | 5081 | 2101 | 79 |
1876292 | 1876292 | 2021-11-02 | Knox | Maine | 23013 | 2101 | 13 |
1849043 | 1849043 | 2021-10-24 | Lafayette | Wisconsin | 55065 | 2101 | 12 |
1845793 | 1845793 | 2021-10-23 | Lafayette | Wisconsin | 55065 | 2101 | 12 |
1842543 | 1842543 | 2021-10-22 | Lafayette | Wisconsin | 55065 | 2101 | 12 |
1839210 | 1839210 | 2021-10-21 | Braxton | West Virginia | 54007 | 2101 | 17 |
1833895 | 1833895 | 2021-10-20 | Fleming | Kentucky | 21069 | 2101 | 34 |
1830428 | 1830428 | 2021-10-19 | Clayton | Iowa | 19043 | 2101 | 58 |
1827179 | 1827179 | 2021-10-18 | Clayton | Iowa | 19043 | 2101 | 58 |
1823930 | 1823930 | 2021-10-17 | Clayton | Iowa | 19043 | 2101 | 58 |
1820681 | 1820681 | 2021-10-16 | Clayton | Iowa | 19043 | 2101 | 58 |
1817432 | 1817432 | 2021-10-15 | Clayton | Iowa | 19043 | 2101 | 58 |
1814184 | 1814184 | 2021-10-14 | Clayton | Iowa | 19043 | 2101 | 58 |
1810935 | 1810935 | 2021-10-13 | Clayton | Iowa | 19043 | 2101 | 58 |
1812726 | 1812726 | 2021-10-13 | Stewart | Tennessee | 47161 | 2101 | 34 |
1810087 | 1810087 | 2021-10-12 | Washburn | Wisconsin | 55129 | 2101 | 26 |
1795445 | 1795445 | 2021-10-08 | Osage | Missouri | 29151 | 2101 | 23 |
1790777 | 1790777 | 2021-10-07 | Marion | Arkansas | 5089 | 2101 | 55 |
1787042 | 1787042 | 2021-10-05 | Orleans | Vermont | 50019 | 2101 | 13 |
1783850 | 1783850 | 2021-10-04 | Giles | Virginia | 51071 | 2101 | 28 |
1768058 | 1768058 | 2021-09-30 | Van Buren | Arkansas | 5141 | 2101 | 37 |
1767102 | 1767102 | 2021-09-29 | Clay | South Dakota | 46027 | 2101 | 16 |
1762912 | 1762912 | 2021-09-28 | Gasconade | Missouri | 29073 | 2101 | 48 |
1742670 | 1742670 | 2021-09-22 | Tipton | Indiana | 18159 | 2101 | 57 |
1738022 | 1738022 | 2021-09-20 | Bandera | Texas | 48019 | 2101 | 43 |
1716759 | 1716759 | 2021-09-14 | O'Brien | Iowa | 19141 | 2101 | 61 |
1713513 | 1713513 | 2021-09-13 | O'Brien | Iowa | 19141 | 2101 | 61 |
1710266 | 1710266 | 2021-09-12 | O'Brien | Iowa | 19141 | 2101 | 61 |
1707019 | 1707019 | 2021-09-11 | O'Brien | Iowa | 19141 | 2101 | 61 |
1703771 | 1703771 | 2021-09-10 | O'Brien | Iowa | 19141 | 2101 | 61 |
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);