ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
342 rows where cases = 1332 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Iowa 22
- Kentucky 22
- Puerto Rico 18
- Virginia 18
- Missouri 15
- Wisconsin 14
- Georgia 12
- Minnesota 12
- Michigan 11
- North Dakota 11
- South Dakota 10
- Arkansas 9
- Mississippi 9
- North Carolina 9
- West Virginia 8
- Alabama 7
- Indiana 7
- Kansas 7
- Ohio 7
- South Carolina 7
- Utah 7
- Washington 6
- Colorado 5
- Florida 5
- Louisiana 5
- Nebraska 5
- New York 5
- Tennessee 5
- Illinois 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488924 | 2488924 | 2022-05-09 | Las Marias | Puerto Rico | 72083 | 1332 | |
2427570 | 2427570 | 2022-04-20 | Kane | Utah | 49025 | 1332 | 14 |
2424314 | 2424314 | 2022-04-19 | Kane | Utah | 49025 | 1332 | 14 |
2316080 | 2316080 | 2022-03-17 | Sioux | North Dakota | 38085 | 1332 | 19 |
2312827 | 2312827 | 2022-03-16 | Sioux | North Dakota | 38085 | 1332 | 19 |
2309574 | 2309574 | 2022-03-15 | Sioux | North Dakota | 38085 | 1332 | 19 |
2305954 | 2305954 | 2022-03-14 | Burt | Nebraska | 31021 | 1332 | 16 |
2306321 | 2306321 | 2022-03-14 | Sioux | North Dakota | 38085 | 1332 | 19 |
2303070 | 2303070 | 2022-03-13 | Sioux | North Dakota | 38085 | 1332 | 19 |
2299818 | 2299818 | 2022-03-12 | Sioux | North Dakota | 38085 | 1332 | 19 |
2292947 | 2292947 | 2022-03-10 | Burt | Nebraska | 31021 | 1332 | 16 |
2283191 | 2283191 | 2022-03-07 | Burt | Nebraska | 31021 | 1332 | 16 |
2273800 | 2273800 | 2022-03-04 | Sioux | North Dakota | 38085 | 1332 | 19 |
2274481 | 2274481 | 2022-03-04 | Hartley | Texas | 48205 | 1332 | 3 |
2271228 | 2271228 | 2022-03-03 | Hartley | Texas | 48205 | 1332 | 3 |
2267976 | 2267976 | 2022-03-02 | Hartley | Texas | 48205 | 1332 | 3 |
2264723 | 2264723 | 2022-03-01 | Hartley | Texas | 48205 | 1332 | 3 |
2241746 | 2241746 | 2022-02-22 | McCook | South Dakota | 46087 | 1332 | 31 |
2212331 | 2212331 | 2022-02-13 | Ceiba | Puerto Rico | 72037 | 1332 | |
2166957 | 2166957 | 2022-01-30 | Spink | South Dakota | 46115 | 1332 | 32 |
2163702 | 2163702 | 2022-01-29 | Spink | South Dakota | 46115 | 1332 | 32 |
2160447 | 2160447 | 2022-01-28 | Spink | South Dakota | 46115 | 1332 | 32 |
2152787 | 2152787 | 2022-01-26 | Mahnomen | Minnesota | 27087 | 1332 | 17 |
2153888 | 2153888 | 2022-01-26 | Brule | South Dakota | 46015 | 1332 | 18 |
2131894 | 2131894 | 2022-01-19 | Weston | Wyoming | 56045 | 1332 | 16 |
2122147 | 2122147 | 2022-01-17 | Choctaw | Alabama | 1023 | 1332 | 31 |
2112236 | 2112236 | 2022-01-13 | Calhoun | West Virginia | 54013 | 1332 | 9 |
2082239 | 2082239 | 2022-01-04 | Lajas | Puerto Rico | 72079 | 1332 | |
2079761 | 2079761 | 2022-01-03 | Tucker | West Virginia | 54093 | 1332 | 32 |
2032718 | 2032718 | 2021-12-20 | Sullivan | Missouri | 29211 | 1332 | 17 |
2034189 | 2034189 | 2021-12-20 | Jefferson | Washington | 53031 | 1332 | 21 |
2029467 | 2029467 | 2021-12-19 | Sullivan | Missouri | 29211 | 1332 | 17 |
2026216 | 2026216 | 2021-12-18 | Sullivan | Missouri | 29211 | 1332 | 17 |
2027253 | 2027253 | 2021-12-18 | Blanco | Texas | 48031 | 1332 | 28 |
2019395 | 2019395 | 2021-12-16 | Lake | Michigan | 26085 | 1332 | 29 |
2019551 | 2019551 | 2021-12-16 | Humphreys | Mississippi | 28053 | 1332 | 39 |
2016145 | 2016145 | 2021-12-15 | Lake | Michigan | 26085 | 1332 | 29 |
2012393 | 2012393 | 2021-12-14 | Union | Indiana | 18161 | 1332 | 17 |
1991534 | 1991534 | 2021-12-07 | Dallam | Texas | 48111 | 1332 | 29 |
1968976 | 1968976 | 2021-11-30 | Winkler | Texas | 48495 | 1332 | 32 |
1963891 | 1963891 | 2021-11-29 | Gallatin | Kentucky | 21077 | 1332 | 42 |
1945106 | 1945106 | 2021-11-23 | Wayne | Nebraska | 31179 | 1332 | 8 |
1941125 | 1941125 | 2021-11-22 | Cumberland | Kentucky | 21057 | 1332 | 21 |
1937875 | 1937875 | 2021-11-21 | Cumberland | Kentucky | 21057 | 1332 | 21 |
1939608 | 1939608 | 2021-11-21 | La Salle | Texas | 48283 | 1332 | 40 |
1934625 | 1934625 | 2021-11-20 | Cumberland | Kentucky | 21057 | 1332 | 21 |
1936358 | 1936358 | 2021-11-20 | La Salle | Texas | 48283 | 1332 | 40 |
1933108 | 1933108 | 2021-11-19 | La Salle | Texas | 48283 | 1332 | 40 |
1926950 | 1926950 | 2021-11-17 | Clay | West Virginia | 54015 | 1332 | 21 |
1922129 | 1922129 | 2021-11-16 | Gentry | Missouri | 29075 | 1332 | 27 |
1891628 | 1891628 | 2021-11-07 | Lincoln | Colorado | 8073 | 1332 | 8 |
1888378 | 1888378 | 2021-11-06 | Lincoln | Colorado | 8073 | 1332 | 8 |
1885128 | 1885128 | 2021-11-05 | Lincoln | Colorado | 8073 | 1332 | 8 |
1878832 | 1878832 | 2021-11-03 | Macon | Georgia | 13193 | 1332 | 43 |
1878043 | 1878043 | 2021-11-02 | Buena Vista city | Virginia | 51530 | 1332 | 27 |
1873793 | 1873793 | 2021-11-01 | Graham | North Carolina | 37075 | 1332 | 28 |
1874509 | 1874509 | 2021-11-01 | Castro | Texas | 48069 | 1332 | 37 |
1871260 | 1871260 | 2021-10-31 | Castro | Texas | 48069 | 1332 | 37 |
1871517 | 1871517 | 2021-10-31 | Lamoille | Vermont | 50015 | 1332 | 7 |
1871623 | 1871623 | 2021-10-31 | Poquoson city | Virginia | 51735 | 1332 | 19 |
1868011 | 1868011 | 2021-10-30 | Castro | Texas | 48069 | 1332 | 37 |
1868374 | 1868374 | 2021-10-30 | Poquoson city | Virginia | 51735 | 1332 | 19 |
1865125 | 1865125 | 2021-10-29 | Poquoson city | Virginia | 51735 | 1332 | 19 |
1861378 | 1861378 | 2021-10-28 | Turner | South Dakota | 46125 | 1332 | 61 |
1855664 | 1855664 | 2021-10-27 | Sumter | Alabama | 1119 | 1332 | 38 |
1857179 | 1857179 | 2021-10-27 | Oregon | Missouri | 29149 | 1332 | 11 |
1849165 | 1849165 | 2021-10-25 | Sumter | Alabama | 1119 | 1332 | 38 |
1845915 | 1845915 | 2021-10-24 | Sumter | Alabama | 1119 | 1332 | 38 |
1848335 | 1848335 | 2021-10-24 | Custer | South Dakota | 46033 | 1332 | 15 |
1845085 | 1845085 | 2021-10-23 | Custer | South Dakota | 46033 | 1332 | 15 |
1841835 | 1841835 | 2021-10-22 | Custer | South Dakota | 46033 | 1332 | 15 |
1834518 | 1834518 | 2021-10-20 | Sanders | Montana | 30089 | 1332 | 19 |
1836100 | 1836100 | 2021-10-20 | Platte | Wyoming | 56031 | 1332 | 24 |
1830988 | 1830988 | 2021-10-19 | Murray | Minnesota | 27101 | 1332 | 10 |
1825563 | 1825563 | 2021-10-17 | McCormick | South Carolina | 45065 | 1332 | 30 |
1822314 | 1822314 | 2021-10-16 | McCormick | South Carolina | 45065 | 1332 | 30 |
1819065 | 1819065 | 2021-10-15 | McCormick | South Carolina | 45065 | 1332 | 30 |
1814461 | 1814461 | 2021-10-14 | Owen | Kentucky | 21187 | 1332 | 22 |
1807861 | 1807861 | 2021-10-12 | Thomas | Kansas | 20193 | 1332 | 21 |
1803777 | 1803777 | 2021-10-11 | Nevada | Arkansas | 5099 | 1332 | 38 |
1804610 | 1804610 | 2021-10-11 | Thomas | Kansas | 20193 | 1332 | 21 |
1806549 | 1806549 | 2021-10-11 | Amelia | Virginia | 51007 | 1332 | 39 |
1800528 | 1800528 | 2021-10-10 | Nevada | Arkansas | 5099 | 1332 | 37 |
1803299 | 1803299 | 2021-10-10 | Amelia | Virginia | 51007 | 1332 | 39 |
1800050 | 1800050 | 2021-10-09 | Amelia | Virginia | 51007 | 1332 | 39 |
1796801 | 1796801 | 2021-10-08 | Amelia | Virginia | 51007 | 1332 | 39 |
1788420 | 1788420 | 2021-10-06 | Hancock | Kentucky | 21091 | 1332 | 16 |
1786543 | 1786543 | 2021-10-05 | Allendale | South Carolina | 45005 | 1332 | 21 |
1780767 | 1780767 | 2021-10-03 | Ritchie | West Virginia | 54085 | 1332 | 16 |
1773516 | 1773516 | 2021-10-01 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1770266 | 1770266 | 2021-09-30 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1767017 | 1767017 | 2021-09-29 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1763768 | 1763768 | 2021-09-28 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1760519 | 1760519 | 2021-09-27 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1756395 | 1756395 | 2021-09-26 | Carroll | Missouri | 29033 | 1332 | 26 |
1757271 | 1757271 | 2021-09-26 | Quebradillas | Puerto Rico | 72115 | 1332 | |
1750789 | 1750789 | 2021-09-24 | Utuado | Puerto Rico | 72141 | 1332 | |
1751048 | 1751048 | 2021-09-24 | Clay | Texas | 48077 | 1332 | 22 |
1746111 | 1746111 | 2021-09-23 | Rice | Kansas | 20159 | 1332 | 15 |
1747799 | 1747799 | 2021-09-23 | Clay | Texas | 48077 | 1332 | 22 |
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);