ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 29186 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418729 | 1418729 | 2021-06-14 | Ste. Genevieve | Missouri | 29186 | 1837 | 17 |
1415484 | 1415484 | 2021-06-13 | Ste. Genevieve | Missouri | 29186 | 1837 | 17 |
1412238 | 1412238 | 2021-06-12 | Ste. Genevieve | Missouri | 29186 | 1837 | 17 |
1408993 | 1408993 | 2021-06-11 | Ste. Genevieve | Missouri | 29186 | 1837 | 17 |
1405748 | 1405748 | 2021-06-10 | Ste. Genevieve | Missouri | 29186 | 1832 | 17 |
1402502 | 1402502 | 2021-06-09 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1399257 | 1399257 | 2021-06-08 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1396011 | 1396011 | 2021-06-07 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1392765 | 1392765 | 2021-06-06 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1389520 | 1389520 | 2021-06-05 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1386275 | 1386275 | 2021-06-04 | Ste. Genevieve | Missouri | 29186 | 1829 | 17 |
1383030 | 1383030 | 2021-06-03 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1379784 | 1379784 | 2021-06-02 | Ste. Genevieve | Missouri | 29186 | 1832 | 17 |
1376539 | 1376539 | 2021-06-01 | Ste. Genevieve | Missouri | 29186 | 1832 | 17 |
1373293 | 1373293 | 2021-05-31 | Ste. Genevieve | Missouri | 29186 | 1832 | 17 |
1370048 | 1370048 | 2021-05-30 | Ste. Genevieve | Missouri | 29186 | 1831 | 17 |
1366802 | 1366802 | 2021-05-29 | Ste. Genevieve | Missouri | 29186 | 1831 | 17 |
1363556 | 1363556 | 2021-05-28 | Ste. Genevieve | Missouri | 29186 | 1831 | 17 |
1360309 | 1360309 | 2021-05-27 | Ste. Genevieve | Missouri | 29186 | 1830 | 17 |
1357063 | 1357063 | 2021-05-26 | Ste. Genevieve | Missouri | 29186 | 1828 | 17 |
1353817 | 1353817 | 2021-05-25 | Ste. Genevieve | Missouri | 29186 | 1828 | 17 |
1350571 | 1350571 | 2021-05-24 | Ste. Genevieve | Missouri | 29186 | 1827 | 16 |
1347325 | 1347325 | 2021-05-23 | Ste. Genevieve | Missouri | 29186 | 1826 | 16 |
1344077 | 1344077 | 2021-05-22 | Ste. Genevieve | Missouri | 29186 | 1826 | 16 |
1340828 | 1340828 | 2021-05-21 | Ste. Genevieve | Missouri | 29186 | 1823 | 16 |
1337581 | 1337581 | 2021-05-20 | Ste. Genevieve | Missouri | 29186 | 1823 | 16 |
1334334 | 1334334 | 2021-05-19 | Ste. Genevieve | Missouri | 29186 | 1821 | 16 |
1331087 | 1331087 | 2021-05-18 | Ste. Genevieve | Missouri | 29186 | 1821 | 16 |
1327840 | 1327840 | 2021-05-17 | Ste. Genevieve | Missouri | 29186 | 1820 | 16 |
1324594 | 1324594 | 2021-05-16 | Ste. Genevieve | Missouri | 29186 | 1820 | 16 |
1321348 | 1321348 | 2021-05-15 | Ste. Genevieve | Missouri | 29186 | 1819 | 16 |
1318102 | 1318102 | 2021-05-14 | Ste. Genevieve | Missouri | 29186 | 1818 | 16 |
1314854 | 1314854 | 2021-05-13 | Ste. Genevieve | Missouri | 29186 | 1818 | 16 |
1311608 | 1311608 | 2021-05-12 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1308361 | 1308361 | 2021-05-11 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1305115 | 1305115 | 2021-05-10 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1301869 | 1301869 | 2021-05-09 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1298621 | 1298621 | 2021-05-08 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1295375 | 1295375 | 2021-05-07 | Ste. Genevieve | Missouri | 29186 | 1816 | 16 |
1292129 | 1292129 | 2021-05-06 | Ste. Genevieve | Missouri | 29186 | 1813 | 16 |
1288883 | 1288883 | 2021-05-05 | Ste. Genevieve | Missouri | 29186 | 1812 | 16 |
1285637 | 1285637 | 2021-05-04 | Ste. Genevieve | Missouri | 29186 | 1811 | 16 |
1282391 | 1282391 | 2021-05-03 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1279144 | 1279144 | 2021-05-02 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1275897 | 1275897 | 2021-05-01 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1272650 | 1272650 | 2021-04-30 | Ste. Genevieve | Missouri | 29186 | 1809 | 16 |
1269403 | 1269403 | 2021-04-29 | Ste. Genevieve | Missouri | 29186 | 1806 | 16 |
1266156 | 1266156 | 2021-04-28 | Ste. Genevieve | Missouri | 29186 | 1805 | 16 |
1262909 | 1262909 | 2021-04-27 | Ste. Genevieve | Missouri | 29186 | 1804 | 16 |
1259662 | 1259662 | 2021-04-26 | Ste. Genevieve | Missouri | 29186 | 1804 | 16 |
1256415 | 1256415 | 2021-04-25 | Ste. Genevieve | Missouri | 29186 | 1803 | 16 |
1253168 | 1253168 | 2021-04-24 | Ste. Genevieve | Missouri | 29186 | 1803 | 16 |
1249921 | 1249921 | 2021-04-23 | Ste. Genevieve | Missouri | 29186 | 1801 | 16 |
1246674 | 1246674 | 2021-04-22 | Ste. Genevieve | Missouri | 29186 | 1798 | 16 |
1243427 | 1243427 | 2021-04-21 | Ste. Genevieve | Missouri | 29186 | 1796 | 16 |
1240180 | 1240180 | 2021-04-20 | Ste. Genevieve | Missouri | 29186 | 1795 | 16 |
1236933 | 1236933 | 2021-04-19 | Ste. Genevieve | Missouri | 29186 | 1793 | 16 |
1233686 | 1233686 | 2021-04-18 | Ste. Genevieve | Missouri | 29186 | 1793 | 16 |
1230438 | 1230438 | 2021-04-17 | Ste. Genevieve | Missouri | 29186 | 1792 | 16 |
1227190 | 1227190 | 2021-04-16 | Ste. Genevieve | Missouri | 29186 | 1824 | 16 |
1223942 | 1223942 | 2021-04-15 | Ste. Genevieve | Missouri | 29186 | 1824 | 16 |
1220695 | 1220695 | 2021-04-14 | Ste. Genevieve | Missouri | 29186 | 1821 | 16 |
1217447 | 1217447 | 2021-04-13 | Ste. Genevieve | Missouri | 29186 | 1820 | 16 |
1214200 | 1214200 | 2021-04-12 | Ste. Genevieve | Missouri | 29186 | 1819 | 16 |
1210952 | 1210952 | 2021-04-11 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1207703 | 1207703 | 2021-04-10 | Ste. Genevieve | Missouri | 29186 | 1817 | 16 |
1204455 | 1204455 | 2021-04-09 | Ste. Genevieve | Missouri | 29186 | 1816 | 16 |
1201207 | 1201207 | 2021-04-08 | Ste. Genevieve | Missouri | 29186 | 1815 | 16 |
1197958 | 1197958 | 2021-04-07 | Ste. Genevieve | Missouri | 29186 | 1814 | 16 |
1194709 | 1194709 | 2021-04-06 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1191460 | 1191460 | 2021-04-05 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1188212 | 1188212 | 2021-04-04 | Ste. Genevieve | Missouri | 29186 | 1810 | 16 |
1184965 | 1184965 | 2021-04-03 | Ste. Genevieve | Missouri | 29186 | 1809 | 16 |
1181719 | 1181719 | 2021-04-02 | Ste. Genevieve | Missouri | 29186 | 1808 | 16 |
1178472 | 1178472 | 2021-04-01 | Ste. Genevieve | Missouri | 29186 | 1806 | 16 |
1175225 | 1175225 | 2021-03-31 | Ste. Genevieve | Missouri | 29186 | 1804 | 16 |
1171978 | 1171978 | 2021-03-30 | Ste. Genevieve | Missouri | 29186 | 1799 | 16 |
1168730 | 1168730 | 2021-03-29 | Ste. Genevieve | Missouri | 29186 | 1793 | 16 |
1165482 | 1165482 | 2021-03-28 | Ste. Genevieve | Missouri | 29186 | 1793 | 16 |
1162234 | 1162234 | 2021-03-27 | Ste. Genevieve | Missouri | 29186 | 1792 | 16 |
1158986 | 1158986 | 2021-03-26 | Ste. Genevieve | Missouri | 29186 | 1790 | 16 |
1155739 | 1155739 | 2021-03-25 | Ste. Genevieve | Missouri | 29186 | 1788 | 16 |
1152492 | 1152492 | 2021-03-24 | Ste. Genevieve | Missouri | 29186 | 1787 | 16 |
1149245 | 1149245 | 2021-03-23 | Ste. Genevieve | Missouri | 29186 | 1785 | 16 |
1145998 | 1145998 | 2021-03-22 | Ste. Genevieve | Missouri | 29186 | 1784 | 16 |
1142751 | 1142751 | 2021-03-21 | Ste. Genevieve | Missouri | 29186 | 1784 | 16 |
1139504 | 1139504 | 2021-03-20 | Ste. Genevieve | Missouri | 29186 | 1782 | 16 |
1136258 | 1136258 | 2021-03-19 | Ste. Genevieve | Missouri | 29186 | 1782 | 16 |
1133012 | 1133012 | 2021-03-18 | Ste. Genevieve | Missouri | 29186 | 1781 | 16 |
1129764 | 1129764 | 2021-03-17 | Ste. Genevieve | Missouri | 29186 | 1781 | 16 |
1126517 | 1126517 | 2021-03-16 | Ste. Genevieve | Missouri | 29186 | 1781 | 16 |
1123271 | 1123271 | 2021-03-15 | Ste. Genevieve | Missouri | 29186 | 1778 | 16 |
1120024 | 1120024 | 2021-03-14 | Ste. Genevieve | Missouri | 29186 | 1777 | 16 |
1116777 | 1116777 | 2021-03-13 | Ste. Genevieve | Missouri | 29186 | 1774 | 16 |
1113531 | 1113531 | 2021-03-12 | Ste. Genevieve | Missouri | 29186 | 1771 | 16 |
1110285 | 1110285 | 2021-03-11 | Ste. Genevieve | Missouri | 29186 | 1771 | 15 |
1107039 | 1107039 | 2021-03-10 | Ste. Genevieve | Missouri | 29186 | 1767 | 15 |
1103793 | 1103793 | 2021-03-09 | Ste. Genevieve | Missouri | 29186 | 1762 | 15 |
1100547 | 1100547 | 2021-03-08 | Ste. Genevieve | Missouri | 29186 | 1760 | 15 |
1097300 | 1097300 | 2021-03-07 | Ste. Genevieve | Missouri | 29186 | 1620 | 15 |
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);