ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
233 rows where cases = 2503 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 24
- Texas 19
- Missouri 15
- Puerto Rico 15
- Alabama 14
- Oklahoma 11
- Tennessee 11
- Illinois 10
- Georgia 9
- Louisiana 9
- Ohio 9
- Iowa 8
- North Carolina 8
- Indiana 7
- Kansas 7
- Virginia 6
- Pennsylvania 5
- Arkansas 4
- Michigan 4
- Mississippi 4
- New York 4
- Florida 3
- Idaho 3
- Minnesota 3
- Alaska 2
- Maryland 2
- Massachusetts 2
- New Hampshire 2
- North Dakota 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497025 | 2497025 | 2022-05-12 | Benton | Indiana | 18007 | 2503 | 21 |
2493767 | 2493767 | 2022-05-11 | Benton | Indiana | 18007 | 2503 | 21 |
2335953 | 2335953 | 2022-03-23 | Santa Isabel | Puerto Rico | 72133 | 2503 | |
2332699 | 2332699 | 2022-03-22 | Santa Isabel | Puerto Rico | 72133 | 2503 | |
2329446 | 2329446 | 2022-03-21 | Santa Isabel | Puerto Rico | 72133 | 2503 | |
2326194 | 2326194 | 2022-03-20 | Santa Isabel | Puerto Rico | 72133 | 2503 | |
2314193 | 2314193 | 2022-03-17 | Perry | Arkansas | 5105 | 2503 | 36 |
2267889 | 2267889 | 2022-03-02 | Blanco | Texas | 48031 | 2503 | 33 |
2264636 | 2264636 | 2022-03-01 | Blanco | Texas | 48031 | 2503 | 33 |
2240501 | 2240501 | 2022-02-22 | Crawford | Michigan | 26039 | 2503 | 26 |
2240725 | 2240725 | 2022-02-22 | Tunica | Mississippi | 28143 | 2503 | 44 |
2237019 | 2237019 | 2022-02-21 | Edmonson | Kentucky | 21061 | 2503 | 38 |
2237250 | 2237250 | 2022-02-21 | Crawford | Michigan | 26039 | 2503 | 26 |
2233999 | 2233999 | 2022-02-20 | Crawford | Michigan | 26039 | 2503 | 26 |
2203176 | 2203176 | 2022-02-10 | Clarke | Virginia | 51043 | 2503 | 38 |
2196942 | 2196942 | 2022-02-08 | Big Horn | Wyoming | 56003 | 2503 | 60 |
2188180 | 2188180 | 2022-02-06 | Rice | Kansas | 20159 | 2503 | 19 |
2184927 | 2184927 | 2022-02-05 | Rice | Kansas | 20159 | 2503 | 19 |
2181675 | 2181675 | 2022-02-04 | Rice | Kansas | 20159 | 2503 | 19 |
2177538 | 2177538 | 2022-02-03 | Valdez-Cordova Census Area | Alaska | 2261 | 2503 | 15 |
2174285 | 2174285 | 2022-02-02 | Valdez-Cordova Census Area | Alaska | 2261 | 2503 | 15 |
2152503 | 2152503 | 2022-01-26 | Metcalfe | Kentucky | 21169 | 2503 | 54 |
2125704 | 2125704 | 2022-01-18 | Unknown | Connecticut | 2503 | 5 | |
2122550 | 2122550 | 2022-01-17 | Charlton | Georgia | 13049 | 2503 | 58 |
2111360 | 2111360 | 2022-01-13 | Baker | Oregon | 41001 | 2503 | 38 |
2108689 | 2108689 | 2022-01-12 | Pecos | Texas | 48371 | 2503 | 59 |
2097655 | 2097655 | 2022-01-09 | Dent | Missouri | 29065 | 2503 | 64 |
2080561 | 2080561 | 2022-01-04 | Wabash | Illinois | 17185 | 2503 | 22 |
2081349 | 2081349 | 2022-01-04 | Tallahatchie | Mississippi | 28135 | 2503 | 53 |
2082071 | 2082071 | 2022-01-04 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2078819 | 2078819 | 2022-01-03 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2078968 | 2078968 | 2022-01-03 | Coamo | Puerto Rico | 72043 | 2503 | |
2075568 | 2075568 | 2022-01-02 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2070294 | 2070294 | 2022-01-01 | Van Buren | Arkansas | 5141 | 2503 | 45 |
2072317 | 2072317 | 2022-01-01 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2069066 | 2069066 | 2021-12-31 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2065815 | 2065815 | 2021-12-30 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2062565 | 2062565 | 2021-12-29 | Okfuskee | Oklahoma | 40107 | 2503 | 49 |
2056220 | 2056220 | 2021-12-27 | Fajardo | Puerto Rico | 72053 | 2503 | |
2037656 | 2037656 | 2021-12-22 | Macon | Alabama | 1087 | 2503 | 68 |
2035897 | 2035897 | 2021-12-21 | Gasconade | Missouri | 29073 | 2503 | 86 |
2019137 | 2019137 | 2021-12-16 | Clinton | Kentucky | 21053 | 2503 | 40 |
2015887 | 2015887 | 2021-12-15 | Clinton | Kentucky | 21053 | 2503 | 40 |
2017177 | 2017177 | 2021-12-15 | Potter | Pennsylvania | 42105 | 2503 | 72 |
2006140 | 2006140 | 2021-12-12 | Estill | Kentucky | 21065 | 2503 | 35 |
2002889 | 2002889 | 2021-12-11 | Estill | Kentucky | 21065 | 2503 | 35 |
1999639 | 1999639 | 2021-12-10 | Estill | Kentucky | 21065 | 2503 | 35 |
1990909 | 1990909 | 2021-12-07 | Walsh | North Dakota | 38099 | 2503 | 30 |
1960661 | 1960661 | 2021-11-28 | Knott | Kentucky | 21119 | 2503 | 43 |
1957410 | 1957410 | 2021-11-27 | Knott | Kentucky | 21119 | 2503 | 43 |
1954159 | 1954159 | 2021-11-26 | Knott | Kentucky | 21119 | 2503 | 43 |
1950908 | 1950908 | 2021-11-25 | Knott | Kentucky | 21119 | 2503 | 43 |
1947657 | 1947657 | 2021-11-24 | Knott | Kentucky | 21119 | 2503 | 43 |
1943382 | 1943382 | 2021-11-23 | Lamar | Alabama | 1075 | 2503 | 53 |
1943989 | 1943989 | 2021-11-23 | Jo Daviess | Illinois | 17085 | 2503 | 32 |
1914765 | 1914765 | 2021-11-14 | Moultrie | Illinois | 17139 | 2503 | 41 |
1911515 | 1911515 | 2021-11-13 | Moultrie | Illinois | 17139 | 2503 | 41 |
1908266 | 1908266 | 2021-11-12 | Moultrie | Illinois | 17139 | 2503 | 41 |
1910396 | 1910396 | 2021-11-12 | Nolan | Texas | 48353 | 2503 | 79 |
1907147 | 1907147 | 2021-11-11 | Nolan | Texas | 48353 | 2503 | 79 |
1892460 | 1892460 | 2021-11-07 | Union | Kentucky | 21225 | 2503 | 34 |
1892474 | 1892474 | 2021-11-07 | Bienville | Louisiana | 22013 | 2503 | 97 |
1889210 | 1889210 | 2021-11-06 | Union | Kentucky | 21225 | 2503 | 34 |
1889224 | 1889224 | 2021-11-06 | Bienville | Louisiana | 22013 | 2503 | 97 |
1885960 | 1885960 | 2021-11-05 | Union | Kentucky | 21225 | 2503 | 34 |
1885974 | 1885974 | 2021-11-05 | Bienville | Louisiana | 22013 | 2503 | 97 |
1882725 | 1882725 | 2021-11-04 | Bienville | Louisiana | 22013 | 2503 | 97 |
1884830 | 1884830 | 2021-11-04 | Goshen | Wyoming | 56015 | 2503 | 39 |
1879476 | 1879476 | 2021-11-03 | Bienville | Louisiana | 22013 | 2503 | 97 |
1850688 | 1850688 | 2021-10-25 | Pike | Missouri | 29163 | 2503 | 37 |
1847438 | 1847438 | 2021-10-24 | Pike | Missouri | 29163 | 2503 | 37 |
1825990 | 1825990 | 2021-10-17 | Zavala | Texas | 48507 | 2503 | 53 |
1822741 | 1822741 | 2021-10-16 | Zavala | Texas | 48507 | 2503 | 53 |
1819492 | 1819492 | 2021-10-15 | Zavala | Texas | 48507 | 2503 | 53 |
1814419 | 1814419 | 2021-10-14 | Henry | Kentucky | 21103 | 2503 | 24 |
1815763 | 1815763 | 2021-10-14 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1815822 | 1815822 | 2021-10-14 | Saluda | South Carolina | 45081 | 2503 | 54 |
1812515 | 1812515 | 2021-10-13 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1809266 | 1809266 | 2021-10-12 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1806016 | 1806016 | 2021-10-11 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1787766 | 1787766 | 2021-10-06 | Bacon | Georgia | 13005 | 2503 | 53 |
1759476 | 1759476 | 2021-09-27 | Dodge | Minnesota | 27039 | 2503 | 5 |
1744910 | 1744910 | 2021-09-22 | Powhatan | Virginia | 51145 | 2503 | 21 |
1741168 | 1741168 | 2021-09-21 | Benton | Tennessee | 47005 | 2503 | 44 |
1737919 | 1737919 | 2021-09-20 | Benton | Tennessee | 47005 | 2503 | 44 |
1697415 | 1697415 | 2021-09-08 | Bourbon | Kentucky | 21017 | 2503 | 21 |
1693886 | 1693886 | 2021-09-07 | Fulton | Indiana | 18049 | 2503 | 48 |
1695762 | 1695762 | 2021-09-07 | Sequatchie | Tennessee | 47153 | 2503 | 30 |
1692927 | 1692927 | 2021-09-06 | Page | Virginia | 51139 | 2503 | 61 |
1678408 | 1678408 | 2021-09-02 | Andrew | Missouri | 29003 | 2503 | 23 |
1674808 | 1674808 | 2021-09-01 | Jackson | Louisiana | 22049 | 2503 | 58 |
1675811 | 1675811 | 2021-09-01 | Wyandot | Ohio | 39175 | 2503 | 57 |
1661880 | 1661880 | 2021-08-28 | Caroline | Maryland | 24011 | 2503 | 34 |
1631402 | 1631402 | 2021-08-18 | Vilas | Wisconsin | 55125 | 2503 | 45 |
1578783 | 1578783 | 2021-08-02 | Johnson | Tennessee | 47091 | 2503 | 39 |
1569865 | 1569865 | 2021-07-31 | Logan | Arkansas | 5083 | 2503 | 23 |
1541257 | 1541257 | 2021-07-22 | Randolph | Indiana | 18135 | 2503 | 84 |
1531535 | 1531535 | 2021-07-19 | Washington | Indiana | 18175 | 2503 | 37 |
1523145 | 1523145 | 2021-07-16 | Van Wert | Ohio | 39161 | 2503 | 65 |
1523652 | 1523652 | 2021-07-16 | Burleson | Texas | 48051 | 2503 | 48 |
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);