ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
157 rows where cases = 3429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 16
- Michigan 12
- Kentucky 10
- Arkansas 9
- Iowa 9
- Alabama 8
- Missouri 7
- Pennsylvania 7
- Virginia 7
- Ohio 6
- Oregon 6
- Texas 6
- Minnesota 5
- New Mexico 4
- New York 4
- Illinois 3
- Louisiana 3
- Nebraska 3
- North Carolina 3
- Puerto Rico 3
- Florida 2
- Idaho 2
- Maryland 2
- Massachusetts 2
- Mississippi 2
- Oklahoma 2
- South Carolina 2
- Tennessee 2
- Washington 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470048 | 2470048 | 2022-05-03 | Southampton | Virginia | 51175 | 3429 | 92 |
2466792 | 2466792 | 2022-05-02 | Southampton | Virginia | 51175 | 3429 | 92 |
2422671 | 2422671 | 2022-04-19 | Benzie | Michigan | 26019 | 3429 | 65 |
2419415 | 2419415 | 2022-04-18 | Benzie | Michigan | 26019 | 3429 | 65 |
2416159 | 2416159 | 2022-04-17 | Benzie | Michigan | 26019 | 3429 | 65 |
2412903 | 2412903 | 2022-04-16 | Benzie | Michigan | 26019 | 3429 | 65 |
2409647 | 2409647 | 2022-04-15 | Benzie | Michigan | 26019 | 3429 | 65 |
2406391 | 2406391 | 2022-04-14 | Benzie | Michigan | 26019 | 3429 | 65 |
2402578 | 2402578 | 2022-04-13 | Washington | Illinois | 17189 | 3429 | 41 |
2403135 | 2403135 | 2022-04-13 | Benzie | Michigan | 26019 | 3429 | 65 |
2324888 | 2324888 | 2022-03-20 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2321634 | 2321634 | 2022-03-19 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2318380 | 2318380 | 2022-03-18 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2315127 | 2315127 | 2022-03-17 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2311874 | 2311874 | 2022-03-16 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2308621 | 2308621 | 2022-03-15 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2305370 | 2305370 | 2022-03-14 | Pendleton | Kentucky | 21191 | 3429 | 37 |
2293663 | 2293663 | 2022-03-10 | San German | Puerto Rico | 72125 | 3429 | |
2265527 | 2265527 | 2022-03-02 | Las Animas | Colorado | 8071 | 3429 | 39 |
2262813 | 2262813 | 2022-03-01 | Clayton | Iowa | 19043 | 3429 | 72 |
2259562 | 2259562 | 2022-02-28 | Clayton | Iowa | 19043 | 3429 | 72 |
2260863 | 2260863 | 2022-02-28 | Monroe | Ohio | 39111 | 3429 | 75 |
2256311 | 2256311 | 2022-02-27 | Clayton | Iowa | 19043 | 3429 | 72 |
2257612 | 2257612 | 2022-02-27 | Monroe | Ohio | 39111 | 3429 | 75 |
2253060 | 2253060 | 2022-02-26 | Clayton | Iowa | 19043 | 3429 | 72 |
2254361 | 2254361 | 2022-02-26 | Monroe | Ohio | 39111 | 3429 | 75 |
2249173 | 2249173 | 2022-02-25 | Van Buren | Arkansas | 5141 | 3429 | 56 |
2249809 | 2249809 | 2022-02-25 | Clayton | Iowa | 19043 | 3429 | 72 |
2245922 | 2245922 | 2022-02-24 | Van Buren | Arkansas | 5141 | 3429 | 56 |
2246558 | 2246558 | 2022-02-24 | Clayton | Iowa | 19043 | 3429 | 72 |
2243307 | 2243307 | 2022-02-23 | Clayton | Iowa | 19043 | 3429 | 72 |
2237371 | 2237371 | 2022-02-21 | Pennington | Minnesota | 27113 | 3429 | 39 |
2238231 | 2238231 | 2022-02-21 | Hood River | Oregon | 41027 | 3429 | 42 |
2234120 | 2234120 | 2022-02-20 | Pennington | Minnesota | 27113 | 3429 | 39 |
2234980 | 2234980 | 2022-02-20 | Hood River | Oregon | 41027 | 3429 | 42 |
2230869 | 2230869 | 2022-02-19 | Pennington | Minnesota | 27113 | 3429 | 39 |
2231729 | 2231729 | 2022-02-19 | Hood River | Oregon | 41027 | 3429 | 42 |
2227618 | 2227618 | 2022-02-18 | Pennington | Minnesota | 27113 | 3429 | 39 |
2228478 | 2228478 | 2022-02-18 | Hood River | Oregon | 41027 | 3429 | 42 |
2178535 | 2178535 | 2022-02-03 | Monroe | Kentucky | 21171 | 3429 | 69 |
2148827 | 2148827 | 2022-01-25 | Massac | Illinois | 17127 | 3429 | 65 |
2076622 | 2076622 | 2022-01-03 | Cherokee | Alabama | 1019 | 3429 | 65 |
2075202 | 2075202 | 2022-01-02 | San Miguel | New Mexico | 35047 | 3429 | 34 |
2071951 | 2071951 | 2022-01-01 | San Miguel | New Mexico | 35047 | 3429 | 34 |
2068700 | 2068700 | 2021-12-31 | San Miguel | New Mexico | 35047 | 3429 | 34 |
2068751 | 2068751 | 2021-12-31 | Schoharie | New York | 36095 | 3429 | 29 |
2065449 | 2065449 | 2021-12-30 | San Miguel | New Mexico | 35047 | 3429 | 34 |
2059516 | 2059516 | 2021-12-28 | Vega Alta | Puerto Rico | 72143 | 3429 | |
2050661 | 2050661 | 2021-12-26 | Monroe | Alabama | 1099 | 3429 | 66 |
2028304 | 2028304 | 2021-12-19 | Elbert | Georgia | 13105 | 3429 | 92 |
2024731 | 2024731 | 2021-12-18 | Clark | Arkansas | 5019 | 3429 | 64 |
2025053 | 2025053 | 2021-12-18 | Elbert | Georgia | 13105 | 3429 | 92 |
2021802 | 2021802 | 2021-12-17 | Elbert | Georgia | 13105 | 3429 | 92 |
2018551 | 2018551 | 2021-12-16 | Elbert | Georgia | 13105 | 3429 | 92 |
2010904 | 2010904 | 2021-12-13 | Crockett | Tennessee | 47033 | 3429 | 65 |
2000936 | 2000936 | 2021-12-10 | Wyoming | Pennsylvania | 42131 | 3429 | 71 |
1995478 | 1995478 | 2021-12-09 | Columbia | Arkansas | 5027 | 3429 | 75 |
1996669 | 1996669 | 2021-12-09 | Roscommon | Michigan | 26143 | 3429 | 90 |
1997400 | 1997400 | 2021-12-09 | Rolette | North Dakota | 38079 | 3429 | 36 |
1993418 | 1993418 | 2021-12-08 | Roscommon | Michigan | 26143 | 3429 | 90 |
1991973 | 1991973 | 2021-12-07 | Lewis | West Virginia | 54041 | 3429 | 60 |
1985647 | 1985647 | 2021-12-06 | Marengo | Alabama | 1091 | 3429 | 93 |
1987494 | 1987494 | 2021-12-06 | Seneca | New York | 36099 | 3429 | 70 |
1982397 | 1982397 | 2021-12-05 | Marengo | Alabama | 1091 | 3429 | 93 |
1979147 | 1979147 | 2021-12-04 | Marengo | Alabama | 1091 | 3429 | 93 |
1966594 | 1966594 | 2021-11-30 | Mitchell | Georgia | 13205 | 3429 | 101 |
1943836 | 1943836 | 2021-11-23 | Mitchell | Georgia | 13205 | 3429 | 101 |
1940586 | 1940586 | 2021-11-22 | Mitchell | Georgia | 13205 | 3429 | 101 |
1941316 | 1941316 | 2021-11-22 | Somerset | Maryland | 24039 | 3429 | 54 |
1938154 | 1938154 | 2021-11-21 | Osceola | Michigan | 26133 | 3429 | 47 |
1934904 | 1934904 | 2021-11-20 | Osceola | Michigan | 26133 | 3429 | 47 |
1931654 | 1931654 | 2021-11-19 | Osceola | Michigan | 26133 | 3429 | 47 |
1917506 | 1917506 | 2021-11-15 | Ouachita | Arkansas | 5103 | 3429 | 85 |
1914256 | 1914256 | 2021-11-14 | Ouachita | Arkansas | 5103 | 3429 | 85 |
1915633 | 1915633 | 2021-11-14 | Henry | Missouri | 29083 | 3429 | 51 |
1911006 | 1911006 | 2021-11-13 | Ouachita | Arkansas | 5103 | 3429 | 85 |
1894392 | 1894392 | 2021-11-07 | Staunton city | Virginia | 51790 | 3429 | 81 |
1891142 | 1891142 | 2021-11-06 | Staunton city | Virginia | 51790 | 3429 | 81 |
1887892 | 1887892 | 2021-11-05 | Staunton city | Virginia | 51790 | 3429 | 81 |
1878823 | 1878823 | 2021-11-03 | Lamar | Georgia | 13171 | 3429 | 90 |
1856079 | 1856079 | 2021-10-27 | Jones | Georgia | 13169 | 3429 | 93 |
1811168 | 1811168 | 2021-10-13 | Hart | Kentucky | 21099 | 3429 | 61 |
1812439 | 1812439 | 2021-10-13 | Susquehanna | Pennsylvania | 42115 | 3429 | 65 |
1790271 | 1790271 | 2021-10-06 | Sevier | Utah | 49041 | 3429 | 16 |
1779319 | 1779319 | 2021-10-03 | Dawson | Nebraska | 31047 | 3429 | 33 |
1776069 | 1776069 | 2021-10-02 | Dawson | Nebraska | 31047 | 3429 | 33 |
1772819 | 1772819 | 2021-10-01 | Dawson | Nebraska | 31047 | 3429 | 33 |
1766860 | 1766860 | 2021-09-29 | Columbia | Oregon | 41009 | 3429 | 39 |
1745137 | 1745137 | 2021-09-23 | Barbour | Alabama | 1005 | 3429 | 69 |
1716475 | 1716475 | 2021-09-14 | Jefferson | Idaho | 16051 | 3429 | 33 |
1713073 | 1713073 | 2021-09-13 | Cook | Georgia | 13075 | 3429 | 50 |
1701774 | 1701774 | 2021-09-09 | Morrow | Ohio | 39117 | 3429 | 47 |
1693333 | 1693333 | 2021-09-07 | Sevier | Arkansas | 5133 | 3429 | 31 |
1677431 | 1677431 | 2021-09-02 | Tattnall | Georgia | 13267 | 3429 | 83 |
1625577 | 1625577 | 2021-08-17 | Iroquois | Illinois | 17075 | 3429 | 71 |
1611881 | 1611881 | 2021-08-12 | Juneau | Wisconsin | 55057 | 3429 | 31 |
1607013 | 1607013 | 2021-08-11 | McDonald | Missouri | 29119 | 3429 | 44 |
1604496 | 1604496 | 2021-08-10 | Greene | Pennsylvania | 42059 | 3429 | 42 |
1582888 | 1582888 | 2021-08-04 | Unknown | Arkansas | 3429 | 0 | |
1580954 | 1580954 | 2021-08-03 | Yazoo | Mississippi | 28163 | 3429 | 77 |
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);