ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where deaths = 3 and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2361641 | 2361641 | 2022-03-31 | Unknown | Northern Mariana Islands | 1341 | 3 | |
2358387 | 2358387 | 2022-03-30 | Unknown | Northern Mariana Islands | 1341 | 3 | |
2355133 | 2355133 | 2022-03-29 | Unknown | Northern Mariana Islands | 1341 | 3 | |
2351880 | 2351880 | 2022-03-28 | Unknown | Northern Mariana Islands | 1298 | 3 | |
2348628 | 2348628 | 2022-03-27 | Unknown | Northern Mariana Islands | 1298 | 3 | |
2345375 | 2345375 | 2022-03-26 | Unknown | Northern Mariana Islands | 1298 | 3 | |
2342122 | 2342122 | 2022-03-25 | Unknown | Northern Mariana Islands | 1298 | 3 | |
2238050 | 2238050 | 2022-02-21 | Unknown | Northern Mariana Islands | 3431 | 3 | |
2234799 | 2234799 | 2022-02-20 | Unknown | Northern Mariana Islands | 3364 | 3 | |
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 | |
2072174 | 2072174 | 2022-01-01 | Unknown | Northern Mariana Islands | 324 | 3 | |
2016919 | 2016919 | 2021-12-15 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
2016921 | 2016921 | 2021-12-15 | Unknown | Northern Mariana Islands | 1722 | 3 | |
2013669 | 2013669 | 2021-12-14 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
2013671 | 2013671 | 2021-12-14 | Unknown | Northern Mariana Islands | 1623 | 3 | |
2010418 | 2010418 | 2021-12-13 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
2010420 | 2010420 | 2021-12-13 | Unknown | Northern Mariana Islands | 1513 | 3 | |
2007167 | 2007167 | 2021-12-12 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
2007169 | 2007169 | 2021-12-12 | Unknown | Northern Mariana Islands | 1513 | 3 | |
2003916 | 2003916 | 2021-12-11 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
2000665 | 2000665 | 2021-12-10 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1997415 | 1997415 | 2021-12-09 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1994164 | 1994164 | 2021-12-08 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1990913 | 1990913 | 2021-12-07 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1987662 | 1987662 | 2021-12-06 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1984412 | 1984412 | 2021-12-05 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1981162 | 1981162 | 2021-12-04 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1977912 | 1977912 | 2021-12-03 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1974662 | 1974662 | 2021-12-02 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1971413 | 1971413 | 2021-12-01 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1968163 | 1968163 | 2021-11-30 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1964912 | 1964912 | 2021-11-29 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1961660 | 1961660 | 2021-11-28 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1958409 | 1958409 | 2021-11-27 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1955158 | 1955158 | 2021-11-26 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1951907 | 1951907 | 2021-11-25 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1948656 | 1948656 | 2021-11-24 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1945405 | 1945405 | 2021-11-23 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1942154 | 1942154 | 2021-11-22 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1938904 | 1938904 | 2021-11-21 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1935654 | 1935654 | 2021-11-20 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1932404 | 1932404 | 2021-11-19 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1929153 | 1929153 | 2021-11-18 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1925903 | 1925903 | 2021-11-17 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1922654 | 1922654 | 2021-11-16 | Saipan | Northern Mariana Islands | 69110 | 389 | 3 |
1919404 | 1919404 | 2021-11-15 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1916154 | 1916154 | 2021-11-14 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1912904 | 1912904 | 2021-11-13 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1909654 | 1909654 | 2021-11-12 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1906405 | 1906405 | 2021-11-11 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1903156 | 1903156 | 2021-11-10 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1899906 | 1899906 | 2021-11-09 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1896656 | 1896656 | 2021-11-08 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1893406 | 1893406 | 2021-11-07 | Saipan | Northern Mariana Islands | 69110 | 336 | 3 |
1890156 | 1890156 | 2021-11-06 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1886906 | 1886906 | 2021-11-05 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1883657 | 1883657 | 2021-11-04 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1880408 | 1880408 | 2021-11-03 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1877159 | 1877159 | 2021-11-02 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1873910 | 1873910 | 2021-11-01 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1870661 | 1870661 | 2021-10-31 | Saipan | Northern Mariana Islands | 69110 | 306 | 3 |
1867412 | 1867412 | 2021-10-30 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1864163 | 1864163 | 2021-10-29 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1860914 | 1860914 | 2021-10-28 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1857665 | 1857665 | 2021-10-27 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1854416 | 1854416 | 2021-10-26 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1851167 | 1851167 | 2021-10-25 | Saipan | Northern Mariana Islands | 69110 | 285 | 3 |
1847917 | 1847917 | 2021-10-24 | Saipan | Northern Mariana Islands | 69110 | 284 | 3 |
1844667 | 1844667 | 2021-10-23 | Saipan | Northern Mariana Islands | 69110 | 284 | 3 |
1841417 | 1841417 | 2021-10-22 | Saipan | Northern Mariana Islands | 69110 | 284 | 3 |
1838168 | 1838168 | 2021-10-21 | Saipan | Northern Mariana Islands | 69110 | 283 | 3 |
1834919 | 1834919 | 2021-10-20 | Saipan | Northern Mariana Islands | 69110 | 283 | 3 |
1831670 | 1831670 | 2021-10-19 | Saipan | Northern Mariana Islands | 69110 | 283 | 3 |
1828421 | 1828421 | 2021-10-18 | Saipan | Northern Mariana Islands | 69110 | 283 | 3 |
1825172 | 1825172 | 2021-10-17 | Saipan | Northern Mariana Islands | 69110 | 276 | 3 |
1821923 | 1821923 | 2021-10-16 | Saipan | Northern Mariana Islands | 69110 | 276 | 3 |
1818674 | 1818674 | 2021-10-15 | Saipan | Northern Mariana Islands | 69110 | 276 | 3 |
1815425 | 1815425 | 2021-10-14 | Saipan | Northern Mariana Islands | 69110 | 276 | 3 |
1812177 | 1812177 | 2021-10-13 | Saipan | Northern Mariana Islands | 69110 | 276 | 3 |
1808928 | 1808928 | 2021-10-12 | Saipan | Northern Mariana Islands | 69110 | 275 | 3 |
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);