ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 30111 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175865 | 2175865 | 2022-02-02 | Yellowstone | Montana | 30111 | 39148 | 500 |
2172612 | 2172612 | 2022-02-01 | Yellowstone | Montana | 30111 | 38935 | 491 |
2169359 | 2169359 | 2022-01-31 | Yellowstone | Montana | 30111 | 38742 | 487 |
2166104 | 2166104 | 2022-01-30 | Yellowstone | Montana | 30111 | 38255 | 486 |
2162849 | 2162849 | 2022-01-29 | Yellowstone | Montana | 30111 | 38255 | 486 |
2159594 | 2159594 | 2022-01-28 | Yellowstone | Montana | 30111 | 38255 | 486 |
2156340 | 2156340 | 2022-01-27 | Yellowstone | Montana | 30111 | 37660 | 485 |
2153087 | 2153087 | 2022-01-26 | Yellowstone | Montana | 30111 | 37378 | 485 |
2149835 | 2149835 | 2022-01-25 | Yellowstone | Montana | 30111 | 36930 | 485 |
2146583 | 2146583 | 2022-01-24 | Yellowstone | Montana | 30111 | 36491 | 485 |
2143328 | 2143328 | 2022-01-23 | Yellowstone | Montana | 30111 | 35406 | 485 |
2140073 | 2140073 | 2022-01-22 | Yellowstone | Montana | 30111 | 35406 | 485 |
2136817 | 2136817 | 2022-01-21 | Yellowstone | Montana | 30111 | 35406 | 485 |
2133565 | 2133565 | 2022-01-20 | Yellowstone | Montana | 30111 | 35177 | 485 |
2130312 | 2130312 | 2022-01-19 | Yellowstone | Montana | 30111 | 34935 | 485 |
2127058 | 2127058 | 2022-01-18 | Yellowstone | Montana | 30111 | 34704 | 483 |
2123806 | 2123806 | 2022-01-17 | Yellowstone | Montana | 30111 | 34307 | 481 |
2120554 | 2120554 | 2022-01-16 | Yellowstone | Montana | 30111 | 34307 | 481 |
2117302 | 2117302 | 2022-01-15 | Yellowstone | Montana | 30111 | 34307 | 481 |
2114051 | 2114051 | 2022-01-14 | Yellowstone | Montana | 30111 | 34307 | 481 |
2110799 | 2110799 | 2022-01-13 | Yellowstone | Montana | 30111 | 33853 | 477 |
2107548 | 2107548 | 2022-01-12 | Yellowstone | Montana | 30111 | 33565 | 477 |
2104297 | 2104297 | 2022-01-11 | Yellowstone | Montana | 30111 | 33206 | 477 |
2101046 | 2101046 | 2022-01-10 | Yellowstone | Montana | 30111 | 33008 | 475 |
2097795 | 2097795 | 2022-01-09 | Yellowstone | Montana | 30111 | 32849 | 475 |
2094543 | 2094543 | 2022-01-08 | Yellowstone | Montana | 30111 | 32849 | 475 |
2091291 | 2091291 | 2022-01-07 | Yellowstone | Montana | 30111 | 32849 | 475 |
2088040 | 2088040 | 2022-01-06 | Yellowstone | Montana | 30111 | 32700 | 475 |
2084788 | 2084788 | 2022-01-05 | Yellowstone | Montana | 30111 | 32613 | 475 |
2081536 | 2081536 | 2022-01-04 | Yellowstone | Montana | 30111 | 32417 | 475 |
2078284 | 2078284 | 2022-01-03 | Yellowstone | Montana | 30111 | 32247 | 473 |
2075033 | 2075033 | 2022-01-02 | Yellowstone | Montana | 30111 | 32133 | 473 |
2071782 | 2071782 | 2022-01-01 | Yellowstone | Montana | 30111 | 32133 | 473 |
2068531 | 2068531 | 2021-12-31 | Yellowstone | Montana | 30111 | 32133 | 473 |
2065280 | 2065280 | 2021-12-30 | Yellowstone | Montana | 30111 | 32133 | 473 |
2062030 | 2062030 | 2021-12-29 | Yellowstone | Montana | 30111 | 32072 | 473 |
2058781 | 2058781 | 2021-12-28 | Yellowstone | Montana | 30111 | 31993 | 472 |
2055532 | 2055532 | 2021-12-27 | Yellowstone | Montana | 30111 | 31926 | 470 |
2052282 | 2052282 | 2021-12-26 | Yellowstone | Montana | 30111 | 31895 | 468 |
2049032 | 2049032 | 2021-12-25 | Yellowstone | Montana | 30111 | 31895 | 468 |
2045782 | 2045782 | 2021-12-24 | Yellowstone | Montana | 30111 | 31895 | 468 |
2042532 | 2042532 | 2021-12-23 | Yellowstone | Montana | 30111 | 31895 | 468 |
2039283 | 2039283 | 2021-12-22 | Yellowstone | Montana | 30111 | 31873 | 468 |
2036033 | 2036033 | 2021-12-21 | Yellowstone | Montana | 30111 | 31828 | 468 |
2032783 | 2032783 | 2021-12-20 | Yellowstone | Montana | 30111 | 31788 | 468 |
2029532 | 2029532 | 2021-12-19 | Yellowstone | Montana | 30111 | 31767 | 468 |
2026281 | 2026281 | 2021-12-18 | Yellowstone | Montana | 30111 | 31767 | 468 |
2023030 | 2023030 | 2021-12-17 | Yellowstone | Montana | 30111 | 31767 | 468 |
2019779 | 2019779 | 2021-12-16 | Yellowstone | Montana | 30111 | 31754 | 467 |
2016529 | 2016529 | 2021-12-15 | Yellowstone | Montana | 30111 | 31735 | 465 |
2013278 | 2013278 | 2021-12-14 | Yellowstone | Montana | 30111 | 31700 | 464 |
2010027 | 2010027 | 2021-12-13 | Yellowstone | Montana | 30111 | 31643 | 462 |
2006776 | 2006776 | 2021-12-12 | Yellowstone | Montana | 30111 | 31626 | 462 |
2003525 | 2003525 | 2021-12-11 | Yellowstone | Montana | 30111 | 31626 | 462 |
2000275 | 2000275 | 2021-12-10 | Yellowstone | Montana | 30111 | 31626 | 462 |
1997024 | 1997024 | 2021-12-09 | Yellowstone | Montana | 30111 | 31591 | 461 |
1993773 | 1993773 | 2021-12-08 | Yellowstone | Montana | 30111 | 31566 | 458 |
1990522 | 1990522 | 2021-12-07 | Yellowstone | Montana | 30111 | 31532 | 456 |
1987272 | 1987272 | 2021-12-06 | Yellowstone | Montana | 30111 | 31438 | 454 |
1984022 | 1984022 | 2021-12-05 | Yellowstone | Montana | 30111 | 31384 | 451 |
1980772 | 1980772 | 2021-12-04 | Yellowstone | Montana | 30111 | 31384 | 451 |
1977522 | 1977522 | 2021-12-03 | Yellowstone | Montana | 30111 | 31384 | 451 |
1974272 | 1974272 | 2021-12-02 | Yellowstone | Montana | 30111 | 31329 | 451 |
1971023 | 1971023 | 2021-12-01 | Yellowstone | Montana | 30111 | 31316 | 451 |
1967773 | 1967773 | 2021-11-30 | Yellowstone | Montana | 30111 | 31241 | 449 |
1964521 | 1964521 | 2021-11-29 | Yellowstone | Montana | 30111 | 31143 | 443 |
1961270 | 1961270 | 2021-11-28 | Yellowstone | Montana | 30111 | 31094 | 438 |
1958019 | 1958019 | 2021-11-27 | Yellowstone | Montana | 30111 | 31094 | 438 |
1954768 | 1954768 | 2021-11-26 | Yellowstone | Montana | 30111 | 31094 | 438 |
1951517 | 1951517 | 2021-11-25 | Yellowstone | Montana | 30111 | 31033 | 436 |
1948266 | 1948266 | 2021-11-24 | Yellowstone | Montana | 30111 | 31033 | 436 |
1945015 | 1945015 | 2021-11-23 | Yellowstone | Montana | 30111 | 30970 | 435 |
1941764 | 1941764 | 2021-11-22 | Yellowstone | Montana | 30111 | 30821 | 433 |
1938514 | 1938514 | 2021-11-21 | Yellowstone | Montana | 30111 | 30722 | 430 |
1935264 | 1935264 | 2021-11-20 | Yellowstone | Montana | 30111 | 30722 | 430 |
1932014 | 1932014 | 2021-11-19 | Yellowstone | Montana | 30111 | 30722 | 430 |
1928763 | 1928763 | 2021-11-18 | Yellowstone | Montana | 30111 | 30647 | 429 |
1925513 | 1925513 | 2021-11-17 | Yellowstone | Montana | 30111 | 30515 | 426 |
1922264 | 1922264 | 2021-11-16 | Yellowstone | Montana | 30111 | 30477 | 425 |
1919014 | 1919014 | 2021-11-15 | Yellowstone | Montana | 30111 | 30295 | 419 |
1915764 | 1915764 | 2021-11-14 | Yellowstone | Montana | 30111 | 30210 | 424 |
1912514 | 1912514 | 2021-11-13 | Yellowstone | Montana | 30111 | 30210 | 424 |
1909264 | 1909264 | 2021-11-12 | Yellowstone | Montana | 30111 | 30210 | 424 |
1906015 | 1906015 | 2021-11-11 | Yellowstone | Montana | 30111 | 30017 | 417 |
1902766 | 1902766 | 2021-11-10 | Yellowstone | Montana | 30111 | 30017 | 417 |
1899516 | 1899516 | 2021-11-09 | Yellowstone | Montana | 30111 | 29835 | 417 |
1896266 | 1896266 | 2021-11-08 | Yellowstone | Montana | 30111 | 29634 | 412 |
1893016 | 1893016 | 2021-11-07 | Yellowstone | Montana | 30111 | 29550 | 410 |
1889766 | 1889766 | 2021-11-06 | Yellowstone | Montana | 30111 | 29550 | 410 |
1886516 | 1886516 | 2021-11-05 | Yellowstone | Montana | 30111 | 29550 | 410 |
1883267 | 1883267 | 2021-11-04 | Yellowstone | Montana | 30111 | 29399 | 410 |
1880018 | 1880018 | 2021-11-03 | Yellowstone | Montana | 30111 | 29240 | 410 |
1876769 | 1876769 | 2021-11-02 | Yellowstone | Montana | 30111 | 29098 | 408 |
1873520 | 1873520 | 2021-11-01 | Yellowstone | Montana | 30111 | 28866 | 403 |
1870271 | 1870271 | 2021-10-31 | Yellowstone | Montana | 30111 | 28696 | 400 |
1867022 | 1867022 | 2021-10-30 | Yellowstone | Montana | 30111 | 28696 | 400 |
1863773 | 1863773 | 2021-10-29 | Yellowstone | Montana | 30111 | 28696 | 400 |
1860524 | 1860524 | 2021-10-28 | Yellowstone | Montana | 30111 | 28515 | 398 |
1857275 | 1857275 | 2021-10-27 | Yellowstone | Montana | 30111 | 28334 | 397 |
1854026 | 1854026 | 2021-10-26 | Yellowstone | Montana | 30111 | 28110 | 396 |
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);