ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
344 rows where cases = 1301 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 37
- Texas 21
- Kentucky 17
- North Dakota 17
- Illinois 15
- Kansas 14
- Missouri 14
- Utah 14
- Minnesota 12
- Georgia 11
- Puerto Rico 10
- Alabama 9
- Arkansas 9
- Indiana 9
- Ohio 9
- Oklahoma 9
- Virginia 9
- New Mexico 8
- South Dakota 8
- West Virginia 8
- Florida 7
- Tennessee 7
- Michigan 6
- Mississippi 6
- New York 6
- North Carolina 5
- South Carolina 5
- Wisconsin 5
- Maine 4
- Alaska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502496 | 2502496 | 2022-05-13 | Essex | Vermont | 50009 | 1301 | 3 |
2426863 | 2426863 | 2022-04-20 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2423607 | 2423607 | 2022-04-19 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2420350 | 2420350 | 2022-04-18 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2420951 | 2420951 | 2022-04-18 | McCulloch | Texas | 48307 | 1301 | 47 |
2417095 | 2417095 | 2022-04-17 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2417695 | 2417695 | 2022-04-17 | McCulloch | Texas | 48307 | 1301 | 47 |
2413839 | 2413839 | 2022-04-16 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2414439 | 2414439 | 2022-04-16 | McCulloch | Texas | 48307 | 1301 | 47 |
2410583 | 2410583 | 2022-04-15 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2411183 | 2411183 | 2022-04-15 | McCulloch | Texas | 48307 | 1301 | 47 |
2407327 | 2407327 | 2022-04-14 | Jefferson | Oklahoma | 40067 | 1301 | 28 |
2407927 | 2407927 | 2022-04-14 | McCulloch | Texas | 48307 | 1301 | 47 |
2404671 | 2404671 | 2022-04-13 | McCulloch | Texas | 48307 | 1301 | 47 |
2401416 | 2401416 | 2022-04-12 | McCulloch | Texas | 48307 | 1301 | 47 |
2384383 | 2384383 | 2022-04-07 | McHenry | North Dakota | 38049 | 1301 | 31 |
2381128 | 2381128 | 2022-04-06 | McHenry | North Dakota | 38049 | 1301 | 31 |
2377873 | 2377873 | 2022-04-05 | McHenry | North Dakota | 38049 | 1301 | 31 |
2374620 | 2374620 | 2022-04-04 | McHenry | North Dakota | 38049 | 1301 | 31 |
2371368 | 2371368 | 2022-04-03 | McHenry | North Dakota | 38049 | 1301 | 31 |
2368115 | 2368115 | 2022-04-02 | McHenry | North Dakota | 38049 | 1301 | 31 |
2364862 | 2364862 | 2022-04-01 | McHenry | North Dakota | 38049 | 1301 | 31 |
2338836 | 2338836 | 2022-03-24 | McHenry | North Dakota | 38049 | 1301 | 31 |
2335582 | 2335582 | 2022-03-23 | McHenry | North Dakota | 38049 | 1301 | 31 |
2332328 | 2332328 | 2022-03-22 | McHenry | North Dakota | 38049 | 1301 | 31 |
2329075 | 2329075 | 2022-03-21 | McHenry | North Dakota | 38049 | 1301 | 31 |
2325823 | 2325823 | 2022-03-20 | McHenry | North Dakota | 38049 | 1301 | 31 |
2322570 | 2322570 | 2022-03-19 | McHenry | North Dakota | 38049 | 1301 | 31 |
2319316 | 2319316 | 2022-03-18 | McHenry | North Dakota | 38049 | 1301 | 31 |
2312809 | 2312809 | 2022-03-16 | McHenry | North Dakota | 38049 | 1301 | 31 |
2313796 | 2313796 | 2022-03-16 | Norton city | Virginia | 51720 | 1301 | 22 |
2264522 | 2264522 | 2022-03-01 | Walworth | South Dakota | 46129 | 1301 | 25 |
2261272 | 2261272 | 2022-02-28 | Walworth | South Dakota | 46129 | 1301 | 25 |
2258021 | 2258021 | 2022-02-27 | Walworth | South Dakota | 46129 | 1301 | 25 |
2254770 | 2254770 | 2022-02-26 | Walworth | South Dakota | 46129 | 1301 | 25 |
2251519 | 2251519 | 2022-02-25 | Walworth | South Dakota | 46129 | 1301 | 25 |
2245017 | 2245017 | 2022-02-23 | Walworth | South Dakota | 46129 | 1301 | 24 |
2157449 | 2157449 | 2022-01-27 | Lynn | Texas | 48305 | 1301 | 31 |
2122295 | 2122295 | 2022-01-17 | Montgomery | Arkansas | 5097 | 1301 | 53 |
2102256 | 2102256 | 2022-01-10 | Beaver | Utah | 49001 | 1301 | 14 |
2099005 | 2099005 | 2022-01-09 | Beaver | Utah | 49001 | 1301 | 14 |
2095753 | 2095753 | 2022-01-08 | Beaver | Utah | 49001 | 1301 | 14 |
2092501 | 2092501 | 2022-01-07 | Beaver | Utah | 49001 | 1301 | 14 |
2083743 | 2083743 | 2022-01-05 | Edwards | Illinois | 17047 | 1301 | 23 |
2074891 | 2074891 | 2022-01-02 | Daviess | Missouri | 29061 | 1301 | 17 |
2071640 | 2071640 | 2022-01-01 | Daviess | Missouri | 29061 | 1301 | 17 |
2068389 | 2068389 | 2021-12-31 | Daviess | Missouri | 29061 | 1301 | 17 |
2065138 | 2065138 | 2021-12-30 | Daviess | Missouri | 29061 | 1301 | 17 |
2057198 | 2057198 | 2021-12-28 | Sitka City and Borough | Alaska | 2220 | 1301 | 5 |
2053949 | 2053949 | 2021-12-27 | Sitka City and Borough | Alaska | 2220 | 1301 | 5 |
2040628 | 2040628 | 2021-12-22 | Northumberland | Virginia | 51133 | 1301 | 37 |
2037498 | 2037498 | 2021-12-21 | Pendleton | West Virginia | 54071 | 1301 | 16 |
2022870 | 2022870 | 2021-12-17 | Caldwell | Missouri | 29025 | 1301 | 26 |
2016399 | 2016399 | 2021-12-15 | Hickory | Missouri | 29085 | 1301 | 44 |
2003460 | 2003460 | 2021-12-11 | Sullivan | Missouri | 29211 | 1301 | 17 |
1995523 | 1995523 | 2021-12-09 | Prairie | Arkansas | 5117 | 1301 | 29 |
1989375 | 1989375 | 2021-12-07 | Taylor | Georgia | 13269 | 1301 | 39 |
1966054 | 1966054 | 2021-11-29 | Pepin | Wisconsin | 55091 | 1301 | 10 |
1946627 | 1946627 | 2021-11-24 | Greene | Alabama | 1063 | 1301 | 45 |
1943376 | 1943376 | 2021-11-23 | Greene | Alabama | 1063 | 1301 | 45 |
1944255 | 1944255 | 2021-11-23 | Clay | Kansas | 20027 | 1301 | 31 |
1941005 | 1941005 | 2021-11-22 | Clay | Kansas | 20027 | 1301 | 31 |
1928005 | 1928005 | 2021-11-18 | Coffey | Kansas | 20031 | 1301 | 28 |
1928133 | 1928133 | 2021-11-18 | Gallatin | Kentucky | 21077 | 1301 | 41 |
1924755 | 1924755 | 2021-11-17 | Coffey | Kansas | 20031 | 1301 | 28 |
1919383 | 1919383 | 2021-11-15 | Pembina | North Dakota | 38067 | 1301 | 13 |
1879278 | 1879278 | 2021-11-03 | Grant | Kansas | 20067 | 1301 | 29 |
1879790 | 1879790 | 2021-11-03 | Humphreys | Mississippi | 28053 | 1301 | 39 |
1876810 | 1876810 | 2021-11-02 | Hamilton | Nebraska | 31081 | 1301 | 19 |
1873561 | 1873561 | 2021-11-01 | Hamilton | Nebraska | 31081 | 1301 | 19 |
1869893 | 1869893 | 2021-10-31 | Mackinac | Michigan | 26097 | 1301 | 12 |
1866644 | 1866644 | 2021-10-30 | Mackinac | Michigan | 26097 | 1301 | 12 |
1863395 | 1863395 | 2021-10-29 | Mackinac | Michigan | 26097 | 1301 | 12 |
1850304 | 1850304 | 2021-10-25 | Piscataquis | Maine | 23021 | 1301 | 11 |
1847054 | 1847054 | 2021-10-24 | Piscataquis | Maine | 23021 | 1301 | 11 |
1843804 | 1843804 | 2021-10-23 | Piscataquis | Maine | 23021 | 1301 | 11 |
1816069 | 1816069 | 2021-10-14 | Franklin | Texas | 48159 | 1301 | 32 |
1813139 | 1813139 | 2021-10-13 | Poquoson city | Virginia | 51735 | 1301 | 19 |
1801771 | 1801771 | 2021-10-10 | Swift | Minnesota | 27151 | 1301 | 19 |
1798522 | 1798522 | 2021-10-09 | Swift | Minnesota | 27151 | 1301 | 19 |
1795273 | 1795273 | 2021-10-08 | Swift | Minnesota | 27151 | 1301 | 19 |
1787010 | 1787010 | 2021-10-05 | Emery | Utah | 49015 | 1301 | 16 |
1774014 | 1774014 | 2021-10-01 | Grand | Utah | 49019 | 1301 | 4 |
1768036 | 1768036 | 2021-09-30 | Nevada | Arkansas | 5099 | 1301 | 30 |
1770327 | 1770327 | 2021-09-30 | McCormick | South Carolina | 45065 | 1301 | 30 |
1750276 | 1750276 | 2021-09-24 | Schuyler | New York | 36097 | 1301 | 16 |
1745060 | 1745060 | 2021-09-22 | Forest | Wisconsin | 55041 | 1301 | 30 |
1728547 | 1728547 | 2021-09-17 | Addison | Vermont | 50001 | 1301 | 8 |
1718484 | 1718484 | 2021-09-14 | Moore | Tennessee | 47127 | 1301 | 19 |
1715236 | 1715236 | 2021-09-13 | Moore | Tennessee | 47127 | 1301 | 19 |
1710364 | 1710364 | 2021-09-12 | Norton | Kansas | 20137 | 1301 | 30 |
1707117 | 1707117 | 2021-09-11 | Norton | Kansas | 20137 | 1301 | 30 |
1703869 | 1703869 | 2021-09-10 | Norton | Kansas | 20137 | 1301 | 30 |
1699707 | 1699707 | 2021-09-09 | Perry | Alabama | 1105 | 1301 | 30 |
1700619 | 1700619 | 2021-09-09 | Norton | Kansas | 20137 | 1301 | 29 |
1702015 | 1702015 | 2021-09-09 | Guayama | Puerto Rico | 72057 | 1301 | |
1697370 | 1697370 | 2021-09-08 | Norton | Kansas | 20137 | 1301 | 29 |
1698766 | 1698766 | 2021-09-08 | Guayama | Puerto Rico | 72057 | 1301 | |
1692004 | 1692004 | 2021-09-06 | Harrison | Ohio | 39067 | 1301 | 38 |
1689631 | 1689631 | 2021-09-05 | Franklin city | Virginia | 51620 | 1301 | 35 |
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);