ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,053 rows where cases = 161 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 91
- Virginia 58
- Georgia 55
- Kansas 45
- Kentucky 43
- Nebraska 42
- Montana 37
- Illinois 36
- Minnesota 36
- Iowa 35
- Missouri 35
- North Carolina 27
- Puerto Rico 26
- Washington 25
- North Dakota 23
- West Virginia 22
- Arkansas 21
- Mississippi 21
- New York 21
- Ohio 21
- Wisconsin 21
- Colorado 20
- South Dakota 20
- California 19
- Indiana 18
- Alaska 17
- Idaho 17
- Pennsylvania 17
- Tennessee 17
- Wyoming 17
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293491 | 2293491 | 2022-03-10 | Unknown | Oklahoma | 161 | 1 | |
2267605 | 2267605 | 2022-03-02 | Culebra | Puerto Rico | 72049 | 161 | |
2264352 | 2264352 | 2022-03-01 | Culebra | Puerto Rico | 72049 | 161 | |
2261102 | 2261102 | 2022-02-28 | Culebra | Puerto Rico | 72049 | 161 | |
2257851 | 2257851 | 2022-02-27 | Culebra | Puerto Rico | 72049 | 161 | |
2254600 | 2254600 | 2022-02-26 | Culebra | Puerto Rico | 72049 | 161 | |
2251349 | 2251349 | 2022-02-25 | Culebra | Puerto Rico | 72049 | 161 | |
2199789 | 2199789 | 2022-02-09 | Roberts | Texas | 48393 | 161 | 1 |
2196535 | 2196535 | 2022-02-08 | Roberts | Texas | 48393 | 161 | 1 |
2193281 | 2193281 | 2022-02-07 | Roberts | Texas | 48393 | 161 | 1 |
2190027 | 2190027 | 2022-02-06 | Roberts | Texas | 48393 | 161 | 1 |
2186739 | 2186739 | 2022-02-05 | McMullen | Texas | 48311 | 161 | 8 |
2183487 | 2183487 | 2022-02-04 | McMullen | Texas | 48311 | 161 | 8 |
2102928 | 2102928 | 2022-01-11 | San Juan | Colorado | 8111 | 161 | 0 |
2088115 | 2088115 | 2022-01-06 | Rock | Nebraska | 31149 | 161 | 2 |
2084863 | 2084863 | 2022-01-05 | Rock | Nebraska | 31149 | 161 | 2 |
2081611 | 2081611 | 2022-01-04 | Rock | Nebraska | 31149 | 161 | 2 |
2078359 | 2078359 | 2022-01-03 | Rock | Nebraska | 31149 | 161 | 2 |
2075108 | 2075108 | 2022-01-02 | Rock | Nebraska | 31149 | 161 | 2 |
2071857 | 2071857 | 2022-01-01 | Rock | Nebraska | 31149 | 161 | 2 |
2068606 | 2068606 | 2021-12-31 | Rock | Nebraska | 31149 | 161 | 2 |
2065355 | 2065355 | 2021-12-30 | Rock | Nebraska | 31149 | 161 | 2 |
2062105 | 2062105 | 2021-12-29 | Rock | Nebraska | 31149 | 161 | 2 |
2058856 | 2058856 | 2021-12-28 | Rock | Nebraska | 31149 | 161 | 2 |
2056573 | 2056573 | 2021-12-27 | Glasscock | Texas | 48173 | 161 | 3 |
1983983 | 1983983 | 2021-12-05 | Garfield | Montana | 30033 | 161 | 3 |
1980733 | 1980733 | 2021-12-04 | Garfield | Montana | 30033 | 161 | 3 |
1977483 | 1977483 | 2021-12-03 | Garfield | Montana | 30033 | 161 | 3 |
1974233 | 1974233 | 2021-12-02 | Garfield | Montana | 30033 | 161 | 3 |
1941731 | 1941731 | 2021-11-22 | Judith Basin | Montana | 30045 | 161 | 1 |
1938481 | 1938481 | 2021-11-21 | Judith Basin | Montana | 30045 | 161 | 1 |
1935231 | 1935231 | 2021-11-20 | Judith Basin | Montana | 30045 | 161 | 1 |
1931981 | 1931981 | 2021-11-19 | Judith Basin | Montana | 30045 | 161 | 1 |
1928730 | 1928730 | 2021-11-18 | Judith Basin | Montana | 30045 | 161 | 1 |
1925480 | 1925480 | 2021-11-17 | Judith Basin | Montana | 30045 | 161 | 1 |
1922231 | 1922231 | 2021-11-16 | Judith Basin | Montana | 30045 | 161 | 1 |
1918981 | 1918981 | 2021-11-15 | Judith Basin | Montana | 30045 | 161 | 1 |
1897938 | 1897938 | 2021-11-09 | Wrangell City and Borough | Alaska | 2275 | 161 | 0 |
1897118 | 1897118 | 2021-11-08 | Sully | South Dakota | 46119 | 161 | 3 |
1880002 | 1880002 | 2021-11-03 | Prairie | Montana | 30079 | 161 | 2 |
1881145 | 1881145 | 2021-11-03 | Motley | Texas | 48345 | 161 | 9 |
1876753 | 1876753 | 2021-11-02 | Prairie | Montana | 30079 | 161 | 2 |
1877896 | 1877896 | 2021-11-02 | Motley | Texas | 48345 | 161 | 9 |
1873504 | 1873504 | 2021-11-01 | Prairie | Montana | 30079 | 161 | 2 |
1874647 | 1874647 | 2021-11-01 | Motley | Texas | 48345 | 161 | 9 |
1869533 | 1869533 | 2021-10-31 | Greeley | Kansas | 20071 | 161 | 3 |
1871094 | 1871094 | 2021-10-31 | Harding | South Dakota | 46063 | 161 | 2 |
1871398 | 1871398 | 2021-10-31 | Motley | Texas | 48345 | 161 | 9 |
1866284 | 1866284 | 2021-10-30 | Greeley | Kansas | 20071 | 161 | 3 |
1867845 | 1867845 | 2021-10-30 | Harding | South Dakota | 46063 | 161 | 2 |
1868149 | 1868149 | 2021-10-30 | Motley | Texas | 48345 | 161 | 9 |
1863035 | 1863035 | 2021-10-29 | Greeley | Kansas | 20071 | 161 | 3 |
1864596 | 1864596 | 2021-10-29 | Harding | South Dakota | 46063 | 161 | 2 |
1864900 | 1864900 | 2021-10-29 | Motley | Texas | 48345 | 161 | 9 |
1861347 | 1861347 | 2021-10-28 | Harding | South Dakota | 46063 | 161 | 2 |
1861651 | 1861651 | 2021-10-28 | Motley | Texas | 48345 | 161 | 9 |
1858098 | 1858098 | 2021-10-27 | Harding | South Dakota | 46063 | 161 | 2 |
1858402 | 1858402 | 2021-10-27 | Motley | Texas | 48345 | 161 | 9 |
1854849 | 1854849 | 2021-10-26 | Harding | South Dakota | 46063 | 161 | 2 |
1855153 | 1855153 | 2021-10-26 | Motley | Texas | 48345 | 161 | 9 |
1851600 | 1851600 | 2021-10-25 | Harding | South Dakota | 46063 | 161 | 1 |
1851904 | 1851904 | 2021-10-25 | Motley | Texas | 48345 | 161 | 9 |
1848654 | 1848654 | 2021-10-24 | Motley | Texas | 48345 | 161 | 9 |
1845404 | 1845404 | 2021-10-23 | Motley | Texas | 48345 | 161 | 9 |
1838155 | 1838155 | 2021-10-21 | Sheridan | North Dakota | 38083 | 161 | 3 |
1824781 | 1824781 | 2021-10-17 | Wibaux | Montana | 30109 | 161 | 7 |
1824807 | 1824807 | 2021-10-17 | Deuel | Nebraska | 31049 | 161 | 2 |
1821532 | 1821532 | 2021-10-16 | Wibaux | Montana | 30109 | 161 | 7 |
1821558 | 1821558 | 2021-10-16 | Deuel | Nebraska | 31049 | 161 | 2 |
1818283 | 1818283 | 2021-10-15 | Wibaux | Montana | 30109 | 161 | 7 |
1818309 | 1818309 | 2021-10-15 | Deuel | Nebraska | 31049 | 161 | 2 |
1815034 | 1815034 | 2021-10-14 | Wibaux | Montana | 30109 | 161 | 7 |
1816259 | 1816259 | 2021-10-14 | Piute | Utah | 49031 | 161 | 2 |
1811786 | 1811786 | 2021-10-13 | Wibaux | Montana | 30109 | 161 | 7 |
1808537 | 1808537 | 2021-10-12 | Wibaux | Montana | 30109 | 161 | 7 |
1781129 | 1781129 | 2021-10-04 | Cheyenne | Colorado | 8017 | 161 | 7 |
1764218 | 1764218 | 2021-09-28 | Sterling | Texas | 48431 | 161 | 5 |
1760969 | 1760969 | 2021-09-27 | Sterling | Texas | 48431 | 161 | 5 |
1757721 | 1757721 | 2021-09-26 | Sterling | Texas | 48431 | 161 | 5 |
1754473 | 1754473 | 2021-09-25 | Sterling | Texas | 48431 | 161 | 5 |
1751225 | 1751225 | 2021-09-24 | Sterling | Texas | 48431 | 161 | 5 |
1747976 | 1747976 | 2021-09-23 | Sterling | Texas | 48431 | 161 | 5 |
1744726 | 1744726 | 2021-09-22 | Sterling | Texas | 48431 | 161 | 5 |
1717671 | 1717671 | 2021-09-14 | Storey | Nevada | 32029 | 161 | 4 |
1695859 | 1695859 | 2021-09-07 | Foard | Texas | 48155 | 161 | 10 |
1692611 | 1692611 | 2021-09-06 | Foard | Texas | 48155 | 161 | 10 |
1689362 | 1689362 | 2021-09-05 | Foard | Texas | 48155 | 161 | 10 |
1686112 | 1686112 | 2021-09-04 | Foard | Texas | 48155 | 161 | 10 |
1682861 | 1682861 | 2021-09-03 | Foard | Texas | 48155 | 161 | 10 |
1673156 | 1673156 | 2021-08-31 | Irion | Texas | 48235 | 161 | 1 |
1665563 | 1665563 | 2021-08-29 | Meagher | Montana | 30059 | 161 | 7 |
1666990 | 1666990 | 2021-08-29 | Garfield | Washington | 53023 | 161 | 7 |
1662315 | 1662315 | 2021-08-28 | Meagher | Montana | 30059 | 161 | 7 |
1663742 | 1663742 | 2021-08-28 | Garfield | Washington | 53023 | 161 | 7 |
1659067 | 1659067 | 2021-08-27 | Meagher | Montana | 30059 | 161 | 7 |
1660494 | 1660494 | 2021-08-27 | Garfield | Washington | 53023 | 161 | 7 |
1655818 | 1655818 | 2021-08-26 | Meagher | Montana | 30059 | 161 | 7 |
1652571 | 1652571 | 2021-08-25 | Meagher | Montana | 30059 | 161 | 7 |
1623728 | 1623728 | 2021-08-16 | Oliver | North Dakota | 38065 | 161 | 3 |
1620481 | 1620481 | 2021-08-15 | Oliver | North Dakota | 38065 | 161 | 3 |
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);