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 674
- 28029 672
- 28083 672
- 28109 672
- 28049 670
- 28045 669
- 28095 669
- 28047 668
- 28059 668
- 28011 667
- 28027 667
- 28033 667
- 28089 667
- 28111 667
- 28051 666
- 28067 666
- 28123 666
- 28147 666
- 28157 666
- 28159 666
- 28163 666
- 28001 665
- 28037 665
- 28053 665
- 28071 665
- 28077 665
- 28081 665
- 28093 665
- 28113 665
- 28121 665
- …
county >30
- Forrest 674
- Copiah 672
- Leflore 672
- Pearl River 672
- Hinds 670
- Hancock 669
- Monroe 669
- Harrison 668
- Jackson 668
- Bolivar 667
- Coahoma 667
- DeSoto 667
- Madison 667
- Perry 667
- Holmes 666
- Jones 666
- Scott 666
- Walthall 666
- Wilkinson 666
- Winston 666
- Yazoo 666
- Adams 665
- Franklin 665
- Humphreys 665
- Lafayette 665
- Lawrence 665
- Lee 665
- Marshall 665
- Pike 665
- Rankin 665
- …
state 1
- Mississippi · 54,250 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110545 | 2110545 | 2022-01-13 | Adams | Mississippi | 28001 | 5531 | 125 |
2110546 | 2110546 | 2022-01-13 | Alcorn | Mississippi | 28003 | 7348 | 120 |
2110547 | 2110547 | 2022-01-13 | Amite | Mississippi | 28005 | 2472 | 59 |
2110548 | 2110548 | 2022-01-13 | Attala | Mississippi | 28007 | 3883 | 90 |
2110549 | 2110549 | 2022-01-13 | Benton | Mississippi | 28009 | 1827 | 42 |
2110550 | 2110550 | 2022-01-13 | Bolivar | Mississippi | 28011 | 7496 | 155 |
2110551 | 2110551 | 2022-01-13 | Calhoun | Mississippi | 28013 | 3481 | 52 |
2110552 | 2110552 | 2022-01-13 | Carroll | Mississippi | 28015 | 2135 | 42 |
2110553 | 2110553 | 2022-01-13 | Chickasaw | Mississippi | 28017 | 4058 | 79 |
2110554 | 2110554 | 2022-01-13 | Choctaw | Mississippi | 28019 | 1572 | 27 |
2110555 | 2110555 | 2022-01-13 | Claiborne | Mississippi | 28021 | 1726 | 41 |
2110556 | 2110556 | 2022-01-13 | Clarke | Mississippi | 28023 | 3349 | 96 |
2110557 | 2110557 | 2022-01-13 | Clay | Mississippi | 28025 | 4059 | 78 |
2110558 | 2110558 | 2022-01-13 | Coahoma | Mississippi | 28027 | 5383 | 114 |
2110559 | 2110559 | 2022-01-13 | Copiah | Mississippi | 28029 | 5639 | 95 |
2110560 | 2110560 | 2022-01-13 | Covington | Mississippi | 28031 | 5632 | 98 |
2110561 | 2110561 | 2022-01-13 | DeSoto | Mississippi | 28033 | 40994 | 460 |
2110562 | 2110562 | 2022-01-13 | Forrest | Mississippi | 28035 | 16572 | 267 |
2110563 | 2110563 | 2022-01-13 | Franklin | Mississippi | 28037 | 1497 | 34 |
2110564 | 2110564 | 2022-01-13 | George | Mississippi | 28039 | 5730 | 80 |
2110565 | 2110565 | 2022-01-13 | Greene | Mississippi | 28041 | 2477 | 50 |
2110566 | 2110566 | 2022-01-13 | Grenada | Mississippi | 28043 | 4469 | 113 |
2110567 | 2110567 | 2022-01-13 | Hancock | Mississippi | 28045 | 9250 | 140 |
2110568 | 2110568 | 2022-01-13 | Harrison | Mississippi | 28047 | 40700 | 572 |
2110569 | 2110569 | 2022-01-13 | Hinds | Mississippi | 28049 | 43895 | 665 |
2110570 | 2110570 | 2022-01-13 | Holmes | Mississippi | 28051 | 3564 | 94 |
2110571 | 2110571 | 2022-01-13 | Humphreys | Mississippi | 28053 | 1648 | 39 |
2110572 | 2110572 | 2022-01-13 | Issaquena | Mississippi | 28055 | 200 | 7 |
2110573 | 2110573 | 2022-01-13 | Itawamba | Mississippi | 28057 | 5627 | 114 |
2110574 | 2110574 | 2022-01-13 | Jackson | Mississippi | 28059 | 29475 | 397 |
2110575 | 2110575 | 2022-01-13 | Jasper | Mississippi | 28061 | 3916 | 66 |
2110576 | 2110576 | 2022-01-13 | Jefferson | Mississippi | 28063 | 1194 | 35 |
2110577 | 2110577 | 2022-01-13 | Jefferson Davis | Mississippi | 28065 | 2291 | 43 |
2110578 | 2110578 | 2022-01-13 | Jones | Mississippi | 28067 | 16464 | 250 |
2110579 | 2110579 | 2022-01-13 | Kemper | Mississippi | 28069 | 1700 | 42 |
2110580 | 2110580 | 2022-01-13 | Lafayette | Mississippi | 28071 | 11309 | 149 |
2110581 | 2110581 | 2022-01-13 | Lamar | Mississippi | 28073 | 13178 | 140 |
2110582 | 2110582 | 2022-01-13 | Lauderdale | Mississippi | 28075 | 14687 | 324 |
2110583 | 2110583 | 2022-01-13 | Lawrence | Mississippi | 28077 | 2754 | 44 |
2110584 | 2110584 | 2022-01-13 | Leake | Mississippi | 28079 | 4948 | 92 |
2110585 | 2110585 | 2022-01-13 | Lee | Mississippi | 28081 | 21058 | 253 |
2110586 | 2110586 | 2022-01-13 | Leflore | Mississippi | 28083 | 6447 | 145 |
2110587 | 2110587 | 2022-01-13 | Lincoln | Mississippi | 28085 | 6404 | 139 |
2110588 | 2110588 | 2022-01-13 | Lowndes | Mississippi | 28087 | 13408 | 201 |
2110589 | 2110589 | 2022-01-13 | Madison | Mississippi | 28089 | 19238 | 289 |
2110590 | 2110590 | 2022-01-13 | Marion | Mississippi | 28091 | 5260 | 119 |
2110591 | 2110591 | 2022-01-13 | Marshall | Mississippi | 28093 | 8034 | 150 |
2110592 | 2110592 | 2022-01-13 | Monroe | Mississippi | 28095 | 8486 | 184 |
2110593 | 2110593 | 2022-01-13 | Montgomery | Mississippi | 28097 | 2401 | 58 |
2110594 | 2110594 | 2022-01-13 | Neshoba | Mississippi | 28099 | 7941 | 211 |
2110595 | 2110595 | 2022-01-13 | Newton | Mississippi | 28101 | 4490 | 85 |
2110596 | 2110596 | 2022-01-13 | Noxubee | Mississippi | 28103 | 2210 | 44 |
2110597 | 2110597 | 2022-01-13 | Oktibbeha | Mississippi | 28105 | 8524 | 141 |
2110598 | 2110598 | 2022-01-13 | Panola | Mississippi | 28107 | 8442 | 141 |
2110599 | 2110599 | 2022-01-13 | Pearl River | Mississippi | 28109 | 11369 | 245 |
2110600 | 2110600 | 2022-01-13 | Perry | Mississippi | 28111 | 2393 | 57 |
2110601 | 2110601 | 2022-01-13 | Pike | Mississippi | 28113 | 7294 | 159 |
2110602 | 2110602 | 2022-01-13 | Pontotoc | Mississippi | 28115 | 8160 | 117 |
2110603 | 2110603 | 2022-01-13 | Prentiss | Mississippi | 28117 | 6112 | 89 |
2110604 | 2110604 | 2022-01-13 | Quitman | Mississippi | 28119 | 1330 | 28 |
2110605 | 2110605 | 2022-01-13 | Rankin | Mississippi | 28121 | 28282 | 418 |
2110606 | 2110606 | 2022-01-13 | Scott | Mississippi | 28123 | 5547 | 101 |
2110607 | 2110607 | 2022-01-13 | Sharkey | Mississippi | 28125 | 733 | 21 |
2110608 | 2110608 | 2022-01-13 | Simpson | Mississippi | 28127 | 5524 | 120 |
2110609 | 2110609 | 2022-01-13 | Smith | Mississippi | 28129 | 3127 | 56 |
2110610 | 2110610 | 2022-01-13 | Stone | Mississippi | 28131 | 4173 | 67 |
2110611 | 2110611 | 2022-01-13 | Sunflower | Mississippi | 28133 | 5042 | 111 |
2110612 | 2110612 | 2022-01-13 | Tallahatchie | Mississippi | 28135 | 2676 | 53 |
2110613 | 2110613 | 2022-01-13 | Tate | Mississippi | 28137 | 5751 | 122 |
2110614 | 2110614 | 2022-01-13 | Tippah | Mississippi | 28139 | 5701 | 89 |
2110615 | 2110615 | 2022-01-13 | Tishomingo | Mississippi | 28141 | 4466 | 99 |
2110616 | 2110616 | 2022-01-13 | Tunica | Mississippi | 28143 | 2108 | 40 |
2110617 | 2110617 | 2022-01-13 | Union | Mississippi | 28145 | 7489 | 101 |
2110618 | 2110618 | 2022-01-13 | Walthall | Mississippi | 28147 | 2666 | 70 |
2110619 | 2110619 | 2022-01-13 | Warren | Mississippi | 28149 | 8221 | 181 |
2110620 | 2110620 | 2022-01-13 | Washington | Mississippi | 28151 | 8487 | 171 |
2110621 | 2110621 | 2022-01-13 | Wayne | Mississippi | 28153 | 4754 | 73 |
2110622 | 2110622 | 2022-01-13 | Webster | Mississippi | 28155 | 2456 | 51 |
2110623 | 2110623 | 2022-01-13 | Wilkinson | Mississippi | 28157 | 1457 | 40 |
2110624 | 2110624 | 2022-01-13 | Winston | Mississippi | 28159 | 3919 | 95 |
2110625 | 2110625 | 2022-01-13 | Yalobusha | Mississippi | 28161 | 3085 | 48 |
2110626 | 2110626 | 2022-01-13 | Yazoo | Mississippi | 28163 | 6533 | 94 |
2107294 | 2107294 | 2022-01-12 | Adams | Mississippi | 28001 | 5465 | 125 |
2107295 | 2107295 | 2022-01-12 | Alcorn | Mississippi | 28003 | 7221 | 119 |
2107296 | 2107296 | 2022-01-12 | Amite | Mississippi | 28005 | 2430 | 59 |
2107297 | 2107297 | 2022-01-12 | Attala | Mississippi | 28007 | 3838 | 90 |
2107298 | 2107298 | 2022-01-12 | Benton | Mississippi | 28009 | 1810 | 42 |
2107299 | 2107299 | 2022-01-12 | Bolivar | Mississippi | 28011 | 7396 | 155 |
2107300 | 2107300 | 2022-01-12 | Calhoun | Mississippi | 28013 | 3412 | 52 |
2107301 | 2107301 | 2022-01-12 | Carroll | Mississippi | 28015 | 2109 | 42 |
2107302 | 2107302 | 2022-01-12 | Chickasaw | Mississippi | 28017 | 3993 | 78 |
2107303 | 2107303 | 2022-01-12 | Choctaw | Mississippi | 28019 | 1552 | 27 |
2107304 | 2107304 | 2022-01-12 | Claiborne | Mississippi | 28021 | 1677 | 41 |
2107305 | 2107305 | 2022-01-12 | Clarke | Mississippi | 28023 | 3314 | 96 |
2107306 | 2107306 | 2022-01-12 | Clay | Mississippi | 28025 | 3965 | 78 |
2107307 | 2107307 | 2022-01-12 | Coahoma | Mississippi | 28027 | 5328 | 114 |
2107308 | 2107308 | 2022-01-12 | Copiah | Mississippi | 28029 | 5586 | 95 |
2107309 | 2107309 | 2022-01-12 | Covington | Mississippi | 28031 | 5510 | 98 |
2107310 | 2107310 | 2022-01-12 | DeSoto | Mississippi | 28033 | 40580 | 459 |
2107311 | 2107311 | 2022-01-12 | Forrest | Mississippi | 28035 | 16320 | 266 |
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);