ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 431 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
944630 | 944630 | 2021-01-19 | Sharkey | Mississippi | 28125 | 431 | 17 |
830992 | 830992 | 2020-12-15 | Choctaw | Mississippi | 28019 | 431 | 10 |
701242 | 701242 | 2020-11-05 | Quitman | Mississippi | 28119 | 431 | 7 |
565011 | 565011 | 2020-09-24 | Lawrence | Mississippi | 28077 | 431 | 12 |
477629 | 477629 | 2020-08-28 | Clarke | Mississippi | 28023 | 431 | 28 |
474396 | 474396 | 2020-08-27 | Clarke | Mississippi | 28023 | 431 | 28 |
467994 | 467994 | 2020-08-25 | Tunica | Mississippi | 28143 | 431 | 10 |
448564 | 448564 | 2020-08-19 | Clay | Mississippi | 28025 | 431 | 14 |
374534 | 374534 | 2020-07-27 | Pearl River | Mississippi | 28109 | 431 | 34 |
336108 | 336108 | 2020-07-15 | Tate | Mississippi | 28137 | 431 | 13 |
313810 | 313810 | 2020-07-08 | Monroe | Mississippi | 28095 | 431 | 35 |
304314 | 304314 | 2020-07-05 | Pike | Mississippi | 28113 | 431 | 12 |
301150 | 301150 | 2020-07-04 | Pike | Mississippi | 28113 | 431 | 12 |
294809 | 294809 | 2020-07-02 | Lamar | Mississippi | 28073 | 431 | 7 |
282216 | 282216 | 2020-06-28 | Lowndes | Mississippi | 28087 | 431 | 11 |
269648 | 269648 | 2020-06-24 | Oktibbeha | Mississippi | 28105 | 431 | 20 |
198253 | 198253 | 2020-06-01 | Leake | Mississippi | 28079 | 431 | 12 |
152579 | 152579 | 2020-05-17 | Forrest | Mississippi | 28035 | 431 | 27 |
131619 | 131619 | 2020-05-10 | Madison | Mississippi | 28089 | 431 | 12 |
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);