ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
209 rows where cases = 2452 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 14
- Indiana 13
- North Carolina 13
- Georgia 12
- Puerto Rico 12
- Texas 12
- Missouri 10
- Mississippi 8
- Oklahoma 8
- Alabama 7
- Iowa 7
- Louisiana 7
- South Carolina 7
- West Virginia 6
- Kentucky 5
- Arizona 4
- Illinois 4
- Michigan 4
- Minnesota 4
- Nebraska 4
- New York 4
- Ohio 4
- Tennessee 4
- Washington 4
- Wisconsin 4
- Arkansas 3
- Florida 3
- Pennsylvania 3
- Utah 3
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453868 | 2453868 | 2022-04-28 | Ritchie | West Virginia | 54085 | 2452 | 31 |
2381256 | 2381256 | 2022-04-06 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2378001 | 2378001 | 2022-04-05 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2374747 | 2374747 | 2022-04-04 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2371495 | 2371495 | 2022-04-03 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2368242 | 2368242 | 2022-04-02 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2364989 | 2364989 | 2022-04-01 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2361736 | 2361736 | 2022-03-31 | Blaine | Oklahoma | 40011 | 2452 | 41 |
2328630 | 2328630 | 2022-03-21 | Ralls | Missouri | 29173 | 2452 | 25 |
2325378 | 2325378 | 2022-03-20 | Ralls | Missouri | 29173 | 2452 | 25 |
2322124 | 2322124 | 2022-03-19 | Ralls | Missouri | 29173 | 2452 | 25 |
2318870 | 2318870 | 2022-03-18 | Ralls | Missouri | 29173 | 2452 | 25 |
2315617 | 2315617 | 2022-03-17 | Ralls | Missouri | 29173 | 2452 | 25 |
2306652 | 2306652 | 2022-03-14 | Luquillo | Puerto Rico | 72089 | 2452 | |
2266815 | 2266815 | 2022-03-02 | Montgomery | Missouri | 29139 | 2452 | 54 |
2263564 | 2263564 | 2022-03-01 | Montgomery | Missouri | 29139 | 2452 | 54 |
2260313 | 2260313 | 2022-02-28 | Montgomery | Missouri | 29139 | 2452 | 53 |
2258381 | 2258381 | 2022-02-27 | Emery | Utah | 49015 | 2452 | 27 |
2255130 | 2255130 | 2022-02-26 | Emery | Utah | 49015 | 2452 | 27 |
2251879 | 2251879 | 2022-02-25 | Emery | Utah | 49015 | 2452 | 27 |
2248713 | 2248713 | 2022-02-24 | Franklin city | Virginia | 51620 | 2452 | 46 |
2236695 | 2236695 | 2022-02-21 | Benton | Indiana | 18007 | 2452 | 21 |
2225336 | 2225336 | 2022-02-17 | Ciales | Puerto Rico | 72039 | 2452 | |
2215631 | 2215631 | 2022-02-14 | Santa Isabel | Puerto Rico | 72133 | 2452 | |
2188627 | 2188627 | 2022-02-06 | Carroll | Mississippi | 28015 | 2452 | 47 |
2185374 | 2185374 | 2022-02-05 | Carroll | Mississippi | 28015 | 2452 | 47 |
2182122 | 2182122 | 2022-02-04 | Carroll | Mississippi | 28015 | 2452 | 47 |
2175277 | 2175277 | 2022-02-02 | McLean | Kentucky | 21149 | 2452 | 44 |
2173898 | 2173898 | 2022-02-01 | Clarke | Virginia | 51043 | 2452 | 37 |
2167515 | 2167515 | 2022-01-30 | Jefferson | Washington | 53031 | 2452 | 22 |
2164260 | 2164260 | 2022-01-29 | Jefferson | Washington | 53031 | 2452 | 22 |
2161005 | 2161005 | 2022-01-28 | Jefferson | Washington | 53031 | 2452 | 22 |
2150592 | 2150592 | 2022-01-25 | Calhoun | South Carolina | 45017 | 2452 | 54 |
2147340 | 2147340 | 2022-01-24 | Calhoun | South Carolina | 45017 | 2452 | 54 |
2144086 | 2144086 | 2022-01-23 | Calhoun | South Carolina | 45017 | 2452 | 54 |
2140831 | 2140831 | 2022-01-22 | Calhoun | South Carolina | 45017 | 2452 | 54 |
2137575 | 2137575 | 2022-01-21 | Calhoun | South Carolina | 45017 | 2452 | 54 |
2105004 | 2105004 | 2022-01-11 | Loiza | Puerto Rico | 72087 | 2452 | |
2100704 | 2100704 | 2022-01-10 | Aitkin | Minnesota | 27001 | 2452 | 55 |
2062836 | 2062836 | 2021-12-29 | Clay | South Dakota | 46027 | 2452 | 17 |
2055788 | 2055788 | 2021-12-27 | Chowan | North Carolina | 37041 | 2452 | 44 |
2052538 | 2052538 | 2021-12-26 | Chowan | North Carolina | 37041 | 2452 | 44 |
2049288 | 2049288 | 2021-12-25 | Chowan | North Carolina | 37041 | 2452 | 44 |
2046038 | 2046038 | 2021-12-24 | Chowan | North Carolina | 37041 | 2452 | 44 |
2042788 | 2042788 | 2021-12-23 | Chowan | North Carolina | 37041 | 2452 | 44 |
2039539 | 2039539 | 2021-12-22 | Chowan | North Carolina | 37041 | 2452 | 44 |
2026998 | 2026998 | 2021-12-18 | Naranjito | Puerto Rico | 72105 | 2452 | |
2023740 | 2023740 | 2021-12-17 | Manati | Puerto Rico | 72091 | 2452 | |
1995758 | 1995758 | 2021-12-09 | Brooks | Georgia | 13027 | 2452 | 73 |
1993305 | 1993305 | 2021-12-08 | Washington | Maine | 23029 | 2452 | 36 |
1985293 | 1985293 | 2021-12-05 | Bristol city | Virginia | 51520 | 2452 | 50 |
1982043 | 1982043 | 2021-12-04 | Bristol city | Virginia | 51520 | 2452 | 50 |
1978793 | 1978793 | 2021-12-03 | Bristol city | Virginia | 51520 | 2452 | 50 |
1970985 | 1970985 | 2021-12-01 | Glacier | Montana | 30035 | 2452 | 62 |
1960384 | 1960384 | 2021-11-28 | Tipton | Indiana | 18159 | 2452 | 67 |
1962243 | 1962243 | 2021-11-28 | Bosque | Texas | 48035 | 2452 | 57 |
1957133 | 1957133 | 2021-11-27 | Tipton | Indiana | 18159 | 2452 | 67 |
1958992 | 1958992 | 2021-11-27 | Bosque | Texas | 48035 | 2452 | 57 |
1953882 | 1953882 | 2021-11-26 | Tipton | Indiana | 18159 | 2452 | 67 |
1955741 | 1955741 | 2021-11-26 | Bosque | Texas | 48035 | 2452 | 57 |
1950631 | 1950631 | 2021-11-25 | Tipton | Indiana | 18159 | 2452 | 67 |
1952490 | 1952490 | 2021-11-25 | Bosque | Texas | 48035 | 2452 | 57 |
1947380 | 1947380 | 2021-11-24 | Tipton | Indiana | 18159 | 2452 | 67 |
1949239 | 1949239 | 2021-11-24 | Bosque | Texas | 48035 | 2452 | 57 |
1945988 | 1945988 | 2021-11-23 | Bosque | Texas | 48035 | 2452 | 57 |
1942092 | 1942092 | 2021-11-22 | Warren | North Carolina | 37185 | 2452 | 33 |
1942737 | 1942737 | 2021-11-22 | Bosque | Texas | 48035 | 2452 | 57 |
1932678 | 1932678 | 2021-11-19 | Aguada | Puerto Rico | 72003 | 2452 | |
1928442 | 1928442 | 2021-11-18 | Faribault | Minnesota | 27043 | 2452 | 31 |
1917381 | 1917381 | 2021-11-15 | Lamar | Alabama | 1075 | 2452 | 52 |
1899736 | 1899736 | 2021-11-09 | Schoharie | New York | 36095 | 2452 | 24 |
1895951 | 1895951 | 2021-11-08 | Houston | Minnesota | 27055 | 2452 | 17 |
1875083 | 1875083 | 2021-11-01 | Goshen | Wyoming | 56015 | 2452 | 38 |
1857013 | 1857013 | 2021-10-27 | Wadena | Minnesota | 27159 | 2452 | 29 |
1850152 | 1850152 | 2021-10-25 | Green | Kentucky | 21087 | 2452 | 34 |
1845876 | 1845876 | 2021-10-24 | Crenshaw | Alabama | 1041 | 2452 | 75 |
1842626 | 1842626 | 2021-10-23 | Crenshaw | Alabama | 1041 | 2452 | 75 |
1837226 | 1837226 | 2021-10-21 | Webster | Kentucky | 21233 | 2452 | 34 |
1828405 | 1828405 | 2021-10-18 | Richland | North Dakota | 38077 | 2452 | 19 |
1825467 | 1825467 | 2021-10-17 | Corozal | Puerto Rico | 72047 | 2452 | |
1825890 | 1825890 | 2021-10-17 | Madison | Texas | 48313 | 2452 | 43 |
1822641 | 1822641 | 2021-10-16 | Madison | Texas | 48313 | 2452 | 43 |
1790363 | 1790363 | 2021-10-06 | King George | Virginia | 51099 | 2452 | 22 |
1781499 | 1781499 | 2021-10-04 | Edgar | Illinois | 17045 | 2452 | 65 |
1780725 | 1780725 | 2021-10-03 | Barbour | West Virginia | 54001 | 2452 | 41 |
1768269 | 1768269 | 2021-09-30 | Bacon | Georgia | 13005 | 2452 | 52 |
1769186 | 1769186 | 2021-09-30 | Osceola | Michigan | 26133 | 2452 | 34 |
1765937 | 1765937 | 2021-09-29 | Osceola | Michigan | 26133 | 2452 | 34 |
1760708 | 1760708 | 2021-09-27 | Lewis | Tennessee | 47101 | 2452 | 33 |
1756585 | 1756585 | 2021-09-26 | Gage | Nebraska | 31067 | 2452 | 20 |
1751698 | 1751698 | 2021-09-25 | Washington | Alabama | 1129 | 2452 | 48 |
1753337 | 1753337 | 2021-09-25 | Gage | Nebraska | 31067 | 2452 | 20 |
1750089 | 1750089 | 2021-09-24 | Gage | Nebraska | 31067 | 2452 | 20 |
1728036 | 1728036 | 2021-09-17 | San Sebastian | Puerto Rico | 72131 | 2452 | |
1700330 | 1700330 | 2021-09-09 | Pike | Illinois | 17149 | 2452 | 59 |
1693613 | 1693613 | 2021-09-07 | Greene | Georgia | 13133 | 2452 | 65 |
1689678 | 1689678 | 2021-09-05 | Page | Virginia | 51139 | 2452 | 61 |
1686428 | 1686428 | 2021-09-04 | Page | Virginia | 51139 | 2452 | 61 |
1683177 | 1683177 | 2021-09-03 | Page | Virginia | 51139 | 2452 | 61 |
1670139 | 1670139 | 2021-08-30 | Fredericksburg city | Virginia | 51630 | 2452 | 25 |
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);