ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 4259 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 13
- Nebraska 10
- Kentucky 9
- Texas 9
- Oklahoma 8
- Illinois 7
- Tennessee 7
- Georgia 6
- Indiana 6
- Minnesota 5
- Mississippi 5
- New York 5
- North Carolina 5
- Ohio 5
- Louisiana 4
- West Virginia 4
- Arkansas 3
- Iowa 3
- Virginia 3
- Missouri 2
- Montana 2
- Wisconsin 2
- Wyoming 2
- California 1
- Delaware 1
- Florida 1
- New Mexico 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473029 | 2473029 | 2022-05-04 | Lavaca | Texas | 48285 | 4259 | 120 |
2431066 | 2431066 | 2022-04-21 | Morgan | West Virginia | 54065 | 4259 | 69 |
2347619 | 2347619 | 2022-03-27 | Jackson | Kentucky | 21109 | 4259 | 74 |
2344366 | 2344366 | 2022-03-26 | Jackson | Kentucky | 21109 | 4259 | 74 |
2341113 | 2341113 | 2022-03-25 | Jackson | Kentucky | 21109 | 4259 | 74 |
2337860 | 2337860 | 2022-03-24 | Jackson | Kentucky | 21109 | 4259 | 74 |
2334606 | 2334606 | 2022-03-23 | Jackson | Kentucky | 21109 | 4259 | 74 |
2331352 | 2331352 | 2022-03-22 | Jackson | Kentucky | 21109 | 4259 | 74 |
2328100 | 2328100 | 2022-03-21 | Jackson | Kentucky | 21109 | 4259 | 74 |
2283268 | 2283268 | 2022-03-07 | Unknown | Nebraska | 4259 | 475 | |
2271651 | 2271651 | 2022-03-03 | Wetzel | West Virginia | 54103 | 4259 | 80 |
2241734 | 2241734 | 2022-02-22 | Hughes | South Dakota | 46065 | 4259 | 58 |
2224894 | 2224894 | 2022-02-17 | Avery | North Carolina | 37011 | 4259 | 41 |
2222568 | 2222568 | 2022-02-16 | Shelby | Texas | 48419 | 4259 | 125 |
2213834 | 2213834 | 2022-02-14 | Bond | Illinois | 17005 | 4259 | 35 |
2198600 | 2198600 | 2022-02-09 | Hill | Montana | 30041 | 4259 | 71 |
2192073 | 2192073 | 2022-02-07 | Big Horn | Montana | 30003 | 4259 | 89 |
2187932 | 2187932 | 2022-02-06 | Franklin | Indiana | 18047 | 4259 | 60 |
2184679 | 2184679 | 2022-02-05 | Franklin | Indiana | 18047 | 4259 | 60 |
2181427 | 2181427 | 2022-02-04 | Franklin | Indiana | 18047 | 4259 | 60 |
2173255 | 2173255 | 2022-02-01 | Montour | Pennsylvania | 42093 | 4259 | 84 |
2155985 | 2155985 | 2022-01-27 | Roscommon | Michigan | 26143 | 4259 | 109 |
2152732 | 2152732 | 2022-01-26 | Roscommon | Michigan | 26143 | 4259 | 109 |
2142049 | 2142049 | 2022-01-23 | Appling | Georgia | 13001 | 4259 | 111 |
2138794 | 2138794 | 2022-01-22 | Appling | Georgia | 13001 | 4259 | 111 |
2135538 | 2135538 | 2022-01-21 | Appling | Georgia | 13001 | 4259 | 111 |
2125242 | 2125242 | 2022-01-17 | Brooke | West Virginia | 54009 | 4259 | 87 |
2109279 | 2109279 | 2022-01-13 | Lincoln | Arkansas | 5079 | 4259 | 59 |
2082310 | 2082310 | 2022-01-04 | Jasper | South Carolina | 45053 | 4259 | 82 |
2076790 | 2076790 | 2022-01-03 | Sevier | Arkansas | 5133 | 4259 | 63 |
2039176 | 2039176 | 2021-12-22 | McDonald | Missouri | 29119 | 4259 | 64 |
1987031 | 1987031 | 2021-12-06 | Coahoma | Mississippi | 28027 | 4259 | 110 |
1929642 | 1929642 | 2021-11-18 | DeKalb | Tennessee | 47041 | 4259 | 75 |
1869322 | 1869322 | 2021-10-31 | Decatur | Indiana | 18031 | 4259 | 110 |
1866073 | 1866073 | 2021-10-30 | Decatur | Indiana | 18031 | 4259 | 110 |
1862824 | 1862824 | 2021-10-29 | Decatur | Indiana | 18031 | 4259 | 110 |
1864191 | 1864191 | 2021-10-29 | Gallia | Ohio | 39053 | 4259 | 71 |
1856980 | 1856980 | 2021-10-27 | Mille Lacs | Minnesota | 27095 | 4259 | 67 |
1829549 | 1829549 | 2021-10-18 | Lincoln | Wisconsin | 55069 | 4259 | 107 |
1812244 | 1812244 | 2021-10-13 | Pike | Ohio | 39131 | 4259 | 58 |
1807065 | 1807065 | 2021-10-12 | Glenn | California | 6021 | 4259 | 39 |
1808471 | 1808471 | 2021-10-12 | Stoddard | Missouri | 29207 | 4259 | 67 |
1787251 | 1787251 | 2021-10-05 | Mineral | West Virginia | 54057 | 4259 | 106 |
1769760 | 1769760 | 2021-09-30 | Otsego | New York | 36077 | 4259 | 51 |
1756736 | 1756736 | 2021-09-26 | Chenango | New York | 36017 | 4259 | 86 |
1741688 | 1741688 | 2021-09-21 | Warren | Virginia | 51187 | 4259 | 68 |
1719134 | 1719134 | 2021-09-14 | Sheridan | Wyoming | 56033 | 4259 | 38 |
1708557 | 1708557 | 2021-09-11 | Vega Baja | Puerto Rico | 72145 | 4259 | |
1696888 | 1696888 | 2021-09-08 | Lumpkin | Georgia | 13187 | 4259 | 86 |
1695135 | 1695135 | 2021-09-07 | Person | North Carolina | 37145 | 4259 | 77 |
1628797 | 1628797 | 2021-08-18 | Christian | Illinois | 17021 | 4259 | 94 |
1610768 | 1610768 | 2021-08-12 | Brown | Ohio | 39015 | 4259 | 63 |
1601509 | 1601509 | 2021-08-09 | Giles | Tennessee | 47055 | 4259 | 99 |
1530117 | 1530117 | 2021-07-18 | Weakley | Tennessee | 47183 | 4259 | 69 |
1526870 | 1526870 | 2021-07-17 | Weakley | Tennessee | 47183 | 4259 | 69 |
1523623 | 1523623 | 2021-07-16 | Weakley | Tennessee | 47183 | 4259 | 69 |
1519743 | 1519743 | 2021-07-15 | Stokes | North Carolina | 37169 | 4259 | 81 |
1509388 | 1509388 | 2021-07-12 | Morrison | Minnesota | 27097 | 4259 | 62 |
1496404 | 1496404 | 2021-07-08 | Morrison | Minnesota | 27097 | 4259 | 62 |
1493157 | 1493157 | 2021-07-07 | Morrison | Minnesota | 27097 | 4259 | 62 |
1490407 | 1490407 | 2021-07-06 | Montgomery | New York | 36057 | 4259 | 128 |
1487160 | 1487160 | 2021-07-05 | Montgomery | New York | 36057 | 4259 | 127 |
1483914 | 1483914 | 2021-07-04 | Montgomery | New York | 36057 | 4259 | 127 |
1470239 | 1470239 | 2021-06-30 | Webster | Louisiana | 22119 | 4259 | 114 |
1467128 | 1467128 | 2021-06-29 | Sanilac | Michigan | 26151 | 4259 | 125 |
1463883 | 1463883 | 2021-06-28 | Sanilac | Michigan | 26151 | 4259 | 125 |
1460638 | 1460638 | 2021-06-27 | Sanilac | Michigan | 26151 | 4259 | 125 |
1457393 | 1457393 | 2021-06-26 | Sanilac | Michigan | 26151 | 4259 | 125 |
1454148 | 1454148 | 2021-06-25 | Sanilac | Michigan | 26151 | 4259 | 125 |
1450903 | 1450903 | 2021-06-24 | Sanilac | Michigan | 26151 | 4259 | 125 |
1447657 | 1447657 | 2021-06-23 | Sanilac | Michigan | 26151 | 4259 | 125 |
1444412 | 1444412 | 2021-06-22 | Sanilac | Michigan | 26151 | 4259 | 125 |
1444568 | 1444568 | 2021-06-22 | Pontotoc | Mississippi | 28115 | 4259 | 73 |
1445959 | 1445959 | 2021-06-22 | Wharton | Texas | 48481 | 4259 | 117 |
1441323 | 1441323 | 2021-06-21 | Pontotoc | Mississippi | 28115 | 4259 | 73 |
1422568 | 1422568 | 2021-06-15 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1419322 | 1419322 | 2021-06-14 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1416077 | 1416077 | 2021-06-13 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1412831 | 1412831 | 2021-06-12 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1409586 | 1409586 | 2021-06-11 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1406341 | 1406341 | 2021-06-10 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1403095 | 1403095 | 2021-06-09 | Mayes | Oklahoma | 40097 | 4259 | 72 |
1388726 | 1388726 | 2021-06-05 | Buena Vista | Iowa | 19021 | 4259 | 40 |
1378990 | 1378990 | 2021-06-02 | Buena Vista | Iowa | 19021 | 4259 | 40 |
1377597 | 1377597 | 2021-06-01 | Cherokee | Texas | 48073 | 4259 | 142 |
1374351 | 1374351 | 2021-05-31 | Cherokee | Texas | 48073 | 4259 | 142 |
1371106 | 1371106 | 2021-05-30 | Cherokee | Texas | 48073 | 4259 | 142 |
1367860 | 1367860 | 2021-05-29 | Cherokee | Texas | 48073 | 4259 | 142 |
1364614 | 1364614 | 2021-05-28 | Cherokee | Texas | 48073 | 4259 | 142 |
1325056 | 1325056 | 2021-05-16 | Ashland | Ohio | 39005 | 4259 | 90 |
1318587 | 1318587 | 2021-05-14 | Fulton | Ohio | 39051 | 4259 | 69 |
1294416 | 1294416 | 2021-05-07 | Jefferson | Illinois | 17081 | 4259 | 121 |
1255700 | 1255700 | 2021-04-25 | Wapello | Iowa | 19179 | 4259 | 122 |
1248476 | 1248476 | 2021-04-23 | Miller | Arkansas | 5091 | 4259 | 36 |
1201067 | 1201067 | 2021-04-08 | Marshall | Mississippi | 28093 | 4259 | 100 |
1197411 | 1197411 | 2021-04-07 | Hopkins | Kentucky | 21107 | 4259 | 141 |
1167817 | 1167817 | 2021-03-29 | Stephenson | Illinois | 17177 | 4259 | 98 |
1169128 | 1169128 | 2021-03-29 | Watauga | North Carolina | 37189 | 4259 | 30 |
1158703 | 1158703 | 2021-03-26 | Shiawassee | Michigan | 26155 | 4259 | 84 |
1152170 | 1152170 | 2021-03-24 | Isabella | Michigan | 26073 | 4259 | 76 |
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);