ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28081 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054961 | 1054961 | 2021-02-22 | Lee | Mississippi | 28081 | 9627 | 160 |
1051714 | 1051714 | 2021-02-21 | Lee | Mississippi | 28081 | 9620 | 160 |
1048467 | 1048467 | 2021-02-20 | Lee | Mississippi | 28081 | 9618 | 160 |
1045221 | 1045221 | 2021-02-19 | Lee | Mississippi | 28081 | 9608 | 159 |
1041976 | 1041976 | 2021-02-18 | Lee | Mississippi | 28081 | 9602 | 159 |
1038731 | 1038731 | 2021-02-17 | Lee | Mississippi | 28081 | 9601 | 159 |
1035486 | 1035486 | 2021-02-16 | Lee | Mississippi | 28081 | 9592 | 158 |
1032241 | 1032241 | 2021-02-15 | Lee | Mississippi | 28081 | 9575 | 158 |
1028994 | 1028994 | 2021-02-14 | Lee | Mississippi | 28081 | 9568 | 158 |
1025748 | 1025748 | 2021-02-13 | Lee | Mississippi | 28081 | 9555 | 158 |
1022503 | 1022503 | 2021-02-12 | Lee | Mississippi | 28081 | 9543 | 156 |
1019258 | 1019258 | 2021-02-11 | Lee | Mississippi | 28081 | 9518 | 154 |
1016013 | 1016013 | 2021-02-10 | Lee | Mississippi | 28081 | 9478 | 154 |
1012768 | 1012768 | 2021-02-09 | Lee | Mississippi | 28081 | 9464 | 153 |
1009523 | 1009523 | 2021-02-08 | Lee | Mississippi | 28081 | 9443 | 153 |
1006276 | 1006276 | 2021-02-07 | Lee | Mississippi | 28081 | 9431 | 153 |
1003030 | 1003030 | 2021-02-06 | Lee | Mississippi | 28081 | 9410 | 153 |
999785 | 999785 | 2021-02-05 | Lee | Mississippi | 28081 | 9381 | 153 |
996539 | 996539 | 2021-02-04 | Lee | Mississippi | 28081 | 9346 | 151 |
993293 | 993293 | 2021-02-03 | Lee | Mississippi | 28081 | 9323 | 150 |
990047 | 990047 | 2021-02-02 | Lee | Mississippi | 28081 | 9306 | 150 |
986800 | 986800 | 2021-02-01 | Lee | Mississippi | 28081 | 9289 | 149 |
983553 | 983553 | 2021-01-31 | Lee | Mississippi | 28081 | 9279 | 149 |
980307 | 980307 | 2021-01-30 | Lee | Mississippi | 28081 | 9264 | 149 |
977061 | 977061 | 2021-01-29 | Lee | Mississippi | 28081 | 9241 | 149 |
973816 | 973816 | 2021-01-28 | Lee | Mississippi | 28081 | 9202 | 149 |
970571 | 970571 | 2021-01-27 | Lee | Mississippi | 28081 | 9160 | 149 |
967326 | 967326 | 2021-01-26 | Lee | Mississippi | 28081 | 9109 | 147 |
964082 | 964082 | 2021-01-25 | Lee | Mississippi | 28081 | 9088 | 145 |
960837 | 960837 | 2021-01-24 | Lee | Mississippi | 28081 | 9071 | 145 |
957591 | 957591 | 2021-01-23 | Lee | Mississippi | 28081 | 9050 | 144 |
954346 | 954346 | 2021-01-22 | Lee | Mississippi | 28081 | 9014 | 143 |
951101 | 951101 | 2021-01-21 | Lee | Mississippi | 28081 | 8981 | 141 |
947855 | 947855 | 2021-01-20 | Lee | Mississippi | 28081 | 8922 | 141 |
944608 | 944608 | 2021-01-19 | Lee | Mississippi | 28081 | 8864 | 141 |
941363 | 941363 | 2021-01-18 | Lee | Mississippi | 28081 | 8819 | 141 |
938118 | 938118 | 2021-01-17 | Lee | Mississippi | 28081 | 8796 | 141 |
934873 | 934873 | 2021-01-16 | Lee | Mississippi | 28081 | 8759 | 141 |
931628 | 931628 | 2021-01-15 | Lee | Mississippi | 28081 | 8721 | 135 |
928383 | 928383 | 2021-01-14 | Lee | Mississippi | 28081 | 8666 | 135 |
925137 | 925137 | 2021-01-13 | Lee | Mississippi | 28081 | 8603 | 135 |
921892 | 921892 | 2021-01-12 | Lee | Mississippi | 28081 | 8526 | 135 |
918647 | 918647 | 2021-01-11 | Lee | Mississippi | 28081 | 8472 | 133 |
915402 | 915402 | 2021-01-10 | Lee | Mississippi | 28081 | 8448 | 133 |
912157 | 912157 | 2021-01-09 | Lee | Mississippi | 28081 | 8403 | 133 |
908912 | 908912 | 2021-01-08 | Lee | Mississippi | 28081 | 8305 | 131 |
905666 | 905666 | 2021-01-07 | Lee | Mississippi | 28081 | 8261 | 131 |
902421 | 902421 | 2021-01-06 | Lee | Mississippi | 28081 | 8161 | 125 |
899176 | 899176 | 2021-01-05 | Lee | Mississippi | 28081 | 8075 | 123 |
895931 | 895931 | 2021-01-04 | Lee | Mississippi | 28081 | 7927 | 122 |
892684 | 892684 | 2021-01-03 | Lee | Mississippi | 28081 | 7872 | 120 |
889438 | 889438 | 2021-01-02 | Lee | Mississippi | 28081 | 7807 | 118 |
886192 | 886192 | 2021-01-01 | Lee | Mississippi | 28081 | 7758 | 118 |
882947 | 882947 | 2020-12-31 | Lee | Mississippi | 28081 | 7668 | 118 |
879702 | 879702 | 2020-12-30 | Lee | Mississippi | 28081 | 7566 | 118 |
876457 | 876457 | 2020-12-29 | Lee | Mississippi | 28081 | 7455 | 118 |
873212 | 873212 | 2020-12-28 | Lee | Mississippi | 28081 | 7370 | 115 |
869967 | 869967 | 2020-12-27 | Lee | Mississippi | 28081 | 7316 | 114 |
866722 | 866722 | 2020-12-26 | Lee | Mississippi | 28081 | 7246 | 111 |
863477 | 863477 | 2020-12-25 | Lee | Mississippi | 28081 | 7230 | 111 |
860232 | 860232 | 2020-12-24 | Lee | Mississippi | 28081 | 7188 | 111 |
856987 | 856987 | 2020-12-23 | Lee | Mississippi | 28081 | 7121 | 111 |
853742 | 853742 | 2020-12-22 | Lee | Mississippi | 28081 | 7026 | 110 |
850497 | 850497 | 2020-12-21 | Lee | Mississippi | 28081 | 6894 | 109 |
847252 | 847252 | 2020-12-20 | Lee | Mississippi | 28081 | 6853 | 109 |
844006 | 844006 | 2020-12-19 | Lee | Mississippi | 28081 | 6772 | 108 |
840761 | 840761 | 2020-12-18 | Lee | Mississippi | 28081 | 6675 | 106 |
837516 | 837516 | 2020-12-17 | Lee | Mississippi | 28081 | 6595 | 106 |
834270 | 834270 | 2020-12-16 | Lee | Mississippi | 28081 | 6540 | 106 |
831023 | 831023 | 2020-12-15 | Lee | Mississippi | 28081 | 6422 | 105 |
827777 | 827777 | 2020-12-14 | Lee | Mississippi | 28081 | 6321 | 105 |
824530 | 824530 | 2020-12-13 | Lee | Mississippi | 28081 | 6208 | 105 |
821284 | 821284 | 2020-12-12 | Lee | Mississippi | 28081 | 6157 | 104 |
818038 | 818038 | 2020-12-11 | Lee | Mississippi | 28081 | 6079 | 103 |
814792 | 814792 | 2020-12-10 | Lee | Mississippi | 28081 | 6006 | 100 |
811547 | 811547 | 2020-12-09 | Lee | Mississippi | 28081 | 5925 | 99 |
808302 | 808302 | 2020-12-08 | Lee | Mississippi | 28081 | 5829 | 99 |
805057 | 805057 | 2020-12-07 | Lee | Mississippi | 28081 | 5748 | 98 |
801812 | 801812 | 2020-12-06 | Lee | Mississippi | 28081 | 5701 | 98 |
798567 | 798567 | 2020-12-05 | Lee | Mississippi | 28081 | 5646 | 98 |
795322 | 795322 | 2020-12-04 | Lee | Mississippi | 28081 | 5577 | 98 |
792077 | 792077 | 2020-12-03 | Lee | Mississippi | 28081 | 5476 | 97 |
788832 | 788832 | 2020-12-02 | Lee | Mississippi | 28081 | 5403 | 96 |
785587 | 785587 | 2020-12-01 | Lee | Mississippi | 28081 | 5294 | 96 |
782343 | 782343 | 2020-11-30 | Lee | Mississippi | 28081 | 5236 | 95 |
779097 | 779097 | 2020-11-29 | Lee | Mississippi | 28081 | 5170 | 95 |
775852 | 775852 | 2020-11-28 | Lee | Mississippi | 28081 | 5091 | 95 |
772607 | 772607 | 2020-11-27 | Lee | Mississippi | 28081 | 5010 | 95 |
769362 | 769362 | 2020-11-26 | Lee | Mississippi | 28081 | 4984 | 95 |
766116 | 766116 | 2020-11-25 | Lee | Mississippi | 28081 | 4876 | 95 |
762871 | 762871 | 2020-11-24 | Lee | Mississippi | 28081 | 4842 | 95 |
759626 | 759626 | 2020-11-23 | Lee | Mississippi | 28081 | 4802 | 94 |
756379 | 756379 | 2020-11-22 | Lee | Mississippi | 28081 | 4770 | 94 |
753133 | 753133 | 2020-11-21 | Lee | Mississippi | 28081 | 4740 | 92 |
749887 | 749887 | 2020-11-20 | Lee | Mississippi | 28081 | 4672 | 91 |
746641 | 746641 | 2020-11-19 | Lee | Mississippi | 28081 | 4622 | 91 |
743394 | 743394 | 2020-11-18 | Lee | Mississippi | 28081 | 4579 | 90 |
740147 | 740147 | 2020-11-17 | Lee | Mississippi | 28081 | 4491 | 90 |
736903 | 736903 | 2020-11-16 | Lee | Mississippi | 28081 | 4439 | 89 |
733657 | 733657 | 2020-11-15 | Lee | Mississippi | 28081 | 4411 | 89 |
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);