ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where cases = 2345 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 30
- Ohio 20
- Alabama 15
- Kentucky 15
- Texas 12
- Indiana 10
- Georgia 9
- Missouri 8
- Minnesota 7
- Tennessee 7
- Virginia 7
- Arkansas 6
- Michigan 6
- North Carolina 6
- California 4
- Idaho 4
- Illinois 4
- Mississippi 4
- New York 4
- Puerto Rico 4
- West Virginia 4
- Wisconsin 4
- South Carolina 3
- Wyoming 3
- Florida 2
- Kansas 2
- Louisiana 2
- Nebraska 2
- New Jersey 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492916 | 2492916 | 2022-05-10 | Clay | West Virginia | 54015 | 2345 | 41 |
2489658 | 2489658 | 2022-05-09 | Clay | West Virginia | 54015 | 2345 | 41 |
2404909 | 2404909 | 2022-04-13 | Poquoson city | Virginia | 51735 | 2345 | 30 |
2339617 | 2339617 | 2022-03-24 | Parmer | Texas | 48369 | 2345 | 52 |
2331131 | 2331131 | 2022-03-22 | Guthrie | Iowa | 19077 | 2345 | 44 |
2327879 | 2327879 | 2022-03-21 | Guthrie | Iowa | 19077 | 2345 | 44 |
2324626 | 2324626 | 2022-03-20 | Guthrie | Iowa | 19077 | 2345 | 44 |
2321372 | 2321372 | 2022-03-19 | Guthrie | Iowa | 19077 | 2345 | 44 |
2318118 | 2318118 | 2022-03-18 | Guthrie | Iowa | 19077 | 2345 | 44 |
2314865 | 2314865 | 2022-03-17 | Guthrie | Iowa | 19077 | 2345 | 44 |
2311612 | 2311612 | 2022-03-16 | Guthrie | Iowa | 19077 | 2345 | 44 |
2308359 | 2308359 | 2022-03-15 | Guthrie | Iowa | 19077 | 2345 | 44 |
2305108 | 2305108 | 2022-03-14 | Guthrie | Iowa | 19077 | 2345 | 44 |
2301856 | 2301856 | 2022-03-13 | Guthrie | Iowa | 19077 | 2345 | 44 |
2298604 | 2298604 | 2022-03-12 | Guthrie | Iowa | 19077 | 2345 | 44 |
2295352 | 2295352 | 2022-03-11 | Guthrie | Iowa | 19077 | 2345 | 44 |
2292100 | 2292100 | 2022-03-10 | Guthrie | Iowa | 19077 | 2345 | 44 |
2294515 | 2294515 | 2022-03-10 | Washakie | Wyoming | 56043 | 2345 | 43 |
2288848 | 2288848 | 2022-03-09 | Guthrie | Iowa | 19077 | 2345 | 44 |
2265847 | 2265847 | 2022-03-02 | Washington | Idaho | 16087 | 2345 | 57 |
2240795 | 2240795 | 2022-02-22 | Linn | Missouri | 29115 | 2345 | 62 |
2224520 | 2224520 | 2022-02-17 | Grundy | Missouri | 29079 | 2345 | 63 |
2152424 | 2152424 | 2022-01-26 | Bath | Kentucky | 21011 | 2345 | 34 |
2141866 | 2141866 | 2022-01-23 | Mariposa | California | 6043 | 2345 | 19 |
2138611 | 2138611 | 2022-01-22 | Mariposa | California | 6043 | 2345 | 19 |
2135355 | 2135355 | 2022-01-21 | Mariposa | California | 6043 | 2345 | 19 |
2103427 | 2103427 | 2022-01-11 | Appanoose | Iowa | 19007 | 2345 | 59 |
2100176 | 2100176 | 2022-01-10 | Appanoose | Iowa | 19007 | 2345 | 59 |
2096925 | 2096925 | 2022-01-09 | Appanoose | Iowa | 19007 | 2345 | 59 |
2093673 | 2093673 | 2022-01-08 | Appanoose | Iowa | 19007 | 2345 | 59 |
2090421 | 2090421 | 2022-01-07 | Appanoose | Iowa | 19007 | 2345 | 59 |
2087170 | 2087170 | 2022-01-06 | Appanoose | Iowa | 19007 | 2345 | 59 |
2089247 | 2089247 | 2022-01-06 | Zapata | Texas | 48505 | 2345 | 46 |
2083918 | 2083918 | 2022-01-05 | Appanoose | Iowa | 19007 | 2345 | 59 |
2082922 | 2082922 | 2022-01-04 | Westmoreland | Virginia | 51193 | 2345 | 39 |
2038044 | 2038044 | 2021-12-22 | Dade | Georgia | 13083 | 2345 | 22 |
2019592 | 2019592 | 2021-12-16 | Tallahatchie | Mississippi | 28135 | 2345 | 53 |
1971471 | 1971471 | 2021-12-01 | Monroe | Ohio | 39111 | 2345 | 61 |
1960181 | 1960181 | 2021-11-28 | Gooding | Idaho | 16047 | 2345 | 42 |
1956930 | 1956930 | 2021-11-27 | Gooding | Idaho | 16047 | 2345 | 42 |
1931910 | 1931910 | 2021-11-19 | Mississippi | Missouri | 29133 | 2345 | 49 |
1929019 | 1929019 | 2021-11-18 | Chowan | North Carolina | 37041 | 2345 | 43 |
1920996 | 1920996 | 2021-11-16 | Bleckley | Georgia | 13023 | 2345 | 81 |
1922635 | 1922635 | 2021-11-16 | Ramsey | North Dakota | 38071 | 2345 | 38 |
1872050 | 1872050 | 2021-11-01 | Inyo | California | 6027 | 2345 | 41 |
1873830 | 1873830 | 2021-11-01 | Polk | North Carolina | 37149 | 2345 | 46 |
1870633 | 1870633 | 2021-10-31 | McKenzie | North Dakota | 38053 | 2345 | 21 |
1871766 | 1871766 | 2021-10-31 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1868517 | 1868517 | 2021-10-30 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1865268 | 1865268 | 2021-10-29 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1859619 | 1859619 | 2021-10-28 | Parke | Indiana | 18121 | 2345 | 30 |
1856370 | 1856370 | 2021-10-27 | Parke | Indiana | 18121 | 2345 | 30 |
1856960 | 1856960 | 2021-10-27 | Houston | Minnesota | 27055 | 2345 | 17 |
1850125 | 1850125 | 2021-10-25 | Caldwell | Kentucky | 21033 | 2345 | 47 |
1850603 | 1850603 | 2021-10-25 | Yalobusha | Mississippi | 28161 | 2345 | 47 |
1844985 | 1844985 | 2021-10-23 | Manati | Puerto Rico | 72091 | 2345 | |
1833530 | 1833530 | 2021-10-20 | Moultrie | Illinois | 17139 | 2345 | 41 |
1830509 | 1830509 | 2021-10-19 | Atchison | Kansas | 20005 | 2345 | 24 |
1832724 | 1832724 | 2021-10-19 | Hardy | West Virginia | 54031 | 2345 | 28 |
1827260 | 1827260 | 2021-10-18 | Atchison | Kansas | 20005 | 2345 | 24 |
1829294 | 1829294 | 2021-10-18 | Appomattox | Virginia | 51011 | 2345 | 36 |
1816283 | 1816283 | 2021-10-14 | Orleans | Vermont | 50019 | 2345 | 13 |
1810726 | 1810726 | 2021-10-13 | Carroll | Illinois | 17015 | 2345 | 39 |
1811178 | 1811178 | 2021-10-13 | Knott | Kentucky | 21119 | 2345 | 36 |
1787928 | 1787928 | 2021-10-06 | Kauai | Hawaii | 15007 | 2345 | 8 |
1788473 | 1788473 | 2021-10-06 | Powell | Kentucky | 21197 | 2345 | 20 |
1789118 | 1789118 | 2021-10-06 | Saline | Nebraska | 31151 | 2345 | 5 |
1789604 | 1789604 | 2021-10-06 | Clatsop | Oregon | 41007 | 2345 | 27 |
1785432 | 1785432 | 2021-10-05 | Ogemaw | Michigan | 26129 | 2345 | 46 |
1782183 | 1782183 | 2021-10-04 | Ogemaw | Michigan | 26129 | 2345 | 46 |
1762431 | 1762431 | 2021-09-28 | Henry | Kentucky | 21103 | 2345 | 23 |
1751777 | 1751777 | 2021-09-25 | Izard | Arkansas | 5065 | 2345 | 53 |
1745922 | 1745922 | 2021-09-23 | Vermillion | Indiana | 18165 | 2345 | 50 |
1745115 | 1745115 | 2021-09-22 | Carbon | Wyoming | 56007 | 2345 | 35 |
1739443 | 1739443 | 2021-09-21 | Buchanan | Iowa | 19019 | 2345 | 38 |
1741490 | 1741490 | 2021-09-21 | Tyler | Texas | 48457 | 2345 | 60 |
1735792 | 1735792 | 2021-09-20 | Brooks | Georgia | 13027 | 2345 | 58 |
1736194 | 1736194 | 2021-09-20 | Buchanan | Iowa | 19019 | 2345 | 38 |
1732944 | 1732944 | 2021-09-19 | Buchanan | Iowa | 19019 | 2345 | 38 |
1733153 | 1733153 | 2021-09-19 | Breckinridge | Kentucky | 21027 | 2345 | 20 |
1729694 | 1729694 | 2021-09-18 | Buchanan | Iowa | 19019 | 2345 | 38 |
1729903 | 1729903 | 2021-09-18 | Breckinridge | Kentucky | 21027 | 2345 | 20 |
1726444 | 1726444 | 2021-09-17 | Buchanan | Iowa | 19019 | 2345 | 38 |
1726653 | 1726653 | 2021-09-17 | Breckinridge | Kentucky | 21027 | 2345 | 20 |
1723195 | 1723195 | 2021-09-16 | Buchanan | Iowa | 19019 | 2345 | 38 |
1719946 | 1719946 | 2021-09-15 | Buchanan | Iowa | 19019 | 2345 | 38 |
1708043 | 1708043 | 2021-09-11 | Seneca | New York | 36099 | 2345 | 58 |
1706016 | 1706016 | 2021-09-10 | Hampshire | West Virginia | 54027 | 2345 | 37 |
1702428 | 1702428 | 2021-09-09 | Llano | Texas | 48299 | 2345 | 60 |
1696081 | 1696081 | 2021-09-07 | St. Croix | Virgin Islands | 78010 | 2345 | 19 |
1689042 | 1689042 | 2021-09-05 | Moca | Puerto Rico | 72099 | 2345 | |
1683529 | 1683529 | 2021-09-04 | Clay | Arkansas | 5021 | 2345 | 52 |
1683073 | 1683073 | 2021-09-03 | Franklin | Vermont | 50011 | 2345 | 40 |
1655280 | 1655280 | 2021-08-26 | Russell | Kentucky | 21207 | 2345 | 49 |
1657192 | 1657192 | 2021-08-26 | Page | Virginia | 51139 | 2345 | 61 |
1652033 | 1652033 | 2021-08-25 | Russell | Kentucky | 21207 | 2345 | 49 |
1646872 | 1646872 | 2021-08-23 | Hampton | South Carolina | 45049 | 2345 | 56 |
1633530 | 1633530 | 2021-08-19 | Hocking | Ohio | 39073 | 2345 | 63 |
1618574 | 1618574 | 2021-08-15 | Cross | Arkansas | 5037 | 2345 | 54 |
1609463 | 1609463 | 2021-08-12 | Owen | Indiana | 18119 | 2345 | 62 |
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);