ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5291 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501653 | 2501653 | 2022-05-13 | Carroll | Ohio | 39019 | 5291 | 126 |
2498395 | 2498395 | 2022-05-12 | Carroll | Ohio | 39019 | 5291 | 126 |
2490582 | 2490582 | 2022-05-10 | Sullivan | Indiana | 18153 | 5291 | 76 |
2487325 | 2487325 | 2022-05-09 | Sullivan | Indiana | 18153 | 5291 | 76 |
2484983 | 2484983 | 2022-05-08 | Dawson | Nebraska | 31047 | 5291 | 44 |
2481725 | 2481725 | 2022-05-07 | Dawson | Nebraska | 31047 | 5291 | 44 |
2478467 | 2478467 | 2022-05-06 | Dawson | Nebraska | 31047 | 5291 | 44 |
2475209 | 2475209 | 2022-05-05 | Dawson | Nebraska | 31047 | 5291 | 44 |
2399324 | 2399324 | 2022-04-12 | Wayne | Illinois | 17191 | 5291 | 85 |
2372736 | 2372736 | 2022-04-04 | Lawrence | Arkansas | 5075 | 5291 | 76 |
2359982 | 2359982 | 2022-03-31 | Burke | Georgia | 13033 | 5291 | 105 |
2304077 | 2304077 | 2022-03-13 | Waynesboro city | Virginia | 51820 | 5291 | 60 |
2300825 | 2300825 | 2022-03-12 | Waynesboro city | Virginia | 51820 | 5291 | 60 |
2297573 | 2297573 | 2022-03-11 | Waynesboro city | Virginia | 51820 | 5291 | 60 |
2280970 | 2280970 | 2022-03-06 | Gillespie | Texas | 48171 | 5291 | 106 |
2277717 | 2277717 | 2022-03-05 | Gillespie | Texas | 48171 | 5291 | 107 |
2177951 | 2177951 | 2022-02-03 | Pierce | Georgia | 13229 | 5291 | 109 |
2155813 | 2155813 | 2022-01-27 | Grant | Louisiana | 22043 | 5291 | 82 |
2152467 | 2152467 | 2022-01-26 | Harrison | Kentucky | 21097 | 5291 | 58 |
2152585 | 2152585 | 2022-01-26 | St. James | Louisiana | 22093 | 5291 | 73 |
2122905 | 2122905 | 2022-01-17 | Posey | Indiana | 18129 | 5291 | 46 |
2100469 | 2100469 | 2022-01-10 | Ohio | Kentucky | 21183 | 5291 | 91 |
2097541 | 2097541 | 2022-01-09 | Adams | Mississippi | 28001 | 5291 | 125 |
2094289 | 2094289 | 2022-01-08 | Adams | Mississippi | 28001 | 5291 | 125 |
2091037 | 2091037 | 2022-01-07 | Adams | Mississippi | 28001 | 5291 | 125 |
2078099 | 2078099 | 2022-01-03 | Tippah | Mississippi | 28139 | 5291 | 86 |
2074767 | 2074767 | 2022-01-02 | Todd | Minnesota | 27153 | 5291 | 51 |
2071516 | 2071516 | 2022-01-01 | Todd | Minnesota | 27153 | 5291 | 51 |
2068265 | 2068265 | 2021-12-31 | Todd | Minnesota | 27153 | 5291 | 51 |
2065014 | 2065014 | 2021-12-30 | Todd | Minnesota | 27153 | 5291 | 51 |
2010936 | 2010936 | 2021-12-13 | Lauderdale | Tennessee | 47097 | 5291 | 73 |
1985107 | 1985107 | 2021-12-05 | Kendall | Texas | 48259 | 5291 | 102 |
1981857 | 1981857 | 2021-12-04 | Kendall | Texas | 48259 | 5291 | 102 |
1954961 | 1954961 | 2021-11-26 | Franklin | New York | 36033 | 5291 | 25 |
1944954 | 1944954 | 2021-11-23 | Warren | Missouri | 29219 | 5291 | 73 |
1853026 | 1853026 | 2021-10-26 | Morgan | Illinois | 17137 | 5291 | 123 |
1825342 | 1825342 | 2021-10-17 | Benton | Oregon | 41003 | 5291 | 30 |
1822093 | 1822093 | 2021-10-16 | Benton | Oregon | 41003 | 5291 | 30 |
1818844 | 1818844 | 2021-10-15 | Benton | Oregon | 41003 | 5291 | 30 |
1785481 | 1785481 | 2021-10-05 | Isanti | Minnesota | 27059 | 5291 | 71 |
1763107 | 1763107 | 2021-09-28 | Madison | Nebraska | 31119 | 5291 | 44 |
1712567 | 1712567 | 2021-09-12 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1709320 | 1709320 | 2021-09-11 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1706073 | 1706073 | 2021-09-10 | Douglas | Wisconsin | 55031 | 5291 | 66 |
1694769 | 1694769 | 2021-09-07 | Webster | Missouri | 29225 | 5291 | 82 |
1693135 | 1693135 | 2021-09-06 | Albany | Wyoming | 56001 | 5291 | 21 |
1689886 | 1689886 | 2021-09-05 | Albany | Wyoming | 56001 | 5291 | 21 |
1686636 | 1686636 | 2021-09-04 | Albany | Wyoming | 56001 | 5291 | 21 |
1683386 | 1683386 | 2021-09-03 | Albany | Wyoming | 56001 | 5291 | 21 |
1676939 | 1676939 | 2021-09-02 | Franklin | Alabama | 1059 | 5291 | 89 |
1673531 | 1673531 | 2021-08-31 | Jefferson | West Virginia | 54037 | 5291 | 61 |
1649141 | 1649141 | 2021-08-24 | Marshall | Mississippi | 28093 | 5291 | 108 |
1644827 | 1644827 | 2021-08-23 | Baldwin | Georgia | 13009 | 5291 | 141 |
1626358 | 1626358 | 2021-08-17 | Bolivar | Mississippi | 28011 | 5291 | 137 |
1606576 | 1606576 | 2021-08-11 | Avoyelles | Louisiana | 22009 | 5291 | 131 |
1604989 | 1604989 | 2021-08-10 | Medina | Texas | 48325 | 5291 | 111 |
1599205 | 1599205 | 2021-08-09 | Broomfield | Colorado | 8014 | 5291 | 77 |
1584774 | 1584774 | 2021-08-04 | Athens | Ohio | 39009 | 5291 | 60 |
1516016 | 1516016 | 2021-07-14 | Callaway | Missouri | 29027 | 5291 | 51 |
1474265 | 1474265 | 2021-07-01 | McDowell | North Carolina | 37111 | 5291 | 63 |
1466199 | 1466199 | 2021-06-29 | Unknown | Florida | 5291 | 863 | |
1429227 | 1429227 | 2021-06-17 | Guaynabo | Puerto Rico | 72061 | 5291 | |
1305085 | 1305085 | 2021-05-10 | Newton | Missouri | 29145 | 5291 | 77 |
1301839 | 1301839 | 2021-05-09 | Newton | Missouri | 29145 | 5291 | 77 |
1298591 | 1298591 | 2021-05-08 | Newton | Missouri | 29145 | 5291 | 77 |
1258873 | 1258873 | 2021-04-26 | Cerro Gordo | Iowa | 19033 | 5291 | 87 |
1227079 | 1227079 | 2021-04-16 | Washington | Mississippi | 28151 | 5291 | 133 |
1220665 | 1220665 | 2021-04-14 | Newton | Missouri | 29145 | 5291 | 74 |
1158595 | 1158595 | 2021-03-26 | Cecil | Maryland | 24015 | 5291 | 126 |
1143699 | 1143699 | 2021-03-21 | Dyer | Tennessee | 47045 | 5291 | 103 |
1140452 | 1140452 | 2021-03-20 | Dyer | Tennessee | 47045 | 5291 | 103 |
1137206 | 1137206 | 2021-03-19 | Dyer | Tennessee | 47045 | 5291 | 103 |
1132509 | 1132509 | 2021-03-18 | Pike | Kentucky | 21195 | 5291 | 70 |
1132633 | 1132633 | 2021-03-18 | St. Mary's | Maryland | 24037 | 5291 | 117 |
1134061 | 1134061 | 2021-03-18 | Caldwell | Texas | 48055 | 5291 | 92 |
1042477 | 1042477 | 2021-02-18 | Lee | North Carolina | 37105 | 5291 | 65 |
1017719 | 1017719 | 2021-02-10 | Columbia | Wisconsin | 55021 | 5291 | 54 |
895065 | 895065 | 2021-01-04 | Madison | Idaho | 16065 | 5291 | 19 |
793858 | 793858 | 2020-12-03 | Natrona | Wyoming | 56025 | 5291 | 55 |
690011 | 690011 | 2020-11-01 | Washington | Wisconsin | 55131 | 5291 | 46 |
548024 | 548024 | 2020-09-19 | Madison | Illinois | 17119 | 5291 | 130 |
424915 | 424915 | 2020-08-12 | Lake | Florida | 12069 | 5291 | 74 |
346852 | 346852 | 2020-07-18 | Collin | Texas | 48085 | 5291 | 64 |
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);