ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29043 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934936 | 934936 | 2021-01-16 | Christian | Missouri | 29043 | 7359 | 60 |
931691 | 931691 | 2021-01-15 | Christian | Missouri | 29043 | 7359 | 60 |
928446 | 928446 | 2021-01-14 | Christian | Missouri | 29043 | 7162 | 60 |
925200 | 925200 | 2021-01-13 | Christian | Missouri | 29043 | 7162 | 60 |
921955 | 921955 | 2021-01-12 | Christian | Missouri | 29043 | 7162 | 60 |
918710 | 918710 | 2021-01-11 | Christian | Missouri | 29043 | 7162 | 55 |
915465 | 915465 | 2021-01-10 | Christian | Missouri | 29043 | 6982 | 55 |
912220 | 912220 | 2021-01-09 | Christian | Missouri | 29043 | 6982 | 55 |
908975 | 908975 | 2021-01-08 | Christian | Missouri | 29043 | 6982 | 55 |
905729 | 905729 | 2021-01-07 | Christian | Missouri | 29043 | 6675 | 53 |
902484 | 902484 | 2021-01-06 | Christian | Missouri | 29043 | 6675 | 53 |
899239 | 899239 | 2021-01-05 | Christian | Missouri | 29043 | 6675 | 53 |
895994 | 895994 | 2021-01-04 | Christian | Missouri | 29043 | 6675 | 49 |
892747 | 892747 | 2021-01-03 | Christian | Missouri | 29043 | 6285 | 49 |
889501 | 889501 | 2021-01-02 | Christian | Missouri | 29043 | 6285 | 49 |
886255 | 886255 | 2021-01-01 | Christian | Missouri | 29043 | 6285 | 49 |
883010 | 883010 | 2020-12-31 | Christian | Missouri | 29043 | 6285 | 49 |
879765 | 879765 | 2020-12-30 | Christian | Missouri | 29043 | 6050 | 49 |
876520 | 876520 | 2020-12-29 | Christian | Missouri | 29043 | 6050 | 48 |
873275 | 873275 | 2020-12-28 | Christian | Missouri | 29043 | 6050 | 45 |
870030 | 870030 | 2020-12-27 | Christian | Missouri | 29043 | 5932 | 45 |
866785 | 866785 | 2020-12-26 | Christian | Missouri | 29043 | 5932 | 45 |
863540 | 863540 | 2020-12-25 | Christian | Missouri | 29043 | 5932 | 45 |
860295 | 860295 | 2020-12-24 | Christian | Missouri | 29043 | 5932 | 45 |
857050 | 857050 | 2020-12-23 | Christian | Missouri | 29043 | 5683 | 44 |
853805 | 853805 | 2020-12-22 | Christian | Missouri | 29043 | 5683 | 41 |
850560 | 850560 | 2020-12-21 | Christian | Missouri | 29043 | 5683 | 35 |
847315 | 847315 | 2020-12-20 | Christian | Missouri | 29043 | 5498 | 35 |
844069 | 844069 | 2020-12-19 | Christian | Missouri | 29043 | 5498 | 35 |
840824 | 840824 | 2020-12-18 | Christian | Missouri | 29043 | 5498 | 35 |
837579 | 837579 | 2020-12-17 | Christian | Missouri | 29043 | 5116 | 35 |
834333 | 834333 | 2020-12-16 | Christian | Missouri | 29043 | 5116 | 34 |
831086 | 831086 | 2020-12-15 | Christian | Missouri | 29043 | 5116 | 34 |
827840 | 827840 | 2020-12-14 | Christian | Missouri | 29043 | 5116 | 29 |
824593 | 824593 | 2020-12-13 | Christian | Missouri | 29043 | 5023 | 29 |
821347 | 821347 | 2020-12-12 | Christian | Missouri | 29043 | 4592 | 29 |
818101 | 818101 | 2020-12-11 | Christian | Missouri | 29043 | 4592 | 28 |
814855 | 814855 | 2020-12-10 | Christian | Missouri | 29043 | 4592 | 28 |
811610 | 811610 | 2020-12-09 | Christian | Missouri | 29043 | 4592 | 28 |
808365 | 808365 | 2020-12-08 | Christian | Missouri | 29043 | 4592 | 28 |
805120 | 805120 | 2020-12-07 | Christian | Missouri | 29043 | 4592 | 24 |
801875 | 801875 | 2020-12-06 | Christian | Missouri | 29043 | 4538 | 24 |
798630 | 798630 | 2020-12-05 | Christian | Missouri | 29043 | 4538 | 24 |
795385 | 795385 | 2020-12-04 | Christian | Missouri | 29043 | 4538 | 24 |
792140 | 792140 | 2020-12-03 | Christian | Missouri | 29043 | 4214 | 24 |
788895 | 788895 | 2020-12-02 | Christian | Missouri | 29043 | 4214 | 24 |
785650 | 785650 | 2020-12-01 | Christian | Missouri | 29043 | 4214 | 24 |
782406 | 782406 | 2020-11-30 | Christian | Missouri | 29043 | 4214 | 23 |
779160 | 779160 | 2020-11-29 | Christian | Missouri | 29043 | 4099 | 23 |
775915 | 775915 | 2020-11-28 | Christian | Missouri | 29043 | 4099 | 23 |
772670 | 772670 | 2020-11-27 | Christian | Missouri | 29043 | 4099 | 23 |
769425 | 769425 | 2020-11-26 | Christian | Missouri | 29043 | 3936 | 23 |
766179 | 766179 | 2020-11-25 | Christian | Missouri | 29043 | 3936 | 23 |
762934 | 762934 | 2020-11-24 | Christian | Missouri | 29043 | 3936 | 23 |
759689 | 759689 | 2020-11-23 | Christian | Missouri | 29043 | 3725 | 22 |
756442 | 756442 | 2020-11-22 | Christian | Missouri | 29043 | 3725 | 22 |
753196 | 753196 | 2020-11-21 | Christian | Missouri | 29043 | 3725 | 22 |
749950 | 749950 | 2020-11-20 | Christian | Missouri | 29043 | 3725 | 22 |
746704 | 746704 | 2020-11-19 | Christian | Missouri | 29043 | 3515 | 20 |
743457 | 743457 | 2020-11-18 | Christian | Missouri | 29043 | 3515 | 20 |
740210 | 740210 | 2020-11-17 | Christian | Missouri | 29043 | 3515 | 20 |
736966 | 736966 | 2020-11-16 | Christian | Missouri | 29043 | 3515 | 20 |
733720 | 733720 | 2020-11-15 | Christian | Missouri | 29043 | 3358 | 20 |
730475 | 730475 | 2020-11-14 | Christian | Missouri | 29043 | 3358 | 20 |
727232 | 727232 | 2020-11-13 | Christian | Missouri | 29043 | 3358 | 20 |
723989 | 723989 | 2020-11-12 | Christian | Missouri | 29043 | 3090 | 20 |
720746 | 720746 | 2020-11-11 | Christian | Missouri | 29043 | 3090 | 20 |
717503 | 717503 | 2020-11-10 | Christian | Missouri | 29043 | 3090 | 20 |
714259 | 714259 | 2020-11-09 | Christian | Missouri | 29043 | 3090 | 17 |
711015 | 711015 | 2020-11-08 | Christian | Missouri | 29043 | 2955 | 17 |
707771 | 707771 | 2020-11-07 | Christian | Missouri | 29043 | 2955 | 17 |
704528 | 704528 | 2020-11-06 | Christian | Missouri | 29043 | 2955 | 17 |
701286 | 701286 | 2020-11-05 | Christian | Missouri | 29043 | 2717 | 17 |
698042 | 698042 | 2020-11-04 | Christian | Missouri | 29043 | 2717 | 17 |
694799 | 694799 | 2020-11-03 | Christian | Missouri | 29043 | 2717 | 17 |
691557 | 691557 | 2020-11-02 | Christian | Missouri | 29043 | 2717 | 16 |
688312 | 688312 | 2020-11-01 | Christian | Missouri | 29043 | 2630 | 16 |
685068 | 685068 | 2020-10-31 | Christian | Missouri | 29043 | 2630 | 16 |
681825 | 681825 | 2020-10-30 | Christian | Missouri | 29043 | 2630 | 13 |
678581 | 678581 | 2020-10-29 | Christian | Missouri | 29043 | 2498 | 13 |
675339 | 675339 | 2020-10-28 | Christian | Missouri | 29043 | 2498 | 13 |
672096 | 672096 | 2020-10-27 | Christian | Missouri | 29043 | 2498 | 13 |
668854 | 668854 | 2020-10-26 | Christian | Missouri | 29043 | 2498 | 13 |
665610 | 665610 | 2020-10-25 | Christian | Missouri | 29043 | 2421 | 13 |
662365 | 662365 | 2020-10-24 | Christian | Missouri | 29043 | 2421 | 13 |
659121 | 659121 | 2020-10-23 | Christian | Missouri | 29043 | 2421 | 11 |
655876 | 655876 | 2020-10-22 | Christian | Missouri | 29043 | 2277 | 10 |
652631 | 652631 | 2020-10-21 | Christian | Missouri | 29043 | 2277 | 10 |
649386 | 649386 | 2020-10-20 | Christian | Missouri | 29043 | 2277 | 10 |
646142 | 646142 | 2020-10-19 | Christian | Missouri | 29043 | 2277 | 10 |
642896 | 642896 | 2020-10-18 | Christian | Missouri | 29043 | 2212 | 10 |
639648 | 639648 | 2020-10-17 | Christian | Missouri | 29043 | 2212 | 10 |
636402 | 636402 | 2020-10-16 | Christian | Missouri | 29043 | 2212 | 8 |
633156 | 633156 | 2020-10-15 | Christian | Missouri | 29043 | 1972 | 8 |
629911 | 629911 | 2020-10-14 | Christian | Missouri | 29043 | 1947 | 8 |
626667 | 626667 | 2020-10-13 | Christian | Missouri | 29043 | 1929 | 8 |
623425 | 623425 | 2020-10-12 | Christian | Missouri | 29043 | 1929 | 8 |
620182 | 620182 | 2020-10-11 | Christian | Missouri | 29043 | 1929 | 8 |
616940 | 616940 | 2020-10-10 | Christian | Missouri | 29043 | 1929 | 8 |
613699 | 613699 | 2020-10-09 | Christian | Missouri | 29043 | 1929 | 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);