ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
476 rows where cases = 746 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 43
- Nebraska 35
- Virginia 29
- Illinois 25
- Kansas 25
- Kentucky 25
- Georgia 22
- Missouri 20
- Iowa 16
- Minnesota 15
- Arkansas 14
- Indiana 14
- Oregon 14
- Tennessee 14
- Mississippi 13
- North Dakota 13
- Utah 12
- Puerto Rico 11
- West Virginia 10
- Colorado 9
- North Carolina 9
- Wyoming 9
- Michigan 7
- Ohio 7
- Oklahoma 7
- Pennsylvania 7
- Idaho 6
- Louisiana 6
- New Mexico 6
- South Dakota 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419916 | 2419916 | 2022-04-18 | Stanton | Nebraska | 31167 | 746 | 11 |
2416661 | 2416661 | 2022-04-17 | Stanton | Nebraska | 31167 | 746 | 11 |
2413405 | 2413405 | 2022-04-16 | Stanton | Nebraska | 31167 | 746 | 11 |
2410149 | 2410149 | 2022-04-15 | Stanton | Nebraska | 31167 | 746 | 11 |
2406893 | 2406893 | 2022-04-14 | Stanton | Nebraska | 31167 | 746 | 11 |
2403637 | 2403637 | 2022-04-13 | Stanton | Nebraska | 31167 | 746 | 11 |
2338564 | 2338564 | 2022-03-24 | Valley | Nebraska | 31175 | 746 | 6 |
2335310 | 2335310 | 2022-03-23 | Valley | Nebraska | 31175 | 746 | 6 |
2332056 | 2332056 | 2022-03-22 | Valley | Nebraska | 31175 | 746 | 6 |
2309284 | 2309284 | 2022-03-15 | Valley | Nebraska | 31175 | 746 | 6 |
2306032 | 2306032 | 2022-03-14 | Valley | Nebraska | 31175 | 746 | 6 |
2293025 | 2293025 | 2022-03-10 | Valley | Nebraska | 31175 | 746 | 6 |
2218500 | 2218500 | 2022-02-15 | Eddy | North Dakota | 38027 | 746 | 6 |
2192925 | 2192925 | 2022-02-07 | Bennett | South Dakota | 46007 | 746 | 11 |
2176661 | 2176661 | 2022-02-02 | Aurora | South Dakota | 46003 | 746 | 17 |
2169705 | 2169705 | 2022-01-31 | Cavalier | North Dakota | 38019 | 746 | 7 |
2166450 | 2166450 | 2022-01-30 | Cavalier | North Dakota | 38019 | 746 | 7 |
2163195 | 2163195 | 2022-01-29 | Cavalier | North Dakota | 38019 | 746 | 7 |
2159940 | 2159940 | 2022-01-28 | Cavalier | North Dakota | 38019 | 746 | 7 |
2132801 | 2132801 | 2022-01-20 | Chautauqua | Kansas | 20019 | 746 | 16 |
2129548 | 2129548 | 2022-01-19 | Chautauqua | Kansas | 20019 | 746 | 16 |
2127256 | 2127256 | 2022-01-18 | Hamilton | New York | 36041 | 746 | 4 |
2121551 | 2121551 | 2022-01-16 | Coke | Texas | 48081 | 746 | 18 |
2087760 | 2087760 | 2022-01-06 | Red Lake | Minnesota | 27125 | 746 | 11 |
2086006 | 2086006 | 2022-01-05 | Garfield | Utah | 49017 | 746 | 12 |
2082754 | 2082754 | 2022-01-04 | Garfield | Utah | 49017 | 746 | 12 |
2079502 | 2079502 | 2022-01-03 | Garfield | Utah | 49017 | 746 | 12 |
2066604 | 2066604 | 2021-12-30 | King and Queen | Virginia | 51097 | 746 | 9 |
2051248 | 2051248 | 2021-12-26 | Hardin | Illinois | 17069 | 746 | 16 |
2047998 | 2047998 | 2021-12-25 | Hardin | Illinois | 17069 | 746 | 16 |
2044748 | 2044748 | 2021-12-24 | Hardin | Illinois | 17069 | 746 | 16 |
2041499 | 2041499 | 2021-12-23 | Hardin | Illinois | 17069 | 746 | 16 |
2038292 | 2038292 | 2021-12-22 | Putnam | Illinois | 17155 | 746 | 7 |
2017826 | 2017826 | 2021-12-15 | Falls Church city | Virginia | 51610 | 746 | 14 |
2013667 | 2013667 | 2021-12-14 | Wells | North Dakota | 38103 | 746 | 10 |
2011531 | 2011531 | 2021-12-13 | Florence | Wisconsin | 55037 | 746 | 14 |
2008280 | 2008280 | 2021-12-12 | Florence | Wisconsin | 55037 | 746 | 14 |
2005029 | 2005029 | 2021-12-11 | Florence | Wisconsin | 55037 | 746 | 14 |
2000651 | 2000651 | 2021-12-10 | Sargent | North Dakota | 38081 | 746 | 9 |
2001778 | 2001778 | 2021-12-10 | Florence | Wisconsin | 55037 | 746 | 14 |
1982872 | 1982872 | 2021-12-05 | Talbot | Georgia | 13263 | 746 | 29 |
1983714 | 1983714 | 2021-12-05 | Kittson | Minnesota | 27069 | 746 | 23 |
1979622 | 1979622 | 2021-12-04 | Talbot | Georgia | 13263 | 746 | 29 |
1980464 | 1980464 | 2021-12-04 | Kittson | Minnesota | 27069 | 746 | 23 |
1976372 | 1976372 | 2021-12-03 | Talbot | Georgia | 13263 | 746 | 29 |
1977214 | 1977214 | 2021-12-03 | Kittson | Minnesota | 27069 | 746 | 23 |
1974630 | 1974630 | 2021-12-02 | LaMoure | North Dakota | 38045 | 746 | 17 |
1975561 | 1975561 | 2021-12-02 | Cumberland | Virginia | 51049 | 746 | 19 |
1970358 | 1970358 | 2021-12-01 | Ballard | Kentucky | 21007 | 746 | 22 |
1972312 | 1972312 | 2021-12-01 | Cumberland | Virginia | 51049 | 746 | 19 |
1937453 | 1937453 | 2021-11-21 | Calhoun | Illinois | 17013 | 746 | 5 |
1934203 | 1934203 | 2021-11-20 | Calhoun | Illinois | 17013 | 746 | 5 |
1930952 | 1930952 | 2021-11-19 | Calhoun | Illinois | 17013 | 746 | 5 |
1927701 | 1927701 | 2021-11-18 | Calhoun | Illinois | 17013 | 746 | 5 |
1925343 | 1925343 | 2021-11-17 | Atchison | Missouri | 29005 | 746 | 7 |
1899518 | 1899518 | 2021-11-09 | Antelope | Nebraska | 31003 | 746 | 10 |
1896268 | 1896268 | 2021-11-08 | Antelope | Nebraska | 31003 | 746 | 9 |
1896313 | 1896313 | 2021-11-08 | Howard | Nebraska | 31093 | 746 | 13 |
1891983 | 1891983 | 2021-11-07 | Henderson | Illinois | 17071 | 746 | 23 |
1888733 | 1888733 | 2021-11-06 | Henderson | Illinois | 17071 | 746 | 23 |
1885483 | 1885483 | 2021-11-05 | Henderson | Illinois | 17071 | 746 | 23 |
1832565 | 1832565 | 2021-10-19 | Covington city | Virginia | 51580 | 746 | 16 |
1815107 | 1815107 | 2021-10-14 | Polk | Nebraska | 31143 | 746 | 18 |
1808608 | 1808608 | 2021-10-12 | Pierce | Nebraska | 31139 | 746 | 21 |
1787960 | 1787960 | 2021-10-06 | Lemhi | Idaho | 16059 | 746 | 14 |
1788705 | 1788705 | 2021-10-06 | Big Stone | Minnesota | 27011 | 746 | 4 |
1789053 | 1789053 | 2021-10-06 | Burt | Nebraska | 31021 | 746 | 12 |
1785084 | 1785084 | 2021-10-05 | Morris | Kansas | 20127 | 746 | 23 |
1781835 | 1781835 | 2021-10-04 | Morris | Kansas | 20127 | 746 | 23 |
1700343 | 1700343 | 2021-09-09 | Stark | Illinois | 17175 | 746 | 26 |
1692910 | 1692910 | 2021-09-06 | Madison | Virginia | 51113 | 746 | 17 |
1671383 | 1671383 | 2021-08-31 | Phillips | Kansas | 20147 | 746 | 25 |
1672786 | 1672786 | 2021-08-31 | Lajas | Puerto Rico | 72079 | 746 | |
1668136 | 1668136 | 2021-08-30 | Phillips | Kansas | 20147 | 746 | 25 |
1669538 | 1669538 | 2021-08-30 | Lajas | Puerto Rico | 72079 | 746 | |
1663419 | 1663419 | 2021-08-28 | Jim Hogg | Texas | 48247 | 746 | 17 |
1659811 | 1659811 | 2021-08-27 | Penuelas | Puerto Rico | 72111 | 746 | |
1660171 | 1660171 | 2021-08-27 | Jim Hogg | Texas | 48247 | 746 | 17 |
1653889 | 1653889 | 2021-08-25 | Emporia city | Virginia | 51595 | 746 | 42 |
1645003 | 1645003 | 2021-08-23 | Caribou | Idaho | 16029 | 746 | 12 |
1644325 | 1644325 | 2021-08-22 | Roane | West Virginia | 54087 | 746 | 9 |
1641075 | 1641075 | 2021-08-21 | Roane | West Virginia | 54087 | 746 | 9 |
1637825 | 1637825 | 2021-08-20 | Roane | West Virginia | 54087 | 746 | 9 |
1634211 | 1634211 | 2021-08-19 | Marion | Texas | 48315 | 746 | 34 |
1626947 | 1626947 | 2021-08-17 | Bottineau | North Dakota | 38009 | 746 | 20 |
1603648 | 1603648 | 2021-08-10 | Jefferson | Mississippi | 28063 | 746 | 29 |
1571273 | 1571273 | 2021-07-31 | Maries | Missouri | 29125 | 746 | 8 |
1557716 | 1557716 | 2021-07-27 | Wabaunsee | Kansas | 20197 | 746 | 14 |
1554469 | 1554469 | 2021-07-26 | Wabaunsee | Kansas | 20197 | 746 | 14 |
1551222 | 1551222 | 2021-07-25 | Wabaunsee | Kansas | 20197 | 746 | 14 |
1551720 | 1551720 | 2021-07-25 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1547975 | 1547975 | 2021-07-24 | Wabaunsee | Kansas | 20197 | 746 | 14 |
1548473 | 1548473 | 2021-07-24 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1544728 | 1544728 | 2021-07-23 | Wabaunsee | Kansas | 20197 | 746 | 14 |
1545226 | 1545226 | 2021-07-23 | Wilkinson | Mississippi | 28157 | 746 | 32 |
1534209 | 1534209 | 2021-07-20 | Plumas | California | 6063 | 746 | 6 |
1530962 | 1530962 | 2021-07-19 | Plumas | California | 6063 | 746 | 6 |
1518848 | 1518848 | 2021-07-15 | Owen | Kentucky | 21187 | 746 | 13 |
1515601 | 1515601 | 2021-07-14 | Owen | Kentucky | 21187 | 746 | 13 |
1509108 | 1509108 | 2021-07-12 | Owen | Kentucky | 21187 | 746 | 13 |
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);