ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 3431 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 10
- Texas 10
- Kansas 9
- Alabama 7
- Arkansas 6
- Georgia 6
- Minnesota 5
- Mississippi 5
- Missouri 5
- Nebraska 5
- California 4
- Illinois 4
- Kentucky 4
- Massachusetts 4
- Michigan 4
- Ohio 4
- West Virginia 4
- Louisiana 3
- New Mexico 3
- North Carolina 3
- Puerto Rico 3
- Tennessee 3
- Virginia 3
- Idaho 2
- New York 2
- Pennsylvania 2
- Iowa 1
- Maryland 1
- Montana 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2451960 | 2451960 | 2022-04-28 | Nantucket | Massachusetts | 25019 | 3431 | 0 |
2283502 | 2283502 | 2022-03-07 | Swain | North Carolina | 37173 | 3431 | 36 |
2262177 | 2262177 | 2022-03-01 | Van Buren | Arkansas | 5141 | 3431 | 57 |
2264113 | 2264113 | 2022-03-01 | Monroe | Ohio | 39111 | 3431 | 77 |
2237099 | 2237099 | 2022-02-21 | Trigg | Kentucky | 21221 | 3431 | 41 |
2238050 | 2238050 | 2022-02-21 | Unknown | Northern Mariana Islands | 3431 | 3 | |
2211261 | 2211261 | 2022-02-13 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2211682 | 2211682 | 2022-02-13 | Gage | Nebraska | 31067 | 3431 | 37 |
2208008 | 2208008 | 2022-02-12 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2208429 | 2208429 | 2022-02-12 | Gage | Nebraska | 31067 | 3431 | 37 |
2204755 | 2204755 | 2022-02-11 | Kalkaska | Michigan | 26079 | 3431 | 52 |
2205176 | 2205176 | 2022-02-11 | Gage | Nebraska | 31067 | 3431 | 37 |
2180712 | 2180712 | 2022-02-04 | Cleburne | Alabama | 1029 | 3431 | 65 |
2174047 | 2174047 | 2022-02-01 | Braxton | West Virginia | 54007 | 3431 | 35 |
2147893 | 2147893 | 2022-01-24 | Goochland | Virginia | 51075 | 3431 | 37 |
2132486 | 2132486 | 2022-01-20 | Minidoka | Idaho | 16067 | 3431 | 55 |
2088214 | 2088214 | 2022-01-06 | Taos | New Mexico | 35055 | 3431 | 74 |
2079978 | 2079978 | 2022-01-04 | Ashley | Arkansas | 5003 | 3431 | 56 |
2053911 | 2053911 | 2021-12-27 | Monroe | Alabama | 1099 | 3431 | 66 |
2031168 | 2031168 | 2021-12-20 | Randolph | Alabama | 1111 | 3431 | 67 |
2031233 | 2031233 | 2021-12-20 | Clark | Arkansas | 5019 | 3431 | 65 |
2014904 | 2014904 | 2021-12-15 | Marengo | Alabama | 1091 | 3431 | 93 |
2000650 | 2000650 | 2021-12-10 | Rolette | North Dakota | 38079 | 3431 | 36 |
1963342 | 1963342 | 2021-11-29 | Mitchell | Georgia | 13205 | 3431 | 101 |
1960381 | 1960381 | 2021-11-28 | Sullivan | Indiana | 18153 | 3431 | 56 |
1957130 | 1957130 | 2021-11-27 | Sullivan | Indiana | 18153 | 3431 | 56 |
1953879 | 1953879 | 2021-11-26 | Sullivan | Indiana | 18153 | 3431 | 56 |
1950628 | 1950628 | 2021-11-25 | Sullivan | Indiana | 18153 | 3431 | 56 |
1947377 | 1947377 | 2021-11-24 | Sullivan | Indiana | 18153 | 3431 | 56 |
1941105 | 1941105 | 2021-11-22 | Bourbon | Kentucky | 21017 | 3431 | 37 |
1941842 | 1941842 | 2021-11-22 | Saunders | Nebraska | 31155 | 3431 | 23 |
1902311 | 1902311 | 2021-11-10 | Garrett | Maryland | 24023 | 3431 | 83 |
1882909 | 1882909 | 2021-11-04 | Otsego | Michigan | 26137 | 3431 | 59 |
1850341 | 1850341 | 2021-10-25 | Franklin | Massachusetts | 25011 | 3431 | 122 |
1837191 | 1837191 | 2021-10-21 | Meade | Kentucky | 21163 | 3431 | 35 |
1823799 | 1823799 | 2021-10-17 | Shelby | Illinois | 17173 | 3431 | 50 |
1820550 | 1820550 | 2021-10-16 | Shelby | Illinois | 17173 | 3431 | 50 |
1817301 | 1817301 | 2021-10-15 | Shelby | Illinois | 17173 | 3431 | 50 |
1809400 | 1809400 | 2021-10-12 | Bledsoe | Tennessee | 47007 | 3431 | 16 |
1800479 | 1800479 | 2021-10-10 | Arkansas | Arkansas | 5001 | 3431 | 58 |
1798989 | 1798989 | 2021-10-09 | Lewis | New York | 36049 | 3431 | 38 |
1751532 | 1751532 | 2021-09-24 | Upshur | West Virginia | 54097 | 3431 | 49 |
1740925 | 1740925 | 2021-09-21 | Elk | Pennsylvania | 42047 | 3431 | 47 |
1722196 | 1722196 | 2021-09-15 | Winchester city | Virginia | 51840 | 3431 | 50 |
1676772 | 1676772 | 2021-09-01 | Greenbrier | West Virginia | 54025 | 3431 | 66 |
1625371 | 1625371 | 2021-08-17 | Dawson | Georgia | 13085 | 3431 | 49 |
1626592 | 1626592 | 2021-08-17 | Ravalli | Montana | 30081 | 3431 | 51 |
1620535 | 1620535 | 2021-08-15 | Guernsey | Ohio | 39059 | 3431 | 54 |
1602320 | 1602320 | 2021-08-10 | Carroll | Arkansas | 5015 | 3431 | 52 |
1602610 | 1602610 | 2021-08-10 | Butts | Georgia | 13035 | 3431 | 91 |
1557676 | 1557676 | 2021-07-27 | McPherson | Kansas | 20113 | 3431 | 89 |
1554429 | 1554429 | 2021-07-26 | McPherson | Kansas | 20113 | 3431 | 89 |
1551182 | 1551182 | 2021-07-25 | McPherson | Kansas | 20113 | 3431 | 89 |
1547935 | 1547935 | 2021-07-24 | McPherson | Kansas | 20113 | 3431 | 89 |
1544688 | 1544688 | 2021-07-23 | McPherson | Kansas | 20113 | 3431 | 89 |
1541440 | 1541440 | 2021-07-22 | McPherson | Kansas | 20113 | 3431 | 89 |
1541901 | 1541901 | 2021-07-22 | Alcorn | Mississippi | 28003 | 3431 | 74 |
1460805 | 1460805 | 2021-06-27 | Tate | Mississippi | 28137 | 3431 | 86 |
1457560 | 1457560 | 2021-06-26 | Tate | Mississippi | 28137 | 3431 | 86 |
1454315 | 1454315 | 2021-06-25 | Tate | Mississippi | 28137 | 3431 | 86 |
1399726 | 1399726 | 2021-06-08 | Champaign | Ohio | 39021 | 3431 | 58 |
1350523 | 1350523 | 2021-05-24 | Lawrence | Missouri | 29109 | 3431 | 83 |
1347277 | 1347277 | 2021-05-23 | Lawrence | Missouri | 29109 | 3431 | 83 |
1344029 | 1344029 | 2021-05-22 | Lawrence | Missouri | 29109 | 3431 | 83 |
1337330 | 1337330 | 2021-05-20 | Freeborn | Minnesota | 27047 | 3431 | 29 |
1333770 | 1333770 | 2021-05-19 | Floyd | Kentucky | 21071 | 3431 | 69 |
1325422 | 1325422 | 2021-05-16 | Clarendon | South Carolina | 45027 | 3431 | 113 |
1286373 | 1286373 | 2021-05-04 | Arecibo | Puerto Rico | 72013 | 3431 | |
1264758 | 1264758 | 2021-04-28 | Lake | California | 6033 | 3431 | 43 |
1255772 | 1255772 | 2021-04-25 | Montgomery | Kansas | 20125 | 3431 | 78 |
1252525 | 1252525 | 2021-04-24 | Montgomery | Kansas | 20125 | 3431 | 78 |
1249278 | 1249278 | 2021-04-23 | Montgomery | Kansas | 20125 | 3431 | 78 |
1246972 | 1246972 | 2021-04-22 | Warren | New York | 36113 | 3431 | 56 |
1243409 | 1243409 | 2021-04-21 | Pulaski | Missouri | 29169 | 3431 | 51 |
1228286 | 1228286 | 2021-04-16 | Fannin | Texas | 48147 | 3431 | 108 |
1187399 | 1187399 | 2021-04-04 | Wabash | Indiana | 18169 | 3431 | 77 |
1180723 | 1180723 | 2021-04-02 | Bureau | Illinois | 17011 | 3431 | 92 |
1154679 | 1154679 | 2021-03-25 | Wayne | Georgia | 13305 | 3431 | 81 |
1155278 | 1155278 | 2021-03-25 | Evangeline | Louisiana | 22039 | 3431 | 89 |
1135427 | 1135427 | 2021-03-19 | Putnam | Indiana | 18133 | 3431 | 60 |
1113513 | 1113513 | 2021-03-12 | Pulaski | Missouri | 29169 | 3431 | 49 |
1107761 | 1107761 | 2021-03-10 | Venango | Pennsylvania | 42121 | 3431 | 87 |
1104026 | 1104026 | 2021-03-09 | Rio Arriba | New Mexico | 35039 | 3431 | 70 |
1085970 | 1085970 | 2021-03-04 | Chambers | Alabama | 1017 | 3431 | 111 |
1080856 | 1080856 | 2021-03-02 | Polk | Minnesota | 27119 | 3431 | 62 |
1066500 | 1066500 | 2021-02-26 | Clarke | Alabama | 1025 | 3431 | 49 |
1050447 | 1050447 | 2021-02-21 | Amador | California | 6005 | 3431 | 39 |
1052246 | 1052246 | 2021-02-21 | Scotland | North Carolina | 37165 | 3431 | 72 |
1036926 | 1036926 | 2021-02-16 | Sanpete | Utah | 49039 | 3431 | 19 |
1012478 | 1012478 | 2021-02-09 | St. Bernard | Louisiana | 22087 | 3431 | 46 |
998214 | 998214 | 2021-02-04 | Ohio | West Virginia | 54069 | 3431 | 63 |
994660 | 994660 | 2021-02-03 | Rusk | Texas | 48401 | 3431 | 80 |
944334 | 944334 | 2021-01-19 | Webster | Louisiana | 22119 | 3431 | 78 |
942565 | 942565 | 2021-01-18 | Chambers | Texas | 48071 | 3431 | 31 |
942908 | 942908 | 2021-01-18 | Manassas city | Virginia | 51683 | 3431 | 29 |
939320 | 939320 | 2021-01-17 | Chambers | Texas | 48071 | 3431 | 31 |
936075 | 936075 | 2021-01-16 | Chambers | Texas | 48071 | 3431 | 31 |
932830 | 932830 | 2021-01-15 | Chambers | Texas | 48071 | 3431 | 31 |
905080 | 905080 | 2021-01-07 | Plymouth | Iowa | 19149 | 3431 | 62 |
871978 | 871978 | 2020-12-28 | San Benito | California | 6069 | 3431 | 28 |
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);