ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
666 rows where cases = 382 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 87
- South Dakota 45
- Nebraska 38
- Virginia 34
- Georgia 33
- Montana 32
- Kentucky 27
- Missouri 21
- Puerto Rico 20
- Iowa 18
- Kansas 17
- North Carolina 16
- Mississippi 15
- Alaska 14
- Indiana 14
- Louisiana 14
- Ohio 14
- Alabama 13
- New York 13
- Tennessee 12
- Arkansas 11
- Illinois 11
- Michigan 11
- Oklahoma 11
- West Virginia 11
- Minnesota 10
- Pennsylvania 10
- North Dakota 9
- Utah 9
- Idaho 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489538 | 2489538 | 2022-05-09 | Highland | Virginia | 51091 | 382 | 7 |
2302690 | 2302690 | 2022-03-13 | Wheatland | Montana | 30107 | 382 | 14 |
2299438 | 2299438 | 2022-03-12 | Wheatland | Montana | 30107 | 382 | 14 |
2294612 | 2294612 | 2022-03-11 | Unknown | American Samoa | 382 | 0 | |
2296186 | 2296186 | 2022-03-11 | Wheatland | Montana | 30107 | 382 | 14 |
2291360 | 2291360 | 2022-03-10 | Unknown | American Samoa | 382 | 0 | |
2292934 | 2292934 | 2022-03-10 | Wheatland | Montana | 30107 | 382 | 14 |
2289682 | 2289682 | 2022-03-09 | Wheatland | Montana | 30107 | 382 | 14 |
2286430 | 2286430 | 2022-03-08 | Wheatland | Montana | 30107 | 382 | 14 |
2283178 | 2283178 | 2022-03-07 | Wheatland | Montana | 30107 | 382 | 14 |
2279925 | 2279925 | 2022-03-06 | Wheatland | Montana | 30107 | 382 | 14 |
2276672 | 2276672 | 2022-03-05 | Wheatland | Montana | 30107 | 382 | 14 |
2273419 | 2273419 | 2022-03-04 | Wheatland | Montana | 30107 | 382 | 14 |
2267298 | 2267298 | 2022-03-02 | Steele | North Dakota | 38091 | 382 | 2 |
2264046 | 2264046 | 2022-03-01 | Steele | North Dakota | 38091 | 382 | 2 |
2247364 | 2247364 | 2022-02-24 | Daniels | Montana | 30019 | 382 | 9 |
2247452 | 2247452 | 2022-02-24 | Harlan | Nebraska | 31083 | 382 | 2 |
2244113 | 2244113 | 2022-02-23 | Daniels | Montana | 30019 | 382 | 9 |
2244201 | 2244201 | 2022-02-23 | Harlan | Nebraska | 31083 | 382 | 2 |
2237627 | 2237627 | 2022-02-21 | Liberty | Montana | 30051 | 382 | 3 |
2234376 | 2234376 | 2022-02-20 | Liberty | Montana | 30051 | 382 | 3 |
2234448 | 2234448 | 2022-02-20 | Harlan | Nebraska | 31083 | 382 | 2 |
2231125 | 2231125 | 2022-02-19 | Liberty | Montana | 30051 | 382 | 3 |
2231197 | 2231197 | 2022-02-19 | Harlan | Nebraska | 31083 | 382 | 2 |
2227874 | 2227874 | 2022-02-18 | Liberty | Montana | 30051 | 382 | 3 |
2227946 | 2227946 | 2022-02-18 | Harlan | Nebraska | 31083 | 382 | 2 |
2224623 | 2224623 | 2022-02-17 | Liberty | Montana | 30051 | 382 | 3 |
2188848 | 2188848 | 2022-02-06 | Meagher | Montana | 30059 | 382 | 10 |
2185595 | 2185595 | 2022-02-05 | Meagher | Montana | 30059 | 382 | 10 |
2182343 | 2182343 | 2022-02-04 | Meagher | Montana | 30059 | 382 | 10 |
2179156 | 2179156 | 2022-02-03 | Greeley | Nebraska | 31077 | 382 | 2 |
2175904 | 2175904 | 2022-02-02 | Greeley | Nebraska | 31077 | 382 | 2 |
2142596 | 2142596 | 2022-01-23 | Hodgeman | Kansas | 20083 | 382 | 10 |
2139341 | 2139341 | 2022-01-22 | Hodgeman | Kansas | 20083 | 382 | 10 |
2136085 | 2136085 | 2022-01-21 | Hodgeman | Kansas | 20083 | 382 | 10 |
2130672 | 2130672 | 2022-01-19 | Logan | North Dakota | 38047 | 382 | 11 |
2121579 | 2121579 | 2022-01-16 | Edwards | Texas | 48137 | 382 | 9 |
2117645 | 2117645 | 2022-01-15 | Burke | North Dakota | 38013 | 382 | 3 |
2118327 | 2118327 | 2022-01-15 | Edwards | Texas | 48137 | 382 | 9 |
2108258 | 2108258 | 2022-01-12 | Maricao | Puerto Rico | 72093 | 382 | |
2075771 | 2075771 | 2022-01-02 | Vieques | Puerto Rico | 72147 | 382 | |
1975407 | 1975407 | 2021-12-02 | Oldham | Texas | 48359 | 382 | 6 |
1943162 | 1943162 | 2021-11-22 | Columbia | Washington | 53013 | 382 | 9 |
1938523 | 1938523 | 2021-11-21 | Brown | Nebraska | 31017 | 382 | 4 |
1935273 | 1935273 | 2021-11-20 | Brown | Nebraska | 31017 | 382 | 4 |
1932023 | 1932023 | 2021-11-19 | Brown | Nebraska | 31017 | 382 | 4 |
1925557 | 1925557 | 2021-11-17 | Hitchcock | Nebraska | 31087 | 382 | 5 |
1923660 | 1923660 | 2021-11-16 | Columbia | Washington | 53013 | 382 | 9 |
1902848 | 1902848 | 2021-11-10 | Sherman | Nebraska | 31163 | 382 | 4 |
1854853 | 1854853 | 2021-10-26 | Jackson | South Dakota | 46071 | 382 | 16 |
1854874 | 1854874 | 2021-10-26 | Sanborn | South Dakota | 46111 | 382 | 3 |
1834452 | 1834452 | 2021-10-20 | Scotland | Missouri | 29199 | 382 | 4 |
1830598 | 1830598 | 2021-10-19 | Smith | Kansas | 20183 | 382 | 3 |
1832382 | 1832382 | 2021-10-19 | Lipscomb | Texas | 48295 | 382 | 12 |
1827349 | 1827349 | 2021-10-18 | Smith | Kansas | 20183 | 382 | 3 |
1825640 | 1825640 | 2021-10-17 | Ziebach | South Dakota | 46137 | 382 | 9 |
1822391 | 1822391 | 2021-10-16 | Ziebach | South Dakota | 46137 | 382 | 9 |
1819142 | 1819142 | 2021-10-15 | Ziebach | South Dakota | 46137 | 382 | 9 |
1815893 | 1815893 | 2021-10-14 | Ziebach | South Dakota | 46137 | 382 | 9 |
1812645 | 1812645 | 2021-10-13 | Ziebach | South Dakota | 46137 | 382 | 9 |
1809396 | 1809396 | 2021-10-12 | Ziebach | South Dakota | 46137 | 382 | 9 |
1806146 | 1806146 | 2021-10-11 | Ziebach | South Dakota | 46137 | 382 | 9 |
1802896 | 1802896 | 2021-10-10 | Ziebach | South Dakota | 46137 | 382 | 9 |
1799647 | 1799647 | 2021-10-09 | Ziebach | South Dakota | 46137 | 382 | 9 |
1796398 | 1796398 | 2021-10-08 | Ziebach | South Dakota | 46137 | 382 | 9 |
1793149 | 1793149 | 2021-10-07 | Ziebach | South Dakota | 46137 | 382 | 9 |
1793300 | 1793300 | 2021-10-07 | Culberson | Texas | 48109 | 382 | 11 |
1790051 | 1790051 | 2021-10-06 | Culberson | Texas | 48109 | 382 | 11 |
1786803 | 1786803 | 2021-10-05 | Culberson | Texas | 48109 | 382 | 11 |
1783554 | 1783554 | 2021-10-04 | Culberson | Texas | 48109 | 382 | 11 |
1780305 | 1780305 | 2021-10-03 | Culberson | Texas | 48109 | 382 | 11 |
1777055 | 1777055 | 2021-10-02 | Culberson | Texas | 48109 | 382 | 11 |
1773794 | 1773794 | 2021-10-01 | Collingsworth | Texas | 48087 | 382 | 9 |
1773805 | 1773805 | 2021-10-01 | Culberson | Texas | 48109 | 382 | 11 |
1770544 | 1770544 | 2021-09-30 | Collingsworth | Texas | 48087 | 382 | 9 |
1770555 | 1770555 | 2021-09-30 | Culberson | Texas | 48109 | 382 | 11 |
1767295 | 1767295 | 2021-09-29 | Collingsworth | Texas | 48087 | 382 | 9 |
1767306 | 1767306 | 2021-09-29 | Culberson | Texas | 48109 | 382 | 11 |
1764057 | 1764057 | 2021-09-28 | Culberson | Texas | 48109 | 382 | 11 |
1760620 | 1760620 | 2021-09-27 | Hand | South Dakota | 46059 | 382 | 6 |
1760808 | 1760808 | 2021-09-27 | Culberson | Texas | 48109 | 382 | 11 |
1757560 | 1757560 | 2021-09-26 | Culberson | Texas | 48109 | 382 | 11 |
1754312 | 1754312 | 2021-09-25 | Culberson | Texas | 48109 | 382 | 11 |
1751064 | 1751064 | 2021-09-24 | Culberson | Texas | 48109 | 382 | 11 |
1747651 | 1747651 | 2021-09-23 | Perkins | South Dakota | 46105 | 382 | 14 |
1747815 | 1747815 | 2021-09-23 | Culberson | Texas | 48109 | 382 | 11 |
1744565 | 1744565 | 2021-09-22 | Culberson | Texas | 48109 | 382 | 11 |
1738906 | 1738906 | 2021-09-21 | Gilpin | Colorado | 8047 | 382 | 3 |
1741316 | 1741316 | 2021-09-21 | Culberson | Texas | 48109 | 382 | 11 |
1738067 | 1738067 | 2021-09-20 | Culberson | Texas | 48109 | 382 | 11 |
1734817 | 1734817 | 2021-09-19 | Culberson | Texas | 48109 | 382 | 11 |
1731567 | 1731567 | 2021-09-18 | Culberson | Texas | 48109 | 382 | 11 |
1728317 | 1728317 | 2021-09-17 | Culberson | Texas | 48109 | 382 | 11 |
1725068 | 1725068 | 2021-09-16 | Culberson | Texas | 48109 | 382 | 11 |
1721819 | 1721819 | 2021-09-15 | Culberson | Texas | 48109 | 382 | 11 |
1715979 | 1715979 | 2021-09-14 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 382 | 5 |
1718571 | 1718571 | 2021-09-14 | Culberson | Texas | 48109 | 382 | 11 |
1715164 | 1715164 | 2021-09-13 | Stanley | South Dakota | 46117 | 382 | 2 |
1715323 | 1715323 | 2021-09-13 | Culberson | Texas | 48109 | 382 | 11 |
1715344 | 1715344 | 2021-09-13 | Fisher | Texas | 48151 | 382 | 16 |
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);