ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
522 rows where deaths = 14 and state = "North Dakota" 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 |
---|---|---|---|---|---|---|---|
2016898 | 2016898 | 2021-12-15 | Pembina | North Dakota | 38067 | 1456 | 14 |
2016902 | 2016902 | 2021-12-15 | Renville | North Dakota | 38075 | 445 | 14 |
2013648 | 2013648 | 2021-12-14 | Pembina | North Dakota | 38067 | 1455 | 14 |
2013652 | 2013652 | 2021-12-14 | Renville | North Dakota | 38075 | 445 | 14 |
2010397 | 2010397 | 2021-12-13 | Pembina | North Dakota | 38067 | 1449 | 14 |
2010401 | 2010401 | 2021-12-13 | Renville | North Dakota | 38075 | 445 | 14 |
2007146 | 2007146 | 2021-12-12 | Pembina | North Dakota | 38067 | 1449 | 14 |
2007150 | 2007150 | 2021-12-12 | Renville | North Dakota | 38075 | 445 | 14 |
2003895 | 2003895 | 2021-12-11 | Pembina | North Dakota | 38067 | 1444 | 14 |
2003899 | 2003899 | 2021-12-11 | Renville | North Dakota | 38075 | 445 | 14 |
2000644 | 2000644 | 2021-12-10 | Pembina | North Dakota | 38067 | 1438 | 14 |
2000648 | 2000648 | 2021-12-10 | Renville | North Dakota | 38075 | 444 | 14 |
1997394 | 1997394 | 2021-12-09 | Pembina | North Dakota | 38067 | 1435 | 14 |
1997398 | 1997398 | 2021-12-09 | Renville | North Dakota | 38075 | 442 | 14 |
1994143 | 1994143 | 2021-12-08 | Pembina | North Dakota | 38067 | 1428 | 14 |
1994147 | 1994147 | 2021-12-08 | Renville | North Dakota | 38075 | 441 | 14 |
1990892 | 1990892 | 2021-12-07 | Pembina | North Dakota | 38067 | 1426 | 14 |
1990896 | 1990896 | 2021-12-07 | Renville | North Dakota | 38075 | 441 | 14 |
1987641 | 1987641 | 2021-12-06 | Pembina | North Dakota | 38067 | 1417 | 14 |
1987645 | 1987645 | 2021-12-06 | Renville | North Dakota | 38075 | 441 | 14 |
1984391 | 1984391 | 2021-12-05 | Pembina | North Dakota | 38067 | 1415 | 14 |
1984395 | 1984395 | 2021-12-05 | Renville | North Dakota | 38075 | 441 | 14 |
1981141 | 1981141 | 2021-12-04 | Pembina | North Dakota | 38067 | 1414 | 14 |
1981145 | 1981145 | 2021-12-04 | Renville | North Dakota | 38075 | 441 | 14 |
1977891 | 1977891 | 2021-12-03 | Pembina | North Dakota | 38067 | 1410 | 14 |
1977895 | 1977895 | 2021-12-03 | Renville | North Dakota | 38075 | 439 | 14 |
1974641 | 1974641 | 2021-12-02 | Pembina | North Dakota | 38067 | 1404 | 14 |
1974645 | 1974645 | 2021-12-02 | Renville | North Dakota | 38075 | 439 | 14 |
1971392 | 1971392 | 2021-12-01 | Pembina | North Dakota | 38067 | 1398 | 14 |
1971396 | 1971396 | 2021-12-01 | Renville | North Dakota | 38075 | 440 | 14 |
1968142 | 1968142 | 2021-11-30 | Pembina | North Dakota | 38067 | 1392 | 14 |
1968146 | 1968146 | 2021-11-30 | Renville | North Dakota | 38075 | 440 | 14 |
1964891 | 1964891 | 2021-11-29 | Pembina | North Dakota | 38067 | 1385 | 14 |
1964895 | 1964895 | 2021-11-29 | Renville | North Dakota | 38075 | 440 | 14 |
1961639 | 1961639 | 2021-11-28 | Pembina | North Dakota | 38067 | 1385 | 14 |
1961643 | 1961643 | 2021-11-28 | Renville | North Dakota | 38075 | 440 | 14 |
1958388 | 1958388 | 2021-11-27 | Pembina | North Dakota | 38067 | 1383 | 14 |
1958392 | 1958392 | 2021-11-27 | Renville | North Dakota | 38075 | 440 | 14 |
1955137 | 1955137 | 2021-11-26 | Pembina | North Dakota | 38067 | 1378 | 14 |
1955141 | 1955141 | 2021-11-26 | Renville | North Dakota | 38075 | 439 | 14 |
1951886 | 1951886 | 2021-11-25 | Pembina | North Dakota | 38067 | 1374 | 14 |
1951890 | 1951890 | 2021-11-25 | Renville | North Dakota | 38075 | 439 | 14 |
1948635 | 1948635 | 2021-11-24 | Pembina | North Dakota | 38067 | 1364 | 14 |
1948639 | 1948639 | 2021-11-24 | Renville | North Dakota | 38075 | 435 | 14 |
1945384 | 1945384 | 2021-11-23 | Pembina | North Dakota | 38067 | 1363 | 14 |
1945388 | 1945388 | 2021-11-23 | Renville | North Dakota | 38075 | 433 | 14 |
1942137 | 1942137 | 2021-11-22 | Renville | North Dakota | 38075 | 433 | 14 |
1938887 | 1938887 | 2021-11-21 | Renville | North Dakota | 38075 | 431 | 14 |
1935637 | 1935637 | 2021-11-20 | Renville | North Dakota | 38075 | 430 | 14 |
1932387 | 1932387 | 2021-11-19 | Renville | North Dakota | 38075 | 423 | 14 |
1929136 | 1929136 | 2021-11-18 | Renville | North Dakota | 38075 | 423 | 14 |
1925886 | 1925886 | 2021-11-17 | Renville | North Dakota | 38075 | 422 | 14 |
1922637 | 1922637 | 2021-11-16 | Renville | North Dakota | 38075 | 420 | 14 |
1919387 | 1919387 | 2021-11-15 | Renville | North Dakota | 38075 | 420 | 14 |
1916137 | 1916137 | 2021-11-14 | Renville | North Dakota | 38075 | 420 | 14 |
1912887 | 1912887 | 2021-11-13 | Renville | North Dakota | 38075 | 419 | 14 |
1909637 | 1909637 | 2021-11-12 | Renville | North Dakota | 38075 | 418 | 14 |
1906388 | 1906388 | 2021-11-11 | Renville | North Dakota | 38075 | 416 | 14 |
1903139 | 1903139 | 2021-11-10 | Renville | North Dakota | 38075 | 416 | 14 |
1899889 | 1899889 | 2021-11-09 | Renville | North Dakota | 38075 | 413 | 14 |
1896639 | 1896639 | 2021-11-08 | Renville | North Dakota | 38075 | 410 | 14 |
1893389 | 1893389 | 2021-11-07 | Renville | North Dakota | 38075 | 408 | 14 |
1890139 | 1890139 | 2021-11-06 | Renville | North Dakota | 38075 | 406 | 14 |
1886889 | 1886889 | 2021-11-05 | Renville | North Dakota | 38075 | 405 | 14 |
1883640 | 1883640 | 2021-11-04 | Renville | North Dakota | 38075 | 405 | 14 |
1880391 | 1880391 | 2021-11-03 | Renville | North Dakota | 38075 | 403 | 14 |
1877142 | 1877142 | 2021-11-02 | Renville | North Dakota | 38075 | 397 | 14 |
1873893 | 1873893 | 2021-11-01 | Renville | North Dakota | 38075 | 396 | 14 |
1870644 | 1870644 | 2021-10-31 | Renville | North Dakota | 38075 | 394 | 14 |
1867395 | 1867395 | 2021-10-30 | Renville | North Dakota | 38075 | 392 | 14 |
1864137 | 1864137 | 2021-10-29 | Mercer | North Dakota | 38057 | 1742 | 14 |
1864146 | 1864146 | 2021-10-29 | Renville | North Dakota | 38075 | 391 | 14 |
1860897 | 1860897 | 2021-10-28 | Renville | North Dakota | 38075 | 387 | 14 |
1857648 | 1857648 | 2021-10-27 | Renville | North Dakota | 38075 | 386 | 14 |
1854399 | 1854399 | 2021-10-26 | Renville | North Dakota | 38075 | 383 | 14 |
1851150 | 1851150 | 2021-10-25 | Renville | North Dakota | 38075 | 381 | 14 |
1847900 | 1847900 | 2021-10-24 | Renville | North Dakota | 38075 | 380 | 14 |
1844650 | 1844650 | 2021-10-23 | Renville | North Dakota | 38075 | 379 | 14 |
1841400 | 1841400 | 2021-10-22 | Renville | North Dakota | 38075 | 378 | 14 |
1838151 | 1838151 | 2021-10-21 | Renville | North Dakota | 38075 | 377 | 14 |
1834902 | 1834902 | 2021-10-20 | Renville | North Dakota | 38075 | 376 | 14 |
1831653 | 1831653 | 2021-10-19 | Renville | North Dakota | 38075 | 373 | 14 |
1828404 | 1828404 | 2021-10-18 | Renville | North Dakota | 38075 | 373 | 14 |
1825155 | 1825155 | 2021-10-17 | Renville | North Dakota | 38075 | 368 | 14 |
1821906 | 1821906 | 2021-10-16 | Renville | North Dakota | 38075 | 367 | 14 |
1818657 | 1818657 | 2021-10-15 | Renville | North Dakota | 38075 | 364 | 14 |
1815408 | 1815408 | 2021-10-14 | Renville | North Dakota | 38075 | 362 | 14 |
1812160 | 1812160 | 2021-10-13 | Renville | North Dakota | 38075 | 362 | 14 |
1808888 | 1808888 | 2021-10-12 | Emmons | North Dakota | 38029 | 531 | 14 |
1808911 | 1808911 | 2021-10-12 | Renville | North Dakota | 38075 | 358 | 14 |
1808916 | 1808916 | 2021-10-12 | Sioux | North Dakota | 38085 | 841 | 14 |
1805637 | 1805637 | 2021-10-11 | Emmons | North Dakota | 38029 | 531 | 14 |
1805660 | 1805660 | 2021-10-11 | Renville | North Dakota | 38075 | 357 | 14 |
1805665 | 1805665 | 2021-10-11 | Sioux | North Dakota | 38085 | 837 | 14 |
1802388 | 1802388 | 2021-10-10 | Emmons | North Dakota | 38029 | 531 | 14 |
1802411 | 1802411 | 2021-10-10 | Renville | North Dakota | 38075 | 357 | 14 |
1802416 | 1802416 | 2021-10-10 | Sioux | North Dakota | 38085 | 835 | 14 |
1799139 | 1799139 | 2021-10-09 | Emmons | North Dakota | 38029 | 531 | 14 |
1799162 | 1799162 | 2021-10-09 | Renville | North Dakota | 38075 | 357 | 14 |
1799167 | 1799167 | 2021-10-09 | Sioux | North Dakota | 38085 | 834 | 14 |
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);