ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
214 rows where cases = 2725 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Kentucky 12
- Missouri 11
- Ohio 11
- Illinois 10
- Iowa 10
- Michigan 10
- North Dakota 10
- Virginia 9
- Texas 8
- Minnesota 7
- Tennessee 7
- Indiana 6
- North Carolina 6
- Vermont 6
- Louisiana 5
- Mississippi 5
- New York 5
- Florida 4
- Kansas 4
- Maine 4
- Pennsylvania 4
- West Virginia 4
- Alabama 3
- Arkansas 3
- Maryland 3
- Nebraska 3
- Oklahoma 3
- Washington 3
- Alaska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452758 | 2452758 | 2022-04-28 | McLean | North Dakota | 38055 | 2725 | 49 |
2449502 | 2449502 | 2022-04-27 | McLean | North Dakota | 38055 | 2725 | 49 |
2446245 | 2446245 | 2022-04-26 | McLean | North Dakota | 38055 | 2725 | 49 |
2442990 | 2442990 | 2022-04-25 | McLean | North Dakota | 38055 | 2725 | 49 |
2439734 | 2439734 | 2022-04-24 | McLean | North Dakota | 38055 | 2725 | 49 |
2436478 | 2436478 | 2022-04-23 | McLean | North Dakota | 38055 | 2725 | 49 |
2433222 | 2433222 | 2022-04-22 | McLean | North Dakota | 38055 | 2725 | 49 |
2376696 | 2376696 | 2022-04-05 | Lyon | Iowa | 19119 | 2725 | 50 |
2373444 | 2373444 | 2022-04-04 | Lyon | Iowa | 19119 | 2725 | 50 |
2374419 | 2374419 | 2022-04-04 | Los Alamos | New Mexico | 35028 | 2725 | 16 |
2370191 | 2370191 | 2022-04-03 | Lyon | Iowa | 19119 | 2725 | 50 |
2366938 | 2366938 | 2022-04-02 | Lyon | Iowa | 19119 | 2725 | 50 |
2363685 | 2363685 | 2022-04-01 | Lyon | Iowa | 19119 | 2725 | 50 |
2360431 | 2360431 | 2022-03-31 | Lyon | Iowa | 19119 | 2725 | 50 |
2357177 | 2357177 | 2022-03-30 | Lyon | Iowa | 19119 | 2725 | 50 |
2290047 | 2290047 | 2022-03-09 | McLean | North Dakota | 38055 | 2725 | 49 |
2277038 | 2277038 | 2022-03-05 | McLean | North Dakota | 38055 | 2725 | 49 |
2242781 | 2242781 | 2022-02-23 | Park | Colorado | 8093 | 2725 | 20 |
2242970 | 2242970 | 2022-02-23 | Long | Georgia | 13183 | 2725 | 31 |
2217554 | 2217554 | 2022-02-15 | Lyon | Kentucky | 21143 | 2725 | 33 |
2193889 | 2193889 | 2022-02-08 | Stone | Arkansas | 5137 | 2725 | 54 |
2189112 | 2189112 | 2022-02-06 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2185859 | 2185859 | 2022-02-05 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2182607 | 2182607 | 2022-02-04 | Alleghany | North Carolina | 37005 | 2725 | 11 |
2172053 | 2172053 | 2022-02-01 | Todd | Kentucky | 21219 | 2725 | 39 |
2154563 | 2154563 | 2022-01-26 | Roane | West Virginia | 54087 | 2725 | 30 |
2132665 | 2132665 | 2022-01-20 | Pulaski | Indiana | 18131 | 2725 | 76 |
2119353 | 2119353 | 2022-01-16 | Jasper | Georgia | 13159 | 2725 | 62 |
2116101 | 2116101 | 2022-01-15 | Jasper | Georgia | 13159 | 2725 | 62 |
2112850 | 2112850 | 2022-01-14 | Jasper | Georgia | 13159 | 2725 | 62 |
2106990 | 2106990 | 2022-01-12 | Trigg | Kentucky | 21221 | 2725 | 32 |
2102011 | 2102011 | 2022-01-10 | Bandera | Texas | 48019 | 2725 | 65 |
2092475 | 2092475 | 2022-01-07 | Tyler | Texas | 48457 | 2725 | 74 |
2078141 | 2078141 | 2022-01-03 | Dallas | Missouri | 29059 | 2725 | 59 |
2049745 | 2049745 | 2021-12-25 | Moca | Puerto Rico | 72099 | 2725 | |
2041372 | 2041372 | 2021-12-23 | Rabun | Georgia | 13241 | 2725 | 76 |
2031788 | 2031788 | 2021-12-20 | Piatt | Illinois | 17147 | 2725 | 21 |
2029260 | 2029260 | 2021-12-19 | Sibley | Minnesota | 27143 | 2725 | 20 |
2026009 | 2026009 | 2021-12-18 | Sibley | Minnesota | 27143 | 2725 | 20 |
2022758 | 2022758 | 2021-12-17 | Sibley | Minnesota | 27143 | 2725 | 20 |
2009001 | 2009001 | 2021-12-13 | Jo Daviess | Illinois | 17085 | 2725 | 33 |
1986994 | 1986994 | 2021-12-06 | Renville | Minnesota | 27129 | 2725 | 51 |
1974043 | 1974043 | 2021-12-02 | Holmes | Mississippi | 28051 | 2725 | 89 |
1969824 | 1969824 | 2021-12-01 | Jefferson | Georgia | 13163 | 2725 | 89 |
1970967 | 1970967 | 2021-12-01 | Wright | Missouri | 29229 | 2725 | 64 |
1962523 | 1962523 | 2021-11-28 | Windham | Vermont | 50025 | 2725 | 26 |
1959272 | 1959272 | 2021-11-27 | Windham | Vermont | 50025 | 2725 | 26 |
1956021 | 1956021 | 2021-11-26 | Windham | Vermont | 50025 | 2725 | 26 |
1952770 | 1952770 | 2021-11-25 | Windham | Vermont | 50025 | 2725 | 26 |
1949519 | 1949519 | 2021-11-24 | Windham | Vermont | 50025 | 2725 | 26 |
1938092 | 1938092 | 2021-11-21 | Antrim | Michigan | 26009 | 2725 | 41 |
1934842 | 1934842 | 2021-11-20 | Antrim | Michigan | 26009 | 2725 | 41 |
1936746 | 1936746 | 2021-11-20 | Wetzel | West Virginia | 54103 | 2725 | 58 |
1931592 | 1931592 | 2021-11-19 | Antrim | Michigan | 26009 | 2725 | 41 |
1928294 | 1928294 | 2021-11-18 | Waldo | Maine | 23027 | 2725 | 34 |
1915159 | 1915159 | 2021-11-14 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1911909 | 1911909 | 2021-11-13 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1908660 | 1908660 | 2021-11-12 | Lawrence | Kentucky | 21127 | 2725 | 42 |
1909638 | 1909638 | 2021-11-12 | Richland | North Dakota | 38077 | 2725 | 21 |
1898574 | 1898574 | 2021-11-09 | Franklin | Indiana | 18047 | 2725 | 46 |
1872140 | 1872140 | 2021-11-01 | Otero | Colorado | 8089 | 2725 | 84 |
1867466 | 1867466 | 2021-10-30 | Meigs | Ohio | 39105 | 2725 | 55 |
1850298 | 1850298 | 2021-10-25 | Hancock | Maine | 23009 | 2725 | 48 |
1847048 | 1847048 | 2021-10-24 | Hancock | Maine | 23009 | 2725 | 48 |
1843798 | 1843798 | 2021-10-23 | Hancock | Maine | 23009 | 2725 | 48 |
1836688 | 1836688 | 2021-10-21 | Gem | Idaho | 16045 | 2725 | 56 |
1831502 | 1831502 | 2021-10-19 | Seneca | New York | 36099 | 2725 | 63 |
1808146 | 1808146 | 2021-10-12 | Iosco | Michigan | 26069 | 2725 | 88 |
1804895 | 1804895 | 2021-10-11 | Iosco | Michigan | 26069 | 2725 | 88 |
1786660 | 1786660 | 2021-10-05 | Cannon | Tennessee | 47015 | 2725 | 39 |
1783411 | 1783411 | 2021-10-04 | Cannon | Tennessee | 47015 | 2725 | 39 |
1778324 | 1778324 | 2021-10-03 | White | Illinois | 17193 | 2725 | 42 |
1775074 | 1775074 | 2021-10-02 | White | Illinois | 17193 | 2725 | 42 |
1771824 | 1771824 | 2021-10-01 | White | Illinois | 17193 | 2725 | 42 |
1770704 | 1770704 | 2021-09-30 | San Jacinto | Texas | 48407 | 2725 | 66 |
1770786 | 1770786 | 2021-09-30 | Bennington | Vermont | 50003 | 2725 | 19 |
1751219 | 1751219 | 2021-09-24 | Shelby | Texas | 48419 | 2725 | 92 |
1703985 | 1703985 | 2021-09-10 | McCreary | Kentucky | 21147 | 2725 | 35 |
1698021 | 1698021 | 2021-09-08 | Big Horn | Montana | 30003 | 2725 | 77 |
1681765 | 1681765 | 2021-09-03 | Vernon | Missouri | 29217 | 2725 | 54 |
1655713 | 1655713 | 2021-08-26 | Henry | Missouri | 29083 | 2725 | 41 |
1655957 | 1655957 | 2021-08-26 | Carroll | New Hampshire | 33003 | 2725 | 13 |
1657219 | 1657219 | 2021-08-26 | Staunton city | Virginia | 51790 | 2725 | 71 |
1646984 | 1646984 | 2021-08-23 | Fentress | Tennessee | 47049 | 2725 | 50 |
1635903 | 1635903 | 2021-08-20 | Somerset | Maryland | 24039 | 2725 | 42 |
1628649 | 1628649 | 2021-08-18 | Hart | Georgia | 13147 | 2725 | 57 |
1602313 | 1602313 | 2021-08-10 | Arkansas | Arkansas | 5001 | 2725 | 45 |
1603344 | 1603344 | 2021-08-10 | Grant | Louisiana | 22043 | 2725 | 58 |
1594138 | 1594138 | 2021-08-07 | Cass | Nebraska | 31025 | 2725 | 17 |
1590889 | 1590889 | 2021-08-06 | Cass | Nebraska | 31025 | 2725 | 17 |
1588380 | 1588380 | 2021-08-05 | Barnwell | South Carolina | 45011 | 2725 | 58 |
1561893 | 1561893 | 2021-07-28 | Cherokee | North Carolina | 37039 | 2725 | 39 |
1558820 | 1558820 | 2021-07-27 | Holmes | Ohio | 39075 | 2725 | 102 |
1555551 | 1555551 | 2021-07-26 | Coshocton | Ohio | 39031 | 2725 | 61 |
1555573 | 1555573 | 2021-07-26 | Holmes | Ohio | 39075 | 2725 | 102 |
1552304 | 1552304 | 2021-07-25 | Coshocton | Ohio | 39031 | 2725 | 61 |
1552326 | 1552326 | 2021-07-25 | Holmes | Ohio | 39075 | 2725 | 102 |
1549057 | 1549057 | 2021-07-24 | Coshocton | Ohio | 39031 | 2725 | 61 |
1549079 | 1549079 | 2021-07-24 | Holmes | Ohio | 39075 | 2725 | 102 |
1545832 | 1545832 | 2021-07-23 | Holmes | Ohio | 39075 | 2725 | 102 |
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);