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 347
- 28083 346
- 28109 346
- 28029 345
- 28049 344
- 28045 343
- 28095 343
- 28047 342
- 28059 342
- 28089 341
- 28111 341
- 28011 340
- 28027 340
- 28033 340
- 28051 340
- 28067 340
- 28123 340
- 28147 340
- 28157 340
- 28159 340
- 28163 340
- 28037 339
- 28053 339
- 28071 339
- 28077 339
- 28081 339
- 28093 339
- 28113 339
- 28121 339
- 28129 339
- …
county >30
- Forrest 347
- Leflore 346
- Pearl River 346
- Copiah 345
- Hinds 344
- Hancock 343
- Monroe 343
- Harrison 342
- Jackson 342
- Madison 341
- Perry 341
- Bolivar 340
- Coahoma 340
- DeSoto 340
- Holmes 340
- Jones 340
- Scott 340
- Walthall 340
- Wilkinson 340
- Winston 340
- Yazoo 340
- Franklin 339
- Humphreys 339
- Lafayette 339
- Lawrence 339
- Lee 339
- Marshall 339
- Pike 339
- Rankin 339
- Smith 339
- …
state 1
- Mississippi · 27,500 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1051692 | 1051692 | 2021-02-21 | Franklin | Mississippi | 28037 | 750 | 19 |
1051693 | 1051693 | 2021-02-21 | George | Mississippi | 28039 | 2293 | 45 |
1051694 | 1051694 | 2021-02-21 | Greene | Mississippi | 28041 | 1261 | 33 |
1051695 | 1051695 | 2021-02-21 | Grenada | Mississippi | 28043 | 2440 | 75 |
1051696 | 1051696 | 2021-02-21 | Hancock | Mississippi | 28045 | 3366 | 73 |
1051697 | 1051697 | 2021-02-21 | Harrison | Mississippi | 28047 | 16347 | 269 |
1051698 | 1051698 | 2021-02-21 | Hinds | Mississippi | 28049 | 18532 | 382 |
1051699 | 1051699 | 2021-02-21 | Holmes | Mississippi | 28051 | 1803 | 69 |
1051700 | 1051700 | 2021-02-21 | Humphreys | Mississippi | 28053 | 911 | 26 |
1051701 | 1051701 | 2021-02-21 | Issaquena | Mississippi | 28055 | 167 | 6 |
1051702 | 1051702 | 2021-02-21 | Itawamba | Mississippi | 28057 | 2884 | 71 |
1051703 | 1051703 | 2021-02-21 | Jackson | Mississippi | 28059 | 12372 | 216 |
1051704 | 1051704 | 2021-02-21 | Jasper | Mississippi | 28061 | 2099 | 42 |
1051705 | 1051705 | 2021-02-21 | Jefferson | Mississippi | 28063 | 607 | 27 |
1051706 | 1051706 | 2021-02-21 | Jefferson Davis | Mississippi | 28065 | 997 | 31 |
1051707 | 1051707 | 2021-02-21 | Jones | Mississippi | 28067 | 7814 | 142 |
1051708 | 1051708 | 2021-02-21 | Kemper | Mississippi | 28069 | 891 | 22 |
1051709 | 1051709 | 2021-02-21 | Lafayette | Mississippi | 28071 | 5675 | 113 |
1051710 | 1051710 | 2021-02-21 | Lamar | Mississippi | 28073 | 5776 | 79 |
1051711 | 1051711 | 2021-02-21 | Lauderdale | Mississippi | 28075 | 6726 | 224 |
1051712 | 1051712 | 2021-02-21 | Lawrence | Mississippi | 28077 | 1179 | 20 |
1051713 | 1051713 | 2021-02-21 | Leake | Mississippi | 28079 | 2505 | 70 |
1051714 | 1051714 | 2021-02-21 | Lee | Mississippi | 28081 | 9620 | 160 |
1051715 | 1051715 | 2021-02-21 | Leflore | Mississippi | 28083 | 3336 | 117 |
1051716 | 1051716 | 2021-02-21 | Lincoln | Mississippi | 28085 | 3423 | 99 |
1051717 | 1051717 | 2021-02-21 | Lowndes | Mississippi | 28087 | 5961 | 137 |
1051718 | 1051718 | 2021-02-21 | Madison | Mississippi | 28089 | 9340 | 190 |
1051719 | 1051719 | 2021-02-21 | Marion | Mississippi | 28091 | 2493 | 78 |
1051720 | 1051720 | 2021-02-21 | Marshall | Mississippi | 28093 | 3952 | 92 |
1051721 | 1051721 | 2021-02-21 | Monroe | Mississippi | 28095 | 3966 | 125 |
1051722 | 1051722 | 2021-02-21 | Montgomery | Mississippi | 28097 | 1201 | 37 |
1051723 | 1051723 | 2021-02-21 | Neshoba | Mississippi | 28099 | 3740 | 165 |
1051724 | 1051724 | 2021-02-21 | Newton | Mississippi | 28101 | 2218 | 51 |
1051725 | 1051725 | 2021-02-21 | Noxubee | Mississippi | 28103 | 1222 | 29 |
1051726 | 1051726 | 2021-02-21 | Oktibbeha | Mississippi | 28105 | 4377 | 90 |
1051727 | 1051727 | 2021-02-21 | Panola | Mississippi | 28107 | 4233 | 92 |
1051728 | 1051728 | 2021-02-21 | Pearl River | Mississippi | 28109 | 4051 | 127 |
1051729 | 1051729 | 2021-02-21 | Perry | Mississippi | 28111 | 1195 | 33 |
1051730 | 1051730 | 2021-02-21 | Pike | Mississippi | 28113 | 2971 | 91 |
1051731 | 1051731 | 2021-02-21 | Pontotoc | Mississippi | 28115 | 4056 | 66 |
1051732 | 1051732 | 2021-02-21 | Prentiss | Mississippi | 28117 | 2670 | 58 |
1051733 | 1051733 | 2021-02-21 | Quitman | Mississippi | 28119 | 766 | 14 |
1051734 | 1051734 | 2021-02-21 | Rankin | Mississippi | 28121 | 12483 | 258 |
1051735 | 1051735 | 2021-02-21 | Scott | Mississippi | 28123 | 2911 | 66 |
1051736 | 1051736 | 2021-02-21 | Sharkey | Mississippi | 28125 | 488 | 17 |
1051737 | 1051737 | 2021-02-21 | Simpson | Mississippi | 28127 | 2674 | 78 |
1051738 | 1051738 | 2021-02-21 | Smith | Mississippi | 28129 | 1510 | 30 |
1051739 | 1051739 | 2021-02-21 | Stone | Mississippi | 28131 | 1704 | 29 |
1051740 | 1051740 | 2021-02-21 | Sunflower | Mississippi | 28133 | 3155 | 85 |
1051741 | 1051741 | 2021-02-21 | Tallahatchie | Mississippi | 28135 | 1687 | 39 |
1051742 | 1051742 | 2021-02-21 | Tate | Mississippi | 28137 | 2981 | 72 |
1051743 | 1051743 | 2021-02-21 | Tippah | Mississippi | 28139 | 2743 | 64 |
1051744 | 1051744 | 2021-02-21 | Tishomingo | Mississippi | 28141 | 2102 | 65 |
1051745 | 1051745 | 2021-02-21 | Tunica | Mississippi | 28143 | 975 | 23 |
1051746 | 1051746 | 2021-02-21 | Union | Mississippi | 28145 | 3904 | 72 |
1051747 | 1051747 | 2021-02-21 | Walthall | Mississippi | 28147 | 1230 | 40 |
1051748 | 1051748 | 2021-02-21 | Warren | Mississippi | 28149 | 4087 | 113 |
1051749 | 1051749 | 2021-02-21 | Washington | Mississippi | 28151 | 5123 | 128 |
1051750 | 1051750 | 2021-02-21 | Wayne | Mississippi | 28153 | 2499 | 40 |
1051751 | 1051751 | 2021-02-21 | Webster | Mississippi | 28155 | 1085 | 29 |
1051752 | 1051752 | 2021-02-21 | Wilkinson | Mississippi | 28157 | 621 | 26 |
1051753 | 1051753 | 2021-02-21 | Winston | Mississippi | 28159 | 2197 | 74 |
1051754 | 1051754 | 2021-02-21 | Yalobusha | Mississippi | 28161 | 1416 | 36 |
1051755 | 1051755 | 2021-02-21 | Yazoo | Mississippi | 28163 | 2822 | 62 |
1048427 | 1048427 | 2021-02-20 | Adams | Mississippi | 28001 | 2316 | 74 |
1048428 | 1048428 | 2021-02-20 | Alcorn | Mississippi | 28003 | 2894 | 60 |
1048429 | 1048429 | 2021-02-20 | Amite | Mississippi | 28005 | 1099 | 32 |
1048430 | 1048430 | 2021-02-20 | Attala | Mississippi | 28007 | 2056 | 69 |
1048431 | 1048431 | 2021-02-20 | Benton | Mississippi | 28009 | 923 | 24 |
1048432 | 1048432 | 2021-02-20 | Bolivar | Mississippi | 28011 | 4550 | 120 |
1048433 | 1048433 | 2021-02-20 | Calhoun | Mississippi | 28013 | 1551 | 27 |
1048434 | 1048434 | 2021-02-20 | Carroll | Mississippi | 28015 | 1169 | 23 |
1048435 | 1048435 | 2021-02-20 | Chickasaw | Mississippi | 28017 | 2001 | 50 |
1048436 | 1048436 | 2021-02-20 | Choctaw | Mississippi | 28019 | 693 | 16 |
1048437 | 1048437 | 2021-02-20 | Claiborne | Mississippi | 28021 | 973 | 29 |
1048438 | 1048438 | 2021-02-20 | Clarke | Mississippi | 28023 | 1670 | 70 |
1048439 | 1048439 | 2021-02-20 | Clay | Mississippi | 28025 | 1768 | 48 |
1048440 | 1048440 | 2021-02-20 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1048441 | 1048441 | 2021-02-20 | Copiah | Mississippi | 28029 | 2727 | 57 |
1048442 | 1048442 | 2021-02-20 | Covington | Mississippi | 28031 | 2452 | 77 |
1048443 | 1048443 | 2021-02-20 | DeSoto | Mississippi | 28033 | 19389 | 226 |
1048444 | 1048444 | 2021-02-20 | Forrest | Mississippi | 28035 | 6989 | 135 |
1048445 | 1048445 | 2021-02-20 | Franklin | Mississippi | 28037 | 750 | 19 |
1048446 | 1048446 | 2021-02-20 | George | Mississippi | 28039 | 2293 | 45 |
1048447 | 1048447 | 2021-02-20 | Greene | Mississippi | 28041 | 1259 | 33 |
1048448 | 1048448 | 2021-02-20 | Grenada | Mississippi | 28043 | 2439 | 75 |
1048449 | 1048449 | 2021-02-20 | Hancock | Mississippi | 28045 | 3363 | 73 |
1048450 | 1048450 | 2021-02-20 | Harrison | Mississippi | 28047 | 16315 | 269 |
1048451 | 1048451 | 2021-02-20 | Hinds | Mississippi | 28049 | 18528 | 382 |
1048452 | 1048452 | 2021-02-20 | Holmes | Mississippi | 28051 | 1803 | 69 |
1048453 | 1048453 | 2021-02-20 | Humphreys | Mississippi | 28053 | 909 | 26 |
1048454 | 1048454 | 2021-02-20 | Issaquena | Mississippi | 28055 | 167 | 6 |
1048455 | 1048455 | 2021-02-20 | Itawamba | Mississippi | 28057 | 2879 | 71 |
1048456 | 1048456 | 2021-02-20 | Jackson | Mississippi | 28059 | 12353 | 216 |
1048457 | 1048457 | 2021-02-20 | Jasper | Mississippi | 28061 | 2099 | 42 |
1048458 | 1048458 | 2021-02-20 | Jefferson | Mississippi | 28063 | 607 | 27 |
1048459 | 1048459 | 2021-02-20 | Jefferson Davis | Mississippi | 28065 | 993 | 31 |
1048460 | 1048460 | 2021-02-20 | Jones | Mississippi | 28067 | 7790 | 142 |
1048461 | 1048461 | 2021-02-20 | Kemper | Mississippi | 28069 | 888 | 22 |
1048462 | 1048462 | 2021-02-20 | Lafayette | Mississippi | 28071 | 5679 | 113 |
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);