ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Leflore" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278999 | 1278999 | 2021-05-02 | Leflore | Mississippi | 28083 | 3484 | 125 |
1275752 | 1275752 | 2021-05-01 | Leflore | Mississippi | 28083 | 3484 | 125 |
1272505 | 1272505 | 2021-04-30 | Leflore | Mississippi | 28083 | 3484 | 125 |
1269258 | 1269258 | 2021-04-29 | Leflore | Mississippi | 28083 | 3483 | 125 |
1266011 | 1266011 | 2021-04-28 | Leflore | Mississippi | 28083 | 3483 | 124 |
1262764 | 1262764 | 2021-04-27 | Leflore | Mississippi | 28083 | 3483 | 124 |
1259517 | 1259517 | 2021-04-26 | Leflore | Mississippi | 28083 | 3482 | 124 |
1256270 | 1256270 | 2021-04-25 | Leflore | Mississippi | 28083 | 3480 | 124 |
1253023 | 1253023 | 2021-04-24 | Leflore | Mississippi | 28083 | 3480 | 124 |
1249776 | 1249776 | 2021-04-23 | Leflore | Mississippi | 28083 | 3480 | 124 |
1246529 | 1246529 | 2021-04-22 | Leflore | Mississippi | 28083 | 3481 | 124 |
1243282 | 1243282 | 2021-04-21 | Leflore | Mississippi | 28083 | 3476 | 124 |
1240035 | 1240035 | 2021-04-20 | Leflore | Mississippi | 28083 | 3476 | 124 |
1236788 | 1236788 | 2021-04-19 | Leflore | Mississippi | 28083 | 3471 | 124 |
1233541 | 1233541 | 2021-04-18 | Leflore | Mississippi | 28083 | 3472 | 124 |
1230293 | 1230293 | 2021-04-17 | Leflore | Mississippi | 28083 | 3471 | 124 |
1227045 | 1227045 | 2021-04-16 | Leflore | Mississippi | 28083 | 3471 | 124 |
1223797 | 1223797 | 2021-04-15 | Leflore | Mississippi | 28083 | 3470 | 124 |
1220550 | 1220550 | 2021-04-14 | Leflore | Mississippi | 28083 | 3469 | 124 |
1217302 | 1217302 | 2021-04-13 | Leflore | Mississippi | 28083 | 3468 | 124 |
1214055 | 1214055 | 2021-04-12 | Leflore | Mississippi | 28083 | 3468 | 124 |
1210807 | 1210807 | 2021-04-11 | Leflore | Mississippi | 28083 | 3468 | 124 |
1207558 | 1207558 | 2021-04-10 | Leflore | Mississippi | 28083 | 3468 | 124 |
1204310 | 1204310 | 2021-04-09 | Leflore | Mississippi | 28083 | 3468 | 124 |
1201062 | 1201062 | 2021-04-08 | Leflore | Mississippi | 28083 | 3467 | 124 |
1197813 | 1197813 | 2021-04-07 | Leflore | Mississippi | 28083 | 3467 | 124 |
1194564 | 1194564 | 2021-04-06 | Leflore | Mississippi | 28083 | 3466 | 124 |
1191315 | 1191315 | 2021-04-05 | Leflore | Mississippi | 28083 | 3465 | 124 |
1188067 | 1188067 | 2021-04-04 | Leflore | Mississippi | 28083 | 3464 | 124 |
1184820 | 1184820 | 2021-04-03 | Leflore | Mississippi | 28083 | 3464 | 124 |
1181574 | 1181574 | 2021-04-02 | Leflore | Mississippi | 28083 | 3463 | 124 |
1178327 | 1178327 | 2021-04-01 | Leflore | Mississippi | 28083 | 3461 | 124 |
1175080 | 1175080 | 2021-03-31 | Leflore | Mississippi | 28083 | 3460 | 124 |
1171833 | 1171833 | 2021-03-30 | Leflore | Mississippi | 28083 | 3459 | 123 |
1168585 | 1168585 | 2021-03-29 | Leflore | Mississippi | 28083 | 3459 | 123 |
1165337 | 1165337 | 2021-03-28 | Leflore | Mississippi | 28083 | 3459 | 123 |
1162089 | 1162089 | 2021-03-27 | Leflore | Mississippi | 28083 | 3457 | 123 |
1158841 | 1158841 | 2021-03-26 | Leflore | Mississippi | 28083 | 3456 | 123 |
1155594 | 1155594 | 2021-03-25 | Leflore | Mississippi | 28083 | 3453 | 123 |
1152347 | 1152347 | 2021-03-24 | Leflore | Mississippi | 28083 | 3450 | 123 |
1149100 | 1149100 | 2021-03-23 | Leflore | Mississippi | 28083 | 3447 | 123 |
1145853 | 1145853 | 2021-03-22 | Leflore | Mississippi | 28083 | 3445 | 123 |
1142606 | 1142606 | 2021-03-21 | Leflore | Mississippi | 28083 | 3443 | 123 |
1139359 | 1139359 | 2021-03-20 | Leflore | Mississippi | 28083 | 3439 | 123 |
1136113 | 1136113 | 2021-03-19 | Leflore | Mississippi | 28083 | 3430 | 123 |
1132867 | 1132867 | 2021-03-18 | Leflore | Mississippi | 28083 | 3426 | 123 |
1129619 | 1129619 | 2021-03-17 | Leflore | Mississippi | 28083 | 3423 | 123 |
1126372 | 1126372 | 2021-03-16 | Leflore | Mississippi | 28083 | 3421 | 123 |
1123126 | 1123126 | 2021-03-15 | Leflore | Mississippi | 28083 | 3419 | 123 |
1119879 | 1119879 | 2021-03-14 | Leflore | Mississippi | 28083 | 3419 | 123 |
1116632 | 1116632 | 2021-03-13 | Leflore | Mississippi | 28083 | 3419 | 123 |
1113386 | 1113386 | 2021-03-12 | Leflore | Mississippi | 28083 | 3417 | 123 |
1110140 | 1110140 | 2021-03-11 | Leflore | Mississippi | 28083 | 3417 | 123 |
1106894 | 1106894 | 2021-03-10 | Leflore | Mississippi | 28083 | 3414 | 123 |
1103648 | 1103648 | 2021-03-09 | Leflore | Mississippi | 28083 | 3413 | 123 |
1100402 | 1100402 | 2021-03-08 | Leflore | Mississippi | 28083 | 3404 | 122 |
1097155 | 1097155 | 2021-03-07 | Leflore | Mississippi | 28083 | 3402 | 122 |
1093908 | 1093908 | 2021-03-06 | Leflore | Mississippi | 28083 | 3400 | 121 |
1090662 | 1090662 | 2021-03-05 | Leflore | Mississippi | 28083 | 3394 | 120 |
1087417 | 1087417 | 2021-03-04 | Leflore | Mississippi | 28083 | 3389 | 119 |
1084172 | 1084172 | 2021-03-03 | Leflore | Mississippi | 28083 | 3380 | 118 |
1080926 | 1080926 | 2021-03-02 | Leflore | Mississippi | 28083 | 3376 | 118 |
1077680 | 1077680 | 2021-03-01 | Leflore | Mississippi | 28083 | 3375 | 118 |
1074434 | 1074434 | 2021-02-28 | Leflore | Mississippi | 28083 | 3374 | 118 |
1071188 | 1071188 | 2021-02-27 | Leflore | Mississippi | 28083 | 3367 | 118 |
1067943 | 1067943 | 2021-02-26 | Leflore | Mississippi | 28083 | 3363 | 118 |
1064698 | 1064698 | 2021-02-25 | Leflore | Mississippi | 28083 | 3358 | 118 |
1061454 | 1061454 | 2021-02-24 | Leflore | Mississippi | 28083 | 3349 | 118 |
1058208 | 1058208 | 2021-02-23 | Leflore | Mississippi | 28083 | 3346 | 118 |
1054962 | 1054962 | 2021-02-22 | Leflore | Mississippi | 28083 | 3341 | 117 |
1051715 | 1051715 | 2021-02-21 | Leflore | Mississippi | 28083 | 3336 | 117 |
1048468 | 1048468 | 2021-02-20 | Leflore | Mississippi | 28083 | 3333 | 117 |
1045222 | 1045222 | 2021-02-19 | Leflore | Mississippi | 28083 | 3330 | 117 |
1041977 | 1041977 | 2021-02-18 | Leflore | Mississippi | 28083 | 3329 | 117 |
1038732 | 1038732 | 2021-02-17 | Leflore | Mississippi | 28083 | 3328 | 117 |
1035487 | 1035487 | 2021-02-16 | Leflore | Mississippi | 28083 | 3320 | 117 |
1032242 | 1032242 | 2021-02-15 | Leflore | Mississippi | 28083 | 3314 | 117 |
1028995 | 1028995 | 2021-02-14 | Leflore | Mississippi | 28083 | 3311 | 117 |
1025749 | 1025749 | 2021-02-13 | Leflore | Mississippi | 28083 | 3299 | 117 |
1022504 | 1022504 | 2021-02-12 | Leflore | Mississippi | 28083 | 3290 | 116 |
1019259 | 1019259 | 2021-02-11 | Leflore | Mississippi | 28083 | 3284 | 116 |
1016014 | 1016014 | 2021-02-10 | Leflore | Mississippi | 28083 | 3274 | 116 |
1012769 | 1012769 | 2021-02-09 | Leflore | Mississippi | 28083 | 3271 | 116 |
1009524 | 1009524 | 2021-02-08 | Leflore | Mississippi | 28083 | 3261 | 115 |
1006277 | 1006277 | 2021-02-07 | Leflore | Mississippi | 28083 | 3258 | 115 |
1003031 | 1003031 | 2021-02-06 | Leflore | Mississippi | 28083 | 3254 | 115 |
999786 | 999786 | 2021-02-05 | Leflore | Mississippi | 28083 | 3246 | 114 |
996540 | 996540 | 2021-02-04 | Leflore | Mississippi | 28083 | 3224 | 114 |
993294 | 993294 | 2021-02-03 | Leflore | Mississippi | 28083 | 3220 | 114 |
990048 | 990048 | 2021-02-02 | Leflore | Mississippi | 28083 | 3217 | 114 |
986801 | 986801 | 2021-02-01 | Leflore | Mississippi | 28083 | 3210 | 114 |
983554 | 983554 | 2021-01-31 | Leflore | Mississippi | 28083 | 3204 | 114 |
980308 | 980308 | 2021-01-30 | Leflore | Mississippi | 28083 | 3193 | 114 |
977062 | 977062 | 2021-01-29 | Leflore | Mississippi | 28083 | 3188 | 114 |
973817 | 973817 | 2021-01-28 | Leflore | Mississippi | 28083 | 3172 | 110 |
970572 | 970572 | 2021-01-27 | Leflore | Mississippi | 28083 | 3148 | 110 |
967327 | 967327 | 2021-01-26 | Leflore | Mississippi | 28083 | 3132 | 110 |
964083 | 964083 | 2021-01-25 | Leflore | Mississippi | 28083 | 3122 | 109 |
960838 | 960838 | 2021-01-24 | Leflore | Mississippi | 28083 | 3118 | 109 |
957592 | 957592 | 2021-01-23 | Leflore | Mississippi | 28083 | 3111 | 109 |
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);