ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
225 rows where cases = 2472 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 20
- Puerto Rico 16
- Kentucky 14
- Georgia 12
- Indiana 12
- Mississippi 12
- Texas 12
- Tennessee 10
- Missouri 9
- Kansas 8
- Oklahoma 8
- Virginia 8
- Minnesota 7
- Louisiana 6
- Alabama 5
- Arkansas 5
- New Hampshire 5
- Idaho 4
- Michigan 4
- North Carolina 4
- Utah 4
- Colorado 3
- Illinois 3
- Iowa 3
- Maryland 3
- North Dakota 3
- Arizona 2
- California 2
- Florida 2
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473148 | 2473148 | 2022-05-04 | Emery | Utah | 49015 | 2472 | 28 |
2469892 | 2469892 | 2022-05-03 | Emery | Utah | 49015 | 2472 | 28 |
2466636 | 2466636 | 2022-05-02 | Emery | Utah | 49015 | 2472 | 28 |
2453120 | 2453120 | 2022-04-28 | Sabana Grande | Puerto Rico | 72121 | 2472 | |
2420526 | 2420526 | 2022-04-18 | Florida | Puerto Rico | 72054 | 2472 | |
2417270 | 2417270 | 2022-04-17 | Florida | Puerto Rico | 72054 | 2472 | |
2387982 | 2387982 | 2022-04-08 | Lajas | Puerto Rico | 72079 | 2472 | |
2365210 | 2365210 | 2022-04-01 | Luquillo | Puerto Rico | 72089 | 2472 | |
2311485 | 2311485 | 2022-03-16 | Benton | Indiana | 18007 | 2472 | 21 |
2242652 | 2242652 | 2022-02-23 | Perry | Arkansas | 5105 | 2472 | 31 |
2193391 | 2193391 | 2022-02-07 | Amelia | Virginia | 51007 | 2472 | 51 |
2151596 | 2151596 | 2022-01-26 | Stone | Arkansas | 5137 | 2472 | 51 |
2146946 | 2146946 | 2022-01-24 | McLean | North Dakota | 38055 | 2472 | 48 |
2143692 | 2143692 | 2022-01-23 | McLean | North Dakota | 38055 | 2472 | 48 |
2110547 | 2110547 | 2022-01-13 | Amite | Mississippi | 28005 | 2472 | 59 |
2102776 | 2102776 | 2022-01-11 | Lee | Arkansas | 5077 | 2472 | 55 |
2077309 | 2077309 | 2022-01-03 | Wabash | Illinois | 17185 | 2472 | 22 |
2052971 | 2052971 | 2021-12-26 | Fajardo | Puerto Rico | 72053 | 2472 | |
2035329 | 2035329 | 2021-12-21 | Osage | Kansas | 20139 | 2472 | 39 |
2032079 | 2032079 | 2021-12-20 | Osage | Kansas | 20139 | 2472 | 39 |
2022554 | 2022554 | 2021-12-17 | Lincoln | Maine | 23015 | 2472 | 10 |
2013943 | 2013943 | 2021-12-14 | Aguada | Puerto Rico | 72003 | 2472 | |
2010692 | 2010692 | 2021-12-13 | Aguada | Puerto Rico | 72003 | 2472 | |
2007441 | 2007441 | 2021-12-12 | Aguada | Puerto Rico | 72003 | 2472 | |
2001898 | 2001898 | 2021-12-11 | Macon | Alabama | 1087 | 2472 | 68 |
2004190 | 2004190 | 2021-12-11 | Aguada | Puerto Rico | 72003 | 2472 | |
2000939 | 2000939 | 2021-12-10 | Aguada | Puerto Rico | 72003 | 2472 | |
1993599 | 1993599 | 2021-12-08 | Yalobusha | Mississippi | 28161 | 2472 | 47 |
1988645 | 1988645 | 2021-12-06 | Southampton | Virginia | 51175 | 2472 | 69 |
1983439 | 1983439 | 2021-12-05 | Monroe | Kentucky | 21171 | 2472 | 64 |
1980189 | 1980189 | 2021-12-04 | Monroe | Kentucky | 21171 | 2472 | 64 |
1981737 | 1981737 | 2021-12-04 | Bandera | Texas | 48019 | 2472 | 61 |
1976939 | 1976939 | 2021-12-03 | Monroe | Kentucky | 21171 | 2472 | 64 |
1978487 | 1978487 | 2021-12-03 | Bandera | Texas | 48019 | 2472 | 61 |
1973678 | 1973678 | 2021-12-02 | Magoffin | Kentucky | 21153 | 2472 | 27 |
1962150 | 1962150 | 2021-11-28 | Decatur | Tennessee | 47039 | 2472 | 44 |
1958381 | 1958381 | 2021-11-27 | McKenzie | North Dakota | 38053 | 2472 | 22 |
1958899 | 1958899 | 2021-11-27 | Decatur | Tennessee | 47039 | 2472 | 44 |
1955648 | 1955648 | 2021-11-26 | Decatur | Tennessee | 47039 | 2472 | 44 |
1952397 | 1952397 | 2021-11-25 | Decatur | Tennessee | 47039 | 2472 | 44 |
1949146 | 1949146 | 2021-11-24 | Decatur | Tennessee | 47039 | 2472 | 44 |
1945895 | 1945895 | 2021-11-23 | Decatur | Tennessee | 47039 | 2472 | 44 |
1941858 | 1941858 | 2021-11-22 | York | Nebraska | 31185 | 2472 | 19 |
1914993 | 1914993 | 2021-11-14 | Atchison | Kansas | 20005 | 2472 | 27 |
1915112 | 1915112 | 2021-11-14 | Caldwell | Kentucky | 21033 | 2472 | 50 |
1911743 | 1911743 | 2021-11-13 | Atchison | Kansas | 20005 | 2472 | 27 |
1911862 | 1911862 | 2021-11-13 | Caldwell | Kentucky | 21033 | 2472 | 50 |
1908494 | 1908494 | 2021-11-12 | Atchison | Kansas | 20005 | 2472 | 27 |
1908613 | 1908613 | 2021-11-12 | Caldwell | Kentucky | 21033 | 2472 | 50 |
1900360 | 1900360 | 2021-11-09 | Oglala Lakota | South Dakota | 46102 | 2472 | 53 |
1878361 | 1878361 | 2021-11-03 | Clay | Alabama | 1027 | 2472 | 69 |
1881245 | 1881245 | 2021-11-03 | San Juan | Utah | 49037 | 2472 | 41 |
1878332 | 1878332 | 2021-11-02 | Goshen | Wyoming | 56015 | 2472 | 39 |
1874205 | 1874205 | 2021-11-01 | Corozal | Puerto Rico | 72047 | 2472 | |
1842135 | 1842135 | 2021-10-22 | Madison | Texas | 48313 | 2472 | 43 |
1833973 | 1833973 | 2021-10-20 | Union | Kentucky | 21225 | 2472 | 32 |
1827246 | 1827246 | 2021-10-18 | Unknown | Iowa | 2472 | 0 | |
1823997 | 1823997 | 2021-10-17 | Unknown | Iowa | 2472 | 0 | |
1820748 | 1820748 | 2021-10-16 | Unknown | Iowa | 2472 | 0 | |
1814494 | 1814494 | 2021-10-14 | Bienville | Louisiana | 22013 | 2472 | 95 |
1803700 | 1803700 | 2021-10-11 | North Slope Borough | Alaska | 2185 | 2472 | 5 |
1791687 | 1791687 | 2021-10-07 | Lawrence | Kentucky | 21127 | 2472 | 37 |
1788953 | 1788953 | 2021-10-06 | Pike | Missouri | 29163 | 2472 | 35 |
1771189 | 1771189 | 2021-10-01 | Washington | Alabama | 1129 | 2472 | 49 |
1765231 | 1765231 | 2021-09-29 | Bond | Illinois | 17005 | 2472 | 29 |
1762734 | 1762734 | 2021-09-28 | Hubbard | Minnesota | 27057 | 2472 | 41 |
1763565 | 1763565 | 2021-09-28 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1760316 | 1760316 | 2021-09-27 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1757068 | 1757068 | 2021-09-26 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1753820 | 1753820 | 2021-09-25 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1754031 | 1754031 | 2021-09-25 | San Sebastian | Puerto Rico | 72131 | 2472 | |
1750572 | 1750572 | 2021-09-24 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1747322 | 1747322 | 2021-09-23 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1744073 | 1744073 | 2021-09-22 | Kingfisher | Oklahoma | 40073 | 2472 | 44 |
1699430 | 1699430 | 2021-09-08 | Prince Edward | Virginia | 51147 | 2472 | 40 |
1669264 | 1669264 | 2021-08-30 | Hocking | Ohio | 39073 | 2472 | 63 |
1648888 | 1648888 | 2021-08-24 | Caroline | Maryland | 24011 | 2472 | 33 |
1645742 | 1645742 | 2021-08-23 | Otsego | Michigan | 26137 | 2472 | 41 |
1619565 | 1619565 | 2021-08-15 | Woodford | Kentucky | 21239 | 2472 | 22 |
1616317 | 1616317 | 2021-08-14 | Woodford | Kentucky | 21239 | 2472 | 22 |
1613068 | 1613068 | 2021-08-13 | Woodford | Kentucky | 21239 | 2472 | 22 |
1606586 | 1606586 | 2021-08-11 | Concordia | Louisiana | 22029 | 2472 | 62 |
1588777 | 1588777 | 2021-08-05 | Reeves | Texas | 48389 | 2472 | 45 |
1588934 | 1588934 | 2021-08-05 | Gloucester | Virginia | 51073 | 2472 | 52 |
1585704 | 1585704 | 2021-08-04 | Lee | Virginia | 51105 | 2472 | 48 |
1578867 | 1578867 | 2021-08-02 | Cass | Texas | 48067 | 2472 | 85 |
1556048 | 1556048 | 2021-07-26 | Johnson | Tennessee | 47091 | 2472 | 39 |
1556527 | 1556527 | 2021-07-26 | Waynesboro city | Virginia | 51820 | 2472 | 38 |
1539326 | 1539326 | 2021-07-21 | Gallia | Ohio | 39053 | 2472 | 50 |
1517987 | 1517987 | 2021-07-15 | Siskiyou | California | 6093 | 2472 | 40 |
1505559 | 1505559 | 2021-07-11 | Washington | Indiana | 18175 | 2472 | 37 |
1502313 | 1502313 | 2021-07-10 | Washington | Indiana | 18175 | 2472 | 37 |
1499067 | 1499067 | 2021-07-09 | Washington | Indiana | 18175 | 2472 | 37 |
1495820 | 1495820 | 2021-07-08 | Washington | Indiana | 18175 | 2472 | 37 |
1492574 | 1492574 | 2021-07-07 | Washington | Indiana | 18175 | 2472 | 37 |
1458218 | 1458218 | 2021-06-26 | Van Wert | Ohio | 39161 | 2472 | 65 |
1454973 | 1454973 | 2021-06-25 | Van Wert | Ohio | 39161 | 2472 | 65 |
1451728 | 1451728 | 2021-06-24 | Van Wert | Ohio | 39161 | 2472 | 64 |
1448482 | 1448482 | 2021-06-23 | Van Wert | Ohio | 39161 | 2472 | 64 |
1444356 | 1444356 | 2021-06-22 | Clare | Michigan | 26035 | 2472 | 83 |
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);