ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where cases = 2860 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 22
- Georgia 13
- Tennessee 12
- Louisiana 11
- Oklahoma 10
- Texas 10
- Kentucky 9
- Virginia 9
- Alabama 8
- Indiana 8
- Minnesota 8
- West Virginia 8
- Arkansas 7
- Missouri 7
- Ohio 7
- Wisconsin 6
- Illinois 5
- Mississippi 5
- Michigan 4
- Puerto Rico 4
- New York 3
- North Carolina 3
- Pennsylvania 3
- Colorado 2
- Kansas 2
- Nevada 2
- North Dakota 2
- South Dakota 2
- Utah 2
- Vermont 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451012 | 2451012 | 2022-04-28 | Park | Colorado | 8093 | 2860 | 20 |
2401898 | 2401898 | 2022-04-13 | Conecuh | Alabama | 1035 | 2860 | 71 |
2392132 | 2392132 | 2022-04-10 | Conecuh | Alabama | 1035 | 2860 | 71 |
2388876 | 2388876 | 2022-04-09 | Conecuh | Alabama | 1035 | 2860 | 71 |
2385621 | 2385621 | 2022-04-08 | Conecuh | Alabama | 1035 | 2860 | 71 |
2382366 | 2382366 | 2022-04-07 | Conecuh | Alabama | 1035 | 2860 | 71 |
2361966 | 2361966 | 2022-03-31 | Orocovis | Puerto Rico | 72107 | 2860 | |
2263061 | 2263061 | 2022-03-01 | Lee | Kentucky | 21129 | 2860 | 46 |
2249170 | 2249170 | 2022-02-25 | Stone | Arkansas | 5137 | 2860 | 59 |
2222624 | 2222624 | 2022-02-16 | Juab | Utah | 49023 | 2860 | 22 |
2192465 | 2192465 | 2022-02-07 | Barnes | North Dakota | 38003 | 2860 | 45 |
2192933 | 2192933 | 2022-02-07 | Charles Mix | South Dakota | 46023 | 2860 | 32 |
2178786 | 2178786 | 2022-02-03 | Chippewa | Minnesota | 27023 | 2860 | 46 |
2157550 | 2157550 | 2022-01-27 | Zapata | Texas | 48505 | 2860 | 47 |
2150201 | 2150201 | 2022-01-25 | Mountrail | North Dakota | 38061 | 2860 | 32 |
2132857 | 2132857 | 2022-01-20 | Nemaha | Kansas | 20131 | 2860 | 60 |
2129604 | 2129604 | 2022-01-19 | Nemaha | Kansas | 20131 | 2860 | 60 |
2103445 | 2103445 | 2022-01-11 | Clayton | Iowa | 19043 | 2860 | 65 |
2100194 | 2100194 | 2022-01-10 | Clayton | Iowa | 19043 | 2860 | 65 |
2096943 | 2096943 | 2022-01-09 | Clayton | Iowa | 19043 | 2860 | 65 |
2097652 | 2097652 | 2022-01-09 | Dallas | Missouri | 29059 | 2860 | 62 |
2093691 | 2093691 | 2022-01-08 | Clayton | Iowa | 19043 | 2860 | 65 |
2090439 | 2090439 | 2022-01-07 | Clayton | Iowa | 19043 | 2860 | 65 |
2087188 | 2087188 | 2022-01-06 | Clayton | Iowa | 19043 | 2860 | 65 |
2083936 | 2083936 | 2022-01-05 | Clayton | Iowa | 19043 | 2860 | 65 |
2057755 | 2057755 | 2021-12-28 | Jo Daviess | Illinois | 17085 | 2860 | 35 |
2060121 | 2060121 | 2021-12-28 | New Kent | Virginia | 51127 | 2860 | 28 |
2054506 | 2054506 | 2021-12-27 | Jo Daviess | Illinois | 17085 | 2860 | 35 |
2027996 | 2027996 | 2021-12-19 | Franklin | Arkansas | 5047 | 2860 | 57 |
2004768 | 2004768 | 2021-12-11 | Caledonia | Vermont | 50005 | 2860 | 21 |
1991049 | 1991049 | 2021-12-07 | Marshall | Oklahoma | 40095 | 2860 | 30 |
1986389 | 1986389 | 2021-12-06 | Vermillion | Indiana | 18165 | 2860 | 58 |
1987798 | 1987798 | 2021-12-06 | Marshall | Oklahoma | 40095 | 2860 | 30 |
1984548 | 1984548 | 2021-12-05 | Marshall | Oklahoma | 40095 | 2860 | 30 |
1981298 | 1981298 | 2021-12-04 | Marshall | Oklahoma | 40095 | 2860 | 30 |
1978048 | 1978048 | 2021-12-03 | Marshall | Oklahoma | 40095 | 2860 | 30 |
1974798 | 1974798 | 2021-12-02 | Marshall | Oklahoma | 40095 | 2860 | 28 |
1975525 | 1975525 | 2021-12-02 | Windham | Vermont | 50025 | 2860 | 26 |
1975545 | 1975545 | 2021-12-02 | Buchanan | Virginia | 51027 | 2860 | 79 |
1970934 | 1970934 | 2021-12-01 | Pike | Missouri | 29163 | 2860 | 51 |
1971549 | 1971549 | 2021-12-01 | Marshall | Oklahoma | 40095 | 2860 | 28 |
1967947 | 1967947 | 2021-11-30 | Taos | New Mexico | 35055 | 2860 | 71 |
1968640 | 1968640 | 2021-11-30 | Cannon | Tennessee | 47015 | 2860 | 44 |
1944639 | 1944639 | 2021-11-23 | Manistee | Michigan | 26101 | 2860 | 44 |
1940807 | 1940807 | 2021-11-22 | Carroll | Indiana | 18015 | 2860 | 40 |
1941388 | 1941388 | 2021-11-22 | Manistee | Michigan | 26101 | 2860 | 44 |
1925805 | 1925805 | 2021-11-17 | Madison | North Carolina | 37115 | 2860 | 63 |
1908150 | 1908150 | 2021-11-12 | Kauai | Hawaii | 15007 | 2860 | 11 |
1896488 | 1896488 | 2021-11-08 | Seneca | New York | 36099 | 2860 | 64 |
1880299 | 1880299 | 2021-11-03 | Hertford | North Carolina | 37091 | 2860 | 72 |
1861682 | 1861682 | 2021-10-28 | San Jacinto | Texas | 48407 | 2860 | 77 |
1846599 | 1846599 | 2021-10-24 | Jay | Indiana | 18075 | 2860 | 50 |
1843349 | 1843349 | 2021-10-23 | Jay | Indiana | 18075 | 2860 | 50 |
1840099 | 1840099 | 2021-10-22 | Jay | Indiana | 18075 | 2860 | 50 |
1823244 | 1823244 | 2021-10-17 | Drew | Arkansas | 5043 | 2860 | 54 |
1793798 | 1793798 | 2021-10-07 | Green Lake | Wisconsin | 55047 | 2860 | 29 |
1784253 | 1784253 | 2021-10-05 | Cross | Arkansas | 5037 | 2860 | 59 |
1784950 | 1784950 | 2021-10-05 | Dickinson | Iowa | 19059 | 2860 | 50 |
1781701 | 1781701 | 2021-10-04 | Dickinson | Iowa | 19059 | 2860 | 50 |
1778451 | 1778451 | 2021-10-03 | Dickinson | Iowa | 19059 | 2860 | 50 |
1780231 | 1780231 | 2021-10-03 | Sequatchie | Tennessee | 47153 | 2860 | 29 |
1775201 | 1775201 | 2021-10-02 | Dickinson | Iowa | 19059 | 2860 | 50 |
1776981 | 1776981 | 2021-10-02 | Sequatchie | Tennessee | 47153 | 2860 | 29 |
1771951 | 1771951 | 2021-10-01 | Dickinson | Iowa | 19059 | 2860 | 50 |
1773731 | 1773731 | 2021-10-01 | Sequatchie | Tennessee | 47153 | 2860 | 29 |
1768702 | 1768702 | 2021-09-30 | Dickinson | Iowa | 19059 | 2860 | 50 |
1765453 | 1765453 | 2021-09-29 | Dickinson | Iowa | 19059 | 2860 | 50 |
1767420 | 1767420 | 2021-09-29 | Montague | Texas | 48337 | 2860 | 84 |
1757031 | 1757031 | 2021-09-26 | Wyandot | Ohio | 39175 | 2860 | 58 |
1728920 | 1728920 | 2021-09-18 | Hale | Alabama | 1065 | 2860 | 81 |
1720549 | 1720549 | 2021-09-15 | Waseca | Minnesota | 27161 | 2860 | 25 |
1690382 | 1690382 | 2021-09-06 | Jones | Georgia | 13169 | 2860 | 65 |
1692483 | 1692483 | 2021-09-06 | Johnson | Tennessee | 47091 | 2860 | 40 |
1686712 | 1686712 | 2021-09-05 | Pickens | Alabama | 1107 | 2860 | 63 |
1687132 | 1687132 | 2021-09-05 | Jones | Georgia | 13169 | 2860 | 65 |
1689031 | 1689031 | 2021-09-05 | Juncos | Puerto Rico | 72077 | 2860 | |
1689234 | 1689234 | 2021-09-05 | Johnson | Tennessee | 47091 | 2860 | 40 |
1683882 | 1683882 | 2021-09-04 | Jones | Georgia | 13169 | 2860 | 65 |
1685984 | 1685984 | 2021-09-04 | Johnson | Tennessee | 47091 | 2860 | 40 |
1680631 | 1680631 | 2021-09-03 | Jones | Georgia | 13169 | 2860 | 65 |
1682733 | 1682733 | 2021-09-03 | Johnson | Tennessee | 47091 | 2860 | 40 |
1682809 | 1682809 | 2021-09-03 | Burleson | Texas | 48051 | 2860 | 51 |
1679243 | 1679243 | 2021-09-02 | Aguadilla | Puerto Rico | 72005 | 2860 | |
1651218 | 1651218 | 2021-08-25 | Morgan | Colorado | 8087 | 2860 | 96 |
1644556 | 1644556 | 2021-08-23 | Columbia | Arkansas | 5027 | 2860 | 60 |
1637977 | 1637977 | 2021-08-21 | Marengo | Alabama | 1091 | 2860 | 67 |
1640028 | 1640028 | 2021-08-21 | Henry | Ohio | 39069 | 2860 | 67 |
1605858 | 1605858 | 2021-08-11 | Burke | Georgia | 13033 | 2860 | 66 |
1584577 | 1584577 | 2021-08-04 | Lewis | New York | 36049 | 2860 | 36 |
1571237 | 1571237 | 2021-07-31 | Crawford | Missouri | 29055 | 2860 | 41 |
1556455 | 1556455 | 2021-07-26 | Halifax | Virginia | 51083 | 2860 | 78 |
1553340 | 1553340 | 2021-07-25 | Hancock | West Virginia | 54029 | 2860 | 90 |
1553395 | 1553395 | 2021-07-25 | Door | Wisconsin | 55029 | 2860 | 34 |
1550093 | 1550093 | 2021-07-24 | Hancock | West Virginia | 54029 | 2860 | 90 |
1550148 | 1550148 | 2021-07-24 | Door | Wisconsin | 55029 | 2860 | 34 |
1546846 | 1546846 | 2021-07-23 | Hancock | West Virginia | 54029 | 2860 | 90 |
1546901 | 1546901 | 2021-07-23 | Door | Wisconsin | 55029 | 2860 | 34 |
1543599 | 1543599 | 2021-07-22 | Hancock | West Virginia | 54029 | 2860 | 90 |
1543654 | 1543654 | 2021-07-22 | Door | Wisconsin | 55029 | 2860 | 34 |
1540406 | 1540406 | 2021-07-21 | Door | Wisconsin | 55029 | 2860 | 34 |
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);