ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 4701 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Texas 10
- Ohio 9
- Georgia 8
- Kentucky 6
- Louisiana 6
- Mississippi 6
- North Carolina 6
- Minnesota 4
- South Carolina 4
- Virginia 4
- Washington 4
- Illinois 3
- Pennsylvania 3
- Puerto Rico 3
- Wisconsin 3
- Alabama 2
- Arkansas 2
- Florida 2
- Indiana 2
- Iowa 2
- Michigan 2
- Missouri 2
- Nevada 2
- New York 2
- West Virginia 2
- California 1
- Idaho 1
- Montana 1
- New Mexico 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492156 | 2492156 | 2022-05-10 | Catano | Puerto Rico | 72033 | 4701 | |
2331904 | 2331904 | 2022-03-22 | Texas | Missouri | 29215 | 4701 | 100 |
2315672 | 2315672 | 2022-03-17 | Lincoln | Montana | 30053 | 4701 | 86 |
2266768 | 2266768 | 2022-03-02 | Clinton | Missouri | 29049 | 4701 | 114 |
2179284 | 2179284 | 2022-02-03 | Roosevelt | New Mexico | 35041 | 4701 | 88 |
2176988 | 2176988 | 2022-02-02 | Milam | Texas | 48331 | 4701 | 93 |
2155806 | 2155806 | 2022-01-27 | Concordia | Louisiana | 22029 | 4701 | 82 |
2157002 | 2157002 | 2022-01-27 | Wyoming | Pennsylvania | 42131 | 4701 | 96 |
2152093 | 2152093 | 2022-01-26 | Pike | Illinois | 17149 | 4701 | 65 |
2141116 | 2141116 | 2022-01-22 | Gillespie | Texas | 48171 | 4701 | 89 |
2126513 | 2126513 | 2022-01-18 | Assumption | Louisiana | 22007 | 4701 | 57 |
2117784 | 2117784 | 2022-01-15 | Wyandot | Ohio | 39175 | 4701 | 89 |
2110895 | 2110895 | 2022-01-13 | Churchill | Nevada | 32001 | 4701 | 92 |
2108212 | 2108212 | 2022-01-12 | Aguada | Puerto Rico | 72003 | 4701 | |
2080309 | 2080309 | 2022-01-04 | Emanuel | Georgia | 13107 | 4701 | 144 |
2047506 | 2047506 | 2021-12-25 | Jackson | Arkansas | 5067 | 4701 | 47 |
1988716 | 1988716 | 2021-12-06 | Hancock | West Virginia | 54029 | 4701 | 121 |
1943931 | 1943931 | 2021-11-23 | Latah | Idaho | 16057 | 4701 | 40 |
1925768 | 1925768 | 2021-11-17 | Cherokee | North Carolina | 37039 | 4701 | 78 |
1888282 | 1888282 | 2021-11-06 | Yell | Arkansas | 5149 | 4701 | 79 |
1873618 | 1873618 | 2021-11-01 | Douglas | Nevada | 32005 | 4701 | 57 |
1846335 | 1846335 | 2021-10-24 | Lee | Georgia | 13177 | 4701 | 79 |
1843085 | 1843085 | 2021-10-23 | Lee | Georgia | 13177 | 4701 | 79 |
1839835 | 1839835 | 2021-10-22 | Lee | Georgia | 13177 | 4701 | 79 |
1828658 | 1828658 | 2021-10-18 | Jefferson | Pennsylvania | 42065 | 4701 | 112 |
1824249 | 1824249 | 2021-10-17 | De Soto | Louisiana | 22031 | 4701 | 107 |
1821000 | 1821000 | 2021-10-16 | De Soto | Louisiana | 22031 | 4701 | 107 |
1817751 | 1817751 | 2021-10-15 | De Soto | Louisiana | 22031 | 4701 | 107 |
1813209 | 1813209 | 2021-10-13 | Stevens | Washington | 53065 | 4701 | 78 |
1804968 | 1804968 | 2021-10-11 | Freeborn | Minnesota | 27047 | 4701 | 42 |
1774266 | 1774266 | 2021-10-01 | Randolph | West Virginia | 54083 | 4701 | 34 |
1761923 | 1761923 | 2021-09-28 | White | Georgia | 13311 | 4701 | 116 |
1757311 | 1757311 | 2021-09-26 | Clarendon | South Carolina | 45027 | 4701 | 134 |
1757635 | 1757635 | 2021-09-26 | Kendall | Texas | 48259 | 4701 | 89 |
1754063 | 1754063 | 2021-09-25 | Clarendon | South Carolina | 45027 | 4701 | 134 |
1754387 | 1754387 | 2021-09-25 | Kendall | Texas | 48259 | 4701 | 89 |
1750815 | 1750815 | 2021-09-24 | Clarendon | South Carolina | 45027 | 4701 | 134 |
1751139 | 1751139 | 2021-09-24 | Kendall | Texas | 48259 | 4701 | 88 |
1747890 | 1747890 | 2021-09-23 | Kendall | Texas | 48259 | 4701 | 88 |
1742629 | 1742629 | 2021-09-22 | Jefferson | Indiana | 18077 | 4701 | 93 |
1723499 | 1723499 | 2021-09-16 | Taylor | Kentucky | 21217 | 4701 | 69 |
1650778 | 1650778 | 2021-08-24 | Whitman | Washington | 53075 | 4701 | 54 |
1646301 | 1646301 | 2021-08-23 | Livingston | New York | 36051 | 4701 | 60 |
1619931 | 1619931 | 2021-08-15 | Union | Mississippi | 28145 | 4701 | 79 |
1616683 | 1616683 | 2021-08-14 | Union | Mississippi | 28145 | 4701 | 79 |
1613435 | 1613435 | 2021-08-13 | Union | Mississippi | 28145 | 4701 | 79 |
1584811 | 1584811 | 2021-08-04 | Knox | Ohio | 39083 | 4701 | 112 |
1574422 | 1574422 | 2021-08-01 | Marshall | Mississippi | 28093 | 4701 | 106 |
1571174 | 1571174 | 2021-07-31 | Marshall | Mississippi | 28093 | 4701 | 106 |
1567926 | 1567926 | 2021-07-30 | Marshall | Mississippi | 28093 | 4701 | 106 |
1540224 | 1540224 | 2021-07-21 | Henry | Virginia | 51089 | 4701 | 124 |
1514249 | 1514249 | 2021-07-13 | James City | Virginia | 51095 | 4701 | 72 |
1488158 | 1488158 | 2021-07-05 | Wilson | Texas | 48493 | 4701 | 69 |
1484911 | 1484911 | 2021-07-04 | Wilson | Texas | 48493 | 4701 | 69 |
1481665 | 1481665 | 2021-07-03 | Wilson | Texas | 48493 | 4701 | 69 |
1476374 | 1476374 | 2021-07-02 | Des Moines | Iowa | 19057 | 4701 | 73 |
1478418 | 1478418 | 2021-07-02 | Wilson | Texas | 48493 | 4701 | 69 |
1460377 | 1460377 | 2021-06-27 | Hopkins | Kentucky | 21107 | 4701 | 149 |
1457132 | 1457132 | 2021-06-26 | Hopkins | Kentucky | 21107 | 4701 | 149 |
1453887 | 1453887 | 2021-06-25 | Hopkins | Kentucky | 21107 | 4701 | 149 |
1429821 | 1429821 | 2021-06-17 | Culpeper | Virginia | 51047 | 4701 | 67 |
1407834 | 1407834 | 2021-06-11 | Effingham | Georgia | 13103 | 4701 | 72 |
1379559 | 1379559 | 2021-06-02 | Mower | Minnesota | 27099 | 4701 | 33 |
1381372 | 1381372 | 2021-06-02 | Marinette | Wisconsin | 55075 | 4701 | 72 |
1376314 | 1376314 | 2021-06-01 | Mower | Minnesota | 27099 | 4701 | 33 |
1355410 | 1355410 | 2021-05-25 | Monroe | Wisconsin | 55081 | 4701 | 39 |
1337961 | 1337961 | 2021-05-20 | Richmond | North Carolina | 37153 | 4701 | 94 |
1328190 | 1328190 | 2021-05-17 | Hoke | North Carolina | 37093 | 4701 | 55 |
1325392 | 1325392 | 2021-05-16 | Toa Alta | Puerto Rico | 72135 | 4701 | |
1318636 | 1318636 | 2021-05-14 | Shelby | Ohio | 39149 | 4701 | 93 |
1315388 | 1315388 | 2021-05-13 | Shelby | Ohio | 39149 | 4701 | 93 |
1312142 | 1312142 | 2021-05-12 | Shelby | Ohio | 39149 | 4701 | 93 |
1279398 | 1279398 | 2021-05-02 | Clinton | New York | 36019 | 4701 | 33 |
1271396 | 1271396 | 2021-04-30 | Hendry | Florida | 12051 | 4701 | 82 |
1261229 | 1261229 | 2021-04-26 | Douglas | Wisconsin | 55031 | 4701 | 50 |
1204920 | 1204920 | 2021-04-09 | Auglaize | Ohio | 39011 | 4701 | 84 |
1194364 | 1194364 | 2021-04-06 | Cass | Michigan | 26027 | 4701 | 69 |
1154776 | 1154776 | 2021-03-25 | Jackson | Illinois | 17077 | 4701 | 73 |
1144634 | 1144634 | 2021-03-22 | Tehama | California | 6103 | 4701 | 45 |
1129253 | 1129253 | 2021-03-17 | Nelson | Kentucky | 21179 | 4701 | 44 |
1116187 | 1116187 | 2021-03-13 | Boyd | Kentucky | 21019 | 4701 | 47 |
1117241 | 1117241 | 2021-03-13 | Athens | Ohio | 39009 | 4701 | 50 |
1111953 | 1111953 | 2021-03-12 | Dale | Alabama | 1045 | 4701 | 108 |
1058850 | 1058850 | 2021-02-23 | Huron | Ohio | 39077 | 4701 | 117 |
1015737 | 1015737 | 2021-02-10 | Vermilion | Louisiana | 22113 | 4701 | 103 |
1002957 | 1002957 | 2021-02-06 | Otter Tail | Minnesota | 27111 | 4701 | 70 |
976867 | 976867 | 2021-01-29 | Clinton | Michigan | 26037 | 4701 | 63 |
977745 | 977745 | 2021-01-29 | Union | Ohio | 39159 | 4701 | 31 |
946877 | 946877 | 2021-01-20 | Laurens | Georgia | 13175 | 4701 | 129 |
947289 | 947289 | 2021-01-20 | Webster | Iowa | 19187 | 4701 | 72 |
942982 | 942982 | 2021-01-18 | Kitsap | Washington | 53035 | 4701 | 52 |
939737 | 939737 | 2021-01-17 | Kitsap | Washington | 53035 | 4701 | 52 |
909894 | 909894 | 2021-01-08 | Greenwood | South Carolina | 45047 | 4701 | 100 |
904963 | 904963 | 2021-01-07 | Marshall | Indiana | 18099 | 4701 | 83 |
890246 | 890246 | 2021-01-02 | Adams | Pennsylvania | 42001 | 4701 | 90 |
884754 | 884754 | 2021-01-01 | Colbert | Alabama | 1033 | 4701 | 60 |
876968 | 876968 | 2020-12-29 | Moore | North Carolina | 37125 | 4701 | 75 |
725086 | 725086 | 2020-11-12 | Washington | Tennessee | 47179 | 4701 | 84 |
688715 | 688715 | 2020-11-01 | Catawba | North Carolina | 37035 | 4701 | 62 |
622390 | 622390 | 2020-10-12 | Lowndes | Georgia | 13185 | 4701 | 85 |
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);