ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where cases = 293 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 63
- Virginia 48
- Kansas 44
- Georgia 34
- Missouri 34
- North Dakota 31
- Colorado 29
- Pennsylvania 29
- Puerto Rico 29
- Nebraska 28
- Iowa 25
- Kentucky 25
- Mississippi 25
- Montana 25
- Arkansas 22
- Oklahoma 22
- Indiana 20
- Idaho 19
- Tennessee 19
- South Dakota 18
- Minnesota 17
- Illinois 16
- North Carolina 16
- New York 15
- Ohio 15
- Alabama 13
- Wisconsin 12
- Michigan 10
- California 9
- Florida 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290061 | 2290061 | 2022-03-09 | Sheridan | North Dakota | 38083 | 293 | 7 |
2240185 | 2240185 | 2022-02-22 | Lane | Kansas | 20101 | 293 | 11 |
2236934 | 2236934 | 2022-02-21 | Lane | Kansas | 20101 | 293 | 11 |
2176694 | 2176694 | 2022-02-02 | Hyde | South Dakota | 46069 | 293 | 5 |
2177092 | 2177092 | 2022-02-02 | Piute | Utah | 49031 | 293 | 6 |
2164688 | 2164688 | 2022-01-30 | Cheyenne | Colorado | 8017 | 293 | 9 |
2158177 | 2158177 | 2022-01-28 | Cheyenne | Colorado | 8017 | 293 | 9 |
2144502 | 2144502 | 2022-01-23 | Stonewall | Texas | 48433 | 293 | 7 |
2132827 | 2132827 | 2022-01-20 | Greeley | Kansas | 20071 | 293 | 3 |
2129574 | 2129574 | 2022-01-19 | Greeley | Kansas | 20071 | 293 | 3 |
2130294 | 2130294 | 2022-01-19 | Powder River | Montana | 30075 | 293 | 10 |
2109405 | 2109405 | 2022-01-13 | Kiowa | Colorado | 8061 | 293 | 4 |
2104326 | 2104326 | 2022-01-11 | Dundy | Nebraska | 31057 | 293 | 6 |
2101075 | 2101075 | 2022-01-10 | Dundy | Nebraska | 31057 | 293 | 6 |
2086632 | 2086632 | 2022-01-06 | Dolores | Colorado | 8033 | 293 | 6 |
2089265 | 2089265 | 2022-01-06 | Rich | Utah | 49033 | 293 | 0 |
2057183 | 2057183 | 2021-12-28 | Denali Borough | Alaska | 2068 | 293 | 1 |
2053934 | 2053934 | 2021-12-27 | Denali Borough | Alaska | 2068 | 293 | 1 |
2023769 | 2023769 | 2021-12-17 | Vieques | Puerto Rico | 72147 | 293 | |
2020518 | 2020518 | 2021-12-16 | Vieques | Puerto Rico | 72147 | 293 | |
2017267 | 2017267 | 2021-12-15 | Vieques | Puerto Rico | 72147 | 293 | |
2011266 | 2011266 | 2021-12-13 | Wayne | Utah | 49055 | 293 | 0 |
1987215 | 1987215 | 2021-12-06 | Worth | Missouri | 29227 | 293 | 2 |
1964557 | 1964557 | 2021-11-29 | Garfield | Nebraska | 31071 | 293 | 2 |
1937841 | 1937841 | 2021-11-21 | Wallace | Kansas | 20199 | 293 | 4 |
1934591 | 1934591 | 2021-11-20 | Wallace | Kansas | 20199 | 293 | 4 |
1931340 | 1931340 | 2021-11-19 | Wallace | Kansas | 20199 | 293 | 4 |
1900941 | 1900941 | 2021-11-09 | Wahkiakum | Washington | 53069 | 293 | 5 |
1882531 | 1882531 | 2021-11-04 | Hamilton | Kansas | 20075 | 293 | 1 |
1879282 | 1879282 | 2021-11-03 | Hamilton | Kansas | 20075 | 293 | 1 |
1871935 | 1871935 | 2021-11-01 | Petersburg Borough | Alaska | 2195 | 293 | 2 |
1859852 | 1859852 | 2021-10-28 | Wichita | Kansas | 20203 | 293 | 6 |
1856603 | 1856603 | 2021-10-27 | Wichita | Kansas | 20203 | 293 | 6 |
1819449 | 1819449 | 2021-10-15 | Sherman | Texas | 48421 | 293 | 15 |
1815377 | 1815377 | 2021-10-14 | Burke | North Dakota | 38013 | 293 | 3 |
1816200 | 1816200 | 2021-10-14 | Sherman | Texas | 48421 | 293 | 15 |
1812952 | 1812952 | 2021-10-13 | Sherman | Texas | 48421 | 293 | 15 |
1808547 | 1808547 | 2021-10-12 | Brown | Nebraska | 31017 | 293 | 4 |
1799143 | 1799143 | 2021-10-09 | Grant | North Dakota | 38037 | 293 | 7 |
1782576 | 1782576 | 2021-10-04 | Franklin | Nebraska | 31061 | 293 | 6 |
1783373 | 1783373 | 2021-10-04 | Jerauld | South Dakota | 46073 | 293 | 17 |
1780713 | 1780713 | 2021-10-03 | San Juan | Washington | 53055 | 293 | 0 |
1777463 | 1777463 | 2021-10-02 | San Juan | Washington | 53055 | 293 | 0 |
1774213 | 1774213 | 2021-10-01 | San Juan | Washington | 53055 | 293 | 0 |
1767136 | 1767136 | 2021-09-29 | Mellette | South Dakota | 46095 | 293 | 2 |
1760636 | 1760636 | 2021-09-27 | McPherson | South Dakota | 46089 | 293 | 5 |
1760891 | 1760891 | 2021-09-27 | Knox | Texas | 48275 | 293 | 20 |
1757643 | 1757643 | 2021-09-26 | Knox | Texas | 48275 | 293 | 20 |
1754395 | 1754395 | 2021-09-25 | Knox | Texas | 48275 | 293 | 20 |
1751220 | 1751220 | 2021-09-24 | Sherman | Texas | 48421 | 293 | 13 |
1747971 | 1747971 | 2021-09-23 | Sherman | Texas | 48421 | 293 | 13 |
1744721 | 1744721 | 2021-09-22 | Sherman | Texas | 48421 | 293 | 13 |
1740800 | 1740800 | 2021-09-21 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1737551 | 1737551 | 2021-09-20 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1738303 | 1738303 | 2021-09-20 | Grand Isle | Vermont | 50013 | 293 | 2 |
1734301 | 1734301 | 2021-09-19 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1731051 | 1731051 | 2021-09-18 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1727801 | 1727801 | 2021-09-17 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1723318 | 1723318 | 2021-09-16 | Graham | Kansas | 20065 | 293 | 10 |
1724552 | 1724552 | 2021-09-16 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1720069 | 1720069 | 2021-09-15 | Graham | Kansas | 20065 | 293 | 10 |
1720242 | 1720242 | 2021-09-15 | Robertson | Kentucky | 21201 | 293 | 15 |
1721303 | 1721303 | 2021-09-15 | Cimarron | Oklahoma | 40025 | 293 | 2 |
1713222 | 1713222 | 2021-09-13 | Custer | Idaho | 16037 | 293 | 3 |
1695179 | 1695179 | 2021-09-07 | Golden Valley | North Dakota | 38033 | 293 | 4 |
1695646 | 1695646 | 2021-09-07 | Haakon | South Dakota | 46055 | 293 | 11 |
1695945 | 1695945 | 2021-09-07 | Menard | Texas | 48327 | 293 | 10 |
1691931 | 1691931 | 2021-09-06 | Golden Valley | North Dakota | 38033 | 293 | 4 |
1692398 | 1692398 | 2021-09-06 | Haakon | South Dakota | 46055 | 293 | 11 |
1692697 | 1692697 | 2021-09-06 | Menard | Texas | 48327 | 293 | 10 |
1688681 | 1688681 | 2021-09-05 | Golden Valley | North Dakota | 38033 | 293 | 4 |
1689149 | 1689149 | 2021-09-05 | Haakon | South Dakota | 46055 | 293 | 11 |
1685431 | 1685431 | 2021-09-04 | Golden Valley | North Dakota | 38033 | 293 | 4 |
1685899 | 1685899 | 2021-09-04 | Haakon | South Dakota | 46055 | 293 | 11 |
1682180 | 1682180 | 2021-09-03 | Golden Valley | North Dakota | 38033 | 293 | 4 |
1682648 | 1682648 | 2021-09-03 | Haakon | South Dakota | 46055 | 293 | 11 |
1677329 | 1677329 | 2021-09-02 | Clay | Georgia | 13061 | 293 | 3 |
1671329 | 1671329 | 2021-08-31 | Decatur | Kansas | 20039 | 293 | 12 |
1668082 | 1668082 | 2021-08-30 | Decatur | Kansas | 20039 | 293 | 12 |
1630211 | 1630211 | 2021-08-18 | Kidder | North Dakota | 38043 | 293 | 10 |
1626964 | 1626964 | 2021-08-17 | Kidder | North Dakota | 38043 | 293 | 10 |
1619349 | 1619349 | 2021-08-15 | Chase | Kansas | 20017 | 293 | 3 |
1616101 | 1616101 | 2021-08-14 | Chase | Kansas | 20017 | 293 | 3 |
1612852 | 1612852 | 2021-08-13 | Chase | Kansas | 20017 | 293 | 3 |
1609604 | 1609604 | 2021-08-12 | Chase | Kansas | 20017 | 293 | 3 |
1606355 | 1606355 | 2021-08-11 | Chase | Kansas | 20017 | 293 | 3 |
1601786 | 1601786 | 2021-08-09 | Shackelford | Texas | 48417 | 293 | 5 |
1598538 | 1598538 | 2021-08-08 | Shackelford | Texas | 48417 | 293 | 5 |
1595289 | 1595289 | 2021-08-07 | Shackelford | Texas | 48417 | 293 | 5 |
1551853 | 1551853 | 2021-07-25 | Fallon | Montana | 30025 | 293 | 2 |
1548606 | 1548606 | 2021-07-24 | Fallon | Montana | 30025 | 293 | 2 |
1545359 | 1545359 | 2021-07-23 | Fallon | Montana | 30025 | 293 | 2 |
1542111 | 1542111 | 2021-07-22 | Fallon | Montana | 30025 | 293 | 2 |
1538864 | 1538864 | 2021-07-21 | Fallon | Montana | 30025 | 293 | 2 |
1535617 | 1535617 | 2021-07-20 | Fallon | Montana | 30025 | 293 | 2 |
1533758 | 1533758 | 2021-07-19 | Norton city | Virginia | 51720 | 293 | 7 |
1530511 | 1530511 | 2021-07-18 | Norton city | Virginia | 51720 | 293 | 7 |
1527264 | 1527264 | 2021-07-17 | Norton city | Virginia | 51720 | 293 | 7 |
1524017 | 1524017 | 2021-07-16 | Norton city | Virginia | 51720 | 293 | 7 |
1520769 | 1520769 | 2021-07-15 | Norton city | Virginia | 51720 | 293 | 7 |
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);