ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
289 rows where cases = 2058 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 35
- Georgia 23
- Kentucky 19
- Texas 17
- Arkansas 15
- Puerto Rico 14
- Indiana 13
- Mississippi 12
- Virginia 12
- Wisconsin 11
- Missouri 10
- Louisiana 9
- South Carolina 9
- West Virginia 9
- Minnesota 8
- Ohio 6
- Vermont 6
- Illinois 5
- Maine 5
- New Hampshire 5
- Oregon 5
- Tennessee 5
- Iowa 4
- Maryland 4
- Wyoming 3
- Alabama 2
- Idaho 2
- Kansas 2
- Michigan 2
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426294 | 2426294 | 2022-04-20 | Carbon | Montana | 30009 | 2058 | 28 |
2421133 | 2421133 | 2022-04-18 | Falls Church city | Virginia | 51610 | 2058 | 16 |
2313916 | 2313916 | 2022-03-16 | Pleasants | West Virginia | 54073 | 2058 | 34 |
2308889 | 2308889 | 2022-03-15 | Lake | Minnesota | 27075 | 2058 | 28 |
2310663 | 2310663 | 2022-03-15 | Pleasants | West Virginia | 54073 | 2058 | 34 |
2257914 | 2257914 | 2022-02-27 | Allendale | South Carolina | 45005 | 2058 | 24 |
2254663 | 2254663 | 2022-02-26 | Allendale | South Carolina | 45005 | 2058 | 24 |
2251412 | 2251412 | 2022-02-25 | Allendale | South Carolina | 45005 | 2058 | 24 |
2248161 | 2248161 | 2022-02-24 | Allendale | South Carolina | 45005 | 2058 | 24 |
2233147 | 2233147 | 2022-02-20 | Candler | Georgia | 13043 | 2058 | 91 |
2229896 | 2229896 | 2022-02-19 | Candler | Georgia | 13043 | 2058 | 91 |
2226645 | 2226645 | 2022-02-18 | Candler | Georgia | 13043 | 2058 | 91 |
2219163 | 2219163 | 2022-02-15 | Dallam | Texas | 48111 | 2058 | 38 |
2185486 | 2185486 | 2022-02-05 | Gentry | Missouri | 29075 | 2058 | 28 |
2174355 | 2174355 | 2022-02-02 | Nevada | Arkansas | 5099 | 2058 | 43 |
2175645 | 2175645 | 2022-02-02 | Kemper | Mississippi | 28069 | 2058 | 43 |
2173276 | 2173276 | 2022-02-01 | Adjuntas | Puerto Rico | 72001 | 2058 | |
2170024 | 2170024 | 2022-01-31 | Adjuntas | Puerto Rico | 72001 | 2058 | |
2165189 | 2165189 | 2022-01-30 | Martin | Indiana | 18101 | 2058 | 23 |
2161934 | 2161934 | 2022-01-29 | Martin | Indiana | 18101 | 2058 | 23 |
2164001 | 2164001 | 2022-01-29 | Red River | Texas | 48387 | 2058 | 59 |
2158679 | 2158679 | 2022-01-28 | Martin | Indiana | 18101 | 2058 | 23 |
2155219 | 2155219 | 2022-01-27 | Wilkinson | Georgia | 13319 | 2058 | 49 |
2142690 | 2142690 | 2022-01-23 | Edmonson | Kentucky | 21061 | 2058 | 35 |
2139435 | 2139435 | 2022-01-22 | Edmonson | Kentucky | 21061 | 2058 | 35 |
2136179 | 2136179 | 2022-01-21 | Edmonson | Kentucky | 21061 | 2058 | 35 |
2132961 | 2132961 | 2022-01-20 | Lee | Kentucky | 21129 | 2058 | 44 |
2123538 | 2123538 | 2022-01-17 | Stevens | Minnesota | 27149 | 2058 | 11 |
2120286 | 2120286 | 2022-01-16 | Stevens | Minnesota | 27149 | 2058 | 11 |
2117034 | 2117034 | 2022-01-15 | Stevens | Minnesota | 27149 | 2058 | 11 |
2113783 | 2113783 | 2022-01-14 | Stevens | Minnesota | 27149 | 2058 | 11 |
2100799 | 2100799 | 2022-01-10 | Carroll | Mississippi | 28015 | 2058 | 42 |
2089662 | 2089662 | 2022-01-07 | Lowndes | Alabama | 1085 | 2058 | 68 |
2087081 | 2087081 | 2022-01-06 | Brown | Indiana | 18013 | 2058 | 52 |
2082261 | 2082261 | 2022-01-04 | Salinas | Puerto Rico | 72123 | 2058 | |
2050728 | 2050728 | 2021-12-26 | Bradley | Arkansas | 5011 | 2058 | 42 |
2047478 | 2047478 | 2021-12-25 | Bradley | Arkansas | 5011 | 2058 | 42 |
2044228 | 2044228 | 2021-12-24 | Bradley | Arkansas | 5011 | 2058 | 42 |
2040979 | 2040979 | 2021-12-23 | Bradley | Arkansas | 5011 | 2058 | 42 |
2011413 | 2011413 | 2021-12-13 | Westmoreland | Virginia | 51193 | 2058 | 39 |
2006241 | 2006241 | 2021-12-12 | Claiborne | Louisiana | 22027 | 2058 | 66 |
2002990 | 2002990 | 2021-12-11 | Claiborne | Louisiana | 22027 | 2058 | 66 |
1999740 | 1999740 | 2021-12-10 | Claiborne | Louisiana | 22027 | 2058 | 66 |
1993995 | 1993995 | 2021-12-08 | Schuyler | New York | 36097 | 2058 | 20 |
1942214 | 1942214 | 2021-11-22 | Morgan | Ohio | 39115 | 2058 | 38 |
1924440 | 1924440 | 2021-11-17 | Shoshone | Idaho | 16079 | 2058 | 63 |
1922943 | 1922943 | 2021-11-16 | Cayey | Puerto Rico | 72035 | 2058 | |
1919694 | 1919694 | 2021-11-15 | Cayey | Puerto Rico | 72035 | 2058 | |
1916444 | 1916444 | 2021-11-14 | Cayey | Puerto Rico | 72035 | 2058 | |
1913194 | 1913194 | 2021-11-13 | Cayey | Puerto Rico | 72035 | 2058 | |
1905360 | 1905360 | 2021-11-11 | Breathitt | Kentucky | 21025 | 2058 | 36 |
1902110 | 1902110 | 2021-11-10 | Breathitt | Kentucky | 21025 | 2058 | 36 |
1895798 | 1895798 | 2021-11-08 | Washington | Maine | 23029 | 2058 | 23 |
1892548 | 1892548 | 2021-11-07 | Washington | Maine | 23029 | 2058 | 23 |
1894574 | 1894574 | 2021-11-07 | Big Horn | Wyoming | 56003 | 2058 | 54 |
1889298 | 1889298 | 2021-11-06 | Washington | Maine | 23029 | 2058 | 23 |
1891324 | 1891324 | 2021-11-06 | Big Horn | Wyoming | 56003 | 2058 | 54 |
1888074 | 1888074 | 2021-11-05 | Big Horn | Wyoming | 56003 | 2058 | 54 |
1876297 | 1876297 | 2021-11-02 | Sagadahoc | Maine | 23023 | 2058 | 13 |
1870830 | 1870830 | 2021-10-31 | Baker | Oregon | 41001 | 2058 | 29 |
1867581 | 1867581 | 2021-10-30 | Baker | Oregon | 41001 | 2058 | 29 |
1864332 | 1864332 | 2021-10-29 | Baker | Oregon | 41001 | 2058 | 29 |
1849739 | 1849739 | 2021-10-25 | Greene | Illinois | 17061 | 2058 | 53 |
1833441 | 1833441 | 2021-10-20 | Idaho | Idaho | 16049 | 2058 | 31 |
1826042 | 1826042 | 2021-10-17 | Alleghany | Virginia | 51005 | 2058 | 65 |
1822793 | 1822793 | 2021-10-16 | Alleghany | Virginia | 51005 | 2058 | 65 |
1819544 | 1819544 | 2021-10-15 | Alleghany | Virginia | 51005 | 2058 | 65 |
1796561 | 1796561 | 2021-10-08 | Eastland | Texas | 48133 | 2058 | 76 |
1787522 | 1787522 | 2021-10-06 | Lee | Arkansas | 5077 | 2058 | 48 |
1778659 | 1778659 | 2021-10-03 | Estill | Kentucky | 21065 | 2058 | 12 |
1775409 | 1775409 | 2021-10-02 | Estill | Kentucky | 21065 | 2058 | 12 |
1772159 | 1772159 | 2021-10-01 | Estill | Kentucky | 21065 | 2058 | 12 |
1761847 | 1761847 | 2021-09-28 | Jasper | Georgia | 13159 | 2058 | 53 |
1764543 | 1764543 | 2021-09-28 | Crawford | Wisconsin | 55023 | 2058 | 22 |
1759148 | 1759148 | 2021-09-27 | Caldwell | Kentucky | 21033 | 2058 | 44 |
1743018 | 1743018 | 2021-09-22 | Caldwell | Louisiana | 22021 | 2058 | 37 |
1727197 | 1727197 | 2021-09-17 | Macon | Missouri | 29121 | 2058 | 19 |
1724369 | 1724369 | 2021-09-16 | Polk | North Carolina | 37149 | 2058 | 40 |
1719924 | 1719924 | 2021-09-15 | Tipton | Indiana | 18159 | 2058 | 56 |
1694213 | 1694213 | 2021-09-07 | Jackson | Kentucky | 21109 | 2058 | 40 |
1675785 | 1675785 | 2021-09-01 | Paulding | Ohio | 39125 | 2058 | 42 |
1668190 | 1668190 | 2021-08-30 | Casey | Kentucky | 21045 | 2058 | 45 |
1649281 | 1649281 | 2021-08-24 | Ste. Genevieve | Missouri | 29186 | 2058 | 19 |
1649929 | 1649929 | 2021-08-24 | Lincoln | Oregon | 41041 | 2058 | 24 |
1642232 | 1642232 | 2021-08-22 | Harrison | Kentucky | 21097 | 2058 | 27 |
1638982 | 1638982 | 2021-08-21 | Harrison | Kentucky | 21097 | 2058 | 27 |
1635732 | 1635732 | 2021-08-20 | Harrison | Kentucky | 21097 | 2058 | 27 |
1628798 | 1628798 | 2021-08-18 | Clark | Illinois | 17023 | 2058 | 44 |
1626766 | 1626766 | 2021-08-17 | Lincoln | New Mexico | 35027 | 2058 | 20 |
1623112 | 1623112 | 2021-08-16 | Calhoun | Mississippi | 28013 | 2058 | 33 |
1618848 | 1618848 | 2021-08-15 | Brantley | Georgia | 13025 | 2058 | 42 |
1615600 | 1615600 | 2021-08-14 | Brantley | Georgia | 13025 | 2058 | 42 |
1612351 | 1612351 | 2021-08-13 | Brantley | Georgia | 13025 | 2058 | 42 |
1614278 | 1614278 | 2021-08-13 | Wyoming | Pennsylvania | 42131 | 2058 | 54 |
1597145 | 1597145 | 2021-08-08 | Holmes | Mississippi | 28051 | 2058 | 74 |
1593896 | 1593896 | 2021-08-07 | Holmes | Mississippi | 28051 | 2058 | 74 |
1594527 | 1594527 | 2021-08-07 | Carroll | Ohio | 39019 | 2058 | 49 |
1590647 | 1590647 | 2021-08-06 | Holmes | Mississippi | 28051 | 2058 | 74 |
1588399 | 1588399 | 2021-08-05 | Hampton | South Carolina | 45049 | 2058 | 53 |
1574041 | 1574041 | 2021-08-01 | McCreary | Kentucky | 21147 | 2058 | 34 |
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);