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 |
---|---|---|---|---|---|---|---|
1063911 | 1063911 | 2021-02-25 | Morgan | Illinois | 17137 | 3631 | 98 |
1060666 | 1060666 | 2021-02-24 | Morgan | Illinois | 17137 | 3631 | 98 |
1057420 | 1057420 | 2021-02-23 | Morgan | Illinois | 17137 | 3631 | 98 |
1054174 | 1054174 | 2021-02-22 | Morgan | Illinois | 17137 | 3631 | 98 |
1050927 | 1050927 | 2021-02-21 | Morgan | Illinois | 17137 | 3631 | 98 |
1047680 | 1047680 | 2021-02-20 | Morgan | Illinois | 17137 | 3631 | 98 |
1044435 | 1044435 | 2021-02-19 | Morgan | Illinois | 17137 | 3619 | 97 |
1041190 | 1041190 | 2021-02-18 | Morgan | Illinois | 17137 | 3619 | 97 |
1037945 | 1037945 | 2021-02-17 | Morgan | Illinois | 17137 | 3619 | 97 |
1034700 | 1034700 | 2021-02-16 | Morgan | Illinois | 17137 | 3608 | 97 |
1031454 | 1031454 | 2021-02-15 | Morgan | Illinois | 17137 | 3542 | 96 |
1028207 | 1028207 | 2021-02-14 | Morgan | Illinois | 17137 | 3542 | 96 |
1024962 | 1024962 | 2021-02-13 | Morgan | Illinois | 17137 | 3542 | 96 |
1021717 | 1021717 | 2021-02-12 | Morgan | Illinois | 17137 | 3542 | 96 |
1018472 | 1018472 | 2021-02-11 | Morgan | Illinois | 17137 | 3542 | 96 |
1015227 | 1015227 | 2021-02-10 | Morgan | Illinois | 17137 | 3497 | 95 |
1011982 | 1011982 | 2021-02-09 | Morgan | Illinois | 17137 | 3497 | 95 |
1008736 | 1008736 | 2021-02-08 | Morgan | Illinois | 17137 | 3497 | 95 |
1005490 | 1005490 | 2021-02-07 | Morgan | Illinois | 17137 | 3474 | 95 |
1002244 | 1002244 | 2021-02-06 | Morgan | Illinois | 17137 | 3474 | 95 |
998998 | 998998 | 2021-02-05 | Morgan | Illinois | 17137 | 3474 | 95 |
995752 | 995752 | 2021-02-04 | Morgan | Illinois | 17137 | 3474 | 95 |
992506 | 992506 | 2021-02-03 | Morgan | Illinois | 17137 | 3474 | 95 |
989260 | 989260 | 2021-02-02 | Morgan | Illinois | 17137 | 3446 | 94 |
986013 | 986013 | 2021-02-01 | Morgan | Illinois | 17137 | 3409 | 93 |
982766 | 982766 | 2021-01-31 | Morgan | Illinois | 17137 | 3409 | 93 |
979520 | 979520 | 2021-01-30 | Morgan | Illinois | 17137 | 3409 | 94 |
976275 | 976275 | 2021-01-29 | Morgan | Illinois | 17137 | 3409 | 94 |
973030 | 973030 | 2021-01-28 | Morgan | Illinois | 17137 | 3401 | 94 |
969785 | 969785 | 2021-01-27 | Morgan | Illinois | 17137 | 3393 | 94 |
966541 | 966541 | 2021-01-26 | Morgan | Illinois | 17137 | 3362 | 93 |
963296 | 963296 | 2021-01-25 | Morgan | Illinois | 17137 | 3362 | 93 |
960051 | 960051 | 2021-01-24 | Morgan | Illinois | 17137 | 3362 | 93 |
956805 | 956805 | 2021-01-23 | Morgan | Illinois | 17137 | 3362 | 93 |
953560 | 953560 | 2021-01-22 | Morgan | Illinois | 17137 | 3362 | 93 |
950315 | 950315 | 2021-01-21 | Morgan | Illinois | 17137 | 3347 | 92 |
947069 | 947069 | 2021-01-20 | Morgan | Illinois | 17137 | 3347 | 91 |
943822 | 943822 | 2021-01-19 | Morgan | Illinois | 17137 | 3347 | 90 |
940577 | 940577 | 2021-01-18 | Morgan | Illinois | 17137 | 3306 | 90 |
937332 | 937332 | 2021-01-17 | Morgan | Illinois | 17137 | 3306 | 90 |
934087 | 934087 | 2021-01-16 | Morgan | Illinois | 17137 | 3306 | 90 |
930842 | 930842 | 2021-01-15 | Morgan | Illinois | 17137 | 3306 | 90 |
927597 | 927597 | 2021-01-14 | Morgan | Illinois | 17137 | 3289 | 90 |
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 |
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);