ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 3987 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Indiana 12
- Tennessee 8
- Virginia 7
- Illinois 6
- Kansas 6
- Minnesota 6
- California 5
- Missouri 5
- Kentucky 4
- Ohio 4
- Puerto Rico 4
- Wisconsin 4
- Arkansas 3
- Florida 3
- Georgia 3
- Louisiana 3
- Alabama 2
- Colorado 2
- Michigan 2
- Mississippi 2
- North Carolina 2
- Oklahoma 2
- Pennsylvania 2
- South Carolina 2
- Iowa 1
- Maine 1
- New Hampshire 1
- New Mexico 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469342 | 2469342 | 2022-05-03 | Aibonito | Puerto Rico | 72009 | 3987 | |
2456378 | 2456378 | 2022-04-29 | San German | Puerto Rico | 72125 | 3987 | |
2418130 | 2418130 | 2022-04-17 | Washburn | Wisconsin | 55129 | 3987 | 46 |
2414874 | 2414874 | 2022-04-16 | Washburn | Wisconsin | 55129 | 3987 | 46 |
2411618 | 2411618 | 2022-04-15 | Washburn | Wisconsin | 55129 | 3987 | 46 |
2330963 | 2330963 | 2022-03-22 | Mercer | Illinois | 17131 | 3987 | 47 |
2327711 | 2327711 | 2022-03-21 | Mercer | Illinois | 17131 | 3987 | 47 |
2266816 | 2266816 | 2022-03-02 | Morgan | Missouri | 29141 | 3987 | 101 |
2229114 | 2229114 | 2022-02-18 | Zavala | Texas | 48507 | 3987 | 62 |
2148302 | 2148302 | 2022-01-25 | Grant | Arkansas | 5053 | 3987 | 53 |
2150851 | 2150851 | 2022-01-25 | Deaf Smith | Texas | 48117 | 3987 | 103 |
2131600 | 2131600 | 2022-01-19 | Colonial Heights city | Virginia | 51570 | 3987 | 72 |
2125895 | 2125895 | 2022-01-18 | Putnam | Georgia | 13237 | 3987 | 91 |
2128155 | 2128155 | 2022-01-18 | Lamb | Texas | 48279 | 3987 | 102 |
2110330 | 2110330 | 2022-01-13 | Waldo | Maine | 23027 | 3987 | 44 |
2096906 | 2096906 | 2022-01-09 | Sullivan | Indiana | 18153 | 3987 | 62 |
2093654 | 2093654 | 2022-01-08 | Sullivan | Indiana | 18153 | 3987 | 62 |
2090402 | 2090402 | 2022-01-07 | Sullivan | Indiana | 18153 | 3987 | 62 |
2080595 | 2080595 | 2022-01-04 | Fulton | Indiana | 18049 | 3987 | 85 |
2082841 | 2082841 | 2022-01-04 | Fredericksburg city | Virginia | 51630 | 3987 | 27 |
2055401 | 2055401 | 2021-12-27 | Henry | Missouri | 29083 | 3987 | 66 |
2053005 | 2053005 | 2021-12-26 | Rio Grande | Puerto Rico | 72119 | 3987 | |
2032579 | 2032579 | 2021-12-20 | Newton | Mississippi | 28101 | 3987 | 83 |
2019634 | 2019634 | 2021-12-16 | Crawford | Missouri | 29055 | 3987 | 76 |
2020533 | 2020533 | 2021-12-16 | Barnwell | South Carolina | 45011 | 3987 | 88 |
2016683 | 2016683 | 2021-12-15 | Grant | New Mexico | 35017 | 3987 | 57 |
2007701 | 2007701 | 2021-12-12 | Morgan | Tennessee | 47129 | 3987 | 51 |
2004450 | 2004450 | 2021-12-11 | Morgan | Tennessee | 47129 | 3987 | 51 |
2001199 | 2001199 | 2021-12-10 | Morgan | Tennessee | 47129 | 3987 | 51 |
1996652 | 1996652 | 2021-12-09 | Menominee | Michigan | 26109 | 3987 | 58 |
1993401 | 1993401 | 2021-12-08 | Menominee | Michigan | 26109 | 3987 | 58 |
1945825 | 1945825 | 2021-11-23 | Davison | South Dakota | 46035 | 3987 | 71 |
1941595 | 1941595 | 2021-11-22 | Audrain | Missouri | 29007 | 3987 | 77 |
1915170 | 1915170 | 2021-11-14 | Marion | Kentucky | 21155 | 3987 | 49 |
1911920 | 1911920 | 2021-11-13 | Marion | Kentucky | 21155 | 3987 | 49 |
1908671 | 1908671 | 2021-11-12 | Marion | Kentucky | 21155 | 3987 | 49 |
1904036 | 1904036 | 2021-11-10 | Botetourt | Virginia | 51023 | 3987 | 53 |
1904078 | 1904078 | 2021-11-10 | Halifax | Virginia | 51083 | 3987 | 109 |
1898295 | 1898295 | 2021-11-09 | Franklin | Georgia | 13119 | 3987 | 84 |
1850284 | 1850284 | 2021-10-25 | Union | Louisiana | 22111 | 3987 | 105 |
1834424 | 1834424 | 2021-10-20 | Miller | Missouri | 29131 | 3987 | 77 |
1740006 | 1740006 | 2021-09-21 | Lyon | Minnesota | 27083 | 3987 | 54 |
1691981 | 1691981 | 2021-09-06 | Champaign | Ohio | 39021 | 3987 | 61 |
1678260 | 1678260 | 2021-09-02 | Freeborn | Minnesota | 27047 | 3987 | 37 |
1651115 | 1651115 | 2021-08-25 | Yell | Arkansas | 5149 | 3987 | 67 |
1648769 | 1648769 | 2021-08-24 | Muhlenberg | Kentucky | 21177 | 3987 | 76 |
1647629 | 1647629 | 2021-08-23 | Oneida | Wisconsin | 55085 | 3987 | 81 |
1640029 | 1640029 | 2021-08-21 | Highland | Ohio | 39071 | 3987 | 70 |
1632221 | 1632221 | 2021-08-19 | Wabash | Indiana | 18169 | 3987 | 84 |
1579466 | 1579466 | 2021-08-03 | Chambers | Alabama | 1017 | 3987 | 125 |
1579761 | 1579761 | 2021-08-03 | Summit | Colorado | 8117 | 3987 | 8 |
1486044 | 1486044 | 2021-07-05 | Miami | Indiana | 18103 | 3987 | 70 |
1486688 | 1486688 | 2021-07-05 | Steele | Minnesota | 27147 | 3987 | 18 |
1482798 | 1482798 | 2021-07-04 | Miami | Indiana | 18103 | 3987 | 70 |
1483442 | 1483442 | 2021-07-04 | Steele | Minnesota | 27147 | 3987 | 18 |
1479551 | 1479551 | 2021-07-03 | Miami | Indiana | 18103 | 3987 | 70 |
1480196 | 1480196 | 2021-07-03 | Steele | Minnesota | 27147 | 3987 | 18 |
1476305 | 1476305 | 2021-07-02 | Miami | Indiana | 18103 | 3987 | 70 |
1450241 | 1450241 | 2021-06-24 | Logan | Illinois | 17107 | 3987 | 77 |
1414866 | 1414866 | 2021-06-13 | Seward | Kansas | 20175 | 3987 | 41 |
1411621 | 1411621 | 2021-06-12 | Seward | Kansas | 20175 | 3987 | 41 |
1408172 | 1408172 | 2021-06-11 | Steuben | Indiana | 18151 | 3987 | 61 |
1408376 | 1408376 | 2021-06-11 | Seward | Kansas | 20175 | 3987 | 41 |
1405130 | 1405130 | 2021-06-10 | Seward | Kansas | 20175 | 3987 | 41 |
1381456 | 1381456 | 2021-06-03 | Escambia | Alabama | 1053 | 3987 | 78 |
1336894 | 1336894 | 2021-05-20 | Cowley | Kansas | 20035 | 3987 | 108 |
1333647 | 1333647 | 2021-05-19 | Cowley | Kansas | 20035 | 3987 | 108 |
1335557 | 1335557 | 2021-05-19 | Rusk | Texas | 48401 | 3987 | 108 |
1329770 | 1329770 | 2021-05-18 | Logan | Colorado | 8075 | 3987 | 67 |
1327035 | 1327035 | 2021-05-17 | Whitley | Indiana | 18183 | 3987 | 39 |
1261010 | 1261010 | 2021-04-26 | Charlottesville city | Virginia | 51540 | 3987 | 55 |
1235541 | 1235541 | 2021-04-19 | Mendocino | California | 6045 | 3987 | 47 |
1232294 | 1232294 | 2021-04-18 | Mendocino | California | 6045 | 3987 | 47 |
1229045 | 1229045 | 2021-04-17 | Mendocino | California | 6045 | 3987 | 47 |
1225797 | 1225797 | 2021-04-16 | Mendocino | California | 6045 | 3987 | 47 |
1223720 | 1223720 | 2021-04-15 | Nobles | Minnesota | 27105 | 3987 | 48 |
1210815 | 1210815 | 2021-04-11 | Neshoba | Mississippi | 28099 | 3987 | 176 |
1211971 | 1211971 | 2021-04-11 | Weakley | Tennessee | 47183 | 3987 | 61 |
1208722 | 1208722 | 2021-04-10 | Weakley | Tennessee | 47183 | 3987 | 61 |
1205474 | 1205474 | 2021-04-09 | Weakley | Tennessee | 47183 | 3987 | 61 |
1185632 | 1185632 | 2021-04-03 | Bedford | Pennsylvania | 42009 | 3987 | 130 |
1155263 | 1155263 | 2021-03-25 | Avoyelles | Louisiana | 22009 | 3987 | 121 |
1152016 | 1152016 | 2021-03-24 | Avoyelles | Louisiana | 22009 | 3987 | 121 |
1143004 | 1143004 | 2021-03-21 | Clinton | New York | 36019 | 3987 | 30 |
1114038 | 1114038 | 2021-03-12 | Madison | Ohio | 39097 | 3987 | 55 |
1102871 | 1102871 | 2021-03-09 | Randolph | Illinois | 17157 | 3987 | 86 |
1099625 | 1099625 | 2021-03-08 | Randolph | Illinois | 17157 | 3987 | 86 |
1098237 | 1098237 | 2021-03-07 | Cheatham | Tennessee | 47021 | 3987 | 44 |
1095199 | 1095199 | 2021-03-06 | Jim Wells | Texas | 48249 | 3987 | 90 |
1087959 | 1087959 | 2021-03-04 | Watauga | North Carolina | 37189 | 3987 | 29 |
1088391 | 1088391 | 2021-03-04 | Dillon | South Carolina | 45033 | 3987 | 78 |
1068654 | 1068654 | 2021-02-26 | Custer | Oklahoma | 40039 | 3987 | 67 |
1056260 | 1056260 | 2021-02-22 | Kerr | Texas | 48265 | 3987 | 80 |
1053014 | 1053014 | 2021-02-21 | Kerr | Texas | 48265 | 3987 | 80 |
1049767 | 1049767 | 2021-02-20 | Kerr | Texas | 48265 | 3987 | 80 |
1046520 | 1046520 | 2021-02-19 | Kerr | Texas | 48265 | 3987 | 79 |
1043179 | 1043179 | 2021-02-18 | Cherokee | Texas | 48073 | 3987 | 119 |
1039934 | 1039934 | 2021-02-17 | Cherokee | Texas | 48073 | 3987 | 119 |
1040230 | 1040230 | 2021-02-17 | Culpeper | Virginia | 51047 | 3987 | 39 |
1036689 | 1036689 | 2021-02-16 | Cherokee | Texas | 48073 | 3987 | 119 |
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);