ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
486 rows where deaths = 15 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Kemper 106
- Humphreys 37
- Adams 22
- Jasper 20
- Smith 19
- Scott 18
- Carroll 15
- Sharkey 15
- Tippah 14
- Stone 13
- Tunica 12
- Quitman 11
- Prentiss 10
- Noxubee 9
- Amite 8
- Claiborne 8
- Copiah 8
- DeSoto 8
- Calhoun 7
- Jefferson Davis 7
- Choctaw 6
- Franklin 6
- Lawrence 6
- Lee 6
- Winston 6
- Chickasaw 5
- Hancock 5
- Leake 5
- Marshall 5
- Pontotoc 5
- …
state 1
- Mississippi · 486 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1136131 | 1136131 | 2021-03-19 | Quitman | Mississippi | 28119 | 784 | 15 |
1132885 | 1132885 | 2021-03-18 | Quitman | Mississippi | 28119 | 783 | 15 |
1129637 | 1129637 | 2021-03-17 | Quitman | Mississippi | 28119 | 783 | 15 |
1126390 | 1126390 | 2021-03-16 | Quitman | Mississippi | 28119 | 783 | 15 |
1123144 | 1123144 | 2021-03-15 | Quitman | Mississippi | 28119 | 781 | 15 |
1119897 | 1119897 | 2021-03-14 | Quitman | Mississippi | 28119 | 781 | 15 |
1116650 | 1116650 | 2021-03-13 | Quitman | Mississippi | 28119 | 781 | 15 |
1113404 | 1113404 | 2021-03-12 | Quitman | Mississippi | 28119 | 781 | 15 |
1110158 | 1110158 | 2021-03-11 | Quitman | Mississippi | 28119 | 778 | 15 |
1106912 | 1106912 | 2021-03-10 | Quitman | Mississippi | 28119 | 777 | 15 |
1103666 | 1103666 | 2021-03-09 | Quitman | Mississippi | 28119 | 775 | 15 |
1035455 | 1035455 | 2021-02-16 | Choctaw | Mississippi | 28019 | 693 | 15 |
1032210 | 1032210 | 2021-02-15 | Choctaw | Mississippi | 28019 | 692 | 15 |
1028963 | 1028963 | 2021-02-14 | Choctaw | Mississippi | 28019 | 690 | 15 |
1025717 | 1025717 | 2021-02-13 | Choctaw | Mississippi | 28019 | 684 | 15 |
1022472 | 1022472 | 2021-02-12 | Choctaw | Mississippi | 28019 | 684 | 15 |
1019227 | 1019227 | 2021-02-11 | Choctaw | Mississippi | 28019 | 682 | 15 |
947833 | 947833 | 2021-01-20 | Franklin | Mississippi | 28037 | 671 | 15 |
944586 | 944586 | 2021-01-19 | Franklin | Mississippi | 28037 | 667 | 15 |
941341 | 941341 | 2021-01-18 | Franklin | Mississippi | 28037 | 666 | 15 |
938096 | 938096 | 2021-01-17 | Franklin | Mississippi | 28037 | 664 | 15 |
934851 | 934851 | 2021-01-16 | Franklin | Mississippi | 28037 | 658 | 15 |
931606 | 931606 | 2021-01-15 | Franklin | Mississippi | 28037 | 653 | 15 |
840759 | 840759 | 2020-12-18 | Lawrence | Mississippi | 28077 | 866 | 15 |
837482 | 837482 | 2020-12-17 | Calhoun | Mississippi | 28013 | 951 | 15 |
837514 | 837514 | 2020-12-17 | Lawrence | Mississippi | 28077 | 857 | 15 |
834236 | 834236 | 2020-12-16 | Calhoun | Mississippi | 28013 | 928 | 15 |
834268 | 834268 | 2020-12-16 | Lawrence | Mississippi | 28077 | 849 | 15 |
830989 | 830989 | 2020-12-15 | Calhoun | Mississippi | 28013 | 921 | 15 |
831021 | 831021 | 2020-12-15 | Lawrence | Mississippi | 28077 | 838 | 15 |
827743 | 827743 | 2020-12-14 | Calhoun | Mississippi | 28013 | 913 | 15 |
827775 | 827775 | 2020-12-14 | Lawrence | Mississippi | 28077 | 829 | 15 |
824496 | 824496 | 2020-12-13 | Calhoun | Mississippi | 28013 | 907 | 15 |
824528 | 824528 | 2020-12-13 | Lawrence | Mississippi | 28077 | 824 | 15 |
821250 | 821250 | 2020-12-12 | Calhoun | Mississippi | 28013 | 904 | 15 |
818004 | 818004 | 2020-12-11 | Calhoun | Mississippi | 28013 | 897 | 15 |
818063 | 818063 | 2020-12-11 | Stone | Mississippi | 28131 | 942 | 15 |
818075 | 818075 | 2020-12-11 | Webster | Mississippi | 28155 | 556 | 15 |
814759 | 814759 | 2020-12-10 | Carroll | Mississippi | 28015 | 829 | 15 |
814817 | 814817 | 2020-12-10 | Stone | Mississippi | 28131 | 925 | 15 |
814829 | 814829 | 2020-12-10 | Webster | Mississippi | 28155 | 536 | 15 |
811514 | 811514 | 2020-12-09 | Carroll | Mississippi | 28015 | 819 | 15 |
811572 | 811572 | 2020-12-09 | Stone | Mississippi | 28131 | 911 | 15 |
808264 | 808264 | 2020-12-08 | Amite | Mississippi | 28005 | 659 | 15 |
808269 | 808269 | 2020-12-08 | Carroll | Mississippi | 28015 | 813 | 15 |
808327 | 808327 | 2020-12-08 | Stone | Mississippi | 28131 | 895 | 15 |
805019 | 805019 | 2020-12-07 | Amite | Mississippi | 28005 | 651 | 15 |
805024 | 805024 | 2020-12-07 | Carroll | Mississippi | 28015 | 806 | 15 |
805082 | 805082 | 2020-12-07 | Stone | Mississippi | 28131 | 886 | 15 |
801774 | 801774 | 2020-12-06 | Amite | Mississippi | 28005 | 645 | 15 |
801779 | 801779 | 2020-12-06 | Carroll | Mississippi | 28015 | 802 | 15 |
801837 | 801837 | 2020-12-06 | Stone | Mississippi | 28131 | 867 | 15 |
798529 | 798529 | 2020-12-05 | Amite | Mississippi | 28005 | 629 | 15 |
798534 | 798534 | 2020-12-05 | Carroll | Mississippi | 28015 | 795 | 15 |
798592 | 798592 | 2020-12-05 | Stone | Mississippi | 28131 | 859 | 15 |
795284 | 795284 | 2020-12-04 | Amite | Mississippi | 28005 | 618 | 15 |
795289 | 795289 | 2020-12-04 | Carroll | Mississippi | 28015 | 781 | 15 |
795347 | 795347 | 2020-12-04 | Stone | Mississippi | 28131 | 851 | 15 |
792039 | 792039 | 2020-12-03 | Amite | Mississippi | 28005 | 593 | 15 |
792044 | 792044 | 2020-12-03 | Carroll | Mississippi | 28015 | 763 | 15 |
792102 | 792102 | 2020-12-03 | Stone | Mississippi | 28131 | 831 | 15 |
788794 | 788794 | 2020-12-02 | Amite | Mississippi | 28005 | 576 | 15 |
788799 | 788799 | 2020-12-02 | Carroll | Mississippi | 28015 | 755 | 15 |
788857 | 788857 | 2020-12-02 | Stone | Mississippi | 28131 | 820 | 15 |
785549 | 785549 | 2020-12-01 | Amite | Mississippi | 28005 | 566 | 15 |
785554 | 785554 | 2020-12-01 | Carroll | Mississippi | 28015 | 741 | 15 |
785612 | 785612 | 2020-12-01 | Stone | Mississippi | 28131 | 806 | 15 |
782310 | 782310 | 2020-11-30 | Carroll | Mississippi | 28015 | 740 | 15 |
782368 | 782368 | 2020-11-30 | Stone | Mississippi | 28131 | 800 | 15 |
779064 | 779064 | 2020-11-29 | Carroll | Mississippi | 28015 | 738 | 15 |
779122 | 779122 | 2020-11-29 | Stone | Mississippi | 28131 | 785 | 15 |
775819 | 775819 | 2020-11-28 | Carroll | Mississippi | 28015 | 724 | 15 |
772574 | 772574 | 2020-11-27 | Carroll | Mississippi | 28015 | 721 | 15 |
769329 | 769329 | 2020-11-26 | Carroll | Mississippi | 28015 | 714 | 15 |
759620 | 759620 | 2020-11-23 | Kemper | Mississippi | 28069 | 408 | 15 |
756373 | 756373 | 2020-11-22 | Kemper | Mississippi | 28069 | 406 | 15 |
753127 | 753127 | 2020-11-21 | Kemper | Mississippi | 28069 | 405 | 15 |
749881 | 749881 | 2020-11-20 | Kemper | Mississippi | 28069 | 395 | 15 |
746635 | 746635 | 2020-11-19 | Kemper | Mississippi | 28069 | 392 | 15 |
743388 | 743388 | 2020-11-18 | Kemper | Mississippi | 28069 | 380 | 15 |
740141 | 740141 | 2020-11-17 | Kemper | Mississippi | 28069 | 365 | 15 |
736895 | 736895 | 2020-11-16 | Jefferson Davis | Mississippi | 28065 | 513 | 15 |
736897 | 736897 | 2020-11-16 | Kemper | Mississippi | 28069 | 362 | 15 |
733649 | 733649 | 2020-11-15 | Jefferson Davis | Mississippi | 28065 | 511 | 15 |
733651 | 733651 | 2020-11-15 | Kemper | Mississippi | 28069 | 361 | 15 |
730404 | 730404 | 2020-11-14 | Jefferson Davis | Mississippi | 28065 | 504 | 15 |
730406 | 730406 | 2020-11-14 | Kemper | Mississippi | 28069 | 358 | 15 |
727161 | 727161 | 2020-11-13 | Jefferson Davis | Mississippi | 28065 | 494 | 15 |
727163 | 727163 | 2020-11-13 | Kemper | Mississippi | 28069 | 356 | 15 |
723918 | 723918 | 2020-11-12 | Jefferson Davis | Mississippi | 28065 | 492 | 15 |
723920 | 723920 | 2020-11-12 | Kemper | Mississippi | 28069 | 354 | 15 |
720647 | 720647 | 2020-11-11 | Benton | Mississippi | 28009 | 425 | 15 |
720675 | 720675 | 2020-11-11 | Jefferson Davis | Mississippi | 28065 | 486 | 15 |
720677 | 720677 | 2020-11-11 | Kemper | Mississippi | 28069 | 351 | 15 |
717404 | 717404 | 2020-11-10 | Benton | Mississippi | 28009 | 418 | 15 |
717432 | 717432 | 2020-11-10 | Jefferson Davis | Mississippi | 28065 | 475 | 15 |
717434 | 717434 | 2020-11-10 | Kemper | Mississippi | 28069 | 348 | 15 |
717462 | 717462 | 2020-11-10 | Sharkey | Mississippi | 28125 | 293 | 15 |
714190 | 714190 | 2020-11-09 | Kemper | Mississippi | 28069 | 345 | 15 |
714218 | 714218 | 2020-11-09 | Sharkey | Mississippi | 28125 | 293 | 15 |
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);