ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where cases = 2659 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 18
- Georgia 16
- Pennsylvania 16
- Texas 15
- Illinois 11
- Michigan 11
- Mississippi 11
- Virginia 11
- Oklahoma 10
- Wisconsin 8
- Missouri 7
- Ohio 7
- Tennessee 6
- Montana 5
- Alaska 4
- Colorado 4
- Indiana 4
- Nebraska 4
- New York 4
- South Carolina 4
- Alabama 3
- Idaho 3
- Minnesota 3
- New Mexico 3
- Oregon 3
- Utah 3
- Arkansas 2
- Kansas 2
- North Carolina 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500089 | 2500089 | 2022-05-13 | Screven | Georgia | 13251 | 2659 | 70 |
2496831 | 2496831 | 2022-05-12 | Screven | Georgia | 13251 | 2659 | 70 |
2493573 | 2493573 | 2022-05-11 | Screven | Georgia | 13251 | 2659 | 70 |
2491082 | 2491082 | 2022-05-10 | Iron | Michigan | 26071 | 2659 | 87 |
2487825 | 2487825 | 2022-05-09 | Iron | Michigan | 26071 | 2659 | 87 |
2484567 | 2484567 | 2022-05-08 | Iron | Michigan | 26071 | 2659 | 87 |
2481309 | 2481309 | 2022-05-07 | Iron | Michigan | 26071 | 2659 | 87 |
2478051 | 2478051 | 2022-05-06 | Iron | Michigan | 26071 | 2659 | 87 |
2474793 | 2474793 | 2022-05-05 | Iron | Michigan | 26071 | 2659 | 87 |
2471536 | 2471536 | 2022-05-04 | Iron | Michigan | 26071 | 2659 | 87 |
2430334 | 2430334 | 2022-04-21 | Santa Isabel | Puerto Rico | 72133 | 2659 | |
2294652 | 2294652 | 2022-03-11 | Fulton | Arkansas | 5049 | 2659 | 86 |
2240828 | 2240828 | 2022-02-22 | Ripley | Missouri | 29181 | 2659 | 57 |
2242414 | 2242414 | 2022-02-22 | Forest | Wisconsin | 55041 | 2659 | 49 |
2239163 | 2239163 | 2022-02-21 | Forest | Wisconsin | 55041 | 2659 | 49 |
2187496 | 2187496 | 2022-02-06 | Park | Colorado | 8093 | 2659 | 17 |
2184243 | 2184243 | 2022-02-05 | Park | Colorado | 8093 | 2659 | 17 |
2180991 | 2180991 | 2022-02-04 | Park | Colorado | 8093 | 2659 | 17 |
2154313 | 2154313 | 2022-01-26 | Morgan | Utah | 49029 | 2659 | 13 |
2147388 | 2147388 | 2022-01-24 | Charles Mix | South Dakota | 46023 | 2659 | 33 |
2130400 | 2130400 | 2022-01-19 | Unknown | Nebraska | 2659 | 320 | |
2104532 | 2104532 | 2022-01-11 | Yates | New York | 36123 | 2659 | 36 |
2097408 | 2097408 | 2022-01-09 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2094156 | 2094156 | 2022-01-08 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2090904 | 2090904 | 2022-01-07 | Kalkaska | Michigan | 26079 | 2659 | 48 |
2057978 | 2057978 | 2021-12-28 | O'Brien | Iowa | 19141 | 2659 | 67 |
2054729 | 2054729 | 2021-12-27 | O'Brien | Iowa | 19141 | 2659 | 67 |
2057048 | 2057048 | 2021-12-27 | Lafayette | Wisconsin | 55065 | 2659 | 18 |
2051479 | 2051479 | 2021-12-26 | O'Brien | Iowa | 19141 | 2659 | 67 |
2048229 | 2048229 | 2021-12-25 | O'Brien | Iowa | 19141 | 2659 | 67 |
2044979 | 2044979 | 2021-12-24 | O'Brien | Iowa | 19141 | 2659 | 67 |
2041730 | 2041730 | 2021-12-23 | O'Brien | Iowa | 19141 | 2659 | 67 |
2038480 | 2038480 | 2021-12-22 | O'Brien | Iowa | 19141 | 2659 | 67 |
2023990 | 2023990 | 2021-12-17 | Aransas | Texas | 48007 | 2659 | 67 |
2020739 | 2020739 | 2021-12-16 | Aransas | Texas | 48007 | 2659 | 67 |
2020780 | 2020780 | 2021-12-16 | Colorado | Texas | 48089 | 2659 | 55 |
2016052 | 2016052 | 2021-12-15 | Knox | Maine | 23013 | 2659 | 17 |
2017488 | 2017488 | 2021-12-15 | Aransas | Texas | 48007 | 2659 | 67 |
2012228 | 2012228 | 2021-12-14 | De Witt | Illinois | 17039 | 2659 | 39 |
2013580 | 2013580 | 2021-12-14 | Northampton | North Carolina | 37131 | 2659 | 66 |
1983023 | 1983023 | 2021-12-05 | Moultrie | Illinois | 17139 | 2659 | 42 |
1979773 | 1979773 | 2021-12-04 | Moultrie | Illinois | 17139 | 2659 | 42 |
1976523 | 1976523 | 2021-12-03 | Moultrie | Illinois | 17139 | 2659 | 42 |
1973505 | 1973505 | 2021-12-02 | Bourbon | Kansas | 20011 | 2659 | 44 |
1975050 | 1975050 | 2021-12-02 | Lee | South Carolina | 45061 | 2659 | 79 |
1970255 | 1970255 | 2021-12-01 | Bourbon | Kansas | 20011 | 2659 | 44 |
1966915 | 1966915 | 2021-11-30 | Cedar | Iowa | 19031 | 2659 | 27 |
1968291 | 1968291 | 2021-11-30 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1963360 | 1963360 | 2021-11-29 | Rabun | Georgia | 13241 | 2659 | 74 |
1963663 | 1963663 | 2021-11-29 | Cedar | Iowa | 19031 | 2659 | 27 |
1965040 | 1965040 | 2021-11-29 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1960412 | 1960412 | 2021-11-28 | Cedar | Iowa | 19031 | 2659 | 27 |
1961788 | 1961788 | 2021-11-28 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1957161 | 1957161 | 2021-11-27 | Cedar | Iowa | 19031 | 2659 | 27 |
1958537 | 1958537 | 2021-11-27 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1953910 | 1953910 | 2021-11-26 | Cedar | Iowa | 19031 | 2659 | 27 |
1955286 | 1955286 | 2021-11-26 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1950659 | 1950659 | 2021-11-25 | Cedar | Iowa | 19031 | 2659 | 27 |
1952035 | 1952035 | 2021-11-25 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1947408 | 1947408 | 2021-11-24 | Cedar | Iowa | 19031 | 2659 | 27 |
1948784 | 1948784 | 2021-11-24 | Kingfisher | Oklahoma | 40073 | 2659 | 54 |
1949614 | 1949614 | 2021-11-24 | Nottoway | Virginia | 51135 | 2659 | 70 |
1946363 | 1946363 | 2021-11-23 | Nottoway | Virginia | 51135 | 2659 | 70 |
1942869 | 1942869 | 2021-11-22 | Llano | Texas | 48299 | 2659 | 76 |
1936924 | 1936924 | 2021-11-21 | Kodiak Island Borough | Alaska | 2150 | 2659 | 9 |
1933674 | 1933674 | 2021-11-20 | Kodiak Island Borough | Alaska | 2150 | 2659 | 9 |
1930422 | 1930422 | 2021-11-19 | Kodiak Island Borough | Alaska | 2150 | 2659 | 9 |
1930486 | 1930486 | 2021-11-19 | Izard | Arkansas | 5065 | 2659 | 55 |
1896458 | 1896458 | 2021-11-08 | Essex | New York | 36031 | 2659 | 36 |
1858937 | 1858937 | 2021-10-28 | North Slope Borough | Alaska | 2185 | 2659 | 6 |
1830376 | 1830376 | 2021-10-19 | Perry | Indiana | 18123 | 2659 | 55 |
1827127 | 1827127 | 2021-10-18 | Perry | Indiana | 18123 | 2659 | 55 |
1817194 | 1817194 | 2021-10-15 | Gem | Idaho | 16045 | 2659 | 54 |
1799243 | 1799243 | 2021-10-09 | Paulding | Ohio | 39125 | 2659 | 44 |
1768985 | 1768985 | 2021-09-30 | Spencer | Kentucky | 21215 | 2659 | 28 |
1769705 | 1769705 | 2021-09-30 | Lincoln | New Mexico | 35027 | 2659 | 29 |
1751299 | 1751299 | 2021-09-24 | Franklin | Vermont | 50011 | 2659 | 42 |
1742585 | 1742585 | 2021-09-22 | White | Illinois | 17193 | 2659 | 40 |
1733660 | 1733660 | 2021-09-19 | Clinton | Missouri | 29049 | 2659 | 75 |
1735137 | 1735137 | 2021-09-19 | Louisa | Virginia | 51109 | 2659 | 40 |
1731887 | 1731887 | 2021-09-18 | Louisa | Virginia | 51109 | 2659 | 40 |
1728637 | 1728637 | 2021-09-17 | Louisa | Virginia | 51109 | 2659 | 40 |
1714282 | 1714282 | 2021-09-13 | Lake | Montana | 30047 | 2659 | 45 |
1707739 | 1707739 | 2021-09-11 | Ray | Missouri | 29177 | 2659 | 40 |
1689101 | 1689101 | 2021-09-05 | Hampton | South Carolina | 45049 | 2659 | 61 |
1685851 | 1685851 | 2021-09-04 | Hampton | South Carolina | 45049 | 2659 | 61 |
1682600 | 1682600 | 2021-09-03 | Hampton | South Carolina | 45049 | 2659 | 61 |
1665535 | 1665535 | 2021-08-29 | Big Horn | Montana | 30003 | 2659 | 77 |
1662287 | 1662287 | 2021-08-28 | Big Horn | Montana | 30003 | 2659 | 77 |
1659039 | 1659039 | 2021-08-27 | Big Horn | Montana | 30003 | 2659 | 77 |
1644966 | 1644966 | 2021-08-23 | Union | Georgia | 13291 | 2659 | 84 |
1641676 | 1641676 | 2021-08-22 | Morgan | Georgia | 13211 | 2659 | 31 |
1638426 | 1638426 | 2021-08-21 | Morgan | Georgia | 13211 | 2659 | 31 |
1635176 | 1635176 | 2021-08-20 | Morgan | Georgia | 13211 | 2659 | 31 |
1637514 | 1637514 | 2021-08-20 | Scurry | Texas | 48415 | 2659 | 63 |
1577674 | 1577674 | 2021-08-02 | Newton | Mississippi | 28101 | 2659 | 64 |
1565543 | 1565543 | 2021-07-29 | Warren | Pennsylvania | 42123 | 2659 | 106 |
1562759 | 1562759 | 2021-07-28 | Milam | Texas | 48331 | 2659 | 53 |
1557316 | 1557316 | 2021-07-27 | Payette | Idaho | 16075 | 2659 | 38 |
1534434 | 1534434 | 2021-07-20 | Emanuel | Georgia | 13107 | 2659 | 83 |
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);