ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
349 rows where cases = 1191 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Kentucky 23
- Georgia 20
- Louisiana 17
- Missouri 16
- Virginia 16
- Kansas 14
- North Carolina 13
- South Dakota 13
- Arkansas 12
- Iowa 12
- Montana 12
- Minnesota 11
- Illinois 10
- Mississippi 10
- Nebraska 10
- Idaho 7
- California 6
- Puerto Rico 6
- Tennessee 6
- West Virginia 6
- Wisconsin 6
- Michigan 5
- Pennsylvania 5
- South Carolina 5
- Colorado 4
- New York 4
- North Dakota 4
- Ohio 4
- Florida 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502531 | 2502531 | 2022-05-13 | Charles City | Virginia | 51036 | 1191 | 27 |
2479643 | 2479643 | 2022-05-06 | Wheeler | Texas | 48483 | 1191 | 23 |
2476385 | 2476385 | 2022-05-05 | Wheeler | Texas | 48483 | 1191 | 23 |
2473128 | 2473128 | 2022-05-04 | Wheeler | Texas | 48483 | 1191 | 22 |
2469872 | 2469872 | 2022-05-03 | Wheeler | Texas | 48483 | 1191 | 22 |
2466616 | 2466616 | 2022-05-02 | Wheeler | Texas | 48483 | 1191 | 22 |
2463361 | 2463361 | 2022-05-01 | Wheeler | Texas | 48483 | 1191 | 22 |
2460105 | 2460105 | 2022-04-30 | Wheeler | Texas | 48483 | 1191 | 22 |
2456849 | 2456849 | 2022-04-29 | Wheeler | Texas | 48483 | 1191 | 22 |
2452440 | 2452440 | 2022-04-28 | Howard | Nebraska | 31093 | 1191 | 15 |
2453593 | 2453593 | 2022-04-28 | Wheeler | Texas | 48483 | 1191 | 22 |
2449184 | 2449184 | 2022-04-27 | Howard | Nebraska | 31093 | 1191 | 15 |
2445927 | 2445927 | 2022-04-26 | Howard | Nebraska | 31093 | 1191 | 15 |
2329759 | 2329759 | 2022-03-21 | Goliad | Texas | 48175 | 1191 | 32 |
2326507 | 2326507 | 2022-03-20 | Goliad | Texas | 48175 | 1191 | 32 |
2323254 | 2323254 | 2022-03-19 | Goliad | Texas | 48175 | 1191 | 32 |
2217849 | 2217849 | 2022-02-15 | Lincoln | Minnesota | 27081 | 1191 | 6 |
2212485 | 2212485 | 2022-02-13 | Lyman | South Dakota | 46085 | 1191 | 12 |
2209232 | 2209232 | 2022-02-12 | Lyman | South Dakota | 46085 | 1191 | 12 |
2205979 | 2205979 | 2022-02-11 | Lyman | South Dakota | 46085 | 1191 | 12 |
2199228 | 2199228 | 2022-02-09 | Wallowa | Oregon | 41063 | 1191 | 14 |
2169353 | 2169353 | 2022-01-31 | Teton | Montana | 30099 | 1191 | 18 |
2151059 | 2151059 | 2022-01-25 | Kane | Utah | 49025 | 1191 | 13 |
2132870 | 2132870 | 2022-01-20 | Republic | Kansas | 20157 | 1191 | 14 |
2129617 | 2129617 | 2022-01-19 | Republic | Kansas | 20157 | 1191 | 14 |
2128117 | 2128117 | 2022-01-18 | Hartley | Texas | 48205 | 1191 | 3 |
2106089 | 2106089 | 2022-01-12 | Modoc | California | 6049 | 1191 | 11 |
2100746 | 2100746 | 2022-01-10 | Mahnomen | Minnesota | 27087 | 1191 | 17 |
2092270 | 2092270 | 2022-01-07 | Brooks | Texas | 48047 | 1191 | 47 |
2082875 | 2082875 | 2022-01-04 | Middlesex | Virginia | 51119 | 1191 | 34 |
2078630 | 2078630 | 2022-01-03 | Dickey | North Dakota | 38021 | 1191 | 38 |
2075379 | 2075379 | 2022-01-02 | Dickey | North Dakota | 38021 | 1191 | 38 |
2072128 | 2072128 | 2022-01-01 | Dickey | North Dakota | 38021 | 1191 | 38 |
2066991 | 2066991 | 2021-12-31 | Dallas | Arkansas | 5039 | 1191 | 20 |
2053578 | 2053578 | 2021-12-26 | Fairfax city | Virginia | 51600 | 1191 | 36 |
2050328 | 2050328 | 2021-12-25 | Fairfax city | Virginia | 51600 | 1191 | 36 |
2047078 | 2047078 | 2021-12-24 | Fairfax city | Virginia | 51600 | 1191 | 36 |
1997132 | 1997132 | 2021-12-09 | Pershing | Nevada | 32027 | 1191 | 27 |
1989131 | 1989131 | 2021-12-07 | Lake | Colorado | 8065 | 1191 | 1 |
1991520 | 1991520 | 2021-12-07 | Coleman | Texas | 48083 | 1191 | 56 |
1975482 | 1975482 | 2021-12-02 | Beaver | Utah | 49001 | 1191 | 14 |
1968883 | 1968883 | 2021-11-30 | Marion | Texas | 48315 | 1191 | 53 |
1939845 | 1939845 | 2021-11-21 | Lunenburg | Virginia | 51111 | 1191 | 22 |
1936595 | 1936595 | 2021-11-20 | Lunenburg | Virginia | 51111 | 1191 | 22 |
1936730 | 1936730 | 2021-11-20 | Pendleton | West Virginia | 54071 | 1191 | 15 |
1933345 | 1933345 | 2021-11-19 | Lunenburg | Virginia | 51111 | 1191 | 22 |
1902778 | 1902778 | 2021-11-10 | Butler | Nebraska | 31023 | 1191 | 12 |
1897933 | 1897933 | 2021-11-09 | Sitka City and Borough | Alaska | 2220 | 1191 | 4 |
1895068 | 1895068 | 2021-11-08 | Jenkins | Georgia | 13165 | 1191 | 58 |
1878650 | 1878650 | 2021-11-03 | San Miguel | Colorado | 8113 | 1191 | 5 |
1872152 | 1872152 | 2021-11-01 | San Miguel | Colorado | 8113 | 1191 | 5 |
1869721 | 1869721 | 2021-10-31 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1866472 | 1866472 | 2021-10-30 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1863223 | 1863223 | 2021-10-29 | Wolfe | Kentucky | 21237 | 1191 | 11 |
1849265 | 1849265 | 2021-10-25 | Monroe | Arkansas | 5095 | 1191 | 24 |
1846015 | 1846015 | 2021-10-24 | Monroe | Arkansas | 5095 | 1191 | 24 |
1842765 | 1842765 | 2021-10-23 | Monroe | Arkansas | 5095 | 1191 | 24 |
1833972 | 1833972 | 2021-10-20 | Trimble | Kentucky | 21223 | 1191 | 17 |
1827795 | 1827795 | 2021-10-18 | Franklin | Mississippi | 28037 | 1191 | 28 |
1824546 | 1824546 | 2021-10-17 | Franklin | Mississippi | 28037 | 1191 | 28 |
1821297 | 1821297 | 2021-10-16 | Franklin | Mississippi | 28037 | 1191 | 28 |
1822683 | 1822683 | 2021-10-16 | Refugio | Texas | 48391 | 1191 | 31 |
1818048 | 1818048 | 2021-10-15 | Franklin | Mississippi | 28037 | 1191 | 28 |
1819294 | 1819294 | 2021-10-15 | Dallam | Texas | 48111 | 1191 | 29 |
1814799 | 1814799 | 2021-10-14 | Franklin | Mississippi | 28037 | 1191 | 28 |
1790316 | 1790316 | 2021-10-06 | Buena Vista city | Virginia | 51530 | 1191 | 22 |
1790321 | 1790321 | 2021-10-06 | Charlotte | Virginia | 51037 | 1191 | 24 |
1785885 | 1785885 | 2021-10-05 | Wayne | Nebraska | 31179 | 1191 | 8 |
1778193 | 1778193 | 2021-10-03 | Boundary | Idaho | 16021 | 1191 | 20 |
1759840 | 1759840 | 2021-09-27 | Hamilton | Nebraska | 31081 | 1191 | 19 |
1761210 | 1761210 | 2021-09-27 | Lincoln | Washington | 53043 | 1191 | 17 |
1739548 | 1739548 | 2021-09-21 | Cloud | Kansas | 20029 | 1191 | 26 |
1741778 | 1741778 | 2021-09-21 | Ritchie | West Virginia | 54085 | 1191 | 14 |
1736299 | 1736299 | 2021-09-20 | Cloud | Kansas | 20029 | 1191 | 26 |
1732661 | 1732661 | 2021-09-19 | Taylor | Georgia | 13269 | 1191 | 28 |
1729411 | 1729411 | 2021-09-18 | Taylor | Georgia | 13269 | 1191 | 28 |
1726161 | 1726161 | 2021-09-17 | Taylor | Georgia | 13269 | 1191 | 28 |
1726238 | 1726238 | 2021-09-17 | Valley | Idaho | 16085 | 1191 | 6 |
1728359 | 1728359 | 2021-09-17 | Hamilton | Texas | 48193 | 1191 | 29 |
1712820 | 1712820 | 2021-09-13 | Searcy | Arkansas | 5129 | 1191 | 23 |
1709946 | 1709946 | 2021-09-12 | Wilcox | Georgia | 13315 | 1191 | 50 |
1706699 | 1706699 | 2021-09-11 | Wilcox | Georgia | 13315 | 1191 | 50 |
1703451 | 1703451 | 2021-09-10 | Wilcox | Georgia | 13315 | 1191 | 50 |
1700201 | 1700201 | 2021-09-09 | Wilcox | Georgia | 13315 | 1191 | 50 |
1700701 | 1700701 | 2021-09-09 | Hancock | Kentucky | 21091 | 1191 | 16 |
1701198 | 1701198 | 2021-09-09 | Iron | Missouri | 29093 | 1191 | 10 |
1698296 | 1698296 | 2021-09-08 | Schuyler | New York | 36097 | 1191 | 15 |
1699064 | 1699064 | 2021-09-08 | Castro | Texas | 48069 | 1191 | 33 |
1689111 | 1689111 | 2021-09-05 | McCormick | South Carolina | 45065 | 1191 | 28 |
1685861 | 1685861 | 2021-09-04 | McCormick | South Carolina | 45065 | 1191 | 28 |
1682610 | 1682610 | 2021-09-03 | McCormick | South Carolina | 45065 | 1191 | 28 |
1673722 | 1673722 | 2021-09-01 | Sumter | Alabama | 1119 | 1191 | 34 |
1649065 | 1649065 | 2021-08-24 | Pipestone | Minnesota | 27117 | 1191 | 26 |
1642151 | 1642151 | 2021-08-22 | Pawnee | Kansas | 20145 | 1191 | 14 |
1638901 | 1638901 | 2021-08-21 | Pawnee | Kansas | 20145 | 1191 | 14 |
1635651 | 1635651 | 2021-08-20 | Pawnee | Kansas | 20145 | 1191 | 14 |
1622210 | 1622210 | 2021-08-16 | Stewart | Georgia | 13259 | 1191 | 26 |
1620417 | 1620417 | 2021-08-15 | Pamlico | North Carolina | 37137 | 1191 | 14 |
1620539 | 1620539 | 2021-08-15 | Harrison | Ohio | 39067 | 1191 | 38 |
1617169 | 1617169 | 2021-08-14 | Pamlico | North Carolina | 37137 | 1191 | 14 |
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);