ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
185 rows where cases = 2621 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 19
- Georgia 16
- Indiana 15
- Kansas 14
- Kentucky 14
- Virginia 10
- Missouri 9
- Texas 9
- Iowa 7
- Minnesota 7
- Illinois 6
- Oregon 5
- Pennsylvania 5
- Colorado 4
- Washington 4
- Maine 3
- Michigan 3
- North Carolina 3
- Puerto Rico 3
- South Carolina 3
- South Dakota 3
- West Virginia 3
- Alabama 2
- Florida 2
- Idaho 2
- New Mexico 2
- Ohio 2
- Vermont 2
- Alaska 1
- Arkansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500659 | 2500659 | 2022-05-13 | McLean | Kentucky | 21149 | 2621 | 53 |
2497401 | 2497401 | 2022-05-12 | McLean | Kentucky | 21149 | 2621 | 53 |
2494143 | 2494143 | 2022-05-11 | McLean | Kentucky | 21149 | 2621 | 53 |
2490885 | 2490885 | 2022-05-10 | McLean | Kentucky | 21149 | 2621 | 53 |
2487628 | 2487628 | 2022-05-09 | McLean | Kentucky | 21149 | 2621 | 53 |
2473554 | 2473554 | 2022-05-05 | Lowndes | Alabama | 1085 | 2621 | 77 |
2470297 | 2470297 | 2022-05-04 | Lowndes | Alabama | 1085 | 2621 | 77 |
2450219 | 2450219 | 2022-04-27 | Jim Hogg | Texas | 48247 | 2621 | 22 |
2446962 | 2446962 | 2022-04-26 | Jim Hogg | Texas | 48247 | 2621 | 22 |
2309453 | 2309453 | 2022-03-15 | Clay | North Carolina | 37043 | 2621 | 39 |
2240601 | 2240601 | 2022-02-22 | Koochiching | Minnesota | 27071 | 2621 | 34 |
2224802 | 2224802 | 2022-02-17 | Colfax | New Mexico | 35007 | 2621 | 64 |
2197606 | 2197606 | 2022-02-09 | Jasper | Illinois | 17079 | 2621 | 27 |
2198555 | 2198555 | 2022-02-09 | Ripley | Missouri | 29181 | 2621 | 54 |
2190282 | 2190282 | 2022-02-06 | Jefferson | Washington | 53031 | 2621 | 23 |
2187029 | 2187029 | 2022-02-05 | Jefferson | Washington | 53031 | 2621 | 23 |
2183776 | 2183776 | 2022-02-04 | Jefferson | Washington | 53031 | 2621 | 23 |
2165882 | 2165882 | 2022-01-30 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2162627 | 2162627 | 2022-01-29 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2159372 | 2159372 | 2022-01-28 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2157615 | 2157615 | 2022-01-27 | Brunswick | Virginia | 51025 | 2621 | 37 |
2143122 | 2143122 | 2022-01-23 | Montgomery | Mississippi | 28097 | 2621 | 61 |
2139867 | 2139867 | 2022-01-22 | Montgomery | Mississippi | 28097 | 2621 | 61 |
2136611 | 2136611 | 2022-01-21 | Montgomery | Mississippi | 28097 | 2621 | 61 |
2127233 | 2127233 | 2022-01-18 | Torrance | New Mexico | 35057 | 2621 | 42 |
2122394 | 2122394 | 2022-01-17 | Crowley | Colorado | 8025 | 2621 | 27 |
2124380 | 2124380 | 2022-01-17 | Hood River | Oregon | 41027 | 2621 | 38 |
2121128 | 2121128 | 2022-01-16 | Hood River | Oregon | 41027 | 2621 | 38 |
2117876 | 2117876 | 2022-01-15 | Hood River | Oregon | 41027 | 2621 | 38 |
2114625 | 2114625 | 2022-01-14 | Hood River | Oregon | 41027 | 2621 | 38 |
2112047 | 2112047 | 2022-01-13 | Lamoille | Vermont | 50015 | 2621 | 12 |
2077650 | 2077650 | 2022-01-03 | Fleming | Kentucky | 21069 | 2621 | 43 |
2037754 | 2037754 | 2021-12-22 | Howard | Arkansas | 5061 | 2621 | 39 |
2033512 | 2033512 | 2021-12-20 | San Sebastian | Puerto Rico | 72131 | 2621 | |
2022864 | 2022864 | 2021-12-17 | Bates | Missouri | 29013 | 2621 | 60 |
2017373 | 2017373 | 2021-12-15 | Oglala Lakota | South Dakota | 46102 | 2621 | 55 |
2014123 | 2014123 | 2021-12-14 | Oglala Lakota | South Dakota | 46102 | 2621 | 55 |
2014307 | 2014307 | 2021-12-14 | Falls | Texas | 48145 | 2621 | 51 |
1999803 | 1999803 | 2021-12-10 | Sagadahoc | Maine | 23023 | 2621 | 16 |
1988272 | 1988272 | 2021-12-06 | Colorado | Texas | 48089 | 2621 | 55 |
1978764 | 1978764 | 2021-12-03 | Caledonia | Vermont | 50005 | 2621 | 21 |
1915485 | 1915485 | 2021-11-14 | Redwood | Minnesota | 27127 | 2621 | 45 |
1912235 | 1912235 | 2021-11-13 | Redwood | Minnesota | 27127 | 2621 | 45 |
1908985 | 1908985 | 2021-11-12 | Redwood | Minnesota | 27127 | 2621 | 45 |
1899140 | 1899140 | 2021-11-09 | Manistee | Michigan | 26101 | 2621 | 40 |
1895890 | 1895890 | 2021-11-08 | Manistee | Michigan | 26101 | 2621 | 40 |
1894363 | 1894363 | 2021-11-07 | Nottoway | Virginia | 51135 | 2621 | 68 |
1891113 | 1891113 | 2021-11-06 | Nottoway | Virginia | 51135 | 2621 | 68 |
1887863 | 1887863 | 2021-11-05 | Nottoway | Virginia | 51135 | 2621 | 68 |
1881990 | 1881990 | 2021-11-04 | Bacon | Georgia | 13005 | 2621 | 61 |
1873108 | 1873108 | 2021-11-01 | Charlevoix | Michigan | 26029 | 2621 | 35 |
1869388 | 1869388 | 2021-10-31 | Vermillion | Indiana | 18165 | 2621 | 54 |
1866139 | 1866139 | 2021-10-30 | Vermillion | Indiana | 18165 | 2621 | 54 |
1862890 | 1862890 | 2021-10-29 | Vermillion | Indiana | 18165 | 2621 | 54 |
1849189 | 1849189 | 2021-10-25 | North Slope Borough | Alaska | 2185 | 2621 | 6 |
1846569 | 1846569 | 2021-10-24 | Carroll | Indiana | 18015 | 2621 | 36 |
1843319 | 1843319 | 2021-10-23 | Carroll | Indiana | 18015 | 2621 | 36 |
1840069 | 1840069 | 2021-10-22 | Carroll | Indiana | 18015 | 2621 | 36 |
1784890 | 1784890 | 2021-10-05 | Perry | Indiana | 18123 | 2621 | 57 |
1781346 | 1781346 | 2021-10-04 | Jefferson | Georgia | 13163 | 2621 | 80 |
1768793 | 1768793 | 2021-09-30 | Dickinson | Kansas | 20041 | 2621 | 59 |
1765544 | 1765544 | 2021-09-29 | Dickinson | Kansas | 20041 | 2621 | 59 |
1756322 | 1756322 | 2021-09-26 | Holmes | Mississippi | 28051 | 2621 | 87 |
1753074 | 1753074 | 2021-09-25 | Holmes | Mississippi | 28051 | 2621 | 87 |
1749826 | 1749826 | 2021-09-24 | Holmes | Mississippi | 28051 | 2621 | 87 |
1720662 | 1720662 | 2021-09-15 | Clinton | Missouri | 29049 | 2621 | 75 |
1713735 | 1713735 | 2021-09-13 | Morgan | Kentucky | 21175 | 2621 | 5 |
1710178 | 1710178 | 2021-09-12 | Starke | Indiana | 18149 | 2621 | 62 |
1706931 | 1706931 | 2021-09-11 | Starke | Indiana | 18149 | 2621 | 62 |
1703683 | 1703683 | 2021-09-10 | Starke | Indiana | 18149 | 2621 | 62 |
1701242 | 1701242 | 2021-09-09 | Ray | Missouri | 29177 | 2621 | 40 |
1679350 | 1679350 | 2021-09-02 | Hampton | South Carolina | 45049 | 2621 | 60 |
1657228 | 1657228 | 2021-08-26 | Waynesboro city | Virginia | 51820 | 2621 | 39 |
1640564 | 1640564 | 2021-08-21 | Austin | Texas | 48015 | 2621 | 39 |
1636288 | 1636288 | 2021-08-20 | Texas | Missouri | 29215 | 2621 | 31 |
1632209 | 1632209 | 2021-08-19 | Spencer | Indiana | 18147 | 2621 | 31 |
1623834 | 1623834 | 2021-08-16 | Van Wert | Ohio | 39161 | 2621 | 65 |
1604953 | 1604953 | 2021-08-10 | Jones | Texas | 48253 | 2621 | 56 |
1602176 | 1602176 | 2021-08-09 | Waushara | Wisconsin | 55137 | 2621 | 38 |
1585072 | 1585072 | 2021-08-04 | Gurabo | Puerto Rico | 72063 | 2621 | |
1581825 | 1581825 | 2021-08-03 | Humacao | Puerto Rico | 72069 | 2621 | |
1534612 | 1534612 | 2021-07-20 | Douglas | Illinois | 17041 | 2621 | 42 |
1518654 | 1518654 | 2021-07-15 | Barton | Kansas | 20009 | 2621 | 51 |
1515407 | 1515407 | 2021-07-14 | Barton | Kansas | 20009 | 2621 | 51 |
1512161 | 1512161 | 2021-07-13 | Barton | Kansas | 20009 | 2621 | 51 |
1508914 | 1508914 | 2021-07-12 | Barton | Kansas | 20009 | 2621 | 51 |
1505450 | 1505450 | 2021-07-11 | Saline | Illinois | 17165 | 2621 | 73 |
1502204 | 1502204 | 2021-07-10 | Saline | Illinois | 17165 | 2621 | 73 |
1498958 | 1498958 | 2021-07-09 | Saline | Illinois | 17165 | 2621 | 73 |
1495711 | 1495711 | 2021-07-08 | Saline | Illinois | 17165 | 2621 | 73 |
1494203 | 1494203 | 2021-07-07 | Barnwell | South Carolina | 45011 | 2621 | 58 |
1490956 | 1490956 | 2021-07-06 | Barnwell | South Carolina | 45011 | 2621 | 58 |
1475844 | 1475844 | 2021-07-02 | Pitkin | Colorado | 8097 | 2621 | 4 |
1466332 | 1466332 | 2021-06-29 | Sumter | Georgia | 13261 | 2621 | 106 |
1463087 | 1463087 | 2021-06-28 | Sumter | Georgia | 13261 | 2621 | 106 |
1459842 | 1459842 | 2021-06-27 | Sumter | Georgia | 13261 | 2621 | 106 |
1456597 | 1456597 | 2021-06-26 | Sumter | Georgia | 13261 | 2621 | 106 |
1453276 | 1453276 | 2021-06-25 | Emanuel | Georgia | 13107 | 2621 | 83 |
1443997 | 1443997 | 2021-06-22 | Barton | Kansas | 20009 | 2621 | 51 |
1444317 | 1444317 | 2021-06-22 | Somerset | Maryland | 24039 | 2621 | 40 |
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);