ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
708 rows where deaths = 28 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501164 | 2501164 | 2022-05-13 | Ralls | Missouri | 29173 | 2470 | 28 |
2497906 | 2497906 | 2022-05-12 | Ralls | Missouri | 29173 | 2463 | 28 |
2494648 | 2494648 | 2022-05-11 | Ralls | Missouri | 29173 | 2463 | 28 |
2491390 | 2491390 | 2022-05-10 | Ralls | Missouri | 29173 | 2463 | 28 |
2488132 | 2488132 | 2022-05-09 | Ralls | Missouri | 29173 | 2463 | 28 |
2484875 | 2484875 | 2022-05-08 | Ralls | Missouri | 29173 | 2463 | 28 |
2481617 | 2481617 | 2022-05-07 | Ralls | Missouri | 29173 | 2463 | 28 |
2478359 | 2478359 | 2022-05-06 | Ralls | Missouri | 29173 | 2463 | 28 |
2475101 | 2475101 | 2022-05-05 | Ralls | Missouri | 29173 | 2458 | 28 |
2471786 | 2471786 | 2022-05-04 | Daviess | Missouri | 29061 | 1716 | 28 |
2468530 | 2468530 | 2022-05-03 | Daviess | Missouri | 29061 | 1716 | 28 |
2465274 | 2465274 | 2022-05-02 | Daviess | Missouri | 29061 | 1716 | 28 |
2462019 | 2462019 | 2022-05-01 | Daviess | Missouri | 29061 | 1716 | 28 |
2458763 | 2458763 | 2022-04-30 | Daviess | Missouri | 29061 | 1716 | 28 |
2455507 | 2455507 | 2022-04-29 | Daviess | Missouri | 29061 | 1716 | 28 |
2452251 | 2452251 | 2022-04-28 | Daviess | Missouri | 29061 | 1716 | 28 |
2448995 | 2448995 | 2022-04-27 | Daviess | Missouri | 29061 | 1716 | 28 |
2445738 | 2445738 | 2022-04-26 | Daviess | Missouri | 29061 | 1716 | 28 |
2442483 | 2442483 | 2022-04-25 | Daviess | Missouri | 29061 | 1716 | 28 |
2439227 | 2439227 | 2022-04-24 | Daviess | Missouri | 29061 | 1716 | 28 |
2435971 | 2435971 | 2022-04-23 | Daviess | Missouri | 29061 | 1716 | 28 |
2432715 | 2432715 | 2022-04-22 | Daviess | Missouri | 29061 | 1716 | 28 |
2429459 | 2429459 | 2022-04-21 | Daviess | Missouri | 29061 | 1716 | 28 |
2426203 | 2426203 | 2022-04-20 | Daviess | Missouri | 29061 | 1716 | 28 |
2422947 | 2422947 | 2022-04-19 | Daviess | Missouri | 29061 | 1716 | 28 |
2419690 | 2419690 | 2022-04-18 | Daviess | Missouri | 29061 | 1716 | 28 |
2416435 | 2416435 | 2022-04-17 | Daviess | Missouri | 29061 | 1716 | 28 |
2413179 | 2413179 | 2022-04-16 | Daviess | Missouri | 29061 | 1716 | 28 |
2409923 | 2409923 | 2022-04-15 | Daviess | Missouri | 29061 | 1716 | 28 |
2406667 | 2406667 | 2022-04-14 | Daviess | Missouri | 29061 | 1716 | 28 |
2403411 | 2403411 | 2022-04-13 | Daviess | Missouri | 29061 | 1716 | 28 |
2400156 | 2400156 | 2022-04-12 | Daviess | Missouri | 29061 | 1716 | 28 |
2396901 | 2396901 | 2022-04-11 | Daviess | Missouri | 29061 | 1716 | 28 |
2393646 | 2393646 | 2022-04-10 | Daviess | Missouri | 29061 | 1716 | 28 |
2390390 | 2390390 | 2022-04-09 | Daviess | Missouri | 29061 | 1716 | 28 |
2387134 | 2387134 | 2022-04-08 | Daviess | Missouri | 29061 | 1716 | 28 |
2383879 | 2383879 | 2022-04-07 | Daviess | Missouri | 29061 | 1716 | 28 |
2380624 | 2380624 | 2022-04-06 | Daviess | Missouri | 29061 | 1716 | 28 |
2377369 | 2377369 | 2022-04-05 | Daviess | Missouri | 29061 | 1716 | 28 |
2374116 | 2374116 | 2022-04-04 | Daviess | Missouri | 29061 | 1716 | 28 |
2370864 | 2370864 | 2022-04-03 | Daviess | Missouri | 29061 | 1716 | 28 |
2367611 | 2367611 | 2022-04-02 | Daviess | Missouri | 29061 | 1716 | 28 |
2364358 | 2364358 | 2022-04-01 | Daviess | Missouri | 29061 | 1716 | 28 |
2361104 | 2361104 | 2022-03-31 | Daviess | Missouri | 29061 | 1716 | 28 |
2357850 | 2357850 | 2022-03-30 | Daviess | Missouri | 29061 | 1716 | 28 |
2354597 | 2354597 | 2022-03-29 | Daviess | Missouri | 29061 | 1714 | 28 |
2244009 | 2244009 | 2022-02-23 | Clark | Missouri | 29045 | 1567 | 28 |
2244027 | 2244027 | 2022-02-23 | Harrison | Missouri | 29081 | 1787 | 28 |
2240758 | 2240758 | 2022-02-22 | Clark | Missouri | 29045 | 1566 | 28 |
2240776 | 2240776 | 2022-02-22 | Harrison | Missouri | 29081 | 1787 | 28 |
2237507 | 2237507 | 2022-02-21 | Clark | Missouri | 29045 | 1565 | 28 |
2237525 | 2237525 | 2022-02-21 | Harrison | Missouri | 29081 | 1780 | 28 |
2234256 | 2234256 | 2022-02-20 | Clark | Missouri | 29045 | 1565 | 28 |
2234274 | 2234274 | 2022-02-20 | Harrison | Missouri | 29081 | 1780 | 28 |
2231005 | 2231005 | 2022-02-19 | Clark | Missouri | 29045 | 1565 | 28 |
2231023 | 2231023 | 2022-02-19 | Harrison | Missouri | 29081 | 1780 | 28 |
2227754 | 2227754 | 2022-02-18 | Clark | Missouri | 29045 | 1565 | 28 |
2227772 | 2227772 | 2022-02-18 | Harrison | Missouri | 29081 | 1780 | 28 |
2224503 | 2224503 | 2022-02-17 | Clark | Missouri | 29045 | 1565 | 28 |
2224521 | 2224521 | 2022-02-17 | Harrison | Missouri | 29081 | 1780 | 28 |
2221252 | 2221252 | 2022-02-16 | Clark | Missouri | 29045 | 1563 | 28 |
2221270 | 2221270 | 2022-02-16 | Harrison | Missouri | 29081 | 1778 | 28 |
2218001 | 2218001 | 2022-02-15 | Clark | Missouri | 29045 | 1559 | 28 |
2218019 | 2218019 | 2022-02-15 | Harrison | Missouri | 29081 | 1776 | 28 |
2214750 | 2214750 | 2022-02-14 | Clark | Missouri | 29045 | 1559 | 28 |
2211498 | 2211498 | 2022-02-13 | Clark | Missouri | 29045 | 1554 | 28 |
2208245 | 2208245 | 2022-02-12 | Clark | Missouri | 29045 | 1554 | 28 |
2204992 | 2204992 | 2022-02-11 | Clark | Missouri | 29045 | 1554 | 28 |
2201739 | 2201739 | 2022-02-10 | Clark | Missouri | 29045 | 1554 | 28 |
2198485 | 2198485 | 2022-02-09 | Clark | Missouri | 29045 | 1551 | 28 |
2195231 | 2195231 | 2022-02-08 | Clark | Missouri | 29045 | 1548 | 28 |
2195285 | 2195285 | 2022-02-08 | Oregon | Missouri | 29149 | 1951 | 28 |
2191977 | 2191977 | 2022-02-07 | Clark | Missouri | 29045 | 1533 | 28 |
2191992 | 2191992 | 2022-02-07 | Gentry | Missouri | 29075 | 2061 | 28 |
2192018 | 2192018 | 2022-02-07 | Maries | Missouri | 29125 | 1537 | 28 |
2192031 | 2192031 | 2022-02-07 | Oregon | Missouri | 29149 | 1941 | 28 |
2188724 | 2188724 | 2022-02-06 | Clark | Missouri | 29045 | 1533 | 28 |
2188739 | 2188739 | 2022-02-06 | Gentry | Missouri | 29075 | 2060 | 28 |
2188765 | 2188765 | 2022-02-06 | Maries | Missouri | 29125 | 1535 | 28 |
2188778 | 2188778 | 2022-02-06 | Oregon | Missouri | 29149 | 1941 | 28 |
2185471 | 2185471 | 2022-02-05 | Clark | Missouri | 29045 | 1531 | 28 |
2185486 | 2185486 | 2022-02-05 | Gentry | Missouri | 29075 | 2058 | 28 |
2185512 | 2185512 | 2022-02-05 | Maries | Missouri | 29125 | 1535 | 28 |
2185525 | 2185525 | 2022-02-05 | Oregon | Missouri | 29149 | 1939 | 28 |
2182219 | 2182219 | 2022-02-04 | Clark | Missouri | 29045 | 1526 | 28 |
2182234 | 2182234 | 2022-02-04 | Gentry | Missouri | 29075 | 2054 | 28 |
2182260 | 2182260 | 2022-02-04 | Maries | Missouri | 29125 | 1532 | 28 |
2182273 | 2182273 | 2022-02-04 | Oregon | Missouri | 29149 | 1933 | 28 |
2178967 | 2178967 | 2022-02-03 | Clark | Missouri | 29045 | 1526 | 28 |
2178982 | 2178982 | 2022-02-03 | Gentry | Missouri | 29075 | 2052 | 28 |
2179008 | 2179008 | 2022-02-03 | Maries | Missouri | 29125 | 1528 | 28 |
2179021 | 2179021 | 2022-02-03 | Oregon | Missouri | 29149 | 1931 | 28 |
2175715 | 2175715 | 2022-02-02 | Clark | Missouri | 29045 | 1521 | 28 |
2175730 | 2175730 | 2022-02-02 | Gentry | Missouri | 29075 | 2048 | 28 |
2175756 | 2175756 | 2022-02-02 | Maries | Missouri | 29125 | 1526 | 28 |
2175769 | 2175769 | 2022-02-02 | Oregon | Missouri | 29149 | 1920 | 28 |
2172462 | 2172462 | 2022-02-01 | Clark | Missouri | 29045 | 1511 | 28 |
2172477 | 2172477 | 2022-02-01 | Gentry | Missouri | 29075 | 2037 | 28 |
2172503 | 2172503 | 2022-02-01 | Maries | Missouri | 29125 | 1511 | 28 |
2172516 | 2172516 | 2022-02-01 | Oregon | Missouri | 29149 | 1906 | 28 |
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);