ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 2782 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 20
- Texas 17
- Kentucky 14
- Georgia 10
- South Carolina 10
- Missouri 9
- Alabama 6
- Michigan 6
- Pennsylvania 6
- Indiana 5
- Ohio 4
- Tennessee 4
- Arkansas 3
- Kansas 3
- New York 3
- West Virginia 3
- California 2
- Colorado 2
- Louisiana 2
- Minnesota 2
- North Carolina 2
- North Dakota 2
- Virginia 2
- Wisconsin 2
- Wyoming 2
- Delaware 1
- Illinois 1
- Maryland 1
- Mississippi 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491166 | 2491166 | 2022-05-10 | Koochiching | Minnesota | 27071 | 2782 | 37 |
2444689 | 2444689 | 2022-04-26 | Long | Georgia | 13183 | 2782 | 34 |
2441433 | 2441433 | 2022-04-25 | Long | Georgia | 13183 | 2782 | 34 |
2402362 | 2402362 | 2022-04-13 | Long | Georgia | 13183 | 2782 | 34 |
2388457 | 2388457 | 2022-04-08 | Terry | Texas | 48445 | 2782 | 84 |
2375016 | 2375016 | 2022-04-04 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2371764 | 2371764 | 2022-04-03 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2368511 | 2368511 | 2022-04-02 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2365258 | 2365258 | 2022-04-01 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2362005 | 2362005 | 2022-03-31 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2358751 | 2358751 | 2022-03-30 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2353366 | 2353366 | 2022-03-29 | Rio Grande | Colorado | 8105 | 2782 | 46 |
2355497 | 2355497 | 2022-03-29 | Calhoun | South Carolina | 45017 | 2782 | 61 |
2313472 | 2313472 | 2022-03-16 | Eastland | Texas | 48133 | 2782 | 113 |
2287418 | 2287418 | 2022-03-08 | Callahan | Texas | 48059 | 2782 | 72 |
2284166 | 2284166 | 2022-03-07 | Callahan | Texas | 48059 | 2782 | 72 |
2240324 | 2240324 | 2022-02-22 | Metcalfe | Kentucky | 21169 | 2782 | 58 |
2238851 | 2238851 | 2022-02-21 | Ward | Texas | 48475 | 2782 | 42 |
2217281 | 2217281 | 2022-02-15 | Appanoose | Iowa | 19007 | 2782 | 63 |
2214030 | 2214030 | 2022-02-14 | Appanoose | Iowa | 19007 | 2782 | 63 |
2210778 | 2210778 | 2022-02-13 | Appanoose | Iowa | 19007 | 2782 | 63 |
2207525 | 2207525 | 2022-02-12 | Appanoose | Iowa | 19007 | 2782 | 63 |
2204272 | 2204272 | 2022-02-11 | Appanoose | Iowa | 19007 | 2782 | 63 |
2201019 | 2201019 | 2022-02-10 | Appanoose | Iowa | 19007 | 2782 | 63 |
2197765 | 2197765 | 2022-02-09 | Appanoose | Iowa | 19007 | 2782 | 63 |
2175273 | 2175273 | 2022-02-02 | Martin | Kentucky | 21159 | 2782 | 44 |
2169689 | 2169689 | 2022-01-31 | Washington | North Carolina | 37187 | 2782 | 42 |
2106895 | 2106895 | 2022-01-12 | Butler | Kentucky | 21031 | 2782 | 44 |
2107919 | 2107919 | 2022-01-12 | Ramsey | North Dakota | 38071 | 2782 | 47 |
2087388 | 2087388 | 2022-01-06 | Caldwell | Kentucky | 21033 | 2782 | 54 |
2079822 | 2079822 | 2022-01-03 | Richland | Wisconsin | 55103 | 2782 | 38 |
2056993 | 2056993 | 2021-12-27 | Morgan | West Virginia | 54065 | 2782 | 53 |
1964000 | 1964000 | 2021-11-29 | LaSalle | Louisiana | 22059 | 2782 | 46 |
1962306 | 1962306 | 2021-11-28 | Freestone | Texas | 48161 | 2782 | 72 |
1959055 | 1959055 | 2021-11-27 | Freestone | Texas | 48161 | 2782 | 72 |
1955804 | 1955804 | 2021-11-26 | Freestone | Texas | 48161 | 2782 | 72 |
1952553 | 1952553 | 2021-11-25 | Freestone | Texas | 48161 | 2782 | 72 |
1952791 | 1952791 | 2021-11-25 | Buchanan | Virginia | 51027 | 2782 | 75 |
1949302 | 1949302 | 2021-11-24 | Freestone | Texas | 48161 | 2782 | 72 |
1928149 | 1928149 | 2021-11-18 | Jackson | Kentucky | 21109 | 2782 | 51 |
1921418 | 1921418 | 2021-11-16 | Delaware | Iowa | 19055 | 2782 | 53 |
1918168 | 1918168 | 2021-11-15 | Delaware | Iowa | 19055 | 2782 | 53 |
1914918 | 1914918 | 2021-11-14 | Delaware | Iowa | 19055 | 2782 | 53 |
1911668 | 1911668 | 2021-11-13 | Delaware | Iowa | 19055 | 2782 | 53 |
1908419 | 1908419 | 2021-11-12 | Delaware | Iowa | 19055 | 2782 | 53 |
1905170 | 1905170 | 2021-11-11 | Delaware | Iowa | 19055 | 2782 | 53 |
1901920 | 1901920 | 2021-11-10 | Delaware | Iowa | 19055 | 2782 | 53 |
1886370 | 1886370 | 2021-11-05 | Cooper | Missouri | 29053 | 2782 | 34 |
1876494 | 1876494 | 2021-11-02 | Roseau | Minnesota | 27135 | 2782 | 28 |
1877429 | 1877429 | 2021-11-02 | Wyoming | Pennsylvania | 42131 | 2782 | 63 |
1860353 | 1860353 | 2021-10-28 | Andrew | Missouri | 29003 | 2782 | 24 |
1858349 | 1858349 | 2021-10-27 | Jackson | Texas | 48239 | 2782 | 50 |
1855100 | 1855100 | 2021-10-26 | Jackson | Texas | 48239 | 2782 | 50 |
1850148 | 1850148 | 2021-10-25 | Garrard | Kentucky | 21079 | 2782 | 47 |
1852336 | 1852336 | 2021-10-25 | Carbon | Wyoming | 56007 | 2782 | 36 |
1846828 | 1846828 | 2021-10-24 | Pottawatomie | Kansas | 20149 | 2782 | 41 |
1843578 | 1843578 | 2021-10-23 | Pottawatomie | Kansas | 20149 | 2782 | 41 |
1840328 | 1840328 | 2021-10-22 | Pottawatomie | Kansas | 20149 | 2782 | 41 |
1824336 | 1824336 | 2021-10-17 | Talbot | Maryland | 24041 | 2782 | 51 |
1814047 | 1814047 | 2021-10-14 | Richland | Illinois | 17159 | 2782 | 66 |
1814390 | 1814390 | 2021-10-14 | Casey | Kentucky | 21045 | 2782 | 53 |
1811141 | 1811141 | 2021-10-13 | Casey | Kentucky | 21045 | 2782 | 53 |
1792143 | 1792143 | 2021-10-07 | Clinton | Missouri | 29049 | 2782 | 76 |
1793115 | 1793115 | 2021-10-07 | Hughes | South Dakota | 46065 | 2782 | 43 |
1768008 | 1768008 | 2021-09-30 | Drew | Arkansas | 5043 | 2782 | 54 |
1755645 | 1755645 | 2021-09-26 | Orange | Indiana | 18117 | 2782 | 62 |
1752397 | 1752397 | 2021-09-25 | Orange | Indiana | 18117 | 2782 | 62 |
1749148 | 1749148 | 2021-09-24 | Orange | Indiana | 18117 | 2782 | 62 |
1748239 | 1748239 | 2021-09-23 | Brooke | West Virginia | 54009 | 2782 | 64 |
1725647 | 1725647 | 2021-09-17 | Cherokee | Alabama | 1019 | 2782 | 49 |
1682924 | 1682924 | 2021-09-03 | Lamb | Texas | 48279 | 2782 | 86 |
1663926 | 1663926 | 2021-08-29 | Butler | Alabama | 1013 | 2782 | 74 |
1660073 | 1660073 | 2021-08-27 | Burleson | Texas | 48051 | 2782 | 50 |
1656418 | 1656418 | 2021-08-26 | Jefferson | Oregon | 41031 | 2782 | 44 |
1633114 | 1633114 | 2021-08-19 | Cass | Nebraska | 31025 | 2782 | 17 |
1624985 | 1624985 | 2021-08-17 | Marengo | Alabama | 1091 | 2782 | 67 |
1609222 | 1609222 | 2021-08-12 | Tattnall | Georgia | 13267 | 2782 | 72 |
1587042 | 1587042 | 2021-08-05 | Mercer | Kentucky | 21167 | 2782 | 52 |
1577473 | 1577473 | 2021-08-02 | Dickinson | Michigan | 26043 | 2782 | 74 |
1574225 | 1574225 | 2021-08-01 | Dickinson | Michigan | 26043 | 2782 | 74 |
1570977 | 1570977 | 2021-07-31 | Dickinson | Michigan | 26043 | 2782 | 74 |
1567729 | 1567729 | 2021-07-30 | Dickinson | Michigan | 26043 | 2782 | 74 |
1560716 | 1560716 | 2021-07-28 | LaGrange | Indiana | 18087 | 2782 | 74 |
1553936 | 1553936 | 2021-07-26 | Haralson | Georgia | 13143 | 2782 | 91 |
1548504 | 1548504 | 2021-07-24 | Crawford | Missouri | 29055 | 2782 | 41 |
1543738 | 1543738 | 2021-07-23 | Bibb | Alabama | 1007 | 2782 | 65 |
1529590 | 1529590 | 2021-07-18 | Hardin | Ohio | 39065 | 2782 | 65 |
1514956 | 1514956 | 2021-07-14 | Franklin | Georgia | 13119 | 2782 | 57 |
1499839 | 1499839 | 2021-07-09 | Miller | Missouri | 29131 | 2782 | 57 |
1409001 | 1409001 | 2021-06-11 | Washington | Missouri | 29221 | 2782 | 52 |
1381321 | 1381321 | 2021-06-02 | Randolph | West Virginia | 54083 | 2782 | 13 |
1355530 | 1355530 | 2021-05-26 | Winston | Alabama | 1133 | 2782 | 73 |
1335972 | 1335972 | 2021-05-19 | Park | Wyoming | 56029 | 2782 | 30 |
1303038 | 1303038 | 2021-05-09 | Limestone | Texas | 48293 | 2782 | 77 |
1299791 | 1299791 | 2021-05-08 | Limestone | Texas | 48293 | 2782 | 77 |
1294506 | 1294506 | 2021-05-07 | Greene | Indiana | 18055 | 2782 | 89 |
1282263 | 1282263 | 2021-05-03 | Prentiss | Mississippi | 28117 | 2782 | 59 |
1280523 | 1280523 | 2021-05-02 | Halifax | Virginia | 51083 | 2782 | 77 |
1265603 | 1265603 | 2021-04-28 | Harlan | Kentucky | 21095 | 2782 | 83 |
1248438 | 1248438 | 2021-04-23 | Carroll | Arkansas | 5015 | 2782 | 45 |
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);