ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,535 rows where county = "Pennington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175579 | 2175579 | 2022-02-02 | Pennington | Minnesota | 27113 | 3246 | 36 |
2176712 | 2176712 | 2022-02-02 | Pennington | South Dakota | 46103 | 31482 | 310 |
2172326 | 2172326 | 2022-02-01 | Pennington | Minnesota | 27113 | 3235 | 36 |
2173458 | 2173458 | 2022-02-01 | Pennington | South Dakota | 46103 | 31382 | 310 |
2169073 | 2169073 | 2022-01-31 | Pennington | Minnesota | 27113 | 3174 | 35 |
2170206 | 2170206 | 2022-01-31 | Pennington | South Dakota | 46103 | 31070 | 309 |
2165818 | 2165818 | 2022-01-30 | Pennington | Minnesota | 27113 | 3129 | 35 |
2166952 | 2166952 | 2022-01-30 | Pennington | South Dakota | 46103 | 30904 | 306 |
2162563 | 2162563 | 2022-01-29 | Pennington | Minnesota | 27113 | 3129 | 35 |
2163697 | 2163697 | 2022-01-29 | Pennington | South Dakota | 46103 | 30904 | 306 |
2159308 | 2159308 | 2022-01-28 | Pennington | Minnesota | 27113 | 3129 | 35 |
2160442 | 2160442 | 2022-01-28 | Pennington | South Dakota | 46103 | 30904 | 306 |
2156054 | 2156054 | 2022-01-27 | Pennington | Minnesota | 27113 | 3105 | 35 |
2157186 | 2157186 | 2022-01-27 | Pennington | South Dakota | 46103 | 30740 | 306 |
2152801 | 2152801 | 2022-01-26 | Pennington | Minnesota | 27113 | 3058 | 34 |
2153933 | 2153933 | 2022-01-26 | Pennington | South Dakota | 46103 | 30530 | 306 |
2149549 | 2149549 | 2022-01-25 | Pennington | Minnesota | 27113 | 3016 | 34 |
2150681 | 2150681 | 2022-01-25 | Pennington | South Dakota | 46103 | 30268 | 304 |
2146297 | 2146297 | 2022-01-24 | Pennington | Minnesota | 27113 | 2943 | 34 |
2147429 | 2147429 | 2022-01-24 | Pennington | South Dakota | 46103 | 29687 | 304 |
2143042 | 2143042 | 2022-01-23 | Pennington | Minnesota | 27113 | 2919 | 34 |
2144175 | 2144175 | 2022-01-23 | Pennington | South Dakota | 46103 | 29364 | 304 |
2139787 | 2139787 | 2022-01-22 | Pennington | Minnesota | 27113 | 2919 | 34 |
2140920 | 2140920 | 2022-01-22 | Pennington | South Dakota | 46103 | 29364 | 304 |
2136531 | 2136531 | 2022-01-21 | Pennington | Minnesota | 27113 | 2919 | 34 |
2137664 | 2137664 | 2022-01-21 | Pennington | South Dakota | 46103 | 29364 | 304 |
2133279 | 2133279 | 2022-01-20 | Pennington | Minnesota | 27113 | 2897 | 34 |
2134410 | 2134410 | 2022-01-20 | Pennington | South Dakota | 46103 | 28937 | 301 |
2130026 | 2130026 | 2022-01-19 | Pennington | Minnesota | 27113 | 2868 | 34 |
2131158 | 2131158 | 2022-01-19 | Pennington | South Dakota | 46103 | 28545 | 298 |
2126772 | 2126772 | 2022-01-18 | Pennington | Minnesota | 27113 | 2821 | 34 |
2127904 | 2127904 | 2022-01-18 | Pennington | South Dakota | 46103 | 27354 | 295 |
2123520 | 2123520 | 2022-01-17 | Pennington | Minnesota | 27113 | 2809 | 34 |
2124652 | 2124652 | 2022-01-17 | Pennington | South Dakota | 46103 | 27003 | 295 |
2120268 | 2120268 | 2022-01-16 | Pennington | Minnesota | 27113 | 2809 | 34 |
2121400 | 2121400 | 2022-01-16 | Pennington | South Dakota | 46103 | 27003 | 295 |
2117016 | 2117016 | 2022-01-15 | Pennington | Minnesota | 27113 | 2809 | 34 |
2118148 | 2118148 | 2022-01-15 | Pennington | South Dakota | 46103 | 27003 | 295 |
2113765 | 2113765 | 2022-01-14 | Pennington | Minnesota | 27113 | 2809 | 34 |
2114897 | 2114897 | 2022-01-14 | Pennington | South Dakota | 46103 | 27003 | 295 |
2110513 | 2110513 | 2022-01-13 | Pennington | Minnesota | 27113 | 2799 | 34 |
2111645 | 2111645 | 2022-01-13 | Pennington | South Dakota | 46103 | 26606 | 293 |
2107262 | 2107262 | 2022-01-12 | Pennington | Minnesota | 27113 | 2789 | 34 |
2108393 | 2108393 | 2022-01-12 | Pennington | South Dakota | 46103 | 26274 | 292 |
2104011 | 2104011 | 2022-01-11 | Pennington | Minnesota | 27113 | 2776 | 33 |
2105142 | 2105142 | 2022-01-11 | Pennington | South Dakota | 46103 | 25913 | 291 |
2100760 | 2100760 | 2022-01-10 | Pennington | Minnesota | 27113 | 2739 | 33 |
2101891 | 2101891 | 2022-01-10 | Pennington | South Dakota | 46103 | 25283 | 291 |
2097509 | 2097509 | 2022-01-09 | Pennington | Minnesota | 27113 | 2729 | 33 |
2098640 | 2098640 | 2022-01-09 | Pennington | South Dakota | 46103 | 25010 | 289 |
2094257 | 2094257 | 2022-01-08 | Pennington | Minnesota | 27113 | 2729 | 33 |
2095388 | 2095388 | 2022-01-08 | Pennington | South Dakota | 46103 | 25010 | 289 |
2091005 | 2091005 | 2022-01-07 | Pennington | Minnesota | 27113 | 2729 | 33 |
2092136 | 2092136 | 2022-01-07 | Pennington | South Dakota | 46103 | 25010 | 289 |
2087754 | 2087754 | 2022-01-06 | Pennington | Minnesota | 27113 | 2722 | 32 |
2088884 | 2088884 | 2022-01-06 | Pennington | South Dakota | 46103 | 24775 | 289 |
2084502 | 2084502 | 2022-01-05 | Pennington | Minnesota | 27113 | 2704 | 32 |
2085633 | 2085633 | 2022-01-05 | Pennington | South Dakota | 46103 | 24488 | 289 |
2081250 | 2081250 | 2022-01-04 | Pennington | Minnesota | 27113 | 2702 | 32 |
2082381 | 2082381 | 2022-01-04 | Pennington | South Dakota | 46103 | 24314 | 286 |
2077998 | 2077998 | 2022-01-03 | Pennington | Minnesota | 27113 | 2675 | 32 |
2079129 | 2079129 | 2022-01-03 | Pennington | South Dakota | 46103 | 23942 | 286 |
2074747 | 2074747 | 2022-01-02 | Pennington | Minnesota | 27113 | 2669 | 32 |
2075878 | 2075878 | 2022-01-02 | Pennington | South Dakota | 46103 | 23859 | 284 |
2071496 | 2071496 | 2022-01-01 | Pennington | Minnesota | 27113 | 2669 | 32 |
2072627 | 2072627 | 2022-01-01 | Pennington | South Dakota | 46103 | 23859 | 284 |
2068245 | 2068245 | 2021-12-31 | Pennington | Minnesota | 27113 | 2669 | 32 |
2069376 | 2069376 | 2021-12-31 | Pennington | South Dakota | 46103 | 23859 | 284 |
2064994 | 2064994 | 2021-12-30 | Pennington | Minnesota | 27113 | 2669 | 32 |
2066125 | 2066125 | 2021-12-30 | Pennington | South Dakota | 46103 | 23859 | 284 |
2061744 | 2061744 | 2021-12-29 | Pennington | Minnesota | 27113 | 2664 | 31 |
2062875 | 2062875 | 2021-12-29 | Pennington | South Dakota | 46103 | 23801 | 280 |
2058495 | 2058495 | 2021-12-28 | Pennington | Minnesota | 27113 | 2661 | 31 |
2059625 | 2059625 | 2021-12-28 | Pennington | South Dakota | 46103 | 23691 | 280 |
2055246 | 2055246 | 2021-12-27 | Pennington | Minnesota | 27113 | 2653 | 31 |
2056376 | 2056376 | 2021-12-27 | Pennington | South Dakota | 46103 | 23528 | 280 |
2051996 | 2051996 | 2021-12-26 | Pennington | Minnesota | 27113 | 2646 | 31 |
2053127 | 2053127 | 2021-12-26 | Pennington | South Dakota | 46103 | 23479 | 278 |
2048746 | 2048746 | 2021-12-25 | Pennington | Minnesota | 27113 | 2646 | 31 |
2049877 | 2049877 | 2021-12-25 | Pennington | South Dakota | 46103 | 23479 | 278 |
2045496 | 2045496 | 2021-12-24 | Pennington | Minnesota | 27113 | 2646 | 31 |
2046627 | 2046627 | 2021-12-24 | Pennington | South Dakota | 46103 | 23479 | 278 |
2042246 | 2042246 | 2021-12-23 | Pennington | Minnesota | 27113 | 2646 | 31 |
2043377 | 2043377 | 2021-12-23 | Pennington | South Dakota | 46103 | 23479 | 278 |
2038997 | 2038997 | 2021-12-22 | Pennington | Minnesota | 27113 | 2644 | 31 |
2040128 | 2040128 | 2021-12-22 | Pennington | South Dakota | 46103 | 23419 | 278 |
2035747 | 2035747 | 2021-12-21 | Pennington | Minnesota | 27113 | 2641 | 31 |
2036878 | 2036878 | 2021-12-21 | Pennington | South Dakota | 46103 | 23369 | 278 |
2032497 | 2032497 | 2021-12-20 | Pennington | Minnesota | 27113 | 2638 | 31 |
2033628 | 2033628 | 2021-12-20 | Pennington | South Dakota | 46103 | 23307 | 277 |
2029246 | 2029246 | 2021-12-19 | Pennington | Minnesota | 27113 | 2631 | 31 |
2030378 | 2030378 | 2021-12-19 | Pennington | South Dakota | 46103 | 23281 | 275 |
2025995 | 2025995 | 2021-12-18 | Pennington | Minnesota | 27113 | 2631 | 31 |
2027127 | 2027127 | 2021-12-18 | Pennington | South Dakota | 46103 | 23281 | 275 |
2022744 | 2022744 | 2021-12-17 | Pennington | Minnesota | 27113 | 2631 | 31 |
2023876 | 2023876 | 2021-12-17 | Pennington | South Dakota | 46103 | 23281 | 275 |
2019493 | 2019493 | 2021-12-16 | Pennington | Minnesota | 27113 | 2624 | 30 |
2020625 | 2020625 | 2021-12-16 | Pennington | South Dakota | 46103 | 23252 | 275 |
2016243 | 2016243 | 2021-12-15 | Pennington | Minnesota | 27113 | 2618 | 30 |
2017374 | 2017374 | 2021-12-15 | Pennington | South Dakota | 46103 | 23201 | 273 |
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);