ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 2621 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Covington 3
- Grenada 3
- Holmes 3
- Jefferson Davis 3
- Montgomery 3
- Prentiss 1
- Simpson 1
- Wayne 1
- Yazoo 1
state 1
- Mississippi · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2165882 | 2165882 | 2022-01-30 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2162627 | 2162627 | 2022-01-29 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2159372 | 2159372 | 2022-01-28 | Jefferson Davis | Mississippi | 28065 | 2621 | 43 |
2143122 | 2143122 | 2022-01-23 | Montgomery | Mississippi | 28097 | 2621 | 61 |
2139867 | 2139867 | 2022-01-22 | Montgomery | Mississippi | 28097 | 2621 | 61 |
2136611 | 2136611 | 2022-01-21 | Montgomery | Mississippi | 28097 | 2621 | 61 |
1756322 | 1756322 | 2021-09-26 | Holmes | Mississippi | 28051 | 2621 | 87 |
1753074 | 1753074 | 2021-09-25 | Holmes | Mississippi | 28051 | 2621 | 87 |
1749826 | 1749826 | 2021-09-24 | Holmes | Mississippi | 28051 | 2621 | 87 |
1347154 | 1347154 | 2021-05-23 | Covington | Mississippi | 28031 | 2621 | 81 |
1343906 | 1343906 | 2021-05-22 | Covington | Mississippi | 28031 | 2621 | 81 |
1340657 | 1340657 | 2021-05-21 | Covington | Mississippi | 28031 | 2621 | 81 |
1337416 | 1337416 | 2021-05-20 | Grenada | Mississippi | 28043 | 2621 | 87 |
1334169 | 1334169 | 2021-05-19 | Grenada | Mississippi | 28043 | 2621 | 87 |
1330922 | 1330922 | 2021-05-18 | Grenada | Mississippi | 28043 | 2621 | 87 |
1269293 | 1269293 | 2021-04-29 | Wayne | Mississippi | 28153 | 2621 | 41 |
1032264 | 1032264 | 2021-02-15 | Simpson | Mississippi | 28127 | 2621 | 78 |
999803 | 999803 | 2021-02-05 | Prentiss | Mississippi | 28117 | 2621 | 56 |
973857 | 973857 | 2021-01-28 | Yazoo | Mississippi | 28163 | 2621 | 56 |
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);