ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
353 rows where cases = 1429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 35
- Texas 30
- Tennessee 19
- Puerto Rico 18
- Iowa 16
- Minnesota 15
- Georgia 14
- Illinois 14
- Alabama 12
- Mississippi 12
- Montana 12
- Virginia 12
- Florida 11
- Colorado 9
- Missouri 9
- California 8
- Kansas 8
- Arkansas 7
- Louisiana 7
- Michigan 7
- North Carolina 7
- Wisconsin 7
- West Virginia 6
- Indiana 5
- New York 5
- Utah 5
- Vermont 5
- Nebraska 4
- North Dakota 4
- Oklahoma 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501829 | 2501829 | 2022-05-13 | Lake | Oregon | 41037 | 1429 | 29 |
2443339 | 2443339 | 2022-04-25 | Maunabo | Puerto Rico | 72095 | 1429 | |
2378850 | 2378850 | 2022-04-05 | Mathews | Virginia | 51115 | 1429 | 28 |
2375596 | 2375596 | 2022-04-04 | Mathews | Virginia | 51115 | 1429 | 28 |
2308835 | 2308835 | 2022-03-15 | Oscoda | Michigan | 26135 | 1429 | 54 |
2305584 | 2305584 | 2022-03-14 | Oscoda | Michigan | 26135 | 1429 | 54 |
2284663 | 2284663 | 2022-03-07 | Wirt | West Virginia | 54105 | 1429 | 23 |
2269457 | 2269457 | 2022-03-03 | Mitchell | Kansas | 20123 | 1429 | 19 |
2266204 | 2266204 | 2022-03-02 | Mitchell | Kansas | 20123 | 1429 | 19 |
2201903 | 2201903 | 2022-02-10 | Cedar | Nebraska | 31027 | 1429 | 11 |
2192119 | 2192119 | 2022-02-07 | Stillwater | Montana | 30095 | 1429 | 29 |
2149577 | 2149577 | 2022-01-25 | Wilkin | Minnesota | 27167 | 1429 | 19 |
2142266 | 2142266 | 2022-01-23 | Calhoun | Illinois | 17013 | 1429 | 7 |
2139011 | 2139011 | 2022-01-22 | Calhoun | Illinois | 17013 | 1429 | 7 |
2135755 | 2135755 | 2022-01-21 | Calhoun | Illinois | 17013 | 1429 | 7 |
2095262 | 2095262 | 2022-01-08 | Penuelas | Puerto Rico | 72111 | 1429 | |
2089651 | 2089651 | 2022-01-07 | Greene | Alabama | 1063 | 1429 | 46 |
2085991 | 2085991 | 2022-01-05 | Winkler | Texas | 48495 | 1429 | 32 |
2081110 | 2081110 | 2022-01-04 | Alcona | Michigan | 26001 | 1429 | 56 |
2077858 | 2077858 | 2022-01-03 | Alcona | Michigan | 26001 | 1429 | 56 |
2051625 | 2051625 | 2021-12-26 | Bracken | Kentucky | 21023 | 1429 | 20 |
2051641 | 2051641 | 2021-12-26 | Crittenden | Kentucky | 21055 | 1429 | 37 |
2052953 | 2052953 | 2021-12-26 | Barceloneta | Puerto Rico | 72017 | 1429 | |
2048375 | 2048375 | 2021-12-25 | Bracken | Kentucky | 21023 | 1429 | 20 |
2048391 | 2048391 | 2021-12-25 | Crittenden | Kentucky | 21055 | 1429 | 37 |
2049740 | 2049740 | 2021-12-25 | Luquillo | Puerto Rico | 72089 | 1429 | |
2045125 | 2045125 | 2021-12-24 | Bracken | Kentucky | 21023 | 1429 | 20 |
2045141 | 2045141 | 2021-12-24 | Crittenden | Kentucky | 21055 | 1429 | 37 |
2041876 | 2041876 | 2021-12-23 | Bracken | Kentucky | 21023 | 1429 | 20 |
2041892 | 2041892 | 2021-12-23 | Crittenden | Kentucky | 21055 | 1429 | 37 |
2038626 | 2038626 | 2021-12-22 | Bracken | Kentucky | 21023 | 1429 | 20 |
2038642 | 2038642 | 2021-12-22 | Crittenden | Kentucky | 21055 | 1429 | 37 |
2018210 | 2018210 | 2021-12-16 | Greenlee | Arizona | 4011 | 1429 | 23 |
2011768 | 2011768 | 2021-12-14 | Nevada | Arkansas | 5099 | 1429 | 41 |
2004516 | 2004516 | 2021-12-11 | Castro | Texas | 48069 | 1429 | 40 |
2004620 | 2004620 | 2021-12-11 | La Salle | Texas | 48283 | 1429 | 40 |
1997807 | 1997807 | 2021-12-09 | McCormick | South Carolina | 45065 | 1429 | 30 |
1994556 | 1994556 | 2021-12-08 | McCormick | South Carolina | 45065 | 1429 | 30 |
1990469 | 1990469 | 2021-12-07 | Blaine | Montana | 30005 | 1429 | 28 |
1975547 | 1975547 | 2021-12-02 | Buena Vista city | Virginia | 51530 | 1429 | 28 |
1966967 | 1966967 | 2021-11-30 | Monroe | Iowa | 19135 | 1429 | 39 |
1963715 | 1963715 | 2021-11-29 | Monroe | Iowa | 19135 | 1429 | 39 |
1960464 | 1960464 | 2021-11-28 | Monroe | Iowa | 19135 | 1429 | 39 |
1957213 | 1957213 | 2021-11-27 | Monroe | Iowa | 19135 | 1429 | 39 |
1953962 | 1953962 | 2021-11-26 | Monroe | Iowa | 19135 | 1429 | 39 |
1950711 | 1950711 | 2021-11-25 | Monroe | Iowa | 19135 | 1429 | 39 |
1947460 | 1947460 | 2021-11-24 | Monroe | Iowa | 19135 | 1429 | 39 |
1945056 | 1945056 | 2021-11-23 | Hamilton | Nebraska | 31081 | 1429 | 19 |
1940877 | 1940877 | 2021-11-22 | Switzerland | Indiana | 18155 | 1429 | 12 |
1938497 | 1938497 | 2021-11-21 | Powell | Montana | 30077 | 1429 | 21 |
1935247 | 1935247 | 2021-11-20 | Powell | Montana | 30077 | 1429 | 21 |
1931997 | 1931997 | 2021-11-19 | Powell | Montana | 30077 | 1429 | 21 |
1922947 | 1922947 | 2021-11-16 | Coamo | Puerto Rico | 72043 | 1429 | |
1923703 | 1923703 | 2021-11-16 | Gilmer | West Virginia | 54021 | 1429 | 14 |
1919698 | 1919698 | 2021-11-15 | Coamo | Puerto Rico | 72043 | 1429 | |
1909932 | 1909932 | 2021-11-12 | Anasco | Puerto Rico | 72011 | 1429 | |
1905795 | 1905795 | 2021-11-11 | Kemper | Mississippi | 28069 | 1429 | 41 |
1906683 | 1906683 | 2021-11-11 | Anasco | Puerto Rico | 72011 | 1429 | |
1902546 | 1902546 | 2021-11-10 | Kemper | Mississippi | 28069 | 1429 | 41 |
1903434 | 1903434 | 2021-11-10 | Anasco | Puerto Rico | 72011 | 1429 | |
1899585 | 1899585 | 2021-11-09 | Phelps | Nebraska | 31137 | 1429 | 10 |
1900928 | 1900928 | 2021-11-09 | Lincoln | Washington | 53043 | 1429 | 22 |
1858977 | 1858977 | 2021-10-28 | Cleveland | Arkansas | 5025 | 1429 | 32 |
1858573 | 1858573 | 2021-10-27 | Floyd | Virginia | 51063 | 1429 | 29 |
1851699 | 1851699 | 2021-10-25 | Moore | Tennessee | 47127 | 1429 | 22 |
1848449 | 1848449 | 2021-10-24 | Moore | Tennessee | 47127 | 1429 | 22 |
1845199 | 1845199 | 2021-10-23 | Moore | Tennessee | 47127 | 1429 | 22 |
1841949 | 1841949 | 2021-10-22 | Moore | Tennessee | 47127 | 1429 | 22 |
1836451 | 1836451 | 2021-10-21 | Glades | Florida | 12043 | 1429 | 25 |
1838700 | 1838700 | 2021-10-21 | Moore | Tennessee | 47127 | 1429 | 22 |
1833202 | 1833202 | 2021-10-20 | Glades | Florida | 12043 | 1429 | 25 |
1829953 | 1829953 | 2021-10-19 | Glades | Florida | 12043 | 1429 | 25 |
1826704 | 1826704 | 2021-10-18 | Glades | Florida | 12043 | 1429 | 25 |
1823360 | 1823360 | 2021-10-17 | Archuleta | Colorado | 8007 | 1429 | 4 |
1823455 | 1823455 | 2021-10-17 | Glades | Florida | 12043 | 1429 | 24 |
1820111 | 1820111 | 2021-10-16 | Archuleta | Colorado | 8007 | 1429 | 4 |
1820206 | 1820206 | 2021-10-16 | Glades | Florida | 12043 | 1429 | 24 |
1816862 | 1816862 | 2021-10-15 | Archuleta | Colorado | 8007 | 1429 | 4 |
1816957 | 1816957 | 2021-10-15 | Glades | Florida | 12043 | 1429 | 24 |
1808227 | 1808227 | 2021-10-12 | Jackson | Minnesota | 27063 | 1429 | 14 |
1809711 | 1809711 | 2021-10-12 | Swisher | Texas | 48437 | 1429 | 22 |
1806461 | 1806461 | 2021-10-11 | Swisher | Texas | 48437 | 1429 | 22 |
1806704 | 1806704 | 2021-10-11 | Pend Oreille | Washington | 53051 | 1429 | 19 |
1800452 | 1800452 | 2021-10-10 | Northwest Arctic Borough | Alaska | 2188 | 1429 | 5 |
1803211 | 1803211 | 2021-10-10 | Swisher | Texas | 48437 | 1429 | 22 |
1797203 | 1797203 | 2021-10-09 | Northwest Arctic Borough | Alaska | 2188 | 1429 | 5 |
1799962 | 1799962 | 2021-10-09 | Swisher | Texas | 48437 | 1429 | 22 |
1793954 | 1793954 | 2021-10-08 | Northwest Arctic Borough | Alaska | 2188 | 1429 | 5 |
1796713 | 1796713 | 2021-10-08 | Swisher | Texas | 48437 | 1429 | 22 |
1788901 | 1788901 | 2021-10-06 | DeKalb | Missouri | 29063 | 1429 | 33 |
1776786 | 1776786 | 2021-10-02 | Yauco | Puerto Rico | 72153 | 1429 | |
1773520 | 1773520 | 2021-10-01 | Salinas | Puerto Rico | 72123 | 1429 | |
1770270 | 1770270 | 2021-09-30 | Salinas | Puerto Rico | 72123 | 1429 | |
1766661 | 1766661 | 2021-09-29 | Mercer | North Dakota | 38057 | 1429 | 11 |
1767021 | 1767021 | 2021-09-29 | Salinas | Puerto Rico | 72123 | 1429 | |
1763006 | 1763006 | 2021-09-28 | Fergus | Montana | 30027 | 1429 | 36 |
1763283 | 1763283 | 2021-09-28 | Yates | New York | 36123 | 1429 | 26 |
1759765 | 1759765 | 2021-09-27 | Jefferson | Montana | 30043 | 1429 | 9 |
1755914 | 1755914 | 2021-09-26 | Edmonson | Kentucky | 21061 | 1429 | 26 |
1756275 | 1756275 | 2021-09-26 | Rock | Minnesota | 27133 | 1429 | 19 |
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);