ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 3775 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 12
- Georgia 9
- Tennessee 8
- Mississippi 7
- New Mexico 7
- Washington 7
- Ohio 6
- Illinois 5
- Michigan 5
- Minnesota 5
- Alabama 4
- Arkansas 4
- Indiana 4
- Missouri 4
- West Virginia 4
- Colorado 3
- Louisiana 3
- North Carolina 3
- Pennsylvania 3
- Virginia 3
- Iowa 2
- Kentucky 2
- Nebraska 2
- New York 2
- Puerto Rico 2
- South Carolina 2
- Vermont 2
- Maine 1
- Maryland 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495844 | 2495844 | 2022-05-11 | Madison | Texas | 48313 | 3775 | 54 |
2492586 | 2492586 | 2022-05-10 | Madison | Texas | 48313 | 3775 | 54 |
2486378 | 2486378 | 2022-05-08 | Pacific | Washington | 53049 | 3775 | 57 |
2483120 | 2483120 | 2022-05-07 | Pacific | Washington | 53049 | 3775 | 57 |
2479862 | 2479862 | 2022-05-06 | Pacific | Washington | 53049 | 3775 | 57 |
2476604 | 2476604 | 2022-05-05 | Pacific | Washington | 53049 | 3775 | 57 |
2473346 | 2473346 | 2022-05-04 | Pacific | Washington | 53049 | 3775 | 57 |
2431045 | 2431045 | 2022-04-21 | Grant | West Virginia | 54023 | 3775 | 56 |
2401022 | 2401022 | 2022-04-12 | Quebradillas | Puerto Rico | 72115 | 3775 | |
2316950 | 2316950 | 2022-03-17 | Lamoille | Vermont | 50015 | 3775 | 17 |
2288147 | 2288147 | 2022-03-09 | Franklin | Arkansas | 5047 | 3775 | 71 |
2268518 | 2268518 | 2022-03-03 | Crenshaw | Alabama | 1041 | 3775 | 93 |
2271693 | 2271693 | 2022-03-03 | Marquette | Wisconsin | 55077 | 3775 | 55 |
2224597 | 2224597 | 2022-02-17 | Wright | Missouri | 29229 | 3775 | 73 |
2219109 | 2219109 | 2022-02-15 | Andrews | Texas | 48003 | 3775 | 70 |
2193752 | 2193752 | 2022-02-08 | Macon | Alabama | 1087 | 3775 | 71 |
2150765 | 2150765 | 2022-01-25 | Polk | Tennessee | 47139 | 3775 | 51 |
2146494 | 2146494 | 2022-01-24 | Pike | Missouri | 29163 | 3775 | 56 |
2147513 | 2147513 | 2022-01-24 | Polk | Tennessee | 47139 | 3775 | 51 |
2141948 | 2141948 | 2022-01-23 | Otero | Colorado | 8089 | 3775 | 118 |
2144259 | 2144259 | 2022-01-23 | Polk | Tennessee | 47139 | 3775 | 51 |
2138693 | 2138693 | 2022-01-22 | Otero | Colorado | 8089 | 3775 | 118 |
2141004 | 2141004 | 2022-01-22 | Polk | Tennessee | 47139 | 3775 | 51 |
2135437 | 2135437 | 2022-01-21 | Otero | Colorado | 8089 | 3775 | 118 |
2137748 | 2137748 | 2022-01-21 | Polk | Tennessee | 47139 | 3775 | 51 |
2134494 | 2134494 | 2022-01-20 | Polk | Tennessee | 47139 | 3775 | 51 |
2131242 | 2131242 | 2022-01-19 | Polk | Tennessee | 47139 | 3775 | 51 |
2122749 | 2122749 | 2022-01-17 | Clark | Illinois | 17023 | 3775 | 55 |
2123980 | 2123980 | 2022-01-17 | Taos | New Mexico | 35055 | 3775 | 75 |
2119497 | 2119497 | 2022-01-16 | Clark | Illinois | 17023 | 3775 | 55 |
2120728 | 2120728 | 2022-01-16 | Taos | New Mexico | 35055 | 3775 | 75 |
2116245 | 2116245 | 2022-01-15 | Clark | Illinois | 17023 | 3775 | 55 |
2117476 | 2117476 | 2022-01-15 | Taos | New Mexico | 35055 | 3775 | 75 |
2112994 | 2112994 | 2022-01-14 | Clark | Illinois | 17023 | 3775 | 55 |
2114225 | 2114225 | 2022-01-14 | Taos | New Mexico | 35055 | 3775 | 75 |
2111472 | 2111472 | 2022-01-13 | Barranquitas | Puerto Rico | 72019 | 3775 | |
2102671 | 2102671 | 2022-01-11 | Marengo | Alabama | 1091 | 3775 | 93 |
2099883 | 2099883 | 2022-01-10 | Putnam | Georgia | 13237 | 3775 | 90 |
2080014 | 2080014 | 2022-01-04 | Lawrence | Arkansas | 5075 | 3775 | 63 |
2015011 | 2015011 | 2021-12-15 | Logan | Arkansas | 5083 | 3775 | 53 |
1996471 | 1996471 | 2021-12-09 | Wayne | Kentucky | 21231 | 3775 | 71 |
1996701 | 1996701 | 2021-12-09 | Dodge | Minnesota | 27039 | 3775 | 12 |
1966510 | 1966510 | 2021-11-30 | Burke | Georgia | 13033 | 3775 | 85 |
1961037 | 1961037 | 2021-11-28 | Grenada | Mississippi | 28043 | 3775 | 109 |
1957786 | 1957786 | 2021-11-27 | Grenada | Mississippi | 28043 | 3775 | 109 |
1954535 | 1954535 | 2021-11-26 | Grenada | Mississippi | 28043 | 3775 | 109 |
1951284 | 1951284 | 2021-11-25 | Grenada | Mississippi | 28043 | 3775 | 109 |
1948033 | 1948033 | 2021-11-24 | Grenada | Mississippi | 28043 | 3775 | 109 |
1926634 | 1926634 | 2021-11-17 | Milam | Texas | 48331 | 3775 | 87 |
1923384 | 1923384 | 2021-11-16 | Milam | Texas | 48331 | 3775 | 87 |
1920135 | 1920135 | 2021-11-15 | Milam | Texas | 48331 | 3775 | 87 |
1916885 | 1916885 | 2021-11-14 | Milam | Texas | 48331 | 3775 | 86 |
1912943 | 1912943 | 2021-11-13 | Hocking | Ohio | 39073 | 3775 | 90 |
1913635 | 1913635 | 2021-11-13 | Milam | Texas | 48331 | 3775 | 86 |
1910385 | 1910385 | 2021-11-12 | Milam | Texas | 48331 | 3775 | 86 |
1907136 | 1907136 | 2021-11-11 | Milam | Texas | 48331 | 3775 | 85 |
1889597 | 1889597 | 2021-11-06 | Audrain | Missouri | 29007 | 3775 | 64 |
1856067 | 1856067 | 2021-10-27 | Harris | Georgia | 13145 | 3775 | 86 |
1853617 | 1853617 | 2021-10-26 | Clare | Michigan | 26035 | 3775 | 99 |
1849876 | 1849876 | 2021-10-25 | Posey | Indiana | 18129 | 3775 | 44 |
1850368 | 1850368 | 2021-10-25 | Clare | Michigan | 26035 | 3775 | 99 |
1845526 | 1845526 | 2021-10-23 | Rutland | Vermont | 50021 | 3775 | 28 |
1838796 | 1838796 | 2021-10-21 | Dimmit | Texas | 48127 | 3775 | 45 |
1759739 | 1759739 | 2021-09-27 | Washington | Missouri | 29221 | 3775 | 59 |
1719934 | 1719934 | 2021-09-15 | Wells | Indiana | 18179 | 3775 | 85 |
1688508 | 1688508 | 2021-09-05 | Allegany | New York | 36003 | 3775 | 90 |
1674179 | 1674179 | 2021-09-01 | Stephens | Georgia | 13257 | 3775 | 81 |
1652406 | 1652406 | 2021-08-25 | Simpson | Mississippi | 28127 | 3775 | 100 |
1649048 | 1649048 | 2021-08-24 | Lyon | Minnesota | 27083 | 3775 | 54 |
1624141 | 1624141 | 2021-08-16 | Marlboro | South Carolina | 45069 | 3775 | 61 |
1621552 | 1621552 | 2021-08-15 | Fayette | West Virginia | 54019 | 3775 | 86 |
1618304 | 1618304 | 2021-08-14 | Fayette | West Virginia | 54019 | 3775 | 86 |
1615056 | 1615056 | 2021-08-13 | Fayette | West Virginia | 54019 | 3775 | 86 |
1580685 | 1580685 | 2021-08-03 | Worcester | Maryland | 24047 | 3775 | 106 |
1508784 | 1508784 | 2021-07-12 | Putnam | Indiana | 18133 | 3775 | 62 |
1396484 | 1396484 | 2021-06-07 | Clinton | Ohio | 39027 | 3775 | 66 |
1393237 | 1393237 | 2021-06-06 | Clinton | Ohio | 39027 | 3775 | 66 |
1389992 | 1389992 | 2021-06-05 | Clinton | Ohio | 39027 | 3775 | 66 |
1386747 | 1386747 | 2021-06-04 | Clinton | Ohio | 39027 | 3775 | 66 |
1377995 | 1377995 | 2021-06-01 | York | Virginia | 51199 | 3775 | 55 |
1372361 | 1372361 | 2021-05-31 | Montgomery | Illinois | 17135 | 3775 | 80 |
1371504 | 1371504 | 2021-05-30 | York | Virginia | 51199 | 3775 | 54 |
1368258 | 1368258 | 2021-05-29 | York | Virginia | 51199 | 3775 | 54 |
1353385 | 1353385 | 2021-05-25 | St. John the Baptist | Louisiana | 22095 | 3775 | 141 |
1339224 | 1339224 | 2021-05-20 | Teton | Wyoming | 56039 | 3775 | 9 |
1282515 | 1282515 | 2021-05-03 | Lincoln | Nebraska | 31111 | 3775 | 54 |
1279268 | 1279268 | 2021-05-02 | Lincoln | Nebraska | 31111 | 3775 | 54 |
1279858 | 1279858 | 2021-05-02 | Pike | Pennsylvania | 42103 | 3775 | 54 |
1275682 | 1275682 | 2021-05-01 | Polk | Minnesota | 27119 | 3775 | 67 |
1275696 | 1275696 | 2021-05-01 | Steele | Minnesota | 27147 | 3775 | 15 |
1252897 | 1252897 | 2021-04-24 | Beltrami | Minnesota | 27007 | 3775 | 57 |
1242970 | 1242970 | 2021-04-21 | Iberville | Louisiana | 22047 | 3775 | 98 |
1149646 | 1149646 | 2021-03-23 | Yadkin | North Carolina | 37197 | 3775 | 47 |
1077474 | 1077474 | 2021-03-01 | Barry | Michigan | 26015 | 3775 | 45 |
1071818 | 1071818 | 2021-02-27 | Fulton | Ohio | 39051 | 3775 | 64 |
1061316 | 1061316 | 2021-02-24 | Shiawassee | Michigan | 26155 | 3775 | 78 |
1062615 | 1062615 | 2021-02-24 | Weakley | Tennessee | 47183 | 3775 | 59 |
1055376 | 1055376 | 2021-02-22 | Madison | New York | 36053 | 3775 | 84 |
1044523 | 1044523 | 2021-02-19 | Montgomery | Indiana | 18107 | 3775 | 83 |
1018689 | 1018689 | 2021-02-11 | Wapello | Iowa | 19179 | 3775 | 103 |
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);