ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 4819 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 15
- Illinois 10
- Tennessee 8
- Indiana 6
- South Carolina 6
- Michigan 5
- Mississippi 5
- Missouri 4
- Kansas 3
- New Jersey 3
- North Carolina 3
- Ohio 3
- Virginia 3
- Arkansas 2
- Florida 2
- Idaho 2
- Iowa 2
- Kentucky 2
- Nebraska 2
- North Dakota 2
- Oklahoma 2
- Puerto Rico 2
- Washington 2
- Wyoming 2
- Alabama 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463908 | 2463908 | 2022-05-02 | Phillips | Arkansas | 5107 | 4819 | 99 |
2444599 | 2444599 | 2022-04-26 | Appling | Georgia | 13001 | 4819 | 126 |
2441343 | 2441343 | 2022-04-25 | Appling | Georgia | 13001 | 4819 | 126 |
2438087 | 2438087 | 2022-04-24 | Appling | Georgia | 13001 | 4819 | 126 |
2434831 | 2434831 | 2022-04-23 | Appling | Georgia | 13001 | 4819 | 126 |
2431575 | 2431575 | 2022-04-22 | Appling | Georgia | 13001 | 4819 | 126 |
2428319 | 2428319 | 2022-04-21 | Appling | Georgia | 13001 | 4819 | 126 |
2425063 | 2425063 | 2022-04-20 | Appling | Georgia | 13001 | 4819 | 126 |
2379059 | 2379059 | 2022-04-05 | Taylor | Wisconsin | 55119 | 4819 | 72 |
2327173 | 2327173 | 2022-03-21 | Cross | Arkansas | 5037 | 4819 | 81 |
2180367 | 2180367 | 2022-02-03 | Orleans | Vermont | 50019 | 4819 | 31 |
2152109 | 2152109 | 2022-01-26 | Union | Illinois | 17181 | 4819 | 63 |
2141112 | 2141112 | 2022-01-22 | Frio | Texas | 48163 | 4819 | 80 |
2127742 | 2127742 | 2022-01-18 | Cidra | Puerto Rico | 72041 | 4819 | |
2099107 | 2099107 | 2022-01-09 | Halifax | Virginia | 51083 | 4819 | 127 |
2095856 | 2095856 | 2022-01-08 | Halifax | Virginia | 51083 | 4819 | 127 |
2092604 | 2092604 | 2022-01-07 | Halifax | Virginia | 51083 | 4819 | 127 |
2087440 | 2087440 | 2022-01-06 | Lincoln | Kentucky | 21137 | 4819 | 108 |
2033080 | 2033080 | 2021-12-20 | Montgomery | North Carolina | 37123 | 4819 | 110 |
2015267 | 2015267 | 2021-12-15 | Butts | Georgia | 13035 | 4819 | 123 |
2012194 | 2012194 | 2021-12-14 | Latah | Idaho | 16057 | 4819 | 41 |
2005827 | 2005827 | 2021-12-12 | Decatur | Indiana | 18031 | 4819 | 117 |
2002576 | 2002576 | 2021-12-11 | Decatur | Indiana | 18031 | 4819 | 117 |
1999326 | 1999326 | 2021-12-10 | Decatur | Indiana | 18031 | 4819 | 117 |
1996502 | 1996502 | 2021-12-09 | Jefferson Davis | Louisiana | 22053 | 4819 | 130 |
1961686 | 1961686 | 2021-11-28 | Fayette | Ohio | 39047 | 4819 | 70 |
1946635 | 1946635 | 2021-11-24 | Lawrence | Alabama | 1079 | 4819 | 127 |
1906466 | 1906466 | 2021-11-11 | Morrow | Ohio | 39117 | 4819 | 60 |
1902788 | 1902788 | 2021-11-10 | Dakota | Nebraska | 31043 | 4819 | 82 |
1892273 | 1892273 | 2021-11-07 | Geary | Kansas | 20061 | 4819 | 58 |
1889023 | 1889023 | 2021-11-06 | Geary | Kansas | 20061 | 4819 | 58 |
1885773 | 1885773 | 2021-11-05 | Geary | Kansas | 20061 | 4819 | 58 |
1878865 | 1878865 | 2021-11-03 | Stephens | Georgia | 13257 | 4819 | 109 |
1871051 | 1871051 | 2021-10-31 | Marlboro | South Carolina | 45069 | 4819 | 82 |
1867802 | 1867802 | 2021-10-30 | Marlboro | South Carolina | 45069 | 4819 | 82 |
1864553 | 1864553 | 2021-10-29 | Marlboro | South Carolina | 45069 | 4819 | 82 |
1856258 | 1856258 | 2021-10-27 | Lee | Illinois | 17103 | 4819 | 101 |
1846402 | 1846402 | 2021-10-24 | White | Georgia | 13311 | 4819 | 124 |
1843152 | 1843152 | 2021-10-23 | White | Georgia | 13311 | 4819 | 124 |
1839902 | 1839902 | 2021-10-22 | White | Georgia | 13311 | 4819 | 124 |
1798347 | 1798347 | 2021-10-09 | Worcester | Maryland | 24047 | 4819 | 114 |
1779940 | 1779940 | 2021-10-03 | Perry | Pennsylvania | 42099 | 4819 | 109 |
1743627 | 1743627 | 2021-09-22 | Platte | Nebraska | 31141 | 4819 | 50 |
1739426 | 1739426 | 2021-09-21 | Wabash | Indiana | 18169 | 4819 | 92 |
1741882 | 1741882 | 2021-09-21 | Teton | Wyoming | 56039 | 4819 | 12 |
1732750 | 1732750 | 2021-09-19 | Christian | Illinois | 17021 | 4819 | 98 |
1729500 | 1729500 | 2021-09-18 | Christian | Illinois | 17021 | 4819 | 98 |
1726250 | 1726250 | 2021-09-17 | Christian | Illinois | 17021 | 4819 | 98 |
1701216 | 1701216 | 2021-09-09 | Marion | Missouri | 29127 | 4819 | 58 |
1675244 | 1675244 | 2021-09-01 | Polk | Missouri | 29167 | 4819 | 52 |
1673511 | 1673511 | 2021-08-31 | Whitman | Washington | 53075 | 4819 | 54 |
1630440 | 1630440 | 2021-08-18 | Polk | Oregon | 41053 | 4819 | 60 |
1624124 | 1624124 | 2021-08-16 | Dillon | South Carolina | 45033 | 4819 | 86 |
1607554 | 1607554 | 2021-08-11 | Knox | Ohio | 39083 | 4819 | 112 |
1604796 | 1604796 | 2021-08-10 | Obion | Tennessee | 47131 | 4819 | 98 |
1601496 | 1601496 | 2021-08-09 | Cocke | Tennessee | 47029 | 4819 | 102 |
1594037 | 1594037 | 2021-08-07 | Platte | Missouri | 29165 | 4819 | 53 |
1581997 | 1581997 | 2021-08-03 | Cheatham | Tennessee | 47021 | 4819 | 56 |
1539638 | 1539638 | 2021-07-21 | Toa Alta | Puerto Rico | 72135 | 4819 | |
1496086 | 1496086 | 2021-07-08 | Jessamine | Kentucky | 21113 | 4819 | 73 |
1437294 | 1437294 | 2021-06-20 | Stephenson | Illinois | 17177 | 4819 | 104 |
1434047 | 1434047 | 2021-06-19 | Stephenson | Illinois | 17177 | 4819 | 104 |
1430801 | 1430801 | 2021-06-18 | Stephenson | Illinois | 17177 | 4819 | 104 |
1427556 | 1427556 | 2021-06-17 | Stephenson | Illinois | 17177 | 4819 | 104 |
1417832 | 1417832 | 2021-06-14 | Woodford | Illinois | 17203 | 4819 | 96 |
1392584 | 1392584 | 2021-06-06 | Bolivar | Mississippi | 28011 | 4819 | 133 |
1389339 | 1389339 | 2021-06-05 | Bolivar | Mississippi | 28011 | 4819 | 133 |
1386094 | 1386094 | 2021-06-04 | Bolivar | Mississippi | 28011 | 4819 | 133 |
1382976 | 1382976 | 2021-06-03 | Johnson | Missouri | 29101 | 4819 | 56 |
1356813 | 1356813 | 2021-05-26 | Goodhue | Minnesota | 27049 | 4819 | 72 |
1302326 | 1302326 | 2021-05-09 | Williams | North Dakota | 38105 | 4819 | 38 |
1282558 | 1282558 | 2021-05-03 | Elko | Nevada | 32007 | 4819 | 56 |
1268364 | 1268364 | 2021-04-29 | Bingham | Idaho | 16011 | 4819 | 74 |
1261288 | 1261288 | 2021-04-26 | Campbell | Wyoming | 56005 | 4819 | 60 |
1247524 | 1247524 | 2021-04-22 | Newberry | South Carolina | 45071 | 4819 | 100 |
1235871 | 1235871 | 2021-04-19 | Ware | Georgia | 13299 | 4819 | 171 |
1213125 | 1213125 | 2021-04-12 | Tift | Georgia | 13277 | 4819 | 124 |
1210607 | 1210607 | 2021-04-11 | Cass | Michigan | 26027 | 4819 | 70 |
1207358 | 1207358 | 2021-04-10 | Cass | Michigan | 26027 | 4819 | 70 |
1128009 | 1128009 | 2021-03-16 | Walla Walla | Washington | 53071 | 4819 | 64 |
1120976 | 1120976 | 2021-03-14 | Franklin | Tennessee | 47051 | 4819 | 85 |
1117729 | 1117729 | 2021-03-13 | Franklin | Tennessee | 47051 | 4819 | 85 |
1114482 | 1114482 | 2021-03-12 | Franklin | Tennessee | 47051 | 4819 | 85 |
1088183 | 1088183 | 2021-03-04 | Washington | Oklahoma | 40147 | 4819 | 89 |
1081432 | 1081432 | 2021-03-02 | McDowell | North Carolina | 37111 | 4819 | 61 |
1057981 | 1057981 | 2021-02-23 | Berkshire | Massachusetts | 25003 | 4819 | 251 |
1006144 | 1006144 | 2021-02-07 | Van Buren | Michigan | 26159 | 4819 | 94 |
1002898 | 1002898 | 2021-02-06 | Van Buren | Michigan | 26159 | 4819 | 94 |
999628 | 999628 | 2021-02-05 | Midland | Michigan | 26111 | 4819 | 59 |
992724 | 992724 | 2021-02-03 | Warren | Iowa | 19181 | 4819 | 60 |
945598 | 945598 | 2021-01-19 | Laurens | South Carolina | 45059 | 4819 | 106 |
927294 | 927294 | 2021-01-14 | Monroe | Florida | 12087 | 4819 | 37 |
921189 | 921189 | 2021-01-12 | Marshall | Indiana | 18099 | 4819 | 84 |
872139 | 872139 | 2020-12-28 | Sumter | Florida | 12119 | 4819 | 118 |
856980 | 856980 | 2020-12-23 | Jones | Mississippi | 28067 | 4819 | 94 |
850474 | 850474 | 2020-12-21 | Forrest | Mississippi | 28035 | 4819 | 93 |
844723 | 844723 | 2020-12-19 | Garfield | Oklahoma | 40047 | 4819 | 41 |
834816 | 834816 | 2020-12-16 | Wilson | North Carolina | 37195 | 4819 | 89 |
734787 | 734787 | 2020-11-15 | Maury | Tennessee | 47119 | 4819 | 46 |
709936 | 709936 | 2020-11-08 | Douglas | Georgia | 13097 | 4819 | 82 |
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);