ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
195 rows where cases = 3268 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 29
- North Carolina 11
- Virginia 11
- Ohio 10
- Kentucky 8
- Louisiana 8
- Michigan 8
- Georgia 7
- Missouri 7
- Oregon 6
- Illinois 5
- Minnesota 5
- New York 5
- South Dakota 5
- West Virginia 5
- Alabama 4
- Texas 4
- Washington 4
- Wisconsin 4
- Arkansas 3
- Florida 3
- Indiana 3
- Massachusetts 3
- Mississippi 3
- Montana 3
- Nebraska 3
- New Mexico 3
- Pennsylvania 3
- Puerto Rico 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473316 | 2473316 | 2022-05-04 | Westmoreland | Virginia | 51193 | 3268 | 51 |
2443994 | 2443994 | 2022-04-25 | Rockbridge | Virginia | 51163 | 3268 | 80 |
2440595 | 2440595 | 2022-04-24 | Millard | Utah | 49027 | 3268 | 35 |
2437339 | 2437339 | 2022-04-23 | Millard | Utah | 49027 | 3268 | 35 |
2434083 | 2434083 | 2022-04-22 | Millard | Utah | 49027 | 3268 | 35 |
2421202 | 2421202 | 2022-04-18 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2417946 | 2417946 | 2022-04-17 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2414690 | 2414690 | 2022-04-16 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2411434 | 2411434 | 2022-04-15 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2408178 | 2408178 | 2022-04-14 | Rockbridge | Virginia | 51163 | 3268 | 78 |
2404006 | 2404006 | 2022-04-13 | Morgan | Ohio | 39115 | 3268 | 59 |
2404922 | 2404922 | 2022-04-13 | Rockbridge | Virginia | 51163 | 3268 | 77 |
2400751 | 2400751 | 2022-04-12 | Morgan | Ohio | 39115 | 3268 | 59 |
2397496 | 2397496 | 2022-04-11 | Morgan | Ohio | 39115 | 3268 | 59 |
2394241 | 2394241 | 2022-04-10 | Morgan | Ohio | 39115 | 3268 | 59 |
2390985 | 2390985 | 2022-04-09 | Morgan | Ohio | 39115 | 3268 | 59 |
2387729 | 2387729 | 2022-04-08 | Morgan | Ohio | 39115 | 3268 | 59 |
2384474 | 2384474 | 2022-04-07 | Morgan | Ohio | 39115 | 3268 | 59 |
2358710 | 2358710 | 2022-03-30 | Naguabo | Puerto Rico | 72103 | 3268 | |
2310570 | 2310570 | 2022-03-15 | Southampton | Virginia | 51175 | 3268 | 89 |
2307317 | 2307317 | 2022-03-14 | Southampton | Virginia | 51175 | 3268 | 89 |
2287373 | 2287373 | 2022-03-08 | Stewart | Tennessee | 47161 | 3268 | 52 |
2284121 | 2284121 | 2022-03-07 | Stewart | Tennessee | 47161 | 3268 | 52 |
2280869 | 2280869 | 2022-03-06 | Stewart | Tennessee | 47161 | 3268 | 52 |
2277616 | 2277616 | 2022-03-05 | Stewart | Tennessee | 47161 | 3268 | 52 |
2274363 | 2274363 | 2022-03-04 | Stewart | Tennessee | 47161 | 3268 | 52 |
2271110 | 2271110 | 2022-03-03 | Stewart | Tennessee | 47161 | 3268 | 52 |
2267858 | 2267858 | 2022-03-02 | Stewart | Tennessee | 47161 | 3268 | 52 |
2260982 | 2260982 | 2022-02-28 | Curry | Oregon | 41015 | 3268 | 44 |
2224517 | 2224517 | 2022-02-17 | Gasconade | Missouri | 29073 | 3268 | 93 |
2190738 | 2190738 | 2022-02-07 | Las Animas | Colorado | 8071 | 3268 | 39 |
2193619 | 2193619 | 2022-02-07 | Buffalo | Wisconsin | 55011 | 3268 | 11 |
2190286 | 2190286 | 2022-02-06 | Klickitat | Washington | 53039 | 3268 | 39 |
2185842 | 2185842 | 2022-02-05 | Schuyler | New York | 36097 | 3268 | 23 |
2187033 | 2187033 | 2022-02-05 | Klickitat | Washington | 53039 | 3268 | 39 |
2183780 | 2183780 | 2022-02-04 | Klickitat | Washington | 53039 | 3268 | 39 |
2165666 | 2165666 | 2022-01-30 | Dukes | Massachusetts | 25007 | 3268 | 0 |
2162411 | 2162411 | 2022-01-29 | Dukes | Massachusetts | 25007 | 3268 | 0 |
2163520 | 2163520 | 2022-01-29 | Anasco | Puerto Rico | 72011 | 3268 | |
2163817 | 2163817 | 2022-01-29 | Bandera | Texas | 48019 | 3268 | 69 |
2159156 | 2159156 | 2022-01-28 | Dukes | Massachusetts | 25007 | 3268 | 0 |
2151036 | 2151036 | 2022-01-25 | Wilbarger | Texas | 48487 | 3268 | 77 |
2144774 | 2144774 | 2022-01-23 | Grant | West Virginia | 54023 | 3268 | 50 |
2109029 | 2109029 | 2022-01-12 | Wetzel | West Virginia | 54103 | 3268 | 67 |
2101902 | 2101902 | 2022-01-10 | Union | South Dakota | 46127 | 3268 | 47 |
2097225 | 2097225 | 2022-01-09 | Powell | Kentucky | 21197 | 3268 | 29 |
2093973 | 2093973 | 2022-01-08 | Powell | Kentucky | 21197 | 3268 | 29 |
2090721 | 2090721 | 2022-01-07 | Powell | Kentucky | 21197 | 3268 | 29 |
2087778 | 2087778 | 2022-01-06 | Wadena | Minnesota | 27159 | 3268 | 45 |
2038154 | 2038154 | 2021-12-22 | Washington | Georgia | 13303 | 3268 | 124 |
2035671 | 2035671 | 2021-12-21 | Ogemaw | Michigan | 26129 | 3268 | 80 |
2032421 | 2032421 | 2021-12-20 | Ogemaw | Michigan | 26129 | 3268 | 80 |
2014223 | 2014223 | 2021-12-14 | Trousdale | Tennessee | 47169 | 3268 | 28 |
2010972 | 2010972 | 2021-12-13 | Trousdale | Tennessee | 47169 | 3268 | 28 |
1984951 | 1984951 | 2021-12-05 | Polk | Tennessee | 47139 | 3268 | 33 |
1981701 | 1981701 | 2021-12-04 | Polk | Tennessee | 47139 | 3268 | 33 |
1978451 | 1978451 | 2021-12-03 | Polk | Tennessee | 47139 | 3268 | 33 |
1937352 | 1937352 | 2021-11-21 | Putnam | Georgia | 13237 | 3268 | 84 |
1939080 | 1939080 | 2021-11-21 | Crook | Oregon | 41013 | 3268 | 54 |
1934102 | 1934102 | 2021-11-20 | Putnam | Georgia | 13237 | 3268 | 84 |
1935830 | 1935830 | 2021-11-20 | Crook | Oregon | 41013 | 3268 | 54 |
1930850 | 1930850 | 2021-11-19 | Putnam | Georgia | 13237 | 3268 | 84 |
1932580 | 1932580 | 2021-11-19 | Crook | Oregon | 41013 | 3268 | 54 |
1924946 | 1924946 | 2021-11-17 | Rockcastle | Kentucky | 21203 | 3268 | 33 |
1925190 | 1925190 | 2021-11-17 | Dodge | Minnesota | 27039 | 3268 | 11 |
1874109 | 1874109 | 2021-11-01 | Union | Oregon | 41061 | 3268 | 50 |
1831555 | 1831555 | 2021-10-19 | Greene | North Carolina | 37079 | 3268 | 56 |
1824379 | 1824379 | 2021-10-17 | Emmet | Michigan | 26047 | 3268 | 49 |
1821130 | 1821130 | 2021-10-16 | Emmet | Michigan | 26047 | 3268 | 49 |
1823043 | 1823043 | 2021-10-16 | Jackson | Wisconsin | 55053 | 3268 | 31 |
1817881 | 1817881 | 2021-10-15 | Emmet | Michigan | 26047 | 3268 | 49 |
1819794 | 1819794 | 2021-10-15 | Jackson | Wisconsin | 55053 | 3268 | 31 |
1816545 | 1816545 | 2021-10-14 | Jackson | Wisconsin | 55053 | 3268 | 31 |
1800417 | 1800417 | 2021-10-10 | Monroe | Alabama | 1099 | 3268 | 60 |
1780171 | 1780171 | 2021-10-03 | Crockett | Tennessee | 47033 | 3268 | 59 |
1776921 | 1776921 | 2021-10-02 | Crockett | Tennessee | 47033 | 3268 | 59 |
1773671 | 1773671 | 2021-10-01 | Crockett | Tennessee | 47033 | 3268 | 59 |
1711925 | 1711925 | 2021-09-12 | Yankton | South Dakota | 46135 | 3268 | 34 |
1708678 | 1708678 | 2021-09-11 | Yankton | South Dakota | 46135 | 3268 | 34 |
1705431 | 1705431 | 2021-09-10 | Yankton | South Dakota | 46135 | 3268 | 34 |
1693592 | 1693592 | 2021-09-07 | Dodge | Georgia | 13091 | 3268 | 112 |
1669489 | 1669489 | 2021-08-30 | Tioga | Pennsylvania | 42117 | 3268 | 113 |
1659033 | 1659033 | 2021-08-27 | Washington | Missouri | 29221 | 3268 | 56 |
1630780 | 1630780 | 2021-08-18 | Overton | Tennessee | 47133 | 3268 | 63 |
1582607 | 1582607 | 2021-08-03 | Wayne | West Virginia | 54099 | 3268 | 46 |
1560595 | 1560595 | 2021-07-28 | Fayette | Illinois | 17051 | 3268 | 59 |
1557348 | 1557348 | 2021-07-27 | Fayette | Illinois | 17051 | 3268 | 59 |
1551317 | 1551317 | 2021-07-25 | Muhlenberg | Kentucky | 21177 | 3268 | 69 |
1548070 | 1548070 | 2021-07-24 | Muhlenberg | Kentucky | 21177 | 3268 | 69 |
1544823 | 1544823 | 2021-07-23 | Muhlenberg | Kentucky | 21177 | 3268 | 69 |
1539779 | 1539779 | 2021-07-21 | Claiborne | Tennessee | 47025 | 3268 | 74 |
1505915 | 1505915 | 2021-07-11 | Jefferson Davis | Louisiana | 22053 | 3268 | 97 |
1502669 | 1502669 | 2021-07-10 | Jefferson Davis | Louisiana | 22053 | 3268 | 97 |
1499423 | 1499423 | 2021-07-09 | Jefferson Davis | Louisiana | 22053 | 3268 | 97 |
1487864 | 1487864 | 2021-07-05 | Lauderdale | Tennessee | 47097 | 3268 | 50 |
1487871 | 1487871 | 2021-07-05 | Marion | Tennessee | 47115 | 3268 | 49 |
1482186 | 1482186 | 2021-07-04 | Jackson | Arkansas | 5067 | 3268 | 38 |
1484617 | 1484617 | 2021-07-04 | Lauderdale | Tennessee | 47097 | 3268 | 50 |
1484624 | 1484624 | 2021-07-04 | Marion | Tennessee | 47115 | 3268 | 49 |
1478939 | 1478939 | 2021-07-03 | Jackson | Arkansas | 5067 | 3268 | 38 |
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);