ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
436 rows where cases = 795 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 46
- Georgia 38
- Iowa 32
- Kansas 24
- Virginia 23
- Nebraska 19
- Mississippi 16
- Missouri 15
- Kentucky 14
- Minnesota 14
- Indiana 13
- Puerto Rico 13
- Arkansas 12
- North Carolina 12
- North Dakota 12
- Illinois 11
- Oklahoma 10
- South Dakota 10
- West Virginia 9
- Utah 8
- Alabama 7
- Idaho 6
- New York 6
- Tennessee 6
- Wyoming 6
- Colorado 5
- New Mexico 5
- Pennsylvania 5
- Florida 4
- Michigan 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2306006 | 2306006 | 2022-03-14 | Nance | Nebraska | 31125 | 795 | 10 |
2302755 | 2302755 | 2022-03-13 | Nance | Nebraska | 31125 | 795 | 10 |
2299503 | 2299503 | 2022-03-12 | Nance | Nebraska | 31125 | 795 | 10 |
2296251 | 2296251 | 2022-03-11 | Nance | Nebraska | 31125 | 795 | 10 |
2286495 | 2286495 | 2022-03-08 | Nance | Nebraska | 31125 | 795 | 10 |
2283243 | 2283243 | 2022-03-07 | Nance | Nebraska | 31125 | 795 | 10 |
2270232 | 2270232 | 2022-03-03 | Nance | Nebraska | 31125 | 795 | 10 |
2209364 | 2209364 | 2022-02-12 | Baylor | Texas | 48023 | 795 | 31 |
2206111 | 2206111 | 2022-02-11 | Baylor | Texas | 48023 | 795 | 31 |
2176222 | 2176222 | 2022-02-02 | Hettinger | North Dakota | 38041 | 795 | 7 |
2155621 | 2155621 | 2022-01-27 | Logan | Kansas | 20109 | 795 | 9 |
2152368 | 2152368 | 2022-01-26 | Logan | Kansas | 20109 | 795 | 9 |
2109690 | 2109690 | 2022-01-13 | Bear Lake | Idaho | 16007 | 795 | 15 |
2108544 | 2108544 | 2022-01-12 | Coke | Texas | 48081 | 795 | 18 |
2104473 | 2104473 | 2022-01-11 | Union | New Mexico | 35059 | 795 | 12 |
2091206 | 2091206 | 2022-01-07 | Putnam | Missouri | 29171 | 795 | 20 |
2088398 | 2088398 | 2022-01-06 | LaMoure | North Dakota | 38045 | 795 | 18 |
2058733 | 2058733 | 2021-12-28 | Chouteau | Montana | 30015 | 795 | 9 |
2020592 | 2020592 | 2021-12-16 | Deuel | South Dakota | 46039 | 795 | 12 |
2017815 | 2017815 | 2021-12-15 | Covington city | Virginia | 51580 | 795 | 19 |
2014287 | 2014287 | 2021-12-14 | Crockett | Texas | 48105 | 795 | 17 |
2014565 | 2014565 | 2021-12-14 | Covington city | Virginia | 51580 | 795 | 19 |
2011036 | 2011036 | 2021-12-13 | Crockett | Texas | 48105 | 795 | 17 |
2007785 | 2007785 | 2021-12-12 | Crockett | Texas | 48105 | 795 | 17 |
2004534 | 2004534 | 2021-12-11 | Crockett | Texas | 48105 | 795 | 17 |
1996943 | 1996943 | 2021-12-09 | Reynolds | Missouri | 29179 | 795 | 12 |
1987305 | 1987305 | 2021-12-06 | Furnas | Nebraska | 31065 | 795 | 5 |
1964568 | 1964568 | 2021-11-29 | Howard | Nebraska | 31093 | 795 | 14 |
1945021 | 1945021 | 2021-11-23 | Boone | Nebraska | 31011 | 795 | 4 |
1942112 | 1942112 | 2021-11-22 | Dunn | North Dakota | 38025 | 795 | 7 |
1938862 | 1938862 | 2021-11-21 | Dunn | North Dakota | 38025 | 795 | 7 |
1935612 | 1935612 | 2021-11-20 | Dunn | North Dakota | 38025 | 795 | 7 |
1924446 | 1924446 | 2021-11-17 | Alexander | Illinois | 17003 | 795 | 13 |
1908160 | 1908160 | 2021-11-12 | Boise | Idaho | 16015 | 795 | 10 |
1909983 | 1909983 | 2021-11-12 | Penuelas | Puerto Rico | 72111 | 795 | |
1904911 | 1904911 | 2021-11-11 | Boise | Idaho | 16015 | 795 | 10 |
1901661 | 1901661 | 2021-11-10 | Boise | Idaho | 16015 | 795 | 10 |
1899542 | 1899542 | 2021-11-09 | Dixon | Nebraska | 31051 | 795 | 11 |
1899886 | 1899886 | 2021-11-09 | Pierce | North Dakota | 38069 | 795 | 27 |
1876839 | 1876839 | 2021-11-02 | Pierce | Nebraska | 31139 | 795 | 21 |
1873590 | 1873590 | 2021-11-01 | Pierce | Nebraska | 31139 | 795 | 21 |
1869579 | 1869579 | 2021-10-31 | Rooks | Kansas | 20163 | 795 | 11 |
1870282 | 1870282 | 2021-10-31 | Burt | Nebraska | 31021 | 795 | 12 |
1866330 | 1866330 | 2021-10-30 | Rooks | Kansas | 20163 | 795 | 11 |
1863081 | 1863081 | 2021-10-29 | Rooks | Kansas | 20163 | 795 | 11 |
1852987 | 1852987 | 2021-10-26 | Gallatin | Illinois | 17059 | 795 | 10 |
1853353 | 1853353 | 2021-10-26 | Washington | Kansas | 20201 | 795 | 16 |
1849738 | 1849738 | 2021-10-25 | Gallatin | Illinois | 17059 | 795 | 10 |
1850104 | 1850104 | 2021-10-25 | Washington | Kansas | 20201 | 795 | 16 |
1834192 | 1834192 | 2021-10-20 | Big Stone | Minnesota | 27011 | 795 | 4 |
1807691 | 1807691 | 2021-10-12 | Decatur | Iowa | 19053 | 795 | 12 |
1804440 | 1804440 | 2021-10-11 | Decatur | Iowa | 19053 | 795 | 12 |
1801191 | 1801191 | 2021-10-10 | Decatur | Iowa | 19053 | 795 | 12 |
1797942 | 1797942 | 2021-10-09 | Decatur | Iowa | 19053 | 795 | 12 |
1794693 | 1794693 | 2021-10-08 | Decatur | Iowa | 19053 | 795 | 12 |
1791445 | 1791445 | 2021-10-07 | Decatur | Iowa | 19053 | 795 | 12 |
1792993 | 1792993 | 2021-10-07 | Lajas | Puerto Rico | 72079 | 795 | |
1788196 | 1788196 | 2021-10-06 | Decatur | Iowa | 19053 | 795 | 12 |
1788742 | 1788742 | 2021-10-06 | Mahnomen | Minnesota | 27087 | 795 | 10 |
1738115 | 1738115 | 2021-09-20 | Hartley | Texas | 48205 | 795 | 2 |
1734865 | 1734865 | 2021-09-19 | Hartley | Texas | 48205 | 795 | 2 |
1731615 | 1731615 | 2021-09-18 | Hartley | Texas | 48205 | 795 | 2 |
1728465 | 1728465 | 2021-09-17 | San Augustine | Texas | 48405 | 795 | 33 |
1723364 | 1723364 | 2021-09-16 | Republic | Kansas | 20157 | 795 | 15 |
1725216 | 1725216 | 2021-09-16 | San Augustine | Texas | 48405 | 795 | 33 |
1720115 | 1720115 | 2021-09-15 | Republic | Kansas | 20157 | 795 | 15 |
1702804 | 1702804 | 2021-09-09 | Webster | West Virginia | 54101 | 795 | 11 |
1671346 | 1671346 | 2021-08-31 | Greenwood | Kansas | 20073 | 795 | 11 |
1672238 | 1672238 | 2021-08-31 | Guadalupe | New Mexico | 35019 | 795 | 15 |
1668099 | 1668099 | 2021-08-30 | Greenwood | Kansas | 20073 | 795 | 11 |
1668286 | 1668286 | 2021-08-30 | Wolfe | Kentucky | 21237 | 795 | 8 |
1668530 | 1668530 | 2021-08-30 | Lac qui Parle | Minnesota | 27073 | 795 | 22 |
1665283 | 1665283 | 2021-08-29 | Lac qui Parle | Minnesota | 27073 | 795 | 22 |
1662035 | 1662035 | 2021-08-28 | Lac qui Parle | Minnesota | 27073 | 795 | 22 |
1658787 | 1658787 | 2021-08-27 | Lac qui Parle | Minnesota | 27073 | 795 | 22 |
1651014 | 1651014 | 2021-08-25 | Northwest Arctic Borough | Alaska | 2188 | 795 | 3 |
1632461 | 1632461 | 2021-08-19 | Crittenden | Kentucky | 21055 | 795 | 26 |
1629846 | 1629846 | 2021-08-18 | Stillwater | Montana | 30095 | 795 | 16 |
1629849 | 1629849 | 2021-08-18 | Toole | Montana | 30101 | 795 | 11 |
1622476 | 1622476 | 2021-08-16 | Union | Indiana | 18161 | 795 | 11 |
1621590 | 1621590 | 2021-08-15 | Tyler | West Virginia | 54095 | 795 | 13 |
1618342 | 1618342 | 2021-08-14 | Tyler | West Virginia | 54095 | 795 | 13 |
1615094 | 1615094 | 2021-08-13 | Tyler | West Virginia | 54095 | 795 | 13 |
1610293 | 1610293 | 2021-08-12 | Shannon | Missouri | 29203 | 795 | 13 |
1603056 | 1603056 | 2021-08-10 | Lucas | Iowa | 19117 | 795 | 23 |
1599807 | 1599807 | 2021-08-09 | Lucas | Iowa | 19117 | 795 | 23 |
1596559 | 1596559 | 2021-08-08 | Lucas | Iowa | 19117 | 795 | 23 |
1596616 | 1596616 | 2021-08-08 | Coffey | Kansas | 20031 | 795 | 23 |
1593310 | 1593310 | 2021-08-07 | Lucas | Iowa | 19117 | 795 | 23 |
1593367 | 1593367 | 2021-08-07 | Coffey | Kansas | 20031 | 795 | 23 |
1590061 | 1590061 | 2021-08-06 | Lucas | Iowa | 19117 | 795 | 23 |
1590118 | 1590118 | 2021-08-06 | Coffey | Kansas | 20031 | 795 | 23 |
1586812 | 1586812 | 2021-08-05 | Lucas | Iowa | 19117 | 795 | 23 |
1582925 | 1582925 | 2021-08-04 | Plumas | California | 6063 | 795 | 6 |
1583562 | 1583562 | 2021-08-04 | Lucas | Iowa | 19117 | 795 | 23 |
1585764 | 1585764 | 2021-08-04 | Williamsburg city | Virginia | 51830 | 795 | 14 |
1580325 | 1580325 | 2021-08-03 | Osceola | Iowa | 19143 | 795 | 17 |
1577076 | 1577076 | 2021-08-02 | Osceola | Iowa | 19143 | 795 | 17 |
1573828 | 1573828 | 2021-08-01 | Osceola | Iowa | 19143 | 795 | 17 |
1570580 | 1570580 | 2021-07-31 | Osceola | Iowa | 19143 | 795 | 17 |
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);