ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
264 rows where deaths = 79 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471789 | 2471789 | 2022-05-04 | Douglas | Missouri | 29067 | 2550 | 79 |
2468533 | 2468533 | 2022-05-03 | Douglas | Missouri | 29067 | 2550 | 79 |
2465277 | 2465277 | 2022-05-02 | Douglas | Missouri | 29067 | 2550 | 79 |
2462022 | 2462022 | 2022-05-01 | Douglas | Missouri | 29067 | 2550 | 79 |
2458766 | 2458766 | 2022-04-30 | Douglas | Missouri | 29067 | 2550 | 79 |
2455510 | 2455510 | 2022-04-29 | Douglas | Missouri | 29067 | 2550 | 79 |
2452254 | 2452254 | 2022-04-28 | Douglas | Missouri | 29067 | 2550 | 79 |
2448998 | 2448998 | 2022-04-27 | Douglas | Missouri | 29067 | 2550 | 79 |
2445741 | 2445741 | 2022-04-26 | Douglas | Missouri | 29067 | 2550 | 79 |
2442486 | 2442486 | 2022-04-25 | Douglas | Missouri | 29067 | 2550 | 79 |
2439230 | 2439230 | 2022-04-24 | Douglas | Missouri | 29067 | 2550 | 79 |
2435974 | 2435974 | 2022-04-23 | Douglas | Missouri | 29067 | 2550 | 79 |
2432718 | 2432718 | 2022-04-22 | Douglas | Missouri | 29067 | 2550 | 79 |
2429462 | 2429462 | 2022-04-21 | Douglas | Missouri | 29067 | 2550 | 79 |
2426206 | 2426206 | 2022-04-20 | Douglas | Missouri | 29067 | 2550 | 79 |
2422950 | 2422950 | 2022-04-19 | Douglas | Missouri | 29067 | 2550 | 79 |
2419693 | 2419693 | 2022-04-18 | Douglas | Missouri | 29067 | 2550 | 79 |
2416438 | 2416438 | 2022-04-17 | Douglas | Missouri | 29067 | 2550 | 79 |
2413182 | 2413182 | 2022-04-16 | Douglas | Missouri | 29067 | 2550 | 79 |
2409926 | 2409926 | 2022-04-15 | Douglas | Missouri | 29067 | 2550 | 79 |
2406670 | 2406670 | 2022-04-14 | Douglas | Missouri | 29067 | 2550 | 79 |
2403414 | 2403414 | 2022-04-13 | Douglas | Missouri | 29067 | 2550 | 79 |
2400159 | 2400159 | 2022-04-12 | Douglas | Missouri | 29067 | 2550 | 79 |
2396904 | 2396904 | 2022-04-11 | Douglas | Missouri | 29067 | 2550 | 79 |
2393649 | 2393649 | 2022-04-10 | Douglas | Missouri | 29067 | 2550 | 79 |
2390393 | 2390393 | 2022-04-09 | Douglas | Missouri | 29067 | 2550 | 79 |
2387137 | 2387137 | 2022-04-08 | Douglas | Missouri | 29067 | 2550 | 79 |
2383882 | 2383882 | 2022-04-07 | Douglas | Missouri | 29067 | 2550 | 79 |
2380627 | 2380627 | 2022-04-06 | Douglas | Missouri | 29067 | 2550 | 79 |
2377372 | 2377372 | 2022-04-05 | Douglas | Missouri | 29067 | 2550 | 79 |
2374119 | 2374119 | 2022-04-04 | Douglas | Missouri | 29067 | 2550 | 79 |
2370867 | 2370867 | 2022-04-03 | Douglas | Missouri | 29067 | 2550 | 79 |
2367614 | 2367614 | 2022-04-02 | Douglas | Missouri | 29067 | 2550 | 79 |
2364361 | 2364361 | 2022-04-01 | Douglas | Missouri | 29067 | 2550 | 79 |
2361107 | 2361107 | 2022-03-31 | Douglas | Missouri | 29067 | 2550 | 79 |
2357853 | 2357853 | 2022-03-30 | Douglas | Missouri | 29067 | 2550 | 79 |
2354600 | 2354600 | 2022-03-29 | Douglas | Missouri | 29067 | 2549 | 79 |
2351347 | 2351347 | 2022-03-28 | Douglas | Missouri | 29067 | 2549 | 79 |
2348095 | 2348095 | 2022-03-27 | Douglas | Missouri | 29067 | 2549 | 79 |
2344842 | 2344842 | 2022-03-26 | Douglas | Missouri | 29067 | 2549 | 79 |
2341589 | 2341589 | 2022-03-25 | Douglas | Missouri | 29067 | 2549 | 79 |
2338336 | 2338336 | 2022-03-24 | Douglas | Missouri | 29067 | 2549 | 79 |
2335082 | 2335082 | 2022-03-23 | Douglas | Missouri | 29067 | 2547 | 79 |
2331828 | 2331828 | 2022-03-22 | Douglas | Missouri | 29067 | 2545 | 79 |
2328574 | 2328574 | 2022-03-21 | Dent | Missouri | 29065 | 3252 | 79 |
2325322 | 2325322 | 2022-03-20 | Dent | Missouri | 29065 | 3247 | 79 |
2322068 | 2322068 | 2022-03-19 | Dent | Missouri | 29065 | 3247 | 79 |
2318814 | 2318814 | 2022-03-18 | Dent | Missouri | 29065 | 3247 | 79 |
2315561 | 2315561 | 2022-03-17 | Dent | Missouri | 29065 | 3243 | 79 |
2312308 | 2312308 | 2022-03-16 | Dent | Missouri | 29065 | 3243 | 79 |
2309055 | 2309055 | 2022-03-15 | Dent | Missouri | 29065 | 3242 | 79 |
2305887 | 2305887 | 2022-03-14 | Wright | Missouri | 29229 | 3823 | 79 |
2302636 | 2302636 | 2022-03-13 | Wright | Missouri | 29229 | 3823 | 79 |
2299384 | 2299384 | 2022-03-12 | Wright | Missouri | 29229 | 3823 | 79 |
2296132 | 2296132 | 2022-03-11 | Wright | Missouri | 29229 | 3823 | 79 |
2292880 | 2292880 | 2022-03-10 | Wright | Missouri | 29229 | 3821 | 79 |
2289628 | 2289628 | 2022-03-09 | Wright | Missouri | 29229 | 3821 | 79 |
2286376 | 2286376 | 2022-03-08 | Wright | Missouri | 29229 | 3817 | 79 |
2260315 | 2260315 | 2022-02-28 | New Madrid | Missouri | 29143 | 4995 | 79 |
2257064 | 2257064 | 2022-02-27 | New Madrid | Missouri | 29143 | 4994 | 79 |
2253813 | 2253813 | 2022-02-26 | New Madrid | Missouri | 29143 | 4994 | 79 |
2250562 | 2250562 | 2022-02-25 | New Madrid | Missouri | 29143 | 4994 | 79 |
2247311 | 2247311 | 2022-02-24 | New Madrid | Missouri | 29143 | 4993 | 79 |
2221236 | 2221236 | 2022-02-16 | Bates | Missouri | 29013 | 3693 | 79 |
2217985 | 2217985 | 2022-02-15 | Bates | Missouri | 29013 | 3689 | 79 |
2169296 | 2169296 | 2022-01-31 | Texas | Missouri | 29215 | 4327 | 79 |
2166041 | 2166041 | 2022-01-30 | Texas | Missouri | 29215 | 4320 | 79 |
2162786 | 2162786 | 2022-01-29 | Texas | Missouri | 29215 | 4312 | 79 |
2159531 | 2159531 | 2022-01-28 | Texas | Missouri | 29215 | 4280 | 79 |
2156277 | 2156277 | 2022-01-27 | Texas | Missouri | 29215 | 4251 | 79 |
2153024 | 2153024 | 2022-01-26 | Texas | Missouri | 29215 | 4200 | 79 |
2149772 | 2149772 | 2022-01-25 | Texas | Missouri | 29215 | 4163 | 79 |
2146520 | 2146520 | 2022-01-24 | Texas | Missouri | 29215 | 4111 | 79 |
2143265 | 2143265 | 2022-01-23 | Texas | Missouri | 29215 | 4091 | 79 |
2140010 | 2140010 | 2022-01-22 | Texas | Missouri | 29215 | 4070 | 79 |
2136754 | 2136754 | 2022-01-21 | Texas | Missouri | 29215 | 4045 | 79 |
2133400 | 2133400 | 2022-01-20 | Benton | Missouri | 29015 | 3479 | 79 |
2130147 | 2130147 | 2022-01-19 | Benton | Missouri | 29015 | 3434 | 79 |
2126958 | 2126958 | 2022-01-18 | Morgan | Missouri | 29141 | 3452 | 79 |
2123706 | 2123706 | 2022-01-17 | Morgan | Missouri | 29141 | 3362 | 79 |
2120454 | 2120454 | 2022-01-16 | Morgan | Missouri | 29141 | 3362 | 79 |
2117202 | 2117202 | 2022-01-15 | Morgan | Missouri | 29141 | 3362 | 79 |
2113951 | 2113951 | 2022-01-14 | Morgan | Missouri | 29141 | 3317 | 79 |
2110699 | 2110699 | 2022-01-13 | Morgan | Missouri | 29141 | 3297 | 79 |
2107448 | 2107448 | 2022-01-12 | Morgan | Missouri | 29141 | 3270 | 79 |
2100985 | 2100985 | 2022-01-10 | Warren | Missouri | 29219 | 6667 | 79 |
2097734 | 2097734 | 2022-01-09 | Warren | Missouri | 29219 | 6617 | 79 |
2094482 | 2094482 | 2022-01-08 | Warren | Missouri | 29219 | 6539 | 79 |
2091230 | 2091230 | 2022-01-07 | Warren | Missouri | 29219 | 6451 | 79 |
2032671 | 2032671 | 2021-12-20 | Livingston | Missouri | 29117 | 2758 | 79 |
2029420 | 2029420 | 2021-12-19 | Livingston | Missouri | 29117 | 2756 | 79 |
2026169 | 2026169 | 2021-12-18 | Livingston | Missouri | 29117 | 2754 | 79 |
2022918 | 2022918 | 2021-12-17 | Livingston | Missouri | 29117 | 2745 | 79 |
2019667 | 2019667 | 2021-12-16 | Livingston | Missouri | 29117 | 2732 | 79 |
2016417 | 2016417 | 2021-12-15 | Livingston | Missouri | 29117 | 2729 | 79 |
2013166 | 2013166 | 2021-12-14 | Livingston | Missouri | 29117 | 2724 | 79 |
2009858 | 2009858 | 2021-12-13 | Audrain | Missouri | 29007 | 4274 | 79 |
2009915 | 2009915 | 2021-12-13 | Livingston | Missouri | 29117 | 2723 | 79 |
2006607 | 2006607 | 2021-12-12 | Audrain | Missouri | 29007 | 4272 | 79 |
2006664 | 2006664 | 2021-12-12 | Livingston | Missouri | 29117 | 2722 | 79 |
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);