ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28089 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054965 | 1054965 | 2021-02-22 | Madison | Mississippi | 28089 | 9343 | 190 |
1051718 | 1051718 | 2021-02-21 | Madison | Mississippi | 28089 | 9340 | 190 |
1048471 | 1048471 | 2021-02-20 | Madison | Mississippi | 28089 | 9336 | 190 |
1045225 | 1045225 | 2021-02-19 | Madison | Mississippi | 28089 | 9333 | 189 |
1041980 | 1041980 | 2021-02-18 | Madison | Mississippi | 28089 | 9327 | 189 |
1038735 | 1038735 | 2021-02-17 | Madison | Mississippi | 28089 | 9324 | 189 |
1035490 | 1035490 | 2021-02-16 | Madison | Mississippi | 28089 | 9318 | 189 |
1032245 | 1032245 | 2021-02-15 | Madison | Mississippi | 28089 | 9307 | 189 |
1028998 | 1028998 | 2021-02-14 | Madison | Mississippi | 28089 | 9295 | 189 |
1025752 | 1025752 | 2021-02-13 | Madison | Mississippi | 28089 | 9262 | 189 |
1022507 | 1022507 | 2021-02-12 | Madison | Mississippi | 28089 | 9242 | 189 |
1019262 | 1019262 | 2021-02-11 | Madison | Mississippi | 28089 | 9227 | 189 |
1016017 | 1016017 | 2021-02-10 | Madison | Mississippi | 28089 | 9204 | 188 |
1012772 | 1012772 | 2021-02-09 | Madison | Mississippi | 28089 | 9180 | 188 |
1009527 | 1009527 | 2021-02-08 | Madison | Mississippi | 28089 | 9162 | 186 |
1006280 | 1006280 | 2021-02-07 | Madison | Mississippi | 28089 | 9147 | 186 |
1003034 | 1003034 | 2021-02-06 | Madison | Mississippi | 28089 | 9112 | 186 |
999789 | 999789 | 2021-02-05 | Madison | Mississippi | 28089 | 9075 | 185 |
996543 | 996543 | 2021-02-04 | Madison | Mississippi | 28089 | 9042 | 183 |
993297 | 993297 | 2021-02-03 | Madison | Mississippi | 28089 | 9009 | 182 |
990051 | 990051 | 2021-02-02 | Madison | Mississippi | 28089 | 8988 | 178 |
986804 | 986804 | 2021-02-01 | Madison | Mississippi | 28089 | 8941 | 176 |
983557 | 983557 | 2021-01-31 | Madison | Mississippi | 28089 | 8922 | 176 |
980311 | 980311 | 2021-01-30 | Madison | Mississippi | 28089 | 8893 | 175 |
977065 | 977065 | 2021-01-29 | Madison | Mississippi | 28089 | 8856 | 173 |
973820 | 973820 | 2021-01-28 | Madison | Mississippi | 28089 | 8785 | 173 |
970575 | 970575 | 2021-01-27 | Madison | Mississippi | 28089 | 8736 | 173 |
967330 | 967330 | 2021-01-26 | Madison | Mississippi | 28089 | 8663 | 171 |
964086 | 964086 | 2021-01-25 | Madison | Mississippi | 28089 | 8619 | 169 |
960841 | 960841 | 2021-01-24 | Madison | Mississippi | 28089 | 8599 | 169 |
957595 | 957595 | 2021-01-23 | Madison | Mississippi | 28089 | 8568 | 168 |
954350 | 954350 | 2021-01-22 | Madison | Mississippi | 28089 | 8495 | 168 |
951105 | 951105 | 2021-01-21 | Madison | Mississippi | 28089 | 8413 | 168 |
947859 | 947859 | 2021-01-20 | Madison | Mississippi | 28089 | 8335 | 166 |
944612 | 944612 | 2021-01-19 | Madison | Mississippi | 28089 | 8314 | 164 |
941367 | 941367 | 2021-01-18 | Madison | Mississippi | 28089 | 8262 | 162 |
938122 | 938122 | 2021-01-17 | Madison | Mississippi | 28089 | 8232 | 162 |
934877 | 934877 | 2021-01-16 | Madison | Mississippi | 28089 | 8186 | 161 |
931632 | 931632 | 2021-01-15 | Madison | Mississippi | 28089 | 8071 | 160 |
928387 | 928387 | 2021-01-14 | Madison | Mississippi | 28089 | 7994 | 158 |
925141 | 925141 | 2021-01-13 | Madison | Mississippi | 28089 | 7937 | 156 |
921896 | 921896 | 2021-01-12 | Madison | Mississippi | 28089 | 7893 | 153 |
918651 | 918651 | 2021-01-11 | Madison | Mississippi | 28089 | 7868 | 152 |
915406 | 915406 | 2021-01-10 | Madison | Mississippi | 28089 | 7853 | 152 |
912161 | 912161 | 2021-01-09 | Madison | Mississippi | 28089 | 7796 | 151 |
908916 | 908916 | 2021-01-08 | Madison | Mississippi | 28089 | 7723 | 149 |
905670 | 905670 | 2021-01-07 | Madison | Mississippi | 28089 | 7651 | 147 |
902425 | 902425 | 2021-01-06 | Madison | Mississippi | 28089 | 7551 | 146 |
899180 | 899180 | 2021-01-05 | Madison | Mississippi | 28089 | 7447 | 145 |
895935 | 895935 | 2021-01-04 | Madison | Mississippi | 28089 | 7418 | 139 |
892688 | 892688 | 2021-01-03 | Madison | Mississippi | 28089 | 7372 | 138 |
889442 | 889442 | 2021-01-02 | Madison | Mississippi | 28089 | 7342 | 137 |
886196 | 886196 | 2021-01-01 | Madison | Mississippi | 28089 | 7294 | 136 |
882951 | 882951 | 2020-12-31 | Madison | Mississippi | 28089 | 7194 | 136 |
879706 | 879706 | 2020-12-30 | Madison | Mississippi | 28089 | 7079 | 132 |
876461 | 876461 | 2020-12-29 | Madison | Mississippi | 28089 | 6961 | 131 |
873216 | 873216 | 2020-12-28 | Madison | Mississippi | 28089 | 6905 | 129 |
869971 | 869971 | 2020-12-27 | Madison | Mississippi | 28089 | 6859 | 129 |
866726 | 866726 | 2020-12-26 | Madison | Mississippi | 28089 | 6815 | 128 |
863481 | 863481 | 2020-12-25 | Madison | Mississippi | 28089 | 6783 | 128 |
860236 | 860236 | 2020-12-24 | Madison | Mississippi | 28089 | 6733 | 128 |
856991 | 856991 | 2020-12-23 | Madison | Mississippi | 28089 | 6665 | 127 |
853746 | 853746 | 2020-12-22 | Madison | Mississippi | 28089 | 6568 | 127 |
850501 | 850501 | 2020-12-21 | Madison | Mississippi | 28089 | 6517 | 126 |
847256 | 847256 | 2020-12-20 | Madison | Mississippi | 28089 | 6482 | 126 |
844010 | 844010 | 2020-12-19 | Madison | Mississippi | 28089 | 6379 | 126 |
840765 | 840765 | 2020-12-18 | Madison | Mississippi | 28089 | 6327 | 126 |
837520 | 837520 | 2020-12-17 | Madison | Mississippi | 28089 | 6196 | 125 |
834274 | 834274 | 2020-12-16 | Madison | Mississippi | 28089 | 6114 | 123 |
831027 | 831027 | 2020-12-15 | Madison | Mississippi | 28089 | 5997 | 122 |
827781 | 827781 | 2020-12-14 | Madison | Mississippi | 28089 | 5927 | 122 |
824534 | 824534 | 2020-12-13 | Madison | Mississippi | 28089 | 5889 | 122 |
821288 | 821288 | 2020-12-12 | Madison | Mississippi | 28089 | 5836 | 121 |
818042 | 818042 | 2020-12-11 | Madison | Mississippi | 28089 | 5726 | 121 |
814796 | 814796 | 2020-12-10 | Madison | Mississippi | 28089 | 5639 | 119 |
811551 | 811551 | 2020-12-09 | Madison | Mississippi | 28089 | 5532 | 118 |
808306 | 808306 | 2020-12-08 | Madison | Mississippi | 28089 | 5478 | 114 |
805061 | 805061 | 2020-12-07 | Madison | Mississippi | 28089 | 5433 | 113 |
801816 | 801816 | 2020-12-06 | Madison | Mississippi | 28089 | 5408 | 113 |
798571 | 798571 | 2020-12-05 | Madison | Mississippi | 28089 | 5368 | 113 |
795326 | 795326 | 2020-12-04 | Madison | Mississippi | 28089 | 5311 | 112 |
792081 | 792081 | 2020-12-03 | Madison | Mississippi | 28089 | 5202 | 110 |
788836 | 788836 | 2020-12-02 | Madison | Mississippi | 28089 | 5120 | 107 |
785591 | 785591 | 2020-12-01 | Madison | Mississippi | 28089 | 5014 | 107 |
782347 | 782347 | 2020-11-30 | Madison | Mississippi | 28089 | 4964 | 107 |
779101 | 779101 | 2020-11-29 | Madison | Mississippi | 28089 | 4902 | 107 |
775856 | 775856 | 2020-11-28 | Madison | Mississippi | 28089 | 4799 | 106 |
772611 | 772611 | 2020-11-27 | Madison | Mississippi | 28089 | 4734 | 106 |
769366 | 769366 | 2020-11-26 | Madison | Mississippi | 28089 | 4711 | 106 |
766120 | 766120 | 2020-11-25 | Madison | Mississippi | 28089 | 4666 | 106 |
762875 | 762875 | 2020-11-24 | Madison | Mississippi | 28089 | 4633 | 105 |
759630 | 759630 | 2020-11-23 | Madison | Mississippi | 28089 | 4602 | 102 |
756383 | 756383 | 2020-11-22 | Madison | Mississippi | 28089 | 4595 | 102 |
753137 | 753137 | 2020-11-21 | Madison | Mississippi | 28089 | 4573 | 102 |
749891 | 749891 | 2020-11-20 | Madison | Mississippi | 28089 | 4498 | 101 |
746645 | 746645 | 2020-11-19 | Madison | Mississippi | 28089 | 4462 | 99 |
743398 | 743398 | 2020-11-18 | Madison | Mississippi | 28089 | 4402 | 99 |
740151 | 740151 | 2020-11-17 | Madison | Mississippi | 28089 | 4339 | 98 |
736907 | 736907 | 2020-11-16 | Madison | Mississippi | 28089 | 4311 | 97 |
733661 | 733661 | 2020-11-15 | Madison | Mississippi | 28089 | 4300 | 97 |
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);