ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 3947 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 10
- Illinois 9
- Tennessee 9
- Wisconsin 9
- Kansas 8
- Indiana 7
- Mississippi 7
- Texas 7
- Georgia 5
- Virginia 5
- Wyoming 5
- Alabama 4
- Colorado 4
- Ohio 4
- Kentucky 3
- Louisiana 3
- Michigan 3
- Missouri 3
- North Carolina 3
- Puerto Rico 3
- South Dakota 3
- Florida 2
- Maryland 2
- Minnesota 2
- Arizona 1
- Arkansas 1
- California 1
- Idaho 1
- New Hampshire 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430308 | 2430308 | 2022-04-21 | Lares | Puerto Rico | 72081 | 3947 | |
2387945 | 2387945 | 2022-04-08 | Aguas Buenas | Puerto Rico | 72007 | 3947 | |
2313941 | 2313941 | 2022-03-16 | Burnett | Wisconsin | 55013 | 3947 | 42 |
2310688 | 2310688 | 2022-03-15 | Burnett | Wisconsin | 55013 | 3947 | 42 |
2293725 | 2293725 | 2022-03-10 | Saluda | South Carolina | 45081 | 3947 | 74 |
2281479 | 2281479 | 2022-03-06 | Washburn | Wisconsin | 55129 | 3947 | 45 |
2278226 | 2278226 | 2022-03-05 | Washburn | Wisconsin | 55129 | 3947 | 45 |
2274973 | 2274973 | 2022-03-04 | Washburn | Wisconsin | 55129 | 3947 | 45 |
2264555 | 2264555 | 2022-03-01 | Grundy | Tennessee | 47061 | 3947 | 68 |
2261305 | 2261305 | 2022-02-28 | Grundy | Tennessee | 47061 | 3947 | 68 |
2258054 | 2258054 | 2022-02-27 | Grundy | Tennessee | 47061 | 3947 | 68 |
2258732 | 2258732 | 2022-02-27 | Lincoln | Wyoming | 56023 | 3947 | 28 |
2254803 | 2254803 | 2022-02-26 | Grundy | Tennessee | 47061 | 3947 | 68 |
2255481 | 2255481 | 2022-02-26 | Lincoln | Wyoming | 56023 | 3947 | 28 |
2251552 | 2251552 | 2022-02-25 | Grundy | Tennessee | 47061 | 3947 | 68 |
2252230 | 2252230 | 2022-02-25 | Lincoln | Wyoming | 56023 | 3947 | 28 |
2248301 | 2248301 | 2022-02-24 | Grundy | Tennessee | 47061 | 3947 | 68 |
2245050 | 2245050 | 2022-02-23 | Grundy | Tennessee | 47061 | 3947 | 68 |
2236683 | 2236683 | 2022-02-21 | Warren | Illinois | 17187 | 3947 | 82 |
2233432 | 2233432 | 2022-02-20 | Warren | Illinois | 17187 | 3947 | 82 |
2230181 | 2230181 | 2022-02-19 | Warren | Illinois | 17187 | 3947 | 82 |
2226930 | 2226930 | 2022-02-18 | Warren | Illinois | 17187 | 3947 | 82 |
2187875 | 2187875 | 2022-02-06 | Moultrie | Illinois | 17139 | 3947 | 50 |
2184622 | 2184622 | 2022-02-05 | Moultrie | Illinois | 17139 | 3947 | 50 |
2181370 | 2181370 | 2022-02-04 | Moultrie | Illinois | 17139 | 3947 | 50 |
2125818 | 2125818 | 2022-01-18 | Crisp | Georgia | 13081 | 3947 | 123 |
2099910 | 2099910 | 2022-01-10 | Union | Georgia | 13291 | 3947 | 132 |
2086307 | 2086307 | 2022-01-05 | Langlade | Wisconsin | 55067 | 3947 | 66 |
2080016 | 2080016 | 2022-01-04 | Lincoln | Arkansas | 5079 | 3947 | 59 |
2053266 | 2053266 | 2021-12-26 | Calhoun | Texas | 48057 | 3947 | 39 |
2050016 | 2050016 | 2021-12-25 | Calhoun | Texas | 48057 | 3947 | 39 |
2046766 | 2046766 | 2021-12-24 | Calhoun | Texas | 48057 | 3947 | 39 |
2043516 | 2043516 | 2021-12-23 | Calhoun | Texas | 48057 | 3947 | 39 |
2033023 | 2033023 | 2021-12-20 | Ashe | North Carolina | 37009 | 3947 | 58 |
2014176 | 2014176 | 2021-12-14 | Haywood | Tennessee | 47075 | 3947 | 79 |
1998412 | 1998412 | 2021-12-09 | Winchester city | Virginia | 51840 | 3947 | 57 |
1982639 | 1982639 | 2021-12-05 | Montezuma | Colorado | 8083 | 3947 | 48 |
1979389 | 1979389 | 2021-12-04 | Montezuma | Colorado | 8083 | 3947 | 48 |
1976139 | 1976139 | 2021-12-03 | Montezuma | Colorado | 8083 | 3947 | 48 |
1970665 | 1970665 | 2021-12-01 | Otsego | Michigan | 26137 | 3947 | 68 |
1967415 | 1967415 | 2021-11-30 | Otsego | Michigan | 26137 | 3947 | 67 |
1968203 | 1968203 | 2021-11-30 | Holmes | Ohio | 39075 | 3947 | 140 |
1939324 | 1939324 | 2021-11-21 | Davison | South Dakota | 46035 | 3947 | 71 |
1936074 | 1936074 | 2021-11-20 | Davison | South Dakota | 46035 | 3947 | 71 |
1932824 | 1932824 | 2021-11-19 | Davison | South Dakota | 46035 | 3947 | 71 |
1921167 | 1921167 | 2021-11-16 | Cassia | Idaho | 16031 | 3947 | 42 |
1916476 | 1916476 | 2021-11-14 | Mayaguez | Puerto Rico | 72097 | 3947 | |
1908700 | 1908700 | 2021-11-12 | Russell | Kentucky | 21207 | 3947 | 61 |
1905451 | 1905451 | 2021-11-11 | Russell | Kentucky | 21207 | 3947 | 61 |
1905719 | 1905719 | 2021-11-11 | Meeker | Minnesota | 27093 | 3947 | 55 |
1892567 | 1892567 | 2021-11-07 | Queen Anne's | Maryland | 24035 | 3947 | 73 |
1893790 | 1893790 | 2021-11-07 | Jasper | South Carolina | 45053 | 3947 | 81 |
1890540 | 1890540 | 2021-11-06 | Jasper | South Carolina | 45053 | 3947 | 81 |
1887290 | 1887290 | 2021-11-05 | Jasper | South Carolina | 45053 | 3947 | 81 |
1884040 | 1884040 | 2021-11-04 | Jasper | South Carolina | 45053 | 3947 | 81 |
1884578 | 1884578 | 2021-11-04 | Halifax | Virginia | 51083 | 3947 | 108 |
1880791 | 1880791 | 2021-11-03 | Jasper | South Carolina | 45053 | 3947 | 81 |
1877542 | 1877542 | 2021-11-02 | Jasper | South Carolina | 45053 | 3947 | 81 |
1874293 | 1874293 | 2021-11-01 | Jasper | South Carolina | 45053 | 3947 | 81 |
1814543 | 1814543 | 2021-10-14 | Union | Louisiana | 22111 | 3947 | 103 |
1801933 | 1801933 | 2021-10-10 | Miller | Missouri | 29131 | 3947 | 75 |
1798684 | 1798684 | 2021-10-09 | Miller | Missouri | 29131 | 3947 | 75 |
1766006 | 1766006 | 2021-09-29 | Nicollet | Minnesota | 27103 | 3947 | 49 |
1761879 | 1761879 | 2021-09-28 | Peach | Georgia | 13225 | 3947 | 88 |
1725641 | 1725641 | 2021-09-17 | Bibb | Alabama | 1007 | 3947 | 76 |
1702794 | 1702794 | 2021-09-09 | Randolph | West Virginia | 54083 | 3947 | 25 |
1689836 | 1689836 | 2021-09-05 | Green | Wisconsin | 55045 | 3947 | 26 |
1685482 | 1685482 | 2021-09-04 | Champaign | Ohio | 39021 | 3947 | 61 |
1686586 | 1686586 | 2021-09-04 | Green | Wisconsin | 55045 | 3947 | 26 |
1683336 | 1683336 | 2021-09-03 | Green | Wisconsin | 55045 | 3947 | 26 |
1678401 | 1678401 | 2021-09-02 | Wayne | Mississippi | 28153 | 3947 | 58 |
1665335 | 1665335 | 2021-08-29 | Adams | Mississippi | 28001 | 3947 | 105 |
1662087 | 1662087 | 2021-08-28 | Adams | Mississippi | 28001 | 3947 | 105 |
1658839 | 1658839 | 2021-08-27 | Adams | Mississippi | 28001 | 3947 | 105 |
1632580 | 1632580 | 2021-08-19 | Jefferson Davis | Louisiana | 22053 | 3947 | 103 |
1614262 | 1614262 | 2021-08-13 | Perry | Pennsylvania | 42099 | 3947 | 101 |
1596475 | 1596475 | 2021-08-08 | Putnam | Indiana | 18133 | 3947 | 63 |
1593226 | 1593226 | 2021-08-07 | Putnam | Indiana | 18133 | 3947 | 63 |
1589977 | 1589977 | 2021-08-06 | Putnam | Indiana | 18133 | 3947 | 63 |
1588631 | 1588631 | 2021-08-05 | Cooke | Texas | 48097 | 3947 | 72 |
1548541 | 1548541 | 2021-07-24 | Marion | Missouri | 29127 | 3947 | 53 |
1519741 | 1519741 | 2021-07-15 | Scotland | North Carolina | 37165 | 3947 | 88 |
1369102 | 1369102 | 2021-05-30 | Logan | Illinois | 17107 | 3947 | 75 |
1323732 | 1323732 | 2021-05-16 | Huntington | Indiana | 18069 | 3947 | 82 |
1319775 | 1319775 | 2021-05-15 | Escambia | Alabama | 1053 | 3947 | 77 |
1294570 | 1294570 | 2021-05-07 | Whitley | Indiana | 18183 | 3947 | 39 |
1291985 | 1291985 | 2021-05-06 | Lincoln | Mississippi | 28085 | 3947 | 110 |
1287566 | 1287566 | 2021-05-05 | Logan | Colorado | 8075 | 3947 | 67 |
1284950 | 1284950 | 2021-05-04 | Cowley | Kansas | 20035 | 3947 | 107 |
1285817 | 1285817 | 2021-05-04 | Belknap | New Hampshire | 33001 | 3947 | 98 |
1281703 | 1281703 | 2021-05-03 | Cowley | Kansas | 20035 | 3947 | 107 |
1283614 | 1283614 | 2021-05-03 | Rusk | Texas | 48401 | 3947 | 107 |
1236315 | 1236315 | 2021-04-19 | Seward | Kansas | 20175 | 3947 | 41 |
1233068 | 1233068 | 2021-04-18 | Seward | Kansas | 20175 | 3947 | 41 |
1229819 | 1229819 | 2021-04-17 | Seward | Kansas | 20175 | 3947 | 40 |
1226571 | 1226571 | 2021-04-16 | Seward | Kansas | 20175 | 3947 | 40 |
1223324 | 1223324 | 2021-04-15 | Seward | Kansas | 20175 | 3947 | 40 |
1202066 | 1202066 | 2021-04-08 | Williamsburg | South Carolina | 45089 | 3947 | 97 |
1177079 | 1177079 | 2021-04-01 | Mendocino | California | 6045 | 3947 | 46 |
1147621 | 1147621 | 2021-03-22 | Albany | Wyoming | 56001 | 3947 | 11 |
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);