ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 38011 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176207 | 2176207 | 2022-02-02 | Bowman | North Dakota | 38011 | 786 | 9 |
2172954 | 2172954 | 2022-02-01 | Bowman | North Dakota | 38011 | 783 | 9 |
2169701 | 2169701 | 2022-01-31 | Bowman | North Dakota | 38011 | 776 | 9 |
2166446 | 2166446 | 2022-01-30 | Bowman | North Dakota | 38011 | 776 | 9 |
2163191 | 2163191 | 2022-01-29 | Bowman | North Dakota | 38011 | 772 | 9 |
2159936 | 2159936 | 2022-01-28 | Bowman | North Dakota | 38011 | 766 | 9 |
2156681 | 2156681 | 2022-01-27 | Bowman | North Dakota | 38011 | 759 | 9 |
2153428 | 2153428 | 2022-01-26 | Bowman | North Dakota | 38011 | 754 | 9 |
2150176 | 2150176 | 2022-01-25 | Bowman | North Dakota | 38011 | 745 | 9 |
2146924 | 2146924 | 2022-01-24 | Bowman | North Dakota | 38011 | 740 | 9 |
2143670 | 2143670 | 2022-01-23 | Bowman | North Dakota | 38011 | 740 | 9 |
2140415 | 2140415 | 2022-01-22 | Bowman | North Dakota | 38011 | 739 | 9 |
2137159 | 2137159 | 2022-01-21 | Bowman | North Dakota | 38011 | 734 | 9 |
2133906 | 2133906 | 2022-01-20 | Bowman | North Dakota | 38011 | 727 | 9 |
2130654 | 2130654 | 2022-01-19 | Bowman | North Dakota | 38011 | 722 | 9 |
2127400 | 2127400 | 2022-01-18 | Bowman | North Dakota | 38011 | 718 | 9 |
2124148 | 2124148 | 2022-01-17 | Bowman | North Dakota | 38011 | 709 | 9 |
2120896 | 2120896 | 2022-01-16 | Bowman | North Dakota | 38011 | 707 | 9 |
2117644 | 2117644 | 2022-01-15 | Bowman | North Dakota | 38011 | 706 | 9 |
2114393 | 2114393 | 2022-01-14 | Bowman | North Dakota | 38011 | 703 | 9 |
2111141 | 2111141 | 2022-01-13 | Bowman | North Dakota | 38011 | 698 | 9 |
2107889 | 2107889 | 2022-01-12 | Bowman | North Dakota | 38011 | 696 | 9 |
2104638 | 2104638 | 2022-01-11 | Bowman | North Dakota | 38011 | 694 | 9 |
2101387 | 2101387 | 2022-01-10 | Bowman | North Dakota | 38011 | 693 | 9 |
2098136 | 2098136 | 2022-01-09 | Bowman | North Dakota | 38011 | 692 | 9 |
2094884 | 2094884 | 2022-01-08 | Bowman | North Dakota | 38011 | 689 | 9 |
2091632 | 2091632 | 2022-01-07 | Bowman | North Dakota | 38011 | 689 | 9 |
2088381 | 2088381 | 2022-01-06 | Bowman | North Dakota | 38011 | 687 | 9 |
2085129 | 2085129 | 2022-01-05 | Bowman | North Dakota | 38011 | 685 | 9 |
2081877 | 2081877 | 2022-01-04 | Bowman | North Dakota | 38011 | 684 | 9 |
2078625 | 2078625 | 2022-01-03 | Bowman | North Dakota | 38011 | 684 | 9 |
2075374 | 2075374 | 2022-01-02 | Bowman | North Dakota | 38011 | 684 | 9 |
2072123 | 2072123 | 2022-01-01 | Bowman | North Dakota | 38011 | 683 | 9 |
2068872 | 2068872 | 2021-12-31 | Bowman | North Dakota | 38011 | 682 | 9 |
2065621 | 2065621 | 2021-12-30 | Bowman | North Dakota | 38011 | 679 | 9 |
2062371 | 2062371 | 2021-12-29 | Bowman | North Dakota | 38011 | 676 | 9 |
2059122 | 2059122 | 2021-12-28 | Bowman | North Dakota | 38011 | 675 | 8 |
2055873 | 2055873 | 2021-12-27 | Bowman | North Dakota | 38011 | 676 | 8 |
2052623 | 2052623 | 2021-12-26 | Bowman | North Dakota | 38011 | 675 | 8 |
2049373 | 2049373 | 2021-12-25 | Bowman | North Dakota | 38011 | 675 | 8 |
2046123 | 2046123 | 2021-12-24 | Bowman | North Dakota | 38011 | 675 | 8 |
2042873 | 2042873 | 2021-12-23 | Bowman | North Dakota | 38011 | 674 | 8 |
2039624 | 2039624 | 2021-12-22 | Bowman | North Dakota | 38011 | 674 | 8 |
2036374 | 2036374 | 2021-12-21 | Bowman | North Dakota | 38011 | 673 | 8 |
2033124 | 2033124 | 2021-12-20 | Bowman | North Dakota | 38011 | 673 | 8 |
2029874 | 2029874 | 2021-12-19 | Bowman | North Dakota | 38011 | 673 | 8 |
2026623 | 2026623 | 2021-12-18 | Bowman | North Dakota | 38011 | 673 | 8 |
2023372 | 2023372 | 2021-12-17 | Bowman | North Dakota | 38011 | 673 | 8 |
2020121 | 2020121 | 2021-12-16 | Bowman | North Dakota | 38011 | 673 | 8 |
2016870 | 2016870 | 2021-12-15 | Bowman | North Dakota | 38011 | 673 | 8 |
2013620 | 2013620 | 2021-12-14 | Bowman | North Dakota | 38011 | 672 | 8 |
2010369 | 2010369 | 2021-12-13 | Bowman | North Dakota | 38011 | 671 | 8 |
2007118 | 2007118 | 2021-12-12 | Bowman | North Dakota | 38011 | 671 | 8 |
2003867 | 2003867 | 2021-12-11 | Bowman | North Dakota | 38011 | 671 | 8 |
2000616 | 2000616 | 2021-12-10 | Bowman | North Dakota | 38011 | 670 | 8 |
1997366 | 1997366 | 2021-12-09 | Bowman | North Dakota | 38011 | 670 | 8 |
1994115 | 1994115 | 2021-12-08 | Bowman | North Dakota | 38011 | 669 | 8 |
1990864 | 1990864 | 2021-12-07 | Bowman | North Dakota | 38011 | 668 | 8 |
1987613 | 1987613 | 2021-12-06 | Bowman | North Dakota | 38011 | 668 | 8 |
1984363 | 1984363 | 2021-12-05 | Bowman | North Dakota | 38011 | 668 | 8 |
1981113 | 1981113 | 2021-12-04 | Bowman | North Dakota | 38011 | 668 | 8 |
1977863 | 1977863 | 2021-12-03 | Bowman | North Dakota | 38011 | 667 | 8 |
1974613 | 1974613 | 2021-12-02 | Bowman | North Dakota | 38011 | 663 | 8 |
1971364 | 1971364 | 2021-12-01 | Bowman | North Dakota | 38011 | 660 | 8 |
1968114 | 1968114 | 2021-11-30 | Bowman | North Dakota | 38011 | 660 | 8 |
1964863 | 1964863 | 2021-11-29 | Bowman | North Dakota | 38011 | 655 | 8 |
1961611 | 1961611 | 2021-11-28 | Bowman | North Dakota | 38011 | 655 | 8 |
1958360 | 1958360 | 2021-11-27 | Bowman | North Dakota | 38011 | 655 | 8 |
1955109 | 1955109 | 2021-11-26 | Bowman | North Dakota | 38011 | 654 | 8 |
1951858 | 1951858 | 2021-11-25 | Bowman | North Dakota | 38011 | 654 | 8 |
1948607 | 1948607 | 2021-11-24 | Bowman | North Dakota | 38011 | 652 | 8 |
1945356 | 1945356 | 2021-11-23 | Bowman | North Dakota | 38011 | 648 | 8 |
1942105 | 1942105 | 2021-11-22 | Bowman | North Dakota | 38011 | 645 | 8 |
1938855 | 1938855 | 2021-11-21 | Bowman | North Dakota | 38011 | 645 | 8 |
1935605 | 1935605 | 2021-11-20 | Bowman | North Dakota | 38011 | 644 | 8 |
1932355 | 1932355 | 2021-11-19 | Bowman | North Dakota | 38011 | 641 | 8 |
1929104 | 1929104 | 2021-11-18 | Bowman | North Dakota | 38011 | 639 | 8 |
1925854 | 1925854 | 2021-11-17 | Bowman | North Dakota | 38011 | 637 | 8 |
1922605 | 1922605 | 2021-11-16 | Bowman | North Dakota | 38011 | 636 | 8 |
1919355 | 1919355 | 2021-11-15 | Bowman | North Dakota | 38011 | 634 | 8 |
1916105 | 1916105 | 2021-11-14 | Bowman | North Dakota | 38011 | 634 | 8 |
1912855 | 1912855 | 2021-11-13 | Bowman | North Dakota | 38011 | 633 | 8 |
1909605 | 1909605 | 2021-11-12 | Bowman | North Dakota | 38011 | 633 | 8 |
1906356 | 1906356 | 2021-11-11 | Bowman | North Dakota | 38011 | 633 | 8 |
1903107 | 1903107 | 2021-11-10 | Bowman | North Dakota | 38011 | 630 | 8 |
1899857 | 1899857 | 2021-11-09 | Bowman | North Dakota | 38011 | 629 | 8 |
1896607 | 1896607 | 2021-11-08 | Bowman | North Dakota | 38011 | 627 | 8 |
1893357 | 1893357 | 2021-11-07 | Bowman | North Dakota | 38011 | 625 | 8 |
1890107 | 1890107 | 2021-11-06 | Bowman | North Dakota | 38011 | 625 | 8 |
1886857 | 1886857 | 2021-11-05 | Bowman | North Dakota | 38011 | 617 | 8 |
1883608 | 1883608 | 2021-11-04 | Bowman | North Dakota | 38011 | 614 | 8 |
1880359 | 1880359 | 2021-11-03 | Bowman | North Dakota | 38011 | 610 | 8 |
1877110 | 1877110 | 2021-11-02 | Bowman | North Dakota | 38011 | 608 | 7 |
1873861 | 1873861 | 2021-11-01 | Bowman | North Dakota | 38011 | 605 | 7 |
1870612 | 1870612 | 2021-10-31 | Bowman | North Dakota | 38011 | 605 | 7 |
1867363 | 1867363 | 2021-10-30 | Bowman | North Dakota | 38011 | 601 | 7 |
1864114 | 1864114 | 2021-10-29 | Bowman | North Dakota | 38011 | 600 | 7 |
1860865 | 1860865 | 2021-10-28 | Bowman | North Dakota | 38011 | 598 | 7 |
1857616 | 1857616 | 2021-10-27 | Bowman | North Dakota | 38011 | 592 | 7 |
1854367 | 1854367 | 2021-10-26 | Bowman | North Dakota | 38011 | 590 | 7 |
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);