ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where cases = 2941 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 22
- Iowa 21
- Tennessee 15
- Texas 13
- South Dakota 12
- Minnesota 9
- Arkansas 8
- Missouri 8
- Virginia 7
- West Virginia 7
- Louisiana 6
- Ohio 6
- Alabama 5
- Kentucky 5
- Maine 5
- Michigan 5
- Mississippi 5
- North Carolina 5
- Georgia 4
- Illinois 4
- Puerto Rico 4
- California 3
- Maryland 3
- Wisconsin 3
- Florida 2
- Kansas 2
- Pennsylvania 2
- Arizona 1
- Colorado 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492281 | 2492281 | 2022-05-10 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2489023 | 2489023 | 2022-05-09 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2485766 | 2485766 | 2022-05-08 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2482508 | 2482508 | 2022-05-07 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2479250 | 2479250 | 2022-05-06 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2475992 | 2475992 | 2022-05-05 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2472735 | 2472735 | 2022-05-04 | Charles Mix | South Dakota | 46023 | 2941 | 35 |
2354978 | 2354978 | 2022-03-29 | Alleghany | North Carolina | 37005 | 2941 | 12 |
2351725 | 2351725 | 2022-03-28 | Alleghany | North Carolina | 37005 | 2941 | 12 |
2338132 | 2338132 | 2022-03-24 | Aitkin | Minnesota | 27001 | 2941 | 60 |
2288595 | 2288595 | 2022-03-09 | Idaho | Idaho | 16049 | 2941 | 51 |
2286173 | 2286173 | 2022-03-08 | Watonwan | Minnesota | 27165 | 2941 | 23 |
2282921 | 2282921 | 2022-03-07 | Watonwan | Minnesota | 27165 | 2941 | 23 |
2263459 | 2263459 | 2022-03-01 | Montgomery | Mississippi | 28097 | 2941 | 74 |
2210094 | 2210094 | 2022-02-13 | Bradley | Arkansas | 5011 | 2941 | 43 |
2199910 | 2199910 | 2022-02-09 | Brunswick | Virginia | 51025 | 2941 | 38 |
2165143 | 2165143 | 2022-01-30 | Blackford | Indiana | 18009 | 2941 | 63 |
2161888 | 2161888 | 2022-01-29 | Blackford | Indiana | 18009 | 2941 | 63 |
2158633 | 2158633 | 2022-01-28 | Blackford | Indiana | 18009 | 2941 | 63 |
2149012 | 2149012 | 2022-01-25 | Jefferson | Iowa | 19101 | 2941 | 47 |
2145760 | 2145760 | 2022-01-24 | Jefferson | Iowa | 19101 | 2941 | 47 |
2141813 | 2141813 | 2022-01-23 | Marion | Arkansas | 5089 | 2941 | 76 |
2142505 | 2142505 | 2022-01-23 | Jefferson | Iowa | 19101 | 2941 | 47 |
2139250 | 2139250 | 2022-01-22 | Jefferson | Iowa | 19101 | 2941 | 47 |
2135994 | 2135994 | 2022-01-21 | Jefferson | Iowa | 19101 | 2941 | 47 |
2132742 | 2132742 | 2022-01-20 | Jefferson | Iowa | 19101 | 2941 | 47 |
2129489 | 2129489 | 2022-01-19 | Jefferson | Iowa | 19101 | 2941 | 47 |
2131548 | 2131548 | 2022-01-19 | Unknown | Utah | 2941 | 57 | |
2122150 | 2122150 | 2022-01-17 | Cleburne | Alabama | 1029 | 2941 | 62 |
2100768 | 2100768 | 2022-01-10 | Renville | Minnesota | 27129 | 2941 | 52 |
2080000 | 2080000 | 2022-01-04 | Franklin | Arkansas | 5047 | 2941 | 59 |
2081060 | 2081060 | 2022-01-04 | Lincoln | Maine | 23015 | 2941 | 13 |
2057232 | 2057232 | 2021-12-28 | Clay | Arkansas | 5021 | 2941 | 77 |
1990053 | 1990053 | 2021-12-07 | Waldo | Maine | 23027 | 2941 | 36 |
1991480 | 1991480 | 2021-12-07 | Andrews | Texas | 48003 | 2941 | 65 |
1986368 | 1986368 | 2021-12-06 | Perry | Indiana | 18123 | 2941 | 57 |
1984912 | 1984912 | 2021-12-05 | Grundy | Tennessee | 47061 | 2941 | 43 |
1981662 | 1981662 | 2021-12-04 | Grundy | Tennessee | 47061 | 2941 | 43 |
1978412 | 1978412 | 2021-12-03 | Grundy | Tennessee | 47061 | 2941 | 43 |
1975162 | 1975162 | 2021-12-02 | Grundy | Tennessee | 47061 | 2941 | 43 |
1964375 | 1964375 | 2021-11-29 | Cooper | Missouri | 29053 | 2941 | 52 |
1965823 | 1965823 | 2021-11-29 | Fluvanna | Virginia | 51065 | 2941 | 28 |
1949622 | 1949622 | 2021-11-24 | Powhatan | Virginia | 51145 | 2941 | 28 |
1933727 | 1933727 | 2021-11-20 | Drew | Arkansas | 5043 | 2941 | 55 |
1927728 | 1927728 | 2021-11-18 | Hancock | Illinois | 17067 | 2941 | 45 |
1923748 | 1923748 | 2021-11-16 | Adams | Wisconsin | 55001 | 2941 | 35 |
1918433 | 1918433 | 2021-11-15 | Morgan | Kentucky | 21175 | 2941 | 10 |
1880646 | 1880646 | 2021-11-03 | Juniata | Pennsylvania | 42067 | 2941 | 116 |
1855744 | 1855744 | 2021-10-27 | Hempstead | Arkansas | 5057 | 2941 | 38 |
1854850 | 1854850 | 2021-10-26 | Hughes | South Dakota | 46065 | 2941 | 45 |
1855124 | 1855124 | 2021-10-26 | Lee | Texas | 48287 | 2941 | 50 |
1849134 | 1849134 | 2021-10-25 | Fayette | Alabama | 1057 | 2941 | 80 |
1845884 | 1845884 | 2021-10-24 | Fayette | Alabama | 1057 | 2941 | 80 |
1836871 | 1836871 | 2021-10-21 | Orange | Indiana | 18117 | 2941 | 69 |
1837418 | 1837418 | 2021-10-21 | Osceola | Michigan | 26133 | 2941 | 38 |
1834169 | 1834169 | 2021-10-20 | Osceola | Michigan | 26133 | 2941 | 38 |
1814580 | 1814580 | 2021-10-14 | Garrett | Maryland | 24023 | 2941 | 77 |
1811725 | 1811725 | 2021-10-13 | Vernon | Missouri | 29217 | 2941 | 64 |
1790165 | 1790165 | 2021-10-06 | Montague | Texas | 48337 | 2941 | 87 |
1784982 | 1784982 | 2021-10-05 | Mahaska | Iowa | 19123 | 2941 | 56 |
1787122 | 1787122 | 2021-10-05 | Louisa | Virginia | 51109 | 2941 | 41 |
1781733 | 1781733 | 2021-10-04 | Mahaska | Iowa | 19123 | 2941 | 56 |
1778483 | 1778483 | 2021-10-03 | Mahaska | Iowa | 19123 | 2941 | 56 |
1775233 | 1775233 | 2021-10-02 | Mahaska | Iowa | 19123 | 2941 | 56 |
1771983 | 1771983 | 2021-10-01 | Mahaska | Iowa | 19123 | 2941 | 56 |
1768734 | 1768734 | 2021-09-30 | Mahaska | Iowa | 19123 | 2941 | 56 |
1765485 | 1765485 | 2021-09-29 | Mahaska | Iowa | 19123 | 2941 | 56 |
1743314 | 1743314 | 2021-09-22 | Clay | Mississippi | 28025 | 2941 | 73 |
1736576 | 1736576 | 2021-09-20 | Aroostook | Maine | 23003 | 2941 | 68 |
1733326 | 1733326 | 2021-09-19 | Aroostook | Maine | 23003 | 2941 | 68 |
1730076 | 1730076 | 2021-09-18 | Aroostook | Maine | 23003 | 2941 | 68 |
1725002 | 1725002 | 2021-09-16 | Trousdale | Tennessee | 47169 | 2941 | 24 |
1715946 | 1715946 | 2021-09-14 | Pickens | Alabama | 1107 | 2941 | 65 |
1705238 | 1705238 | 2021-09-10 | Aguadilla | Puerto Rico | 72005 | 2941 | |
1690656 | 1690656 | 2021-09-06 | LaGrange | Indiana | 18087 | 2941 | 75 |
1690685 | 1690685 | 2021-09-06 | Spencer | Indiana | 18147 | 2941 | 32 |
1687406 | 1687406 | 2021-09-05 | LaGrange | Indiana | 18087 | 2941 | 75 |
1687435 | 1687435 | 2021-09-05 | Spencer | Indiana | 18147 | 2941 | 32 |
1684156 | 1684156 | 2021-09-04 | LaGrange | Indiana | 18087 | 2941 | 75 |
1684185 | 1684185 | 2021-09-04 | Spencer | Indiana | 18147 | 2941 | 32 |
1680905 | 1680905 | 2021-09-03 | LaGrange | Indiana | 18087 | 2941 | 75 |
1680934 | 1680934 | 2021-09-03 | Spencer | Indiana | 18147 | 2941 | 32 |
1651374 | 1651374 | 2021-08-25 | Fannin | Georgia | 13111 | 2941 | 77 |
1648749 | 1648749 | 2021-08-24 | Lincoln | Kentucky | 21137 | 2941 | 63 |
1630473 | 1630473 | 2021-08-18 | Elk | Pennsylvania | 42047 | 2941 | 41 |
1623028 | 1623028 | 2021-08-16 | Cass | Minnesota | 27021 | 2941 | 33 |
1619770 | 1619770 | 2021-08-15 | Wexford | Michigan | 26165 | 2941 | 48 |
1616522 | 1616522 | 2021-08-14 | Wexford | Michigan | 26165 | 2941 | 48 |
1613274 | 1613274 | 2021-08-13 | Wexford | Michigan | 26165 | 2941 | 48 |
1614305 | 1614305 | 2021-08-13 | Dorado | Puerto Rico | 72051 | 2941 | |
1610102 | 1610102 | 2021-08-12 | Todd | Minnesota | 27153 | 2941 | 33 |
1603326 | 1603326 | 2021-08-10 | Assumption | Louisiana | 22007 | 2941 | 38 |
1604287 | 1604287 | 2021-08-10 | Fayette | Ohio | 39047 | 2941 | 50 |
1598816 | 1598816 | 2021-08-08 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1595567 | 1595567 | 2021-08-07 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1592318 | 1592318 | 2021-08-06 | Greenbrier | West Virginia | 54025 | 2941 | 65 |
1572474 | 1572474 | 2021-07-31 | Kleberg | Texas | 48273 | 2941 | 95 |
1536697 | 1536697 | 2021-07-20 | Frio | Texas | 48163 | 2941 | 52 |
1532863 | 1532863 | 2021-07-19 | Morrow | Ohio | 39117 | 2941 | 43 |
1515661 | 1515661 | 2021-07-14 | Morehouse | Louisiana | 22067 | 2941 | 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);