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 |
---|---|---|---|---|---|---|---|
1278975 | 1278975 | 2021-05-02 | Forrest | Mississippi | 28035 | 7620 | 149 |
1275728 | 1275728 | 2021-05-01 | Forrest | Mississippi | 28035 | 7620 | 149 |
1272481 | 1272481 | 2021-04-30 | Forrest | Mississippi | 28035 | 7620 | 149 |
1269234 | 1269234 | 2021-04-29 | Forrest | Mississippi | 28035 | 7617 | 149 |
1265987 | 1265987 | 2021-04-28 | Forrest | Mississippi | 28035 | 7614 | 149 |
1262740 | 1262740 | 2021-04-27 | Forrest | Mississippi | 28035 | 7609 | 149 |
1259493 | 1259493 | 2021-04-26 | Forrest | Mississippi | 28035 | 7607 | 149 |
1256246 | 1256246 | 2021-04-25 | Forrest | Mississippi | 28035 | 7595 | 149 |
1252999 | 1252999 | 2021-04-24 | Forrest | Mississippi | 28035 | 7595 | 149 |
1249752 | 1249752 | 2021-04-23 | Forrest | Mississippi | 28035 | 7595 | 149 |
1246505 | 1246505 | 2021-04-22 | Forrest | Mississippi | 28035 | 7585 | 149 |
1243258 | 1243258 | 2021-04-21 | Forrest | Mississippi | 28035 | 7573 | 149 |
1240011 | 1240011 | 2021-04-20 | Forrest | Mississippi | 28035 | 7562 | 149 |
1236764 | 1236764 | 2021-04-19 | Forrest | Mississippi | 28035 | 7554 | 149 |
1233517 | 1233517 | 2021-04-18 | Forrest | Mississippi | 28035 | 7551 | 149 |
1230269 | 1230269 | 2021-04-17 | Forrest | Mississippi | 28035 | 7551 | 149 |
1227021 | 1227021 | 2021-04-16 | Forrest | Mississippi | 28035 | 7542 | 148 |
1223773 | 1223773 | 2021-04-15 | Forrest | Mississippi | 28035 | 7537 | 147 |
1220526 | 1220526 | 2021-04-14 | Forrest | Mississippi | 28035 | 7529 | 147 |
1217278 | 1217278 | 2021-04-13 | Forrest | Mississippi | 28035 | 7525 | 147 |
1214031 | 1214031 | 2021-04-12 | Forrest | Mississippi | 28035 | 7523 | 146 |
1210783 | 1210783 | 2021-04-11 | Forrest | Mississippi | 28035 | 7523 | 146 |
1207534 | 1207534 | 2021-04-10 | Forrest | Mississippi | 28035 | 7522 | 146 |
1204286 | 1204286 | 2021-04-09 | Forrest | Mississippi | 28035 | 7511 | 146 |
1201038 | 1201038 | 2021-04-08 | Forrest | Mississippi | 28035 | 7507 | 146 |
1197789 | 1197789 | 2021-04-07 | Forrest | Mississippi | 28035 | 7506 | 146 |
1194540 | 1194540 | 2021-04-06 | Forrest | Mississippi | 28035 | 7506 | 146 |
1191291 | 1191291 | 2021-04-05 | Forrest | Mississippi | 28035 | 7502 | 145 |
1188043 | 1188043 | 2021-04-04 | Forrest | Mississippi | 28035 | 7501 | 145 |
1184796 | 1184796 | 2021-04-03 | Forrest | Mississippi | 28035 | 7500 | 145 |
1181550 | 1181550 | 2021-04-02 | Forrest | Mississippi | 28035 | 7493 | 145 |
1178303 | 1178303 | 2021-04-01 | Forrest | Mississippi | 28035 | 7489 | 145 |
1175056 | 1175056 | 2021-03-31 | Forrest | Mississippi | 28035 | 7479 | 144 |
1171809 | 1171809 | 2021-03-30 | Forrest | Mississippi | 28035 | 7475 | 144 |
1168561 | 1168561 | 2021-03-29 | Forrest | Mississippi | 28035 | 7470 | 143 |
1165313 | 1165313 | 2021-03-28 | Forrest | Mississippi | 28035 | 7468 | 143 |
1162065 | 1162065 | 2021-03-27 | Forrest | Mississippi | 28035 | 7467 | 143 |
1158817 | 1158817 | 2021-03-26 | Forrest | Mississippi | 28035 | 7460 | 143 |
1155570 | 1155570 | 2021-03-25 | Forrest | Mississippi | 28035 | 7456 | 143 |
1152323 | 1152323 | 2021-03-24 | Forrest | Mississippi | 28035 | 7452 | 143 |
1149076 | 1149076 | 2021-03-23 | Forrest | Mississippi | 28035 | 7441 | 143 |
1145829 | 1145829 | 2021-03-22 | Forrest | Mississippi | 28035 | 7462 | 142 |
1142582 | 1142582 | 2021-03-21 | Forrest | Mississippi | 28035 | 7460 | 142 |
1139335 | 1139335 | 2021-03-20 | Forrest | Mississippi | 28035 | 7454 | 142 |
1136089 | 1136089 | 2021-03-19 | Forrest | Mississippi | 28035 | 7450 | 142 |
1132843 | 1132843 | 2021-03-18 | Forrest | Mississippi | 28035 | 7422 | 142 |
1129595 | 1129595 | 2021-03-17 | Forrest | Mississippi | 28035 | 7415 | 142 |
1126348 | 1126348 | 2021-03-16 | Forrest | Mississippi | 28035 | 7408 | 142 |
1123102 | 1123102 | 2021-03-15 | Forrest | Mississippi | 28035 | 7388 | 141 |
1119855 | 1119855 | 2021-03-14 | Forrest | Mississippi | 28035 | 7386 | 140 |
1116608 | 1116608 | 2021-03-13 | Forrest | Mississippi | 28035 | 7380 | 140 |
1113362 | 1113362 | 2021-03-12 | Forrest | Mississippi | 28035 | 7353 | 140 |
1110116 | 1110116 | 2021-03-11 | Forrest | Mississippi | 28035 | 7336 | 139 |
1106870 | 1106870 | 2021-03-10 | Forrest | Mississippi | 28035 | 7320 | 139 |
1103624 | 1103624 | 2021-03-09 | Forrest | Mississippi | 28035 | 7309 | 138 |
1100378 | 1100378 | 2021-03-08 | Forrest | Mississippi | 28035 | 7300 | 138 |
1097131 | 1097131 | 2021-03-07 | Forrest | Mississippi | 28035 | 7295 | 138 |
1093884 | 1093884 | 2021-03-06 | Forrest | Mississippi | 28035 | 7289 | 138 |
1090638 | 1090638 | 2021-03-05 | Forrest | Mississippi | 28035 | 7272 | 138 |
1087393 | 1087393 | 2021-03-04 | Forrest | Mississippi | 28035 | 7250 | 138 |
1084148 | 1084148 | 2021-03-03 | Forrest | Mississippi | 28035 | 7234 | 138 |
1080902 | 1080902 | 2021-03-02 | Forrest | Mississippi | 28035 | 7217 | 138 |
1077656 | 1077656 | 2021-03-01 | Forrest | Mississippi | 28035 | 7208 | 136 |
1074410 | 1074410 | 2021-02-28 | Forrest | Mississippi | 28035 | 7204 | 136 |
1071164 | 1071164 | 2021-02-27 | Forrest | Mississippi | 28035 | 7184 | 136 |
1067919 | 1067919 | 2021-02-26 | Forrest | Mississippi | 28035 | 7159 | 136 |
1064674 | 1064674 | 2021-02-25 | Forrest | Mississippi | 28035 | 7140 | 136 |
1061430 | 1061430 | 2021-02-24 | Forrest | Mississippi | 28035 | 7094 | 136 |
1058184 | 1058184 | 2021-02-23 | Forrest | Mississippi | 28035 | 7055 | 135 |
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 |
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);