ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,512 rows where cases = 44 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 210
- Kansas 142
- Puerto Rico 118
- Nebraska 107
- Virginia 106
- Missouri 97
- Illinois 91
- Georgia 88
- Kentucky 85
- Colorado 79
- Minnesota 77
- Oklahoma 72
- Michigan 66
- Iowa 65
- Ohio 62
- Tennessee 62
- Arkansas 59
- New York 51
- South Dakota 51
- West Virginia 51
- North Dakota 50
- Wisconsin 50
- New Mexico 47
- North Carolina 47
- Idaho 44
- Pennsylvania 40
- Washington 40
- Indiana 38
- Alabama 36
- Nevada 36
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2055917 | 2055917 | 2021-12-27 | Unknown | North Dakota | 44 | 44 | |
2052667 | 2052667 | 2021-12-26 | Unknown | North Dakota | 44 | 44 | |
2053254 | 2053254 | 2021-12-26 | Borden | Texas | 48033 | 44 | 2 |
2049417 | 2049417 | 2021-12-25 | Unknown | North Dakota | 44 | 44 | |
2050004 | 2050004 | 2021-12-25 | Borden | Texas | 48033 | 44 | 2 |
2046167 | 2046167 | 2021-12-24 | Unknown | North Dakota | 44 | 44 | |
2046754 | 2046754 | 2021-12-24 | Borden | Texas | 48033 | 44 | 2 |
2042917 | 2042917 | 2021-12-23 | Unknown | North Dakota | 44 | 44 | |
2043504 | 2043504 | 2021-12-23 | Borden | Texas | 48033 | 44 | 2 |
2040255 | 2040255 | 2021-12-22 | Borden | Texas | 48033 | 44 | 2 |
2037005 | 2037005 | 2021-12-21 | Borden | Texas | 48033 | 44 | 2 |
2033755 | 2033755 | 2021-12-20 | Borden | Texas | 48033 | 44 | 2 |
2030505 | 2030505 | 2021-12-19 | Borden | Texas | 48033 | 44 | 2 |
2027254 | 2027254 | 2021-12-18 | Borden | Texas | 48033 | 44 | 2 |
2024003 | 2024003 | 2021-12-17 | Borden | Texas | 48033 | 44 | 2 |
2020752 | 2020752 | 2021-12-16 | Borden | Texas | 48033 | 44 | 2 |
2017501 | 2017501 | 2021-12-15 | Borden | Texas | 48033 | 44 | 2 |
2014251 | 2014251 | 2021-12-14 | Borden | Texas | 48033 | 44 | 2 |
2011000 | 2011000 | 2021-12-13 | Borden | Texas | 48033 | 44 | 2 |
2007749 | 2007749 | 2021-12-12 | Borden | Texas | 48033 | 44 | 2 |
2004498 | 2004498 | 2021-12-11 | Borden | Texas | 48033 | 44 | 2 |
2001247 | 2001247 | 2021-12-10 | Borden | Texas | 48033 | 44 | 2 |
1967778 | 1967778 | 2021-11-30 | Blaine | Nebraska | 31009 | 44 | 1 |
1964526 | 1964526 | 2021-11-29 | Blaine | Nebraska | 31009 | 44 | 1 |
1961275 | 1961275 | 2021-11-28 | Blaine | Nebraska | 31009 | 44 | 1 |
1958024 | 1958024 | 2021-11-27 | Blaine | Nebraska | 31009 | 44 | 1 |
1954773 | 1954773 | 2021-11-26 | Blaine | Nebraska | 31009 | 44 | 1 |
1951522 | 1951522 | 2021-11-25 | Blaine | Nebraska | 31009 | 44 | 1 |
1948271 | 1948271 | 2021-11-24 | Blaine | Nebraska | 31009 | 44 | 1 |
1945020 | 1945020 | 2021-11-23 | Blaine | Nebraska | 31009 | 44 | 1 |
1941769 | 1941769 | 2021-11-22 | Blaine | Nebraska | 31009 | 44 | 1 |
1938519 | 1938519 | 2021-11-21 | Blaine | Nebraska | 31009 | 44 | 1 |
1935269 | 1935269 | 2021-11-20 | Blaine | Nebraska | 31009 | 44 | 1 |
1932019 | 1932019 | 2021-11-19 | Blaine | Nebraska | 31009 | 44 | 1 |
1928768 | 1928768 | 2021-11-18 | Blaine | Nebraska | 31009 | 44 | 1 |
1906171 | 1906171 | 2021-11-11 | Harding | New Mexico | 35021 | 44 | 3 |
1902922 | 1902922 | 2021-11-10 | Harding | New Mexico | 35021 | 44 | 3 |
1899672 | 1899672 | 2021-11-09 | Harding | New Mexico | 35021 | 44 | 3 |
1900767 | 1900767 | 2021-11-09 | Unknown | Vermont | 44 | 0 | |
1896422 | 1896422 | 2021-11-08 | Harding | New Mexico | 35021 | 44 | 3 |
1893172 | 1893172 | 2021-11-07 | Harding | New Mexico | 35021 | 44 | 3 |
1889922 | 1889922 | 2021-11-06 | Harding | New Mexico | 35021 | 44 | 3 |
1886672 | 1886672 | 2021-11-05 | Harding | New Mexico | 35021 | 44 | 3 |
1883423 | 1883423 | 2021-11-04 | Harding | New Mexico | 35021 | 44 | 3 |
1880174 | 1880174 | 2021-11-03 | Harding | New Mexico | 35021 | 44 | 3 |
1876925 | 1876925 | 2021-11-02 | Harding | New Mexico | 35021 | 44 | 3 |
1873676 | 1873676 | 2021-11-01 | Harding | New Mexico | 35021 | 44 | 3 |
1870427 | 1870427 | 2021-10-31 | Harding | New Mexico | 35021 | 44 | 3 |
1867178 | 1867178 | 2021-10-30 | Harding | New Mexico | 35021 | 44 | 3 |
1863929 | 1863929 | 2021-10-29 | Harding | New Mexico | 35021 | 44 | 3 |
1860680 | 1860680 | 2021-10-28 | Harding | New Mexico | 35021 | 44 | 3 |
1857654 | 1857654 | 2021-10-27 | Slope | North Dakota | 38087 | 44 | 0 |
1854405 | 1854405 | 2021-10-26 | Slope | North Dakota | 38087 | 44 | 0 |
1769550 | 1769550 | 2021-09-30 | Banner | Nebraska | 31007 | 44 | 0 |
1769606 | 1769606 | 2021-09-30 | McPherson | Nebraska | 31117 | 44 | 1 |
1766301 | 1766301 | 2021-09-29 | Banner | Nebraska | 31007 | 44 | 0 |
1766357 | 1766357 | 2021-09-29 | McPherson | Nebraska | 31117 | 44 | 1 |
1763108 | 1763108 | 2021-09-28 | McPherson | Nebraska | 31117 | 44 | 1 |
1759859 | 1759859 | 2021-09-27 | McPherson | Nebraska | 31117 | 44 | 1 |
1756611 | 1756611 | 2021-09-26 | McPherson | Nebraska | 31117 | 44 | 1 |
1753363 | 1753363 | 2021-09-25 | McPherson | Nebraska | 31117 | 44 | 1 |
1750115 | 1750115 | 2021-09-24 | McPherson | Nebraska | 31117 | 44 | 1 |
1746865 | 1746865 | 2021-09-23 | McPherson | Nebraska | 31117 | 44 | 1 |
1743616 | 1743616 | 2021-09-22 | McPherson | Nebraska | 31117 | 44 | 1 |
1740365 | 1740365 | 2021-09-21 | Loup | Nebraska | 31115 | 44 | 0 |
1740367 | 1740367 | 2021-09-21 | McPherson | Nebraska | 31117 | 44 | 1 |
1737116 | 1737116 | 2021-09-20 | Loup | Nebraska | 31115 | 44 | 0 |
1737118 | 1737118 | 2021-09-20 | McPherson | Nebraska | 31117 | 44 | 1 |
1641270 | 1641270 | 2021-08-22 | Skagway Municipality | Alaska | 2230 | 44 | 0 |
1638020 | 1638020 | 2021-08-21 | Skagway Municipality | Alaska | 2230 | 44 | 0 |
1634770 | 1634770 | 2021-08-20 | Skagway Municipality | Alaska | 2230 | 44 | 0 |
1631522 | 1631522 | 2021-08-19 | Skagway Municipality | Alaska | 2230 | 44 | 0 |
1624446 | 1624446 | 2021-08-16 | Kenedy | Texas | 48261 | 44 | 2 |
1621199 | 1621199 | 2021-08-15 | Kenedy | Texas | 48261 | 44 | 2 |
1617951 | 1617951 | 2021-08-14 | Kenedy | Texas | 48261 | 44 | 2 |
1614703 | 1614703 | 2021-08-13 | Kenedy | Texas | 48261 | 44 | 2 |
1611454 | 1611454 | 2021-08-12 | Kenedy | Texas | 48261 | 44 | 2 |
1608206 | 1608206 | 2021-08-11 | Kenedy | Texas | 48261 | 44 | 2 |
1604957 | 1604957 | 2021-08-10 | Kenedy | Texas | 48261 | 44 | 2 |
1601708 | 1601708 | 2021-08-09 | Kenedy | Texas | 48261 | 44 | 2 |
1598460 | 1598460 | 2021-08-08 | Kenedy | Texas | 48261 | 44 | 2 |
1591563 | 1591563 | 2021-08-06 | Culebra | Puerto Rico | 72049 | 44 | |
1588314 | 1588314 | 2021-08-05 | Culebra | Puerto Rico | 72049 | 44 | |
1585064 | 1585064 | 2021-08-04 | Culebra | Puerto Rico | 72049 | 44 | |
1581814 | 1581814 | 2021-08-03 | Culebra | Puerto Rico | 72049 | 44 | |
1578565 | 1578565 | 2021-08-02 | Culebra | Puerto Rico | 72049 | 44 | |
1575224 | 1575224 | 2021-08-01 | Wheeler | Oregon | 41069 | 44 | 1 |
1575317 | 1575317 | 2021-08-01 | Culebra | Puerto Rico | 72049 | 44 | |
1571976 | 1571976 | 2021-07-31 | Wheeler | Oregon | 41069 | 44 | 1 |
1572069 | 1572069 | 2021-07-31 | Culebra | Puerto Rico | 72049 | 44 | |
1568728 | 1568728 | 2021-07-30 | Wheeler | Oregon | 41069 | 44 | 1 |
1568821 | 1568821 | 2021-07-30 | Culebra | Puerto Rico | 72049 | 44 | |
1565573 | 1565573 | 2021-07-29 | Culebra | Puerto Rico | 72049 | 44 | |
1562325 | 1562325 | 2021-07-28 | Culebra | Puerto Rico | 72049 | 44 | |
1559077 | 1559077 | 2021-07-27 | Culebra | Puerto Rico | 72049 | 44 | |
1555830 | 1555830 | 2021-07-26 | Culebra | Puerto Rico | 72049 | 44 | |
1552583 | 1552583 | 2021-07-25 | Culebra | Puerto Rico | 72049 | 44 | |
1549336 | 1549336 | 2021-07-24 | Culebra | Puerto Rico | 72049 | 44 | |
1546089 | 1546089 | 2021-07-23 | Culebra | Puerto Rico | 72049 | 44 | |
1542842 | 1542842 | 2021-07-22 | Culebra | Puerto Rico | 72049 | 44 |
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);