ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Montgomery" and fips = 28097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921900 | 921900 | 2021-01-12 | Montgomery | Mississippi | 28097 | 1066 | 34 |
918655 | 918655 | 2021-01-11 | Montgomery | Mississippi | 28097 | 1061 | 32 |
915410 | 915410 | 2021-01-10 | Montgomery | Mississippi | 28097 | 1058 | 32 |
912165 | 912165 | 2021-01-09 | Montgomery | Mississippi | 28097 | 1050 | 32 |
908920 | 908920 | 2021-01-08 | Montgomery | Mississippi | 28097 | 1040 | 32 |
905674 | 905674 | 2021-01-07 | Montgomery | Mississippi | 28097 | 1034 | 31 |
902429 | 902429 | 2021-01-06 | Montgomery | Mississippi | 28097 | 1027 | 31 |
899184 | 899184 | 2021-01-05 | Montgomery | Mississippi | 28097 | 1015 | 31 |
895939 | 895939 | 2021-01-04 | Montgomery | Mississippi | 28097 | 1008 | 31 |
892692 | 892692 | 2021-01-03 | Montgomery | Mississippi | 28097 | 1004 | 31 |
889446 | 889446 | 2021-01-02 | Montgomery | Mississippi | 28097 | 997 | 31 |
886200 | 886200 | 2021-01-01 | Montgomery | Mississippi | 28097 | 994 | 31 |
882955 | 882955 | 2020-12-31 | Montgomery | Mississippi | 28097 | 984 | 31 |
879710 | 879710 | 2020-12-30 | Montgomery | Mississippi | 28097 | 972 | 31 |
876465 | 876465 | 2020-12-29 | Montgomery | Mississippi | 28097 | 962 | 31 |
873220 | 873220 | 2020-12-28 | Montgomery | Mississippi | 28097 | 955 | 31 |
869975 | 869975 | 2020-12-27 | Montgomery | Mississippi | 28097 | 953 | 31 |
866730 | 866730 | 2020-12-26 | Montgomery | Mississippi | 28097 | 951 | 30 |
863485 | 863485 | 2020-12-25 | Montgomery | Mississippi | 28097 | 949 | 30 |
860240 | 860240 | 2020-12-24 | Montgomery | Mississippi | 28097 | 946 | 30 |
856995 | 856995 | 2020-12-23 | Montgomery | Mississippi | 28097 | 941 | 30 |
853750 | 853750 | 2020-12-22 | Montgomery | Mississippi | 28097 | 935 | 30 |
850505 | 850505 | 2020-12-21 | Montgomery | Mississippi | 28097 | 929 | 30 |
847260 | 847260 | 2020-12-20 | Montgomery | Mississippi | 28097 | 923 | 30 |
844014 | 844014 | 2020-12-19 | Montgomery | Mississippi | 28097 | 917 | 30 |
840769 | 840769 | 2020-12-18 | Montgomery | Mississippi | 28097 | 916 | 30 |
837524 | 837524 | 2020-12-17 | Montgomery | Mississippi | 28097 | 908 | 30 |
834278 | 834278 | 2020-12-16 | Montgomery | Mississippi | 28097 | 902 | 30 |
831031 | 831031 | 2020-12-15 | Montgomery | Mississippi | 28097 | 893 | 30 |
827785 | 827785 | 2020-12-14 | Montgomery | Mississippi | 28097 | 889 | 30 |
824538 | 824538 | 2020-12-13 | Montgomery | Mississippi | 28097 | 877 | 30 |
821292 | 821292 | 2020-12-12 | Montgomery | Mississippi | 28097 | 868 | 30 |
818046 | 818046 | 2020-12-11 | Montgomery | Mississippi | 28097 | 863 | 28 |
814800 | 814800 | 2020-12-10 | Montgomery | Mississippi | 28097 | 859 | 27 |
811555 | 811555 | 2020-12-09 | Montgomery | Mississippi | 28097 | 849 | 27 |
808310 | 808310 | 2020-12-08 | Montgomery | Mississippi | 28097 | 842 | 27 |
805065 | 805065 | 2020-12-07 | Montgomery | Mississippi | 28097 | 829 | 26 |
801820 | 801820 | 2020-12-06 | Montgomery | Mississippi | 28097 | 823 | 26 |
798575 | 798575 | 2020-12-05 | Montgomery | Mississippi | 28097 | 816 | 26 |
795330 | 795330 | 2020-12-04 | Montgomery | Mississippi | 28097 | 807 | 26 |
792085 | 792085 | 2020-12-03 | Montgomery | Mississippi | 28097 | 788 | 26 |
788840 | 788840 | 2020-12-02 | Montgomery | Mississippi | 28097 | 784 | 26 |
785595 | 785595 | 2020-12-01 | Montgomery | Mississippi | 28097 | 769 | 26 |
782351 | 782351 | 2020-11-30 | Montgomery | Mississippi | 28097 | 758 | 25 |
779105 | 779105 | 2020-11-29 | Montgomery | Mississippi | 28097 | 754 | 25 |
775860 | 775860 | 2020-11-28 | Montgomery | Mississippi | 28097 | 745 | 25 |
772615 | 772615 | 2020-11-27 | Montgomery | Mississippi | 28097 | 736 | 25 |
769370 | 769370 | 2020-11-26 | Montgomery | Mississippi | 28097 | 728 | 25 |
766124 | 766124 | 2020-11-25 | Montgomery | Mississippi | 28097 | 721 | 25 |
762879 | 762879 | 2020-11-24 | Montgomery | Mississippi | 28097 | 719 | 25 |
759634 | 759634 | 2020-11-23 | Montgomery | Mississippi | 28097 | 719 | 25 |
756387 | 756387 | 2020-11-22 | Montgomery | Mississippi | 28097 | 719 | 25 |
753141 | 753141 | 2020-11-21 | Montgomery | Mississippi | 28097 | 717 | 25 |
749895 | 749895 | 2020-11-20 | Montgomery | Mississippi | 28097 | 703 | 25 |
746649 | 746649 | 2020-11-19 | Montgomery | Mississippi | 28097 | 696 | 25 |
743402 | 743402 | 2020-11-18 | Montgomery | Mississippi | 28097 | 690 | 24 |
740155 | 740155 | 2020-11-17 | Montgomery | Mississippi | 28097 | 678 | 24 |
736911 | 736911 | 2020-11-16 | Montgomery | Mississippi | 28097 | 673 | 24 |
733665 | 733665 | 2020-11-15 | Montgomery | Mississippi | 28097 | 670 | 24 |
730420 | 730420 | 2020-11-14 | Montgomery | Mississippi | 28097 | 663 | 24 |
727177 | 727177 | 2020-11-13 | Montgomery | Mississippi | 28097 | 652 | 23 |
723934 | 723934 | 2020-11-12 | Montgomery | Mississippi | 28097 | 639 | 23 |
720691 | 720691 | 2020-11-11 | Montgomery | Mississippi | 28097 | 633 | 23 |
717448 | 717448 | 2020-11-10 | Montgomery | Mississippi | 28097 | 621 | 23 |
714204 | 714204 | 2020-11-09 | Montgomery | Mississippi | 28097 | 616 | 23 |
710960 | 710960 | 2020-11-08 | Montgomery | Mississippi | 28097 | 612 | 23 |
707716 | 707716 | 2020-11-07 | Montgomery | Mississippi | 28097 | 609 | 23 |
704473 | 704473 | 2020-11-06 | Montgomery | Mississippi | 28097 | 601 | 23 |
701231 | 701231 | 2020-11-05 | Montgomery | Mississippi | 28097 | 600 | 23 |
697987 | 697987 | 2020-11-04 | Montgomery | Mississippi | 28097 | 583 | 23 |
694744 | 694744 | 2020-11-03 | Montgomery | Mississippi | 28097 | 578 | 23 |
691502 | 691502 | 2020-11-02 | Montgomery | Mississippi | 28097 | 576 | 23 |
688257 | 688257 | 2020-11-01 | Montgomery | Mississippi | 28097 | 575 | 23 |
685013 | 685013 | 2020-10-31 | Montgomery | Mississippi | 28097 | 575 | 23 |
681770 | 681770 | 2020-10-30 | Montgomery | Mississippi | 28097 | 569 | 23 |
678526 | 678526 | 2020-10-29 | Montgomery | Mississippi | 28097 | 565 | 23 |
675284 | 675284 | 2020-10-28 | Montgomery | Mississippi | 28097 | 558 | 23 |
672041 | 672041 | 2020-10-27 | Montgomery | Mississippi | 28097 | 554 | 23 |
668799 | 668799 | 2020-10-26 | Montgomery | Mississippi | 28097 | 552 | 23 |
665555 | 665555 | 2020-10-25 | Montgomery | Mississippi | 28097 | 549 | 23 |
662310 | 662310 | 2020-10-24 | Montgomery | Mississippi | 28097 | 549 | 23 |
659066 | 659066 | 2020-10-23 | Montgomery | Mississippi | 28097 | 543 | 23 |
655821 | 655821 | 2020-10-22 | Montgomery | Mississippi | 28097 | 535 | 23 |
652576 | 652576 | 2020-10-21 | Montgomery | Mississippi | 28097 | 531 | 23 |
649331 | 649331 | 2020-10-20 | Montgomery | Mississippi | 28097 | 529 | 23 |
646087 | 646087 | 2020-10-19 | Montgomery | Mississippi | 28097 | 527 | 23 |
642840 | 642840 | 2020-10-18 | Montgomery | Mississippi | 28097 | 527 | 23 |
639593 | 639593 | 2020-10-17 | Montgomery | Mississippi | 28097 | 527 | 23 |
636347 | 636347 | 2020-10-16 | Montgomery | Mississippi | 28097 | 523 | 23 |
633101 | 633101 | 2020-10-15 | Montgomery | Mississippi | 28097 | 522 | 23 |
629856 | 629856 | 2020-10-14 | Montgomery | Mississippi | 28097 | 520 | 23 |
626612 | 626612 | 2020-10-13 | Montgomery | Mississippi | 28097 | 515 | 23 |
623370 | 623370 | 2020-10-12 | Montgomery | Mississippi | 28097 | 511 | 23 |
620127 | 620127 | 2020-10-11 | Montgomery | Mississippi | 28097 | 511 | 23 |
616885 | 616885 | 2020-10-10 | Montgomery | Mississippi | 28097 | 511 | 22 |
613644 | 613644 | 2020-10-09 | Montgomery | Mississippi | 28097 | 506 | 21 |
610402 | 610402 | 2020-10-08 | Montgomery | Mississippi | 28097 | 499 | 21 |
607160 | 607160 | 2020-10-07 | Montgomery | Mississippi | 28097 | 498 | 21 |
603917 | 603917 | 2020-10-06 | Montgomery | Mississippi | 28097 | 497 | 21 |
600675 | 600675 | 2020-10-05 | Montgomery | Mississippi | 28097 | 491 | 21 |
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);