ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
123 rows where cases = 4070 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 15
- Ohio 11
- Oklahoma 9
- Alaska 8
- Illinois 8
- Minnesota 6
- North Carolina 6
- Pennsylvania 5
- Virginia 5
- California 4
- Indiana 4
- Kentucky 4
- Tennessee 4
- Arkansas 3
- Michigan 3
- Missouri 3
- Washington 3
- Alabama 2
- Colorado 2
- Georgia 2
- Nebraska 2
- New York 2
- Puerto Rico 2
- South Carolina 2
- Wisconsin 2
- Delaware 1
- Iowa 1
- Louisiana 1
- South Dakota 1
- Texas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463470 | 2463470 | 2022-05-01 | Giles | Virginia | 51071 | 4070 | 50 |
2460214 | 2460214 | 2022-04-30 | Giles | Virginia | 51071 | 4070 | 50 |
2456958 | 2456958 | 2022-04-29 | Giles | Virginia | 51071 | 4070 | 50 |
2415575 | 2415575 | 2022-04-17 | Moultrie | Illinois | 17139 | 4070 | 52 |
2412319 | 2412319 | 2022-04-16 | Moultrie | Illinois | 17139 | 4070 | 52 |
2409063 | 2409063 | 2022-04-15 | Moultrie | Illinois | 17139 | 4070 | 52 |
2396869 | 2396869 | 2022-04-11 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2393614 | 2393614 | 2022-04-10 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2390358 | 2390358 | 2022-04-09 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2387102 | 2387102 | 2022-04-08 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2383847 | 2383847 | 2022-04-07 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2380592 | 2380592 | 2022-04-06 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2377337 | 2377337 | 2022-04-05 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2374084 | 2374084 | 2022-04-04 | Yalobusha | Mississippi | 28161 | 4070 | 57 |
2256973 | 2256973 | 2022-02-27 | Smith | Mississippi | 28129 | 4070 | 66 |
2253722 | 2253722 | 2022-02-26 | Smith | Mississippi | 28129 | 4070 | 66 |
2250471 | 2250471 | 2022-02-25 | Smith | Mississippi | 28129 | 4070 | 66 |
2251286 | 2251286 | 2022-02-25 | Fulton | Pennsylvania | 42057 | 4070 | 64 |
2210061 | 2210061 | 2022-02-13 | North Slope Borough | Alaska | 2185 | 4070 | 10 |
2206808 | 2206808 | 2022-02-12 | North Slope Borough | Alaska | 2185 | 4070 | 10 |
2203555 | 2203555 | 2022-02-11 | North Slope Borough | Alaska | 2185 | 4070 | 10 |
2194825 | 2194825 | 2022-02-08 | Union | Kentucky | 21225 | 4070 | 53 |
2190747 | 2190747 | 2022-02-07 | Otero | Colorado | 8089 | 4070 | 125 |
2156111 | 2156111 | 2022-01-27 | Holmes | Mississippi | 28051 | 4070 | 96 |
2151958 | 2151958 | 2022-01-26 | Washington | Georgia | 13303 | 4070 | 128 |
2140010 | 2140010 | 2022-01-22 | Texas | Missouri | 29215 | 4070 | 79 |
2091483 | 2091483 | 2022-01-07 | Essex | New York | 36031 | 4070 | 48 |
2080645 | 2080645 | 2022-01-04 | Starke | Indiana | 18149 | 4070 | 84 |
2019168 | 2019168 | 2021-12-16 | Johnson | Kentucky | 21115 | 4070 | 75 |
2014184 | 2014184 | 2021-12-14 | Johnson | Tennessee | 47091 | 4070 | 54 |
2010776 | 2010776 | 2021-12-13 | Abbeville | South Carolina | 45001 | 4070 | 53 |
2001730 | 2001730 | 2021-12-10 | Mason | West Virginia | 54053 | 4070 | 63 |
1992225 | 1992225 | 2021-12-08 | Cleburne | Arkansas | 5023 | 4070 | 95 |
1994204 | 1994204 | 2021-12-08 | Holmes | Ohio | 39075 | 4070 | 143 |
1990846 | 1990846 | 2021-12-07 | Transylvania | North Carolina | 37175 | 4070 | 52 |
1883162 | 1883162 | 2021-11-04 | Miller | Missouri | 29131 | 4070 | 79 |
1788801 | 1788801 | 2021-10-06 | Coahoma | Mississippi | 28027 | 4070 | 103 |
1790106 | 1790106 | 2021-10-06 | Hockley | Texas | 48219 | 4070 | 128 |
1770378 | 1770378 | 2021-09-30 | Lawrence | South Dakota | 46081 | 4070 | 54 |
1753236 | 1753236 | 2021-09-25 | Stoddard | Missouri | 29207 | 4070 | 61 |
1732371 | 1732371 | 2021-09-19 | Siskiyou | California | 6093 | 4070 | 49 |
1735222 | 1735222 | 2021-09-19 | Okanogan | Washington | 53047 | 4070 | 51 |
1729121 | 1729121 | 2021-09-18 | Siskiyou | California | 6093 | 4070 | 49 |
1731972 | 1731972 | 2021-09-18 | Okanogan | Washington | 53047 | 4070 | 51 |
1725871 | 1725871 | 2021-09-17 | Siskiyou | California | 6093 | 4070 | 49 |
1728722 | 1728722 | 2021-09-17 | Okanogan | Washington | 53047 | 4070 | 51 |
1718017 | 1718017 | 2021-09-14 | Perry | Ohio | 39127 | 4070 | 51 |
1709517 | 1709517 | 2021-09-12 | Carroll | Arkansas | 5015 | 4070 | 64 |
1706183 | 1706183 | 2021-09-11 | Geneva | Alabama | 1061 | 4070 | 98 |
1708457 | 1708457 | 2021-09-11 | McKean | Pennsylvania | 42083 | 4070 | 76 |
1672864 | 1672864 | 2021-08-31 | Marlboro | South Carolina | 45069 | 4070 | 62 |
1665897 | 1665897 | 2021-08-29 | Person | North Carolina | 37145 | 4070 | 77 |
1662649 | 1662649 | 2021-08-28 | Person | North Carolina | 37145 | 4070 | 77 |
1659401 | 1659401 | 2021-08-27 | Person | North Carolina | 37145 | 4070 | 77 |
1643081 | 1643081 | 2021-08-22 | Warren | New York | 36113 | 4070 | 67 |
1625117 | 1625117 | 2021-08-17 | St. Francis | Arkansas | 5123 | 4070 | 48 |
1602272 | 1602272 | 2021-08-10 | Bethel Census Area | Alaska | 2050 | 4070 | 22 |
1599693 | 1599693 | 2021-08-09 | Jasper | Indiana | 18073 | 4070 | 59 |
1557376 | 1557376 | 2021-07-27 | Logan | Illinois | 17107 | 4070 | 79 |
1536941 | 1536941 | 2021-07-20 | Charlottesville city | Virginia | 51540 | 4070 | 58 |
1516584 | 1516584 | 2021-07-14 | Crawford | Ohio | 39033 | 4070 | 111 |
1513337 | 1513337 | 2021-07-13 | Crawford | Ohio | 39033 | 4070 | 111 |
1508512 | 1508512 | 2021-07-12 | Oconee | Georgia | 13219 | 4070 | 73 |
1510091 | 1510091 | 2021-07-12 | Crawford | Ohio | 39033 | 4070 | 111 |
1506844 | 1506844 | 2021-07-11 | Crawford | Ohio | 39033 | 4070 | 111 |
1503598 | 1503598 | 2021-07-10 | Crawford | Ohio | 39033 | 4070 | 111 |
1411967 | 1411967 | 2021-06-12 | Beltrami | Minnesota | 27007 | 4070 | 60 |
1408722 | 1408722 | 2021-06-11 | Beltrami | Minnesota | 27007 | 4070 | 60 |
1383752 | 1383752 | 2021-06-03 | Venango | Pennsylvania | 42121 | 4070 | 96 |
1364342 | 1364342 | 2021-05-28 | Ponce | Puerto Rico | 72113 | 4070 | |
1355525 | 1355525 | 2021-05-26 | Tallapoosa | Alabama | 1123 | 4070 | 153 |
1356736 | 1356736 | 2021-05-26 | Huron | Michigan | 26063 | 4070 | 77 |
1337983 | 1337983 | 2021-05-20 | Yadkin | North Carolina | 37197 | 4070 | 50 |
1330524 | 1330524 | 2021-05-18 | Franklin | Kentucky | 21073 | 4070 | 47 |
1308929 | 1308929 | 2021-05-11 | Custer | Oklahoma | 40039 | 4070 | 98 |
1305683 | 1305683 | 2021-05-10 | Custer | Oklahoma | 40039 | 4070 | 98 |
1302437 | 1302437 | 2021-05-09 | Custer | Oklahoma | 40039 | 4070 | 98 |
1299189 | 1299189 | 2021-05-08 | Custer | Oklahoma | 40039 | 4070 | 98 |
1295153 | 1295153 | 2021-05-07 | Nobles | Minnesota | 27105 | 4070 | 48 |
1295943 | 1295943 | 2021-05-07 | Custer | Oklahoma | 40039 | 4070 | 98 |
1292697 | 1292697 | 2021-05-06 | Custer | Oklahoma | 40039 | 4070 | 98 |
1289451 | 1289451 | 2021-05-05 | Custer | Oklahoma | 40039 | 4070 | 98 |
1285392 | 1285392 | 2021-05-04 | Isanti | Minnesota | 27059 | 4070 | 62 |
1275653 | 1275653 | 2021-05-01 | Itasca | Minnesota | 27061 | 4070 | 53 |
1268454 | 1268454 | 2021-04-29 | Lee | Illinois | 17103 | 4070 | 90 |
1237072 | 1237072 | 2021-04-19 | Platte | Nebraska | 31141 | 4070 | 48 |
1233825 | 1233825 | 2021-04-18 | Platte | Nebraska | 31141 | 4070 | 47 |
1223059 | 1223059 | 2021-04-15 | DeKalb | Indiana | 18033 | 4070 | 87 |
1202190 | 1202190 | 2021-04-08 | Marshall | Tennessee | 47117 | 4070 | 58 |
1195508 | 1195508 | 2021-04-06 | Toa Baja | Puerto Rico | 72137 | 4070 | |
1174264 | 1174264 | 2021-03-31 | Jefferson | Illinois | 17081 | 4070 | 119 |
1167206 | 1167206 | 2021-03-29 | Kenai Peninsula Borough | Alaska | 2122 | 4070 | 19 |
1169258 | 1169258 | 2021-03-29 | Putnam | Ohio | 39137 | 4070 | 98 |
1163958 | 1163958 | 2021-03-28 | Kenai Peninsula Borough | Alaska | 2122 | 4070 | 19 |
1164637 | 1164637 | 2021-03-28 | Montgomery | Indiana | 18107 | 4070 | 86 |
1160710 | 1160710 | 2021-03-27 | Kenai Peninsula Borough | Alaska | 2122 | 4070 | 19 |
1157462 | 1157462 | 2021-03-26 | Kenai Peninsula Borough | Alaska | 2122 | 4070 | 19 |
1148995 | 1148995 | 2021-03-23 | Goodhue | Minnesota | 27049 | 4070 | 69 |
1105653 | 1105653 | 2021-03-10 | Nevada | California | 6057 | 4070 | 74 |
1107539 | 1107539 | 2021-03-10 | Knox | Ohio | 39083 | 4070 | 106 |
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);