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
- 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
- …
date (date) >30 ✖
- 2020-07-26 83
- 2020-07-27 83
- 2020-07-28 83
- 2020-07-29 83
- 2020-10-18 83
- 2022-03-09 83
- 2022-03-10 83
- 2022-03-11 83
- 2022-03-12 83
- 2022-03-13 83
- 2022-03-15 83
- 2022-03-16 83
- 2022-03-17 83
- 2022-03-18 83
- 2022-03-19 83
- 2022-03-20 83
- 2022-03-22 83
- 2022-03-23 83
- 2022-03-24 83
- 2022-03-25 83
- 2022-03-26 83
- 2022-03-27 83
- 2022-03-29 83
- 2022-03-30 83
- 2022-03-31 83
- 2022-04-01 83
- 2022-04-02 83
- 2022-04-03 83
- 2022-04-05 83
- 2022-04-06 83
- …
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 |
1777 | 1777 | 2020-03-13 | Forrest | Mississippi | 28035 | 3 | 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 |
2122 | 2122 | 2020-03-14 | Forrest | Mississippi | 28035 | 3 | 0 |
2123 | 2123 | 2020-03-14 | Leflore | Mississippi | 28083 | 1 | 0 |
2124 | 2124 | 2020-03-14 | Pearl River | Mississippi | 28109 | 1 | 0 |
2527 | 2527 | 2020-03-15 | Copiah | Mississippi | 28029 | 2 | 0 |
2528 | 2528 | 2020-03-15 | Forrest | Mississippi | 28035 | 3 | 0 |
2529 | 2529 | 2020-03-15 | Hinds | Mississippi | 28049 | 2 | 0 |
2530 | 2530 | 2020-03-15 | Leflore | Mississippi | 28083 | 1 | 0 |
2531 | 2531 | 2020-03-15 | Pearl River | Mississippi | 28109 | 2 | 0 |
2979 | 2979 | 2020-03-16 | Copiah | Mississippi | 28029 | 2 | 0 |
2980 | 2980 | 2020-03-16 | Forrest | Mississippi | 28035 | 3 | 0 |
2981 | 2981 | 2020-03-16 | Hancock | Mississippi | 28045 | 1 | 0 |
2982 | 2982 | 2020-03-16 | Hinds | Mississippi | 28049 | 2 | 0 |
2983 | 2983 | 2020-03-16 | Leflore | Mississippi | 28083 | 1 | 0 |
2984 | 2984 | 2020-03-16 | Monroe | Mississippi | 28095 | 1 | 0 |
2985 | 2985 | 2020-03-16 | Pearl River | Mississippi | 28109 | 2 | 0 |
3484 | 3484 | 2020-03-17 | Copiah | Mississippi | 28029 | 2 | 0 |
3485 | 3485 | 2020-03-17 | Forrest | Mississippi | 28035 | 3 | 0 |
3486 | 3486 | 2020-03-17 | Hancock | Mississippi | 28045 | 1 | 0 |
3487 | 3487 | 2020-03-17 | Harrison | Mississippi | 28047 | 1 | 0 |
3488 | 3488 | 2020-03-17 | Hinds | Mississippi | 28049 | 6 | 0 |
3489 | 3489 | 2020-03-17 | Jackson | Mississippi | 28059 | 1 | 0 |
3490 | 3490 | 2020-03-17 | Leflore | Mississippi | 28083 | 4 | 0 |
3491 | 3491 | 2020-03-17 | Monroe | Mississippi | 28095 | 1 | 0 |
3492 | 3492 | 2020-03-17 | Pearl River | Mississippi | 28109 | 2 | 0 |
4068 | 4068 | 2020-03-18 | Bolivar | Mississippi | 28011 | 2 | 0 |
4069 | 4069 | 2020-03-18 | Coahoma | Mississippi | 28027 | 2 | 0 |
4070 | 4070 | 2020-03-18 | Copiah | Mississippi | 28029 | 2 | 0 |
4071 | 4071 | 2020-03-18 | DeSoto | Mississippi | 28033 | 1 | 0 |
4072 | 4072 | 2020-03-18 | Forrest | Mississippi | 28035 | 3 | 0 |
4073 | 4073 | 2020-03-18 | Hancock | Mississippi | 28045 | 2 | 0 |
4074 | 4074 | 2020-03-18 | Harrison | Mississippi | 28047 | 4 | 0 |
4075 | 4075 | 2020-03-18 | Hinds | Mississippi | 28049 | 6 | 0 |
4076 | 4076 | 2020-03-18 | Jackson | Mississippi | 28059 | 1 | 0 |
4077 | 4077 | 2020-03-18 | Leflore | Mississippi | 28083 | 4 | 0 |
4078 | 4078 | 2020-03-18 | Madison | Mississippi | 28089 | 1 | 0 |
4079 | 4079 | 2020-03-18 | Monroe | Mississippi | 28095 | 1 | 0 |
4080 | 4080 | 2020-03-18 | Pearl River | Mississippi | 28109 | 4 | 0 |
4081 | 4081 | 2020-03-18 | Perry | Mississippi | 28111 | 1 | 0 |
4780 | 4780 | 2020-03-19 | Bolivar | Mississippi | 28011 | 2 | 0 |
4781 | 4781 | 2020-03-19 | Coahoma | Mississippi | 28027 | 2 | 0 |
4782 | 4782 | 2020-03-19 | Copiah | Mississippi | 28029 | 2 | 0 |
4783 | 4783 | 2020-03-19 | DeSoto | Mississippi | 28033 | 2 | 0 |
4784 | 4784 | 2020-03-19 | Forrest | Mississippi | 28035 | 4 | 0 |
4785 | 4785 | 2020-03-19 | Hancock | Mississippi | 28045 | 2 | 1 |
4786 | 4786 | 2020-03-19 | Harrison | Mississippi | 28047 | 7 | 0 |
4787 | 4787 | 2020-03-19 | Hinds | Mississippi | 28049 | 6 | 0 |
4788 | 4788 | 2020-03-19 | Holmes | Mississippi | 28051 | 1 | 0 |
4789 | 4789 | 2020-03-19 | Jackson | Mississippi | 28059 | 2 | 0 |
4790 | 4790 | 2020-03-19 | Jones | Mississippi | 28067 | 1 | 0 |
4791 | 4791 | 2020-03-19 | Leflore | Mississippi | 28083 | 4 | 0 |
4792 | 4792 | 2020-03-19 | Madison | Mississippi | 28089 | 1 | 0 |
4793 | 4793 | 2020-03-19 | Monroe | Mississippi | 28095 | 1 | 0 |
4794 | 4794 | 2020-03-19 | Pearl River | Mississippi | 28109 | 7 | 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 |
5603 | 5603 | 2020-03-20 | Bolivar | Mississippi | 28011 | 2 | 0 |
5604 | 5604 | 2020-03-20 | Coahoma | Mississippi | 28027 | 3 | 0 |
5605 | 5605 | 2020-03-20 | Copiah | Mississippi | 28029 | 2 | 0 |
5606 | 5606 | 2020-03-20 | DeSoto | Mississippi | 28033 | 4 | 0 |
5607 | 5607 | 2020-03-20 | Forrest | Mississippi | 28035 | 4 | 0 |
5608 | 5608 | 2020-03-20 | Franklin | Mississippi | 28037 | 1 | 0 |
5609 | 5609 | 2020-03-20 | Hancock | Mississippi | 28045 | 3 | 1 |
5610 | 5610 | 2020-03-20 | Harrison | Mississippi | 28047 | 8 | 0 |
5611 | 5611 | 2020-03-20 | Hinds | Mississippi | 28049 | 7 | 0 |
5612 | 5612 | 2020-03-20 | Holmes | Mississippi | 28051 | 3 | 0 |
5613 | 5613 | 2020-03-20 | Humphreys | Mississippi | 28053 | 1 | 0 |
5614 | 5614 | 2020-03-20 | Jackson | Mississippi | 28059 | 3 | 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 |
5619 | 5619 | 2020-03-20 | Leflore | Mississippi | 28083 | 7 | 0 |
5620 | 5620 | 2020-03-20 | Madison | Mississippi | 28089 | 3 | 0 |
5621 | 5621 | 2020-03-20 | Marshall | Mississippi | 28093 | 1 | 0 |
5622 | 5622 | 2020-03-20 | Monroe | Mississippi | 28095 | 2 | 0 |
5623 | 5623 | 2020-03-20 | Pearl River | Mississippi | 28109 | 7 | 0 |
5624 | 5624 | 2020-03-20 | Perry | Mississippi | 28111 | 1 | 0 |
5625 | 5625 | 2020-03-20 | Pike | Mississippi | 28113 | 1 | 0 |
5626 | 5626 | 2020-03-20 | Rankin | Mississippi | 28121 | 3 | 0 |
5627 | 5627 | 2020-03-20 | Scott | Mississippi | 28123 | 1 | 0 |
5628 | 5628 | 2020-03-20 | Smith | Mississippi | 28129 | 1 | 0 |
5629 | 5629 | 2020-03-20 | Tippah | Mississippi | 28139 | 3 | 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 |
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);