ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
579 rows where deaths = 2 and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338869 | 2338869 | 2022-03-24 | Unknown | Northern Mariana Islands | 1273 | 2 | |
2231548 | 2231548 | 2022-02-19 | Unknown | Northern Mariana Islands | 3142 | 2 | |
2228297 | 2228297 | 2022-02-18 | Unknown | Northern Mariana Islands | 3031 | 2 | |
2225046 | 2225046 | 2022-02-17 | Unknown | Northern Mariana Islands | 2873 | 2 | |
2221795 | 2221795 | 2022-02-16 | Unknown | Northern Mariana Islands | 2647 | 2 | |
2218544 | 2218544 | 2022-02-15 | Unknown | Northern Mariana Islands | 2466 | 2 | |
2169753 | 2169753 | 2022-01-31 | Unknown | Northern Mariana Islands | 676 | 2 | |
2166498 | 2166498 | 2022-01-30 | Unknown | Northern Mariana Islands | 676 | 2 | |
2163243 | 2163243 | 2022-01-29 | Unknown | Northern Mariana Islands | 653 | 2 | |
2159988 | 2159988 | 2022-01-28 | Unknown | Northern Mariana Islands | 573 | 2 | |
2156733 | 2156733 | 2022-01-27 | Unknown | Northern Mariana Islands | 445 | 2 | |
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 | |
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 | |
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 | |
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 | |
1805677 | 1805677 | 2021-10-11 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1802428 | 1802428 | 2021-10-10 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1799179 | 1799179 | 2021-10-09 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1795930 | 1795930 | 2021-10-08 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1792681 | 1792681 | 2021-10-07 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1789432 | 1789432 | 2021-10-06 | Saipan | Northern Mariana Islands | 69110 | 267 | 2 |
1786184 | 1786184 | 2021-10-05 | Saipan | Northern Mariana Islands | 69110 | 266 | 2 |
1782935 | 1782935 | 2021-10-04 | Saipan | Northern Mariana Islands | 69110 | 266 | 2 |
1779686 | 1779686 | 2021-10-03 | Saipan | Northern Mariana Islands | 69110 | 264 | 2 |
1776436 | 1776436 | 2021-10-02 | Saipan | Northern Mariana Islands | 69110 | 264 | 2 |
1773186 | 1773186 | 2021-10-01 | Saipan | Northern Mariana Islands | 69110 | 264 | 2 |
1769936 | 1769936 | 2021-09-30 | Saipan | Northern Mariana Islands | 69110 | 263 | 2 |
1766687 | 1766687 | 2021-09-29 | Saipan | Northern Mariana Islands | 69110 | 262 | 2 |
1763438 | 1763438 | 2021-09-28 | Saipan | Northern Mariana Islands | 69110 | 262 | 2 |
1760189 | 1760189 | 2021-09-27 | Saipan | Northern Mariana Islands | 69110 | 261 | 2 |
1756941 | 1756941 | 2021-09-26 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1753693 | 1753693 | 2021-09-25 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1750445 | 1750445 | 2021-09-24 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1747195 | 1747195 | 2021-09-23 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1743946 | 1743946 | 2021-09-22 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1740697 | 1740697 | 2021-09-21 | Saipan | Northern Mariana Islands | 69110 | 259 | 2 |
1737448 | 1737448 | 2021-09-20 | Saipan | Northern Mariana Islands | 69110 | 257 | 2 |
1734198 | 1734198 | 2021-09-19 | Saipan | Northern Mariana Islands | 69110 | 252 | 2 |
1730948 | 1730948 | 2021-09-18 | Saipan | Northern Mariana Islands | 69110 | 252 | 2 |
1727698 | 1727698 | 2021-09-17 | Saipan | Northern Mariana Islands | 69110 | 252 | 2 |
1724449 | 1724449 | 2021-09-16 | Saipan | Northern Mariana Islands | 69110 | 252 | 2 |
1721200 | 1721200 | 2021-09-15 | Saipan | Northern Mariana Islands | 69110 | 252 | 2 |
1717952 | 1717952 | 2021-09-14 | Saipan | Northern Mariana Islands | 69110 | 250 | 2 |
1714704 | 1714704 | 2021-09-13 | Saipan | Northern Mariana Islands | 69110 | 246 | 2 |
1711458 | 1711458 | 2021-09-12 | Saipan | Northern Mariana Islands | 69110 | 244 | 2 |
1708211 | 1708211 | 2021-09-11 | Saipan | Northern Mariana Islands | 69110 | 244 | 2 |
1704964 | 1704964 | 2021-09-10 | Saipan | Northern Mariana Islands | 69110 | 244 | 2 |
1701714 | 1701714 | 2021-09-09 | Saipan | Northern Mariana Islands | 69110 | 243 | 2 |
1698465 | 1698465 | 2021-09-08 | Saipan | Northern Mariana Islands | 69110 | 243 | 2 |
1695217 | 1695217 | 2021-09-07 | Saipan | Northern Mariana Islands | 69110 | 242 | 2 |
1691969 | 1691969 | 2021-09-06 | Saipan | Northern Mariana Islands | 69110 | 242 | 2 |
1688719 | 1688719 | 2021-09-05 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1685469 | 1685469 | 2021-09-04 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1682218 | 1682218 | 2021-09-03 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1678969 | 1678969 | 2021-09-02 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1675721 | 1675721 | 2021-09-01 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1672474 | 1672474 | 2021-08-31 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1669226 | 1669226 | 2021-08-30 | Saipan | Northern Mariana Islands | 69110 | 235 | 2 |
1665979 | 1665979 | 2021-08-29 | Saipan | Northern Mariana Islands | 69110 | 228 | 2 |
1662731 | 1662731 | 2021-08-28 | Saipan | Northern Mariana Islands | 69110 | 228 | 2 |
1659483 | 1659483 | 2021-08-27 | Saipan | Northern Mariana Islands | 69110 | 228 | 2 |
1656234 | 1656234 | 2021-08-26 | Saipan | Northern Mariana Islands | 69110 | 226 | 2 |
1652987 | 1652987 | 2021-08-25 | Saipan | Northern Mariana Islands | 69110 | 224 | 2 |
1649739 | 1649739 | 2021-08-24 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1646490 | 1646490 | 2021-08-23 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1643241 | 1643241 | 2021-08-22 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1639991 | 1639991 | 2021-08-21 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1636741 | 1636741 | 2021-08-20 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1633491 | 1633491 | 2021-08-19 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1630244 | 1630244 | 2021-08-18 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1626997 | 1626997 | 2021-08-17 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1623750 | 1623750 | 2021-08-16 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1620503 | 1620503 | 2021-08-15 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1617255 | 1617255 | 2021-08-14 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1614007 | 1614007 | 2021-08-13 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1610758 | 1610758 | 2021-08-12 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1607510 | 1607510 | 2021-08-11 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1604261 | 1604261 | 2021-08-10 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1601012 | 1601012 | 2021-08-09 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1597764 | 1597764 | 2021-08-08 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1594515 | 1594515 | 2021-08-07 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1591266 | 1591266 | 2021-08-06 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1588017 | 1588017 | 2021-08-05 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1584767 | 1584767 | 2021-08-04 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1581517 | 1581517 | 2021-08-03 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1578268 | 1578268 | 2021-08-02 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1575020 | 1575020 | 2021-08-01 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1571772 | 1571772 | 2021-07-31 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
1568524 | 1568524 | 2021-07-30 | Saipan | Northern Mariana Islands | 69110 | 181 | 2 |
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);