ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 5428 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Kentucky 16
- Georgia 15
- Texas 8
- Iowa 7
- Ohio 6
- Pennsylvania 6
- Wisconsin 6
- Minnesota 4
- Tennessee 4
- Alabama 3
- Alaska 3
- Arkansas 3
- Illinois 3
- Indiana 3
- New Hampshire 3
- New York 3
- South Carolina 3
- California 2
- Florida 2
- Kansas 2
- Michigan 2
- Mississippi 2
- Utah 2
- Maine 1
- Maryland 1
- Missouri 1
- North Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500628 | 2500628 | 2022-05-13 | Hart | Kentucky | 21099 | 5428 | 101 |
2497370 | 2497370 | 2022-05-12 | Hart | Kentucky | 21099 | 5428 | 101 |
2494112 | 2494112 | 2022-05-11 | Hart | Kentucky | 21099 | 5428 | 101 |
2490854 | 2490854 | 2022-05-10 | Hart | Kentucky | 21099 | 5428 | 101 |
2487597 | 2487597 | 2022-05-09 | Hart | Kentucky | 21099 | 5428 | 101 |
2476894 | 2476894 | 2022-05-06 | Columbia | Arkansas | 5027 | 5428 | 95 |
2473636 | 2473636 | 2022-05-05 | Columbia | Arkansas | 5027 | 5428 | 95 |
2379555 | 2379555 | 2022-04-06 | Haralson | Georgia | 13143 | 5428 | 167 |
2373049 | 2373049 | 2022-04-04 | Haralson | Georgia | 13143 | 5428 | 166 |
2369796 | 2369796 | 2022-04-03 | Haralson | Georgia | 13143 | 5428 | 165 |
2366543 | 2366543 | 2022-04-02 | Haralson | Georgia | 13143 | 5428 | 165 |
2363290 | 2363290 | 2022-04-01 | Haralson | Georgia | 13143 | 5428 | 165 |
2360036 | 2360036 | 2022-03-31 | Haralson | Georgia | 13143 | 5428 | 165 |
2356782 | 2356782 | 2022-03-30 | Haralson | Georgia | 13143 | 5428 | 165 |
2355971 | 2355971 | 2022-03-29 | Sevier | Utah | 49041 | 5428 | 30 |
2352718 | 2352718 | 2022-03-28 | Sevier | Utah | 49041 | 5428 | 30 |
2311281 | 2311281 | 2022-03-16 | Pike | Georgia | 13231 | 5428 | 89 |
2307686 | 2307686 | 2022-03-15 | Ouachita | Arkansas | 5103 | 5428 | 98 |
2274549 | 2274549 | 2022-03-04 | Moore | Texas | 48341 | 5428 | 110 |
2256495 | 2256495 | 2022-02-27 | Adair | Kentucky | 21001 | 5428 | 99 |
2253244 | 2253244 | 2022-02-26 | Adair | Kentucky | 21001 | 5428 | 99 |
2249993 | 2249993 | 2022-02-25 | Adair | Kentucky | 21001 | 5428 | 99 |
2247147 | 2247147 | 2022-02-24 | Wabasha | Minnesota | 27157 | 5428 | 16 |
2230686 | 2230686 | 2022-02-19 | Waldo | Maine | 23027 | 5428 | 52 |
2221104 | 2221104 | 2022-02-16 | Martin | Minnesota | 27091 | 5428 | 59 |
2157115 | 2157115 | 2022-01-27 | Jasper | South Carolina | 45053 | 5428 | 83 |
2133202 | 2133202 | 2022-01-20 | Oceana | Michigan | 26127 | 5428 | 86 |
2129949 | 2129949 | 2022-01-19 | Oceana | Michigan | 26127 | 5428 | 86 |
2066041 | 2066041 | 2021-12-30 | Clarendon | South Carolina | 45027 | 5428 | 137 |
2023227 | 2023227 | 2021-12-17 | Greene | New York | 36039 | 5428 | 94 |
2006897 | 2006897 | 2021-12-12 | Sullivan | New Hampshire | 33019 | 5428 | 40 |
2003646 | 2003646 | 2021-12-11 | Sullivan | New Hampshire | 33019 | 5428 | 40 |
2000396 | 2000396 | 2021-12-10 | Sullivan | New Hampshire | 33019 | 5428 | 40 |
1972649 | 1972649 | 2021-12-02 | Marion | Alabama | 1093 | 5428 | 130 |
1915120 | 1915120 | 2021-11-14 | Clark | Kentucky | 21049 | 5428 | 42 |
1911870 | 1911870 | 2021-11-13 | Clark | Kentucky | 21049 | 5428 | 42 |
1908621 | 1908621 | 2021-11-12 | Clark | Kentucky | 21049 | 5428 | 42 |
1909877 | 1909877 | 2021-11-12 | Clinton | Pennsylvania | 42035 | 5428 | 81 |
1875635 | 1875635 | 2021-11-02 | Upson | Georgia | 13293 | 5428 | 178 |
1876148 | 1876148 | 2021-11-02 | Harlan | Kentucky | 21095 | 5428 | 131 |
1854805 | 1854805 | 2021-10-26 | Marion | South Carolina | 45067 | 5428 | 138 |
1854897 | 1854897 | 2021-10-26 | Claiborne | Tennessee | 47025 | 5428 | 112 |
1846385 | 1846385 | 2021-10-24 | Toombs | Georgia | 13279 | 5428 | 167 |
1843135 | 1843135 | 2021-10-23 | Toombs | Georgia | 13279 | 5428 | 167 |
1839885 | 1839885 | 2021-10-22 | Toombs | Georgia | 13279 | 5428 | 167 |
1833048 | 1833048 | 2021-10-20 | Amador | California | 6005 | 5428 | 64 |
1834759 | 1834759 | 2021-10-20 | Warren | New York | 36113 | 5428 | 84 |
1800438 | 1800438 | 2021-10-10 | Bethel Census Area | Alaska | 2050 | 5428 | 25 |
1801478 | 1801478 | 2021-10-10 | Taylor | Kentucky | 21217 | 5428 | 79 |
1797189 | 1797189 | 2021-10-09 | Bethel Census Area | Alaska | 2050 | 5428 | 25 |
1798229 | 1798229 | 2021-10-09 | Taylor | Kentucky | 21217 | 5428 | 79 |
1793940 | 1793940 | 2021-10-08 | Bethel Census Area | Alaska | 2050 | 5428 | 25 |
1794980 | 1794980 | 2021-10-08 | Taylor | Kentucky | 21217 | 5428 | 79 |
1793243 | 1793243 | 2021-10-07 | White | Tennessee | 47185 | 5428 | 92 |
1781555 | 1781555 | 2021-10-04 | Randolph | Illinois | 17157 | 5428 | 104 |
1748305 | 1748305 | 2021-09-23 | Douglas | Wisconsin | 55031 | 5428 | 66 |
1739517 | 1739517 | 2021-09-21 | Sioux | Iowa | 19167 | 5428 | 75 |
1736268 | 1736268 | 2021-09-20 | Sioux | Iowa | 19167 | 5428 | 75 |
1733018 | 1733018 | 2021-09-19 | Sioux | Iowa | 19167 | 5428 | 75 |
1729768 | 1729768 | 2021-09-18 | Sioux | Iowa | 19167 | 5428 | 75 |
1726518 | 1726518 | 2021-09-17 | Sioux | Iowa | 19167 | 5428 | 75 |
1723269 | 1723269 | 2021-09-16 | Sioux | Iowa | 19167 | 5428 | 75 |
1720020 | 1720020 | 2021-09-15 | Sioux | Iowa | 19167 | 5428 | 75 |
1714057 | 1714057 | 2021-09-13 | Winona | Minnesota | 27169 | 5428 | 52 |
1712593 | 1712593 | 2021-09-12 | Monroe | Wisconsin | 55081 | 5428 | 52 |
1709346 | 1709346 | 2021-09-11 | Monroe | Wisconsin | 55081 | 5428 | 52 |
1706099 | 1706099 | 2021-09-10 | Monroe | Wisconsin | 55081 | 5428 | 52 |
1689521 | 1689521 | 2021-09-05 | Waller | Texas | 48473 | 5428 | 57 |
1674397 | 1674397 | 2021-09-01 | Harrison | Indiana | 18061 | 5428 | 82 |
1660728 | 1660728 | 2021-08-28 | Russell | Alabama | 1113 | 5428 | 51 |
1597851 | 1597851 | 2021-08-08 | Washington | Ohio | 39167 | 5428 | 111 |
1477627 | 1477627 | 2021-07-02 | Darke | Ohio | 39037 | 5428 | 129 |
1451077 | 1451077 | 2021-06-24 | Washington | Mississippi | 28151 | 5428 | 138 |
1435665 | 1435665 | 2021-06-19 | Mifflin | Pennsylvania | 42087 | 5428 | 180 |
1432418 | 1432418 | 2021-06-18 | Mifflin | Pennsylvania | 42087 | 5428 | 180 |
1367332 | 1367332 | 2021-05-29 | Sandusky | Ohio | 39143 | 5428 | 124 |
1364086 | 1364086 | 2021-05-28 | Sandusky | Ohio | 39143 | 5428 | 124 |
1232845 | 1232845 | 2021-04-18 | Noble | Indiana | 18113 | 5428 | 86 |
1188906 | 1188906 | 2021-04-04 | Indiana | Pennsylvania | 42063 | 5428 | 163 |
1177502 | 1177502 | 2021-04-01 | Grundy | Illinois | 17063 | 5428 | 74 |
1092929 | 1092929 | 2021-03-06 | Laurens | Georgia | 13175 | 5428 | 161 |
1094302 | 1094302 | 2021-03-06 | Cayuga | New York | 36011 | 5428 | 89 |
1086438 | 1086438 | 2021-03-04 | Laurens | Georgia | 13175 | 5428 | 159 |
1076977 | 1076977 | 2021-03-01 | Marshall | Indiana | 18099 | 5428 | 105 |
1070073 | 1070073 | 2021-02-27 | Gadsden | Florida | 12039 | 5428 | 83 |
1033547 | 1033547 | 2021-02-15 | Lamar | Texas | 48277 | 5428 | 139 |
1030301 | 1030301 | 2021-02-14 | Lamar | Texas | 48277 | 5428 | 138 |
1027054 | 1027054 | 2021-02-13 | Lamar | Texas | 48277 | 5428 | 138 |
1023809 | 1023809 | 2021-02-12 | Lamar | Texas | 48277 | 5428 | 137 |
1009168 | 1009168 | 2021-02-08 | Pulaski | Kentucky | 21199 | 5428 | 78 |
1007618 | 1007618 | 2021-02-07 | Navarro | Texas | 48349 | 5428 | 104 |
1004372 | 1004372 | 2021-02-06 | Navarro | Texas | 48349 | 5428 | 104 |
998943 | 998943 | 2021-02-05 | Clinton | Illinois | 17027 | 5428 | 94 |
984186 | 984186 | 2021-01-31 | Geauga | Ohio | 39055 | 5428 | 56 |
979227 | 979227 | 2021-01-30 | Putnam | Florida | 12107 | 5428 | 101 |
975580 | 975580 | 2021-01-28 | Waupaca | Wisconsin | 55135 | 5428 | 149 |
966851 | 966851 | 2021-01-26 | Saline | Kansas | 20169 | 5428 | 88 |
963606 | 963606 | 2021-01-25 | Saline | Kansas | 20169 | 5428 | 88 |
912154 | 912154 | 2021-01-09 | Lauderdale | Mississippi | 28075 | 5428 | 173 |
868726 | 868726 | 2020-12-27 | Napa | California | 6055 | 5428 | 27 |
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);