ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 5779 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Kentucky 9
- Iowa 8
- Illinois 7
- Michigan 7
- Virginia 6
- Georgia 5
- Indiana 5
- Mississippi 5
- Missouri 5
- North Carolina 5
- Texas 5
- Oregon 4
- West Virginia 4
- Ohio 3
- Alabama 2
- Arizona 2
- Florida 2
- Minnesota 2
- South Carolina 2
- Arkansas 1
- Colorado 1
- Louisiana 1
- Montana 1
- New York 1
- Oklahoma 1
- Pennsylvania 1
- South Dakota 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500889 | 2500889 | 2022-05-13 | Otsego | Michigan | 26137 | 5779 | 101 |
2497631 | 2497631 | 2022-05-12 | Otsego | Michigan | 26137 | 5779 | 101 |
2392570 | 2392570 | 2022-04-10 | Grady | Georgia | 13131 | 5779 | 111 |
2389314 | 2389314 | 2022-04-09 | Grady | Georgia | 13131 | 5779 | 111 |
2386059 | 2386059 | 2022-04-08 | Grady | Georgia | 13131 | 5779 | 111 |
2373043 | 2373043 | 2022-04-04 | Grady | Georgia | 13131 | 5779 | 110 |
2371283 | 2371283 | 2022-04-03 | Greene | North Carolina | 37079 | 5779 | 61 |
2368030 | 2368030 | 2022-04-02 | Greene | North Carolina | 37079 | 5779 | 61 |
2364777 | 2364777 | 2022-04-01 | Greene | North Carolina | 37079 | 5779 | 61 |
2347646 | 2347646 | 2022-03-27 | Meade | Kentucky | 21163 | 5779 | 64 |
2344393 | 2344393 | 2022-03-26 | Meade | Kentucky | 21163 | 5779 | 64 |
2341140 | 2341140 | 2022-03-25 | Meade | Kentucky | 21163 | 5779 | 64 |
2337887 | 2337887 | 2022-03-24 | Meade | Kentucky | 21163 | 5779 | 64 |
2334633 | 2334633 | 2022-03-23 | Meade | Kentucky | 21163 | 5779 | 64 |
2331379 | 2331379 | 2022-03-22 | Meade | Kentucky | 21163 | 5779 | 64 |
2328127 | 2328127 | 2022-03-21 | Meade | Kentucky | 21163 | 5779 | 64 |
2302585 | 2302585 | 2022-03-13 | McDonald | Missouri | 29119 | 5779 | 66 |
2299333 | 2299333 | 2022-03-12 | McDonald | Missouri | 29119 | 5779 | 66 |
2296081 | 2296081 | 2022-03-11 | McDonald | Missouri | 29119 | 5779 | 66 |
2292829 | 2292829 | 2022-03-10 | McDonald | Missouri | 29119 | 5779 | 66 |
2286654 | 2286654 | 2022-03-08 | Seneca | New York | 36099 | 5779 | 89 |
2270923 | 2270923 | 2022-03-03 | Barnwell | South Carolina | 45011 | 5779 | 95 |
2223993 | 2223993 | 2022-02-17 | Bourbon | Kentucky | 21017 | 5779 | 49 |
2200506 | 2200506 | 2022-02-10 | Montezuma | Colorado | 8083 | 5779 | 63 |
2199404 | 2199404 | 2022-02-09 | Fairfield | South Carolina | 45039 | 5779 | 101 |
2141661 | 2141661 | 2022-01-23 | Bibb | Alabama | 1007 | 5779 | 95 |
2124200 | 2124200 | 2022-01-17 | Adams | Ohio | 39001 | 5779 | 124 |
2124281 | 2124281 | 2022-01-17 | Van Wert | Ohio | 39161 | 5779 | 120 |
2119599 | 2119599 | 2022-01-16 | Clay | Indiana | 18021 | 5779 | 75 |
2116347 | 2116347 | 2022-01-15 | Clay | Indiana | 18021 | 5779 | 75 |
2113096 | 2113096 | 2022-01-14 | Clay | Indiana | 18021 | 5779 | 75 |
2098880 | 2098880 | 2022-01-09 | Kendall | Texas | 48259 | 5779 | 103 |
1995856 | 1995856 | 2021-12-09 | Pickens | Georgia | 13227 | 5779 | 122 |
1982226 | 1982226 | 2021-12-04 | Marshall | West Virginia | 54051 | 5779 | 122 |
1918434 | 1918434 | 2021-11-15 | Muhlenberg | Kentucky | 21177 | 5779 | 94 |
1893577 | 1893577 | 2021-11-07 | Benton | Oregon | 41003 | 5779 | 31 |
1894396 | 1894396 | 2021-11-07 | Tazewell | Virginia | 51185 | 5779 | 108 |
1890327 | 1890327 | 2021-11-06 | Benton | Oregon | 41003 | 5779 | 31 |
1891146 | 1891146 | 2021-11-06 | Tazewell | Virginia | 51185 | 5779 | 108 |
1887077 | 1887077 | 2021-11-05 | Benton | Oregon | 41003 | 5779 | 31 |
1887896 | 1887896 | 2021-11-05 | Tazewell | Virginia | 51185 | 5779 | 108 |
1877350 | 1877350 | 2021-11-02 | Malheur | Oregon | 41045 | 5779 | 80 |
1871339 | 1871339 | 2021-10-31 | Howard | Texas | 48227 | 5779 | 135 |
1868090 | 1868090 | 2021-10-30 | Howard | Texas | 48227 | 5779 | 135 |
1860983 | 1860983 | 2021-10-28 | Preble | Ohio | 39135 | 5779 | 125 |
1842090 | 1842090 | 2021-10-22 | Hill | Texas | 48217 | 5779 | 156 |
1809838 | 1809838 | 2021-10-12 | Franklin | Virginia | 51067 | 5779 | 96 |
1806727 | 1806727 | 2021-10-11 | Fayette | West Virginia | 54019 | 5779 | 111 |
1793754 | 1793754 | 2021-10-07 | Ohio | West Virginia | 54069 | 5779 | 99 |
1751663 | 1751663 | 2021-09-25 | Franklin | Alabama | 1059 | 5779 | 101 |
1738170 | 1738170 | 2021-09-20 | Matagorda | Texas | 48321 | 5779 | 141 |
1710860 | 1710860 | 2021-09-12 | Marshall | Mississippi | 28093 | 5779 | 115 |
1707613 | 1707613 | 2021-09-11 | Marshall | Mississippi | 28093 | 5779 | 115 |
1704366 | 1704366 | 2021-09-10 | Marshall | Mississippi | 28093 | 5779 | 115 |
1701166 | 1701166 | 2021-09-09 | Camden | Missouri | 29029 | 5779 | 114 |
1673466 | 1673466 | 2021-08-31 | Washington | Virginia | 51191 | 5779 | 115 |
1669634 | 1669634 | 2021-08-30 | Brown | South Dakota | 46013 | 5779 | 95 |
1654053 | 1654053 | 2021-08-25 | Mercer | West Virginia | 54055 | 5779 | 129 |
1625751 | 1625751 | 2021-08-17 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1622504 | 1622504 | 2021-08-16 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1619257 | 1619257 | 2021-08-15 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1616009 | 1616009 | 2021-08-14 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1612760 | 1612760 | 2021-08-13 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1609512 | 1609512 | 2021-08-12 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1606263 | 1606263 | 2021-08-11 | Cerro Gordo | Iowa | 19033 | 5779 | 98 |
1531914 | 1531914 | 2021-07-19 | St. Martin | Louisiana | 22099 | 5779 | 119 |
1509267 | 1509267 | 2021-07-12 | Branch | Michigan | 26023 | 5779 | 121 |
1506021 | 1506021 | 2021-07-11 | Branch | Michigan | 26023 | 5779 | 121 |
1502775 | 1502775 | 2021-07-10 | Branch | Michigan | 26023 | 5779 | 121 |
1499529 | 1499529 | 2021-07-09 | Branch | Michigan | 26023 | 5779 | 121 |
1485904 | 1485904 | 2021-07-05 | Coles | Illinois | 17029 | 5779 | 103 |
1482658 | 1482658 | 2021-07-04 | Coles | Illinois | 17029 | 5779 | 103 |
1479411 | 1479411 | 2021-07-03 | Coles | Illinois | 17029 | 5779 | 103 |
1476165 | 1476165 | 2021-07-02 | Coles | Illinois | 17029 | 5779 | 103 |
1472919 | 1472919 | 2021-07-01 | Coles | Illinois | 17029 | 5779 | 103 |
1469673 | 1469673 | 2021-06-30 | Coles | Illinois | 17029 | 5779 | 103 |
1466428 | 1466428 | 2021-06-29 | Coles | Illinois | 17029 | 5779 | 103 |
1350301 | 1350301 | 2021-05-24 | Benton | Minnesota | 27009 | 5779 | 97 |
1337362 | 1337362 | 2021-05-20 | Otter Tail | Minnesota | 27111 | 5779 | 78 |
1327127 | 1327127 | 2021-05-17 | Warren | Iowa | 19181 | 5779 | 89 |
1325920 | 1325920 | 2021-05-16 | Albemarle | Virginia | 51003 | 5779 | 83 |
1224617 | 1224617 | 2021-04-15 | Carbon | Pennsylvania | 42025 | 5779 | 160 |
1216002 | 1216002 | 2021-04-13 | Mississippi | Arkansas | 5093 | 5779 | 106 |
1106888 | 1106888 | 2021-03-10 | Lafayette | Mississippi | 28071 | 5779 | 114 |
1050634 | 1050634 | 2021-02-21 | Putnam | Florida | 12107 | 5779 | 122 |
1049167 | 1049167 | 2021-02-20 | Bryan | Oklahoma | 40013 | 5779 | 52 |
996542 | 996542 | 2021-02-04 | Lowndes | Mississippi | 28087 | 5779 | 130 |
994931 | 994931 | 2021-02-03 | Whatcom | Washington | 53073 | 5779 | 66 |
945139 | 945139 | 2021-01-19 | Sampson | North Carolina | 37163 | 5779 | 73 |
868620 | 868620 | 2020-12-27 | Santa Cruz | Arizona | 4023 | 5779 | 93 |
834460 | 834460 | 2020-12-16 | Missoula | Montana | 30063 | 5779 | 45 |
797832 | 797832 | 2020-12-05 | Delaware | Indiana | 18035 | 5779 | 113 |
791334 | 791334 | 2020-12-03 | Clark | Indiana | 18019 | 5779 | 93 |
779641 | 779641 | 2020-11-29 | Wayne | North Carolina | 37191 | 5779 | 112 |
739057 | 739057 | 2020-11-17 | Martin | Florida | 12085 | 5779 | 170 |
684862 | 684862 | 2020-10-31 | Ottawa | Michigan | 26139 | 5779 | 78 |
127342 | 127342 | 2020-05-09 | Maricopa | Arizona | 4013 | 5779 | 245 |
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);