ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
251 rows where cases = 2079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 30
- Georgia 26
- North Carolina 18
- Virginia 18
- Texas 16
- Tennessee 15
- Arkansas 14
- Kentucky 14
- Missouri 13
- Indiana 8
- Louisiana 8
- Michigan 7
- Mississippi 6
- Puerto Rico 6
- West Virginia 5
- Illinois 4
- New York 4
- Ohio 4
- Oregon 4
- Pennsylvania 4
- Iowa 3
- North Dakota 3
- South Carolina 3
- Alabama 2
- Colorado 2
- Florida 2
- Kansas 2
- Washington 2
- Wisconsin 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490294 | 2490294 | 2022-05-10 | Montgomery | Georgia | 13209 | 2079 | 53 |
2487037 | 2487037 | 2022-05-09 | Montgomery | Georgia | 13209 | 2079 | 53 |
2483779 | 2483779 | 2022-05-08 | Montgomery | Georgia | 13209 | 2079 | 53 |
2480521 | 2480521 | 2022-05-07 | Montgomery | Georgia | 13209 | 2079 | 53 |
2477263 | 2477263 | 2022-05-06 | Montgomery | Georgia | 13209 | 2079 | 53 |
2474005 | 2474005 | 2022-05-05 | Montgomery | Georgia | 13209 | 2079 | 53 |
2470748 | 2470748 | 2022-05-04 | Montgomery | Georgia | 13209 | 2079 | 53 |
2443622 | 2443622 | 2022-04-25 | Clay | Texas | 48077 | 2079 | 35 |
2440366 | 2440366 | 2022-04-24 | Clay | Texas | 48077 | 2079 | 35 |
2437110 | 2437110 | 2022-04-23 | Clay | Texas | 48077 | 2079 | 35 |
2422783 | 2422783 | 2022-04-19 | Lake | Minnesota | 27075 | 2079 | 28 |
2325162 | 2325162 | 2022-03-20 | Marshall | Minnesota | 27089 | 2079 | 23 |
2321908 | 2321908 | 2022-03-19 | Marshall | Minnesota | 27089 | 2079 | 23 |
2318654 | 2318654 | 2022-03-18 | Marshall | Minnesota | 27089 | 2079 | 23 |
2315401 | 2315401 | 2022-03-17 | Marshall | Minnesota | 27089 | 2079 | 23 |
2312148 | 2312148 | 2022-03-16 | Marshall | Minnesota | 27089 | 2079 | 23 |
2291125 | 2291125 | 2022-03-09 | Gilmer | West Virginia | 54021 | 2079 | 18 |
2287873 | 2287873 | 2022-03-08 | Gilmer | West Virginia | 54021 | 2079 | 18 |
2224016 | 2224016 | 2022-02-17 | Elliott | Kentucky | 21063 | 2079 | 16 |
2225614 | 2225614 | 2022-02-17 | Archer | Texas | 48009 | 2079 | 27 |
2217823 | 2217823 | 2022-02-15 | Clearwater | Minnesota | 27029 | 2079 | 29 |
2216069 | 2216069 | 2022-02-14 | Somervell | Texas | 48425 | 2079 | 32 |
2195370 | 2195370 | 2022-02-08 | Sanders | Montana | 30089 | 2079 | 44 |
2196729 | 2196729 | 2022-02-08 | Northumberland | Virginia | 51133 | 2079 | 41 |
2189161 | 2189161 | 2022-02-06 | Jones | North Carolina | 37103 | 2079 | 38 |
2184111 | 2184111 | 2022-02-05 | Nevada | Arkansas | 5099 | 2079 | 43 |
2185519 | 2185519 | 2022-02-05 | Monroe | Missouri | 29137 | 2079 | 38 |
2185908 | 2185908 | 2022-02-05 | Jones | North Carolina | 37103 | 2079 | 38 |
2182656 | 2182656 | 2022-02-04 | Jones | North Carolina | 37103 | 2079 | 38 |
2178897 | 2178897 | 2022-02-03 | Kemper | Mississippi | 28069 | 2079 | 44 |
2171982 | 2171982 | 2022-02-01 | Gallatin | Kentucky | 21077 | 2079 | 45 |
2173395 | 2173395 | 2022-02-01 | McCormick | South Carolina | 45065 | 2079 | 34 |
2173762 | 2173762 | 2022-02-01 | Red River | Texas | 48387 | 2079 | 60 |
2163946 | 2163946 | 2022-01-29 | La Salle | Texas | 48283 | 2079 | 42 |
2144685 | 2144685 | 2022-01-23 | Poquoson city | Virginia | 51735 | 2079 | 24 |
2141430 | 2141430 | 2022-01-22 | Poquoson city | Virginia | 51735 | 2079 | 24 |
2138174 | 2138174 | 2022-01-21 | Poquoson city | Virginia | 51735 | 2079 | 24 |
2127960 | 2127960 | 2022-01-18 | Houston | Tennessee | 47083 | 2079 | 53 |
2124708 | 2124708 | 2022-01-17 | Houston | Tennessee | 47083 | 2079 | 53 |
2121456 | 2121456 | 2022-01-16 | Houston | Tennessee | 47083 | 2079 | 53 |
2118204 | 2118204 | 2022-01-15 | Houston | Tennessee | 47083 | 2079 | 53 |
2114953 | 2114953 | 2022-01-14 | Houston | Tennessee | 47083 | 2079 | 53 |
2111701 | 2111701 | 2022-01-13 | Houston | Tennessee | 47083 | 2079 | 53 |
2108449 | 2108449 | 2022-01-12 | Houston | Tennessee | 47083 | 2079 | 53 |
2105014 | 2105014 | 2022-01-11 | Orocovis | Puerto Rico | 72107 | 2079 | |
2100933 | 2100933 | 2022-01-10 | Linn | Missouri | 29115 | 2079 | 58 |
2092914 | 2092914 | 2022-01-08 | Lowndes | Alabama | 1085 | 2079 | 68 |
2081369 | 2081369 | 2022-01-04 | Barton | Missouri | 29011 | 2079 | 42 |
2056755 | 2056755 | 2021-12-27 | Morgan | Utah | 49029 | 2079 | 13 |
2029185 | 2029185 | 2021-12-19 | Unknown | Michigan | 2079 | 22 | |
2006599 | 2006599 | 2021-12-12 | Webster | Mississippi | 28155 | 2079 | 49 |
2003348 | 2003348 | 2021-12-11 | Webster | Mississippi | 28155 | 2079 | 49 |
2000098 | 2000098 | 2021-12-10 | Webster | Mississippi | 28155 | 2079 | 49 |
1969972 | 1969972 | 2021-12-01 | Cumberland | Illinois | 17035 | 2079 | 39 |
1961130 | 1961130 | 2021-11-28 | Dent | Missouri | 29065 | 2079 | 62 |
1961636 | 1961636 | 2021-11-28 | Mountrail | North Dakota | 38061 | 2079 | 29 |
1957879 | 1957879 | 2021-11-27 | Dent | Missouri | 29065 | 2079 | 62 |
1954628 | 1954628 | 2021-11-26 | Dent | Missouri | 29065 | 2079 | 62 |
1951377 | 1951377 | 2021-11-25 | Dent | Missouri | 29065 | 2079 | 62 |
1948126 | 1948126 | 2021-11-24 | Dent | Missouri | 29065 | 2079 | 62 |
1925171 | 1925171 | 2021-11-17 | Aitkin | Minnesota | 27001 | 2079 | 47 |
1917428 | 1917428 | 2021-11-15 | Northwest Arctic Borough | Alaska | 2188 | 2079 | 9 |
1893576 | 1893576 | 2021-11-07 | Baker | Oregon | 41001 | 2079 | 30 |
1890326 | 1890326 | 2021-11-06 | Baker | Oregon | 41001 | 2079 | 30 |
1887076 | 1887076 | 2021-11-05 | Baker | Oregon | 41001 | 2079 | 30 |
1881427 | 1881427 | 2021-11-03 | Klickitat | Washington | 53039 | 2079 | 22 |
1858735 | 1858735 | 2021-10-27 | Monroe | West Virginia | 54063 | 2079 | 25 |
1835789 | 1835789 | 2021-10-20 | Alleghany | Virginia | 51005 | 2079 | 71 |
1820012 | 1820012 | 2021-10-16 | Lee | Arkansas | 5077 | 2079 | 48 |
1789981 | 1789981 | 2021-10-06 | Stewart | Tennessee | 47161 | 2079 | 33 |
1784161 | 1784161 | 2021-10-05 | Lamar | Alabama | 1075 | 2079 | 45 |
1781344 | 1781344 | 2021-10-04 | Jasper | Georgia | 13159 | 2079 | 54 |
1769330 | 1769330 | 2021-09-30 | Lawrence | Mississippi | 28077 | 2079 | 36 |
1763967 | 1763967 | 2021-09-28 | Meigs | Tennessee | 47121 | 2079 | 25 |
1756447 | 1756447 | 2021-09-26 | Mississippi | Missouri | 29133 | 2079 | 34 |
1744828 | 1744828 | 2021-09-22 | Buchanan | Virginia | 51027 | 2079 | 47 |
1734118 | 1734118 | 2021-09-19 | Polk | North Carolina | 37149 | 2079 | 40 |
1730868 | 1730868 | 2021-09-18 | Polk | North Carolina | 37149 | 2079 | 40 |
1727618 | 1727618 | 2021-09-17 | Polk | North Carolina | 37149 | 2079 | 40 |
1721196 | 1721196 | 2021-09-15 | Walsh | North Dakota | 38099 | 2079 | 27 |
1718760 | 1718760 | 2021-09-14 | Wilbarger | Texas | 48487 | 2079 | 56 |
1713762 | 1713762 | 2021-09-13 | Washington | Kentucky | 21229 | 2079 | 42 |
1700553 | 1700553 | 2021-09-09 | Atchison | Kansas | 20005 | 2079 | 23 |
1697304 | 1697304 | 2021-09-08 | Atchison | Kansas | 20005 | 2079 | 23 |
1691871 | 1691871 | 2021-09-06 | Madison | North Carolina | 37115 | 2079 | 44 |
1688621 | 1688621 | 2021-09-05 | Madison | North Carolina | 37115 | 2079 | 44 |
1685371 | 1685371 | 2021-09-04 | Madison | North Carolina | 37115 | 2079 | 44 |
1682120 | 1682120 | 2021-09-03 | Madison | North Carolina | 37115 | 2079 | 44 |
1677311 | 1677311 | 2021-09-02 | Bleckley | Georgia | 13023 | 2079 | 53 |
1676118 | 1676118 | 2021-09-01 | Saluda | South Carolina | 45081 | 2079 | 49 |
1671492 | 1671492 | 2021-08-31 | Mason | Kentucky | 21161 | 2079 | 43 |
1666961 | 1666961 | 2021-08-29 | Southampton | Virginia | 51175 | 2079 | 58 |
1662982 | 1662982 | 2021-08-28 | Montour | Pennsylvania | 42093 | 2079 | 67 |
1663713 | 1663713 | 2021-08-28 | Southampton | Virginia | 51175 | 2079 | 58 |
1660465 | 1660465 | 2021-08-27 | Southampton | Virginia | 51175 | 2079 | 58 |
1650363 | 1650363 | 2021-08-24 | DeWitt | Texas | 48123 | 2079 | 64 |
1645559 | 1645559 | 2021-08-23 | Bienville | Louisiana | 22013 | 2079 | 84 |
1645777 | 1645777 | 2021-08-23 | Dodge | Minnesota | 27039 | 2079 | 3 |
1634449 | 1634449 | 2021-08-19 | Nottoway | Virginia | 51135 | 2079 | 55 |
1631063 | 1631063 | 2021-08-18 | Zavala | Texas | 48507 | 2079 | 43 |
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);