ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
187 rows where cases = 2841 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Arkansas 13
- Indiana 13
- Louisiana 13
- Alabama 12
- Mississippi 12
- Tennessee 10
- Minnesota 9
- Missouri 9
- Virginia 9
- Georgia 7
- Texas 6
- Colorado 5
- Illinois 5
- Michigan 5
- West Virginia 5
- New York 4
- North Carolina 4
- South Dakota 4
- Ohio 3
- Kentucky 2
- Montana 2
- Oregon 2
- Pennsylvania 2
- Utah 2
- Washington 2
- Wisconsin 2
- Wyoming 2
- Arizona 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483584 | 2483584 | 2022-05-08 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2480326 | 2480326 | 2022-05-07 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2477068 | 2477068 | 2022-05-06 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2470553 | 2470553 | 2022-05-04 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2466746 | 2466746 | 2022-05-02 | Lexington city | Virginia | 51678 | 2841 | 40 |
2422254 | 2422254 | 2022-04-19 | Hancock | Iowa | 19081 | 2841 | 47 |
2418998 | 2418998 | 2022-04-18 | Hancock | Iowa | 19081 | 2841 | 47 |
2415742 | 2415742 | 2022-04-17 | Hancock | Iowa | 19081 | 2841 | 47 |
2412486 | 2412486 | 2022-04-16 | Hancock | Iowa | 19081 | 2841 | 47 |
2409230 | 2409230 | 2022-04-15 | Hancock | Iowa | 19081 | 2841 | 47 |
2405974 | 2405974 | 2022-04-14 | Hancock | Iowa | 19081 | 2841 | 47 |
2402718 | 2402718 | 2022-04-13 | Hancock | Iowa | 19081 | 2841 | 47 |
2365487 | 2365487 | 2022-04-01 | Callahan | Texas | 48059 | 2841 | 72 |
2326181 | 2326181 | 2022-03-20 | Orocovis | Puerto Rico | 72107 | 2841 | |
2310794 | 2310794 | 2022-03-16 | Conecuh | Alabama | 1035 | 2841 | 69 |
2307541 | 2307541 | 2022-03-15 | Conecuh | Alabama | 1035 | 2841 | 69 |
2304290 | 2304290 | 2022-03-14 | Conecuh | Alabama | 1035 | 2841 | 69 |
2301038 | 2301038 | 2022-03-13 | Conecuh | Alabama | 1035 | 2841 | 69 |
2297786 | 2297786 | 2022-03-12 | Conecuh | Alabama | 1035 | 2841 | 69 |
2294534 | 2294534 | 2022-03-11 | Conecuh | Alabama | 1035 | 2841 | 69 |
2291282 | 2291282 | 2022-03-10 | Conecuh | Alabama | 1035 | 2841 | 68 |
2269947 | 2269947 | 2022-03-03 | Jefferson Davis | Mississippi | 28065 | 2841 | 50 |
2232915 | 2232915 | 2022-02-20 | Stone | Arkansas | 5137 | 2841 | 58 |
2226383 | 2226383 | 2022-02-18 | Lee | Arkansas | 5077 | 2841 | 55 |
2219376 | 2219376 | 2022-02-15 | Morgan | Utah | 49029 | 2841 | 13 |
2201607 | 2201607 | 2022-02-10 | Pope | Minnesota | 27121 | 2841 | 17 |
2169182 | 2169182 | 2022-01-31 | Webster | Mississippi | 28155 | 2841 | 54 |
2148935 | 2148935 | 2022-01-25 | Pulaski | Indiana | 18131 | 2841 | 76 |
2151045 | 2151045 | 2022-01-25 | Zapata | Texas | 48505 | 2841 | 47 |
2136722 | 2136722 | 2022-01-21 | Osage | Missouri | 29151 | 2841 | 39 |
2133049 | 2133049 | 2022-01-20 | Madison | Louisiana | 22065 | 2841 | 56 |
2126227 | 2126227 | 2022-01-18 | Harrison | Iowa | 19085 | 2841 | 85 |
2126410 | 2126410 | 2022-01-18 | Carroll | Kentucky | 21041 | 2841 | 38 |
2126877 | 2126877 | 2022-01-18 | Walthall | Mississippi | 28147 | 2841 | 70 |
2122975 | 2122975 | 2022-01-17 | Harrison | Iowa | 19085 | 2841 | 85 |
2119723 | 2119723 | 2022-01-16 | Harrison | Iowa | 19085 | 2841 | 85 |
2116471 | 2116471 | 2022-01-15 | Harrison | Iowa | 19085 | 2841 | 85 |
2113220 | 2113220 | 2022-01-14 | Harrison | Iowa | 19085 | 2841 | 85 |
2109968 | 2109968 | 2022-01-13 | Harrison | Iowa | 19085 | 2841 | 85 |
2106717 | 2106717 | 2022-01-12 | Harrison | Iowa | 19085 | 2841 | 85 |
2074712 | 2074712 | 2022-01-02 | Faribault | Minnesota | 27043 | 2841 | 40 |
2071461 | 2071461 | 2022-01-01 | Faribault | Minnesota | 27043 | 2841 | 40 |
2068210 | 2068210 | 2021-12-31 | Faribault | Minnesota | 27043 | 2841 | 40 |
2064959 | 2064959 | 2021-12-30 | Faribault | Minnesota | 27043 | 2841 | 40 |
2043806 | 2043806 | 2021-12-23 | Buckingham | Virginia | 51029 | 2841 | 41 |
2037767 | 2037767 | 2021-12-22 | Madison | Arkansas | 5087 | 2841 | 44 |
2038759 | 2038759 | 2021-12-22 | Jackson | Louisiana | 22049 | 2841 | 64 |
2008491 | 2008491 | 2021-12-13 | Franklin | Arkansas | 5047 | 2841 | 56 |
2005240 | 2005240 | 2021-12-12 | Franklin | Arkansas | 5047 | 2841 | 56 |
2001989 | 2001989 | 2021-12-11 | Franklin | Arkansas | 5047 | 2841 | 56 |
1962137 | 1962137 | 2021-11-28 | Cannon | Tennessee | 47015 | 2841 | 44 |
1958886 | 1958886 | 2021-11-27 | Cannon | Tennessee | 47015 | 2841 | 44 |
1955635 | 1955635 | 2021-11-26 | Cannon | Tennessee | 47015 | 2841 | 44 |
1952384 | 1952384 | 2021-11-25 | Cannon | Tennessee | 47015 | 2841 | 44 |
1949133 | 1949133 | 2021-11-24 | Cannon | Tennessee | 47015 | 2841 | 44 |
1925367 | 1925367 | 2021-11-17 | Cooper | Missouri | 29053 | 2841 | 34 |
1917957 | 1917957 | 2021-11-15 | Clark | Illinois | 17023 | 2841 | 50 |
1898112 | 1898112 | 2021-11-09 | Elbert | Colorado | 8039 | 2841 | 23 |
1898545 | 1898545 | 2021-11-09 | White | Illinois | 17193 | 2841 | 43 |
1883602 | 1883602 | 2021-11-04 | Yancey | North Carolina | 37199 | 2841 | 32 |
1853615 | 1853615 | 2021-10-26 | Cheboygan | Michigan | 26031 | 2841 | 63 |
1850366 | 1850366 | 2021-10-25 | Cheboygan | Michigan | 26031 | 2841 | 63 |
1847379 | 1847379 | 2021-10-24 | Clinton | Missouri | 29049 | 2841 | 77 |
1844129 | 1844129 | 2021-10-23 | Clinton | Missouri | 29049 | 2841 | 77 |
1838845 | 1838845 | 2021-10-21 | Houston | Texas | 48225 | 2841 | 79 |
1759745 | 1759745 | 2021-09-27 | Big Horn | Montana | 30003 | 2841 | 80 |
1751801 | 1751801 | 2021-09-25 | Polk | Arkansas | 5113 | 2841 | 97 |
1742650 | 1742650 | 2021-09-22 | Owen | Indiana | 18119 | 2841 | 65 |
1712522 | 1712522 | 2021-09-12 | Mason | West Virginia | 54053 | 2841 | 41 |
1700306 | 1700306 | 2021-09-09 | Lawrence | Illinois | 17101 | 2841 | 38 |
1696847 | 1696847 | 2021-09-08 | Elbert | Georgia | 13105 | 2841 | 76 |
1689705 | 1689705 | 2021-09-05 | Staunton city | Virginia | 51790 | 2841 | 72 |
1686455 | 1686455 | 2021-09-04 | Staunton city | Virginia | 51790 | 2841 | 72 |
1683204 | 1683204 | 2021-09-03 | Staunton city | Virginia | 51790 | 2841 | 72 |
1655660 | 1655660 | 2021-08-26 | Tishomingo | Mississippi | 28141 | 2841 | 75 |
1654173 | 1654173 | 2021-08-25 | Uinta | Wyoming | 56041 | 2841 | 14 |
1646363 | 1646363 | 2021-08-23 | Dare | North Carolina | 37055 | 2841 | 10 |
1611646 | 1611646 | 2021-08-12 | Carroll | Virginia | 51035 | 2841 | 80 |
1577371 | 1577371 | 2021-08-02 | Richland | Louisiana | 22083 | 2841 | 58 |
1573735 | 1573735 | 2021-08-01 | Scott | Indiana | 18143 | 2841 | 60 |
1574421 | 1574421 | 2021-08-01 | Marion | Mississippi | 28091 | 2841 | 81 |
1570487 | 1570487 | 2021-07-31 | Scott | Indiana | 18143 | 2841 | 60 |
1571173 | 1571173 | 2021-07-31 | Marion | Mississippi | 28091 | 2841 | 81 |
1571582 | 1571582 | 2021-07-31 | Lewis | New York | 36049 | 2841 | 36 |
1567239 | 1567239 | 2021-07-30 | Scott | Indiana | 18143 | 2841 | 60 |
1567925 | 1567925 | 2021-07-30 | Marion | Mississippi | 28091 | 2841 | 81 |
1562764 | 1562764 | 2021-07-28 | Moore | Texas | 48341 | 2841 | 74 |
1540321 | 1540321 | 2021-07-21 | Okanogan | Washington | 53047 | 2841 | 42 |
1534469 | 1534469 | 2021-07-20 | Lee | Georgia | 13177 | 2841 | 59 |
1499775 | 1499775 | 2021-07-09 | Audrain | Missouri | 29007 | 2841 | 58 |
1488602 | 1488602 | 2021-07-06 | Winston | Alabama | 1133 | 2841 | 72 |
1485355 | 1485355 | 2021-07-05 | Winston | Alabama | 1133 | 2841 | 72 |
1482109 | 1482109 | 2021-07-04 | Winston | Alabama | 1133 | 2841 | 72 |
1482218 | 1482218 | 2021-07-04 | Sevier | Arkansas | 5133 | 2841 | 24 |
1478862 | 1478862 | 2021-07-03 | Winston | Alabama | 1133 | 2841 | 72 |
1478971 | 1478971 | 2021-07-03 | Sevier | Arkansas | 5133 | 2841 | 24 |
1475616 | 1475616 | 2021-07-02 | Winston | Alabama | 1133 | 2841 | 72 |
1475725 | 1475725 | 2021-07-02 | Sevier | Arkansas | 5133 | 2841 | 24 |
1438078 | 1438078 | 2021-06-20 | Prentiss | Mississippi | 28117 | 2841 | 61 |
1434831 | 1434831 | 2021-06-19 | Prentiss | Mississippi | 28117 | 2841 | 61 |
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);