ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
542 rows where cases = 773 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 78
- Kansas 37
- South Dakota 35
- Texas 30
- Tennessee 28
- Puerto Rico 27
- Georgia 18
- Iowa 17
- Missouri 17
- North Carolina 17
- Idaho 16
- Kentucky 16
- Mississippi 16
- Montana 15
- Oklahoma 15
- Virginia 14
- Indiana 13
- Minnesota 11
- Pennsylvania 9
- West Virginia 9
- Arkansas 8
- North Dakota 7
- Alabama 6
- Michigan 6
- Ohio 6
- Virgin Islands 6
- Wisconsin 6
- California 5
- Colorado 5
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468367 | 2468367 | 2022-05-03 | Lake of the Woods | Minnesota | 27077 | 773 | 6 |
2465112 | 2465112 | 2022-05-02 | Lake of the Woods | Minnesota | 27077 | 773 | 6 |
2436854 | 2436854 | 2022-04-23 | Vieques | Puerto Rico | 72147 | 773 | |
2426852 | 2426852 | 2022-04-20 | Ellis | Oklahoma | 40045 | 773 | 8 |
2423596 | 2423596 | 2022-04-19 | Ellis | Oklahoma | 40045 | 773 | 8 |
2420339 | 2420339 | 2022-04-18 | Ellis | Oklahoma | 40045 | 773 | 8 |
2417084 | 2417084 | 2022-04-17 | Ellis | Oklahoma | 40045 | 773 | 8 |
2413828 | 2413828 | 2022-04-16 | Ellis | Oklahoma | 40045 | 773 | 8 |
2410572 | 2410572 | 2022-04-15 | Ellis | Oklahoma | 40045 | 773 | 8 |
2407316 | 2407316 | 2022-04-14 | Ellis | Oklahoma | 40045 | 773 | 8 |
2374251 | 2374251 | 2022-04-04 | Sweet Grass | Montana | 30097 | 773 | 11 |
2370999 | 2370999 | 2022-04-03 | Sweet Grass | Montana | 30097 | 773 | 11 |
2367746 | 2367746 | 2022-04-02 | Sweet Grass | Montana | 30097 | 773 | 11 |
2364493 | 2364493 | 2022-04-01 | Sweet Grass | Montana | 30097 | 773 | 11 |
2361239 | 2361239 | 2022-03-31 | Sweet Grass | Montana | 30097 | 773 | 11 |
2357985 | 2357985 | 2022-03-30 | Sweet Grass | Montana | 30097 | 773 | 11 |
2354732 | 2354732 | 2022-03-29 | Sweet Grass | Montana | 30097 | 773 | 11 |
2351479 | 2351479 | 2022-03-28 | Sweet Grass | Montana | 30097 | 773 | 11 |
2348227 | 2348227 | 2022-03-27 | Sweet Grass | Montana | 30097 | 773 | 11 |
2344974 | 2344974 | 2022-03-26 | Sweet Grass | Montana | 30097 | 773 | 11 |
2341721 | 2341721 | 2022-03-25 | Sweet Grass | Montana | 30097 | 773 | 11 |
2316959 | 2316959 | 2022-03-17 | St. John | Virgin Islands | 78020 | 773 | 5 |
2313706 | 2313706 | 2022-03-16 | St. John | Virgin Islands | 78020 | 773 | 5 |
2310453 | 2310453 | 2022-03-15 | St. John | Virgin Islands | 78020 | 773 | 5 |
2257226 | 2257226 | 2022-02-27 | Nance | Nebraska | 31125 | 773 | 10 |
2253975 | 2253975 | 2022-02-26 | Nance | Nebraska | 31125 | 773 | 10 |
2250724 | 2250724 | 2022-02-25 | Nance | Nebraska | 31125 | 773 | 10 |
2218957 | 2218957 | 2022-02-15 | Clark | South Dakota | 46025 | 773 | 8 |
2210978 | 2210978 | 2022-02-13 | Woodson | Kansas | 20207 | 773 | 12 |
2207725 | 2207725 | 2022-02-12 | Woodson | Kansas | 20207 | 773 | 12 |
2204472 | 2204472 | 2022-02-11 | Woodson | Kansas | 20207 | 773 | 12 |
2201219 | 2201219 | 2022-02-10 | Woodson | Kansas | 20207 | 773 | 12 |
2197965 | 2197965 | 2022-02-09 | Woodson | Kansas | 20207 | 773 | 12 |
2176474 | 2176474 | 2022-02-02 | Cameron | Pennsylvania | 42023 | 773 | 18 |
2177053 | 2177053 | 2022-02-02 | Upton | Texas | 48461 | 773 | 17 |
2149071 | 2149071 | 2022-01-25 | Chautauqua | Kansas | 20019 | 773 | 16 |
2145819 | 2145819 | 2022-01-24 | Chautauqua | Kansas | 20019 | 773 | 16 |
2143434 | 2143434 | 2022-01-23 | Mineral | Nevada | 32021 | 773 | 14 |
2140179 | 2140179 | 2022-01-22 | Mineral | Nevada | 32021 | 773 | 14 |
2136923 | 2136923 | 2022-01-21 | Mineral | Nevada | 32021 | 773 | 14 |
2113932 | 2113932 | 2022-01-14 | Knox | Missouri | 29103 | 773 | 10 |
2110029 | 2110029 | 2022-01-13 | Barber | Kansas | 20007 | 773 | 7 |
2110519 | 2110519 | 2022-01-13 | Red Lake | Minnesota | 27125 | 773 | 11 |
2106778 | 2106778 | 2022-01-12 | Barber | Kansas | 20007 | 773 | 7 |
2087391 | 2087391 | 2022-01-06 | Carlisle | Kentucky | 21039 | 773 | 14 |
2084964 | 2084964 | 2022-01-05 | Union | New Mexico | 35059 | 773 | 12 |
2080427 | 2080427 | 2022-01-04 | Bear Lake | Idaho | 16007 | 773 | 15 |
2077175 | 2077175 | 2022-01-03 | Bear Lake | Idaho | 16007 | 773 | 15 |
2062388 | 2062388 | 2021-12-29 | LaMoure | North Dakota | 38045 | 773 | 18 |
2057672 | 2057672 | 2021-12-28 | Bear Lake | Idaho | 16007 | 773 | 15 |
2059139 | 2059139 | 2021-12-28 | LaMoure | North Dakota | 38045 | 773 | 18 |
2054451 | 2054451 | 2021-12-27 | Lincoln | Idaho | 16063 | 773 | 14 |
2056592 | 2056592 | 2021-12-27 | Hemphill | Texas | 48211 | 773 | 3 |
2051201 | 2051201 | 2021-12-26 | Lincoln | Idaho | 16063 | 773 | 14 |
2047951 | 2047951 | 2021-12-25 | Lincoln | Idaho | 16063 | 773 | 14 |
2044701 | 2044701 | 2021-12-24 | Lincoln | Idaho | 16063 | 773 | 14 |
2041452 | 2041452 | 2021-12-23 | Lincoln | Idaho | 16063 | 773 | 14 |
2042920 | 2042920 | 2021-12-23 | Wells | North Dakota | 38103 | 773 | 11 |
2032654 | 2032654 | 2021-12-20 | Holt | Missouri | 29087 | 773 | 23 |
2029403 | 2029403 | 2021-12-19 | Holt | Missouri | 29087 | 773 | 23 |
2008066 | 2008066 | 2021-12-12 | Cumberland | Virginia | 51049 | 773 | 19 |
2004815 | 2004815 | 2021-12-11 | Cumberland | Virginia | 51049 | 773 | 19 |
2001564 | 2001564 | 2021-12-10 | Cumberland | Virginia | 51049 | 773 | 19 |
1996310 | 1996310 | 2021-12-09 | Meade | Kansas | 20119 | 773 | 14 |
1993059 | 1993059 | 2021-12-08 | Meade | Kansas | 20119 | 773 | 14 |
1993108 | 1993108 | 2021-12-08 | Ballard | Kentucky | 21007 | 773 | 25 |
1967806 | 1967806 | 2021-11-30 | Furnas | Nebraska | 31065 | 773 | 5 |
1940635 | 1940635 | 2021-11-22 | Warren | Georgia | 13301 | 773 | 26 |
1927366 | 1927366 | 2021-11-18 | Huerfano | Colorado | 8055 | 773 | 21 |
1903490 | 1903490 | 2021-11-10 | Sabana Grande | Puerto Rico | 72121 | 773 | |
1900240 | 1900240 | 2021-11-09 | Sabana Grande | Puerto Rico | 72121 | 773 | |
1896990 | 1896990 | 2021-11-08 | Sabana Grande | Puerto Rico | 72121 | 773 | |
1893740 | 1893740 | 2021-11-07 | Sabana Grande | Puerto Rico | 72121 | 773 | |
1869189 | 1869189 | 2021-10-31 | Lewis | Idaho | 16061 | 773 | 21 |
1865940 | 1865940 | 2021-10-30 | Lewis | Idaho | 16061 | 773 | 21 |
1862691 | 1862691 | 2021-10-29 | Lewis | Idaho | 16061 | 773 | 21 |
1859814 | 1859814 | 2021-10-28 | Morris | Kansas | 20127 | 773 | 23 |
1856565 | 1856565 | 2021-10-27 | Morris | Kansas | 20127 | 773 | 23 |
1842014 | 1842014 | 2021-10-22 | Carson | Texas | 48065 | 773 | 24 |
1838765 | 1838765 | 2021-10-21 | Carson | Texas | 48065 | 773 | 24 |
1829683 | 1829683 | 2021-10-19 | Dillingham Census Area | Alaska | 2070 | 773 | 5 |
1830588 | 1830588 | 2021-10-19 | Rooks | Kansas | 20163 | 773 | 11 |
1827339 | 1827339 | 2021-10-18 | Rooks | Kansas | 20163 | 773 | 11 |
1808486 | 1808486 | 2021-10-12 | Broadwater | Montana | 30007 | 773 | 15 |
1806295 | 1806295 | 2021-10-11 | Crockett | Texas | 48105 | 773 | 16 |
1769906 | 1769906 | 2021-09-30 | McHenry | North Dakota | 38049 | 773 | 23 |
1761617 | 1761617 | 2021-09-28 | Trinity | California | 6105 | 773 | 9 |
1763858 | 1763858 | 2021-09-28 | Day | South Dakota | 46037 | 773 | 30 |
1750773 | 1750773 | 2021-09-24 | Penuelas | Puerto Rico | 72111 | 773 | |
1746070 | 1746070 | 2021-09-23 | Harper | Kansas | 20077 | 773 | 19 |
1747524 | 1747524 | 2021-09-23 | Penuelas | Puerto Rico | 72111 | 773 | |
1742821 | 1742821 | 2021-09-22 | Harper | Kansas | 20077 | 773 | 19 |
1744274 | 1744274 | 2021-09-22 | Penuelas | Puerto Rico | 72111 | 773 | |
1741025 | 1741025 | 2021-09-21 | Penuelas | Puerto Rico | 72111 | 773 | |
1737776 | 1737776 | 2021-09-20 | Penuelas | Puerto Rico | 72111 | 773 | |
1738493 | 1738493 | 2021-09-20 | Calhoun | West Virginia | 54013 | 773 | 2 |
1733831 | 1733831 | 2021-09-19 | Dawes | Nebraska | 31045 | 773 | 20 |
1734526 | 1734526 | 2021-09-19 | Penuelas | Puerto Rico | 72111 | 773 | |
1730581 | 1730581 | 2021-09-18 | Dawes | Nebraska | 31045 | 773 | 20 |
1727331 | 1727331 | 2021-09-17 | Dawes | Nebraska | 31045 | 773 | 20 |
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);