ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where cases = 2337 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 17
- Kentucky 15
- Georgia 12
- Virginia 11
- Missouri 10
- Iowa 9
- Mississippi 9
- West Virginia 9
- Texas 8
- Indiana 7
- Kansas 7
- Minnesota 7
- Oklahoma 7
- Arkansas 6
- Montana 6
- Nebraska 6
- Alabama 5
- Idaho 5
- New York 5
- Ohio 5
- Puerto Rico 5
- Wisconsin 5
- Maryland 4
- North Carolina 4
- Oregon 4
- Colorado 3
- Florida 3
- Illinois 3
- Utah 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489439 | 2489439 | 2022-05-09 | Grand | Utah | 49019 | 2337 | 6 |
2479143 | 2479143 | 2022-05-06 | Hormigueros | Puerto Rico | 72067 | 2337 | |
2380773 | 2380773 | 2022-04-06 | Box Butte | Nebraska | 31013 | 2337 | 17 |
2377518 | 2377518 | 2022-04-05 | Box Butte | Nebraska | 31013 | 2337 | 17 |
2374265 | 2374265 | 2022-04-04 | Box Butte | Nebraska | 31013 | 2337 | 17 |
2375613 | 2375613 | 2022-04-04 | Poquoson city | Virginia | 51735 | 2337 | 30 |
2359432 | 2359432 | 2022-03-30 | Clay | West Virginia | 54015 | 2337 | 40 |
2356178 | 2356178 | 2022-03-29 | Clay | West Virginia | 54015 | 2337 | 40 |
2352925 | 2352925 | 2022-03-28 | Clay | West Virginia | 54015 | 2337 | 40 |
2313590 | 2313590 | 2022-03-16 | Parmer | Texas | 48369 | 2337 | 52 |
2302092 | 2302092 | 2022-03-13 | Livingston | Kentucky | 21139 | 2337 | 58 |
2298840 | 2298840 | 2022-03-12 | Livingston | Kentucky | 21139 | 2337 | 58 |
2295588 | 2295588 | 2022-03-11 | Livingston | Kentucky | 21139 | 2337 | 58 |
2292336 | 2292336 | 2022-03-10 | Livingston | Kentucky | 21139 | 2337 | 58 |
2289084 | 2289084 | 2022-03-09 | Livingston | Kentucky | 21139 | 2337 | 58 |
2285597 | 2285597 | 2022-03-08 | Guthrie | Iowa | 19077 | 2337 | 44 |
2285833 | 2285833 | 2022-03-08 | Livingston | Kentucky | 21139 | 2337 | 58 |
2282345 | 2282345 | 2022-03-07 | Guthrie | Iowa | 19077 | 2337 | 44 |
2282581 | 2282581 | 2022-03-07 | Livingston | Kentucky | 21139 | 2337 | 58 |
2279092 | 2279092 | 2022-03-06 | Guthrie | Iowa | 19077 | 2337 | 44 |
2275839 | 2275839 | 2022-03-05 | Guthrie | Iowa | 19077 | 2337 | 44 |
2272586 | 2272586 | 2022-03-04 | Guthrie | Iowa | 19077 | 2337 | 44 |
2269334 | 2269334 | 2022-03-03 | Guthrie | Iowa | 19077 | 2337 | 44 |
2266081 | 2266081 | 2022-03-02 | Guthrie | Iowa | 19077 | 2337 | 44 |
2245440 | 2245440 | 2022-02-23 | Charlotte | Virginia | 51037 | 2337 | 37 |
2239130 | 2239130 | 2022-02-21 | Ritchie | West Virginia | 54085 | 2337 | 29 |
2221269 | 2221269 | 2022-02-16 | Grundy | Missouri | 29079 | 2337 | 63 |
2218092 | 2218092 | 2022-02-15 | Wayne | Missouri | 29223 | 2337 | 44 |
2218107 | 2218107 | 2022-02-15 | Deer Lodge | Montana | 30023 | 2337 | 29 |
2200277 | 2200277 | 2022-02-10 | Sumter | Alabama | 1119 | 2337 | 44 |
2197023 | 2197023 | 2022-02-09 | Sumter | Alabama | 1119 | 2337 | 43 |
2174030 | 2174030 | 2022-02-01 | Pend Oreille | Washington | 53051 | 2337 | 29 |
2169195 | 2169195 | 2022-01-31 | Bollinger | Missouri | 29017 | 2337 | 35 |
2170778 | 2170778 | 2022-01-31 | Pend Oreille | Washington | 53051 | 2337 | 29 |
2159455 | 2159455 | 2022-01-28 | Douglas | Missouri | 29067 | 2337 | 68 |
2153391 | 2153391 | 2022-01-26 | Pamlico | North Carolina | 37137 | 2337 | 27 |
2150743 | 2150743 | 2022-01-25 | Lake | Tennessee | 47095 | 2337 | 34 |
2147491 | 2147491 | 2022-01-24 | Lake | Tennessee | 47095 | 2337 | 34 |
2142369 | 2142369 | 2022-01-23 | Brown | Indiana | 18013 | 2337 | 58 |
2144237 | 2144237 | 2022-01-23 | Lake | Tennessee | 47095 | 2337 | 34 |
2139114 | 2139114 | 2022-01-22 | Brown | Indiana | 18013 | 2337 | 58 |
2140982 | 2140982 | 2022-01-22 | Lake | Tennessee | 47095 | 2337 | 34 |
2135858 | 2135858 | 2022-01-21 | Brown | Indiana | 18013 | 2337 | 58 |
2137726 | 2137726 | 2022-01-21 | Lake | Tennessee | 47095 | 2337 | 34 |
2134472 | 2134472 | 2022-01-20 | Lake | Tennessee | 47095 | 2337 | 34 |
2131220 | 2131220 | 2022-01-19 | Lake | Tennessee | 47095 | 2337 | 34 |
2126338 | 2126338 | 2022-01-18 | Linn | Kansas | 20107 | 2337 | 23 |
2123086 | 2123086 | 2022-01-17 | Linn | Kansas | 20107 | 2337 | 23 |
2119834 | 2119834 | 2022-01-16 | Linn | Kansas | 20107 | 2337 | 23 |
2120918 | 2120918 | 2022-01-16 | McLean | North Dakota | 38055 | 2337 | 47 |
2116582 | 2116582 | 2022-01-15 | Linn | Kansas | 20107 | 2337 | 23 |
2113331 | 2113331 | 2022-01-14 | Linn | Kansas | 20107 | 2337 | 23 |
2101761 | 2101761 | 2022-01-10 | Naguabo | Puerto Rico | 72103 | 2337 | |
2086656 | 2086656 | 2022-01-06 | Moffat | Colorado | 8081 | 2337 | 49 |
2085996 | 2085996 | 2022-01-05 | Zapata | Texas | 48505 | 2337 | 46 |
2057881 | 2057881 | 2021-12-28 | Pulaski | Indiana | 18131 | 2337 | 69 |
2013265 | 2013265 | 2021-12-14 | Roosevelt | Montana | 30085 | 2337 | 68 |
2009840 | 2009840 | 2021-12-13 | Tallahatchie | Mississippi | 28135 | 2337 | 53 |
2001736 | 2001736 | 2021-12-10 | Monroe | West Virginia | 54063 | 2337 | 27 |
1995035 | 1995035 | 2021-12-08 | Alleghany | Virginia | 51005 | 2337 | 84 |
1988622 | 1988622 | 2021-12-06 | Patrick | Virginia | 51141 | 2337 | 60 |
1973265 | 1973265 | 2021-12-02 | Massac | Illinois | 17127 | 2337 | 57 |
1940676 | 1940676 | 2021-11-22 | Gooding | Idaho | 16047 | 2337 | 42 |
1937426 | 1937426 | 2021-11-21 | Gooding | Idaho | 16047 | 2337 | 42 |
1934176 | 1934176 | 2021-11-20 | Gooding | Idaho | 16047 | 2337 | 42 |
1926784 | 1926784 | 2021-11-17 | Bristol city | Virginia | 51520 | 2337 | 48 |
1904748 | 1904748 | 2021-11-11 | Bleckley | Georgia | 13023 | 2337 | 80 |
1901498 | 1901498 | 2021-11-10 | Bleckley | Georgia | 13023 | 2337 | 80 |
1850997 | 1850997 | 2021-10-25 | Schoharie | New York | 36095 | 2337 | 23 |
1837604 | 1837604 | 2021-10-21 | Yalobusha | Mississippi | 28161 | 2337 | 47 |
1832507 | 1832507 | 2021-10-19 | San Juan | Utah | 49037 | 2337 | 41 |
1810375 | 1810375 | 2021-10-13 | Crowley | Colorado | 8025 | 2337 | 22 |
1807929 | 1807929 | 2021-10-12 | Knott | Kentucky | 21119 | 2337 | 36 |
1805219 | 1805219 | 2021-10-11 | Ste. Genevieve | Missouri | 29186 | 2337 | 29 |
1801970 | 1801970 | 2021-10-10 | Ste. Genevieve | Missouri | 29186 | 2337 | 29 |
1777766 | 1777766 | 2021-10-03 | Howard | Arkansas | 5061 | 2337 | 30 |
1780175 | 1780175 | 2021-10-03 | Decatur | Tennessee | 47039 | 2337 | 42 |
1776925 | 1776925 | 2021-10-02 | Decatur | Tennessee | 47039 | 2337 | 42 |
1773675 | 1773675 | 2021-10-01 | Decatur | Tennessee | 47039 | 2337 | 42 |
1768778 | 1768778 | 2021-09-30 | Bourbon | Kansas | 20011 | 2337 | 41 |
1765529 | 1765529 | 2021-09-29 | Bourbon | Kansas | 20011 | 2337 | 41 |
1741591 | 1741591 | 2021-09-21 | Colonial Heights city | Virginia | 51570 | 2337 | 64 |
1724650 | 1724650 | 2021-09-16 | Wasco | Oregon | 41065 | 2337 | 39 |
1724846 | 1724846 | 2021-09-16 | Saluda | South Carolina | 45081 | 2337 | 50 |
1715313 | 1715313 | 2021-09-13 | Colorado | Texas | 48089 | 2337 | 41 |
1702213 | 1702213 | 2021-09-09 | Grundy | Tennessee | 47061 | 2337 | 36 |
1694372 | 1694372 | 2021-09-07 | Garrett | Maryland | 24023 | 2337 | 69 |
1682514 | 1682514 | 2021-09-03 | Corozal | Puerto Rico | 72047 | 2337 | |
1672609 | 1672609 | 2021-08-31 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1668733 | 1668733 | 2021-08-30 | Moniteau | Missouri | 29135 | 2337 | 34 |
1669361 | 1669361 | 2021-08-30 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1665489 | 1665489 | 2021-08-29 | Morgan | Missouri | 29141 | 2337 | 52 |
1666114 | 1666114 | 2021-08-29 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1662866 | 1662866 | 2021-08-28 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1663069 | 1663069 | 2021-08-28 | San Sebastian | Puerto Rico | 72131 | 2337 | |
1659618 | 1659618 | 2021-08-27 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1656369 | 1656369 | 2021-08-26 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1653122 | 1653122 | 2021-08-25 | Marshall | Oklahoma | 40095 | 2337 | 25 |
1650782 | 1650782 | 2021-08-24 | Boone | West Virginia | 54005 | 2337 | 36 |
1616783 | 1616783 | 2021-08-14 | Ray | Missouri | 29177 | 2337 | 37 |
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);