ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where cases = 2449 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 29
- Texas 24
- Michigan 12
- Virginia 11
- Kentucky 10
- Missouri 10
- Georgia 8
- Montana 8
- Alabama 7
- Puerto Rico 7
- Indiana 6
- Minnesota 6
- Mississippi 6
- Ohio 6
- Arkansas 5
- Kansas 5
- Tennessee 5
- North Carolina 4
- Utah 4
- Washington 4
- West Virginia 4
- Arizona 3
- California 3
- Idaho 3
- Louisiana 3
- North Dakota 3
- Pennsylvania 3
- Wisconsin 3
- Alaska 2
- Illinois 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475858 | 2475858 | 2022-05-05 | Arroyo | Puerto Rico | 72015 | 2449 | |
2472624 | 2472624 | 2022-05-04 | Guayanilla | Puerto Rico | 72059 | 2449 | |
2309111 | 2309111 | 2022-03-15 | Ralls | Missouri | 29173 | 2449 | 25 |
2296897 | 2296897 | 2022-03-11 | Luquillo | Puerto Rico | 72089 | 2449 | |
2293645 | 2293645 | 2022-03-10 | Luquillo | Puerto Rico | 72089 | 2449 | |
2285280 | 2285280 | 2022-03-08 | Stewart | Georgia | 13259 | 2449 | 32 |
2257119 | 2257119 | 2022-02-27 | Deer Lodge | Montana | 30023 | 2449 | 29 |
2253868 | 2253868 | 2022-02-26 | Deer Lodge | Montana | 30023 | 2449 | 29 |
2250617 | 2250617 | 2022-02-25 | Deer Lodge | Montana | 30023 | 2449 | 29 |
2240092 | 2240092 | 2022-02-22 | Louisa | Iowa | 19115 | 2449 | 60 |
2236841 | 2236841 | 2022-02-21 | Louisa | Iowa | 19115 | 2449 | 60 |
2233590 | 2233590 | 2022-02-20 | Louisa | Iowa | 19115 | 2449 | 60 |
2230339 | 2230339 | 2022-02-19 | Louisa | Iowa | 19115 | 2449 | 60 |
2232235 | 2232235 | 2022-02-19 | Jim Hogg | Texas | 48247 | 2449 | 21 |
2227088 | 2227088 | 2022-02-18 | Louisa | Iowa | 19115 | 2449 | 60 |
2223837 | 2223837 | 2022-02-17 | Louisa | Iowa | 19115 | 2449 | 60 |
2220586 | 2220586 | 2022-02-16 | Louisa | Iowa | 19115 | 2449 | 60 |
2218882 | 2218882 | 2022-02-15 | Santa Isabel | Puerto Rico | 72133 | 2449 | |
2212867 | 2212867 | 2022-02-13 | Emery | Utah | 49015 | 2449 | 25 |
2209614 | 2209614 | 2022-02-12 | Emery | Utah | 49015 | 2449 | 25 |
2206361 | 2206361 | 2022-02-11 | Emery | Utah | 49015 | 2449 | 25 |
2203108 | 2203108 | 2022-02-10 | Emery | Utah | 49015 | 2449 | 25 |
2188860 | 2188860 | 2022-02-06 | Richland | Montana | 30083 | 2449 | 30 |
2185607 | 2185607 | 2022-02-05 | Richland | Montana | 30083 | 2449 | 30 |
2182355 | 2182355 | 2022-02-04 | Richland | Montana | 30083 | 2449 | 30 |
2148300 | 2148300 | 2022-01-25 | Fulton | Arkansas | 5049 | 2449 | 80 |
2141876 | 2141876 | 2022-01-23 | Plumas | California | 6063 | 2449 | 12 |
2138621 | 2138621 | 2022-01-22 | Plumas | California | 6063 | 2449 | 12 |
2135365 | 2135365 | 2022-01-21 | Plumas | California | 6063 | 2449 | 12 |
2137181 | 2137181 | 2022-01-21 | McLean | North Dakota | 38055 | 2449 | 48 |
2123475 | 2123475 | 2022-01-17 | Chippewa | Minnesota | 27023 | 2449 | 43 |
2120223 | 2120223 | 2022-01-16 | Chippewa | Minnesota | 27023 | 2449 | 43 |
2116971 | 2116971 | 2022-01-15 | Chippewa | Minnesota | 27023 | 2449 | 43 |
2113720 | 2113720 | 2022-01-14 | Chippewa | Minnesota | 27023 | 2449 | 43 |
2102704 | 2102704 | 2022-01-11 | Ketchikan Gateway Borough | Alaska | 2130 | 2449 | 13 |
2103041 | 2103041 | 2022-01-11 | Charlton | Georgia | 13049 | 2449 | 58 |
2099453 | 2099453 | 2022-01-10 | Ketchikan Gateway Borough | Alaska | 2130 | 2449 | 13 |
2097374 | 2097374 | 2022-01-09 | Arenac | Michigan | 26011 | 2449 | 55 |
2094122 | 2094122 | 2022-01-08 | Arenac | Michigan | 26011 | 2449 | 55 |
2090870 | 2090870 | 2022-01-07 | Arenac | Michigan | 26011 | 2449 | 55 |
2081489 | 2081489 | 2022-01-04 | Custer | Montana | 30017 | 2449 | 41 |
2051895 | 2051895 | 2021-12-26 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2048645 | 2048645 | 2021-12-25 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2045395 | 2045395 | 2021-12-24 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2042145 | 2042145 | 2021-12-23 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2038896 | 2038896 | 2021-12-22 | Kalkaska | Michigan | 26079 | 2449 | 46 |
2040544 | 2040544 | 2021-12-22 | Alleghany | Virginia | 51005 | 2449 | 86 |
2028828 | 2028828 | 2021-12-19 | Osage | Kansas | 20139 | 2449 | 39 |
2025577 | 2025577 | 2021-12-18 | Osage | Kansas | 20139 | 2449 | 39 |
2022326 | 2022326 | 2021-12-17 | Osage | Kansas | 20139 | 2449 | 39 |
2002010 | 2002010 | 2021-12-11 | Marion | Arkansas | 5089 | 2449 | 66 |
1983848 | 1983848 | 2021-12-05 | Yalobusha | Mississippi | 28161 | 2449 | 47 |
1980598 | 1980598 | 2021-12-04 | Yalobusha | Mississippi | 28161 | 2449 | 47 |
1977348 | 1977348 | 2021-12-03 | Yalobusha | Mississippi | 28161 | 2449 | 47 |
1964483 | 1964483 | 2021-11-29 | Glacier | Montana | 30035 | 2449 | 62 |
1965250 | 1965250 | 2021-11-29 | San Lorenzo | Puerto Rico | 72129 | 2449 | |
1944461 | 1944461 | 2021-11-23 | Washington | Kentucky | 21229 | 2449 | 48 |
1941112 | 1941112 | 2021-11-22 | Butler | Kentucky | 21031 | 2449 | 40 |
1914131 | 1914131 | 2021-11-14 | Lamar | Alabama | 1075 | 2449 | 52 |
1917028 | 1917028 | 2021-11-14 | Appomattox | Virginia | 51011 | 2449 | 36 |
1913778 | 1913778 | 2021-11-13 | Appomattox | Virginia | 51011 | 2449 | 36 |
1910528 | 1910528 | 2021-11-12 | Appomattox | Virginia | 51011 | 2449 | 36 |
1898682 | 1898682 | 2021-11-09 | Hamilton | Iowa | 19079 | 2449 | 57 |
1895432 | 1895432 | 2021-11-08 | Hamilton | Iowa | 19079 | 2449 | 57 |
1892182 | 1892182 | 2021-11-07 | Hamilton | Iowa | 19079 | 2449 | 57 |
1888932 | 1888932 | 2021-11-06 | Hamilton | Iowa | 19079 | 2449 | 57 |
1884987 | 1884987 | 2021-11-05 | Howard | Arkansas | 5061 | 2449 | 38 |
1885682 | 1885682 | 2021-11-05 | Hamilton | Iowa | 19079 | 2449 | 57 |
1882433 | 1882433 | 2021-11-04 | Hamilton | Iowa | 19079 | 2449 | 57 |
1884450 | 1884450 | 2021-11-04 | Tyler | Texas | 48457 | 2449 | 70 |
1879184 | 1879184 | 2021-11-03 | Hamilton | Iowa | 19079 | 2449 | 57 |
1881201 | 1881201 | 2021-11-03 | Tyler | Texas | 48457 | 2449 | 70 |
1877952 | 1877952 | 2021-11-02 | Tyler | Texas | 48457 | 2449 | 70 |
1874703 | 1874703 | 2021-11-01 | Tyler | Texas | 48457 | 2449 | 70 |
1871370 | 1871370 | 2021-10-31 | Leon | Texas | 48289 | 2449 | 69 |
1871454 | 1871454 | 2021-10-31 | Tyler | Texas | 48457 | 2449 | 70 |
1868121 | 1868121 | 2021-10-30 | Leon | Texas | 48289 | 2449 | 69 |
1868205 | 1868205 | 2021-10-30 | Tyler | Texas | 48457 | 2449 | 70 |
1864956 | 1864956 | 2021-10-29 | Tyler | Texas | 48457 | 2449 | 70 |
1833977 | 1833977 | 2021-10-20 | Webster | Kentucky | 21233 | 2449 | 34 |
1830479 | 1830479 | 2021-10-19 | Page | Iowa | 19145 | 2449 | 27 |
1831921 | 1831921 | 2021-10-19 | Montour | Pennsylvania | 42093 | 2449 | 70 |
1827230 | 1827230 | 2021-10-18 | Page | Iowa | 19145 | 2449 | 27 |
1823981 | 1823981 | 2021-10-17 | Page | Iowa | 19145 | 2449 | 27 |
1825156 | 1825156 | 2021-10-17 | Richland | North Dakota | 38077 | 2449 | 19 |
1820732 | 1820732 | 2021-10-16 | Page | Iowa | 19145 | 2449 | 27 |
1823013 | 1823013 | 2021-10-16 | Wetzel | West Virginia | 54103 | 2449 | 49 |
1817483 | 1817483 | 2021-10-15 | Page | Iowa | 19145 | 2449 | 27 |
1818969 | 1818969 | 2021-10-15 | Corozal | Puerto Rico | 72047 | 2449 | |
1814235 | 1814235 | 2021-10-14 | Page | Iowa | 19145 | 2449 | 27 |
1810986 | 1810986 | 2021-10-13 | Page | Iowa | 19145 | 2449 | 27 |
1783829 | 1783829 | 2021-10-04 | Colonial Heights city | Virginia | 51570 | 2449 | 64 |
1770545 | 1770545 | 2021-09-30 | Colorado | Texas | 48089 | 2449 | 49 |
1762216 | 1762216 | 2021-09-28 | Hardin | Iowa | 19083 | 2449 | 47 |
1758968 | 1758968 | 2021-09-27 | Hardin | Iowa | 19083 | 2449 | 47 |
1755720 | 1755720 | 2021-09-26 | Hardin | Iowa | 19083 | 2449 | 47 |
1752472 | 1752472 | 2021-09-25 | Hardin | Iowa | 19083 | 2449 | 47 |
1749223 | 1749223 | 2021-09-24 | Hardin | Iowa | 19083 | 2449 | 47 |
1751013 | 1751013 | 2021-09-24 | Aransas | Texas | 48007 | 2449 | 56 |
1745973 | 1745973 | 2021-09-23 | Hardin | Iowa | 19083 | 2449 | 47 |
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);