ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 1089 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths
fips 16
county 16
- Quitman 6
- Jefferson Davis 4
- Adams 1
- Amite 1
- Calhoun 1
- Coahoma 1
- Covington 1
- Greene 1
- Noxubee 1
- Pearl River 1
- Tallahatchie 1
- Tishomingo 1
- Tunica 1
- Union 1
- Warren 1
- Wayne 1
state 1
- Mississippi · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2052087 | 2052087 | 2021-12-26 | Quitman | Mississippi | 28119 | 1089 | 28 |
2048837 | 2048837 | 2021-12-25 | Quitman | Mississippi | 28119 | 1089 | 28 |
2045587 | 2045587 | 2021-12-24 | Quitman | Mississippi | 28119 | 1089 | 28 |
2042337 | 2042337 | 2021-12-23 | Quitman | Mississippi | 28119 | 1089 | 28 |
2039088 | 2039088 | 2021-12-22 | Quitman | Mississippi | 28119 | 1089 | 28 |
2032588 | 2032588 | 2021-12-20 | Quitman | Mississippi | 28119 | 1089 | 28 |
1496515 | 1496515 | 2021-07-08 | Tunica | Mississippi | 28143 | 1089 | 27 |
1486735 | 1486735 | 2021-07-05 | Jefferson Davis | Mississippi | 28065 | 1089 | 34 |
1483489 | 1483489 | 2021-07-04 | Jefferson Davis | Mississippi | 28065 | 1089 | 34 |
1480243 | 1480243 | 2021-07-03 | Jefferson Davis | Mississippi | 28065 | 1089 | 34 |
1476996 | 1476996 | 2021-07-02 | Jefferson Davis | Mississippi | 28065 | 1089 | 34 |
1019220 | 1019220 | 2021-02-11 | Amite | Mississippi | 28005 | 1089 | 32 |
931608 | 931608 | 2021-01-15 | Greene | Mississippi | 28041 | 1089 | 29 |
928394 | 928394 | 2021-01-14 | Noxubee | Mississippi | 28103 | 1089 | 22 |
863443 | 863443 | 2020-12-25 | Calhoun | Mississippi | 28013 | 1089 | 16 |
827804 | 827804 | 2020-12-14 | Tallahatchie | Mississippi | 28135 | 1089 | 28 |
772637 | 772637 | 2020-11-27 | Tishomingo | Mississippi | 28141 | 1089 | 42 |
723901 | 723901 | 2020-11-12 | Covington | Mississippi | 28031 | 1089 | 31 |
723962 | 723962 | 2020-11-12 | Wayne | Mississippi | 28153 | 1089 | 22 |
668751 | 668751 | 2020-10-26 | Adams | Mississippi | 28001 | 1089 | 44 |
649337 | 649337 | 2020-10-20 | Pearl River | Mississippi | 28109 | 1089 | 58 |
623394 | 623394 | 2020-10-12 | Union | Mississippi | 28145 | 1089 | 24 |
539084 | 539084 | 2020-09-16 | Coahoma | Mississippi | 28027 | 1089 | 26 |
413160 | 413160 | 2020-08-08 | Warren | Mississippi | 28149 | 1089 | 32 |
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);