ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 4371 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 13
- Indiana 12
- Illinois 10
- Colorado 8
- Oklahoma 7
- South Carolina 7
- Louisiana 6
- Mississippi 6
- North Carolina 6
- Virginia 6
- New York 5
- Ohio 5
- Michigan 4
- Missouri 4
- Nevada 4
- Utah 4
- Alabama 3
- Texas 3
- West Virginia 3
- Arkansas 2
- New Mexico 2
- Puerto Rico 2
- Wisconsin 2
- Arizona 1
- Florida 1
- Georgia 1
- Kentucky 1
- Maine 1
- Massachusetts 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473147 | 2473147 | 2022-05-04 | Duchesne | Utah | 49013 | 4371 | 27 |
2469891 | 2469891 | 2022-05-03 | Duchesne | Utah | 49013 | 4371 | 27 |
2376568 | 2376568 | 2022-04-05 | Franklin | Indiana | 18047 | 4371 | 65 |
2373316 | 2373316 | 2022-04-04 | Franklin | Indiana | 18047 | 4371 | 65 |
2353703 | 2353703 | 2022-03-29 | Hancock | Illinois | 17067 | 4371 | 58 |
2347198 | 2347198 | 2022-03-27 | Hancock | Illinois | 17067 | 4371 | 58 |
2343945 | 2343945 | 2022-03-26 | Hancock | Illinois | 17067 | 4371 | 58 |
2340692 | 2340692 | 2022-03-25 | Hancock | Illinois | 17067 | 4371 | 58 |
2337950 | 2337950 | 2022-03-24 | Jackson | Louisiana | 22049 | 4371 | 74 |
2324044 | 2324044 | 2022-03-20 | Chaffee | Colorado | 8015 | 4371 | 43 |
2320790 | 2320790 | 2022-03-19 | Chaffee | Colorado | 8015 | 4371 | 43 |
2317536 | 2317536 | 2022-03-18 | Chaffee | Colorado | 8015 | 4371 | 43 |
2314283 | 2314283 | 2022-03-17 | Chaffee | Colorado | 8015 | 4371 | 43 |
2314705 | 2314705 | 2022-03-17 | Piatt | Illinois | 17147 | 4371 | 29 |
2313721 | 2313721 | 2022-03-16 | Bristol city | Virginia | 51520 | 4371 | 76 |
2310468 | 2310468 | 2022-03-15 | Bristol city | Virginia | 51520 | 4371 | 76 |
2296873 | 2296873 | 2022-03-11 | Coamo | Puerto Rico | 72043 | 4371 | |
2256192 | 2256192 | 2022-02-27 | White | Illinois | 17193 | 4371 | 56 |
2252941 | 2252941 | 2022-02-26 | White | Illinois | 17193 | 4371 | 56 |
2249690 | 2249690 | 2022-02-25 | White | Illinois | 17193 | 4371 | 56 |
2242735 | 2242735 | 2022-02-23 | Alamosa | Colorado | 8003 | 4371 | 60 |
2243844 | 2243844 | 2022-02-23 | Houston | Minnesota | 27055 | 4371 | 18 |
2153678 | 2153678 | 2022-01-26 | Union | Oregon | 41061 | 4371 | 66 |
2149660 | 2149660 | 2022-01-25 | Winston | Mississippi | 28159 | 4371 | 96 |
2135259 | 2135259 | 2022-01-21 | Ashley | Arkansas | 5003 | 4371 | 56 |
2133153 | 2133153 | 2022-01-20 | Charlevoix | Michigan | 26029 | 4371 | 54 |
2092328 | 2092328 | 2022-01-07 | Frio | Texas | 48163 | 4371 | 79 |
2084681 | 2084681 | 2022-01-05 | McDonald | Missouri | 29119 | 4371 | 64 |
2086022 | 2086022 | 2022-01-05 | Unknown | Utah | 4371 | 59 | |
2081966 | 2081966 | 2022-01-04 | Holmes | Ohio | 39075 | 4371 | 157 |
2057798 | 2057798 | 2021-12-28 | Shelby | Illinois | 17173 | 4371 | 57 |
2056603 | 2056603 | 2021-12-27 | Hutchinson | Texas | 48233 | 4371 | 106 |
2026221 | 2026221 | 2021-12-18 | Washington | Missouri | 29221 | 4371 | 100 |
1992106 | 1992106 | 2021-12-08 | Bibb | Alabama | 1007 | 4371 | 95 |
1993337 | 1993337 | 2021-12-08 | Franklin | Massachusetts | 25011 | 4371 | 126 |
1989600 | 1989600 | 2021-12-07 | LaGrange | Indiana | 18087 | 4371 | 93 |
1982235 | 1982235 | 2021-12-04 | Nicholas | West Virginia | 54067 | 4371 | 67 |
1937570 | 1937570 | 2021-11-21 | Fayette | Indiana | 18041 | 4371 | 95 |
1934320 | 1934320 | 2021-11-20 | Fayette | Indiana | 18041 | 4371 | 95 |
1931069 | 1931069 | 2021-11-19 | Fayette | Indiana | 18041 | 4371 | 95 |
1925674 | 1925674 | 2021-11-17 | Luna | New Mexico | 35029 | 4371 | 96 |
1904210 | 1904210 | 2021-11-10 | Hancock | West Virginia | 54029 | 4371 | 117 |
1886941 | 1886941 | 2021-11-05 | Hardin | Ohio | 39065 | 4371 | 91 |
1877656 | 1877656 | 2021-11-02 | Grainger | Tennessee | 47057 | 4371 | 67 |
1863635 | 1863635 | 2021-10-29 | Dunklin | Missouri | 29069 | 4371 | 61 |
1856804 | 1856804 | 2021-10-27 | Somerset | Maine | 23025 | 4371 | 50 |
1855544 | 1855544 | 2021-10-26 | Lincoln | Wisconsin | 55069 | 4371 | 110 |
1834725 | 1834725 | 2021-10-20 | Greene | New York | 36039 | 4371 | 86 |
1834763 | 1834763 | 2021-10-20 | Wyoming | New York | 36121 | 4371 | 58 |
1814662 | 1814662 | 2021-10-14 | Mecosta | Michigan | 26107 | 4371 | 41 |
1811414 | 1811414 | 2021-10-13 | Mecosta | Michigan | 26107 | 4371 | 41 |
1808645 | 1808645 | 2021-10-12 | Nye | Nevada | 32023 | 4371 | 143 |
1782354 | 1782354 | 2021-10-04 | Simpson | Mississippi | 28127 | 4371 | 115 |
1778343 | 1778343 | 2021-10-03 | Daviess | Indiana | 18027 | 4371 | 112 |
1775093 | 1775093 | 2021-10-02 | Daviess | Indiana | 18027 | 4371 | 112 |
1771843 | 1771843 | 2021-10-01 | Daviess | Indiana | 18027 | 4371 | 112 |
1765769 | 1765769 | 2021-09-29 | Franklin | Louisiana | 22041 | 4371 | 135 |
1763033 | 1763033 | 2021-09-28 | Ravalli | Montana | 30081 | 4371 | 56 |
1748415 | 1748415 | 2021-09-24 | Geneva | Alabama | 1061 | 4371 | 116 |
1720280 | 1720280 | 2021-09-15 | East Feliciana | Louisiana | 22037 | 4371 | 136 |
1689062 | 1689062 | 2021-09-05 | Trujillo Alto | Puerto Rico | 72139 | 4371 | |
1678766 | 1678766 | 2021-09-02 | Columbia | New York | 36021 | 4371 | 105 |
1674451 | 1674451 | 2021-09-01 | Wabash | Indiana | 18169 | 4371 | 86 |
1675790 | 1675790 | 2021-09-01 | Preble | Ohio | 39135 | 4371 | 109 |
1676110 | 1676110 | 2021-09-01 | Marion | South Carolina | 45067 | 4371 | 113 |
1665694 | 1665694 | 2021-08-29 | Lyon | Nevada | 32019 | 4371 | 76 |
1662446 | 1662446 | 2021-08-28 | Lyon | Nevada | 32019 | 4371 | 76 |
1659198 | 1659198 | 2021-08-27 | Lyon | Nevada | 32019 | 4371 | 76 |
1627144 | 1627144 | 2021-08-17 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1623897 | 1623897 | 2021-08-16 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1620650 | 1620650 | 2021-08-15 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1617402 | 1617402 | 2021-08-14 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1614154 | 1614154 | 2021-08-13 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1610905 | 1610905 | 2021-08-12 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1611160 | 1611160 | 2021-08-12 | Williamsburg | South Carolina | 45089 | 4371 | 107 |
1607657 | 1607657 | 2021-08-11 | Okmulgee | Oklahoma | 40111 | 4371 | 88 |
1595982 | 1595982 | 2021-08-08 | La Plata | Colorado | 8067 | 4371 | 45 |
1592733 | 1592733 | 2021-08-07 | La Plata | Colorado | 8067 | 4371 | 45 |
1589484 | 1589484 | 2021-08-06 | La Plata | Colorado | 8067 | 4371 | 45 |
1577696 | 1577696 | 2021-08-02 | Union | Mississippi | 28145 | 4371 | 79 |
1528678 | 1528678 | 2021-07-18 | Webster | Louisiana | 22119 | 4371 | 115 |
1525431 | 1525431 | 2021-07-17 | Webster | Louisiana | 22119 | 4371 | 115 |
1522183 | 1522183 | 2021-07-16 | Webster | Louisiana | 22119 | 4371 | 115 |
1457588 | 1457588 | 2021-06-26 | Camden | Missouri | 29029 | 4371 | 89 |
1368239 | 1368239 | 2021-05-29 | Shenandoah | Virginia | 51171 | 4371 | 133 |
1347587 | 1347587 | 2021-05-23 | Fulton | New York | 36035 | 4371 | 91 |
1348303 | 1348303 | 2021-05-23 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1345055 | 1345055 | 2021-05-22 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1341807 | 1341807 | 2021-05-21 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1335332 | 1335332 | 2021-05-19 | Rhea | Tennessee | 47143 | 4371 | 75 |
1330221 | 1330221 | 2021-05-18 | Harrison | Indiana | 18061 | 4371 | 75 |
1332065 | 1332065 | 2021-05-18 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1332085 | 1332085 | 2021-05-18 | Rhea | Tennessee | 47143 | 4371 | 75 |
1328818 | 1328818 | 2021-05-17 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1325572 | 1325572 | 2021-05-16 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1320083 | 1320083 | 2021-05-15 | DeSoto | Florida | 12027 | 4371 | 93 |
1321617 | 1321617 | 2021-05-15 | Livingston | New York | 36051 | 4371 | 58 |
1322326 | 1322326 | 2021-05-15 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1319080 | 1319080 | 2021-05-14 | Lincoln | Tennessee | 47103 | 4371 | 63 |
1311955 | 1311955 | 2021-05-12 | Haywood | North Carolina | 37087 | 4371 | 96 |
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);