ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where cases = 6228 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Indiana 9
- Iowa 7
- Oklahoma 7
- Kentucky 5
- Pennsylvania 5
- Georgia 4
- Michigan 4
- Tennessee 4
- Washington 4
- Alabama 3
- Illinois 3
- Nebraska 3
- North Carolina 3
- Texas 3
- Florida 2
- Mississippi 2
- New York 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- California 1
- Louisiana 1
- Missouri 1
- Puerto Rico 1
- Rhode Island 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483904 | 2483904 | 2022-05-08 | Crawford | Illinois | 17033 | 6228 | 61 |
2480646 | 2480646 | 2022-05-07 | Crawford | Illinois | 17033 | 6228 | 61 |
2477388 | 2477388 | 2022-05-06 | Crawford | Illinois | 17033 | 6228 | 61 |
2205821 | 2205821 | 2022-02-11 | Canovanas | Puerto Rico | 72029 | 6228 | |
2200116 | 2200116 | 2022-02-09 | Upshur | West Virginia | 54097 | 6228 | 78 |
2117960 | 2117960 | 2022-01-15 | Warren | Pennsylvania | 42123 | 6228 | 188 |
2079156 | 2079156 | 2022-01-03 | Claiborne | Tennessee | 47025 | 6228 | 145 |
2028972 | 2028972 | 2021-12-19 | Taylor | Kentucky | 21217 | 6228 | 101 |
2029603 | 2029603 | 2021-12-19 | Platte | Nebraska | 31141 | 6228 | 60 |
2025721 | 2025721 | 2021-12-18 | Taylor | Kentucky | 21217 | 6228 | 101 |
2026352 | 2026352 | 2021-12-18 | Platte | Nebraska | 31141 | 6228 | 60 |
2022470 | 2022470 | 2021-12-17 | Taylor | Kentucky | 21217 | 6228 | 101 |
2023101 | 2023101 | 2021-12-17 | Platte | Nebraska | 31141 | 6228 | 60 |
2015275 | 2015275 | 2021-12-15 | Chattahoochee | Georgia | 13053 | 6228 | 21 |
1986343 | 1986343 | 2021-12-06 | Jasper | Indiana | 18073 | 6228 | 97 |
1917373 | 1917373 | 2021-11-15 | Franklin | Alabama | 1059 | 6228 | 108 |
1874958 | 1874958 | 2021-11-01 | Fayette | West Virginia | 54019 | 6228 | 126 |
1838729 | 1838729 | 2021-10-21 | Weakley | Tennessee | 47183 | 6228 | 88 |
1830790 | 1830790 | 2021-10-19 | Vernon | Louisiana | 22115 | 6228 | 160 |
1824976 | 1824976 | 2021-10-17 | Fulton | New York | 36035 | 6228 | 102 |
1807734 | 1807734 | 2021-10-12 | Muscatine | Iowa | 19139 | 6228 | 113 |
1808380 | 1808380 | 2021-10-12 | Camden | Missouri | 29029 | 6228 | 122 |
1809825 | 1809825 | 2021-10-12 | Culpeper | Virginia | 51047 | 6228 | 79 |
1804483 | 1804483 | 2021-10-11 | Muscatine | Iowa | 19139 | 6228 | 113 |
1801107 | 1801107 | 2021-10-10 | Huntington | Indiana | 18069 | 6228 | 99 |
1801234 | 1801234 | 2021-10-10 | Muscatine | Iowa | 19139 | 6228 | 113 |
1797858 | 1797858 | 2021-10-09 | Huntington | Indiana | 18069 | 6228 | 99 |
1797985 | 1797985 | 2021-10-09 | Muscatine | Iowa | 19139 | 6228 | 113 |
1794609 | 1794609 | 2021-10-08 | Huntington | Indiana | 18069 | 6228 | 99 |
1794736 | 1794736 | 2021-10-08 | Muscatine | Iowa | 19139 | 6228 | 113 |
1791488 | 1791488 | 2021-10-07 | Muscatine | Iowa | 19139 | 6228 | 113 |
1788239 | 1788239 | 2021-10-06 | Muscatine | Iowa | 19139 | 6228 | 113 |
1786985 | 1786985 | 2021-10-05 | Waller | Texas | 48473 | 6228 | 72 |
1778030 | 1778030 | 2021-10-03 | Bryan | Georgia | 13029 | 6228 | 57 |
1774531 | 1774531 | 2021-10-02 | Miller | Arkansas | 5091 | 6228 | 47 |
1774780 | 1774780 | 2021-10-02 | Bryan | Georgia | 13029 | 6228 | 57 |
1771530 | 1771530 | 2021-10-01 | Bryan | Georgia | 13029 | 6228 | 57 |
1759994 | 1759994 | 2021-09-27 | Genesee | New York | 36037 | 6228 | 131 |
1720247 | 1720247 | 2021-09-15 | Shelby | Kentucky | 21211 | 6228 | 90 |
1712673 | 1712673 | 2021-09-13 | Escambia | Alabama | 1053 | 6228 | 97 |
1679658 | 1679658 | 2021-09-02 | Jim Wells | Texas | 48249 | 6228 | 129 |
1621930 | 1621930 | 2021-08-16 | Tehama | California | 6103 | 6228 | 66 |
1473026 | 1473026 | 2021-07-01 | Dubois | Indiana | 18037 | 6228 | 119 |
1469780 | 1469780 | 2021-06-30 | Dubois | Indiana | 18037 | 6228 | 119 |
1466535 | 1466535 | 2021-06-29 | Dubois | Indiana | 18037 | 6228 | 119 |
1463290 | 1463290 | 2021-06-28 | Dubois | Indiana | 18037 | 6228 | 119 |
1445254 | 1445254 | 2021-06-22 | Carter | Oklahoma | 40019 | 6228 | 126 |
1442009 | 1442009 | 2021-06-21 | Carter | Oklahoma | 40019 | 6228 | 126 |
1438764 | 1438764 | 2021-06-20 | Carter | Oklahoma | 40019 | 6228 | 126 |
1435517 | 1435517 | 2021-06-19 | Carter | Oklahoma | 40019 | 6228 | 126 |
1432270 | 1432270 | 2021-06-18 | Carter | Oklahoma | 40019 | 6228 | 126 |
1429024 | 1429024 | 2021-06-17 | Carter | Oklahoma | 40019 | 6228 | 126 |
1425779 | 1425779 | 2021-06-16 | Carter | Oklahoma | 40019 | 6228 | 126 |
1392484 | 1392484 | 2021-06-06 | St. Joseph | Michigan | 26149 | 6228 | 99 |
1389239 | 1389239 | 2021-06-05 | St. Joseph | Michigan | 26149 | 6228 | 99 |
1337430 | 1337430 | 2021-05-20 | Lafayette | Mississippi | 28071 | 6228 | 119 |
1300621 | 1300621 | 2021-05-09 | Jackson | Florida | 12063 | 6228 | 157 |
1197436 | 1197436 | 2021-04-07 | McCracken | Kentucky | 21145 | 6228 | 118 |
1175082 | 1175082 | 2021-03-31 | Lowndes | Mississippi | 28087 | 6228 | 144 |
1141515 | 1141515 | 2021-03-21 | Monroe | Florida | 12087 | 6228 | 48 |
1082017 | 1082017 | 2021-03-02 | Dickson | Tennessee | 47043 | 6228 | 106 |
1076039 | 1076039 | 2021-02-28 | Chelan | Washington | 53007 | 6228 | 62 |
1072793 | 1072793 | 2021-02-27 | Chelan | Washington | 53007 | 6228 | 62 |
1066488 | 1066488 | 2021-02-26 | Autauga | Alabama | 1001 | 6228 | 90 |
1069547 | 1069547 | 2021-02-26 | Chelan | Washington | 53007 | 6228 | 62 |
1017902 | 1017902 | 2021-02-11 | Gila | Arizona | 4007 | 6228 | 202 |
980841 | 980841 | 2021-01-30 | Surry | North Carolina | 37171 | 6228 | 110 |
977595 | 977595 | 2021-01-29 | Surry | North Carolina | 37171 | 6228 | 110 |
961644 | 961644 | 2021-01-24 | Adams | Pennsylvania | 42001 | 6228 | 137 |
912660 | 912660 | 2021-01-09 | Lincoln | North Carolina | 37109 | 6228 | 39 |
829519 | 829519 | 2020-12-14 | Ozaukee | Wisconsin | 55089 | 6228 | 48 |
799394 | 799394 | 2020-12-05 | Cumberland | Pennsylvania | 42041 | 6228 | 168 |
733517 | 733517 | 2020-11-15 | Saginaw | Michigan | 26145 | 6228 | 178 |
730272 | 730272 | 2020-11-14 | Saginaw | Michigan | 26145 | 6228 | 178 |
724882 | 724882 | 2020-11-12 | Unknown | Rhode Island | 6228 | 26 | |
671363 | 671363 | 2020-10-27 | Vanderburgh | Indiana | 18163 | 6228 | 64 |
618642 | 618642 | 2020-10-10 | Winnebago | Wisconsin | 55139 | 6228 | 41 |
553688 | 553688 | 2020-09-20 | Spokane | Washington | 53063 | 6228 | 153 |
482209 | 482209 | 2020-08-29 | McLennan | Texas | 48309 | 6228 | 82 |
442971 | 442971 | 2020-08-17 | Lancaster | Pennsylvania | 42071 | 6228 | 421 |
340063 | 340063 | 2020-07-16 | Bucks | Pennsylvania | 42017 | 6228 | 572 |
220841 | 220841 | 2020-06-08 | Davidson | Tennessee | 47037 | 6228 | 73 |
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);