ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 1, county = "Putnam" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
341699 | 341699 | 2020-07-17 | Putnam | Illinois | 17155 | 1 | 0 |
338503 | 338503 | 2020-07-16 | Putnam | Illinois | 17155 | 1 | 0 |
335307 | 335307 | 2020-07-15 | Putnam | Illinois | 17155 | 1 | 0 |
332114 | 332114 | 2020-07-14 | Putnam | Illinois | 17155 | 1 | 0 |
328927 | 328927 | 2020-07-13 | Putnam | Illinois | 17155 | 1 | 0 |
325741 | 325741 | 2020-07-12 | Putnam | Illinois | 17155 | 1 | 0 |
322560 | 322560 | 2020-07-11 | Putnam | Illinois | 17155 | 1 | 0 |
319381 | 319381 | 2020-07-10 | Putnam | Illinois | 17155 | 1 | 0 |
316208 | 316208 | 2020-07-09 | Putnam | Illinois | 17155 | 1 | 0 |
313034 | 313034 | 2020-07-08 | Putnam | Illinois | 17155 | 1 | 0 |
309864 | 309864 | 2020-07-07 | Putnam | Illinois | 17155 | 1 | 0 |
306696 | 306696 | 2020-07-06 | Putnam | Illinois | 17155 | 1 | 0 |
303531 | 303531 | 2020-07-05 | Putnam | Illinois | 17155 | 1 | 0 |
300367 | 300367 | 2020-07-04 | Putnam | Illinois | 17155 | 1 | 0 |
297205 | 297205 | 2020-07-03 | Putnam | Illinois | 17155 | 1 | 0 |
294048 | 294048 | 2020-07-02 | Putnam | Illinois | 17155 | 1 | 0 |
290894 | 290894 | 2020-07-01 | Putnam | Illinois | 17155 | 1 | 0 |
287744 | 287744 | 2020-06-30 | Putnam | Illinois | 17155 | 1 | 0 |
284595 | 284595 | 2020-06-29 | Putnam | Illinois | 17155 | 1 | 0 |
281450 | 281450 | 2020-06-28 | Putnam | Illinois | 17155 | 1 | 0 |
278302 | 278302 | 2020-06-27 | Putnam | Illinois | 17155 | 1 | 0 |
275154 | 275154 | 2020-06-26 | Putnam | Illinois | 17155 | 1 | 0 |
272012 | 272012 | 2020-06-25 | Putnam | Illinois | 17155 | 1 | 0 |
268875 | 268875 | 2020-06-24 | Putnam | Illinois | 17155 | 1 | 0 |
265745 | 265745 | 2020-06-23 | Putnam | Illinois | 17155 | 1 | 0 |
262617 | 262617 | 2020-06-22 | Putnam | Illinois | 17155 | 1 | 0 |
259490 | 259490 | 2020-06-21 | Putnam | Illinois | 17155 | 1 | 0 |
256364 | 256364 | 2020-06-20 | Putnam | Illinois | 17155 | 1 | 0 |
253244 | 253244 | 2020-06-19 | Putnam | Illinois | 17155 | 1 | 0 |
250129 | 250129 | 2020-06-18 | Putnam | Illinois | 17155 | 1 | 0 |
247017 | 247017 | 2020-06-17 | Putnam | Illinois | 17155 | 1 | 0 |
243904 | 243904 | 2020-06-16 | Putnam | Illinois | 17155 | 1 | 0 |
240793 | 240793 | 2020-06-15 | Putnam | Illinois | 17155 | 1 | 0 |
237685 | 237685 | 2020-06-14 | Putnam | Illinois | 17155 | 1 | 0 |
234578 | 234578 | 2020-06-13 | Putnam | Illinois | 17155 | 1 | 0 |
231472 | 231472 | 2020-06-12 | Putnam | Illinois | 17155 | 1 | 0 |
228369 | 228369 | 2020-06-11 | Putnam | Illinois | 17155 | 1 | 0 |
225267 | 225267 | 2020-06-10 | Putnam | Illinois | 17155 | 1 | 0 |
222172 | 222172 | 2020-06-09 | Putnam | Illinois | 17155 | 1 | 0 |
219077 | 219077 | 2020-06-08 | Putnam | Illinois | 17155 | 1 | 0 |
215986 | 215986 | 2020-06-07 | Putnam | Illinois | 17155 | 1 | 0 |
212899 | 212899 | 2020-06-06 | Putnam | Illinois | 17155 | 1 | 0 |
209814 | 209814 | 2020-06-05 | Putnam | Illinois | 17155 | 1 | 0 |
206733 | 206733 | 2020-06-04 | Putnam | Illinois | 17155 | 1 | 0 |
203653 | 203653 | 2020-06-03 | Putnam | Illinois | 17155 | 1 | 0 |
200577 | 200577 | 2020-06-02 | Putnam | Illinois | 17155 | 1 | 0 |
197504 | 197504 | 2020-06-01 | Putnam | Illinois | 17155 | 1 | 0 |
194434 | 194434 | 2020-05-31 | Putnam | Illinois | 17155 | 1 | 0 |
191367 | 191367 | 2020-05-30 | Putnam | Illinois | 17155 | 1 | 0 |
188302 | 188302 | 2020-05-29 | Putnam | Illinois | 17155 | 1 | 0 |
185244 | 185244 | 2020-05-28 | Putnam | Illinois | 17155 | 1 | 0 |
182190 | 182190 | 2020-05-27 | Putnam | Illinois | 17155 | 1 | 0 |
179146 | 179146 | 2020-05-26 | Putnam | Illinois | 17155 | 1 | 0 |
176102 | 176102 | 2020-05-25 | Putnam | Illinois | 17155 | 1 | 0 |
173058 | 173058 | 2020-05-24 | Putnam | Illinois | 17155 | 1 | 0 |
170017 | 170017 | 2020-05-23 | Putnam | Illinois | 17155 | 1 | 0 |
166980 | 166980 | 2020-05-22 | Putnam | Illinois | 17155 | 1 | 0 |
163947 | 163947 | 2020-05-21 | Putnam | Illinois | 17155 | 1 | 0 |
160919 | 160919 | 2020-05-20 | Putnam | Illinois | 17155 | 1 | 0 |
157893 | 157893 | 2020-05-19 | Putnam | Illinois | 17155 | 1 | 0 |
154877 | 154877 | 2020-05-18 | Putnam | Illinois | 17155 | 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);