ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
688 rows where county = "Joplin" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934966 | 934966 | 2021-01-16 | Joplin | Missouri | 4335 | 88 | |
931721 | 931721 | 2021-01-15 | Joplin | Missouri | 4332 | 88 | |
928476 | 928476 | 2021-01-14 | Joplin | Missouri | 4300 | 85 | |
925230 | 925230 | 2021-01-13 | Joplin | Missouri | 4287 | 85 | |
921985 | 921985 | 2021-01-12 | Joplin | Missouri | 4255 | 82 | |
918740 | 918740 | 2021-01-11 | Joplin | Missouri | 4240 | 80 | |
915495 | 915495 | 2021-01-10 | Joplin | Missouri | 4237 | 80 | |
912250 | 912250 | 2021-01-09 | Joplin | Missouri | 4209 | 80 | |
909005 | 909005 | 2021-01-08 | Joplin | Missouri | 4182 | 80 | |
905759 | 905759 | 2021-01-07 | Joplin | Missouri | 4144 | 80 | |
902514 | 902514 | 2021-01-06 | Joplin | Missouri | 4120 | 80 | |
899269 | 899269 | 2021-01-05 | Joplin | Missouri | 4087 | 79 | |
896024 | 896024 | 2021-01-04 | Joplin | Missouri | 4073 | 77 | |
892777 | 892777 | 2021-01-03 | Joplin | Missouri | 4073 | 77 | |
889531 | 889531 | 2021-01-02 | Joplin | Missouri | 4059 | 77 | |
886285 | 886285 | 2021-01-01 | Joplin | Missouri | 4035 | 74 | |
883040 | 883040 | 2020-12-31 | Joplin | Missouri | 3975 | 74 | |
879795 | 879795 | 2020-12-30 | Joplin | Missouri | 3929 | 74 | |
876550 | 876550 | 2020-12-29 | Joplin | Missouri | 3889 | 73 | |
873305 | 873305 | 2020-12-28 | Joplin | Missouri | 3882 | 71 | |
870060 | 870060 | 2020-12-27 | Joplin | Missouri | 3862 | 71 | |
866815 | 866815 | 2020-12-26 | Joplin | Missouri | 3857 | 71 | |
863570 | 863570 | 2020-12-25 | Joplin | Missouri | 3849 | 71 | |
860325 | 860325 | 2020-12-24 | Joplin | Missouri | 3831 | 71 | |
857080 | 857080 | 2020-12-23 | Joplin | Missouri | 3797 | 71 | |
853835 | 853835 | 2020-12-22 | Joplin | Missouri | 3747 | 68 | |
850590 | 850590 | 2020-12-21 | Joplin | Missouri | 3747 | 65 | |
847345 | 847345 | 2020-12-20 | Joplin | Missouri | 3736 | 65 | |
844099 | 844099 | 2020-12-19 | Joplin | Missouri | 3726 | 64 | |
840854 | 840854 | 2020-12-18 | Joplin | Missouri | 3698 | 63 | |
837609 | 837609 | 2020-12-17 | Joplin | Missouri | 3677 | 60 | |
834363 | 834363 | 2020-12-16 | Joplin | Missouri | 3647 | 60 | |
831116 | 831116 | 2020-12-15 | Joplin | Missouri | 3628 | 57 | |
827870 | 827870 | 2020-12-14 | Joplin | Missouri | 3617 | 57 | |
824623 | 824623 | 2020-12-13 | Joplin | Missouri | 3607 | 57 | |
821377 | 821377 | 2020-12-12 | Joplin | Missouri | 3589 | 57 | |
818131 | 818131 | 2020-12-11 | Joplin | Missouri | 3546 | 56 | |
814885 | 814885 | 2020-12-10 | Joplin | Missouri | 3546 | 56 | |
811640 | 811640 | 2020-12-09 | Joplin | Missouri | 3533 | 56 | |
808395 | 808395 | 2020-12-08 | Joplin | Missouri | 3486 | 56 | |
805150 | 805150 | 2020-12-07 | Joplin | Missouri | 3443 | 53 | |
801905 | 801905 | 2020-12-06 | Joplin | Missouri | 3436 | 53 | |
798660 | 798660 | 2020-12-05 | Joplin | Missouri | 3419 | 51 | |
795415 | 795415 | 2020-12-04 | Joplin | Missouri | 3407 | 51 | |
792170 | 792170 | 2020-12-03 | Joplin | Missouri | 3377 | 51 | |
788925 | 788925 | 2020-12-02 | Joplin | Missouri | 3348 | 51 | |
785680 | 785680 | 2020-12-01 | Joplin | Missouri | 3299 | 51 | |
782436 | 782436 | 2020-11-30 | Joplin | Missouri | 3282 | 46 | |
779190 | 779190 | 2020-11-29 | Joplin | Missouri | 3267 | 46 | |
775945 | 775945 | 2020-11-28 | Joplin | Missouri | 3229 | 46 | |
772700 | 772700 | 2020-11-27 | Joplin | Missouri | 3224 | 46 | |
769455 | 769455 | 2020-11-26 | Joplin | Missouri | 3194 | 46 | |
766209 | 766209 | 2020-11-25 | Joplin | Missouri | 3147 | 46 | |
762964 | 762964 | 2020-11-24 | Joplin | Missouri | 3107 | 46 | |
759719 | 759719 | 2020-11-23 | Joplin | Missouri | 3081 | 45 | |
756472 | 756472 | 2020-11-22 | Joplin | Missouri | 3069 | 45 | |
753226 | 753226 | 2020-11-21 | Joplin | Missouri | 3039 | 45 | |
749980 | 749980 | 2020-11-20 | Joplin | Missouri | 2982 | 45 | |
746734 | 746734 | 2020-11-19 | Joplin | Missouri | 2940 | 44 | |
743487 | 743487 | 2020-11-18 | Joplin | Missouri | 2879 | 44 | |
740240 | 740240 | 2020-11-17 | Joplin | Missouri | 2829 | 44 | |
736996 | 736996 | 2020-11-16 | Joplin | Missouri | 2799 | 44 | |
733750 | 733750 | 2020-11-15 | Joplin | Missouri | 2762 | 44 | |
730505 | 730505 | 2020-11-14 | Joplin | Missouri | 2762 | 44 | |
727262 | 727262 | 2020-11-13 | Joplin | Missouri | 2641 | 44 | |
724019 | 724019 | 2020-11-12 | Joplin | Missouri | 2581 | 41 | |
720776 | 720776 | 2020-11-11 | Joplin | Missouri | 2516 | 37 | |
717533 | 717533 | 2020-11-10 | Joplin | Missouri | 2461 | 35 | |
714289 | 714289 | 2020-11-09 | Joplin | Missouri | 2437 | 34 | |
711045 | 711045 | 2020-11-08 | Joplin | Missouri | 2421 | 34 | |
707801 | 707801 | 2020-11-07 | Joplin | Missouri | 2367 | 34 | |
704558 | 704558 | 2020-11-06 | Joplin | Missouri | 2308 | 33 | |
701316 | 701316 | 2020-11-05 | Joplin | Missouri | 2276 | 32 | |
698072 | 698072 | 2020-11-04 | Joplin | Missouri | 2250 | 32 | |
694829 | 694829 | 2020-11-03 | Joplin | Missouri | 2197 | 32 | |
691587 | 691587 | 2020-11-02 | Joplin | Missouri | 2188 | 32 | |
688342 | 688342 | 2020-11-01 | Joplin | Missouri | 2172 | 32 | |
685098 | 685098 | 2020-10-31 | Joplin | Missouri | 2146 | 32 | |
681855 | 681855 | 2020-10-30 | Joplin | Missouri | 2113 | 31 | |
678611 | 678611 | 2020-10-29 | Joplin | Missouri | 2072 | 31 | |
675369 | 675369 | 2020-10-28 | Joplin | Missouri | 2053 | 31 | |
672126 | 672126 | 2020-10-27 | Joplin | Missouri | 1993 | 30 | |
668884 | 668884 | 2020-10-26 | Joplin | Missouri | 1969 | 30 | |
665640 | 665640 | 2020-10-25 | Joplin | Missouri | 1961 | 29 | |
662395 | 662395 | 2020-10-24 | Joplin | Missouri | 1940 | 29 | |
659151 | 659151 | 2020-10-23 | Joplin | Missouri | 1906 | 28 | |
655906 | 655906 | 2020-10-22 | Joplin | Missouri | 1874 | 28 | |
652661 | 652661 | 2020-10-21 | Joplin | Missouri | 1842 | 28 | |
649416 | 649416 | 2020-10-20 | Joplin | Missouri | 1799 | 27 | |
646172 | 646172 | 2020-10-19 | Joplin | Missouri | 1799 | 27 | |
642926 | 642926 | 2020-10-18 | Joplin | Missouri | 1799 | 27 | |
639678 | 639678 | 2020-10-17 | Joplin | Missouri | 1788 | 27 | |
636432 | 636432 | 2020-10-16 | Joplin | Missouri | 1752 | 23 | |
633186 | 633186 | 2020-10-15 | Joplin | Missouri | 1736 | 23 | |
629941 | 629941 | 2020-10-14 | Joplin | Missouri | 1710 | 25 | |
626697 | 626697 | 2020-10-13 | Joplin | Missouri | 2240 | 26 | |
623455 | 623455 | 2020-10-12 | Joplin | Missouri | 2240 | 26 | |
620212 | 620212 | 2020-10-11 | Joplin | Missouri | 2240 | 26 | |
616970 | 616970 | 2020-10-10 | Joplin | Missouri | 2240 | 26 | |
613729 | 613729 | 2020-10-09 | Joplin | Missouri | 2150 | 26 |
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);