ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 492 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Mississippi · 33 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1149121 | 1149121 | 2021-03-23 | Sharkey | Mississippi | 28125 | 492 | 17 |
1145874 | 1145874 | 2021-03-22 | Sharkey | Mississippi | 28125 | 492 | 17 |
1142627 | 1142627 | 2021-03-21 | Sharkey | Mississippi | 28125 | 492 | 17 |
1139380 | 1139380 | 2021-03-20 | Sharkey | Mississippi | 28125 | 492 | 17 |
1136134 | 1136134 | 2021-03-19 | Sharkey | Mississippi | 28125 | 492 | 17 |
1132888 | 1132888 | 2021-03-18 | Sharkey | Mississippi | 28125 | 492 | 17 |
1129640 | 1129640 | 2021-03-17 | Sharkey | Mississippi | 28125 | 492 | 17 |
1126393 | 1126393 | 2021-03-16 | Sharkey | Mississippi | 28125 | 492 | 17 |
1123147 | 1123147 | 2021-03-15 | Sharkey | Mississippi | 28125 | 492 | 17 |
1119900 | 1119900 | 2021-03-14 | Sharkey | Mississippi | 28125 | 492 | 17 |
1116653 | 1116653 | 2021-03-13 | Sharkey | Mississippi | 28125 | 492 | 17 |
1113407 | 1113407 | 2021-03-12 | Sharkey | Mississippi | 28125 | 492 | 17 |
1110161 | 1110161 | 2021-03-11 | Sharkey | Mississippi | 28125 | 492 | 17 |
1106915 | 1106915 | 2021-03-10 | Sharkey | Mississippi | 28125 | 492 | 17 |
1103669 | 1103669 | 2021-03-09 | Sharkey | Mississippi | 28125 | 492 | 17 |
1100423 | 1100423 | 2021-03-08 | Sharkey | Mississippi | 28125 | 492 | 17 |
1097176 | 1097176 | 2021-03-07 | Sharkey | Mississippi | 28125 | 492 | 17 |
1093929 | 1093929 | 2021-03-06 | Sharkey | Mississippi | 28125 | 492 | 17 |
1090683 | 1090683 | 2021-03-05 | Sharkey | Mississippi | 28125 | 492 | 17 |
873181 | 873181 | 2020-12-28 | Choctaw | Mississippi | 28019 | 492 | 10 |
775871 | 775871 | 2020-11-28 | Quitman | Mississippi | 28119 | 492 | 7 |
723918 | 723918 | 2020-11-12 | Jefferson Davis | Mississippi | 28065 | 492 | 15 |
516483 | 516483 | 2020-09-09 | Smith | Mississippi | 28129 | 492 | 13 |
513249 | 513249 | 2020-09-08 | Smith | Mississippi | 28129 | 492 | 13 |
510017 | 510017 | 2020-09-07 | Smith | Mississippi | 28129 | 492 | 13 |
506784 | 506784 | 2020-09-06 | Smith | Mississippi | 28129 | 492 | 13 |
503551 | 503551 | 2020-09-05 | Smith | Mississippi | 28129 | 492 | 13 |
500265 | 500265 | 2020-09-04 | Clay | Mississippi | 28025 | 492 | 16 |
364863 | 364863 | 2020-07-24 | Coahoma | Mississippi | 28027 | 492 | 7 |
313805 | 313805 | 2020-07-08 | Lincoln | Mississippi | 28085 | 492 | 34 |
266478 | 266478 | 2020-06-23 | Copiah | Mississippi | 28029 | 492 | 11 |
176840 | 176840 | 2020-05-25 | Jones | Mississippi | 28067 | 492 | 15 |
134603 | 134603 | 2020-05-11 | Lauderdale | Mississippi | 28075 | 492 | 44 |
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);