ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where cases = 4864 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Kansas 9
- North Carolina 8
- Illinois 6
- Alabama 5
- California 5
- South Dakota 5
- Washington 5
- Georgia 4
- Michigan 4
- Minnesota 4
- Virginia 4
- Iowa 3
- Ohio 3
- Tennessee 3
- Wyoming 3
- Indiana 2
- Oklahoma 2
- Pennsylvania 2
- Alaska 1
- Arkansas 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Missouri 1
- New York 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500050 | 2500050 | 2022-05-13 | Lamar | Georgia | 13171 | 4864 | 113 |
2501781 | 2501781 | 2022-05-13 | McIntosh | Oklahoma | 40091 | 4864 | 124 |
2496792 | 2496792 | 2022-05-12 | Lamar | Georgia | 13171 | 4864 | 113 |
2498523 | 2498523 | 2022-05-12 | McIntosh | Oklahoma | 40091 | 4864 | 124 |
2493534 | 2493534 | 2022-05-11 | Lamar | Georgia | 13171 | 4864 | 113 |
2471607 | 2471607 | 2022-05-04 | Fillmore | Minnesota | 27045 | 4864 | 24 |
2451333 | 2451333 | 2022-04-28 | Clark | Illinois | 17023 | 4864 | 60 |
2333242 | 2333242 | 2022-03-22 | Buchanan | Virginia | 51027 | 4864 | 108 |
2329989 | 2329989 | 2022-03-21 | Buchanan | Virginia | 51027 | 4864 | 108 |
2268278 | 2268278 | 2022-03-02 | Radford city | Virginia | 51750 | 4864 | 46 |
2248802 | 2248802 | 2022-02-24 | Adams | Washington | 53001 | 4864 | 36 |
2245551 | 2245551 | 2022-02-23 | Adams | Washington | 53001 | 4864 | 36 |
2240012 | 2240012 | 2022-02-22 | Rush | Indiana | 18139 | 4864 | 55 |
2189536 | 2189536 | 2022-02-06 | Wyoming | Pennsylvania | 42131 | 4864 | 97 |
2103314 | 2103314 | 2022-01-11 | Shelby | Illinois | 17173 | 4864 | 63 |
2101369 | 2101369 | 2022-01-10 | Transylvania | North Carolina | 37175 | 4864 | 54 |
2078547 | 2078547 | 2022-01-03 | Dare | North Carolina | 37055 | 4864 | 15 |
2015996 | 2015996 | 2021-12-15 | De Soto | Louisiana | 22031 | 4864 | 113 |
2017448 | 2017448 | 2021-12-15 | McNairy | Tennessee | 47109 | 4864 | 78 |
2009078 | 2009078 | 2021-12-13 | Decatur | Indiana | 18031 | 4864 | 117 |
1998617 | 1998617 | 2021-12-10 | Clarke | Alabama | 1025 | 4864 | 86 |
1995366 | 1995366 | 2021-12-09 | Clarke | Alabama | 1025 | 4864 | 86 |
1959833 | 1959833 | 2021-11-28 | Siskiyou | California | 6093 | 4864 | 70 |
1962109 | 1962109 | 2021-11-28 | Meade | South Dakota | 46093 | 4864 | 51 |
1956582 | 1956582 | 2021-11-27 | Siskiyou | California | 6093 | 4864 | 70 |
1958858 | 1958858 | 2021-11-27 | Meade | South Dakota | 46093 | 4864 | 51 |
1953331 | 1953331 | 2021-11-26 | Siskiyou | California | 6093 | 4864 | 70 |
1955607 | 1955607 | 2021-11-26 | Meade | South Dakota | 46093 | 4864 | 51 |
1950080 | 1950080 | 2021-11-25 | Siskiyou | California | 6093 | 4864 | 70 |
1952356 | 1952356 | 2021-11-25 | Meade | South Dakota | 46093 | 4864 | 51 |
1946829 | 1946829 | 2021-11-24 | Siskiyou | California | 6093 | 4864 | 70 |
1949105 | 1949105 | 2021-11-24 | Meade | South Dakota | 46093 | 4864 | 51 |
1927610 | 1927610 | 2021-11-18 | Stephens | Georgia | 13257 | 4864 | 118 |
1905273 | 1905273 | 2021-11-11 | Geary | Kansas | 20061 | 4864 | 58 |
1902023 | 1902023 | 2021-11-10 | Geary | Kansas | 20061 | 4864 | 58 |
1867253 | 1867253 | 2021-10-30 | Washington | New York | 36115 | 4864 | 69 |
1811345 | 1811345 | 2021-10-13 | Worcester | Maryland | 24047 | 4864 | 115 |
1800259 | 1800259 | 2021-10-09 | Randolph | West Virginia | 54083 | 4864 | 38 |
1792230 | 1792230 | 2021-10-07 | Warren | Missouri | 29219 | 4864 | 43 |
1694109 | 1694109 | 2021-09-07 | Lyon | Kansas | 20111 | 4864 | 89 |
1690860 | 1690860 | 2021-09-06 | Lyon | Kansas | 20111 | 4864 | 89 |
1687610 | 1687610 | 2021-09-05 | Lyon | Kansas | 20111 | 4864 | 89 |
1684360 | 1684360 | 2021-09-04 | Lyon | Kansas | 20111 | 4864 | 89 |
1681109 | 1681109 | 2021-09-03 | Lyon | Kansas | 20111 | 4864 | 89 |
1668524 | 1668524 | 2021-08-30 | Itasca | Minnesota | 27061 | 4864 | 69 |
1665909 | 1665909 | 2021-08-29 | Stokes | North Carolina | 37169 | 4864 | 83 |
1662661 | 1662661 | 2021-08-28 | Stokes | North Carolina | 37169 | 4864 | 83 |
1659413 | 1659413 | 2021-08-27 | Stokes | North Carolina | 37169 | 4864 | 83 |
1652991 | 1652991 | 2021-08-25 | Ashland | Ohio | 39005 | 4864 | 103 |
1649614 | 1649614 | 2021-08-24 | Davie | North Carolina | 37059 | 4864 | 46 |
1588948 | 1588948 | 2021-08-05 | James City | Virginia | 51095 | 4864 | 72 |
1582727 | 1582727 | 2021-08-04 | Covington | Alabama | 1039 | 4864 | 125 |
1561320 | 1561320 | 2021-07-28 | Goodhue | Minnesota | 27049 | 4864 | 74 |
1485992 | 1485992 | 2021-07-05 | Woodford | Illinois | 17203 | 4864 | 96 |
1482746 | 1482746 | 2021-07-04 | Woodford | Illinois | 17203 | 4864 | 96 |
1479499 | 1479499 | 2021-07-03 | Woodford | Illinois | 17203 | 4864 | 96 |
1476253 | 1476253 | 2021-07-02 | Woodford | Illinois | 17203 | 4864 | 96 |
1417988 | 1417988 | 2021-06-14 | Marshall | Iowa | 19127 | 4864 | 76 |
1406546 | 1406546 | 2021-06-10 | Toa Baja | Puerto Rico | 72137 | 4864 | |
1382294 | 1382294 | 2021-06-03 | Muscatine | Iowa | 19139 | 4864 | 104 |
1309987 | 1309987 | 2021-05-11 | Campbell | Wyoming | 56005 | 4864 | 60 |
1259151 | 1259151 | 2021-04-26 | Nelson | Kentucky | 21179 | 4864 | 52 |
1202693 | 1202693 | 2021-04-08 | Skagit | Washington | 53057 | 4864 | 67 |
1179964 | 1179964 | 2021-04-01 | Walla Walla | Washington | 53071 | 4864 | 64 |
1176689 | 1176689 | 2021-03-31 | Cowlitz | Washington | 53015 | 4864 | 76 |
1165212 | 1165212 | 2021-03-28 | Benton | Minnesota | 27009 | 4864 | 95 |
1130294 | 1130294 | 2021-03-17 | Sandusky | Ohio | 39143 | 4864 | 115 |
1119717 | 1119717 | 2021-03-14 | Marquette | Michigan | 26103 | 4864 | 57 |
1116470 | 1116470 | 2021-03-13 | Marquette | Michigan | 26103 | 4864 | 57 |
1091168 | 1091168 | 2021-03-05 | McDowell | North Carolina | 37111 | 4864 | 61 |
1072962 | 1072962 | 2021-02-27 | Fremont | Wyoming | 56013 | 4864 | 82 |
1069716 | 1069716 | 2021-02-26 | Fremont | Wyoming | 56013 | 4864 | 82 |
1019126 | 1019126 | 2021-02-11 | Van Buren | Michigan | 26159 | 4864 | 96 |
1003518 | 1003518 | 2021-02-06 | Granville | North Carolina | 37077 | 4864 | 74 |
999141 | 999141 | 2021-02-05 | Cerro Gordo | Iowa | 19033 | 4864 | 76 |
984686 | 984686 | 2021-01-31 | Monroe | Tennessee | 47123 | 4864 | 67 |
913300 | 913300 | 2021-01-09 | Roane | Tennessee | 47145 | 4864 | 69 |
910327 | 910327 | 2021-01-08 | Wise | Texas | 48497 | 4864 | 75 |
878322 | 878322 | 2020-12-30 | Fairbanks North Star Borough | Alaska | 2090 | 4864 | 19 |
818721 | 818721 | 2020-12-11 | Tuscarawas | Ohio | 39157 | 4864 | 97 |
814260 | 814260 | 2020-12-10 | Ford | Kansas | 20057 | 4864 | 10 |
811015 | 811015 | 2020-12-09 | Ford | Kansas | 20057 | 4864 | 10 |
788696 | 788696 | 2020-12-02 | St. Clair | Michigan | 26147 | 4864 | 102 |
712790 | 712790 | 2020-11-09 | Marshall | Alabama | 1095 | 4864 | 53 |
656773 | 656773 | 2020-10-22 | Aiken | South Carolina | 45003 | 4864 | 86 |
624216 | 624216 | 2020-10-12 | Northampton | Pennsylvania | 42095 | 4864 | 309 |
427898 | 427898 | 2020-08-13 | Benton | Arkansas | 5007 | 4864 | 43 |
337884 | 337884 | 2020-07-16 | Montgomery | Alabama | 1101 | 4864 | 121 |
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);