ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where cases = 4193 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 18
- Georgia 9
- Texas 9
- Florida 8
- Missouri 8
- Louisiana 7
- Mississippi 7
- Wisconsin 7
- Ohio 6
- Colorado 4
- Indiana 4
- Pennsylvania 4
- Utah 4
- Virginia 4
- West Virginia 4
- Alabama 3
- Alaska 3
- Arkansas 3
- Iowa 3
- Kentucky 3
- North Carolina 3
- Kansas 2
- Minnesota 2
- California 1
- Michigan 1
- New Mexico 1
- New York 1
- North Dakota 1
- Oklahoma 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463625 | 2463625 | 2022-05-01 | Monroe | West Virginia | 54063 | 4193 | 46 |
2460369 | 2460369 | 2022-04-30 | Monroe | West Virginia | 54063 | 4193 | 46 |
2457113 | 2457113 | 2022-04-29 | Monroe | West Virginia | 54063 | 4193 | 46 |
2326698 | 2326698 | 2022-03-20 | Unknown | Utah | 4193 | 80 | |
2323445 | 2323445 | 2022-03-19 | Unknown | Utah | 4193 | 80 | |
2320191 | 2320191 | 2022-03-18 | Unknown | Utah | 4193 | 80 | |
2305681 | 2305681 | 2022-03-14 | Wadena | Minnesota | 27159 | 4193 | 52 |
2302170 | 2302170 | 2022-03-13 | LaSalle | Louisiana | 22059 | 4193 | 53 |
2298918 | 2298918 | 2022-03-12 | LaSalle | Louisiana | 22059 | 4193 | 53 |
2295666 | 2295666 | 2022-03-11 | LaSalle | Louisiana | 22059 | 4193 | 53 |
2268789 | 2268789 | 2022-03-03 | Otero | Colorado | 8089 | 4193 | 125 |
2268152 | 2268152 | 2022-03-02 | Unknown | Utah | 4193 | 75 | |
2261911 | 2261911 | 2022-02-28 | Crawford | Wisconsin | 55023 | 4193 | 28 |
2187285 | 2187285 | 2022-02-06 | Nome Census Area | Alaska | 2180 | 4193 | 3 |
2184032 | 2184032 | 2022-02-05 | Nome Census Area | Alaska | 2180 | 4193 | 3 |
2180780 | 2180780 | 2022-02-04 | Nome Census Area | Alaska | 2180 | 4193 | 3 |
2154870 | 2154870 | 2022-01-27 | Inyo | California | 6027 | 4193 | 50 |
2128813 | 2128813 | 2022-01-19 | Randolph | Arkansas | 5121 | 4193 | 69 |
2109254 | 2109254 | 2022-01-13 | Conway | Arkansas | 5029 | 4193 | 50 |
2108249 | 2108249 | 2022-01-12 | Juana Diaz | Puerto Rico | 72075 | 4193 | |
2103245 | 2103245 | 2022-01-11 | Crawford | Illinois | 17033 | 4193 | 52 |
2028549 | 2028549 | 2021-12-19 | Shelby | Illinois | 17173 | 4193 | 57 |
2025298 | 2025298 | 2021-12-18 | Shelby | Illinois | 17173 | 4193 | 57 |
2022047 | 2022047 | 2021-12-17 | Shelby | Illinois | 17173 | 4193 | 57 |
2016432 | 2016432 | 2021-12-15 | Nodaway | Missouri | 29147 | 4193 | 37 |
1989778 | 1989778 | 2021-12-07 | Franklin | Kansas | 20059 | 4193 | 63 |
1990353 | 1990353 | 2021-12-07 | Audrain | Missouri | 29007 | 4193 | 79 |
1986528 | 1986528 | 2021-12-06 | Franklin | Kansas | 20059 | 4193 | 63 |
1963352 | 1963352 | 2021-11-29 | Peach | Georgia | 13225 | 4193 | 113 |
1965097 | 1965097 | 2021-11-29 | Jefferson | Oregon | 41031 | 4193 | 66 |
1951944 | 1951944 | 2021-11-25 | Henry | Ohio | 39069 | 4193 | 74 |
1948693 | 1948693 | 2021-11-24 | Henry | Ohio | 39069 | 4193 | 74 |
1946274 | 1946274 | 2021-11-23 | Accomack | Virginia | 51001 | 4193 | 80 |
1851195 | 1851195 | 2021-10-25 | Gallia | Ohio | 39053 | 4193 | 67 |
1823051 | 1823051 | 2021-10-16 | Lincoln | Wisconsin | 55069 | 4193 | 106 |
1819802 | 1819802 | 2021-10-15 | Lincoln | Wisconsin | 55069 | 4193 | 106 |
1816553 | 1816553 | 2021-10-14 | Lincoln | Wisconsin | 55069 | 4193 | 106 |
1800371 | 1800371 | 2021-10-10 | Bibb | Alabama | 1007 | 4193 | 86 |
1785656 | 1785656 | 2021-10-05 | Dunklin | Missouri | 29069 | 4193 | 58 |
1782478 | 1782478 | 2021-10-04 | Stoddard | Missouri | 29207 | 4193 | 64 |
1774253 | 1774253 | 2021-10-01 | Mineral | West Virginia | 54057 | 4193 | 104 |
1762052 | 1762052 | 2021-09-28 | Perry | Illinois | 17145 | 4193 | 81 |
1706298 | 1706298 | 2021-09-11 | Johnson | Arkansas | 5071 | 4193 | 54 |
1690393 | 1690393 | 2021-09-06 | Madison | Georgia | 13195 | 4193 | 60 |
1687143 | 1687143 | 2021-09-05 | Madison | Georgia | 13195 | 4193 | 60 |
1683893 | 1683893 | 2021-09-04 | Madison | Georgia | 13195 | 4193 | 60 |
1680642 | 1680642 | 2021-09-03 | Madison | Georgia | 13195 | 4193 | 60 |
1677192 | 1677192 | 2021-09-02 | Logan | Colorado | 8075 | 4193 | 69 |
1679935 | 1679935 | 2021-09-02 | Prince George | Virginia | 51149 | 4193 | 33 |
1673168 | 1673168 | 2021-08-31 | Kendall | Texas | 48259 | 4193 | 78 |
1622220 | 1622220 | 2021-08-16 | Toombs | Georgia | 13279 | 4193 | 123 |
1619190 | 1619190 | 2021-08-15 | Knox | Indiana | 18083 | 4193 | 91 |
1615942 | 1615942 | 2021-08-14 | Knox | Indiana | 18083 | 4193 | 91 |
1612693 | 1612693 | 2021-08-13 | Knox | Indiana | 18083 | 4193 | 91 |
1609088 | 1609088 | 2021-08-12 | Wakulla | Florida | 12129 | 4193 | 56 |
1611024 | 1611024 | 2021-08-12 | Venango | Pennsylvania | 42121 | 4193 | 104 |
1605839 | 1605839 | 2021-08-11 | Wakulla | Florida | 12129 | 4193 | 56 |
1607767 | 1607767 | 2021-08-11 | Pike | Pennsylvania | 42103 | 4193 | 54 |
1602590 | 1602590 | 2021-08-10 | Wakulla | Florida | 12129 | 4193 | 56 |
1599341 | 1599341 | 2021-08-09 | Wakulla | Florida | 12129 | 4193 | 56 |
1596092 | 1596092 | 2021-08-08 | Wakulla | Florida | 12129 | 4193 | 56 |
1592843 | 1592843 | 2021-08-07 | Wakulla | Florida | 12129 | 4193 | 56 |
1589594 | 1589594 | 2021-08-06 | Wakulla | Florida | 12129 | 4193 | 56 |
1562297 | 1562297 | 2021-07-28 | Wayne | Pennsylvania | 42127 | 4193 | 84 |
1498554 | 1498554 | 2021-07-09 | La Plata | Colorado | 8067 | 4193 | 41 |
1496516 | 1496516 | 2021-07-08 | Union | Mississippi | 28145 | 4193 | 79 |
1466465 | 1466465 | 2021-06-29 | Lee | Illinois | 17103 | 4193 | 93 |
1450239 | 1450239 | 2021-06-24 | Lee | Illinois | 17103 | 4193 | 93 |
1446994 | 1446994 | 2021-06-23 | Lee | Illinois | 17103 | 4193 | 93 |
1443749 | 1443749 | 2021-06-22 | Lee | Illinois | 17103 | 4193 | 93 |
1440504 | 1440504 | 2021-06-21 | Lee | Illinois | 17103 | 4193 | 93 |
1440889 | 1440889 | 2021-06-21 | Franklin | Kentucky | 21073 | 4193 | 56 |
1437257 | 1437257 | 2021-06-20 | Lee | Illinois | 17103 | 4193 | 93 |
1434010 | 1434010 | 2021-06-19 | Lee | Illinois | 17103 | 4193 | 93 |
1430764 | 1430764 | 2021-06-18 | Lee | Illinois | 17103 | 4193 | 93 |
1410253 | 1410253 | 2021-06-11 | Washington | Texas | 48477 | 4193 | 94 |
1401554 | 1401554 | 2021-06-09 | Lee | Illinois | 17103 | 4193 | 92 |
1399644 | 1399644 | 2021-06-08 | Stokes | North Carolina | 37169 | 4193 | 79 |
1395062 | 1395062 | 2021-06-07 | Lee | Illinois | 17103 | 4193 | 92 |
1397270 | 1397270 | 2021-06-07 | Waller | Texas | 48473 | 4193 | 49 |
1391817 | 1391817 | 2021-06-06 | Lee | Illinois | 17103 | 4193 | 92 |
1351504 | 1351504 | 2021-05-24 | Campbell | Tennessee | 47013 | 4193 | 63 |
1348505 | 1348505 | 2021-05-23 | Matagorda | Texas | 48321 | 4193 | 112 |
1345257 | 1345257 | 2021-05-22 | Matagorda | Texas | 48321 | 4193 | 112 |
1317817 | 1317817 | 2021-05-14 | Sanilac | Michigan | 26151 | 4193 | 110 |
1314296 | 1314296 | 2021-05-13 | Graves | Kentucky | 21083 | 4193 | 93 |
1295671 | 1295671 | 2021-05-07 | Tompkins | New York | 36109 | 4193 | 50 |
1292000 | 1292000 | 2021-05-06 | Pontotoc | Mississippi | 28115 | 4193 | 72 |
1288754 | 1288754 | 2021-05-05 | Pontotoc | Mississippi | 28115 | 4193 | 72 |
1285508 | 1285508 | 2021-05-04 | Pontotoc | Mississippi | 28115 | 4193 | 72 |
1273112 | 1273112 | 2021-04-30 | Ashland | Ohio | 39005 | 4193 | 89 |
1258072 | 1258072 | 2021-04-26 | Chilton | Alabama | 1021 | 4193 | 111 |
1221223 | 1221223 | 2021-04-14 | Putnam | Ohio | 39137 | 4193 | 98 |
1166825 | 1166825 | 2021-03-28 | Campbell | Virginia | 51031 | 4193 | 81 |
1161687 | 1161687 | 2021-03-27 | Hopkins | Kentucky | 21107 | 4193 | 133 |
1129652 | 1129652 | 2021-03-17 | Warren | Mississippi | 28149 | 4193 | 116 |
1125544 | 1125544 | 2021-03-16 | Franklin | Illinois | 17055 | 4193 | 78 |
1096870 | 1096870 | 2021-03-07 | St. Mary | Louisiana | 22101 | 4193 | 122 |
1087373 | 1087373 | 2021-03-04 | Winona | Minnesota | 27169 | 4193 | 49 |
1087430 | 1087430 | 2021-03-04 | Pearl River | Mississippi | 28109 | 4193 | 132 |
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);