ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 4758 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 39
- Illinois 10
- Georgia 9
- Indiana 9
- Iowa 8
- Wisconsin 8
- Virginia 7
- Mississippi 6
- Texas 6
- Minnesota 4
- Ohio 4
- Tennessee 4
- Arkansas 3
- Kentucky 3
- Oregon 3
- Alabama 2
- Florida 2
- Idaho 2
- Kansas 2
- Louisiana 2
- New Jersey 2
- Oklahoma 2
- California 1
- Colorado 1
- Michigan 1
- Nebraska 1
- New York 1
- North Carolina 1
- Pennsylvania 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471757 | 2471757 | 2022-05-04 | Andrew | Missouri | 29003 | 4758 | 56 |
2468501 | 2468501 | 2022-05-03 | Andrew | Missouri | 29003 | 4758 | 56 |
2465245 | 2465245 | 2022-05-02 | Andrew | Missouri | 29003 | 4758 | 56 |
2461990 | 2461990 | 2022-05-01 | Andrew | Missouri | 29003 | 4758 | 56 |
2458734 | 2458734 | 2022-04-30 | Andrew | Missouri | 29003 | 4758 | 56 |
2455478 | 2455478 | 2022-04-29 | Andrew | Missouri | 29003 | 4758 | 56 |
2452222 | 2452222 | 2022-04-28 | Andrew | Missouri | 29003 | 4758 | 56 |
2448966 | 2448966 | 2022-04-27 | Andrew | Missouri | 29003 | 4758 | 56 |
2444987 | 2444987 | 2022-04-26 | Starke | Indiana | 18149 | 4758 | 98 |
2445709 | 2445709 | 2022-04-26 | Andrew | Missouri | 29003 | 4758 | 56 |
2441731 | 2441731 | 2022-04-25 | Starke | Indiana | 18149 | 4758 | 98 |
2442454 | 2442454 | 2022-04-25 | Andrew | Missouri | 29003 | 4758 | 56 |
2439198 | 2439198 | 2022-04-24 | Andrew | Missouri | 29003 | 4758 | 56 |
2435942 | 2435942 | 2022-04-23 | Andrew | Missouri | 29003 | 4758 | 56 |
2432686 | 2432686 | 2022-04-22 | Andrew | Missouri | 29003 | 4758 | 56 |
2429430 | 2429430 | 2022-04-21 | Andrew | Missouri | 29003 | 4758 | 56 |
2426174 | 2426174 | 2022-04-20 | Andrew | Missouri | 29003 | 4758 | 56 |
2422918 | 2422918 | 2022-04-19 | Andrew | Missouri | 29003 | 4758 | 56 |
2419661 | 2419661 | 2022-04-18 | Andrew | Missouri | 29003 | 4758 | 56 |
2416406 | 2416406 | 2022-04-17 | Andrew | Missouri | 29003 | 4758 | 56 |
2413150 | 2413150 | 2022-04-16 | Andrew | Missouri | 29003 | 4758 | 56 |
2409894 | 2409894 | 2022-04-15 | Andrew | Missouri | 29003 | 4758 | 56 |
2406638 | 2406638 | 2022-04-14 | Andrew | Missouri | 29003 | 4758 | 56 |
2403382 | 2403382 | 2022-04-13 | Andrew | Missouri | 29003 | 4758 | 56 |
2400127 | 2400127 | 2022-04-12 | Andrew | Missouri | 29003 | 4758 | 56 |
2396872 | 2396872 | 2022-04-11 | Andrew | Missouri | 29003 | 4758 | 56 |
2393617 | 2393617 | 2022-04-10 | Andrew | Missouri | 29003 | 4758 | 56 |
2390361 | 2390361 | 2022-04-09 | Andrew | Missouri | 29003 | 4758 | 56 |
2387105 | 2387105 | 2022-04-08 | Andrew | Missouri | 29003 | 4758 | 56 |
2383850 | 2383850 | 2022-04-07 | Andrew | Missouri | 29003 | 4758 | 56 |
2380595 | 2380595 | 2022-04-06 | Andrew | Missouri | 29003 | 4758 | 56 |
2377340 | 2377340 | 2022-04-05 | Andrew | Missouri | 29003 | 4758 | 56 |
2374087 | 2374087 | 2022-04-04 | Andrew | Missouri | 29003 | 4758 | 56 |
2370835 | 2370835 | 2022-04-03 | Andrew | Missouri | 29003 | 4758 | 56 |
2367582 | 2367582 | 2022-04-02 | Andrew | Missouri | 29003 | 4758 | 56 |
2364329 | 2364329 | 2022-04-01 | Andrew | Missouri | 29003 | 4758 | 56 |
2361075 | 2361075 | 2022-03-31 | Andrew | Missouri | 29003 | 4758 | 56 |
2359025 | 2359025 | 2022-03-30 | Fayette | Texas | 48149 | 4758 | 104 |
2316332 | 2316332 | 2022-03-17 | Juniata | Pennsylvania | 42067 | 4758 | 175 |
2301185 | 2301185 | 2022-03-13 | Phillips | Arkansas | 5107 | 4758 | 96 |
2240155 | 2240155 | 2022-02-22 | Dickinson | Kansas | 20041 | 4758 | 72 |
2236904 | 2236904 | 2022-02-21 | Dickinson | Kansas | 20041 | 4758 | 72 |
2213196 | 2213196 | 2022-02-13 | Taylor | Wisconsin | 55119 | 4758 | 66 |
2209943 | 2209943 | 2022-02-12 | Taylor | Wisconsin | 55119 | 4758 | 66 |
2206690 | 2206690 | 2022-02-11 | Taylor | Wisconsin | 55119 | 4758 | 66 |
2194521 | 2194521 | 2022-02-08 | Carroll | Iowa | 19027 | 4758 | 61 |
2191267 | 2191267 | 2022-02-07 | Carroll | Iowa | 19027 | 4758 | 61 |
2188014 | 2188014 | 2022-02-06 | Carroll | Iowa | 19027 | 4758 | 61 |
2184761 | 2184761 | 2022-02-05 | Carroll | Iowa | 19027 | 4758 | 61 |
2181509 | 2181509 | 2022-02-04 | Carroll | Iowa | 19027 | 4758 | 61 |
2178258 | 2178258 | 2022-02-03 | Carroll | Iowa | 19027 | 4758 | 61 |
2175005 | 2175005 | 2022-02-02 | Carroll | Iowa | 19027 | 4758 | 61 |
2125675 | 2125675 | 2022-01-18 | Montezuma | Colorado | 8083 | 4758 | 59 |
2040746 | 2040746 | 2021-12-22 | Nicholas | West Virginia | 54067 | 4758 | 74 |
2019712 | 2019712 | 2021-12-16 | Stoddard | Missouri | 29207 | 4758 | 108 |
2015542 | 2015542 | 2021-12-15 | Saline | Illinois | 17165 | 4758 | 90 |
2005821 | 2005821 | 2021-12-12 | Clay | Indiana | 18021 | 4758 | 63 |
2002570 | 2002570 | 2021-12-11 | Clay | Indiana | 18021 | 4758 | 63 |
1999320 | 1999320 | 2021-12-10 | Clay | Indiana | 18021 | 4758 | 63 |
1987691 | 1987691 | 2021-12-06 | Gallia | Ohio | 39053 | 4758 | 78 |
1973398 | 1973398 | 2021-12-02 | White | Indiana | 18181 | 4758 | 71 |
1966897 | 1966897 | 2021-11-30 | Wells | Indiana | 18179 | 4758 | 103 |
1967191 | 1967191 | 2021-11-30 | Montgomery | Kentucky | 21173 | 4758 | 63 |
1968673 | 1968673 | 2021-11-30 | Hickman | Tennessee | 47081 | 4758 | 78 |
1941237 | 1941237 | 2021-11-22 | Franklin | Louisiana | 22041 | 4758 | 140 |
1937452 | 1937452 | 2021-11-21 | Bureau | Illinois | 17011 | 4758 | 110 |
1938321 | 1938321 | 2021-11-21 | Scott | Mississippi | 28123 | 4758 | 99 |
1934202 | 1934202 | 2021-11-20 | Bureau | Illinois | 17011 | 4758 | 110 |
1935071 | 1935071 | 2021-11-20 | Scott | Mississippi | 28123 | 4758 | 99 |
1930951 | 1930951 | 2021-11-19 | Bureau | Illinois | 17011 | 4758 | 110 |
1931821 | 1931821 | 2021-11-19 | Scott | Mississippi | 28123 | 4758 | 99 |
1928570 | 1928570 | 2021-11-18 | Scott | Mississippi | 28123 | 4758 | 99 |
1925320 | 1925320 | 2021-11-17 | Scott | Mississippi | 28123 | 4758 | 98 |
1922071 | 1922071 | 2021-11-16 | Scott | Mississippi | 28123 | 4758 | 98 |
1904412 | 1904412 | 2021-11-11 | Winston | Alabama | 1133 | 4758 | 105 |
1895074 | 1895074 | 2021-11-08 | Lee | Georgia | 13177 | 4758 | 80 |
1890217 | 1890217 | 2021-11-06 | Morrow | Ohio | 39117 | 4758 | 60 |
1876983 | 1876983 | 2021-11-02 | Otsego | New York | 36077 | 4758 | 56 |
1849118 | 1849118 | 2021-10-25 | Clarke | Alabama | 1025 | 4758 | 84 |
1807302 | 1807302 | 2021-10-12 | Decatur | Georgia | 13087 | 4758 | 95 |
1778294 | 1778294 | 2021-10-03 | Montgomery | Illinois | 17135 | 4758 | 83 |
1775044 | 1775044 | 2021-10-02 | Montgomery | Illinois | 17135 | 4758 | 83 |
1771794 | 1771794 | 2021-10-01 | Montgomery | Illinois | 17135 | 4758 | 83 |
1732673 | 1732673 | 2021-09-19 | Unknown | Georgia | 4758 | 14 | |
1734389 | 1734389 | 2021-09-19 | Malheur | Oregon | 41045 | 4758 | 67 |
1729423 | 1729423 | 2021-09-18 | Unknown | Georgia | 4758 | 14 | |
1731139 | 1731139 | 2021-09-18 | Malheur | Oregon | 41045 | 4758 | 67 |
1726173 | 1726173 | 2021-09-17 | Unknown | Georgia | 4758 | 14 | |
1726748 | 1726748 | 2021-09-17 | Taylor | Kentucky | 21217 | 4758 | 71 |
1727889 | 1727889 | 2021-09-17 | Malheur | Oregon | 41045 | 4758 | 67 |
1718941 | 1718941 | 2021-09-14 | Tazewell | Virginia | 51185 | 4758 | 83 |
1674332 | 1674332 | 2021-09-01 | Morgan | Illinois | 17137 | 4758 | 117 |
1669627 | 1669627 | 2021-08-30 | Williamsburg | South Carolina | 45089 | 4758 | 109 |
1654356 | 1654356 | 2021-08-26 | Union | Arkansas | 5139 | 4758 | 118 |
1609457 | 1609457 | 2021-08-12 | Montgomery | Indiana | 18107 | 4758 | 95 |
1608031 | 1608031 | 2021-08-11 | Lincoln | Tennessee | 47103 | 4758 | 69 |
1596183 | 1596183 | 2021-08-08 | Liberty | Georgia | 13179 | 4758 | 69 |
1592934 | 1592934 | 2021-08-07 | Liberty | Georgia | 13179 | 4758 | 69 |
1589685 | 1589685 | 2021-08-06 | Liberty | Georgia | 13179 | 4758 | 69 |
1569203 | 1569203 | 2021-07-30 | Howard | Texas | 48227 | 4758 | 103 |
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);