ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
432 rows where cases = 1138 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 93
- Iowa 24
- Kentucky 22
- Missouri 20
- North Carolina 18
- Virginia 16
- Georgia 15
- Louisiana 15
- Michigan 14
- Alabama 13
- Kansas 13
- Illinois 12
- Minnesota 12
- Mississippi 11
- Nebraska 11
- Oklahoma 8
- Tennessee 8
- Arkansas 7
- Indiana 7
- Ohio 7
- Nevada 6
- Pennsylvania 6
- Puerto Rico 6
- Utah 6
- Idaho 5
- Colorado 4
- Montana 4
- South Carolina 4
- South Dakota 4
- Washington 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396050 | 2396050 | 2022-04-11 | Putnam | Illinois | 17155 | 1138 | 10 |
2352694 | 2352694 | 2022-03-28 | Yoakum | Texas | 48501 | 1138 | 41 |
2349442 | 2349442 | 2022-03-27 | Yoakum | Texas | 48501 | 1138 | 41 |
2346189 | 2346189 | 2022-03-26 | Yoakum | Texas | 48501 | 1138 | 41 |
2329736 | 2329736 | 2022-03-21 | Donley | Texas | 48129 | 1138 | 26 |
2326484 | 2326484 | 2022-03-20 | Donley | Texas | 48129 | 1138 | 26 |
2233775 | 2233775 | 2022-02-20 | Fulton | Kentucky | 21075 | 1138 | 23 |
2230524 | 2230524 | 2022-02-19 | Fulton | Kentucky | 21075 | 1138 | 23 |
2227273 | 2227273 | 2022-02-18 | Fulton | Kentucky | 21075 | 1138 | 23 |
2219349 | 2219349 | 2022-02-15 | Wheeler | Texas | 48483 | 1138 | 19 |
2126472 | 2126472 | 2022-01-18 | Menifee | Kentucky | 21165 | 1138 | 28 |
2108525 | 2108525 | 2022-01-12 | Brewster | Texas | 48043 | 1138 | 24 |
2099862 | 2099862 | 2022-01-10 | Marion | Georgia | 13197 | 1138 | 43 |
2089631 | 2089631 | 2022-01-07 | Choctaw | Alabama | 1023 | 1138 | 30 |
2084948 | 2084948 | 2022-01-05 | Los Alamos | New Mexico | 35028 | 1138 | 11 |
2057707 | 2057707 | 2021-12-28 | Power | Idaho | 16077 | 1138 | 17 |
2056381 | 2056381 | 2021-12-27 | Spink | South Dakota | 46115 | 1138 | 31 |
2022921 | 2022921 | 2021-12-17 | Maries | Missouri | 29125 | 1138 | 22 |
2013365 | 2013365 | 2021-12-14 | Thurston | Nebraska | 31173 | 1138 | 17 |
2014715 | 2014715 | 2021-12-14 | Calhoun | West Virginia | 54013 | 1138 | 9 |
2010050 | 2010050 | 2021-12-13 | Dawes | Nebraska | 31045 | 1138 | 21 |
1998004 | 1998004 | 2021-12-09 | Brooks | Texas | 48047 | 1138 | 47 |
1991792 | 1991792 | 2021-12-07 | Bland | Virginia | 51021 | 1138 | 17 |
1986208 | 1986208 | 2021-12-06 | Brown | Illinois | 17009 | 1138 | 18 |
1988541 | 1988541 | 2021-12-06 | Bland | Virginia | 51021 | 1138 | 17 |
1972859 | 1972859 | 2021-12-02 | Conejos | Colorado | 8021 | 1138 | 42 |
1966728 | 1966728 | 2021-11-30 | Edwards | Illinois | 17047 | 1138 | 20 |
1955108 | 1955108 | 2021-11-26 | Bottineau | North Dakota | 38009 | 1138 | 21 |
1944863 | 1944863 | 2021-11-23 | Chariton | Missouri | 29041 | 1138 | 30 |
1925621 | 1925621 | 2021-11-17 | Pershing | Nevada | 32027 | 1138 | 27 |
1921379 | 1921379 | 2021-11-16 | Union | Indiana | 18161 | 1138 | 17 |
1922372 | 1922372 | 2021-11-16 | Pershing | Nevada | 32027 | 1138 | 27 |
1919075 | 1919075 | 2021-11-15 | Merrick | Nebraska | 31121 | 1138 | 15 |
1919122 | 1919122 | 2021-11-15 | Pershing | Nevada | 32027 | 1138 | 27 |
1915872 | 1915872 | 2021-11-14 | Pershing | Nevada | 32027 | 1138 | 27 |
1912622 | 1912622 | 2021-11-13 | Pershing | Nevada | 32027 | 1138 | 27 |
1909372 | 1909372 | 2021-11-12 | Pershing | Nevada | 32027 | 1138 | 27 |
1905883 | 1905883 | 2021-11-11 | Harrison | Missouri | 29081 | 1138 | 17 |
1907225 | 1907225 | 2021-11-11 | Beaver | Utah | 49001 | 1138 | 12 |
1902634 | 1902634 | 2021-11-10 | Harrison | Missouri | 29081 | 1138 | 17 |
1895025 | 1895025 | 2021-11-08 | Crawford | Georgia | 13079 | 1138 | 43 |
1885005 | 1885005 | 2021-11-05 | Montgomery | Arkansas | 5097 | 1138 | 45 |
1887569 | 1887569 | 2021-11-05 | Hansford | Texas | 48195 | 1138 | 25 |
1873215 | 1873215 | 2021-11-01 | Lake | Minnesota | 27075 | 1138 | 22 |
1866862 | 1866862 | 2021-10-30 | Caldwell | Missouri | 29025 | 1138 | 20 |
1859834 | 1859834 | 2021-10-28 | Russell | Kansas | 20167 | 1138 | 33 |
1860098 | 1860098 | 2021-10-28 | Alcona | Michigan | 26001 | 1138 | 42 |
1861249 | 1861249 | 2021-10-28 | San German | Puerto Rico | 72125 | 1138 | |
1856585 | 1856585 | 2021-10-27 | Russell | Kansas | 20167 | 1138 | 33 |
1856849 | 1856849 | 2021-10-27 | Alcona | Michigan | 26001 | 1138 | 42 |
1853211 | 1853211 | 2021-10-26 | Lucas | Iowa | 19117 | 1138 | 24 |
1854046 | 1854046 | 2021-10-26 | Cuming | Nebraska | 31039 | 1138 | 15 |
1849962 | 1849962 | 2021-10-25 | Lucas | Iowa | 19117 | 1138 | 24 |
1850797 | 1850797 | 2021-10-25 | Cuming | Nebraska | 31039 | 1138 | 15 |
1846712 | 1846712 | 2021-10-24 | Lucas | Iowa | 19117 | 1138 | 24 |
1847547 | 1847547 | 2021-10-24 | Cuming | Nebraska | 31039 | 1138 | 15 |
1843462 | 1843462 | 2021-10-23 | Lucas | Iowa | 19117 | 1138 | 24 |
1844297 | 1844297 | 2021-10-23 | Cuming | Nebraska | 31039 | 1138 | 15 |
1840212 | 1840212 | 2021-10-22 | Lucas | Iowa | 19117 | 1138 | 24 |
1841047 | 1841047 | 2021-10-22 | Cuming | Nebraska | 31039 | 1138 | 15 |
1836963 | 1836963 | 2021-10-21 | Lucas | Iowa | 19117 | 1138 | 24 |
1837798 | 1837798 | 2021-10-21 | Cuming | Nebraska | 31039 | 1138 | 15 |
1833714 | 1833714 | 2021-10-20 | Lucas | Iowa | 19117 | 1138 | 24 |
1830443 | 1830443 | 2021-10-19 | Greene | Iowa | 19073 | 1138 | 12 |
1827194 | 1827194 | 2021-10-18 | Greene | Iowa | 19073 | 1138 | 12 |
1823945 | 1823945 | 2021-10-17 | Greene | Iowa | 19073 | 1138 | 12 |
1820696 | 1820696 | 2021-10-16 | Greene | Iowa | 19073 | 1138 | 12 |
1817447 | 1817447 | 2021-10-15 | Greene | Iowa | 19073 | 1138 | 12 |
1814199 | 1814199 | 2021-10-14 | Greene | Iowa | 19073 | 1138 | 12 |
1810950 | 1810950 | 2021-10-13 | Greene | Iowa | 19073 | 1138 | 12 |
1793537 | 1793537 | 2021-10-07 | Lamoille | Vermont | 50015 | 1138 | 5 |
1790151 | 1790151 | 2021-10-06 | Marion | Texas | 48315 | 1138 | 44 |
1786903 | 1786903 | 2021-10-05 | Marion | Texas | 48315 | 1138 | 44 |
1783889 | 1783889 | 2021-10-04 | Northumberland | Virginia | 51133 | 1138 | 26 |
1768356 | 1768356 | 2021-09-30 | Lincoln | Georgia | 13181 | 1138 | 32 |
1768786 | 1768786 | 2021-09-30 | Clay | Kansas | 20027 | 1138 | 31 |
1765537 | 1765537 | 2021-09-29 | Clay | Kansas | 20027 | 1138 | 31 |
1761850 | 1761850 | 2021-09-28 | Jenkins | Georgia | 13165 | 1138 | 49 |
1762418 | 1762418 | 2021-09-28 | Gallatin | Kentucky | 21077 | 1138 | 36 |
1756500 | 1756500 | 2021-09-26 | Carbon | Montana | 30009 | 1138 | 19 |
1753252 | 1753252 | 2021-09-25 | Carbon | Montana | 30009 | 1138 | 19 |
1750004 | 1750004 | 2021-09-24 | Carbon | Montana | 30009 | 1138 | 19 |
1738935 | 1738935 | 2021-09-21 | Rio Grande | Colorado | 8105 | 1138 | 21 |
1741718 | 1741718 | 2021-09-21 | Lincoln | Washington | 53043 | 1138 | 16 |
1721480 | 1721480 | 2021-09-15 | Barceloneta | Puerto Rico | 72017 | 1138 | |
1717270 | 1717270 | 2021-09-14 | Murray | Minnesota | 27101 | 1138 | 10 |
1710996 | 1710996 | 2021-09-12 | St. Clair | Missouri | 29185 | 1138 | 9 |
1669543 | 1669543 | 2021-08-30 | Luquillo | Puerto Rico | 72089 | 1138 | |
1665846 | 1665846 | 2021-08-29 | Clay | North Carolina | 37043 | 1138 | 20 |
1662598 | 1662598 | 2021-08-28 | Clay | North Carolina | 37043 | 1138 | 20 |
1659314 | 1659314 | 2021-08-27 | Schuyler | New York | 36097 | 1138 | 14 |
1659350 | 1659350 | 2021-08-27 | Clay | North Carolina | 37043 | 1138 | 20 |
1650343 | 1650343 | 2021-08-24 | Clay | Texas | 48077 | 1138 | 18 |
1634343 | 1634343 | 2021-08-19 | Caledonia | Vermont | 50005 | 1138 | 7 |
1622285 | 1622285 | 2021-08-16 | Owyhee | Idaho | 16073 | 1138 | 31 |
1620351 | 1620351 | 2021-08-15 | Alleghany | North Carolina | 37005 | 1138 | 5 |
1615256 | 1615256 | 2021-08-14 | Sumter | Alabama | 1119 | 1138 | 34 |
1617103 | 1617103 | 2021-08-14 | Alleghany | North Carolina | 37005 | 1138 | 5 |
1612007 | 1612007 | 2021-08-13 | Sumter | Alabama | 1119 | 1138 | 34 |
1613855 | 1613855 | 2021-08-13 | Alleghany | North Carolina | 37005 | 1138 | 5 |
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);