ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where deaths = 109 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 |
---|---|---|---|---|---|---|---|
2501186 | 2501186 | 2022-05-13 | Vernon | Missouri | 29217 | 5104 | 109 |
2497928 | 2497928 | 2022-05-12 | Vernon | Missouri | 29217 | 5100 | 109 |
2494670 | 2494670 | 2022-05-11 | Vernon | Missouri | 29217 | 5100 | 109 |
2491412 | 2491412 | 2022-05-10 | Vernon | Missouri | 29217 | 5100 | 109 |
2488154 | 2488154 | 2022-05-09 | Vernon | Missouri | 29217 | 5100 | 109 |
2484897 | 2484897 | 2022-05-08 | Vernon | Missouri | 29217 | 5100 | 109 |
2481639 | 2481639 | 2022-05-07 | Vernon | Missouri | 29217 | 5100 | 109 |
2478381 | 2478381 | 2022-05-06 | Vernon | Missouri | 29217 | 5100 | 109 |
2475123 | 2475123 | 2022-05-05 | Vernon | Missouri | 29217 | 5094 | 109 |
2471828 | 2471828 | 2022-05-04 | Morgan | Missouri | 29141 | 4025 | 109 |
2471866 | 2471866 | 2022-05-04 | Vernon | Missouri | 29217 | 5051 | 109 |
2468572 | 2468572 | 2022-05-03 | Morgan | Missouri | 29141 | 4025 | 109 |
2468610 | 2468610 | 2022-05-03 | Vernon | Missouri | 29217 | 5051 | 109 |
2465316 | 2465316 | 2022-05-02 | Morgan | Missouri | 29141 | 4025 | 109 |
2465354 | 2465354 | 2022-05-02 | Vernon | Missouri | 29217 | 5051 | 109 |
2462061 | 2462061 | 2022-05-01 | Morgan | Missouri | 29141 | 4025 | 109 |
2462099 | 2462099 | 2022-05-01 | Vernon | Missouri | 29217 | 5051 | 109 |
2458805 | 2458805 | 2022-04-30 | Morgan | Missouri | 29141 | 4025 | 109 |
2458843 | 2458843 | 2022-04-30 | Vernon | Missouri | 29217 | 5051 | 109 |
2455549 | 2455549 | 2022-04-29 | Morgan | Missouri | 29141 | 4025 | 109 |
2455587 | 2455587 | 2022-04-29 | Vernon | Missouri | 29217 | 5051 | 109 |
2452293 | 2452293 | 2022-04-28 | Morgan | Missouri | 29141 | 4025 | 109 |
2452331 | 2452331 | 2022-04-28 | Vernon | Missouri | 29217 | 5051 | 109 |
2449037 | 2449037 | 2022-04-27 | Morgan | Missouri | 29141 | 4025 | 109 |
2449075 | 2449075 | 2022-04-27 | Vernon | Missouri | 29217 | 5051 | 109 |
2445780 | 2445780 | 2022-04-26 | Morgan | Missouri | 29141 | 4025 | 109 |
2445818 | 2445818 | 2022-04-26 | Vernon | Missouri | 29217 | 5051 | 109 |
2442525 | 2442525 | 2022-04-25 | Morgan | Missouri | 29141 | 4025 | 109 |
2442563 | 2442563 | 2022-04-25 | Vernon | Missouri | 29217 | 5051 | 109 |
2439269 | 2439269 | 2022-04-24 | Morgan | Missouri | 29141 | 4025 | 109 |
2439307 | 2439307 | 2022-04-24 | Vernon | Missouri | 29217 | 5051 | 109 |
2436013 | 2436013 | 2022-04-23 | Morgan | Missouri | 29141 | 4025 | 109 |
2436051 | 2436051 | 2022-04-23 | Vernon | Missouri | 29217 | 5051 | 109 |
2432757 | 2432757 | 2022-04-22 | Morgan | Missouri | 29141 | 4025 | 109 |
2432795 | 2432795 | 2022-04-22 | Vernon | Missouri | 29217 | 5051 | 109 |
2429501 | 2429501 | 2022-04-21 | Morgan | Missouri | 29141 | 4025 | 109 |
2429539 | 2429539 | 2022-04-21 | Vernon | Missouri | 29217 | 5051 | 109 |
2426245 | 2426245 | 2022-04-20 | Morgan | Missouri | 29141 | 4025 | 109 |
2426283 | 2426283 | 2022-04-20 | Vernon | Missouri | 29217 | 5051 | 109 |
2422989 | 2422989 | 2022-04-19 | Morgan | Missouri | 29141 | 4025 | 109 |
2423027 | 2423027 | 2022-04-19 | Vernon | Missouri | 29217 | 5051 | 109 |
2419732 | 2419732 | 2022-04-18 | Morgan | Missouri | 29141 | 4025 | 109 |
2419770 | 2419770 | 2022-04-18 | Vernon | Missouri | 29217 | 5051 | 109 |
2416477 | 2416477 | 2022-04-17 | Morgan | Missouri | 29141 | 4025 | 109 |
2416515 | 2416515 | 2022-04-17 | Vernon | Missouri | 29217 | 5051 | 109 |
2413221 | 2413221 | 2022-04-16 | Morgan | Missouri | 29141 | 4025 | 109 |
2413259 | 2413259 | 2022-04-16 | Vernon | Missouri | 29217 | 5051 | 109 |
2409965 | 2409965 | 2022-04-15 | Morgan | Missouri | 29141 | 4025 | 109 |
2410003 | 2410003 | 2022-04-15 | Vernon | Missouri | 29217 | 5051 | 109 |
2406709 | 2406709 | 2022-04-14 | Morgan | Missouri | 29141 | 4025 | 109 |
2406747 | 2406747 | 2022-04-14 | Vernon | Missouri | 29217 | 5051 | 109 |
2403453 | 2403453 | 2022-04-13 | Morgan | Missouri | 29141 | 4025 | 109 |
2403491 | 2403491 | 2022-04-13 | Vernon | Missouri | 29217 | 5051 | 109 |
2400198 | 2400198 | 2022-04-12 | Morgan | Missouri | 29141 | 4025 | 109 |
2400236 | 2400236 | 2022-04-12 | Vernon | Missouri | 29217 | 5051 | 109 |
2396943 | 2396943 | 2022-04-11 | Morgan | Missouri | 29141 | 4025 | 109 |
2396981 | 2396981 | 2022-04-11 | Vernon | Missouri | 29217 | 5051 | 109 |
2393688 | 2393688 | 2022-04-10 | Morgan | Missouri | 29141 | 4025 | 109 |
2393726 | 2393726 | 2022-04-10 | Vernon | Missouri | 29217 | 5051 | 109 |
2390432 | 2390432 | 2022-04-09 | Morgan | Missouri | 29141 | 4025 | 109 |
2390470 | 2390470 | 2022-04-09 | Vernon | Missouri | 29217 | 5051 | 109 |
2387176 | 2387176 | 2022-04-08 | Morgan | Missouri | 29141 | 4025 | 109 |
2387214 | 2387214 | 2022-04-08 | Vernon | Missouri | 29217 | 5051 | 109 |
2383921 | 2383921 | 2022-04-07 | Morgan | Missouri | 29141 | 4025 | 109 |
2383959 | 2383959 | 2022-04-07 | Vernon | Missouri | 29217 | 5051 | 109 |
2380666 | 2380666 | 2022-04-06 | Morgan | Missouri | 29141 | 4025 | 109 |
2380704 | 2380704 | 2022-04-06 | Vernon | Missouri | 29217 | 5051 | 109 |
2377411 | 2377411 | 2022-04-05 | Morgan | Missouri | 29141 | 4025 | 109 |
2377449 | 2377449 | 2022-04-05 | Vernon | Missouri | 29217 | 5051 | 109 |
2374158 | 2374158 | 2022-04-04 | Morgan | Missouri | 29141 | 4025 | 109 |
2374196 | 2374196 | 2022-04-04 | Vernon | Missouri | 29217 | 5051 | 109 |
2370906 | 2370906 | 2022-04-03 | Morgan | Missouri | 29141 | 4025 | 109 |
2370944 | 2370944 | 2022-04-03 | Vernon | Missouri | 29217 | 5051 | 109 |
2367653 | 2367653 | 2022-04-02 | Morgan | Missouri | 29141 | 4025 | 109 |
2367691 | 2367691 | 2022-04-02 | Vernon | Missouri | 29217 | 5051 | 109 |
2364400 | 2364400 | 2022-04-01 | Morgan | Missouri | 29141 | 4025 | 109 |
2364438 | 2364438 | 2022-04-01 | Vernon | Missouri | 29217 | 5051 | 109 |
2361146 | 2361146 | 2022-03-31 | Morgan | Missouri | 29141 | 4025 | 109 |
2361184 | 2361184 | 2022-03-31 | Vernon | Missouri | 29217 | 5051 | 109 |
2357892 | 2357892 | 2022-03-30 | Morgan | Missouri | 29141 | 4025 | 109 |
2357930 | 2357930 | 2022-03-30 | Vernon | Missouri | 29217 | 5049 | 109 |
2354639 | 2354639 | 2022-03-29 | Morgan | Missouri | 29141 | 4024 | 109 |
2351386 | 2351386 | 2022-03-28 | Morgan | Missouri | 29141 | 4022 | 109 |
2348134 | 2348134 | 2022-03-27 | Morgan | Missouri | 29141 | 4020 | 109 |
2344881 | 2344881 | 2022-03-26 | Morgan | Missouri | 29141 | 4020 | 109 |
2341628 | 2341628 | 2022-03-25 | Morgan | Missouri | 29141 | 4020 | 109 |
2338375 | 2338375 | 2022-03-24 | Morgan | Missouri | 29141 | 4018 | 109 |
2335121 | 2335121 | 2022-03-23 | Morgan | Missouri | 29141 | 4014 | 109 |
2331867 | 2331867 | 2022-03-22 | Morgan | Missouri | 29141 | 4015 | 109 |
2305774 | 2305774 | 2022-03-14 | Audrain | Missouri | 29007 | 5699 | 109 |
2302523 | 2302523 | 2022-03-13 | Audrain | Missouri | 29007 | 5698 | 109 |
2299271 | 2299271 | 2022-03-12 | Audrain | Missouri | 29007 | 5698 | 109 |
2296019 | 2296019 | 2022-03-11 | Audrain | Missouri | 29007 | 5698 | 109 |
2292767 | 2292767 | 2022-03-10 | Audrain | Missouri | 29007 | 5698 | 109 |
2289515 | 2289515 | 2022-03-09 | Audrain | Missouri | 29007 | 5687 | 109 |
2244011 | 2244011 | 2022-02-23 | Clinton | Missouri | 29049 | 4669 | 109 |
2240760 | 2240760 | 2022-02-22 | Clinton | Missouri | 29049 | 4664 | 109 |
2237509 | 2237509 | 2022-02-21 | Clinton | Missouri | 29049 | 4648 | 109 |
2234258 | 2234258 | 2022-02-20 | Clinton | Missouri | 29049 | 4648 | 109 |
2231007 | 2231007 | 2022-02-19 | Clinton | Missouri | 29049 | 4648 | 109 |
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);