ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where cases = 3626 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Georgia 10
- Missouri 10
- Florida 9
- Indiana 8
- Illinois 7
- Wyoming 7
- Kansas 5
- North Carolina 5
- Virginia 5
- Oregon 4
- Puerto Rico 4
- South Carolina 4
- Tennessee 4
- Iowa 3
- Mississippi 3
- Pennsylvania 3
- West Virginia 3
- Wisconsin 3
- Arkansas 2
- California 2
- Kentucky 2
- Louisiana 2
- Michigan 2
- Minnesota 2
- Nebraska 2
- New Mexico 2
- Ohio 2
- Idaho 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500472 | 2500472 | 2022-05-13 | Wright | Iowa | 19197 | 3626 | 63 |
2497214 | 2497214 | 2022-05-12 | Wright | Iowa | 19197 | 3626 | 63 |
2493956 | 2493956 | 2022-05-11 | Wright | Iowa | 19197 | 3626 | 63 |
2465992 | 2465992 | 2022-05-02 | Hood River | Oregon | 41027 | 3626 | 43 |
2448650 | 2448650 | 2022-04-27 | West Carroll | Louisiana | 22123 | 3626 | 66 |
2439592 | 2439592 | 2022-04-24 | Schuyler | New York | 36097 | 3626 | 25 |
2353005 | 2353005 | 2022-03-28 | Lafayette | Wisconsin | 55065 | 3626 | 22 |
2340041 | 2340041 | 2022-03-24 | Goshen | Wyoming | 56015 | 3626 | 56 |
2336788 | 2336788 | 2022-03-23 | Goshen | Wyoming | 56015 | 3626 | 56 |
2332557 | 2332557 | 2022-03-22 | Tillamook | Oregon | 41057 | 3626 | 60 |
2333534 | 2333534 | 2022-03-22 | Goshen | Wyoming | 56015 | 3626 | 56 |
2330280 | 2330280 | 2022-03-21 | Goshen | Wyoming | 56015 | 3626 | 56 |
2327028 | 2327028 | 2022-03-20 | Goshen | Wyoming | 56015 | 3626 | 56 |
2323775 | 2323775 | 2022-03-19 | Goshen | Wyoming | 56015 | 3626 | 56 |
2320521 | 2320521 | 2022-03-18 | Goshen | Wyoming | 56015 | 3626 | 56 |
2315590 | 2315590 | 2022-03-17 | Macon | Missouri | 29121 | 3626 | 53 |
2266638 | 2266638 | 2022-03-02 | Renville | Minnesota | 27129 | 3626 | 56 |
2242960 | 2242960 | 2022-02-23 | Jefferson | Georgia | 13163 | 3626 | 105 |
2239747 | 2239747 | 2022-02-22 | Rabun | Georgia | 13241 | 3626 | 90 |
2240840 | 2240840 | 2022-02-22 | Ste. Genevieve | Missouri | 29186 | 3626 | 37 |
2216001 | 2216001 | 2022-02-14 | Leon | Texas | 48289 | 3626 | 84 |
2199746 | 2199746 | 2022-02-09 | Madison | Texas | 48313 | 3626 | 50 |
2148774 | 2148774 | 2022-01-25 | Carroll | Illinois | 17015 | 3626 | 45 |
2138524 | 2138524 | 2022-01-22 | Clay | Arkansas | 5021 | 3626 | 77 |
2131169 | 2131169 | 2022-01-19 | Union | South Dakota | 46127 | 3626 | 47 |
2127302 | 2127302 | 2022-01-18 | Bertie | North Carolina | 37015 | 3626 | 57 |
2108848 | 2108848 | 2022-01-12 | Fluvanna | Virginia | 51065 | 3626 | 33 |
2084221 | 2084221 | 2022-01-05 | Rockcastle | Kentucky | 21203 | 3626 | 48 |
2085504 | 2085504 | 2022-01-05 | Naranjito | Puerto Rico | 72105 | 3626 | |
2034534 | 2034534 | 2021-12-21 | Randolph | Arkansas | 5121 | 3626 | 65 |
2031855 | 2031855 | 2021-12-20 | Jay | Indiana | 18075 | 3626 | 59 |
1991860 | 1991860 | 2021-12-07 | Mecklenburg | Virginia | 51117 | 3626 | 91 |
1933044 | 1933044 | 2021-11-19 | Fayette | Texas | 48149 | 3626 | 93 |
1929793 | 1929793 | 2021-11-18 | Fayette | Texas | 48149 | 3626 | 93 |
1892033 | 1892033 | 2021-11-07 | Shelby | Illinois | 17173 | 3626 | 53 |
1888783 | 1888783 | 2021-11-06 | Shelby | Illinois | 17173 | 3626 | 53 |
1885533 | 1885533 | 2021-11-05 | Shelby | Illinois | 17173 | 3626 | 53 |
1863628 | 1863628 | 2021-10-29 | Crawford | Missouri | 29055 | 3626 | 57 |
1860352 | 1860352 | 2021-10-28 | Adair | Missouri | 29001 | 3626 | 34 |
1857103 | 1857103 | 2021-10-27 | Adair | Missouri | 29001 | 3626 | 34 |
1858658 | 1858658 | 2021-10-27 | Waynesboro city | Virginia | 51820 | 3626 | 45 |
1846312 | 1846312 | 2021-10-24 | Grady | Georgia | 13131 | 3626 | 88 |
1846764 | 1846764 | 2021-10-24 | Cherokee | Kansas | 20021 | 3626 | 77 |
1843062 | 1843062 | 2021-10-23 | Grady | Georgia | 13131 | 3626 | 88 |
1843514 | 1843514 | 2021-10-23 | Cherokee | Kansas | 20021 | 3626 | 77 |
1839812 | 1839812 | 2021-10-22 | Grady | Georgia | 13131 | 3626 | 88 |
1840264 | 1840264 | 2021-10-22 | Cherokee | Kansas | 20021 | 3626 | 77 |
1813285 | 1813285 | 2021-10-13 | Door | Wisconsin | 55029 | 3626 | 38 |
1791523 | 1791523 | 2021-10-07 | Barton | Kansas | 20009 | 3626 | 56 |
1788274 | 1788274 | 2021-10-06 | Barton | Kansas | 20009 | 3626 | 56 |
1760919 | 1760919 | 2021-09-27 | Milam | Texas | 48331 | 3626 | 71 |
1757671 | 1757671 | 2021-09-26 | Milam | Texas | 48331 | 3626 | 71 |
1754423 | 1754423 | 2021-09-25 | Milam | Texas | 48331 | 3626 | 71 |
1751175 | 1751175 | 2021-09-24 | Milam | Texas | 48331 | 3626 | 70 |
1742347 | 1742347 | 2021-09-22 | Haralson | Georgia | 13143 | 3626 | 101 |
1717502 | 1717502 | 2021-09-14 | Washington | Missouri | 29221 | 3626 | 57 |
1715087 | 1715087 | 2021-09-13 | Jasper | South Carolina | 45053 | 3626 | 61 |
1696924 | 1696924 | 2021-09-08 | Sumter | Georgia | 13261 | 3626 | 111 |
1690683 | 1690683 | 2021-09-06 | Scott | Indiana | 18143 | 3626 | 63 |
1687433 | 1687433 | 2021-09-05 | Scott | Indiana | 18143 | 3626 | 63 |
1683605 | 1683605 | 2021-09-04 | Glenn | California | 6021 | 3626 | 31 |
1684183 | 1684183 | 2021-09-04 | Scott | Indiana | 18143 | 3626 | 63 |
1685707 | 1685707 | 2021-09-04 | Jefferson | Pennsylvania | 42065 | 3626 | 100 |
1680932 | 1680932 | 2021-09-03 | Scott | Indiana | 18143 | 3626 | 63 |
1668621 | 1668621 | 2021-08-30 | Leake | Mississippi | 28079 | 3626 | 80 |
1666354 | 1666354 | 2021-08-29 | Edgefield | South Carolina | 45037 | 3626 | 45 |
1663106 | 1663106 | 2021-08-28 | Edgefield | South Carolina | 45037 | 3626 | 45 |
1659858 | 1659858 | 2021-08-27 | Edgefield | South Carolina | 45037 | 3626 | 45 |
1648163 | 1648163 | 2021-08-24 | Lumpkin | Georgia | 13187 | 3626 | 83 |
1632509 | 1632509 | 2021-08-19 | Marshall | Kentucky | 21157 | 3626 | 65 |
1625424 | 1625424 | 2021-08-17 | Madison | Georgia | 13195 | 3626 | 57 |
1622257 | 1622257 | 2021-08-16 | Bonner | Idaho | 16017 | 3626 | 46 |
1610516 | 1610516 | 2021-08-12 | Cibola | New Mexico | 35006 | 3626 | 128 |
1563563 | 1563563 | 2021-07-29 | Hardee | Florida | 12049 | 3626 | 45 |
1560315 | 1560315 | 2021-07-28 | Hardee | Florida | 12049 | 3626 | 45 |
1557068 | 1557068 | 2021-07-27 | Hardee | Florida | 12049 | 3626 | 45 |
1553821 | 1553821 | 2021-07-26 | Hardee | Florida | 12049 | 3626 | 45 |
1550574 | 1550574 | 2021-07-25 | Hardee | Florida | 12049 | 3626 | 45 |
1547327 | 1547327 | 2021-07-24 | Hardee | Florida | 12049 | 3626 | 45 |
1549834 | 1549834 | 2021-07-24 | Upshur | Texas | 48459 | 3626 | 78 |
1544080 | 1544080 | 2021-07-23 | Hardee | Florida | 12049 | 3626 | 45 |
1523099 | 1523099 | 2021-07-16 | Highland | Ohio | 39071 | 3626 | 68 |
1464150 | 1464150 | 2021-06-28 | Pulaski | Missouri | 29169 | 3626 | 55 |
1376891 | 1376891 | 2021-06-01 | Jackson | North Carolina | 37099 | 3626 | 56 |
1338381 | 1338381 | 2021-05-20 | Trujillo Alto | Puerto Rico | 72139 | 3626 | |
1335134 | 1335134 | 2021-05-19 | Trujillo Alto | Puerto Rico | 72139 | 3626 | |
1331047 | 1331047 | 2021-05-18 | Marion | Missouri | 29127 | 3626 | 50 |
1327800 | 1327800 | 2021-05-17 | Marion | Missouri | 29127 | 3626 | 45 |
1324554 | 1324554 | 2021-05-16 | Marion | Missouri | 29127 | 3626 | 45 |
1318782 | 1318782 | 2021-05-14 | Clinton | Pennsylvania | 42035 | 3626 | 63 |
1316301 | 1316301 | 2021-05-13 | Tazewell | Virginia | 51185 | 3626 | 70 |
1309296 | 1309296 | 2021-05-11 | Carroll | Tennessee | 47017 | 3626 | 83 |
1289903 | 1289903 | 2021-05-05 | White | Tennessee | 47185 | 3626 | 69 |
1267769 | 1267769 | 2021-04-28 | Trempealeau | Wisconsin | 55121 | 3626 | 44 |
1235521 | 1235521 | 2021-04-19 | Amador | California | 6005 | 3626 | 46 |
1206769 | 1206769 | 2021-04-10 | Montgomery | Illinois | 17135 | 3626 | 77 |
1197525 | 1197525 | 2021-04-07 | St. John the Baptist | Louisiana | 22095 | 3626 | 137 |
1192532 | 1192532 | 2021-04-05 | Cooke | Texas | 48097 | 3626 | 69 |
1189283 | 1189283 | 2021-04-04 | Cooke | Texas | 48097 | 3626 | 69 |
1186036 | 1186036 | 2021-04-03 | Cooke | Texas | 48097 | 3626 | 68 |
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);