ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
578 rows where cases = 574 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 64
- Virginia 38
- Kansas 33
- Puerto Rico 33
- Georgia 30
- Nebraska 26
- North Carolina 26
- Illinois 23
- Oklahoma 23
- Minnesota 22
- South Dakota 19
- Arizona 17
- North Dakota 17
- Iowa 16
- Missouri 14
- Mississippi 13
- Kentucky 12
- Indiana 11
- Ohio 9
- Pennsylvania 9
- New York 8
- Rhode Island 8
- Alabama 7
- Arkansas 7
- Tennessee 7
- Michigan 6
- Montana 6
- New Mexico 6
- Washington 6
- West Virginia 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468344 | 2468344 | 2022-05-03 | Cook | Minnesota | 27031 | 574 | 4 |
2358489 | 2358489 | 2022-03-30 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2355235 | 2355235 | 2022-03-29 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2351982 | 2351982 | 2022-03-28 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2348730 | 2348730 | 2022-03-27 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2345477 | 2345477 | 2022-03-26 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2342224 | 2342224 | 2022-03-25 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2338971 | 2338971 | 2022-03-24 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2221738 | 2221738 | 2022-02-16 | Adams | North Dakota | 38001 | 574 | 9 |
2173644 | 2173644 | 2022-02-01 | Fisher | Texas | 48151 | 574 | 20 |
2130674 | 2130674 | 2022-01-19 | McIntosh | North Dakota | 38051 | 574 | 9 |
2131114 | 2131114 | 2022-01-19 | Buffalo | South Dakota | 46017 | 574 | 17 |
2127910 | 2127910 | 2022-01-18 | Stanley | South Dakota | 46117 | 574 | 5 |
2128162 | 2128162 | 2022-01-18 | Lipscomb | Texas | 48295 | 574 | 13 |
2109218 | 2109218 | 2022-01-13 | Unknown | Alaska | 574 | 0 | |
2105967 | 2105967 | 2022-01-12 | Unknown | Alaska | 574 | 0 | |
2108371 | 2108371 | 2022-01-12 | Hanson | South Dakota | 46061 | 574 | 5 |
2103186 | 2103186 | 2022-01-11 | Adams | Idaho | 16003 | 574 | 14 |
2078368 | 2078368 | 2022-01-03 | Stanton | Nebraska | 31167 | 574 | 11 |
2016618 | 2016618 | 2021-12-15 | Valley | Nebraska | 31175 | 574 | 5 |
2012581 | 2012581 | 2021-12-14 | Rawlins | Kansas | 20153 | 574 | 8 |
2009330 | 2009330 | 2021-12-13 | Rawlins | Kansas | 20153 | 574 | 8 |
1997736 | 1997736 | 2021-12-09 | Maunabo | Puerto Rico | 72095 | 574 | |
1994485 | 1994485 | 2021-12-08 | Maunabo | Puerto Rico | 72095 | 574 | |
1983280 | 1983280 | 2021-12-05 | Gove | Kansas | 20063 | 574 | 22 |
1983338 | 1983338 | 2021-12-05 | Sheridan | Kansas | 20179 | 574 | 16 |
1980030 | 1980030 | 2021-12-04 | Gove | Kansas | 20063 | 574 | 22 |
1980088 | 1980088 | 2021-12-04 | Sheridan | Kansas | 20179 | 574 | 16 |
1980915 | 1980915 | 2021-12-04 | Unknown | New Jersey | 574 | 0 | |
1976780 | 1976780 | 2021-12-03 | Gove | Kansas | 20063 | 574 | 22 |
1976838 | 1976838 | 2021-12-03 | Sheridan | Kansas | 20179 | 574 | 16 |
1960277 | 1960277 | 2021-11-28 | Pope | Illinois | 17151 | 574 | 6 |
1961594 | 1961594 | 2021-11-28 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1957026 | 1957026 | 2021-11-27 | Pope | Illinois | 17151 | 574 | 6 |
1958343 | 1958343 | 2021-11-27 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1953775 | 1953775 | 2021-11-26 | Pope | Illinois | 17151 | 574 | 6 |
1955092 | 1955092 | 2021-11-26 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1950524 | 1950524 | 2021-11-25 | Pope | Illinois | 17151 | 574 | 6 |
1951841 | 1951841 | 2021-11-25 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1947273 | 1947273 | 2021-11-24 | Pope | Illinois | 17151 | 574 | 6 |
1948590 | 1948590 | 2021-11-24 | Tyrrell | North Carolina | 37177 | 574 | 7 |
1944022 | 1944022 | 2021-11-23 | Pope | Illinois | 17151 | 574 | 6 |
1945068 | 1945068 | 2021-11-23 | Kimball | Nebraska | 31105 | 574 | 9 |
1938577 | 1938577 | 2021-11-21 | Nance | Nebraska | 31125 | 574 | 10 |
1935327 | 1935327 | 2021-11-20 | Nance | Nebraska | 31125 | 574 | 10 |
1932077 | 1932077 | 2021-11-19 | Nance | Nebraska | 31125 | 574 | 10 |
1921648 | 1921648 | 2021-11-16 | Hickman | Kentucky | 21105 | 574 | 20 |
1906191 | 1906191 | 2021-11-11 | Union | New Mexico | 35059 | 574 | 12 |
1902942 | 1902942 | 2021-11-10 | Union | New Mexico | 35059 | 574 | 12 |
1903733 | 1903733 | 2021-11-10 | Baylor | Texas | 48023 | 574 | 24 |
1900001 | 1900001 | 2021-11-09 | Beaver | Oklahoma | 40007 | 574 | 9 |
1900483 | 1900483 | 2021-11-09 | Baylor | Texas | 48023 | 574 | 24 |
1896751 | 1896751 | 2021-11-08 | Beaver | Oklahoma | 40007 | 574 | 9 |
1893501 | 1893501 | 2021-11-07 | Beaver | Oklahoma | 40007 | 574 | 9 |
1890251 | 1890251 | 2021-11-06 | Beaver | Oklahoma | 40007 | 574 | 9 |
1887001 | 1887001 | 2021-11-05 | Beaver | Oklahoma | 40007 | 574 | 9 |
1883751 | 1883751 | 2021-11-04 | Beaver | Oklahoma | 40007 | 574 | 9 |
1880502 | 1880502 | 2021-11-03 | Beaver | Oklahoma | 40007 | 574 | 9 |
1848887 | 1848887 | 2021-10-24 | Rappahannock | Virginia | 51157 | 574 | 4 |
1845637 | 1845637 | 2021-10-23 | Rappahannock | Virginia | 51157 | 574 | 4 |
1842387 | 1842387 | 2021-10-22 | Rappahannock | Virginia | 51157 | 574 | 4 |
1835548 | 1835548 | 2021-10-20 | Donley | Texas | 48129 | 574 | 18 |
1831931 | 1831931 | 2021-10-19 | Sullivan | Pennsylvania | 42113 | 574 | 24 |
1812601 | 1812601 | 2021-10-13 | Edmunds | South Dakota | 46045 | 574 | 14 |
1799935 | 1799935 | 2021-10-09 | Reagan | Texas | 48383 | 574 | 10 |
1786170 | 1786170 | 2021-10-05 | Sargent | North Dakota | 38081 | 574 | 7 |
1784047 | 1784047 | 2021-10-04 | Florence | Wisconsin | 55037 | 574 | 13 |
1767970 | 1767970 | 2021-09-30 | Yukon-Koyukuk Census Area | Alaska | 2290 | 574 | 5 |
1764927 | 1764927 | 2021-09-29 | Saguache | Colorado | 8109 | 574 | 8 |
1761495 | 1761495 | 2021-09-28 | Calhoun | Arkansas | 5013 | 574 | 7 |
1744955 | 1744955 | 2021-09-22 | Ferry | Washington | 53019 | 574 | 10 |
1737010 | 1737010 | 2021-09-20 | Chouteau | Montana | 30015 | 574 | 7 |
1731627 | 1731627 | 2021-09-18 | Hudspeth | Texas | 48229 | 574 | 13 |
1718981 | 1718981 | 2021-09-14 | Skamania | Washington | 53059 | 574 | 3 |
1701682 | 1701682 | 2021-09-09 | LaMoure | North Dakota | 38045 | 574 | 17 |
1698056 | 1698056 | 2021-09-08 | Pondera | Montana | 30073 | 574 | 3 |
1693140 | 1693140 | 2021-09-06 | Crook | Wyoming | 56011 | 574 | 13 |
1689891 | 1689891 | 2021-09-05 | Crook | Wyoming | 56011 | 574 | 13 |
1686641 | 1686641 | 2021-09-04 | Crook | Wyoming | 56011 | 574 | 13 |
1683391 | 1683391 | 2021-09-03 | Crook | Wyoming | 56011 | 574 | 13 |
1678559 | 1678559 | 2021-09-02 | Phillips | Montana | 30071 | 574 | 16 |
1666867 | 1666867 | 2021-08-29 | Charles City | Virginia | 51036 | 574 | 16 |
1663619 | 1663619 | 2021-08-28 | Charles City | Virginia | 51036 | 574 | 16 |
1660265 | 1660265 | 2021-08-27 | Sutton | Texas | 48435 | 574 | 8 |
1660371 | 1660371 | 2021-08-27 | Charles City | Virginia | 51036 | 574 | 16 |
1652591 | 1652591 | 2021-08-25 | Teton | Montana | 30099 | 574 | 6 |
1652967 | 1652967 | 2021-08-25 | Pierce | North Dakota | 38069 | 574 | 26 |
1629554 | 1629554 | 2021-08-18 | Mahnomen | Minnesota | 27087 | 574 | 9 |
1625459 | 1625459 | 2021-08-17 | Talbot | Georgia | 13263 | 574 | 20 |
1625828 | 1625828 | 2021-08-17 | Wayne | Iowa | 19185 | 574 | 23 |
1622581 | 1622581 | 2021-08-16 | Wayne | Iowa | 19185 | 574 | 23 |
1619334 | 1619334 | 2021-08-15 | Wayne | Iowa | 19185 | 574 | 23 |
1616086 | 1616086 | 2021-08-14 | Wayne | Iowa | 19185 | 574 | 23 |
1617528 | 1617528 | 2021-08-14 | Adjuntas | Puerto Rico | 72001 | 574 | |
1612837 | 1612837 | 2021-08-13 | Wayne | Iowa | 19185 | 574 | 23 |
1609589 | 1609589 | 2021-08-12 | Wayne | Iowa | 19185 | 574 | 23 |
1606340 | 1606340 | 2021-08-11 | Wayne | Iowa | 19185 | 574 | 23 |
1603198 | 1603198 | 2021-08-10 | Washington | Kansas | 20201 | 574 | 14 |
1599393 | 1599393 | 2021-08-09 | Echols | Georgia | 13101 | 574 | 9 |
1599949 | 1599949 | 2021-08-09 | Washington | Kansas | 20201 | 574 | 14 |
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);