ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where cases = 6008 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 |
---|---|---|---|---|---|---|---|
2501070 | 2501070 | 2022-05-13 | Wayne | Mississippi | 28153 | 6008 | 87 |
2497812 | 2497812 | 2022-05-12 | Wayne | Mississippi | 28153 | 6008 | 87 |
2494554 | 2494554 | 2022-05-11 | Wayne | Mississippi | 28153 | 6008 | 87 |
2491296 | 2491296 | 2022-05-10 | Wayne | Mississippi | 28153 | 6008 | 87 |
2488038 | 2488038 | 2022-05-09 | Wayne | Mississippi | 28153 | 6008 | 87 |
2211464 | 2211464 | 2022-02-13 | Tishomingo | Mississippi | 28141 | 6008 | 115 |
2208211 | 2208211 | 2022-02-12 | Tishomingo | Mississippi | 28141 | 6008 | 115 |
2204958 | 2204958 | 2022-02-11 | Tishomingo | Mississippi | 28141 | 6008 | 115 |
2146329 | 2146329 | 2022-01-24 | Adams | Mississippi | 28001 | 6008 | 125 |
2032585 | 2032585 | 2021-12-20 | Pike | Mississippi | 28113 | 6008 | 158 |
1064700 | 1064700 | 2021-02-25 | Lowndes | Mississippi | 28087 | 6008 | 137 |
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);