ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
328 rows where cases = 1456 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 21
- Missouri 18
- Kansas 16
- Texas 16
- Iowa 14
- Georgia 13
- Illinois 13
- Wisconsin 13
- Indiana 12
- Virginia 12
- Alabama 11
- North Carolina 11
- Puerto Rico 11
- Michigan 10
- Alaska 8
- Colorado 8
- Minnesota 8
- Montana 8
- Arkansas 7
- Mississippi 6
- New Mexico 6
- Washington 6
- Louisiana 5
- Nebraska 5
- New York 5
- Oklahoma 5
- Oregon 5
- Pennsylvania 5
- South Carolina 5
- Tennessee 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497079 | 2497079 | 2022-05-12 | Ohio | Indiana | 18115 | 1456 | 19 |
2493821 | 2493821 | 2022-05-11 | Ohio | Indiana | 18115 | 1456 | 19 |
2378205 | 2378205 | 2022-04-05 | Guanica | Puerto Rico | 72055 | 1456 | |
2374951 | 2374951 | 2022-04-04 | Guanica | Puerto Rico | 72055 | 1456 | |
2371699 | 2371699 | 2022-04-03 | Guanica | Puerto Rico | 72055 | 1456 | |
2279248 | 2279248 | 2022-03-06 | Stevens | Kansas | 20189 | 1456 | 18 |
2275995 | 2275995 | 2022-03-05 | Stevens | Kansas | 20189 | 1456 | 18 |
2272742 | 2272742 | 2022-03-04 | Stevens | Kansas | 20189 | 1456 | 18 |
2258584 | 2258584 | 2022-02-27 | Skamania | Washington | 53059 | 1456 | 11 |
2258674 | 2258674 | 2022-02-27 | Iron | Wisconsin | 55051 | 1456 | 46 |
2255333 | 2255333 | 2022-02-26 | Skamania | Washington | 53059 | 1456 | 11 |
2255423 | 2255423 | 2022-02-26 | Iron | Wisconsin | 55051 | 1456 | 46 |
2252082 | 2252082 | 2022-02-25 | Skamania | Washington | 53059 | 1456 | 11 |
2252172 | 2252172 | 2022-02-25 | Iron | Wisconsin | 55051 | 1456 | 46 |
2248921 | 2248921 | 2022-02-24 | Iron | Wisconsin | 55051 | 1456 | 45 |
2245282 | 2245282 | 2022-02-23 | Mills | Texas | 48333 | 1456 | 33 |
2215975 | 2215975 | 2022-02-14 | Jack | Texas | 48237 | 1456 | 26 |
2191146 | 2191146 | 2022-02-07 | Stark | Illinois | 17175 | 1456 | 32 |
2191972 | 2191972 | 2022-02-07 | Carter | Missouri | 29035 | 1456 | 19 |
2188164 | 2188164 | 2022-02-06 | Morris | Kansas | 20127 | 1456 | 25 |
2184911 | 2184911 | 2022-02-05 | Morris | Kansas | 20127 | 1456 | 25 |
2180858 | 2180858 | 2022-02-04 | Montgomery | Arkansas | 5097 | 1456 | 53 |
2181659 | 2181659 | 2022-02-04 | Morris | Kansas | 20127 | 1456 | 25 |
2166029 | 2166029 | 2022-01-30 | Shannon | Missouri | 29203 | 1456 | 32 |
2152892 | 2152892 | 2022-01-26 | Quitman | Mississippi | 28119 | 1456 | 28 |
2112276 | 2112276 | 2022-01-13 | Tucker | West Virginia | 54093 | 1456 | 32 |
2103470 | 2103470 | 2022-01-11 | Ida | Iowa | 19093 | 1456 | 43 |
2100219 | 2100219 | 2022-01-10 | Ida | Iowa | 19093 | 1456 | 43 |
2096155 | 2096155 | 2022-01-09 | Greene | Alabama | 1063 | 1456 | 47 |
2096213 | 2096213 | 2022-01-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 1456 | 14 |
2096968 | 2096968 | 2022-01-09 | Ida | Iowa | 19093 | 1456 | 43 |
2092961 | 2092961 | 2022-01-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 1456 | 14 |
2093716 | 2093716 | 2022-01-08 | Ida | Iowa | 19093 | 1456 | 43 |
2089709 | 2089709 | 2022-01-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 1456 | 14 |
2090464 | 2090464 | 2022-01-07 | Ida | Iowa | 19093 | 1456 | 43 |
2087213 | 2087213 | 2022-01-06 | Ida | Iowa | 19093 | 1456 | 43 |
2083961 | 2083961 | 2022-01-05 | Ida | Iowa | 19093 | 1456 | 43 |
2080148 | 2080148 | 2022-01-04 | Lincoln | Colorado | 8073 | 1456 | 9 |
2050713 | 2050713 | 2021-12-26 | Greenlee | Arizona | 4011 | 1456 | 27 |
2047463 | 2047463 | 2021-12-25 | Greenlee | Arizona | 4011 | 1456 | 27 |
2047522 | 2047522 | 2021-12-25 | Nevada | Arkansas | 5099 | 1456 | 42 |
2041171 | 2041171 | 2021-12-23 | Yuma | Colorado | 8125 | 1456 | 21 |
2037921 | 2037921 | 2021-12-22 | Yuma | Colorado | 8125 | 1456 | 21 |
2035728 | 2035728 | 2021-12-21 | Lake | Minnesota | 27075 | 1456 | 26 |
2030813 | 2030813 | 2021-12-19 | Charlotte | Virginia | 51037 | 1456 | 28 |
2027562 | 2027562 | 2021-12-18 | Charlotte | Virginia | 51037 | 1456 | 28 |
2024311 | 2024311 | 2021-12-17 | Charlotte | Virginia | 51037 | 1456 | 28 |
2016898 | 2016898 | 2021-12-15 | Pembina | North Dakota | 38067 | 1456 | 14 |
2009387 | 2009387 | 2021-12-13 | Cumberland | Kentucky | 21057 | 1456 | 22 |
2010712 | 2010712 | 2021-12-13 | Coamo | Puerto Rico | 72043 | 1456 | |
2006018 | 2006018 | 2021-12-12 | Coffey | Kansas | 20031 | 1456 | 30 |
2007461 | 2007461 | 2021-12-12 | Coamo | Puerto Rico | 72043 | 1456 | |
2002767 | 2002767 | 2021-12-11 | Coffey | Kansas | 20031 | 1456 | 30 |
2004675 | 2004675 | 2021-12-11 | Red River | Texas | 48387 | 1456 | 56 |
1999517 | 1999517 | 2021-12-10 | Coffey | Kansas | 20031 | 1456 | 30 |
2001755 | 2001755 | 2021-12-10 | Webster | West Virginia | 54101 | 1456 | 26 |
1992737 | 1992737 | 2021-12-08 | Hamilton | Illinois | 17065 | 1456 | 26 |
1993553 | 1993553 | 2021-12-08 | Kemper | Mississippi | 28069 | 1456 | 41 |
1993756 | 1993756 | 2021-12-08 | Powell | Montana | 30077 | 1456 | 23 |
1990302 | 1990302 | 2021-12-07 | Kemper | Mississippi | 28069 | 1456 | 41 |
1990505 | 1990505 | 2021-12-07 | Powell | Montana | 30077 | 1456 | 23 |
1987176 | 1987176 | 2021-12-06 | Oregon | Missouri | 29149 | 1456 | 25 |
1975749 | 1975749 | 2021-12-02 | Tyler | West Virginia | 54095 | 1456 | 25 |
1972363 | 1972363 | 2021-12-01 | Nelson | Virginia | 51125 | 1456 | 20 |
1967814 | 1967814 | 2021-11-30 | Hamilton | Nebraska | 31081 | 1456 | 19 |
1960695 | 1960695 | 2021-11-28 | Owen | Kentucky | 21187 | 1456 | 28 |
1957444 | 1957444 | 2021-11-27 | Owen | Kentucky | 21187 | 1456 | 28 |
1954193 | 1954193 | 2021-11-26 | Owen | Kentucky | 21187 | 1456 | 28 |
1950942 | 1950942 | 2021-11-25 | Owen | Kentucky | 21187 | 1456 | 28 |
1947691 | 1947691 | 2021-11-24 | Owen | Kentucky | 21187 | 1456 | 28 |
1944392 | 1944392 | 2021-11-23 | Hancock | Kentucky | 21091 | 1456 | 18 |
1945938 | 1945938 | 2021-11-23 | Moore | Tennessee | 47127 | 1456 | 24 |
1935138 | 1935138 | 2021-11-20 | Iron | Missouri | 29093 | 1456 | 26 |
1931888 | 1931888 | 2021-11-19 | Iron | Missouri | 29093 | 1456 | 26 |
1928164 | 1928164 | 2021-11-18 | Livingston | Kentucky | 21139 | 1456 | 45 |
1925229 | 1925229 | 2021-11-17 | Pipestone | Minnesota | 27117 | 1456 | 29 |
1920426 | 1920426 | 2021-11-15 | Lincoln | Washington | 53043 | 1456 | 23 |
1914561 | 1914561 | 2021-11-14 | Irwin | Georgia | 13155 | 1456 | 39 |
1911311 | 1911311 | 2021-11-13 | Irwin | Georgia | 13155 | 1456 | 39 |
1908062 | 1908062 | 2021-11-12 | Irwin | Georgia | 13155 | 1456 | 39 |
1904813 | 1904813 | 2021-11-11 | Irwin | Georgia | 13155 | 1456 | 39 |
1905595 | 1905595 | 2021-11-11 | Baraga | Michigan | 26013 | 1456 | 47 |
1901563 | 1901563 | 2021-11-10 | Irwin | Georgia | 13155 | 1456 | 39 |
1902346 | 1902346 | 2021-11-10 | Baraga | Michigan | 26013 | 1456 | 47 |
1889638 | 1889638 | 2021-11-06 | Howard | Missouri | 29089 | 1456 | 13 |
1884565 | 1884565 | 2021-11-04 | Floyd | Virginia | 51063 | 1456 | 29 |
1868893 | 1868893 | 2021-10-31 | Park | Colorado | 8093 | 1456 | 10 |
1865644 | 1865644 | 2021-10-30 | Park | Colorado | 8093 | 1456 | 10 |
1862395 | 1862395 | 2021-10-29 | Park | Colorado | 8093 | 1456 | 10 |
1846457 | 1846457 | 2021-10-24 | Valley | Idaho | 16085 | 1456 | 10 |
1833941 | 1833941 | 2021-10-20 | McLean | Kentucky | 21149 | 1456 | 38 |
1830969 | 1830969 | 2021-10-19 | Jackson | Minnesota | 27063 | 1456 | 14 |
1829198 | 1829198 | 2021-10-18 | Somervell | Texas | 48425 | 1456 | 21 |
1825949 | 1825949 | 2021-10-17 | Somervell | Texas | 48425 | 1456 | 21 |
1822700 | 1822700 | 2021-10-16 | Somervell | Texas | 48425 | 1456 | 21 |
1818143 | 1818143 | 2021-10-15 | DeKalb | Missouri | 29063 | 1456 | 33 |
1777703 | 1777703 | 2021-10-03 | Ketchikan Gateway Borough | Alaska | 2130 | 1456 | 7 |
1779531 | 1779531 | 2021-10-03 | Yates | New York | 36123 | 1456 | 26 |
1774453 | 1774453 | 2021-10-02 | Ketchikan Gateway Borough | Alaska | 2130 | 1456 | 7 |
1771203 | 1771203 | 2021-10-01 | Ketchikan Gateway Borough | Alaska | 2130 | 1456 | 7 |
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);