ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "DeSoto" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918623 | 918623 | 2021-01-11 | DeSoto | Mississippi | 28033 | 16358 | 155 |
915378 | 915378 | 2021-01-10 | DeSoto | Mississippi | 28033 | 16277 | 154 |
912133 | 912133 | 2021-01-09 | DeSoto | Mississippi | 28033 | 16090 | 152 |
908888 | 908888 | 2021-01-08 | DeSoto | Mississippi | 28033 | 15910 | 151 |
905642 | 905642 | 2021-01-07 | DeSoto | Mississippi | 28033 | 15775 | 149 |
902397 | 902397 | 2021-01-06 | DeSoto | Mississippi | 28033 | 15586 | 148 |
899152 | 899152 | 2021-01-05 | DeSoto | Mississippi | 28033 | 15363 | 145 |
895907 | 895907 | 2021-01-04 | DeSoto | Mississippi | 28033 | 15263 | 141 |
892660 | 892660 | 2021-01-03 | DeSoto | Mississippi | 28033 | 15142 | 141 |
889414 | 889414 | 2021-01-02 | DeSoto | Mississippi | 28033 | 15023 | 139 |
886168 | 886168 | 2021-01-01 | DeSoto | Mississippi | 28033 | 14885 | 139 |
882923 | 882923 | 2020-12-31 | DeSoto | Mississippi | 28033 | 14714 | 139 |
879678 | 879678 | 2020-12-30 | DeSoto | Mississippi | 28033 | 14512 | 137 |
876433 | 876433 | 2020-12-29 | DeSoto | Mississippi | 28033 | 14287 | 135 |
873188 | 873188 | 2020-12-28 | DeSoto | Mississippi | 28033 | 14149 | 135 |
869943 | 869943 | 2020-12-27 | DeSoto | Mississippi | 28033 | 14005 | 133 |
866698 | 866698 | 2020-12-26 | DeSoto | Mississippi | 28033 | 13932 | 132 |
863453 | 863453 | 2020-12-25 | DeSoto | Mississippi | 28033 | 13822 | 131 |
860208 | 860208 | 2020-12-24 | DeSoto | Mississippi | 28033 | 13674 | 129 |
856963 | 856963 | 2020-12-23 | DeSoto | Mississippi | 28033 | 13485 | 128 |
853718 | 853718 | 2020-12-22 | DeSoto | Mississippi | 28033 | 13307 | 128 |
850473 | 850473 | 2020-12-21 | DeSoto | Mississippi | 28033 | 13165 | 128 |
847228 | 847228 | 2020-12-20 | DeSoto | Mississippi | 28033 | 13081 | 128 |
843982 | 843982 | 2020-12-19 | DeSoto | Mississippi | 28033 | 12853 | 127 |
840737 | 840737 | 2020-12-18 | DeSoto | Mississippi | 28033 | 12746 | 121 |
837492 | 837492 | 2020-12-17 | DeSoto | Mississippi | 28033 | 12561 | 117 |
834246 | 834246 | 2020-12-16 | DeSoto | Mississippi | 28033 | 12433 | 116 |
830999 | 830999 | 2020-12-15 | DeSoto | Mississippi | 28033 | 12217 | 115 |
827753 | 827753 | 2020-12-14 | DeSoto | Mississippi | 28033 | 12089 | 114 |
824506 | 824506 | 2020-12-13 | DeSoto | Mississippi | 28033 | 11976 | 114 |
821260 | 821260 | 2020-12-12 | DeSoto | Mississippi | 28033 | 11868 | 114 |
818014 | 818014 | 2020-12-11 | DeSoto | Mississippi | 28033 | 11694 | 111 |
814768 | 814768 | 2020-12-10 | DeSoto | Mississippi | 28033 | 11503 | 110 |
811523 | 811523 | 2020-12-09 | DeSoto | Mississippi | 28033 | 11375 | 110 |
808278 | 808278 | 2020-12-08 | DeSoto | Mississippi | 28033 | 11203 | 110 |
805033 | 805033 | 2020-12-07 | DeSoto | Mississippi | 28033 | 11132 | 106 |
801788 | 801788 | 2020-12-06 | DeSoto | Mississippi | 28033 | 11051 | 106 |
798543 | 798543 | 2020-12-05 | DeSoto | Mississippi | 28033 | 10942 | 106 |
795298 | 795298 | 2020-12-04 | DeSoto | Mississippi | 28033 | 10863 | 104 |
792053 | 792053 | 2020-12-03 | DeSoto | Mississippi | 28033 | 10708 | 104 |
788808 | 788808 | 2020-12-02 | DeSoto | Mississippi | 28033 | 10563 | 104 |
785563 | 785563 | 2020-12-01 | DeSoto | Mississippi | 28033 | 10409 | 104 |
782319 | 782319 | 2020-11-30 | DeSoto | Mississippi | 28033 | 10332 | 104 |
779073 | 779073 | 2020-11-29 | DeSoto | Mississippi | 28033 | 10249 | 104 |
775828 | 775828 | 2020-11-28 | DeSoto | Mississippi | 28033 | 10097 | 104 |
772583 | 772583 | 2020-11-27 | DeSoto | Mississippi | 28033 | 9953 | 104 |
769338 | 769338 | 2020-11-26 | DeSoto | Mississippi | 28033 | 9874 | 101 |
766092 | 766092 | 2020-11-25 | DeSoto | Mississippi | 28033 | 9731 | 99 |
762847 | 762847 | 2020-11-24 | DeSoto | Mississippi | 28033 | 9632 | 99 |
759602 | 759602 | 2020-11-23 | DeSoto | Mississippi | 28033 | 9569 | 99 |
756355 | 756355 | 2020-11-22 | DeSoto | Mississippi | 28033 | 9527 | 99 |
753109 | 753109 | 2020-11-21 | DeSoto | Mississippi | 28033 | 9467 | 97 |
749863 | 749863 | 2020-11-20 | DeSoto | Mississippi | 28033 | 9358 | 97 |
746617 | 746617 | 2020-11-19 | DeSoto | Mississippi | 28033 | 9232 | 93 |
743370 | 743370 | 2020-11-18 | DeSoto | Mississippi | 28033 | 9117 | 92 |
740123 | 740123 | 2020-11-17 | DeSoto | Mississippi | 28033 | 8985 | 91 |
736879 | 736879 | 2020-11-16 | DeSoto | Mississippi | 28033 | 8912 | 87 |
733633 | 733633 | 2020-11-15 | DeSoto | Mississippi | 28033 | 8857 | 87 |
730388 | 730388 | 2020-11-14 | DeSoto | Mississippi | 28033 | 8763 | 87 |
727145 | 727145 | 2020-11-13 | DeSoto | Mississippi | 28033 | 8656 | 86 |
723902 | 723902 | 2020-11-12 | DeSoto | Mississippi | 28033 | 8535 | 85 |
720659 | 720659 | 2020-11-11 | DeSoto | Mississippi | 28033 | 8430 | 85 |
717416 | 717416 | 2020-11-10 | DeSoto | Mississippi | 28033 | 8328 | 85 |
714172 | 714172 | 2020-11-09 | DeSoto | Mississippi | 28033 | 8229 | 84 |
710928 | 710928 | 2020-11-08 | DeSoto | Mississippi | 28033 | 8159 | 84 |
707684 | 707684 | 2020-11-07 | DeSoto | Mississippi | 28033 | 8108 | 83 |
704441 | 704441 | 2020-11-06 | DeSoto | Mississippi | 28033 | 8036 | 82 |
701199 | 701199 | 2020-11-05 | DeSoto | Mississippi | 28033 | 7916 | 82 |
697955 | 697955 | 2020-11-04 | DeSoto | Mississippi | 28033 | 7729 | 82 |
694712 | 694712 | 2020-11-03 | DeSoto | Mississippi | 28033 | 7691 | 82 |
691470 | 691470 | 2020-11-02 | DeSoto | Mississippi | 28033 | 7632 | 81 |
688225 | 688225 | 2020-11-01 | DeSoto | Mississippi | 28033 | 7552 | 81 |
684981 | 684981 | 2020-10-31 | DeSoto | Mississippi | 28033 | 7492 | 80 |
681738 | 681738 | 2020-10-30 | DeSoto | Mississippi | 28033 | 7422 | 80 |
678494 | 678494 | 2020-10-29 | DeSoto | Mississippi | 28033 | 7342 | 80 |
675252 | 675252 | 2020-10-28 | DeSoto | Mississippi | 28033 | 7285 | 80 |
672009 | 672009 | 2020-10-27 | DeSoto | Mississippi | 28033 | 7210 | 79 |
668767 | 668767 | 2020-10-26 | DeSoto | Mississippi | 28033 | 7134 | 79 |
665523 | 665523 | 2020-10-25 | DeSoto | Mississippi | 28033 | 7039 | 79 |
662278 | 662278 | 2020-10-24 | DeSoto | Mississippi | 28033 | 7039 | 79 |
659034 | 659034 | 2020-10-23 | DeSoto | Mississippi | 28033 | 6932 | 79 |
655789 | 655789 | 2020-10-22 | DeSoto | Mississippi | 28033 | 6857 | 79 |
652544 | 652544 | 2020-10-21 | DeSoto | Mississippi | 28033 | 6767 | 78 |
649299 | 649299 | 2020-10-20 | DeSoto | Mississippi | 28033 | 6701 | 78 |
646055 | 646055 | 2020-10-19 | DeSoto | Mississippi | 28033 | 6636 | 77 |
642808 | 642808 | 2020-10-18 | DeSoto | Mississippi | 28033 | 6551 | 77 |
639561 | 639561 | 2020-10-17 | DeSoto | Mississippi | 28033 | 6551 | 77 |
636315 | 636315 | 2020-10-16 | DeSoto | Mississippi | 28033 | 6495 | 77 |
633069 | 633069 | 2020-10-15 | DeSoto | Mississippi | 28033 | 6401 | 77 |
629824 | 629824 | 2020-10-14 | DeSoto | Mississippi | 28033 | 6302 | 77 |
626580 | 626580 | 2020-10-13 | DeSoto | Mississippi | 28033 | 6238 | 75 |
623338 | 623338 | 2020-10-12 | DeSoto | Mississippi | 28033 | 6189 | 75 |
620095 | 620095 | 2020-10-11 | DeSoto | Mississippi | 28033 | 6148 | 75 |
616853 | 616853 | 2020-10-10 | DeSoto | Mississippi | 28033 | 6123 | 75 |
613612 | 613612 | 2020-10-09 | DeSoto | Mississippi | 28033 | 6076 | 74 |
610370 | 610370 | 2020-10-08 | DeSoto | Mississippi | 28033 | 6019 | 72 |
607128 | 607128 | 2020-10-07 | DeSoto | Mississippi | 28033 | 5994 | 71 |
603885 | 603885 | 2020-10-06 | DeSoto | Mississippi | 28033 | 5947 | 70 |
600643 | 600643 | 2020-10-05 | DeSoto | Mississippi | 28033 | 5825 | 70 |
597400 | 597400 | 2020-10-04 | DeSoto | Mississippi | 28033 | 5811 | 70 |
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);