ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28053 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921878 | 921878 | 2021-01-12 | Humphreys | Mississippi | 28053 | 794 | 24 |
918633 | 918633 | 2021-01-11 | Humphreys | Mississippi | 28053 | 788 | 22 |
915388 | 915388 | 2021-01-10 | Humphreys | Mississippi | 28053 | 786 | 22 |
912143 | 912143 | 2021-01-09 | Humphreys | Mississippi | 28053 | 784 | 22 |
908898 | 908898 | 2021-01-08 | Humphreys | Mississippi | 28053 | 773 | 22 |
905652 | 905652 | 2021-01-07 | Humphreys | Mississippi | 28053 | 770 | 22 |
902407 | 902407 | 2021-01-06 | Humphreys | Mississippi | 28053 | 763 | 22 |
899162 | 899162 | 2021-01-05 | Humphreys | Mississippi | 28053 | 752 | 22 |
895917 | 895917 | 2021-01-04 | Humphreys | Mississippi | 28053 | 749 | 22 |
892670 | 892670 | 2021-01-03 | Humphreys | Mississippi | 28053 | 742 | 22 |
889424 | 889424 | 2021-01-02 | Humphreys | Mississippi | 28053 | 739 | 22 |
886178 | 886178 | 2021-01-01 | Humphreys | Mississippi | 28053 | 739 | 22 |
882933 | 882933 | 2020-12-31 | Humphreys | Mississippi | 28053 | 726 | 22 |
879688 | 879688 | 2020-12-30 | Humphreys | Mississippi | 28053 | 712 | 22 |
876443 | 876443 | 2020-12-29 | Humphreys | Mississippi | 28053 | 707 | 22 |
873198 | 873198 | 2020-12-28 | Humphreys | Mississippi | 28053 | 705 | 22 |
869953 | 869953 | 2020-12-27 | Humphreys | Mississippi | 28053 | 704 | 22 |
866708 | 866708 | 2020-12-26 | Humphreys | Mississippi | 28053 | 702 | 22 |
863463 | 863463 | 2020-12-25 | Humphreys | Mississippi | 28053 | 702 | 22 |
860218 | 860218 | 2020-12-24 | Humphreys | Mississippi | 28053 | 697 | 22 |
856973 | 856973 | 2020-12-23 | Humphreys | Mississippi | 28053 | 688 | 22 |
853728 | 853728 | 2020-12-22 | Humphreys | Mississippi | 28053 | 680 | 22 |
850483 | 850483 | 2020-12-21 | Humphreys | Mississippi | 28053 | 675 | 22 |
847238 | 847238 | 2020-12-20 | Humphreys | Mississippi | 28053 | 669 | 22 |
843992 | 843992 | 2020-12-19 | Humphreys | Mississippi | 28053 | 664 | 22 |
840747 | 840747 | 2020-12-18 | Humphreys | Mississippi | 28053 | 657 | 21 |
837502 | 837502 | 2020-12-17 | Humphreys | Mississippi | 28053 | 651 | 21 |
834256 | 834256 | 2020-12-16 | Humphreys | Mississippi | 28053 | 648 | 21 |
831009 | 831009 | 2020-12-15 | Humphreys | Mississippi | 28053 | 641 | 21 |
827763 | 827763 | 2020-12-14 | Humphreys | Mississippi | 28053 | 632 | 21 |
824516 | 824516 | 2020-12-13 | Humphreys | Mississippi | 28053 | 626 | 21 |
821270 | 821270 | 2020-12-12 | Humphreys | Mississippi | 28053 | 616 | 21 |
818024 | 818024 | 2020-12-11 | Humphreys | Mississippi | 28053 | 610 | 21 |
814778 | 814778 | 2020-12-10 | Humphreys | Mississippi | 28053 | 597 | 21 |
811533 | 811533 | 2020-12-09 | Humphreys | Mississippi | 28053 | 596 | 21 |
808288 | 808288 | 2020-12-08 | Humphreys | Mississippi | 28053 | 588 | 20 |
805043 | 805043 | 2020-12-07 | Humphreys | Mississippi | 28053 | 586 | 19 |
801798 | 801798 | 2020-12-06 | Humphreys | Mississippi | 28053 | 577 | 19 |
798553 | 798553 | 2020-12-05 | Humphreys | Mississippi | 28053 | 569 | 19 |
795308 | 795308 | 2020-12-04 | Humphreys | Mississippi | 28053 | 561 | 19 |
792063 | 792063 | 2020-12-03 | Humphreys | Mississippi | 28053 | 557 | 19 |
788818 | 788818 | 2020-12-02 | Humphreys | Mississippi | 28053 | 552 | 19 |
785573 | 785573 | 2020-12-01 | Humphreys | Mississippi | 28053 | 547 | 19 |
782329 | 782329 | 2020-11-30 | Humphreys | Mississippi | 28053 | 547 | 19 |
779083 | 779083 | 2020-11-29 | Humphreys | Mississippi | 28053 | 543 | 19 |
775838 | 775838 | 2020-11-28 | Humphreys | Mississippi | 28053 | 536 | 19 |
772593 | 772593 | 2020-11-27 | Humphreys | Mississippi | 28053 | 531 | 19 |
769348 | 769348 | 2020-11-26 | Humphreys | Mississippi | 28053 | 531 | 19 |
766102 | 766102 | 2020-11-25 | Humphreys | Mississippi | 28053 | 529 | 18 |
762857 | 762857 | 2020-11-24 | Humphreys | Mississippi | 28053 | 526 | 18 |
759612 | 759612 | 2020-11-23 | Humphreys | Mississippi | 28053 | 525 | 18 |
756365 | 756365 | 2020-11-22 | Humphreys | Mississippi | 28053 | 523 | 18 |
753119 | 753119 | 2020-11-21 | Humphreys | Mississippi | 28053 | 519 | 18 |
749873 | 749873 | 2020-11-20 | Humphreys | Mississippi | 28053 | 515 | 18 |
746627 | 746627 | 2020-11-19 | Humphreys | Mississippi | 28053 | 509 | 18 |
743380 | 743380 | 2020-11-18 | Humphreys | Mississippi | 28053 | 509 | 18 |
740133 | 740133 | 2020-11-17 | Humphreys | Mississippi | 28053 | 506 | 18 |
736889 | 736889 | 2020-11-16 | Humphreys | Mississippi | 28053 | 506 | 18 |
733643 | 733643 | 2020-11-15 | Humphreys | Mississippi | 28053 | 503 | 18 |
730398 | 730398 | 2020-11-14 | Humphreys | Mississippi | 28053 | 499 | 18 |
727155 | 727155 | 2020-11-13 | Humphreys | Mississippi | 28053 | 495 | 18 |
723912 | 723912 | 2020-11-12 | Humphreys | Mississippi | 28053 | 491 | 18 |
720669 | 720669 | 2020-11-11 | Humphreys | Mississippi | 28053 | 491 | 18 |
717426 | 717426 | 2020-11-10 | Humphreys | Mississippi | 28053 | 489 | 18 |
714182 | 714182 | 2020-11-09 | Humphreys | Mississippi | 28053 | 487 | 18 |
710938 | 710938 | 2020-11-08 | Humphreys | Mississippi | 28053 | 487 | 18 |
707694 | 707694 | 2020-11-07 | Humphreys | Mississippi | 28053 | 484 | 18 |
704451 | 704451 | 2020-11-06 | Humphreys | Mississippi | 28053 | 481 | 18 |
701209 | 701209 | 2020-11-05 | Humphreys | Mississippi | 28053 | 480 | 18 |
697965 | 697965 | 2020-11-04 | Humphreys | Mississippi | 28053 | 476 | 18 |
694722 | 694722 | 2020-11-03 | Humphreys | Mississippi | 28053 | 473 | 18 |
691480 | 691480 | 2020-11-02 | Humphreys | Mississippi | 28053 | 470 | 17 |
688235 | 688235 | 2020-11-01 | Humphreys | Mississippi | 28053 | 469 | 17 |
684991 | 684991 | 2020-10-31 | Humphreys | Mississippi | 28053 | 469 | 17 |
681748 | 681748 | 2020-10-30 | Humphreys | Mississippi | 28053 | 468 | 17 |
678504 | 678504 | 2020-10-29 | Humphreys | Mississippi | 28053 | 458 | 17 |
675262 | 675262 | 2020-10-28 | Humphreys | Mississippi | 28053 | 451 | 17 |
672019 | 672019 | 2020-10-27 | Humphreys | Mississippi | 28053 | 449 | 16 |
668777 | 668777 | 2020-10-26 | Humphreys | Mississippi | 28053 | 449 | 16 |
665533 | 665533 | 2020-10-25 | Humphreys | Mississippi | 28053 | 438 | 16 |
662288 | 662288 | 2020-10-24 | Humphreys | Mississippi | 28053 | 438 | 16 |
659044 | 659044 | 2020-10-23 | Humphreys | Mississippi | 28053 | 428 | 16 |
655799 | 655799 | 2020-10-22 | Humphreys | Mississippi | 28053 | 426 | 16 |
652554 | 652554 | 2020-10-21 | Humphreys | Mississippi | 28053 | 419 | 16 |
649309 | 649309 | 2020-10-20 | Humphreys | Mississippi | 28053 | 412 | 16 |
646065 | 646065 | 2020-10-19 | Humphreys | Mississippi | 28053 | 399 | 16 |
642818 | 642818 | 2020-10-18 | Humphreys | Mississippi | 28053 | 399 | 16 |
639571 | 639571 | 2020-10-17 | Humphreys | Mississippi | 28053 | 399 | 16 |
636325 | 636325 | 2020-10-16 | Humphreys | Mississippi | 28053 | 394 | 16 |
633079 | 633079 | 2020-10-15 | Humphreys | Mississippi | 28053 | 392 | 16 |
629834 | 629834 | 2020-10-14 | Humphreys | Mississippi | 28053 | 389 | 16 |
626590 | 626590 | 2020-10-13 | Humphreys | Mississippi | 28053 | 388 | 16 |
623348 | 623348 | 2020-10-12 | Humphreys | Mississippi | 28053 | 386 | 16 |
620105 | 620105 | 2020-10-11 | Humphreys | Mississippi | 28053 | 385 | 16 |
616863 | 616863 | 2020-10-10 | Humphreys | Mississippi | 28053 | 384 | 16 |
613622 | 613622 | 2020-10-09 | Humphreys | Mississippi | 28053 | 383 | 16 |
610380 | 610380 | 2020-10-08 | Humphreys | Mississippi | 28053 | 382 | 16 |
607138 | 607138 | 2020-10-07 | Humphreys | Mississippi | 28053 | 382 | 15 |
603895 | 603895 | 2020-10-06 | Humphreys | Mississippi | 28053 | 382 | 15 |
600653 | 600653 | 2020-10-05 | Humphreys | Mississippi | 28053 | 382 | 15 |
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);