ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29201 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717486 | 1717486 | 2021-09-14 | Scott | Missouri | 29201 | 6437 | 99 |
1714238 | 1714238 | 2021-09-13 | Scott | Missouri | 29201 | 6413 | 95 |
1710992 | 1710992 | 2021-09-12 | Scott | Missouri | 29201 | 6391 | 95 |
1707745 | 1707745 | 2021-09-11 | Scott | Missouri | 29201 | 6376 | 95 |
1704498 | 1704498 | 2021-09-10 | Scott | Missouri | 29201 | 6297 | 95 |
1701248 | 1701248 | 2021-09-09 | Scott | Missouri | 29201 | 6219 | 94 |
1697999 | 1697999 | 2021-09-08 | Scott | Missouri | 29201 | 6187 | 94 |
1694751 | 1694751 | 2021-09-07 | Scott | Missouri | 29201 | 6136 | 94 |
1691502 | 1691502 | 2021-09-06 | Scott | Missouri | 29201 | 6131 | 94 |
1688252 | 1688252 | 2021-09-05 | Scott | Missouri | 29201 | 6104 | 94 |
1685002 | 1685002 | 2021-09-04 | Scott | Missouri | 29201 | 6098 | 94 |
1681751 | 1681751 | 2021-09-03 | Scott | Missouri | 29201 | 6024 | 94 |
1678503 | 1678503 | 2021-09-02 | Scott | Missouri | 29201 | 5984 | 94 |
1675255 | 1675255 | 2021-09-01 | Scott | Missouri | 29201 | 5925 | 94 |
1672007 | 1672007 | 2021-08-31 | Scott | Missouri | 29201 | 5841 | 94 |
1668760 | 1668760 | 2021-08-30 | Scott | Missouri | 29201 | 5814 | 92 |
1665513 | 1665513 | 2021-08-29 | Scott | Missouri | 29201 | 5806 | 92 |
1662265 | 1662265 | 2021-08-28 | Scott | Missouri | 29201 | 5800 | 92 |
1659017 | 1659017 | 2021-08-27 | Scott | Missouri | 29201 | 5746 | 90 |
1655768 | 1655768 | 2021-08-26 | Scott | Missouri | 29201 | 5681 | 90 |
1652521 | 1652521 | 2021-08-25 | Scott | Missouri | 29201 | 5605 | 90 |
1649273 | 1649273 | 2021-08-24 | Scott | Missouri | 29201 | 5551 | 90 |
1646024 | 1646024 | 2021-08-23 | Scott | Missouri | 29201 | 5505 | 90 |
1642775 | 1642775 | 2021-08-22 | Scott | Missouri | 29201 | 5494 | 90 |
1639525 | 1639525 | 2021-08-21 | Scott | Missouri | 29201 | 5471 | 90 |
1636275 | 1636275 | 2021-08-20 | Scott | Missouri | 29201 | 5427 | 90 |
1633025 | 1633025 | 2021-08-19 | Scott | Missouri | 29201 | 5398 | 90 |
1629778 | 1629778 | 2021-08-18 | Scott | Missouri | 29201 | 5354 | 90 |
1626531 | 1626531 | 2021-08-17 | Scott | Missouri | 29201 | 5301 | 90 |
1623284 | 1623284 | 2021-08-16 | Scott | Missouri | 29201 | 5274 | 90 |
1620037 | 1620037 | 2021-08-15 | Scott | Missouri | 29201 | 5270 | 90 |
1616789 | 1616789 | 2021-08-14 | Scott | Missouri | 29201 | 5262 | 90 |
1613541 | 1613541 | 2021-08-13 | Scott | Missouri | 29201 | 5227 | 90 |
1610292 | 1610292 | 2021-08-12 | Scott | Missouri | 29201 | 5194 | 90 |
1607044 | 1607044 | 2021-08-11 | Scott | Missouri | 29201 | 5157 | 89 |
1603795 | 1603795 | 2021-08-10 | Scott | Missouri | 29201 | 5113 | 89 |
1600546 | 1600546 | 2021-08-09 | Scott | Missouri | 29201 | 5099 | 89 |
1597298 | 1597298 | 2021-08-08 | Scott | Missouri | 29201 | 5090 | 89 |
1594049 | 1594049 | 2021-08-07 | Scott | Missouri | 29201 | 5052 | 89 |
1590800 | 1590800 | 2021-08-06 | Scott | Missouri | 29201 | 5034 | 89 |
1587551 | 1587551 | 2021-08-05 | Scott | Missouri | 29201 | 5015 | 89 |
1584300 | 1584300 | 2021-08-04 | Scott | Missouri | 29201 | 4998 | 89 |
1581051 | 1581051 | 2021-08-03 | Scott | Missouri | 29201 | 4972 | 88 |
1577802 | 1577802 | 2021-08-02 | Scott | Missouri | 29201 | 4953 | 88 |
1574554 | 1574554 | 2021-08-01 | Scott | Missouri | 29201 | 4950 | 88 |
1571306 | 1571306 | 2021-07-31 | Scott | Missouri | 29201 | 4940 | 88 |
1568058 | 1568058 | 2021-07-30 | Scott | Missouri | 29201 | 4918 | 88 |
1564810 | 1564810 | 2021-07-29 | Scott | Missouri | 29201 | 4896 | 88 |
1561562 | 1561562 | 2021-07-28 | Scott | Missouri | 29201 | 4883 | 88 |
1558314 | 1558314 | 2021-07-27 | Scott | Missouri | 29201 | 4851 | 88 |
1555067 | 1555067 | 2021-07-26 | Scott | Missouri | 29201 | 4848 | 88 |
1551820 | 1551820 | 2021-07-25 | Scott | Missouri | 29201 | 4842 | 88 |
1548573 | 1548573 | 2021-07-24 | Scott | Missouri | 29201 | 4842 | 88 |
1545326 | 1545326 | 2021-07-23 | Scott | Missouri | 29201 | 4834 | 88 |
1542078 | 1542078 | 2021-07-22 | Scott | Missouri | 29201 | 4824 | 88 |
1538831 | 1538831 | 2021-07-21 | Scott | Missouri | 29201 | 4812 | 88 |
1535584 | 1535584 | 2021-07-20 | Scott | Missouri | 29201 | 4803 | 88 |
1532336 | 1532336 | 2021-07-19 | Scott | Missouri | 29201 | 4794 | 88 |
1529089 | 1529089 | 2021-07-18 | Scott | Missouri | 29201 | 4793 | 88 |
1525842 | 1525842 | 2021-07-17 | Scott | Missouri | 29201 | 4787 | 88 |
1522595 | 1522595 | 2021-07-16 | Scott | Missouri | 29201 | 4777 | 88 |
1519346 | 1519346 | 2021-07-15 | Scott | Missouri | 29201 | 4777 | 88 |
1516099 | 1516099 | 2021-07-14 | Scott | Missouri | 29201 | 4772 | 88 |
1512853 | 1512853 | 2021-07-13 | Scott | Missouri | 29201 | 4770 | 88 |
1509606 | 1509606 | 2021-07-12 | Scott | Missouri | 29201 | 4767 | 88 |
1506360 | 1506360 | 2021-07-11 | Scott | Missouri | 29201 | 4767 | 88 |
1503114 | 1503114 | 2021-07-10 | Scott | Missouri | 29201 | 4766 | 88 |
1499868 | 1499868 | 2021-07-09 | Scott | Missouri | 29201 | 4764 | 88 |
1496622 | 1496622 | 2021-07-08 | Scott | Missouri | 29201 | 4761 | 88 |
1493375 | 1493375 | 2021-07-07 | Scott | Missouri | 29201 | 4761 | 88 |
1490128 | 1490128 | 2021-07-06 | Scott | Missouri | 29201 | 4761 | 87 |
1486881 | 1486881 | 2021-07-05 | Scott | Missouri | 29201 | 4760 | 87 |
1483635 | 1483635 | 2021-07-04 | Scott | Missouri | 29201 | 4759 | 87 |
1480389 | 1480389 | 2021-07-03 | Scott | Missouri | 29201 | 4758 | 87 |
1477142 | 1477142 | 2021-07-02 | Scott | Missouri | 29201 | 4758 | 87 |
1473896 | 1473896 | 2021-07-01 | Scott | Missouri | 29201 | 4755 | 87 |
1470650 | 1470650 | 2021-06-30 | Scott | Missouri | 29201 | 4753 | 87 |
1467405 | 1467405 | 2021-06-29 | Scott | Missouri | 29201 | 4753 | 87 |
1464160 | 1464160 | 2021-06-28 | Scott | Missouri | 29201 | 4751 | 87 |
1460915 | 1460915 | 2021-06-27 | Scott | Missouri | 29201 | 4751 | 87 |
1457670 | 1457670 | 2021-06-26 | Scott | Missouri | 29201 | 4751 | 87 |
1454425 | 1454425 | 2021-06-25 | Scott | Missouri | 29201 | 4751 | 87 |
1451180 | 1451180 | 2021-06-24 | Scott | Missouri | 29201 | 4750 | 87 |
1447934 | 1447934 | 2021-06-23 | Scott | Missouri | 29201 | 4750 | 87 |
1444689 | 1444689 | 2021-06-22 | Scott | Missouri | 29201 | 4749 | 87 |
1441444 | 1441444 | 2021-06-21 | Scott | Missouri | 29201 | 4747 | 87 |
1438198 | 1438198 | 2021-06-20 | Scott | Missouri | 29201 | 4747 | 87 |
1434951 | 1434951 | 2021-06-19 | Scott | Missouri | 29201 | 4747 | 87 |
1431704 | 1431704 | 2021-06-18 | Scott | Missouri | 29201 | 4747 | 87 |
1428459 | 1428459 | 2021-06-17 | Scott | Missouri | 29201 | 4747 | 87 |
1425214 | 1425214 | 2021-06-16 | Scott | Missouri | 29201 | 4745 | 87 |
1421966 | 1421966 | 2021-06-15 | Scott | Missouri | 29201 | 4742 | 87 |
1418721 | 1418721 | 2021-06-14 | Scott | Missouri | 29201 | 4741 | 86 |
1415476 | 1415476 | 2021-06-13 | Scott | Missouri | 29201 | 4741 | 86 |
1412230 | 1412230 | 2021-06-12 | Scott | Missouri | 29201 | 4739 | 86 |
1408985 | 1408985 | 2021-06-11 | Scott | Missouri | 29201 | 4739 | 86 |
1405740 | 1405740 | 2021-06-10 | Scott | Missouri | 29201 | 4738 | 86 |
1402494 | 1402494 | 2021-06-09 | Scott | Missouri | 29201 | 4737 | 86 |
1399249 | 1399249 | 2021-06-08 | Scott | Missouri | 29201 | 4736 | 86 |
1396003 | 1396003 | 2021-06-07 | Scott | Missouri | 29201 | 4736 | 86 |
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);