ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,609 rows where cases = 26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 280
- Nebraska 264
- Georgia 160
- Kentucky 145
- Kansas 143
- Missouri 136
- Virginia 133
- Tennessee 126
- Colorado 117
- Arkansas 110
- Michigan 108
- Alaska 105
- North Carolina 101
- Oklahoma 100
- Ohio 98
- North Dakota 97
- Puerto Rico 96
- Indiana 93
- Illinois 92
- South Dakota 79
- Minnesota 75
- Iowa 71
- Wisconsin 66
- Oregon 54
- Pennsylvania 54
- California 53
- Montana 53
- Idaho 52
- Mississippi 51
- West Virginia 46
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2477972 | 2477972 | 2022-05-06 | Unknown | Maine | 26 | 0 | |
2429130 | 2429130 | 2022-04-21 | Unknown | Maine | 26 | 0 | |
2429779 | 2429779 | 2022-04-21 | Unknown | New Mexico | 26 | 0 | |
2166281 | 2166281 | 2022-01-30 | Unknown | New Mexico | 26 | 0 | |
2163026 | 2163026 | 2022-01-29 | Unknown | New Mexico | 26 | 0 | |
2159771 | 2159771 | 2022-01-28 | Unknown | New Mexico | 26 | 0 | |
2039262 | 2039262 | 2021-12-22 | Petroleum | Montana | 30069 | 26 | 1 |
2040373 | 2040373 | 2021-12-22 | King | Texas | 48269 | 26 | 0 |
2036012 | 2036012 | 2021-12-21 | Petroleum | Montana | 30069 | 26 | 1 |
2037123 | 2037123 | 2021-12-21 | King | Texas | 48269 | 26 | 0 |
2032762 | 2032762 | 2021-12-20 | Petroleum | Montana | 30069 | 26 | 1 |
2033873 | 2033873 | 2021-12-20 | King | Texas | 48269 | 26 | 0 |
2029511 | 2029511 | 2021-12-19 | Petroleum | Montana | 30069 | 26 | 1 |
2030623 | 2030623 | 2021-12-19 | King | Texas | 48269 | 26 | 0 |
2026260 | 2026260 | 2021-12-18 | Petroleum | Montana | 30069 | 26 | 1 |
2027372 | 2027372 | 2021-12-18 | King | Texas | 48269 | 26 | 0 |
2023009 | 2023009 | 2021-12-17 | Petroleum | Montana | 30069 | 26 | 1 |
2024121 | 2024121 | 2021-12-17 | King | Texas | 48269 | 26 | 0 |
2019758 | 2019758 | 2021-12-16 | Petroleum | Montana | 30069 | 26 | 1 |
2020870 | 2020870 | 2021-12-16 | King | Texas | 48269 | 26 | 0 |
2016508 | 2016508 | 2021-12-15 | Petroleum | Montana | 30069 | 26 | 1 |
2017619 | 2017619 | 2021-12-15 | King | Texas | 48269 | 26 | 0 |
2013257 | 2013257 | 2021-12-14 | Petroleum | Montana | 30069 | 26 | 1 |
2014369 | 2014369 | 2021-12-14 | King | Texas | 48269 | 26 | 0 |
2010006 | 2010006 | 2021-12-13 | Petroleum | Montana | 30069 | 26 | 1 |
2011118 | 2011118 | 2021-12-13 | King | Texas | 48269 | 26 | 0 |
2006755 | 2006755 | 2021-12-12 | Petroleum | Montana | 30069 | 26 | 1 |
2006779 | 2006779 | 2021-12-12 | Arthur | Nebraska | 31005 | 26 | 1 |
2007867 | 2007867 | 2021-12-12 | King | Texas | 48269 | 26 | 0 |
2003504 | 2003504 | 2021-12-11 | Petroleum | Montana | 30069 | 26 | 1 |
2003528 | 2003528 | 2021-12-11 | Arthur | Nebraska | 31005 | 26 | 1 |
2004616 | 2004616 | 2021-12-11 | King | Texas | 48269 | 26 | 0 |
2000254 | 2000254 | 2021-12-10 | Petroleum | Montana | 30069 | 26 | 1 |
2000278 | 2000278 | 2021-12-10 | Arthur | Nebraska | 31005 | 26 | 1 |
2001365 | 2001365 | 2021-12-10 | King | Texas | 48269 | 26 | 0 |
1997003 | 1997003 | 2021-12-09 | Petroleum | Montana | 30069 | 26 | 1 |
1997027 | 1997027 | 2021-12-09 | Arthur | Nebraska | 31005 | 26 | 1 |
1998115 | 1998115 | 2021-12-09 | King | Texas | 48269 | 26 | 0 |
1993776 | 1993776 | 2021-12-08 | Arthur | Nebraska | 31005 | 26 | 1 |
1994864 | 1994864 | 2021-12-08 | King | Texas | 48269 | 26 | 0 |
1990525 | 1990525 | 2021-12-07 | Arthur | Nebraska | 31005 | 26 | 1 |
1991613 | 1991613 | 2021-12-07 | King | Texas | 48269 | 26 | 0 |
1987275 | 1987275 | 2021-12-06 | Arthur | Nebraska | 31005 | 26 | 1 |
1874770 | 1874770 | 2021-11-01 | Unknown | Vermont | 26 | 0 | |
1796790 | 1796790 | 2021-10-08 | Unknown | Vermont | 26 | 0 | |
1793541 | 1793541 | 2021-10-07 | Unknown | Vermont | 26 | 0 | |
1733813 | 1733813 | 2021-09-19 | Blaine | Nebraska | 31009 | 26 | 0 |
1730088 | 1730088 | 2021-09-18 | Unknown | Maine | 26 | 0 | |
1730563 | 1730563 | 2021-09-18 | Blaine | Nebraska | 31009 | 26 | 0 |
1727313 | 1727313 | 2021-09-17 | Blaine | Nebraska | 31009 | 26 | 0 |
1724064 | 1724064 | 2021-09-16 | Blaine | Nebraska | 31009 | 26 | 0 |
1720815 | 1720815 | 2021-09-15 | Blaine | Nebraska | 31009 | 26 | 0 |
1717567 | 1717567 | 2021-09-14 | Blaine | Nebraska | 31009 | 26 | 0 |
1714319 | 1714319 | 2021-09-13 | Blaine | Nebraska | 31009 | 26 | 0 |
1711073 | 1711073 | 2021-09-12 | Blaine | Nebraska | 31009 | 26 | 0 |
1707826 | 1707826 | 2021-09-11 | Blaine | Nebraska | 31009 | 26 | 0 |
1704579 | 1704579 | 2021-09-10 | Blaine | Nebraska | 31009 | 26 | 0 |
1701329 | 1701329 | 2021-09-09 | Blaine | Nebraska | 31009 | 26 | 0 |
1698080 | 1698080 | 2021-09-08 | Blaine | Nebraska | 31009 | 26 | 0 |
1694832 | 1694832 | 2021-09-07 | Blaine | Nebraska | 31009 | 26 | 0 |
1691583 | 1691583 | 2021-09-06 | Blaine | Nebraska | 31009 | 26 | 0 |
1688333 | 1688333 | 2021-09-05 | Blaine | Nebraska | 31009 | 26 | 0 |
1685083 | 1685083 | 2021-09-04 | Blaine | Nebraska | 31009 | 26 | 0 |
1681832 | 1681832 | 2021-09-03 | Blaine | Nebraska | 31009 | 26 | 0 |
1678584 | 1678584 | 2021-09-02 | Blaine | Nebraska | 31009 | 26 | 0 |
1675336 | 1675336 | 2021-09-01 | Blaine | Nebraska | 31009 | 26 | 0 |
1672088 | 1672088 | 2021-08-31 | Blaine | Nebraska | 31009 | 26 | 0 |
1668841 | 1668841 | 2021-08-30 | Blaine | Nebraska | 31009 | 26 | 0 |
1665594 | 1665594 | 2021-08-29 | Blaine | Nebraska | 31009 | 26 | 0 |
1662346 | 1662346 | 2021-08-28 | Blaine | Nebraska | 31009 | 26 | 0 |
1659098 | 1659098 | 2021-08-27 | Blaine | Nebraska | 31009 | 26 | 0 |
1655849 | 1655849 | 2021-08-26 | Blaine | Nebraska | 31009 | 26 | 0 |
1652602 | 1652602 | 2021-08-25 | Blaine | Nebraska | 31009 | 26 | 0 |
1649354 | 1649354 | 2021-08-24 | Blaine | Nebraska | 31009 | 26 | 0 |
1646105 | 1646105 | 2021-08-23 | Blaine | Nebraska | 31009 | 26 | 0 |
1642856 | 1642856 | 2021-08-22 | Blaine | Nebraska | 31009 | 26 | 0 |
1639606 | 1639606 | 2021-08-21 | Blaine | Nebraska | 31009 | 26 | 0 |
1636356 | 1636356 | 2021-08-20 | Blaine | Nebraska | 31009 | 26 | 0 |
1633106 | 1633106 | 2021-08-19 | Blaine | Nebraska | 31009 | 26 | 0 |
1629859 | 1629859 | 2021-08-18 | Blaine | Nebraska | 31009 | 26 | 0 |
1626612 | 1626612 | 2021-08-17 | Blaine | Nebraska | 31009 | 26 | 0 |
1623365 | 1623365 | 2021-08-16 | Blaine | Nebraska | 31009 | 26 | 0 |
1620118 | 1620118 | 2021-08-15 | Blaine | Nebraska | 31009 | 26 | 0 |
1616870 | 1616870 | 2021-08-14 | Blaine | Nebraska | 31009 | 26 | 0 |
1613622 | 1613622 | 2021-08-13 | Blaine | Nebraska | 31009 | 26 | 0 |
1610373 | 1610373 | 2021-08-12 | Blaine | Nebraska | 31009 | 26 | 0 |
1607125 | 1607125 | 2021-08-11 | Blaine | Nebraska | 31009 | 26 | 0 |
1603876 | 1603876 | 2021-08-10 | Blaine | Nebraska | 31009 | 26 | 0 |
1600627 | 1600627 | 2021-08-09 | Blaine | Nebraska | 31009 | 26 | 0 |
1597379 | 1597379 | 2021-08-08 | Blaine | Nebraska | 31009 | 26 | 0 |
1594130 | 1594130 | 2021-08-07 | Blaine | Nebraska | 31009 | 26 | 0 |
1590881 | 1590881 | 2021-08-06 | Blaine | Nebraska | 31009 | 26 | 0 |
1587632 | 1587632 | 2021-08-05 | Blaine | Nebraska | 31009 | 26 | 0 |
1584381 | 1584381 | 2021-08-04 | Blaine | Nebraska | 31009 | 26 | 0 |
1581132 | 1581132 | 2021-08-03 | Blaine | Nebraska | 31009 | 26 | 0 |
1577883 | 1577883 | 2021-08-02 | Blaine | Nebraska | 31009 | 26 | 0 |
1573050 | 1573050 | 2021-08-01 | Skagway Municipality | Alaska | 2230 | 26 | 0 |
1574635 | 1574635 | 2021-08-01 | Blaine | Nebraska | 31009 | 26 | 0 |
1569802 | 1569802 | 2021-07-31 | Skagway Municipality | Alaska | 2230 | 26 | 0 |
1571387 | 1571387 | 2021-07-31 | Blaine | Nebraska | 31009 | 26 | 0 |
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);