ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
380 rows where county = "Unknown" and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2156733 | 2156733 | 2022-01-27 | Unknown | Northern Mariana Islands | 445 | 2 | |
2153480 | 2153480 | 2022-01-26 | Unknown | Northern Mariana Islands | 321 | 1 | |
2150228 | 2150228 | 2022-01-25 | Unknown | Northern Mariana Islands | 225 | 1 | |
2146976 | 2146976 | 2022-01-24 | Unknown | Northern Mariana Islands | 146 | 1 | |
2143722 | 2143722 | 2022-01-23 | Unknown | Northern Mariana Islands | 127 | 1 | |
2140467 | 2140467 | 2022-01-22 | Unknown | Northern Mariana Islands | 89 | 1 | |
2137211 | 2137211 | 2022-01-21 | Unknown | Northern Mariana Islands | 47 | 0 | |
2130705 | 2130705 | 2022-01-19 | Unknown | Northern Mariana Islands | 549 | 3 | |
2127451 | 2127451 | 2022-01-18 | Unknown | Northern Mariana Islands | 496 | 3 | |
2124199 | 2124199 | 2022-01-17 | Unknown | Northern Mariana Islands | 453 | 3 | |
2120947 | 2120947 | 2022-01-16 | Unknown | Northern Mariana Islands | 387 | 3 | |
2117695 | 2117695 | 2022-01-15 | Unknown | Northern Mariana Islands | 387 | 3 | |
2114444 | 2114444 | 2022-01-14 | Unknown | Northern Mariana Islands | 350 | 3 | |
2111192 | 2111192 | 2022-01-13 | Unknown | Northern Mariana Islands | 284 | 2 | |
2107940 | 2107940 | 2022-01-12 | Unknown | Northern Mariana Islands | 233 | 2 | |
2104689 | 2104689 | 2022-01-11 | Unknown | Northern Mariana Islands | 180 | 2 | |
2101438 | 2101438 | 2022-01-10 | Unknown | Northern Mariana Islands | 147 | 2 | |
2098187 | 2098187 | 2022-01-09 | Unknown | Northern Mariana Islands | 129 | 2 | |
2094935 | 2094935 | 2022-01-08 | Unknown | Northern Mariana Islands | 80 | 1 | |
2091683 | 2091683 | 2022-01-07 | Unknown | Northern Mariana Islands | 43 | 1 | |
2085180 | 2085180 | 2022-01-05 | Unknown | Northern Mariana Islands | 490 | 7 | |
2081928 | 2081928 | 2022-01-04 | Unknown | Northern Mariana Islands | 429 | 7 | |
2078676 | 2078676 | 2022-01-03 | Unknown | Northern Mariana Islands | 371 | 7 | |
2075425 | 2075425 | 2022-01-02 | Unknown | Northern Mariana Islands | 334 | 6 | |
2072174 | 2072174 | 2022-01-01 | Unknown | Northern Mariana Islands | 324 | 3 | |
2068923 | 2068923 | 2021-12-31 | Unknown | Northern Mariana Islands | 292 | 2 | |
2065672 | 2065672 | 2021-12-30 | Unknown | Northern Mariana Islands | 245 | 2 | |
2062422 | 2062422 | 2021-12-29 | Unknown | Northern Mariana Islands | 122 | 2 | |
2052674 | 2052674 | 2021-12-26 | Unknown | Northern Mariana Islands | 317 | 1 | |
2049424 | 2049424 | 2021-12-25 | Unknown | Northern Mariana Islands | 317 | 1 | |
2046174 | 2046174 | 2021-12-24 | Unknown | Northern Mariana Islands | 317 | 1 | |
2042924 | 2042924 | 2021-12-23 | Unknown | Northern Mariana Islands | 317 | 1 | |
2039675 | 2039675 | 2021-12-22 | Unknown | Northern Mariana Islands | 522 | 2 | |
2036425 | 2036425 | 2021-12-21 | Unknown | Northern Mariana Islands | 461 | 2 | |
2033175 | 2033175 | 2021-12-20 | Unknown | Northern Mariana Islands | 387 | 2 | |
2029925 | 2029925 | 2021-12-19 | Unknown | Northern Mariana Islands | 303 | 2 | |
2026674 | 2026674 | 2021-12-18 | Unknown | Northern Mariana Islands | 256 | 1 | |
2023423 | 2023423 | 2021-12-17 | Unknown | Northern Mariana Islands | 202 | 0 | |
2020172 | 2020172 | 2021-12-16 | Unknown | Northern Mariana Islands | 86 | 0 | |
2016921 | 2016921 | 2021-12-15 | Unknown | Northern Mariana Islands | 1722 | 3 | |
2013671 | 2013671 | 2021-12-14 | Unknown | Northern Mariana Islands | 1623 | 3 | |
2010420 | 2010420 | 2021-12-13 | Unknown | Northern Mariana Islands | 1513 | 3 | |
2007169 | 2007169 | 2021-12-12 | Unknown | Northern Mariana Islands | 1513 | 3 | |
2003918 | 2003918 | 2021-12-11 | Unknown | Northern Mariana Islands | 1119 | 2 | |
2000667 | 2000667 | 2021-12-10 | Unknown | Northern Mariana Islands | 1119 | 2 | |
1997417 | 1997417 | 2021-12-09 | Unknown | Northern Mariana Islands | 1119 | 2 | |
1994166 | 1994166 | 2021-12-08 | Unknown | Northern Mariana Islands | 787 | 0 | |
1990915 | 1990915 | 2021-12-07 | Unknown | Northern Mariana Islands | 787 | 0 | |
1987664 | 1987664 | 2021-12-06 | Unknown | Northern Mariana Islands | 787 | 0 | |
1984414 | 1984414 | 2021-12-05 | Unknown | Northern Mariana Islands | 709 | 0 | |
1981164 | 1981164 | 2021-12-04 | Unknown | Northern Mariana Islands | 709 | 0 | |
1977914 | 1977914 | 2021-12-03 | Unknown | Northern Mariana Islands | 709 | 0 | |
1974664 | 1974664 | 2021-12-02 | Unknown | Northern Mariana Islands | 667 | 0 | |
1971415 | 1971415 | 2021-12-01 | Unknown | Northern Mariana Islands | 460 | 0 | |
1968165 | 1968165 | 2021-11-30 | Unknown | Northern Mariana Islands | 460 | 0 | |
1964914 | 1964914 | 2021-11-29 | Unknown | Northern Mariana Islands | 274 | 0 | |
1961662 | 1961662 | 2021-11-28 | Unknown | Northern Mariana Islands | 274 | 0 | |
1958411 | 1958411 | 2021-11-27 | Unknown | Northern Mariana Islands | 274 | 0 | |
1955160 | 1955160 | 2021-11-26 | Unknown | Northern Mariana Islands | 274 | 0 | |
1951909 | 1951909 | 2021-11-25 | Unknown | Northern Mariana Islands | 254 | 0 | |
1948658 | 1948658 | 2021-11-24 | Unknown | Northern Mariana Islands | 209 | 0 | |
1945407 | 1945407 | 2021-11-23 | Unknown | Northern Mariana Islands | 79 | 0 | |
1942156 | 1942156 | 2021-11-22 | Unknown | Northern Mariana Islands | 79 | 0 | |
1938906 | 1938906 | 2021-11-21 | Unknown | Northern Mariana Islands | 69 | 0 | |
1935656 | 1935656 | 2021-11-20 | Unknown | Northern Mariana Islands | 43 | 0 | |
1932406 | 1932406 | 2021-11-19 | Unknown | Northern Mariana Islands | 43 | 0 | |
1929155 | 1929155 | 2021-11-18 | Unknown | Northern Mariana Islands | 36 | 0 | |
1925905 | 1925905 | 2021-11-17 | Unknown | Northern Mariana Islands | 13 | 0 | |
1919406 | 1919406 | 2021-11-15 | Unknown | Northern Mariana Islands | 1 | 0 | |
1916156 | 1916156 | 2021-11-14 | Unknown | Northern Mariana Islands | 1 | 0 | |
1912906 | 1912906 | 2021-11-13 | Unknown | Northern Mariana Islands | 1 | 0 | |
1909656 | 1909656 | 2021-11-12 | Unknown | Northern Mariana Islands | 1 | 0 | |
1906407 | 1906407 | 2021-11-11 | Unknown | Northern Mariana Islands | 1 | 0 | |
1903158 | 1903158 | 2021-11-10 | Unknown | Northern Mariana Islands | 1 | 0 | |
1899908 | 1899908 | 2021-11-09 | Unknown | Northern Mariana Islands | 1 | 0 | |
1896658 | 1896658 | 2021-11-08 | Unknown | Northern Mariana Islands | 1 | 0 | |
1893408 | 1893408 | 2021-11-07 | Unknown | Northern Mariana Islands | 1 | 0 | |
1890158 | 1890158 | 2021-11-06 | Unknown | Northern Mariana Islands | 31 | 0 | |
1886908 | 1886908 | 2021-11-05 | Unknown | Northern Mariana Islands | 31 | 0 | |
1805679 | 1805679 | 2021-10-11 | Unknown | Northern Mariana Islands | 4 | 1 | |
1688721 | 1688721 | 2021-09-05 | Unknown | Northern Mariana Islands | 2 | 0 | |
1685471 | 1685471 | 2021-09-04 | Unknown | Northern Mariana Islands | 2 | 0 | |
1682220 | 1682220 | 2021-09-03 | Unknown | Northern Mariana Islands | 2 | 0 | |
1649741 | 1649741 | 2021-08-24 | Unknown | Northern Mariana Islands | 43 | 0 | |
1646492 | 1646492 | 2021-08-23 | Unknown | Northern Mariana Islands | 43 | 0 | |
1643243 | 1643243 | 2021-08-22 | Unknown | Northern Mariana Islands | 41 | 0 | |
1639993 | 1639993 | 2021-08-21 | Unknown | Northern Mariana Islands | 41 | 0 | |
1636743 | 1636743 | 2021-08-20 | Unknown | Northern Mariana Islands | 41 | 0 | |
1633493 | 1633493 | 2021-08-19 | Unknown | Northern Mariana Islands | 41 | 0 | |
1630246 | 1630246 | 2021-08-18 | Unknown | Northern Mariana Islands | 37 | 0 | |
1626999 | 1626999 | 2021-08-17 | Unknown | Northern Mariana Islands | 37 | 0 | |
1623752 | 1623752 | 2021-08-16 | Unknown | Northern Mariana Islands | 36 | 0 | |
1620505 | 1620505 | 2021-08-15 | Unknown | Northern Mariana Islands | 31 | 0 | |
1617257 | 1617257 | 2021-08-14 | Unknown | Northern Mariana Islands | 31 | 0 | |
1614009 | 1614009 | 2021-08-13 | Unknown | Northern Mariana Islands | 31 | 0 | |
1610760 | 1610760 | 2021-08-12 | Unknown | Northern Mariana Islands | 28 | 0 | |
1607512 | 1607512 | 2021-08-11 | Unknown | Northern Mariana Islands | 28 | 0 | |
1604263 | 1604263 | 2021-08-10 | Unknown | Northern Mariana Islands | 27 | 0 | |
1601014 | 1601014 | 2021-08-09 | Unknown | Northern Mariana Islands | 27 | 0 | |
1597766 | 1597766 | 2021-08-08 | Unknown | Northern Mariana Islands | 23 | 0 |
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);