ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
239 rows where cases = 1930 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 29
- Michigan 25
- Iowa 16
- South Carolina 13
- Puerto Rico 11
- Arkansas 10
- Kentucky 10
- Virginia 10
- Georgia 8
- Kansas 8
- Alabama 7
- Missouri 7
- North Carolina 7
- Tennessee 7
- Wisconsin 7
- Idaho 6
- Mississippi 6
- Minnesota 5
- South Dakota 5
- Indiana 4
- West Virginia 4
- Colorado 3
- Louisiana 3
- North Dakota 3
- Ohio 3
- Washington 3
- Wyoming 3
- Illinois 2
- Montana 2
- Nebraska 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497290 | 2497290 | 2022-05-12 | Pratt | Kansas | 20151 | 1930 | 30 |
2494032 | 2494032 | 2022-05-11 | Pratt | Kansas | 20151 | 1930 | 30 |
2490774 | 2490774 | 2022-05-10 | Pratt | Kansas | 20151 | 1930 | 30 |
2487517 | 2487517 | 2022-05-09 | Pratt | Kansas | 20151 | 1930 | 30 |
2484259 | 2484259 | 2022-05-08 | Pratt | Kansas | 20151 | 1930 | 30 |
2481001 | 2481001 | 2022-05-07 | Pratt | Kansas | 20151 | 1930 | 30 |
2477743 | 2477743 | 2022-05-06 | Pratt | Kansas | 20151 | 1930 | 30 |
2293969 | 2293969 | 2022-03-10 | Floyd | Texas | 48153 | 1930 | 48 |
2290982 | 2290982 | 2022-03-09 | Falls Church city | Virginia | 51610 | 1930 | 16 |
2239189 | 2239189 | 2022-02-21 | Pepin | Wisconsin | 55091 | 1930 | 17 |
2216650 | 2216650 | 2022-02-15 | Prairie | Arkansas | 5117 | 1930 | 37 |
2203483 | 2203483 | 2022-02-11 | Choctaw | Alabama | 1023 | 1930 | 33 |
2202609 | 2202609 | 2022-02-10 | Patillas | Puerto Rico | 72109 | 1930 | |
2195082 | 2195082 | 2022-02-08 | Marshall | Minnesota | 27089 | 1930 | 23 |
2196238 | 2196238 | 2022-02-08 | Turner | South Dakota | 46125 | 1930 | 62 |
2191004 | 2191004 | 2022-02-07 | Wilcox | Georgia | 13315 | 1930 | 62 |
2187772 | 2187772 | 2022-02-06 | Boundary | Idaho | 16021 | 1930 | 55 |
2189730 | 2189730 | 2022-02-06 | Turner | South Dakota | 46125 | 1930 | 62 |
2184519 | 2184519 | 2022-02-05 | Boundary | Idaho | 16021 | 1930 | 55 |
2186477 | 2186477 | 2022-02-05 | Turner | South Dakota | 46125 | 1930 | 62 |
2183063 | 2183063 | 2022-02-04 | Guayanilla | Puerto Rico | 72059 | 1930 | |
2183225 | 2183225 | 2022-02-04 | Turner | South Dakota | 46125 | 1930 | 62 |
2171972 | 2171972 | 2022-02-01 | Cumberland | Kentucky | 21057 | 1930 | 23 |
2172062 | 2172062 | 2022-02-01 | Wolfe | Kentucky | 21237 | 1930 | 17 |
2153360 | 2153360 | 2022-01-26 | Graham | North Carolina | 37075 | 1930 | 30 |
2141179 | 2141179 | 2022-01-22 | Live Oak | Texas | 48297 | 1930 | 39 |
2135004 | 2135004 | 2022-01-20 | Clay | West Virginia | 54015 | 1930 | 30 |
2129217 | 2129217 | 2022-01-19 | Clearwater | Idaho | 16035 | 1930 | 29 |
2111422 | 2111422 | 2022-01-13 | Forest | Pennsylvania | 42053 | 1930 | 33 |
2083182 | 2083182 | 2022-01-05 | Wilcox | Alabama | 1131 | 1930 | 38 |
2076305 | 2076305 | 2022-01-02 | Brunswick | Virginia | 51025 | 1930 | 36 |
2073054 | 2073054 | 2022-01-01 | Brunswick | Virginia | 51025 | 1930 | 36 |
2069803 | 2069803 | 2021-12-31 | Brunswick | Virginia | 51025 | 1930 | 36 |
2058642 | 2058642 | 2021-12-28 | Douglas | Missouri | 29067 | 1930 | 66 |
2055393 | 2055393 | 2021-12-27 | Douglas | Missouri | 29067 | 1930 | 65 |
2019664 | 2019664 | 2021-12-16 | Lewis | Missouri | 29111 | 1930 | 30 |
2016495 | 2016495 | 2021-12-15 | Jefferson | Montana | 30043 | 1930 | 21 |
1999206 | 1999206 | 2021-12-10 | Washington | Idaho | 16087 | 1930 | 47 |
1995955 | 1995955 | 2021-12-09 | Washington | Idaho | 16087 | 1930 | 47 |
1992704 | 1992704 | 2021-12-08 | Washington | Idaho | 16087 | 1930 | 47 |
1935938 | 1935938 | 2021-11-20 | Cabo Rojo | Puerto Rico | 72023 | 1930 | |
1919686 | 1919686 | 2021-11-15 | Barranquitas | Puerto Rico | 72019 | 1930 | |
1883949 | 1883949 | 2021-11-04 | Cidra | Puerto Rico | 72041 | 1930 | |
1880696 | 1880696 | 2021-11-03 | Catano | Puerto Rico | 72033 | 1930 | |
1880700 | 1880700 | 2021-11-03 | Cidra | Puerto Rico | 72041 | 1930 | |
1856843 | 1856843 | 2021-10-27 | Nantucket | Massachusetts | 25019 | 1930 | 0 |
1833568 | 1833568 | 2021-10-20 | Blackford | Indiana | 18009 | 1930 | 42 |
1824456 | 1824456 | 2021-10-17 | Cottonwood | Minnesota | 27033 | 1930 | 27 |
1821207 | 1821207 | 2021-10-16 | Cottonwood | Minnesota | 27033 | 1930 | 27 |
1817958 | 1817958 | 2021-10-15 | Cottonwood | Minnesota | 27033 | 1930 | 27 |
1815357 | 1815357 | 2021-10-14 | Swain | North Carolina | 37173 | 1930 | 22 |
1807715 | 1807715 | 2021-10-12 | Jefferson | Iowa | 19101 | 1930 | 38 |
1810095 | 1810095 | 2021-10-12 | Big Horn | Wyoming | 56003 | 1930 | 46 |
1804464 | 1804464 | 2021-10-11 | Jefferson | Iowa | 19101 | 1930 | 38 |
1801215 | 1801215 | 2021-10-10 | Jefferson | Iowa | 19101 | 1930 | 38 |
1797966 | 1797966 | 2021-10-09 | Jefferson | Iowa | 19101 | 1930 | 38 |
1794717 | 1794717 | 2021-10-08 | Jefferson | Iowa | 19101 | 1930 | 38 |
1797001 | 1797001 | 2021-10-08 | Morgan | West Virginia | 54065 | 1930 | 39 |
1791469 | 1791469 | 2021-10-07 | Jefferson | Iowa | 19101 | 1930 | 38 |
1793854 | 1793854 | 2021-10-07 | Goshen | Wyoming | 56015 | 1930 | 33 |
1788220 | 1788220 | 2021-10-06 | Jefferson | Iowa | 19101 | 1930 | 38 |
1777741 | 1777741 | 2021-10-03 | Bradley | Arkansas | 5011 | 1930 | 37 |
1761529 | 1761529 | 2021-09-28 | Little River | Arkansas | 5081 | 1930 | 45 |
1764570 | 1764570 | 2021-09-28 | Marquette | Wisconsin | 55077 | 1930 | 29 |
1742920 | 1742920 | 2021-09-22 | Estill | Kentucky | 21065 | 1930 | 12 |
1740021 | 1740021 | 2021-09-21 | Pennington | Minnesota | 27113 | 1930 | 22 |
1730750 | 1730750 | 2021-09-18 | Essex | New York | 36031 | 1930 | 29 |
1696874 | 1696874 | 2021-09-08 | Jasper | Georgia | 13159 | 1930 | 43 |
1665478 | 1665478 | 2021-08-29 | Macon | Missouri | 29121 | 1930 | 19 |
1640809 | 1640809 | 2021-08-21 | Zapata | Texas | 48505 | 1930 | 38 |
1628148 | 1628148 | 2021-08-17 | Sawyer | Wisconsin | 55113 | 1930 | 29 |
1623173 | 1623173 | 2021-08-16 | Tallahatchie | Mississippi | 28135 | 1930 | 45 |
1623746 | 1623746 | 2021-08-16 | Walsh | North Dakota | 38099 | 1930 | 27 |
1619758 | 1619758 | 2021-08-15 | Roscommon | Michigan | 26143 | 1930 | 55 |
1620499 | 1620499 | 2021-08-15 | Walsh | North Dakota | 38099 | 1930 | 27 |
1616510 | 1616510 | 2021-08-14 | Roscommon | Michigan | 26143 | 1930 | 55 |
1613262 | 1613262 | 2021-08-13 | Roscommon | Michigan | 26143 | 1930 | 55 |
1603251 | 1603251 | 2021-08-10 | Harrison | Kentucky | 21097 | 1930 | 27 |
1536859 | 1536859 | 2021-07-20 | Wilbarger | Texas | 48487 | 1930 | 55 |
1533611 | 1533611 | 2021-07-19 | Wilbarger | Texas | 48487 | 1930 | 55 |
1530364 | 1530364 | 2021-07-18 | Wilbarger | Texas | 48487 | 1930 | 55 |
1526627 | 1526627 | 2021-07-17 | Manati | Puerto Rico | 72091 | 1930 | |
1527117 | 1527117 | 2021-07-17 | Wilbarger | Texas | 48487 | 1930 | 55 |
1520622 | 1520622 | 2021-07-15 | Wilbarger | Texas | 48487 | 1930 | 55 |
1517374 | 1517374 | 2021-07-14 | Wilbarger | Texas | 48487 | 1930 | 55 |
1514127 | 1514127 | 2021-07-13 | Wilbarger | Texas | 48487 | 1930 | 55 |
1497469 | 1497469 | 2021-07-08 | Hampton | South Carolina | 45049 | 1930 | 52 |
1492253 | 1492253 | 2021-07-07 | Jeff Davis | Georgia | 13161 | 1930 | 44 |
1494750 | 1494750 | 2021-07-07 | Fluvanna | Virginia | 51065 | 1930 | 20 |
1494805 | 1494805 | 2021-07-07 | Powhatan | Virginia | 51145 | 1930 | 17 |
1463825 | 1463825 | 2021-06-28 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1460580 | 1460580 | 2021-06-27 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1457335 | 1457335 | 2021-06-26 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1454090 | 1454090 | 2021-06-25 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1455727 | 1455727 | 2021-06-25 | San Juan | Utah | 49037 | 1930 | 37 |
1450845 | 1450845 | 2021-06-24 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1451818 | 1451818 | 2021-06-24 | Columbia | Oregon | 41009 | 1930 | 29 |
1447599 | 1447599 | 2021-06-23 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1444354 | 1444354 | 2021-06-22 | Cheboygan | Michigan | 26031 | 1930 | 46 |
1441109 | 1441109 | 2021-06-21 | Cheboygan | Michigan | 26031 | 1930 | 46 |
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);