ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
518 rows where cases = 684 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 44
- South Dakota 29
- Georgia 24
- Illinois 24
- Nebraska 22
- North Carolina 22
- Mississippi 21
- Oklahoma 21
- Virginia 21
- Iowa 19
- Kentucky 19
- Puerto Rico 19
- Kansas 18
- Minnesota 16
- Alaska 14
- Missouri 14
- Idaho 12
- Montana 12
- North Dakota 12
- Ohio 12
- Tennessee 12
- Alabama 11
- Colorado 10
- Michigan 8
- South Carolina 7
- West Virginia 7
- Arkansas 6
- Indiana 6
- Utah 6
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502065 | 2502065 | 2022-05-13 | Douglas | South Dakota | 46043 | 684 | 16 |
2502097 | 2502097 | 2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 |
2498807 | 2498807 | 2022-05-12 | Douglas | South Dakota | 46043 | 684 | 16 |
2498839 | 2498839 | 2022-05-12 | Perkins | South Dakota | 46105 | 684 | 18 |
2495549 | 2495549 | 2022-05-11 | Douglas | South Dakota | 46043 | 684 | 16 |
2495581 | 2495581 | 2022-05-11 | Perkins | South Dakota | 46105 | 684 | 18 |
2492291 | 2492291 | 2022-05-10 | Douglas | South Dakota | 46043 | 684 | 16 |
2489033 | 2489033 | 2022-05-09 | Douglas | South Dakota | 46043 | 684 | 16 |
2485776 | 2485776 | 2022-05-08 | Douglas | South Dakota | 46043 | 684 | 16 |
2482518 | 2482518 | 2022-05-07 | Douglas | South Dakota | 46043 | 684 | 16 |
2479260 | 2479260 | 2022-05-06 | Douglas | South Dakota | 46043 | 684 | 16 |
2476002 | 2476002 | 2022-05-05 | Douglas | South Dakota | 46043 | 684 | 16 |
2472745 | 2472745 | 2022-05-04 | Douglas | South Dakota | 46043 | 684 | 16 |
2469489 | 2469489 | 2022-05-03 | Douglas | South Dakota | 46043 | 684 | 16 |
2466233 | 2466233 | 2022-05-02 | Douglas | South Dakota | 46043 | 684 | 16 |
2462978 | 2462978 | 2022-05-01 | Douglas | South Dakota | 46043 | 684 | 16 |
2459722 | 2459722 | 2022-04-30 | Douglas | South Dakota | 46043 | 684 | 16 |
2456466 | 2456466 | 2022-04-29 | Douglas | South Dakota | 46043 | 684 | 16 |
2453210 | 2453210 | 2022-04-28 | Douglas | South Dakota | 46043 | 684 | 16 |
2449954 | 2449954 | 2022-04-27 | Douglas | South Dakota | 46043 | 684 | 16 |
2296549 | 2296549 | 2022-03-11 | McIntosh | North Dakota | 38051 | 684 | 9 |
2256052 | 2256052 | 2022-02-27 | Adams | Idaho | 16003 | 684 | 14 |
2252801 | 2252801 | 2022-02-26 | Adams | Idaho | 16003 | 684 | 14 |
2249550 | 2249550 | 2022-02-25 | Adams | Idaho | 16003 | 684 | 14 |
2245159 | 2245159 | 2022-02-23 | Collingsworth | Texas | 48087 | 684 | 16 |
2146950 | 2146950 | 2022-01-24 | Nelson | North Dakota | 38063 | 684 | 17 |
2143696 | 2143696 | 2022-01-23 | Nelson | North Dakota | 38063 | 684 | 17 |
2125681 | 2125681 | 2022-01-18 | Phillips | Colorado | 8095 | 684 | 15 |
2127073 | 2127073 | 2022-01-18 | Chase | Nebraska | 31029 | 684 | 6 |
2118550 | 2118550 | 2022-01-15 | Grand Isle | Vermont | 50013 | 684 | 3 |
2110035 | 2110035 | 2022-01-13 | Chautauqua | Kansas | 20019 | 684 | 16 |
2105995 | 2105995 | 2022-01-12 | Calhoun | Arkansas | 5013 | 684 | 9 |
2106784 | 2106784 | 2022-01-12 | Chautauqua | Kansas | 20019 | 684 | 16 |
2087595 | 2087595 | 2022-01-06 | Unknown | Maryland | 684 | 219 | |
2081877 | 2081877 | 2022-01-04 | Bowman | North Dakota | 38011 | 684 | 9 |
2078625 | 2078625 | 2022-01-03 | Bowman | North Dakota | 38011 | 684 | 9 |
2075374 | 2075374 | 2022-01-02 | Bowman | North Dakota | 38011 | 684 | 9 |
2043893 | 2043893 | 2021-12-23 | Rappahannock | Virginia | 51157 | 684 | 7 |
2040303 | 2040303 | 2021-12-22 | Donley | Texas | 48129 | 684 | 18 |
2023712 | 2023712 | 2021-12-17 | Ceiba | Puerto Rico | 72037 | 684 | |
2008064 | 2008064 | 2021-12-12 | Craig | Virginia | 51045 | 684 | 10 |
2004813 | 2004813 | 2021-12-11 | Craig | Virginia | 51045 | 684 | 10 |
2001562 | 2001562 | 2021-12-10 | Craig | Virginia | 51045 | 684 | 10 |
1991847 | 1991847 | 2021-12-07 | King and Queen | Virginia | 51097 | 684 | 9 |
1986238 | 1986238 | 2021-12-06 | Hardin | Illinois | 17069 | 684 | 16 |
1970374 | 1970374 | 2021-12-01 | Carlisle | Kentucky | 21039 | 684 | 12 |
1964586 | 1964586 | 2021-11-29 | Nuckolls | Nebraska | 31129 | 684 | 12 |
1965518 | 1965518 | 2021-11-29 | Coke | Texas | 48081 | 684 | 18 |
1961141 | 1961141 | 2021-11-28 | Holt | Missouri | 29087 | 684 | 23 |
1957890 | 1957890 | 2021-11-27 | Holt | Missouri | 29087 | 684 | 23 |
1954639 | 1954639 | 2021-11-26 | Holt | Missouri | 29087 | 684 | 23 |
1951388 | 1951388 | 2021-11-25 | Holt | Missouri | 29087 | 684 | 23 |
1952180 | 1952180 | 2021-11-25 | Adjuntas | Puerto Rico | 72001 | 684 | |
1948137 | 1948137 | 2021-11-24 | Holt | Missouri | 29087 | 684 | 23 |
1948929 | 1948929 | 2021-11-24 | Adjuntas | Puerto Rico | 72001 | 684 | |
1921956 | 1921956 | 2021-11-16 | Kittson | Minnesota | 27069 | 684 | 22 |
1904859 | 1904859 | 2021-11-11 | Schley | Georgia | 13249 | 684 | 7 |
1901609 | 1901609 | 2021-11-10 | Schley | Georgia | 13249 | 684 | 7 |
1902502 | 1902502 | 2021-11-10 | Unknown | Minnesota | 684 | 124 | |
1899252 | 1899252 | 2021-11-09 | Unknown | Minnesota | 684 | 124 | |
1854718 | 1854718 | 2021-10-26 | Guayanilla | Puerto Rico | 72059 | 684 | |
1849200 | 1849200 | 2021-10-25 | Yukon-Koyukuk Census Area | Alaska | 2290 | 684 | 5 |
1851469 | 1851469 | 2021-10-25 | Guayanilla | Puerto Rico | 72059 | 684 | |
1848219 | 1848219 | 2021-10-24 | Guayanilla | Puerto Rico | 72059 | 684 | |
1844969 | 1844969 | 2021-10-23 | Guayanilla | Puerto Rico | 72059 | 684 | |
1841719 | 1841719 | 2021-10-22 | Guayanilla | Puerto Rico | 72059 | 684 | |
1838470 | 1838470 | 2021-10-21 | Guayanilla | Puerto Rico | 72059 | 684 | |
1835221 | 1835221 | 2021-10-20 | Guayanilla | Puerto Rico | 72059 | 684 | |
1828116 | 1828116 | 2021-10-18 | Thayer | Nebraska | 31169 | 684 | 7 |
1810725 | 1810725 | 2021-10-13 | Calhoun | Illinois | 17013 | 684 | 5 |
1809598 | 1809598 | 2021-10-12 | Hemphill | Texas | 48211 | 684 | 3 |
1806348 | 1806348 | 2021-10-11 | Hemphill | Texas | 48211 | 684 | 3 |
1803098 | 1803098 | 2021-10-10 | Hemphill | Texas | 48211 | 684 | 3 |
1799849 | 1799849 | 2021-10-09 | Hemphill | Texas | 48211 | 684 | 3 |
1793109 | 1793109 | 2021-10-07 | Gregory | South Dakota | 46053 | 684 | 30 |
1786301 | 1786301 | 2021-10-05 | Grant | Oklahoma | 40053 | 684 | 7 |
1787082 | 1787082 | 2021-10-05 | Cumberland | Virginia | 51049 | 684 | 13 |
1783052 | 1783052 | 2021-10-04 | Grant | Oklahoma | 40053 | 684 | 7 |
1783833 | 1783833 | 2021-10-04 | Cumberland | Virginia | 51049 | 684 | 13 |
1779803 | 1779803 | 2021-10-03 | Grant | Oklahoma | 40053 | 684 | 7 |
1776553 | 1776553 | 2021-10-02 | Grant | Oklahoma | 40053 | 684 | 7 |
1773303 | 1773303 | 2021-10-01 | Grant | Oklahoma | 40053 | 684 | 7 |
1768819 | 1768819 | 2021-09-30 | Kearny | Kansas | 20093 | 684 | 12 |
1768858 | 1768858 | 2021-09-30 | Scott | Kansas | 20171 | 684 | 27 |
1770053 | 1770053 | 2021-09-30 | Grant | Oklahoma | 40053 | 684 | 7 |
1765570 | 1765570 | 2021-09-29 | Kearny | Kansas | 20093 | 684 | 12 |
1765609 | 1765609 | 2021-09-29 | Scott | Kansas | 20171 | 684 | 27 |
1766804 | 1766804 | 2021-09-29 | Grant | Oklahoma | 40053 | 684 | 7 |
1761981 | 1761981 | 2021-09-28 | Alexander | Illinois | 17003 | 684 | 11 |
1751057 | 1751057 | 2021-09-24 | Concho | Texas | 48095 | 684 | 10 |
1736741 | 1736741 | 2021-09-20 | Grant | Minnesota | 27051 | 684 | 8 |
1738060 | 1738060 | 2021-09-20 | Concho | Texas | 48095 | 684 | 9 |
1734504 | 1734504 | 2021-09-19 | Hormigueros | Puerto Rico | 72067 | 684 | |
1734810 | 1734810 | 2021-09-19 | Concho | Texas | 48095 | 684 | 9 |
1731254 | 1731254 | 2021-09-18 | Hormigueros | Puerto Rico | 72067 | 684 | |
1728004 | 1728004 | 2021-09-17 | Hormigueros | Puerto Rico | 72067 | 684 | |
1710390 | 1710390 | 2021-09-12 | Stevens | Kansas | 20189 | 684 | 11 |
1707143 | 1707143 | 2021-09-11 | Stevens | Kansas | 20189 | 684 | 11 |
1703895 | 1703895 | 2021-09-10 | Stevens | Kansas | 20189 | 684 | 11 |
1679916 | 1679916 | 2021-09-02 | Middlesex | Virginia | 51119 | 684 | 23 |
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);