ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
688 rows where county = "Joplin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055054 | 1055054 | 2021-02-22 | Joplin | Missouri | 4756 | 100 | |
1051807 | 1051807 | 2021-02-21 | Joplin | Missouri | 4754 | 100 | |
1048560 | 1048560 | 2021-02-20 | Joplin | Missouri | 4748 | 100 | |
1045314 | 1045314 | 2021-02-19 | Joplin | Missouri | 4746 | 100 | |
1042069 | 1042069 | 2021-02-18 | Joplin | Missouri | 4740 | 100 | |
1038824 | 1038824 | 2021-02-17 | Joplin | Missouri | 4734 | 100 | |
1035579 | 1035579 | 2021-02-16 | Joplin | Missouri | 4737 | 100 | |
1032334 | 1032334 | 2021-02-15 | Joplin | Missouri | 4733 | 100 | |
1029087 | 1029087 | 2021-02-14 | Joplin | Missouri | 4729 | 100 | |
1025841 | 1025841 | 2021-02-13 | Joplin | Missouri | 4723 | 100 | |
1022596 | 1022596 | 2021-02-12 | Joplin | Missouri | 4716 | 100 | |
1019351 | 1019351 | 2021-02-11 | Joplin | Missouri | 4714 | 100 | |
1016106 | 1016106 | 2021-02-10 | Joplin | Missouri | 4702 | 99 | |
1012861 | 1012861 | 2021-02-09 | Joplin | Missouri | 4696 | 99 | |
1009616 | 1009616 | 2021-02-08 | Joplin | Missouri | 4686 | 99 | |
1006369 | 1006369 | 2021-02-07 | Joplin | Missouri | 4679 | 99 | |
1003123 | 1003123 | 2021-02-06 | Joplin | Missouri | 4674 | 99 | |
999878 | 999878 | 2021-02-05 | Joplin | Missouri | 4659 | 99 | |
996632 | 996632 | 2021-02-04 | Joplin | Missouri | 4655 | 99 | |
993386 | 993386 | 2021-02-03 | Joplin | Missouri | 4642 | 96 | |
990140 | 990140 | 2021-02-02 | Joplin | Missouri | 4613 | 96 | |
986893 | 986893 | 2021-02-01 | Joplin | Missouri | 4588 | 94 | |
983646 | 983646 | 2021-01-31 | Joplin | Missouri | 4575 | 94 | |
980400 | 980400 | 2021-01-30 | Joplin | Missouri | 4567 | 94 | |
977154 | 977154 | 2021-01-29 | Joplin | Missouri | 4549 | 94 | |
973909 | 973909 | 2021-01-28 | Joplin | Missouri | 4535 | 92 | |
970664 | 970664 | 2021-01-27 | Joplin | Missouri | 4504 | 92 | |
967419 | 967419 | 2021-01-26 | Joplin | Missouri | 4492 | 92 | |
964175 | 964175 | 2021-01-25 | Joplin | Missouri | 4469 | 92 | |
960930 | 960930 | 2021-01-24 | Joplin | Missouri | 4466 | 92 | |
957684 | 957684 | 2021-01-23 | Joplin | Missouri | 4451 | 88 | |
954439 | 954439 | 2021-01-22 | Joplin | Missouri | 4437 | 88 | |
951194 | 951194 | 2021-01-21 | Joplin | Missouri | 4409 | 88 | |
947948 | 947948 | 2021-01-20 | Joplin | Missouri | 4392 | 88 | |
944701 | 944701 | 2021-01-19 | Joplin | Missouri | 4387 | 88 | |
941456 | 941456 | 2021-01-18 | Joplin | Missouri | 4367 | 88 | |
938211 | 938211 | 2021-01-17 | Joplin | Missouri | 4349 | 88 | |
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 |
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);