ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
350 rows where cases = 1595 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 35
- Missouri 24
- Virginia 18
- Georgia 16
- Puerto Rico 14
- Illinois 13
- Nebraska 13
- North Carolina 12
- Florida 11
- Kansas 11
- Arkansas 10
- Kentucky 10
- North Dakota 10
- Texas 10
- Alabama 9
- Minnesota 9
- Indiana 8
- Louisiana 8
- Michigan 8
- Oregon 8
- Wisconsin 8
- Wyoming 7
- Oklahoma 6
- Pennsylvania 6
- Colorado 5
- Idaho 5
- Maine 5
- Tennessee 5
- Mississippi 4
- New Mexico 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498332 | 2498332 | 2022-05-12 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2495074 | 2495074 | 2022-05-11 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2491816 | 2491816 | 2022-05-10 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2488558 | 2488558 | 2022-05-09 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2485301 | 2485301 | 2022-05-08 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2482043 | 2482043 | 2022-05-07 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2478785 | 2478785 | 2022-05-06 | Bottineau | North Dakota | 38009 | 1595 | 26 |
2376662 | 2376662 | 2022-04-05 | Davis | Iowa | 19051 | 1595 | 32 |
2373410 | 2373410 | 2022-04-04 | Davis | Iowa | 19051 | 1595 | 32 |
2370157 | 2370157 | 2022-04-03 | Davis | Iowa | 19051 | 1595 | 32 |
2366904 | 2366904 | 2022-04-02 | Davis | Iowa | 19051 | 1595 | 32 |
2363651 | 2363651 | 2022-04-01 | Davis | Iowa | 19051 | 1595 | 32 |
2360397 | 2360397 | 2022-03-31 | Davis | Iowa | 19051 | 1595 | 32 |
2357143 | 2357143 | 2022-03-30 | Davis | Iowa | 19051 | 1595 | 32 |
2350093 | 2350093 | 2022-03-28 | Kit Carson | Colorado | 8063 | 1595 | 31 |
2313022 | 2313022 | 2022-03-16 | Harney | Oregon | 41025 | 1595 | 37 |
2309769 | 2309769 | 2022-03-15 | Harney | Oregon | 41025 | 1595 | 37 |
2305834 | 2305834 | 2022-03-14 | Maries | Missouri | 29125 | 1595 | 34 |
2306516 | 2306516 | 2022-03-14 | Harney | Oregon | 41025 | 1595 | 37 |
2302583 | 2302583 | 2022-03-13 | Maries | Missouri | 29125 | 1595 | 34 |
2302617 | 2302617 | 2022-03-13 | Shannon | Missouri | 29203 | 1595 | 36 |
2299331 | 2299331 | 2022-03-12 | Maries | Missouri | 29125 | 1595 | 34 |
2299365 | 2299365 | 2022-03-12 | Shannon | Missouri | 29203 | 1595 | 36 |
2296079 | 2296079 | 2022-03-11 | Maries | Missouri | 29125 | 1595 | 34 |
2296113 | 2296113 | 2022-03-11 | Shannon | Missouri | 29203 | 1595 | 36 |
2212860 | 2212860 | 2022-02-13 | Beaver | Utah | 49001 | 1595 | 14 |
2209607 | 2209607 | 2022-02-12 | Beaver | Utah | 49001 | 1595 | 14 |
2206354 | 2206354 | 2022-02-11 | Beaver | Utah | 49001 | 1595 | 14 |
2198689 | 2198689 | 2022-02-09 | Knox | Nebraska | 31107 | 1595 | 13 |
2194241 | 2194241 | 2022-02-08 | Treutlen | Georgia | 13283 | 1595 | 58 |
2151907 | 2151907 | 2022-01-26 | Miller | Georgia | 13201 | 1595 | 25 |
2143419 | 2143419 | 2022-01-23 | Wayne | Nebraska | 31179 | 1595 | 11 |
2140164 | 2140164 | 2022-01-22 | Wayne | Nebraska | 31179 | 1595 | 11 |
2136908 | 2136908 | 2022-01-21 | Wayne | Nebraska | 31179 | 1595 | 11 |
2089612 | 2089612 | 2022-01-06 | Platte | Wyoming | 56031 | 1595 | 37 |
2035978 | 2035978 | 2021-12-21 | Beaverhead | Montana | 30001 | 1595 | 23 |
2032728 | 2032728 | 2021-12-20 | Beaverhead | Montana | 30001 | 1595 | 23 |
2008673 | 2008673 | 2021-12-13 | Unknown | Connecticut | 1595 | 0 | |
1998404 | 1998404 | 2021-12-09 | Sussex | Virginia | 51183 | 1595 | 29 |
1991785 | 1991785 | 2021-12-07 | Amelia | Virginia | 51007 | 1595 | 42 |
1988412 | 1988412 | 2021-12-06 | Parmer | Texas | 48369 | 1595 | 42 |
1983317 | 1983317 | 2021-12-05 | Norton | Kansas | 20137 | 1595 | 33 |
1980067 | 1980067 | 2021-12-04 | Norton | Kansas | 20137 | 1595 | 33 |
1976817 | 1976817 | 2021-12-03 | Norton | Kansas | 20137 | 1595 | 33 |
1967842 | 1967842 | 2021-11-30 | Phelps | Nebraska | 31137 | 1595 | 10 |
1930922 | 1930922 | 2021-11-19 | Fremont | Idaho | 16043 | 1595 | 17 |
1927672 | 1927672 | 2021-11-18 | Fremont | Idaho | 16043 | 1595 | 17 |
1923511 | 1923511 | 2021-11-16 | Orange | Vermont | 50017 | 1595 | 6 |
1916612 | 1916612 | 2021-11-14 | Roberts | South Dakota | 46109 | 1595 | 44 |
1913362 | 1913362 | 2021-11-13 | Roberts | South Dakota | 46109 | 1595 | 44 |
1910112 | 1910112 | 2021-11-12 | Roberts | South Dakota | 46109 | 1595 | 44 |
1910504 | 1910504 | 2021-11-12 | Addison | Vermont | 50001 | 1595 | 8 |
1905057 | 1905057 | 2021-11-11 | Brown | Indiana | 18013 | 1595 | 50 |
1904093 | 1904093 | 2021-11-10 | Lexington city | Virginia | 51678 | 1595 | 36 |
1900843 | 1900843 | 2021-11-09 | Lexington city | Virginia | 51678 | 1595 | 36 |
1869608 | 1869608 | 2021-10-31 | Bath | Kentucky | 21011 | 1595 | 30 |
1866359 | 1866359 | 2021-10-30 | Bath | Kentucky | 21011 | 1595 | 30 |
1863110 | 1863110 | 2021-10-29 | Bath | Kentucky | 21011 | 1595 | 30 |
1864394 | 1864394 | 2021-10-29 | Forest | Pennsylvania | 42053 | 1595 | 24 |
1859804 | 1859804 | 2021-10-28 | Linn | Kansas | 20107 | 1595 | 16 |
1856555 | 1856555 | 2021-10-27 | Linn | Kansas | 20107 | 1595 | 16 |
1853171 | 1853171 | 2021-10-26 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1849922 | 1849922 | 2021-10-25 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1846672 | 1846672 | 2021-10-24 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1843422 | 1843422 | 2021-10-23 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1840172 | 1840172 | 2021-10-22 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1836923 | 1836923 | 2021-10-21 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1837396 | 1837396 | 2021-10-21 | Leelanau | Michigan | 26089 | 1595 | 24 |
1833674 | 1833674 | 2021-10-20 | Chickasaw | Iowa | 19037 | 1595 | 18 |
1834147 | 1834147 | 2021-10-20 | Leelanau | Michigan | 26089 | 1595 | 24 |
1830494 | 1830494 | 2021-10-19 | Union | Iowa | 19175 | 1595 | 37 |
1832206 | 1832206 | 2021-10-19 | Perry | Tennessee | 47135 | 1595 | 34 |
1826959 | 1826959 | 2021-10-18 | Teton | Idaho | 16081 | 1595 | 5 |
1827245 | 1827245 | 2021-10-18 | Union | Iowa | 19175 | 1595 | 37 |
1823996 | 1823996 | 2021-10-17 | Union | Iowa | 19175 | 1595 | 37 |
1826269 | 1826269 | 2021-10-17 | Bayfield | Wisconsin | 55007 | 1595 | 24 |
1820747 | 1820747 | 2021-10-16 | Union | Iowa | 19175 | 1595 | 37 |
1817498 | 1817498 | 2021-10-15 | Union | Iowa | 19175 | 1595 | 37 |
1814250 | 1814250 | 2021-10-14 | Union | Iowa | 19175 | 1595 | 37 |
1811001 | 1811001 | 2021-10-13 | Union | Iowa | 19175 | 1595 | 37 |
1807509 | 1807509 | 2021-10-12 | Jasper | Illinois | 17079 | 1595 | 23 |
1802295 | 1802295 | 2021-10-10 | Clay | North Carolina | 37043 | 1595 | 34 |
1799046 | 1799046 | 2021-10-09 | Clay | North Carolina | 37043 | 1595 | 34 |
1795797 | 1795797 | 2021-10-08 | Clay | North Carolina | 37043 | 1595 | 34 |
1778069 | 1778069 | 2021-10-03 | Evans | Georgia | 13109 | 1595 | 46 |
1774819 | 1774819 | 2021-10-02 | Evans | Georgia | 13109 | 1595 | 46 |
1771569 | 1771569 | 2021-10-01 | Evans | Georgia | 13109 | 1595 | 46 |
1765738 | 1765738 | 2021-09-29 | Todd | Kentucky | 21219 | 1595 | 30 |
1767831 | 1767831 | 2021-09-29 | Price | Wisconsin | 55099 | 1595 | 8 |
1759684 | 1759684 | 2021-09-27 | Lewis | Missouri | 29111 | 1595 | 21 |
1756436 | 1756436 | 2021-09-26 | Lewis | Missouri | 29111 | 1595 | 21 |
1738042 | 1738042 | 2021-09-20 | Callahan | Texas | 48059 | 1595 | 50 |
1734792 | 1734792 | 2021-09-19 | Callahan | Texas | 48059 | 1595 | 50 |
1731542 | 1731542 | 2021-09-18 | Callahan | Texas | 48059 | 1595 | 50 |
1714680 | 1714680 | 2021-09-13 | Mountrail | North Dakota | 38061 | 1595 | 19 |
1703104 | 1703104 | 2021-09-10 | Inyo | California | 6027 | 1595 | 39 |
1705239 | 1705239 | 2021-09-10 | Aguas Buenas | Puerto Rico | 72007 | 1595 | |
1693686 | 1693686 | 2021-09-07 | Towns | Georgia | 13281 | 1595 | 68 |
1694224 | 1694224 | 2021-09-07 | Leslie | Kentucky | 21131 | 1595 | 10 |
1694355 | 1694355 | 2021-09-07 | Sagadahoc | Maine | 23023 | 1595 | 12 |
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);