ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28011 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730377 | 730377 | 2020-11-14 | Bolivar | Mississippi | 28011 | 2245 | 82 |
727134 | 727134 | 2020-11-13 | Bolivar | Mississippi | 28011 | 2232 | 82 |
723891 | 723891 | 2020-11-12 | Bolivar | Mississippi | 28011 | 2202 | 82 |
720648 | 720648 | 2020-11-11 | Bolivar | Mississippi | 28011 | 2184 | 82 |
717405 | 717405 | 2020-11-10 | Bolivar | Mississippi | 28011 | 2158 | 82 |
714161 | 714161 | 2020-11-09 | Bolivar | Mississippi | 28011 | 2148 | 81 |
710917 | 710917 | 2020-11-08 | Bolivar | Mississippi | 28011 | 2148 | 81 |
707673 | 707673 | 2020-11-07 | Bolivar | Mississippi | 28011 | 2144 | 81 |
704430 | 704430 | 2020-11-06 | Bolivar | Mississippi | 28011 | 2125 | 81 |
701188 | 701188 | 2020-11-05 | Bolivar | Mississippi | 28011 | 2103 | 81 |
697944 | 697944 | 2020-11-04 | Bolivar | Mississippi | 28011 | 2081 | 81 |
694701 | 694701 | 2020-11-03 | Bolivar | Mississippi | 28011 | 2076 | 81 |
691459 | 691459 | 2020-11-02 | Bolivar | Mississippi | 28011 | 2073 | 79 |
688214 | 688214 | 2020-11-01 | Bolivar | Mississippi | 28011 | 2072 | 79 |
684970 | 684970 | 2020-10-31 | Bolivar | Mississippi | 28011 | 2072 | 79 |
681727 | 681727 | 2020-10-30 | Bolivar | Mississippi | 28011 | 2062 | 79 |
678483 | 678483 | 2020-10-29 | Bolivar | Mississippi | 28011 | 2052 | 79 |
675241 | 675241 | 2020-10-28 | Bolivar | Mississippi | 28011 | 2039 | 79 |
671998 | 671998 | 2020-10-27 | Bolivar | Mississippi | 28011 | 2028 | 77 |
668756 | 668756 | 2020-10-26 | Bolivar | Mississippi | 28011 | 2019 | 77 |
665512 | 665512 | 2020-10-25 | Bolivar | Mississippi | 28011 | 2016 | 77 |
662267 | 662267 | 2020-10-24 | Bolivar | Mississippi | 28011 | 2016 | 77 |
659023 | 659023 | 2020-10-23 | Bolivar | Mississippi | 28011 | 2004 | 77 |
655778 | 655778 | 2020-10-22 | Bolivar | Mississippi | 28011 | 2001 | 77 |
652533 | 652533 | 2020-10-21 | Bolivar | Mississippi | 28011 | 1994 | 77 |
649288 | 649288 | 2020-10-20 | Bolivar | Mississippi | 28011 | 1983 | 77 |
646044 | 646044 | 2020-10-19 | Bolivar | Mississippi | 28011 | 1980 | 75 |
642797 | 642797 | 2020-10-18 | Bolivar | Mississippi | 28011 | 1977 | 75 |
639550 | 639550 | 2020-10-17 | Bolivar | Mississippi | 28011 | 1977 | 75 |
636304 | 636304 | 2020-10-16 | Bolivar | Mississippi | 28011 | 1973 | 75 |
633058 | 633058 | 2020-10-15 | Bolivar | Mississippi | 28011 | 1967 | 75 |
629813 | 629813 | 2020-10-14 | Bolivar | Mississippi | 28011 | 1962 | 75 |
626569 | 626569 | 2020-10-13 | Bolivar | Mississippi | 28011 | 1959 | 75 |
623327 | 623327 | 2020-10-12 | Bolivar | Mississippi | 28011 | 1943 | 75 |
620084 | 620084 | 2020-10-11 | Bolivar | Mississippi | 28011 | 1940 | 75 |
616842 | 616842 | 2020-10-10 | Bolivar | Mississippi | 28011 | 1942 | 75 |
613601 | 613601 | 2020-10-09 | Bolivar | Mississippi | 28011 | 1933 | 75 |
610359 | 610359 | 2020-10-08 | Bolivar | Mississippi | 28011 | 1928 | 74 |
607117 | 607117 | 2020-10-07 | Bolivar | Mississippi | 28011 | 1924 | 74 |
603874 | 603874 | 2020-10-06 | Bolivar | Mississippi | 28011 | 1912 | 72 |
600632 | 600632 | 2020-10-05 | Bolivar | Mississippi | 28011 | 1902 | 71 |
597389 | 597389 | 2020-10-04 | Bolivar | Mississippi | 28011 | 1902 | 71 |
594148 | 594148 | 2020-10-03 | Bolivar | Mississippi | 28011 | 1898 | 71 |
590907 | 590907 | 2020-10-02 | Bolivar | Mississippi | 28011 | 1889 | 71 |
587666 | 587666 | 2020-10-01 | Bolivar | Mississippi | 28011 | 1882 | 71 |
584426 | 584426 | 2020-09-30 | Bolivar | Mississippi | 28011 | 1873 | 70 |
581185 | 581185 | 2020-09-29 | Bolivar | Mississippi | 28011 | 1857 | 70 |
577944 | 577944 | 2020-09-28 | Bolivar | Mississippi | 28011 | 1849 | 66 |
574703 | 574703 | 2020-09-27 | Bolivar | Mississippi | 28011 | 1847 | 66 |
571460 | 571460 | 2020-09-26 | Bolivar | Mississippi | 28011 | 1845 | 66 |
568218 | 568218 | 2020-09-25 | Bolivar | Mississippi | 28011 | 1840 | 66 |
564978 | 564978 | 2020-09-24 | Bolivar | Mississippi | 28011 | 1823 | 66 |
561738 | 561738 | 2020-09-23 | Bolivar | Mississippi | 28011 | 1813 | 66 |
558501 | 558501 | 2020-09-22 | Bolivar | Mississippi | 28011 | 1797 | 65 |
555264 | 555264 | 2020-09-21 | Bolivar | Mississippi | 28011 | 1795 | 65 |
552026 | 552026 | 2020-09-20 | Bolivar | Mississippi | 28011 | 1794 | 65 |
548787 | 548787 | 2020-09-19 | Bolivar | Mississippi | 28011 | 1790 | 65 |
545549 | 545549 | 2020-09-18 | Bolivar | Mississippi | 28011 | 1775 | 65 |
542312 | 542312 | 2020-09-17 | Bolivar | Mississippi | 28011 | 1774 | 65 |
539076 | 539076 | 2020-09-16 | Bolivar | Mississippi | 28011 | 1750 | 64 |
535839 | 535839 | 2020-09-15 | Bolivar | Mississippi | 28011 | 1727 | 62 |
532604 | 532604 | 2020-09-14 | Bolivar | Mississippi | 28011 | 1708 | 60 |
529368 | 529368 | 2020-09-13 | Bolivar | Mississippi | 28011 | 1708 | 60 |
526132 | 526132 | 2020-09-12 | Bolivar | Mississippi | 28011 | 1706 | 60 |
522896 | 522896 | 2020-09-11 | Bolivar | Mississippi | 28011 | 1701 | 58 |
519659 | 519659 | 2020-09-10 | Bolivar | Mississippi | 28011 | 1678 | 58 |
516424 | 516424 | 2020-09-09 | Bolivar | Mississippi | 28011 | 1664 | 58 |
513190 | 513190 | 2020-09-08 | Bolivar | Mississippi | 28011 | 1652 | 58 |
509958 | 509958 | 2020-09-07 | Bolivar | Mississippi | 28011 | 1648 | 58 |
506725 | 506725 | 2020-09-06 | Bolivar | Mississippi | 28011 | 1647 | 58 |
503492 | 503492 | 2020-09-05 | Bolivar | Mississippi | 28011 | 1634 | 57 |
500258 | 500258 | 2020-09-04 | Bolivar | Mississippi | 28011 | 1605 | 56 |
497024 | 497024 | 2020-09-03 | Bolivar | Mississippi | 28011 | 1583 | 55 |
493791 | 493791 | 2020-09-02 | Bolivar | Mississippi | 28011 | 1556 | 54 |
490557 | 490557 | 2020-09-01 | Bolivar | Mississippi | 28011 | 1512 | 51 |
487324 | 487324 | 2020-08-31 | Bolivar | Mississippi | 28011 | 1492 | 49 |
484090 | 484090 | 2020-08-30 | Bolivar | Mississippi | 28011 | 1488 | 49 |
480855 | 480855 | 2020-08-29 | Bolivar | Mississippi | 28011 | 1462 | 48 |
477623 | 477623 | 2020-08-28 | Bolivar | Mississippi | 28011 | 1436 | 48 |
474390 | 474390 | 2020-08-27 | Bolivar | Mississippi | 28011 | 1428 | 46 |
471158 | 471158 | 2020-08-26 | Bolivar | Mississippi | 28011 | 1420 | 45 |
467928 | 467928 | 2020-08-25 | Bolivar | Mississippi | 28011 | 1380 | 42 |
464699 | 464699 | 2020-08-24 | Bolivar | Mississippi | 28011 | 1351 | 42 |
461468 | 461468 | 2020-08-23 | Bolivar | Mississippi | 28011 | 1342 | 42 |
458241 | 458241 | 2020-08-22 | Bolivar | Mississippi | 28011 | 1333 | 42 |
455013 | 455013 | 2020-08-21 | Bolivar | Mississippi | 28011 | 1310 | 42 |
451785 | 451785 | 2020-08-20 | Bolivar | Mississippi | 28011 | 1289 | 41 |
448557 | 448557 | 2020-08-19 | Bolivar | Mississippi | 28011 | 1269 | 40 |
445331 | 445331 | 2020-08-18 | Bolivar | Mississippi | 28011 | 1251 | 41 |
442105 | 442105 | 2020-08-17 | Bolivar | Mississippi | 28011 | 1224 | 40 |
438878 | 438878 | 2020-08-16 | Bolivar | Mississippi | 28011 | 1221 | 40 |
435653 | 435653 | 2020-08-15 | Bolivar | Mississippi | 28011 | 1219 | 40 |
432427 | 432427 | 2020-08-14 | Bolivar | Mississippi | 28011 | 1189 | 40 |
429200 | 429200 | 2020-08-13 | Bolivar | Mississippi | 28011 | 1167 | 37 |
425976 | 425976 | 2020-08-12 | Bolivar | Mississippi | 28011 | 1156 | 36 |
422754 | 422754 | 2020-08-11 | Bolivar | Mississippi | 28011 | 1136 | 35 |
419532 | 419532 | 2020-08-10 | Bolivar | Mississippi | 28011 | 1118 | 34 |
416311 | 416311 | 2020-08-09 | Bolivar | Mississippi | 28011 | 1113 | 34 |
413091 | 413091 | 2020-08-08 | Bolivar | Mississippi | 28011 | 1108 | 34 |
409871 | 409871 | 2020-08-07 | Bolivar | Mississippi | 28011 | 1093 | 33 |
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);