ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29157 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934995 | 934995 | 2021-01-16 | Perry | Missouri | 29157 | 1952 | 21 |
931750 | 931750 | 2021-01-15 | Perry | Missouri | 29157 | 1944 | 21 |
928505 | 928505 | 2021-01-14 | Perry | Missouri | 29157 | 1939 | 21 |
925259 | 925259 | 2021-01-13 | Perry | Missouri | 29157 | 1936 | 20 |
922014 | 922014 | 2021-01-12 | Perry | Missouri | 29157 | 1935 | 20 |
918769 | 918769 | 2021-01-11 | Perry | Missouri | 29157 | 1933 | 20 |
915524 | 915524 | 2021-01-10 | Perry | Missouri | 29157 | 1928 | 19 |
912279 | 912279 | 2021-01-09 | Perry | Missouri | 29157 | 1922 | 19 |
909034 | 909034 | 2021-01-08 | Perry | Missouri | 29157 | 1911 | 19 |
905788 | 905788 | 2021-01-07 | Perry | Missouri | 29157 | 1902 | 19 |
902543 | 902543 | 2021-01-06 | Perry | Missouri | 29157 | 1893 | 19 |
899298 | 899298 | 2021-01-05 | Perry | Missouri | 29157 | 1885 | 19 |
896053 | 896053 | 2021-01-04 | Perry | Missouri | 29157 | 1876 | 19 |
892806 | 892806 | 2021-01-03 | Perry | Missouri | 29157 | 1876 | 19 |
889560 | 889560 | 2021-01-02 | Perry | Missouri | 29157 | 1866 | 19 |
886314 | 886314 | 2021-01-01 | Perry | Missouri | 29157 | 1862 | 19 |
883069 | 883069 | 2020-12-31 | Perry | Missouri | 29157 | 1852 | 19 |
879824 | 879824 | 2020-12-30 | Perry | Missouri | 29157 | 1839 | 19 |
876579 | 876579 | 2020-12-29 | Perry | Missouri | 29157 | 1838 | 19 |
873334 | 873334 | 2020-12-28 | Perry | Missouri | 29157 | 1824 | 19 |
870089 | 870089 | 2020-12-27 | Perry | Missouri | 29157 | 1821 | 19 |
866844 | 866844 | 2020-12-26 | Perry | Missouri | 29157 | 1815 | 19 |
863599 | 863599 | 2020-12-25 | Perry | Missouri | 29157 | 1810 | 19 |
860354 | 860354 | 2020-12-24 | Perry | Missouri | 29157 | 1800 | 19 |
857109 | 857109 | 2020-12-23 | Perry | Missouri | 29157 | 1795 | 19 |
853864 | 853864 | 2020-12-22 | Perry | Missouri | 29157 | 1790 | 15 |
850619 | 850619 | 2020-12-21 | Perry | Missouri | 29157 | 1783 | 15 |
847374 | 847374 | 2020-12-20 | Perry | Missouri | 29157 | 1771 | 15 |
844128 | 844128 | 2020-12-19 | Perry | Missouri | 29157 | 1768 | 15 |
840883 | 840883 | 2020-12-18 | Perry | Missouri | 29157 | 1758 | 15 |
837638 | 837638 | 2020-12-17 | Perry | Missouri | 29157 | 1749 | 15 |
834392 | 834392 | 2020-12-16 | Perry | Missouri | 29157 | 1729 | 15 |
831145 | 831145 | 2020-12-15 | Perry | Missouri | 29157 | 1714 | 15 |
827899 | 827899 | 2020-12-14 | Perry | Missouri | 29157 | 1695 | 15 |
824652 | 824652 | 2020-12-13 | Perry | Missouri | 29157 | 1685 | 15 |
821406 | 821406 | 2020-12-12 | Perry | Missouri | 29157 | 1681 | 15 |
818160 | 818160 | 2020-12-11 | Perry | Missouri | 29157 | 1661 | 15 |
814914 | 814914 | 2020-12-10 | Perry | Missouri | 29157 | 1661 | 15 |
811669 | 811669 | 2020-12-09 | Perry | Missouri | 29157 | 1644 | 15 |
808424 | 808424 | 2020-12-08 | Perry | Missouri | 29157 | 1644 | 13 |
805179 | 805179 | 2020-12-07 | Perry | Missouri | 29157 | 1638 | 12 |
801934 | 801934 | 2020-12-06 | Perry | Missouri | 29157 | 1632 | 12 |
798689 | 798689 | 2020-12-05 | Perry | Missouri | 29157 | 1620 | 12 |
795444 | 795444 | 2020-12-04 | Perry | Missouri | 29157 | 1608 | 12 |
792199 | 792199 | 2020-12-03 | Perry | Missouri | 29157 | 1596 | 12 |
788954 | 788954 | 2020-12-02 | Perry | Missouri | 29157 | 1570 | 12 |
785709 | 785709 | 2020-12-01 | Perry | Missouri | 29157 | 1566 | 12 |
782465 | 782465 | 2020-11-30 | Perry | Missouri | 29157 | 1560 | 12 |
779219 | 779219 | 2020-11-29 | Perry | Missouri | 29157 | 1535 | 12 |
775974 | 775974 | 2020-11-28 | Perry | Missouri | 29157 | 1520 | 12 |
772729 | 772729 | 2020-11-27 | Perry | Missouri | 29157 | 1519 | 12 |
769484 | 769484 | 2020-11-26 | Perry | Missouri | 29157 | 1509 | 12 |
766238 | 766238 | 2020-11-25 | Perry | Missouri | 29157 | 1496 | 12 |
762993 | 762993 | 2020-11-24 | Perry | Missouri | 29157 | 1484 | 12 |
759748 | 759748 | 2020-11-23 | Perry | Missouri | 29157 | 1455 | 8 |
756501 | 756501 | 2020-11-22 | Perry | Missouri | 29157 | 1436 | 8 |
753255 | 753255 | 2020-11-21 | Perry | Missouri | 29157 | 1423 | 8 |
750009 | 750009 | 2020-11-20 | Perry | Missouri | 29157 | 1372 | 8 |
746763 | 746763 | 2020-11-19 | Perry | Missouri | 29157 | 1353 | 8 |
743516 | 743516 | 2020-11-18 | Perry | Missouri | 29157 | 1336 | 8 |
740269 | 740269 | 2020-11-17 | Perry | Missouri | 29157 | 1325 | 8 |
737025 | 737025 | 2020-11-16 | Perry | Missouri | 29157 | 1268 | 8 |
733779 | 733779 | 2020-11-15 | Perry | Missouri | 29157 | 1257 | 8 |
730534 | 730534 | 2020-11-14 | Perry | Missouri | 29157 | 1257 | 8 |
727291 | 727291 | 2020-11-13 | Perry | Missouri | 29157 | 1132 | 8 |
724048 | 724048 | 2020-11-12 | Perry | Missouri | 29157 | 1123 | 8 |
720805 | 720805 | 2020-11-11 | Perry | Missouri | 29157 | 1108 | 8 |
717562 | 717562 | 2020-11-10 | Perry | Missouri | 29157 | 1095 | 8 |
714318 | 714318 | 2020-11-09 | Perry | Missouri | 29157 | 1052 | 8 |
711074 | 711074 | 2020-11-08 | Perry | Missouri | 29157 | 1036 | 8 |
707830 | 707830 | 2020-11-07 | Perry | Missouri | 29157 | 1016 | 8 |
704587 | 704587 | 2020-11-06 | Perry | Missouri | 29157 | 986 | 8 |
701345 | 701345 | 2020-11-05 | Perry | Missouri | 29157 | 931 | 8 |
698101 | 698101 | 2020-11-04 | Perry | Missouri | 29157 | 906 | 8 |
694858 | 694858 | 2020-11-03 | Perry | Missouri | 29157 | 900 | 8 |
691616 | 691616 | 2020-11-02 | Perry | Missouri | 29157 | 886 | 8 |
688371 | 688371 | 2020-11-01 | Perry | Missouri | 29157 | 876 | 8 |
685127 | 685127 | 2020-10-31 | Perry | Missouri | 29157 | 865 | 8 |
681884 | 681884 | 2020-10-30 | Perry | Missouri | 29157 | 848 | 8 |
678640 | 678640 | 2020-10-29 | Perry | Missouri | 29157 | 833 | 8 |
675398 | 675398 | 2020-10-28 | Perry | Missouri | 29157 | 814 | 8 |
672155 | 672155 | 2020-10-27 | Perry | Missouri | 29157 | 812 | 8 |
668913 | 668913 | 2020-10-26 | Perry | Missouri | 29157 | 809 | 8 |
665669 | 665669 | 2020-10-25 | Perry | Missouri | 29157 | 795 | 8 |
662424 | 662424 | 2020-10-24 | Perry | Missouri | 29157 | 789 | 8 |
659180 | 659180 | 2020-10-23 | Perry | Missouri | 29157 | 779 | 8 |
655935 | 655935 | 2020-10-22 | Perry | Missouri | 29157 | 771 | 8 |
652690 | 652690 | 2020-10-21 | Perry | Missouri | 29157 | 762 | 7 |
649445 | 649445 | 2020-10-20 | Perry | Missouri | 29157 | 755 | 7 |
646201 | 646201 | 2020-10-19 | Perry | Missouri | 29157 | 755 | 7 |
642955 | 642955 | 2020-10-18 | Perry | Missouri | 29157 | 748 | 7 |
639707 | 639707 | 2020-10-17 | Perry | Missouri | 29157 | 744 | 7 |
636461 | 636461 | 2020-10-16 | Perry | Missouri | 29157 | 731 | 7 |
633215 | 633215 | 2020-10-15 | Perry | Missouri | 29157 | 726 | 7 |
629970 | 629970 | 2020-10-14 | Perry | Missouri | 29157 | 721 | 8 |
626726 | 626726 | 2020-10-13 | Perry | Missouri | 29157 | 707 | 8 |
623484 | 623484 | 2020-10-12 | Perry | Missouri | 29157 | 707 | 8 |
620241 | 620241 | 2020-10-11 | Perry | Missouri | 29157 | 707 | 8 |
616999 | 616999 | 2020-10-10 | Perry | Missouri | 29157 | 707 | 8 |
613758 | 613758 | 2020-10-09 | Perry | Missouri | 29157 | 694 | 8 |
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);