ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3548 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 16
- Virginia 11
- Georgia 9
- Iowa 9
- Missouri 8
- Oklahoma 8
- Minnesota 7
- Alabama 6
- Idaho 6
- Texas 6
- Wisconsin 5
- Alaska 4
- Arkansas 4
- Illinois 4
- Indiana 4
- North Carolina 4
- Oregon 4
- Mississippi 3
- Ohio 3
- Pennsylvania 3
- Puerto Rico 3
- West Virginia 3
- Florida 2
- Kansas 2
- Kentucky 2
- Louisiana 2
- New Mexico 2
- New York 2
- South Carolina 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487210 | 2487210 | 2022-05-09 | Menard | Illinois | 17129 | 3548 | 24 |
2484648 | 2484648 | 2022-05-08 | Kanabec | Minnesota | 27065 | 3548 | 57 |
2481390 | 2481390 | 2022-05-07 | Kanabec | Minnesota | 27065 | 3548 | 57 |
2478132 | 2478132 | 2022-05-06 | Kanabec | Minnesota | 27065 | 3548 | 57 |
2461888 | 2461888 | 2022-05-01 | Sibley | Minnesota | 27143 | 3548 | 24 |
2458632 | 2458632 | 2022-04-30 | Sibley | Minnesota | 27143 | 3548 | 24 |
2455376 | 2455376 | 2022-04-29 | Sibley | Minnesota | 27143 | 3548 | 24 |
2453886 | 2453886 | 2022-04-28 | Buffalo | Wisconsin | 55011 | 3548 | 12 |
2387946 | 2387946 | 2022-04-08 | Aibonito | Puerto Rico | 72009 | 3548 | |
2371581 | 2371581 | 2022-04-03 | Hood River | Oregon | 41027 | 3548 | 42 |
2368328 | 2368328 | 2022-04-02 | Hood River | Oregon | 41027 | 3548 | 42 |
2365075 | 2365075 | 2022-04-01 | Hood River | Oregon | 41027 | 3548 | 42 |
2304043 | 2304043 | 2022-03-13 | Patrick | Virginia | 51141 | 3548 | 89 |
2300791 | 2300791 | 2022-03-12 | Patrick | Virginia | 51141 | 3548 | 89 |
2297539 | 2297539 | 2022-03-11 | Patrick | Virginia | 51141 | 3548 | 89 |
2284775 | 2284775 | 2022-03-08 | Cleburne | Alabama | 1029 | 3548 | 68 |
2257053 | 2257053 | 2022-02-27 | Madison | Missouri | 29123 | 3548 | 49 |
2253802 | 2253802 | 2022-02-26 | Madison | Missouri | 29123 | 3548 | 49 |
2250551 | 2250551 | 2022-02-25 | Madison | Missouri | 29123 | 3548 | 49 |
2236567 | 2236567 | 2022-02-21 | Gem | Idaho | 16045 | 3548 | 77 |
2233316 | 2233316 | 2022-02-20 | Gem | Idaho | 16045 | 3548 | 77 |
2230065 | 2230065 | 2022-02-19 | Gem | Idaho | 16045 | 3548 | 77 |
2224167 | 2224167 | 2022-02-17 | West Carroll | Louisiana | 22123 | 3548 | 57 |
2193787 | 2193787 | 2022-02-08 | Ketchikan Gateway Borough | Alaska | 2130 | 3548 | 15 |
2190534 | 2190534 | 2022-02-07 | Ketchikan Gateway Borough | Alaska | 2130 | 3548 | 15 |
2178796 | 2178796 | 2022-02-03 | Faribault | Minnesota | 27043 | 3548 | 46 |
2148977 | 2148977 | 2022-01-25 | Cedar | Iowa | 19031 | 3548 | 28 |
2145725 | 2145725 | 2022-01-24 | Cedar | Iowa | 19031 | 3548 | 28 |
2142470 | 2142470 | 2022-01-23 | Cedar | Iowa | 19031 | 3548 | 28 |
2139215 | 2139215 | 2022-01-22 | Cedar | Iowa | 19031 | 3548 | 28 |
2135959 | 2135959 | 2022-01-21 | Cedar | Iowa | 19031 | 3548 | 28 |
2132707 | 2132707 | 2022-01-20 | Cedar | Iowa | 19031 | 3548 | 28 |
2129454 | 2129454 | 2022-01-19 | Cedar | Iowa | 19031 | 3548 | 28 |
2079910 | 2079910 | 2022-01-04 | Marengo | Alabama | 1091 | 3548 | 93 |
2056356 | 2056356 | 2021-12-27 | Hughes | South Dakota | 46065 | 3548 | 53 |
2031876 | 2031876 | 2021-12-20 | Orange | Indiana | 18117 | 3548 | 80 |
2010974 | 2010974 | 2021-12-13 | Union | Tennessee | 47173 | 3548 | 52 |
1998776 | 1998776 | 2021-12-10 | Randolph | Arkansas | 5121 | 3548 | 65 |
1985037 | 1985037 | 2021-12-05 | Deaf Smith | Texas | 48117 | 3548 | 87 |
1972994 | 1972994 | 2021-12-02 | Appling | Georgia | 13001 | 3548 | 107 |
1916635 | 1916635 | 2021-11-14 | Chester | Tennessee | 47023 | 3548 | 76 |
1913385 | 1913385 | 2021-11-13 | Chester | Tennessee | 47023 | 3548 | 76 |
1910135 | 1910135 | 2021-11-12 | Chester | Tennessee | 47023 | 3548 | 76 |
1904833 | 1904833 | 2021-11-11 | McDuffie | Georgia | 13189 | 3548 | 76 |
1901583 | 1901583 | 2021-11-10 | McDuffie | Georgia | 13189 | 3548 | 76 |
1897635 | 1897635 | 2021-11-08 | Salem city | Virginia | 51775 | 3548 | 63 |
1863220 | 1863220 | 2021-10-29 | Wayne | Kentucky | 21231 | 3548 | 60 |
1859971 | 1859971 | 2021-10-28 | Wayne | Kentucky | 21231 | 3548 | 60 |
1832734 | 1832734 | 2021-10-19 | Mason | West Virginia | 54053 | 3548 | 51 |
1812213 | 1812213 | 2021-10-13 | Henry | Ohio | 39069 | 3548 | 69 |
1806870 | 1806870 | 2021-10-12 | Barbour | Alabama | 1005 | 3548 | 74 |
1803769 | 1803769 | 2021-10-11 | Logan | Arkansas | 5083 | 3548 | 40 |
1758592 | 1758592 | 2021-09-27 | Harris | Georgia | 13145 | 3548 | 75 |
1747128 | 1747128 | 2021-09-23 | Transylvania | North Carolina | 37175 | 3548 | 38 |
1736889 | 1736889 | 2021-09-20 | Audrain | Missouri | 29007 | 3548 | 61 |
1718215 | 1718215 | 2021-09-14 | Tioga | Pennsylvania | 42117 | 3548 | 115 |
1689592 | 1689592 | 2021-09-05 | Amherst | Virginia | 51009 | 3548 | 43 |
1686342 | 1686342 | 2021-09-04 | Amherst | Virginia | 51009 | 3548 | 43 |
1683091 | 1683091 | 2021-09-03 | Amherst | Virginia | 51009 | 3548 | 43 |
1675762 | 1675762 | 2021-09-01 | Jackson | Ohio | 39079 | 3548 | 55 |
1670564 | 1670564 | 2021-08-31 | Lincoln | Arkansas | 5079 | 3548 | 55 |
1672711 | 1672711 | 2021-08-31 | Jefferson | Pennsylvania | 42065 | 3548 | 100 |
1664363 | 1664363 | 2021-08-29 | Emanuel | Georgia | 13107 | 3548 | 86 |
1661115 | 1661115 | 2021-08-28 | Emanuel | Georgia | 13107 | 3548 | 86 |
1657867 | 1657867 | 2021-08-27 | Emanuel | Georgia | 13107 | 3548 | 86 |
1653916 | 1653916 | 2021-08-25 | Isle of Wight | Virginia | 51093 | 3548 | 71 |
1596270 | 1596270 | 2021-08-08 | Bonner | Idaho | 16017 | 3548 | 46 |
1593021 | 1593021 | 2021-08-07 | Bonner | Idaho | 16017 | 3548 | 46 |
1589772 | 1589772 | 2021-08-06 | Bonner | Idaho | 16017 | 3548 | 46 |
1584938 | 1584938 | 2021-08-04 | Benton | Oregon | 41003 | 3548 | 22 |
1580230 | 1580230 | 2021-08-03 | Ripley | Indiana | 18137 | 3548 | 72 |
1581010 | 1581010 | 2021-08-03 | Lafayette | Missouri | 29107 | 3548 | 58 |
1559151 | 1559151 | 2021-07-27 | Clarendon | South Carolina | 45027 | 3548 | 114 |
1539386 | 1539386 | 2021-07-21 | Williams | Ohio | 39171 | 3548 | 78 |
1534519 | 1534519 | 2021-07-20 | Toombs | Georgia | 13279 | 3548 | 119 |
1536211 | 1536211 | 2021-07-20 | Texas | Oklahoma | 40139 | 3548 | 34 |
1537114 | 1537114 | 2021-07-20 | Marshall | West Virginia | 54051 | 3548 | 79 |
1532963 | 1532963 | 2021-07-19 | Texas | Oklahoma | 40139 | 3548 | 34 |
1533866 | 1533866 | 2021-07-19 | Marshall | West Virginia | 54051 | 3548 | 79 |
1529716 | 1529716 | 2021-07-18 | Texas | Oklahoma | 40139 | 3548 | 34 |
1526469 | 1526469 | 2021-07-17 | Texas | Oklahoma | 40139 | 3548 | 34 |
1523222 | 1523222 | 2021-07-16 | Texas | Oklahoma | 40139 | 3548 | 34 |
1518458 | 1518458 | 2021-07-15 | Adams | Indiana | 18001 | 3548 | 57 |
1519974 | 1519974 | 2021-07-15 | Texas | Oklahoma | 40139 | 3548 | 34 |
1516726 | 1516726 | 2021-07-14 | Texas | Oklahoma | 40139 | 3548 | 34 |
1497079 | 1497079 | 2021-07-08 | Stutsman | North Dakota | 38093 | 3548 | 81 |
1494635 | 1494635 | 2021-07-07 | Upshur | Texas | 48459 | 3548 | 77 |
1441667 | 1441667 | 2021-06-21 | Cibola | New Mexico | 35006 | 3548 | 125 |
1432448 | 1432448 | 2021-06-18 | Arecibo | Puerto Rico | 72013 | 3548 | |
1418711 | 1418711 | 2021-06-14 | Pulaski | Missouri | 29169 | 3548 | 55 |
1406708 | 1406708 | 2021-06-10 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1399198 | 1399198 | 2021-06-08 | Howell | Missouri | 29091 | 3548 | 45 |
1393725 | 1393725 | 2021-06-06 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1390480 | 1390480 | 2021-06-05 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1387235 | 1387235 | 2021-06-04 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1383990 | 1383990 | 2021-06-03 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1374253 | 1374253 | 2021-05-31 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1371008 | 1371008 | 2021-05-30 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1367762 | 1367762 | 2021-05-29 | Hardeman | Tennessee | 47069 | 3548 | 65 |
1364516 | 1364516 | 2021-05-28 | Hardeman | Tennessee | 47069 | 3548 | 65 |
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);