ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

127 rows where county = "Sioux", deaths = 12 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases

state 1

  • North Dakota · 127 ✖

fips 1

county 1

  • Sioux · 127 ✖
Link rowid date ▲ county state fips cases deaths
1678957 1678957 2021-09-02 Sioux North Dakota 38085 699 12
1675709 1675709 2021-09-01 Sioux North Dakota 38085 698 12
1672462 1672462 2021-08-31 Sioux North Dakota 38085 697 12
1669214 1669214 2021-08-30 Sioux North Dakota 38085 695 12
1665967 1665967 2021-08-29 Sioux North Dakota 38085 694 12
1662719 1662719 2021-08-28 Sioux North Dakota 38085 687 12
1659471 1659471 2021-08-27 Sioux North Dakota 38085 684 12
1656222 1656222 2021-08-26 Sioux North Dakota 38085 682 12
1652975 1652975 2021-08-25 Sioux North Dakota 38085 685 12
1649727 1649727 2021-08-24 Sioux North Dakota 38085 686 12
1646478 1646478 2021-08-23 Sioux North Dakota 38085 687 12
1643229 1643229 2021-08-22 Sioux North Dakota 38085 687 12
1639979 1639979 2021-08-21 Sioux North Dakota 38085 687 12
1636729 1636729 2021-08-20 Sioux North Dakota 38085 687 12
1633479 1633479 2021-08-19 Sioux North Dakota 38085 684 12
1630232 1630232 2021-08-18 Sioux North Dakota 38085 680 12
1626985 1626985 2021-08-17 Sioux North Dakota 38085 679 12
1623738 1623738 2021-08-16 Sioux North Dakota 38085 676 12
1620491 1620491 2021-08-15 Sioux North Dakota 38085 675 12
1617243 1617243 2021-08-14 Sioux North Dakota 38085 675 12
1613995 1613995 2021-08-13 Sioux North Dakota 38085 674 12
1610746 1610746 2021-08-12 Sioux North Dakota 38085 673 12
1607498 1607498 2021-08-11 Sioux North Dakota 38085 673 12
1604249 1604249 2021-08-10 Sioux North Dakota 38085 671 12
1601000 1601000 2021-08-09 Sioux North Dakota 38085 670 12
1597752 1597752 2021-08-08 Sioux North Dakota 38085 670 12
1594503 1594503 2021-08-07 Sioux North Dakota 38085 670 12
1591254 1591254 2021-08-06 Sioux North Dakota 38085 668 12
1588005 1588005 2021-08-05 Sioux North Dakota 38085 668 12
1584755 1584755 2021-08-04 Sioux North Dakota 38085 668 12
1581505 1581505 2021-08-03 Sioux North Dakota 38085 666 12
1578256 1578256 2021-08-02 Sioux North Dakota 38085 666 12
1575008 1575008 2021-08-01 Sioux North Dakota 38085 666 12
1571760 1571760 2021-07-31 Sioux North Dakota 38085 666 12
1568512 1568512 2021-07-30 Sioux North Dakota 38085 666 12
1565264 1565264 2021-07-29 Sioux North Dakota 38085 666 12
1562016 1562016 2021-07-28 Sioux North Dakota 38085 666 12
1558768 1558768 2021-07-27 Sioux North Dakota 38085 666 12
1555521 1555521 2021-07-26 Sioux North Dakota 38085 666 12
1552274 1552274 2021-07-25 Sioux North Dakota 38085 665 12
1549027 1549027 2021-07-24 Sioux North Dakota 38085 665 12
1545780 1545780 2021-07-23 Sioux North Dakota 38085 665 12
1542533 1542533 2021-07-22 Sioux North Dakota 38085 665 12
1539285 1539285 2021-07-21 Sioux North Dakota 38085 665 12
1536038 1536038 2021-07-20 Sioux North Dakota 38085 665 12
1532790 1532790 2021-07-19 Sioux North Dakota 38085 665 12
1529543 1529543 2021-07-18 Sioux North Dakota 38085 665 12
1526296 1526296 2021-07-17 Sioux North Dakota 38085 665 12
1523049 1523049 2021-07-16 Sioux North Dakota 38085 665 12
1519801 1519801 2021-07-15 Sioux North Dakota 38085 665 12
1516553 1516553 2021-07-14 Sioux North Dakota 38085 665 12
1513306 1513306 2021-07-13 Sioux North Dakota 38085 665 12
1510060 1510060 2021-07-12 Sioux North Dakota 38085 665 12
1506813 1506813 2021-07-11 Sioux North Dakota 38085 665 12
1503567 1503567 2021-07-10 Sioux North Dakota 38085 665 12
1500321 1500321 2021-07-09 Sioux North Dakota 38085 665 12
1497075 1497075 2021-07-08 Sioux North Dakota 38085 665 12
1493828 1493828 2021-07-07 Sioux North Dakota 38085 665 12
1490581 1490581 2021-07-06 Sioux North Dakota 38085 665 12
1487334 1487334 2021-07-05 Sioux North Dakota 38085 665 12
1484088 1484088 2021-07-04 Sioux North Dakota 38085 665 12
1480842 1480842 2021-07-03 Sioux North Dakota 38085 665 12
1477595 1477595 2021-07-02 Sioux North Dakota 38085 665 12
1474349 1474349 2021-07-01 Sioux North Dakota 38085 665 12
1471103 1471103 2021-06-30 Sioux North Dakota 38085 665 12
1467858 1467858 2021-06-29 Sioux North Dakota 38085 665 12
1464613 1464613 2021-06-28 Sioux North Dakota 38085 665 12
1461368 1461368 2021-06-27 Sioux North Dakota 38085 665 12
1458123 1458123 2021-06-26 Sioux North Dakota 38085 665 12
1454878 1454878 2021-06-25 Sioux North Dakota 38085 665 12
1451633 1451633 2021-06-24 Sioux North Dakota 38085 665 12
1448387 1448387 2021-06-23 Sioux North Dakota 38085 664 12
1445142 1445142 2021-06-22 Sioux North Dakota 38085 664 12
1441897 1441897 2021-06-21 Sioux North Dakota 38085 665 12
1438652 1438652 2021-06-20 Sioux North Dakota 38085 665 12
1435405 1435405 2021-06-19 Sioux North Dakota 38085 665 12
1432158 1432158 2021-06-18 Sioux North Dakota 38085 665 12
1428912 1428912 2021-06-17 Sioux North Dakota 38085 665 12
1425667 1425667 2021-06-16 Sioux North Dakota 38085 665 12
1422420 1422420 2021-06-15 Sioux North Dakota 38085 664 12
1419174 1419174 2021-06-14 Sioux North Dakota 38085 664 12
1415929 1415929 2021-06-13 Sioux North Dakota 38085 664 12
1412683 1412683 2021-06-12 Sioux North Dakota 38085 664 12
1409438 1409438 2021-06-11 Sioux North Dakota 38085 663 12
1406193 1406193 2021-06-10 Sioux North Dakota 38085 663 12
1402947 1402947 2021-06-09 Sioux North Dakota 38085 663 12
1399702 1399702 2021-06-08 Sioux North Dakota 38085 663 12
1396457 1396457 2021-06-07 Sioux North Dakota 38085 663 12
1393210 1393210 2021-06-06 Sioux North Dakota 38085 663 12
1389965 1389965 2021-06-05 Sioux North Dakota 38085 663 12
1386720 1386720 2021-06-04 Sioux North Dakota 38085 663 12
1383475 1383475 2021-06-03 Sioux North Dakota 38085 663 12
1380229 1380229 2021-06-02 Sioux North Dakota 38085 663 12
1376984 1376984 2021-06-01 Sioux North Dakota 38085 663 12
1373738 1373738 2021-05-31 Sioux North Dakota 38085 663 12
1370493 1370493 2021-05-30 Sioux North Dakota 38085 663 12
1367247 1367247 2021-05-29 Sioux North Dakota 38085 663 12
1364001 1364001 2021-05-28 Sioux North Dakota 38085 664 12
1360755 1360755 2021-05-27 Sioux North Dakota 38085 664 12
1357509 1357509 2021-05-26 Sioux North Dakota 38085 664 12

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);