ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
220 rows where cases = 2531 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 30
- Kentucky 19
- Puerto Rico 19
- Louisiana 15
- Mississippi 11
- Georgia 10
- Virginia 10
- Alabama 9
- Kansas 8
- Missouri 8
- New York 7
- Minnesota 6
- West Virginia 6
- Colorado 5
- Florida 5
- Indiana 5
- Michigan 4
- Nebraska 4
- North Carolina 4
- Tennessee 4
- Arkansas 3
- Idaho 3
- Wisconsin 3
- Illinois 2
- Montana 2
- Nevada 2
- Ohio 2
- Pennsylvania 2
- South Carolina 2
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500697 | 2500697 | 2022-05-13 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2497439 | 2497439 | 2022-05-12 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2494181 | 2494181 | 2022-05-11 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2490923 | 2490923 | 2022-05-10 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2487666 | 2487666 | 2022-05-09 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2461610 | 2461610 | 2022-05-01 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2458354 | 2458354 | 2022-04-30 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2455098 | 2455098 | 2022-04-29 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2451842 | 2451842 | 2022-04-28 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2448586 | 2448586 | 2022-04-27 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2445330 | 2445330 | 2022-04-26 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2442074 | 2442074 | 2022-04-25 | Wolfe | Kentucky | 21237 | 2531 | 26 |
2402131 | 2402131 | 2022-04-13 | Bent | Colorado | 8011 | 2531 | 47 |
2403297 | 2403297 | 2022-04-13 | Yellow Medicine | Minnesota | 27173 | 2531 | 29 |
2398876 | 2398876 | 2022-04-12 | Bent | Colorado | 8011 | 2531 | 47 |
2400043 | 2400043 | 2022-04-12 | Yellow Medicine | Minnesota | 27173 | 2531 | 29 |
2368726 | 2368726 | 2022-04-02 | Blanco | Texas | 48031 | 2531 | 34 |
2337943 | 2337943 | 2022-03-24 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2334689 | 2334689 | 2022-03-23 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2331435 | 2331435 | 2022-03-22 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2328183 | 2328183 | 2022-03-21 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2324930 | 2324930 | 2022-03-20 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2321676 | 2321676 | 2022-03-19 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2318422 | 2318422 | 2022-03-18 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2315169 | 2315169 | 2022-03-17 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2311916 | 2311916 | 2022-03-16 | East Carroll | Louisiana | 22035 | 2531 | 38 |
2287732 | 2287732 | 2022-03-08 | Floyd | Virginia | 51063 | 2531 | 45 |
2284480 | 2284480 | 2022-03-07 | Floyd | Virginia | 51063 | 2531 | 45 |
2261494 | 2261494 | 2022-02-28 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2258243 | 2258243 | 2022-02-27 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2254992 | 2254992 | 2022-02-26 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2251741 | 2251741 | 2022-02-25 | Jim Hogg | Texas | 48247 | 2531 | 21 |
2246272 | 2246272 | 2022-02-24 | Turner | Georgia | 13287 | 2531 | 53 |
2244145 | 2244145 | 2022-02-23 | Richland | Montana | 30083 | 2531 | 30 |
2210954 | 2210954 | 2022-02-13 | Rice | Kansas | 20159 | 2531 | 22 |
2207701 | 2207701 | 2022-02-12 | Rice | Kansas | 20159 | 2531 | 22 |
2209410 | 2209410 | 2022-02-12 | Dawson | Texas | 48115 | 2531 | 92 |
2204448 | 2204448 | 2022-02-11 | Rice | Kansas | 20159 | 2531 | 22 |
2206157 | 2206157 | 2022-02-11 | Dawson | Texas | 48115 | 2531 | 92 |
2201195 | 2201195 | 2022-02-10 | Rice | Kansas | 20159 | 2531 | 22 |
2202904 | 2202904 | 2022-02-10 | Dawson | Texas | 48115 | 2531 | 92 |
2197941 | 2197941 | 2022-02-09 | Rice | Kansas | 20159 | 2531 | 22 |
2191820 | 2191820 | 2022-02-07 | Koochiching | Minnesota | 27071 | 2531 | 34 |
2174493 | 2174493 | 2022-02-02 | Rio Grande | Colorado | 8105 | 2531 | 42 |
2169244 | 2169244 | 2022-01-31 | Lewis | Missouri | 29111 | 2531 | 31 |
2061894 | 2061894 | 2021-12-29 | Gasconade | Missouri | 29073 | 2531 | 87 |
2053905 | 2053905 | 2021-12-27 | Macon | Alabama | 1087 | 2531 | 68 |
2036913 | 2036913 | 2021-12-21 | Decatur | Tennessee | 47039 | 2531 | 44 |
2020753 | 2020753 | 2021-12-16 | Bosque | Texas | 48035 | 2531 | 57 |
2006234 | 2006234 | 2021-12-12 | Bienville | Louisiana | 22013 | 2531 | 99 |
2002983 | 2002983 | 2021-12-11 | Bienville | Louisiana | 22013 | 2531 | 99 |
1999733 | 1999733 | 2021-12-10 | Bienville | Louisiana | 22013 | 2531 | 99 |
1996429 | 1996429 | 2021-12-09 | Magoffin | Kentucky | 21153 | 2531 | 31 |
1988865 | 1988865 | 2021-12-07 | Clay | Alabama | 1027 | 2531 | 69 |
1989472 | 1989472 | 2021-12-07 | De Witt | Illinois | 17039 | 2531 | 38 |
1985615 | 1985615 | 2021-12-06 | Clay | Alabama | 1027 | 2531 | 69 |
1986367 | 1986367 | 2021-12-06 | Parke | Indiana | 18121 | 2531 | 31 |
1986718 | 1986718 | 2021-12-06 | Washington | Kentucky | 21229 | 2531 | 48 |
1969390 | 1969390 | 2021-12-01 | Lamar | Alabama | 1075 | 2531 | 54 |
1970371 | 1970371 | 2021-12-01 | Caldwell | Kentucky | 21033 | 2531 | 52 |
1972287 | 1972287 | 2021-12-01 | Appomattox | Virginia | 51011 | 2531 | 36 |
1967705 | 1967705 | 2021-11-30 | Ste. Genevieve | Missouri | 29186 | 2531 | 34 |
1965654 | 1965654 | 2021-11-29 | Nolan | Texas | 48353 | 2531 | 80 |
1941209 | 1941209 | 2021-11-22 | Union | Kentucky | 21225 | 2531 | 39 |
1932743 | 1932743 | 2021-11-19 | San Sebastian | Puerto Rico | 72131 | 2531 | |
1927107 | 1927107 | 2021-11-18 | Cleburne | Alabama | 1029 | 2531 | 60 |
1929492 | 1929492 | 2021-11-18 | San Sebastian | Puerto Rico | 72131 | 2531 | |
1927036 | 1927036 | 2021-11-17 | Marquette | Wisconsin | 55077 | 2531 | 37 |
1921639 | 1921639 | 2021-11-16 | Green | Kentucky | 21087 | 2531 | 36 |
1878412 | 1878412 | 2021-11-03 | Washington | Alabama | 1129 | 2531 | 52 |
1877678 | 1877678 | 2021-11-02 | Lewis | Tennessee | 47101 | 2531 | 39 |
1869895 | 1869895 | 2021-10-31 | Manistee | Michigan | 26101 | 2531 | 38 |
1866646 | 1866646 | 2021-10-30 | Manistee | Michigan | 26101 | 2531 | 38 |
1862246 | 1862246 | 2021-10-29 | Izard | Arkansas | 5065 | 2531 | 55 |
1863397 | 1863397 | 2021-10-29 | Manistee | Michigan | 26101 | 2531 | 38 |
1851151 | 1851151 | 2021-10-25 | Richland | North Dakota | 38077 | 2531 | 19 |
1824726 | 1824726 | 2021-10-17 | Wright | Missouri | 29229 | 2531 | 47 |
1822231 | 1822231 | 2021-10-16 | Isabela | Puerto Rico | 72071 | 2531 | |
1818982 | 1818982 | 2021-10-15 | Isabela | Puerto Rico | 72071 | 2531 | |
1815733 | 1815733 | 2021-10-14 | Isabela | Puerto Rico | 72071 | 2531 | |
1811182 | 1811182 | 2021-10-13 | Lawrence | Kentucky | 21127 | 2531 | 37 |
1812485 | 1812485 | 2021-10-13 | Isabela | Puerto Rico | 72071 | 2531 | |
1809967 | 1809967 | 2021-10-12 | Barbour | West Virginia | 54001 | 2531 | 43 |
1790492 | 1790492 | 2021-10-06 | Lincoln | West Virginia | 54043 | 2531 | 39 |
1767805 | 1767805 | 2021-09-29 | Iowa | Wisconsin | 55049 | 2531 | 16 |
1717041 | 1717041 | 2021-09-14 | LaSalle | Louisiana | 22059 | 2531 | 41 |
1702786 | 1702786 | 2021-09-09 | Nicholas | West Virginia | 54067 | 2531 | 29 |
1680186 | 1680186 | 2021-09-03 | Fayette | Alabama | 1057 | 2531 | 66 |
1678831 | 1678831 | 2021-09-02 | Caswell | North Carolina | 37033 | 2531 | 31 |
1664911 | 1664911 | 2021-08-29 | Sumner | Kansas | 20191 | 2531 | 53 |
1661663 | 1661663 | 2021-08-28 | Sumner | Kansas | 20191 | 2531 | 53 |
1663590 | 1663590 | 2021-08-28 | Rutland | Vermont | 50021 | 2531 | 22 |
1658415 | 1658415 | 2021-08-27 | Sumner | Kansas | 20191 | 2531 | 53 |
1652355 | 1652355 | 2021-08-25 | Clay | Mississippi | 28025 | 2531 | 60 |
1630730 | 1630730 | 2021-08-18 | Crockett | Tennessee | 47033 | 2531 | 52 |
1627991 | 1627991 | 2021-08-17 | Waynesboro city | Virginia | 51820 | 2531 | 39 |
1621991 | 1621991 | 2021-08-16 | Routt | Colorado | 8107 | 2531 | 21 |
1624744 | 1624744 | 2021-08-16 | Waynesboro city | Virginia | 51820 | 2531 | 39 |
1608458 | 1608458 | 2021-08-11 | Mecklenburg | Virginia | 51117 | 2531 | 68 |
1599344 | 1599344 | 2021-08-09 | Appling | Georgia | 13001 | 2531 | 72 |
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);