ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where deaths = 43, fips = 19139 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
269061 | 269061 | 2020-06-24 | Muscatine | Iowa | 19139 | 595 | 43 |
265931 | 265931 | 2020-06-23 | Muscatine | Iowa | 19139 | 590 | 43 |
262803 | 262803 | 2020-06-22 | Muscatine | Iowa | 19139 | 586 | 43 |
259676 | 259676 | 2020-06-21 | Muscatine | Iowa | 19139 | 584 | 43 |
256550 | 256550 | 2020-06-20 | Muscatine | Iowa | 19139 | 581 | 43 |
253430 | 253430 | 2020-06-19 | Muscatine | Iowa | 19139 | 581 | 43 |
250315 | 250315 | 2020-06-18 | Muscatine | Iowa | 19139 | 578 | 43 |
247203 | 247203 | 2020-06-17 | Muscatine | Iowa | 19139 | 577 | 43 |
244090 | 244090 | 2020-06-16 | Muscatine | Iowa | 19139 | 573 | 43 |
240979 | 240979 | 2020-06-15 | Muscatine | Iowa | 19139 | 574 | 43 |
237871 | 237871 | 2020-06-14 | Muscatine | Iowa | 19139 | 574 | 43 |
234764 | 234764 | 2020-06-13 | Muscatine | Iowa | 19139 | 574 | 43 |
231658 | 231658 | 2020-06-12 | Muscatine | Iowa | 19139 | 572 | 43 |
228555 | 228555 | 2020-06-11 | Muscatine | Iowa | 19139 | 569 | 43 |
225453 | 225453 | 2020-06-10 | Muscatine | Iowa | 19139 | 569 | 43 |
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);