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 |
---|---|---|---|---|---|---|---|
1061418 | 1061418 | 2021-02-24 | Bolivar | Mississippi | 28011 | 4580 | 120 |
1058172 | 1058172 | 2021-02-23 | Bolivar | Mississippi | 28011 | 4567 | 120 |
1054926 | 1054926 | 2021-02-22 | Bolivar | Mississippi | 28011 | 4566 | 120 |
1051679 | 1051679 | 2021-02-21 | Bolivar | Mississippi | 28011 | 4564 | 120 |
1048432 | 1048432 | 2021-02-20 | Bolivar | Mississippi | 28011 | 4550 | 120 |
1045186 | 1045186 | 2021-02-19 | Bolivar | Mississippi | 28011 | 4548 | 119 |
1041941 | 1041941 | 2021-02-18 | Bolivar | Mississippi | 28011 | 4542 | 119 |
1038696 | 1038696 | 2021-02-17 | Bolivar | Mississippi | 28011 | 4530 | 119 |
1035451 | 1035451 | 2021-02-16 | Bolivar | Mississippi | 28011 | 4517 | 117 |
1032206 | 1032206 | 2021-02-15 | Bolivar | Mississippi | 28011 | 4509 | 116 |
1028959 | 1028959 | 2021-02-14 | Bolivar | Mississippi | 28011 | 4505 | 116 |
1025713 | 1025713 | 2021-02-13 | Bolivar | Mississippi | 28011 | 4485 | 116 |
1022468 | 1022468 | 2021-02-12 | Bolivar | Mississippi | 28011 | 4471 | 114 |
1019223 | 1019223 | 2021-02-11 | Bolivar | Mississippi | 28011 | 4455 | 112 |
1015978 | 1015978 | 2021-02-10 | Bolivar | Mississippi | 28011 | 4448 | 112 |
1012733 | 1012733 | 2021-02-09 | Bolivar | Mississippi | 28011 | 4437 | 112 |
1009488 | 1009488 | 2021-02-08 | Bolivar | Mississippi | 28011 | 4430 | 112 |
1006241 | 1006241 | 2021-02-07 | Bolivar | Mississippi | 28011 | 4418 | 112 |
1002995 | 1002995 | 2021-02-06 | Bolivar | Mississippi | 28011 | 4411 | 112 |
999750 | 999750 | 2021-02-05 | Bolivar | Mississippi | 28011 | 4402 | 112 |
996504 | 996504 | 2021-02-04 | Bolivar | Mississippi | 28011 | 4385 | 111 |
993258 | 993258 | 2021-02-03 | Bolivar | Mississippi | 28011 | 4353 | 111 |
990012 | 990012 | 2021-02-02 | Bolivar | Mississippi | 28011 | 4341 | 111 |
986765 | 986765 | 2021-02-01 | Bolivar | Mississippi | 28011 | 4322 | 111 |
983518 | 983518 | 2021-01-31 | Bolivar | Mississippi | 28011 | 4315 | 111 |
980272 | 980272 | 2021-01-30 | Bolivar | Mississippi | 28011 | 4298 | 111 |
977026 | 977026 | 2021-01-29 | Bolivar | Mississippi | 28011 | 4272 | 111 |
973781 | 973781 | 2021-01-28 | Bolivar | Mississippi | 28011 | 4219 | 111 |
970536 | 970536 | 2021-01-27 | Bolivar | Mississippi | 28011 | 4187 | 111 |
967291 | 967291 | 2021-01-26 | Bolivar | Mississippi | 28011 | 4164 | 110 |
964047 | 964047 | 2021-01-25 | Bolivar | Mississippi | 28011 | 4149 | 109 |
960802 | 960802 | 2021-01-24 | Bolivar | Mississippi | 28011 | 4126 | 109 |
957556 | 957556 | 2021-01-23 | Bolivar | Mississippi | 28011 | 4104 | 109 |
954311 | 954311 | 2021-01-22 | Bolivar | Mississippi | 28011 | 4087 | 109 |
951066 | 951066 | 2021-01-21 | Bolivar | Mississippi | 28011 | 4068 | 109 |
947820 | 947820 | 2021-01-20 | Bolivar | Mississippi | 28011 | 4024 | 109 |
944573 | 944573 | 2021-01-19 | Bolivar | Mississippi | 28011 | 3997 | 109 |
941328 | 941328 | 2021-01-18 | Bolivar | Mississippi | 28011 | 3978 | 108 |
938083 | 938083 | 2021-01-17 | Bolivar | Mississippi | 28011 | 3966 | 108 |
934838 | 934838 | 2021-01-16 | Bolivar | Mississippi | 28011 | 3955 | 106 |
931593 | 931593 | 2021-01-15 | Bolivar | Mississippi | 28011 | 3941 | 106 |
928348 | 928348 | 2021-01-14 | Bolivar | Mississippi | 28011 | 3915 | 105 |
925102 | 925102 | 2021-01-13 | Bolivar | Mississippi | 28011 | 3881 | 105 |
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 |
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);