ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 4409 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 16
- Michigan 14
- Georgia 9
- Kentucky 9
- Mississippi 9
- Illinois 8
- Oklahoma 7
- Ohio 6
- Indiana 5
- Minnesota 4
- New York 4
- North Carolina 4
- Texas 4
- California 3
- Florida 3
- Pennsylvania 3
- West Virginia 3
- Alabama 2
- Arkansas 2
- Colorado 2
- Maine 2
- Missouri 2
- New Mexico 2
- Wisconsin 2
- Idaho 1
- Massachusetts 1
- Nevada 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500723 | 2500723 | 2022-05-13 | Jackson | Louisiana | 22049 | 4409 | 76 |
2497465 | 2497465 | 2022-05-12 | Jackson | Louisiana | 22049 | 4409 | 76 |
2493679 | 2493679 | 2022-05-11 | De Witt | Illinois | 17039 | 4409 | 45 |
2494207 | 2494207 | 2022-05-11 | Jackson | Louisiana | 22049 | 4409 | 76 |
2490949 | 2490949 | 2022-05-10 | Jackson | Louisiana | 22049 | 4409 | 76 |
2402509 | 2402509 | 2022-04-13 | Ford | Illinois | 17053 | 4409 | 73 |
2282696 | 2282696 | 2022-03-07 | Winn | Louisiana | 22127 | 4409 | 61 |
2260099 | 2260099 | 2022-02-28 | Houston | Minnesota | 27055 | 4409 | 18 |
2215464 | 2215464 | 2022-02-14 | Clatsop | Oregon | 41007 | 4409 | 38 |
2193887 | 2193887 | 2022-02-08 | Sharp | Arkansas | 5135 | 4409 | 89 |
2161055 | 2161055 | 2022-01-28 | McDowell | West Virginia | 54047 | 4409 | 58 |
2152159 | 2152159 | 2022-01-26 | Jay | Indiana | 18075 | 4409 | 72 |
2154118 | 2154118 | 2022-01-26 | Fayette | Texas | 48149 | 4409 | 96 |
2141196 | 2141196 | 2022-01-22 | Milam | Texas | 48331 | 4409 | 93 |
2132674 | 2132674 | 2022-01-20 | Starke | Indiana | 18149 | 4409 | 89 |
2126869 | 2126869 | 2022-01-18 | Stone | Mississippi | 28131 | 4409 | 67 |
2105064 | 2105064 | 2022-01-11 | Fairfield | South Carolina | 45039 | 4409 | 96 |
2037616 | 2037616 | 2021-12-22 | Bibb | Alabama | 1007 | 4409 | 95 |
2039379 | 2039379 | 2021-12-22 | Churchill | Nevada | 32001 | 4409 | 90 |
1992680 | 1992680 | 2021-12-08 | Elmore | Idaho | 16039 | 4409 | 51 |
1986765 | 1986765 | 2021-12-06 | Richland | Louisiana | 22083 | 4409 | 80 |
1966221 | 1966221 | 2021-11-30 | Carroll | Arkansas | 5015 | 4409 | 75 |
1945668 | 1945668 | 2021-11-23 | Susquehanna | Pennsylvania | 42115 | 4409 | 73 |
1915277 | 1915277 | 2021-11-14 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1912027 | 1912027 | 2021-11-13 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1908778 | 1908778 | 2021-11-12 | West Baton Rouge | Louisiana | 22121 | 4409 | 77 |
1892439 | 1892439 | 2021-11-07 | Ohio | Kentucky | 21183 | 4409 | 82 |
1889189 | 1889189 | 2021-11-06 | Ohio | Kentucky | 21183 | 4409 | 82 |
1885939 | 1885939 | 2021-11-05 | Ohio | Kentucky | 21183 | 4409 | 82 |
1880166 | 1880166 | 2021-11-03 | Cibola | New Mexico | 35006 | 4409 | 143 |
1870093 | 1870093 | 2021-10-31 | Wayne | Mississippi | 28153 | 4409 | 72 |
1866844 | 1866844 | 2021-10-30 | Wayne | Mississippi | 28153 | 4409 | 72 |
1863595 | 1863595 | 2021-10-29 | Wayne | Mississippi | 28153 | 4409 | 72 |
1860053 | 1860053 | 2021-10-28 | Somerset | Maine | 23025 | 4409 | 50 |
1860346 | 1860346 | 2021-10-28 | Wayne | Mississippi | 28153 | 4409 | 72 |
1856984 | 1856984 | 2021-10-27 | Nicollet | Minnesota | 27103 | 4409 | 54 |
1835265 | 1835265 | 2021-10-20 | Vega Baja | Puerto Rico | 72145 | 4409 | |
1827449 | 1827449 | 2021-10-18 | Montgomery | Kentucky | 21173 | 4409 | 54 |
1827697 | 1827697 | 2021-10-18 | Carlton | Minnesota | 27017 | 4409 | 66 |
1808347 | 1808347 | 2021-10-12 | Simpson | Mississippi | 28127 | 4409 | 116 |
1788537 | 1788537 | 2021-10-06 | Sabine | Louisiana | 22085 | 4409 | 84 |
1768159 | 1768159 | 2021-09-30 | Logan | Colorado | 8075 | 4409 | 74 |
1719618 | 1719618 | 2021-09-15 | Lee | Georgia | 13177 | 4409 | 74 |
1712950 | 1712950 | 2021-09-13 | Summit | Colorado | 8117 | 4409 | 9 |
1690998 | 1690998 | 2021-09-06 | Muhlenberg | Kentucky | 21177 | 4409 | 79 |
1687748 | 1687748 | 2021-09-05 | Muhlenberg | Kentucky | 21177 | 4409 | 79 |
1684498 | 1684498 | 2021-09-04 | Muhlenberg | Kentucky | 21177 | 4409 | 79 |
1681247 | 1681247 | 2021-09-03 | Muhlenberg | Kentucky | 21177 | 4409 | 79 |
1679225 | 1679225 | 2021-09-02 | Pike | Pennsylvania | 42103 | 4409 | 55 |
1667669 | 1667669 | 2021-08-30 | Pickens | Georgia | 13227 | 4409 | 82 |
1640010 | 1640010 | 2021-08-21 | Crawford | Ohio | 39033 | 4409 | 112 |
1620317 | 1620317 | 2021-08-15 | Montgomery | New York | 36057 | 4409 | 128 |
1617326 | 1617326 | 2021-08-14 | Putnam | Ohio | 39137 | 4409 | 104 |
1582592 | 1582592 | 2021-08-03 | Ohio | West Virginia | 54069 | 4409 | 87 |
1550469 | 1550469 | 2021-07-25 | Tuolumne | California | 6109 | 4409 | 73 |
1547222 | 1547222 | 2021-07-24 | Tuolumne | California | 6109 | 4409 | 73 |
1543975 | 1543975 | 2021-07-23 | Tuolumne | California | 6109 | 4409 | 73 |
1546394 | 1546394 | 2021-07-23 | Cherokee | Texas | 48073 | 4409 | 148 |
1536187 | 1536187 | 2021-07-20 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1532939 | 1532939 | 2021-07-19 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1529692 | 1529692 | 2021-07-18 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1526445 | 1526445 | 2021-07-17 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1522583 | 1522583 | 2021-07-16 | Platte | Missouri | 29165 | 4409 | 50 |
1523198 | 1523198 | 2021-07-16 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1519025 | 1519025 | 2021-07-15 | Hillsdale | Michigan | 26059 | 4409 | 94 |
1519950 | 1519950 | 2021-07-15 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1515778 | 1515778 | 2021-07-14 | Hillsdale | Michigan | 26059 | 4409 | 94 |
1516702 | 1516702 | 2021-07-14 | Mayes | Oklahoma | 40097 | 4409 | 74 |
1512532 | 1512532 | 2021-07-13 | Hillsdale | Michigan | 26059 | 4409 | 94 |
1476905 | 1476905 | 2021-07-02 | Isanti | Minnesota | 27059 | 4409 | 64 |
1460594 | 1460594 | 2021-06-27 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1457349 | 1457349 | 2021-06-26 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1454104 | 1454104 | 2021-06-25 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1444368 | 1444368 | 2021-06-22 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1437877 | 1437877 | 2021-06-20 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1434630 | 1434630 | 2021-06-19 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1431383 | 1431383 | 2021-06-18 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1421089 | 1421089 | 2021-06-15 | Clinton | Indiana | 18023 | 4409 | 60 |
1415155 | 1415155 | 2021-06-13 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1411054 | 1411054 | 2021-06-12 | Chattahoochee | Georgia | 13053 | 4409 | 17 |
1411909 | 1411909 | 2021-06-12 | Hillsdale | Michigan | 26059 | 4409 | 93 |
1408664 | 1408664 | 2021-06-11 | Hillsdale | Michigan | 26059 | 4409 | 92 |
1375579 | 1375579 | 2021-06-01 | Jefferson | Illinois | 17081 | 4409 | 122 |
1372334 | 1372334 | 2021-05-31 | Jefferson | Illinois | 17081 | 4409 | 122 |
1357368 | 1357368 | 2021-05-26 | Alexander | North Carolina | 37003 | 4409 | 84 |
1346059 | 1346059 | 2021-05-23 | DeSoto | Florida | 12027 | 4409 | 95 |
1346453 | 1346453 | 2021-05-23 | Gibson | Indiana | 18051 | 4409 | 95 |
1347672 | 1347672 | 2021-05-23 | Haywood | North Carolina | 37087 | 4409 | 96 |
1342486 | 1342486 | 2021-05-22 | Chilton | Alabama | 1021 | 4409 | 115 |
1344424 | 1344424 | 2021-05-22 | Haywood | North Carolina | 37087 | 4409 | 96 |
1341176 | 1341176 | 2021-05-21 | Haywood | North Carolina | 37087 | 4409 | 96 |
1287911 | 1287911 | 2021-05-05 | Franklin | Illinois | 17055 | 4409 | 84 |
1284563 | 1284563 | 2021-05-04 | Thomas | Georgia | 13275 | 4409 | 123 |
1251436 | 1251436 | 2021-04-23 | Jefferson | West Virginia | 54037 | 4409 | 50 |
1251521 | 1251521 | 2021-04-23 | Polk | Wisconsin | 55095 | 4409 | 49 |
1235990 | 1235990 | 2021-04-19 | Marion | Illinois | 17121 | 4409 | 121 |
1236483 | 1236483 | 2021-04-19 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1233236 | 1233236 | 2021-04-18 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1229988 | 1229988 | 2021-04-17 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1226740 | 1226740 | 2021-04-16 | Lincoln | Louisiana | 22061 | 4409 | 92 |
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);