ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where cases = 3646 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 13
- Indiana 12
- Texas 11
- Tennessee 10
- Michigan 9
- Minnesota 7
- Missouri 7
- Ohio 7
- Virginia 7
- Georgia 6
- Kentucky 6
- Puerto Rico 5
- South Dakota 5
- Illinois 4
- Mississippi 4
- Oklahoma 4
- West Virginia 4
- Wyoming 4
- Alabama 3
- Arkansas 3
- New Jersey 3
- New Mexico 3
- South Carolina 3
- California 2
- Louisiana 2
- Maine 2
- New York 2
- North Carolina 2
- Pennsylvania 2
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502817 | 2502817 | 2022-05-13 | Goshen | Wyoming | 56015 | 3646 | 57 |
2499559 | 2499559 | 2022-05-12 | Goshen | Wyoming | 56015 | 3646 | 57 |
2496301 | 2496301 | 2022-05-11 | Goshen | Wyoming | 56015 | 3646 | 57 |
2493043 | 2493043 | 2022-05-10 | Goshen | Wyoming | 56015 | 3646 | 57 |
2469390 | 2469390 | 2022-05-03 | Naguabo | Puerto Rico | 72103 | 3646 | |
2433585 | 2433585 | 2022-04-22 | Salinas | Puerto Rico | 72123 | 3646 | |
2326185 | 2326185 | 2022-03-20 | Quebradillas | Puerto Rico | 72115 | 3646 | |
2312380 | 2312380 | 2022-03-16 | Ste. Genevieve | Missouri | 29186 | 3646 | 39 |
2309127 | 2309127 | 2022-03-15 | Ste. Genevieve | Missouri | 29186 | 3646 | 39 |
2305875 | 2305875 | 2022-03-14 | Ste. Genevieve | Missouri | 29186 | 3646 | 39 |
2262839 | 2262839 | 2022-03-01 | Iowa | Iowa | 19095 | 3646 | 47 |
2259588 | 2259588 | 2022-02-28 | Iowa | Iowa | 19095 | 3646 | 47 |
2256337 | 2256337 | 2022-02-27 | Iowa | Iowa | 19095 | 3646 | 47 |
2253086 | 2253086 | 2022-02-26 | Iowa | Iowa | 19095 | 3646 | 47 |
2249835 | 2249835 | 2022-02-25 | Iowa | Iowa | 19095 | 3646 | 47 |
2246584 | 2246584 | 2022-02-24 | Iowa | Iowa | 19095 | 3646 | 47 |
2248734 | 2248734 | 2022-02-24 | King William | Virginia | 51101 | 3646 | 33 |
2243333 | 2243333 | 2022-02-23 | Iowa | Iowa | 19095 | 3646 | 47 |
2223047 | 2223047 | 2022-02-17 | Washington | Alabama | 1129 | 3646 | 53 |
2216010 | 2216010 | 2022-02-14 | Madison | Texas | 48313 | 3646 | 50 |
2204063 | 2204063 | 2022-02-11 | Minidoka | Idaho | 16067 | 3646 | 55 |
2199912 | 2199912 | 2022-02-09 | Buckingham | Virginia | 51029 | 3646 | 45 |
2191152 | 2191152 | 2022-02-07 | Wabash | Illinois | 17185 | 3646 | 24 |
2143996 | 2143996 | 2022-01-23 | Aguas Buenas | Puerto Rico | 72007 | 3646 | |
2118468 | 2118468 | 2022-01-15 | Shelby | Texas | 48419 | 3646 | 116 |
2113574 | 2113574 | 2022-01-14 | Knox | Maine | 23013 | 3646 | 20 |
2111392 | 2111392 | 2022-01-13 | Wasco | Oregon | 41065 | 3646 | 50 |
2111959 | 2111959 | 2022-01-13 | San Jacinto | Texas | 48407 | 3646 | 85 |
2112156 | 2112156 | 2022-01-13 | Prince Edward | Virginia | 51147 | 3646 | 54 |
2091228 | 2091228 | 2022-01-07 | Texas | Missouri | 29215 | 3646 | 74 |
2084376 | 2084376 | 2022-01-05 | Charlevoix | Michigan | 26029 | 3646 | 53 |
2081788 | 2081788 | 2022-01-04 | Caswell | North Carolina | 37033 | 3646 | 39 |
2074678 | 2074678 | 2022-01-02 | Roscommon | Michigan | 26143 | 3646 | 101 |
2076483 | 2076483 | 2022-01-02 | Lewis | West Virginia | 54041 | 3646 | 65 |
2071427 | 2071427 | 2022-01-01 | Roscommon | Michigan | 26143 | 3646 | 101 |
2073232 | 2073232 | 2022-01-01 | Lewis | West Virginia | 54041 | 3646 | 65 |
2068176 | 2068176 | 2021-12-31 | Roscommon | Michigan | 26143 | 3646 | 101 |
2069981 | 2069981 | 2021-12-31 | Lewis | West Virginia | 54041 | 3646 | 65 |
2064925 | 2064925 | 2021-12-30 | Roscommon | Michigan | 26143 | 3646 | 101 |
2066730 | 2066730 | 2021-12-30 | Lewis | West Virginia | 54041 | 3646 | 65 |
2061675 | 2061675 | 2021-12-29 | Roscommon | Michigan | 26143 | 3646 | 101 |
2062001 | 2062001 | 2021-12-29 | Lincoln | Montana | 30053 | 3646 | 73 |
2058370 | 2058370 | 2021-12-28 | Cheboygan | Michigan | 26031 | 3646 | 80 |
2055121 | 2055121 | 2021-12-27 | Cheboygan | Michigan | 26031 | 3646 | 80 |
2055440 | 2055440 | 2021-12-27 | Perry | Missouri | 29157 | 3646 | 40 |
2028643 | 2028643 | 2021-12-19 | Sullivan | Indiana | 18153 | 3646 | 58 |
2025392 | 2025392 | 2021-12-18 | Sullivan | Indiana | 18153 | 3646 | 58 |
2022141 | 2022141 | 2021-12-17 | Sullivan | Indiana | 18153 | 3646 | 58 |
2023660 | 2023660 | 2021-12-17 | Juniata | Pennsylvania | 42067 | 3646 | 141 |
2024128 | 2024128 | 2021-12-17 | Lampasas | Texas | 48281 | 3646 | 70 |
2020877 | 2020877 | 2021-12-16 | Lampasas | Texas | 48281 | 3646 | 70 |
2015286 | 2015286 | 2021-12-15 | Cook | Georgia | 13075 | 3646 | 65 |
1996710 | 1996710 | 2021-12-09 | Hubbard | Minnesota | 27057 | 3646 | 49 |
1991852 | 1991852 | 2021-12-07 | Louisa | Virginia | 51109 | 3646 | 53 |
1978552 | 1978552 | 2021-12-03 | Fayette | Texas | 48149 | 3646 | 93 |
1968736 | 1968736 | 2021-11-30 | Austin | Texas | 48015 | 3646 | 56 |
1927528 | 1927528 | 2021-11-18 | Dodge | Georgia | 13091 | 3646 | 128 |
1924894 | 1924894 | 2021-11-17 | Hart | Kentucky | 21099 | 3646 | 69 |
1901868 | 1901868 | 2021-11-10 | Randolph | Indiana | 18135 | 3646 | 105 |
1881749 | 1881749 | 2021-11-04 | Logan | Arkansas | 5083 | 3646 | 48 |
1878803 | 1878803 | 2021-11-03 | Grady | Georgia | 13131 | 3646 | 88 |
1852506 | 1852506 | 2021-10-26 | Lincoln | Arkansas | 5079 | 3646 | 57 |
1824171 | 1824171 | 2021-10-17 | Johnson | Kentucky | 21115 | 3646 | 46 |
1820922 | 1820922 | 2021-10-16 | Johnson | Kentucky | 21115 | 3646 | 46 |
1817673 | 1817673 | 2021-10-15 | Johnson | Kentucky | 21115 | 3646 | 46 |
1806097 | 1806097 | 2021-10-11 | Davison | South Dakota | 46035 | 3646 | 70 |
1802847 | 1802847 | 2021-10-10 | Davison | South Dakota | 46035 | 3646 | 70 |
1799598 | 1799598 | 2021-10-09 | Davison | South Dakota | 46035 | 3646 | 70 |
1796349 | 1796349 | 2021-10-08 | Davison | South Dakota | 46035 | 3646 | 70 |
1762147 | 1762147 | 2021-09-28 | Posey | Indiana | 18129 | 3646 | 41 |
1759206 | 1759206 | 2021-09-27 | Marion | Kentucky | 21155 | 3646 | 40 |
1744813 | 1744813 | 2021-09-22 | Accomack | Virginia | 51001 | 3646 | 63 |
1693390 | 1693390 | 2021-09-07 | Siskiyou | California | 6093 | 3646 | 42 |
1692206 | 1692206 | 2021-09-06 | Jefferson | Pennsylvania | 42065 | 3646 | 100 |
1677627 | 1677627 | 2021-09-02 | Daviess | Indiana | 18027 | 3646 | 104 |
1670857 | 1670857 | 2021-08-31 | Emanuel | Georgia | 13107 | 3646 | 87 |
1665380 | 1665380 | 2021-08-29 | Marion | Mississippi | 28091 | 3646 | 88 |
1662132 | 1662132 | 2021-08-28 | Marion | Mississippi | 28091 | 3646 | 88 |
1658884 | 1658884 | 2021-08-27 | Marion | Mississippi | 28091 | 3646 | 88 |
1658955 | 1658955 | 2021-08-27 | Dunklin | Missouri | 29069 | 3646 | 52 |
1649640 | 1649640 | 2021-08-24 | Macon | North Carolina | 37113 | 3646 | 41 |
1628241 | 1628241 | 2021-08-18 | Pike | Alabama | 1109 | 3646 | 81 |
1626755 | 1626755 | 2021-08-17 | Cibola | New Mexico | 35006 | 3646 | 128 |
1602944 | 1602944 | 2021-08-10 | Jefferson | Indiana | 18077 | 3646 | 88 |
1545830 | 1545830 | 2021-07-23 | Highland | Ohio | 39071 | 3646 | 68 |
1512049 | 1512049 | 2021-07-13 | Wabash | Indiana | 18169 | 3646 | 83 |
1512628 | 1512628 | 2021-07-13 | Lyon | Minnesota | 27083 | 3646 | 54 |
1509381 | 1509381 | 2021-07-12 | Lyon | Minnesota | 27083 | 3646 | 54 |
1506135 | 1506135 | 2021-07-11 | Lyon | Minnesota | 27083 | 3646 | 54 |
1502889 | 1502889 | 2021-07-10 | Lyon | Minnesota | 27083 | 3646 | 54 |
1499643 | 1499643 | 2021-07-09 | Lyon | Minnesota | 27083 | 3646 | 54 |
1467007 | 1467007 | 2021-06-29 | Oxford | Maine | 23017 | 3646 | 67 |
1462746 | 1462746 | 2021-06-28 | St. Francis | Arkansas | 5123 | 3646 | 44 |
1446120 | 1446120 | 2021-06-22 | Prince George | Virginia | 51149 | 3646 | 32 |
1406727 | 1406727 | 2021-06-10 | Macon | Tennessee | 47111 | 3646 | 78 |
1400236 | 1400236 | 2021-06-08 | Macon | Tennessee | 47111 | 3646 | 78 |
1393744 | 1393744 | 2021-06-06 | Macon | Tennessee | 47111 | 3646 | 78 |
1390499 | 1390499 | 2021-06-05 | Macon | Tennessee | 47111 | 3646 | 78 |
1387254 | 1387254 | 2021-06-04 | Macon | Tennessee | 47111 | 3646 | 78 |
1384009 | 1384009 | 2021-06-03 | Macon | Tennessee | 47111 | 3646 | 78 |
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);