ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Morgan" and fips = 29141 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922006 | 922006 | 2021-01-12 | Morgan | Missouri | 29141 | 1540 | 31 |
918761 | 918761 | 2021-01-11 | Morgan | Missouri | 29141 | 1536 | 30 |
915516 | 915516 | 2021-01-10 | Morgan | Missouri | 29141 | 1532 | 30 |
912271 | 912271 | 2021-01-09 | Morgan | Missouri | 29141 | 1523 | 30 |
909026 | 909026 | 2021-01-08 | Morgan | Missouri | 29141 | 1513 | 24 |
905780 | 905780 | 2021-01-07 | Morgan | Missouri | 29141 | 1500 | 24 |
902535 | 902535 | 2021-01-06 | Morgan | Missouri | 29141 | 1484 | 24 |
899290 | 899290 | 2021-01-05 | Morgan | Missouri | 29141 | 1480 | 24 |
896045 | 896045 | 2021-01-04 | Morgan | Missouri | 29141 | 1475 | 24 |
892798 | 892798 | 2021-01-03 | Morgan | Missouri | 29141 | 1475 | 24 |
889552 | 889552 | 2021-01-02 | Morgan | Missouri | 29141 | 1465 | 24 |
886306 | 886306 | 2021-01-01 | Morgan | Missouri | 29141 | 1458 | 24 |
883061 | 883061 | 2020-12-31 | Morgan | Missouri | 29141 | 1444 | 24 |
879816 | 879816 | 2020-12-30 | Morgan | Missouri | 29141 | 1436 | 24 |
876571 | 876571 | 2020-12-29 | Morgan | Missouri | 29141 | 1423 | 23 |
873326 | 873326 | 2020-12-28 | Morgan | Missouri | 29141 | 1414 | 21 |
870081 | 870081 | 2020-12-27 | Morgan | Missouri | 29141 | 1410 | 21 |
866836 | 866836 | 2020-12-26 | Morgan | Missouri | 29141 | 1408 | 21 |
863591 | 863591 | 2020-12-25 | Morgan | Missouri | 29141 | 1402 | 21 |
860346 | 860346 | 2020-12-24 | Morgan | Missouri | 29141 | 1398 | 21 |
857101 | 857101 | 2020-12-23 | Morgan | Missouri | 29141 | 1393 | 21 |
853856 | 853856 | 2020-12-22 | Morgan | Missouri | 29141 | 1388 | 21 |
850611 | 850611 | 2020-12-21 | Morgan | Missouri | 29141 | 1382 | 16 |
847366 | 847366 | 2020-12-20 | Morgan | Missouri | 29141 | 1374 | 16 |
844120 | 844120 | 2020-12-19 | Morgan | Missouri | 29141 | 1364 | 16 |
840875 | 840875 | 2020-12-18 | Morgan | Missouri | 29141 | 1350 | 16 |
837630 | 837630 | 2020-12-17 | Morgan | Missouri | 29141 | 1343 | 16 |
834384 | 834384 | 2020-12-16 | Morgan | Missouri | 29141 | 1314 | 15 |
831137 | 831137 | 2020-12-15 | Morgan | Missouri | 29141 | 1306 | 15 |
827891 | 827891 | 2020-12-14 | Morgan | Missouri | 29141 | 1296 | 14 |
824644 | 824644 | 2020-12-13 | Morgan | Missouri | 29141 | 1291 | 14 |
821398 | 821398 | 2020-12-12 | Morgan | Missouri | 29141 | 1280 | 14 |
818152 | 818152 | 2020-12-11 | Morgan | Missouri | 29141 | 1242 | 13 |
814906 | 814906 | 2020-12-10 | Morgan | Missouri | 29141 | 1242 | 13 |
811661 | 811661 | 2020-12-09 | Morgan | Missouri | 29141 | 1220 | 13 |
808416 | 808416 | 2020-12-08 | Morgan | Missouri | 29141 | 1202 | 14 |
805171 | 805171 | 2020-12-07 | Morgan | Missouri | 29141 | 1181 | 13 |
801926 | 801926 | 2020-12-06 | Morgan | Missouri | 29141 | 1174 | 13 |
798681 | 798681 | 2020-12-05 | Morgan | Missouri | 29141 | 1158 | 13 |
795436 | 795436 | 2020-12-04 | Morgan | Missouri | 29141 | 1129 | 13 |
792191 | 792191 | 2020-12-03 | Morgan | Missouri | 29141 | 1104 | 13 |
788946 | 788946 | 2020-12-02 | Morgan | Missouri | 29141 | 1089 | 12 |
785701 | 785701 | 2020-12-01 | Morgan | Missouri | 29141 | 1085 | 12 |
782457 | 782457 | 2020-11-30 | Morgan | Missouri | 29141 | 1079 | 12 |
779211 | 779211 | 2020-11-29 | Morgan | Missouri | 29141 | 1068 | 12 |
775966 | 775966 | 2020-11-28 | Morgan | Missouri | 29141 | 1056 | 12 |
772721 | 772721 | 2020-11-27 | Morgan | Missouri | 29141 | 1051 | 12 |
769476 | 769476 | 2020-11-26 | Morgan | Missouri | 29141 | 1043 | 12 |
766230 | 766230 | 2020-11-25 | Morgan | Missouri | 29141 | 1027 | 12 |
762985 | 762985 | 2020-11-24 | Morgan | Missouri | 29141 | 1021 | 12 |
759740 | 759740 | 2020-11-23 | Morgan | Missouri | 29141 | 1012 | 9 |
756493 | 756493 | 2020-11-22 | Morgan | Missouri | 29141 | 995 | 9 |
753247 | 753247 | 2020-11-21 | Morgan | Missouri | 29141 | 989 | 9 |
750001 | 750001 | 2020-11-20 | Morgan | Missouri | 29141 | 972 | 9 |
746755 | 746755 | 2020-11-19 | Morgan | Missouri | 29141 | 961 | 9 |
743508 | 743508 | 2020-11-18 | Morgan | Missouri | 29141 | 944 | 9 |
740261 | 740261 | 2020-11-17 | Morgan | Missouri | 29141 | 935 | 9 |
737017 | 737017 | 2020-11-16 | Morgan | Missouri | 29141 | 924 | 8 |
733771 | 733771 | 2020-11-15 | Morgan | Missouri | 29141 | 907 | 8 |
730526 | 730526 | 2020-11-14 | Morgan | Missouri | 29141 | 907 | 8 |
727283 | 727283 | 2020-11-13 | Morgan | Missouri | 29141 | 880 | 8 |
724040 | 724040 | 2020-11-12 | Morgan | Missouri | 29141 | 875 | 8 |
720797 | 720797 | 2020-11-11 | Morgan | Missouri | 29141 | 858 | 8 |
717554 | 717554 | 2020-11-10 | Morgan | Missouri | 29141 | 850 | 8 |
714310 | 714310 | 2020-11-09 | Morgan | Missouri | 29141 | 840 | 8 |
711066 | 711066 | 2020-11-08 | Morgan | Missouri | 29141 | 828 | 8 |
707822 | 707822 | 2020-11-07 | Morgan | Missouri | 29141 | 819 | 8 |
704579 | 704579 | 2020-11-06 | Morgan | Missouri | 29141 | 802 | 8 |
701337 | 701337 | 2020-11-05 | Morgan | Missouri | 29141 | 791 | 8 |
698093 | 698093 | 2020-11-04 | Morgan | Missouri | 29141 | 774 | 8 |
694850 | 694850 | 2020-11-03 | Morgan | Missouri | 29141 | 771 | 8 |
691608 | 691608 | 2020-11-02 | Morgan | Missouri | 29141 | 762 | 8 |
688363 | 688363 | 2020-11-01 | Morgan | Missouri | 29141 | 745 | 8 |
685119 | 685119 | 2020-10-31 | Morgan | Missouri | 29141 | 732 | 8 |
681876 | 681876 | 2020-10-30 | Morgan | Missouri | 29141 | 704 | 7 |
678632 | 678632 | 2020-10-29 | Morgan | Missouri | 29141 | 698 | 7 |
675390 | 675390 | 2020-10-28 | Morgan | Missouri | 29141 | 682 | 7 |
672147 | 672147 | 2020-10-27 | Morgan | Missouri | 29141 | 672 | 7 |
668905 | 668905 | 2020-10-26 | Morgan | Missouri | 29141 | 665 | 7 |
665661 | 665661 | 2020-10-25 | Morgan | Missouri | 29141 | 661 | 7 |
662416 | 662416 | 2020-10-24 | Morgan | Missouri | 29141 | 649 | 7 |
659172 | 659172 | 2020-10-23 | Morgan | Missouri | 29141 | 629 | 6 |
655927 | 655927 | 2020-10-22 | Morgan | Missouri | 29141 | 622 | 6 |
652682 | 652682 | 2020-10-21 | Morgan | Missouri | 29141 | 604 | 6 |
649437 | 649437 | 2020-10-20 | Morgan | Missouri | 29141 | 584 | 6 |
646193 | 646193 | 2020-10-19 | Morgan | Missouri | 29141 | 584 | 6 |
642947 | 642947 | 2020-10-18 | Morgan | Missouri | 29141 | 571 | 6 |
639699 | 639699 | 2020-10-17 | Morgan | Missouri | 29141 | 559 | 6 |
636453 | 636453 | 2020-10-16 | Morgan | Missouri | 29141 | 551 | 5 |
633207 | 633207 | 2020-10-15 | Morgan | Missouri | 29141 | 535 | 5 |
629962 | 629962 | 2020-10-14 | Morgan | Missouri | 29141 | 526 | 5 |
626718 | 626718 | 2020-10-13 | Morgan | Missouri | 29141 | 497 | 5 |
623476 | 623476 | 2020-10-12 | Morgan | Missouri | 29141 | 497 | 5 |
620233 | 620233 | 2020-10-11 | Morgan | Missouri | 29141 | 497 | 5 |
616991 | 616991 | 2020-10-10 | Morgan | Missouri | 29141 | 497 | 5 |
613750 | 613750 | 2020-10-09 | Morgan | Missouri | 29141 | 468 | 5 |
610508 | 610508 | 2020-10-08 | Morgan | Missouri | 29141 | 457 | 2 |
607266 | 607266 | 2020-10-07 | Morgan | Missouri | 29141 | 451 | 2 |
604023 | 604023 | 2020-10-06 | Morgan | Missouri | 29141 | 447 | 2 |
600781 | 600781 | 2020-10-05 | Morgan | Missouri | 29141 | 439 | 2 |
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);