ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 1524 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 29
- Texas 29
- Georgia 25
- Oklahoma 17
- Iowa 13
- Kentucky 12
- Florida 11
- Michigan 10
- Missouri 10
- Wyoming 10
- Alabama 9
- Minnesota 9
- Montana 9
- Puerto Rico 9
- Wisconsin 9
- Louisiana 7
- Virginia 7
- Mississippi 6
- North Carolina 6
- Tennessee 6
- Washington 6
- Indiana 5
- South Dakota 5
- Arkansas 4
- Ohio 4
- Vermont 4
- West Virginia 4
- Colorado 3
- Idaho 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502588 | 2502588 | 2022-05-13 | Mathews | Virginia | 51115 | 1524 | 27 |
2476929 | 2476929 | 2022-05-06 | Montgomery | Arkansas | 5097 | 1524 | 57 |
2473671 | 2473671 | 2022-05-05 | Montgomery | Arkansas | 5097 | 1524 | 57 |
2438304 | 2438304 | 2022-04-24 | Calhoun | Illinois | 17013 | 1524 | 8 |
2440063 | 2440063 | 2022-04-24 | Guanica | Puerto Rico | 72055 | 1524 | |
2435048 | 2435048 | 2022-04-23 | Calhoun | Illinois | 17013 | 1524 | 8 |
2431792 | 2431792 | 2022-04-22 | Calhoun | Illinois | 17013 | 1524 | 8 |
2358983 | 2358983 | 2022-03-30 | Carson | Texas | 48065 | 1524 | 34 |
2335213 | 2335213 | 2022-03-23 | Stillwater | Montana | 30095 | 1524 | 29 |
2331959 | 2331959 | 2022-03-22 | Stillwater | Montana | 30095 | 1524 | 29 |
2262528 | 2262528 | 2022-03-01 | Twiggs | Georgia | 13289 | 1524 | 67 |
2260465 | 2260465 | 2022-02-28 | Keith | Nebraska | 31101 | 1524 | 17 |
2216481 | 2216481 | 2022-02-14 | Weston | Wyoming | 56045 | 1524 | 17 |
2213230 | 2213230 | 2022-02-13 | Weston | Wyoming | 56045 | 1524 | 17 |
2209977 | 2209977 | 2022-02-12 | Weston | Wyoming | 56045 | 1524 | 17 |
2206724 | 2206724 | 2022-02-11 | Weston | Wyoming | 56045 | 1524 | 17 |
2156337 | 2156337 | 2022-01-27 | Valley | Montana | 30105 | 1524 | 33 |
2156394 | 2156394 | 2022-01-27 | Knox | Nebraska | 31107 | 1524 | 13 |
2146518 | 2146518 | 2022-01-24 | Sullivan | Missouri | 29211 | 1524 | 19 |
2123303 | 2123303 | 2022-01-17 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2124633 | 2124633 | 2022-01-17 | Hutchinson | South Dakota | 46067 | 1524 | 30 |
2125374 | 2125374 | 2022-01-17 | Johnson | Wyoming | 56019 | 1524 | 18 |
2120051 | 2120051 | 2022-01-16 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2121381 | 2121381 | 2022-01-16 | Hutchinson | South Dakota | 46067 | 1524 | 30 |
2122122 | 2122122 | 2022-01-16 | Johnson | Wyoming | 56019 | 1524 | 18 |
2116799 | 2116799 | 2022-01-15 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2118129 | 2118129 | 2022-01-15 | Hutchinson | South Dakota | 46067 | 1524 | 30 |
2118870 | 2118870 | 2022-01-15 | Johnson | Wyoming | 56019 | 1524 | 18 |
2113548 | 2113548 | 2022-01-14 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2114878 | 2114878 | 2022-01-14 | Hutchinson | South Dakota | 46067 | 1524 | 30 |
2115618 | 2115618 | 2022-01-14 | Johnson | Wyoming | 56019 | 1524 | 18 |
2110771 | 2110771 | 2022-01-13 | Madison | Montana | 30057 | 1524 | 20 |
2111500 | 2111500 | 2022-01-13 | Jayuya | Puerto Rico | 72073 | 1524 | |
2106911 | 2106911 | 2022-01-12 | Elliott | Kentucky | 21063 | 1524 | 14 |
2092251 | 2092251 | 2022-01-07 | Archer | Texas | 48009 | 1524 | 24 |
2092326 | 2092326 | 2022-01-07 | Franklin | Texas | 48159 | 1524 | 37 |
2086134 | 2086134 | 2022-01-05 | Northumberland | Virginia | 51133 | 1524 | 39 |
2075956 | 2075956 | 2022-01-02 | Moore | Tennessee | 47127 | 1524 | 31 |
2072705 | 2072705 | 2022-01-01 | Moore | Tennessee | 47127 | 1524 | 31 |
2069454 | 2069454 | 2021-12-31 | Moore | Tennessee | 47127 | 1524 | 31 |
2066203 | 2066203 | 2021-12-30 | Moore | Tennessee | 47127 | 1524 | 31 |
2060354 | 2060354 | 2021-12-28 | Sublette | Wyoming | 56035 | 1524 | 23 |
2056349 | 2056349 | 2021-12-27 | Grant | South Dakota | 46051 | 1524 | 47 |
2053694 | 2053694 | 2021-12-26 | Lincoln | Washington | 53043 | 1524 | 26 |
2050444 | 2050444 | 2021-12-25 | Lincoln | Washington | 53043 | 1524 | 26 |
2047194 | 2047194 | 2021-12-24 | Lincoln | Washington | 53043 | 1524 | 26 |
2043944 | 2043944 | 2021-12-23 | Lincoln | Washington | 53043 | 1524 | 26 |
2040721 | 2040721 | 2021-12-22 | Doddridge | West Virginia | 54017 | 1524 | 13 |
2032687 | 2032687 | 2021-12-20 | Oregon | Missouri | 29149 | 1524 | 27 |
1992652 | 1992652 | 2021-12-08 | Wilkinson | Georgia | 13319 | 1524 | 46 |
1989401 | 1989401 | 2021-12-07 | Wilkinson | Georgia | 13319 | 1524 | 46 |
1986697 | 1986697 | 2021-12-06 | Owen | Kentucky | 21187 | 1524 | 28 |
1982901 | 1982901 | 2021-12-05 | Wilkinson | Georgia | 13319 | 1524 | 47 |
1979651 | 1979651 | 2021-12-04 | Wilkinson | Georgia | 13319 | 1524 | 47 |
1976401 | 1976401 | 2021-12-03 | Wilkinson | Georgia | 13319 | 1524 | 47 |
1973152 | 1973152 | 2021-12-02 | Wilkinson | Georgia | 13319 | 1524 | 47 |
1945535 | 1945535 | 2021-11-23 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1941514 | 1941514 | 2021-11-22 | Benton | Mississippi | 28009 | 1524 | 39 |
1942284 | 1942284 | 2021-11-22 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1939034 | 1939034 | 2021-11-21 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1935784 | 1935784 | 2021-11-20 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1930348 | 1930348 | 2021-11-19 | Bullock | Alabama | 1011 | 1524 | 45 |
1932534 | 1932534 | 2021-11-19 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1927098 | 1927098 | 2021-11-18 | Bullock | Alabama | 1011 | 1524 | 45 |
1929283 | 1929283 | 2021-11-18 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1926033 | 1926033 | 2021-11-17 | Latimer | Oklahoma | 40077 | 1524 | 23 |
1920599 | 1920599 | 2021-11-16 | Bullock | Alabama | 1011 | 1524 | 44 |
1897411 | 1897411 | 2021-11-08 | Rains | Texas | 48379 | 1524 | 47 |
1891852 | 1891852 | 2021-11-07 | Pulaski | Georgia | 13235 | 1524 | 61 |
1894161 | 1894161 | 2021-11-07 | Rains | Texas | 48379 | 1524 | 47 |
1888101 | 1888101 | 2021-11-06 | Bullock | Alabama | 1011 | 1524 | 44 |
1888602 | 1888602 | 2021-11-06 | Pulaski | Georgia | 13235 | 1524 | 61 |
1890911 | 1890911 | 2021-11-06 | Rains | Texas | 48379 | 1524 | 47 |
1885352 | 1885352 | 2021-11-05 | Pulaski | Georgia | 13235 | 1524 | 61 |
1887661 | 1887661 | 2021-11-05 | Rains | Texas | 48379 | 1524 | 47 |
1881602 | 1881602 | 2021-11-04 | Bullock | Alabama | 1011 | 1524 | 44 |
1882103 | 1882103 | 2021-11-04 | Pulaski | Georgia | 13235 | 1524 | 61 |
1878353 | 1878353 | 2021-11-03 | Bullock | Alabama | 1011 | 1524 | 44 |
1875807 | 1875807 | 2021-11-02 | Benton | Indiana | 18007 | 1524 | 17 |
1876458 | 1876458 | 2021-11-02 | Jackson | Minnesota | 27063 | 1524 | 15 |
1870278 | 1870278 | 2021-10-31 | Box Butte | Nebraska | 31013 | 1524 | 12 |
1831501 | 1831501 | 2021-10-19 | Schuyler | New York | 36097 | 1524 | 17 |
1832273 | 1832273 | 2021-10-19 | Clay | Texas | 48077 | 1524 | 23 |
1826854 | 1826854 | 2021-10-18 | Montgomery | Georgia | 13209 | 1524 | 39 |
1810208 | 1810208 | 2021-10-13 | Valdez-Cordova Census Area | Alaska | 2261 | 1524 | 5 |
1804165 | 1804165 | 2021-10-11 | Wilkes | Georgia | 13317 | 1524 | 34 |
1800916 | 1800916 | 2021-10-10 | Wilkes | Georgia | 13317 | 1524 | 34 |
1797667 | 1797667 | 2021-10-09 | Wilkes | Georgia | 13317 | 1524 | 34 |
1794418 | 1794418 | 2021-10-08 | Wilkes | Georgia | 13317 | 1524 | 34 |
1793532 | 1793532 | 2021-10-07 | Caledonia | Vermont | 50005 | 1524 | 11 |
1762209 | 1762209 | 2021-09-28 | Franklin | Iowa | 19069 | 1524 | 24 |
1758961 | 1758961 | 2021-09-27 | Franklin | Iowa | 19069 | 1524 | 24 |
1755457 | 1755457 | 2021-09-26 | Clearwater | Idaho | 16035 | 1524 | 22 |
1755713 | 1755713 | 2021-09-26 | Franklin | Iowa | 19069 | 1524 | 24 |
1752209 | 1752209 | 2021-09-25 | Clearwater | Idaho | 16035 | 1524 | 22 |
1752465 | 1752465 | 2021-09-25 | Franklin | Iowa | 19069 | 1524 | 24 |
1748960 | 1748960 | 2021-09-24 | Clearwater | Idaho | 16035 | 1524 | 22 |
1749216 | 1749216 | 2021-09-24 | Franklin | Iowa | 19069 | 1524 | 24 |
1745966 | 1745966 | 2021-09-23 | Franklin | Iowa | 19069 | 1524 | 24 |
1742527 | 1742527 | 2021-09-22 | Jasper | Illinois | 17079 | 1524 | 20 |
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);