ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 3231 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Arkansas 12
- Tennessee 10
- Alabama 9
- Georgia 9
- Louisiana 9
- Kansas 8
- Wisconsin 8
- Illinois 7
- Missouri 7
- Ohio 7
- Kentucky 5
- New York 5
- Pennsylvania 5
- Puerto Rico 5
- Texas 5
- Minnesota 4
- North Carolina 4
- Virginia 4
- Michigan 3
- Nebraska 3
- South Carolina 3
- California 2
- Colorado 2
- Idaho 2
- Maryland 2
- Nevada 2
- Oregon 2
- West Virginia 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501811 | 2501811 | 2022-05-13 | Baker | Oregon | 41001 | 3231 | 48 |
2467808 | 2467808 | 2022-05-03 | Butler | Iowa | 19023 | 3231 | 53 |
2464553 | 2464553 | 2022-05-02 | Butler | Iowa | 19023 | 3231 | 53 |
2461297 | 2461297 | 2022-05-01 | Butler | Iowa | 19023 | 3231 | 53 |
2458041 | 2458041 | 2022-04-30 | Butler | Iowa | 19023 | 3231 | 53 |
2454785 | 2454785 | 2022-04-29 | Butler | Iowa | 19023 | 3231 | 53 |
2451529 | 2451529 | 2022-04-28 | Butler | Iowa | 19023 | 3231 | 53 |
2448273 | 2448273 | 2022-04-27 | Butler | Iowa | 19023 | 3231 | 53 |
2278408 | 2278408 | 2022-03-06 | Little River | Arkansas | 5081 | 3231 | 88 |
2275155 | 2275155 | 2022-03-05 | Little River | Arkansas | 5081 | 3231 | 88 |
2265151 | 2265151 | 2022-03-01 | Ashland | Wisconsin | 55003 | 3231 | 35 |
2261901 | 2261901 | 2022-02-28 | Ashland | Wisconsin | 55003 | 3231 | 35 |
2258699 | 2258699 | 2022-02-27 | Price | Wisconsin | 55099 | 3231 | 30 |
2255448 | 2255448 | 2022-02-26 | Price | Wisconsin | 55099 | 3231 | 30 |
2252197 | 2252197 | 2022-02-25 | Price | Wisconsin | 55099 | 3231 | 30 |
2241359 | 2241359 | 2022-02-22 | Morgan | Ohio | 39115 | 3231 | 54 |
2157009 | 2157009 | 2022-01-27 | Anasco | Puerto Rico | 72011 | 3231 | |
2151101 | 2151101 | 2022-01-25 | Appomattox | Virginia | 51011 | 3231 | 41 |
2109272 | 2109272 | 2022-01-13 | Izard | Arkansas | 5065 | 3231 | 58 |
2088735 | 2088735 | 2022-01-06 | Hatillo | Puerto Rico | 72065 | 3231 | |
2049477 | 2049477 | 2021-12-25 | Meigs | Ohio | 39105 | 3231 | 67 |
2046227 | 2046227 | 2021-12-24 | Meigs | Ohio | 39105 | 3231 | 67 |
2019417 | 2019417 | 2021-12-16 | Ogemaw | Michigan | 26129 | 3231 | 79 |
2019881 | 2019881 | 2021-12-16 | Humboldt | Nevada | 32013 | 3231 | 39 |
2016167 | 2016167 | 2021-12-15 | Ogemaw | Michigan | 26129 | 3231 | 79 |
1998638 | 1998638 | 2021-12-10 | Henry | Alabama | 1067 | 3231 | 66 |
1992667 | 1992667 | 2021-12-08 | Blaine | Idaho | 16013 | 3231 | 27 |
1988370 | 1988370 | 2021-12-06 | Lavaca | Texas | 48285 | 3231 | 100 |
1985120 | 1985120 | 2021-12-05 | Lavaca | Texas | 48285 | 3231 | 100 |
1981870 | 1981870 | 2021-12-04 | Lavaca | Texas | 48285 | 3231 | 100 |
1969465 | 1969465 | 2021-12-01 | Ashley | Arkansas | 5003 | 3231 | 50 |
1971684 | 1971684 | 2021-12-01 | Wyoming | Pennsylvania | 42131 | 3231 | 69 |
1946760 | 1946760 | 2021-11-24 | Phillips | Arkansas | 5107 | 3231 | 77 |
1943509 | 1943509 | 2021-11-23 | Phillips | Arkansas | 5107 | 3231 | 77 |
1944037 | 1944037 | 2021-11-23 | Union | Illinois | 17181 | 3231 | 54 |
1939443 | 1939443 | 2021-11-21 | Polk | Tennessee | 47139 | 3231 | 31 |
1936193 | 1936193 | 2021-11-20 | Polk | Tennessee | 47139 | 3231 | 31 |
1932943 | 1932943 | 2021-11-19 | Polk | Tennessee | 47139 | 3231 | 31 |
1917638 | 1917638 | 2021-11-15 | Pitkin | Colorado | 8097 | 3231 | 6 |
1918960 | 1918960 | 2021-11-15 | Big Horn | Montana | 30003 | 3231 | 82 |
1904887 | 1904887 | 2021-11-11 | Washington | Georgia | 13303 | 3231 | 121 |
1906267 | 1906267 | 2021-11-11 | Caswell | North Carolina | 37033 | 3231 | 37 |
1901637 | 1901637 | 2021-11-10 | Washington | Georgia | 13303 | 3231 | 121 |
1903018 | 1903018 | 2021-11-10 | Caswell | North Carolina | 37033 | 3231 | 37 |
1892482 | 1892482 | 2021-11-07 | Concordia | Louisiana | 22029 | 3231 | 79 |
1889232 | 1889232 | 2021-11-06 | Concordia | Louisiana | 22029 | 3231 | 79 |
1885982 | 1885982 | 2021-11-05 | Concordia | Louisiana | 22029 | 3231 | 79 |
1882733 | 1882733 | 2021-11-04 | Concordia | Louisiana | 22029 | 3231 | 79 |
1872357 | 1872357 | 2021-11-01 | Putnam | Georgia | 13237 | 3231 | 81 |
1869810 | 1869810 | 2021-10-31 | Caroline | Maryland | 24011 | 3231 | 51 |
1858176 | 1858176 | 2021-10-27 | Humphreys | Tennessee | 47085 | 3231 | 47 |
1853214 | 1853214 | 2021-10-26 | Mahaska | Iowa | 19123 | 3231 | 56 |
1849965 | 1849965 | 2021-10-25 | Mahaska | Iowa | 19123 | 3231 | 56 |
1846299 | 1846299 | 2021-10-24 | Elbert | Georgia | 13105 | 3231 | 85 |
1846715 | 1846715 | 2021-10-24 | Mahaska | Iowa | 19123 | 3231 | 56 |
1843049 | 1843049 | 2021-10-23 | Elbert | Georgia | 13105 | 3231 | 85 |
1843465 | 1843465 | 2021-10-23 | Mahaska | Iowa | 19123 | 3231 | 56 |
1839799 | 1839799 | 2021-10-22 | Elbert | Georgia | 13105 | 3231 | 85 |
1840215 | 1840215 | 2021-10-22 | Mahaska | Iowa | 19123 | 3231 | 56 |
1836966 | 1836966 | 2021-10-21 | Mahaska | Iowa | 19123 | 3231 | 56 |
1833717 | 1833717 | 2021-10-20 | Mahaska | Iowa | 19123 | 3231 | 56 |
1827900 | 1827900 | 2021-10-18 | Henry | Missouri | 29083 | 3231 | 49 |
1809304 | 1809304 | 2021-10-12 | Fairfield | South Carolina | 45039 | 3231 | 94 |
1803548 | 1803548 | 2021-10-10 | Jackson | Wisconsin | 55053 | 3231 | 31 |
1800299 | 1800299 | 2021-10-09 | Jackson | Wisconsin | 55053 | 3231 | 31 |
1796262 | 1796262 | 2021-10-08 | Rio Grande | Puerto Rico | 72119 | 3231 | |
1797050 | 1797050 | 2021-10-08 | Jackson | Wisconsin | 55053 | 3231 | 31 |
1793013 | 1793013 | 2021-10-07 | Rio Grande | Puerto Rico | 72119 | 3231 | |
1785126 | 1785126 | 2021-10-05 | Adair | Kentucky | 21001 | 3231 | 74 |
1756564 | 1756564 | 2021-09-26 | Cass | Nebraska | 31025 | 3231 | 18 |
1753316 | 1753316 | 2021-09-25 | Cass | Nebraska | 31025 | 3231 | 18 |
1750068 | 1750068 | 2021-09-24 | Cass | Nebraska | 31025 | 3231 | 18 |
1745778 | 1745778 | 2021-09-23 | Jersey | Illinois | 17083 | 3231 | 72 |
1741931 | 1741931 | 2021-09-22 | Marengo | Alabama | 1091 | 3231 | 83 |
1742937 | 1742937 | 2021-09-22 | Hart | Kentucky | 21099 | 3231 | 58 |
1735863 | 1735863 | 2021-09-20 | Lamar | Georgia | 13171 | 3231 | 76 |
1709590 | 1709590 | 2021-09-12 | Calaveras | California | 6009 | 3231 | 65 |
1701731 | 1701731 | 2021-09-09 | Coshocton | Ohio | 39031 | 3231 | 63 |
1674704 | 1674704 | 2021-09-01 | Grant | Kentucky | 21081 | 3231 | 27 |
1656497 | 1656497 | 2021-08-26 | Tioga | Pennsylvania | 42117 | 3231 | 113 |
1652537 | 1652537 | 2021-08-25 | Washington | Missouri | 29221 | 3231 | 54 |
1648625 | 1648625 | 2021-08-24 | Labette | Kansas | 20099 | 3231 | 54 |
1645377 | 1645377 | 2021-08-23 | Labette | Kansas | 20099 | 3231 | 54 |
1629787 | 1629787 | 2021-08-18 | Stoddard | Missouri | 29207 | 3231 | 54 |
1607041 | 1607041 | 2021-08-11 | Saline | Missouri | 29195 | 3231 | 40 |
1600720 | 1600720 | 2021-08-09 | Douglas | Nevada | 32005 | 3231 | 37 |
1563335 | 1563335 | 2021-07-29 | Carroll | Arkansas | 5015 | 3231 | 51 |
1566365 | 1566365 | 2021-07-29 | Wayne | West Virginia | 54099 | 3231 | 44 |
1559181 | 1559181 | 2021-07-27 | Union | South Carolina | 45087 | 3231 | 82 |
1548511 | 1548511 | 2021-07-24 | Dunklin | Missouri | 29069 | 3231 | 50 |
1540541 | 1540541 | 2021-07-22 | Pike | Alabama | 1109 | 3231 | 79 |
1543090 | 1543090 | 2021-07-22 | Scott | Tennessee | 47151 | 3231 | 48 |
1539842 | 1539842 | 2021-07-21 | Scott | Tennessee | 47151 | 3231 | 48 |
1534629 | 1534629 | 2021-07-20 | Iroquois | Illinois | 17075 | 3231 | 70 |
1505394 | 1505394 | 2021-07-11 | Fayette | Illinois | 17051 | 3231 | 59 |
1502148 | 1502148 | 2021-07-10 | Fayette | Illinois | 17051 | 3231 | 59 |
1498902 | 1498902 | 2021-07-09 | Fayette | Illinois | 17051 | 3231 | 59 |
1474842 | 1474842 | 2021-07-01 | Claiborne | Tennessee | 47025 | 3231 | 74 |
1445678 | 1445678 | 2021-06-22 | Marion | Tennessee | 47115 | 3231 | 49 |
1431719 | 1431719 | 2021-06-18 | Warren | Missouri | 29219 | 3231 | 33 |
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);