ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 3085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 10
- Illinois 10
- Iowa 10
- Texas 9
- Tennessee 8
- Minnesota 7
- Mississippi 7
- Alabama 6
- Michigan 6
- Missouri 6
- North Carolina 6
- Ohio 4
- South Carolina 4
- Wisconsin 4
- Wyoming 4
- Arkansas 3
- Florida 3
- Kentucky 3
- Oregon 3
- Pennsylvania 3
- Indiana 2
- Maryland 2
- New York 2
- South Dakota 2
- Virginia 2
- Arizona 1
- California 1
- Louisiana 1
- New Jersey 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470463 | 2470463 | 2022-05-04 | Mariposa | California | 6043 | 3085 | 34 |
2445549 | 2445549 | 2022-04-26 | Chippewa | Minnesota | 27023 | 3085 | 48 |
2228553 | 2228553 | 2022-02-18 | Potter | Pennsylvania | 42105 | 3085 | 90 |
2193131 | 2193131 | 2022-02-07 | Comanche | Texas | 48093 | 3085 | 75 |
2153676 | 2153676 | 2022-01-26 | Tillamook | Oregon | 41057 | 3085 | 54 |
2138416 | 2138416 | 2022-01-22 | Cleburne | Alabama | 1029 | 3085 | 62 |
2133738 | 2133738 | 2022-01-20 | Socorro | New Mexico | 35053 | 3085 | 74 |
2130201 | 2130201 | 2022-01-19 | Macon | Missouri | 29121 | 3085 | 39 |
2125249 | 2125249 | 2022-01-17 | Grant | West Virginia | 54023 | 3085 | 49 |
2113885 | 2113885 | 2022-01-14 | Bates | Missouri | 29013 | 3085 | 67 |
2110625 | 2110625 | 2022-01-13 | Yalobusha | Mississippi | 28161 | 3085 | 48 |
2063303 | 2063303 | 2021-12-29 | Buchanan | Virginia | 51027 | 3085 | 85 |
2028351 | 2028351 | 2021-12-19 | Meriwether | Georgia | 13199 | 3085 | 121 |
2025100 | 2025100 | 2021-12-18 | Meriwether | Georgia | 13199 | 3085 | 121 |
2021849 | 2021849 | 2021-12-17 | Meriwether | Georgia | 13199 | 3085 | 121 |
2006400 | 2006400 | 2021-12-12 | Manistee | Michigan | 26101 | 3085 | 54 |
2003149 | 2003149 | 2021-12-11 | Manistee | Michigan | 26101 | 3085 | 54 |
1999899 | 1999899 | 2021-12-10 | Manistee | Michigan | 26101 | 3085 | 54 |
1997961 | 1997961 | 2021-12-09 | Sequatchie | Tennessee | 47153 | 3085 | 40 |
1994710 | 1994710 | 2021-12-08 | Sequatchie | Tennessee | 47153 | 3085 | 40 |
1987607 | 1987607 | 2021-12-06 | Yancey | North Carolina | 37199 | 3085 | 36 |
1957573 | 1957573 | 2021-11-27 | Talbot | Maryland | 24041 | 3085 | 58 |
1925267 | 1925267 | 2021-11-17 | Chickasaw | Mississippi | 28017 | 3085 | 67 |
1921420 | 1921420 | 2021-11-16 | Dickinson | Iowa | 19059 | 3085 | 53 |
1918170 | 1918170 | 2021-11-15 | Dickinson | Iowa | 19059 | 3085 | 53 |
1914920 | 1914920 | 2021-11-14 | Dickinson | Iowa | 19059 | 3085 | 53 |
1911670 | 1911670 | 2021-11-13 | Dickinson | Iowa | 19059 | 3085 | 53 |
1908421 | 1908421 | 2021-11-12 | Dickinson | Iowa | 19059 | 3085 | 53 |
1905172 | 1905172 | 2021-11-11 | Dickinson | Iowa | 19059 | 3085 | 53 |
1901922 | 1901922 | 2021-11-10 | Dickinson | Iowa | 19059 | 3085 | 53 |
1877445 | 1877445 | 2021-11-02 | Canovanas | Puerto Rico | 72029 | 3085 | |
1852324 | 1852324 | 2021-10-25 | Vilas | Wisconsin | 55125 | 3085 | 54 |
1824321 | 1824321 | 2021-10-17 | Caroline | Maryland | 24011 | 3085 | 47 |
1813398 | 1813398 | 2021-10-14 | Hale | Alabama | 1065 | 3085 | 86 |
1814634 | 1814634 | 2021-10-14 | Gladwin | Michigan | 26051 | 3085 | 68 |
1811386 | 1811386 | 2021-10-13 | Gladwin | Michigan | 26051 | 3085 | 68 |
1811429 | 1811429 | 2021-10-13 | Otsego | Michigan | 26137 | 3085 | 51 |
1809482 | 1809482 | 2021-10-12 | Unicoi | Tennessee | 47171 | 3085 | 63 |
1804502 | 1804502 | 2021-10-11 | Unknown | Iowa | 3085 | 0 | |
1801253 | 1801253 | 2021-10-10 | Unknown | Iowa | 3085 | 0 | |
1797152 | 1797152 | 2021-10-09 | Henry | Alabama | 1067 | 3085 | 63 |
1798004 | 1798004 | 2021-10-09 | Unknown | Iowa | 3085 | 0 | |
1788481 | 1788481 | 2021-10-06 | Simpson | Kentucky | 21213 | 3085 | 47 |
1764739 | 1764739 | 2021-09-29 | Ashley | Arkansas | 5003 | 3085 | 42 |
1761820 | 1761820 | 2021-09-28 | Elbert | Georgia | 13105 | 3085 | 81 |
1734281 | 1734281 | 2021-09-19 | Van Wert | Ohio | 39161 | 3085 | 70 |
1718356 | 1718356 | 2021-09-14 | Beadle | South Dakota | 46005 | 3085 | 43 |
1666341 | 1666341 | 2021-08-29 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1663093 | 1663093 | 2021-08-28 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1659845 | 1659845 | 2021-08-27 | Barnwell | South Carolina | 45011 | 3085 | 62 |
1655217 | 1655217 | 2021-08-26 | Grant | Kentucky | 21081 | 3085 | 26 |
1642706 | 1642706 | 2021-08-22 | Crawford | Missouri | 29055 | 3085 | 42 |
1632115 | 1632115 | 2021-08-19 | Saline | Illinois | 17165 | 3085 | 74 |
1630869 | 1630869 | 2021-08-18 | Deaf Smith | Texas | 48117 | 3085 | 68 |
1624462 | 1624462 | 2021-08-16 | Limestone | Texas | 48293 | 3085 | 83 |
1620564 | 1620564 | 2021-08-15 | Morrow | Ohio | 39117 | 3085 | 44 |
1606613 | 1606613 | 2021-08-11 | Richland | Louisiana | 22083 | 3085 | 58 |
1587388 | 1587388 | 2021-08-05 | Covington | Mississippi | 28031 | 3085 | 84 |
1573623 | 1573623 | 2021-08-01 | McDonough | Illinois | 17109 | 3085 | 63 |
1570375 | 1570375 | 2021-07-31 | McDonough | Illinois | 17109 | 3085 | 63 |
1567127 | 1567127 | 2021-07-30 | McDonough | Illinois | 17109 | 3085 | 63 |
1535434 | 1535434 | 2021-07-20 | Itawamba | Mississippi | 28057 | 3085 | 80 |
1506101 | 1506101 | 2021-07-11 | Brown | Minnesota | 27015 | 3085 | 40 |
1502855 | 1502855 | 2021-07-10 | Brown | Minnesota | 27015 | 3085 | 40 |
1499609 | 1499609 | 2021-07-09 | Brown | Minnesota | 27015 | 3085 | 40 |
1497930 | 1497930 | 2021-07-08 | Uintah | Utah | 49047 | 3085 | 25 |
1480297 | 1480297 | 2021-07-03 | Barry | Missouri | 29009 | 3085 | 47 |
1451002 | 1451002 | 2021-06-24 | Adams | Mississippi | 28001 | 3085 | 86 |
1447756 | 1447756 | 2021-06-23 | Adams | Mississippi | 28001 | 3085 | 86 |
1390786 | 1390786 | 2021-06-05 | Willacy | Texas | 48489 | 3085 | 89 |
1365840 | 1365840 | 2021-05-29 | Iroquois | Illinois | 17075 | 3085 | 69 |
1343850 | 1343850 | 2021-05-22 | Mille Lacs | Minnesota | 27095 | 3085 | 54 |
1331038 | 1331038 | 2021-05-18 | Lafayette | Missouri | 29107 | 3085 | 57 |
1321647 | 1321647 | 2021-05-15 | Washington | New York | 36115 | 3085 | 55 |
1312236 | 1312236 | 2021-05-12 | Benton | Oregon | 41003 | 3085 | 19 |
1264610 | 1264610 | 2021-04-28 | Pike | Alabama | 1109 | 3085 | 77 |
1266051 | 1266051 | 2021-04-28 | Yazoo | Mississippi | 28163 | 3085 | 69 |
1236126 | 1236126 | 2021-04-19 | White | Indiana | 18181 | 3085 | 55 |
1237432 | 1237432 | 2021-04-19 | Jackson | Ohio | 39079 | 3085 | 51 |
1234185 | 1234185 | 2021-04-18 | Jackson | Ohio | 39079 | 3085 | 51 |
1222858 | 1222858 | 2021-04-15 | Stephens | Georgia | 13257 | 3085 | 80 |
1212592 | 1212592 | 2021-04-11 | Sheridan | Wyoming | 56033 | 3085 | 31 |
1209343 | 1209343 | 2021-04-10 | Sheridan | Wyoming | 56033 | 3085 | 31 |
1206095 | 1206095 | 2021-04-09 | Sheridan | Wyoming | 56033 | 3085 | 31 |
1202847 | 1202847 | 2021-04-08 | Sheridan | Wyoming | 56033 | 3085 | 31 |
1178773 | 1178773 | 2021-04-01 | Wyoming | New York | 36121 | 3085 | 50 |
1161258 | 1161258 | 2021-03-27 | Fayette | Illinois | 17051 | 3085 | 57 |
1163111 | 1163111 | 2021-03-27 | Davison | South Dakota | 46035 | 3085 | 67 |
1158010 | 1158010 | 2021-03-26 | Fayette | Illinois | 17051 | 3085 | 57 |
1156050 | 1156050 | 2021-03-25 | Bladen | North Carolina | 37017 | 3085 | 41 |
1147149 | 1147149 | 2021-03-22 | Kendall | Texas | 48259 | 3085 | 69 |
1143902 | 1143902 | 2021-03-21 | Kendall | Texas | 48259 | 3085 | 69 |
1140655 | 1140655 | 2021-03-20 | Kendall | Texas | 48259 | 3085 | 69 |
1112475 | 1112475 | 2021-03-12 | White | Georgia | 13311 | 3085 | 75 |
1109357 | 1109357 | 2021-03-11 | Perry | Illinois | 17145 | 3085 | 68 |
1101374 | 1101374 | 2021-03-08 | Clarendon | South Carolina | 45027 | 3085 | 102 |
1091459 | 1091459 | 2021-03-05 | Polk | Oregon | 41053 | 3085 | 45 |
1087926 | 1087926 | 2021-03-04 | Montgomery | North Carolina | 37123 | 3085 | 88 |
1089140 | 1089140 | 2021-03-04 | Juneau | Wisconsin | 55057 | 3085 | 20 |
1075204 | 1075204 | 2021-02-28 | Woodward | Oklahoma | 40153 | 3085 | 17 |
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);