ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
805 rows where cases = 305 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 81
- Missouri 61
- North Dakota 44
- Virginia 42
- South Dakota 41
- Georgia 39
- Nevada 38
- Kentucky 28
- Kansas 25
- Puerto Rico 25
- New York 22
- North Carolina 22
- Illinois 21
- Nebraska 20
- Minnesota 18
- Tennessee 18
- Colorado 15
- Iowa 15
- Montana 15
- Indiana 14
- Alaska 13
- Michigan 13
- Mississippi 13
- Ohio 13
- Oklahoma 12
- Alabama 11
- Oregon 11
- West Virginia 10
- California 9
- Louisiana 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2284008 | 2284008 | 2022-03-07 | Hyde | South Dakota | 46069 | 305 | 7 |
2280756 | 2280756 | 2022-03-06 | Hyde | South Dakota | 46069 | 305 | 7 |
2277503 | 2277503 | 2022-03-05 | Hyde | South Dakota | 46069 | 305 | 7 |
2274250 | 2274250 | 2022-03-04 | Hyde | South Dakota | 46069 | 305 | 7 |
2270997 | 2270997 | 2022-03-03 | Hyde | South Dakota | 46069 | 305 | 7 |
2267017 | 2267017 | 2022-03-02 | Eureka | Nevada | 32011 | 305 | 1 |
2267745 | 2267745 | 2022-03-02 | Hyde | South Dakota | 46069 | 305 | 7 |
2263766 | 2263766 | 2022-03-01 | Eureka | Nevada | 32011 | 305 | 1 |
2264492 | 2264492 | 2022-03-01 | Hyde | South Dakota | 46069 | 305 | 7 |
2261242 | 2261242 | 2022-02-28 | Hyde | South Dakota | 46069 | 305 | 7 |
2257991 | 2257991 | 2022-02-27 | Hyde | South Dakota | 46069 | 305 | 7 |
2254740 | 2254740 | 2022-02-26 | Hyde | South Dakota | 46069 | 305 | 7 |
2251489 | 2251489 | 2022-02-25 | Hyde | South Dakota | 46069 | 305 | 7 |
2248238 | 2248238 | 2022-02-24 | Hyde | South Dakota | 46069 | 305 | 7 |
2244987 | 2244987 | 2022-02-23 | Hyde | South Dakota | 46069 | 305 | 7 |
2238485 | 2238485 | 2022-02-21 | Hyde | South Dakota | 46069 | 305 | 7 |
2235234 | 2235234 | 2022-02-20 | Hyde | South Dakota | 46069 | 305 | 7 |
2231983 | 2231983 | 2022-02-19 | Hyde | South Dakota | 46069 | 305 | 7 |
2228732 | 2228732 | 2022-02-18 | Hyde | South Dakota | 46069 | 305 | 7 |
2225481 | 2225481 | 2022-02-17 | Hyde | South Dakota | 46069 | 305 | 7 |
2221990 | 2221990 | 2022-02-16 | Sherman | Oregon | 41055 | 305 | 3 |
2198660 | 2198660 | 2022-02-09 | Deuel | Nebraska | 31049 | 305 | 2 |
2131540 | 2131540 | 2022-01-19 | Rich | Utah | 49033 | 305 | 0 |
2086026 | 2086026 | 2022-01-05 | Wayne | Utah | 49055 | 305 | 0 |
2081917 | 2081917 | 2022-01-04 | Steele | North Dakota | 38091 | 305 | 2 |
2082774 | 2082774 | 2022-01-04 | Wayne | Utah | 49055 | 305 | 0 |
2078665 | 2078665 | 2022-01-03 | Steele | North Dakota | 38091 | 305 | 2 |
2079522 | 2079522 | 2022-01-03 | Wayne | Utah | 49055 | 305 | 0 |
1997060 | 1997060 | 2021-12-09 | Garfield | Nebraska | 31071 | 305 | 2 |
1993809 | 1993809 | 2021-12-08 | Garfield | Nebraska | 31071 | 305 | 2 |
1990476 | 1990476 | 2021-12-07 | Daniels | Montana | 30019 | 305 | 9 |
1990558 | 1990558 | 2021-12-07 | Garfield | Nebraska | 31071 | 305 | 2 |
1988697 | 1988697 | 2021-12-06 | Wahkiakum | Washington | 53069 | 305 | 5 |
1985447 | 1985447 | 2021-12-05 | Wahkiakum | Washington | 53069 | 305 | 5 |
1982197 | 1982197 | 2021-12-04 | Wahkiakum | Washington | 53069 | 305 | 5 |
1978947 | 1978947 | 2021-12-03 | Wahkiakum | Washington | 53069 | 305 | 5 |
1970996 | 1970996 | 2021-12-01 | McCone | Montana | 30055 | 305 | 4 |
1972189 | 1972189 | 2021-12-01 | Sherman | Texas | 48421 | 305 | 16 |
1967746 | 1967746 | 2021-11-30 | McCone | Montana | 30055 | 305 | 4 |
1967840 | 1967840 | 2021-11-30 | Pawnee | Nebraska | 31133 | 305 | 4 |
1938665 | 1938665 | 2021-11-21 | De Baca | New Mexico | 35011 | 305 | 3 |
1935415 | 1935415 | 2021-11-20 | De Baca | New Mexico | 35011 | 305 | 3 |
1932165 | 1932165 | 2021-11-19 | De Baca | New Mexico | 35011 | 305 | 3 |
1928914 | 1928914 | 2021-11-18 | De Baca | New Mexico | 35011 | 305 | 3 |
1925664 | 1925664 | 2021-11-17 | De Baca | New Mexico | 35011 | 305 | 3 |
1834538 | 1834538 | 2021-10-20 | Brown | Nebraska | 31017 | 305 | 4 |
1818638 | 1818638 | 2021-10-15 | Grant | North Dakota | 38037 | 305 | 7 |
1815389 | 1815389 | 2021-10-14 | Grant | North Dakota | 38037 | 305 | 7 |
1783382 | 1783382 | 2021-10-04 | McPherson | South Dakota | 46089 | 305 | 7 |
1778574 | 1778574 | 2021-10-03 | Lincoln | Kansas | 20105 | 305 | 5 |
1775324 | 1775324 | 2021-10-02 | Lincoln | Kansas | 20105 | 305 | 5 |
1772074 | 1772074 | 2021-10-01 | Lincoln | Kansas | 20105 | 305 | 5 |
1769628 | 1769628 | 2021-09-30 | Sherman | Nebraska | 31163 | 305 | 4 |
1766649 | 1766649 | 2021-09-29 | Golden Valley | North Dakota | 38033 | 305 | 4 |
1766656 | 1766656 | 2021-09-29 | Logan | North Dakota | 38047 | 305 | 10 |
1763407 | 1763407 | 2021-09-28 | Logan | North Dakota | 38047 | 305 | 10 |
1761368 | 1761368 | 2021-09-27 | Niobrara | Wyoming | 56027 | 305 | 4 |
1755811 | 1755811 | 2021-09-26 | Graham | Kansas | 20065 | 305 | 10 |
1752563 | 1752563 | 2021-09-25 | Graham | Kansas | 20065 | 305 | 10 |
1749314 | 1749314 | 2021-09-24 | Graham | Kansas | 20065 | 305 | 10 |
1741330 | 1741330 | 2021-09-21 | Edwards | Texas | 48137 | 305 | 7 |
1738081 | 1738081 | 2021-09-20 | Edwards | Texas | 48137 | 305 | 7 |
1734831 | 1734831 | 2021-09-19 | Edwards | Texas | 48137 | 305 | 7 |
1731581 | 1731581 | 2021-09-18 | Edwards | Texas | 48137 | 305 | 7 |
1728331 | 1728331 | 2021-09-17 | Edwards | Texas | 48137 | 305 | 7 |
1725082 | 1725082 | 2021-09-16 | Edwards | Texas | 48137 | 305 | 6 |
1719560 | 1719560 | 2021-09-15 | Clay | Georgia | 13061 | 305 | 3 |
1721833 | 1721833 | 2021-09-15 | Edwards | Texas | 48137 | 305 | 6 |
1718585 | 1718585 | 2021-09-14 | Edwards | Texas | 48137 | 305 | 6 |
1713066 | 1713066 | 2021-09-13 | Clay | Georgia | 13061 | 305 | 3 |
1700570 | 1700570 | 2021-09-09 | Decatur | Kansas | 20039 | 305 | 12 |
1697321 | 1697321 | 2021-09-08 | Decatur | Kansas | 20039 | 305 | 12 |
1627435 | 1627435 | 2021-08-17 | Jackson | South Dakota | 46071 | 305 | 15 |
1621961 | 1621961 | 2021-08-16 | Gilpin | Colorado | 8047 | 305 | 3 |
1619411 | 1619411 | 2021-08-15 | Osborne | Kansas | 20141 | 305 | 12 |
1616163 | 1616163 | 2021-08-14 | Osborne | Kansas | 20141 | 305 | 12 |
1612914 | 1612914 | 2021-08-13 | Osborne | Kansas | 20141 | 305 | 12 |
1581084 | 1581084 | 2021-08-03 | Fallon | Montana | 30025 | 305 | 2 |
1577835 | 1577835 | 2021-08-02 | Fallon | Montana | 30025 | 305 | 2 |
1569101 | 1569101 | 2021-07-30 | Baylor | Texas | 48023 | 305 | 13 |
1565853 | 1565853 | 2021-07-29 | Baylor | Texas | 48023 | 305 | 13 |
1562605 | 1562605 | 2021-07-28 | Baylor | Texas | 48023 | 305 | 13 |
1557672 | 1557672 | 2021-07-27 | Logan | Kansas | 20109 | 305 | 6 |
1554425 | 1554425 | 2021-07-26 | Logan | Kansas | 20109 | 305 | 6 |
1532387 | 1532387 | 2021-07-19 | Mineral | Montana | 30061 | 305 | 3 |
1495979 | 1495979 | 2021-07-08 | Logan | Kansas | 20109 | 305 | 6 |
1492733 | 1492733 | 2021-07-07 | Logan | Kansas | 20109 | 305 | 6 |
1489486 | 1489486 | 2021-07-06 | Logan | Kansas | 20109 | 305 | 6 |
1486239 | 1486239 | 2021-07-05 | Logan | Kansas | 20109 | 305 | 6 |
1482993 | 1482993 | 2021-07-04 | Logan | Kansas | 20109 | 305 | 6 |
1479746 | 1479746 | 2021-07-03 | Logan | Kansas | 20109 | 305 | 6 |
1476500 | 1476500 | 2021-07-02 | Logan | Kansas | 20109 | 305 | 6 |
1473254 | 1473254 | 2021-07-01 | Logan | Kansas | 20109 | 305 | 6 |
1470008 | 1470008 | 2021-06-30 | Logan | Kansas | 20109 | 305 | 6 |
1400354 | 1400354 | 2021-06-08 | Fisher | Texas | 48151 | 305 | 14 |
1397109 | 1397109 | 2021-06-07 | Fisher | Texas | 48151 | 305 | 14 |
1393862 | 1393862 | 2021-06-06 | Fisher | Texas | 48151 | 305 | 14 |
1390617 | 1390617 | 2021-06-05 | Fisher | Texas | 48151 | 305 | 14 |
1387372 | 1387372 | 2021-06-04 | Fisher | Texas | 48151 | 305 | 14 |
1384127 | 1384127 | 2021-06-03 | Fisher | Texas | 48151 | 305 | 14 |
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);