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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 28011 784
- 28025 784
- 28027 784
- 28029 784
- 28033 784
- 28035 784
- 28037 784
- 28039 784
- 28043 784
- 28045 784
- 28047 784
- 28049 784
- 28051 784
- 28053 784
- 28057 784
- 28059 784
- 28067 784
- 28071 784
- 28077 784
- 28079 784
- 28081 784
- 28083 784
- 28085 784
- 28087 784
- 28089 784
- 28093 784
- 28095 784
- 28107 784
- 28109 784
- 28111 784
- …
county >30
- Bolivar 784
- Clay 784
- Coahoma 784
- Copiah 784
- DeSoto 784
- Forrest 784
- Franklin 784
- George 784
- Grenada 784
- Hancock 784
- Harrison 784
- Hinds 784
- Holmes 784
- Humphreys 784
- Itawamba 784
- Jackson 784
- Jones 784
- Lafayette 784
- Lawrence 784
- Leake 784
- Lee 784
- Leflore 784
- Lincoln 784
- Lowndes 784
- Madison 784
- Marshall 784
- Monroe 784
- Panola 784
- Pearl River 784
- Perry 784
- …
state 1
- Mississippi · 64,047 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6578 | 6578 | 2020-03-21 | Bolivar | Mississippi | 28011 | 2 | 0 |
6579 | 6579 | 2020-03-21 | Clay | Mississippi | 28025 | 1 | 0 |
6580 | 6580 | 2020-03-21 | Coahoma | Mississippi | 28027 | 5 | 0 |
6581 | 6581 | 2020-03-21 | Copiah | Mississippi | 28029 | 2 | 0 |
6582 | 6582 | 2020-03-21 | DeSoto | Mississippi | 28033 | 13 | 0 |
6583 | 6583 | 2020-03-21 | Forrest | Mississippi | 28035 | 5 | 0 |
6584 | 6584 | 2020-03-21 | Franklin | Mississippi | 28037 | 2 | 0 |
6585 | 6585 | 2020-03-21 | George | Mississippi | 28039 | 1 | 0 |
6586 | 6586 | 2020-03-21 | Grenada | Mississippi | 28043 | 1 | 0 |
6587 | 6587 | 2020-03-21 | Hancock | Mississippi | 28045 | 4 | 1 |
6588 | 6588 | 2020-03-21 | Harrison | Mississippi | 28047 | 10 | 0 |
6589 | 6589 | 2020-03-21 | Hinds | Mississippi | 28049 | 14 | 0 |
6590 | 6590 | 2020-03-21 | Holmes | Mississippi | 28051 | 3 | 0 |
6591 | 6591 | 2020-03-21 | Humphreys | Mississippi | 28053 | 1 | 0 |
6592 | 6592 | 2020-03-21 | Itawamba | Mississippi | 28057 | 3 | 0 |
6593 | 6593 | 2020-03-21 | Jackson | Mississippi | 28059 | 5 | 0 |
6594 | 6594 | 2020-03-21 | Jones | Mississippi | 28067 | 1 | 0 |
6595 | 6595 | 2020-03-21 | Lafayette | Mississippi | 28071 | 2 | 0 |
6596 | 6596 | 2020-03-21 | Lawrence | Mississippi | 28077 | 1 | 0 |
6597 | 6597 | 2020-03-21 | Leake | Mississippi | 28079 | 1 | 0 |
6598 | 6598 | 2020-03-21 | Lee | Mississippi | 28081 | 5 | 0 |
6599 | 6599 | 2020-03-21 | Leflore | Mississippi | 28083 | 7 | 0 |
6600 | 6600 | 2020-03-21 | Lincoln | Mississippi | 28085 | 1 | 0 |
6601 | 6601 | 2020-03-21 | Lowndes | Mississippi | 28087 | 4 | 0 |
6602 | 6602 | 2020-03-21 | Madison | Mississippi | 28089 | 7 | 0 |
6603 | 6603 | 2020-03-21 | Marshall | Mississippi | 28093 | 2 | 0 |
6604 | 6604 | 2020-03-21 | Monroe | Mississippi | 28095 | 2 | 0 |
6605 | 6605 | 2020-03-21 | Panola | Mississippi | 28107 | 1 | 0 |
6606 | 6606 | 2020-03-21 | Pearl River | Mississippi | 28109 | 9 | 0 |
6607 | 6607 | 2020-03-21 | Perry | Mississippi | 28111 | 1 | 0 |
6608 | 6608 | 2020-03-21 | Pike | Mississippi | 28113 | 2 | 0 |
6609 | 6609 | 2020-03-21 | Rankin | Mississippi | 28121 | 7 | 0 |
6610 | 6610 | 2020-03-21 | Scott | Mississippi | 28123 | 1 | 0 |
6611 | 6611 | 2020-03-21 | Simpson | Mississippi | 28127 | 1 | 0 |
6612 | 6612 | 2020-03-21 | Smith | Mississippi | 28129 | 1 | 0 |
6613 | 6613 | 2020-03-21 | Tippah | Mississippi | 28139 | 3 | 0 |
6614 | 6614 | 2020-03-21 | Tunica | Mississippi | 28143 | 1 | 0 |
6615 | 6615 | 2020-03-21 | Union | Mississippi | 28145 | 1 | 0 |
6616 | 6616 | 2020-03-21 | Walthall | Mississippi | 28147 | 1 | 0 |
6617 | 6617 | 2020-03-21 | Washington | Mississippi | 28151 | 1 | 0 |
6618 | 6618 | 2020-03-21 | Wilkinson | Mississippi | 28157 | 1 | 0 |
6619 | 6619 | 2020-03-21 | Winston | Mississippi | 28159 | 1 | 0 |
6620 | 6620 | 2020-03-21 | Yazoo | Mississippi | 28163 | 1 | 0 |
7658 | 7658 | 2020-03-22 | Adams | Mississippi | 28001 | 1 | 0 |
7659 | 7659 | 2020-03-22 | Attala | Mississippi | 28007 | 1 | 0 |
7660 | 7660 | 2020-03-22 | Bolivar | Mississippi | 28011 | 3 | 0 |
7661 | 7661 | 2020-03-22 | Chickasaw | Mississippi | 28017 | 1 | 0 |
7662 | 7662 | 2020-03-22 | Clay | Mississippi | 28025 | 1 | 0 |
7663 | 7663 | 2020-03-22 | Coahoma | Mississippi | 28027 | 7 | 0 |
7664 | 7664 | 2020-03-22 | Copiah | Mississippi | 28029 | 4 | 0 |
7665 | 7665 | 2020-03-22 | DeSoto | Mississippi | 28033 | 18 | 0 |
7666 | 7666 | 2020-03-22 | Forrest | Mississippi | 28035 | 11 | 0 |
7667 | 7667 | 2020-03-22 | Franklin | Mississippi | 28037 | 3 | 0 |
7668 | 7668 | 2020-03-22 | George | Mississippi | 28039 | 1 | 0 |
7669 | 7669 | 2020-03-22 | Grenada | Mississippi | 28043 | 2 | 0 |
7670 | 7670 | 2020-03-22 | Hancock | Mississippi | 28045 | 4 | 1 |
7671 | 7671 | 2020-03-22 | Harrison | Mississippi | 28047 | 15 | 0 |
7672 | 7672 | 2020-03-22 | Hinds | Mississippi | 28049 | 20 | 0 |
7673 | 7673 | 2020-03-22 | Holmes | Mississippi | 28051 | 6 | 0 |
7674 | 7674 | 2020-03-22 | Humphreys | Mississippi | 28053 | 1 | 0 |
7675 | 7675 | 2020-03-22 | Itawamba | Mississippi | 28057 | 3 | 0 |
7676 | 7676 | 2020-03-22 | Jackson | Mississippi | 28059 | 5 | 0 |
7677 | 7677 | 2020-03-22 | Jones | Mississippi | 28067 | 1 | 0 |
7678 | 7678 | 2020-03-22 | Lafayette | Mississippi | 28071 | 5 | 0 |
7679 | 7679 | 2020-03-22 | Lawrence | Mississippi | 28077 | 2 | 0 |
7680 | 7680 | 2020-03-22 | Leake | Mississippi | 28079 | 1 | 0 |
7681 | 7681 | 2020-03-22 | Lee | Mississippi | 28081 | 6 | 0 |
7682 | 7682 | 2020-03-22 | Leflore | Mississippi | 28083 | 8 | 0 |
7683 | 7683 | 2020-03-22 | Lincoln | Mississippi | 28085 | 4 | 0 |
7684 | 7684 | 2020-03-22 | Lowndes | Mississippi | 28087 | 4 | 0 |
7685 | 7685 | 2020-03-22 | Madison | Mississippi | 28089 | 9 | 0 |
7686 | 7686 | 2020-03-22 | Marshall | Mississippi | 28093 | 3 | 0 |
7687 | 7687 | 2020-03-22 | Monroe | Mississippi | 28095 | 2 | 0 |
7688 | 7688 | 2020-03-22 | Montgomery | Mississippi | 28097 | 1 | 0 |
7689 | 7689 | 2020-03-22 | Oktibbeha | Mississippi | 28105 | 2 | 0 |
7690 | 7690 | 2020-03-22 | Panola | Mississippi | 28107 | 2 | 0 |
7691 | 7691 | 2020-03-22 | Pearl River | Mississippi | 28109 | 10 | 0 |
7692 | 7692 | 2020-03-22 | Perry | Mississippi | 28111 | 1 | 0 |
7693 | 7693 | 2020-03-22 | Pike | Mississippi | 28113 | 3 | 0 |
7694 | 7694 | 2020-03-22 | Pontotoc | Mississippi | 28115 | 1 | 0 |
7695 | 7695 | 2020-03-22 | Rankin | Mississippi | 28121 | 7 | 0 |
7696 | 7696 | 2020-03-22 | Scott | Mississippi | 28123 | 1 | 0 |
7697 | 7697 | 2020-03-22 | Simpson | Mississippi | 28127 | 1 | 0 |
7698 | 7698 | 2020-03-22 | Smith | Mississippi | 28129 | 1 | 0 |
7699 | 7699 | 2020-03-22 | Sunflower | Mississippi | 28133 | 2 | 0 |
7700 | 7700 | 2020-03-22 | Tate | Mississippi | 28137 | 1 | 0 |
7701 | 7701 | 2020-03-22 | Tippah | Mississippi | 28139 | 7 | 0 |
7702 | 7702 | 2020-03-22 | Tunica | Mississippi | 28143 | 2 | 0 |
7703 | 7703 | 2020-03-22 | Union | Mississippi | 28145 | 1 | 0 |
7704 | 7704 | 2020-03-22 | Walthall | Mississippi | 28147 | 2 | 0 |
7705 | 7705 | 2020-03-22 | Washington | Mississippi | 28151 | 3 | 0 |
7706 | 7706 | 2020-03-22 | Webster | Mississippi | 28155 | 1 | 0 |
7707 | 7707 | 2020-03-22 | Wilkinson | Mississippi | 28157 | 3 | 0 |
7708 | 7708 | 2020-03-22 | Winston | Mississippi | 28159 | 2 | 0 |
7709 | 7709 | 2020-03-22 | Yazoo | Mississippi | 28163 | 1 | 0 |
8838 | 8838 | 2020-03-23 | Adams | Mississippi | 28001 | 2 | 0 |
8839 | 8839 | 2020-03-23 | Attala | Mississippi | 28007 | 1 | 0 |
8840 | 8840 | 2020-03-23 | Bolivar | Mississippi | 28011 | 4 | 0 |
8841 | 8841 | 2020-03-23 | Chickasaw | Mississippi | 28017 | 3 | 0 |
8842 | 8842 | 2020-03-23 | Clay | Mississippi | 28025 | 1 | 0 |
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);