ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 137 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
- Lincoln 37
- Washington 37
- Lawrence 16
- Clay 7
- Jasper 7
- St. Francois 7
- Phelps 6
- Boone 4
- Greene 3
- St. Louis 1
state 1
- Missouri · 125 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471814 | 2471814 | 2022-05-04 | Lincoln | Missouri | 29113 | 15127 | 137 |
2471868 | 2471868 | 2022-05-04 | Washington | Missouri | 29221 | 5983 | 137 |
2468558 | 2468558 | 2022-05-03 | Lincoln | Missouri | 29113 | 15127 | 137 |
2468612 | 2468612 | 2022-05-03 | Washington | Missouri | 29221 | 5983 | 137 |
2465302 | 2465302 | 2022-05-02 | Lincoln | Missouri | 29113 | 15127 | 137 |
2465356 | 2465356 | 2022-05-02 | Washington | Missouri | 29221 | 5983 | 137 |
2462047 | 2462047 | 2022-05-01 | Lincoln | Missouri | 29113 | 15127 | 137 |
2462101 | 2462101 | 2022-05-01 | Washington | Missouri | 29221 | 5983 | 137 |
2458791 | 2458791 | 2022-04-30 | Lincoln | Missouri | 29113 | 15127 | 137 |
2458845 | 2458845 | 2022-04-30 | Washington | Missouri | 29221 | 5983 | 137 |
2455535 | 2455535 | 2022-04-29 | Lincoln | Missouri | 29113 | 15127 | 137 |
2455589 | 2455589 | 2022-04-29 | Washington | Missouri | 29221 | 5983 | 137 |
2452279 | 2452279 | 2022-04-28 | Lincoln | Missouri | 29113 | 15127 | 137 |
2452333 | 2452333 | 2022-04-28 | Washington | Missouri | 29221 | 5983 | 137 |
2449023 | 2449023 | 2022-04-27 | Lincoln | Missouri | 29113 | 15127 | 137 |
2449077 | 2449077 | 2022-04-27 | Washington | Missouri | 29221 | 5983 | 137 |
2445766 | 2445766 | 2022-04-26 | Lincoln | Missouri | 29113 | 15127 | 137 |
2445820 | 2445820 | 2022-04-26 | Washington | Missouri | 29221 | 5983 | 137 |
2442511 | 2442511 | 2022-04-25 | Lincoln | Missouri | 29113 | 15127 | 137 |
2442565 | 2442565 | 2022-04-25 | Washington | Missouri | 29221 | 5983 | 137 |
2439255 | 2439255 | 2022-04-24 | Lincoln | Missouri | 29113 | 15127 | 137 |
2439309 | 2439309 | 2022-04-24 | Washington | Missouri | 29221 | 5983 | 137 |
2435999 | 2435999 | 2022-04-23 | Lincoln | Missouri | 29113 | 15127 | 137 |
2436053 | 2436053 | 2022-04-23 | Washington | Missouri | 29221 | 5983 | 137 |
2432743 | 2432743 | 2022-04-22 | Lincoln | Missouri | 29113 | 15127 | 137 |
2432797 | 2432797 | 2022-04-22 | Washington | Missouri | 29221 | 5983 | 137 |
2429487 | 2429487 | 2022-04-21 | Lincoln | Missouri | 29113 | 15127 | 137 |
2429541 | 2429541 | 2022-04-21 | Washington | Missouri | 29221 | 5983 | 137 |
2426231 | 2426231 | 2022-04-20 | Lincoln | Missouri | 29113 | 15127 | 137 |
2426285 | 2426285 | 2022-04-20 | Washington | Missouri | 29221 | 5983 | 137 |
2422975 | 2422975 | 2022-04-19 | Lincoln | Missouri | 29113 | 15127 | 137 |
2423029 | 2423029 | 2022-04-19 | Washington | Missouri | 29221 | 5983 | 137 |
2419718 | 2419718 | 2022-04-18 | Lincoln | Missouri | 29113 | 15127 | 137 |
2419772 | 2419772 | 2022-04-18 | Washington | Missouri | 29221 | 5983 | 137 |
2416463 | 2416463 | 2022-04-17 | Lincoln | Missouri | 29113 | 15127 | 137 |
2416517 | 2416517 | 2022-04-17 | Washington | Missouri | 29221 | 5983 | 137 |
2413207 | 2413207 | 2022-04-16 | Lincoln | Missouri | 29113 | 15127 | 137 |
2413261 | 2413261 | 2022-04-16 | Washington | Missouri | 29221 | 5983 | 137 |
2409951 | 2409951 | 2022-04-15 | Lincoln | Missouri | 29113 | 15127 | 137 |
2410005 | 2410005 | 2022-04-15 | Washington | Missouri | 29221 | 5983 | 137 |
2406695 | 2406695 | 2022-04-14 | Lincoln | Missouri | 29113 | 15127 | 137 |
2406749 | 2406749 | 2022-04-14 | Washington | Missouri | 29221 | 5983 | 137 |
2403439 | 2403439 | 2022-04-13 | Lincoln | Missouri | 29113 | 15127 | 137 |
2403493 | 2403493 | 2022-04-13 | Washington | Missouri | 29221 | 5983 | 137 |
2400184 | 2400184 | 2022-04-12 | Lincoln | Missouri | 29113 | 15127 | 137 |
2400238 | 2400238 | 2022-04-12 | Washington | Missouri | 29221 | 5983 | 137 |
2396929 | 2396929 | 2022-04-11 | Lincoln | Missouri | 29113 | 15127 | 137 |
2396983 | 2396983 | 2022-04-11 | Washington | Missouri | 29221 | 5983 | 137 |
2393674 | 2393674 | 2022-04-10 | Lincoln | Missouri | 29113 | 15127 | 137 |
2393728 | 2393728 | 2022-04-10 | Washington | Missouri | 29221 | 5983 | 137 |
2390418 | 2390418 | 2022-04-09 | Lincoln | Missouri | 29113 | 15127 | 137 |
2390472 | 2390472 | 2022-04-09 | Washington | Missouri | 29221 | 5983 | 137 |
2387162 | 2387162 | 2022-04-08 | Lincoln | Missouri | 29113 | 15127 | 137 |
2387216 | 2387216 | 2022-04-08 | Washington | Missouri | 29221 | 5983 | 137 |
2383907 | 2383907 | 2022-04-07 | Lincoln | Missouri | 29113 | 15127 | 137 |
2383961 | 2383961 | 2022-04-07 | Washington | Missouri | 29221 | 5983 | 137 |
2380652 | 2380652 | 2022-04-06 | Lincoln | Missouri | 29113 | 15127 | 137 |
2380706 | 2380706 | 2022-04-06 | Washington | Missouri | 29221 | 5983 | 137 |
2377397 | 2377397 | 2022-04-05 | Lincoln | Missouri | 29113 | 15127 | 137 |
2377451 | 2377451 | 2022-04-05 | Washington | Missouri | 29221 | 5983 | 137 |
2374144 | 2374144 | 2022-04-04 | Lincoln | Missouri | 29113 | 15127 | 137 |
2374198 | 2374198 | 2022-04-04 | Washington | Missouri | 29221 | 5983 | 137 |
2370892 | 2370892 | 2022-04-03 | Lincoln | Missouri | 29113 | 15127 | 137 |
2370946 | 2370946 | 2022-04-03 | Washington | Missouri | 29221 | 5983 | 137 |
2367639 | 2367639 | 2022-04-02 | Lincoln | Missouri | 29113 | 15127 | 137 |
2367693 | 2367693 | 2022-04-02 | Washington | Missouri | 29221 | 5983 | 137 |
2364386 | 2364386 | 2022-04-01 | Lincoln | Missouri | 29113 | 15127 | 137 |
2364440 | 2364440 | 2022-04-01 | Washington | Missouri | 29221 | 5983 | 137 |
2361132 | 2361132 | 2022-03-31 | Lincoln | Missouri | 29113 | 15127 | 137 |
2361186 | 2361186 | 2022-03-31 | Washington | Missouri | 29221 | 5983 | 137 |
2357878 | 2357878 | 2022-03-30 | Lincoln | Missouri | 29113 | 15127 | 137 |
2357932 | 2357932 | 2022-03-30 | Washington | Missouri | 29221 | 5971 | 137 |
2354625 | 2354625 | 2022-03-29 | Lincoln | Missouri | 29113 | 15126 | 137 |
2354679 | 2354679 | 2022-03-29 | Washington | Missouri | 29221 | 5964 | 137 |
2032667 | 2032667 | 2021-12-20 | Lawrence | Missouri | 29109 | 5658 | 137 |
2029416 | 2029416 | 2021-12-19 | Lawrence | Missouri | 29109 | 5651 | 137 |
2026165 | 2026165 | 2021-12-18 | Lawrence | Missouri | 29109 | 5643 | 137 |
2022914 | 2022914 | 2021-12-17 | Lawrence | Missouri | 29109 | 5629 | 137 |
2019663 | 2019663 | 2021-12-16 | Lawrence | Missouri | 29109 | 5607 | 137 |
2016413 | 2016413 | 2021-12-15 | Lawrence | Missouri | 29109 | 5592 | 137 |
2013162 | 2013162 | 2021-12-14 | Lawrence | Missouri | 29109 | 5580 | 137 |
2009911 | 2009911 | 2021-12-13 | Lawrence | Missouri | 29109 | 5570 | 137 |
2006660 | 2006660 | 2021-12-12 | Lawrence | Missouri | 29109 | 5563 | 137 |
2003409 | 2003409 | 2021-12-11 | Lawrence | Missouri | 29109 | 5547 | 137 |
2000159 | 2000159 | 2021-12-10 | Lawrence | Missouri | 29109 | 5537 | 137 |
1996908 | 1996908 | 2021-12-09 | Lawrence | Missouri | 29109 | 5509 | 137 |
1993657 | 1993657 | 2021-12-08 | Lawrence | Missouri | 29109 | 5499 | 137 |
1938398 | 1938398 | 2021-11-21 | Lawrence | Missouri | 29109 | 5335 | 137 |
1935148 | 1935148 | 2021-11-20 | Lawrence | Missouri | 29109 | 5335 | 137 |
1931898 | 1931898 | 2021-11-19 | Lawrence | Missouri | 29109 | 5326 | 137 |
1736987 | 1736987 | 2021-09-20 | St. Francois | Missouri | 29187 | 11353 | 137 |
1733737 | 1733737 | 2021-09-19 | St. Francois | Missouri | 29187 | 11343 | 137 |
1730487 | 1730487 | 2021-09-18 | St. Francois | Missouri | 29187 | 11314 | 137 |
1727237 | 1727237 | 2021-09-17 | St. Francois | Missouri | 29187 | 11270 | 137 |
1723988 | 1723988 | 2021-09-16 | St. Francois | Missouri | 29187 | 11226 | 137 |
1720739 | 1720739 | 2021-09-15 | St. Francois | Missouri | 29187 | 11173 | 137 |
1717491 | 1717491 | 2021-09-14 | St. Francois | Missouri | 29187 | 11114 | 137 |
1665426 | 1665426 | 2021-08-29 | Boone | Missouri | 29019 | 22803 | 137 |
1662178 | 1662178 | 2021-08-28 | Boone | Missouri | 29019 | 22803 | 137 |
1658930 | 1658930 | 2021-08-27 | Boone | Missouri | 29019 | 22803 | 137 |
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);