ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
728 rows where county = "Putnam" and state = "Illinois" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
148856 | 148856 | 2020-05-16 | Putnam | Illinois | 17155 | 2 | 0 |
151865 | 151865 | 2020-05-17 | Putnam | Illinois | 17155 | 2 | 0 |
154877 | 154877 | 2020-05-18 | Putnam | Illinois | 17155 | 1 | 0 |
157893 | 157893 | 2020-05-19 | Putnam | Illinois | 17155 | 1 | 0 |
160919 | 160919 | 2020-05-20 | Putnam | Illinois | 17155 | 1 | 0 |
163947 | 163947 | 2020-05-21 | Putnam | Illinois | 17155 | 1 | 0 |
166980 | 166980 | 2020-05-22 | Putnam | Illinois | 17155 | 1 | 0 |
170017 | 170017 | 2020-05-23 | Putnam | Illinois | 17155 | 1 | 0 |
173058 | 173058 | 2020-05-24 | Putnam | Illinois | 17155 | 1 | 0 |
176102 | 176102 | 2020-05-25 | Putnam | Illinois | 17155 | 1 | 0 |
179146 | 179146 | 2020-05-26 | Putnam | Illinois | 17155 | 1 | 0 |
182190 | 182190 | 2020-05-27 | Putnam | Illinois | 17155 | 1 | 0 |
185244 | 185244 | 2020-05-28 | Putnam | Illinois | 17155 | 1 | 0 |
188302 | 188302 | 2020-05-29 | Putnam | Illinois | 17155 | 1 | 0 |
191367 | 191367 | 2020-05-30 | Putnam | Illinois | 17155 | 1 | 0 |
194434 | 194434 | 2020-05-31 | Putnam | Illinois | 17155 | 1 | 0 |
197504 | 197504 | 2020-06-01 | Putnam | Illinois | 17155 | 1 | 0 |
200577 | 200577 | 2020-06-02 | Putnam | Illinois | 17155 | 1 | 0 |
203653 | 203653 | 2020-06-03 | Putnam | Illinois | 17155 | 1 | 0 |
206733 | 206733 | 2020-06-04 | Putnam | Illinois | 17155 | 1 | 0 |
209814 | 209814 | 2020-06-05 | Putnam | Illinois | 17155 | 1 | 0 |
212899 | 212899 | 2020-06-06 | Putnam | Illinois | 17155 | 1 | 0 |
215986 | 215986 | 2020-06-07 | Putnam | Illinois | 17155 | 1 | 0 |
219077 | 219077 | 2020-06-08 | Putnam | Illinois | 17155 | 1 | 0 |
222172 | 222172 | 2020-06-09 | Putnam | Illinois | 17155 | 1 | 0 |
225267 | 225267 | 2020-06-10 | Putnam | Illinois | 17155 | 1 | 0 |
228369 | 228369 | 2020-06-11 | Putnam | Illinois | 17155 | 1 | 0 |
231472 | 231472 | 2020-06-12 | Putnam | Illinois | 17155 | 1 | 0 |
234578 | 234578 | 2020-06-13 | Putnam | Illinois | 17155 | 1 | 0 |
237685 | 237685 | 2020-06-14 | Putnam | Illinois | 17155 | 1 | 0 |
240793 | 240793 | 2020-06-15 | Putnam | Illinois | 17155 | 1 | 0 |
243904 | 243904 | 2020-06-16 | Putnam | Illinois | 17155 | 1 | 0 |
247017 | 247017 | 2020-06-17 | Putnam | Illinois | 17155 | 1 | 0 |
250129 | 250129 | 2020-06-18 | Putnam | Illinois | 17155 | 1 | 0 |
253244 | 253244 | 2020-06-19 | Putnam | Illinois | 17155 | 1 | 0 |
256364 | 256364 | 2020-06-20 | Putnam | Illinois | 17155 | 1 | 0 |
259490 | 259490 | 2020-06-21 | Putnam | Illinois | 17155 | 1 | 0 |
262617 | 262617 | 2020-06-22 | Putnam | Illinois | 17155 | 1 | 0 |
265745 | 265745 | 2020-06-23 | Putnam | Illinois | 17155 | 1 | 0 |
268875 | 268875 | 2020-06-24 | Putnam | Illinois | 17155 | 1 | 0 |
272012 | 272012 | 2020-06-25 | Putnam | Illinois | 17155 | 1 | 0 |
275154 | 275154 | 2020-06-26 | Putnam | Illinois | 17155 | 1 | 0 |
278302 | 278302 | 2020-06-27 | Putnam | Illinois | 17155 | 1 | 0 |
281450 | 281450 | 2020-06-28 | Putnam | Illinois | 17155 | 1 | 0 |
284595 | 284595 | 2020-06-29 | Putnam | Illinois | 17155 | 1 | 0 |
287744 | 287744 | 2020-06-30 | Putnam | Illinois | 17155 | 1 | 0 |
290894 | 290894 | 2020-07-01 | Putnam | Illinois | 17155 | 1 | 0 |
294048 | 294048 | 2020-07-02 | Putnam | Illinois | 17155 | 1 | 0 |
297205 | 297205 | 2020-07-03 | Putnam | Illinois | 17155 | 1 | 0 |
300367 | 300367 | 2020-07-04 | Putnam | Illinois | 17155 | 1 | 0 |
303531 | 303531 | 2020-07-05 | Putnam | Illinois | 17155 | 1 | 0 |
306696 | 306696 | 2020-07-06 | Putnam | Illinois | 17155 | 1 | 0 |
309864 | 309864 | 2020-07-07 | Putnam | Illinois | 17155 | 1 | 0 |
313034 | 313034 | 2020-07-08 | Putnam | Illinois | 17155 | 1 | 0 |
316208 | 316208 | 2020-07-09 | Putnam | Illinois | 17155 | 1 | 0 |
319381 | 319381 | 2020-07-10 | Putnam | Illinois | 17155 | 1 | 0 |
322560 | 322560 | 2020-07-11 | Putnam | Illinois | 17155 | 1 | 0 |
325741 | 325741 | 2020-07-12 | Putnam | Illinois | 17155 | 1 | 0 |
328927 | 328927 | 2020-07-13 | Putnam | Illinois | 17155 | 1 | 0 |
332114 | 332114 | 2020-07-14 | Putnam | Illinois | 17155 | 1 | 0 |
335307 | 335307 | 2020-07-15 | Putnam | Illinois | 17155 | 1 | 0 |
338503 | 338503 | 2020-07-16 | Putnam | Illinois | 17155 | 1 | 0 |
341699 | 341699 | 2020-07-17 | Putnam | Illinois | 17155 | 1 | 0 |
344899 | 344899 | 2020-07-18 | Putnam | Illinois | 17155 | 2 | 0 |
348100 | 348100 | 2020-07-19 | Putnam | Illinois | 17155 | 2 | 0 |
351300 | 351300 | 2020-07-20 | Putnam | Illinois | 17155 | 2 | 0 |
354502 | 354502 | 2020-07-21 | Putnam | Illinois | 17155 | 3 | 0 |
357704 | 357704 | 2020-07-22 | Putnam | Illinois | 17155 | 3 | 0 |
360909 | 360909 | 2020-07-23 | Putnam | Illinois | 17155 | 4 | 0 |
364116 | 364116 | 2020-07-24 | Putnam | Illinois | 17155 | 6 | 0 |
367323 | 367323 | 2020-07-25 | Putnam | Illinois | 17155 | 7 | 0 |
370533 | 370533 | 2020-07-26 | Putnam | Illinois | 17155 | 7 | 0 |
373745 | 373745 | 2020-07-27 | Putnam | Illinois | 17155 | 8 | 0 |
376960 | 376960 | 2020-07-28 | Putnam | Illinois | 17155 | 7 | 0 |
380177 | 380177 | 2020-07-29 | Putnam | Illinois | 17155 | 7 | 0 |
383394 | 383394 | 2020-07-30 | Putnam | Illinois | 17155 | 7 | 0 |
386612 | 386612 | 2020-07-31 | Putnam | Illinois | 17155 | 7 | 0 |
389829 | 389829 | 2020-08-01 | Putnam | Illinois | 17155 | 7 | 0 |
393046 | 393046 | 2020-08-02 | Putnam | Illinois | 17155 | 7 | 0 |
396262 | 396262 | 2020-08-03 | Putnam | Illinois | 17155 | 8 | 0 |
399478 | 399478 | 2020-08-04 | Putnam | Illinois | 17155 | 9 | 0 |
402694 | 402694 | 2020-08-05 | Putnam | Illinois | 17155 | 9 | 0 |
405912 | 405912 | 2020-08-06 | Putnam | Illinois | 17155 | 11 | 0 |
409132 | 409132 | 2020-08-07 | Putnam | Illinois | 17155 | 11 | 0 |
412351 | 412351 | 2020-08-08 | Putnam | Illinois | 17155 | 11 | 0 |
415571 | 415571 | 2020-08-09 | Putnam | Illinois | 17155 | 13 | 0 |
418792 | 418792 | 2020-08-10 | Putnam | Illinois | 17155 | 13 | 0 |
422015 | 422015 | 2020-08-11 | Putnam | Illinois | 17155 | 14 | 0 |
425236 | 425236 | 2020-08-12 | Putnam | Illinois | 17155 | 14 | 0 |
428460 | 428460 | 2020-08-13 | Putnam | Illinois | 17155 | 13 | 0 |
431688 | 431688 | 2020-08-14 | Putnam | Illinois | 17155 | 13 | 0 |
434913 | 434913 | 2020-08-15 | Putnam | Illinois | 17155 | 13 | 0 |
438139 | 438139 | 2020-08-16 | Putnam | Illinois | 17155 | 13 | 0 |
441365 | 441365 | 2020-08-17 | Putnam | Illinois | 17155 | 13 | 0 |
444591 | 444591 | 2020-08-18 | Putnam | Illinois | 17155 | 13 | 0 |
447818 | 447818 | 2020-08-19 | Putnam | Illinois | 17155 | 13 | 0 |
451046 | 451046 | 2020-08-20 | Putnam | Illinois | 17155 | 13 | 0 |
454274 | 454274 | 2020-08-21 | Putnam | Illinois | 17155 | 13 | 0 |
457502 | 457502 | 2020-08-22 | Putnam | Illinois | 17155 | 13 | 0 |
460729 | 460729 | 2020-08-23 | Putnam | Illinois | 17155 | 13 | 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);