ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 28047 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278981 | 1278981 | 2021-05-02 | Harrison | Mississippi | 28047 | 17735 | 306 |
1275734 | 1275734 | 2021-05-01 | Harrison | Mississippi | 28047 | 17735 | 306 |
1272487 | 1272487 | 2021-04-30 | Harrison | Mississippi | 28047 | 17735 | 306 |
1269240 | 1269240 | 2021-04-29 | Harrison | Mississippi | 28047 | 17719 | 306 |
1265993 | 1265993 | 2021-04-28 | Harrison | Mississippi | 28047 | 17710 | 306 |
1262746 | 1262746 | 2021-04-27 | Harrison | Mississippi | 28047 | 17682 | 306 |
1259499 | 1259499 | 2021-04-26 | Harrison | Mississippi | 28047 | 17675 | 306 |
1256252 | 1256252 | 2021-04-25 | Harrison | Mississippi | 28047 | 17647 | 306 |
1253005 | 1253005 | 2021-04-24 | Harrison | Mississippi | 28047 | 17647 | 306 |
1249758 | 1249758 | 2021-04-23 | Harrison | Mississippi | 28047 | 17647 | 306 |
1246511 | 1246511 | 2021-04-22 | Harrison | Mississippi | 28047 | 17626 | 306 |
1243264 | 1243264 | 2021-04-21 | Harrison | Mississippi | 28047 | 17612 | 304 |
1240017 | 1240017 | 2021-04-20 | Harrison | Mississippi | 28047 | 17609 | 304 |
1236770 | 1236770 | 2021-04-19 | Harrison | Mississippi | 28047 | 17590 | 303 |
1233523 | 1233523 | 2021-04-18 | Harrison | Mississippi | 28047 | 17596 | 303 |
1230275 | 1230275 | 2021-04-17 | Harrison | Mississippi | 28047 | 17575 | 303 |
1227027 | 1227027 | 2021-04-16 | Harrison | Mississippi | 28047 | 17562 | 303 |
1223779 | 1223779 | 2021-04-15 | Harrison | Mississippi | 28047 | 17551 | 302 |
1220532 | 1220532 | 2021-04-14 | Harrison | Mississippi | 28047 | 17530 | 302 |
1217284 | 1217284 | 2021-04-13 | Harrison | Mississippi | 28047 | 17510 | 302 |
1214037 | 1214037 | 2021-04-12 | Harrison | Mississippi | 28047 | 17493 | 302 |
1210789 | 1210789 | 2021-04-11 | Harrison | Mississippi | 28047 | 17489 | 302 |
1207540 | 1207540 | 2021-04-10 | Harrison | Mississippi | 28047 | 17475 | 302 |
1204292 | 1204292 | 2021-04-09 | Harrison | Mississippi | 28047 | 17465 | 302 |
1201044 | 1201044 | 2021-04-08 | Harrison | Mississippi | 28047 | 17459 | 302 |
1197795 | 1197795 | 2021-04-07 | Harrison | Mississippi | 28047 | 17441 | 300 |
1194546 | 1194546 | 2021-04-06 | Harrison | Mississippi | 28047 | 17433 | 300 |
1191297 | 1191297 | 2021-04-05 | Harrison | Mississippi | 28047 | 17418 | 299 |
1188049 | 1188049 | 2021-04-04 | Harrison | Mississippi | 28047 | 17417 | 299 |
1184802 | 1184802 | 2021-04-03 | Harrison | Mississippi | 28047 | 17415 | 299 |
1181556 | 1181556 | 2021-04-02 | Harrison | Mississippi | 28047 | 17397 | 299 |
1178309 | 1178309 | 2021-04-01 | Harrison | Mississippi | 28047 | 17382 | 299 |
1175062 | 1175062 | 2021-03-31 | Harrison | Mississippi | 28047 | 17356 | 299 |
1171815 | 1171815 | 2021-03-30 | Harrison | Mississippi | 28047 | 17335 | 299 |
1168567 | 1168567 | 2021-03-29 | Harrison | Mississippi | 28047 | 17320 | 298 |
1165319 | 1165319 | 2021-03-28 | Harrison | Mississippi | 28047 | 17315 | 298 |
1162071 | 1162071 | 2021-03-27 | Harrison | Mississippi | 28047 | 17307 | 298 |
1158823 | 1158823 | 2021-03-26 | Harrison | Mississippi | 28047 | 17293 | 298 |
1155576 | 1155576 | 2021-03-25 | Harrison | Mississippi | 28047 | 17283 | 298 |
1152329 | 1152329 | 2021-03-24 | Harrison | Mississippi | 28047 | 17263 | 298 |
1149082 | 1149082 | 2021-03-23 | Harrison | Mississippi | 28047 | 17245 | 298 |
1145835 | 1145835 | 2021-03-22 | Harrison | Mississippi | 28047 | 17229 | 298 |
1142588 | 1142588 | 2021-03-21 | Harrison | Mississippi | 28047 | 17221 | 298 |
1139341 | 1139341 | 2021-03-20 | Harrison | Mississippi | 28047 | 17216 | 298 |
1136095 | 1136095 | 2021-03-19 | Harrison | Mississippi | 28047 | 17194 | 297 |
1132849 | 1132849 | 2021-03-18 | Harrison | Mississippi | 28047 | 17177 | 296 |
1129601 | 1129601 | 2021-03-17 | Harrison | Mississippi | 28047 | 17157 | 296 |
1126354 | 1126354 | 2021-03-16 | Harrison | Mississippi | 28047 | 17132 | 296 |
1123108 | 1123108 | 2021-03-15 | Harrison | Mississippi | 28047 | 17117 | 292 |
1119861 | 1119861 | 2021-03-14 | Harrison | Mississippi | 28047 | 17106 | 292 |
1116614 | 1116614 | 2021-03-13 | Harrison | Mississippi | 28047 | 17098 | 292 |
1113368 | 1113368 | 2021-03-12 | Harrison | Mississippi | 28047 | 17043 | 292 |
1110122 | 1110122 | 2021-03-11 | Harrison | Mississippi | 28047 | 17008 | 291 |
1106876 | 1106876 | 2021-03-10 | Harrison | Mississippi | 28047 | 16962 | 290 |
1103630 | 1103630 | 2021-03-09 | Harrison | Mississippi | 28047 | 16943 | 288 |
1100384 | 1100384 | 2021-03-08 | Harrison | Mississippi | 28047 | 16904 | 283 |
1097137 | 1097137 | 2021-03-07 | Harrison | Mississippi | 28047 | 16899 | 283 |
1093890 | 1093890 | 2021-03-06 | Harrison | Mississippi | 28047 | 16886 | 282 |
1090644 | 1090644 | 2021-03-05 | Harrison | Mississippi | 28047 | 16850 | 282 |
1087399 | 1087399 | 2021-03-04 | Harrison | Mississippi | 28047 | 16780 | 282 |
1084154 | 1084154 | 2021-03-03 | Harrison | Mississippi | 28047 | 16736 | 281 |
1080908 | 1080908 | 2021-03-02 | Harrison | Mississippi | 28047 | 16722 | 280 |
1077662 | 1077662 | 2021-03-01 | Harrison | Mississippi | 28047 | 16710 | 278 |
1074416 | 1074416 | 2021-02-28 | Harrison | Mississippi | 28047 | 16679 | 278 |
1071170 | 1071170 | 2021-02-27 | Harrison | Mississippi | 28047 | 16618 | 278 |
1067925 | 1067925 | 2021-02-26 | Harrison | Mississippi | 28047 | 16569 | 277 |
1064680 | 1064680 | 2021-02-25 | Harrison | Mississippi | 28047 | 16512 | 276 |
1061436 | 1061436 | 2021-02-24 | Harrison | Mississippi | 28047 | 16431 | 275 |
1058190 | 1058190 | 2021-02-23 | Harrison | Mississippi | 28047 | 16385 | 273 |
1054944 | 1054944 | 2021-02-22 | Harrison | Mississippi | 28047 | 16363 | 269 |
1051697 | 1051697 | 2021-02-21 | Harrison | Mississippi | 28047 | 16347 | 269 |
1048450 | 1048450 | 2021-02-20 | Harrison | Mississippi | 28047 | 16315 | 269 |
1045204 | 1045204 | 2021-02-19 | Harrison | Mississippi | 28047 | 16291 | 267 |
1041959 | 1041959 | 2021-02-18 | Harrison | Mississippi | 28047 | 16241 | 266 |
1038714 | 1038714 | 2021-02-17 | Harrison | Mississippi | 28047 | 16232 | 266 |
1035469 | 1035469 | 2021-02-16 | Harrison | Mississippi | 28047 | 16162 | 264 |
1032224 | 1032224 | 2021-02-15 | Harrison | Mississippi | 28047 | 16117 | 258 |
1028977 | 1028977 | 2021-02-14 | Harrison | Mississippi | 28047 | 16082 | 258 |
1025731 | 1025731 | 2021-02-13 | Harrison | Mississippi | 28047 | 16024 | 258 |
1022486 | 1022486 | 2021-02-12 | Harrison | Mississippi | 28047 | 15984 | 256 |
1019241 | 1019241 | 2021-02-11 | Harrison | Mississippi | 28047 | 15904 | 256 |
1015996 | 1015996 | 2021-02-10 | Harrison | Mississippi | 28047 | 15846 | 253 |
1012751 | 1012751 | 2021-02-09 | Harrison | Mississippi | 28047 | 15783 | 251 |
1009506 | 1009506 | 2021-02-08 | Harrison | Mississippi | 28047 | 15747 | 244 |
1006259 | 1006259 | 2021-02-07 | Harrison | Mississippi | 28047 | 15702 | 244 |
1003013 | 1003013 | 2021-02-06 | Harrison | Mississippi | 28047 | 15620 | 243 |
999768 | 999768 | 2021-02-05 | Harrison | Mississippi | 28047 | 15582 | 239 |
996522 | 996522 | 2021-02-04 | Harrison | Mississippi | 28047 | 15510 | 236 |
993276 | 993276 | 2021-02-03 | Harrison | Mississippi | 28047 | 15412 | 234 |
990030 | 990030 | 2021-02-02 | Harrison | Mississippi | 28047 | 15376 | 234 |
986783 | 986783 | 2021-02-01 | Harrison | Mississippi | 28047 | 15292 | 223 |
983536 | 983536 | 2021-01-31 | Harrison | Mississippi | 28047 | 15236 | 223 |
980290 | 980290 | 2021-01-30 | Harrison | Mississippi | 28047 | 15180 | 220 |
977044 | 977044 | 2021-01-29 | Harrison | Mississippi | 28047 | 15045 | 216 |
973799 | 973799 | 2021-01-28 | Harrison | Mississippi | 28047 | 14829 | 215 |
970554 | 970554 | 2021-01-27 | Harrison | Mississippi | 28047 | 14654 | 214 |
967309 | 967309 | 2021-01-26 | Harrison | Mississippi | 28047 | 14510 | 212 |
964065 | 964065 | 2021-01-25 | Harrison | Mississippi | 28047 | 14298 | 204 |
960820 | 960820 | 2021-01-24 | Harrison | Mississippi | 28047 | 14279 | 204 |
957574 | 957574 | 2021-01-23 | Harrison | Mississippi | 28047 | 14224 | 204 |
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);