ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where cases = 2710 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 21
- Missouri 19
- Kansas 14
- Mississippi 11
- Tennessee 11
- Oklahoma 10
- Georgia 9
- Virginia 9
- Wisconsin 9
- Indiana 8
- Texas 7
- Kentucky 6
- Ohio 6
- Alaska 5
- Colorado 5
- Florida 5
- Illinois 5
- Louisiana 5
- Nebraska 5
- South Carolina 5
- Idaho 4
- Pennsylvania 4
- Rhode Island 4
- Arkansas 3
- California 3
- Michigan 3
- New York 3
- North Carolina 3
- Alabama 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497221 | 2497221 | 2022-05-12 | Brown | Kansas | 20013 | 2710 | 46 |
2493963 | 2493963 | 2022-05-11 | Brown | Kansas | 20013 | 2710 | 46 |
2490705 | 2490705 | 2022-05-10 | Brown | Kansas | 20013 | 2710 | 46 |
2487448 | 2487448 | 2022-05-09 | Brown | Kansas | 20013 | 2710 | 46 |
2484190 | 2484190 | 2022-05-08 | Brown | Kansas | 20013 | 2710 | 46 |
2480932 | 2480932 | 2022-05-07 | Brown | Kansas | 20013 | 2710 | 46 |
2477674 | 2477674 | 2022-05-06 | Brown | Kansas | 20013 | 2710 | 46 |
2354900 | 2354900 | 2022-03-29 | Los Alamos | New Mexico | 35028 | 2710 | 14 |
2338563 | 2338563 | 2022-03-24 | Unknown | Nebraska | 2710 | 437 | |
2283065 | 2283065 | 2022-03-07 | Lewis | Missouri | 29111 | 2710 | 34 |
2279812 | 2279812 | 2022-03-06 | Lewis | Missouri | 29111 | 2710 | 34 |
2276559 | 2276559 | 2022-03-05 | Lewis | Missouri | 29111 | 2710 | 34 |
2273306 | 2273306 | 2022-03-04 | Lewis | Missouri | 29111 | 2710 | 34 |
2256960 | 2256960 | 2022-02-27 | Noxubee | Mississippi | 28103 | 2710 | 48 |
2253709 | 2253709 | 2022-02-26 | Noxubee | Mississippi | 28103 | 2710 | 48 |
2250458 | 2250458 | 2022-02-25 | Noxubee | Mississippi | 28103 | 2710 | 48 |
2218908 | 2218908 | 2022-02-15 | Calhoun | South Carolina | 45017 | 2710 | 55 |
2203591 | 2203591 | 2022-02-11 | Chicot | Arkansas | 5017 | 2710 | 52 |
2169017 | 2169017 | 2022-01-31 | Aitkin | Minnesota | 27001 | 2710 | 58 |
2156669 | 2156669 | 2022-01-27 | Washington | North Carolina | 37187 | 2710 | 41 |
2143235 | 2143235 | 2022-01-23 | Pemiscot | Missouri | 29155 | 2710 | 60 |
2129826 | 2129826 | 2022-01-19 | West Carroll | Louisiana | 22123 | 2710 | 53 |
2125468 | 2125468 | 2022-01-18 | Kusilvak Census Area | Alaska | 2158 | 2710 | 9 |
2125646 | 2125646 | 2022-01-18 | Crowley | Colorado | 8025 | 2710 | 27 |
2127969 | 2127969 | 2022-01-18 | Lewis | Tennessee | 47101 | 2710 | 48 |
2122216 | 2122216 | 2022-01-17 | Kusilvak Census Area | Alaska | 2158 | 2710 | 9 |
2123702 | 2123702 | 2022-01-17 | Mississippi | Missouri | 29133 | 2710 | 51 |
2124717 | 2124717 | 2022-01-17 | Lewis | Tennessee | 47101 | 2710 | 48 |
2118964 | 2118964 | 2022-01-16 | Kusilvak Census Area | Alaska | 2158 | 2710 | 9 |
2120450 | 2120450 | 2022-01-16 | Mississippi | Missouri | 29133 | 2710 | 51 |
2120620 | 2120620 | 2022-01-16 | Otoe | Nebraska | 31131 | 2710 | 16 |
2121465 | 2121465 | 2022-01-16 | Lewis | Tennessee | 47101 | 2710 | 48 |
2115712 | 2115712 | 2022-01-15 | Kusilvak Census Area | Alaska | 2158 | 2710 | 9 |
2117198 | 2117198 | 2022-01-15 | Mississippi | Missouri | 29133 | 2710 | 51 |
2117368 | 2117368 | 2022-01-15 | Otoe | Nebraska | 31131 | 2710 | 16 |
2118213 | 2118213 | 2022-01-15 | Lewis | Tennessee | 47101 | 2710 | 48 |
2112460 | 2112460 | 2022-01-14 | Kusilvak Census Area | Alaska | 2158 | 2710 | 9 |
2114117 | 2114117 | 2022-01-14 | Otoe | Nebraska | 31131 | 2710 | 16 |
2114962 | 2114962 | 2022-01-14 | Lewis | Tennessee | 47101 | 2710 | 48 |
2111186 | 2111186 | 2022-01-13 | Walsh | North Dakota | 38099 | 2710 | 34 |
2111710 | 2111710 | 2022-01-13 | Lewis | Tennessee | 47101 | 2710 | 48 |
2108458 | 2108458 | 2022-01-12 | Lewis | Tennessee | 47101 | 2710 | 48 |
2079908 | 2079908 | 2022-01-04 | Macon | Alabama | 1087 | 2710 | 69 |
2080927 | 2080927 | 2022-01-04 | Knott | Kentucky | 21119 | 2710 | 47 |
2040820 | 2040820 | 2021-12-22 | Richland | Wisconsin | 55103 | 2710 | 35 |
2017307 | 2017307 | 2021-12-15 | Lee | South Carolina | 45061 | 2710 | 79 |
2017870 | 2017870 | 2021-12-15 | New Kent | Virginia | 51127 | 2710 | 27 |
2013797 | 2013797 | 2021-12-14 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
2010546 | 2010546 | 2021-12-13 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
2007295 | 2007295 | 2021-12-12 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
2004044 | 2004044 | 2021-12-11 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
2000793 | 2000793 | 2021-12-10 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
1997543 | 1997543 | 2021-12-09 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
1998130 | 1998130 | 2021-12-09 | Llano | Texas | 48299 | 2710 | 80 |
1994292 | 1994292 | 2021-12-08 | Kingfisher | Oklahoma | 40073 | 2710 | 56 |
1992019 | 1992019 | 2021-12-07 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1988768 | 1988768 | 2021-12-06 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1985518 | 1985518 | 2021-12-05 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1982268 | 1982268 | 2021-12-04 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1979018 | 1979018 | 2021-12-03 | Crawford | Wisconsin | 55023 | 2710 | 23 |
1924314 | 1924314 | 2021-11-17 | Jefferson | Georgia | 13163 | 2710 | 87 |
1917958 | 1917958 | 2021-11-15 | Clay | Illinois | 17025 | 2710 | 59 |
1898728 | 1898728 | 2021-11-09 | Tama | Iowa | 19171 | 2710 | 77 |
1898902 | 1898902 | 2021-11-09 | Jackson | Kentucky | 21109 | 2710 | 50 |
1895478 | 1895478 | 2021-11-08 | Tama | Iowa | 19171 | 2710 | 77 |
1892228 | 1892228 | 2021-11-07 | Tama | Iowa | 19171 | 2710 | 77 |
1888978 | 1888978 | 2021-11-06 | Tama | Iowa | 19171 | 2710 | 77 |
1885728 | 1885728 | 2021-11-05 | Tama | Iowa | 19171 | 2710 | 77 |
1882479 | 1882479 | 2021-11-04 | Tama | Iowa | 19171 | 2710 | 77 |
1879230 | 1879230 | 2021-11-03 | Tama | Iowa | 19171 | 2710 | 77 |
1841687 | 1841687 | 2021-10-22 | Wyoming | Pennsylvania | 42131 | 2710 | 62 |
1830455 | 1830455 | 2021-10-19 | Jackson | Iowa | 19097 | 2710 | 45 |
1830759 | 1830759 | 2021-10-19 | LaSalle | Louisiana | 22059 | 2710 | 46 |
1827206 | 1827206 | 2021-10-18 | Jackson | Iowa | 19097 | 2710 | 45 |
1823957 | 1823957 | 2021-10-17 | Jackson | Iowa | 19097 | 2710 | 45 |
1820708 | 1820708 | 2021-10-16 | Jackson | Iowa | 19097 | 2710 | 45 |
1817459 | 1817459 | 2021-10-15 | Jackson | Iowa | 19097 | 2710 | 45 |
1818138 | 1818138 | 2021-10-15 | Cooper | Missouri | 29053 | 2710 | 33 |
1814211 | 1814211 | 2021-10-14 | Jackson | Iowa | 19097 | 2710 | 45 |
1810962 | 1810962 | 2021-10-13 | Jackson | Iowa | 19097 | 2710 | 45 |
1770412 | 1770412 | 2021-09-30 | Cannon | Tennessee | 47015 | 2710 | 38 |
1765326 | 1765326 | 2021-09-29 | White | Illinois | 17193 | 2710 | 42 |
1759651 | 1759651 | 2021-09-27 | Clinton | Missouri | 29049 | 2710 | 75 |
1760873 | 1760873 | 2021-09-27 | Jackson | Texas | 48239 | 2710 | 47 |
1761154 | 1761154 | 2021-09-27 | Prince Edward | Virginia | 51147 | 2710 | 44 |
1744720 | 1744720 | 2021-09-22 | Shelby | Texas | 48419 | 2710 | 90 |
1739463 | 1739463 | 2021-09-21 | Dickinson | Iowa | 19059 | 2710 | 46 |
1736214 | 1736214 | 2021-09-20 | Dickinson | Iowa | 19059 | 2710 | 46 |
1732964 | 1732964 | 2021-09-19 | Dickinson | Iowa | 19059 | 2710 | 46 |
1729714 | 1729714 | 2021-09-18 | Dickinson | Iowa | 19059 | 2710 | 46 |
1726464 | 1726464 | 2021-09-17 | Dickinson | Iowa | 19059 | 2710 | 46 |
1723215 | 1723215 | 2021-09-16 | Dickinson | Iowa | 19059 | 2710 | 46 |
1719966 | 1719966 | 2021-09-15 | Dickinson | Iowa | 19059 | 2710 | 46 |
1716031 | 1716031 | 2021-09-14 | Hempstead | Arkansas | 5057 | 2710 | 24 |
1710163 | 1710163 | 2021-09-12 | Owen | Indiana | 18119 | 2710 | 63 |
1706916 | 1706916 | 2021-09-11 | Owen | Indiana | 18119 | 2710 | 63 |
1703668 | 1703668 | 2021-09-10 | Owen | Indiana | 18119 | 2710 | 63 |
1679962 | 1679962 | 2021-09-02 | Waynesboro city | Virginia | 51820 | 2710 | 39 |
1670844 | 1670844 | 2021-08-31 | Crisp | Georgia | 13081 | 2710 | 95 |
1664112 | 1664112 | 2021-08-29 | Colusa | California | 6011 | 2710 | 18 |
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);