ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
403 rows where cases = 905 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 48
- Missouri 21
- Texas 20
- North Carolina 18
- Indiana 16
- Iowa 16
- Nebraska 16
- Minnesota 15
- Puerto Rico 15
- Kentucky 14
- Montana 14
- Kansas 13
- Virginia 11
- Alabama 10
- Michigan 10
- Alaska 9
- South Carolina 9
- Arkansas 8
- New York 8
- Colorado 7
- Illinois 7
- Ohio 7
- Mississippi 6
- Oregon 6
- South Dakota 6
- West Virginia 6
- California 5
- Florida 5
- New Mexico 5
- North Dakota 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499261 | 2499261 | 2022-05-12 | Bath | Virginia | 51017 | 905 | 20 |
2465615 | 2465615 | 2022-05-02 | Hamilton | New York | 36041 | 905 | 5 |
2375930 | 2375930 | 2022-04-05 | Unknown | Alaska | 905 | 1 | |
2372678 | 2372678 | 2022-04-04 | Unknown | Alaska | 905 | 1 | |
2369425 | 2369425 | 2022-04-03 | Unknown | Alaska | 905 | 1 | |
2366172 | 2366172 | 2022-04-02 | Unknown | Alaska | 905 | 1 | |
2362919 | 2362919 | 2022-04-01 | Unknown | Alaska | 905 | 1 | |
2330386 | 2330386 | 2022-03-22 | Unknown | Alaska | 905 | 1 | |
2327134 | 2327134 | 2022-03-21 | Unknown | Alaska | 905 | 1 | |
2294298 | 2294298 | 2022-03-10 | Rappahannock | Virginia | 51157 | 905 | 9 |
2240885 | 2240885 | 2022-02-22 | Musselshell | Montana | 30065 | 905 | 26 |
2211368 | 2211368 | 2022-02-13 | Red Lake | Minnesota | 27125 | 905 | 11 |
2208115 | 2208115 | 2022-02-12 | Red Lake | Minnesota | 27125 | 905 | 11 |
2204862 | 2204862 | 2022-02-11 | Red Lake | Minnesota | 27125 | 905 | 11 |
2179933 | 2179933 | 2022-02-03 | Edmunds | South Dakota | 46045 | 905 | 16 |
2169274 | 2169274 | 2022-01-31 | Putnam | Missouri | 29171 | 905 | 20 |
2170412 | 2170412 | 2022-01-31 | Hall | Texas | 48191 | 905 | 20 |
2166019 | 2166019 | 2022-01-30 | Putnam | Missouri | 29171 | 905 | 20 |
2162764 | 2162764 | 2022-01-29 | Putnam | Missouri | 29171 | 905 | 20 |
2159946 | 2159946 | 2022-01-28 | Foster | North Dakota | 38031 | 905 | 20 |
2155607 | 2155607 | 2022-01-27 | Haskell | Kansas | 20081 | 905 | 10 |
2152354 | 2152354 | 2022-01-26 | Haskell | Kansas | 20081 | 905 | 10 |
2123887 | 2123887 | 2022-01-17 | Sheridan | Nebraska | 31161 | 905 | 23 |
2120943 | 2120943 | 2022-01-16 | Wells | North Dakota | 38103 | 905 | 11 |
2117651 | 2117651 | 2022-01-15 | Dunn | North Dakota | 38025 | 905 | 8 |
2107918 | 2107918 | 2022-01-12 | Pierce | North Dakota | 38069 | 905 | 29 |
2096534 | 2096534 | 2022-01-09 | Calhoun | Georgia | 13037 | 905 | 22 |
2093282 | 2093282 | 2022-01-08 | Calhoun | Georgia | 13037 | 905 | 22 |
2090030 | 2090030 | 2022-01-07 | Calhoun | Georgia | 13037 | 905 | 22 |
2086779 | 2086779 | 2022-01-06 | Calhoun | Georgia | 13037 | 905 | 22 |
2089333 | 2089333 | 2022-01-06 | Emporia city | Virginia | 51595 | 905 | 46 |
2083527 | 2083527 | 2022-01-05 | Calhoun | Georgia | 13037 | 905 | 22 |
2078356 | 2078356 | 2022-01-03 | Polk | Nebraska | 31143 | 905 | 18 |
2079119 | 2079119 | 2022-01-03 | Lyman | South Dakota | 46085 | 905 | 12 |
2057742 | 2057742 | 2021-12-28 | Gallatin | Illinois | 17059 | 905 | 11 |
2037886 | 2037886 | 2021-12-22 | Huerfano | Colorado | 8055 | 905 | 26 |
2027012 | 2027012 | 2021-12-18 | Santa Isabel | Puerto Rico | 72133 | 905 | |
2017929 | 2017929 | 2021-12-15 | Ferry | Washington | 53019 | 905 | 18 |
1996314 | 1996314 | 2021-12-09 | Morris | Kansas | 20127 | 905 | 22 |
1993063 | 1993063 | 2021-12-08 | Morris | Kansas | 20127 | 905 | 22 |
1960362 | 1960362 | 2021-11-28 | Ohio | Indiana | 18115 | 905 | 13 |
1961264 | 1961264 | 2021-11-28 | Teton | Montana | 30099 | 905 | 18 |
1957111 | 1957111 | 2021-11-27 | Ohio | Indiana | 18115 | 905 | 13 |
1958013 | 1958013 | 2021-11-27 | Teton | Montana | 30099 | 905 | 18 |
1953860 | 1953860 | 2021-11-26 | Ohio | Indiana | 18115 | 905 | 13 |
1954762 | 1954762 | 2021-11-26 | Teton | Montana | 30099 | 905 | 18 |
1950609 | 1950609 | 2021-11-25 | Ohio | Indiana | 18115 | 905 | 13 |
1947358 | 1947358 | 2021-11-24 | Ohio | Indiana | 18115 | 905 | 13 |
1944871 | 1944871 | 2021-11-23 | Dade | Missouri | 29057 | 905 | 38 |
1945063 | 1945063 | 2021-11-23 | Jefferson | Nebraska | 31095 | 905 | 3 |
1945170 | 1945170 | 2021-11-23 | Guadalupe | New Mexico | 35019 | 905 | 15 |
1921927 | 1921927 | 2021-11-16 | Big Stone | Minnesota | 27011 | 905 | 5 |
1917931 | 1917931 | 2021-11-15 | Lemhi | Idaho | 16059 | 905 | 19 |
1919814 | 1919814 | 2021-11-15 | Brule | South Dakota | 46015 | 905 | 11 |
1905663 | 1905663 | 2021-11-11 | Schoolcraft | Michigan | 26153 | 905 | 5 |
1902414 | 1902414 | 2021-11-10 | Schoolcraft | Michigan | 26153 | 905 | 5 |
1898777 | 1898777 | 2021-11-09 | Gray | Kansas | 20069 | 905 | 18 |
1898833 | 1898833 | 2021-11-09 | Sherman | Kansas | 20181 | 905 | 13 |
1895527 | 1895527 | 2021-11-08 | Gray | Kansas | 20069 | 905 | 18 |
1895583 | 1895583 | 2021-11-08 | Sherman | Kansas | 20181 | 905 | 13 |
1878359 | 1878359 | 2021-11-03 | Choctaw | Alabama | 1023 | 905 | 27 |
1878421 | 1878421 | 2021-11-03 | Dillingham Census Area | Alaska | 2070 | 905 | 6 |
1875110 | 1875110 | 2021-11-02 | Choctaw | Alabama | 1023 | 905 | 27 |
1860235 | 1860235 | 2021-10-28 | Norman | Minnesota | 27107 | 905 | 9 |
1854090 | 1854090 | 2021-10-26 | Nemaha | Nebraska | 31127 | 905 | 15 |
1850841 | 1850841 | 2021-10-25 | Nemaha | Nebraska | 31127 | 905 | 15 |
1847591 | 1847591 | 2021-10-24 | Nemaha | Nebraska | 31127 | 905 | 15 |
1844341 | 1844341 | 2021-10-23 | Nemaha | Nebraska | 31127 | 905 | 15 |
1841091 | 1841091 | 2021-10-22 | Nemaha | Nebraska | 31127 | 905 | 15 |
1837842 | 1837842 | 2021-10-21 | Nemaha | Nebraska | 31127 | 905 | 15 |
1812617 | 1812617 | 2021-10-13 | Kingsbury | South Dakota | 46077 | 905 | 18 |
1807165 | 1807165 | 2021-10-12 | Rio Blanco | Colorado | 8103 | 905 | 8 |
1793405 | 1793405 | 2021-10-07 | McCulloch | Texas | 48307 | 905 | 31 |
1784380 | 1784380 | 2021-10-05 | Conejos | Colorado | 8021 | 905 | 31 |
1779290 | 1779290 | 2021-10-03 | Toole | Montana | 30101 | 905 | 11 |
1776040 | 1776040 | 2021-10-02 | Toole | Montana | 30101 | 905 | 11 |
1772790 | 1772790 | 2021-10-01 | Toole | Montana | 30101 | 905 | 11 |
1764208 | 1764208 | 2021-09-28 | San Saba | Texas | 48411 | 905 | 25 |
1760370 | 1760370 | 2021-09-27 | Harney | Oregon | 41025 | 905 | 18 |
1760955 | 1760955 | 2021-09-27 | Sabine | Texas | 48403 | 905 | 65 |
1743617 | 1743617 | 2021-09-22 | Merrick | Nebraska | 31121 | 905 | 15 |
1707746 | 1707746 | 2021-09-11 | Shannon | Missouri | 29203 | 905 | 16 |
1697190 | 1697190 | 2021-09-08 | Union | Indiana | 18161 | 905 | 11 |
1696156 | 1696156 | 2021-09-07 | Lunenburg | Virginia | 51111 | 905 | 18 |
1686282 | 1686282 | 2021-09-04 | Winkler | Texas | 48495 | 905 | 24 |
1683031 | 1683031 | 2021-09-03 | Winkler | Texas | 48495 | 905 | 23 |
1654455 | 1654455 | 2021-08-26 | Lake | Colorado | 8065 | 905 | 1 |
1632527 | 1632527 | 2021-08-19 | Owen | Kentucky | 21187 | 905 | 13 |
1629724 | 1629724 | 2021-08-18 | Hickory | Missouri | 29085 | 905 | 17 |
1625419 | 1625419 | 2021-08-17 | Lincoln | Georgia | 13181 | 905 | 28 |
1617340 | 1617340 | 2021-08-14 | Vinton | Ohio | 39163 | 905 | 17 |
1603099 | 1603099 | 2021-08-10 | Anderson | Kansas | 20003 | 905 | 19 |
1599850 | 1599850 | 2021-08-09 | Anderson | Kansas | 20003 | 905 | 19 |
1600386 | 1600386 | 2021-08-09 | Franklin | Mississippi | 28037 | 905 | 24 |
1596194 | 1596194 | 2021-08-08 | Miller | Georgia | 13201 | 905 | 14 |
1592945 | 1592945 | 2021-08-07 | Miller | Georgia | 13201 | 905 | 14 |
1589696 | 1589696 | 2021-08-06 | Miller | Georgia | 13201 | 905 | 14 |
1591561 | 1591561 | 2021-08-06 | Comerio | Puerto Rico | 72045 | 905 | |
1589067 | 1589067 | 2021-08-05 | Gilmer | West Virginia | 54021 | 905 | 7 |
1576697 | 1576697 | 2021-08-02 | McIntosh | Georgia | 13191 | 905 | 16 |
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);