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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 28035 794
- 28029 792
- 28083 792
- 28109 792
- 28049 790
- 28045 789
- 28095 789
- 28047 788
- 28059 788
- 28011 787
- 28027 787
- 28033 787
- 28089 787
- 28111 787
- 28051 786
- 28067 786
- 28123 786
- 28147 786
- 28157 786
- 28159 786
- 28163 786
- 28001 785
- 28037 785
- 28053 785
- 28071 785
- 28077 785
- 28081 785
- 28093 785
- 28113 785
- 28121 785
- …
county >30
- Forrest 794
- Copiah 792
- Leflore 792
- Pearl River 792
- Hinds 790
- Hancock 789
- Monroe 789
- Harrison 788
- Jackson 788
- Bolivar 787
- Coahoma 787
- DeSoto 787
- Madison 787
- Perry 787
- Holmes 786
- Jones 786
- Scott 786
- Walthall 786
- Wilkinson 786
- Winston 786
- Yazoo 786
- Adams 785
- Franklin 785
- Humphreys 785
- Lafayette 785
- Lawrence 785
- Lee 785
- Marshall 785
- Pike 785
- Rankin 785
- …
state 1
- Mississippi · 64,147 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1266 | 1266 | 2020-03-11 | Forrest | Mississippi | 28035 | 1 | 0 |
1492 | 1492 | 2020-03-12 | Forrest | Mississippi | 28035 | 1 | 0 |
1776 | 1776 | 2020-03-13 | Copiah | Mississippi | 28029 | 1 | 0 |
1778 | 1778 | 2020-03-13 | Leflore | Mississippi | 28083 | 1 | 0 |
1779 | 1779 | 2020-03-13 | Pearl River | Mississippi | 28109 | 1 | 0 |
2121 | 2121 | 2020-03-14 | Copiah | Mississippi | 28029 | 1 | 0 |
2123 | 2123 | 2020-03-14 | Leflore | Mississippi | 28083 | 1 | 0 |
2124 | 2124 | 2020-03-14 | Pearl River | Mississippi | 28109 | 1 | 0 |
2530 | 2530 | 2020-03-15 | Leflore | Mississippi | 28083 | 1 | 0 |
2981 | 2981 | 2020-03-16 | Hancock | Mississippi | 28045 | 1 | 0 |
2983 | 2983 | 2020-03-16 | Leflore | Mississippi | 28083 | 1 | 0 |
2984 | 2984 | 2020-03-16 | Monroe | Mississippi | 28095 | 1 | 0 |
3486 | 3486 | 2020-03-17 | Hancock | Mississippi | 28045 | 1 | 0 |
3487 | 3487 | 2020-03-17 | Harrison | Mississippi | 28047 | 1 | 0 |
3489 | 3489 | 2020-03-17 | Jackson | Mississippi | 28059 | 1 | 0 |
3491 | 3491 | 2020-03-17 | Monroe | Mississippi | 28095 | 1 | 0 |
4071 | 4071 | 2020-03-18 | DeSoto | Mississippi | 28033 | 1 | 0 |
4076 | 4076 | 2020-03-18 | Jackson | Mississippi | 28059 | 1 | 0 |
4078 | 4078 | 2020-03-18 | Madison | Mississippi | 28089 | 1 | 0 |
4079 | 4079 | 2020-03-18 | Monroe | Mississippi | 28095 | 1 | 0 |
4081 | 4081 | 2020-03-18 | Perry | Mississippi | 28111 | 1 | 0 |
4788 | 4788 | 2020-03-19 | Holmes | Mississippi | 28051 | 1 | 0 |
4790 | 4790 | 2020-03-19 | Jones | Mississippi | 28067 | 1 | 0 |
4792 | 4792 | 2020-03-19 | Madison | Mississippi | 28089 | 1 | 0 |
4793 | 4793 | 2020-03-19 | Monroe | Mississippi | 28095 | 1 | 0 |
4795 | 4795 | 2020-03-19 | Perry | Mississippi | 28111 | 1 | 0 |
4796 | 4796 | 2020-03-19 | Scott | Mississippi | 28123 | 1 | 0 |
4797 | 4797 | 2020-03-19 | Walthall | Mississippi | 28147 | 1 | 0 |
4798 | 4798 | 2020-03-19 | Wilkinson | Mississippi | 28157 | 1 | 0 |
4799 | 4799 | 2020-03-19 | Winston | Mississippi | 28159 | 1 | 0 |
4800 | 4800 | 2020-03-19 | Yazoo | Mississippi | 28163 | 1 | 0 |
5602 | 5602 | 2020-03-20 | Adams | Mississippi | 28001 | 1 | 0 |
5608 | 5608 | 2020-03-20 | Franklin | Mississippi | 28037 | 1 | 0 |
5613 | 5613 | 2020-03-20 | Humphreys | Mississippi | 28053 | 1 | 0 |
5615 | 5615 | 2020-03-20 | Jones | Mississippi | 28067 | 1 | 0 |
5616 | 5616 | 2020-03-20 | Lafayette | Mississippi | 28071 | 1 | 0 |
5617 | 5617 | 2020-03-20 | Lawrence | Mississippi | 28077 | 1 | 0 |
5618 | 5618 | 2020-03-20 | Lee | Mississippi | 28081 | 1 | 0 |
5621 | 5621 | 2020-03-20 | Marshall | Mississippi | 28093 | 1 | 0 |
5624 | 5624 | 2020-03-20 | Perry | Mississippi | 28111 | 1 | 0 |
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
5627 | 5627 | 2020-03-20 | Scott | Mississippi | 28123 | 1 | 0 |
5628 | 5628 | 2020-03-20 | Smith | Mississippi | 28129 | 1 | 0 |
5630 | 5630 | 2020-03-20 | Walthall | Mississippi | 28147 | 1 | 0 |
5631 | 5631 | 2020-03-20 | Wilkinson | Mississippi | 28157 | 1 | 0 |
5632 | 5632 | 2020-03-20 | Winston | Mississippi | 28159 | 1 | 0 |
5633 | 5633 | 2020-03-20 | Yazoo | Mississippi | 28163 | 1 | 0 |
6576 | 6576 | 2020-03-21 | Adams | Mississippi | 28001 | 1 | 0 |
6577 | 6577 | 2020-03-21 | Attala | Mississippi | 28007 | 1 | 0 |
6579 | 6579 | 2020-03-21 | Clay | Mississippi | 28025 | 1 | 0 |
6585 | 6585 | 2020-03-21 | George | Mississippi | 28039 | 1 | 0 |
6586 | 6586 | 2020-03-21 | Grenada | Mississippi | 28043 | 1 | 0 |
6591 | 6591 | 2020-03-21 | Humphreys | Mississippi | 28053 | 1 | 0 |
6594 | 6594 | 2020-03-21 | Jones | Mississippi | 28067 | 1 | 0 |
6596 | 6596 | 2020-03-21 | Lawrence | Mississippi | 28077 | 1 | 0 |
6597 | 6597 | 2020-03-21 | Leake | Mississippi | 28079 | 1 | 0 |
6600 | 6600 | 2020-03-21 | Lincoln | Mississippi | 28085 | 1 | 0 |
6605 | 6605 | 2020-03-21 | Panola | Mississippi | 28107 | 1 | 0 |
6607 | 6607 | 2020-03-21 | Perry | Mississippi | 28111 | 1 | 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 |
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 |
7661 | 7661 | 2020-03-22 | Chickasaw | Mississippi | 28017 | 1 | 0 |
7662 | 7662 | 2020-03-22 | Clay | Mississippi | 28025 | 1 | 0 |
7668 | 7668 | 2020-03-22 | George | Mississippi | 28039 | 1 | 0 |
7674 | 7674 | 2020-03-22 | Humphreys | Mississippi | 28053 | 1 | 0 |
7677 | 7677 | 2020-03-22 | Jones | Mississippi | 28067 | 1 | 0 |
7680 | 7680 | 2020-03-22 | Leake | Mississippi | 28079 | 1 | 0 |
7688 | 7688 | 2020-03-22 | Montgomery | Mississippi | 28097 | 1 | 0 |
7692 | 7692 | 2020-03-22 | Perry | Mississippi | 28111 | 1 | 0 |
7694 | 7694 | 2020-03-22 | Pontotoc | Mississippi | 28115 | 1 | 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 |
7700 | 7700 | 2020-03-22 | Tate | Mississippi | 28137 | 1 | 0 |
7703 | 7703 | 2020-03-22 | Union | Mississippi | 28145 | 1 | 0 |
7706 | 7706 | 2020-03-22 | Webster | Mississippi | 28155 | 1 | 0 |
7709 | 7709 | 2020-03-22 | Yazoo | Mississippi | 28163 | 1 | 0 |
8839 | 8839 | 2020-03-23 | Attala | Mississippi | 28007 | 1 | 0 |
8842 | 8842 | 2020-03-23 | Clay | Mississippi | 28025 | 1 | 0 |
8848 | 8848 | 2020-03-23 | George | Mississippi | 28039 | 1 | 0 |
8854 | 8854 | 2020-03-23 | Humphreys | Mississippi | 28053 | 1 | 0 |
8857 | 8857 | 2020-03-23 | Jones | Mississippi | 28067 | 1 | 0 |
8859 | 8859 | 2020-03-23 | Lamar | Mississippi | 28073 | 1 | 0 |
8861 | 8861 | 2020-03-23 | Leake | Mississippi | 28079 | 1 | 0 |
8867 | 8867 | 2020-03-23 | Marion | Mississippi | 28091 | 1 | 0 |
8870 | 8870 | 2020-03-23 | Montgomery | Mississippi | 28097 | 1 | 0 |
8874 | 8874 | 2020-03-23 | Perry | Mississippi | 28111 | 1 | 0 |
8876 | 8876 | 2020-03-23 | Pontotoc | Mississippi | 28115 | 1 | 0 |
8878 | 8878 | 2020-03-23 | Scott | Mississippi | 28123 | 1 | 0 |
8879 | 8879 | 2020-03-23 | Simpson | Mississippi | 28127 | 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);