ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
725 rows where fips = 19159 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281646 | 281646 | 2020-06-28 | Ringgold | Iowa | 19159 | 13 | 0 |
278498 | 278498 | 2020-06-27 | Ringgold | Iowa | 19159 | 13 | 0 |
275350 | 275350 | 2020-06-26 | Ringgold | Iowa | 19159 | 12 | 0 |
272208 | 272208 | 2020-06-25 | Ringgold | Iowa | 19159 | 12 | 0 |
269071 | 269071 | 2020-06-24 | Ringgold | Iowa | 19159 | 12 | 0 |
265941 | 265941 | 2020-06-23 | Ringgold | Iowa | 19159 | 12 | 0 |
262813 | 262813 | 2020-06-22 | Ringgold | Iowa | 19159 | 11 | 0 |
259686 | 259686 | 2020-06-21 | Ringgold | Iowa | 19159 | 11 | 0 |
256560 | 256560 | 2020-06-20 | Ringgold | Iowa | 19159 | 11 | 0 |
253440 | 253440 | 2020-06-19 | Ringgold | Iowa | 19159 | 11 | 0 |
250325 | 250325 | 2020-06-18 | Ringgold | Iowa | 19159 | 10 | 0 |
247213 | 247213 | 2020-06-17 | Ringgold | Iowa | 19159 | 10 | 0 |
244100 | 244100 | 2020-06-16 | Ringgold | Iowa | 19159 | 9 | 0 |
240989 | 240989 | 2020-06-15 | Ringgold | Iowa | 19159 | 8 | 0 |
237881 | 237881 | 2020-06-14 | Ringgold | Iowa | 19159 | 8 | 0 |
234774 | 234774 | 2020-06-13 | Ringgold | Iowa | 19159 | 8 | 0 |
231668 | 231668 | 2020-06-12 | Ringgold | Iowa | 19159 | 8 | 0 |
228565 | 228565 | 2020-06-11 | Ringgold | Iowa | 19159 | 8 | 0 |
225463 | 225463 | 2020-06-10 | Ringgold | Iowa | 19159 | 7 | 0 |
222368 | 222368 | 2020-06-09 | Ringgold | Iowa | 19159 | 6 | 0 |
219273 | 219273 | 2020-06-08 | Ringgold | Iowa | 19159 | 6 | 0 |
216181 | 216181 | 2020-06-07 | Ringgold | Iowa | 19159 | 4 | 0 |
213094 | 213094 | 2020-06-06 | Ringgold | Iowa | 19159 | 4 | 0 |
210009 | 210009 | 2020-06-05 | Ringgold | Iowa | 19159 | 4 | 0 |
206928 | 206928 | 2020-06-04 | Ringgold | Iowa | 19159 | 4 | 0 |
203848 | 203848 | 2020-06-03 | Ringgold | Iowa | 19159 | 4 | 0 |
200772 | 200772 | 2020-06-02 | Ringgold | Iowa | 19159 | 4 | 0 |
197699 | 197699 | 2020-06-01 | Ringgold | Iowa | 19159 | 4 | 0 |
194629 | 194629 | 2020-05-31 | Ringgold | Iowa | 19159 | 4 | 0 |
191562 | 191562 | 2020-05-30 | Ringgold | Iowa | 19159 | 4 | 0 |
188497 | 188497 | 2020-05-29 | Ringgold | Iowa | 19159 | 4 | 0 |
185439 | 185439 | 2020-05-28 | Ringgold | Iowa | 19159 | 4 | 0 |
182385 | 182385 | 2020-05-27 | Ringgold | Iowa | 19159 | 4 | 0 |
179340 | 179340 | 2020-05-26 | Ringgold | Iowa | 19159 | 4 | 0 |
176296 | 176296 | 2020-05-25 | Ringgold | Iowa | 19159 | 4 | 0 |
173252 | 173252 | 2020-05-24 | Ringgold | Iowa | 19159 | 4 | 0 |
170211 | 170211 | 2020-05-23 | Ringgold | Iowa | 19159 | 2 | 0 |
167174 | 167174 | 2020-05-22 | Ringgold | Iowa | 19159 | 2 | 0 |
164141 | 164141 | 2020-05-21 | Ringgold | Iowa | 19159 | 1 | 0 |
161113 | 161113 | 2020-05-20 | Ringgold | Iowa | 19159 | 1 | 0 |
158087 | 158087 | 2020-05-19 | Ringgold | Iowa | 19159 | 1 | 0 |
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);