ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pike" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054977 | 1054977 | 2021-02-22 | Pike | Mississippi | 28113 | 2973 | 91 |
1051730 | 1051730 | 2021-02-21 | Pike | Mississippi | 28113 | 2971 | 91 |
1048483 | 1048483 | 2021-02-20 | Pike | Mississippi | 28113 | 2963 | 91 |
1045237 | 1045237 | 2021-02-19 | Pike | Mississippi | 28113 | 2958 | 91 |
1041992 | 1041992 | 2021-02-18 | Pike | Mississippi | 28113 | 2956 | 91 |
1038747 | 1038747 | 2021-02-17 | Pike | Mississippi | 28113 | 2955 | 91 |
1035502 | 1035502 | 2021-02-16 | Pike | Mississippi | 28113 | 2950 | 91 |
1032257 | 1032257 | 2021-02-15 | Pike | Mississippi | 28113 | 2947 | 90 |
1029010 | 1029010 | 2021-02-14 | Pike | Mississippi | 28113 | 2943 | 90 |
1025764 | 1025764 | 2021-02-13 | Pike | Mississippi | 28113 | 2935 | 90 |
1022519 | 1022519 | 2021-02-12 | Pike | Mississippi | 28113 | 2926 | 89 |
1019274 | 1019274 | 2021-02-11 | Pike | Mississippi | 28113 | 2917 | 89 |
1016029 | 1016029 | 2021-02-10 | Pike | Mississippi | 28113 | 2902 | 89 |
1012784 | 1012784 | 2021-02-09 | Pike | Mississippi | 28113 | 2897 | 89 |
1009539 | 1009539 | 2021-02-08 | Pike | Mississippi | 28113 | 2893 | 89 |
1006292 | 1006292 | 2021-02-07 | Pike | Mississippi | 28113 | 2886 | 89 |
1003046 | 1003046 | 2021-02-06 | Pike | Mississippi | 28113 | 2882 | 89 |
999801 | 999801 | 2021-02-05 | Pike | Mississippi | 28113 | 2875 | 89 |
996555 | 996555 | 2021-02-04 | Pike | Mississippi | 28113 | 2856 | 89 |
993309 | 993309 | 2021-02-03 | Pike | Mississippi | 28113 | 2841 | 89 |
990063 | 990063 | 2021-02-02 | Pike | Mississippi | 28113 | 2837 | 89 |
986816 | 986816 | 2021-02-01 | Pike | Mississippi | 28113 | 2824 | 89 |
983569 | 983569 | 2021-01-31 | Pike | Mississippi | 28113 | 2818 | 89 |
980323 | 980323 | 2021-01-30 | Pike | Mississippi | 28113 | 2812 | 88 |
977077 | 977077 | 2021-01-29 | Pike | Mississippi | 28113 | 2794 | 87 |
973832 | 973832 | 2021-01-28 | Pike | Mississippi | 28113 | 2774 | 87 |
970587 | 970587 | 2021-01-27 | Pike | Mississippi | 28113 | 2759 | 85 |
967342 | 967342 | 2021-01-26 | Pike | Mississippi | 28113 | 2729 | 84 |
964098 | 964098 | 2021-01-25 | Pike | Mississippi | 28113 | 2710 | 81 |
960853 | 960853 | 2021-01-24 | Pike | Mississippi | 28113 | 2701 | 81 |
957607 | 957607 | 2021-01-23 | Pike | Mississippi | 28113 | 2689 | 81 |
954362 | 954362 | 2021-01-22 | Pike | Mississippi | 28113 | 2681 | 80 |
951117 | 951117 | 2021-01-21 | Pike | Mississippi | 28113 | 2665 | 80 |
947871 | 947871 | 2021-01-20 | Pike | Mississippi | 28113 | 2646 | 79 |
944624 | 944624 | 2021-01-19 | Pike | Mississippi | 28113 | 2637 | 78 |
941379 | 941379 | 2021-01-18 | Pike | Mississippi | 28113 | 2635 | 77 |
938134 | 938134 | 2021-01-17 | Pike | Mississippi | 28113 | 2620 | 77 |
934889 | 934889 | 2021-01-16 | Pike | Mississippi | 28113 | 2599 | 77 |
931644 | 931644 | 2021-01-15 | Pike | Mississippi | 28113 | 2581 | 76 |
928399 | 928399 | 2021-01-14 | Pike | Mississippi | 28113 | 2548 | 76 |
925153 | 925153 | 2021-01-13 | Pike | Mississippi | 28113 | 2524 | 76 |
921908 | 921908 | 2021-01-12 | Pike | Mississippi | 28113 | 2499 | 76 |
918663 | 918663 | 2021-01-11 | Pike | Mississippi | 28113 | 2483 | 75 |
915418 | 915418 | 2021-01-10 | Pike | Mississippi | 28113 | 2465 | 75 |
912173 | 912173 | 2021-01-09 | Pike | Mississippi | 28113 | 2437 | 75 |
908928 | 908928 | 2021-01-08 | Pike | Mississippi | 28113 | 2385 | 74 |
905682 | 905682 | 2021-01-07 | Pike | Mississippi | 28113 | 2377 | 73 |
902437 | 902437 | 2021-01-06 | Pike | Mississippi | 28113 | 2344 | 73 |
899192 | 899192 | 2021-01-05 | Pike | Mississippi | 28113 | 2318 | 72 |
895947 | 895947 | 2021-01-04 | Pike | Mississippi | 28113 | 2298 | 71 |
892700 | 892700 | 2021-01-03 | Pike | Mississippi | 28113 | 2281 | 71 |
889454 | 889454 | 2021-01-02 | Pike | Mississippi | 28113 | 2271 | 71 |
886208 | 886208 | 2021-01-01 | Pike | Mississippi | 28113 | 2252 | 71 |
882963 | 882963 | 2020-12-31 | Pike | Mississippi | 28113 | 2210 | 71 |
879718 | 879718 | 2020-12-30 | Pike | Mississippi | 28113 | 2200 | 70 |
876473 | 876473 | 2020-12-29 | Pike | Mississippi | 28113 | 2175 | 68 |
873228 | 873228 | 2020-12-28 | Pike | Mississippi | 28113 | 2138 | 65 |
869983 | 869983 | 2020-12-27 | Pike | Mississippi | 28113 | 2121 | 65 |
866738 | 866738 | 2020-12-26 | Pike | Mississippi | 28113 | 2106 | 65 |
863493 | 863493 | 2020-12-25 | Pike | Mississippi | 28113 | 2098 | 65 |
860248 | 860248 | 2020-12-24 | Pike | Mississippi | 28113 | 2080 | 65 |
857003 | 857003 | 2020-12-23 | Pike | Mississippi | 28113 | 2057 | 65 |
853758 | 853758 | 2020-12-22 | Pike | Mississippi | 28113 | 2045 | 65 |
850513 | 850513 | 2020-12-21 | Pike | Mississippi | 28113 | 2026 | 65 |
847268 | 847268 | 2020-12-20 | Pike | Mississippi | 28113 | 2019 | 65 |
844022 | 844022 | 2020-12-19 | Pike | Mississippi | 28113 | 1991 | 65 |
840777 | 840777 | 2020-12-18 | Pike | Mississippi | 28113 | 1964 | 65 |
837532 | 837532 | 2020-12-17 | Pike | Mississippi | 28113 | 1939 | 65 |
834286 | 834286 | 2020-12-16 | Pike | Mississippi | 28113 | 1919 | 65 |
831039 | 831039 | 2020-12-15 | Pike | Mississippi | 28113 | 1907 | 64 |
827793 | 827793 | 2020-12-14 | Pike | Mississippi | 28113 | 1896 | 63 |
824546 | 824546 | 2020-12-13 | Pike | Mississippi | 28113 | 1884 | 63 |
821300 | 821300 | 2020-12-12 | Pike | Mississippi | 28113 | 1871 | 62 |
818054 | 818054 | 2020-12-11 | Pike | Mississippi | 28113 | 1850 | 62 |
814808 | 814808 | 2020-12-10 | Pike | Mississippi | 28113 | 1820 | 61 |
811563 | 811563 | 2020-12-09 | Pike | Mississippi | 28113 | 1795 | 61 |
808318 | 808318 | 2020-12-08 | Pike | Mississippi | 28113 | 1752 | 61 |
805073 | 805073 | 2020-12-07 | Pike | Mississippi | 28113 | 1748 | 60 |
801828 | 801828 | 2020-12-06 | Pike | Mississippi | 28113 | 1739 | 60 |
798583 | 798583 | 2020-12-05 | Pike | Mississippi | 28113 | 1725 | 60 |
795338 | 795338 | 2020-12-04 | Pike | Mississippi | 28113 | 1708 | 60 |
792093 | 792093 | 2020-12-03 | Pike | Mississippi | 28113 | 1683 | 60 |
788848 | 788848 | 2020-12-02 | Pike | Mississippi | 28113 | 1667 | 60 |
785603 | 785603 | 2020-12-01 | Pike | Mississippi | 28113 | 1653 | 59 |
782359 | 782359 | 2020-11-30 | Pike | Mississippi | 28113 | 1647 | 58 |
779113 | 779113 | 2020-11-29 | Pike | Mississippi | 28113 | 1639 | 58 |
775868 | 775868 | 2020-11-28 | Pike | Mississippi | 28113 | 1626 | 58 |
772623 | 772623 | 2020-11-27 | Pike | Mississippi | 28113 | 1616 | 58 |
769378 | 769378 | 2020-11-26 | Pike | Mississippi | 28113 | 1609 | 58 |
766132 | 766132 | 2020-11-25 | Pike | Mississippi | 28113 | 1606 | 58 |
762887 | 762887 | 2020-11-24 | Pike | Mississippi | 28113 | 1604 | 58 |
759642 | 759642 | 2020-11-23 | Pike | Mississippi | 28113 | 1600 | 58 |
756395 | 756395 | 2020-11-22 | Pike | Mississippi | 28113 | 1599 | 58 |
753149 | 753149 | 2020-11-21 | Pike | Mississippi | 28113 | 1596 | 58 |
749903 | 749903 | 2020-11-20 | Pike | Mississippi | 28113 | 1582 | 58 |
746657 | 746657 | 2020-11-19 | Pike | Mississippi | 28113 | 1564 | 58 |
743410 | 743410 | 2020-11-18 | Pike | Mississippi | 28113 | 1556 | 58 |
740163 | 740163 | 2020-11-17 | Pike | Mississippi | 28113 | 1547 | 58 |
736919 | 736919 | 2020-11-16 | Pike | Mississippi | 28113 | 1536 | 58 |
733673 | 733673 | 2020-11-15 | Pike | Mississippi | 28113 | 1533 | 58 |
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);