ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 5568 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Tennessee 10
- North Carolina 8
- Iowa 7
- Michigan 6
- Texas 5
- Utah 5
- West Virginia 5
- Indiana 4
- Minnesota 4
- Oregon 4
- Washington 4
- Louisiana 3
- New York 3
- Pennsylvania 3
- Wisconsin 3
- Georgia 2
- Kentucky 2
- Missouri 2
- Ohio 2
- Puerto Rico 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Massachusetts 1
- Mississippi 1
- New Jersey 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474923 | 2474923 | 2022-05-05 | Waseca | Minnesota | 27161 | 5568 | 39 |
2476641 | 2476641 | 2022-05-05 | Lincoln | West Virginia | 54043 | 5568 | 82 |
2380502 | 2380502 | 2022-04-06 | Wabasha | Minnesota | 27157 | 5568 | 16 |
2377247 | 2377247 | 2022-04-05 | Wabasha | Minnesota | 27157 | 5568 | 16 |
2326920 | 2326920 | 2022-03-20 | McDowell | West Virginia | 54047 | 5568 | 67 |
2323667 | 2323667 | 2022-03-19 | McDowell | West Virginia | 54047 | 5568 | 67 |
2320040 | 2320040 | 2022-03-18 | Karnes | Texas | 48255 | 5568 | 68 |
2320413 | 2320413 | 2022-03-18 | McDowell | West Virginia | 54047 | 5568 | 67 |
2316786 | 2316786 | 2022-03-17 | Karnes | Texas | 48255 | 5568 | 68 |
2308822 | 2308822 | 2022-03-15 | Menominee | Michigan | 26109 | 5568 | 69 |
2305571 | 2305571 | 2022-03-14 | Menominee | Michigan | 26109 | 5568 | 69 |
2302268 | 2302268 | 2022-03-13 | Alpena | Michigan | 26007 | 5568 | 133 |
2299016 | 2299016 | 2022-03-12 | Alpena | Michigan | 26007 | 5568 | 133 |
2295764 | 2295764 | 2022-03-11 | Alpena | Michigan | 26007 | 5568 | 133 |
2241860 | 2241860 | 2022-02-22 | Wayne | Tennessee | 47181 | 5568 | 53 |
2238609 | 2238609 | 2022-02-21 | Wayne | Tennessee | 47181 | 5568 | 53 |
2235358 | 2235358 | 2022-02-20 | Wayne | Tennessee | 47181 | 5568 | 53 |
2232107 | 2232107 | 2022-02-19 | Wayne | Tennessee | 47181 | 5568 | 53 |
2228856 | 2228856 | 2022-02-18 | Wayne | Tennessee | 47181 | 5568 | 53 |
2225605 | 2225605 | 2022-02-17 | Wayne | Tennessee | 47181 | 5568 | 53 |
2222354 | 2222354 | 2022-02-16 | Wayne | Tennessee | 47181 | 5568 | 53 |
2189441 | 2189441 | 2022-02-06 | Crook | Oregon | 41013 | 5568 | 64 |
2186188 | 2186188 | 2022-02-05 | Crook | Oregon | 41013 | 5568 | 64 |
2182936 | 2182936 | 2022-02-04 | Crook | Oregon | 41013 | 5568 | 64 |
2127488 | 2127488 | 2022-01-18 | Hocking | Ohio | 39073 | 5568 | 104 |
2111829 | 2111829 | 2022-01-13 | Fannin | Texas | 48147 | 5568 | 156 |
2111937 | 2111937 | 2022-01-13 | Palo Pinto | Texas | 48363 | 5568 | 132 |
2030928 | 2030928 | 2021-12-19 | Clallam | Washington | 53009 | 5568 | 79 |
2027677 | 2027677 | 2021-12-18 | Clallam | Washington | 53009 | 5568 | 79 |
2024426 | 2024426 | 2021-12-17 | Clallam | Washington | 53009 | 5568 | 79 |
1991756 | 1991756 | 2021-12-07 | Uintah | Utah | 49047 | 5568 | 54 |
1984327 | 1984327 | 2021-12-05 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1981077 | 1981077 | 2021-12-04 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1977827 | 1977827 | 2021-12-03 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1971235 | 1971235 | 2021-12-01 | Orleans | New York | 36073 | 5568 | 96 |
1968686 | 1968686 | 2021-11-30 | Macon | Tennessee | 47111 | 5568 | 95 |
1948453 | 1948453 | 2021-11-24 | Columbia | New York | 36021 | 5568 | 113 |
1940838 | 1940838 | 2021-11-22 | Jefferson | Indiana | 18077 | 5568 | 105 |
1943179 | 1943179 | 2021-11-22 | Okanogan | Washington | 53047 | 5568 | 92 |
1890245 | 1890245 | 2021-11-06 | Williams | Ohio | 39171 | 5568 | 92 |
1833949 | 1833949 | 2021-10-20 | Muhlenberg | Kentucky | 21177 | 5568 | 88 |
1807748 | 1807748 | 2021-10-12 | Sioux | Iowa | 19167 | 5568 | 76 |
1804497 | 1804497 | 2021-10-11 | Sioux | Iowa | 19167 | 5568 | 76 |
1801248 | 1801248 | 2021-10-10 | Sioux | Iowa | 19167 | 5568 | 76 |
1797999 | 1797999 | 2021-10-09 | Sioux | Iowa | 19167 | 5568 | 76 |
1794750 | 1794750 | 2021-10-08 | Sioux | Iowa | 19167 | 5568 | 76 |
1791502 | 1791502 | 2021-10-07 | Sioux | Iowa | 19167 | 5568 | 76 |
1788253 | 1788253 | 2021-10-06 | Sioux | Iowa | 19167 | 5568 | 76 |
1781883 | 1781883 | 2021-10-04 | Bell | Kentucky | 21013 | 5568 | 88 |
1691905 | 1691905 | 2021-09-06 | Vance | North Carolina | 37181 | 5568 | 92 |
1688655 | 1688655 | 2021-09-05 | Vance | North Carolina | 37181 | 5568 | 92 |
1685405 | 1685405 | 2021-09-04 | Vance | North Carolina | 37181 | 5568 | 92 |
1682154 | 1682154 | 2021-09-03 | Vance | North Carolina | 37181 | 5568 | 92 |
1675241 | 1675241 | 2021-09-01 | Phelps | Missouri | 29161 | 5568 | 164 |
1670336 | 1670336 | 2021-08-30 | Dunn | Wisconsin | 55033 | 5568 | 37 |
1664035 | 1664035 | 2021-08-29 | Boone | Arkansas | 5009 | 5568 | 99 |
1631311 | 1631311 | 2021-08-18 | Mercer | West Virginia | 54055 | 5568 | 129 |
1619596 | 1619596 | 2021-08-15 | Lincoln | Louisiana | 22061 | 5568 | 98 |
1616348 | 1616348 | 2021-08-14 | Lincoln | Louisiana | 22061 | 5568 | 98 |
1613099 | 1613099 | 2021-08-13 | Lincoln | Louisiana | 22061 | 5568 | 98 |
1604165 | 1604165 | 2021-08-10 | McDowell | North Carolina | 37111 | 5568 | 63 |
1601507 | 1601507 | 2021-08-09 | Franklin | Tennessee | 47051 | 5568 | 92 |
1554984 | 1554984 | 2021-07-26 | Callaway | Missouri | 29027 | 5568 | 51 |
1407025 | 1407025 | 2021-06-10 | Box Elder | Utah | 49003 | 5568 | 53 |
1361110 | 1361110 | 2021-05-27 | Unknown | Puerto Rico | 5568 | 2489 | |
1354618 | 1354618 | 2021-05-25 | Unknown | Puerto Rico | 5568 | 2480 | |
1345375 | 1345375 | 2021-05-22 | Summit | Utah | 49043 | 5568 | 13 |
1342127 | 1342127 | 2021-05-21 | Summit | Utah | 49043 | 5568 | 13 |
1338879 | 1338879 | 2021-05-20 | Summit | Utah | 49043 | 5568 | 13 |
1327498 | 1327498 | 2021-05-17 | Chippewa | Michigan | 26033 | 5568 | 49 |
1303615 | 1303615 | 2021-05-10 | Graham | Arizona | 4009 | 5568 | 79 |
1216581 | 1216581 | 2021-04-13 | Henry | Indiana | 18065 | 5568 | 102 |
1159235 | 1159235 | 2021-03-26 | Cayuga | New York | 36011 | 5568 | 90 |
1145115 | 1145115 | 2021-03-22 | Dearborn | Indiana | 18029 | 5568 | 75 |
1082045 | 1082045 | 2021-03-02 | Lawrence | Tennessee | 47099 | 5568 | 83 |
1023982 | 1023982 | 2021-02-12 | Bedford | Virginia | 51019 | 5568 | 42 |
1009518 | 1009518 | 2021-02-08 | Lafayette | Mississippi | 28071 | 5568 | 108 |
1007056 | 1007056 | 2021-02-07 | Deschutes | Oregon | 41017 | 5568 | 47 |
989925 | 989925 | 2021-02-02 | Blue Earth | Minnesota | 27013 | 5568 | 33 |
969121 | 969121 | 2021-01-27 | Blount | Alabama | 1009 | 5568 | 95 |
951458 | 951458 | 2021-01-21 | Warren | New Jersey | 34041 | 5568 | 191 |
914478 | 914478 | 2021-01-10 | Troup | Georgia | 13285 | 5568 | 132 |
805891 | 805891 | 2020-12-07 | Franklin | Pennsylvania | 42055 | 5568 | 135 |
784845 | 784845 | 2020-12-01 | Clark | Indiana | 18019 | 5568 | 88 |
774810 | 774810 | 2020-11-28 | Carroll | Georgia | 13045 | 5568 | 93 |
685858 | 685858 | 2020-10-31 | Northampton | Pennsylvania | 42095 | 5568 | 315 |
569096 | 569096 | 2020-09-25 | Lehigh | Pennsylvania | 42077 | 5568 | 353 |
520960 | 520960 | 2020-09-10 | Hays | Texas | 48209 | 5568 | 59 |
495525 | 495525 | 2020-09-02 | Dane | Wisconsin | 55025 | 5568 | 40 |
489114 | 489114 | 2020-08-31 | Waukesha | Wisconsin | 55133 | 5568 | 74 |
167512 | 167512 | 2020-05-22 | Hampden | Massachusetts | 25013 | 5568 | 537 |
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);