ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 6149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Tennessee 14
- Kansas 7
- Oklahoma 7
- Rhode Island 7
- Pennsylvania 6
- Michigan 5
- Ohio 5
- Kentucky 4
- North Carolina 4
- Alabama 3
- New York 3
- Virginia 3
- Indiana 2
- Washington 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Georgia 1
- Louisiana 1
- Maryland 1
- Missouri 1
- Montana 1
- New Mexico 1
- Puerto Rico 1
- Vermont 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474420 | 2474420 | 2022-05-05 | Cherokee | Kansas | 20021 | 6149 | 84 |
2471163 | 2471163 | 2022-05-04 | Cherokee | Kansas | 20021 | 6149 | 84 |
2467907 | 2467907 | 2022-05-03 | Cherokee | Kansas | 20021 | 6149 | 84 |
2464652 | 2464652 | 2022-05-02 | Cherokee | Kansas | 20021 | 6149 | 84 |
2461396 | 2461396 | 2022-05-01 | Cherokee | Kansas | 20021 | 6149 | 84 |
2458140 | 2458140 | 2022-04-30 | Cherokee | Kansas | 20021 | 6149 | 84 |
2454884 | 2454884 | 2022-04-29 | Cherokee | Kansas | 20021 | 6149 | 84 |
2404292 | 2404292 | 2022-04-13 | Vega Alta | Puerto Rico | 72143 | 6149 | |
2380968 | 2380968 | 2022-04-06 | Lewis | New York | 36049 | 6149 | 49 |
2350103 | 2350103 | 2022-03-28 | Montezuma | Colorado | 8083 | 6149 | 72 |
2329965 | 2329965 | 2022-03-21 | Orleans | Vermont | 50019 | 6149 | 37 |
2287372 | 2287372 | 2022-03-08 | Smith | Tennessee | 47159 | 6149 | 74 |
2284120 | 2284120 | 2022-03-07 | Smith | Tennessee | 47159 | 6149 | 74 |
2280868 | 2280868 | 2022-03-06 | Smith | Tennessee | 47159 | 6149 | 74 |
2277615 | 2277615 | 2022-03-05 | Smith | Tennessee | 47159 | 6149 | 74 |
2274362 | 2274362 | 2022-03-04 | Smith | Tennessee | 47159 | 6149 | 74 |
2271109 | 2271109 | 2022-03-03 | Smith | Tennessee | 47159 | 6149 | 74 |
2267857 | 2267857 | 2022-03-02 | Smith | Tennessee | 47159 | 6149 | 74 |
2261741 | 2261741 | 2022-02-28 | Lee | Virginia | 51105 | 6149 | 83 |
2239268 | 2239268 | 2022-02-22 | Geneva | Alabama | 1061 | 6149 | 149 |
2196271 | 2196271 | 2022-02-08 | Grainger | Tennessee | 47057 | 6149 | 98 |
2191460 | 2191460 | 2022-02-07 | Allen | Kentucky | 21003 | 6149 | 92 |
2193017 | 2193017 | 2022-02-07 | Grainger | Tennessee | 47057 | 6149 | 98 |
2189763 | 2189763 | 2022-02-06 | Grainger | Tennessee | 47057 | 6149 | 98 |
2186510 | 2186510 | 2022-02-05 | Grainger | Tennessee | 47057 | 6149 | 98 |
2183258 | 2183258 | 2022-02-04 | Grainger | Tennessee | 47057 | 6149 | 98 |
2180006 | 2180006 | 2022-02-03 | Grainger | Tennessee | 47057 | 6149 | 98 |
2176755 | 2176755 | 2022-02-02 | Grainger | Tennessee | 47057 | 6149 | 98 |
2151281 | 2151281 | 2022-01-25 | Hancock | West Virginia | 54029 | 6149 | 130 |
2107964 | 2107964 | 2022-01-12 | Fayette | Ohio | 39047 | 6149 | 85 |
2086283 | 2086283 | 2022-01-05 | Clark | Wisconsin | 55019 | 6149 | 106 |
2032949 | 2032949 | 2021-12-20 | Rio Arriba | New Mexico | 35039 | 6149 | 89 |
1945006 | 1945006 | 2021-11-23 | Silver Bow | Montana | 30093 | 6149 | 107 |
1921721 | 1921721 | 2021-11-16 | Beauregard | Louisiana | 22011 | 6149 | 124 |
1900258 | 1900258 | 2021-11-09 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1897008 | 1897008 | 2021-11-08 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1893758 | 1893758 | 2021-11-07 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1890508 | 1890508 | 2021-11-06 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1887258 | 1887258 | 2021-11-05 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1884008 | 1884008 | 2021-11-04 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1880759 | 1880759 | 2021-11-03 | Bristol | Rhode Island | 44001 | 6149 | 149 |
1766922 | 1766922 | 2021-09-29 | Huntingdon | Pennsylvania | 42061 | 6149 | 144 |
1733175 | 1733175 | 2021-09-19 | Floyd | Kentucky | 21071 | 6149 | 87 |
1729925 | 1729925 | 2021-09-18 | Floyd | Kentucky | 21071 | 6149 | 87 |
1726675 | 1726675 | 2021-09-17 | Floyd | Kentucky | 21071 | 6149 | 87 |
1712708 | 1712708 | 2021-09-13 | Tallapoosa | Alabama | 1123 | 6149 | 163 |
1636823 | 1636823 | 2021-08-20 | Union | Ohio | 39159 | 6149 | 49 |
1630131 | 1630131 | 2021-08-18 | Halifax | North Carolina | 37083 | 6149 | 116 |
1602224 | 1602224 | 2021-08-10 | Dale | Alabama | 1045 | 6149 | 121 |
1580233 | 1580233 | 2021-08-03 | Shelby | Indiana | 18145 | 6149 | 109 |
1579304 | 1579304 | 2021-08-02 | Walla Walla | Washington | 53071 | 6149 | 72 |
1523274 | 1523274 | 2021-07-16 | Bradford | Pennsylvania | 42015 | 6149 | 96 |
1431979 | 1431979 | 2021-06-18 | Jefferson | New York | 36045 | 6149 | 68 |
1428733 | 1428733 | 2021-06-17 | Jefferson | New York | 36045 | 6149 | 68 |
1419194 | 1419194 | 2021-06-14 | Belmont | Ohio | 39013 | 6149 | 174 |
1415949 | 1415949 | 2021-06-13 | Belmont | Ohio | 39013 | 6149 | 174 |
1378312 | 1378312 | 2021-06-02 | Crittenden | Arkansas | 5035 | 6149 | 97 |
1377096 | 1377096 | 2021-06-01 | Carter | Oklahoma | 40019 | 6149 | 125 |
1373850 | 1373850 | 2021-05-31 | Carter | Oklahoma | 40019 | 6149 | 125 |
1370605 | 1370605 | 2021-05-30 | Carter | Oklahoma | 40019 | 6149 | 125 |
1366749 | 1366749 | 2021-05-29 | Joplin | Missouri | 6149 | 108 | |
1367359 | 1367359 | 2021-05-29 | Carter | Oklahoma | 40019 | 6149 | 125 |
1364113 | 1364113 | 2021-05-28 | Carter | Oklahoma | 40019 | 6149 | 125 |
1360867 | 1360867 | 2021-05-27 | Carter | Oklahoma | 40019 | 6149 | 125 |
1357621 | 1357621 | 2021-05-26 | Carter | Oklahoma | 40019 | 6149 | 125 |
1340547 | 1340547 | 2021-05-21 | St. Joseph | Michigan | 26149 | 6149 | 97 |
1291251 | 1291251 | 2021-05-06 | Dubois | Indiana | 18037 | 6149 | 118 |
1210622 | 1210622 | 2021-04-11 | Gratiot | Michigan | 26057 | 6149 | 110 |
1207373 | 1207373 | 2021-04-10 | Gratiot | Michigan | 26057 | 6149 | 110 |
1195036 | 1195036 | 2021-04-06 | Columbus | North Carolina | 37047 | 6149 | 149 |
1173359 | 1173359 | 2021-03-30 | Harrisonburg city | Virginia | 51660 | 6149 | 95 |
1055784 | 1055784 | 2021-02-22 | Clearfield | Pennsylvania | 42033 | 6149 | 113 |
1051524 | 1051524 | 2021-02-21 | Eaton | Michigan | 26045 | 6149 | 151 |
1048277 | 1048277 | 2021-02-20 | Eaton | Michigan | 26045 | 6149 | 151 |
1021454 | 1021454 | 2021-02-12 | Bulloch | Georgia | 13031 | 6149 | 83 |
1023329 | 1023329 | 2021-02-12 | Crawford | Pennsylvania | 42039 | 6149 | 133 |
981849 | 981849 | 2021-01-30 | Lynchburg city | Virginia | 51680 | 6149 | 71 |
961295 | 961295 | 2021-01-24 | Brunswick | North Carolina | 37019 | 6149 | 86 |
852252 | 852252 | 2020-12-21 | St. Croix | Wisconsin | 55109 | 6149 | 25 |
753599 | 753599 | 2020-11-21 | Catawba | North Carolina | 37035 | 6149 | 80 |
647974 | 647974 | 2020-10-20 | Navajo | Arizona | 4017 | 6149 | 236 |
646924 | 646924 | 2020-10-19 | Lehigh | Pennsylvania | 42077 | 6149 | 362 |
520511 | 520511 | 2020-09-10 | Chester | Pennsylvania | 42029 | 6149 | 361 |
468605 | 468605 | 2020-08-25 | Lucas | Ohio | 39095 | 6149 | 339 |
414734 | 414734 | 2020-08-08 | Pierce | Washington | 53053 | 6149 | 148 |
213407 | 213407 | 2020-06-06 | Baltimore city | Maryland | 24510 | 6149 | 276 |
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);