ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
120 rows where cases = 4424 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 12
- Illinois 11
- Iowa 8
- Ohio 8
- Minnesota 7
- Oklahoma 7
- Georgia 6
- Tennessee 6
- Alabama 5
- New York 5
- Texas 5
- Maine 4
- Michigan 4
- North Carolina 4
- California 3
- Indiana 3
- Kentucky 3
- New Jersey 2
- Pennsylvania 2
- Puerto Rico 2
- Virginia 2
- West Virginia 2
- Alaska 1
- Idaho 1
- Mississippi 1
- Missouri 1
- Nevada 1
- New Hampshire 1
- Oregon 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500195 | 2500195 | 2022-05-13 | De Witt | Illinois | 17039 | 4424 | 45 |
2422620 | 2422620 | 2022-04-19 | Washington | Maine | 23029 | 4424 | 55 |
2419364 | 2419364 | 2022-04-18 | Washington | Maine | 23029 | 4424 | 55 |
2416108 | 2416108 | 2022-04-17 | Washington | Maine | 23029 | 4424 | 55 |
2412852 | 2412852 | 2022-04-16 | Washington | Maine | 23029 | 4424 | 55 |
2217560 | 2217560 | 2022-02-15 | Mason | Kentucky | 21161 | 4424 | 93 |
2218715 | 2218715 | 2022-02-15 | Clatsop | Oregon | 41007 | 4424 | 38 |
2215983 | 2215983 | 2022-02-14 | Jones | Texas | 48253 | 4424 | 87 |
2179794 | 2179794 | 2022-02-03 | Camuy | Puerto Rico | 72027 | 4424 | |
2164876 | 2164876 | 2022-01-30 | Elbert | Georgia | 13105 | 4424 | 97 |
2161621 | 2161621 | 2022-01-29 | Elbert | Georgia | 13105 | 4424 | 97 |
2158365 | 2158365 | 2022-01-28 | Elbert | Georgia | 13105 | 4424 | 97 |
2128353 | 2128353 | 2022-01-18 | Dinwiddie | Virginia | 51053 | 4424 | 63 |
2101286 | 2101286 | 2022-01-10 | Ashe | North Carolina | 37009 | 4424 | 60 |
2098276 | 2098276 | 2022-01-09 | Wyandot | Ohio | 39175 | 4424 | 83 |
2079740 | 2079740 | 2022-01-03 | Mason | West Virginia | 54053 | 4424 | 70 |
2064113 | 2064113 | 2021-12-30 | Pierce | Georgia | 13229 | 4424 | 107 |
2035165 | 2035165 | 2021-12-21 | Benton | Iowa | 19011 | 4424 | 62 |
2031915 | 2031915 | 2021-12-20 | Benton | Iowa | 19011 | 4424 | 62 |
2028664 | 2028664 | 2021-12-19 | Benton | Iowa | 19011 | 4424 | 62 |
2025413 | 2025413 | 2021-12-18 | Benton | Iowa | 19011 | 4424 | 62 |
2022162 | 2022162 | 2021-12-17 | Benton | Iowa | 19011 | 4424 | 62 |
2018911 | 2018911 | 2021-12-16 | Benton | Iowa | 19011 | 4424 | 62 |
2015661 | 2015661 | 2021-12-15 | Benton | Iowa | 19011 | 4424 | 62 |
1982024 | 1982024 | 2021-12-04 | Washington | Vermont | 50023 | 4424 | 28 |
1928585 | 1928585 | 2021-11-18 | Wayne | Mississippi | 28153 | 4424 | 72 |
1921664 | 1921664 | 2021-11-16 | Lincoln | Kentucky | 21137 | 4424 | 99 |
1918846 | 1918846 | 2021-11-15 | Barry | Missouri | 29009 | 4424 | 64 |
1895689 | 1895689 | 2021-11-08 | Ohio | Kentucky | 21183 | 4424 | 82 |
1860233 | 1860233 | 2021-10-28 | Nicollet | Minnesota | 27103 | 4424 | 55 |
1852799 | 1852799 | 2021-10-26 | Emanuel | Georgia | 13107 | 4424 | 127 |
1854238 | 1854238 | 2021-10-26 | Orleans | New York | 36073 | 4424 | 89 |
1819272 | 1819272 | 2021-10-15 | Cass | Texas | 48067 | 4424 | 138 |
1784842 | 1784842 | 2021-10-05 | Daviess | Indiana | 18027 | 4424 | 112 |
1785892 | 1785892 | 2021-10-05 | Douglas | Nevada | 32005 | 4424 | 50 |
1780214 | 1780214 | 2021-10-03 | McNairy | Tennessee | 47109 | 4424 | 64 |
1776964 | 1776964 | 2021-10-02 | McNairy | Tennessee | 47109 | 4424 | 64 |
1773714 | 1773714 | 2021-10-01 | McNairy | Tennessee | 47109 | 4424 | 64 |
1770182 | 1770182 | 2021-09-30 | McKean | Pennsylvania | 42083 | 4424 | 77 |
1767738 | 1767738 | 2021-09-29 | Greenbrier | West Virginia | 54025 | 4424 | 79 |
1763479 | 1763479 | 2021-09-28 | Jackson | Ohio | 39079 | 4424 | 63 |
1753756 | 1753756 | 2021-09-25 | Ottawa | Ohio | 39123 | 4424 | 84 |
1712659 | 1712659 | 2021-09-13 | Clarke | Alabama | 1025 | 4424 | 68 |
1709446 | 1709446 | 2021-09-12 | Marion | Alabama | 1093 | 4424 | 113 |
1690561 | 1690561 | 2021-09-06 | Lee | Illinois | 17103 | 4424 | 95 |
1687311 | 1687311 | 2021-09-05 | Lee | Illinois | 17103 | 4424 | 95 |
1684061 | 1684061 | 2021-09-04 | Lee | Illinois | 17103 | 4424 | 95 |
1680810 | 1680810 | 2021-09-03 | Lee | Illinois | 17103 | 4424 | 95 |
1672572 | 1672572 | 2021-08-31 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1669324 | 1669324 | 2021-08-30 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1665183 | 1665183 | 2021-08-29 | Delta | Michigan | 26041 | 4424 | 95 |
1665320 | 1665320 | 2021-08-29 | Steele | Minnesota | 27147 | 4424 | 20 |
1666077 | 1666077 | 2021-08-29 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1661935 | 1661935 | 2021-08-28 | Delta | Michigan | 26041 | 4424 | 95 |
1662072 | 1662072 | 2021-08-28 | Steele | Minnesota | 27147 | 4424 | 20 |
1662829 | 1662829 | 2021-08-28 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1658687 | 1658687 | 2021-08-27 | Delta | Michigan | 26041 | 4424 | 95 |
1658824 | 1658824 | 2021-08-27 | Steele | Minnesota | 27147 | 4424 | 20 |
1659581 | 1659581 | 2021-08-27 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1656332 | 1656332 | 2021-08-26 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1653085 | 1653085 | 2021-08-25 | Caddo | Oklahoma | 40015 | 4424 | 98 |
1643251 | 1643251 | 2021-08-22 | Brown | Ohio | 39015 | 4424 | 64 |
1633988 | 1633988 | 2021-08-19 | Giles | Tennessee | 47055 | 4424 | 100 |
1488036 | 1488036 | 2021-07-05 | Jim Wells | Texas | 48249 | 4424 | 108 |
1484789 | 1484789 | 2021-07-04 | Jim Wells | Texas | 48249 | 4424 | 108 |
1473022 | 1473022 | 2021-07-01 | DeKalb | Indiana | 18033 | 4424 | 88 |
1461753 | 1461753 | 2021-06-27 | Dillon | South Carolina | 45033 | 4424 | 85 |
1458508 | 1458508 | 2021-06-26 | Dillon | South Carolina | 45033 | 4424 | 85 |
1455263 | 1455263 | 2021-06-25 | Dillon | South Carolina | 45033 | 4424 | 85 |
1450228 | 1450228 | 2021-06-24 | Jefferson | Illinois | 17081 | 4424 | 123 |
1452018 | 1452018 | 2021-06-24 | Dillon | South Carolina | 45033 | 4424 | 85 |
1448772 | 1448772 | 2021-06-23 | Dillon | South Carolina | 45033 | 4424 | 85 |
1444958 | 1444958 | 2021-06-22 | Fulton | New York | 36035 | 4424 | 92 |
1445527 | 1445527 | 2021-06-22 | Dillon | South Carolina | 45033 | 4424 | 85 |
1440493 | 1440493 | 2021-06-21 | Jefferson | Illinois | 17081 | 4424 | 123 |
1441713 | 1441713 | 2021-06-21 | Fulton | New York | 36035 | 4424 | 92 |
1442282 | 1442282 | 2021-06-21 | Dillon | South Carolina | 45033 | 4424 | 85 |
1439037 | 1439037 | 2021-06-20 | Dillon | South Carolina | 45033 | 4424 | 85 |
1435790 | 1435790 | 2021-06-19 | Dillon | South Carolina | 45033 | 4424 | 85 |
1432543 | 1432543 | 2021-06-18 | Dillon | South Carolina | 45033 | 4424 | 85 |
1355474 | 1355474 | 2021-05-26 | Chilton | Alabama | 1021 | 4424 | 115 |
1272353 | 1272353 | 2021-04-30 | Newaygo | Michigan | 26123 | 4424 | 57 |
1248978 | 1248978 | 2021-04-23 | Marion | Illinois | 17121 | 4424 | 121 |
1247175 | 1247175 | 2021-04-22 | Knox | Ohio | 39083 | 4424 | 108 |
1230188 | 1230188 | 2021-04-17 | Goodhue | Minnesota | 27049 | 4424 | 71 |
1134314 | 1134314 | 2021-03-18 | Wasatch | Utah | 49051 | 4424 | 21 |
1122326 | 1122326 | 2021-03-15 | Macoupin | Illinois | 17117 | 4424 | 109 |
1109246 | 1109246 | 2021-03-11 | Bingham | Idaho | 16011 | 4424 | 63 |
1100940 | 1100940 | 2021-03-08 | Vance | North Carolina | 37181 | 4424 | 82 |
1091656 | 1091656 | 2021-03-05 | Newberry | South Carolina | 45071 | 4424 | 92 |
1088095 | 1088095 | 2021-03-04 | Shelby | Ohio | 39149 | 4424 | 79 |
1075379 | 1075379 | 2021-02-28 | Unknown | Puerto Rico | 4424 | 2036 | |
1070157 | 1070157 | 2021-02-27 | Colquitt | Georgia | 13071 | 4424 | 101 |
1067818 | 1067818 | 2021-02-26 | Benton | Minnesota | 27009 | 4424 | 90 |
1016452 | 1016452 | 2021-02-10 | Sullivan | New York | 36105 | 4424 | 58 |
1002200 | 1002200 | 2021-02-06 | Effingham | Illinois | 17049 | 4424 | 79 |
1000137 | 1000137 | 2021-02-05 | Salem | New Jersey | 34033 | 4424 | 150 |
989450 | 989450 | 2021-02-02 | Marshall | Iowa | 19127 | 4424 | 68 |
984232 | 984232 | 2021-01-31 | Seneca | Ohio | 39147 | 4424 | 66 |
977704 | 977704 | 2021-01-29 | Huron | Ohio | 39077 | 4424 | 41 |
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);