ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Monroe" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064704 | 1064704 | 2021-02-25 | Monroe | Mississippi | 28095 | 3980 | 126 |
1061460 | 1061460 | 2021-02-24 | Monroe | Mississippi | 28095 | 3977 | 126 |
1058214 | 1058214 | 2021-02-23 | Monroe | Mississippi | 28095 | 3971 | 125 |
1054968 | 1054968 | 2021-02-22 | Monroe | Mississippi | 28095 | 3967 | 125 |
1051721 | 1051721 | 2021-02-21 | Monroe | Mississippi | 28095 | 3966 | 125 |
1048474 | 1048474 | 2021-02-20 | Monroe | Mississippi | 28095 | 3963 | 125 |
1045228 | 1045228 | 2021-02-19 | Monroe | Mississippi | 28095 | 3961 | 125 |
1041983 | 1041983 | 2021-02-18 | Monroe | Mississippi | 28095 | 3961 | 125 |
1038738 | 1038738 | 2021-02-17 | Monroe | Mississippi | 28095 | 3961 | 125 |
1035493 | 1035493 | 2021-02-16 | Monroe | Mississippi | 28095 | 3952 | 124 |
1032248 | 1032248 | 2021-02-15 | Monroe | Mississippi | 28095 | 3948 | 123 |
1029001 | 1029001 | 2021-02-14 | Monroe | Mississippi | 28095 | 3946 | 123 |
1025755 | 1025755 | 2021-02-13 | Monroe | Mississippi | 28095 | 3937 | 123 |
1022510 | 1022510 | 2021-02-12 | Monroe | Mississippi | 28095 | 3929 | 123 |
1019265 | 1019265 | 2021-02-11 | Monroe | Mississippi | 28095 | 3926 | 123 |
1016020 | 1016020 | 2021-02-10 | Monroe | Mississippi | 28095 | 3915 | 121 |
1012775 | 1012775 | 2021-02-09 | Monroe | Mississippi | 28095 | 3911 | 121 |
1009530 | 1009530 | 2021-02-08 | Monroe | Mississippi | 28095 | 3903 | 119 |
1006283 | 1006283 | 2021-02-07 | Monroe | Mississippi | 28095 | 3902 | 119 |
1003037 | 1003037 | 2021-02-06 | Monroe | Mississippi | 28095 | 3893 | 119 |
999792 | 999792 | 2021-02-05 | Monroe | Mississippi | 28095 | 3868 | 119 |
996546 | 996546 | 2021-02-04 | Monroe | Mississippi | 28095 | 3857 | 118 |
993300 | 993300 | 2021-02-03 | Monroe | Mississippi | 28095 | 3840 | 118 |
990054 | 990054 | 2021-02-02 | Monroe | Mississippi | 28095 | 3827 | 117 |
986807 | 986807 | 2021-02-01 | Monroe | Mississippi | 28095 | 3819 | 117 |
983560 | 983560 | 2021-01-31 | Monroe | Mississippi | 28095 | 3811 | 117 |
980314 | 980314 | 2021-01-30 | Monroe | Mississippi | 28095 | 3806 | 115 |
977068 | 977068 | 2021-01-29 | Monroe | Mississippi | 28095 | 3791 | 114 |
973823 | 973823 | 2021-01-28 | Monroe | Mississippi | 28095 | 3762 | 112 |
970578 | 970578 | 2021-01-27 | Monroe | Mississippi | 28095 | 3746 | 112 |
967333 | 967333 | 2021-01-26 | Monroe | Mississippi | 28095 | 3727 | 111 |
964089 | 964089 | 2021-01-25 | Monroe | Mississippi | 28095 | 3693 | 110 |
960844 | 960844 | 2021-01-24 | Monroe | Mississippi | 28095 | 3686 | 110 |
957598 | 957598 | 2021-01-23 | Monroe | Mississippi | 28095 | 3671 | 108 |
954353 | 954353 | 2021-01-22 | Monroe | Mississippi | 28095 | 3651 | 106 |
951108 | 951108 | 2021-01-21 | Monroe | Mississippi | 28095 | 3628 | 105 |
947862 | 947862 | 2021-01-20 | Monroe | Mississippi | 28095 | 3591 | 105 |
944615 | 944615 | 2021-01-19 | Monroe | Mississippi | 28095 | 3558 | 105 |
941370 | 941370 | 2021-01-18 | Monroe | Mississippi | 28095 | 3543 | 105 |
938125 | 938125 | 2021-01-17 | Monroe | Mississippi | 28095 | 3533 | 105 |
934880 | 934880 | 2021-01-16 | Monroe | Mississippi | 28095 | 3521 | 104 |
931635 | 931635 | 2021-01-15 | Monroe | Mississippi | 28095 | 3487 | 103 |
928390 | 928390 | 2021-01-14 | Monroe | Mississippi | 28095 | 3463 | 101 |
925144 | 925144 | 2021-01-13 | Monroe | Mississippi | 28095 | 3439 | 100 |
921899 | 921899 | 2021-01-12 | Monroe | Mississippi | 28095 | 3409 | 100 |
918654 | 918654 | 2021-01-11 | Monroe | Mississippi | 28095 | 3394 | 98 |
915409 | 915409 | 2021-01-10 | Monroe | Mississippi | 28095 | 3380 | 96 |
912164 | 912164 | 2021-01-09 | Monroe | Mississippi | 28095 | 3369 | 96 |
908919 | 908919 | 2021-01-08 | Monroe | Mississippi | 28095 | 3323 | 95 |
905673 | 905673 | 2021-01-07 | Monroe | Mississippi | 28095 | 3303 | 93 |
902428 | 902428 | 2021-01-06 | Monroe | Mississippi | 28095 | 3241 | 91 |
899183 | 899183 | 2021-01-05 | Monroe | Mississippi | 28095 | 3184 | 91 |
895938 | 895938 | 2021-01-04 | Monroe | Mississippi | 28095 | 3137 | 90 |
892691 | 892691 | 2021-01-03 | Monroe | Mississippi | 28095 | 3119 | 90 |
889445 | 889445 | 2021-01-02 | Monroe | Mississippi | 28095 | 3090 | 90 |
886199 | 886199 | 2021-01-01 | Monroe | Mississippi | 28095 | 3061 | 89 |
882954 | 882954 | 2020-12-31 | Monroe | Mississippi | 28095 | 3007 | 89 |
879709 | 879709 | 2020-12-30 | Monroe | Mississippi | 28095 | 2947 | 89 |
876464 | 876464 | 2020-12-29 | Monroe | Mississippi | 28095 | 2899 | 88 |
873219 | 873219 | 2020-12-28 | Monroe | Mississippi | 28095 | 2854 | 85 |
869974 | 869974 | 2020-12-27 | Monroe | Mississippi | 28095 | 2833 | 85 |
866729 | 866729 | 2020-12-26 | Monroe | Mississippi | 28095 | 2821 | 84 |
863484 | 863484 | 2020-12-25 | Monroe | Mississippi | 28095 | 2815 | 84 |
860239 | 860239 | 2020-12-24 | Monroe | Mississippi | 28095 | 2799 | 84 |
856994 | 856994 | 2020-12-23 | Monroe | Mississippi | 28095 | 2773 | 84 |
853749 | 853749 | 2020-12-22 | Monroe | Mississippi | 28095 | 2725 | 84 |
850504 | 850504 | 2020-12-21 | Monroe | Mississippi | 28095 | 2677 | 83 |
847259 | 847259 | 2020-12-20 | Monroe | Mississippi | 28095 | 2667 | 83 |
844013 | 844013 | 2020-12-19 | Monroe | Mississippi | 28095 | 2641 | 83 |
840768 | 840768 | 2020-12-18 | Monroe | Mississippi | 28095 | 2613 | 83 |
837523 | 837523 | 2020-12-17 | Monroe | Mississippi | 28095 | 2580 | 83 |
834277 | 834277 | 2020-12-16 | Monroe | Mississippi | 28095 | 2547 | 82 |
831030 | 831030 | 2020-12-15 | Monroe | Mississippi | 28095 | 2504 | 81 |
827784 | 827784 | 2020-12-14 | Monroe | Mississippi | 28095 | 2459 | 80 |
824537 | 824537 | 2020-12-13 | Monroe | Mississippi | 28095 | 2429 | 80 |
821291 | 821291 | 2020-12-12 | Monroe | Mississippi | 28095 | 2419 | 80 |
818045 | 818045 | 2020-12-11 | Monroe | Mississippi | 28095 | 2387 | 80 |
814799 | 814799 | 2020-12-10 | Monroe | Mississippi | 28095 | 2359 | 79 |
811554 | 811554 | 2020-12-09 | Monroe | Mississippi | 28095 | 2325 | 78 |
808309 | 808309 | 2020-12-08 | Monroe | Mississippi | 28095 | 2287 | 78 |
805064 | 805064 | 2020-12-07 | Monroe | Mississippi | 28095 | 2236 | 78 |
801819 | 801819 | 2020-12-06 | Monroe | Mississippi | 28095 | 2217 | 78 |
798574 | 798574 | 2020-12-05 | Monroe | Mississippi | 28095 | 2192 | 78 |
795329 | 795329 | 2020-12-04 | Monroe | Mississippi | 28095 | 2162 | 78 |
792084 | 792084 | 2020-12-03 | Monroe | Mississippi | 28095 | 2122 | 78 |
788839 | 788839 | 2020-12-02 | Monroe | Mississippi | 28095 | 2097 | 78 |
785594 | 785594 | 2020-12-01 | Monroe | Mississippi | 28095 | 2067 | 78 |
782350 | 782350 | 2020-11-30 | Monroe | Mississippi | 28095 | 2039 | 78 |
779104 | 779104 | 2020-11-29 | Monroe | Mississippi | 28095 | 2010 | 78 |
775859 | 775859 | 2020-11-28 | Monroe | Mississippi | 28095 | 1981 | 77 |
772614 | 772614 | 2020-11-27 | Monroe | Mississippi | 28095 | 1973 | 77 |
769369 | 769369 | 2020-11-26 | Monroe | Mississippi | 28095 | 1960 | 77 |
766123 | 766123 | 2020-11-25 | Monroe | Mississippi | 28095 | 1914 | 77 |
762878 | 762878 | 2020-11-24 | Monroe | Mississippi | 28095 | 1902 | 77 |
759633 | 759633 | 2020-11-23 | Monroe | Mississippi | 28095 | 1895 | 77 |
756386 | 756386 | 2020-11-22 | Monroe | Mississippi | 28095 | 1888 | 77 |
753140 | 753140 | 2020-11-21 | Monroe | Mississippi | 28095 | 1882 | 77 |
749894 | 749894 | 2020-11-20 | Monroe | Mississippi | 28095 | 1857 | 77 |
746648 | 746648 | 2020-11-19 | Monroe | Mississippi | 28095 | 1827 | 77 |
743401 | 743401 | 2020-11-18 | Monroe | Mississippi | 28095 | 1810 | 76 |
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);