ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4842 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 11
- Georgia 10
- Texas 9
- Illinois 8
- Kentucky 6
- Idaho 5
- Kansas 5
- Minnesota 5
- Tennessee 5
- Michigan 4
- New York 4
- North Carolina 4
- Alaska 3
- West Virginia 3
- Arkansas 2
- Florida 2
- Louisiana 2
- Mississippi 2
- Missouri 2
- Wisconsin 2
- Alabama 1
- Colorado 1
- Maine 1
- Maryland 1
- New Jersey 1
- New Mexico 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450685 | 2450685 | 2022-04-27 | Taylor | Wisconsin | 55119 | 4842 | 72 |
2428702 | 2428702 | 2022-04-21 | Rush | Indiana | 18139 | 4842 | 58 |
2424977 | 2424977 | 2022-04-20 | Teller | Colorado | 8119 | 4842 | 57 |
2425446 | 2425446 | 2022-04-20 | Rush | Indiana | 18139 | 4842 | 58 |
2408097 | 2408097 | 2022-04-14 | Colonial Heights city | Virginia | 51570 | 4842 | 96 |
2395846 | 2395846 | 2022-04-11 | Lamar | Georgia | 13171 | 4842 | 112 |
2392857 | 2392857 | 2022-04-10 | Jay | Indiana | 18075 | 4842 | 78 |
2389601 | 2389601 | 2022-04-09 | Jay | Indiana | 18075 | 4842 | 78 |
2386346 | 2386346 | 2022-04-08 | Jay | Indiana | 18075 | 4842 | 78 |
2379569 | 2379569 | 2022-04-06 | Lamar | Georgia | 13171 | 4842 | 112 |
2369810 | 2369810 | 2022-04-03 | Lamar | Georgia | 13171 | 4842 | 112 |
2366557 | 2366557 | 2022-04-02 | Lamar | Georgia | 13171 | 4842 | 112 |
2363304 | 2363304 | 2022-04-01 | Lamar | Georgia | 13171 | 4842 | 112 |
2288547 | 2288547 | 2022-03-09 | Union | Georgia | 13291 | 4842 | 149 |
2278999 | 2278999 | 2022-03-06 | Jay | Indiana | 18075 | 4842 | 77 |
2275746 | 2275746 | 2022-03-05 | Jay | Indiana | 18075 | 4842 | 77 |
2272493 | 2272493 | 2022-03-04 | Jay | Indiana | 18075 | 4842 | 77 |
2269241 | 2269241 | 2022-03-03 | Jay | Indiana | 18075 | 4842 | 77 |
2223712 | 2223712 | 2022-02-17 | Fulton | Indiana | 18049 | 4842 | 101 |
2193585 | 2193585 | 2022-02-07 | McDowell | West Virginia | 54047 | 4842 | 60 |
2168273 | 2168273 | 2022-01-31 | Jerome | Idaho | 16053 | 4842 | 59 |
2131758 | 2131758 | 2022-01-19 | Hampshire | West Virginia | 54027 | 4842 | 62 |
2123240 | 2123240 | 2022-01-17 | Rowan | Kentucky | 21205 | 4842 | 48 |
2119988 | 2119988 | 2022-01-16 | Rowan | Kentucky | 21205 | 4842 | 48 |
2122011 | 2122011 | 2022-01-16 | Mason | West Virginia | 54053 | 4842 | 74 |
2116736 | 2116736 | 2022-01-15 | Rowan | Kentucky | 21205 | 4842 | 48 |
2113485 | 2113485 | 2022-01-14 | Rowan | Kentucky | 21205 | 4842 | 48 |
2103210 | 2103210 | 2022-01-11 | Jefferson | Idaho | 16051 | 4842 | 55 |
2061034 | 2061034 | 2021-12-29 | Perry | Illinois | 17145 | 4842 | 90 |
2054008 | 2054008 | 2021-12-27 | Johnson | Arkansas | 5071 | 4842 | 61 |
2023489 | 2023489 | 2021-12-17 | Pike | Ohio | 39131 | 4842 | 79 |
2002041 | 2002041 | 2021-12-11 | Yell | Arkansas | 5149 | 4842 | 85 |
1996086 | 1996086 | 2021-12-09 | Greene | Indiana | 18055 | 4842 | 107 |
1997944 | 1997944 | 2021-12-09 | McNairy | Tennessee | 47109 | 4842 | 76 |
1993240 | 1993240 | 2021-12-08 | De Soto | Louisiana | 22031 | 4842 | 113 |
1994693 | 1994693 | 2021-12-08 | McNairy | Tennessee | 47109 | 4842 | 76 |
1987925 | 1987925 | 2021-12-06 | Susquehanna | Pennsylvania | 42115 | 4842 | 76 |
1943357 | 1943357 | 2021-11-23 | Clarke | Alabama | 1025 | 4842 | 86 |
1943731 | 1943731 | 2021-11-23 | Unknown | Florida | 4842 | 66 | |
1928478 | 1928478 | 2021-11-18 | Pine | Minnesota | 27115 | 4842 | 40 |
1875582 | 1875582 | 2021-11-02 | Lumpkin | Georgia | 13187 | 4842 | 107 |
1835951 | 1835951 | 2021-10-20 | Stevens | Washington | 53065 | 4842 | 84 |
1812351 | 1812351 | 2021-10-13 | Coos | Oregon | 41011 | 4842 | 91 |
1710358 | 1710358 | 2021-09-12 | Montgomery | Kansas | 20125 | 4842 | 97 |
1707111 | 1707111 | 2021-09-11 | Montgomery | Kansas | 20125 | 4842 | 97 |
1703863 | 1703863 | 2021-09-10 | Montgomery | Kansas | 20125 | 4842 | 97 |
1701528 | 1701528 | 2021-09-09 | Montgomery | New York | 36057 | 4842 | 132 |
1645111 | 1645111 | 2021-08-23 | Randolph | Illinois | 17157 | 4842 | 96 |
1627538 | 1627538 | 2021-08-17 | Rhea | Tennessee | 47143 | 4842 | 83 |
1609742 | 1609742 | 2021-08-12 | Graves | Kentucky | 21083 | 4842 | 100 |
1611348 | 1611348 | 2021-08-12 | Brown | Texas | 48049 | 4842 | 143 |
1608100 | 1608100 | 2021-08-11 | Brown | Texas | 48049 | 4842 | 143 |
1604745 | 1604745 | 2021-08-10 | Cocke | Tennessee | 47029 | 4842 | 102 |
1604851 | 1604851 | 2021-08-10 | Brown | Texas | 48049 | 4842 | 143 |
1599594 | 1599594 | 2021-08-09 | Jefferson | Illinois | 17081 | 4842 | 125 |
1600300 | 1600300 | 2021-08-09 | Douglas | Minnesota | 27041 | 4842 | 81 |
1600329 | 1600329 | 2021-08-09 | Mower | Minnesota | 27099 | 4842 | 34 |
1601602 | 1601602 | 2021-08-09 | Brown | Texas | 48049 | 4842 | 143 |
1598354 | 1598354 | 2021-08-08 | Brown | Texas | 48049 | 4842 | 143 |
1595105 | 1595105 | 2021-08-07 | Brown | Texas | 48049 | 4842 | 143 |
1591856 | 1591856 | 2021-08-06 | Brown | Texas | 48049 | 4842 | 143 |
1588497 | 1588497 | 2021-08-05 | Cheatham | Tennessee | 47021 | 4842 | 56 |
1550306 | 1550306 | 2021-07-25 | Kenai Peninsula Borough | Alaska | 2122 | 4842 | 19 |
1551820 | 1551820 | 2021-07-25 | Scott | Missouri | 29201 | 4842 | 88 |
1552150 | 1552150 | 2021-07-25 | Chatham | North Carolina | 37037 | 4842 | 89 |
1547059 | 1547059 | 2021-07-24 | Kenai Peninsula Borough | Alaska | 2122 | 4842 | 19 |
1548573 | 1548573 | 2021-07-24 | Scott | Missouri | 29201 | 4842 | 88 |
1548903 | 1548903 | 2021-07-24 | Chatham | North Carolina | 37037 | 4842 | 89 |
1543812 | 1543812 | 2021-07-23 | Kenai Peninsula Borough | Alaska | 2122 | 4842 | 19 |
1545656 | 1545656 | 2021-07-23 | Chatham | North Carolina | 37037 | 4842 | 89 |
1540109 | 1540109 | 2021-07-21 | Wilson | Texas | 48493 | 4842 | 71 |
1534432 | 1534432 | 2021-07-20 | Effingham | Georgia | 13103 | 4842 | 74 |
1531801 | 1531801 | 2021-07-19 | Jessamine | Kentucky | 21113 | 4842 | 74 |
1533945 | 1533945 | 2021-07-19 | Polk | Wisconsin | 55095 | 4842 | 65 |
1496380 | 1496380 | 2021-07-08 | Goodhue | Minnesota | 27049 | 4842 | 74 |
1485978 | 1485978 | 2021-07-05 | Stephenson | Illinois | 17177 | 4842 | 105 |
1482732 | 1482732 | 2021-07-04 | Stephenson | Illinois | 17177 | 4842 | 105 |
1479485 | 1479485 | 2021-07-03 | Stephenson | Illinois | 17177 | 4842 | 105 |
1476239 | 1476239 | 2021-07-02 | Stephenson | Illinois | 17177 | 4842 | 105 |
1450501 | 1450501 | 2021-06-24 | Crawford | Kansas | 20037 | 4842 | 83 |
1447256 | 1447256 | 2021-06-23 | Crawford | Kansas | 20037 | 4842 | 83 |
1447761 | 1447761 | 2021-06-23 | Bolivar | Mississippi | 28011 | 4842 | 133 |
1420799 | 1420799 | 2021-06-15 | Colquitt | Georgia | 13071 | 4842 | 127 |
1372996 | 1372996 | 2021-05-31 | Newaygo | Michigan | 26123 | 4842 | 66 |
1369751 | 1369751 | 2021-05-30 | Newaygo | Michigan | 26123 | 4842 | 66 |
1366505 | 1366505 | 2021-05-29 | Newaygo | Michigan | 26123 | 4842 | 66 |
1333387 | 1333387 | 2021-05-19 | Livingston | Illinois | 17105 | 4842 | 97 |
1313816 | 1313816 | 2021-05-13 | Bingham | Idaho | 16011 | 4842 | 74 |
1310569 | 1310569 | 2021-05-12 | Bingham | Idaho | 16011 | 4842 | 74 |
1296499 | 1296499 | 2021-05-07 | Harrison | Texas | 48203 | 4842 | 109 |
1284017 | 1284017 | 2021-05-03 | Campbell | Wyoming | 56005 | 4842 | 60 |
1257265 | 1257265 | 2021-04-25 | Newberry | South Carolina | 45071 | 4842 | 101 |
1235859 | 1235859 | 2021-04-19 | Tift | Georgia | 13277 | 4842 | 125 |
1237165 | 1237165 | 2021-04-19 | Otero | New Mexico | 35035 | 4842 | 74 |
1207969 | 1207969 | 2021-04-10 | Herkimer | New York | 36043 | 4842 | 107 |
1175524 | 1175524 | 2021-03-31 | Wayne | New York | 36117 | 4842 | 66 |
1171631 | 1171631 | 2021-03-30 | Branch | Michigan | 26023 | 4842 | 112 |
1080656 | 1080656 | 2021-03-02 | Androscoggin | Maine | 23001 | 4842 | 56 |
1077395 | 1077395 | 2021-03-01 | St. Martin | Louisiana | 22099 | 4842 | 112 |
1030437 | 1030437 | 2021-02-14 | Summit | Utah | 49043 | 4842 | 8 |
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);