ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
275 rows where cases = 1885 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 23
- Texas 19
- Indiana 16
- Oklahoma 16
- Illinois 12
- Iowa 11
- Mississippi 11
- Minnesota 10
- Tennessee 10
- Alabama 9
- Arkansas 9
- Georgia 9
- North Carolina 9
- Nebraska 8
- Puerto Rico 8
- Colorado 6
- Kentucky 6
- Louisiana 6
- Missouri 6
- California 5
- South Carolina 5
- Maine 4
- Michigan 4
- New Mexico 4
- Ohio 4
- Pennsylvania 4
- West Virginia 4
- Wisconsin 4
- Idaho 3
- South Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499431 | 2499431 | 2022-05-12 | Calhoun | West Virginia | 54013 | 1885 | 15 |
2335494 | 2335494 | 2022-03-23 | Gates | North Carolina | 37073 | 1885 | 19 |
2280967 | 2280967 | 2022-03-06 | Gaines | Texas | 48165 | 1885 | 83 |
2277714 | 2277714 | 2022-03-05 | Gaines | Texas | 48165 | 1885 | 83 |
2261939 | 2261939 | 2022-02-28 | Menominee | Wisconsin | 55078 | 1885 | 13 |
2248464 | 2248464 | 2022-02-24 | Hansford | Texas | 48195 | 1885 | 28 |
2245732 | 2245732 | 2022-02-23 | Platte | Wyoming | 56031 | 1885 | 39 |
2241941 | 2241941 | 2022-02-22 | Floyd | Texas | 48153 | 1885 | 47 |
2242481 | 2242481 | 2022-02-22 | Platte | Wyoming | 56031 | 1885 | 39 |
2238690 | 2238690 | 2022-02-21 | Floyd | Texas | 48153 | 1885 | 47 |
2225951 | 2225951 | 2022-02-17 | Falls Church city | Virginia | 51610 | 1885 | 16 |
2198399 | 2198399 | 2022-02-09 | Franklin | Mississippi | 28037 | 1885 | 35 |
2195492 | 2195492 | 2022-02-08 | White Pine | Nevada | 32033 | 1885 | 18 |
2175637 | 2175637 | 2022-02-02 | Humphreys | Mississippi | 28053 | 1885 | 40 |
2171504 | 2171504 | 2022-02-01 | Benewah | Idaho | 16009 | 1885 | 33 |
2172633 | 2172633 | 2022-02-01 | Custer | Nebraska | 31041 | 1885 | 27 |
2169380 | 2169380 | 2022-01-31 | Custer | Nebraska | 31041 | 1885 | 26 |
2157150 | 2157150 | 2022-01-27 | Custer | South Dakota | 46033 | 1885 | 21 |
2154386 | 2154386 | 2022-01-26 | Fairfax city | Virginia | 51600 | 1885 | 36 |
2148576 | 2148576 | 2022-01-25 | Candler | Georgia | 13043 | 1885 | 91 |
2149823 | 2149823 | 2022-01-25 | Rosebud | Montana | 30087 | 1885 | 58 |
2132413 | 2132413 | 2022-01-20 | Stewart | Georgia | 13259 | 1885 | 30 |
2133254 | 2133254 | 2022-01-20 | Jackson | Minnesota | 27063 | 1885 | 16 |
2126917 | 2126917 | 2022-01-18 | DeKalb | Missouri | 29063 | 1885 | 40 |
2128498 | 2128498 | 2022-01-18 | Clay | West Virginia | 54015 | 1885 | 30 |
2121909 | 2121909 | 2022-01-16 | Poquoson city | Virginia | 51735 | 1885 | 24 |
2118657 | 2118657 | 2022-01-15 | Poquoson city | Virginia | 51735 | 1885 | 24 |
2115405 | 2115405 | 2022-01-14 | Poquoson city | Virginia | 51735 | 1885 | 24 |
2109292 | 2109292 | 2022-01-13 | Perry | Arkansas | 5105 | 1885 | 26 |
2097694 | 2097694 | 2022-01-09 | Montgomery | Missouri | 29139 | 1885 | 34 |
2085527 | 2085527 | 2022-01-05 | Villalba | Puerto Rico | 72149 | 1885 | |
2082368 | 2082368 | 2022-01-04 | Lake | South Dakota | 46079 | 1885 | 22 |
2078016 | 2078016 | 2022-01-03 | Stevens | Minnesota | 27149 | 1885 | 11 |
2079863 | 2079863 | 2022-01-03 | Washakie | Wyoming | 56043 | 1885 | 37 |
2074765 | 2074765 | 2022-01-02 | Stevens | Minnesota | 27149 | 1885 | 11 |
2071514 | 2071514 | 2022-01-01 | Stevens | Minnesota | 27149 | 1885 | 11 |
2068263 | 2068263 | 2021-12-31 | Stevens | Minnesota | 27149 | 1885 | 11 |
2065012 | 2065012 | 2021-12-30 | Stevens | Minnesota | 27149 | 1885 | 11 |
2034055 | 2034055 | 2021-12-20 | Brunswick | Virginia | 51025 | 1885 | 35 |
2018127 | 2018127 | 2021-12-16 | Coosa | Alabama | 1037 | 1885 | 48 |
2006849 | 2006849 | 2021-12-12 | Red Willow | Nebraska | 31145 | 1885 | 16 |
2003598 | 2003598 | 2021-12-11 | Red Willow | Nebraska | 31145 | 1885 | 16 |
2000348 | 2000348 | 2021-12-10 | Red Willow | Nebraska | 31145 | 1885 | 16 |
1996361 | 1996361 | 2021-12-09 | Bath | Kentucky | 21011 | 1885 | 33 |
1944812 | 1944812 | 2021-11-23 | Noxubee | Mississippi | 28103 | 1885 | 42 |
1941561 | 1941561 | 2021-11-22 | Noxubee | Mississippi | 28103 | 1885 | 42 |
1927311 | 1927311 | 2021-11-18 | Plumas | California | 6063 | 1885 | 8 |
1907249 | 1907249 | 2021-11-11 | Unknown | Utah | 1885 | 38 | |
1886942 | 1886942 | 2021-11-05 | Harrison | Ohio | 39067 | 1885 | 48 |
1882791 | 1882791 | 2021-11-04 | Lincoln | Maine | 23015 | 1885 | 7 |
1881241 | 1881241 | 2021-11-03 | Morgan | Utah | 49029 | 1885 | 12 |
1881402 | 1881402 | 2021-11-03 | Westmoreland | Virginia | 51193 | 1885 | 36 |
1874321 | 1874321 | 2021-11-01 | Butte | South Dakota | 46019 | 1885 | 31 |
1861834 | 1861834 | 2021-10-28 | Greensville | Virginia | 51081 | 1885 | 28 |
1858585 | 1858585 | 2021-10-27 | Greensville | Virginia | 51081 | 1885 | 28 |
1853253 | 1853253 | 2021-10-26 | Allen | Kansas | 20001 | 1885 | 25 |
1853378 | 1853378 | 2021-10-26 | Carroll | Kentucky | 21041 | 1885 | 26 |
1854392 | 1854392 | 2021-10-26 | Mountrail | North Dakota | 38061 | 1885 | 26 |
1850004 | 1850004 | 2021-10-25 | Allen | Kansas | 20001 | 1885 | 25 |
1823731 | 1823731 | 2021-10-17 | Cumberland | Illinois | 17035 | 1885 | 38 |
1820482 | 1820482 | 2021-10-16 | Cumberland | Illinois | 17035 | 1885 | 38 |
1817233 | 1817233 | 2021-10-15 | Cumberland | Illinois | 17035 | 1885 | 38 |
1809053 | 1809053 | 2021-10-12 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1805803 | 1805803 | 2021-10-11 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1802553 | 1802553 | 2021-10-10 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1799304 | 1799304 | 2021-10-09 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1796055 | 1796055 | 2021-10-08 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1792613 | 1792613 | 2021-10-07 | Swain | North Carolina | 37173 | 1885 | 22 |
1792806 | 1792806 | 2021-10-07 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1789557 | 1789557 | 2021-10-06 | Johnston | Oklahoma | 40069 | 1885 | 43 |
1783852 | 1783852 | 2021-10-04 | Goochland | Virginia | 51075 | 1885 | 28 |
1780645 | 1780645 | 2021-10-03 | Patrick | Virginia | 51141 | 1885 | 52 |
1777395 | 1777395 | 2021-10-02 | Patrick | Virginia | 51141 | 1885 | 52 |
1774145 | 1774145 | 2021-10-01 | Patrick | Virginia | 51141 | 1885 | 52 |
1757224 | 1757224 | 2021-09-26 | Cabo Rojo | Puerto Rico | 72023 | 1885 | |
1747484 | 1747484 | 2021-09-23 | Catano | Puerto Rico | 72033 | 1885 | |
1743124 | 1743124 | 2021-09-22 | Nantucket | Massachusetts | 25019 | 1885 | 0 |
1741823 | 1741823 | 2021-09-21 | Lafayette | Wisconsin | 55065 | 1885 | 11 |
1702768 | 1702768 | 2021-09-09 | Hardy | West Virginia | 54031 | 1885 | 25 |
1690090 | 1690090 | 2021-09-06 | Van Buren | Arkansas | 5141 | 1885 | 35 |
1689779 | 1689779 | 2021-09-05 | Lewis | West Virginia | 54041 | 1885 | 25 |
1674727 | 1674727 | 2021-09-01 | Lawrence | Kentucky | 21127 | 1885 | 31 |
1667691 | 1667691 | 2021-08-30 | Telfair | Georgia | 13271 | 1885 | 61 |
1668620 | 1668620 | 2021-08-30 | Lawrence | Mississippi | 28077 | 1885 | 29 |
1665743 | 1665743 | 2021-08-29 | Grant | New Mexico | 35017 | 1885 | 43 |
1662495 | 1662495 | 2021-08-28 | Grant | New Mexico | 35017 | 1885 | 43 |
1663054 | 1663054 | 2021-08-28 | Morovis | Puerto Rico | 72101 | 1885 | |
1659247 | 1659247 | 2021-08-27 | Grant | New Mexico | 35017 | 1885 | 43 |
1655529 | 1655529 | 2021-08-26 | Houston | Minnesota | 27055 | 1885 | 16 |
1626935 | 1626935 | 2021-08-17 | Warren | North Carolina | 37185 | 1885 | 20 |
1623688 | 1623688 | 2021-08-16 | Warren | North Carolina | 37185 | 1885 | 20 |
1624568 | 1624568 | 2021-08-16 | Zapata | Texas | 48505 | 1885 | 38 |
1621321 | 1621321 | 2021-08-15 | Zapata | Texas | 48505 | 1885 | 38 |
1617554 | 1617554 | 2021-08-14 | Fajardo | Puerto Rico | 72053 | 1885 | |
1602988 | 1602988 | 2021-08-10 | Vermillion | Indiana | 18165 | 1885 | 44 |
1540607 | 1540607 | 2021-07-22 | Clay | Arkansas | 5021 | 1885 | 52 |
1537818 | 1537818 | 2021-07-21 | Gem | Idaho | 16045 | 1885 | 42 |
1534625 | 1534625 | 2021-07-20 | Hancock | Illinois | 17067 | 1885 | 42 |
1531356 | 1531356 | 2021-07-19 | Clark | Illinois | 17023 | 1885 | 42 |
1532089 | 1532089 | 2021-07-19 | Dodge | Minnesota | 27039 | 1885 | 3 |
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);