ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17105 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930826 | 930826 | 2021-01-15 | Livingston | Illinois | 17105 | 3579 | 66 |
927581 | 927581 | 2021-01-14 | Livingston | Illinois | 17105 | 3524 | 66 |
924335 | 924335 | 2021-01-13 | Livingston | Illinois | 17105 | 3481 | 65 |
921090 | 921090 | 2021-01-12 | Livingston | Illinois | 17105 | 3437 | 65 |
917845 | 917845 | 2021-01-11 | Livingston | Illinois | 17105 | 3403 | 65 |
914600 | 914600 | 2021-01-10 | Livingston | Illinois | 17105 | 3390 | 64 |
911355 | 911355 | 2021-01-09 | Livingston | Illinois | 17105 | 3362 | 64 |
908110 | 908110 | 2021-01-08 | Livingston | Illinois | 17105 | 3328 | 64 |
904864 | 904864 | 2021-01-07 | Livingston | Illinois | 17105 | 3280 | 62 |
901619 | 901619 | 2021-01-06 | Livingston | Illinois | 17105 | 3246 | 61 |
898374 | 898374 | 2021-01-05 | Livingston | Illinois | 17105 | 3220 | 60 |
895129 | 895129 | 2021-01-04 | Livingston | Illinois | 17105 | 3201 | 60 |
891882 | 891882 | 2021-01-03 | Livingston | Illinois | 17105 | 3180 | 60 |
888635 | 888635 | 2021-01-02 | Livingston | Illinois | 17105 | 3166 | 59 |
885390 | 885390 | 2021-01-01 | Livingston | Illinois | 17105 | 3140 | 58 |
882145 | 882145 | 2020-12-31 | Livingston | Illinois | 17105 | 3140 | 58 |
878900 | 878900 | 2020-12-30 | Livingston | Illinois | 17105 | 3118 | 58 |
875655 | 875655 | 2020-12-29 | Livingston | Illinois | 17105 | 3093 | 58 |
872410 | 872410 | 2020-12-28 | Livingston | Illinois | 17105 | 3059 | 58 |
869165 | 869165 | 2020-12-27 | Livingston | Illinois | 17105 | 3050 | 58 |
865920 | 865920 | 2020-12-26 | Livingston | Illinois | 17105 | 3040 | 58 |
862675 | 862675 | 2020-12-25 | Livingston | Illinois | 17105 | 3030 | 58 |
859430 | 859430 | 2020-12-24 | Livingston | Illinois | 17105 | 2997 | 57 |
856185 | 856185 | 2020-12-23 | Livingston | Illinois | 17105 | 2967 | 57 |
852940 | 852940 | 2020-12-22 | Livingston | Illinois | 17105 | 2934 | 57 |
849695 | 849695 | 2020-12-21 | Livingston | Illinois | 17105 | 2907 | 55 |
846450 | 846450 | 2020-12-20 | Livingston | Illinois | 17105 | 2893 | 55 |
843204 | 843204 | 2020-12-19 | Livingston | Illinois | 17105 | 2874 | 55 |
839959 | 839959 | 2020-12-18 | Livingston | Illinois | 17105 | 2860 | 55 |
836714 | 836714 | 2020-12-17 | Livingston | Illinois | 17105 | 2840 | 52 |
833468 | 833468 | 2020-12-16 | Livingston | Illinois | 17105 | 2812 | 51 |
830221 | 830221 | 2020-12-15 | Livingston | Illinois | 17105 | 2779 | 50 |
826975 | 826975 | 2020-12-14 | Livingston | Illinois | 17105 | 2758 | 49 |
823728 | 823728 | 2020-12-13 | Livingston | Illinois | 17105 | 2736 | 49 |
820482 | 820482 | 2020-12-12 | Livingston | Illinois | 17105 | 2723 | 49 |
817236 | 817236 | 2020-12-11 | Livingston | Illinois | 17105 | 2698 | 49 |
813990 | 813990 | 2020-12-10 | Livingston | Illinois | 17105 | 2636 | 48 |
810745 | 810745 | 2020-12-09 | Livingston | Illinois | 17105 | 2593 | 46 |
807500 | 807500 | 2020-12-08 | Livingston | Illinois | 17105 | 2555 | 45 |
804255 | 804255 | 2020-12-07 | Livingston | Illinois | 17105 | 2515 | 41 |
801010 | 801010 | 2020-12-06 | Livingston | Illinois | 17105 | 2484 | 41 |
797765 | 797765 | 2020-12-05 | Livingston | Illinois | 17105 | 2471 | 40 |
794520 | 794520 | 2020-12-04 | Livingston | Illinois | 17105 | 2419 | 38 |
791275 | 791275 | 2020-12-03 | Livingston | Illinois | 17105 | 2387 | 38 |
788030 | 788030 | 2020-12-02 | Livingston | Illinois | 17105 | 2348 | 36 |
784786 | 784786 | 2020-12-01 | Livingston | Illinois | 17105 | 2312 | 29 |
781541 | 781541 | 2020-11-30 | Livingston | Illinois | 17105 | 2268 | 28 |
778295 | 778295 | 2020-11-29 | Livingston | Illinois | 17105 | 2245 | 27 |
775050 | 775050 | 2020-11-28 | Livingston | Illinois | 17105 | 2234 | 27 |
771805 | 771805 | 2020-11-27 | Livingston | Illinois | 17105 | 2212 | 26 |
768560 | 768560 | 2020-11-26 | Livingston | Illinois | 17105 | 2184 | 24 |
765314 | 765314 | 2020-11-25 | Livingston | Illinois | 17105 | 2135 | 23 |
762069 | 762069 | 2020-11-24 | Livingston | Illinois | 17105 | 2095 | 21 |
758824 | 758824 | 2020-11-23 | Livingston | Illinois | 17105 | 2034 | 21 |
755577 | 755577 | 2020-11-22 | Livingston | Illinois | 17105 | 2005 | 19 |
752331 | 752331 | 2020-11-21 | Livingston | Illinois | 17105 | 1978 | 18 |
749085 | 749085 | 2020-11-20 | Livingston | Illinois | 17105 | 1922 | 18 |
745839 | 745839 | 2020-11-19 | Livingston | Illinois | 17105 | 1863 | 17 |
742592 | 742592 | 2020-11-18 | Livingston | Illinois | 17105 | 1788 | 16 |
739345 | 739345 | 2020-11-17 | Livingston | Illinois | 17105 | 1725 | 15 |
736101 | 736101 | 2020-11-16 | Livingston | Illinois | 17105 | 1661 | 15 |
732855 | 732855 | 2020-11-15 | Livingston | Illinois | 17105 | 1617 | 15 |
729610 | 729610 | 2020-11-14 | Livingston | Illinois | 17105 | 1572 | 15 |
726367 | 726367 | 2020-11-13 | Livingston | Illinois | 17105 | 1504 | 14 |
723124 | 723124 | 2020-11-12 | Livingston | Illinois | 17105 | 1416 | 14 |
719881 | 719881 | 2020-11-11 | Livingston | Illinois | 17105 | 1340 | 14 |
716638 | 716638 | 2020-11-10 | Livingston | Illinois | 17105 | 1264 | 12 |
713394 | 713394 | 2020-11-09 | Livingston | Illinois | 17105 | 1153 | 12 |
710150 | 710150 | 2020-11-08 | Livingston | Illinois | 17105 | 1099 | 12 |
706906 | 706906 | 2020-11-07 | Livingston | Illinois | 17105 | 1060 | 12 |
703663 | 703663 | 2020-11-06 | Livingston | Illinois | 17105 | 964 | 12 |
700420 | 700420 | 2020-11-05 | Livingston | Illinois | 17105 | 867 | 12 |
697176 | 697176 | 2020-11-04 | Livingston | Illinois | 17105 | 827 | 12 |
693934 | 693934 | 2020-11-03 | Livingston | Illinois | 17105 | 803 | 12 |
690691 | 690691 | 2020-11-02 | Livingston | Illinois | 17105 | 792 | 12 |
687446 | 687446 | 2020-11-01 | Livingston | Illinois | 17105 | 769 | 12 |
684202 | 684202 | 2020-10-31 | Livingston | Illinois | 17105 | 730 | 12 |
680959 | 680959 | 2020-10-30 | Livingston | Illinois | 17105 | 730 | 12 |
677716 | 677716 | 2020-10-29 | Livingston | Illinois | 17105 | 707 | 11 |
674473 | 674473 | 2020-10-28 | Livingston | Illinois | 17105 | 692 | 10 |
671231 | 671231 | 2020-10-27 | Livingston | Illinois | 17105 | 662 | 10 |
667988 | 667988 | 2020-10-26 | Livingston | Illinois | 17105 | 646 | 10 |
664744 | 664744 | 2020-10-25 | Livingston | Illinois | 17105 | 632 | 10 |
661499 | 661499 | 2020-10-24 | Livingston | Illinois | 17105 | 626 | 10 |
658255 | 658255 | 2020-10-23 | Livingston | Illinois | 17105 | 608 | 10 |
655010 | 655010 | 2020-10-22 | Livingston | Illinois | 17105 | 597 | 10 |
651765 | 651765 | 2020-10-21 | Livingston | Illinois | 17105 | 586 | 10 |
648521 | 648521 | 2020-10-20 | Livingston | Illinois | 17105 | 557 | 10 |
645276 | 645276 | 2020-10-19 | Livingston | Illinois | 17105 | 549 | 10 |
642029 | 642029 | 2020-10-18 | Livingston | Illinois | 17105 | 538 | 9 |
638782 | 638782 | 2020-10-17 | Livingston | Illinois | 17105 | 529 | 9 |
635536 | 635536 | 2020-10-16 | Livingston | Illinois | 17105 | 517 | 9 |
632290 | 632290 | 2020-10-15 | Livingston | Illinois | 17105 | 499 | 9 |
629046 | 629046 | 2020-10-14 | Livingston | Illinois | 17105 | 489 | 9 |
625803 | 625803 | 2020-10-13 | Livingston | Illinois | 17105 | 485 | 9 |
622561 | 622561 | 2020-10-12 | Livingston | Illinois | 17105 | 480 | 9 |
619317 | 619317 | 2020-10-11 | Livingston | Illinois | 17105 | 474 | 9 |
616075 | 616075 | 2020-10-10 | Livingston | Illinois | 17105 | 468 | 9 |
612834 | 612834 | 2020-10-09 | Livingston | Illinois | 17105 | 464 | 9 |
609592 | 609592 | 2020-10-08 | Livingston | Illinois | 17105 | 457 | 9 |
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);