ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29107 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934970 | 934970 | 2021-01-16 | Lafayette | Missouri | 29107 | 2272 | 44 |
931725 | 931725 | 2021-01-15 | Lafayette | Missouri | 29107 | 2269 | 44 |
928480 | 928480 | 2021-01-14 | Lafayette | Missouri | 29107 | 2261 | 44 |
925234 | 925234 | 2021-01-13 | Lafayette | Missouri | 29107 | 2243 | 44 |
921989 | 921989 | 2021-01-12 | Lafayette | Missouri | 29107 | 2241 | 44 |
918744 | 918744 | 2021-01-11 | Lafayette | Missouri | 29107 | 2223 | 43 |
915499 | 915499 | 2021-01-10 | Lafayette | Missouri | 29107 | 2213 | 43 |
912254 | 912254 | 2021-01-09 | Lafayette | Missouri | 29107 | 2204 | 43 |
909009 | 909009 | 2021-01-08 | Lafayette | Missouri | 29107 | 2191 | 43 |
905763 | 905763 | 2021-01-07 | Lafayette | Missouri | 29107 | 2170 | 42 |
902518 | 902518 | 2021-01-06 | Lafayette | Missouri | 29107 | 2152 | 42 |
899273 | 899273 | 2021-01-05 | Lafayette | Missouri | 29107 | 2140 | 42 |
896028 | 896028 | 2021-01-04 | Lafayette | Missouri | 29107 | 2125 | 40 |
892781 | 892781 | 2021-01-03 | Lafayette | Missouri | 29107 | 2125 | 40 |
889535 | 889535 | 2021-01-02 | Lafayette | Missouri | 29107 | 2114 | 40 |
886289 | 886289 | 2021-01-01 | Lafayette | Missouri | 29107 | 2092 | 40 |
883044 | 883044 | 2020-12-31 | Lafayette | Missouri | 29107 | 2058 | 40 |
879799 | 879799 | 2020-12-30 | Lafayette | Missouri | 29107 | 2055 | 40 |
876554 | 876554 | 2020-12-29 | Lafayette | Missouri | 29107 | 2034 | 40 |
873309 | 873309 | 2020-12-28 | Lafayette | Missouri | 29107 | 2014 | 38 |
870064 | 870064 | 2020-12-27 | Lafayette | Missouri | 29107 | 2002 | 38 |
866819 | 866819 | 2020-12-26 | Lafayette | Missouri | 29107 | 1997 | 38 |
863574 | 863574 | 2020-12-25 | Lafayette | Missouri | 29107 | 1988 | 38 |
860329 | 860329 | 2020-12-24 | Lafayette | Missouri | 29107 | 1970 | 38 |
857084 | 857084 | 2020-12-23 | Lafayette | Missouri | 29107 | 1951 | 38 |
853839 | 853839 | 2020-12-22 | Lafayette | Missouri | 29107 | 1940 | 36 |
850594 | 850594 | 2020-12-21 | Lafayette | Missouri | 29107 | 1904 | 36 |
847349 | 847349 | 2020-12-20 | Lafayette | Missouri | 29107 | 1879 | 36 |
844103 | 844103 | 2020-12-19 | Lafayette | Missouri | 29107 | 1866 | 36 |
840858 | 840858 | 2020-12-18 | Lafayette | Missouri | 29107 | 1839 | 36 |
837613 | 837613 | 2020-12-17 | Lafayette | Missouri | 29107 | 1821 | 35 |
834367 | 834367 | 2020-12-16 | Lafayette | Missouri | 29107 | 1805 | 35 |
831120 | 831120 | 2020-12-15 | Lafayette | Missouri | 29107 | 1797 | 35 |
827874 | 827874 | 2020-12-14 | Lafayette | Missouri | 29107 | 1782 | 35 |
824627 | 824627 | 2020-12-13 | Lafayette | Missouri | 29107 | 1770 | 35 |
821381 | 821381 | 2020-12-12 | Lafayette | Missouri | 29107 | 1752 | 35 |
818135 | 818135 | 2020-12-11 | Lafayette | Missouri | 29107 | 1723 | 31 |
814889 | 814889 | 2020-12-10 | Lafayette | Missouri | 29107 | 1723 | 31 |
811644 | 811644 | 2020-12-09 | Lafayette | Missouri | 29107 | 1704 | 31 |
808399 | 808399 | 2020-12-08 | Lafayette | Missouri | 29107 | 1690 | 31 |
805154 | 805154 | 2020-12-07 | Lafayette | Missouri | 29107 | 1667 | 30 |
801909 | 801909 | 2020-12-06 | Lafayette | Missouri | 29107 | 1657 | 30 |
798664 | 798664 | 2020-12-05 | Lafayette | Missouri | 29107 | 1634 | 30 |
795419 | 795419 | 2020-12-04 | Lafayette | Missouri | 29107 | 1617 | 30 |
792174 | 792174 | 2020-12-03 | Lafayette | Missouri | 29107 | 1601 | 30 |
788929 | 788929 | 2020-12-02 | Lafayette | Missouri | 29107 | 1581 | 30 |
785684 | 785684 | 2020-12-01 | Lafayette | Missouri | 29107 | 1566 | 29 |
782440 | 782440 | 2020-11-30 | Lafayette | Missouri | 29107 | 1554 | 29 |
779194 | 779194 | 2020-11-29 | Lafayette | Missouri | 29107 | 1528 | 29 |
775949 | 775949 | 2020-11-28 | Lafayette | Missouri | 29107 | 1499 | 29 |
772704 | 772704 | 2020-11-27 | Lafayette | Missouri | 29107 | 1491 | 29 |
769459 | 769459 | 2020-11-26 | Lafayette | Missouri | 29107 | 1477 | 29 |
766213 | 766213 | 2020-11-25 | Lafayette | Missouri | 29107 | 1448 | 29 |
762968 | 762968 | 2020-11-24 | Lafayette | Missouri | 29107 | 1410 | 29 |
759723 | 759723 | 2020-11-23 | Lafayette | Missouri | 29107 | 1389 | 29 |
756476 | 756476 | 2020-11-22 | Lafayette | Missouri | 29107 | 1369 | 29 |
753230 | 753230 | 2020-11-21 | Lafayette | Missouri | 29107 | 1355 | 29 |
749984 | 749984 | 2020-11-20 | Lafayette | Missouri | 29107 | 1331 | 29 |
746738 | 746738 | 2020-11-19 | Lafayette | Missouri | 29107 | 1309 | 29 |
743491 | 743491 | 2020-11-18 | Lafayette | Missouri | 29107 | 1278 | 28 |
740244 | 740244 | 2020-11-17 | Lafayette | Missouri | 29107 | 1261 | 28 |
737000 | 737000 | 2020-11-16 | Lafayette | Missouri | 29107 | 1234 | 27 |
733754 | 733754 | 2020-11-15 | Lafayette | Missouri | 29107 | 1221 | 27 |
730509 | 730509 | 2020-11-14 | Lafayette | Missouri | 29107 | 1221 | 27 |
727266 | 727266 | 2020-11-13 | Lafayette | Missouri | 29107 | 1181 | 27 |
724023 | 724023 | 2020-11-12 | Lafayette | Missouri | 29107 | 1153 | 27 |
720780 | 720780 | 2020-11-11 | Lafayette | Missouri | 29107 | 1140 | 27 |
717537 | 717537 | 2020-11-10 | Lafayette | Missouri | 29107 | 1113 | 27 |
714293 | 714293 | 2020-11-09 | Lafayette | Missouri | 29107 | 1089 | 26 |
711049 | 711049 | 2020-11-08 | Lafayette | Missouri | 29107 | 1072 | 26 |
707805 | 707805 | 2020-11-07 | Lafayette | Missouri | 29107 | 1052 | 26 |
704562 | 704562 | 2020-11-06 | Lafayette | Missouri | 29107 | 1025 | 26 |
701320 | 701320 | 2020-11-05 | Lafayette | Missouri | 29107 | 990 | 26 |
698076 | 698076 | 2020-11-04 | Lafayette | Missouri | 29107 | 973 | 26 |
694833 | 694833 | 2020-11-03 | Lafayette | Missouri | 29107 | 953 | 26 |
691591 | 691591 | 2020-11-02 | Lafayette | Missouri | 29107 | 938 | 26 |
688346 | 688346 | 2020-11-01 | Lafayette | Missouri | 29107 | 912 | 26 |
685102 | 685102 | 2020-10-31 | Lafayette | Missouri | 29107 | 902 | 26 |
681859 | 681859 | 2020-10-30 | Lafayette | Missouri | 29107 | 896 | 24 |
678615 | 678615 | 2020-10-29 | Lafayette | Missouri | 29107 | 881 | 24 |
675373 | 675373 | 2020-10-28 | Lafayette | Missouri | 29107 | 854 | 24 |
672130 | 672130 | 2020-10-27 | Lafayette | Missouri | 29107 | 845 | 24 |
668888 | 668888 | 2020-10-26 | Lafayette | Missouri | 29107 | 831 | 24 |
665644 | 665644 | 2020-10-25 | Lafayette | Missouri | 29107 | 810 | 24 |
662399 | 662399 | 2020-10-24 | Lafayette | Missouri | 29107 | 797 | 24 |
659155 | 659155 | 2020-10-23 | Lafayette | Missouri | 29107 | 782 | 24 |
655910 | 655910 | 2020-10-22 | Lafayette | Missouri | 29107 | 767 | 24 |
652665 | 652665 | 2020-10-21 | Lafayette | Missouri | 29107 | 754 | 24 |
649420 | 649420 | 2020-10-20 | Lafayette | Missouri | 29107 | 738 | 24 |
646176 | 646176 | 2020-10-19 | Lafayette | Missouri | 29107 | 738 | 24 |
642930 | 642930 | 2020-10-18 | Lafayette | Missouri | 29107 | 738 | 24 |
639682 | 639682 | 2020-10-17 | Lafayette | Missouri | 29107 | 733 | 24 |
636436 | 636436 | 2020-10-16 | Lafayette | Missouri | 29107 | 718 | 19 |
633190 | 633190 | 2020-10-15 | Lafayette | Missouri | 29107 | 709 | 19 |
629945 | 629945 | 2020-10-14 | Lafayette | Missouri | 29107 | 703 | 19 |
626701 | 626701 | 2020-10-13 | Lafayette | Missouri | 29107 | 673 | 19 |
623459 | 623459 | 2020-10-12 | Lafayette | Missouri | 29107 | 673 | 19 |
620216 | 620216 | 2020-10-11 | Lafayette | Missouri | 29107 | 673 | 19 |
616974 | 616974 | 2020-10-10 | Lafayette | Missouri | 29107 | 673 | 19 |
613733 | 613733 | 2020-10-09 | Lafayette | Missouri | 29107 | 632 | 19 |
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);