ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
291 rows where cases = 1565 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 37
- Missouri 25
- Georgia 20
- Kentucky 18
- Texas 17
- Minnesota 13
- Tennessee 11
- Indiana 10
- Puerto Rico 10
- Virginia 10
- Alabama 9
- Ohio 9
- Idaho 8
- Louisiana 7
- Wisconsin 7
- California 6
- West Virginia 6
- Colorado 5
- Michigan 5
- North Carolina 5
- South Carolina 5
- South Dakota 5
- Florida 4
- Montana 4
- Wyoming 4
- Arkansas 3
- Connecticut 3
- Mississippi 3
- New York 3
- North Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2330391 | 2330391 | 2022-03-22 | Unknown | American Samoa | 1565 | 0 | |
2268959 | 2268959 | 2022-03-03 | Hancock | Georgia | 13141 | 1565 | 87 |
2265706 | 2265706 | 2022-03-02 | Hancock | Georgia | 13141 | 1565 | 87 |
2262455 | 2262455 | 2022-03-01 | Hancock | Georgia | 13141 | 1565 | 87 |
2240035 | 2240035 | 2022-02-22 | Adair | Iowa | 19001 | 1565 | 49 |
2240110 | 2240110 | 2022-02-22 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2236264 | 2236264 | 2022-02-21 | Kit Carson | Colorado | 8063 | 1565 | 29 |
2236784 | 2236784 | 2022-02-21 | Adair | Iowa | 19001 | 1565 | 49 |
2236859 | 2236859 | 2022-02-21 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2237507 | 2237507 | 2022-02-21 | Clark | Missouri | 29045 | 1565 | 28 |
2233533 | 2233533 | 2022-02-20 | Adair | Iowa | 19001 | 1565 | 49 |
2233608 | 2233608 | 2022-02-20 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2234256 | 2234256 | 2022-02-20 | Clark | Missouri | 29045 | 1565 | 28 |
2230282 | 2230282 | 2022-02-19 | Adair | Iowa | 19001 | 1565 | 49 |
2230357 | 2230357 | 2022-02-19 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2231005 | 2231005 | 2022-02-19 | Clark | Missouri | 29045 | 1565 | 28 |
2227031 | 2227031 | 2022-02-18 | Adair | Iowa | 19001 | 1565 | 49 |
2227106 | 2227106 | 2022-02-18 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2227754 | 2227754 | 2022-02-18 | Clark | Missouri | 29045 | 1565 | 28 |
2223780 | 2223780 | 2022-02-17 | Adair | Iowa | 19001 | 1565 | 49 |
2223855 | 2223855 | 2022-02-17 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2224503 | 2224503 | 2022-02-17 | Clark | Missouri | 29045 | 1565 | 28 |
2225633 | 2225633 | 2022-02-17 | Brooks | Texas | 48047 | 1565 | 50 |
2220529 | 2220529 | 2022-02-16 | Adair | Iowa | 19001 | 1565 | 49 |
2220604 | 2220604 | 2022-02-16 | Pocahontas | Iowa | 19151 | 1565 | 27 |
2221742 | 2221742 | 2022-02-16 | Bottineau | North Dakota | 38009 | 1565 | 25 |
2214825 | 2214825 | 2022-02-14 | Shannon | Missouri | 29203 | 1565 | 32 |
2185479 | 2185479 | 2022-02-05 | Daviess | Missouri | 29061 | 1565 | 25 |
2121248 | 2121248 | 2022-01-16 | Guayanilla | Puerto Rico | 72059 | 1565 | |
2106663 | 2106663 | 2022-01-12 | Union | Indiana | 18161 | 1565 | 20 |
2107416 | 2107416 | 2022-01-12 | Harrison | Missouri | 29081 | 1565 | 26 |
2098519 | 2098519 | 2022-01-09 | Sabana Grande | Puerto Rico | 72121 | 1565 | |
2082221 | 2082221 | 2022-01-04 | Comerio | Puerto Rico | 72045 | 1565 | |
2082710 | 2082710 | 2022-01-04 | Swisher | Texas | 48437 | 1565 | 26 |
2057660 | 2057660 | 2021-12-28 | Wilkinson | Georgia | 13319 | 1565 | 47 |
2031105 | 2031105 | 2021-12-19 | Platte | Wyoming | 56031 | 1565 | 33 |
2027854 | 2027854 | 2021-12-18 | Platte | Wyoming | 56031 | 1565 | 33 |
2022928 | 2022928 | 2021-12-17 | Monroe | Missouri | 29137 | 1565 | 34 |
2024603 | 2024603 | 2021-12-17 | Platte | Wyoming | 56031 | 1565 | 33 |
2018624 | 2018624 | 2021-12-16 | Seminole | Georgia | 13253 | 1565 | 26 |
2019653 | 2019653 | 2021-12-16 | Iron | Missouri | 29093 | 1565 | 28 |
2021352 | 2021352 | 2021-12-16 | Platte | Wyoming | 56031 | 1565 | 33 |
1988145 | 1988145 | 2021-12-06 | Clay | Tennessee | 47027 | 1565 | 37 |
1946804 | 1946804 | 2021-11-24 | Mariposa | California | 6043 | 1565 | 17 |
1943553 | 1943553 | 2021-11-23 | Mariposa | California | 6043 | 1565 | 17 |
1930142 | 1930142 | 2021-11-18 | Sussex | Virginia | 51183 | 1565 | 29 |
1918913 | 1918913 | 2021-11-15 | Montgomery | Missouri | 29139 | 1565 | 20 |
1914642 | 1914642 | 2021-11-14 | Wilkes | Georgia | 13317 | 1565 | 38 |
1915663 | 1915663 | 2021-11-14 | Montgomery | Missouri | 29139 | 1565 | 20 |
1911392 | 1911392 | 2021-11-13 | Wilkes | Georgia | 13317 | 1565 | 38 |
1908143 | 1908143 | 2021-11-12 | Wilkes | Georgia | 13317 | 1565 | 38 |
1909180 | 1909180 | 2021-11-12 | Ralls | Missouri | 29173 | 1565 | 14 |
1904894 | 1904894 | 2021-11-11 | Wilkes | Georgia | 13317 | 1565 | 37 |
1901644 | 1901644 | 2021-11-10 | Wilkes | Georgia | 13317 | 1565 | 37 |
1904271 | 1904271 | 2021-11-10 | Forest | Wisconsin | 55041 | 1565 | 33 |
1898557 | 1898557 | 2021-11-09 | Brown | Indiana | 18013 | 1565 | 50 |
1897260 | 1897260 | 2021-11-08 | Clay | Texas | 48077 | 1565 | 24 |
1894010 | 1894010 | 2021-11-07 | Clay | Texas | 48077 | 1565 | 24 |
1890760 | 1890760 | 2021-11-06 | Clay | Texas | 48077 | 1565 | 24 |
1881845 | 1881845 | 2021-11-04 | Archuleta | Colorado | 8007 | 1565 | 4 |
1847482 | 1847482 | 2021-10-24 | Dawson | Montana | 30021 | 1565 | 42 |
1844232 | 1844232 | 2021-10-23 | Dawson | Montana | 30021 | 1565 | 42 |
1840982 | 1840982 | 2021-10-22 | Dawson | Montana | 30021 | 1565 | 42 |
1835381 | 1835381 | 2021-10-20 | Todd | South Dakota | 46121 | 1565 | 36 |
1830487 | 1830487 | 2021-10-19 | Sac | Iowa | 19161 | 1565 | 23 |
1827238 | 1827238 | 2021-10-18 | Sac | Iowa | 19161 | 1565 | 23 |
1827898 | 1827898 | 2021-10-18 | Grundy | Missouri | 29079 | 1565 | 47 |
1823989 | 1823989 | 2021-10-17 | Sac | Iowa | 19161 | 1565 | 23 |
1820740 | 1820740 | 2021-10-16 | Sac | Iowa | 19161 | 1565 | 23 |
1817491 | 1817491 | 2021-10-15 | Sac | Iowa | 19161 | 1565 | 23 |
1813758 | 1813758 | 2021-10-14 | Atkinson | Georgia | 13003 | 1565 | 32 |
1814243 | 1814243 | 2021-10-14 | Sac | Iowa | 19161 | 1565 | 23 |
1810994 | 1810994 | 2021-10-13 | Sac | Iowa | 19161 | 1565 | 23 |
1807466 | 1807466 | 2021-10-12 | Teton | Idaho | 16081 | 1565 | 5 |
1804334 | 1804334 | 2021-10-11 | Crawford | Indiana | 18025 | 1565 | 22 |
1804756 | 1804756 | 2021-10-11 | East Carroll | Louisiana | 22035 | 1565 | 30 |
1762257 | 1762257 | 2021-09-28 | Shelby | Iowa | 19165 | 1565 | 39 |
1759009 | 1759009 | 2021-09-27 | Shelby | Iowa | 19165 | 1565 | 39 |
1755761 | 1755761 | 2021-09-26 | Shelby | Iowa | 19165 | 1565 | 39 |
1752513 | 1752513 | 2021-09-25 | Shelby | Iowa | 19165 | 1565 | 39 |
1749264 | 1749264 | 2021-09-24 | Shelby | Iowa | 19165 | 1565 | 39 |
1746014 | 1746014 | 2021-09-23 | Shelby | Iowa | 19165 | 1565 | 39 |
1746246 | 1746246 | 2021-09-23 | Todd | Kentucky | 21219 | 1565 | 29 |
1742765 | 1742765 | 2021-09-22 | Shelby | Iowa | 19165 | 1565 | 39 |
1739073 | 1739073 | 2021-09-21 | Dooly | Georgia | 13093 | 1565 | 50 |
1740048 | 1740048 | 2021-09-21 | Watonwan | Minnesota | 27165 | 1565 | 11 |
1724862 | 1724862 | 2021-09-16 | Charles Mix | South Dakota | 46023 | 1565 | 25 |
1711520 | 1711520 | 2021-09-12 | Noble | Ohio | 39121 | 1565 | 40 |
1707741 | 1707741 | 2021-09-11 | Ripley | Missouri | 29181 | 1565 | 19 |
1688695 | 1688695 | 2021-09-05 | Mountrail | North Dakota | 38061 | 1565 | 19 |
1688953 | 1688953 | 2021-09-05 | Fulton | Pennsylvania | 42057 | 1565 | 20 |
1680053 | 1680053 | 2021-09-02 | Taylor | West Virginia | 54091 | 1565 | 26 |
1671930 | 1671930 | 2021-08-31 | Cedar | Missouri | 29039 | 1565 | 25 |
1673344 | 1673344 | 2021-08-31 | Alleghany | Virginia | 51005 | 1565 | 52 |
1656656 | 1656656 | 2021-08-26 | Dewey | South Dakota | 46041 | 1565 | 30 |
1653393 | 1653393 | 2021-08-25 | Bon Homme | South Dakota | 46009 | 1565 | 29 |
1641764 | 1641764 | 2021-08-22 | Idaho | Idaho | 16049 | 1565 | 18 |
1638514 | 1638514 | 2021-08-21 | Idaho | Idaho | 16049 | 1565 | 18 |
1635264 | 1635264 | 2021-08-20 | Idaho | Idaho | 16049 | 1565 | 18 |
1630150 | 1630150 | 2021-08-18 | Mitchell | North Carolina | 37121 | 1565 | 16 |
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);