ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
530 rows where cases = 592 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 53
- Kansas 37
- Virginia 34
- Nebraska 30
- Georgia 29
- Missouri 28
- Iowa 26
- Kentucky 23
- Arkansas 18
- Puerto Rico 18
- Mississippi 15
- Indiana 14
- Minnesota 13
- North Carolina 12
- Ohio 12
- Illinois 11
- Colorado 10
- Michigan 10
- South Dakota 10
- Alabama 9
- Montana 9
- Idaho 8
- North Dakota 8
- Oklahoma 8
- Tennessee 8
- Pennsylvania 7
- Washington 6
- West Virginia 6
- California 5
- Florida 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497662 | 2497662 | 2022-05-12 | Cook | Minnesota | 27031 | 592 | 4 |
2453106 | 2453106 | 2022-04-28 | Maricao | Puerto Rico | 72093 | 592 | |
2270505 | 2270505 | 2022-03-03 | Adams | North Dakota | 38001 | 592 | 10 |
2267253 | 2267253 | 2022-03-02 | Adams | North Dakota | 38001 | 592 | 10 |
2219549 | 2219549 | 2022-02-15 | Columbia | Washington | 53013 | 592 | 13 |
2214332 | 2214332 | 2022-02-14 | Robertson | Kentucky | 21201 | 592 | 21 |
2216299 | 2216299 | 2022-02-14 | Columbia | Washington | 53013 | 592 | 13 |
2206175 | 2206175 | 2022-02-11 | Fisher | Texas | 48151 | 592 | 22 |
2172996 | 2172996 | 2022-02-01 | Towner | North Dakota | 38095 | 592 | 11 |
2165383 | 2165383 | 2022-01-30 | Lincoln | Kansas | 20105 | 592 | 8 |
2162128 | 2162128 | 2022-01-29 | Lincoln | Kansas | 20105 | 592 | 8 |
2158873 | 2158873 | 2022-01-28 | Lincoln | Kansas | 20105 | 592 | 8 |
2157142 | 2157142 | 2022-01-27 | Buffalo | South Dakota | 46017 | 592 | 17 |
2148232 | 2148232 | 2022-01-25 | Aleutians East Borough | Alaska | 2013 | 592 | 3 |
2144980 | 2144980 | 2022-01-24 | Aleutians East Borough | Alaska | 2013 | 592 | 3 |
2142646 | 2142646 | 2022-01-23 | Smith | Kansas | 20183 | 592 | 5 |
2144419 | 2144419 | 2022-01-23 | Kimble | Texas | 48267 | 592 | 12 |
2139391 | 2139391 | 2022-01-22 | Smith | Kansas | 20183 | 592 | 5 |
2136135 | 2136135 | 2022-01-21 | Smith | Kansas | 20183 | 592 | 5 |
2136740 | 2136740 | 2022-01-21 | Scotland | Missouri | 29199 | 592 | 17 |
2131477 | 2131477 | 2022-01-19 | Shackelford | Texas | 48417 | 592 | 11 |
2111964 | 2111964 | 2022-01-13 | Shackelford | Texas | 48417 | 592 | 10 |
2107244 | 2107244 | 2022-01-12 | Lake of the Woods | Minnesota | 27077 | 592 | 5 |
2101138 | 2101138 | 2022-01-10 | Webster | Nebraska | 31181 | 592 | 9 |
2082350 | 2082350 | 2022-01-04 | Douglas | South Dakota | 46043 | 592 | 14 |
2076863 | 2076863 | 2022-01-03 | Baca | Colorado | 8009 | 592 | 7 |
2055040 | 2055040 | 2021-12-27 | Unknown | Louisiana | 592 | 0 | |
2019095 | 2019095 | 2021-12-16 | Sheridan | Kansas | 20179 | 592 | 16 |
2015845 | 2015845 | 2021-12-15 | Sheridan | Kansas | 20179 | 592 | 16 |
2011079 | 2011079 | 2021-12-13 | Hall | Texas | 48191 | 592 | 15 |
2007828 | 2007828 | 2021-12-12 | Hall | Texas | 48191 | 592 | 15 |
2004577 | 2004577 | 2021-12-11 | Hall | Texas | 48191 | 592 | 15 |
2001326 | 2001326 | 2021-12-10 | Hall | Texas | 48191 | 592 | 15 |
1992396 | 1992396 | 2021-12-08 | Phillips | Colorado | 8095 | 592 | 15 |
1987335 | 1987335 | 2021-12-06 | Nance | Nebraska | 31125 | 592 | 10 |
1987622 | 1987622 | 2021-12-06 | Emmons | North Dakota | 38029 | 592 | 16 |
1984165 | 1984165 | 2021-12-05 | Unknown | New Jersey | 592 | 0 | |
1984989 | 1984989 | 2021-12-05 | Baylor | Texas | 48023 | 592 | 24 |
1981739 | 1981739 | 2021-12-04 | Baylor | Texas | 48023 | 592 | 24 |
1978489 | 1978489 | 2021-12-03 | Baylor | Texas | 48023 | 592 | 24 |
1971390 | 1971390 | 2021-12-01 | Nelson | North Dakota | 38063 | 592 | 16 |
1968380 | 1968380 | 2021-11-30 | Cameron | Pennsylvania | 42023 | 592 | 13 |
1931895 | 1931895 | 2021-11-19 | Knox | Missouri | 29103 | 592 | 8 |
1922279 | 1922279 | 2021-11-16 | Chase | Nebraska | 31029 | 592 | 6 |
1903836 | 1903836 | 2021-11-10 | Hudspeth | Texas | 48229 | 592 | 14 |
1900586 | 1900586 | 2021-11-09 | Hudspeth | Texas | 48229 | 592 | 14 |
1897336 | 1897336 | 2021-11-08 | Hudspeth | Texas | 48229 | 592 | 14 |
1894086 | 1894086 | 2021-11-07 | Hudspeth | Texas | 48229 | 592 | 14 |
1881037 | 1881037 | 2021-11-03 | Donley | Texas | 48129 | 592 | 18 |
1857616 | 1857616 | 2021-10-27 | Bowman | North Dakota | 38011 | 592 | 7 |
1852473 | 1852473 | 2021-10-26 | Calhoun | Arkansas | 5013 | 592 | 8 |
1849224 | 1849224 | 2021-10-25 | Calhoun | Arkansas | 5013 | 592 | 8 |
1845974 | 1845974 | 2021-10-24 | Calhoun | Arkansas | 5013 | 592 | 8 |
1846846 | 1846846 | 2021-10-24 | Stafford | Kansas | 20185 | 592 | 16 |
1842724 | 1842724 | 2021-10-23 | Calhoun | Arkansas | 5013 | 592 | 8 |
1843596 | 1843596 | 2021-10-23 | Stafford | Kansas | 20185 | 592 | 16 |
1839474 | 1839474 | 2021-10-22 | Calhoun | Arkansas | 5013 | 592 | 7 |
1840346 | 1840346 | 2021-10-22 | Stafford | Kansas | 20185 | 592 | 16 |
1829177 | 1829177 | 2021-10-18 | Reagan | Texas | 48383 | 592 | 10 |
1814002 | 1814002 | 2021-10-14 | Hardin | Illinois | 17069 | 592 | 16 |
1812845 | 1812845 | 2021-10-13 | Haskell | Texas | 48207 | 592 | 31 |
1809553 | 1809553 | 2021-10-12 | Delta | Texas | 48119 | 592 | 20 |
1809723 | 1809723 | 2021-10-12 | Upton | Texas | 48461 | 592 | 13 |
1810040 | 1810040 | 2021-10-12 | Florence | Wisconsin | 55037 | 592 | 13 |
1806473 | 1806473 | 2021-10-11 | Upton | Texas | 48461 | 592 | 13 |
1806611 | 1806611 | 2021-10-11 | King and Queen | Virginia | 51097 | 592 | 8 |
1803223 | 1803223 | 2021-10-10 | Upton | Texas | 48461 | 592 | 13 |
1803361 | 1803361 | 2021-10-10 | King and Queen | Virginia | 51097 | 592 | 8 |
1800112 | 1800112 | 2021-10-09 | King and Queen | Virginia | 51097 | 592 | 8 |
1796863 | 1796863 | 2021-10-08 | King and Queen | Virginia | 51097 | 592 | 8 |
1793614 | 1793614 | 2021-10-07 | King and Queen | Virginia | 51097 | 592 | 8 |
1768832 | 1768832 | 2021-09-30 | Meade | Kansas | 20119 | 592 | 15 |
1769521 | 1769521 | 2021-09-30 | Mineral | Montana | 30061 | 592 | 9 |
1765583 | 1765583 | 2021-09-29 | Meade | Kansas | 20119 | 592 | 15 |
1749970 | 1749970 | 2021-09-24 | Putnam | Missouri | 29171 | 592 | 7 |
1746720 | 1746720 | 2021-09-23 | Putnam | Missouri | 29171 | 592 | 7 |
1736929 | 1736929 | 2021-09-20 | Holt | Missouri | 29087 | 592 | 16 |
1733143 | 1733143 | 2021-09-19 | Ballard | Kentucky | 21007 | 592 | 16 |
1729893 | 1729893 | 2021-09-18 | Ballard | Kentucky | 21007 | 592 | 16 |
1730916 | 1730916 | 2021-09-18 | LaMoure | North Dakota | 38045 | 592 | 17 |
1726643 | 1726643 | 2021-09-17 | Ballard | Kentucky | 21007 | 592 | 16 |
1705746 | 1705746 | 2021-09-10 | Sutton | Texas | 48435 | 592 | 10 |
1706055 | 1706055 | 2021-09-10 | Wirt | West Virginia | 54105 | 592 | 4 |
1697811 | 1697811 | 2021-09-08 | Unknown | Minnesota | 592 | 93 | |
1677164 | 1677164 | 2021-09-02 | Clear Creek | Colorado | 8019 | 592 | 4 |
1679857 | 1679857 | 2021-09-02 | Charles City | Virginia | 51036 | 592 | 16 |
1674299 | 1674299 | 2021-09-01 | Henderson | Illinois | 17071 | 592 | 23 |
1671303 | 1671303 | 2021-08-31 | Wayne | Iowa | 19185 | 592 | 23 |
1671819 | 1671819 | 2021-08-31 | Unknown | Minnesota | 592 | 93 | |
1667774 | 1667774 | 2021-08-30 | Calhoun | Illinois | 17013 | 592 | 5 |
1668056 | 1668056 | 2021-08-30 | Wayne | Iowa | 19185 | 592 | 23 |
1664809 | 1664809 | 2021-08-29 | Wayne | Iowa | 19185 | 592 | 23 |
1661561 | 1661561 | 2021-08-28 | Wayne | Iowa | 19185 | 592 | 23 |
1658313 | 1658313 | 2021-08-27 | Wayne | Iowa | 19185 | 592 | 23 |
1655065 | 1655065 | 2021-08-26 | Wayne | Iowa | 19185 | 592 | 23 |
1655214 | 1655214 | 2021-08-26 | Fulton | Kentucky | 21075 | 592 | 16 |
1651818 | 1651818 | 2021-08-25 | Wayne | Iowa | 19185 | 592 | 23 |
1648555 | 1648555 | 2021-08-24 | Ringgold | Iowa | 19159 | 592 | 24 |
1645307 | 1645307 | 2021-08-23 | Ringgold | Iowa | 19159 | 592 | 24 |
1642058 | 1642058 | 2021-08-22 | Ringgold | Iowa | 19159 | 592 | 24 |
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);