ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where cases = 1535 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 26
- Missouri 23
- Texas 20
- Illinois 16
- Iowa 14
- Colorado 11
- Montana 11
- North Carolina 11
- Kentucky 10
- Minnesota 10
- Puerto Rico 10
- Arkansas 9
- Virginia 9
- Alabama 8
- South Carolina 8
- South Dakota 8
- Tennessee 8
- Wisconsin 7
- Indiana 5
- Louisiana 5
- Michigan 5
- New Mexico 5
- West Virginia 5
- Idaho 4
- Mississippi 4
- Nebraska 4
- Wyoming 4
- Nevada 3
- New York 3
- North Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500958 | 2500958 | 2022-05-13 | Norman | Minnesota | 27107 | 1535 | 14 |
2491538 | 2491538 | 2022-05-10 | Nemaha | Nebraska | 31127 | 1535 | 20 |
2488280 | 2488280 | 2022-05-09 | Nemaha | Nebraska | 31127 | 1535 | 20 |
2442617 | 2442617 | 2022-04-25 | Stillwater | Montana | 30095 | 1535 | 32 |
2439361 | 2439361 | 2022-04-24 | Stillwater | Montana | 30095 | 1535 | 30 |
2436105 | 2436105 | 2022-04-23 | Stillwater | Montana | 30095 | 1535 | 30 |
2432849 | 2432849 | 2022-04-22 | Stillwater | Montana | 30095 | 1535 | 30 |
2429593 | 2429593 | 2022-04-21 | Stillwater | Montana | 30095 | 1535 | 30 |
2369590 | 2369590 | 2022-04-03 | Clear Creek | Colorado | 8019 | 1535 | 12 |
2366337 | 2366337 | 2022-04-02 | Clear Creek | Colorado | 8019 | 1535 | 12 |
2363084 | 2363084 | 2022-04-01 | Clear Creek | Colorado | 8019 | 1535 | 12 |
2309246 | 2309246 | 2022-03-15 | Keith | Nebraska | 31101 | 1535 | 17 |
2188765 | 2188765 | 2022-02-06 | Maries | Missouri | 29125 | 1535 | 28 |
2185512 | 2185512 | 2022-02-05 | Maries | Missouri | 29125 | 1535 | 28 |
2142148 | 2142148 | 2022-01-23 | Miller | Georgia | 13201 | 1535 | 25 |
2138893 | 2138893 | 2022-01-22 | Miller | Georgia | 13201 | 1535 | 25 |
2135637 | 2135637 | 2022-01-21 | Miller | Georgia | 13201 | 1535 | 25 |
2097663 | 2097663 | 2022-01-09 | Harrison | Missouri | 29081 | 1535 | 26 |
2085759 | 2085759 | 2022-01-05 | Blanco | Texas | 48031 | 1535 | 28 |
2076737 | 2076737 | 2022-01-03 | Cleveland | Arkansas | 5025 | 1535 | 33 |
2076313 | 2076313 | 2022-01-02 | Charlotte | Virginia | 51037 | 1535 | 30 |
2073062 | 2073062 | 2022-01-01 | Charlotte | Virginia | 51037 | 1535 | 30 |
2069811 | 2069811 | 2021-12-31 | Charlotte | Virginia | 51037 | 1535 | 30 |
2055436 | 2055436 | 2021-12-27 | Oregon | Missouri | 29149 | 1535 | 27 |
2038162 | 2038162 | 2021-12-22 | Wilkinson | Georgia | 13319 | 1535 | 47 |
2036748 | 2036748 | 2021-12-21 | Naguabo | Puerto Rico | 72103 | 1535 | |
2037207 | 2037207 | 2021-12-21 | Swisher | Texas | 48437 | 1535 | 25 |
2033498 | 2033498 | 2021-12-20 | Naguabo | Puerto Rico | 72103 | 1535 | |
2006650 | 2006650 | 2021-12-12 | Iron | Missouri | 29093 | 1535 | 28 |
1990272 | 1990272 | 2021-12-07 | Benton | Mississippi | 28009 | 1535 | 39 |
1975417 | 1975417 | 2021-12-02 | Rains | Texas | 48379 | 1535 | 48 |
1970724 | 1970724 | 2021-12-01 | Marshall | Minnesota | 27089 | 1535 | 22 |
1972168 | 1972168 | 2021-12-01 | Rains | Texas | 48379 | 1535 | 48 |
1972497 | 1972497 | 2021-12-01 | Summers | West Virginia | 54089 | 1535 | 32 |
1968918 | 1968918 | 2021-11-30 | Rains | Texas | 48379 | 1535 | 48 |
1925458 | 1925458 | 2021-11-17 | Beaverhead | Montana | 30001 | 1535 | 22 |
1898138 | 1898138 | 2021-11-09 | Park | Colorado | 8093 | 1535 | 10 |
1892054 | 1892054 | 2021-11-07 | Benton | Indiana | 18007 | 1535 | 17 |
1888804 | 1888804 | 2021-11-06 | Benton | Indiana | 18007 | 1535 | 17 |
1885554 | 1885554 | 2021-11-05 | Benton | Indiana | 18007 | 1535 | 17 |
1887656 | 1887656 | 2021-11-05 | Parmer | Texas | 48369 | 1535 | 37 |
1884406 | 1884406 | 2021-11-04 | Parmer | Texas | 48369 | 1535 | 37 |
1869094 | 1869094 | 2021-10-31 | Montgomery | Georgia | 13209 | 1535 | 40 |
1865845 | 1865845 | 2021-10-30 | Montgomery | Georgia | 13209 | 1535 | 40 |
1866938 | 1866938 | 2021-10-30 | Ralls | Missouri | 29173 | 1535 | 14 |
1862596 | 1862596 | 2021-10-29 | Montgomery | Georgia | 13209 | 1535 | 40 |
1864906 | 1864906 | 2021-10-29 | Ochiltree | Texas | 48357 | 1535 | 37 |
1859347 | 1859347 | 2021-10-28 | Montgomery | Georgia | 13209 | 1535 | 40 |
1860423 | 1860423 | 2021-10-28 | Montgomery | Missouri | 29139 | 1535 | 18 |
1852871 | 1852871 | 2021-10-26 | Seminole | Georgia | 13253 | 1535 | 25 |
1848374 | 1848374 | 2021-10-24 | Roberts | South Dakota | 46109 | 1535 | 43 |
1845124 | 1845124 | 2021-10-23 | Roberts | South Dakota | 46109 | 1535 | 43 |
1841874 | 1841874 | 2021-10-22 | Roberts | South Dakota | 46109 | 1535 | 43 |
1842020 | 1842020 | 2021-10-22 | Clay | Texas | 48077 | 1535 | 23 |
1830158 | 1830158 | 2021-10-19 | Wilkes | Georgia | 13317 | 1535 | 34 |
1813960 | 1813960 | 2021-10-14 | Owyhee | Idaho | 16073 | 1535 | 39 |
1814656 | 1814656 | 2021-10-14 | Luce | Michigan | 26095 | 1535 | 6 |
1816027 | 1816027 | 2021-10-14 | Childress | Texas | 48075 | 1535 | 20 |
1811124 | 1811124 | 2021-10-13 | Bath | Kentucky | 21011 | 1535 | 28 |
1811408 | 1811408 | 2021-10-13 | Luce | Michigan | 26095 | 1535 | 6 |
1807745 | 1807745 | 2021-10-12 | Sac | Iowa | 19161 | 1535 | 23 |
1809369 | 1809369 | 2021-10-12 | Lake | South Dakota | 46079 | 1535 | 20 |
1804090 | 1804090 | 2021-10-11 | Johnson | Georgia | 13167 | 1535 | 58 |
1804494 | 1804494 | 2021-10-11 | Sac | Iowa | 19161 | 1535 | 23 |
1800841 | 1800841 | 2021-10-10 | Johnson | Georgia | 13167 | 1535 | 58 |
1801245 | 1801245 | 2021-10-10 | Sac | Iowa | 19161 | 1535 | 23 |
1797592 | 1797592 | 2021-10-09 | Johnson | Georgia | 13167 | 1535 | 58 |
1797996 | 1797996 | 2021-10-09 | Sac | Iowa | 19161 | 1535 | 23 |
1794343 | 1794343 | 2021-10-08 | Johnson | Georgia | 13167 | 1535 | 58 |
1794747 | 1794747 | 2021-10-08 | Sac | Iowa | 19161 | 1535 | 23 |
1791499 | 1791499 | 2021-10-07 | Sac | Iowa | 19161 | 1535 | 23 |
1788250 | 1788250 | 2021-10-06 | Sac | Iowa | 19161 | 1535 | 23 |
1788909 | 1788909 | 2021-10-06 | Grundy | Missouri | 29079 | 1535 | 47 |
1758705 | 1758705 | 2021-09-27 | Clearwater | Idaho | 16035 | 1535 | 24 |
1735366 | 1735366 | 2021-09-19 | Big Horn | Wyoming | 56003 | 1535 | 38 |
1732116 | 1732116 | 2021-09-18 | Big Horn | Wyoming | 56003 | 1535 | 38 |
1727169 | 1727169 | 2021-09-17 | Douglas | Missouri | 29067 | 1535 | 40 |
1728866 | 1728866 | 2021-09-17 | Big Horn | Wyoming | 56003 | 1535 | 38 |
1722454 | 1722454 | 2021-09-16 | Wilcox | Alabama | 1131 | 1535 | 33 |
1721259 | 1721259 | 2021-09-15 | Morgan | Ohio | 39115 | 1535 | 28 |
1713312 | 1713312 | 2021-09-13 | Menard | Illinois | 17129 | 1535 | 16 |
1711170 | 1711170 | 2021-09-12 | Humboldt | Nevada | 32013 | 1535 | 17 |
1711241 | 1711241 | 2021-09-12 | Socorro | New Mexico | 35053 | 1535 | 62 |
1707923 | 1707923 | 2021-09-11 | Humboldt | Nevada | 32013 | 1535 | 17 |
1707994 | 1707994 | 2021-09-11 | Socorro | New Mexico | 35053 | 1535 | 62 |
1704676 | 1704676 | 2021-09-10 | Humboldt | Nevada | 32013 | 1535 | 17 |
1704747 | 1704747 | 2021-09-10 | Socorro | New Mexico | 35053 | 1535 | 62 |
1696387 | 1696387 | 2021-09-07 | Converse | Wyoming | 56009 | 1535 | 25 |
1690396 | 1690396 | 2021-09-06 | McIntosh | Georgia | 13191 | 1535 | 21 |
1687146 | 1687146 | 2021-09-05 | McIntosh | Georgia | 13191 | 1535 | 21 |
1683896 | 1683896 | 2021-09-04 | McIntosh | Georgia | 13191 | 1535 | 21 |
1680645 | 1680645 | 2021-09-03 | McIntosh | Georgia | 13191 | 1535 | 21 |
1664191 | 1664191 | 2021-08-29 | Gunnison | Colorado | 8051 | 1535 | 7 |
1660943 | 1660943 | 2021-08-28 | Gunnison | Colorado | 8051 | 1535 | 7 |
1657695 | 1657695 | 2021-08-27 | Gunnison | Colorado | 8051 | 1535 | 7 |
1646462 | 1646462 | 2021-08-23 | McKenzie | North Dakota | 38053 | 1535 | 15 |
1647353 | 1647353 | 2021-08-23 | Windham | Vermont | 50025 | 1535 | 16 |
1643213 | 1643213 | 2021-08-22 | McKenzie | North Dakota | 38053 | 1535 | 15 |
1637052 | 1637052 | 2021-08-20 | Juana Diaz | Puerto Rico | 72075 | 1535 | |
1630667 | 1630667 | 2021-08-18 | Dewey | South Dakota | 46041 | 1535 | 29 |
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);