ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
302 rows where cases = 1739 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 39
- Iowa 16
- North Carolina 16
- Virginia 16
- Arkansas 14
- Kentucky 13
- Illinois 12
- Oklahoma 11
- Georgia 10
- Louisiana 10
- Michigan 10
- Missouri 10
- Indiana 9
- Kansas 9
- Mississippi 9
- Nebraska 9
- Puerto Rico 9
- Idaho 8
- Minnesota 8
- Tennessee 7
- Pennsylvania 6
- West Virginia 6
- Alabama 5
- Ohio 5
- Maine 4
- New Mexico 4
- Wisconsin 4
- New York 3
- South Dakota 3
- Alaska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2398756 | 2398756 | 2022-04-12 | Dallas | Arkansas | 5039 | 1739 | 31 |
2395501 | 2395501 | 2022-04-11 | Dallas | Arkansas | 5039 | 1739 | 31 |
2392245 | 2392245 | 2022-04-10 | Dallas | Arkansas | 5039 | 1739 | 31 |
2388989 | 2388989 | 2022-04-09 | Dallas | Arkansas | 5039 | 1739 | 31 |
2385734 | 2385734 | 2022-04-08 | Dallas | Arkansas | 5039 | 1739 | 31 |
2382479 | 2382479 | 2022-04-07 | Dallas | Arkansas | 5039 | 1739 | 31 |
2205841 | 2205841 | 2022-02-11 | Hormigueros | Puerto Rico | 72067 | 1739 | |
2194140 | 2194140 | 2022-02-08 | Crawford | Georgia | 13079 | 1739 | 50 |
2191995 | 2191995 | 2022-02-07 | Harrison | Missouri | 29081 | 1739 | 27 |
2172559 | 2172559 | 2022-02-01 | Blaine | Montana | 30005 | 1739 | 28 |
2173283 | 2173283 | 2022-02-01 | Arroyo | Puerto Rico | 72015 | 1739 | |
2173758 | 2173758 | 2022-02-01 | Rains | Texas | 48379 | 1739 | 52 |
2132925 | 2132925 | 2022-01-20 | Cumberland | Kentucky | 21057 | 1739 | 23 |
2131345 | 2131345 | 2022-01-19 | Floyd | Texas | 48153 | 1739 | 42 |
2128473 | 2128473 | 2022-01-18 | Lincoln | Washington | 53043 | 1739 | 26 |
2115518 | 2115518 | 2022-01-14 | Pleasants | West Virginia | 54073 | 1739 | 32 |
2098935 | 2098935 | 2022-01-09 | Parmer | Texas | 48369 | 1739 | 45 |
2084165 | 2084165 | 2022-01-05 | Hancock | Kentucky | 21091 | 1739 | 19 |
2082093 | 2082093 | 2022-01-04 | Washita | Oklahoma | 40149 | 1739 | 34 |
2078128 | 2078128 | 2022-01-03 | Carroll | Missouri | 29033 | 1739 | 39 |
2078841 | 2078841 | 2022-01-03 | Washita | Oklahoma | 40149 | 1739 | 34 |
2075590 | 2075590 | 2022-01-02 | Washita | Oklahoma | 40149 | 1739 | 34 |
2076360 | 2076360 | 2022-01-02 | Lexington city | Virginia | 51678 | 1739 | 38 |
2072339 | 2072339 | 2022-01-01 | Washita | Oklahoma | 40149 | 1739 | 34 |
2073109 | 2073109 | 2022-01-01 | Lexington city | Virginia | 51678 | 1739 | 38 |
2069088 | 2069088 | 2021-12-31 | Washita | Oklahoma | 40149 | 1739 | 34 |
2069858 | 2069858 | 2021-12-31 | Lexington city | Virginia | 51678 | 1739 | 38 |
2065837 | 2065837 | 2021-12-30 | Washita | Oklahoma | 40149 | 1739 | 34 |
2062587 | 2062587 | 2021-12-29 | Washita | Oklahoma | 40149 | 1739 | 34 |
2057673 | 2057673 | 2021-12-28 | Benewah | Idaho | 16009 | 1739 | 30 |
2058143 | 2058143 | 2021-12-28 | Edmonson | Kentucky | 21061 | 1739 | 34 |
2051180 | 2051180 | 2021-12-26 | Boundary | Idaho | 16021 | 1739 | 50 |
2047930 | 2047930 | 2021-12-25 | Boundary | Idaho | 16021 | 1739 | 50 |
2044680 | 2044680 | 2021-12-24 | Boundary | Idaho | 16021 | 1739 | 50 |
2041431 | 2041431 | 2021-12-23 | Boundary | Idaho | 16021 | 1739 | 50 |
2043837 | 2043837 | 2021-12-23 | Galax city | Virginia | 51640 | 1739 | 65 |
2013586 | 2013586 | 2021-12-14 | Perquimans | North Carolina | 37143 | 1739 | 16 |
2010335 | 2010335 | 2021-12-13 | Perquimans | North Carolina | 37143 | 1739 | 16 |
2000191 | 2000191 | 2021-12-10 | Ralls | Missouri | 29173 | 1739 | 18 |
1982950 | 1982950 | 2021-12-05 | Teton | Idaho | 16081 | 1739 | 7 |
1979700 | 1979700 | 2021-12-04 | Teton | Idaho | 16081 | 1739 | 7 |
1980713 | 1980713 | 2021-12-04 | Wayne | Missouri | 29223 | 1739 | 35 |
1970801 | 1970801 | 2021-12-01 | Jefferson Davis | Mississippi | 28065 | 1739 | 43 |
1966635 | 1966635 | 2021-11-30 | Turner | Georgia | 13287 | 1739 | 49 |
1922568 | 1922568 | 2021-11-16 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1919318 | 1919318 | 2021-11-15 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1916068 | 1916068 | 2021-11-14 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1912818 | 1912818 | 2021-11-13 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1907768 | 1907768 | 2021-11-12 | Scott | Arkansas | 5127 | 1739 | 30 |
1909111 | 1909111 | 2021-11-12 | Cedar | Missouri | 29039 | 1739 | 31 |
1909568 | 1909568 | 2021-11-12 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1904519 | 1904519 | 2021-11-11 | Scott | Arkansas | 5127 | 1739 | 30 |
1906319 | 1906319 | 2021-11-11 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1903070 | 1903070 | 2021-11-10 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1899820 | 1899820 | 2021-11-09 | Pamlico | North Carolina | 37137 | 1739 | 26 |
1892599 | 1892599 | 2021-11-07 | Benzie | Michigan | 26019 | 1739 | 40 |
1889349 | 1889349 | 2021-11-06 | Benzie | Michigan | 26019 | 1739 | 40 |
1886099 | 1886099 | 2021-11-05 | Benzie | Michigan | 26019 | 1739 | 40 |
1881675 | 1881675 | 2021-11-04 | Ketchikan Gateway Borough | Alaska | 2130 | 1739 | 9 |
1878439 | 1878439 | 2021-11-03 | Valdez-Cordova Census Area | Alaska | 2261 | 1739 | 8 |
1869267 | 1869267 | 2021-10-31 | Menard | Illinois | 17129 | 1739 | 17 |
1869819 | 1869819 | 2021-10-31 | Kent | Maryland | 24029 | 1739 | 56 |
1866018 | 1866018 | 2021-10-30 | Menard | Illinois | 17129 | 1739 | 17 |
1867728 | 1867728 | 2021-10-30 | Loiza | Puerto Rico | 72087 | 1739 | |
1862769 | 1862769 | 2021-10-29 | Menard | Illinois | 17129 | 1739 | 17 |
1860697 | 1860697 | 2021-10-28 | Socorro | New Mexico | 35053 | 1739 | 62 |
1861279 | 1861279 | 2021-10-28 | Calhoun | South Carolina | 45017 | 1739 | 52 |
1856716 | 1856716 | 2021-10-27 | Todd | Kentucky | 21219 | 1739 | 31 |
1858030 | 1858030 | 2021-10-27 | Calhoun | South Carolina | 45017 | 1739 | 52 |
1833340 | 1833340 | 2021-10-20 | Long | Georgia | 13183 | 1739 | 24 |
1824801 | 1824801 | 2021-10-17 | Colfax | Nebraska | 31037 | 1739 | 22 |
1821552 | 1821552 | 2021-10-16 | Colfax | Nebraska | 31037 | 1739 | 22 |
1818303 | 1818303 | 2021-10-15 | Colfax | Nebraska | 31037 | 1739 | 22 |
1811875 | 1811875 | 2021-10-13 | Unknown | Nebraska | 1739 | 113 | |
1812599 | 1812599 | 2021-10-13 | Dewey | South Dakota | 46041 | 1739 | 30 |
1808061 | 1808061 | 2021-10-12 | Knox | Maine | 23013 | 1739 | 12 |
1804810 | 1804810 | 2021-10-11 | Knox | Maine | 23013 | 1739 | 12 |
1805713 | 1805713 | 2021-10-11 | Harrison | Ohio | 39067 | 1739 | 41 |
1801561 | 1801561 | 2021-10-10 | Knox | Maine | 23013 | 1739 | 12 |
1798312 | 1798312 | 2021-10-09 | Knox | Maine | 23013 | 1739 | 12 |
1796240 | 1796240 | 2021-10-08 | Juana Diaz | Puerto Rico | 72075 | 1739 | |
1793562 | 1793562 | 2021-10-07 | Brunswick | Virginia | 51025 | 1739 | 31 |
1781645 | 1781645 | 2021-10-04 | Pulaski | Indiana | 18131 | 1739 | 51 |
1778985 | 1778985 | 2021-10-03 | Kanabec | Minnesota | 27065 | 1739 | 29 |
1779089 | 1779089 | 2021-10-03 | Montgomery | Mississippi | 28097 | 1739 | 54 |
1775735 | 1775735 | 2021-10-02 | Kanabec | Minnesota | 27065 | 1739 | 29 |
1775839 | 1775839 | 2021-10-02 | Montgomery | Mississippi | 28097 | 1739 | 54 |
1772485 | 1772485 | 2021-10-01 | Kanabec | Minnesota | 27065 | 1739 | 29 |
1772589 | 1772589 | 2021-10-01 | Montgomery | Mississippi | 28097 | 1739 | 54 |
1750730 | 1750730 | 2021-09-24 | Camuy | Puerto Rico | 72027 | 1739 | |
1746032 | 1746032 | 2021-09-23 | Allen | Kansas | 20001 | 1739 | 25 |
1742783 | 1742783 | 2021-09-22 | Allen | Kansas | 20001 | 1739 | 25 |
1745045 | 1745045 | 2021-09-22 | Buffalo | Wisconsin | 55011 | 1739 | 7 |
1740409 | 1740409 | 2021-09-21 | Humboldt | Nevada | 32013 | 1739 | 17 |
1720538 | 1720538 | 2021-09-15 | Sibley | Minnesota | 27143 | 1739 | 10 |
1716858 | 1716858 | 2021-09-14 | Osage | Kansas | 20139 | 1739 | 30 |
1713612 | 1713612 | 2021-09-13 | Osage | Kansas | 20139 | 1739 | 30 |
1671075 | 1671075 | 2021-08-31 | Massac | Illinois | 17127 | 1739 | 45 |
1671243 | 1671243 | 2021-08-31 | Floyd | Iowa | 19067 | 1739 | 42 |
1667996 | 1667996 | 2021-08-30 | Floyd | Iowa | 19067 | 1739 | 42 |
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);