ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where cases = 2594 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 27
- Kentucky 16
- Georgia 12
- Arkansas 11
- Illinois 11
- Indiana 11
- Iowa 9
- Mississippi 9
- Oklahoma 9
- Virginia 9
- Alabama 8
- Montana 8
- North Carolina 7
- Wisconsin 7
- Minnesota 6
- Colorado 5
- Michigan 5
- California 4
- Puerto Rico 4
- Missouri 3
- Nebraska 3
- New York 3
- Ohio 3
- South Carolina 3
- Tennessee 3
- Utah 3
- West Virginia 3
- Florida 2
- North Dakota 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499634 | 2499634 | 2022-05-13 | Sumter | Alabama | 1119 | 2594 | 51 |
2500610 | 2500610 | 2022-05-13 | Elliott | Kentucky | 21063 | 2594 | 19 |
2497352 | 2497352 | 2022-05-12 | Elliott | Kentucky | 21063 | 2594 | 19 |
2494094 | 2494094 | 2022-05-11 | Elliott | Kentucky | 21063 | 2594 | 19 |
2490836 | 2490836 | 2022-05-10 | Elliott | Kentucky | 21063 | 2594 | 19 |
2487579 | 2487579 | 2022-05-09 | Elliott | Kentucky | 21063 | 2594 | 19 |
2462127 | 2462127 | 2022-05-01 | Jefferson | Montana | 30043 | 2594 | 23 |
2458871 | 2458871 | 2022-04-30 | Jefferson | Montana | 30043 | 2594 | 23 |
2455615 | 2455615 | 2022-04-29 | Jefferson | Montana | 30043 | 2594 | 23 |
2443318 | 2443318 | 2022-04-25 | Florida | Puerto Rico | 72054 | 2594 | |
2426311 | 2426311 | 2022-04-20 | Jefferson | Montana | 30043 | 2594 | 23 |
2362533 | 2362533 | 2022-03-31 | Clarke | Virginia | 51043 | 2594 | 41 |
2359279 | 2359279 | 2022-03-30 | Clarke | Virginia | 51043 | 2594 | 41 |
2356025 | 2356025 | 2022-03-29 | Clarke | Virginia | 51043 | 2594 | 41 |
2323956 | 2323956 | 2022-03-20 | Pike | Arkansas | 5109 | 2594 | 42 |
2320702 | 2320702 | 2022-03-19 | Pike | Arkansas | 5109 | 2594 | 42 |
2317448 | 2317448 | 2022-03-18 | Pike | Arkansas | 5109 | 2594 | 42 |
2237914 | 2237914 | 2022-02-21 | Clay | North Carolina | 37043 | 2594 | 38 |
2229527 | 2229527 | 2022-02-19 | Lowndes | Alabama | 1085 | 2594 | 70 |
2193270 | 2193270 | 2022-02-07 | Pecos | Texas | 48371 | 2594 | 65 |
2187339 | 2187339 | 2022-02-06 | Fulton | Arkansas | 5049 | 2594 | 82 |
2163213 | 2163213 | 2022-01-29 | McLean | North Dakota | 38055 | 2594 | 48 |
2153773 | 2153773 | 2022-01-26 | Comerio | Puerto Rico | 72045 | 2594 | |
2141675 | 2141675 | 2022-01-23 | Conecuh | Alabama | 1035 | 2594 | 63 |
2134858 | 2134858 | 2022-01-20 | Dickenson | Virginia | 51051 | 2594 | 40 |
2119096 | 2119096 | 2022-01-16 | Mono | California | 6051 | 2594 | 4 |
2115844 | 2115844 | 2022-01-15 | Mono | California | 6051 | 2594 | 4 |
2112593 | 2112593 | 2022-01-14 | Mono | California | 6051 | 2594 | 4 |
2080710 | 2080710 | 2022-01-04 | Iowa | Iowa | 19095 | 2594 | 36 |
2077458 | 2077458 | 2022-01-03 | Iowa | Iowa | 19095 | 2594 | 36 |
2074207 | 2074207 | 2022-01-02 | Iowa | Iowa | 19095 | 2594 | 36 |
2070956 | 2070956 | 2022-01-01 | Iowa | Iowa | 19095 | 2594 | 36 |
2067705 | 2067705 | 2021-12-31 | Iowa | Iowa | 19095 | 2594 | 36 |
2064454 | 2064454 | 2021-12-30 | Iowa | Iowa | 19095 | 2594 | 36 |
2061204 | 2061204 | 2021-12-29 | Iowa | Iowa | 19095 | 2594 | 36 |
2050626 | 2050626 | 2021-12-26 | Cleburne | Alabama | 1029 | 2594 | 60 |
2033693 | 2033693 | 2021-12-20 | Lewis | Tennessee | 47101 | 2594 | 44 |
2013641 | 2013641 | 2021-12-14 | McKenzie | North Dakota | 38053 | 2594 | 23 |
2005726 | 2005726 | 2021-12-12 | De Witt | Illinois | 17039 | 2594 | 38 |
2006224 | 2006224 | 2021-12-12 | Webster | Kentucky | 21233 | 2594 | 42 |
2002475 | 2002475 | 2021-12-11 | De Witt | Illinois | 17039 | 2594 | 38 |
2002973 | 2002973 | 2021-12-11 | Webster | Kentucky | 21233 | 2594 | 42 |
2004225 | 2004225 | 2021-12-11 | Isabela | Puerto Rico | 72071 | 2594 | |
1999225 | 1999225 | 2021-12-10 | De Witt | Illinois | 17039 | 2594 | 38 |
1999723 | 1999723 | 2021-12-10 | Webster | Kentucky | 21233 | 2594 | 42 |
2000974 | 2000974 | 2021-12-10 | Isabela | Puerto Rico | 72071 | 2594 | |
1985802 | 1985802 | 2021-12-06 | Inyo | California | 6027 | 2594 | 46 |
1973951 | 1973951 | 2021-12-02 | Faribault | Minnesota | 27043 | 2594 | 35 |
1952305 | 1952305 | 2021-11-25 | Saluda | South Carolina | 45081 | 2594 | 56 |
1949054 | 1949054 | 2021-11-24 | Saluda | South Carolina | 45081 | 2594 | 56 |
1943499 | 1943499 | 2021-11-23 | Madison | Arkansas | 5087 | 2594 | 40 |
1919048 | 1919048 | 2021-11-15 | Gage | Nebraska | 31067 | 2594 | 28 |
1912402 | 1912402 | 2021-11-13 | Livingston | Missouri | 29117 | 2594 | 63 |
1891855 | 1891855 | 2021-11-07 | Rabun | Georgia | 13241 | 2594 | 66 |
1892446 | 1892446 | 2021-11-07 | Powell | Kentucky | 21197 | 2594 | 23 |
1888605 | 1888605 | 2021-11-06 | Rabun | Georgia | 13241 | 2594 | 66 |
1889196 | 1889196 | 2021-11-06 | Powell | Kentucky | 21197 | 2594 | 23 |
1885355 | 1885355 | 2021-11-05 | Rabun | Georgia | 13241 | 2594 | 66 |
1885946 | 1885946 | 2021-11-05 | Powell | Kentucky | 21197 | 2594 | 23 |
1879756 | 1879756 | 2021-11-03 | Wadena | Minnesota | 27159 | 2594 | 31 |
1877286 | 1877286 | 2021-11-02 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1874037 | 1874037 | 2021-11-01 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1870788 | 1870788 | 2021-10-31 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1867539 | 1867539 | 2021-10-30 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1863670 | 1863670 | 2021-10-29 | Moniteau | Missouri | 29135 | 2594 | 39 |
1864290 | 1864290 | 2021-10-29 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1864731 | 1864731 | 2021-10-29 | Aransas | Texas | 48007 | 2594 | 66 |
1861041 | 1861041 | 2021-10-28 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1861482 | 1861482 | 2021-10-28 | Aransas | Texas | 48007 | 2594 | 66 |
1857792 | 1857792 | 2021-10-27 | Kingfisher | Oklahoma | 40073 | 2594 | 54 |
1833149 | 1833149 | 2021-10-20 | Otero | Colorado | 8089 | 2594 | 80 |
1819311 | 1819311 | 2021-10-15 | Falls | Texas | 48145 | 2594 | 43 |
1801096 | 1801096 | 2021-10-10 | Franklin | Indiana | 18047 | 2594 | 44 |
1797847 | 1797847 | 2021-10-09 | Franklin | Indiana | 18047 | 2594 | 44 |
1794598 | 1794598 | 2021-10-08 | Franklin | Indiana | 18047 | 2594 | 44 |
1788852 | 1788852 | 2021-10-06 | Smith | Mississippi | 28129 | 2594 | 49 |
1778903 | 1778903 | 2021-10-03 | Iosco | Michigan | 26069 | 2594 | 86 |
1775653 | 1775653 | 2021-10-02 | Iosco | Michigan | 26069 | 2594 | 86 |
1772403 | 1772403 | 2021-10-01 | Iosco | Michigan | 26069 | 2594 | 86 |
1768552 | 1768552 | 2021-09-30 | Pike | Illinois | 17149 | 2594 | 59 |
1769283 | 1769283 | 2021-09-30 | Wabasha | Minnesota | 27157 | 2594 | 5 |
1759889 | 1759889 | 2021-09-27 | Washington | Nebraska | 31177 | 2594 | 29 |
1746244 | 1746244 | 2021-09-23 | Spencer | Kentucky | 21215 | 2594 | 28 |
1744925 | 1744925 | 2021-09-22 | Scott | Virginia | 51169 | 2594 | 68 |
1738264 | 1738264 | 2021-09-20 | Young | Texas | 48503 | 2594 | 54 |
1733579 | 1733579 | 2021-09-19 | Holmes | Mississippi | 28051 | 2594 | 85 |
1735014 | 1735014 | 2021-09-19 | Young | Texas | 48503 | 2594 | 54 |
1730329 | 1730329 | 2021-09-18 | Holmes | Mississippi | 28051 | 2594 | 85 |
1731764 | 1731764 | 2021-09-18 | Young | Texas | 48503 | 2594 | 54 |
1727079 | 1727079 | 2021-09-17 | Holmes | Mississippi | 28051 | 2594 | 85 |
1718629 | 1718629 | 2021-09-14 | Houston | Texas | 48225 | 2594 | 64 |
1702461 | 1702461 | 2021-09-09 | Panola | Texas | 48365 | 2594 | 90 |
1697717 | 1697717 | 2021-09-08 | Otsego | Michigan | 26137 | 2594 | 43 |
1677076 | 1677076 | 2021-09-02 | Polk | Arkansas | 5113 | 2594 | 89 |
1673097 | 1673097 | 2021-08-31 | DeWitt | Texas | 48123 | 2594 | 65 |
1669849 | 1669849 | 2021-08-30 | DeWitt | Texas | 48123 | 2594 | 65 |
1666602 | 1666602 | 2021-08-29 | DeWitt | Texas | 48123 | 2594 | 65 |
1663354 | 1663354 | 2021-08-28 | DeWitt | Texas | 48123 | 2594 | 65 |
1654340 | 1654340 | 2021-08-26 | Phillips | Arkansas | 5107 | 2594 | 54 |
1648406 | 1648406 | 2021-08-24 | Fountain | Indiana | 18045 | 2594 | 54 |
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);