ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17177 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635572 | 635572 | 2020-10-16 | Stephenson | Illinois | 17177 | 746 | 7 |
632326 | 632326 | 2020-10-15 | Stephenson | Illinois | 17177 | 732 | 7 |
629082 | 629082 | 2020-10-14 | Stephenson | Illinois | 17177 | 712 | 7 |
625839 | 625839 | 2020-10-13 | Stephenson | Illinois | 17177 | 707 | 7 |
622597 | 622597 | 2020-10-12 | Stephenson | Illinois | 17177 | 699 | 7 |
619353 | 619353 | 2020-10-11 | Stephenson | Illinois | 17177 | 673 | 7 |
616111 | 616111 | 2020-10-10 | Stephenson | Illinois | 17177 | 666 | 7 |
612870 | 612870 | 2020-10-09 | Stephenson | Illinois | 17177 | 649 | 7 |
609628 | 609628 | 2020-10-08 | Stephenson | Illinois | 17177 | 635 | 7 |
606385 | 606385 | 2020-10-07 | Stephenson | Illinois | 17177 | 611 | 7 |
603143 | 603143 | 2020-10-06 | Stephenson | Illinois | 17177 | 595 | 7 |
599900 | 599900 | 2020-10-05 | Stephenson | Illinois | 17177 | 588 | 7 |
596658 | 596658 | 2020-10-04 | Stephenson | Illinois | 17177 | 581 | 7 |
593416 | 593416 | 2020-10-03 | Stephenson | Illinois | 17177 | 577 | 7 |
590175 | 590175 | 2020-10-02 | Stephenson | Illinois | 17177 | 563 | 7 |
586934 | 586934 | 2020-10-01 | Stephenson | Illinois | 17177 | 552 | 6 |
583694 | 583694 | 2020-09-30 | Stephenson | Illinois | 17177 | 548 | 6 |
580455 | 580455 | 2020-09-29 | Stephenson | Illinois | 17177 | 535 | 6 |
577214 | 577214 | 2020-09-28 | Stephenson | Illinois | 17177 | 529 | 6 |
573972 | 573972 | 2020-09-27 | Stephenson | Illinois | 17177 | 523 | 6 |
570729 | 570729 | 2020-09-26 | Stephenson | Illinois | 17177 | 517 | 6 |
567487 | 567487 | 2020-09-25 | Stephenson | Illinois | 17177 | 510 | 6 |
564247 | 564247 | 2020-09-24 | Stephenson | Illinois | 17177 | 498 | 6 |
561007 | 561007 | 2020-09-23 | Stephenson | Illinois | 17177 | 484 | 6 |
557771 | 557771 | 2020-09-22 | Stephenson | Illinois | 17177 | 475 | 6 |
554534 | 554534 | 2020-09-21 | Stephenson | Illinois | 17177 | 470 | 6 |
551295 | 551295 | 2020-09-20 | Stephenson | Illinois | 17177 | 463 | 6 |
548056 | 548056 | 2020-09-19 | Stephenson | Illinois | 17177 | 461 | 6 |
544818 | 544818 | 2020-09-18 | Stephenson | Illinois | 17177 | 453 | 6 |
541582 | 541582 | 2020-09-17 | Stephenson | Illinois | 17177 | 449 | 6 |
538345 | 538345 | 2020-09-16 | Stephenson | Illinois | 17177 | 439 | 6 |
535109 | 535109 | 2020-09-15 | Stephenson | Illinois | 17177 | 434 | 6 |
531874 | 531874 | 2020-09-14 | Stephenson | Illinois | 17177 | 431 | 6 |
528637 | 528637 | 2020-09-13 | Stephenson | Illinois | 17177 | 424 | 6 |
525401 | 525401 | 2020-09-12 | Stephenson | Illinois | 17177 | 421 | 6 |
522165 | 522165 | 2020-09-11 | Stephenson | Illinois | 17177 | 417 | 6 |
518928 | 518928 | 2020-09-10 | Stephenson | Illinois | 17177 | 409 | 6 |
515693 | 515693 | 2020-09-09 | Stephenson | Illinois | 17177 | 403 | 6 |
512460 | 512460 | 2020-09-08 | Stephenson | Illinois | 17177 | 402 | 6 |
509227 | 509227 | 2020-09-07 | Stephenson | Illinois | 17177 | 401 | 6 |
505995 | 505995 | 2020-09-06 | Stephenson | Illinois | 17177 | 399 | 6 |
502761 | 502761 | 2020-09-05 | Stephenson | Illinois | 17177 | 398 | 6 |
499527 | 499527 | 2020-09-04 | Stephenson | Illinois | 17177 | 395 | 6 |
496294 | 496294 | 2020-09-03 | Stephenson | Illinois | 17177 | 388 | 6 |
493060 | 493060 | 2020-09-02 | Stephenson | Illinois | 17177 | 387 | 6 |
489827 | 489827 | 2020-09-01 | Stephenson | Illinois | 17177 | 381 | 6 |
486594 | 486594 | 2020-08-31 | Stephenson | Illinois | 17177 | 380 | 6 |
483359 | 483359 | 2020-08-30 | Stephenson | Illinois | 17177 | 378 | 6 |
480125 | 480125 | 2020-08-29 | Stephenson | Illinois | 17177 | 376 | 6 |
476892 | 476892 | 2020-08-28 | Stephenson | Illinois | 17177 | 376 | 6 |
473659 | 473659 | 2020-08-27 | Stephenson | Illinois | 17177 | 373 | 6 |
470427 | 470427 | 2020-08-26 | Stephenson | Illinois | 17177 | 371 | 6 |
467198 | 467198 | 2020-08-25 | Stephenson | Illinois | 17177 | 369 | 6 |
463969 | 463969 | 2020-08-24 | Stephenson | Illinois | 17177 | 368 | 6 |
460740 | 460740 | 2020-08-23 | Stephenson | Illinois | 17177 | 364 | 6 |
457513 | 457513 | 2020-08-22 | Stephenson | Illinois | 17177 | 360 | 6 |
454285 | 454285 | 2020-08-21 | Stephenson | Illinois | 17177 | 361 | 6 |
451057 | 451057 | 2020-08-20 | Stephenson | Illinois | 17177 | 355 | 6 |
447829 | 447829 | 2020-08-19 | Stephenson | Illinois | 17177 | 353 | 6 |
444602 | 444602 | 2020-08-18 | Stephenson | Illinois | 17177 | 351 | 6 |
441376 | 441376 | 2020-08-17 | Stephenson | Illinois | 17177 | 348 | 6 |
438150 | 438150 | 2020-08-16 | Stephenson | Illinois | 17177 | 345 | 6 |
434924 | 434924 | 2020-08-15 | Stephenson | Illinois | 17177 | 342 | 6 |
431699 | 431699 | 2020-08-14 | Stephenson | Illinois | 17177 | 340 | 6 |
428471 | 428471 | 2020-08-13 | Stephenson | Illinois | 17177 | 336 | 6 |
425247 | 425247 | 2020-08-12 | Stephenson | Illinois | 17177 | 335 | 6 |
422026 | 422026 | 2020-08-11 | Stephenson | Illinois | 17177 | 334 | 6 |
418803 | 418803 | 2020-08-10 | Stephenson | Illinois | 17177 | 330 | 6 |
415582 | 415582 | 2020-08-09 | Stephenson | Illinois | 17177 | 327 | 6 |
412362 | 412362 | 2020-08-08 | Stephenson | Illinois | 17177 | 327 | 6 |
409143 | 409143 | 2020-08-07 | Stephenson | Illinois | 17177 | 325 | 6 |
405923 | 405923 | 2020-08-06 | Stephenson | Illinois | 17177 | 325 | 6 |
402705 | 402705 | 2020-08-05 | Stephenson | Illinois | 17177 | 324 | 6 |
399489 | 399489 | 2020-08-04 | Stephenson | Illinois | 17177 | 321 | 6 |
396273 | 396273 | 2020-08-03 | Stephenson | Illinois | 17177 | 318 | 6 |
393057 | 393057 | 2020-08-02 | Stephenson | Illinois | 17177 | 317 | 6 |
389840 | 389840 | 2020-08-01 | Stephenson | Illinois | 17177 | 313 | 6 |
386623 | 386623 | 2020-07-31 | Stephenson | Illinois | 17177 | 313 | 6 |
383405 | 383405 | 2020-07-30 | Stephenson | Illinois | 17177 | 312 | 6 |
380188 | 380188 | 2020-07-29 | Stephenson | Illinois | 17177 | 311 | 6 |
376971 | 376971 | 2020-07-28 | Stephenson | Illinois | 17177 | 311 | 6 |
373756 | 373756 | 2020-07-27 | Stephenson | Illinois | 17177 | 307 | 6 |
370544 | 370544 | 2020-07-26 | Stephenson | Illinois | 17177 | 306 | 6 |
367334 | 367334 | 2020-07-25 | Stephenson | Illinois | 17177 | 304 | 6 |
364127 | 364127 | 2020-07-24 | Stephenson | Illinois | 17177 | 299 | 6 |
360920 | 360920 | 2020-07-23 | Stephenson | Illinois | 17177 | 296 | 6 |
357715 | 357715 | 2020-07-22 | Stephenson | Illinois | 17177 | 292 | 6 |
354513 | 354513 | 2020-07-21 | Stephenson | Illinois | 17177 | 290 | 6 |
351311 | 351311 | 2020-07-20 | Stephenson | Illinois | 17177 | 289 | 6 |
348111 | 348111 | 2020-07-19 | Stephenson | Illinois | 17177 | 289 | 6 |
344910 | 344910 | 2020-07-18 | Stephenson | Illinois | 17177 | 288 | 6 |
341710 | 341710 | 2020-07-17 | Stephenson | Illinois | 17177 | 287 | 6 |
338514 | 338514 | 2020-07-16 | Stephenson | Illinois | 17177 | 287 | 6 |
335318 | 335318 | 2020-07-15 | Stephenson | Illinois | 17177 | 287 | 6 |
332125 | 332125 | 2020-07-14 | Stephenson | Illinois | 17177 | 287 | 6 |
328938 | 328938 | 2020-07-13 | Stephenson | Illinois | 17177 | 286 | 6 |
325752 | 325752 | 2020-07-12 | Stephenson | Illinois | 17177 | 285 | 6 |
322571 | 322571 | 2020-07-11 | Stephenson | Illinois | 17177 | 283 | 6 |
319392 | 319392 | 2020-07-10 | Stephenson | Illinois | 17177 | 282 | 6 |
316219 | 316219 | 2020-07-09 | Stephenson | Illinois | 17177 | 282 | 6 |
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);