ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pearl River" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054975 | 1054975 | 2021-02-22 | Pearl River | Mississippi | 28109 | 4057 | 127 |
1051728 | 1051728 | 2021-02-21 | Pearl River | Mississippi | 28109 | 4051 | 127 |
1048481 | 1048481 | 2021-02-20 | Pearl River | Mississippi | 28109 | 4036 | 127 |
1045235 | 1045235 | 2021-02-19 | Pearl River | Mississippi | 28109 | 4023 | 126 |
1041990 | 1041990 | 2021-02-18 | Pearl River | Mississippi | 28109 | 4010 | 126 |
1038745 | 1038745 | 2021-02-17 | Pearl River | Mississippi | 28109 | 4004 | 126 |
1035500 | 1035500 | 2021-02-16 | Pearl River | Mississippi | 28109 | 3985 | 126 |
1032255 | 1032255 | 2021-02-15 | Pearl River | Mississippi | 28109 | 3969 | 123 |
1029008 | 1029008 | 2021-02-14 | Pearl River | Mississippi | 28109 | 3958 | 123 |
1025762 | 1025762 | 2021-02-13 | Pearl River | Mississippi | 28109 | 3953 | 123 |
1022517 | 1022517 | 2021-02-12 | Pearl River | Mississippi | 28109 | 3934 | 123 |
1019272 | 1019272 | 2021-02-11 | Pearl River | Mississippi | 28109 | 3897 | 122 |
1016027 | 1016027 | 2021-02-10 | Pearl River | Mississippi | 28109 | 3878 | 121 |
1012782 | 1012782 | 2021-02-09 | Pearl River | Mississippi | 28109 | 3864 | 121 |
1009537 | 1009537 | 2021-02-08 | Pearl River | Mississippi | 28109 | 3856 | 117 |
1006290 | 1006290 | 2021-02-07 | Pearl River | Mississippi | 28109 | 3846 | 117 |
1003044 | 1003044 | 2021-02-06 | Pearl River | Mississippi | 28109 | 3820 | 117 |
999799 | 999799 | 2021-02-05 | Pearl River | Mississippi | 28109 | 3805 | 117 |
996553 | 996553 | 2021-02-04 | Pearl River | Mississippi | 28109 | 3791 | 116 |
993307 | 993307 | 2021-02-03 | Pearl River | Mississippi | 28109 | 3775 | 115 |
990061 | 990061 | 2021-02-02 | Pearl River | Mississippi | 28109 | 3749 | 113 |
986814 | 986814 | 2021-02-01 | Pearl River | Mississippi | 28109 | 3717 | 111 |
983567 | 983567 | 2021-01-31 | Pearl River | Mississippi | 28109 | 3714 | 111 |
980321 | 980321 | 2021-01-30 | Pearl River | Mississippi | 28109 | 3704 | 110 |
977075 | 977075 | 2021-01-29 | Pearl River | Mississippi | 28109 | 3669 | 109 |
973830 | 973830 | 2021-01-28 | Pearl River | Mississippi | 28109 | 3626 | 109 |
970585 | 970585 | 2021-01-27 | Pearl River | Mississippi | 28109 | 3578 | 107 |
967340 | 967340 | 2021-01-26 | Pearl River | Mississippi | 28109 | 3527 | 106 |
964096 | 964096 | 2021-01-25 | Pearl River | Mississippi | 28109 | 3508 | 106 |
960851 | 960851 | 2021-01-24 | Pearl River | Mississippi | 28109 | 3495 | 106 |
957605 | 957605 | 2021-01-23 | Pearl River | Mississippi | 28109 | 3468 | 105 |
954360 | 954360 | 2021-01-22 | Pearl River | Mississippi | 28109 | 3422 | 105 |
951115 | 951115 | 2021-01-21 | Pearl River | Mississippi | 28109 | 3380 | 104 |
947869 | 947869 | 2021-01-20 | Pearl River | Mississippi | 28109 | 3329 | 103 |
944622 | 944622 | 2021-01-19 | Pearl River | Mississippi | 28109 | 3301 | 100 |
941377 | 941377 | 2021-01-18 | Pearl River | Mississippi | 28109 | 3297 | 99 |
938132 | 938132 | 2021-01-17 | Pearl River | Mississippi | 28109 | 3278 | 99 |
934887 | 934887 | 2021-01-16 | Pearl River | Mississippi | 28109 | 3232 | 95 |
931642 | 931642 | 2021-01-15 | Pearl River | Mississippi | 28109 | 3194 | 92 |
928397 | 928397 | 2021-01-14 | Pearl River | Mississippi | 28109 | 3138 | 91 |
925151 | 925151 | 2021-01-13 | Pearl River | Mississippi | 28109 | 3100 | 91 |
921906 | 921906 | 2021-01-12 | Pearl River | Mississippi | 28109 | 3060 | 90 |
918661 | 918661 | 2021-01-11 | Pearl River | Mississippi | 28109 | 3041 | 89 |
915416 | 915416 | 2021-01-10 | Pearl River | Mississippi | 28109 | 3026 | 89 |
912171 | 912171 | 2021-01-09 | Pearl River | Mississippi | 28109 | 2999 | 89 |
908926 | 908926 | 2021-01-08 | Pearl River | Mississippi | 28109 | 2926 | 88 |
905680 | 905680 | 2021-01-07 | Pearl River | Mississippi | 28109 | 2893 | 87 |
902435 | 902435 | 2021-01-06 | Pearl River | Mississippi | 28109 | 2821 | 87 |
899190 | 899190 | 2021-01-05 | Pearl River | Mississippi | 28109 | 2773 | 85 |
895945 | 895945 | 2021-01-04 | Pearl River | Mississippi | 28109 | 2733 | 83 |
892698 | 892698 | 2021-01-03 | Pearl River | Mississippi | 28109 | 2707 | 82 |
889452 | 889452 | 2021-01-02 | Pearl River | Mississippi | 28109 | 2687 | 82 |
886206 | 886206 | 2021-01-01 | Pearl River | Mississippi | 28109 | 2633 | 81 |
882961 | 882961 | 2020-12-31 | Pearl River | Mississippi | 28109 | 2581 | 81 |
879716 | 879716 | 2020-12-30 | Pearl River | Mississippi | 28109 | 2536 | 80 |
876471 | 876471 | 2020-12-29 | Pearl River | Mississippi | 28109 | 2458 | 80 |
873226 | 873226 | 2020-12-28 | Pearl River | Mississippi | 28109 | 2430 | 80 |
869981 | 869981 | 2020-12-27 | Pearl River | Mississippi | 28109 | 2408 | 79 |
866736 | 866736 | 2020-12-26 | Pearl River | Mississippi | 28109 | 2394 | 79 |
863491 | 863491 | 2020-12-25 | Pearl River | Mississippi | 28109 | 2380 | 79 |
860246 | 860246 | 2020-12-24 | Pearl River | Mississippi | 28109 | 2354 | 79 |
857001 | 857001 | 2020-12-23 | Pearl River | Mississippi | 28109 | 2320 | 79 |
853756 | 853756 | 2020-12-22 | Pearl River | Mississippi | 28109 | 2274 | 77 |
850511 | 850511 | 2020-12-21 | Pearl River | Mississippi | 28109 | 2260 | 77 |
847266 | 847266 | 2020-12-20 | Pearl River | Mississippi | 28109 | 2238 | 77 |
844020 | 844020 | 2020-12-19 | Pearl River | Mississippi | 28109 | 2208 | 75 |
840775 | 840775 | 2020-12-18 | Pearl River | Mississippi | 28109 | 2177 | 75 |
837530 | 837530 | 2020-12-17 | Pearl River | Mississippi | 28109 | 2139 | 75 |
834284 | 834284 | 2020-12-16 | Pearl River | Mississippi | 28109 | 2083 | 74 |
831037 | 831037 | 2020-12-15 | Pearl River | Mississippi | 28109 | 2045 | 73 |
827791 | 827791 | 2020-12-14 | Pearl River | Mississippi | 28109 | 2029 | 73 |
824544 | 824544 | 2020-12-13 | Pearl River | Mississippi | 28109 | 2011 | 73 |
821298 | 821298 | 2020-12-12 | Pearl River | Mississippi | 28109 | 1977 | 73 |
818052 | 818052 | 2020-12-11 | Pearl River | Mississippi | 28109 | 1924 | 73 |
814806 | 814806 | 2020-12-10 | Pearl River | Mississippi | 28109 | 1871 | 73 |
811561 | 811561 | 2020-12-09 | Pearl River | Mississippi | 28109 | 1827 | 72 |
808316 | 808316 | 2020-12-08 | Pearl River | Mississippi | 28109 | 1772 | 72 |
805071 | 805071 | 2020-12-07 | Pearl River | Mississippi | 28109 | 1746 | 71 |
801826 | 801826 | 2020-12-06 | Pearl River | Mississippi | 28109 | 1732 | 71 |
798581 | 798581 | 2020-12-05 | Pearl River | Mississippi | 28109 | 1709 | 71 |
795336 | 795336 | 2020-12-04 | Pearl River | Mississippi | 28109 | 1681 | 70 |
792091 | 792091 | 2020-12-03 | Pearl River | Mississippi | 28109 | 1638 | 70 |
788846 | 788846 | 2020-12-02 | Pearl River | Mississippi | 28109 | 1589 | 69 |
785601 | 785601 | 2020-12-01 | Pearl River | Mississippi | 28109 | 1553 | 68 |
782357 | 782357 | 2020-11-30 | Pearl River | Mississippi | 28109 | 1541 | 68 |
779111 | 779111 | 2020-11-29 | Pearl River | Mississippi | 28109 | 1534 | 68 |
775866 | 775866 | 2020-11-28 | Pearl River | Mississippi | 28109 | 1521 | 67 |
772621 | 772621 | 2020-11-27 | Pearl River | Mississippi | 28109 | 1508 | 67 |
769376 | 769376 | 2020-11-26 | Pearl River | Mississippi | 28109 | 1494 | 67 |
766130 | 766130 | 2020-11-25 | Pearl River | Mississippi | 28109 | 1465 | 67 |
762885 | 762885 | 2020-11-24 | Pearl River | Mississippi | 28109 | 1444 | 67 |
759640 | 759640 | 2020-11-23 | Pearl River | Mississippi | 28109 | 1429 | 67 |
756393 | 756393 | 2020-11-22 | Pearl River | Mississippi | 28109 | 1420 | 67 |
753147 | 753147 | 2020-11-21 | Pearl River | Mississippi | 28109 | 1405 | 67 |
749901 | 749901 | 2020-11-20 | Pearl River | Mississippi | 28109 | 1385 | 66 |
746655 | 746655 | 2020-11-19 | Pearl River | Mississippi | 28109 | 1363 | 66 |
743408 | 743408 | 2020-11-18 | Pearl River | Mississippi | 28109 | 1357 | 66 |
740161 | 740161 | 2020-11-17 | Pearl River | Mississippi | 28109 | 1339 | 65 |
736917 | 736917 | 2020-11-16 | Pearl River | Mississippi | 28109 | 1327 | 65 |
733671 | 733671 | 2020-11-15 | Pearl River | Mississippi | 28109 | 1323 | 65 |
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);