ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 623 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1743364 | 1743364 | 2021-09-22 | Sharkey | Mississippi | 28125 | 623 | 20 |
1074424 | 1074424 | 2021-02-28 | Jefferson | Mississippi | 28063 | 623 | 27 |
1071225 | 1071225 | 2021-02-27 | Wilkinson | Mississippi | 28157 | 623 | 26 |
951070 | 951070 | 2021-01-21 | Choctaw | Mississippi | 28019 | 623 | 13 |
853706 | 853706 | 2020-12-22 | Benton | Mississippi | 28009 | 623 | 20 |
808294 | 808294 | 2020-12-08 | Jefferson Davis | Mississippi | 28065 | 623 | 18 |
782374 | 782374 | 2020-11-30 | Tunica | Mississippi | 28143 | 623 | 19 |
707719 | 707719 | 2020-11-07 | Noxubee | Mississippi | 28103 | 623 | 17 |
603881 | 603881 | 2020-10-06 | Clay | Mississippi | 28025 | 623 | 20 |
594154 | 594154 | 2020-10-03 | Clarke | Mississippi | 28023 | 623 | 48 |
480917 | 480917 | 2020-08-29 | Tallahatchie | Mississippi | 28135 | 623 | 13 |
419606 | 419606 | 2020-08-10 | Winston | Mississippi | 28159 | 623 | 16 |
416306 | 416306 | 2020-08-09 | Adams | Mississippi | 28001 | 623 | 25 |
371331 | 371331 | 2020-07-26 | Simpson | Mississippi | 28127 | 623 | 13 |
345708 | 345708 | 2020-07-18 | Wayne | Mississippi | 28153 | 623 | 20 |
329712 | 329712 | 2020-07-13 | Oktibbeha | Mississippi | 28105 | 623 | 28 |
182958 | 182958 | 2020-05-27 | Scott | Mississippi | 28123 | 623 | 10 |
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);