ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Brown" and state = "South Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718360 | 1718360 | 2021-09-14 | Brown | South Dakota | 46013 | 6025 | 95 |
1715112 | 1715112 | 2021-09-13 | Brown | South Dakota | 46013 | 5992 | 95 |
1711866 | 1711866 | 2021-09-12 | Brown | South Dakota | 46013 | 5964 | 95 |
1708619 | 1708619 | 2021-09-11 | Brown | South Dakota | 46013 | 5964 | 95 |
1705372 | 1705372 | 2021-09-10 | Brown | South Dakota | 46013 | 5964 | 95 |
1702122 | 1702122 | 2021-09-09 | Brown | South Dakota | 46013 | 5923 | 95 |
1698873 | 1698873 | 2021-09-08 | Brown | South Dakota | 46013 | 5897 | 95 |
1695625 | 1695625 | 2021-09-07 | Brown | South Dakota | 46013 | 5868 | 95 |
1692377 | 1692377 | 2021-09-06 | Brown | South Dakota | 46013 | 5853 | 95 |
1689128 | 1689128 | 2021-09-05 | Brown | South Dakota | 46013 | 5853 | 95 |
1685878 | 1685878 | 2021-09-04 | Brown | South Dakota | 46013 | 5853 | 95 |
1682627 | 1682627 | 2021-09-03 | Brown | South Dakota | 46013 | 5853 | 95 |
1679377 | 1679377 | 2021-09-02 | Brown | South Dakota | 46013 | 5842 | 95 |
1676129 | 1676129 | 2021-09-01 | Brown | South Dakota | 46013 | 5828 | 95 |
1672882 | 1672882 | 2021-08-31 | Brown | South Dakota | 46013 | 5801 | 95 |
1669634 | 1669634 | 2021-08-30 | Brown | South Dakota | 46013 | 5779 | 95 |
1666387 | 1666387 | 2021-08-29 | Brown | South Dakota | 46013 | 5762 | 95 |
1663139 | 1663139 | 2021-08-28 | Brown | South Dakota | 46013 | 5762 | 95 |
1659891 | 1659891 | 2021-08-27 | Brown | South Dakota | 46013 | 5762 | 95 |
1656642 | 1656642 | 2021-08-26 | Brown | South Dakota | 46013 | 5754 | 95 |
1653395 | 1653395 | 2021-08-25 | Brown | South Dakota | 46013 | 5741 | 95 |
1650148 | 1650148 | 2021-08-24 | Brown | South Dakota | 46013 | 5726 | 95 |
1646899 | 1646899 | 2021-08-23 | Brown | South Dakota | 46013 | 5716 | 95 |
1643650 | 1643650 | 2021-08-22 | Brown | South Dakota | 46013 | 5715 | 95 |
1640400 | 1640400 | 2021-08-21 | Brown | South Dakota | 46013 | 5715 | 95 |
1637150 | 1637150 | 2021-08-20 | Brown | South Dakota | 46013 | 5715 | 95 |
1633900 | 1633900 | 2021-08-19 | Brown | South Dakota | 46013 | 5710 | 95 |
1630653 | 1630653 | 2021-08-18 | Brown | South Dakota | 46013 | 5708 | 95 |
1627406 | 1627406 | 2021-08-17 | Brown | South Dakota | 46013 | 5705 | 95 |
1624159 | 1624159 | 2021-08-16 | Brown | South Dakota | 46013 | 5698 | 95 |
1620912 | 1620912 | 2021-08-15 | Brown | South Dakota | 46013 | 5694 | 95 |
1617664 | 1617664 | 2021-08-14 | Brown | South Dakota | 46013 | 5694 | 95 |
1614416 | 1614416 | 2021-08-13 | Brown | South Dakota | 46013 | 5694 | 95 |
1611167 | 1611167 | 2021-08-12 | Brown | South Dakota | 46013 | 5695 | 95 |
1607919 | 1607919 | 2021-08-11 | Brown | South Dakota | 46013 | 5691 | 95 |
1604670 | 1604670 | 2021-08-10 | Brown | South Dakota | 46013 | 5662 | 95 |
1601421 | 1601421 | 2021-08-09 | Brown | South Dakota | 46013 | 5662 | 95 |
1598173 | 1598173 | 2021-08-08 | Brown | South Dakota | 46013 | 5662 | 95 |
1594924 | 1594924 | 2021-08-07 | Brown | South Dakota | 46013 | 5662 | 95 |
1591675 | 1591675 | 2021-08-06 | Brown | South Dakota | 46013 | 5662 | 95 |
1588426 | 1588426 | 2021-08-05 | Brown | South Dakota | 46013 | 5662 | 95 |
1585176 | 1585176 | 2021-08-04 | Brown | South Dakota | 46013 | 5662 | 95 |
1581926 | 1581926 | 2021-08-03 | Brown | South Dakota | 46013 | 5653 | 95 |
1578677 | 1578677 | 2021-08-02 | Brown | South Dakota | 46013 | 5653 | 95 |
1575429 | 1575429 | 2021-08-01 | Brown | South Dakota | 46013 | 5653 | 95 |
1572181 | 1572181 | 2021-07-31 | Brown | South Dakota | 46013 | 5653 | 95 |
1568933 | 1568933 | 2021-07-30 | Brown | South Dakota | 46013 | 5653 | 95 |
1565685 | 1565685 | 2021-07-29 | Brown | South Dakota | 46013 | 5653 | 95 |
1562437 | 1562437 | 2021-07-28 | Brown | South Dakota | 46013 | 5653 | 95 |
1559189 | 1559189 | 2021-07-27 | Brown | South Dakota | 46013 | 5650 | 95 |
1555942 | 1555942 | 2021-07-26 | Brown | South Dakota | 46013 | 5650 | 95 |
1552695 | 1552695 | 2021-07-25 | Brown | South Dakota | 46013 | 5650 | 95 |
1549448 | 1549448 | 2021-07-24 | Brown | South Dakota | 46013 | 5650 | 95 |
1546201 | 1546201 | 2021-07-23 | Brown | South Dakota | 46013 | 5650 | 95 |
1542954 | 1542954 | 2021-07-22 | Brown | South Dakota | 46013 | 5650 | 95 |
1539706 | 1539706 | 2021-07-21 | Brown | South Dakota | 46013 | 5650 | 95 |
1536459 | 1536459 | 2021-07-20 | Brown | South Dakota | 46013 | 5647 | 95 |
1533211 | 1533211 | 2021-07-19 | Brown | South Dakota | 46013 | 5647 | 95 |
1529964 | 1529964 | 2021-07-18 | Brown | South Dakota | 46013 | 5647 | 95 |
1526717 | 1526717 | 2021-07-17 | Brown | South Dakota | 46013 | 5647 | 95 |
1523470 | 1523470 | 2021-07-16 | Brown | South Dakota | 46013 | 5647 | 95 |
1520222 | 1520222 | 2021-07-15 | Brown | South Dakota | 46013 | 5647 | 95 |
1516974 | 1516974 | 2021-07-14 | Brown | South Dakota | 46013 | 5647 | 95 |
1513727 | 1513727 | 2021-07-13 | Brown | South Dakota | 46013 | 5646 | 95 |
1510481 | 1510481 | 2021-07-12 | Brown | South Dakota | 46013 | 5646 | 95 |
1507234 | 1507234 | 2021-07-11 | Brown | South Dakota | 46013 | 5646 | 95 |
1503988 | 1503988 | 2021-07-10 | Brown | South Dakota | 46013 | 5646 | 95 |
1500742 | 1500742 | 2021-07-09 | Brown | South Dakota | 46013 | 5646 | 95 |
1497496 | 1497496 | 2021-07-08 | Brown | South Dakota | 46013 | 5646 | 95 |
1494249 | 1494249 | 2021-07-07 | Brown | South Dakota | 46013 | 5646 | 95 |
1491002 | 1491002 | 2021-07-06 | Brown | South Dakota | 46013 | 5645 | 95 |
1487755 | 1487755 | 2021-07-05 | Brown | South Dakota | 46013 | 5645 | 95 |
1484508 | 1484508 | 2021-07-04 | Brown | South Dakota | 46013 | 5645 | 95 |
1481262 | 1481262 | 2021-07-03 | Brown | South Dakota | 46013 | 5645 | 95 |
1478015 | 1478015 | 2021-07-02 | Brown | South Dakota | 46013 | 5645 | 95 |
1474769 | 1474769 | 2021-07-01 | Brown | South Dakota | 46013 | 5645 | 95 |
1471523 | 1471523 | 2021-06-30 | Brown | South Dakota | 46013 | 5644 | 95 |
1468278 | 1468278 | 2021-06-29 | Brown | South Dakota | 46013 | 5643 | 95 |
1465033 | 1465033 | 2021-06-28 | Brown | South Dakota | 46013 | 5642 | 95 |
1461788 | 1461788 | 2021-06-27 | Brown | South Dakota | 46013 | 5640 | 95 |
1458543 | 1458543 | 2021-06-26 | Brown | South Dakota | 46013 | 5640 | 95 |
1455298 | 1455298 | 2021-06-25 | Brown | South Dakota | 46013 | 5640 | 95 |
1452053 | 1452053 | 2021-06-24 | Brown | South Dakota | 46013 | 5640 | 95 |
1448807 | 1448807 | 2021-06-23 | Brown | South Dakota | 46013 | 5640 | 95 |
1445562 | 1445562 | 2021-06-22 | Brown | South Dakota | 46013 | 5640 | 95 |
1442317 | 1442317 | 2021-06-21 | Brown | South Dakota | 46013 | 5637 | 95 |
1439072 | 1439072 | 2021-06-20 | Brown | South Dakota | 46013 | 5635 | 95 |
1435825 | 1435825 | 2021-06-19 | Brown | South Dakota | 46013 | 5635 | 95 |
1432578 | 1432578 | 2021-06-18 | Brown | South Dakota | 46013 | 5635 | 95 |
1429332 | 1429332 | 2021-06-17 | Brown | South Dakota | 46013 | 5635 | 95 |
1426087 | 1426087 | 2021-06-16 | Brown | South Dakota | 46013 | 5635 | 95 |
1422840 | 1422840 | 2021-06-15 | Brown | South Dakota | 46013 | 5635 | 95 |
1419594 | 1419594 | 2021-06-14 | Brown | South Dakota | 46013 | 5635 | 95 |
1416349 | 1416349 | 2021-06-13 | Brown | South Dakota | 46013 | 5635 | 95 |
1413103 | 1413103 | 2021-06-12 | Brown | South Dakota | 46013 | 5635 | 95 |
1409858 | 1409858 | 2021-06-11 | Brown | South Dakota | 46013 | 5635 | 95 |
1406613 | 1406613 | 2021-06-10 | Brown | South Dakota | 46013 | 5635 | 95 |
1403367 | 1403367 | 2021-06-09 | Brown | South Dakota | 46013 | 5635 | 95 |
1400122 | 1400122 | 2021-06-08 | Brown | South Dakota | 46013 | 5635 | 95 |
1396877 | 1396877 | 2021-06-07 | Brown | South Dakota | 46013 | 5634 | 95 |
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);