ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 175 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1597147 | 1597147 | 2021-08-08 | Issaquena | Mississippi | 28055 | 175 | 6 |
1593898 | 1593898 | 2021-08-07 | Issaquena | Mississippi | 28055 | 175 | 6 |
1590649 | 1590649 | 2021-08-06 | Issaquena | Mississippi | 28055 | 175 | 6 |
487337 | 487337 | 2020-08-31 | Franklin | Mississippi | 28037 | 175 | 3 |
484103 | 484103 | 2020-08-30 | Franklin | Mississippi | 28037 | 175 | 3 |
480868 | 480868 | 2020-08-29 | Franklin | Mississippi | 28037 | 175 | 3 |
380990 | 380990 | 2020-07-29 | Webster | Mississippi | 28155 | 175 | 11 |
371323 | 371323 | 2020-07-26 | Perry | Mississippi | 28111 | 175 | 6 |
364921 | 364921 | 2020-07-24 | Tunica | Mississippi | 28143 | 175 | 4 |
291691 | 291691 | 2020-07-01 | Union | Mississippi | 28145 | 175 | 9 |
272747 | 272747 | 2020-06-25 | Coahoma | Mississippi | 28027 | 175 | 6 |
272791 | 272791 | 2020-06-25 | Pontotoc | Mississippi | 28115 | 175 | 3 |
238437 | 238437 | 2020-06-14 | Lafayette | Mississippi | 28071 | 175 | 4 |
235359 | 235359 | 2020-06-13 | Smith | Mississippi | 28129 | 175 | 11 |
213640 | 213640 | 2020-06-06 | Jasper | Mississippi | 28061 | 175 | 4 |
198288 | 198288 | 2020-06-01 | Warren | Mississippi | 28149 | 175 | 10 |
155611 | 155611 | 2020-05-18 | Lamar | Mississippi | 28073 | 175 | 4 |
152597 | 152597 | 2020-05-17 | Lamar | Mississippi | 28073 | 175 | 4 |
116723 | 116723 | 2020-05-05 | Leflore | Mississippi | 28083 | 175 | 18 |
113847 | 113847 | 2020-05-04 | Monroe | Mississippi | 28095 | 175 | 16 |
110968 | 110968 | 2020-05-03 | Monroe | Mississippi | 28095 | 175 | 16 |
105239 | 105239 | 2020-05-01 | Pearl River | Mississippi | 28109 | 175 | 20 |
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);