ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Bolivar" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921857 | 921857 | 2021-01-12 | Bolivar | Mississippi | 28011 | 3868 | 102 |
918612 | 918612 | 2021-01-11 | Bolivar | Mississippi | 28011 | 3842 | 101 |
915367 | 915367 | 2021-01-10 | Bolivar | Mississippi | 28011 | 3828 | 101 |
912122 | 912122 | 2021-01-09 | Bolivar | Mississippi | 28011 | 3796 | 101 |
908877 | 908877 | 2021-01-08 | Bolivar | Mississippi | 28011 | 3711 | 99 |
905631 | 905631 | 2021-01-07 | Bolivar | Mississippi | 28011 | 3667 | 97 |
902386 | 902386 | 2021-01-06 | Bolivar | Mississippi | 28011 | 3595 | 96 |
899141 | 899141 | 2021-01-05 | Bolivar | Mississippi | 28011 | 3569 | 96 |
895896 | 895896 | 2021-01-04 | Bolivar | Mississippi | 28011 | 3550 | 95 |
892649 | 892649 | 2021-01-03 | Bolivar | Mississippi | 28011 | 3516 | 95 |
889403 | 889403 | 2021-01-02 | Bolivar | Mississippi | 28011 | 3475 | 95 |
886157 | 886157 | 2021-01-01 | Bolivar | Mississippi | 28011 | 3450 | 95 |
882912 | 882912 | 2020-12-31 | Bolivar | Mississippi | 28011 | 3418 | 95 |
879667 | 879667 | 2020-12-30 | Bolivar | Mississippi | 28011 | 3373 | 95 |
876422 | 876422 | 2020-12-29 | Bolivar | Mississippi | 28011 | 3309 | 95 |
873177 | 873177 | 2020-12-28 | Bolivar | Mississippi | 28011 | 3274 | 95 |
869932 | 869932 | 2020-12-27 | Bolivar | Mississippi | 28011 | 3252 | 95 |
866687 | 866687 | 2020-12-26 | Bolivar | Mississippi | 28011 | 3235 | 95 |
863442 | 863442 | 2020-12-25 | Bolivar | Mississippi | 28011 | 3220 | 95 |
860197 | 860197 | 2020-12-24 | Bolivar | Mississippi | 28011 | 3202 | 95 |
856952 | 856952 | 2020-12-23 | Bolivar | Mississippi | 28011 | 3154 | 95 |
853707 | 853707 | 2020-12-22 | Bolivar | Mississippi | 28011 | 3097 | 95 |
850462 | 850462 | 2020-12-21 | Bolivar | Mississippi | 28011 | 3051 | 92 |
847217 | 847217 | 2020-12-20 | Bolivar | Mississippi | 28011 | 3035 | 92 |
843971 | 843971 | 2020-12-19 | Bolivar | Mississippi | 28011 | 3001 | 91 |
840726 | 840726 | 2020-12-18 | Bolivar | Mississippi | 28011 | 2993 | 91 |
837481 | 837481 | 2020-12-17 | Bolivar | Mississippi | 28011 | 2941 | 91 |
834235 | 834235 | 2020-12-16 | Bolivar | Mississippi | 28011 | 2908 | 90 |
830988 | 830988 | 2020-12-15 | Bolivar | Mississippi | 28011 | 2857 | 90 |
827742 | 827742 | 2020-12-14 | Bolivar | Mississippi | 28011 | 2828 | 89 |
824495 | 824495 | 2020-12-13 | Bolivar | Mississippi | 28011 | 2815 | 89 |
821249 | 821249 | 2020-12-12 | Bolivar | Mississippi | 28011 | 2796 | 89 |
818003 | 818003 | 2020-12-11 | Bolivar | Mississippi | 28011 | 2753 | 89 |
814757 | 814757 | 2020-12-10 | Bolivar | Mississippi | 28011 | 2726 | 89 |
811512 | 811512 | 2020-12-09 | Bolivar | Mississippi | 28011 | 2703 | 89 |
808267 | 808267 | 2020-12-08 | Bolivar | Mississippi | 28011 | 2657 | 89 |
805022 | 805022 | 2020-12-07 | Bolivar | Mississippi | 28011 | 2637 | 86 |
801777 | 801777 | 2020-12-06 | Bolivar | Mississippi | 28011 | 2629 | 86 |
798532 | 798532 | 2020-12-05 | Bolivar | Mississippi | 28011 | 2589 | 86 |
795287 | 795287 | 2020-12-04 | Bolivar | Mississippi | 28011 | 2546 | 86 |
792042 | 792042 | 2020-12-03 | Bolivar | Mississippi | 28011 | 2501 | 85 |
788797 | 788797 | 2020-12-02 | Bolivar | Mississippi | 28011 | 2480 | 84 |
785552 | 785552 | 2020-12-01 | Bolivar | Mississippi | 28011 | 2443 | 84 |
782308 | 782308 | 2020-11-30 | Bolivar | Mississippi | 28011 | 2429 | 84 |
779062 | 779062 | 2020-11-29 | Bolivar | Mississippi | 28011 | 2424 | 84 |
775817 | 775817 | 2020-11-28 | Bolivar | Mississippi | 28011 | 2413 | 84 |
772572 | 772572 | 2020-11-27 | Bolivar | Mississippi | 28011 | 2409 | 84 |
769327 | 769327 | 2020-11-26 | Bolivar | Mississippi | 28011 | 2408 | 84 |
766081 | 766081 | 2020-11-25 | Bolivar | Mississippi | 28011 | 2401 | 84 |
762836 | 762836 | 2020-11-24 | Bolivar | Mississippi | 28011 | 2390 | 83 |
759591 | 759591 | 2020-11-23 | Bolivar | Mississippi | 28011 | 2378 | 83 |
756344 | 756344 | 2020-11-22 | Bolivar | Mississippi | 28011 | 2375 | 83 |
753098 | 753098 | 2020-11-21 | Bolivar | Mississippi | 28011 | 2369 | 83 |
749852 | 749852 | 2020-11-20 | Bolivar | Mississippi | 28011 | 2350 | 83 |
746606 | 746606 | 2020-11-19 | Bolivar | Mississippi | 28011 | 2315 | 83 |
743359 | 743359 | 2020-11-18 | Bolivar | Mississippi | 28011 | 2294 | 83 |
740112 | 740112 | 2020-11-17 | Bolivar | Mississippi | 28011 | 2266 | 83 |
736868 | 736868 | 2020-11-16 | Bolivar | Mississippi | 28011 | 2257 | 82 |
733622 | 733622 | 2020-11-15 | Bolivar | Mississippi | 28011 | 2251 | 82 |
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 |
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);