ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 3820 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 11
- Minnesota 8
- Alabama 7
- Kentucky 7
- Tennessee 6
- Texas 6
- Pennsylvania 5
- Alaska 4
- Arkansas 4
- Indiana 4
- South Dakota 4
- Georgia 3
- Missouri 3
- North Carolina 3
- Puerto Rico 3
- Virginia 3
- Illinois 2
- Iowa 2
- Kansas 2
- New Jersey 2
- Oregon 2
- South Carolina 2
- Washington 2
- Colorado 1
- Idaho 1
- Maine 1
- Massachusetts 1
- Mississippi 1
- Nebraska 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487895 | 2487895 | 2022-05-09 | Faribault | Minnesota | 27043 | 3820 | 51 |
2446551 | 2446551 | 2022-04-26 | Anasco | Puerto Rico | 72011 | 3820 | |
2248447 | 2248447 | 2022-02-24 | Freestone | Texas | 48161 | 3820 | 82 |
2236030 | 2236030 | 2022-02-21 | Macon | Alabama | 1087 | 3820 | 72 |
2232779 | 2232779 | 2022-02-20 | Macon | Alabama | 1087 | 3820 | 72 |
2229528 | 2229528 | 2022-02-19 | Macon | Alabama | 1087 | 3820 | 72 |
2218996 | 2218996 | 2022-02-15 | Oglala Lakota | South Dakota | 46102 | 3820 | 60 |
2187084 | 2187084 | 2022-02-05 | Monroe | West Virginia | 54063 | 3820 | 35 |
2125527 | 2125527 | 2022-01-18 | Hempstead | Arkansas | 5057 | 3820 | 51 |
2103018 | 2103018 | 2022-01-11 | Appling | Georgia | 13001 | 3820 | 109 |
2092019 | 2092019 | 2022-01-07 | San Lorenzo | Puerto Rico | 72129 | 3820 | |
2050764 | 2050764 | 2021-12-26 | Logan | Arkansas | 5083 | 3820 | 53 |
1998044 | 1998044 | 2021-12-09 | Dimmit | Texas | 48127 | 3820 | 46 |
1944579 | 1944579 | 2021-11-23 | Franklin | Massachusetts | 25011 | 3820 | 124 |
1926418 | 1926418 | 2021-11-17 | Johnson | Tennessee | 47091 | 3820 | 52 |
1916622 | 1916622 | 2021-11-14 | Yankton | South Dakota | 46135 | 3820 | 40 |
1913372 | 1913372 | 2021-11-13 | Yankton | South Dakota | 46135 | 3820 | 40 |
1910122 | 1910122 | 2021-11-12 | Yankton | South Dakota | 46135 | 3820 | 40 |
1907363 | 1907363 | 2021-11-11 | Orange | Virginia | 51137 | 3820 | 60 |
1877665 | 1877665 | 2021-11-02 | Haywood | Tennessee | 47075 | 3820 | 76 |
1872311 | 1872311 | 2021-11-01 | Haralson | Georgia | 13143 | 3820 | 119 |
1872853 | 1872853 | 2021-11-01 | Allen | Kentucky | 21003 | 3820 | 69 |
1869760 | 1869760 | 2021-10-31 | Plaquemines | Louisiana | 22075 | 3820 | 40 |
1866511 | 1866511 | 2021-10-30 | Plaquemines | Louisiana | 22075 | 3820 | 40 |
1863262 | 1863262 | 2021-10-29 | Plaquemines | Louisiana | 22075 | 3820 | 40 |
1860013 | 1860013 | 2021-10-28 | Plaquemines | Louisiana | 22075 | 3820 | 40 |
1856764 | 1856764 | 2021-10-27 | Plaquemines | Louisiana | 22075 | 3820 | 40 |
1851016 | 1851016 | 2021-10-25 | Anson | North Carolina | 37007 | 3820 | 78 |
1826621 | 1826621 | 2021-10-18 | Delta | Colorado | 8029 | 3820 | 80 |
1813961 | 1813961 | 2021-10-14 | Payette | Idaho | 16075 | 3820 | 56 |
1808539 | 1808539 | 2021-10-12 | Adams | Nebraska | 31001 | 3820 | 54 |
1736481 | 1736481 | 2021-09-20 | Ohio | Kentucky | 21183 | 3820 | 68 |
1732932 | 1732932 | 2021-09-19 | Wells | Indiana | 18179 | 3820 | 85 |
1729682 | 1729682 | 2021-09-18 | Wells | Indiana | 18179 | 3820 | 85 |
1726432 | 1726432 | 2021-09-17 | Wells | Indiana | 18179 | 3820 | 85 |
1723346 | 1723346 | 2021-09-16 | Miami | Kansas | 20121 | 3820 | 51 |
1720097 | 1720097 | 2021-09-15 | Miami | Kansas | 20121 | 3820 | 51 |
1718352 | 1718352 | 2021-09-14 | Union | South Carolina | 45087 | 3820 | 86 |
1710734 | 1710734 | 2021-09-12 | Carlton | Minnesota | 27017 | 3820 | 59 |
1707487 | 1707487 | 2021-09-11 | Carlton | Minnesota | 27017 | 3820 | 59 |
1704240 | 1704240 | 2021-09-10 | Carlton | Minnesota | 27017 | 3820 | 59 |
1680197 | 1680197 | 2021-09-03 | Lawrence | Alabama | 1079 | 3820 | 100 |
1664945 | 1664945 | 2021-08-29 | Clark | Kentucky | 21049 | 3820 | 32 |
1661697 | 1661697 | 2021-08-28 | Clark | Kentucky | 21049 | 3820 | 32 |
1658449 | 1658449 | 2021-08-27 | Clark | Kentucky | 21049 | 3820 | 32 |
1633040 | 1633040 | 2021-08-19 | Warren | Missouri | 29219 | 3820 | 39 |
1623942 | 1623942 | 2021-08-16 | Malheur | Oregon | 41045 | 3820 | 68 |
1623973 | 1623973 | 2021-08-16 | Clinton | Pennsylvania | 42035 | 3820 | 68 |
1615363 | 1615363 | 2021-08-14 | Poinsett | Arkansas | 5111 | 3820 | 87 |
1614286 | 1614286 | 2021-08-13 | Arecibo | Puerto Rico | 72013 | 3820 | |
1575583 | 1575583 | 2021-08-01 | White | Tennessee | 47185 | 3820 | 74 |
1572335 | 1572335 | 2021-07-31 | White | Tennessee | 47185 | 3820 | 74 |
1569087 | 1569087 | 2021-07-30 | White | Tennessee | 47185 | 3820 | 74 |
1531789 | 1531789 | 2021-07-19 | Greenup | Kentucky | 21089 | 3820 | 63 |
1514327 | 1514327 | 2021-07-13 | Douglas | Washington | 53017 | 3820 | 23 |
1510319 | 1510319 | 2021-07-12 | McKean | Pennsylvania | 42083 | 3820 | 72 |
1511081 | 1511081 | 2021-07-12 | Douglas | Washington | 53017 | 3820 | 23 |
1507072 | 1507072 | 2021-07-11 | McKean | Pennsylvania | 42083 | 3820 | 72 |
1484757 | 1484757 | 2021-07-04 | Grimes | Texas | 48185 | 3820 | 74 |
1471772 | 1471772 | 2021-06-30 | Grimes | Texas | 48185 | 3820 | 74 |
1468527 | 1468527 | 2021-06-29 | Grimes | Texas | 48185 | 3820 | 74 |
1421984 | 1421984 | 2021-06-15 | Webster | Missouri | 29225 | 3820 | 55 |
1417980 | 1417980 | 2021-06-14 | Lee | Iowa | 19111 | 3820 | 56 |
1405315 | 1405315 | 2021-06-10 | St. John the Baptist | Louisiana | 22095 | 3820 | 141 |
1402796 | 1402796 | 2021-06-09 | Tioga | New York | 36107 | 3820 | 63 |
1378924 | 1378924 | 2021-06-02 | Jasper | Indiana | 18073 | 3820 | 54 |
1375549 | 1375549 | 2021-06-01 | Christian | Illinois | 17021 | 3820 | 91 |
1350957 | 1350957 | 2021-05-24 | Scotland | North Carolina | 37165 | 3820 | 86 |
1337309 | 1337309 | 2021-05-20 | Becker | Minnesota | 27005 | 3820 | 53 |
1301412 | 1301412 | 2021-05-09 | Iberville | Louisiana | 22047 | 3820 | 98 |
1298165 | 1298165 | 2021-05-08 | Iberville | Louisiana | 22047 | 3820 | 98 |
1298406 | 1298406 | 2021-05-08 | Polk | Minnesota | 27119 | 3820 | 68 |
1294919 | 1294919 | 2021-05-07 | Iberville | Louisiana | 22047 | 3820 | 98 |
1291928 | 1291928 | 2021-05-06 | Steele | Minnesota | 27147 | 3820 | 15 |
1292852 | 1292852 | 2021-05-06 | Venango | Pennsylvania | 42121 | 3820 | 93 |
1282369 | 1282369 | 2021-05-03 | Phelps | Missouri | 29161 | 3820 | 129 |
1272379 | 1272379 | 2021-04-30 | Beltrami | Minnesota | 27007 | 3820 | 58 |
1209420 | 1209420 | 2021-04-11 | Bethel Census Area | Alaska | 2050 | 3820 | 20 |
1206172 | 1206172 | 2021-04-10 | Bethel Census Area | Alaska | 2050 | 3820 | 20 |
1202924 | 1202924 | 2021-04-09 | Bethel Census Area | Alaska | 2050 | 3820 | 20 |
1199676 | 1199676 | 2021-04-08 | Bethel Census Area | Alaska | 2050 | 3820 | 20 |
1158254 | 1158254 | 2021-03-26 | Plymouth | Iowa | 19149 | 3820 | 79 |
1088227 | 1088227 | 2021-03-04 | Bedford | Pennsylvania | 42009 | 3820 | 129 |
1042426 | 1042426 | 2021-02-18 | Alexander | North Carolina | 37003 | 3820 | 72 |
1003044 | 1003044 | 2021-02-06 | Pearl River | Mississippi | 28109 | 3820 | 117 |
953316 | 953316 | 2021-01-22 | Colquitt | Georgia | 13071 | 3820 | 64 |
952695 | 952695 | 2021-01-21 | Washington | Virginia | 51191 | 3820 | 68 |
937291 | 937291 | 2021-01-17 | Franklin | Illinois | 17055 | 3820 | 68 |
905389 | 905389 | 2021-01-07 | Vermilion | Louisiana | 22113 | 3820 | 88 |
897204 | 897204 | 2021-01-04 | Henderson | Texas | 48213 | 3820 | 78 |
880834 | 880834 | 2020-12-30 | Monroe | Tennessee | 47123 | 3820 | 54 |
850244 | 850244 | 2020-12-21 | York | Maine | 23031 | 3820 | 48 |
848234 | 848234 | 2020-12-20 | Greenwood | South Carolina | 45047 | 3820 | 92 |
757171 | 757171 | 2020-11-22 | Lane | Oregon | 41039 | 3820 | 37 |
754710 | 754710 | 2020-11-21 | Roanoke city | Virginia | 51770 | 3820 | 67 |
748459 | 748459 | 2020-11-20 | Elmore | Alabama | 1051 | 3820 | 61 |
741999 | 741999 | 2020-11-18 | St. Clair | Alabama | 1115 | 3820 | 55 |
729130 | 729130 | 2020-11-14 | Saline | Arkansas | 5125 | 3820 | 46 |
703036 | 703036 | 2020-11-06 | DeKalb | Alabama | 1049 | 3820 | 30 |
594522 | 594522 | 2020-10-03 | Cumberland | New Jersey | 34011 | 3820 | 160 |
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);