ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "Douglas", deaths = 79 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 |
---|---|---|---|---|---|---|---|
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 |
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);