ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 1725 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 24
- Illinois 18
- Georgia 17
- Texas 16
- Michigan 14
- Colorado 13
- Alabama 12
- South Dakota 12
- Tennessee 12
- Florida 11
- Virginia 11
- Missouri 10
- North Carolina 9
- Oklahoma 9
- Minnesota 8
- North Dakota 8
- South Carolina 8
- Arkansas 7
- Iowa 7
- Kentucky 7
- Puerto Rico 7
- Indiana 6
- Ohio 6
- Idaho 5
- Pennsylvania 5
- West Virginia 5
- Nebraska 4
- New York 4
- Utah 4
- Wisconsin 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448142 | 2448142 | 2022-04-27 | Pulaski | Illinois | 17153 | 1725 | 19 |
2444886 | 2444886 | 2022-04-26 | Pulaski | Illinois | 17153 | 1725 | 19 |
2377084 | 2377084 | 2022-04-05 | Alcona | Michigan | 26001 | 1725 | 71 |
2373832 | 2373832 | 2022-04-04 | Alcona | Michigan | 26001 | 1725 | 71 |
2369591 | 2369591 | 2022-04-03 | Conejos | Colorado | 8021 | 1725 | 54 |
2370579 | 2370579 | 2022-04-03 | Alcona | Michigan | 26001 | 1725 | 71 |
2367326 | 2367326 | 2022-04-02 | Alcona | Michigan | 26001 | 1725 | 71 |
2364073 | 2364073 | 2022-04-01 | Alcona | Michigan | 26001 | 1725 | 71 |
2360819 | 2360819 | 2022-03-31 | Alcona | Michigan | 26001 | 1725 | 71 |
2356577 | 2356577 | 2022-03-30 | Conejos | Colorado | 8021 | 1725 | 54 |
2357565 | 2357565 | 2022-03-30 | Alcona | Michigan | 26001 | 1725 | 71 |
2353324 | 2353324 | 2022-03-29 | Conejos | Colorado | 8021 | 1725 | 54 |
2325035 | 2325035 | 2022-03-20 | Alcona | Michigan | 26001 | 1725 | 71 |
2321781 | 2321781 | 2022-03-19 | Alcona | Michigan | 26001 | 1725 | 71 |
2317468 | 2317468 | 2022-03-18 | Woodruff | Arkansas | 5147 | 1725 | 29 |
2318527 | 2318527 | 2022-03-18 | Alcona | Michigan | 26001 | 1725 | 71 |
2309446 | 2309446 | 2022-03-15 | Camden | North Carolina | 37029 | 1725 | 9 |
2307330 | 2307330 | 2022-03-14 | Williamsburg city | Virginia | 51830 | 1725 | 21 |
2282874 | 2282874 | 2022-03-07 | Lac qui Parle | Minnesota | 27073 | 1725 | 28 |
2284007 | 2284007 | 2022-03-07 | Hutchinson | South Dakota | 46067 | 1725 | 36 |
2270996 | 2270996 | 2022-03-03 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2267744 | 2267744 | 2022-03-02 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2263359 | 2263359 | 2022-03-01 | Lac qui Parle | Minnesota | 27073 | 1725 | 28 |
2264491 | 2264491 | 2022-03-01 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2261241 | 2261241 | 2022-02-28 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2257990 | 2257990 | 2022-02-27 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2254739 | 2254739 | 2022-02-26 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2249121 | 2249121 | 2022-02-25 | Dallas | Arkansas | 5039 | 1725 | 28 |
2251488 | 2251488 | 2022-02-25 | Hutchinson | South Dakota | 46067 | 1725 | 35 |
2248237 | 2248237 | 2022-02-24 | Hutchinson | South Dakota | 46067 | 1725 | 34 |
2244986 | 2244986 | 2022-02-23 | Hutchinson | South Dakota | 46067 | 1725 | 34 |
2209548 | 2209548 | 2022-02-12 | Refugio | Texas | 48391 | 1725 | 31 |
2178985 | 2178985 | 2022-02-03 | Harrison | Missouri | 29081 | 1725 | 27 |
2175885 | 2175885 | 2022-02-02 | Cuming | Nebraska | 31039 | 1725 | 15 |
2170399 | 2170399 | 2022-01-31 | Gaines | Texas | 48165 | 1725 | 75 |
2132064 | 2132064 | 2022-01-20 | Prairie | Arkansas | 5117 | 1725 | 32 |
2124839 | 2124839 | 2022-01-17 | Floyd | Texas | 48153 | 1725 | 42 |
2118936 | 2118936 | 2022-01-16 | Perry | Alabama | 1105 | 1725 | 40 |
2106270 | 2106270 | 2022-01-12 | Atkinson | Georgia | 13003 | 1725 | 39 |
2104681 | 2104681 | 2022-01-11 | Traill | North Dakota | 38097 | 1725 | 21 |
2099976 | 2099976 | 2022-01-10 | Valley | Idaho | 16085 | 1725 | 13 |
2097751 | 2097751 | 2022-01-09 | Deer Lodge | Montana | 30023 | 1725 | 28 |
2094499 | 2094499 | 2022-01-08 | Deer Lodge | Montana | 30023 | 1725 | 28 |
2091247 | 2091247 | 2022-01-07 | Deer Lodge | Montana | 30023 | 1725 | 28 |
2079664 | 2079664 | 2022-01-03 | Sussex | Virginia | 51183 | 1725 | 31 |
2079757 | 2079757 | 2022-01-03 | Ritchie | West Virginia | 54085 | 1725 | 25 |
2053581 | 2053581 | 2021-12-26 | Floyd | Virginia | 51063 | 1725 | 33 |
2050331 | 2050331 | 2021-12-25 | Floyd | Virginia | 51063 | 1725 | 33 |
2047081 | 2047081 | 2021-12-24 | Floyd | Virginia | 51063 | 1725 | 33 |
2008925 | 2008925 | 2021-12-13 | Boundary | Idaho | 16021 | 1725 | 48 |
2011245 | 2011245 | 2021-12-13 | Emery | Utah | 49015 | 1725 | 25 |
2007994 | 2007994 | 2021-12-12 | Emery | Utah | 49015 | 1725 | 25 |
2004743 | 2004743 | 2021-12-11 | Emery | Utah | 49015 | 1725 | 25 |
1997282 | 1997282 | 2021-12-09 | Clay | North Carolina | 37043 | 1725 | 38 |
1982644 | 1982644 | 2021-12-05 | Park | Colorado | 8093 | 1725 | 13 |
1979394 | 1979394 | 2021-12-04 | Park | Colorado | 8093 | 1725 | 13 |
1976144 | 1976144 | 2021-12-03 | Park | Colorado | 8093 | 1725 | 13 |
1924375 | 1924375 | 2021-11-17 | Turner | Georgia | 13287 | 1725 | 49 |
1915542 | 1915542 | 2021-11-14 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1912292 | 1912292 | 2021-11-13 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1909042 | 1909042 | 2021-11-12 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1905793 | 1905793 | 2021-11-11 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1902544 | 1902544 | 2021-11-10 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1899294 | 1899294 | 2021-11-09 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1896044 | 1896044 | 2021-11-08 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1892794 | 1892794 | 2021-11-07 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1889544 | 1889544 | 2021-11-06 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1886294 | 1886294 | 2021-11-05 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1883045 | 1883045 | 2021-11-04 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1879796 | 1879796 | 2021-11-03 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1875190 | 1875190 | 2021-11-02 | Valdez-Cordova Census Area | Alaska | 2261 | 1725 | 7 |
1876547 | 1876547 | 2021-11-02 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1876654 | 1876654 | 2021-11-02 | Lewis | Missouri | 29111 | 1725 | 22 |
1873298 | 1873298 | 2021-11-01 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1873755 | 1873755 | 2021-11-01 | Yates | New York | 36123 | 1725 | 29 |
1868780 | 1868780 | 2021-10-31 | Stone | Arkansas | 5137 | 1725 | 43 |
1870049 | 1870049 | 2021-10-31 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1866800 | 1866800 | 2021-10-30 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1863551 | 1863551 | 2021-10-29 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1859072 | 1859072 | 2021-10-28 | Plumas | California | 6063 | 1725 | 7 |
1860302 | 1860302 | 2021-10-28 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1852606 | 1852606 | 2021-10-26 | Bent | Colorado | 8011 | 1725 | 27 |
1855387 | 1855387 | 2021-10-26 | Richmond | Virginia | 51159 | 1725 | 13 |
1846523 | 1846523 | 2021-10-24 | Menard | Illinois | 17129 | 1725 | 17 |
1843273 | 1843273 | 2021-10-23 | Menard | Illinois | 17129 | 1725 | 17 |
1840023 | 1840023 | 2021-10-22 | Menard | Illinois | 17129 | 1725 | 17 |
1830859 | 1830859 | 2021-10-19 | Arenac | Michigan | 26011 | 1725 | 33 |
1827610 | 1827610 | 2021-10-18 | Arenac | Michigan | 26011 | 1725 | 33 |
1825537 | 1825537 | 2021-10-17 | Calhoun | South Carolina | 45017 | 1725 | 51 |
1822288 | 1822288 | 2021-10-16 | Calhoun | South Carolina | 45017 | 1725 | 51 |
1819039 | 1819039 | 2021-10-15 | Calhoun | South Carolina | 45017 | 1725 | 51 |
1793912 | 1793912 | 2021-10-08 | Lowndes | Alabama | 1085 | 1725 | 61 |
1795965 | 1795965 | 2021-10-08 | Harrison | Ohio | 39067 | 1725 | 41 |
1790663 | 1790663 | 2021-10-07 | Lowndes | Alabama | 1085 | 1725 | 60 |
1786606 | 1786606 | 2021-10-05 | Dewey | South Dakota | 46041 | 1725 | 30 |
1768473 | 1768473 | 2021-09-30 | Shoshone | Idaho | 16079 | 1725 | 52 |
1762400 | 1762400 | 2021-09-28 | Carroll | Kentucky | 21041 | 1725 | 22 |
1757251 | 1757251 | 2021-09-26 | Juana Diaz | Puerto Rico | 72075 | 1725 | |
1740818 | 1740818 | 2021-09-21 | Haskell | Oklahoma | 40061 | 1725 | 24 |
1737569 | 1737569 | 2021-09-20 | Haskell | Oklahoma | 40061 | 1725 | 24 |
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);