ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
174 rows where cases = 2761 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Georgia 13
- Illinois 12
- Missouri 11
- Ohio 9
- Wisconsin 9
- Florida 8
- Iowa 8
- Indiana 7
- Michigan 7
- West Virginia 7
- Alabama 6
- Kansas 6
- Minnesota 6
- Mississippi 6
- Virginia 6
- Kentucky 4
- South Carolina 4
- Arkansas 3
- Pennsylvania 3
- Tennessee 3
- Alaska 2
- Colorado 2
- Idaho 2
- Louisiana 2
- Maryland 2
- New York 2
- North Carolina 2
- Puerto Rico 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471620 | 2471620 | 2022-05-04 | Koochiching | Minnesota | 27071 | 2761 | 37 |
2369995 | 2369995 | 2022-04-03 | Marshall | Illinois | 17123 | 2761 | 33 |
2366742 | 2366742 | 2022-04-02 | Marshall | Illinois | 17123 | 2761 | 33 |
2363489 | 2363489 | 2022-04-01 | Marshall | Illinois | 17123 | 2761 | 33 |
2353728 | 2353728 | 2022-03-29 | Marshall | Illinois | 17123 | 2761 | 33 |
2350476 | 2350476 | 2022-03-28 | Marshall | Illinois | 17123 | 2761 | 33 |
2304565 | 2304565 | 2022-03-14 | Park | Colorado | 8093 | 2761 | 20 |
2264421 | 2264421 | 2022-03-01 | Calhoun | South Carolina | 45017 | 2761 | 58 |
2258149 | 2258149 | 2022-02-27 | Callahan | Texas | 48059 | 2761 | 72 |
2254898 | 2254898 | 2022-02-26 | Callahan | Texas | 48059 | 2761 | 72 |
2194822 | 2194822 | 2022-02-08 | Todd | Kentucky | 21219 | 2761 | 40 |
2179593 | 2179593 | 2022-02-03 | Vinton | Ohio | 39163 | 2761 | 47 |
2167707 | 2167707 | 2022-01-31 | Coosa | Alabama | 1037 | 2761 | 51 |
2165905 | 2165905 | 2022-01-30 | Perry | Mississippi | 28111 | 2761 | 57 |
2162650 | 2162650 | 2022-01-29 | Perry | Mississippi | 28111 | 2761 | 57 |
2159395 | 2159395 | 2022-01-28 | Perry | Mississippi | 28111 | 2761 | 57 |
2154819 | 2154819 | 2022-01-27 | Lee | Arkansas | 5077 | 2761 | 54 |
2146758 | 2146758 | 2022-01-24 | Torrance | New Mexico | 35057 | 2761 | 44 |
2141207 | 2141207 | 2022-01-22 | Nolan | Texas | 48353 | 2761 | 88 |
2126235 | 2126235 | 2022-01-18 | Jefferson | Iowa | 19101 | 2761 | 46 |
2122983 | 2122983 | 2022-01-17 | Jefferson | Iowa | 19101 | 2761 | 46 |
2119731 | 2119731 | 2022-01-16 | Jefferson | Iowa | 19101 | 2761 | 46 |
2116479 | 2116479 | 2022-01-15 | Jefferson | Iowa | 19101 | 2761 | 46 |
2113228 | 2113228 | 2022-01-14 | Jefferson | Iowa | 19101 | 2761 | 46 |
2109976 | 2109976 | 2022-01-13 | Jefferson | Iowa | 19101 | 2761 | 46 |
2106725 | 2106725 | 2022-01-12 | Jefferson | Iowa | 19101 | 2761 | 46 |
2096188 | 2096188 | 2022-01-09 | Washington | Alabama | 1129 | 2761 | 52 |
2037138 | 2037138 | 2021-12-21 | Llano | Texas | 48299 | 2761 | 83 |
2018004 | 2018004 | 2021-12-15 | Taylor | West Virginia | 54091 | 2761 | 49 |
1995699 | 1995699 | 2021-12-09 | Hamilton | Florida | 12047 | 2761 | 49 |
1995963 | 1995963 | 2021-12-09 | Carroll | Illinois | 17015 | 2761 | 42 |
1998470 | 1998470 | 2021-12-09 | Hardy | West Virginia | 54031 | 2761 | 37 |
1992448 | 1992448 | 2021-12-08 | Hamilton | Florida | 12047 | 2761 | 49 |
1989197 | 1989197 | 2021-12-07 | Hamilton | Florida | 12047 | 2761 | 49 |
1985947 | 1985947 | 2021-12-06 | Hamilton | Florida | 12047 | 2761 | 49 |
1982697 | 1982697 | 2021-12-05 | Hamilton | Florida | 12047 | 2761 | 49 |
1979447 | 1979447 | 2021-12-04 | Hamilton | Florida | 12047 | 2761 | 49 |
1976197 | 1976197 | 2021-12-03 | Hamilton | Florida | 12047 | 2761 | 49 |
1961167 | 1961167 | 2021-11-28 | Moniteau | Missouri | 29135 | 2761 | 46 |
1957916 | 1957916 | 2021-11-27 | Moniteau | Missouri | 29135 | 2761 | 46 |
1954665 | 1954665 | 2021-11-26 | Moniteau | Missouri | 29135 | 2761 | 46 |
1951414 | 1951414 | 2021-11-25 | Moniteau | Missouri | 29135 | 2761 | 46 |
1948163 | 1948163 | 2021-11-24 | Moniteau | Missouri | 29135 | 2761 | 46 |
1928242 | 1928242 | 2021-11-18 | LaSalle | Louisiana | 22059 | 2761 | 46 |
1904429 | 1904429 | 2021-11-11 | North Slope Borough | Alaska | 2185 | 2761 | 7 |
1901179 | 1901179 | 2021-11-10 | North Slope Borough | Alaska | 2185 | 2761 | 7 |
1869236 | 1869236 | 2021-10-31 | Hancock | Illinois | 17067 | 2761 | 45 |
1865987 | 1865987 | 2021-10-30 | Hancock | Illinois | 17067 | 2761 | 45 |
1862738 | 1862738 | 2021-10-29 | Hancock | Illinois | 17067 | 2761 | 45 |
1859250 | 1859250 | 2021-10-28 | Banks | Georgia | 13011 | 2761 | 62 |
1847749 | 1847749 | 2021-10-24 | Seneca | New York | 36099 | 2761 | 63 |
1816109 | 1816109 | 2021-10-14 | Jackson | Texas | 48239 | 2761 | 50 |
1780651 | 1780651 | 2021-10-03 | Prince Edward | Virginia | 51147 | 2761 | 46 |
1777401 | 1777401 | 2021-10-02 | Prince Edward | Virginia | 51147 | 2761 | 46 |
1774151 | 1774151 | 2021-10-01 | Prince Edward | Virginia | 51147 | 2761 | 46 |
1762467 | 1762467 | 2021-09-28 | Morgan | Kentucky | 21175 | 2761 | 6 |
1758098 | 1758098 | 2021-09-26 | Vilas | Wisconsin | 55125 | 2761 | 49 |
1754850 | 1754850 | 2021-09-25 | Vilas | Wisconsin | 55125 | 2761 | 49 |
1751602 | 1751602 | 2021-09-24 | Vilas | Wisconsin | 55125 | 2761 | 49 |
1747943 | 1747943 | 2021-09-23 | Panola | Texas | 48365 | 2761 | 98 |
1731038 | 1731038 | 2021-09-18 | Wyandot | Ohio | 39175 | 2761 | 58 |
1721962 | 1721962 | 2021-09-15 | Robertson | Texas | 48395 | 2761 | 59 |
1693707 | 1693707 | 2021-09-07 | Worth | Georgia | 13321 | 2761 | 75 |
1676884 | 1676884 | 2021-09-01 | Waushara | Wisconsin | 55137 | 2761 | 41 |
1640254 | 1640254 | 2021-08-21 | Susquehanna | Pennsylvania | 42115 | 2761 | 62 |
1632805 | 1632805 | 2021-08-19 | Meeker | Minnesota | 27093 | 2761 | 45 |
1621695 | 1621695 | 2021-08-16 | Barbour | Alabama | 1005 | 2761 | 65 |
1624055 | 1624055 | 2021-08-16 | Gurabo | Puerto Rico | 72063 | 2761 | |
1607550 | 1607550 | 2021-08-11 | Holmes | Ohio | 39075 | 2761 | 102 |
1598885 | 1598885 | 2021-08-08 | Jackson | Wisconsin | 55053 | 2761 | 29 |
1595636 | 1595636 | 2021-08-07 | Jackson | Wisconsin | 55053 | 2761 | 29 |
1592387 | 1592387 | 2021-08-06 | Jackson | Wisconsin | 55053 | 2761 | 29 |
1564708 | 1564708 | 2021-07-29 | Wayne | Mississippi | 28153 | 2761 | 43 |
1558323 | 1558323 | 2021-07-27 | Stoddard | Missouri | 29207 | 2761 | 45 |
1540490 | 1540490 | 2021-07-22 | Bibb | Alabama | 1007 | 2761 | 65 |
1540947 | 1540947 | 2021-07-22 | Haralson | Georgia | 13143 | 2761 | 91 |
1540987 | 1540987 | 2021-07-22 | Peach | Georgia | 13225 | 2761 | 70 |
1538762 | 1538762 | 2021-07-21 | Crawford | Missouri | 29055 | 2761 | 41 |
1536087 | 1536087 | 2021-07-20 | Henry | Ohio | 39069 | 2761 | 67 |
1515254 | 1515254 | 2021-07-14 | LaGrange | Indiana | 18087 | 2761 | 74 |
1498565 | 1498565 | 2021-07-09 | Morgan | Colorado | 8087 | 2761 | 96 |
1472183 | 1472183 | 2021-06-30 | Mingo | West Virginia | 54059 | 2761 | 43 |
1465693 | 1465693 | 2021-06-28 | Mingo | West Virginia | 54059 | 2761 | 43 |
1454924 | 1454924 | 2021-06-25 | Hardin | Ohio | 39065 | 2761 | 65 |
1445793 | 1445793 | 2021-06-22 | Fayette | Texas | 48149 | 2761 | 67 |
1442644 | 1442644 | 2021-06-21 | Moore | Texas | 48341 | 2761 | 73 |
1439399 | 1439399 | 2021-06-20 | Moore | Texas | 48341 | 2761 | 73 |
1436152 | 1436152 | 2021-06-19 | Moore | Texas | 48341 | 2761 | 73 |
1427964 | 1427964 | 2021-06-17 | Perry | Kentucky | 21193 | 2761 | 66 |
1414828 | 1414828 | 2021-06-13 | Labette | Kansas | 20099 | 2761 | 50 |
1411583 | 1411583 | 2021-06-12 | Labette | Kansas | 20099 | 2761 | 50 |
1408338 | 1408338 | 2021-06-11 | Labette | Kansas | 20099 | 2761 | 50 |
1395716 | 1395716 | 2021-06-07 | Oceana | Michigan | 26127 | 2761 | 60 |
1392470 | 1392470 | 2021-06-06 | Oceana | Michigan | 26127 | 2761 | 60 |
1389225 | 1389225 | 2021-06-05 | Oceana | Michigan | 26127 | 2761 | 60 |
1359187 | 1359187 | 2021-05-27 | Lee | Georgia | 13177 | 2761 | 60 |
1355941 | 1355941 | 2021-05-26 | Lee | Georgia | 13177 | 2761 | 60 |
1342542 | 1342542 | 2021-05-22 | Winston | Alabama | 1133 | 2761 | 73 |
1339294 | 1339294 | 2021-05-21 | Winston | Alabama | 1133 | 2761 | 73 |
1337068 | 1337068 | 2021-05-20 | Montgomery | Kentucky | 21173 | 2761 | 30 |
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);