ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Smith" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064721 | 1064721 | 2021-02-25 | Smith | Mississippi | 28129 | 1518 | 31 |
1061477 | 1061477 | 2021-02-24 | Smith | Mississippi | 28129 | 1515 | 31 |
1058231 | 1058231 | 2021-02-23 | Smith | Mississippi | 28129 | 1511 | 31 |
1054985 | 1054985 | 2021-02-22 | Smith | Mississippi | 28129 | 1510 | 30 |
1051738 | 1051738 | 2021-02-21 | Smith | Mississippi | 28129 | 1510 | 30 |
1048491 | 1048491 | 2021-02-20 | Smith | Mississippi | 28129 | 1498 | 30 |
1045245 | 1045245 | 2021-02-19 | Smith | Mississippi | 28129 | 1495 | 29 |
1042000 | 1042000 | 2021-02-18 | Smith | Mississippi | 28129 | 1488 | 29 |
1038755 | 1038755 | 2021-02-17 | Smith | Mississippi | 28129 | 1487 | 29 |
1035510 | 1035510 | 2021-02-16 | Smith | Mississippi | 28129 | 1483 | 28 |
1032265 | 1032265 | 2021-02-15 | Smith | Mississippi | 28129 | 1480 | 28 |
1029018 | 1029018 | 2021-02-14 | Smith | Mississippi | 28129 | 1476 | 28 |
1025772 | 1025772 | 2021-02-13 | Smith | Mississippi | 28129 | 1464 | 28 |
1022527 | 1022527 | 2021-02-12 | Smith | Mississippi | 28129 | 1460 | 27 |
1019282 | 1019282 | 2021-02-11 | Smith | Mississippi | 28129 | 1456 | 27 |
1016037 | 1016037 | 2021-02-10 | Smith | Mississippi | 28129 | 1451 | 27 |
1012792 | 1012792 | 2021-02-09 | Smith | Mississippi | 28129 | 1447 | 27 |
1009547 | 1009547 | 2021-02-08 | Smith | Mississippi | 28129 | 1444 | 27 |
1006300 | 1006300 | 2021-02-07 | Smith | Mississippi | 28129 | 1438 | 27 |
1003054 | 1003054 | 2021-02-06 | Smith | Mississippi | 28129 | 1436 | 27 |
999809 | 999809 | 2021-02-05 | Smith | Mississippi | 28129 | 1433 | 27 |
996563 | 996563 | 2021-02-04 | Smith | Mississippi | 28129 | 1422 | 27 |
993317 | 993317 | 2021-02-03 | Smith | Mississippi | 28129 | 1409 | 27 |
990071 | 990071 | 2021-02-02 | Smith | Mississippi | 28129 | 1406 | 27 |
986824 | 986824 | 2021-02-01 | Smith | Mississippi | 28129 | 1400 | 27 |
983577 | 983577 | 2021-01-31 | Smith | Mississippi | 28129 | 1395 | 27 |
980331 | 980331 | 2021-01-30 | Smith | Mississippi | 28129 | 1390 | 26 |
977085 | 977085 | 2021-01-29 | Smith | Mississippi | 28129 | 1374 | 26 |
973840 | 973840 | 2021-01-28 | Smith | Mississippi | 28129 | 1368 | 26 |
970595 | 970595 | 2021-01-27 | Smith | Mississippi | 28129 | 1342 | 26 |
967350 | 967350 | 2021-01-26 | Smith | Mississippi | 28129 | 1319 | 26 |
964106 | 964106 | 2021-01-25 | Smith | Mississippi | 28129 | 1307 | 26 |
960861 | 960861 | 2021-01-24 | Smith | Mississippi | 28129 | 1300 | 26 |
957615 | 957615 | 2021-01-23 | Smith | Mississippi | 28129 | 1292 | 26 |
954370 | 954370 | 2021-01-22 | Smith | Mississippi | 28129 | 1277 | 25 |
951125 | 951125 | 2021-01-21 | Smith | Mississippi | 28129 | 1258 | 25 |
947879 | 947879 | 2021-01-20 | Smith | Mississippi | 28129 | 1227 | 25 |
944632 | 944632 | 2021-01-19 | Smith | Mississippi | 28129 | 1214 | 24 |
941387 | 941387 | 2021-01-18 | Smith | Mississippi | 28129 | 1208 | 23 |
938142 | 938142 | 2021-01-17 | Smith | Mississippi | 28129 | 1201 | 23 |
934897 | 934897 | 2021-01-16 | Smith | Mississippi | 28129 | 1194 | 23 |
931652 | 931652 | 2021-01-15 | Smith | Mississippi | 28129 | 1188 | 23 |
928407 | 928407 | 2021-01-14 | Smith | Mississippi | 28129 | 1173 | 22 |
925161 | 925161 | 2021-01-13 | Smith | Mississippi | 28129 | 1160 | 22 |
921916 | 921916 | 2021-01-12 | Smith | Mississippi | 28129 | 1150 | 22 |
918671 | 918671 | 2021-01-11 | Smith | Mississippi | 28129 | 1142 | 20 |
915426 | 915426 | 2021-01-10 | Smith | Mississippi | 28129 | 1140 | 20 |
912181 | 912181 | 2021-01-09 | Smith | Mississippi | 28129 | 1132 | 20 |
908936 | 908936 | 2021-01-08 | Smith | Mississippi | 28129 | 1122 | 20 |
905690 | 905690 | 2021-01-07 | Smith | Mississippi | 28129 | 1112 | 20 |
902445 | 902445 | 2021-01-06 | Smith | Mississippi | 28129 | 1090 | 20 |
899200 | 899200 | 2021-01-05 | Smith | Mississippi | 28129 | 1079 | 20 |
895955 | 895955 | 2021-01-04 | Smith | Mississippi | 28129 | 1072 | 20 |
892708 | 892708 | 2021-01-03 | Smith | Mississippi | 28129 | 1061 | 20 |
889462 | 889462 | 2021-01-02 | Smith | Mississippi | 28129 | 1049 | 20 |
886216 | 886216 | 2021-01-01 | Smith | Mississippi | 28129 | 1036 | 20 |
882971 | 882971 | 2020-12-31 | Smith | Mississippi | 28129 | 1021 | 20 |
879726 | 879726 | 2020-12-30 | Smith | Mississippi | 28129 | 1010 | 20 |
876481 | 876481 | 2020-12-29 | Smith | Mississippi | 28129 | 998 | 20 |
873236 | 873236 | 2020-12-28 | Smith | Mississippi | 28129 | 990 | 19 |
869991 | 869991 | 2020-12-27 | Smith | Mississippi | 28129 | 977 | 19 |
866746 | 866746 | 2020-12-26 | Smith | Mississippi | 28129 | 971 | 18 |
863501 | 863501 | 2020-12-25 | Smith | Mississippi | 28129 | 967 | 18 |
860256 | 860256 | 2020-12-24 | Smith | Mississippi | 28129 | 956 | 18 |
857011 | 857011 | 2020-12-23 | Smith | Mississippi | 28129 | 951 | 18 |
853766 | 853766 | 2020-12-22 | Smith | Mississippi | 28129 | 946 | 17 |
850521 | 850521 | 2020-12-21 | Smith | Mississippi | 28129 | 941 | 17 |
847276 | 847276 | 2020-12-20 | Smith | Mississippi | 28129 | 933 | 17 |
844030 | 844030 | 2020-12-19 | Smith | Mississippi | 28129 | 916 | 17 |
840785 | 840785 | 2020-12-18 | Smith | Mississippi | 28129 | 913 | 17 |
837540 | 837540 | 2020-12-17 | Smith | Mississippi | 28129 | 891 | 17 |
834294 | 834294 | 2020-12-16 | Smith | Mississippi | 28129 | 880 | 17 |
831047 | 831047 | 2020-12-15 | Smith | Mississippi | 28129 | 867 | 17 |
827801 | 827801 | 2020-12-14 | Smith | Mississippi | 28129 | 859 | 17 |
824554 | 824554 | 2020-12-13 | Smith | Mississippi | 28129 | 851 | 17 |
821308 | 821308 | 2020-12-12 | Smith | Mississippi | 28129 | 845 | 17 |
818062 | 818062 | 2020-12-11 | Smith | Mississippi | 28129 | 836 | 16 |
814816 | 814816 | 2020-12-10 | Smith | Mississippi | 28129 | 827 | 16 |
811571 | 811571 | 2020-12-09 | Smith | Mississippi | 28129 | 818 | 16 |
808326 | 808326 | 2020-12-08 | Smith | Mississippi | 28129 | 800 | 16 |
805081 | 805081 | 2020-12-07 | Smith | Mississippi | 28129 | 788 | 16 |
801836 | 801836 | 2020-12-06 | Smith | Mississippi | 28129 | 780 | 16 |
798591 | 798591 | 2020-12-05 | Smith | Mississippi | 28129 | 774 | 16 |
795346 | 795346 | 2020-12-04 | Smith | Mississippi | 28129 | 765 | 16 |
792101 | 792101 | 2020-12-03 | Smith | Mississippi | 28129 | 757 | 16 |
788856 | 788856 | 2020-12-02 | Smith | Mississippi | 28129 | 742 | 16 |
785611 | 785611 | 2020-12-01 | Smith | Mississippi | 28129 | 732 | 16 |
782367 | 782367 | 2020-11-30 | Smith | Mississippi | 28129 | 728 | 16 |
779121 | 779121 | 2020-11-29 | Smith | Mississippi | 28129 | 721 | 16 |
775876 | 775876 | 2020-11-28 | Smith | Mississippi | 28129 | 713 | 16 |
772631 | 772631 | 2020-11-27 | Smith | Mississippi | 28129 | 705 | 16 |
769386 | 769386 | 2020-11-26 | Smith | Mississippi | 28129 | 703 | 16 |
766140 | 766140 | 2020-11-25 | Smith | Mississippi | 28129 | 696 | 16 |
762895 | 762895 | 2020-11-24 | Smith | Mississippi | 28129 | 688 | 16 |
759650 | 759650 | 2020-11-23 | Smith | Mississippi | 28129 | 686 | 16 |
756403 | 756403 | 2020-11-22 | Smith | Mississippi | 28129 | 686 | 16 |
753157 | 753157 | 2020-11-21 | Smith | Mississippi | 28129 | 684 | 16 |
749911 | 749911 | 2020-11-20 | Smith | Mississippi | 28129 | 672 | 16 |
746665 | 746665 | 2020-11-19 | Smith | Mississippi | 28129 | 670 | 16 |
743418 | 743418 | 2020-11-18 | Smith | Mississippi | 28129 | 668 | 16 |
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);