ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3709 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- Tennessee 13
- Georgia 11
- Ohio 9
- Alabama 8
- Arkansas 8
- North Carolina 7
- Oklahoma 7
- Kentucky 6
- Pennsylvania 6
- Louisiana 5
- Virginia 5
- Illinois 4
- Kansas 4
- West Virginia 4
- Indiana 3
- Missouri 3
- Colorado 2
- Iowa 2
- Maryland 2
- Michigan 2
- Minnesota 2
- New York 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Washington 2
- California 1
- Florida 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456860 | 2456860 | 2022-04-29 | Zapata | Texas | 48505 | 3709 | 55 |
2365611 | 2365611 | 2022-04-01 | Madison | Texas | 48313 | 3709 | 54 |
2362358 | 2362358 | 2022-03-31 | Madison | Texas | 48313 | 3709 | 54 |
2359104 | 2359104 | 2022-03-30 | Madison | Texas | 48313 | 3709 | 54 |
2323828 | 2323828 | 2022-03-20 | Lamar | Alabama | 1075 | 3709 | 63 |
2320574 | 2320574 | 2022-03-19 | Lamar | Alabama | 1075 | 3709 | 63 |
2317320 | 2317320 | 2022-03-18 | Lamar | Alabama | 1075 | 3709 | 63 |
2279320 | 2279320 | 2022-03-06 | Larue | Kentucky | 21123 | 3709 | 68 |
2276067 | 2276067 | 2022-03-05 | Larue | Kentucky | 21123 | 3709 | 68 |
2272814 | 2272814 | 2022-03-04 | Larue | Kentucky | 21123 | 3709 | 68 |
2260093 | 2260093 | 2022-02-28 | Faribault | Minnesota | 27043 | 3709 | 50 |
2258192 | 2258192 | 2022-02-27 | Falls | Texas | 48145 | 3709 | 61 |
2254941 | 2254941 | 2022-02-26 | Falls | Texas | 48145 | 3709 | 61 |
2170318 | 2170318 | 2022-01-31 | Andrews | Texas | 48003 | 3709 | 69 |
2154565 | 2154565 | 2022-01-26 | Taylor | West Virginia | 54091 | 3709 | 56 |
2137560 | 2137560 | 2022-01-21 | Yauco | Puerto Rico | 72153 | 3709 | |
2092925 | 2092925 | 2022-01-08 | Pickens | Alabama | 1107 | 3709 | 92 |
2091746 | 2091746 | 2022-01-07 | Paulding | Ohio | 39125 | 3709 | 62 |
2087685 | 2087685 | 2022-01-06 | Roscommon | Michigan | 26143 | 3709 | 106 |
2084433 | 2084433 | 2022-01-05 | Roscommon | Michigan | 26143 | 3709 | 106 |
2060522 | 2060522 | 2021-12-29 | Ouachita | Arkansas | 5103 | 3709 | 89 |
2059441 | 2059441 | 2021-12-28 | Wyoming | Pennsylvania | 42131 | 3709 | 84 |
1995976 | 1995976 | 2021-12-09 | Douglas | Illinois | 17041 | 3709 | 44 |
1997605 | 1997605 | 2021-12-09 | Lincoln | Oregon | 41041 | 3709 | 56 |
1989307 | 1989307 | 2021-12-07 | Grady | Georgia | 13131 | 3709 | 92 |
1941099 | 1941099 | 2021-11-22 | Anderson | Kentucky | 21005 | 3709 | 52 |
1930495 | 1930495 | 2021-11-19 | Logan | Arkansas | 5083 | 3709 | 50 |
1926758 | 1926758 | 2021-11-17 | Franklin | Vermont | 50011 | 3709 | 52 |
1897721 | 1897721 | 2021-11-08 | Mason | West Virginia | 54053 | 3709 | 57 |
1887948 | 1887948 | 2021-11-05 | Boone | West Virginia | 54005 | 3709 | 59 |
1876958 | 1876958 | 2021-11-02 | Delaware | New York | 36025 | 3709 | 48 |
1829151 | 1829151 | 2021-10-18 | Milam | Texas | 48331 | 3709 | 79 |
1825902 | 1825902 | 2021-10-17 | Milam | Texas | 48331 | 3709 | 79 |
1822653 | 1822653 | 2021-10-16 | Milam | Texas | 48331 | 3709 | 79 |
1807769 | 1807769 | 2021-10-12 | Barton | Kansas | 20009 | 3709 | 56 |
1809984 | 1809984 | 2021-10-12 | Jackson | West Virginia | 54035 | 3709 | 76 |
1804024 | 1804024 | 2021-10-11 | Burke | Georgia | 13033 | 3709 | 77 |
1804518 | 1804518 | 2021-10-11 | Barton | Kansas | 20009 | 3709 | 56 |
1800775 | 1800775 | 2021-10-10 | Burke | Georgia | 13033 | 3709 | 77 |
1797526 | 1797526 | 2021-10-09 | Burke | Georgia | 13033 | 3709 | 77 |
1798340 | 1798340 | 2021-10-09 | Queen Anne's | Maryland | 24035 | 3709 | 66 |
1794277 | 1794277 | 2021-10-08 | Burke | Georgia | 13033 | 3709 | 77 |
1786307 | 1786307 | 2021-10-05 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1786412 | 1786412 | 2021-10-05 | Elk | Pennsylvania | 42047 | 3709 | 49 |
1783058 | 1783058 | 2021-10-04 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1779809 | 1779809 | 2021-10-03 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1776559 | 1776559 | 2021-10-02 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1773309 | 1773309 | 2021-10-01 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1770059 | 1770059 | 2021-09-30 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1766810 | 1766810 | 2021-09-29 | Jackson | Oklahoma | 40065 | 3709 | 63 |
1767315 | 1767315 | 2021-09-29 | Dimmit | Texas | 48127 | 3709 | 42 |
1759273 | 1759273 | 2021-09-27 | Grant | Louisiana | 22043 | 3709 | 76 |
1742956 | 1742956 | 2021-09-22 | Lincoln | Kentucky | 21137 | 3709 | 72 |
1733298 | 1733298 | 2021-09-19 | Pointe Coupee | Louisiana | 22077 | 3709 | 81 |
1730048 | 1730048 | 2021-09-18 | Pointe Coupee | Louisiana | 22077 | 3709 | 81 |
1726798 | 1726798 | 2021-09-17 | Pointe Coupee | Louisiana | 22077 | 3709 | 81 |
1724516 | 1724516 | 2021-09-16 | Pike | Ohio | 39131 | 3709 | 40 |
1692898 | 1692898 | 2021-09-06 | Isle of Wight | Virginia | 51093 | 3709 | 74 |
1675565 | 1675565 | 2021-09-01 | Wyoming | New York | 36121 | 3709 | 54 |
1669927 | 1669927 | 2021-08-30 | Kleberg | Texas | 48273 | 3709 | 102 |
1663959 | 1663959 | 2021-08-29 | Lawrence | Alabama | 1079 | 3709 | 100 |
1666680 | 1666680 | 2021-08-29 | Kleberg | Texas | 48273 | 3709 | 102 |
1650738 | 1650738 | 2021-08-24 | Wise | Virginia | 51195 | 3709 | 108 |
1616697 | 1616697 | 2021-08-14 | Barry | Missouri | 29009 | 3709 | 51 |
1606819 | 1606819 | 2021-08-11 | Lyon | Minnesota | 27083 | 3709 | 54 |
1588521 | 1588521 | 2021-08-05 | Hardeman | Tennessee | 47069 | 3709 | 64 |
1584959 | 1584959 | 2021-08-04 | Malheur | Oregon | 41045 | 3709 | 67 |
1559457 | 1559457 | 2021-07-27 | Hopkins | Texas | 48223 | 3709 | 114 |
1520156 | 1520156 | 2021-07-15 | Trujillo Alto | Puerto Rico | 72139 | 3709 | |
1520917 | 1520917 | 2021-07-15 | Clark | Wisconsin | 55019 | 3709 | 65 |
1499502 | 1499502 | 2021-07-09 | Worcester | Maryland | 24047 | 3709 | 106 |
1461857 | 1461857 | 2021-06-27 | Carroll | Tennessee | 47017 | 3709 | 83 |
1458612 | 1458612 | 2021-06-26 | Carroll | Tennessee | 47017 | 3709 | 83 |
1455367 | 1455367 | 2021-06-25 | Carroll | Tennessee | 47017 | 3709 | 83 |
1452122 | 1452122 | 2021-06-24 | Carroll | Tennessee | 47017 | 3709 | 83 |
1435639 | 1435639 | 2021-06-19 | Clinton | Pennsylvania | 42035 | 3709 | 66 |
1432392 | 1432392 | 2021-06-18 | Clinton | Pennsylvania | 42035 | 3709 | 66 |
1429146 | 1429146 | 2021-06-17 | Clinton | Pennsylvania | 42035 | 3709 | 66 |
1426156 | 1426156 | 2021-06-16 | Carroll | Tennessee | 47017 | 3709 | 83 |
1422909 | 1422909 | 2021-06-15 | Carroll | Tennessee | 47017 | 3709 | 83 |
1410827 | 1410827 | 2021-06-12 | Amador | California | 6005 | 3709 | 47 |
1406767 | 1406767 | 2021-06-10 | White | Tennessee | 47185 | 3709 | 74 |
1400911 | 1400911 | 2021-06-09 | Chambers | Alabama | 1017 | 3709 | 124 |
1401493 | 1401493 | 2021-06-09 | Nez Perce | Idaho | 16069 | 3709 | 55 |
1403521 | 1403521 | 2021-06-09 | White | Tennessee | 47185 | 3709 | 74 |
1397666 | 1397666 | 2021-06-08 | Chambers | Alabama | 1017 | 3709 | 124 |
1400276 | 1400276 | 2021-06-08 | White | Tennessee | 47185 | 3709 | 74 |
1394815 | 1394815 | 2021-06-07 | Bryan | Georgia | 13029 | 3709 | 41 |
1391570 | 1391570 | 2021-06-06 | Bryan | Georgia | 13029 | 3709 | 41 |
1393784 | 1393784 | 2021-06-06 | White | Tennessee | 47185 | 3709 | 74 |
1394230 | 1394230 | 2021-06-06 | Douglas | Washington | 53017 | 3709 | 25 |
1388325 | 1388325 | 2021-06-05 | Bryan | Georgia | 13029 | 3709 | 41 |
1390539 | 1390539 | 2021-06-05 | White | Tennessee | 47185 | 3709 | 74 |
1390966 | 1390966 | 2021-06-05 | Tazewell | Virginia | 51185 | 3709 | 74 |
1390985 | 1390985 | 2021-06-05 | Douglas | Washington | 53017 | 3709 | 25 |
1385080 | 1385080 | 2021-06-04 | Bryan | Georgia | 13029 | 3709 | 41 |
1387294 | 1387294 | 2021-06-04 | White | Tennessee | 47185 | 3709 | 74 |
1354338 | 1354338 | 2021-05-25 | Ottawa | Ohio | 39123 | 3709 | 81 |
1351092 | 1351092 | 2021-05-24 | Ottawa | Ohio | 39123 | 3709 | 81 |
1347846 | 1347846 | 2021-05-23 | Ottawa | Ohio | 39123 | 3709 | 81 |
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);