ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,511 rows where fips = "" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811666 | 1811666 | 2021-10-13 | Joplin | Missouri | 8626 | 151 | |
1811667 | 1811667 | 2021-10-13 | Kansas City | Missouri | 62328 | 810 | |
1808417 | 1808417 | 2021-10-12 | Joplin | Missouri | 8605 | 149 | |
1808418 | 1808418 | 2021-10-12 | Kansas City | Missouri | 62237 | 803 | |
1805166 | 1805166 | 2021-10-11 | Joplin | Missouri | 8606 | 149 | |
1805167 | 1805167 | 2021-10-11 | Kansas City | Missouri | 62188 | 803 | |
1801917 | 1801917 | 2021-10-10 | Joplin | Missouri | 8599 | 149 | |
1801918 | 1801918 | 2021-10-10 | Kansas City | Missouri | 62122 | 803 | |
1798668 | 1798668 | 2021-10-09 | Joplin | Missouri | 8594 | 149 | |
1798669 | 1798669 | 2021-10-09 | Kansas City | Missouri | 62048 | 803 | |
1795419 | 1795419 | 2021-10-08 | Joplin | Missouri | 8581 | 149 | |
1795420 | 1795420 | 2021-10-08 | Kansas City | Missouri | 61971 | 802 | |
1792170 | 1792170 | 2021-10-07 | Joplin | Missouri | 8573 | 149 | |
1792171 | 1792171 | 2021-10-07 | Kansas City | Missouri | 61853 | 804 | |
1788921 | 1788921 | 2021-10-06 | Joplin | Missouri | 8571 | 149 | |
1788922 | 1788922 | 2021-10-06 | Kansas City | Missouri | 61744 | 803 | |
1785673 | 1785673 | 2021-10-05 | Joplin | Missouri | 8565 | 149 | |
1785674 | 1785674 | 2021-10-05 | Kansas City | Missouri | 61621 | 801 | |
1782424 | 1782424 | 2021-10-04 | Joplin | Missouri | 8551 | 148 | |
1782425 | 1782425 | 2021-10-04 | Kansas City | Missouri | 61575 | 792 | |
1779174 | 1779174 | 2021-10-03 | Joplin | Missouri | 8543 | 148 | |
1779175 | 1779175 | 2021-10-03 | Kansas City | Missouri | 61508 | 792 | |
1775924 | 1775924 | 2021-10-02 | Joplin | Missouri | 8540 | 148 | |
1775925 | 1775925 | 2021-10-02 | Kansas City | Missouri | 61384 | 791 | |
1772674 | 1772674 | 2021-10-01 | Joplin | Missouri | 8530 | 148 | |
1772675 | 1772675 | 2021-10-01 | Kansas City | Missouri | 61253 | 791 | |
1769425 | 1769425 | 2021-09-30 | Joplin | Missouri | 8523 | 148 | |
1769426 | 1769426 | 2021-09-30 | Kansas City | Missouri | 61247 | 788 | |
1766176 | 1766176 | 2021-09-29 | Joplin | Missouri | 8518 | 148 | |
1766177 | 1766177 | 2021-09-29 | Kansas City | Missouri | 61122 | 787 | |
1762927 | 1762927 | 2021-09-28 | Joplin | Missouri | 8510 | 147 | |
1762928 | 1762928 | 2021-09-28 | Kansas City | Missouri | 60962 | 785 | |
1759678 | 1759678 | 2021-09-27 | Joplin | Missouri | 8506 | 147 | |
1759679 | 1759679 | 2021-09-27 | Kansas City | Missouri | 60887 | 779 | |
1756430 | 1756430 | 2021-09-26 | Joplin | Missouri | 8502 | 147 | |
1756431 | 1756431 | 2021-09-26 | Kansas City | Missouri | 60810 | 779 | |
1753182 | 1753182 | 2021-09-25 | Joplin | Missouri | 8497 | 147 | |
1753183 | 1753183 | 2021-09-25 | Kansas City | Missouri | 60689 | 779 | |
1749934 | 1749934 | 2021-09-24 | Joplin | Missouri | 8493 | 146 | |
1749935 | 1749935 | 2021-09-24 | Kansas City | Missouri | 60515 | 777 | |
1746684 | 1746684 | 2021-09-23 | Joplin | Missouri | 8483 | 146 | |
1746685 | 1746685 | 2021-09-23 | Kansas City | Missouri | 60372 | 778 | |
1743435 | 1743435 | 2021-09-22 | Joplin | Missouri | 8471 | 146 | |
1743436 | 1743436 | 2021-09-22 | Kansas City | Missouri | 60224 | 769 | |
1740186 | 1740186 | 2021-09-21 | Joplin | Missouri | 8462 | 146 | |
1740187 | 1740187 | 2021-09-21 | Kansas City | Missouri | 60066 | 768 | |
1736937 | 1736937 | 2021-09-20 | Joplin | Missouri | 8456 | 144 | |
1736938 | 1736938 | 2021-09-20 | Kansas City | Missouri | 59943 | 754 | |
1733687 | 1733687 | 2021-09-19 | Joplin | Missouri | 8445 | 144 | |
1733688 | 1733688 | 2021-09-19 | Kansas City | Missouri | 59858 | 754 | |
1730437 | 1730437 | 2021-09-18 | Joplin | Missouri | 8437 | 144 | |
1730438 | 1730438 | 2021-09-18 | Kansas City | Missouri | 59709 | 754 | |
1727187 | 1727187 | 2021-09-17 | Joplin | Missouri | 8430 | 144 | |
1727188 | 1727188 | 2021-09-17 | Kansas City | Missouri | 59485 | 750 | |
1723938 | 1723938 | 2021-09-16 | Joplin | Missouri | 8414 | 141 | |
1723939 | 1723939 | 2021-09-16 | Kansas City | Missouri | 59294 | 746 | |
1720689 | 1720689 | 2021-09-15 | Joplin | Missouri | 8407 | 141 | |
1720690 | 1720690 | 2021-09-15 | Kansas City | Missouri | 59131 | 747 | |
1717441 | 1717441 | 2021-09-14 | Joplin | Missouri | 8392 | 141 | |
1717442 | 1717442 | 2021-09-14 | Kansas City | Missouri | 58965 | 742 | |
1714193 | 1714193 | 2021-09-13 | Joplin | Missouri | 8392 | 141 | |
1714194 | 1714194 | 2021-09-13 | Kansas City | Missouri | 58818 | 736 | |
1710947 | 1710947 | 2021-09-12 | Joplin | Missouri | 8381 | 141 | |
1710948 | 1710948 | 2021-09-12 | Kansas City | Missouri | 58694 | 736 | |
1707700 | 1707700 | 2021-09-11 | Joplin | Missouri | 8374 | 141 | |
1707701 | 1707701 | 2021-09-11 | Kansas City | Missouri | 58519 | 736 | |
1704453 | 1704453 | 2021-09-10 | Joplin | Missouri | 8358 | 141 | |
1704454 | 1704454 | 2021-09-10 | Kansas City | Missouri | 58307 | 734 | |
1701203 | 1701203 | 2021-09-09 | Joplin | Missouri | 8328 | 141 | |
1701204 | 1701204 | 2021-09-09 | Kansas City | Missouri | 58098 | 724 | |
1697954 | 1697954 | 2021-09-08 | Joplin | Missouri | 8303 | 141 | |
1697955 | 1697955 | 2021-09-08 | Kansas City | Missouri | 57956 | 716 | |
1694706 | 1694706 | 2021-09-07 | Joplin | Missouri | 8295 | 141 | |
1694707 | 1694707 | 2021-09-07 | Kansas City | Missouri | 57815 | 704 | |
1691457 | 1691457 | 2021-09-06 | Joplin | Missouri | 8284 | 141 | |
1691458 | 1691458 | 2021-09-06 | Kansas City | Missouri | 57715 | 704 | |
1688207 | 1688207 | 2021-09-05 | Joplin | Missouri | 8277 | 141 | |
1688208 | 1688208 | 2021-09-05 | Kansas City | Missouri | 57585 | 703 | |
1684957 | 1684957 | 2021-09-04 | Joplin | Missouri | 8269 | 141 | |
1684958 | 1684958 | 2021-09-04 | Kansas City | Missouri | 57461 | 703 | |
1681706 | 1681706 | 2021-09-03 | Joplin | Missouri | 8251 | 141 | |
1681707 | 1681707 | 2021-09-03 | Kansas City | Missouri | 57267 | 702 | |
1678458 | 1678458 | 2021-09-02 | Joplin | Missouri | 8233 | 141 | |
1678459 | 1678459 | 2021-09-02 | Kansas City | Missouri | 57050 | 699 | |
1675210 | 1675210 | 2021-09-01 | Joplin | Missouri | 8215 | 141 | |
1675211 | 1675211 | 2021-09-01 | Kansas City | Missouri | 56841 | 699 | |
1671962 | 1671962 | 2021-08-31 | Joplin | Missouri | 8200 | 141 | |
1671963 | 1671963 | 2021-08-31 | Kansas City | Missouri | 56645 | 697 | |
1668715 | 1668715 | 2021-08-30 | Joplin | Missouri | 8187 | 136 | |
1668716 | 1668716 | 2021-08-30 | Kansas City | Missouri | 56597 | 686 | |
1665468 | 1665468 | 2021-08-29 | Joplin | Missouri | 8176 | 136 | |
1665469 | 1665469 | 2021-08-29 | Kansas City | Missouri | 56345 | 686 | |
1662220 | 1662220 | 2021-08-28 | Joplin | Missouri | 8167 | 136 | |
1662221 | 1662221 | 2021-08-28 | Kansas City | Missouri | 56200 | 685 | |
1658972 | 1658972 | 2021-08-27 | Joplin | Missouri | 8153 | 136 | |
1658973 | 1658973 | 2021-08-27 | Kansas City | Missouri | 55998 | 681 | |
1655723 | 1655723 | 2021-08-26 | Joplin | Missouri | 8131 | 136 | |
1655724 | 1655724 | 2021-08-26 | Kansas City | Missouri | 55765 | 671 | |
1652476 | 1652476 | 2021-08-25 | Joplin | Missouri | 8110 | 136 | |
1652477 | 1652477 | 2021-08-25 | Kansas City | Missouri | 55497 | 670 |
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);