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 |
---|---|---|---|---|---|---|---|
1840906 | 1840906 | 2021-10-22 | Joplin | Missouri | 8681 | 150 | |
1840907 | 1840907 | 2021-10-22 | Kansas City | Missouri | 62985 | 817 | |
1837657 | 1837657 | 2021-10-21 | Joplin | Missouri | 8675 | 150 | |
1837658 | 1837658 | 2021-10-21 | Kansas City | Missouri | 62898 | 817 | |
1834408 | 1834408 | 2021-10-20 | Joplin | Missouri | 8661 | 150 | |
1834409 | 1834409 | 2021-10-20 | Kansas City | Missouri | 62827 | 817 | |
1831159 | 1831159 | 2021-10-19 | Joplin | Missouri | 8654 | 150 | |
1831160 | 1831160 | 2021-10-19 | Kansas City | Missouri | 62725 | 817 | |
1827910 | 1827910 | 2021-10-18 | Joplin | Missouri | 8645 | 150 | |
1827911 | 1827911 | 2021-10-18 | Kansas City | Missouri | 62669 | 814 | |
1824661 | 1824661 | 2021-10-17 | Joplin | Missouri | 8644 | 150 | |
1824662 | 1824662 | 2021-10-17 | Kansas City | Missouri | 62633 | 814 | |
1821412 | 1821412 | 2021-10-16 | Joplin | Missouri | 8642 | 150 | |
1821413 | 1821413 | 2021-10-16 | Kansas City | Missouri | 62570 | 814 | |
1818163 | 1818163 | 2021-10-15 | Joplin | Missouri | 8634 | 150 | |
1818164 | 1818164 | 2021-10-15 | Kansas City | Missouri | 62491 | 814 | |
1814914 | 1814914 | 2021-10-14 | Joplin | Missouri | 8628 | 151 | |
1814915 | 1814915 | 2021-10-14 | Kansas City | Missouri | 62408 | 812 | |
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 |
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);