ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 10, fips = 28005 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
623324 | 623324 | 2020-10-12 | Amite | Mississippi | 28005 | 378 | 10 |
620081 | 620081 | 2020-10-11 | Amite | Mississippi | 28005 | 376 | 10 |
616839 | 616839 | 2020-10-10 | Amite | Mississippi | 28005 | 375 | 10 |
613598 | 613598 | 2020-10-09 | Amite | Mississippi | 28005 | 368 | 10 |
610356 | 610356 | 2020-10-08 | Amite | Mississippi | 28005 | 364 | 10 |
607114 | 607114 | 2020-10-07 | Amite | Mississippi | 28005 | 363 | 10 |
603871 | 603871 | 2020-10-06 | Amite | Mississippi | 28005 | 360 | 10 |
600629 | 600629 | 2020-10-05 | Amite | Mississippi | 28005 | 355 | 10 |
597386 | 597386 | 2020-10-04 | Amite | Mississippi | 28005 | 355 | 10 |
594145 | 594145 | 2020-10-03 | Amite | Mississippi | 28005 | 348 | 10 |
590904 | 590904 | 2020-10-02 | Amite | Mississippi | 28005 | 345 | 10 |
587663 | 587663 | 2020-10-01 | Amite | Mississippi | 28005 | 342 | 10 |
584423 | 584423 | 2020-09-30 | Amite | Mississippi | 28005 | 342 | 10 |
581182 | 581182 | 2020-09-29 | Amite | Mississippi | 28005 | 342 | 10 |
577941 | 577941 | 2020-09-28 | Amite | Mississippi | 28005 | 335 | 10 |
574700 | 574700 | 2020-09-27 | Amite | Mississippi | 28005 | 332 | 10 |
571457 | 571457 | 2020-09-26 | Amite | Mississippi | 28005 | 332 | 10 |
568215 | 568215 | 2020-09-25 | Amite | Mississippi | 28005 | 329 | 10 |
564975 | 564975 | 2020-09-24 | Amite | Mississippi | 28005 | 325 | 10 |
561735 | 561735 | 2020-09-23 | Amite | Mississippi | 28005 | 321 | 10 |
558498 | 558498 | 2020-09-22 | Amite | Mississippi | 28005 | 314 | 10 |
555261 | 555261 | 2020-09-21 | Amite | Mississippi | 28005 | 311 | 10 |
552023 | 552023 | 2020-09-20 | Amite | Mississippi | 28005 | 311 | 10 |
548784 | 548784 | 2020-09-19 | Amite | Mississippi | 28005 | 312 | 10 |
545546 | 545546 | 2020-09-18 | Amite | Mississippi | 28005 | 311 | 10 |
542309 | 542309 | 2020-09-17 | Amite | Mississippi | 28005 | 307 | 10 |
539073 | 539073 | 2020-09-16 | Amite | Mississippi | 28005 | 303 | 10 |
535836 | 535836 | 2020-09-15 | Amite | Mississippi | 28005 | 293 | 10 |
532601 | 532601 | 2020-09-14 | Amite | Mississippi | 28005 | 291 | 10 |
529365 | 529365 | 2020-09-13 | Amite | Mississippi | 28005 | 291 | 10 |
526129 | 526129 | 2020-09-12 | Amite | Mississippi | 28005 | 291 | 10 |
522893 | 522893 | 2020-09-11 | Amite | Mississippi | 28005 | 289 | 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);