ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 5018 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 10
- South Carolina 8
- Illinois 7
- Kentucky 7
- Mississippi 7
- Indiana 6
- New Mexico 6
- North Carolina 6
- Wyoming 6
- Georgia 5
- Michigan 5
- Ohio 4
- Wisconsin 4
- Washington 3
- West Virginia 3
- Alabama 2
- Louisiana 2
- Missouri 2
- Nebraska 2
- Oregon 2
- Arkansas 1
- Colorado 1
- Minnesota 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- South Dakota 1
- Tennessee 1
- Texas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502612 | 2502612 | 2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 |
2485127 | 2485127 | 2022-05-08 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2481869 | 2481869 | 2022-05-07 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2478611 | 2478611 | 2022-05-06 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2475353 | 2475353 | 2022-05-05 | Roosevelt | New Mexico | 35041 | 5018 | 96 |
2472096 | 2472096 | 2022-05-04 | Roosevelt | New Mexico | 35041 | 5018 | 96 |
2446567 | 2446567 | 2022-04-26 | Coamo | Puerto Rico | 72043 | 5018 | |
2430926 | 2430926 | 2022-04-21 | King George | Virginia | 51099 | 5018 | 39 |
2381359 | 2381359 | 2022-04-06 | Union | Oregon | 41061 | 5018 | 76 |
2378104 | 2378104 | 2022-04-05 | Union | Oregon | 41061 | 5018 | 76 |
2360251 | 2360251 | 2022-03-31 | Pike | Illinois | 17149 | 5018 | 68 |
2356997 | 2356997 | 2022-03-30 | Pike | Illinois | 17149 | 5018 | 68 |
2353744 | 2353744 | 2022-03-29 | Pike | Illinois | 17149 | 5018 | 68 |
2350492 | 2350492 | 2022-03-28 | Pike | Illinois | 17149 | 5018 | 68 |
2256610 | 2256610 | 2022-02-27 | Wayne | Kentucky | 21231 | 5018 | 86 |
2253359 | 2253359 | 2022-02-26 | Wayne | Kentucky | 21231 | 5018 | 86 |
2250108 | 2250108 | 2022-02-25 | Wayne | Kentucky | 21231 | 5018 | 86 |
2229597 | 2229597 | 2022-02-19 | Ashley | Arkansas | 5003 | 5018 | 59 |
2224677 | 2224677 | 2022-02-17 | Dawson | Nebraska | 31047 | 5018 | 42 |
2221426 | 2221426 | 2022-02-16 | Dawson | Nebraska | 31047 | 5018 | 42 |
2191459 | 2191459 | 2022-02-07 | Adair | Kentucky | 21001 | 5018 | 95 |
2169113 | 2169113 | 2022-01-31 | Chickasaw | Mississippi | 28017 | 5018 | 81 |
2157438 | 2157438 | 2022-01-27 | Lampasas | Texas | 48281 | 5018 | 75 |
2152942 | 2152942 | 2022-01-26 | Crawford | Missouri | 29055 | 5018 | 87 |
2119632 | 2119632 | 2022-01-16 | LaGrange | Indiana | 18087 | 5018 | 98 |
2116380 | 2116380 | 2022-01-15 | LaGrange | Indiana | 18087 | 5018 | 98 |
2113129 | 2113129 | 2022-01-14 | LaGrange | Indiana | 18087 | 5018 | 98 |
2109898 | 2109898 | 2022-01-13 | Posey | Indiana | 18129 | 5018 | 46 |
2104230 | 2104230 | 2022-01-11 | Stoddard | Missouri | 29207 | 5018 | 112 |
2102358 | 2102358 | 2022-01-10 | Halifax | Virginia | 51083 | 5018 | 127 |
2085085 | 2085085 | 2022-01-05 | Montgomery | North Carolina | 37123 | 5018 | 110 |
2059561 | 2059561 | 2021-12-28 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2056312 | 2056312 | 2021-12-27 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2053063 | 2053063 | 2021-12-26 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2049813 | 2049813 | 2021-12-25 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2046563 | 2046563 | 2021-12-24 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2043313 | 2043313 | 2021-12-23 | Marlboro | South Carolina | 45069 | 5018 | 86 |
2020706 | 2020706 | 2021-12-16 | Overton | Tennessee | 47133 | 5018 | 89 |
2006591 | 2006591 | 2021-12-12 | Tippah | Mississippi | 28139 | 5018 | 84 |
2003340 | 2003340 | 2021-12-11 | Tippah | Mississippi | 28139 | 5018 | 84 |
2000090 | 2000090 | 2021-12-10 | Tippah | Mississippi | 28139 | 5018 | 84 |
1996148 | 1996148 | 2021-12-09 | Wells | Indiana | 18179 | 5018 | 109 |
1893307 | 1893307 | 2021-11-07 | Macon | North Carolina | 37113 | 5018 | 71 |
1890057 | 1890057 | 2021-11-06 | Macon | North Carolina | 37113 | 5018 | 71 |
1886807 | 1886807 | 2021-11-05 | Macon | North Carolina | 37113 | 5018 | 71 |
1862157 | 1862157 | 2021-10-29 | Pike | Alabama | 1109 | 5018 | 107 |
1855596 | 1855596 | 2021-10-26 | Park | Wyoming | 56029 | 5018 | 70 |
1826115 | 1826115 | 2021-10-17 | Manassas city | Virginia | 51683 | 5018 | 51 |
1822866 | 1822866 | 2021-10-16 | Manassas city | Virginia | 51683 | 5018 | 51 |
1819617 | 1819617 | 2021-10-15 | Manassas city | Virginia | 51683 | 5018 | 51 |
1813362 | 1813362 | 2021-10-13 | Teton | Wyoming | 56039 | 5018 | 13 |
1761188 | 1761188 | 2021-09-27 | York | Virginia | 51199 | 5018 | 68 |
1756145 | 1756145 | 2021-09-26 | Delta | Michigan | 26041 | 5018 | 99 |
1752897 | 1752897 | 2021-09-25 | Delta | Michigan | 26041 | 5018 | 99 |
1749649 | 1749649 | 2021-09-24 | Delta | Michigan | 26041 | 5018 | 99 |
1738496 | 1738496 | 2021-09-20 | Fayette | West Virginia | 54019 | 5018 | 98 |
1685281 | 1685281 | 2021-09-04 | Madison | New York | 36053 | 5018 | 91 |
1677655 | 1677655 | 2021-09-02 | Knox | Indiana | 18083 | 5018 | 96 |
1619881 | 1619881 | 2021-08-15 | Hancock | Mississippi | 28045 | 5018 | 90 |
1621434 | 1621434 | 2021-08-15 | James City | Virginia | 51095 | 5018 | 73 |
1616633 | 1616633 | 2021-08-14 | Hancock | Mississippi | 28045 | 5018 | 90 |
1618186 | 1618186 | 2021-08-14 | James City | Virginia | 51095 | 5018 | 73 |
1613385 | 1613385 | 2021-08-13 | Hancock | Mississippi | 28045 | 5018 | 90 |
1614938 | 1614938 | 2021-08-13 | James City | Virginia | 51095 | 5018 | 73 |
1606154 | 1606154 | 2021-08-11 | Woodford | Illinois | 17203 | 5018 | 96 |
1601858 | 1601858 | 2021-08-09 | Wasatch | Utah | 49051 | 5018 | 22 |
1565266 | 1565266 | 2021-07-29 | Stark | North Dakota | 38089 | 5018 | 52 |
1540407 | 1540407 | 2021-07-21 | Douglas | Wisconsin | 55031 | 5018 | 66 |
1537160 | 1537160 | 2021-07-20 | Douglas | Wisconsin | 55031 | 5018 | 66 |
1511788 | 1511788 | 2021-07-13 | Tift | Georgia | 13277 | 5018 | 133 |
1512312 | 1512312 | 2021-07-13 | Henderson | Kentucky | 21101 | 5018 | 79 |
1505307 | 1505307 | 2021-07-11 | Ware | Georgia | 13299 | 5018 | 182 |
1502061 | 1502061 | 2021-07-10 | Ware | Georgia | 13299 | 5018 | 182 |
1498815 | 1498815 | 2021-07-09 | Ware | Georgia | 13299 | 5018 | 182 |
1488788 | 1488788 | 2021-07-06 | Broomfield | Colorado | 8014 | 5018 | 76 |
1450758 | 1450758 | 2021-06-24 | St. Mary | Louisiana | 22101 | 5018 | 142 |
1428931 | 1428931 | 2021-06-17 | Auglaize | Ohio | 39011 | 5018 | 87 |
1374918 | 1374918 | 2021-05-31 | Campbell | Wyoming | 56005 | 5018 | 60 |
1371673 | 1371673 | 2021-05-30 | Campbell | Wyoming | 56005 | 5018 | 60 |
1368427 | 1368427 | 2021-05-29 | Campbell | Wyoming | 56005 | 5018 | 60 |
1365181 | 1365181 | 2021-05-28 | Campbell | Wyoming | 56005 | 5018 | 60 |
1201740 | 1201740 | 2021-04-08 | Seneca | Ohio | 39147 | 5018 | 113 |
1165175 | 1165175 | 2021-03-28 | Marquette | Michigan | 26103 | 5018 | 57 |
1161927 | 1161927 | 2021-03-27 | Marquette | Michigan | 26103 | 5018 | 57 |
1162734 | 1162734 | 2021-03-27 | Jefferson | Ohio | 39081 | 5018 | 144 |
1152709 | 1152709 | 2021-03-24 | Curry | New Mexico | 35009 | 5018 | 72 |
1141016 | 1141016 | 2021-03-20 | Harrison | West Virginia | 54033 | 5018 | 76 |
1132589 | 1132589 | 2021-03-18 | Vermilion | Louisiana | 22113 | 5018 | 110 |
1131300 | 1131300 | 2021-03-17 | Raleigh | West Virginia | 54081 | 5018 | 66 |
1076872 | 1076872 | 2021-03-01 | Knox | Illinois | 17095 | 5018 | 163 |
1055799 | 1055799 | 2021-02-22 | Indiana | Pennsylvania | 42063 | 5018 | 157 |
1049152 | 1049152 | 2021-02-20 | Union | Ohio | 39159 | 5018 | 52 |
1013778 | 1013778 | 2021-02-09 | Brown | South Dakota | 46013 | 5018 | 79 |
1011276 | 1011276 | 2021-02-08 | Shawano | Wisconsin | 55115 | 5018 | 80 |
1002919 | 1002919 | 2021-02-06 | Crow Wing | Minnesota | 27035 | 5018 | 79 |
972190 | 972190 | 2021-01-27 | Kitsap | Washington | 53035 | 5018 | 64 |
950725 | 950725 | 2021-01-21 | McCracken | Kentucky | 21145 | 5018 | 48 |
949562 | 949562 | 2021-01-20 | Columbia | Wisconsin | 55021 | 5018 | 44 |
944168 | 944168 | 2021-01-19 | Bullitt | Kentucky | 21029 | 5018 | 33 |
907462 | 907462 | 2021-01-08 | Blount | Alabama | 1009 | 5018 | 75 |
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);