ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
312 rows where cases = 1729 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 27
- Arkansas 25
- Kentucky 19
- Texas 18
- Wisconsin 18
- Iowa 16
- Illinois 15
- Georgia 13
- Missouri 13
- Minnesota 10
- Oklahoma 10
- Virginia 10
- Puerto Rico 9
- Kansas 8
- Mississippi 8
- Nebraska 7
- Ohio 7
- Florida 6
- Idaho 6
- North Carolina 6
- South Carolina 6
- Tennessee 6
- Alabama 5
- Michigan 5
- Colorado 4
- Indiana 4
- Louisiana 4
- Oregon 4
- Pennsylvania 4
- New York 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496995 | 2496995 | 2022-05-12 | Pulaski | Illinois | 17153 | 1729 | 19 |
2490479 | 2490479 | 2022-05-10 | Pulaski | Illinois | 17153 | 1729 | 19 |
2470440 | 2470440 | 2022-05-04 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2467184 | 2467184 | 2022-05-03 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2463929 | 2463929 | 2022-05-02 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2460673 | 2460673 | 2022-05-01 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2457417 | 2457417 | 2022-04-30 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2454161 | 2454161 | 2022-04-29 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2450905 | 2450905 | 2022-04-28 | Woodruff | Arkansas | 5147 | 1729 | 31 |
2379350 | 2379350 | 2022-04-06 | Conejos | Colorado | 8021 | 1729 | 54 |
2278387 | 2278387 | 2022-03-06 | Dallas | Arkansas | 5039 | 1729 | 29 |
2275134 | 2275134 | 2022-03-05 | Dallas | Arkansas | 5039 | 1729 | 29 |
2271881 | 2271881 | 2022-03-04 | Dallas | Arkansas | 5039 | 1729 | 29 |
2262850 | 2262850 | 2022-03-01 | Lucas | Iowa | 19117 | 1729 | 31 |
2259599 | 2259599 | 2022-02-28 | Lucas | Iowa | 19117 | 1729 | 31 |
2256348 | 2256348 | 2022-02-27 | Lucas | Iowa | 19117 | 1729 | 31 |
2253097 | 2253097 | 2022-02-26 | Lucas | Iowa | 19117 | 1729 | 31 |
2249846 | 2249846 | 2022-02-25 | Lucas | Iowa | 19117 | 1729 | 31 |
2246595 | 2246595 | 2022-02-24 | Lucas | Iowa | 19117 | 1729 | 31 |
2243344 | 2243344 | 2022-02-23 | Lucas | Iowa | 19117 | 1729 | 31 |
2240133 | 2240133 | 2022-02-22 | Worth | Iowa | 19195 | 1729 | 12 |
2236882 | 2236882 | 2022-02-21 | Worth | Iowa | 19195 | 1729 | 12 |
2233631 | 2233631 | 2022-02-20 | Worth | Iowa | 19195 | 1729 | 12 |
2230380 | 2230380 | 2022-02-19 | Worth | Iowa | 19195 | 1729 | 12 |
2227129 | 2227129 | 2022-02-18 | Worth | Iowa | 19195 | 1729 | 12 |
2223878 | 2223878 | 2022-02-17 | Worth | Iowa | 19195 | 1729 | 12 |
2220627 | 2220627 | 2022-02-16 | Worth | Iowa | 19195 | 1729 | 12 |
2199334 | 2199334 | 2022-02-09 | Hormigueros | Puerto Rico | 72067 | 1729 | |
2196080 | 2196080 | 2022-02-08 | Hormigueros | Puerto Rico | 72067 | 1729 | |
2192826 | 2192826 | 2022-02-07 | Hormigueros | Puerto Rico | 72067 | 1729 | |
2193467 | 2193467 | 2022-02-07 | Middlesex | Virginia | 51119 | 1729 | 41 |
2188137 | 2188137 | 2022-02-06 | Greenwood | Kansas | 20073 | 1729 | 20 |
2184884 | 2184884 | 2022-02-05 | Greenwood | Kansas | 20073 | 1729 | 20 |
2181632 | 2181632 | 2022-02-04 | Greenwood | Kansas | 20073 | 1729 | 20 |
2175735 | 2175735 | 2022-02-02 | Hickory | Missouri | 29085 | 1729 | 50 |
2169306 | 2169306 | 2022-01-31 | Blaine | Montana | 30005 | 1729 | 28 |
2151884 | 2151884 | 2022-01-26 | Irwin | Georgia | 13155 | 1729 | 42 |
2145942 | 2145942 | 2022-01-24 | Crittenden | Kentucky | 21055 | 1729 | 39 |
2147707 | 2147707 | 2022-01-24 | Mitchell | Texas | 48335 | 1729 | 45 |
2144453 | 2144453 | 2022-01-23 | Mitchell | Texas | 48335 | 1729 | 45 |
2137187 | 2137187 | 2022-01-21 | Pembina | North Dakota | 38067 | 1729 | 16 |
2128538 | 2128538 | 2022-01-18 | Tyler | West Virginia | 54095 | 1729 | 27 |
2106289 | 2106289 | 2022-01-12 | Candler | Georgia | 13043 | 1729 | 91 |
2108330 | 2108330 | 2022-01-12 | McCormick | South Carolina | 45065 | 1729 | 33 |
2103969 | 2103969 | 2022-01-11 | Clearwater | Minnesota | 27029 | 1729 | 27 |
2097667 | 2097667 | 2022-01-09 | Howard | Missouri | 29089 | 1729 | 19 |
2085496 | 2085496 | 2022-01-05 | Luquillo | Puerto Rico | 72089 | 1729 | |
2080961 | 2080961 | 2022-01-04 | Owen | Kentucky | 21187 | 1729 | 29 |
2065609 | 2065609 | 2021-12-30 | Washington | North Carolina | 37187 | 1729 | 39 |
2055601 | 2055601 | 2021-12-27 | Phelps | Nebraska | 31137 | 1729 | 11 |
2056947 | 2056947 | 2021-12-27 | Pend Oreille | Washington | 53051 | 1729 | 25 |
2052351 | 2052351 | 2021-12-26 | Phelps | Nebraska | 31137 | 1729 | 11 |
2049101 | 2049101 | 2021-12-25 | Phelps | Nebraska | 31137 | 1729 | 11 |
2045851 | 2045851 | 2021-12-24 | Phelps | Nebraska | 31137 | 1729 | 11 |
2042601 | 2042601 | 2021-12-23 | Phelps | Nebraska | 31137 | 1729 | 11 |
2040131 | 2040131 | 2021-12-22 | Roberts | South Dakota | 46109 | 1729 | 45 |
2015427 | 2015427 | 2021-12-15 | Boundary | Idaho | 16021 | 1729 | 49 |
1996071 | 1996071 | 2021-12-09 | Crawford | Indiana | 18025 | 1729 | 30 |
1970964 | 1970964 | 2021-12-01 | Wayne | Missouri | 29223 | 1729 | 34 |
1966744 | 1966744 | 2021-11-30 | Jasper | Illinois | 17079 | 1729 | 23 |
1950425 | 1950425 | 2021-11-25 | Franklin | Idaho | 16041 | 1729 | 26 |
1947174 | 1947174 | 2021-11-24 | Franklin | Idaho | 16041 | 1729 | 26 |
1948888 | 1948888 | 2021-11-24 | Forest | Pennsylvania | 42053 | 1729 | 28 |
1941488 | 1941488 | 2021-11-22 | Rock | Minnesota | 27133 | 1729 | 28 |
1922042 | 1922042 | 2021-11-16 | Jefferson Davis | Mississippi | 28065 | 1729 | 43 |
1918792 | 1918792 | 2021-11-15 | Jefferson Davis | Mississippi | 28065 | 1729 | 43 |
1894731 | 1894731 | 2021-11-08 | Fulton | Arkansas | 5049 | 1729 | 64 |
1879903 | 1879903 | 2021-11-03 | Lewis | Missouri | 29111 | 1729 | 22 |
1872023 | 1872023 | 2021-11-01 | Scott | Arkansas | 5127 | 1729 | 29 |
1872145 | 1872145 | 2021-11-01 | Prowers | Colorado | 8099 | 1729 | 30 |
1868774 | 1868774 | 2021-10-31 | Scott | Arkansas | 5127 | 1729 | 29 |
1865525 | 1865525 | 2021-10-30 | Scott | Arkansas | 5127 | 1729 | 29 |
1853022 | 1853022 | 2021-10-26 | Menard | Illinois | 17129 | 1729 | 17 |
1835284 | 1835284 | 2021-10-20 | Calhoun | South Carolina | 45017 | 1729 | 51 |
1832035 | 1832035 | 2021-10-19 | Calhoun | South Carolina | 45017 | 1729 | 51 |
1828786 | 1828786 | 2021-10-18 | Calhoun | South Carolina | 45017 | 1729 | 51 |
1815741 | 1815741 | 2021-10-14 | Loiza | Puerto Rico | 72087 | 1729 | |
1805935 | 1805935 | 2021-10-11 | Potter | Pennsylvania | 42105 | 1729 | 32 |
1791223 | 1791223 | 2021-10-07 | Washington | Idaho | 16087 | 1729 | 41 |
1787027 | 1787027 | 2021-10-05 | Unknown | Utah | 1729 | 35 | |
1783111 | 1783111 | 2021-10-04 | Curry | Oregon | 41015 | 1729 | 19 |
1767894 | 1767894 | 2021-09-30 | Coosa | Alabama | 1037 | 1729 | 35 |
1762456 | 1762456 | 2021-09-28 | Martin | Kentucky | 21159 | 1729 | 29 |
1759593 | 1759593 | 2021-09-27 | Montgomery | Mississippi | 28097 | 1729 | 54 |
1750507 | 1750507 | 2021-09-24 | Noble | Ohio | 39121 | 1729 | 42 |
1741966 | 1741966 | 2021-09-22 | Kusilvak Census Area | Alaska | 2158 | 1729 | 5 |
1724682 | 1724682 | 2021-09-16 | Fulton | Pennsylvania | 42057 | 1729 | 21 |
1725369 | 1725369 | 2021-09-16 | Greensville | Virginia | 51081 | 1729 | 26 |
1722120 | 1722120 | 2021-09-15 | Greensville | Virginia | 51081 | 1729 | 26 |
1713721 | 1713721 | 2021-09-13 | Magoffin | Kentucky | 21153 | 1729 | 18 |
1711515 | 1711515 | 2021-09-12 | Monroe | Ohio | 39111 | 1729 | 48 |
1701003 | 1701003 | 2021-09-09 | Faribault | Minnesota | 27043 | 1729 | 22 |
1696536 | 1696536 | 2021-09-08 | Desha | Arkansas | 5041 | 1729 | 26 |
1699565 | 1699565 | 2021-09-08 | Burnett | Wisconsin | 55013 | 1729 | 29 |
1693596 | 1693596 | 2021-09-07 | Early | Georgia | 13099 | 1729 | 50 |
1664594 | 1664594 | 2021-08-29 | Piatt | Illinois | 17147 | 1729 | 20 |
1661346 | 1661346 | 2021-08-28 | Piatt | Illinois | 17147 | 1729 | 20 |
1663594 | 1663594 | 2021-08-28 | Windsor | Vermont | 50027 | 1729 | 15 |
1658098 | 1658098 | 2021-08-27 | Piatt | Illinois | 17147 | 1729 | 20 |
1655192 | 1655192 | 2021-08-26 | Butler | Kentucky | 21031 | 1729 | 28 |
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);