ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Pennington" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176712 | 2176712 | 2022-02-02 | Pennington | South Dakota | 46103 | 31482 | 310 |
2173458 | 2173458 | 2022-02-01 | Pennington | South Dakota | 46103 | 31382 | 310 |
2170206 | 2170206 | 2022-01-31 | Pennington | South Dakota | 46103 | 31070 | 309 |
2166952 | 2166952 | 2022-01-30 | Pennington | South Dakota | 46103 | 30904 | 306 |
2163697 | 2163697 | 2022-01-29 | Pennington | South Dakota | 46103 | 30904 | 306 |
2160442 | 2160442 | 2022-01-28 | Pennington | South Dakota | 46103 | 30904 | 306 |
2157186 | 2157186 | 2022-01-27 | Pennington | South Dakota | 46103 | 30740 | 306 |
2153933 | 2153933 | 2022-01-26 | Pennington | South Dakota | 46103 | 30530 | 306 |
2150681 | 2150681 | 2022-01-25 | Pennington | South Dakota | 46103 | 30268 | 304 |
2147429 | 2147429 | 2022-01-24 | Pennington | South Dakota | 46103 | 29687 | 304 |
2144175 | 2144175 | 2022-01-23 | Pennington | South Dakota | 46103 | 29364 | 304 |
2140920 | 2140920 | 2022-01-22 | Pennington | South Dakota | 46103 | 29364 | 304 |
2137664 | 2137664 | 2022-01-21 | Pennington | South Dakota | 46103 | 29364 | 304 |
2134410 | 2134410 | 2022-01-20 | Pennington | South Dakota | 46103 | 28937 | 301 |
2131158 | 2131158 | 2022-01-19 | Pennington | South Dakota | 46103 | 28545 | 298 |
2127904 | 2127904 | 2022-01-18 | Pennington | South Dakota | 46103 | 27354 | 295 |
2124652 | 2124652 | 2022-01-17 | Pennington | South Dakota | 46103 | 27003 | 295 |
2121400 | 2121400 | 2022-01-16 | Pennington | South Dakota | 46103 | 27003 | 295 |
2118148 | 2118148 | 2022-01-15 | Pennington | South Dakota | 46103 | 27003 | 295 |
2114897 | 2114897 | 2022-01-14 | Pennington | South Dakota | 46103 | 27003 | 295 |
2111645 | 2111645 | 2022-01-13 | Pennington | South Dakota | 46103 | 26606 | 293 |
2108393 | 2108393 | 2022-01-12 | Pennington | South Dakota | 46103 | 26274 | 292 |
2105142 | 2105142 | 2022-01-11 | Pennington | South Dakota | 46103 | 25913 | 291 |
2101891 | 2101891 | 2022-01-10 | Pennington | South Dakota | 46103 | 25283 | 291 |
2098640 | 2098640 | 2022-01-09 | Pennington | South Dakota | 46103 | 25010 | 289 |
2095388 | 2095388 | 2022-01-08 | Pennington | South Dakota | 46103 | 25010 | 289 |
2092136 | 2092136 | 2022-01-07 | Pennington | South Dakota | 46103 | 25010 | 289 |
2088884 | 2088884 | 2022-01-06 | Pennington | South Dakota | 46103 | 24775 | 289 |
2085633 | 2085633 | 2022-01-05 | Pennington | South Dakota | 46103 | 24488 | 289 |
2082381 | 2082381 | 2022-01-04 | Pennington | South Dakota | 46103 | 24314 | 286 |
2079129 | 2079129 | 2022-01-03 | Pennington | South Dakota | 46103 | 23942 | 286 |
2075878 | 2075878 | 2022-01-02 | Pennington | South Dakota | 46103 | 23859 | 284 |
2072627 | 2072627 | 2022-01-01 | Pennington | South Dakota | 46103 | 23859 | 284 |
2069376 | 2069376 | 2021-12-31 | Pennington | South Dakota | 46103 | 23859 | 284 |
2066125 | 2066125 | 2021-12-30 | Pennington | South Dakota | 46103 | 23859 | 284 |
2062875 | 2062875 | 2021-12-29 | Pennington | South Dakota | 46103 | 23801 | 280 |
2059625 | 2059625 | 2021-12-28 | Pennington | South Dakota | 46103 | 23691 | 280 |
2056376 | 2056376 | 2021-12-27 | Pennington | South Dakota | 46103 | 23528 | 280 |
2053127 | 2053127 | 2021-12-26 | Pennington | South Dakota | 46103 | 23479 | 278 |
2049877 | 2049877 | 2021-12-25 | Pennington | South Dakota | 46103 | 23479 | 278 |
2046627 | 2046627 | 2021-12-24 | Pennington | South Dakota | 46103 | 23479 | 278 |
2043377 | 2043377 | 2021-12-23 | Pennington | South Dakota | 46103 | 23479 | 278 |
2040128 | 2040128 | 2021-12-22 | Pennington | South Dakota | 46103 | 23419 | 278 |
2036878 | 2036878 | 2021-12-21 | Pennington | South Dakota | 46103 | 23369 | 278 |
2033628 | 2033628 | 2021-12-20 | Pennington | South Dakota | 46103 | 23307 | 277 |
2030378 | 2030378 | 2021-12-19 | Pennington | South Dakota | 46103 | 23281 | 275 |
2027127 | 2027127 | 2021-12-18 | Pennington | South Dakota | 46103 | 23281 | 275 |
2023876 | 2023876 | 2021-12-17 | Pennington | South Dakota | 46103 | 23281 | 275 |
2020625 | 2020625 | 2021-12-16 | Pennington | South Dakota | 46103 | 23252 | 275 |
2017374 | 2017374 | 2021-12-15 | Pennington | South Dakota | 46103 | 23201 | 273 |
2014124 | 2014124 | 2021-12-14 | Pennington | South Dakota | 46103 | 23160 | 273 |
2010873 | 2010873 | 2021-12-13 | Pennington | South Dakota | 46103 | 23102 | 272 |
2007622 | 2007622 | 2021-12-12 | Pennington | South Dakota | 46103 | 23068 | 271 |
2004371 | 2004371 | 2021-12-11 | Pennington | South Dakota | 46103 | 23068 | 271 |
2001120 | 2001120 | 2021-12-10 | Pennington | South Dakota | 46103 | 23068 | 271 |
1997870 | 1997870 | 2021-12-09 | Pennington | South Dakota | 46103 | 23029 | 271 |
1994619 | 1994619 | 2021-12-08 | Pennington | South Dakota | 46103 | 22981 | 270 |
1991368 | 1991368 | 2021-12-07 | Pennington | South Dakota | 46103 | 22934 | 270 |
1988117 | 1988117 | 2021-12-06 | Pennington | South Dakota | 46103 | 22820 | 269 |
1984867 | 1984867 | 2021-12-05 | Pennington | South Dakota | 46103 | 22779 | 269 |
1981617 | 1981617 | 2021-12-04 | Pennington | South Dakota | 46103 | 22779 | 269 |
1978367 | 1978367 | 2021-12-03 | Pennington | South Dakota | 46103 | 22779 | 269 |
1975117 | 1975117 | 2021-12-02 | Pennington | South Dakota | 46103 | 22733 | 269 |
1971868 | 1971868 | 2021-12-01 | Pennington | South Dakota | 46103 | 22680 | 266 |
1968618 | 1968618 | 2021-11-30 | Pennington | South Dakota | 46103 | 22590 | 264 |
1965367 | 1965367 | 2021-11-29 | Pennington | South Dakota | 46103 | 22438 | 263 |
1962115 | 1962115 | 2021-11-28 | Pennington | South Dakota | 46103 | 22374 | 263 |
1958864 | 1958864 | 2021-11-27 | Pennington | South Dakota | 46103 | 22374 | 263 |
1955613 | 1955613 | 2021-11-26 | Pennington | South Dakota | 46103 | 22374 | 263 |
1952362 | 1952362 | 2021-11-25 | Pennington | South Dakota | 46103 | 22374 | 263 |
1949111 | 1949111 | 2021-11-24 | Pennington | South Dakota | 46103 | 22374 | 263 |
1945860 | 1945860 | 2021-11-23 | Pennington | South Dakota | 46103 | 22289 | 264 |
1942609 | 1942609 | 2021-11-22 | Pennington | South Dakota | 46103 | 22165 | 263 |
1939359 | 1939359 | 2021-11-21 | Pennington | South Dakota | 46103 | 22112 | 262 |
1936109 | 1936109 | 2021-11-20 | Pennington | South Dakota | 46103 | 22112 | 262 |
1932859 | 1932859 | 2021-11-19 | Pennington | South Dakota | 46103 | 22112 | 262 |
1929608 | 1929608 | 2021-11-18 | Pennington | South Dakota | 46103 | 22039 | 262 |
1926358 | 1926358 | 2021-11-17 | Pennington | South Dakota | 46103 | 21978 | 259 |
1923108 | 1923108 | 2021-11-16 | Pennington | South Dakota | 46103 | 21912 | 259 |
1919859 | 1919859 | 2021-11-15 | Pennington | South Dakota | 46103 | 21781 | 259 |
1916609 | 1916609 | 2021-11-14 | Pennington | South Dakota | 46103 | 21666 | 257 |
1913359 | 1913359 | 2021-11-13 | Pennington | South Dakota | 46103 | 21666 | 257 |
1910109 | 1910109 | 2021-11-12 | Pennington | South Dakota | 46103 | 21666 | 257 |
1906860 | 1906860 | 2021-11-11 | Pennington | South Dakota | 46103 | 21606 | 256 |
1903611 | 1903611 | 2021-11-10 | Pennington | South Dakota | 46103 | 21606 | 256 |
1900361 | 1900361 | 2021-11-09 | Pennington | South Dakota | 46103 | 21530 | 256 |
1897111 | 1897111 | 2021-11-08 | Pennington | South Dakota | 46103 | 21354 | 255 |
1893861 | 1893861 | 2021-11-07 | Pennington | South Dakota | 46103 | 21282 | 255 |
1890611 | 1890611 | 2021-11-06 | Pennington | South Dakota | 46103 | 21282 | 255 |
1887361 | 1887361 | 2021-11-05 | Pennington | South Dakota | 46103 | 21282 | 255 |
1884111 | 1884111 | 2021-11-04 | Pennington | South Dakota | 46103 | 21223 | 253 |
1880862 | 1880862 | 2021-11-03 | Pennington | South Dakota | 46103 | 21139 | 253 |
1877613 | 1877613 | 2021-11-02 | Pennington | South Dakota | 46103 | 21046 | 251 |
1874364 | 1874364 | 2021-11-01 | Pennington | South Dakota | 46103 | 20925 | 248 |
1871115 | 1871115 | 2021-10-31 | Pennington | South Dakota | 46103 | 20863 | 248 |
1867866 | 1867866 | 2021-10-30 | Pennington | South Dakota | 46103 | 20863 | 248 |
1864617 | 1864617 | 2021-10-29 | Pennington | South Dakota | 46103 | 20863 | 248 |
1861368 | 1861368 | 2021-10-28 | Pennington | South Dakota | 46103 | 20780 | 248 |
1858119 | 1858119 | 2021-10-27 | Pennington | South Dakota | 46103 | 20706 | 247 |
1854870 | 1854870 | 2021-10-26 | Pennington | South Dakota | 46103 | 20641 | 247 |
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);