ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Forrest" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918624 | 918624 | 2021-01-11 | Forrest | Mississippi | 28035 | 5733 | 111 |
915379 | 915379 | 2021-01-10 | Forrest | Mississippi | 28035 | 5705 | 110 |
912134 | 912134 | 2021-01-09 | Forrest | Mississippi | 28035 | 5667 | 110 |
908889 | 908889 | 2021-01-08 | Forrest | Mississippi | 28035 | 5620 | 108 |
905643 | 905643 | 2021-01-07 | Forrest | Mississippi | 28035 | 5581 | 108 |
902398 | 902398 | 2021-01-06 | Forrest | Mississippi | 28035 | 5513 | 106 |
899153 | 899153 | 2021-01-05 | Forrest | Mississippi | 28035 | 5439 | 105 |
895908 | 895908 | 2021-01-04 | Forrest | Mississippi | 28035 | 5410 | 104 |
892661 | 892661 | 2021-01-03 | Forrest | Mississippi | 28035 | 5375 | 104 |
889415 | 889415 | 2021-01-02 | Forrest | Mississippi | 28035 | 5341 | 104 |
886169 | 886169 | 2021-01-01 | Forrest | Mississippi | 28035 | 5292 | 102 |
882924 | 882924 | 2020-12-31 | Forrest | Mississippi | 28035 | 5232 | 101 |
879679 | 879679 | 2020-12-30 | Forrest | Mississippi | 28035 | 5174 | 98 |
876434 | 876434 | 2020-12-29 | Forrest | Mississippi | 28035 | 5107 | 97 |
873189 | 873189 | 2020-12-28 | Forrest | Mississippi | 28035 | 5076 | 96 |
869944 | 869944 | 2020-12-27 | Forrest | Mississippi | 28035 | 5041 | 95 |
866699 | 866699 | 2020-12-26 | Forrest | Mississippi | 28035 | 5026 | 95 |
863454 | 863454 | 2020-12-25 | Forrest | Mississippi | 28035 | 5013 | 94 |
860209 | 860209 | 2020-12-24 | Forrest | Mississippi | 28035 | 4966 | 94 |
856964 | 856964 | 2020-12-23 | Forrest | Mississippi | 28035 | 4923 | 94 |
853719 | 853719 | 2020-12-22 | Forrest | Mississippi | 28035 | 4869 | 94 |
850474 | 850474 | 2020-12-21 | Forrest | Mississippi | 28035 | 4819 | 93 |
847229 | 847229 | 2020-12-20 | Forrest | Mississippi | 28035 | 4792 | 93 |
843983 | 843983 | 2020-12-19 | Forrest | Mississippi | 28035 | 4735 | 93 |
840738 | 840738 | 2020-12-18 | Forrest | Mississippi | 28035 | 4712 | 93 |
837493 | 837493 | 2020-12-17 | Forrest | Mississippi | 28035 | 4642 | 93 |
834247 | 834247 | 2020-12-16 | Forrest | Mississippi | 28035 | 4581 | 93 |
831000 | 831000 | 2020-12-15 | Forrest | Mississippi | 28035 | 4538 | 93 |
827754 | 827754 | 2020-12-14 | Forrest | Mississippi | 28035 | 4503 | 92 |
824507 | 824507 | 2020-12-13 | Forrest | Mississippi | 28035 | 4466 | 92 |
821261 | 821261 | 2020-12-12 | Forrest | Mississippi | 28035 | 4413 | 92 |
818015 | 818015 | 2020-12-11 | Forrest | Mississippi | 28035 | 4369 | 91 |
814769 | 814769 | 2020-12-10 | Forrest | Mississippi | 28035 | 4319 | 90 |
811524 | 811524 | 2020-12-09 | Forrest | Mississippi | 28035 | 4257 | 90 |
808279 | 808279 | 2020-12-08 | Forrest | Mississippi | 28035 | 4203 | 90 |
805034 | 805034 | 2020-12-07 | Forrest | Mississippi | 28035 | 4166 | 90 |
801789 | 801789 | 2020-12-06 | Forrest | Mississippi | 28035 | 4139 | 90 |
798544 | 798544 | 2020-12-05 | Forrest | Mississippi | 28035 | 4107 | 89 |
795299 | 795299 | 2020-12-04 | Forrest | Mississippi | 28035 | 4055 | 87 |
792054 | 792054 | 2020-12-03 | Forrest | Mississippi | 28035 | 4001 | 87 |
788809 | 788809 | 2020-12-02 | Forrest | Mississippi | 28035 | 3947 | 86 |
785564 | 785564 | 2020-12-01 | Forrest | Mississippi | 28035 | 3897 | 86 |
782320 | 782320 | 2020-11-30 | Forrest | Mississippi | 28035 | 3882 | 86 |
779074 | 779074 | 2020-11-29 | Forrest | Mississippi | 28035 | 3859 | 86 |
775829 | 775829 | 2020-11-28 | Forrest | Mississippi | 28035 | 3831 | 86 |
772584 | 772584 | 2020-11-27 | Forrest | Mississippi | 28035 | 3805 | 86 |
769339 | 769339 | 2020-11-26 | Forrest | Mississippi | 28035 | 3750 | 86 |
766093 | 766093 | 2020-11-25 | Forrest | Mississippi | 28035 | 3713 | 86 |
762848 | 762848 | 2020-11-24 | Forrest | Mississippi | 28035 | 3681 | 86 |
759603 | 759603 | 2020-11-23 | Forrest | Mississippi | 28035 | 3671 | 85 |
756356 | 756356 | 2020-11-22 | Forrest | Mississippi | 28035 | 3606 | 85 |
753110 | 753110 | 2020-11-21 | Forrest | Mississippi | 28035 | 3591 | 85 |
749864 | 749864 | 2020-11-20 | Forrest | Mississippi | 28035 | 3548 | 85 |
746618 | 746618 | 2020-11-19 | Forrest | Mississippi | 28035 | 3517 | 85 |
743371 | 743371 | 2020-11-18 | Forrest | Mississippi | 28035 | 3490 | 85 |
740124 | 740124 | 2020-11-17 | Forrest | Mississippi | 28035 | 3460 | 85 |
736880 | 736880 | 2020-11-16 | Forrest | Mississippi | 28035 | 3448 | 83 |
733634 | 733634 | 2020-11-15 | Forrest | Mississippi | 28035 | 3426 | 83 |
730389 | 730389 | 2020-11-14 | Forrest | Mississippi | 28035 | 3401 | 83 |
727146 | 727146 | 2020-11-13 | Forrest | Mississippi | 28035 | 3365 | 83 |
723903 | 723903 | 2020-11-12 | Forrest | Mississippi | 28035 | 3336 | 83 |
720660 | 720660 | 2020-11-11 | Forrest | Mississippi | 28035 | 3307 | 83 |
717417 | 717417 | 2020-11-10 | Forrest | Mississippi | 28035 | 3293 | 83 |
714173 | 714173 | 2020-11-09 | Forrest | Mississippi | 28035 | 3287 | 82 |
710929 | 710929 | 2020-11-08 | Forrest | Mississippi | 28035 | 3282 | 82 |
707685 | 707685 | 2020-11-07 | Forrest | Mississippi | 28035 | 3271 | 82 |
704442 | 704442 | 2020-11-06 | Forrest | Mississippi | 28035 | 3256 | 82 |
701200 | 701200 | 2020-11-05 | Forrest | Mississippi | 28035 | 3230 | 81 |
697956 | 697956 | 2020-11-04 | Forrest | Mississippi | 28035 | 3196 | 81 |
694713 | 694713 | 2020-11-03 | Forrest | Mississippi | 28035 | 3180 | 81 |
691471 | 691471 | 2020-11-02 | Forrest | Mississippi | 28035 | 3176 | 80 |
688226 | 688226 | 2020-11-01 | Forrest | Mississippi | 28035 | 3166 | 80 |
684982 | 684982 | 2020-10-31 | Forrest | Mississippi | 28035 | 3155 | 80 |
681739 | 681739 | 2020-10-30 | Forrest | Mississippi | 28035 | 3141 | 79 |
678495 | 678495 | 2020-10-29 | Forrest | Mississippi | 28035 | 3134 | 78 |
675253 | 675253 | 2020-10-28 | Forrest | Mississippi | 28035 | 3118 | 78 |
672010 | 672010 | 2020-10-27 | Forrest | Mississippi | 28035 | 3094 | 78 |
668768 | 668768 | 2020-10-26 | Forrest | Mississippi | 28035 | 3069 | 78 |
665524 | 665524 | 2020-10-25 | Forrest | Mississippi | 28035 | 3046 | 78 |
662279 | 662279 | 2020-10-24 | Forrest | Mississippi | 28035 | 3046 | 78 |
659035 | 659035 | 2020-10-23 | Forrest | Mississippi | 28035 | 3007 | 78 |
655790 | 655790 | 2020-10-22 | Forrest | Mississippi | 28035 | 2995 | 78 |
652545 | 652545 | 2020-10-21 | Forrest | Mississippi | 28035 | 2980 | 78 |
649300 | 649300 | 2020-10-20 | Forrest | Mississippi | 28035 | 2963 | 77 |
646056 | 646056 | 2020-10-19 | Forrest | Mississippi | 28035 | 2951 | 77 |
642809 | 642809 | 2020-10-18 | Forrest | Mississippi | 28035 | 2927 | 77 |
639562 | 639562 | 2020-10-17 | Forrest | Mississippi | 28035 | 2927 | 77 |
636316 | 636316 | 2020-10-16 | Forrest | Mississippi | 28035 | 2906 | 77 |
633070 | 633070 | 2020-10-15 | Forrest | Mississippi | 28035 | 2887 | 77 |
629825 | 629825 | 2020-10-14 | Forrest | Mississippi | 28035 | 2863 | 76 |
626581 | 626581 | 2020-10-13 | Forrest | Mississippi | 28035 | 2845 | 76 |
623339 | 623339 | 2020-10-12 | Forrest | Mississippi | 28035 | 2831 | 76 |
620096 | 620096 | 2020-10-11 | Forrest | Mississippi | 28035 | 2824 | 76 |
616854 | 616854 | 2020-10-10 | Forrest | Mississippi | 28035 | 2813 | 76 |
613613 | 613613 | 2020-10-09 | Forrest | Mississippi | 28035 | 2771 | 76 |
610371 | 610371 | 2020-10-08 | Forrest | Mississippi | 28035 | 2750 | 76 |
607129 | 607129 | 2020-10-07 | Forrest | Mississippi | 28035 | 2714 | 75 |
603886 | 603886 | 2020-10-06 | Forrest | Mississippi | 28035 | 2678 | 75 |
600644 | 600644 | 2020-10-05 | Forrest | Mississippi | 28035 | 2656 | 75 |
597401 | 597401 | 2020-10-04 | Forrest | Mississippi | 28035 | 2650 | 75 |
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);