ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where cases = 3794 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 18
- Virginia 14
- Georgia 11
- Texas 9
- Illinois 8
- Ohio 8
- New Mexico 7
- Arkansas 6
- Louisiana 6
- Minnesota 6
- Missouri 4
- Wisconsin 4
- Wyoming 4
- Iowa 3
- New York 3
- North Carolina 3
- Puerto Rico 3
- Alabama 2
- Colorado 2
- Idaho 2
- Kansas 2
- Maryland 2
- Michigan 2
- Mississippi 2
- Oregon 2
- Pennsylvania 2
- Utah 2
- Washington 2
- Indiana 1
- Kentucky 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450473 | 2450473 | 2022-04-27 | Manassas Park city | Virginia | 51685 | 3794 | 27 |
2447147 | 2447147 | 2022-04-26 | Appomattox | Virginia | 51011 | 3794 | 52 |
2443892 | 2443892 | 2022-04-25 | Appomattox | Virginia | 51011 | 3794 | 52 |
2440636 | 2440636 | 2022-04-24 | Appomattox | Virginia | 51011 | 3794 | 52 |
2437380 | 2437380 | 2022-04-23 | Appomattox | Virginia | 51011 | 3794 | 52 |
2434124 | 2434124 | 2022-04-22 | Appomattox | Virginia | 51011 | 3794 | 52 |
2416751 | 2416751 | 2022-04-17 | Socorro | New Mexico | 35053 | 3794 | 86 |
2413495 | 2413495 | 2022-04-16 | Socorro | New Mexico | 35053 | 3794 | 86 |
2410239 | 2410239 | 2022-04-15 | Socorro | New Mexico | 35053 | 3794 | 86 |
2340000 | 2340000 | 2022-03-24 | Marquette | Wisconsin | 55077 | 3794 | 60 |
2196731 | 2196731 | 2022-02-08 | Nottoway | Virginia | 51135 | 3794 | 75 |
2150781 | 2150781 | 2022-01-25 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2147529 | 2147529 | 2022-01-24 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2144275 | 2144275 | 2022-01-23 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2141020 | 2141020 | 2022-01-22 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2137764 | 2137764 | 2022-01-21 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2134510 | 2134510 | 2022-01-20 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2131258 | 2131258 | 2022-01-19 | Unicoi | Tennessee | 47171 | 3794 | 82 |
2096616 | 2096616 | 2022-01-09 | Mitchell | Georgia | 13205 | 3794 | 102 |
2093364 | 2093364 | 2022-01-08 | Mitchell | Georgia | 13205 | 3794 | 102 |
2090112 | 2090112 | 2022-01-07 | Mitchell | Georgia | 13205 | 3794 | 102 |
2086861 | 2086861 | 2022-01-06 | Mitchell | Georgia | 13205 | 3794 | 102 |
2083609 | 2083609 | 2022-01-05 | Mitchell | Georgia | 13205 | 3794 | 102 |
2085803 | 2085803 | 2022-01-05 | Deaf Smith | Texas | 48117 | 3794 | 101 |
2043908 | 2043908 | 2021-12-23 | Staunton city | Virginia | 51790 | 3794 | 86 |
1994176 | 1994176 | 2021-12-08 | Carroll | Ohio | 39019 | 3794 | 78 |
1986009 | 1986009 | 2021-12-06 | Burke | Georgia | 13033 | 3794 | 86 |
1966034 | 1966034 | 2021-11-29 | Jackson | Wisconsin | 55053 | 3794 | 34 |
1946136 | 1946136 | 2021-11-23 | Milam | Texas | 48331 | 3794 | 90 |
1941580 | 1941580 | 2021-11-22 | Tishomingo | Mississippi | 28141 | 3794 | 93 |
1903838 | 1903838 | 2021-11-10 | Hutchinson | Texas | 48233 | 3794 | 93 |
1900588 | 1900588 | 2021-11-09 | Hutchinson | Texas | 48233 | 3794 | 93 |
1888218 | 1888218 | 2021-11-06 | Cleburne | Arkansas | 5023 | 3794 | 93 |
1880444 | 1880444 | 2021-11-03 | Henry | Ohio | 39069 | 3794 | 73 |
1857748 | 1857748 | 2021-10-27 | Van Wert | Ohio | 39161 | 3794 | 82 |
1854949 | 1854949 | 2021-10-26 | Morgan | Tennessee | 47129 | 3794 | 48 |
1852353 | 1852353 | 2021-10-25 | Uinta | Wyoming | 56041 | 3794 | 26 |
1846361 | 1846361 | 2021-10-24 | Pike | Georgia | 13231 | 3794 | 68 |
1843111 | 1843111 | 2021-10-23 | Pike | Georgia | 13231 | 3794 | 68 |
1839861 | 1839861 | 2021-10-22 | Pike | Georgia | 13231 | 3794 | 68 |
1833381 | 1833381 | 2021-10-20 | Tattnall | Georgia | 13267 | 3794 | 105 |
1824255 | 1824255 | 2021-10-17 | Grant | Louisiana | 22043 | 3794 | 77 |
1824333 | 1824333 | 2021-10-17 | Queen Anne's | Maryland | 24035 | 3794 | 70 |
1821006 | 1821006 | 2021-10-16 | Grant | Louisiana | 22043 | 3794 | 77 |
1817757 | 1817757 | 2021-10-15 | Grant | Louisiana | 22043 | 3794 | 77 |
1810293 | 1810293 | 2021-10-13 | Sevier | Arkansas | 5133 | 3794 | 50 |
1786546 | 1786546 | 2021-10-05 | Barnwell | South Carolina | 45011 | 3794 | 80 |
1782963 | 1782963 | 2021-10-04 | Gallia | Ohio | 39053 | 3794 | 61 |
1779456 | 1779456 | 2021-10-03 | Luna | New Mexico | 35029 | 3794 | 93 |
1776206 | 1776206 | 2021-10-02 | Luna | New Mexico | 35029 | 3794 | 93 |
1772956 | 1772956 | 2021-10-01 | Luna | New Mexico | 35029 | 3794 | 93 |
1772989 | 1772989 | 2021-10-01 | Franklin | New York | 36033 | 3794 | 17 |
1741819 | 1741819 | 2021-09-21 | Juneau | Wisconsin | 55057 | 3794 | 31 |
1716613 | 1716613 | 2021-09-14 | Decatur | Indiana | 18031 | 3794 | 99 |
1712330 | 1712330 | 2021-09-12 | Amherst | Virginia | 51009 | 3794 | 44 |
1709083 | 1709083 | 2021-09-11 | Amherst | Virginia | 51009 | 3794 | 44 |
1705836 | 1705836 | 2021-09-10 | Amherst | Virginia | 51009 | 3794 | 44 |
1694245 | 1694245 | 2021-09-07 | Montgomery | Kentucky | 21173 | 3794 | 36 |
1679497 | 1679497 | 2021-09-02 | McNairy | Tennessee | 47109 | 3794 | 58 |
1675429 | 1675429 | 2021-09-01 | Douglas | Nevada | 32005 | 3794 | 42 |
1676265 | 1676265 | 2021-09-01 | Scott | Tennessee | 47151 | 3794 | 50 |
1665288 | 1665288 | 2021-08-29 | Lyon | Minnesota | 27083 | 3794 | 54 |
1662040 | 1662040 | 2021-08-28 | Lyon | Minnesota | 27083 | 3794 | 54 |
1658792 | 1658792 | 2021-08-27 | Lyon | Minnesota | 27083 | 3794 | 54 |
1649534 | 1649534 | 2021-08-24 | Chenango | New York | 36017 | 3794 | 82 |
1606867 | 1606867 | 2021-08-11 | Alcorn | Mississippi | 28003 | 3794 | 75 |
1564138 | 1564138 | 2021-07-29 | Ellis | Kansas | 20051 | 3794 | 73 |
1560890 | 1560890 | 2021-07-28 | Ellis | Kansas | 20051 | 3794 | 73 |
1534582 | 1534582 | 2021-07-20 | Nez Perce | Idaho | 16069 | 3794 | 60 |
1533365 | 1533365 | 2021-07-19 | White | Tennessee | 47185 | 3794 | 74 |
1519314 | 1519314 | 2021-07-15 | Marion | Missouri | 29127 | 3794 | 53 |
1511565 | 1511565 | 2021-07-13 | Summit | Colorado | 8117 | 3794 | 8 |
1494403 | 1494403 | 2021-07-07 | White | Tennessee | 47185 | 3794 | 74 |
1485895 | 1485895 | 2021-07-05 | Bureau | Illinois | 17011 | 3794 | 98 |
1482649 | 1482649 | 2021-07-04 | Bureau | Illinois | 17011 | 3794 | 98 |
1479402 | 1479402 | 2021-07-03 | Bureau | Illinois | 17011 | 3794 | 98 |
1476156 | 1476156 | 2021-07-02 | Bureau | Illinois | 17011 | 3794 | 98 |
1475369 | 1475369 | 2021-07-01 | Douglas | Washington | 53017 | 3794 | 23 |
1470891 | 1470891 | 2021-06-30 | Rio Arriba | New Mexico | 35039 | 3794 | 79 |
1452207 | 1452207 | 2021-06-24 | White | Tennessee | 47185 | 3794 | 73 |
1448961 | 1448961 | 2021-06-23 | White | Tennessee | 47185 | 3794 | 73 |
1443765 | 1443765 | 2021-06-22 | Montgomery | Illinois | 17135 | 3794 | 80 |
1437273 | 1437273 | 2021-06-20 | Montgomery | Illinois | 17135 | 3794 | 80 |
1434026 | 1434026 | 2021-06-19 | Montgomery | Illinois | 17135 | 3794 | 80 |
1430780 | 1430780 | 2021-06-18 | Montgomery | Illinois | 17135 | 3794 | 80 |
1426292 | 1426292 | 2021-06-16 | Cooke | Texas | 48097 | 3794 | 72 |
1423045 | 1423045 | 2021-06-15 | Cooke | Texas | 48097 | 3794 | 72 |
1423432 | 1423432 | 2021-06-15 | York | Virginia | 51199 | 3794 | 55 |
1417126 | 1417126 | 2021-06-13 | Teton | Wyoming | 56039 | 3794 | 11 |
1413880 | 1413880 | 2021-06-12 | Teton | Wyoming | 56039 | 3794 | 11 |
1410635 | 1410635 | 2021-06-11 | Teton | Wyoming | 56039 | 3794 | 11 |
1371835 | 1371835 | 2021-05-31 | Independence | Arkansas | 5063 | 3794 | 124 |
1373587 | 1373587 | 2021-05-31 | Tioga | New York | 36107 | 3794 | 62 |
1368590 | 1368590 | 2021-05-30 | Independence | Arkansas | 5063 | 3794 | 124 |
1365344 | 1365344 | 2021-05-29 | Independence | Arkansas | 5063 | 3794 | 124 |
1362098 | 1362098 | 2021-05-28 | Independence | Arkansas | 5063 | 3794 | 124 |
1337763 | 1337763 | 2021-05-20 | Cheshire | New Hampshire | 33005 | 3794 | 33 |
1328493 | 1328493 | 2021-05-17 | Polk | Oregon | 41053 | 3794 | 53 |
1299918 | 1299918 | 2021-05-08 | Sanpete | Utah | 49039 | 3794 | 22 |
1286351 | 1286351 | 2021-05-04 | Pike | Pennsylvania | 42103 | 3794 | 54 |
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);