ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Morgan" and fips = 17137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
924351 | 924351 | 2021-01-13 | Morgan | Illinois | 17137 | 3259 | 90 |
921106 | 921106 | 2021-01-12 | Morgan | Illinois | 17137 | 3248 | 87 |
917861 | 917861 | 2021-01-11 | Morgan | Illinois | 17137 | 3248 | 87 |
914616 | 914616 | 2021-01-10 | Morgan | Illinois | 17137 | 3211 | 87 |
911371 | 911371 | 2021-01-09 | Morgan | Illinois | 17137 | 3168 | 87 |
908126 | 908126 | 2021-01-08 | Morgan | Illinois | 17137 | 3146 | 84 |
904880 | 904880 | 2021-01-07 | Morgan | Illinois | 17137 | 3146 | 84 |
901635 | 901635 | 2021-01-06 | Morgan | Illinois | 17137 | 3146 | 84 |
898390 | 898390 | 2021-01-05 | Morgan | Illinois | 17137 | 3146 | 84 |
895145 | 895145 | 2021-01-04 | Morgan | Illinois | 17137 | 3060 | 82 |
891898 | 891898 | 2021-01-03 | Morgan | Illinois | 17137 | 3060 | 82 |
888651 | 888651 | 2021-01-02 | Morgan | Illinois | 17137 | 3060 | 82 |
885406 | 885406 | 2021-01-01 | Morgan | Illinois | 17137 | 3060 | 82 |
882161 | 882161 | 2020-12-31 | Morgan | Illinois | 17137 | 3060 | 82 |
878916 | 878916 | 2020-12-30 | Morgan | Illinois | 17137 | 3060 | 82 |
875671 | 875671 | 2020-12-29 | Morgan | Illinois | 17137 | 3037 | 82 |
872426 | 872426 | 2020-12-28 | Morgan | Illinois | 17137 | 3019 | 81 |
869181 | 869181 | 2020-12-27 | Morgan | Illinois | 17137 | 2959 | 77 |
865936 | 865936 | 2020-12-26 | Morgan | Illinois | 17137 | 2959 | 77 |
862691 | 862691 | 2020-12-25 | Morgan | Illinois | 17137 | 2959 | 77 |
859446 | 859446 | 2020-12-24 | Morgan | Illinois | 17137 | 2959 | 77 |
856201 | 856201 | 2020-12-23 | Morgan | Illinois | 17137 | 2959 | 77 |
852956 | 852956 | 2020-12-22 | Morgan | Illinois | 17137 | 2915 | 77 |
849711 | 849711 | 2020-12-21 | Morgan | Illinois | 17137 | 2915 | 77 |
846466 | 846466 | 2020-12-20 | Morgan | Illinois | 17137 | 2829 | 72 |
843220 | 843220 | 2020-12-19 | Morgan | Illinois | 17137 | 2829 | 72 |
839975 | 839975 | 2020-12-18 | Morgan | Illinois | 17137 | 2794 | 71 |
836730 | 836730 | 2020-12-17 | Morgan | Illinois | 17137 | 2794 | 71 |
833484 | 833484 | 2020-12-16 | Morgan | Illinois | 17137 | 2794 | 71 |
830237 | 830237 | 2020-12-15 | Morgan | Illinois | 17137 | 2770 | 69 |
826991 | 826991 | 2020-12-14 | Morgan | Illinois | 17137 | 2734 | 69 |
823744 | 823744 | 2020-12-13 | Morgan | Illinois | 17137 | 2657 | 68 |
820498 | 820498 | 2020-12-12 | Morgan | Illinois | 17137 | 2657 | 67 |
817252 | 817252 | 2020-12-11 | Morgan | Illinois | 17137 | 2657 | 67 |
814006 | 814006 | 2020-12-10 | Morgan | Illinois | 17137 | 2567 | 64 |
810761 | 810761 | 2020-12-09 | Morgan | Illinois | 17137 | 2567 | 63 |
807516 | 807516 | 2020-12-08 | Morgan | Illinois | 17137 | 2543 | 62 |
804271 | 804271 | 2020-12-07 | Morgan | Illinois | 17137 | 2505 | 61 |
801026 | 801026 | 2020-12-06 | Morgan | Illinois | 17137 | 2427 | 55 |
797781 | 797781 | 2020-12-05 | Morgan | Illinois | 17137 | 2420 | 55 |
794536 | 794536 | 2020-12-04 | Morgan | Illinois | 17137 | 2420 | 55 |
791291 | 791291 | 2020-12-03 | Morgan | Illinois | 17137 | 2330 | 52 |
788046 | 788046 | 2020-12-02 | Morgan | Illinois | 17137 | 2280 | 51 |
784802 | 784802 | 2020-12-01 | Morgan | Illinois | 17137 | 2280 | 51 |
781557 | 781557 | 2020-11-30 | Morgan | Illinois | 17137 | 2254 | 48 |
778311 | 778311 | 2020-11-29 | Morgan | Illinois | 17137 | 2209 | 40 |
775066 | 775066 | 2020-11-28 | Morgan | Illinois | 17137 | 2186 | 40 |
771821 | 771821 | 2020-11-27 | Morgan | Illinois | 17137 | 2156 | 40 |
768576 | 768576 | 2020-11-26 | Morgan | Illinois | 17137 | 2140 | 40 |
765330 | 765330 | 2020-11-25 | Morgan | Illinois | 17137 | 2095 | 38 |
762085 | 762085 | 2020-11-24 | Morgan | Illinois | 17137 | 2080 | 38 |
758840 | 758840 | 2020-11-23 | Morgan | Illinois | 17137 | 2004 | 36 |
755593 | 755593 | 2020-11-22 | Morgan | Illinois | 17137 | 1983 | 36 |
752347 | 752347 | 2020-11-21 | Morgan | Illinois | 17137 | 1922 | 36 |
749101 | 749101 | 2020-11-20 | Morgan | Illinois | 17137 | 1911 | 36 |
745855 | 745855 | 2020-11-19 | Morgan | Illinois | 17137 | 1870 | 36 |
742608 | 742608 | 2020-11-18 | Morgan | Illinois | 17137 | 1823 | 36 |
739361 | 739361 | 2020-11-17 | Morgan | Illinois | 17137 | 1746 | 36 |
736117 | 736117 | 2020-11-16 | Morgan | Illinois | 17137 | 1703 | 35 |
732871 | 732871 | 2020-11-15 | Morgan | Illinois | 17137 | 1644 | 32 |
729626 | 729626 | 2020-11-14 | Morgan | Illinois | 17137 | 1606 | 32 |
726383 | 726383 | 2020-11-13 | Morgan | Illinois | 17137 | 1558 | 32 |
723140 | 723140 | 2020-11-12 | Morgan | Illinois | 17137 | 1543 | 32 |
719897 | 719897 | 2020-11-11 | Morgan | Illinois | 17137 | 1449 | 31 |
716654 | 716654 | 2020-11-10 | Morgan | Illinois | 17137 | 1420 | 31 |
713410 | 713410 | 2020-11-09 | Morgan | Illinois | 17137 | 1348 | 30 |
710166 | 710166 | 2020-11-08 | Morgan | Illinois | 17137 | 1259 | 30 |
706922 | 706922 | 2020-11-07 | Morgan | Illinois | 17137 | 1243 | 30 |
703679 | 703679 | 2020-11-06 | Morgan | Illinois | 17137 | 1201 | 30 |
700436 | 700436 | 2020-11-05 | Morgan | Illinois | 17137 | 1196 | 30 |
697192 | 697192 | 2020-11-04 | Morgan | Illinois | 17137 | 1171 | 30 |
693950 | 693950 | 2020-11-03 | Morgan | Illinois | 17137 | 1126 | 28 |
690707 | 690707 | 2020-11-02 | Morgan | Illinois | 17137 | 1126 | 28 |
687462 | 687462 | 2020-11-01 | Morgan | Illinois | 17137 | 1064 | 27 |
684218 | 684218 | 2020-10-31 | Morgan | Illinois | 17137 | 1042 | 27 |
680975 | 680975 | 2020-10-30 | Morgan | Illinois | 17137 | 1042 | 27 |
677732 | 677732 | 2020-10-29 | Morgan | Illinois | 17137 | 1007 | 26 |
674489 | 674489 | 2020-10-28 | Morgan | Illinois | 17137 | 989 | 26 |
671247 | 671247 | 2020-10-27 | Morgan | Illinois | 17137 | 962 | 26 |
668004 | 668004 | 2020-10-26 | Morgan | Illinois | 17137 | 934 | 25 |
664760 | 664760 | 2020-10-25 | Morgan | Illinois | 17137 | 896 | 25 |
661515 | 661515 | 2020-10-24 | Morgan | Illinois | 17137 | 890 | 25 |
658271 | 658271 | 2020-10-23 | Morgan | Illinois | 17137 | 868 | 25 |
655026 | 655026 | 2020-10-22 | Morgan | Illinois | 17137 | 865 | 25 |
651781 | 651781 | 2020-10-21 | Morgan | Illinois | 17137 | 854 | 25 |
648537 | 648537 | 2020-10-20 | Morgan | Illinois | 17137 | 840 | 25 |
645292 | 645292 | 2020-10-19 | Morgan | Illinois | 17137 | 831 | 25 |
642045 | 642045 | 2020-10-18 | Morgan | Illinois | 17137 | 811 | 25 |
638798 | 638798 | 2020-10-17 | Morgan | Illinois | 17137 | 811 | 25 |
635552 | 635552 | 2020-10-16 | Morgan | Illinois | 17137 | 811 | 25 |
632306 | 632306 | 2020-10-15 | Morgan | Illinois | 17137 | 789 | 25 |
629062 | 629062 | 2020-10-14 | Morgan | Illinois | 17137 | 789 | 25 |
625819 | 625819 | 2020-10-13 | Morgan | Illinois | 17137 | 779 | 25 |
622577 | 622577 | 2020-10-12 | Morgan | Illinois | 17137 | 747 | 25 |
619333 | 619333 | 2020-10-11 | Morgan | Illinois | 17137 | 734 | 25 |
616091 | 616091 | 2020-10-10 | Morgan | Illinois | 17137 | 724 | 25 |
612850 | 612850 | 2020-10-09 | Morgan | Illinois | 17137 | 724 | 25 |
609608 | 609608 | 2020-10-08 | Morgan | Illinois | 17137 | 724 | 25 |
606365 | 606365 | 2020-10-07 | Morgan | Illinois | 17137 | 724 | 25 |
603123 | 603123 | 2020-10-06 | Morgan | Illinois | 17137 | 724 | 25 |
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);