ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64,147 rows where state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 28035 416
- 28083 415
- 28109 415
- 28029 414
- 28049 413
- 28045 412
- 28095 412
- 28047 411
- 28059 411
- 28089 410
- 28111 410
- 28011 409
- 28027 409
- 28033 409
- 28051 409
- 28067 409
- 28123 409
- 28147 409
- 28157 409
- 28159 409
- 28163 409
- 28037 408
- 28053 408
- 28071 408
- 28077 408
- 28081 408
- 28093 408
- 28113 408
- 28121 408
- 28129 408
- …
county >30
- Forrest 416
- Leflore 415
- Pearl River 415
- Copiah 414
- Hinds 413
- Hancock 412
- Monroe 412
- Harrison 411
- Jackson 411
- Madison 410
- Perry 410
- Bolivar 409
- Coahoma 409
- DeSoto 409
- Holmes 409
- Jones 409
- Scott 409
- Walthall 409
- Wilkinson 409
- Winston 409
- Yazoo 409
- Franklin 408
- Humphreys 408
- Lafayette 408
- Lawrence 408
- Lee 408
- Marshall 408
- Pike 408
- Rankin 408
- Smith 408
- …
state 1
- Mississippi · 33,158 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1275729 | 1275729 | 2021-05-01 | Franklin | Mississippi | 28037 | 831 | 23 |
1275730 | 1275730 | 2021-05-01 | George | Mississippi | 28039 | 2452 | 47 |
1275731 | 1275731 | 2021-05-01 | Greene | Mississippi | 28041 | 1300 | 33 |
1275732 | 1275732 | 2021-05-01 | Grenada | Mississippi | 28043 | 2590 | 85 |
1275733 | 1275733 | 2021-05-01 | Hancock | Mississippi | 28045 | 3759 | 86 |
1275734 | 1275734 | 2021-05-01 | Harrison | Mississippi | 28047 | 17735 | 306 |
1275735 | 1275735 | 2021-05-01 | Hinds | Mississippi | 28049 | 20214 | 414 |
1275736 | 1275736 | 2021-05-01 | Holmes | Mississippi | 28051 | 1882 | 72 |
1275737 | 1275737 | 2021-05-01 | Humphreys | Mississippi | 28053 | 953 | 32 |
1275738 | 1275738 | 2021-05-01 | Issaquena | Mississippi | 28055 | 168 | 6 |
1275739 | 1275739 | 2021-05-01 | Itawamba | Mississippi | 28057 | 2990 | 77 |
1275740 | 1275740 | 2021-05-01 | Jackson | Mississippi | 28059 | 13363 | 246 |
1275741 | 1275741 | 2021-05-01 | Jasper | Mississippi | 28061 | 2206 | 48 |
1275742 | 1275742 | 2021-05-01 | Jefferson | Mississippi | 28063 | 651 | 28 |
1275743 | 1275743 | 2021-05-01 | Jefferson Davis | Mississippi | 28065 | 1067 | 32 |
1275744 | 1275744 | 2021-05-01 | Jones | Mississippi | 28067 | 8354 | 163 |
1275745 | 1275745 | 2021-05-01 | Kemper | Mississippi | 28069 | 958 | 28 |
1275746 | 1275746 | 2021-05-01 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1275747 | 1275747 | 2021-05-01 | Lamar | Mississippi | 28073 | 6191 | 85 |
1275748 | 1275748 | 2021-05-01 | Lauderdale | Mississippi | 28075 | 7218 | 240 |
1275749 | 1275749 | 2021-05-01 | Lawrence | Mississippi | 28077 | 1281 | 23 |
1275750 | 1275750 | 2021-05-01 | Leake | Mississippi | 28079 | 2640 | 73 |
1275751 | 1275751 | 2021-05-01 | Lee | Mississippi | 28081 | 9944 | 171 |
1275752 | 1275752 | 2021-05-01 | Leflore | Mississippi | 28083 | 3484 | 125 |
1275753 | 1275753 | 2021-05-01 | Lincoln | Mississippi | 28085 | 3928 | 110 |
1275754 | 1275754 | 2021-05-01 | Lowndes | Mississippi | 28087 | 6348 | 144 |
1275755 | 1275755 | 2021-05-01 | Madison | Mississippi | 28089 | 10035 | 215 |
1275756 | 1275756 | 2021-05-01 | Marion | Mississippi | 28091 | 2684 | 80 |
1275757 | 1275757 | 2021-05-01 | Marshall | Mississippi | 28093 | 4368 | 103 |
1275758 | 1275758 | 2021-05-01 | Monroe | Mississippi | 28095 | 4084 | 133 |
1275759 | 1275759 | 2021-05-01 | Montgomery | Mississippi | 28097 | 1262 | 42 |
1275760 | 1275760 | 2021-05-01 | Neshoba | Mississippi | 28099 | 4021 | 176 |
1275761 | 1275761 | 2021-05-01 | Newton | Mississippi | 28101 | 2470 | 61 |
1275762 | 1275762 | 2021-05-01 | Noxubee | Mississippi | 28103 | 1268 | 34 |
1275763 | 1275763 | 2021-05-01 | Oktibbeha | Mississippi | 28105 | 4593 | 98 |
1275764 | 1275764 | 2021-05-01 | Panola | Mississippi | 28107 | 4530 | 103 |
1275765 | 1275765 | 2021-05-01 | Pearl River | Mississippi | 28109 | 4482 | 144 |
1275766 | 1275766 | 2021-05-01 | Perry | Mississippi | 28111 | 1259 | 38 |
1275767 | 1275767 | 2021-05-01 | Pike | Mississippi | 28113 | 3280 | 105 |
1275768 | 1275768 | 2021-05-01 | Pontotoc | Mississippi | 28115 | 4188 | 72 |
1275769 | 1275769 | 2021-05-01 | Prentiss | Mississippi | 28117 | 2780 | 59 |
1275770 | 1275770 | 2021-05-01 | Quitman | Mississippi | 28119 | 795 | 16 |
1275771 | 1275771 | 2021-05-01 | Rankin | Mississippi | 28121 | 13520 | 278 |
1275772 | 1275772 | 2021-05-01 | Scott | Mississippi | 28123 | 3139 | 73 |
1275773 | 1275773 | 2021-05-01 | Sharkey | Mississippi | 28125 | 501 | 17 |
1275774 | 1275774 | 2021-05-01 | Simpson | Mississippi | 28127 | 2935 | 88 |
1275775 | 1275775 | 2021-05-01 | Smith | Mississippi | 28129 | 1619 | 34 |
1275776 | 1275776 | 2021-05-01 | Stone | Mississippi | 28131 | 1808 | 33 |
1275777 | 1275777 | 2021-05-01 | Sunflower | Mississippi | 28133 | 3346 | 90 |
1275778 | 1275778 | 2021-05-01 | Tallahatchie | Mississippi | 28135 | 1771 | 40 |
1275779 | 1275779 | 2021-05-01 | Tate | Mississippi | 28137 | 3309 | 84 |
1275780 | 1275780 | 2021-05-01 | Tippah | Mississippi | 28139 | 2868 | 68 |
1275781 | 1275781 | 2021-05-01 | Tishomingo | Mississippi | 28141 | 2244 | 67 |
1275782 | 1275782 | 2021-05-01 | Tunica | Mississippi | 28143 | 1044 | 25 |
1275783 | 1275783 | 2021-05-01 | Union | Mississippi | 28145 | 4079 | 76 |
1275784 | 1275784 | 2021-05-01 | Walthall | Mississippi | 28147 | 1335 | 45 |
1275785 | 1275785 | 2021-05-01 | Warren | Mississippi | 28149 | 4348 | 119 |
1275786 | 1275786 | 2021-05-01 | Washington | Mississippi | 28151 | 5313 | 133 |
1275787 | 1275787 | 2021-05-01 | Wayne | Mississippi | 28153 | 2622 | 41 |
1275788 | 1275788 | 2021-05-01 | Webster | Mississippi | 28155 | 1145 | 32 |
1275789 | 1275789 | 2021-05-01 | Wilkinson | Mississippi | 28157 | 665 | 30 |
1275790 | 1275790 | 2021-05-01 | Winston | Mississippi | 28159 | 2267 | 81 |
1275791 | 1275791 | 2021-05-01 | Yalobusha | Mississippi | 28161 | 1617 | 36 |
1275792 | 1275792 | 2021-05-01 | Yazoo | Mississippi | 28163 | 3095 | 69 |
1272464 | 1272464 | 2021-04-30 | Adams | Mississippi | 28001 | 2567 | 82 |
1272465 | 1272465 | 2021-04-30 | Alcorn | Mississippi | 28003 | 3097 | 68 |
1272466 | 1272466 | 2021-04-30 | Amite | Mississippi | 28005 | 1227 | 41 |
1272467 | 1272467 | 2021-04-30 | Attala | Mississippi | 28007 | 2142 | 73 |
1272468 | 1272468 | 2021-04-30 | Benton | Mississippi | 28009 | 984 | 25 |
1272469 | 1272469 | 2021-04-30 | Bolivar | Mississippi | 28011 | 4793 | 131 |
1272470 | 1272470 | 2021-04-30 | Calhoun | Mississippi | 28013 | 1685 | 32 |
1272471 | 1272471 | 2021-04-30 | Carroll | Mississippi | 28015 | 1215 | 27 |
1272472 | 1272472 | 2021-04-30 | Chickasaw | Mississippi | 28017 | 2065 | 57 |
1272473 | 1272473 | 2021-04-30 | Choctaw | Mississippi | 28019 | 752 | 18 |
1272474 | 1272474 | 2021-04-30 | Claiborne | Mississippi | 28021 | 1021 | 30 |
1272475 | 1272475 | 2021-04-30 | Clarke | Mississippi | 28023 | 1782 | 79 |
1272476 | 1272476 | 2021-04-30 | Clay | Mississippi | 28025 | 1843 | 54 |
1272477 | 1272477 | 2021-04-30 | Coahoma | Mississippi | 28027 | 2931 | 79 |
1272478 | 1272478 | 2021-04-30 | Copiah | Mississippi | 28029 | 2957 | 65 |
1272479 | 1272479 | 2021-04-30 | Covington | Mississippi | 28031 | 2560 | 80 |
1272480 | 1272480 | 2021-04-30 | DeSoto | Mississippi | 28033 | 21321 | 256 |
1272481 | 1272481 | 2021-04-30 | Forrest | Mississippi | 28035 | 7620 | 149 |
1272482 | 1272482 | 2021-04-30 | Franklin | Mississippi | 28037 | 831 | 23 |
1272483 | 1272483 | 2021-04-30 | George | Mississippi | 28039 | 2452 | 47 |
1272484 | 1272484 | 2021-04-30 | Greene | Mississippi | 28041 | 1300 | 33 |
1272485 | 1272485 | 2021-04-30 | Grenada | Mississippi | 28043 | 2590 | 85 |
1272486 | 1272486 | 2021-04-30 | Hancock | Mississippi | 28045 | 3759 | 86 |
1272487 | 1272487 | 2021-04-30 | Harrison | Mississippi | 28047 | 17735 | 306 |
1272488 | 1272488 | 2021-04-30 | Hinds | Mississippi | 28049 | 20214 | 414 |
1272489 | 1272489 | 2021-04-30 | Holmes | Mississippi | 28051 | 1882 | 72 |
1272490 | 1272490 | 2021-04-30 | Humphreys | Mississippi | 28053 | 953 | 32 |
1272491 | 1272491 | 2021-04-30 | Issaquena | Mississippi | 28055 | 168 | 6 |
1272492 | 1272492 | 2021-04-30 | Itawamba | Mississippi | 28057 | 2990 | 77 |
1272493 | 1272493 | 2021-04-30 | Jackson | Mississippi | 28059 | 13363 | 246 |
1272494 | 1272494 | 2021-04-30 | Jasper | Mississippi | 28061 | 2206 | 48 |
1272495 | 1272495 | 2021-04-30 | Jefferson | Mississippi | 28063 | 651 | 28 |
1272496 | 1272496 | 2021-04-30 | Jefferson Davis | Mississippi | 28065 | 1067 | 32 |
1272497 | 1272497 | 2021-04-30 | Jones | Mississippi | 28067 | 8354 | 163 |
1272498 | 1272498 | 2021-04-30 | Kemper | Mississippi | 28069 | 958 | 28 |
1272499 | 1272499 | 2021-04-30 | Lafayette | Mississippi | 28071 | 6142 | 118 |
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);