ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
229 rows where cases = 2083 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19
- Minnesota 15
- Georgia 14
- Iowa 11
- Puerto Rico 11
- West Virginia 11
- Mississippi 10
- Indiana 9
- Arkansas 8
- Missouri 8
- Colorado 7
- Illinois 7
- Virginia 7
- Kentucky 6
- Michigan 6
- South Dakota 6
- Alabama 5
- New Mexico 5
- Ohio 5
- Nebraska 4
- New York 4
- North Dakota 4
- Tennessee 4
- Utah 4
- Wisconsin 4
- Florida 3
- Idaho 3
- Kansas 3
- North Carolina 3
- Oklahoma 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490652 | 2490652 | 2022-05-10 | Keokuk | Iowa | 19107 | 2083 | 48 |
2487395 | 2487395 | 2022-05-09 | Keokuk | Iowa | 19107 | 2083 | 48 |
2484137 | 2484137 | 2022-05-08 | Keokuk | Iowa | 19107 | 2083 | 48 |
2480879 | 2480879 | 2022-05-07 | Keokuk | Iowa | 19107 | 2083 | 48 |
2477621 | 2477621 | 2022-05-06 | Keokuk | Iowa | 19107 | 2083 | 48 |
2474363 | 2474363 | 2022-05-05 | Keokuk | Iowa | 19107 | 2083 | 48 |
2471106 | 2471106 | 2022-05-04 | Keokuk | Iowa | 19107 | 2083 | 48 |
2445575 | 2445575 | 2022-04-26 | Lake | Minnesota | 27075 | 2083 | 28 |
2442319 | 2442319 | 2022-04-25 | Lake | Minnesota | 27075 | 2083 | 28 |
2360946 | 2360946 | 2022-03-31 | Marshall | Minnesota | 27089 | 2083 | 23 |
2357692 | 2357692 | 2022-03-30 | Marshall | Minnesota | 27089 | 2083 | 23 |
2354439 | 2354439 | 2022-03-29 | Marshall | Minnesota | 27089 | 2083 | 23 |
2350606 | 2350606 | 2022-03-28 | Warren | Indiana | 18171 | 2083 | 30 |
2347353 | 2347353 | 2022-03-27 | Warren | Indiana | 18171 | 2083 | 30 |
2344100 | 2344100 | 2022-03-26 | Warren | Indiana | 18171 | 2083 | 30 |
2340847 | 2340847 | 2022-03-25 | Warren | Indiana | 18171 | 2083 | 30 |
2337594 | 2337594 | 2022-03-24 | Warren | Indiana | 18171 | 2083 | 30 |
2304133 | 2304133 | 2022-03-13 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2300881 | 2300881 | 2022-03-12 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2297629 | 2297629 | 2022-03-11 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2294377 | 2294377 | 2022-03-10 | Gilmer | West Virginia | 54021 | 2083 | 18 |
2268673 | 2268673 | 2022-03-03 | Searcy | Arkansas | 5129 | 2083 | 41 |
2267618 | 2267618 | 2022-03-02 | Jayuya | Puerto Rico | 72073 | 2083 | |
2258796 | 2258796 | 2022-02-28 | Perry | Alabama | 1105 | 2083 | 43 |
2255545 | 2255545 | 2022-02-27 | Perry | Alabama | 1105 | 2083 | 43 |
2238618 | 2238618 | 2022-02-21 | Archer | Texas | 48009 | 2083 | 27 |
2235367 | 2235367 | 2022-02-20 | Archer | Texas | 48009 | 2083 | 27 |
2235442 | 2235442 | 2022-02-20 | Franklin | Texas | 48159 | 2083 | 39 |
2221074 | 2221074 | 2022-02-16 | Clearwater | Minnesota | 27029 | 2083 | 29 |
2214655 | 2214655 | 2022-02-14 | Choctaw | Mississippi | 28019 | 2083 | 30 |
2198509 | 2198509 | 2022-02-09 | Iron | Missouri | 29093 | 2083 | 35 |
2192025 | 2192025 | 2022-02-07 | Monroe | Missouri | 29137 | 2083 | 38 |
2186285 | 2186285 | 2022-02-05 | Adjuntas | Puerto Rico | 72001 | 2083 | |
2139940 | 2139940 | 2022-01-22 | Grundy | Missouri | 29079 | 2083 | 61 |
2111164 | 2111164 | 2022-01-13 | Mercer | North Dakota | 38057 | 2083 | 22 |
2107075 | 2107075 | 2022-01-12 | Piscataquis | Maine | 23021 | 2083 | 23 |
2088606 | 2088606 | 2022-01-06 | Curry | Oregon | 41015 | 2083 | 40 |
2082952 | 2082952 | 2022-01-04 | Pacific | Washington | 53049 | 2083 | 40 |
2071870 | 2071870 | 2022-01-01 | Unknown | Nebraska | 2083 | 268 | |
2068619 | 2068619 | 2021-12-31 | Unknown | Nebraska | 2083 | 268 | |
2060028 | 2060028 | 2021-12-28 | Orange | Vermont | 50017 | 2083 | 9 |
2036707 | 2036707 | 2021-12-21 | Cabo Rojo | Puerto Rico | 72023 | 2083 | |
2009850 | 2009850 | 2021-12-13 | Webster | Mississippi | 28155 | 2083 | 49 |
1998265 | 1998265 | 2021-12-09 | Addison | Vermont | 50001 | 2083 | 10 |
1987447 | 1987447 | 2021-12-06 | Torrance | New Mexico | 35057 | 2083 | 24 |
1978202 | 1978202 | 2021-12-03 | Cayey | Puerto Rico | 72035 | 2083 | |
1964888 | 1964888 | 2021-11-29 | Mountrail | North Dakota | 38061 | 2083 | 29 |
1955218 | 1955218 | 2021-11-26 | Morgan | Ohio | 39115 | 2083 | 38 |
1939735 | 1939735 | 2021-11-21 | Juab | Utah | 49023 | 2083 | 18 |
1936485 | 1936485 | 2021-11-20 | Juab | Utah | 49023 | 2083 | 18 |
1933235 | 1933235 | 2021-11-19 | Juab | Utah | 49023 | 2083 | 18 |
1914380 | 1914380 | 2021-11-14 | Moffat | Colorado | 8081 | 2083 | 46 |
1911130 | 1911130 | 2021-11-13 | Moffat | Colorado | 8081 | 2083 | 46 |
1907881 | 1907881 | 2021-11-12 | Moffat | Colorado | 8081 | 2083 | 46 |
1895271 | 1895271 | 2021-11-08 | Piatt | Illinois | 17147 | 2083 | 20 |
1884169 | 1884169 | 2021-11-04 | Jackson | Tennessee | 47087 | 2083 | 40 |
1861984 | 1861984 | 2021-10-28 | Monroe | West Virginia | 54063 | 2083 | 26 |
1848988 | 1848988 | 2021-10-24 | Morgan | West Virginia | 54065 | 2083 | 41 |
1807138 | 1807138 | 2021-10-12 | Grand | Colorado | 8049 | 2083 | 10 |
1787842 | 1787842 | 2021-10-06 | Jasper | Georgia | 13159 | 2083 | 55 |
1784786 | 1784786 | 2021-10-05 | Massac | Illinois | 17127 | 2083 | 48 |
1785158 | 1785158 | 2021-10-05 | Estill | Kentucky | 21065 | 2083 | 12 |
1782283 | 1782283 | 2021-10-04 | Wadena | Minnesota | 27159 | 2083 | 27 |
1768307 | 1768307 | 2021-09-30 | Dade | Georgia | 13083 | 2083 | 17 |
1768571 | 1768571 | 2021-09-30 | Wabash | Illinois | 17185 | 2083 | 21 |
1762770 | 1762770 | 2021-09-28 | Renville | Minnesota | 27129 | 2083 | 48 |
1759520 | 1759520 | 2021-09-27 | Redwood | Minnesota | 27127 | 2083 | 42 |
1746222 | 1746222 | 2021-09-23 | Monroe | Kentucky | 21171 | 2083 | 52 |
1747025 | 1747025 | 2021-09-23 | Schoharie | New York | 36095 | 2083 | 20 |
1744809 | 1744809 | 2021-09-22 | Windsor | Vermont | 50027 | 2083 | 22 |
1737314 | 1737314 | 2021-09-20 | Chowan | North Carolina | 37041 | 2083 | 38 |
1722913 | 1722913 | 2021-09-16 | Telfair | Georgia | 13271 | 2083 | 63 |
1709443 | 1709443 | 2021-09-12 | Macon | Alabama | 1087 | 2083 | 54 |
1699282 | 1699282 | 2021-09-08 | Zapata | Texas | 48505 | 2083 | 39 |
1679806 | 1679806 | 2021-09-02 | San Juan | Utah | 49037 | 2083 | 39 |
1660826 | 1660826 | 2021-08-28 | Madison | Arkansas | 5087 | 2083 | 32 |
1648788 | 1648788 | 2021-08-24 | Spencer | Kentucky | 21215 | 2083 | 26 |
1648973 | 1648973 | 2021-08-24 | Manistee | Michigan | 26101 | 2083 | 28 |
1645724 | 1645724 | 2021-08-23 | Manistee | Michigan | 26101 | 2083 | 28 |
1644222 | 1644222 | 2021-08-22 | Scott | Virginia | 51169 | 2083 | 61 |
1640972 | 1640972 | 2021-08-21 | Scott | Virginia | 51169 | 2083 | 61 |
1637722 | 1637722 | 2021-08-20 | Scott | Virginia | 51169 | 2083 | 61 |
1624227 | 1624227 | 2021-08-16 | Cannon | Tennessee | 47015 | 2083 | 32 |
1614281 | 1614281 | 2021-08-13 | Aguada | Puerto Rico | 72003 | 2083 | |
1610770 | 1610770 | 2021-08-12 | Carroll | Ohio | 39019 | 2083 | 49 |
1597132 | 1597132 | 2021-08-08 | Clay | Mississippi | 28025 | 2083 | 54 |
1598442 | 1598442 | 2021-08-08 | Houston | Texas | 48225 | 2083 | 59 |
1593883 | 1593883 | 2021-08-07 | Clay | Mississippi | 28025 | 2083 | 54 |
1590634 | 1590634 | 2021-08-06 | Clay | Mississippi | 28025 | 2083 | 54 |
1585925 | 1585925 | 2021-08-04 | Vernon | Wisconsin | 55123 | 2083 | 43 |
1574797 | 1574797 | 2021-08-01 | Roosevelt | New Mexico | 35041 | 2083 | 59 |
1571282 | 1571282 | 2021-07-31 | Morgan | Missouri | 29141 | 2083 | 45 |
1571549 | 1571549 | 2021-07-31 | Roosevelt | New Mexico | 35041 | 2083 | 59 |
1568301 | 1568301 | 2021-07-30 | Roosevelt | New Mexico | 35041 | 2083 | 59 |
1551633 | 1551633 | 2021-07-25 | Wabasha | Minnesota | 27157 | 2083 | 3 |
1548386 | 1548386 | 2021-07-24 | Wabasha | Minnesota | 27157 | 2083 | 3 |
1545139 | 1545139 | 2021-07-23 | Wabasha | Minnesota | 27157 | 2083 | 3 |
1540653 | 1540653 | 2021-07-22 | Polk | Arkansas | 5113 | 2083 | 74 |
1541891 | 1541891 | 2021-07-22 | Wabasha | Minnesota | 27157 | 2083 | 3 |
1543639 | 1543639 | 2021-07-22 | Wyoming | West Virginia | 54109 | 2083 | 41 |
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);