ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 282 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
736881 | 736881 | 2020-11-16 | Franklin | Mississippi | 28037 | 282 | 4 |
629812 | 629812 | 2020-10-14 | Benton | Mississippi | 28009 | 282 | 4 |
500255 | 500255 | 2020-09-04 | Amite | Mississippi | 28005 | 282 | 7 |
497021 | 497021 | 2020-09-03 | Amite | Mississippi | 28005 | 282 | 7 |
464714 | 464714 | 2020-08-24 | Greene | Mississippi | 28041 | 282 | 14 |
464771 | 464771 | 2020-08-24 | Webster | Mississippi | 28155 | 282 | 13 |
461483 | 461483 | 2020-08-23 | Greene | Mississippi | 28041 | 282 | 14 |
461540 | 461540 | 2020-08-23 | Webster | Mississippi | 28155 | 282 | 13 |
458256 | 458256 | 2020-08-22 | Greene | Mississippi | 28041 | 282 | 14 |
455028 | 455028 | 2020-08-21 | Greene | Mississippi | 28041 | 282 | 14 |
406672 | 406672 | 2020-08-06 | Humphreys | Mississippi | 28053 | 282 | 11 |
380970 | 380970 | 2020-07-29 | Prentiss | Mississippi | 28117 | 282 | 6 |
377706 | 377706 | 2020-07-28 | Clarke | Mississippi | 28023 | 282 | 25 |
339308 | 339308 | 2020-07-16 | Union | Mississippi | 28145 | 282 | 11 |
329690 | 329690 | 2020-07-13 | Jasper | Mississippi | 28061 | 282 | 6 |
313842 | 313842 | 2020-07-08 | Winston | Mississippi | 28159 | 282 | 10 |
210567 | 210567 | 2020-06-05 | Leflore | Mississippi | 28083 | 282 | 38 |
201337 | 201337 | 2020-06-02 | Newton | Mississippi | 28101 | 282 | 4 |
149610 | 149610 | 2020-05-16 | Rankin | Mississippi | 28121 | 282 | 6 |
102341 | 102341 | 2020-04-30 | DeSoto | Mississippi | 28033 | 282 | 4 |
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);