ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 4837 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Iowa 7
- Missouri 7
- Tennessee 7
- Ohio 6
- Alabama 5
- Indiana 5
- Minnesota 5
- Virginia 5
- Alaska 4
- California 4
- Illinois 4
- Kentucky 4
- Washington 4
- Wisconsin 4
- Colorado 3
- Florida 3
- Mississippi 3
- Puerto Rico 3
- Arkansas 2
- Kansas 2
- Louisiana 2
- Nebraska 2
- New York 2
- North Carolina 2
- South Carolina 2
- New Jersey 1
- Oklahoma 1
- Pennsylvania 1
- Texas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499659 | 2499659 | 2022-05-13 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2496401 | 2496401 | 2022-05-12 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2493143 | 2493143 | 2022-05-11 | Northwest Arctic Borough | Alaska | 2188 | 4837 | 13 |
2420550 | 2420550 | 2022-04-18 | Morovis | Puerto Rico | 72101 | 4837 | |
2383091 | 2383091 | 2022-04-07 | Jay | Indiana | 18075 | 4837 | 78 |
2379836 | 2379836 | 2022-04-06 | Jay | Indiana | 18075 | 4837 | 78 |
2376582 | 2376582 | 2022-04-05 | Jay | Indiana | 18075 | 4837 | 78 |
2373330 | 2373330 | 2022-04-04 | Jay | Indiana | 18075 | 4837 | 78 |
2353543 | 2353543 | 2022-03-29 | Lamar | Georgia | 13171 | 4837 | 112 |
2355643 | 2355643 | 2022-03-29 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2350291 | 2350291 | 2022-03-28 | Lamar | Georgia | 13171 | 4837 | 112 |
2352390 | 2352390 | 2022-03-28 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2347038 | 2347038 | 2022-03-27 | Lamar | Georgia | 13171 | 4837 | 112 |
2349138 | 2349138 | 2022-03-27 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2343785 | 2343785 | 2022-03-26 | Lamar | Georgia | 13171 | 4837 | 112 |
2345885 | 2345885 | 2022-03-26 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2340532 | 2340532 | 2022-03-25 | Lamar | Georgia | 13171 | 4837 | 112 |
2342632 | 2342632 | 2022-03-25 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2337279 | 2337279 | 2022-03-24 | Lamar | Georgia | 13171 | 4837 | 112 |
2339379 | 2339379 | 2022-03-24 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2334025 | 2334025 | 2022-03-23 | Lamar | Georgia | 13171 | 4837 | 112 |
2336125 | 2336125 | 2022-03-23 | Humphreys | Tennessee | 47085 | 4837 | 70 |
2330771 | 2330771 | 2022-03-22 | Lamar | Georgia | 13171 | 4837 | 112 |
2327519 | 2327519 | 2022-03-21 | Lamar | Georgia | 13171 | 4837 | 112 |
2314643 | 2314643 | 2022-03-17 | Clark | Illinois | 17023 | 4837 | 60 |
2283442 | 2283442 | 2022-03-07 | Currituck | North Carolina | 37053 | 4837 | 32 |
2240096 | 2240096 | 2022-02-22 | Mahaska | Iowa | 19123 | 4837 | 84 |
2236845 | 2236845 | 2022-02-21 | Mahaska | Iowa | 19123 | 4837 | 84 |
2233594 | 2233594 | 2022-02-20 | Mahaska | Iowa | 19123 | 4837 | 84 |
2230343 | 2230343 | 2022-02-19 | Mahaska | Iowa | 19123 | 4837 | 84 |
2227092 | 2227092 | 2022-02-18 | Mahaska | Iowa | 19123 | 4837 | 84 |
2223841 | 2223841 | 2022-02-17 | Mahaska | Iowa | 19123 | 4837 | 84 |
2220590 | 2220590 | 2022-02-16 | Mahaska | Iowa | 19123 | 4837 | 84 |
2217255 | 2217255 | 2022-02-15 | Rush | Indiana | 18139 | 4837 | 51 |
2200646 | 2200646 | 2022-02-10 | Cook | Georgia | 13075 | 4837 | 67 |
2187352 | 2187352 | 2022-02-06 | Lawrence | Arkansas | 5075 | 4837 | 66 |
2182307 | 2182307 | 2022-02-04 | Vernon | Missouri | 29217 | 4837 | 95 |
2167744 | 2167744 | 2022-01-31 | Randolph | Alabama | 1111 | 4837 | 69 |
2161232 | 2161232 | 2022-01-29 | Pickens | Alabama | 1107 | 4837 | 93 |
2152824 | 2152824 | 2022-01-26 | Wabasha | Minnesota | 27157 | 4837 | 13 |
2146607 | 2146607 | 2022-01-24 | Dawson | Nebraska | 31047 | 4837 | 41 |
2144708 | 2144708 | 2022-01-23 | Staunton city | Virginia | 51790 | 4837 | 91 |
2141453 | 2141453 | 2022-01-22 | Staunton city | Virginia | 51790 | 4837 | 91 |
2138197 | 2138197 | 2022-01-21 | Staunton city | Virginia | 51790 | 4837 | 91 |
2131664 | 2131664 | 2022-01-19 | Page | Virginia | 51139 | 4837 | 93 |
2125355 | 2125355 | 2022-01-17 | Vernon | Wisconsin | 55123 | 4837 | 77 |
2096385 | 2096385 | 2022-01-09 | Delta | Colorado | 8029 | 4837 | 123 |
2093133 | 2093133 | 2022-01-08 | Delta | Colorado | 8029 | 4837 | 123 |
2089881 | 2089881 | 2022-01-07 | Delta | Colorado | 8029 | 4837 | 123 |
2083309 | 2083309 | 2022-01-05 | Calaveras | California | 6009 | 4837 | 93 |
2052144 | 2052144 | 2021-12-26 | Dunklin | Missouri | 29069 | 4837 | 93 |
2048894 | 2048894 | 2021-12-25 | Dunklin | Missouri | 29069 | 4837 | 93 |
2045644 | 2045644 | 2021-12-24 | Dunklin | Missouri | 29069 | 4837 | 93 |
2042394 | 2042394 | 2021-12-23 | Dunklin | Missouri | 29069 | 4837 | 93 |
2030202 | 2030202 | 2021-12-19 | Arecibo | Puerto Rico | 72013 | 4837 | |
2018175 | 2018175 | 2021-12-16 | Winston | Alabama | 1133 | 4837 | 111 |
1996311 | 1996311 | 2021-12-09 | Miami | Kansas | 20121 | 4837 | 69 |
1993060 | 1993060 | 2021-12-08 | Miami | Kansas | 20121 | 4837 | 69 |
1986739 | 1986739 | 2021-12-06 | De Soto | Louisiana | 22031 | 4837 | 113 |
1982786 | 1982786 | 2021-12-05 | Decatur | Georgia | 13087 | 4837 | 110 |
1979536 | 1979536 | 2021-12-04 | Decatur | Georgia | 13087 | 4837 | 110 |
1976286 | 1976286 | 2021-12-03 | Decatur | Georgia | 13087 | 4837 | 110 |
1973037 | 1973037 | 2021-12-02 | Decatur | Georgia | 13087 | 4837 | 109 |
1946152 | 1946152 | 2021-11-23 | Palo Pinto | Texas | 48363 | 4837 | 122 |
1936857 | 1936857 | 2021-11-21 | Clarke | Alabama | 1025 | 4837 | 86 |
1937078 | 1937078 | 2021-11-21 | Siskiyou | California | 6093 | 4837 | 69 |
1933607 | 1933607 | 2021-11-20 | Clarke | Alabama | 1025 | 4837 | 86 |
1933828 | 1933828 | 2021-11-20 | Siskiyou | California | 6093 | 4837 | 69 |
1936724 | 1936724 | 2021-11-20 | Mingo | West Virginia | 54059 | 4837 | 84 |
1918829 | 1918829 | 2021-11-15 | Tippah | Mississippi | 28139 | 4837 | 81 |
1881775 | 1881775 | 2021-11-04 | St. Francis | Arkansas | 5123 | 4837 | 67 |
1852148 | 1852148 | 2021-10-25 | Smyth | Virginia | 51173 | 4837 | 116 |
1826327 | 1826327 | 2021-10-17 | Trempealeau | Wisconsin | 55121 | 4837 | 52 |
1785981 | 1785981 | 2021-10-05 | Columbia | New York | 36021 | 4837 | 110 |
1783189 | 1783189 | 2021-10-04 | Perry | Pennsylvania | 42099 | 4837 | 109 |
1743470 | 1743470 | 2021-09-22 | Pulaski | Missouri | 29169 | 4837 | 69 |
1710771 | 1710771 | 2021-09-12 | McLeod | Minnesota | 27085 | 4837 | 62 |
1707524 | 1707524 | 2021-09-11 | McLeod | Minnesota | 27085 | 4837 | 62 |
1704277 | 1704277 | 2021-09-10 | McLeod | Minnesota | 27085 | 4837 | 62 |
1697822 | 1697822 | 2021-09-08 | Alcorn | Mississippi | 28003 | 4837 | 81 |
1551285 | 1551285 | 2021-07-25 | Jessamine | Kentucky | 21113 | 4837 | 74 |
1548038 | 1548038 | 2021-07-24 | Jessamine | Kentucky | 21113 | 4837 | 74 |
1544791 | 1544791 | 2021-07-23 | Jessamine | Kentucky | 21113 | 4837 | 74 |
1466502 | 1466502 | 2021-06-29 | Stephenson | Illinois | 17177 | 4837 | 104 |
1431966 | 1431966 | 2021-06-18 | Clinton | New York | 36019 | 4837 | 33 |
1428286 | 1428286 | 2021-06-17 | Bolivar | Mississippi | 28011 | 4837 | 133 |
1384890 | 1384890 | 2021-06-04 | Nevada | California | 6057 | 4837 | 75 |
1383427 | 1383427 | 2021-06-03 | Watauga | North Carolina | 37189 | 4837 | 31 |
1367600 | 1367600 | 2021-05-29 | Toa Baja | Puerto Rico | 72137 | 4837 | |
1330140 | 1330140 | 2021-05-18 | Livingston | Illinois | 17105 | 4837 | 97 |
1242916 | 1242916 | 2021-04-21 | Nelson | Kentucky | 21179 | 4837 | 51 |
1229363 | 1229363 | 2021-04-17 | Tift | Georgia | 13277 | 4837 | 125 |
1194804 | 1194804 | 2021-04-06 | Dodge | Nebraska | 31053 | 4837 | 58 |
1166975 | 1166975 | 2021-03-28 | Walla Walla | Washington | 53071 | 4837 | 64 |
1163727 | 1163727 | 2021-03-27 | Walla Walla | Washington | 53071 | 4837 | 64 |
1158716 | 1158716 | 2021-03-26 | Benton | Minnesota | 27009 | 4837 | 95 |
1160479 | 1160479 | 2021-03-26 | Walla Walla | Washington | 53071 | 4837 | 64 |
1157231 | 1157231 | 2021-03-25 | Walla Walla | Washington | 53071 | 4837 | 64 |
1127060 | 1127060 | 2021-03-16 | Washington | Ohio | 39167 | 4837 | 99 |
1120555 | 1120555 | 2021-03-14 | Sandusky | Ohio | 39143 | 4837 | 115 |
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);