ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 3748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 12
- Illinois 10
- Florida 8
- Georgia 8
- Texas 8
- Indiana 7
- Louisiana 7
- Tennessee 6
- Arkansas 5
- Kentucky 5
- Oregon 5
- Pennsylvania 5
- Virginia 5
- West Virginia 5
- Minnesota 4
- Kansas 3
- Nebraska 3
- New Mexico 3
- North Carolina 3
- Ohio 3
- Puerto Rico 3
- Alabama 2
- Colorado 2
- Michigan 2
- New York 2
- North Dakota 2
- Washington 2
- Arizona 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501136 | 2501136 | 2022-05-13 | Livingston | Missouri | 29117 | 3748 | 97 |
2445602 | 2445602 | 2022-04-26 | Renville | Minnesota | 27129 | 3748 | 56 |
2447299 | 2447299 | 2022-04-26 | Pacific | Washington | 53049 | 3748 | 57 |
2444043 | 2444043 | 2022-04-25 | Pacific | Washington | 53049 | 3748 | 57 |
2351374 | 2351374 | 2022-03-28 | Livingston | Missouri | 29117 | 3748 | 94 |
2348122 | 2348122 | 2022-03-27 | Livingston | Missouri | 29117 | 3748 | 94 |
2344869 | 2344869 | 2022-03-26 | Livingston | Missouri | 29117 | 3748 | 94 |
2341616 | 2341616 | 2022-03-25 | Livingston | Missouri | 29117 | 3748 | 94 |
2338363 | 2338363 | 2022-03-24 | Livingston | Missouri | 29117 | 3748 | 94 |
2329744 | 2329744 | 2022-03-21 | Falls | Texas | 48145 | 3748 | 63 |
2326492 | 2326492 | 2022-03-20 | Falls | Texas | 48145 | 3748 | 63 |
2281370 | 2281370 | 2022-03-06 | Grant | West Virginia | 54023 | 3748 | 56 |
2278117 | 2278117 | 2022-03-05 | Grant | West Virginia | 54023 | 3748 | 56 |
2274864 | 2274864 | 2022-03-04 | Grant | West Virginia | 54023 | 3748 | 56 |
2255627 | 2255627 | 2022-02-27 | Franklin | Arkansas | 5047 | 3748 | 68 |
2256188 | 2256188 | 2022-02-27 | Wabash | Illinois | 17185 | 3748 | 30 |
2252376 | 2252376 | 2022-02-26 | Franklin | Arkansas | 5047 | 3748 | 68 |
2252937 | 2252937 | 2022-02-26 | Wabash | Illinois | 17185 | 3748 | 30 |
2249686 | 2249686 | 2022-02-25 | Wabash | Illinois | 17185 | 3748 | 30 |
2238932 | 2238932 | 2022-02-21 | Buckingham | Virginia | 51029 | 3748 | 48 |
2177918 | 2177918 | 2022-02-03 | Jeff Davis | Georgia | 13161 | 3748 | 66 |
2160263 | 2160263 | 2022-01-28 | Aguas Buenas | Puerto Rico | 72007 | 3748 | |
2151584 | 2151584 | 2022-01-26 | Polk | Arkansas | 5113 | 3748 | 130 |
2142758 | 2142758 | 2022-01-23 | Powell | Kentucky | 21197 | 3748 | 30 |
2139503 | 2139503 | 2022-01-22 | Powell | Kentucky | 21197 | 3748 | 30 |
2136247 | 2136247 | 2022-01-21 | Powell | Kentucky | 21197 | 3748 | 30 |
2129041 | 2129041 | 2022-01-19 | Ben Hill | Georgia | 13017 | 3748 | 113 |
2117945 | 2117945 | 2022-01-15 | Montour | Pennsylvania | 42093 | 3748 | 83 |
2109739 | 2109739 | 2022-01-13 | Cass | Illinois | 17017 | 3748 | 41 |
2101636 | 2101636 | 2022-01-10 | Union | Oregon | 41061 | 3748 | 64 |
2080608 | 2080608 | 2022-01-04 | Jay | Indiana | 18075 | 3748 | 63 |
2040324 | 2040324 | 2021-12-22 | Gillespie | Texas | 48171 | 3748 | 83 |
2010608 | 2010608 | 2021-12-13 | Lincoln | Oregon | 41041 | 3748 | 57 |
1993105 | 1993105 | 2021-12-08 | Adair | Kentucky | 21001 | 3748 | 87 |
1989854 | 1989854 | 2021-12-07 | Adair | Kentucky | 21001 | 3748 | 87 |
1925110 | 1925110 | 2021-11-17 | Emmet | Michigan | 26047 | 3748 | 55 |
1910719 | 1910719 | 2021-11-12 | Mason | West Virginia | 54053 | 3748 | 59 |
1897653 | 1897653 | 2021-11-08 | Winchester city | Virginia | 51840 | 3748 | 56 |
1894342 | 1894342 | 2021-11-07 | Lee | Virginia | 51105 | 3748 | 60 |
1891092 | 1891092 | 2021-11-06 | Lee | Virginia | 51105 | 3748 | 60 |
1891250 | 1891250 | 2021-11-06 | Wyoming | West Virginia | 54109 | 3748 | 65 |
1887842 | 1887842 | 2021-11-05 | Lee | Virginia | 51105 | 3748 | 60 |
1869008 | 1869008 | 2021-10-31 | Burke | Georgia | 13033 | 3748 | 84 |
1865759 | 1865759 | 2021-10-30 | Burke | Georgia | 13033 | 3748 | 84 |
1862510 | 1862510 | 2021-10-29 | Burke | Georgia | 13033 | 3748 | 84 |
1852818 | 1852818 | 2021-10-26 | Harris | Georgia | 13145 | 3748 | 86 |
1846520 | 1846520 | 2021-10-24 | McDonough | Illinois | 17109 | 3748 | 73 |
1843270 | 1843270 | 2021-10-23 | McDonough | Illinois | 17109 | 3748 | 73 |
1840020 | 1840020 | 2021-10-22 | McDonough | Illinois | 17109 | 3748 | 73 |
1825705 | 1825705 | 2021-10-17 | Morgan | Tennessee | 47129 | 3748 | 46 |
1822456 | 1822456 | 2021-10-16 | Morgan | Tennessee | 47129 | 3748 | 46 |
1819207 | 1819207 | 2021-10-15 | Morgan | Tennessee | 47129 | 3748 | 46 |
1815782 | 1815782 | 2021-10-14 | Abbeville | South Carolina | 45001 | 3748 | 49 |
1786690 | 1786690 | 2021-10-05 | Haywood | Tennessee | 47075 | 3748 | 71 |
1769739 | 1769739 | 2021-09-30 | Franklin | New York | 36033 | 3748 | 17 |
1756042 | 1756042 | 2021-09-26 | Pointe Coupee | Louisiana | 22077 | 3748 | 81 |
1756712 | 1756712 | 2021-09-26 | Luna | New Mexico | 35029 | 3748 | 93 |
1752794 | 1752794 | 2021-09-25 | Pointe Coupee | Louisiana | 22077 | 3748 | 81 |
1753464 | 1753464 | 2021-09-25 | Luna | New Mexico | 35029 | 3748 | 93 |
1749545 | 1749545 | 2021-09-24 | Pointe Coupee | Louisiana | 22077 | 3748 | 81 |
1750216 | 1750216 | 2021-09-24 | Luna | New Mexico | 35029 | 3748 | 93 |
1746295 | 1746295 | 2021-09-23 | Pointe Coupee | Louisiana | 22077 | 3748 | 81 |
1723954 | 1723954 | 2021-09-16 | Miller | Missouri | 29131 | 3748 | 70 |
1725009 | 1725009 | 2021-09-16 | Wayne | Tennessee | 47181 | 3748 | 38 |
1711695 | 1711695 | 2021-09-12 | Jefferson | Pennsylvania | 42065 | 3748 | 101 |
1700281 | 1700281 | 2021-09-09 | Fayette | Illinois | 17051 | 3748 | 59 |
1702388 | 1702388 | 2021-09-09 | Hockley | Texas | 48219 | 3748 | 118 |
1697200 | 1697200 | 2021-09-08 | White | Indiana | 18181 | 3748 | 57 |
1671749 | 1671749 | 2021-08-31 | Carlton | Minnesota | 27017 | 3748 | 59 |
1634016 | 1634016 | 2021-08-19 | Marion | Tennessee | 47115 | 3748 | 51 |
1624010 | 1624010 | 2021-08-16 | Snyder | Pennsylvania | 42109 | 3748 | 86 |
1617602 | 1617602 | 2021-08-14 | Vega Baja | Puerto Rico | 72145 | 3748 | |
1540845 | 1540845 | 2021-07-22 | Levy | Florida | 12075 | 3748 | 56 |
1537598 | 1537598 | 2021-07-21 | Levy | Florida | 12075 | 3748 | 56 |
1534350 | 1534350 | 2021-07-20 | Levy | Florida | 12075 | 3748 | 56 |
1531103 | 1531103 | 2021-07-19 | Levy | Florida | 12075 | 3748 | 56 |
1527856 | 1527856 | 2021-07-18 | Levy | Florida | 12075 | 3748 | 56 |
1524609 | 1524609 | 2021-07-17 | Levy | Florida | 12075 | 3748 | 56 |
1521361 | 1521361 | 2021-07-16 | Levy | Florida | 12075 | 3748 | 56 |
1499858 | 1499858 | 2021-07-09 | Pulaski | Missouri | 29169 | 3748 | 56 |
1436909 | 1436909 | 2021-06-20 | Summit | Colorado | 8117 | 3748 | 8 |
1433662 | 1433662 | 2021-06-19 | Summit | Colorado | 8117 | 3748 | 8 |
1423221 | 1423221 | 2021-06-15 | Titus | Texas | 48449 | 3748 | 84 |
1409628 | 1409628 | 2021-06-11 | Douglas | Oregon | 41019 | 3748 | 80 |
1381030 | 1381030 | 2021-06-02 | Titus | Texas | 48449 | 3748 | 84 |
1365947 | 1365947 | 2021-05-29 | Knox | Indiana | 18083 | 3748 | 90 |
1362701 | 1362701 | 2021-05-28 | Knox | Indiana | 18083 | 3748 | 90 |
1339896 | 1339896 | 2021-05-21 | Montgomery | Illinois | 17135 | 3748 | 79 |
1336902 | 1336902 | 2021-05-20 | Ellis | Kansas | 20051 | 3748 | 72 |
1333655 | 1333655 | 2021-05-19 | Ellis | Kansas | 20051 | 3748 | 72 |
1273364 | 1273364 | 2021-04-30 | Pike | Pennsylvania | 42103 | 3748 | 54 |
1262087 | 1262087 | 2021-04-27 | Steuben | Indiana | 18151 | 3748 | 59 |
1256539 | 1256539 | 2021-04-25 | Lincoln | Nebraska | 31111 | 3748 | 53 |
1253292 | 1253292 | 2021-04-24 | Lincoln | Nebraska | 31111 | 3748 | 53 |
1250647 | 1250647 | 2021-04-23 | Wayne | Pennsylvania | 42127 | 3748 | 76 |
1200084 | 1200084 | 2021-04-08 | Liberty | Georgia | 13179 | 3748 | 60 |
1184016 | 1184016 | 2021-04-03 | Lee | Illinois | 17103 | 3748 | 87 |
1172239 | 1172239 | 2021-03-30 | Fulton | New York | 36035 | 3748 | 85 |
1116383 | 1116383 | 2021-03-13 | Calvert | Maryland | 24009 | 3748 | 73 |
1094519 | 1094519 | 2021-03-06 | Brown | Ohio | 39015 | 3748 | 52 |
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);