ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29069 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934949 | 934949 | 2021-01-16 | Dunklin | Missouri | 29069 | 2259 | 16 |
931704 | 931704 | 2021-01-15 | Dunklin | Missouri | 29069 | 2256 | 17 |
928459 | 928459 | 2021-01-14 | Dunklin | Missouri | 29069 | 2247 | 17 |
925213 | 925213 | 2021-01-13 | Dunklin | Missouri | 29069 | 2227 | 17 |
921968 | 921968 | 2021-01-12 | Dunklin | Missouri | 29069 | 2214 | 17 |
918723 | 918723 | 2021-01-11 | Dunklin | Missouri | 29069 | 2207 | 17 |
915478 | 915478 | 2021-01-10 | Dunklin | Missouri | 29069 | 2202 | 17 |
912233 | 912233 | 2021-01-09 | Dunklin | Missouri | 29069 | 2184 | 17 |
908988 | 908988 | 2021-01-08 | Dunklin | Missouri | 29069 | 2163 | 17 |
905742 | 905742 | 2021-01-07 | Dunklin | Missouri | 29069 | 2155 | 17 |
902497 | 902497 | 2021-01-06 | Dunklin | Missouri | 29069 | 2133 | 17 |
899252 | 899252 | 2021-01-05 | Dunklin | Missouri | 29069 | 2129 | 17 |
896007 | 896007 | 2021-01-04 | Dunklin | Missouri | 29069 | 2112 | 15 |
892760 | 892760 | 2021-01-03 | Dunklin | Missouri | 29069 | 2112 | 15 |
889514 | 889514 | 2021-01-02 | Dunklin | Missouri | 29069 | 2105 | 15 |
886268 | 886268 | 2021-01-01 | Dunklin | Missouri | 29069 | 2096 | 15 |
883023 | 883023 | 2020-12-31 | Dunklin | Missouri | 29069 | 2083 | 15 |
879778 | 879778 | 2020-12-30 | Dunklin | Missouri | 29069 | 2066 | 15 |
876533 | 876533 | 2020-12-29 | Dunklin | Missouri | 29069 | 2060 | 15 |
873288 | 873288 | 2020-12-28 | Dunklin | Missouri | 29069 | 2042 | 15 |
870043 | 870043 | 2020-12-27 | Dunklin | Missouri | 29069 | 2037 | 15 |
866798 | 866798 | 2020-12-26 | Dunklin | Missouri | 29069 | 2029 | 15 |
863553 | 863553 | 2020-12-25 | Dunklin | Missouri | 29069 | 2026 | 15 |
860308 | 860308 | 2020-12-24 | Dunklin | Missouri | 29069 | 2023 | 15 |
857063 | 857063 | 2020-12-23 | Dunklin | Missouri | 29069 | 2008 | 15 |
853818 | 853818 | 2020-12-22 | Dunklin | Missouri | 29069 | 1998 | 14 |
850573 | 850573 | 2020-12-21 | Dunklin | Missouri | 29069 | 1989 | 14 |
847328 | 847328 | 2020-12-20 | Dunklin | Missouri | 29069 | 1984 | 14 |
844082 | 844082 | 2020-12-19 | Dunklin | Missouri | 29069 | 1975 | 14 |
840837 | 840837 | 2020-12-18 | Dunklin | Missouri | 29069 | 1970 | 14 |
837592 | 837592 | 2020-12-17 | Dunklin | Missouri | 29069 | 1963 | 14 |
834346 | 834346 | 2020-12-16 | Dunklin | Missouri | 29069 | 1956 | 14 |
831099 | 831099 | 2020-12-15 | Dunklin | Missouri | 29069 | 1869 | 14 |
827853 | 827853 | 2020-12-14 | Dunklin | Missouri | 29069 | 1858 | 14 |
824606 | 824606 | 2020-12-13 | Dunklin | Missouri | 29069 | 1851 | 14 |
821360 | 821360 | 2020-12-12 | Dunklin | Missouri | 29069 | 1842 | 14 |
818114 | 818114 | 2020-12-11 | Dunklin | Missouri | 29069 | 1827 | 14 |
814868 | 814868 | 2020-12-10 | Dunklin | Missouri | 29069 | 1827 | 14 |
811623 | 811623 | 2020-12-09 | Dunklin | Missouri | 29069 | 1800 | 14 |
808378 | 808378 | 2020-12-08 | Dunklin | Missouri | 29069 | 1798 | 14 |
805133 | 805133 | 2020-12-07 | Dunklin | Missouri | 29069 | 1787 | 14 |
801888 | 801888 | 2020-12-06 | Dunklin | Missouri | 29069 | 1777 | 14 |
798643 | 798643 | 2020-12-05 | Dunklin | Missouri | 29069 | 1762 | 14 |
795398 | 795398 | 2020-12-04 | Dunklin | Missouri | 29069 | 1745 | 14 |
792153 | 792153 | 2020-12-03 | Dunklin | Missouri | 29069 | 1738 | 14 |
788908 | 788908 | 2020-12-02 | Dunklin | Missouri | 29069 | 1726 | 14 |
785663 | 785663 | 2020-12-01 | Dunklin | Missouri | 29069 | 1720 | 14 |
782419 | 782419 | 2020-11-30 | Dunklin | Missouri | 29069 | 1708 | 14 |
779173 | 779173 | 2020-11-29 | Dunklin | Missouri | 29069 | 1691 | 14 |
775928 | 775928 | 2020-11-28 | Dunklin | Missouri | 29069 | 1679 | 14 |
772683 | 772683 | 2020-11-27 | Dunklin | Missouri | 29069 | 1666 | 14 |
769438 | 769438 | 2020-11-26 | Dunklin | Missouri | 29069 | 1662 | 14 |
766192 | 766192 | 2020-11-25 | Dunklin | Missouri | 29069 | 1629 | 14 |
762947 | 762947 | 2020-11-24 | Dunklin | Missouri | 29069 | 1608 | 14 |
759702 | 759702 | 2020-11-23 | Dunklin | Missouri | 29069 | 1595 | 13 |
756455 | 756455 | 2020-11-22 | Dunklin | Missouri | 29069 | 1586 | 13 |
753209 | 753209 | 2020-11-21 | Dunklin | Missouri | 29069 | 1578 | 13 |
749963 | 749963 | 2020-11-20 | Dunklin | Missouri | 29069 | 1558 | 13 |
746717 | 746717 | 2020-11-19 | Dunklin | Missouri | 29069 | 1544 | 13 |
743470 | 743470 | 2020-11-18 | Dunklin | Missouri | 29069 | 1540 | 13 |
740223 | 740223 | 2020-11-17 | Dunklin | Missouri | 29069 | 1510 | 13 |
736979 | 736979 | 2020-11-16 | Dunklin | Missouri | 29069 | 1477 | 13 |
733733 | 733733 | 2020-11-15 | Dunklin | Missouri | 29069 | 1463 | 13 |
730488 | 730488 | 2020-11-14 | Dunklin | Missouri | 29069 | 1463 | 13 |
727245 | 727245 | 2020-11-13 | Dunklin | Missouri | 29069 | 1413 | 13 |
724002 | 724002 | 2020-11-12 | Dunklin | Missouri | 29069 | 1386 | 13 |
720759 | 720759 | 2020-11-11 | Dunklin | Missouri | 29069 | 1371 | 13 |
717516 | 717516 | 2020-11-10 | Dunklin | Missouri | 29069 | 1359 | 13 |
714272 | 714272 | 2020-11-09 | Dunklin | Missouri | 29069 | 1350 | 13 |
711028 | 711028 | 2020-11-08 | Dunklin | Missouri | 29069 | 1328 | 13 |
707784 | 707784 | 2020-11-07 | Dunklin | Missouri | 29069 | 1316 | 13 |
704541 | 704541 | 2020-11-06 | Dunklin | Missouri | 29069 | 1294 | 13 |
701299 | 701299 | 2020-11-05 | Dunklin | Missouri | 29069 | 1257 | 13 |
698055 | 698055 | 2020-11-04 | Dunklin | Missouri | 29069 | 1240 | 13 |
694812 | 694812 | 2020-11-03 | Dunklin | Missouri | 29069 | 1222 | 13 |
691570 | 691570 | 2020-11-02 | Dunklin | Missouri | 29069 | 1209 | 13 |
688325 | 688325 | 2020-11-01 | Dunklin | Missouri | 29069 | 1198 | 13 |
685081 | 685081 | 2020-10-31 | Dunklin | Missouri | 29069 | 1185 | 13 |
681838 | 681838 | 2020-10-30 | Dunklin | Missouri | 29069 | 1182 | 12 |
678594 | 678594 | 2020-10-29 | Dunklin | Missouri | 29069 | 1165 | 12 |
675352 | 675352 | 2020-10-28 | Dunklin | Missouri | 29069 | 1147 | 12 |
672109 | 672109 | 2020-10-27 | Dunklin | Missouri | 29069 | 1130 | 12 |
668867 | 668867 | 2020-10-26 | Dunklin | Missouri | 29069 | 1118 | 12 |
665623 | 665623 | 2020-10-25 | Dunklin | Missouri | 29069 | 1106 | 12 |
662378 | 662378 | 2020-10-24 | Dunklin | Missouri | 29069 | 1091 | 12 |
659134 | 659134 | 2020-10-23 | Dunklin | Missouri | 29069 | 1071 | 12 |
655889 | 655889 | 2020-10-22 | Dunklin | Missouri | 29069 | 1043 | 12 |
652644 | 652644 | 2020-10-21 | Dunklin | Missouri | 29069 | 1028 | 12 |
649399 | 649399 | 2020-10-20 | Dunklin | Missouri | 29069 | 997 | 12 |
646155 | 646155 | 2020-10-19 | Dunklin | Missouri | 29069 | 997 | 12 |
642909 | 642909 | 2020-10-18 | Dunklin | Missouri | 29069 | 982 | 12 |
639661 | 639661 | 2020-10-17 | Dunklin | Missouri | 29069 | 968 | 12 |
636415 | 636415 | 2020-10-16 | Dunklin | Missouri | 29069 | 951 | 11 |
633169 | 633169 | 2020-10-15 | Dunklin | Missouri | 29069 | 938 | 11 |
629924 | 629924 | 2020-10-14 | Dunklin | Missouri | 29069 | 927 | 11 |
626680 | 626680 | 2020-10-13 | Dunklin | Missouri | 29069 | 948 | 11 |
623438 | 623438 | 2020-10-12 | Dunklin | Missouri | 29069 | 948 | 11 |
620195 | 620195 | 2020-10-11 | Dunklin | Missouri | 29069 | 948 | 11 |
616953 | 616953 | 2020-10-10 | Dunklin | Missouri | 29069 | 948 | 11 |
613712 | 613712 | 2020-10-09 | Dunklin | Missouri | 29069 | 923 | 11 |
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);