ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
753 rows where fips = 17069 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535055 | 535055 | 2020-09-15 | Hardin | Illinois | 17069 | 27 | 0 |
531820 | 531820 | 2020-09-14 | Hardin | Illinois | 17069 | 26 | 0 |
528583 | 528583 | 2020-09-13 | Hardin | Illinois | 17069 | 26 | 0 |
525347 | 525347 | 2020-09-12 | Hardin | Illinois | 17069 | 25 | 0 |
522111 | 522111 | 2020-09-11 | Hardin | Illinois | 17069 | 24 | 0 |
518874 | 518874 | 2020-09-10 | Hardin | Illinois | 17069 | 24 | 0 |
515639 | 515639 | 2020-09-09 | Hardin | Illinois | 17069 | 23 | 0 |
512406 | 512406 | 2020-09-08 | Hardin | Illinois | 17069 | 22 | 0 |
509173 | 509173 | 2020-09-07 | Hardin | Illinois | 17069 | 22 | 0 |
505941 | 505941 | 2020-09-06 | Hardin | Illinois | 17069 | 21 | 0 |
502707 | 502707 | 2020-09-05 | Hardin | Illinois | 17069 | 21 | 0 |
499473 | 499473 | 2020-09-04 | Hardin | Illinois | 17069 | 20 | 0 |
496240 | 496240 | 2020-09-03 | Hardin | Illinois | 17069 | 20 | 0 |
493006 | 493006 | 2020-09-02 | Hardin | Illinois | 17069 | 20 | 0 |
489773 | 489773 | 2020-09-01 | Hardin | Illinois | 17069 | 19 | 0 |
486540 | 486540 | 2020-08-31 | Hardin | Illinois | 17069 | 18 | 0 |
483305 | 483305 | 2020-08-30 | Hardin | Illinois | 17069 | 18 | 0 |
480071 | 480071 | 2020-08-29 | Hardin | Illinois | 17069 | 18 | 0 |
476838 | 476838 | 2020-08-28 | Hardin | Illinois | 17069 | 18 | 0 |
473605 | 473605 | 2020-08-27 | Hardin | Illinois | 17069 | 18 | 0 |
470373 | 470373 | 2020-08-26 | Hardin | Illinois | 17069 | 18 | 0 |
467144 | 467144 | 2020-08-25 | Hardin | Illinois | 17069 | 18 | 0 |
463915 | 463915 | 2020-08-24 | Hardin | Illinois | 17069 | 18 | 0 |
460686 | 460686 | 2020-08-23 | Hardin | Illinois | 17069 | 18 | 0 |
457459 | 457459 | 2020-08-22 | Hardin | Illinois | 17069 | 18 | 0 |
454231 | 454231 | 2020-08-21 | Hardin | Illinois | 17069 | 18 | 0 |
451003 | 451003 | 2020-08-20 | Hardin | Illinois | 17069 | 18 | 0 |
447775 | 447775 | 2020-08-19 | Hardin | Illinois | 17069 | 18 | 0 |
444548 | 444548 | 2020-08-18 | Hardin | Illinois | 17069 | 18 | 0 |
441322 | 441322 | 2020-08-17 | Hardin | Illinois | 17069 | 18 | 0 |
438096 | 438096 | 2020-08-16 | Hardin | Illinois | 17069 | 18 | 0 |
434870 | 434870 | 2020-08-15 | Hardin | Illinois | 17069 | 18 | 0 |
431645 | 431645 | 2020-08-14 | Hardin | Illinois | 17069 | 18 | 0 |
428417 | 428417 | 2020-08-13 | Hardin | Illinois | 17069 | 18 | 0 |
425193 | 425193 | 2020-08-12 | Hardin | Illinois | 17069 | 18 | 0 |
421972 | 421972 | 2020-08-11 | Hardin | Illinois | 17069 | 18 | 0 |
418749 | 418749 | 2020-08-10 | Hardin | Illinois | 17069 | 18 | 0 |
415528 | 415528 | 2020-08-09 | Hardin | Illinois | 17069 | 18 | 0 |
412308 | 412308 | 2020-08-08 | Hardin | Illinois | 17069 | 18 | 0 |
409089 | 409089 | 2020-08-07 | Hardin | Illinois | 17069 | 18 | 0 |
405869 | 405869 | 2020-08-06 | Hardin | Illinois | 17069 | 18 | 0 |
402651 | 402651 | 2020-08-05 | Hardin | Illinois | 17069 | 17 | 0 |
399435 | 399435 | 2020-08-04 | Hardin | Illinois | 17069 | 17 | 0 |
396219 | 396219 | 2020-08-03 | Hardin | Illinois | 17069 | 17 | 0 |
393003 | 393003 | 2020-08-02 | Hardin | Illinois | 17069 | 17 | 0 |
389786 | 389786 | 2020-08-01 | Hardin | Illinois | 17069 | 16 | 0 |
386569 | 386569 | 2020-07-31 | Hardin | Illinois | 17069 | 16 | 0 |
383351 | 383351 | 2020-07-30 | Hardin | Illinois | 17069 | 16 | 0 |
380134 | 380134 | 2020-07-29 | Hardin | Illinois | 17069 | 16 | 0 |
376917 | 376917 | 2020-07-28 | Hardin | Illinois | 17069 | 16 | 0 |
373702 | 373702 | 2020-07-27 | Hardin | Illinois | 17069 | 16 | 0 |
370490 | 370490 | 2020-07-26 | Hardin | Illinois | 17069 | 14 | 0 |
367280 | 367280 | 2020-07-25 | Hardin | Illinois | 17069 | 9 | 0 |
364073 | 364073 | 2020-07-24 | Hardin | Illinois | 17069 | 9 | 0 |
360866 | 360866 | 2020-07-23 | Hardin | Illinois | 17069 | 9 | 0 |
357661 | 357661 | 2020-07-22 | Hardin | Illinois | 17069 | 9 | 0 |
354459 | 354459 | 2020-07-21 | Hardin | Illinois | 17069 | 7 | 0 |
351257 | 351257 | 2020-07-20 | Hardin | Illinois | 17069 | 6 | 0 |
348057 | 348057 | 2020-07-19 | Hardin | Illinois | 17069 | 5 | 0 |
344856 | 344856 | 2020-07-18 | Hardin | Illinois | 17069 | 5 | 0 |
341656 | 341656 | 2020-07-17 | Hardin | Illinois | 17069 | 5 | 0 |
338460 | 338460 | 2020-07-16 | Hardin | Illinois | 17069 | 3 | 0 |
335264 | 335264 | 2020-07-15 | Hardin | Illinois | 17069 | 2 | 0 |
332071 | 332071 | 2020-07-14 | Hardin | Illinois | 17069 | 1 | 0 |
328884 | 328884 | 2020-07-13 | Hardin | Illinois | 17069 | 1 | 0 |
325698 | 325698 | 2020-07-12 | Hardin | Illinois | 17069 | 1 | 0 |
322517 | 322517 | 2020-07-11 | Hardin | Illinois | 17069 | 2 | 0 |
319338 | 319338 | 2020-07-10 | Hardin | Illinois | 17069 | 2 | 0 |
316165 | 316165 | 2020-07-09 | Hardin | Illinois | 17069 | 1 | 0 |
312991 | 312991 | 2020-07-08 | Hardin | Illinois | 17069 | 1 | 0 |
309821 | 309821 | 2020-07-07 | Hardin | Illinois | 17069 | 1 | 0 |
306653 | 306653 | 2020-07-06 | Hardin | Illinois | 17069 | 1 | 0 |
303488 | 303488 | 2020-07-05 | Hardin | Illinois | 17069 | 1 | 0 |
300324 | 300324 | 2020-07-04 | Hardin | Illinois | 17069 | 1 | 0 |
297162 | 297162 | 2020-07-03 | Hardin | Illinois | 17069 | 1 | 0 |
294005 | 294005 | 2020-07-02 | Hardin | Illinois | 17069 | 1 | 0 |
290851 | 290851 | 2020-07-01 | Hardin | Illinois | 17069 | 1 | 0 |
287701 | 287701 | 2020-06-30 | Hardin | Illinois | 17069 | 1 | 0 |
284552 | 284552 | 2020-06-29 | Hardin | Illinois | 17069 | 1 | 0 |
281407 | 281407 | 2020-06-28 | Hardin | Illinois | 17069 | 1 | 0 |
278259 | 278259 | 2020-06-27 | Hardin | Illinois | 17069 | 1 | 0 |
275111 | 275111 | 2020-06-26 | Hardin | Illinois | 17069 | 1 | 0 |
271969 | 271969 | 2020-06-25 | Hardin | Illinois | 17069 | 1 | 0 |
268832 | 268832 | 2020-06-24 | Hardin | Illinois | 17069 | 1 | 0 |
265702 | 265702 | 2020-06-23 | Hardin | Illinois | 17069 | 1 | 0 |
262574 | 262574 | 2020-06-22 | Hardin | Illinois | 17069 | 1 | 0 |
259447 | 259447 | 2020-06-21 | Hardin | Illinois | 17069 | 1 | 0 |
256321 | 256321 | 2020-06-20 | Hardin | Illinois | 17069 | 1 | 0 |
253201 | 253201 | 2020-06-19 | Hardin | Illinois | 17069 | 1 | 0 |
250086 | 250086 | 2020-06-18 | Hardin | Illinois | 17069 | 1 | 0 |
246974 | 246974 | 2020-06-17 | Hardin | Illinois | 17069 | 1 | 0 |
243861 | 243861 | 2020-06-16 | Hardin | Illinois | 17069 | 1 | 0 |
240750 | 240750 | 2020-06-15 | Hardin | Illinois | 17069 | 1 | 0 |
237642 | 237642 | 2020-06-14 | Hardin | Illinois | 17069 | 1 | 0 |
234535 | 234535 | 2020-06-13 | Hardin | Illinois | 17069 | 1 | 0 |
231429 | 231429 | 2020-06-12 | Hardin | Illinois | 17069 | 1 | 0 |
228326 | 228326 | 2020-06-11 | Hardin | Illinois | 17069 | 1 | 0 |
225224 | 225224 | 2020-06-10 | Hardin | Illinois | 17069 | 1 | 0 |
222129 | 222129 | 2020-06-09 | Hardin | Illinois | 17069 | 1 | 0 |
219034 | 219034 | 2020-06-08 | Hardin | Illinois | 17069 | 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);