ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
225 rows where cases = 2613 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 29
- Kentucky 16
- Texas 16
- Georgia 15
- Illinois 13
- Mississippi 13
- Missouri 12
- Wisconsin 10
- Maryland 9
- Puerto Rico 8
- Kansas 7
- West Virginia 7
- Arkansas 6
- Virginia 6
- Indiana 5
- North Carolina 5
- Ohio 5
- Alabama 4
- Colorado 4
- Idaho 4
- Iowa 4
- South Carolina 3
- Tennessee 3
- Florida 2
- Minnesota 2
- Nevada 2
- New York 2
- North Dakota 2
- Pennsylvania 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415988 | 2415988 | 2022-04-17 | McLean | Kentucky | 21149 | 2613 | 50 |
2412732 | 2412732 | 2022-04-16 | McLean | Kentucky | 21149 | 2613 | 50 |
2409476 | 2409476 | 2022-04-15 | McLean | Kentucky | 21149 | 2613 | 50 |
2406220 | 2406220 | 2022-04-14 | McLean | Kentucky | 21149 | 2613 | 50 |
2402964 | 2402964 | 2022-04-13 | McLean | Kentucky | 21149 | 2613 | 50 |
2399710 | 2399710 | 2022-04-12 | McLean | Kentucky | 21149 | 2613 | 50 |
2396454 | 2396454 | 2022-04-11 | McLean | Kentucky | 21149 | 2613 | 50 |
2375522 | 2375522 | 2022-04-04 | Amelia | Virginia | 51007 | 2613 | 61 |
2372087 | 2372087 | 2022-04-03 | Jim Hogg | Texas | 48247 | 2613 | 22 |
2327209 | 2327209 | 2022-03-21 | Pike | Arkansas | 5109 | 2613 | 42 |
2288527 | 2288527 | 2022-03-09 | Screven | Georgia | 13251 | 2613 | 67 |
2290242 | 2290242 | 2022-03-09 | Washita | Oklahoma | 40149 | 2613 | 46 |
2286990 | 2286990 | 2022-03-08 | Washita | Oklahoma | 40149 | 2613 | 46 |
2283738 | 2283738 | 2022-03-07 | Washita | Oklahoma | 40149 | 2613 | 46 |
2280486 | 2280486 | 2022-03-06 | Washita | Oklahoma | 40149 | 2613 | 46 |
2277233 | 2277233 | 2022-03-05 | Washita | Oklahoma | 40149 | 2613 | 46 |
2273980 | 2273980 | 2022-03-04 | Washita | Oklahoma | 40149 | 2613 | 46 |
2270727 | 2270727 | 2022-03-03 | Washita | Oklahoma | 40149 | 2613 | 46 |
2267475 | 2267475 | 2022-03-02 | Washita | Oklahoma | 40149 | 2613 | 46 |
2224346 | 2224346 | 2022-02-17 | Koochiching | Minnesota | 27071 | 2613 | 34 |
2197263 | 2197263 | 2022-02-09 | Rio Grande | Colorado | 8105 | 2613 | 43 |
2171523 | 2171523 | 2022-02-01 | Gooding | Idaho | 16047 | 2613 | 48 |
2173146 | 2173146 | 2022-02-01 | Noble | Oklahoma | 40103 | 2613 | 33 |
2169894 | 2169894 | 2022-01-31 | Noble | Oklahoma | 40103 | 2613 | 33 |
2166639 | 2166639 | 2022-01-30 | Noble | Oklahoma | 40103 | 2613 | 33 |
2167094 | 2167094 | 2022-01-30 | Camp | Texas | 48063 | 2613 | 70 |
2163384 | 2163384 | 2022-01-29 | Noble | Oklahoma | 40103 | 2613 | 33 |
2160129 | 2160129 | 2022-01-28 | Noble | Oklahoma | 40103 | 2613 | 33 |
2156874 | 2156874 | 2022-01-27 | Noble | Oklahoma | 40103 | 2613 | 33 |
2157026 | 2157026 | 2022-01-27 | Comerio | Puerto Rico | 72045 | 2613 | |
2153621 | 2153621 | 2022-01-26 | Noble | Oklahoma | 40103 | 2613 | 33 |
2141551 | 2141551 | 2022-01-22 | Roane | West Virginia | 54087 | 2613 | 30 |
2130078 | 2130078 | 2022-01-19 | Greene | Mississippi | 28041 | 2613 | 50 |
2111526 | 2111526 | 2022-01-13 | San German | Puerto Rico | 72125 | 2613 | |
2086324 | 2086324 | 2022-01-05 | Price | Wisconsin | 55099 | 2613 | 22 |
2076142 | 2076142 | 2022-01-02 | Madison | Texas | 48313 | 2613 | 46 |
2070148 | 2070148 | 2022-01-01 | Lamar | Alabama | 1075 | 2613 | 59 |
2072891 | 2072891 | 2022-01-01 | Madison | Texas | 48313 | 2613 | 46 |
2066897 | 2066897 | 2021-12-31 | Lamar | Alabama | 1075 | 2613 | 59 |
2069640 | 2069640 | 2021-12-31 | Madison | Texas | 48313 | 2613 | 46 |
2066389 | 2066389 | 2021-12-30 | Madison | Texas | 48313 | 2613 | 46 |
2062940 | 2062940 | 2021-12-29 | Lewis | Tennessee | 47101 | 2613 | 48 |
2052139 | 2052139 | 2021-12-26 | Dallas | Missouri | 29059 | 2613 | 58 |
2053715 | 2053715 | 2021-12-26 | Braxton | West Virginia | 54007 | 2613 | 29 |
2048889 | 2048889 | 2021-12-25 | Dallas | Missouri | 29059 | 2613 | 58 |
2050465 | 2050465 | 2021-12-25 | Braxton | West Virginia | 54007 | 2613 | 29 |
2045639 | 2045639 | 2021-12-24 | Dallas | Missouri | 29059 | 2613 | 58 |
2047215 | 2047215 | 2021-12-24 | Braxton | West Virginia | 54007 | 2613 | 29 |
2042389 | 2042389 | 2021-12-23 | Dallas | Missouri | 29059 | 2613 | 58 |
2043965 | 2043965 | 2021-12-23 | Braxton | West Virginia | 54007 | 2613 | 29 |
2039947 | 2039947 | 2021-12-22 | Aguada | Puerto Rico | 72003 | 2613 | |
2008314 | 2008314 | 2021-12-12 | Richland | Wisconsin | 55103 | 2613 | 33 |
2005063 | 2005063 | 2021-12-11 | Richland | Wisconsin | 55103 | 2613 | 33 |
2001812 | 2001812 | 2021-12-10 | Richland | Wisconsin | 55103 | 2613 | 33 |
1998053 | 1998053 | 2021-12-09 | Falls | Texas | 48145 | 2613 | 51 |
1983466 | 1983466 | 2021-12-05 | Union | Kentucky | 21225 | 2613 | 41 |
1980216 | 1980216 | 2021-12-04 | Union | Kentucky | 21225 | 2613 | 41 |
1976966 | 1976966 | 2021-12-03 | Union | Kentucky | 21225 | 2613 | 41 |
1969373 | 1969373 | 2021-12-01 | Crenshaw | Alabama | 1041 | 2613 | 77 |
1970049 | 1970049 | 2021-12-01 | Warren | Illinois | 17187 | 2613 | 72 |
1960502 | 1960502 | 2021-11-28 | Bourbon | Kansas | 20011 | 2613 | 44 |
1956503 | 1956503 | 2021-11-27 | Madison | Arkansas | 5087 | 2613 | 40 |
1957251 | 1957251 | 2021-11-27 | Bourbon | Kansas | 20011 | 2613 | 44 |
1954000 | 1954000 | 2021-11-26 | Bourbon | Kansas | 20011 | 2613 | 44 |
1950749 | 1950749 | 2021-11-25 | Bourbon | Kansas | 20011 | 2613 | 44 |
1947498 | 1947498 | 2021-11-24 | Bourbon | Kansas | 20011 | 2613 | 44 |
1904855 | 1904855 | 2021-11-11 | Rabun | Georgia | 13241 | 2613 | 68 |
1901605 | 1901605 | 2021-11-10 | Rabun | Georgia | 13241 | 2613 | 68 |
1903794 | 1903794 | 2021-11-10 | Falls | Texas | 48145 | 2613 | 48 |
1898925 | 1898925 | 2021-11-09 | Mason | Kentucky | 21161 | 2613 | 68 |
1900544 | 1900544 | 2021-11-09 | Falls | Texas | 48145 | 2613 | 48 |
1894044 | 1894044 | 2021-11-07 | Falls | Texas | 48145 | 2613 | 48 |
1890794 | 1890794 | 2021-11-06 | Falls | Texas | 48145 | 2613 | 48 |
1874624 | 1874624 | 2021-11-01 | Llano | Texas | 48299 | 2613 | 73 |
1850163 | 1850163 | 2021-10-25 | Jackson | Kentucky | 21109 | 2613 | 50 |
1836820 | 1836820 | 2021-10-21 | Carroll | Indiana | 18015 | 2613 | 35 |
1834045 | 1834045 | 2021-10-20 | Winn | Louisiana | 22127 | 2613 | 58 |
1809030 | 1809030 | 2021-10-12 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1809198 | 1809198 | 2021-10-12 | Wyoming | Pennsylvania | 42131 | 2613 | 58 |
1803922 | 1803922 | 2021-10-11 | Teller | Colorado | 8119 | 2613 | 25 |
1805780 | 1805780 | 2021-10-11 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1802530 | 1802530 | 2021-10-10 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1799281 | 1799281 | 2021-10-09 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1796032 | 1796032 | 2021-10-08 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1792783 | 1792783 | 2021-10-07 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1789534 | 1789534 | 2021-10-06 | Choctaw | Oklahoma | 40023 | 2613 | 42 |
1786277 | 1786277 | 2021-10-05 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1783028 | 1783028 | 2021-10-04 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1778096 | 1778096 | 2021-10-03 | Jefferson | Georgia | 13163 | 2613 | 80 |
1779779 | 1779779 | 2021-10-03 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1774496 | 1774496 | 2021-10-02 | Clay | Arkansas | 5021 | 2613 | 58 |
1774846 | 1774846 | 2021-10-02 | Jefferson | Georgia | 13163 | 2613 | 80 |
1776529 | 1776529 | 2021-10-02 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1771596 | 1771596 | 2021-10-01 | Jefferson | Georgia | 13163 | 2613 | 80 |
1773279 | 1773279 | 2021-10-01 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1770029 | 1770029 | 2021-09-30 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1766780 | 1766780 | 2021-09-29 | Atoka | Oklahoma | 40005 | 2613 | 30 |
1763163 | 1763163 | 2021-09-28 | Coos | New Hampshire | 33007 | 2613 | 47 |
1758872 | 1758872 | 2021-09-27 | Jay | Indiana | 18075 | 2613 | 42 |
1743327 | 1743327 | 2021-09-22 | Holmes | Mississippi | 28051 | 2613 | 87 |
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);