ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
567 rows where cases = 756 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 47
- Texas 41
- Iowa 32
- South Dakota 32
- Indiana 31
- Kansas 28
- Arkansas 26
- Puerto Rico 26
- Georgia 24
- Missouri 19
- North Dakota 19
- Virginia 18
- Colorado 17
- Kentucky 17
- Oklahoma 16
- West Virginia 14
- Montana 12
- Louisiana 11
- Ohio 11
- Tennessee 11
- Michigan 9
- Nebraska 9
- Florida 8
- North Carolina 8
- Mississippi 7
- Pennsylvania 7
- Wyoming 7
- Alabama 6
- South Carolina 6
- Idaho 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500570 | 2500570 | 2022-05-13 | Trego | Kansas | 20195 | 756 | 10 |
2497312 | 2497312 | 2022-05-12 | Trego | Kansas | 20195 | 756 | 10 |
2494054 | 2494054 | 2022-05-11 | Trego | Kansas | 20195 | 756 | 10 |
2490796 | 2490796 | 2022-05-10 | Trego | Kansas | 20195 | 756 | 10 |
2487539 | 2487539 | 2022-05-09 | Trego | Kansas | 20195 | 756 | 10 |
2484281 | 2484281 | 2022-05-08 | Trego | Kansas | 20195 | 756 | 10 |
2481023 | 2481023 | 2022-05-07 | Trego | Kansas | 20195 | 756 | 10 |
2477765 | 2477765 | 2022-05-06 | Trego | Kansas | 20195 | 756 | 10 |
2338825 | 2338825 | 2022-03-24 | Eddy | North Dakota | 38027 | 756 | 6 |
2335571 | 2335571 | 2022-03-23 | Eddy | North Dakota | 38027 | 756 | 6 |
2332317 | 2332317 | 2022-03-22 | Eddy | North Dakota | 38027 | 756 | 6 |
2329064 | 2329064 | 2022-03-21 | Eddy | North Dakota | 38027 | 756 | 6 |
2325812 | 2325812 | 2022-03-20 | Eddy | North Dakota | 38027 | 756 | 6 |
2322559 | 2322559 | 2022-03-19 | Eddy | North Dakota | 38027 | 756 | 6 |
2319305 | 2319305 | 2022-03-18 | Eddy | North Dakota | 38027 | 756 | 6 |
2316051 | 2316051 | 2022-03-17 | Eddy | North Dakota | 38027 | 756 | 6 |
2312798 | 2312798 | 2022-03-16 | Eddy | North Dakota | 38027 | 756 | 6 |
2277042 | 2277042 | 2022-03-05 | Nelson | North Dakota | 38063 | 756 | 18 |
2273789 | 2273789 | 2022-03-04 | Nelson | North Dakota | 38063 | 756 | 18 |
2240901 | 2240901 | 2022-02-22 | Sweet Grass | Montana | 30097 | 756 | 9 |
2218946 | 2218946 | 2022-02-15 | Aurora | South Dakota | 46003 | 756 | 17 |
2173418 | 2173418 | 2022-02-01 | Clark | South Dakota | 46025 | 756 | 6 |
2157528 | 2157528 | 2022-01-27 | Upton | Texas | 48461 | 756 | 17 |
2123311 | 2123311 | 2022-01-17 | Tensas | Louisiana | 22107 | 756 | 10 |
2120059 | 2120059 | 2022-01-16 | Tensas | Louisiana | 22107 | 756 | 10 |
2116807 | 2116807 | 2022-01-15 | Tensas | Louisiana | 22107 | 756 | 10 |
2113556 | 2113556 | 2022-01-14 | Tensas | Louisiana | 22107 | 756 | 10 |
2107429 | 2107429 | 2022-01-12 | Knox | Missouri | 29103 | 756 | 10 |
2104178 | 2104178 | 2022-01-11 | Knox | Missouri | 29103 | 756 | 10 |
2100927 | 2100927 | 2022-01-10 | Knox | Missouri | 29103 | 756 | 8 |
2098815 | 2098815 | 2022-01-09 | Donley | Texas | 48129 | 756 | 18 |
2094098 | 2094098 | 2022-01-08 | Unknown | Maryland | 756 | 222 | |
2091642 | 2091642 | 2022-01-07 | Foster | North Dakota | 38031 | 756 | 19 |
2088197 | 2088197 | 2022-01-06 | Hidalgo | New Mexico | 35023 | 756 | 12 |
2059480 | 2059480 | 2021-12-28 | Jayuya | Puerto Rico | 72073 | 756 | |
2056231 | 2056231 | 2021-12-27 | Jayuya | Puerto Rico | 72073 | 756 | |
2052982 | 2052982 | 2021-12-26 | Jayuya | Puerto Rico | 72073 | 756 | |
2037094 | 2037094 | 2021-12-21 | Hemphill | Texas | 48211 | 756 | 3 |
2020820 | 2020820 | 2021-12-16 | Garza | Texas | 48169 | 756 | 24 |
2017569 | 2017569 | 2021-12-15 | Garza | Texas | 48169 | 756 | 24 |
2011914 | 2011914 | 2021-12-14 | Washington | Colorado | 8121 | 756 | 24 |
2014319 | 2014319 | 2021-12-14 | Garza | Texas | 48169 | 756 | 24 |
2010076 | 2010076 | 2021-12-13 | Johnson | Nebraska | 31097 | 756 | 10 |
2005412 | 2005412 | 2021-12-12 | Washington | Colorado | 8121 | 756 | 24 |
2002161 | 2002161 | 2021-12-11 | Washington | Colorado | 8121 | 756 | 24 |
1998911 | 1998911 | 2021-12-10 | Washington | Colorado | 8121 | 756 | 24 |
1995660 | 1995660 | 2021-12-09 | Washington | Colorado | 8121 | 756 | 24 |
1992409 | 1992409 | 2021-12-08 | Washington | Colorado | 8121 | 756 | 24 |
1994132 | 1994132 | 2021-12-08 | LaMoure | North Dakota | 38045 | 756 | 17 |
1984834 | 1984834 | 2021-12-05 | Deuel | South Dakota | 46039 | 756 | 11 |
1981584 | 1981584 | 2021-12-04 | Deuel | South Dakota | 46039 | 756 | 11 |
1978334 | 1978334 | 2021-12-03 | Deuel | South Dakota | 46039 | 756 | 11 |
1973592 | 1973592 | 2021-12-02 | Stafford | Kansas | 20185 | 756 | 19 |
1970342 | 1970342 | 2021-12-01 | Stafford | Kansas | 20185 | 756 | 19 |
1964606 | 1964606 | 2021-11-29 | Thayer | Nebraska | 31169 | 756 | 8 |
1942583 | 1942583 | 2021-11-22 | Gregory | South Dakota | 46053 | 756 | 30 |
1925465 | 1925465 | 2021-11-17 | Chouteau | Montana | 30015 | 756 | 8 |
1922772 | 1922772 | 2021-11-16 | Greer | Oklahoma | 40055 | 756 | 25 |
1919523 | 1919523 | 2021-11-15 | Greer | Oklahoma | 40055 | 756 | 25 |
1916273 | 1916273 | 2021-11-14 | Greer | Oklahoma | 40055 | 756 | 25 |
1913023 | 1913023 | 2021-11-13 | Greer | Oklahoma | 40055 | 756 | 25 |
1909773 | 1909773 | 2021-11-12 | Greer | Oklahoma | 40055 | 756 | 25 |
1906524 | 1906524 | 2021-11-11 | Greer | Oklahoma | 40055 | 756 | 25 |
1903275 | 1903275 | 2021-11-10 | Greer | Oklahoma | 40055 | 756 | 25 |
1849695 | 1849695 | 2021-10-25 | Lewis | Idaho | 16061 | 756 | 20 |
1852062 | 1852062 | 2021-10-25 | Covington city | Virginia | 51580 | 756 | 16 |
1838148 | 1838148 | 2021-10-21 | Pierce | North Dakota | 38069 | 756 | 27 |
1833114 | 1833114 | 2021-10-20 | Clear Creek | Colorado | 8019 | 756 | 5 |
1830570 | 1830570 | 2021-10-19 | Morris | Kansas | 20127 | 756 | 23 |
1831261 | 1831261 | 2021-10-19 | Pondera | Montana | 30073 | 756 | 4 |
1827321 | 1827321 | 2021-10-18 | Morris | Kansas | 20127 | 756 | 23 |
1815877 | 1815877 | 2021-10-14 | Moody | South Dakota | 46101 | 756 | 20 |
1811857 | 1811857 | 2021-10-13 | Pierce | Nebraska | 31139 | 756 | 21 |
1808532 | 1808532 | 2021-10-12 | Teton | Montana | 30099 | 756 | 7 |
1747165 | 1747165 | 2021-09-23 | McHenry | North Dakota | 38049 | 756 | 23 |
1744279 | 1744279 | 2021-09-22 | Sabana Grande | Puerto Rico | 72121 | 756 | |
1733073 | 1733073 | 2021-09-19 | Harper | Kansas | 20077 | 756 | 19 |
1734618 | 1734618 | 2021-09-19 | Day | South Dakota | 46037 | 756 | 30 |
1729823 | 1729823 | 2021-09-18 | Harper | Kansas | 20077 | 756 | 19 |
1731368 | 1731368 | 2021-09-18 | Day | South Dakota | 46037 | 756 | 30 |
1726573 | 1726573 | 2021-09-17 | Harper | Kansas | 20077 | 756 | 19 |
1728118 | 1728118 | 2021-09-17 | Day | South Dakota | 46037 | 756 | 30 |
1710369 | 1710369 | 2021-09-12 | Phillips | Kansas | 20147 | 756 | 25 |
1707122 | 1707122 | 2021-09-11 | Phillips | Kansas | 20147 | 756 | 25 |
1708193 | 1708193 | 2021-09-11 | Ransom | North Dakota | 38073 | 756 | 17 |
1703874 | 1703874 | 2021-09-10 | Phillips | Kansas | 20147 | 756 | 25 |
1695529 | 1695529 | 2021-09-07 | Lajas | Puerto Rico | 72079 | 756 | |
1692281 | 1692281 | 2021-09-06 | Lajas | Puerto Rico | 72079 | 756 | |
1686935 | 1686935 | 2021-09-05 | Kit Carson | Colorado | 8063 | 756 | 14 |
1689032 | 1689032 | 2021-09-05 | Lajas | Puerto Rico | 72079 | 756 | |
1683685 | 1683685 | 2021-09-04 | Kit Carson | Colorado | 8063 | 756 | 14 |
1685782 | 1685782 | 2021-09-04 | Lajas | Puerto Rico | 72079 | 756 | |
1680434 | 1680434 | 2021-09-03 | Kit Carson | Colorado | 8063 | 756 | 14 |
1682531 | 1682531 | 2021-09-03 | Lajas | Puerto Rico | 72079 | 756 | |
1678744 | 1678744 | 2021-09-02 | Quay | New Mexico | 35037 | 756 | 12 |
1679281 | 1679281 | 2021-09-02 | Lajas | Puerto Rico | 72079 | 756 | |
1650506 | 1650506 | 2021-08-24 | Sabine | Texas | 48403 | 756 | 48 |
1647370 | 1647370 | 2021-08-23 | Bland | Virginia | 51021 | 756 | 10 |
1637081 | 1637081 | 2021-08-20 | Santa Isabel | Puerto Rico | 72133 | 756 | |
1629215 | 1629215 | 2021-08-18 | Cumberland | Kentucky | 21057 | 756 | 14 |
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);