ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
428 rows where deaths = 5 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Quitman 31
- Hancock 27
- Covington 25
- Lamar 21
- Calhoun 17
- DeSoto 14
- George 14
- Alcorn 13
- Lee 12
- Choctaw 11
- Franklin 11
- Grenada 11
- Harrison 11
- Jackson 11
- Holmes 10
- Union 10
- Humphreys 8
- Jefferson Davis 8
- Marshall 8
- Rankin 8
- Yalobusha 8
- Unknown 7
- Bolivar 5
- Lawrence 5
- Marion 5
- Panola 5
- Sharkey 5
- Tishomingo 5
- Attala 4
- Claiborne 4
- …
state 1
- Mississippi · 428 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475003 | 2475003 | 2022-05-05 | Unknown | Mississippi | 545 | 5 | |
2422907 | 2422907 | 2022-04-19 | Unknown | Mississippi | 50 | 5 | |
2377329 | 2377329 | 2022-04-05 | Unknown | Mississippi | 134 | 5 | |
908899 | 908899 | 2021-01-08 | Issaquena | Mississippi | 28055 | 154 | 5 |
905653 | 905653 | 2021-01-07 | Issaquena | Mississippi | 28055 | 153 | 5 |
902408 | 902408 | 2021-01-06 | Issaquena | Mississippi | 28055 | 152 | 5 |
899163 | 899163 | 2021-01-05 | Issaquena | Mississippi | 28055 | 152 | 5 |
788810 | 788810 | 2020-12-02 | Franklin | Mississippi | 28037 | 363 | 5 |
785565 | 785565 | 2020-12-01 | Franklin | Mississippi | 28037 | 355 | 5 |
782321 | 782321 | 2020-11-30 | Franklin | Mississippi | 28037 | 353 | 5 |
779075 | 779075 | 2020-11-29 | Franklin | Mississippi | 28037 | 348 | 5 |
775830 | 775830 | 2020-11-28 | Franklin | Mississippi | 28037 | 339 | 5 |
772585 | 772585 | 2020-11-27 | Franklin | Mississippi | 28037 | 336 | 5 |
769340 | 769340 | 2020-11-26 | Franklin | Mississippi | 28037 | 334 | 5 |
766094 | 766094 | 2020-11-25 | Franklin | Mississippi | 28037 | 326 | 5 |
762849 | 762849 | 2020-11-24 | Franklin | Mississippi | 28037 | 323 | 5 |
759604 | 759604 | 2020-11-23 | Franklin | Mississippi | 28037 | 318 | 5 |
756357 | 756357 | 2020-11-22 | Franklin | Mississippi | 28037 | 315 | 5 |
659022 | 659022 | 2020-10-23 | Benton | Mississippi | 28009 | 333 | 5 |
655777 | 655777 | 2020-10-22 | Benton | Mississippi | 28009 | 325 | 5 |
607171 | 607171 | 2020-10-07 | Quitman | Mississippi | 28119 | 402 | 5 |
603928 | 603928 | 2020-10-06 | Quitman | Mississippi | 28119 | 402 | 5 |
600686 | 600686 | 2020-10-05 | Quitman | Mississippi | 28119 | 399 | 5 |
597443 | 597443 | 2020-10-04 | Quitman | Mississippi | 28119 | 398 | 5 |
594202 | 594202 | 2020-10-03 | Quitman | Mississippi | 28119 | 398 | 5 |
590961 | 590961 | 2020-10-02 | Quitman | Mississippi | 28119 | 395 | 5 |
587720 | 587720 | 2020-10-01 | Quitman | Mississippi | 28119 | 393 | 5 |
584480 | 584480 | 2020-09-30 | Quitman | Mississippi | 28119 | 390 | 5 |
581239 | 581239 | 2020-09-29 | Quitman | Mississippi | 28119 | 387 | 5 |
577998 | 577998 | 2020-09-28 | Quitman | Mississippi | 28119 | 380 | 5 |
574757 | 574757 | 2020-09-27 | Quitman | Mississippi | 28119 | 377 | 5 |
571514 | 571514 | 2020-09-26 | Quitman | Mississippi | 28119 | 377 | 5 |
568272 | 568272 | 2020-09-25 | Quitman | Mississippi | 28119 | 373 | 5 |
565032 | 565032 | 2020-09-24 | Quitman | Mississippi | 28119 | 372 | 5 |
561792 | 561792 | 2020-09-23 | Quitman | Mississippi | 28119 | 373 | 5 |
558555 | 558555 | 2020-09-22 | Quitman | Mississippi | 28119 | 375 | 5 |
555268 | 555268 | 2020-09-21 | Choctaw | Mississippi | 28019 | 179 | 5 |
555318 | 555318 | 2020-09-21 | Quitman | Mississippi | 28119 | 375 | 5 |
552030 | 552030 | 2020-09-20 | Choctaw | Mississippi | 28019 | 179 | 5 |
552080 | 552080 | 2020-09-20 | Quitman | Mississippi | 28119 | 374 | 5 |
548791 | 548791 | 2020-09-19 | Choctaw | Mississippi | 28019 | 178 | 5 |
548841 | 548841 | 2020-09-19 | Quitman | Mississippi | 28119 | 373 | 5 |
545553 | 545553 | 2020-09-18 | Choctaw | Mississippi | 28019 | 177 | 5 |
545603 | 545603 | 2020-09-18 | Quitman | Mississippi | 28119 | 372 | 5 |
542316 | 542316 | 2020-09-17 | Choctaw | Mississippi | 28019 | 177 | 5 |
542366 | 542366 | 2020-09-17 | Quitman | Mississippi | 28119 | 362 | 5 |
539080 | 539080 | 2020-09-16 | Choctaw | Mississippi | 28019 | 177 | 5 |
539130 | 539130 | 2020-09-16 | Quitman | Mississippi | 28119 | 359 | 5 |
535843 | 535843 | 2020-09-15 | Choctaw | Mississippi | 28019 | 176 | 5 |
535893 | 535893 | 2020-09-15 | Quitman | Mississippi | 28119 | 356 | 5 |
532608 | 532608 | 2020-09-14 | Choctaw | Mississippi | 28019 | 174 | 5 |
532658 | 532658 | 2020-09-14 | Quitman | Mississippi | 28119 | 354 | 5 |
529372 | 529372 | 2020-09-13 | Choctaw | Mississippi | 28019 | 174 | 5 |
529422 | 529422 | 2020-09-13 | Quitman | Mississippi | 28119 | 354 | 5 |
526136 | 526136 | 2020-09-12 | Choctaw | Mississippi | 28019 | 173 | 5 |
526186 | 526186 | 2020-09-12 | Quitman | Mississippi | 28119 | 354 | 5 |
522900 | 522900 | 2020-09-11 | Choctaw | Mississippi | 28019 | 168 | 5 |
522950 | 522950 | 2020-09-11 | Quitman | Mississippi | 28119 | 354 | 5 |
519713 | 519713 | 2020-09-10 | Quitman | Mississippi | 28119 | 352 | 5 |
516478 | 516478 | 2020-09-09 | Quitman | Mississippi | 28119 | 352 | 5 |
513244 | 513244 | 2020-09-08 | Quitman | Mississippi | 28119 | 351 | 5 |
510012 | 510012 | 2020-09-07 | Quitman | Mississippi | 28119 | 351 | 5 |
442101 | 442101 | 2020-08-17 | Alcorn | Mississippi | 28003 | 457 | 5 |
438874 | 438874 | 2020-08-16 | Alcorn | Mississippi | 28003 | 457 | 5 |
435649 | 435649 | 2020-08-15 | Alcorn | Mississippi | 28003 | 451 | 5 |
432423 | 432423 | 2020-08-14 | Alcorn | Mississippi | 28003 | 447 | 5 |
429196 | 429196 | 2020-08-13 | Alcorn | Mississippi | 28003 | 445 | 5 |
425972 | 425972 | 2020-08-12 | Alcorn | Mississippi | 28003 | 439 | 5 |
426033 | 426033 | 2020-08-12 | Sharkey | Mississippi | 28125 | 206 | 5 |
426036 | 426036 | 2020-08-12 | Stone | Mississippi | 28131 | 224 | 5 |
422750 | 422750 | 2020-08-11 | Alcorn | Mississippi | 28003 | 435 | 5 |
422797 | 422797 | 2020-08-11 | Montgomery | Mississippi | 28097 | 329 | 5 |
422811 | 422811 | 2020-08-11 | Sharkey | Mississippi | 28125 | 204 | 5 |
422814 | 422814 | 2020-08-11 | Stone | Mississippi | 28131 | 211 | 5 |
419528 | 419528 | 2020-08-10 | Alcorn | Mississippi | 28003 | 434 | 5 |
419546 | 419546 | 2020-08-10 | George | Mississippi | 28039 | 589 | 5 |
419575 | 419575 | 2020-08-10 | Montgomery | Mississippi | 28097 | 326 | 5 |
419589 | 419589 | 2020-08-10 | Sharkey | Mississippi | 28125 | 199 | 5 |
419592 | 419592 | 2020-08-10 | Stone | Mississippi | 28131 | 205 | 5 |
416307 | 416307 | 2020-08-09 | Alcorn | Mississippi | 28003 | 428 | 5 |
416325 | 416325 | 2020-08-09 | George | Mississippi | 28039 | 581 | 5 |
416354 | 416354 | 2020-08-09 | Montgomery | Mississippi | 28097 | 326 | 5 |
416368 | 416368 | 2020-08-09 | Sharkey | Mississippi | 28125 | 197 | 5 |
416371 | 416371 | 2020-08-09 | Stone | Mississippi | 28131 | 199 | 5 |
416376 | 416376 | 2020-08-09 | Tishomingo | Mississippi | 28141 | 417 | 5 |
413087 | 413087 | 2020-08-08 | Alcorn | Mississippi | 28003 | 419 | 5 |
413105 | 413105 | 2020-08-08 | George | Mississippi | 28039 | 559 | 5 |
413148 | 413148 | 2020-08-08 | Sharkey | Mississippi | 28125 | 197 | 5 |
413156 | 413156 | 2020-08-08 | Tishomingo | Mississippi | 28141 | 409 | 5 |
409867 | 409867 | 2020-08-07 | Alcorn | Mississippi | 28003 | 397 | 5 |
409936 | 409936 | 2020-08-07 | Tishomingo | Mississippi | 28141 | 363 | 5 |
406647 | 406647 | 2020-08-06 | Alcorn | Mississippi | 28003 | 382 | 5 |
406716 | 406716 | 2020-08-06 | Tishomingo | Mississippi | 28141 | 350 | 5 |
403429 | 403429 | 2020-08-05 | Alcorn | Mississippi | 28003 | 377 | 5 |
403498 | 403498 | 2020-08-05 | Tishomingo | Mississippi | 28141 | 344 | 5 |
400230 | 400230 | 2020-08-04 | George | Mississippi | 28039 | 549 | 5 |
400249 | 400249 | 2020-08-04 | Lawrence | Mississippi | 28077 | 315 | 5 |
396999 | 396999 | 2020-08-03 | Amite | Mississippi | 28005 | 210 | 5 |
397016 | 397016 | 2020-08-03 | George | Mississippi | 28039 | 547 | 5 |
397035 | 397035 | 2020-08-03 | Lawrence | Mississippi | 28077 | 313 | 5 |
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);