ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,657 rows where deaths = 14 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sullivan 251
- Harrison 210
- Ralls 91
- Wayne 91
- Holt 89
- St. Clair 58
- Bollinger 53
- Marion 52
- Carter 51
- Osage 50
- Barton 49
- Daviess 36
- Hickory 35
- Dunklin 29
- Caldwell 27
- Shelby 23
- Ripley 22
- Linn 20
- Grundy 19
- Newton 19
- Cole 18
- Montgomery 18
- Iron 17
- Crawford 14
- Pike 14
- Warren 14
- Cass 12
- Jasper 11
- Scott 11
- Douglas 10
- …
state 1
- Missouri · 1,657 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501129 | 2501129 | 2022-05-13 | Knox | Missouri | 29103 | 990 | 14 |
2501142 | 2501142 | 2022-05-13 | Mercer | Missouri | 29129 | 704 | 14 |
2497871 | 2497871 | 2022-05-12 | Knox | Missouri | 29103 | 989 | 14 |
2497884 | 2497884 | 2022-05-12 | Mercer | Missouri | 29129 | 704 | 14 |
2494613 | 2494613 | 2022-05-11 | Knox | Missouri | 29103 | 989 | 14 |
2494626 | 2494626 | 2022-05-11 | Mercer | Missouri | 29129 | 704 | 14 |
2491355 | 2491355 | 2022-05-10 | Knox | Missouri | 29103 | 989 | 14 |
2491368 | 2491368 | 2022-05-10 | Mercer | Missouri | 29129 | 704 | 14 |
2488097 | 2488097 | 2022-05-09 | Knox | Missouri | 29103 | 989 | 14 |
2488110 | 2488110 | 2022-05-09 | Mercer | Missouri | 29129 | 704 | 14 |
2484840 | 2484840 | 2022-05-08 | Knox | Missouri | 29103 | 989 | 14 |
2484853 | 2484853 | 2022-05-08 | Mercer | Missouri | 29129 | 704 | 14 |
2481582 | 2481582 | 2022-05-07 | Knox | Missouri | 29103 | 989 | 14 |
2481595 | 2481595 | 2022-05-07 | Mercer | Missouri | 29129 | 704 | 14 |
2478324 | 2478324 | 2022-05-06 | Knox | Missouri | 29103 | 989 | 14 |
2478337 | 2478337 | 2022-05-06 | Mercer | Missouri | 29129 | 704 | 14 |
2475066 | 2475066 | 2022-05-05 | Knox | Missouri | 29103 | 985 | 14 |
2475079 | 2475079 | 2022-05-05 | Mercer | Missouri | 29129 | 704 | 14 |
2244085 | 2244085 | 2022-02-23 | Shelby | Missouri | 29205 | 1493 | 14 |
2240834 | 2240834 | 2022-02-22 | Shelby | Missouri | 29205 | 1492 | 14 |
2237583 | 2237583 | 2022-02-21 | Shelby | Missouri | 29205 | 1486 | 14 |
2234332 | 2234332 | 2022-02-20 | Shelby | Missouri | 29205 | 1486 | 14 |
2231081 | 2231081 | 2022-02-19 | Shelby | Missouri | 29205 | 1486 | 14 |
2227830 | 2227830 | 2022-02-18 | Shelby | Missouri | 29205 | 1486 | 14 |
2224579 | 2224579 | 2022-02-17 | Shelby | Missouri | 29205 | 1486 | 14 |
2221328 | 2221328 | 2022-02-16 | Shelby | Missouri | 29205 | 1485 | 14 |
2218077 | 2218077 | 2022-02-15 | Shelby | Missouri | 29205 | 1484 | 14 |
2214826 | 2214826 | 2022-02-14 | Shelby | Missouri | 29205 | 1483 | 14 |
2211574 | 2211574 | 2022-02-13 | Shelby | Missouri | 29205 | 1473 | 14 |
2208321 | 2208321 | 2022-02-12 | Shelby | Missouri | 29205 | 1473 | 14 |
2205068 | 2205068 | 2022-02-11 | Shelby | Missouri | 29205 | 1473 | 14 |
2201815 | 2201815 | 2022-02-10 | Shelby | Missouri | 29205 | 1473 | 14 |
2198561 | 2198561 | 2022-02-09 | Shelby | Missouri | 29205 | 1472 | 14 |
2195307 | 2195307 | 2022-02-08 | Shelby | Missouri | 29205 | 1457 | 14 |
2192053 | 2192053 | 2022-02-07 | Shelby | Missouri | 29205 | 1452 | 14 |
2188800 | 2188800 | 2022-02-06 | Shelby | Missouri | 29205 | 1450 | 14 |
2185547 | 2185547 | 2022-02-05 | Shelby | Missouri | 29205 | 1446 | 14 |
2182295 | 2182295 | 2022-02-04 | Shelby | Missouri | 29205 | 1441 | 14 |
2179043 | 2179043 | 2022-02-03 | Shelby | Missouri | 29205 | 1439 | 14 |
2175791 | 2175791 | 2022-02-02 | Shelby | Missouri | 29205 | 1436 | 14 |
2172538 | 2172538 | 2022-02-01 | Shelby | Missouri | 29205 | 1427 | 14 |
1925358 | 1925358 | 2021-11-17 | Carter | Missouri | 29035 | 1087 | 14 |
1925371 | 1925371 | 2021-11-17 | Daviess | Missouri | 29061 | 1072 | 14 |
1925441 | 1925441 | 2021-11-17 | St. Clair | Missouri | 29185 | 1296 | 14 |
1922109 | 1922109 | 2021-11-16 | Carter | Missouri | 29035 | 1087 | 14 |
1922122 | 1922122 | 2021-11-16 | Daviess | Missouri | 29061 | 1070 | 14 |
1922192 | 1922192 | 2021-11-16 | St. Clair | Missouri | 29185 | 1296 | 14 |
1918859 | 1918859 | 2021-11-15 | Carter | Missouri | 29035 | 1087 | 14 |
1918872 | 1918872 | 2021-11-15 | Daviess | Missouri | 29061 | 1061 | 14 |
1918930 | 1918930 | 2021-11-15 | Ralls | Missouri | 29173 | 1572 | 14 |
1918942 | 1918942 | 2021-11-15 | St. Clair | Missouri | 29185 | 1295 | 14 |
1915609 | 1915609 | 2021-11-14 | Carter | Missouri | 29035 | 1086 | 14 |
1915622 | 1915622 | 2021-11-14 | Daviess | Missouri | 29061 | 1061 | 14 |
1915680 | 1915680 | 2021-11-14 | Ralls | Missouri | 29173 | 1571 | 14 |
1915692 | 1915692 | 2021-11-14 | St. Clair | Missouri | 29185 | 1295 | 14 |
1912359 | 1912359 | 2021-11-13 | Carter | Missouri | 29035 | 1086 | 14 |
1912372 | 1912372 | 2021-11-13 | Daviess | Missouri | 29061 | 1061 | 14 |
1912430 | 1912430 | 2021-11-13 | Ralls | Missouri | 29173 | 1570 | 14 |
1912442 | 1912442 | 2021-11-13 | St. Clair | Missouri | 29185 | 1292 | 14 |
1909109 | 1909109 | 2021-11-12 | Carter | Missouri | 29035 | 1085 | 14 |
1909122 | 1909122 | 2021-11-12 | Daviess | Missouri | 29061 | 1059 | 14 |
1909180 | 1909180 | 2021-11-12 | Ralls | Missouri | 29173 | 1565 | 14 |
1909192 | 1909192 | 2021-11-12 | St. Clair | Missouri | 29185 | 1289 | 14 |
1905860 | 1905860 | 2021-11-11 | Carter | Missouri | 29035 | 1084 | 14 |
1905873 | 1905873 | 2021-11-11 | Daviess | Missouri | 29061 | 1055 | 14 |
1905931 | 1905931 | 2021-11-11 | Ralls | Missouri | 29173 | 1560 | 14 |
1905943 | 1905943 | 2021-11-11 | St. Clair | Missouri | 29185 | 1281 | 14 |
1902611 | 1902611 | 2021-11-10 | Carter | Missouri | 29035 | 1084 | 14 |
1902624 | 1902624 | 2021-11-10 | Daviess | Missouri | 29061 | 1055 | 14 |
1902682 | 1902682 | 2021-11-10 | Ralls | Missouri | 29173 | 1560 | 14 |
1902694 | 1902694 | 2021-11-10 | St. Clair | Missouri | 29185 | 1281 | 14 |
1899361 | 1899361 | 2021-11-09 | Carter | Missouri | 29035 | 1082 | 14 |
1899374 | 1899374 | 2021-11-09 | Daviess | Missouri | 29061 | 1054 | 14 |
1899432 | 1899432 | 2021-11-09 | Ralls | Missouri | 29173 | 1555 | 14 |
1899444 | 1899444 | 2021-11-09 | St. Clair | Missouri | 29185 | 1277 | 14 |
1896111 | 1896111 | 2021-11-08 | Carter | Missouri | 29035 | 1081 | 14 |
1896124 | 1896124 | 2021-11-08 | Daviess | Missouri | 29061 | 1046 | 14 |
1896182 | 1896182 | 2021-11-08 | Ralls | Missouri | 29173 | 1549 | 14 |
1896194 | 1896194 | 2021-11-08 | St. Clair | Missouri | 29185 | 1273 | 14 |
1892861 | 1892861 | 2021-11-07 | Carter | Missouri | 29035 | 1081 | 14 |
1892874 | 1892874 | 2021-11-07 | Daviess | Missouri | 29061 | 1045 | 14 |
1892932 | 1892932 | 2021-11-07 | Ralls | Missouri | 29173 | 1549 | 14 |
1892944 | 1892944 | 2021-11-07 | St. Clair | Missouri | 29185 | 1273 | 14 |
1889611 | 1889611 | 2021-11-06 | Carter | Missouri | 29035 | 1081 | 14 |
1889624 | 1889624 | 2021-11-06 | Daviess | Missouri | 29061 | 1045 | 14 |
1889682 | 1889682 | 2021-11-06 | Ralls | Missouri | 29173 | 1548 | 14 |
1889694 | 1889694 | 2021-11-06 | St. Clair | Missouri | 29185 | 1273 | 14 |
1886361 | 1886361 | 2021-11-05 | Carter | Missouri | 29035 | 1081 | 14 |
1886374 | 1886374 | 2021-11-05 | Daviess | Missouri | 29061 | 1044 | 14 |
1886432 | 1886432 | 2021-11-05 | Ralls | Missouri | 29173 | 1547 | 14 |
1886444 | 1886444 | 2021-11-05 | St. Clair | Missouri | 29185 | 1264 | 14 |
1883112 | 1883112 | 2021-11-04 | Carter | Missouri | 29035 | 1080 | 14 |
1883125 | 1883125 | 2021-11-04 | Daviess | Missouri | 29061 | 1044 | 14 |
1883183 | 1883183 | 2021-11-04 | Ralls | Missouri | 29173 | 1545 | 14 |
1883195 | 1883195 | 2021-11-04 | St. Clair | Missouri | 29185 | 1260 | 14 |
1879863 | 1879863 | 2021-11-03 | Carter | Missouri | 29035 | 1078 | 14 |
1879876 | 1879876 | 2021-11-03 | Daviess | Missouri | 29061 | 1042 | 14 |
1879934 | 1879934 | 2021-11-03 | Ralls | Missouri | 29173 | 1542 | 14 |
1879946 | 1879946 | 2021-11-03 | St. Clair | Missouri | 29185 | 1259 | 14 |
1876614 | 1876614 | 2021-11-02 | Carter | Missouri | 29035 | 1078 | 14 |
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);