ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Forrest" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054938 | 1054938 | 2021-02-22 | Forrest | Mississippi | 28035 | 7048 | 135 |
1051691 | 1051691 | 2021-02-21 | Forrest | Mississippi | 28035 | 7040 | 135 |
1048444 | 1048444 | 2021-02-20 | Forrest | Mississippi | 28035 | 6989 | 135 |
1045198 | 1045198 | 2021-02-19 | Forrest | Mississippi | 28035 | 6971 | 135 |
1041953 | 1041953 | 2021-02-18 | Forrest | Mississippi | 28035 | 6938 | 135 |
1038708 | 1038708 | 2021-02-17 | Forrest | Mississippi | 28035 | 6926 | 135 |
1035463 | 1035463 | 2021-02-16 | Forrest | Mississippi | 28035 | 6907 | 135 |
1032218 | 1032218 | 2021-02-15 | Forrest | Mississippi | 28035 | 6870 | 135 |
1028971 | 1028971 | 2021-02-14 | Forrest | Mississippi | 28035 | 6846 | 134 |
1025725 | 1025725 | 2021-02-13 | Forrest | Mississippi | 28035 | 6820 | 134 |
1022480 | 1022480 | 2021-02-12 | Forrest | Mississippi | 28035 | 6798 | 134 |
1019235 | 1019235 | 2021-02-11 | Forrest | Mississippi | 28035 | 6763 | 134 |
1015990 | 1015990 | 2021-02-10 | Forrest | Mississippi | 28035 | 6746 | 134 |
1012745 | 1012745 | 2021-02-09 | Forrest | Mississippi | 28035 | 6722 | 134 |
1009500 | 1009500 | 2021-02-08 | Forrest | Mississippi | 28035 | 6701 | 134 |
1006253 | 1006253 | 2021-02-07 | Forrest | Mississippi | 28035 | 6683 | 134 |
1003007 | 1003007 | 2021-02-06 | Forrest | Mississippi | 28035 | 6664 | 134 |
999762 | 999762 | 2021-02-05 | Forrest | Mississippi | 28035 | 6625 | 132 |
996516 | 996516 | 2021-02-04 | Forrest | Mississippi | 28035 | 6582 | 131 |
993270 | 993270 | 2021-02-03 | Forrest | Mississippi | 28035 | 6542 | 130 |
990024 | 990024 | 2021-02-02 | Forrest | Mississippi | 28035 | 6516 | 130 |
986777 | 986777 | 2021-02-01 | Forrest | Mississippi | 28035 | 6494 | 129 |
983530 | 983530 | 2021-01-31 | Forrest | Mississippi | 28035 | 6476 | 127 |
980284 | 980284 | 2021-01-30 | Forrest | Mississippi | 28035 | 6449 | 127 |
977038 | 977038 | 2021-01-29 | Forrest | Mississippi | 28035 | 6396 | 127 |
973793 | 973793 | 2021-01-28 | Forrest | Mississippi | 28035 | 6361 | 127 |
970548 | 970548 | 2021-01-27 | Forrest | Mississippi | 28035 | 6324 | 126 |
967303 | 967303 | 2021-01-26 | Forrest | Mississippi | 28035 | 6260 | 125 |
964059 | 964059 | 2021-01-25 | Forrest | Mississippi | 28035 | 6236 | 124 |
960814 | 960814 | 2021-01-24 | Forrest | Mississippi | 28035 | 6208 | 124 |
957568 | 957568 | 2021-01-23 | Forrest | Mississippi | 28035 | 6177 | 124 |
954323 | 954323 | 2021-01-22 | Forrest | Mississippi | 28035 | 6135 | 122 |
951078 | 951078 | 2021-01-21 | Forrest | Mississippi | 28035 | 6101 | 121 |
947832 | 947832 | 2021-01-20 | Forrest | Mississippi | 28035 | 6038 | 120 |
944585 | 944585 | 2021-01-19 | Forrest | Mississippi | 28035 | 6009 | 120 |
941340 | 941340 | 2021-01-18 | Forrest | Mississippi | 28035 | 5992 | 119 |
938095 | 938095 | 2021-01-17 | Forrest | Mississippi | 28035 | 5949 | 119 |
934850 | 934850 | 2021-01-16 | Forrest | Mississippi | 28035 | 5917 | 118 |
931605 | 931605 | 2021-01-15 | Forrest | Mississippi | 28035 | 5870 | 117 |
928360 | 928360 | 2021-01-14 | Forrest | Mississippi | 28035 | 5826 | 117 |
925114 | 925114 | 2021-01-13 | Forrest | Mississippi | 28035 | 5786 | 113 |
921869 | 921869 | 2021-01-12 | Forrest | Mississippi | 28035 | 5755 | 112 |
918624 | 918624 | 2021-01-11 | Forrest | Mississippi | 28035 | 5733 | 111 |
915379 | 915379 | 2021-01-10 | Forrest | Mississippi | 28035 | 5705 | 110 |
912134 | 912134 | 2021-01-09 | Forrest | Mississippi | 28035 | 5667 | 110 |
908889 | 908889 | 2021-01-08 | Forrest | Mississippi | 28035 | 5620 | 108 |
905643 | 905643 | 2021-01-07 | Forrest | Mississippi | 28035 | 5581 | 108 |
902398 | 902398 | 2021-01-06 | Forrest | Mississippi | 28035 | 5513 | 106 |
899153 | 899153 | 2021-01-05 | Forrest | Mississippi | 28035 | 5439 | 105 |
895908 | 895908 | 2021-01-04 | Forrest | Mississippi | 28035 | 5410 | 104 |
892661 | 892661 | 2021-01-03 | Forrest | Mississippi | 28035 | 5375 | 104 |
889415 | 889415 | 2021-01-02 | Forrest | Mississippi | 28035 | 5341 | 104 |
886169 | 886169 | 2021-01-01 | Forrest | Mississippi | 28035 | 5292 | 102 |
882924 | 882924 | 2020-12-31 | Forrest | Mississippi | 28035 | 5232 | 101 |
879679 | 879679 | 2020-12-30 | Forrest | Mississippi | 28035 | 5174 | 98 |
876434 | 876434 | 2020-12-29 | Forrest | Mississippi | 28035 | 5107 | 97 |
873189 | 873189 | 2020-12-28 | Forrest | Mississippi | 28035 | 5076 | 96 |
869944 | 869944 | 2020-12-27 | Forrest | Mississippi | 28035 | 5041 | 95 |
866699 | 866699 | 2020-12-26 | Forrest | Mississippi | 28035 | 5026 | 95 |
863454 | 863454 | 2020-12-25 | Forrest | Mississippi | 28035 | 5013 | 94 |
860209 | 860209 | 2020-12-24 | Forrest | Mississippi | 28035 | 4966 | 94 |
856964 | 856964 | 2020-12-23 | Forrest | Mississippi | 28035 | 4923 | 94 |
853719 | 853719 | 2020-12-22 | Forrest | Mississippi | 28035 | 4869 | 94 |
850474 | 850474 | 2020-12-21 | Forrest | Mississippi | 28035 | 4819 | 93 |
847229 | 847229 | 2020-12-20 | Forrest | Mississippi | 28035 | 4792 | 93 |
843983 | 843983 | 2020-12-19 | Forrest | Mississippi | 28035 | 4735 | 93 |
840738 | 840738 | 2020-12-18 | Forrest | Mississippi | 28035 | 4712 | 93 |
837493 | 837493 | 2020-12-17 | Forrest | Mississippi | 28035 | 4642 | 93 |
834247 | 834247 | 2020-12-16 | Forrest | Mississippi | 28035 | 4581 | 93 |
831000 | 831000 | 2020-12-15 | Forrest | Mississippi | 28035 | 4538 | 93 |
827754 | 827754 | 2020-12-14 | Forrest | Mississippi | 28035 | 4503 | 92 |
824507 | 824507 | 2020-12-13 | Forrest | Mississippi | 28035 | 4466 | 92 |
821261 | 821261 | 2020-12-12 | Forrest | Mississippi | 28035 | 4413 | 92 |
818015 | 818015 | 2020-12-11 | Forrest | Mississippi | 28035 | 4369 | 91 |
814769 | 814769 | 2020-12-10 | Forrest | Mississippi | 28035 | 4319 | 90 |
811524 | 811524 | 2020-12-09 | Forrest | Mississippi | 28035 | 4257 | 90 |
808279 | 808279 | 2020-12-08 | Forrest | Mississippi | 28035 | 4203 | 90 |
805034 | 805034 | 2020-12-07 | Forrest | Mississippi | 28035 | 4166 | 90 |
801789 | 801789 | 2020-12-06 | Forrest | Mississippi | 28035 | 4139 | 90 |
798544 | 798544 | 2020-12-05 | Forrest | Mississippi | 28035 | 4107 | 89 |
795299 | 795299 | 2020-12-04 | Forrest | Mississippi | 28035 | 4055 | 87 |
792054 | 792054 | 2020-12-03 | Forrest | Mississippi | 28035 | 4001 | 87 |
788809 | 788809 | 2020-12-02 | Forrest | Mississippi | 28035 | 3947 | 86 |
785564 | 785564 | 2020-12-01 | Forrest | Mississippi | 28035 | 3897 | 86 |
782320 | 782320 | 2020-11-30 | Forrest | Mississippi | 28035 | 3882 | 86 |
779074 | 779074 | 2020-11-29 | Forrest | Mississippi | 28035 | 3859 | 86 |
775829 | 775829 | 2020-11-28 | Forrest | Mississippi | 28035 | 3831 | 86 |
772584 | 772584 | 2020-11-27 | Forrest | Mississippi | 28035 | 3805 | 86 |
769339 | 769339 | 2020-11-26 | Forrest | Mississippi | 28035 | 3750 | 86 |
766093 | 766093 | 2020-11-25 | Forrest | Mississippi | 28035 | 3713 | 86 |
762848 | 762848 | 2020-11-24 | Forrest | Mississippi | 28035 | 3681 | 86 |
759603 | 759603 | 2020-11-23 | Forrest | Mississippi | 28035 | 3671 | 85 |
756356 | 756356 | 2020-11-22 | Forrest | Mississippi | 28035 | 3606 | 85 |
753110 | 753110 | 2020-11-21 | Forrest | Mississippi | 28035 | 3591 | 85 |
749864 | 749864 | 2020-11-20 | Forrest | Mississippi | 28035 | 3548 | 85 |
746618 | 746618 | 2020-11-19 | Forrest | Mississippi | 28035 | 3517 | 85 |
743371 | 743371 | 2020-11-18 | Forrest | Mississippi | 28035 | 3490 | 85 |
740124 | 740124 | 2020-11-17 | Forrest | Mississippi | 28035 | 3460 | 85 |
736880 | 736880 | 2020-11-16 | Forrest | Mississippi | 28035 | 3448 | 83 |
733634 | 733634 | 2020-11-15 | Forrest | Mississippi | 28035 | 3426 | 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);