ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,834 rows where cases = 8 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 624
- Kentucky 452
- Missouri 358
- Nebraska 323
- Kansas 316
- Colorado 304
- Illinois 296
- Iowa 278
- Vermont 275
- West Virginia 275
- Virginia 268
- Montana 266
- Michigan 247
- South Dakota 216
- Tennessee 206
- North Dakota 195
- Arkansas 187
- Oklahoma 178
- Minnesota 172
- North Carolina 171
- Georgia 164
- New Mexico 160
- Wisconsin 160
- Idaho 158
- Ohio 157
- Pennsylvania 136
- Indiana 130
- Alaska 124
- Oregon 120
- Utah 96
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471141 | 2471141 | 2022-05-04 | Unknown | Iowa | 8 | 0 | |
2425558 | 2425558 | 2022-04-20 | Unknown | Iowa | 8 | 0 | |
2393966 | 2393966 | 2022-04-10 | Unknown | New Mexico | 8 | 0 | |
2390710 | 2390710 | 2022-04-09 | Unknown | New Mexico | 8 | 0 | |
2387454 | 2387454 | 2022-04-08 | Unknown | New Mexico | 8 | 0 | |
2384199 | 2384199 | 2022-04-07 | Unknown | New Mexico | 8 | 0 | |
2380944 | 2380944 | 2022-04-06 | Unknown | New Mexico | 8 | 0 | |
2338004 | 2338004 | 2022-03-24 | Unknown | Maine | 8 | 0 | |
2267093 | 2267093 | 2022-03-02 | Unknown | New Mexico | 8 | 0 | |
2169750 | 2169750 | 2022-01-31 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2166495 | 2166495 | 2022-01-30 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2163240 | 2163240 | 2022-01-29 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2159985 | 2159985 | 2022-01-28 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2156730 | 2156730 | 2022-01-27 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2153477 | 2153477 | 2022-01-26 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2150225 | 2150225 | 2022-01-25 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2146973 | 2146973 | 2022-01-24 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2143719 | 2143719 | 2022-01-23 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2140464 | 2140464 | 2022-01-22 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2137208 | 2137208 | 2022-01-21 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
2133955 | 2133955 | 2022-01-20 | Rota | Northern Mariana Islands | 69100 | 8 | 0 |
1968879 | 1968879 | 2021-11-30 | Loving | Texas | 48301 | 8 | 0 |
1965628 | 1965628 | 2021-11-29 | Loving | Texas | 48301 | 8 | 0 |
1962376 | 1962376 | 2021-11-28 | Loving | Texas | 48301 | 8 | 0 |
1959125 | 1959125 | 2021-11-27 | Loving | Texas | 48301 | 8 | 0 |
1955874 | 1955874 | 2021-11-26 | Loving | Texas | 48301 | 8 | 0 |
1952623 | 1952623 | 2021-11-25 | Loving | Texas | 48301 | 8 | 0 |
1949372 | 1949372 | 2021-11-24 | Loving | Texas | 48301 | 8 | 0 |
1946121 | 1946121 | 2021-11-23 | Loving | Texas | 48301 | 8 | 0 |
1942870 | 1942870 | 2021-11-22 | Loving | Texas | 48301 | 8 | 0 |
1939620 | 1939620 | 2021-11-21 | Loving | Texas | 48301 | 8 | 0 |
1936370 | 1936370 | 2021-11-20 | Loving | Texas | 48301 | 8 | 0 |
1933120 | 1933120 | 2021-11-19 | Loving | Texas | 48301 | 8 | 0 |
1929869 | 1929869 | 2021-11-18 | Loving | Texas | 48301 | 8 | 0 |
1925043 | 1925043 | 2021-11-17 | Unknown | Maine | 8 | 0 | |
1926619 | 1926619 | 2021-11-17 | Loving | Texas | 48301 | 8 | 0 |
1923369 | 1923369 | 2021-11-16 | Loving | Texas | 48301 | 8 | 0 |
1920120 | 1920120 | 2021-11-15 | Loving | Texas | 48301 | 8 | 0 |
1916870 | 1916870 | 2021-11-14 | Loving | Texas | 48301 | 8 | 0 |
1913620 | 1913620 | 2021-11-13 | Loving | Texas | 48301 | 8 | 0 |
1910370 | 1910370 | 2021-11-12 | Loving | Texas | 48301 | 8 | 0 |
1907121 | 1907121 | 2021-11-11 | Loving | Texas | 48301 | 8 | 0 |
1903872 | 1903872 | 2021-11-10 | Loving | Texas | 48301 | 8 | 0 |
1900622 | 1900622 | 2021-11-09 | Loving | Texas | 48301 | 8 | 0 |
1897372 | 1897372 | 2021-11-08 | Loving | Texas | 48301 | 8 | 0 |
1894122 | 1894122 | 2021-11-07 | Loving | Texas | 48301 | 8 | 0 |
1890872 | 1890872 | 2021-11-06 | Loving | Texas | 48301 | 8 | 0 |
1887622 | 1887622 | 2021-11-05 | Loving | Texas | 48301 | 8 | 0 |
1884372 | 1884372 | 2021-11-04 | Loving | Texas | 48301 | 8 | 0 |
1881123 | 1881123 | 2021-11-03 | Loving | Texas | 48301 | 8 | 0 |
1877874 | 1877874 | 2021-11-02 | Loving | Texas | 48301 | 8 | 0 |
1874625 | 1874625 | 2021-11-01 | Loving | Texas | 48301 | 8 | 0 |
1871376 | 1871376 | 2021-10-31 | Loving | Texas | 48301 | 8 | 0 |
1868127 | 1868127 | 2021-10-30 | Loving | Texas | 48301 | 8 | 0 |
1864878 | 1864878 | 2021-10-29 | Loving | Texas | 48301 | 8 | 0 |
1861629 | 1861629 | 2021-10-28 | Loving | Texas | 48301 | 8 | 0 |
1858380 | 1858380 | 2021-10-27 | Loving | Texas | 48301 | 8 | 0 |
1855131 | 1855131 | 2021-10-26 | Loving | Texas | 48301 | 8 | 0 |
1851882 | 1851882 | 2021-10-25 | Loving | Texas | 48301 | 8 | 0 |
1848632 | 1848632 | 2021-10-24 | Loving | Texas | 48301 | 8 | 0 |
1845382 | 1845382 | 2021-10-23 | Loving | Texas | 48301 | 8 | 0 |
1842132 | 1842132 | 2021-10-22 | Loving | Texas | 48301 | 8 | 0 |
1838883 | 1838883 | 2021-10-21 | Loving | Texas | 48301 | 8 | 0 |
1835634 | 1835634 | 2021-10-20 | Loving | Texas | 48301 | 8 | 0 |
1832385 | 1832385 | 2021-10-19 | Loving | Texas | 48301 | 8 | 0 |
1827561 | 1827561 | 2021-10-18 | Unknown | Maine | 8 | 0 | |
1829136 | 1829136 | 2021-10-18 | Loving | Texas | 48301 | 8 | 0 |
1824312 | 1824312 | 2021-10-17 | Unknown | Maine | 8 | 0 | |
1825887 | 1825887 | 2021-10-17 | Loving | Texas | 48301 | 8 | 0 |
1821063 | 1821063 | 2021-10-16 | Unknown | Maine | 8 | 0 | |
1822638 | 1822638 | 2021-10-16 | Loving | Texas | 48301 | 8 | 0 |
1819389 | 1819389 | 2021-10-15 | Loving | Texas | 48301 | 8 | 0 |
1816140 | 1816140 | 2021-10-14 | Loving | Texas | 48301 | 8 | 0 |
1811317 | 1811317 | 2021-10-13 | Unknown | Maine | 8 | 0 | |
1812892 | 1812892 | 2021-10-13 | Loving | Texas | 48301 | 8 | 0 |
1809643 | 1809643 | 2021-10-12 | Loving | Texas | 48301 | 8 | 0 |
1806393 | 1806393 | 2021-10-11 | Loving | Texas | 48301 | 8 | 0 |
1803143 | 1803143 | 2021-10-10 | Loving | Texas | 48301 | 8 | 0 |
1799894 | 1799894 | 2021-10-09 | Loving | Texas | 48301 | 8 | 0 |
1796645 | 1796645 | 2021-10-08 | Loving | Texas | 48301 | 8 | 0 |
1793396 | 1793396 | 2021-10-07 | Loving | Texas | 48301 | 8 | 0 |
1790147 | 1790147 | 2021-10-06 | Loving | Texas | 48301 | 8 | 0 |
1786899 | 1786899 | 2021-10-05 | Loving | Texas | 48301 | 8 | 0 |
1783650 | 1783650 | 2021-10-04 | Loving | Texas | 48301 | 8 | 0 |
1780401 | 1780401 | 2021-10-03 | Loving | Texas | 48301 | 8 | 0 |
1777151 | 1777151 | 2021-10-02 | Loving | Texas | 48301 | 8 | 0 |
1773901 | 1773901 | 2021-10-01 | Loving | Texas | 48301 | 8 | 0 |
1770651 | 1770651 | 2021-09-30 | Loving | Texas | 48301 | 8 | 0 |
1760904 | 1760904 | 2021-09-27 | Loving | Texas | 48301 | 8 | 0 |
1757656 | 1757656 | 2021-09-26 | Loving | Texas | 48301 | 8 | 0 |
1754408 | 1754408 | 2021-09-25 | Loving | Texas | 48301 | 8 | 0 |
1751160 | 1751160 | 2021-09-24 | Loving | Texas | 48301 | 8 | 0 |
1747911 | 1747911 | 2021-09-23 | Loving | Texas | 48301 | 8 | 0 |
1744661 | 1744661 | 2021-09-22 | Loving | Texas | 48301 | 8 | 0 |
1741412 | 1741412 | 2021-09-21 | Loving | Texas | 48301 | 8 | 0 |
1738163 | 1738163 | 2021-09-20 | Loving | Texas | 48301 | 8 | 0 |
1734913 | 1734913 | 2021-09-19 | Loving | Texas | 48301 | 8 | 0 |
1731663 | 1731663 | 2021-09-18 | Loving | Texas | 48301 | 8 | 0 |
1728413 | 1728413 | 2021-09-17 | Loving | Texas | 48301 | 8 | 0 |
1725164 | 1725164 | 2021-09-16 | Loving | Texas | 48301 | 8 | 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);