ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
264 rows where cases = 1712 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 38
- Virginia 16
- Alabama 14
- Missouri 14
- Texas 14
- Arkansas 13
- Michigan 11
- Colorado 10
- Idaho 10
- Illinois 9
- North Carolina 9
- Minnesota 8
- Puerto Rico 8
- Georgia 7
- Indiana 7
- Kentucky 6
- Louisiana 6
- Mississippi 6
- Pennsylvania 6
- Tennessee 6
- Nebraska 5
- Ohio 5
- Florida 4
- Oklahoma 4
- North Dakota 3
- South Dakota 3
- West Virginia 3
- Kansas 2
- New Hampshire 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475033 | 2475033 | 2022-05-05 | Chariton | Missouri | 29041 | 1712 | 38 |
2308357 | 2308357 | 2022-03-15 | Greene | Iowa | 19073 | 1712 | 21 |
2308827 | 2308827 | 2022-03-15 | Montmorency | Michigan | 26119 | 1712 | 47 |
2305106 | 2305106 | 2022-03-14 | Greene | Iowa | 19073 | 1712 | 21 |
2305576 | 2305576 | 2022-03-14 | Montmorency | Michigan | 26119 | 1712 | 47 |
2301854 | 2301854 | 2022-03-13 | Greene | Iowa | 19073 | 1712 | 21 |
2302324 | 2302324 | 2022-03-13 | Montmorency | Michigan | 26119 | 1712 | 47 |
2298602 | 2298602 | 2022-03-12 | Greene | Iowa | 19073 | 1712 | 21 |
2299072 | 2299072 | 2022-03-12 | Montmorency | Michigan | 26119 | 1712 | 47 |
2295350 | 2295350 | 2022-03-11 | Greene | Iowa | 19073 | 1712 | 21 |
2295820 | 2295820 | 2022-03-11 | Montmorency | Michigan | 26119 | 1712 | 47 |
2291450 | 2291450 | 2022-03-10 | Woodruff | Arkansas | 5147 | 1712 | 28 |
2292098 | 2292098 | 2022-03-10 | Greene | Iowa | 19073 | 1712 | 21 |
2288846 | 2288846 | 2022-03-09 | Greene | Iowa | 19073 | 1712 | 21 |
2279501 | 2279501 | 2022-03-06 | Alcona | Michigan | 26001 | 1712 | 68 |
2276248 | 2276248 | 2022-03-05 | Alcona | Michigan | 26001 | 1712 | 68 |
2272995 | 2272995 | 2022-03-04 | Alcona | Michigan | 26001 | 1712 | 68 |
2259422 | 2259422 | 2022-02-28 | Pulaski | Illinois | 17153 | 1712 | 18 |
2237745 | 2237745 | 2022-02-21 | Unknown | Nebraska | 1712 | 383 | |
2222672 | 2222672 | 2022-02-16 | Bland | Virginia | 51021 | 1712 | 20 |
2193454 | 2193454 | 2022-02-07 | Lancaster | Virginia | 51103 | 1712 | 26 |
2164056 | 2164056 | 2022-01-29 | Winkler | Texas | 48495 | 1712 | 33 |
2161075 | 2161075 | 2022-01-28 | Tucker | West Virginia | 54093 | 1712 | 33 |
2132053 | 2132053 | 2022-01-20 | Monroe | Arkansas | 5095 | 1712 | 28 |
2130329 | 2130329 | 2022-01-19 | Cheyenne | Nebraska | 31033 | 1712 | 21 |
2087335 | 2087335 | 2022-01-06 | Norton | Kansas | 20137 | 1712 | 35 |
2089179 | 2089179 | 2022-01-06 | Parmer | Texas | 48369 | 1712 | 45 |
2084083 | 2084083 | 2022-01-05 | Norton | Kansas | 20137 | 1712 | 35 |
2084744 | 2084744 | 2022-01-05 | Deer Lodge | Montana | 30023 | 1712 | 28 |
2078149 | 2078149 | 2022-01-03 | Gentry | Missouri | 29075 | 1712 | 28 |
2064054 | 2064054 | 2021-12-30 | Evans | Georgia | 13109 | 1712 | 55 |
2060796 | 2060796 | 2021-12-29 | Dooly | Georgia | 13093 | 1712 | 62 |
2056714 | 2056714 | 2021-12-27 | Trinity | Texas | 48455 | 1712 | 64 |
2030835 | 2030835 | 2021-12-19 | Franklin city | Virginia | 51620 | 1712 | 43 |
2027584 | 2027584 | 2021-12-18 | Franklin city | Virginia | 51620 | 1712 | 43 |
2024333 | 2024333 | 2021-12-17 | Franklin city | Virginia | 51620 | 1712 | 43 |
1992697 | 1992697 | 2021-12-08 | Owyhee | Idaho | 16073 | 1712 | 41 |
1994081 | 1994081 | 2021-12-08 | Perquimans | North Carolina | 37143 | 1712 | 16 |
1982920 | 1982920 | 2021-12-05 | Boundary | Idaho | 16021 | 1712 | 48 |
1984279 | 1984279 | 2021-12-05 | Clay | North Carolina | 37043 | 1712 | 38 |
1985384 | 1985384 | 2021-12-05 | Richmond | Virginia | 51159 | 1712 | 16 |
1979670 | 1979670 | 2021-12-04 | Boundary | Idaho | 16021 | 1712 | 48 |
1981029 | 1981029 | 2021-12-04 | Clay | North Carolina | 37043 | 1712 | 38 |
1982134 | 1982134 | 2021-12-04 | Richmond | Virginia | 51159 | 1712 | 16 |
1977779 | 1977779 | 2021-12-03 | Clay | North Carolina | 37043 | 1712 | 38 |
1978884 | 1978884 | 2021-12-03 | Richmond | Virginia | 51159 | 1712 | 16 |
1960198 | 1960198 | 2021-11-28 | Teton | Idaho | 16081 | 1712 | 6 |
1956947 | 1956947 | 2021-11-27 | Teton | Idaho | 16081 | 1712 | 6 |
1953696 | 1953696 | 2021-11-26 | Teton | Idaho | 16081 | 1712 | 6 |
1950445 | 1950445 | 2021-11-25 | Teton | Idaho | 16081 | 1712 | 6 |
1947194 | 1947194 | 2021-11-24 | Teton | Idaho | 16081 | 1712 | 6 |
1945812 | 1945812 | 2021-11-23 | Bon Homme | South Dakota | 46009 | 1712 | 30 |
1921988 | 1921988 | 2021-11-16 | Rock | Minnesota | 27133 | 1712 | 27 |
1909485 | 1909485 | 2021-11-12 | Schuyler | New York | 36097 | 1712 | 19 |
1905768 | 1905768 | 2021-11-11 | Carroll | Mississippi | 28015 | 1712 | 40 |
1902519 | 1902519 | 2021-11-10 | Carroll | Mississippi | 28015 | 1712 | 40 |
1902854 | 1902854 | 2021-11-10 | Unknown | Nebraska | 1712 | 179 | |
1898674 | 1898674 | 2021-11-09 | Emmet | Iowa | 19063 | 1712 | 46 |
1900807 | 1900807 | 2021-11-09 | Dickenson | Virginia | 51051 | 1712 | 28 |
1895424 | 1895424 | 2021-11-08 | Emmet | Iowa | 19063 | 1712 | 46 |
1892174 | 1892174 | 2021-11-07 | Emmet | Iowa | 19063 | 1712 | 46 |
1888924 | 1888924 | 2021-11-06 | Emmet | Iowa | 19063 | 1712 | 46 |
1885674 | 1885674 | 2021-11-05 | Emmet | Iowa | 19063 | 1712 | 46 |
1882425 | 1882425 | 2021-11-04 | Emmet | Iowa | 19063 | 1712 | 46 |
1878880 | 1878880 | 2021-11-03 | Turner | Georgia | 13287 | 1712 | 49 |
1879176 | 1879176 | 2021-11-03 | Emmet | Iowa | 19063 | 1712 | 46 |
1875234 | 1875234 | 2021-11-02 | Fulton | Arkansas | 5049 | 1712 | 64 |
1875631 | 1875631 | 2021-11-02 | Turner | Georgia | 13287 | 1712 | 49 |
1868896 | 1868896 | 2021-10-31 | Prowers | Colorado | 8099 | 1712 | 30 |
1865417 | 1865417 | 2021-10-30 | Wilcox | Alabama | 1131 | 1712 | 39 |
1865647 | 1865647 | 2021-10-30 | Prowers | Colorado | 8099 | 1712 | 30 |
1866907 | 1866907 | 2021-10-30 | Lewis | Missouri | 29111 | 1712 | 22 |
1862398 | 1862398 | 2021-10-29 | Prowers | Colorado | 8099 | 1712 | 30 |
1849357 | 1849357 | 2021-10-25 | Bent | Colorado | 8011 | 1712 | 27 |
1838581 | 1838581 | 2021-10-21 | Charles Mix | South Dakota | 46023 | 1712 | 26 |
1807668 | 1807668 | 2021-10-12 | Appanoose | Iowa | 19007 | 1712 | 50 |
1804417 | 1804417 | 2021-10-11 | Appanoose | Iowa | 19007 | 1712 | 50 |
1801168 | 1801168 | 2021-10-10 | Appanoose | Iowa | 19007 | 1712 | 50 |
1797919 | 1797919 | 2021-10-09 | Appanoose | Iowa | 19007 | 1712 | 50 |
1794670 | 1794670 | 2021-10-08 | Appanoose | Iowa | 19007 | 1712 | 50 |
1791422 | 1791422 | 2021-10-07 | Appanoose | Iowa | 19007 | 1712 | 50 |
1788173 | 1788173 | 2021-10-06 | Appanoose | Iowa | 19007 | 1712 | 50 |
1786549 | 1786549 | 2021-10-05 | Calhoun | South Carolina | 45017 | 1712 | 51 |
1777911 | 1777911 | 2021-10-03 | Moffat | Colorado | 8081 | 1712 | 32 |
1774661 | 1774661 | 2021-10-02 | Moffat | Colorado | 8081 | 1712 | 32 |
1771411 | 1771411 | 2021-10-01 | Moffat | Colorado | 8081 | 1712 | 32 |
1770358 | 1770358 | 2021-09-30 | Dewey | South Dakota | 46041 | 1712 | 30 |
1760248 | 1760248 | 2021-09-27 | Morgan | Ohio | 39115 | 1712 | 29 |
1760382 | 1760382 | 2021-09-27 | Morrow | Oregon | 41049 | 1712 | 21 |
1740101 | 1740101 | 2021-09-21 | Montgomery | Mississippi | 28097 | 1712 | 54 |
1741007 | 1741007 | 2021-09-21 | Juana Diaz | Puerto Rico | 72075 | 1712 | |
1735468 | 1735468 | 2021-09-20 | Kusilvak Census Area | Alaska | 2158 | 1712 | 5 |
1733477 | 1733477 | 2021-09-19 | Chippewa | Minnesota | 27023 | 1712 | 39 |
1734514 | 1734514 | 2021-09-19 | Loiza | Puerto Rico | 72087 | 1712 | |
1730227 | 1730227 | 2021-09-18 | Chippewa | Minnesota | 27023 | 1712 | 39 |
1726828 | 1726828 | 2021-09-17 | Franklin | Maine | 23007 | 1712 | 17 |
1726977 | 1726977 | 2021-09-17 | Chippewa | Minnesota | 27023 | 1712 | 39 |
1722370 | 1722370 | 2021-09-15 | Converse | Wyoming | 56009 | 1712 | 28 |
1716748 | 1716748 | 2021-09-14 | Lyon | Iowa | 19119 | 1712 | 41 |
1712664 | 1712664 | 2021-09-13 | Conecuh | Alabama | 1035 | 1712 | 37 |
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);