ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where cases = 2653 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 18
- Missouri 14
- Michigan 13
- Georgia 11
- Ohio 11
- Virginia 11
- Tennessee 10
- Illinois 8
- Indiana 7
- Puerto Rico 7
- Louisiana 6
- Minnesota 6
- Mississippi 6
- Wisconsin 6
- Pennsylvania 5
- South Carolina 5
- Alabama 4
- Idaho 4
- North Carolina 4
- South Dakota 4
- Texas 4
- Wyoming 4
- Arkansas 3
- Florida 3
- Oklahoma 3
- Kansas 2
- Nebraska 2
- New York 2
- West Virginia 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486247 | 2486247 | 2022-05-08 | Clarke | Virginia | 51043 | 2653 | 42 |
2482989 | 2482989 | 2022-05-07 | Clarke | Virginia | 51043 | 2653 | 42 |
2479731 | 2479731 | 2022-05-06 | Clarke | Virginia | 51043 | 2653 | 42 |
2468280 | 2468280 | 2022-05-03 | Iron | Michigan | 26071 | 2653 | 87 |
2469937 | 2469937 | 2022-05-03 | Amelia | Virginia | 51007 | 2653 | 60 |
2465025 | 2465025 | 2022-05-02 | Iron | Michigan | 26071 | 2653 | 87 |
2461769 | 2461769 | 2022-05-01 | Iron | Michigan | 26071 | 2653 | 87 |
2458513 | 2458513 | 2022-04-30 | Iron | Michigan | 26071 | 2653 | 87 |
2455257 | 2455257 | 2022-04-29 | Iron | Michigan | 26071 | 2653 | 87 |
2452001 | 2452001 | 2022-04-28 | Iron | Michigan | 26071 | 2653 | 87 |
2448745 | 2448745 | 2022-04-27 | Iron | Michigan | 26071 | 2653 | 87 |
2237542 | 2237542 | 2022-02-21 | Lewis | Missouri | 29111 | 2653 | 31 |
2238998 | 2238998 | 2022-02-21 | Nelson | Virginia | 51125 | 2653 | 29 |
2234291 | 2234291 | 2022-02-20 | Lewis | Missouri | 29111 | 2653 | 31 |
2231040 | 2231040 | 2022-02-19 | Lewis | Missouri | 29111 | 2653 | 31 |
2227789 | 2227789 | 2022-02-18 | Lewis | Missouri | 29111 | 2653 | 31 |
2226159 | 2226159 | 2022-02-17 | Forest | Wisconsin | 55041 | 2653 | 49 |
2187785 | 2187785 | 2022-02-06 | Gooding | Idaho | 16047 | 2653 | 48 |
2184532 | 2184532 | 2022-02-05 | Gooding | Idaho | 16047 | 2653 | 48 |
2183357 | 2183357 | 2022-02-04 | Camp | Texas | 48063 | 2653 | 70 |
2122567 | 2122567 | 2022-01-17 | Dade | Georgia | 13083 | 2653 | 24 |
2108680 | 2108680 | 2022-01-12 | Nolan | Texas | 48353 | 2653 | 85 |
2101694 | 2101694 | 2022-01-10 | Potter | Pennsylvania | 42105 | 2653 | 80 |
2073405 | 2073405 | 2022-01-02 | Macon | Alabama | 1087 | 2653 | 69 |
2074397 | 2074397 | 2022-01-02 | Estill | Kentucky | 21065 | 2653 | 37 |
2071146 | 2071146 | 2022-01-01 | Estill | Kentucky | 21065 | 2653 | 37 |
2067895 | 2067895 | 2021-12-31 | Estill | Kentucky | 21065 | 2653 | 37 |
2064644 | 2064644 | 2021-12-30 | Estill | Kentucky | 21065 | 2653 | 37 |
2061394 | 2061394 | 2021-12-29 | Estill | Kentucky | 21065 | 2653 | 37 |
2055246 | 2055246 | 2021-12-27 | Pennington | Minnesota | 27113 | 2653 | 31 |
2050632 | 2050632 | 2021-12-26 | Crenshaw | Alabama | 1041 | 2653 | 79 |
2051257 | 2051257 | 2021-12-26 | Johnson | Illinois | 17087 | 2653 | 39 |
2051728 | 2051728 | 2021-12-26 | Washington | Kentucky | 21229 | 2653 | 51 |
2053126 | 2053126 | 2021-12-26 | Oglala Lakota | South Dakota | 46102 | 2653 | 55 |
2048007 | 2048007 | 2021-12-25 | Johnson | Illinois | 17087 | 2653 | 39 |
2048478 | 2048478 | 2021-12-25 | Washington | Kentucky | 21229 | 2653 | 51 |
2049876 | 2049876 | 2021-12-25 | Oglala Lakota | South Dakota | 46102 | 2653 | 55 |
2044757 | 2044757 | 2021-12-24 | Johnson | Illinois | 17087 | 2653 | 39 |
2045228 | 2045228 | 2021-12-24 | Washington | Kentucky | 21229 | 2653 | 51 |
2046626 | 2046626 | 2021-12-24 | Oglala Lakota | South Dakota | 46102 | 2653 | 55 |
2041508 | 2041508 | 2021-12-23 | Johnson | Illinois | 17087 | 2653 | 39 |
2041979 | 2041979 | 2021-12-23 | Washington | Kentucky | 21229 | 2653 | 51 |
2043376 | 2043376 | 2021-12-23 | Oglala Lakota | South Dakota | 46102 | 2653 | 55 |
2038729 | 2038729 | 2021-12-22 | Washington | Kentucky | 21229 | 2653 | 51 |
1998366 | 1998366 | 2021-12-09 | New Kent | Virginia | 51127 | 2653 | 27 |
1982745 | 1982745 | 2021-12-05 | Bacon | Georgia | 13005 | 2653 | 64 |
1979495 | 1979495 | 2021-12-04 | Bacon | Georgia | 13005 | 2653 | 64 |
1976245 | 1976245 | 2021-12-03 | Bacon | Georgia | 13005 | 2653 | 64 |
1971647 | 1971647 | 2021-12-01 | Fulton | Pennsylvania | 42057 | 2653 | 39 |
1968551 | 1968551 | 2021-11-30 | Lee | South Carolina | 45061 | 2653 | 78 |
1898899 | 1898899 | 2021-11-09 | Henry | Kentucky | 21103 | 2653 | 31 |
1875723 | 1875723 | 2021-11-02 | Edgar | Illinois | 17045 | 2653 | 69 |
1850502 | 1850502 | 2021-10-25 | Roseau | Minnesota | 27135 | 2653 | 27 |
1852050 | 1852050 | 2021-10-25 | Buckingham | Virginia | 51029 | 2653 | 37 |
1848956 | 1848956 | 2021-10-24 | Barbour | West Virginia | 54001 | 2653 | 44 |
1830223 | 1830223 | 2021-10-19 | Clark | Illinois | 17023 | 2653 | 48 |
1826971 | 1826971 | 2021-10-18 | Cass | Illinois | 17017 | 2653 | 39 |
1813837 | 1813837 | 2021-10-14 | Jefferson | Georgia | 13163 | 2653 | 81 |
1813946 | 1813946 | 2021-10-14 | Gem | Idaho | 16045 | 2653 | 54 |
1814624 | 1814624 | 2021-10-14 | Cheboygan | Michigan | 26031 | 2653 | 63 |
1811376 | 1811376 | 2021-10-13 | Cheboygan | Michigan | 26031 | 2653 | 63 |
1806773 | 1806773 | 2021-10-11 | Adams | Wisconsin | 55001 | 2653 | 33 |
1791899 | 1791899 | 2021-10-07 | Iosco | Michigan | 26069 | 2653 | 87 |
1788414 | 1788414 | 2021-10-06 | Garrard | Kentucky | 21079 | 2653 | 42 |
1788650 | 1788650 | 2021-10-06 | Iosco | Michigan | 26069 | 2653 | 87 |
1783406 | 1783406 | 2021-10-04 | Benton | Tennessee | 47005 | 2653 | 48 |
1775899 | 1775899 | 2021-10-02 | Cooper | Missouri | 29053 | 2653 | 33 |
1768010 | 1768010 | 2021-09-30 | Franklin | Arkansas | 5047 | 2653 | 52 |
1765776 | 1765776 | 2021-09-29 | LaSalle | Louisiana | 22059 | 2653 | 44 |
1762877 | 1762877 | 2021-09-28 | Andrew | Missouri | 29003 | 2653 | 23 |
1740278 | 1740278 | 2021-09-21 | Lincoln | Montana | 30053 | 2653 | 40 |
1681735 | 1681735 | 2021-09-03 | Perry | Missouri | 29157 | 2653 | 32 |
1668217 | 1668217 | 2021-08-30 | Hart | Kentucky | 21099 | 2653 | 56 |
1664394 | 1664394 | 2021-08-29 | Jones | Georgia | 13169 | 2653 | 63 |
1661146 | 1661146 | 2021-08-28 | Jones | Georgia | 13169 | 2653 | 63 |
1662279 | 1662279 | 2021-08-28 | Vernon | Missouri | 29217 | 2653 | 52 |
1657898 | 1657898 | 2021-08-27 | Jones | Georgia | 13169 | 2653 | 63 |
1642667 | 1642667 | 2021-08-22 | Tishomingo | Mississippi | 28141 | 2653 | 71 |
1638033 | 1638033 | 2021-08-21 | La Paz | Arizona | 4012 | 2653 | 80 |
1639417 | 1639417 | 2021-08-21 | Tishomingo | Mississippi | 28141 | 2653 | 71 |
1636167 | 1636167 | 2021-08-20 | Tishomingo | Mississippi | 28141 | 2653 | 71 |
1628306 | 1628306 | 2021-08-18 | Clark | Arkansas | 5019 | 2653 | 41 |
1629321 | 1629321 | 2021-08-18 | Concordia | Louisiana | 22029 | 2653 | 64 |
1628161 | 1628161 | 2021-08-17 | Waushara | Wisconsin | 55137 | 2653 | 38 |
1623109 | 1623109 | 2021-08-16 | Attala | Mississippi | 28007 | 2653 | 76 |
1619236 | 1619236 | 2021-08-15 | Washington | Indiana | 18175 | 2653 | 39 |
1620306 | 1620306 | 2021-08-15 | Franklin | New York | 36033 | 2653 | 12 |
1615988 | 1615988 | 2021-08-14 | Washington | Indiana | 18175 | 2653 | 39 |
1612739 | 1612739 | 2021-08-13 | Washington | Indiana | 18175 | 2653 | 39 |
1546059 | 1546059 | 2021-07-23 | Warren | Pennsylvania | 42123 | 2653 | 106 |
1534022 | 1534022 | 2021-07-20 | Geneva | Alabama | 1061 | 2653 | 83 |
1533124 | 1533124 | 2021-07-19 | Mayaguez | Puerto Rico | 72097 | 2653 | |
1512345 | 1512345 | 2021-07-13 | Mercer | Kentucky | 21167 | 2653 | 54 |
1509098 | 1509098 | 2021-07-12 | Mercer | Kentucky | 21167 | 2653 | 54 |
1472887 | 1472887 | 2021-07-01 | Jerome | Idaho | 16053 | 2653 | 23 |
1438169 | 1438169 | 2021-06-20 | Miller | Missouri | 29131 | 2653 | 57 |
1382859 | 1382859 | 2021-06-03 | Covington | Mississippi | 28031 | 2653 | 81 |
1380738 | 1380738 | 2021-06-02 | Grainger | Tennessee | 47057 | 2653 | 49 |
1377493 | 1377493 | 2021-06-01 | Grainger | Tennessee | 47057 | 2653 | 49 |
1374247 | 1374247 | 2021-05-31 | Grainger | Tennessee | 47057 | 2653 | 49 |
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);