ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279018 | 1279018 | 2021-05-02 | Rankin | Mississippi | 28121 | 13520 | 278 |
1275771 | 1275771 | 2021-05-01 | Rankin | Mississippi | 28121 | 13520 | 278 |
1272524 | 1272524 | 2021-04-30 | Rankin | Mississippi | 28121 | 13520 | 278 |
1269277 | 1269277 | 2021-04-29 | Rankin | Mississippi | 28121 | 13507 | 278 |
1266030 | 1266030 | 2021-04-28 | Rankin | Mississippi | 28121 | 13494 | 278 |
1262783 | 1262783 | 2021-04-27 | Rankin | Mississippi | 28121 | 13476 | 278 |
1259536 | 1259536 | 2021-04-26 | Rankin | Mississippi | 28121 | 13466 | 277 |
1256289 | 1256289 | 2021-04-25 | Rankin | Mississippi | 28121 | 13447 | 277 |
1253042 | 1253042 | 2021-04-24 | Rankin | Mississippi | 28121 | 13447 | 277 |
1249795 | 1249795 | 2021-04-23 | Rankin | Mississippi | 28121 | 13447 | 277 |
1246548 | 1246548 | 2021-04-22 | Rankin | Mississippi | 28121 | 13442 | 277 |
1243301 | 1243301 | 2021-04-21 | Rankin | Mississippi | 28121 | 13423 | 277 |
1240054 | 1240054 | 2021-04-20 | Rankin | Mississippi | 28121 | 13394 | 277 |
1236807 | 1236807 | 2021-04-19 | Rankin | Mississippi | 28121 | 13388 | 277 |
1233560 | 1233560 | 2021-04-18 | Rankin | Mississippi | 28121 | 13388 | 277 |
1230312 | 1230312 | 2021-04-17 | Rankin | Mississippi | 28121 | 13378 | 277 |
1227064 | 1227064 | 2021-04-16 | Rankin | Mississippi | 28121 | 13369 | 277 |
1223816 | 1223816 | 2021-04-15 | Rankin | Mississippi | 28121 | 13358 | 276 |
1220569 | 1220569 | 2021-04-14 | Rankin | Mississippi | 28121 | 13344 | 276 |
1217321 | 1217321 | 2021-04-13 | Rankin | Mississippi | 28121 | 13334 | 276 |
1214074 | 1214074 | 2021-04-12 | Rankin | Mississippi | 28121 | 13316 | 275 |
1210826 | 1210826 | 2021-04-11 | Rankin | Mississippi | 28121 | 13311 | 275 |
1207577 | 1207577 | 2021-04-10 | Rankin | Mississippi | 28121 | 13307 | 275 |
1204329 | 1204329 | 2021-04-09 | Rankin | Mississippi | 28121 | 13297 | 275 |
1201081 | 1201081 | 2021-04-08 | Rankin | Mississippi | 28121 | 13293 | 275 |
1197832 | 1197832 | 2021-04-07 | Rankin | Mississippi | 28121 | 13279 | 275 |
1194583 | 1194583 | 2021-04-06 | Rankin | Mississippi | 28121 | 13270 | 275 |
1191334 | 1191334 | 2021-04-05 | Rankin | Mississippi | 28121 | 13260 | 274 |
1188086 | 1188086 | 2021-04-04 | Rankin | Mississippi | 28121 | 13259 | 274 |
1184839 | 1184839 | 2021-04-03 | Rankin | Mississippi | 28121 | 13253 | 274 |
1181593 | 1181593 | 2021-04-02 | Rankin | Mississippi | 28121 | 13238 | 274 |
1178346 | 1178346 | 2021-04-01 | Rankin | Mississippi | 28121 | 13229 | 274 |
1175099 | 1175099 | 2021-03-31 | Rankin | Mississippi | 28121 | 13220 | 274 |
1171852 | 1171852 | 2021-03-30 | Rankin | Mississippi | 28121 | 13212 | 273 |
1168604 | 1168604 | 2021-03-29 | Rankin | Mississippi | 28121 | 13209 | 272 |
1165356 | 1165356 | 2021-03-28 | Rankin | Mississippi | 28121 | 13209 | 272 |
1162108 | 1162108 | 2021-03-27 | Rankin | Mississippi | 28121 | 13198 | 272 |
1158860 | 1158860 | 2021-03-26 | Rankin | Mississippi | 28121 | 13179 | 272 |
1155613 | 1155613 | 2021-03-25 | Rankin | Mississippi | 28121 | 13170 | 271 |
1152366 | 1152366 | 2021-03-24 | Rankin | Mississippi | 28121 | 13141 | 271 |
1149119 | 1149119 | 2021-03-23 | Rankin | Mississippi | 28121 | 13133 | 271 |
1145872 | 1145872 | 2021-03-22 | Rankin | Mississippi | 28121 | 13115 | 271 |
1142625 | 1142625 | 2021-03-21 | Rankin | Mississippi | 28121 | 13112 | 271 |
1139378 | 1139378 | 2021-03-20 | Rankin | Mississippi | 28121 | 13104 | 271 |
1136132 | 1136132 | 2021-03-19 | Rankin | Mississippi | 28121 | 13092 | 271 |
1132886 | 1132886 | 2021-03-18 | Rankin | Mississippi | 28121 | 13085 | 271 |
1129638 | 1129638 | 2021-03-17 | Rankin | Mississippi | 28121 | 13079 | 271 |
1126391 | 1126391 | 2021-03-16 | Rankin | Mississippi | 28121 | 13060 | 271 |
1123145 | 1123145 | 2021-03-15 | Rankin | Mississippi | 28121 | 13051 | 269 |
1119898 | 1119898 | 2021-03-14 | Rankin | Mississippi | 28121 | 13047 | 269 |
1116651 | 1116651 | 2021-03-13 | Rankin | Mississippi | 28121 | 13034 | 269 |
1113405 | 1113405 | 2021-03-12 | Rankin | Mississippi | 28121 | 12993 | 267 |
1110159 | 1110159 | 2021-03-11 | Rankin | Mississippi | 28121 | 12930 | 267 |
1106913 | 1106913 | 2021-03-10 | Rankin | Mississippi | 28121 | 12877 | 266 |
1103667 | 1103667 | 2021-03-09 | Rankin | Mississippi | 28121 | 12864 | 266 |
1100421 | 1100421 | 2021-03-08 | Rankin | Mississippi | 28121 | 12853 | 265 |
1097174 | 1097174 | 2021-03-07 | Rankin | Mississippi | 28121 | 12851 | 265 |
1093927 | 1093927 | 2021-03-06 | Rankin | Mississippi | 28121 | 12842 | 265 |
1090681 | 1090681 | 2021-03-05 | Rankin | Mississippi | 28121 | 12823 | 265 |
1087436 | 1087436 | 2021-03-04 | Rankin | Mississippi | 28121 | 12787 | 265 |
1084191 | 1084191 | 2021-03-03 | Rankin | Mississippi | 28121 | 12757 | 265 |
1080945 | 1080945 | 2021-03-02 | Rankin | Mississippi | 28121 | 12725 | 265 |
1077699 | 1077699 | 2021-03-01 | Rankin | Mississippi | 28121 | 12685 | 264 |
1074453 | 1074453 | 2021-02-28 | Rankin | Mississippi | 28121 | 12675 | 264 |
1071207 | 1071207 | 2021-02-27 | Rankin | Mississippi | 28121 | 12662 | 264 |
1067962 | 1067962 | 2021-02-26 | Rankin | Mississippi | 28121 | 12637 | 263 |
1064717 | 1064717 | 2021-02-25 | Rankin | Mississippi | 28121 | 12595 | 262 |
1061473 | 1061473 | 2021-02-24 | Rankin | Mississippi | 28121 | 12543 | 261 |
1058227 | 1058227 | 2021-02-23 | Rankin | Mississippi | 28121 | 12498 | 260 |
1054981 | 1054981 | 2021-02-22 | Rankin | Mississippi | 28121 | 12490 | 258 |
1051734 | 1051734 | 2021-02-21 | Rankin | Mississippi | 28121 | 12483 | 258 |
1048487 | 1048487 | 2021-02-20 | Rankin | Mississippi | 28121 | 12478 | 258 |
1045241 | 1045241 | 2021-02-19 | Rankin | Mississippi | 28121 | 12476 | 258 |
1041996 | 1041996 | 2021-02-18 | Rankin | Mississippi | 28121 | 12468 | 257 |
1038751 | 1038751 | 2021-02-17 | Rankin | Mississippi | 28121 | 12467 | 257 |
1035506 | 1035506 | 2021-02-16 | Rankin | Mississippi | 28121 | 12450 | 254 |
1032261 | 1032261 | 2021-02-15 | Rankin | Mississippi | 28121 | 12413 | 253 |
1029014 | 1029014 | 2021-02-14 | Rankin | Mississippi | 28121 | 12384 | 253 |
1025768 | 1025768 | 2021-02-13 | Rankin | Mississippi | 28121 | 12313 | 253 |
1022523 | 1022523 | 2021-02-12 | Rankin | Mississippi | 28121 | 12272 | 252 |
1019278 | 1019278 | 2021-02-11 | Rankin | Mississippi | 28121 | 12244 | 249 |
1016033 | 1016033 | 2021-02-10 | Rankin | Mississippi | 28121 | 12215 | 248 |
1012788 | 1012788 | 2021-02-09 | Rankin | Mississippi | 28121 | 12176 | 246 |
1009543 | 1009543 | 2021-02-08 | Rankin | Mississippi | 28121 | 12146 | 243 |
1006296 | 1006296 | 2021-02-07 | Rankin | Mississippi | 28121 | 12109 | 243 |
1003050 | 1003050 | 2021-02-06 | Rankin | Mississippi | 28121 | 12040 | 243 |
999805 | 999805 | 2021-02-05 | Rankin | Mississippi | 28121 | 11964 | 243 |
996559 | 996559 | 2021-02-04 | Rankin | Mississippi | 28121 | 11890 | 242 |
993313 | 993313 | 2021-02-03 | Rankin | Mississippi | 28121 | 11796 | 240 |
990067 | 990067 | 2021-02-02 | Rankin | Mississippi | 28121 | 11761 | 237 |
986820 | 986820 | 2021-02-01 | Rankin | Mississippi | 28121 | 11734 | 235 |
983573 | 983573 | 2021-01-31 | Rankin | Mississippi | 28121 | 11693 | 232 |
980327 | 980327 | 2021-01-30 | Rankin | Mississippi | 28121 | 11670 | 231 |
977081 | 977081 | 2021-01-29 | Rankin | Mississippi | 28121 | 11568 | 228 |
973836 | 973836 | 2021-01-28 | Rankin | Mississippi | 28121 | 11478 | 227 |
970591 | 970591 | 2021-01-27 | Rankin | Mississippi | 28121 | 11404 | 225 |
967346 | 967346 | 2021-01-26 | Rankin | Mississippi | 28121 | 11315 | 223 |
964102 | 964102 | 2021-01-25 | Rankin | Mississippi | 28121 | 11280 | 221 |
960857 | 960857 | 2021-01-24 | Rankin | Mississippi | 28121 | 11239 | 220 |
957611 | 957611 | 2021-01-23 | Rankin | Mississippi | 28121 | 11167 | 219 |
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);