ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
448 rows where cases = 1071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 32
- Kentucky 28
- Minnesota 27
- Missouri 22
- Mississippi 21
- Georgia 20
- Tennessee 18
- Alabama 17
- Iowa 17
- Michigan 17
- Louisiana 15
- Virginia 14
- Nebraska 13
- Montana 12
- Puerto Rico 11
- Wisconsin 11
- Arkansas 10
- Illinois 10
- Oregon 10
- Nevada 8
- North Dakota 8
- West Virginia 8
- California 7
- Kansas 7
- North Carolina 7
- Oklahoma 7
- South Dakota 7
- Idaho 6
- New Mexico 6
- Utah 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448872 | 2448872 | 2022-04-27 | Unknown | Minnesota | 1071 | 270 | |
2332972 | 2332972 | 2022-03-22 | Concho | Texas | 48095 | 1071 | 11 |
2329719 | 2329719 | 2022-03-21 | Concho | Texas | 48095 | 1071 | 11 |
2326467 | 2326467 | 2022-03-20 | Concho | Texas | 48095 | 1071 | 11 |
2323214 | 2323214 | 2022-03-19 | Concho | Texas | 48095 | 1071 | 11 |
2318956 | 2318956 | 2022-03-18 | Antelope | Nebraska | 31003 | 1071 | 13 |
2315703 | 2315703 | 2022-03-17 | Antelope | Nebraska | 31003 | 1071 | 13 |
2305945 | 2305945 | 2022-03-14 | Antelope | Nebraska | 31003 | 1071 | 13 |
2301610 | 2301610 | 2022-03-13 | Lincoln | Idaho | 16063 | 1071 | 15 |
2302694 | 2302694 | 2022-03-13 | Antelope | Nebraska | 31003 | 1071 | 13 |
2298358 | 2298358 | 2022-03-12 | Lincoln | Idaho | 16063 | 1071 | 15 |
2299442 | 2299442 | 2022-03-12 | Antelope | Nebraska | 31003 | 1071 | 13 |
2295106 | 2295106 | 2022-03-11 | Lincoln | Idaho | 16063 | 1071 | 15 |
2296190 | 2296190 | 2022-03-11 | Antelope | Nebraska | 31003 | 1071 | 13 |
2297240 | 2297240 | 2022-03-11 | Hall | Texas | 48191 | 1071 | 22 |
2277882 | 2277882 | 2022-03-05 | Yoakum | Texas | 48501 | 1071 | 41 |
2260571 | 2260571 | 2022-02-28 | Hidalgo | New Mexico | 35023 | 1071 | 13 |
2258542 | 2258542 | 2022-02-27 | Surry | Virginia | 51181 | 1071 | 18 |
2255291 | 2255291 | 2022-02-26 | Surry | Virginia | 51181 | 1071 | 18 |
2252040 | 2252040 | 2022-02-25 | Surry | Virginia | 51181 | 1071 | 18 |
2240883 | 2240883 | 2022-02-22 | Mineral | Montana | 30061 | 1071 | 17 |
2193373 | 2193373 | 2022-02-07 | Essex | Vermont | 50009 | 1071 | 3 |
2179147 | 2179147 | 2022-02-03 | Fillmore | Nebraska | 31059 | 1071 | 13 |
2169278 | 2169278 | 2022-01-31 | Reynolds | Missouri | 29179 | 1071 | 19 |
2155709 | 2155709 | 2022-01-27 | Fulton | Kentucky | 21075 | 1071 | 23 |
2156366 | 2156366 | 2022-01-27 | Dixon | Nebraska | 31051 | 1071 | 11 |
2147874 | 2147874 | 2022-01-24 | Cumberland | Virginia | 51049 | 1071 | 19 |
2105779 | 2105779 | 2022-01-11 | Wirt | West Virginia | 54105 | 1071 | 19 |
2087817 | 2087817 | 2022-01-06 | Jefferson | Mississippi | 28063 | 1071 | 35 |
2088709 | 2088709 | 2022-01-06 | Arroyo | Puerto Rico | 72015 | 1071 | |
2084214 | 2084214 | 2022-01-05 | Owsley | Kentucky | 21189 | 1071 | 23 |
2078644 | 2078644 | 2022-01-03 | McHenry | North Dakota | 38049 | 1071 | 28 |
2058081 | 2058081 | 2021-12-28 | Phillips | Kansas | 20147 | 1071 | 28 |
2054832 | 2054832 | 2021-12-27 | Phillips | Kansas | 20147 | 1071 | 28 |
2051696 | 2051696 | 2021-12-26 | Menifee | Kentucky | 21165 | 1071 | 26 |
2048446 | 2048446 | 2021-12-25 | Menifee | Kentucky | 21165 | 1071 | 26 |
2045196 | 2045196 | 2021-12-24 | Menifee | Kentucky | 21165 | 1071 | 26 |
2041947 | 2041947 | 2021-12-23 | Menifee | Kentucky | 21165 | 1071 | 26 |
2038697 | 2038697 | 2021-12-22 | Menifee | Kentucky | 21165 | 1071 | 26 |
2035447 | 2035447 | 2021-12-21 | Menifee | Kentucky | 21165 | 1071 | 26 |
2033361 | 2033361 | 2021-12-20 | Lake | Oregon | 41037 | 1071 | 21 |
2030111 | 2030111 | 2021-12-19 | Lake | Oregon | 41037 | 1071 | 21 |
2026860 | 2026860 | 2021-12-18 | Lake | Oregon | 41037 | 1071 | 21 |
2023609 | 2023609 | 2021-12-17 | Lake | Oregon | 41037 | 1071 | 21 |
2008568 | 2008568 | 2021-12-13 | Modoc | California | 6049 | 1071 | 10 |
2005317 | 2005317 | 2021-12-12 | Modoc | California | 6049 | 1071 | 10 |
2002066 | 2002066 | 2021-12-11 | Modoc | California | 6049 | 1071 | 10 |
1998816 | 1998816 | 2021-12-10 | Modoc | California | 6049 | 1071 | 10 |
1995565 | 1995565 | 2021-12-09 | Modoc | California | 6049 | 1071 | 10 |
1987939 | 1987939 | 2021-12-06 | Aibonito | Puerto Rico | 72009 | 1071 | |
1984689 | 1984689 | 2021-12-05 | Aibonito | Puerto Rico | 72009 | 1071 | |
1985031 | 1985031 | 2021-12-05 | Crosby | Texas | 48107 | 1071 | 39 |
1917969 | 1917969 | 2021-11-15 | Edwards | Illinois | 17047 | 1071 | 20 |
1918819 | 1918819 | 2021-11-15 | Quitman | Mississippi | 28119 | 1071 | 28 |
1915569 | 1915569 | 2021-11-14 | Quitman | Mississippi | 28119 | 1071 | 28 |
1912319 | 1912319 | 2021-11-13 | Quitman | Mississippi | 28119 | 1071 | 28 |
1912362 | 1912362 | 2021-11-13 | Chariton | Missouri | 29041 | 1071 | 8 |
1909069 | 1909069 | 2021-11-12 | Quitman | Mississippi | 28119 | 1071 | 28 |
1901352 | 1901352 | 2021-11-10 | Conejos | Colorado | 8021 | 1071 | 37 |
1900087 | 1900087 | 2021-11-09 | Grant | Oregon | 41023 | 1071 | 14 |
1900201 | 1900201 | 2021-11-09 | Comerio | Puerto Rico | 72045 | 1071 | |
1882961 | 1882961 | 2021-11-04 | Lac qui Parle | Minnesota | 27073 | 1071 | 25 |
1856211 | 1856211 | 2021-10-27 | Brown | Illinois | 17009 | 1071 | 16 |
1858853 | 1858853 | 2021-10-27 | Weston | Wyoming | 56045 | 1071 | 9 |
1852962 | 1852962 | 2021-10-26 | Brown | Illinois | 17009 | 1071 | 16 |
1849713 | 1849713 | 2021-10-25 | Brown | Illinois | 17009 | 1071 | 16 |
1831552 | 1831552 | 2021-10-19 | Gates | North Carolina | 37073 | 1071 | 18 |
1832207 | 1832207 | 2021-10-19 | Pickett | Tennessee | 47137 | 1071 | 24 |
1826894 | 1826894 | 2021-10-18 | Twiggs | Georgia | 13289 | 1071 | 59 |
1813899 | 1813899 | 2021-10-14 | Twiggs | Georgia | 13289 | 1071 | 59 |
1814379 | 1814379 | 2021-10-14 | Bracken | Kentucky | 21023 | 1071 | 8 |
1786996 | 1786996 | 2021-10-05 | Winkler | Texas | 48495 | 1071 | 27 |
1767682 | 1767682 | 2021-09-29 | Williamsburg city | Virginia | 51830 | 1071 | 14 |
1761686 | 1761686 | 2021-09-28 | Yuma | Colorado | 8125 | 1071 | 18 |
1760168 | 1760168 | 2021-09-27 | Pembina | North Dakota | 38067 | 1071 | 11 |
1760758 | 1760758 | 2021-09-27 | Archer | Texas | 48009 | 1071 | 14 |
1757510 | 1757510 | 2021-09-26 | Archer | Texas | 48009 | 1071 | 14 |
1754262 | 1754262 | 2021-09-25 | Archer | Texas | 48009 | 1071 | 14 |
1746477 | 1746477 | 2021-09-23 | Clearwater | Minnesota | 27029 | 1071 | 18 |
1746794 | 1746794 | 2021-09-23 | Sanders | Montana | 30089 | 1071 | 16 |
1744665 | 1744665 | 2021-09-22 | Marion | Texas | 48315 | 1071 | 41 |
1741651 | 1741651 | 2021-09-21 | Northumberland | Virginia | 51133 | 1071 | 23 |
1736926 | 1736926 | 2021-09-20 | Harrison | Missouri | 29081 | 1071 | 17 |
1733676 | 1733676 | 2021-09-19 | Harrison | Missouri | 29081 | 1071 | 17 |
1735281 | 1735281 | 2021-09-19 | Roane | West Virginia | 54087 | 1071 | 12 |
1716051 | 1716051 | 2021-09-14 | Montgomery | Arkansas | 5097 | 1071 | 36 |
1717402 | 1717402 | 2021-09-14 | Caldwell | Missouri | 29025 | 1071 | 18 |
1702132 | 1702132 | 2021-09-09 | Custer | South Dakota | 46033 | 1071 | 14 |
1692630 | 1692630 | 2021-09-06 | Hamilton | Texas | 48193 | 1071 | 29 |
1679723 | 1679723 | 2021-09-02 | Rains | Texas | 48379 | 1071 | 30 |
1676475 | 1676475 | 2021-09-01 | Rains | Texas | 48379 | 1071 | 30 |
1673228 | 1673228 | 2021-08-31 | Rains | Texas | 48379 | 1071 | 30 |
1665738 | 1665738 | 2021-08-29 | Colfax | New Mexico | 35007 | 1071 | 47 |
1662490 | 1662490 | 2021-08-28 | Colfax | New Mexico | 35007 | 1071 | 47 |
1659242 | 1659242 | 2021-08-27 | Colfax | New Mexico | 35007 | 1071 | 47 |
1660309 | 1660309 | 2021-08-27 | Emery | Utah | 49015 | 1071 | 12 |
1655222 | 1655222 | 2021-08-26 | Hancock | Kentucky | 21091 | 1071 | 16 |
1651858 | 1651858 | 2021-08-25 | Grant | Kansas | 20067 | 1071 | 22 |
1648609 | 1648609 | 2021-08-24 | Grant | Kansas | 20067 | 1071 | 22 |
1645361 | 1645361 | 2021-08-23 | Grant | Kansas | 20067 | 1071 | 22 |
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);