ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Amite" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054923 | 1054923 | 2021-02-22 | Amite | Mississippi | 28005 | 1104 | 32 |
1051676 | 1051676 | 2021-02-21 | Amite | Mississippi | 28005 | 1102 | 32 |
1048429 | 1048429 | 2021-02-20 | Amite | Mississippi | 28005 | 1099 | 32 |
1045183 | 1045183 | 2021-02-19 | Amite | Mississippi | 28005 | 1098 | 32 |
1041938 | 1041938 | 2021-02-18 | Amite | Mississippi | 28005 | 1098 | 32 |
1038693 | 1038693 | 2021-02-17 | Amite | Mississippi | 28005 | 1097 | 32 |
1035448 | 1035448 | 2021-02-16 | Amite | Mississippi | 28005 | 1095 | 32 |
1032203 | 1032203 | 2021-02-15 | Amite | Mississippi | 28005 | 1092 | 32 |
1028956 | 1028956 | 2021-02-14 | Amite | Mississippi | 28005 | 1092 | 32 |
1025710 | 1025710 | 2021-02-13 | Amite | Mississippi | 28005 | 1091 | 32 |
1022465 | 1022465 | 2021-02-12 | Amite | Mississippi | 28005 | 1090 | 32 |
1019220 | 1019220 | 2021-02-11 | Amite | Mississippi | 28005 | 1089 | 32 |
1015975 | 1015975 | 2021-02-10 | Amite | Mississippi | 28005 | 1088 | 31 |
1012730 | 1012730 | 2021-02-09 | Amite | Mississippi | 28005 | 1086 | 31 |
1009485 | 1009485 | 2021-02-08 | Amite | Mississippi | 28005 | 1084 | 31 |
1006238 | 1006238 | 2021-02-07 | Amite | Mississippi | 28005 | 1081 | 31 |
1002992 | 1002992 | 2021-02-06 | Amite | Mississippi | 28005 | 1079 | 31 |
999747 | 999747 | 2021-02-05 | Amite | Mississippi | 28005 | 1073 | 30 |
996501 | 996501 | 2021-02-04 | Amite | Mississippi | 28005 | 1072 | 30 |
993255 | 993255 | 2021-02-03 | Amite | Mississippi | 28005 | 1070 | 30 |
990009 | 990009 | 2021-02-02 | Amite | Mississippi | 28005 | 1069 | 30 |
986762 | 986762 | 2021-02-01 | Amite | Mississippi | 28005 | 1067 | 29 |
983515 | 983515 | 2021-01-31 | Amite | Mississippi | 28005 | 1066 | 29 |
980269 | 980269 | 2021-01-30 | Amite | Mississippi | 28005 | 1063 | 29 |
977023 | 977023 | 2021-01-29 | Amite | Mississippi | 28005 | 1058 | 29 |
973778 | 973778 | 2021-01-28 | Amite | Mississippi | 28005 | 1048 | 29 |
970533 | 970533 | 2021-01-27 | Amite | Mississippi | 28005 | 1038 | 29 |
967288 | 967288 | 2021-01-26 | Amite | Mississippi | 28005 | 1027 | 27 |
964044 | 964044 | 2021-01-25 | Amite | Mississippi | 28005 | 1024 | 26 |
960799 | 960799 | 2021-01-24 | Amite | Mississippi | 28005 | 1021 | 26 |
957553 | 957553 | 2021-01-23 | Amite | Mississippi | 28005 | 1014 | 26 |
954308 | 954308 | 2021-01-22 | Amite | Mississippi | 28005 | 1008 | 26 |
951063 | 951063 | 2021-01-21 | Amite | Mississippi | 28005 | 999 | 26 |
947817 | 947817 | 2021-01-20 | Amite | Mississippi | 28005 | 988 | 26 |
944570 | 944570 | 2021-01-19 | Amite | Mississippi | 28005 | 984 | 26 |
941325 | 941325 | 2021-01-18 | Amite | Mississippi | 28005 | 980 | 25 |
938080 | 938080 | 2021-01-17 | Amite | Mississippi | 28005 | 977 | 25 |
934835 | 934835 | 2021-01-16 | Amite | Mississippi | 28005 | 968 | 25 |
931590 | 931590 | 2021-01-15 | Amite | Mississippi | 28005 | 964 | 25 |
928345 | 928345 | 2021-01-14 | Amite | Mississippi | 28005 | 957 | 25 |
925099 | 925099 | 2021-01-13 | Amite | Mississippi | 28005 | 950 | 25 |
921854 | 921854 | 2021-01-12 | Amite | Mississippi | 28005 | 944 | 25 |
918609 | 918609 | 2021-01-11 | Amite | Mississippi | 28005 | 942 | 25 |
915364 | 915364 | 2021-01-10 | Amite | Mississippi | 28005 | 940 | 25 |
912119 | 912119 | 2021-01-09 | Amite | Mississippi | 28005 | 931 | 25 |
908874 | 908874 | 2021-01-08 | Amite | Mississippi | 28005 | 915 | 23 |
905628 | 905628 | 2021-01-07 | Amite | Mississippi | 28005 | 913 | 23 |
902383 | 902383 | 2021-01-06 | Amite | Mississippi | 28005 | 903 | 23 |
899138 | 899138 | 2021-01-05 | Amite | Mississippi | 28005 | 897 | 23 |
895893 | 895893 | 2021-01-04 | Amite | Mississippi | 28005 | 890 | 23 |
892646 | 892646 | 2021-01-03 | Amite | Mississippi | 28005 | 883 | 23 |
889400 | 889400 | 2021-01-02 | Amite | Mississippi | 28005 | 875 | 23 |
886154 | 886154 | 2021-01-01 | Amite | Mississippi | 28005 | 869 | 23 |
882909 | 882909 | 2020-12-31 | Amite | Mississippi | 28005 | 859 | 23 |
879664 | 879664 | 2020-12-30 | Amite | Mississippi | 28005 | 849 | 22 |
876419 | 876419 | 2020-12-29 | Amite | Mississippi | 28005 | 841 | 22 |
873174 | 873174 | 2020-12-28 | Amite | Mississippi | 28005 | 833 | 21 |
869929 | 869929 | 2020-12-27 | Amite | Mississippi | 28005 | 821 | 20 |
866684 | 866684 | 2020-12-26 | Amite | Mississippi | 28005 | 819 | 20 |
863439 | 863439 | 2020-12-25 | Amite | Mississippi | 28005 | 819 | 20 |
860194 | 860194 | 2020-12-24 | Amite | Mississippi | 28005 | 817 | 20 |
856949 | 856949 | 2020-12-23 | Amite | Mississippi | 28005 | 811 | 20 |
853704 | 853704 | 2020-12-22 | Amite | Mississippi | 28005 | 806 | 20 |
850459 | 850459 | 2020-12-21 | Amite | Mississippi | 28005 | 796 | 20 |
847214 | 847214 | 2020-12-20 | Amite | Mississippi | 28005 | 794 | 20 |
843968 | 843968 | 2020-12-19 | Amite | Mississippi | 28005 | 783 | 19 |
840723 | 840723 | 2020-12-18 | Amite | Mississippi | 28005 | 777 | 19 |
837478 | 837478 | 2020-12-17 | Amite | Mississippi | 28005 | 769 | 16 |
834232 | 834232 | 2020-12-16 | Amite | Mississippi | 28005 | 764 | 16 |
830985 | 830985 | 2020-12-15 | Amite | Mississippi | 28005 | 757 | 16 |
827739 | 827739 | 2020-12-14 | Amite | Mississippi | 28005 | 751 | 16 |
824492 | 824492 | 2020-12-13 | Amite | Mississippi | 28005 | 746 | 16 |
821246 | 821246 | 2020-12-12 | Amite | Mississippi | 28005 | 734 | 16 |
818000 | 818000 | 2020-12-11 | Amite | Mississippi | 28005 | 724 | 16 |
814754 | 814754 | 2020-12-10 | Amite | Mississippi | 28005 | 689 | 16 |
811509 | 811509 | 2020-12-09 | Amite | Mississippi | 28005 | 675 | 16 |
808264 | 808264 | 2020-12-08 | Amite | Mississippi | 28005 | 659 | 15 |
805019 | 805019 | 2020-12-07 | Amite | Mississippi | 28005 | 651 | 15 |
801774 | 801774 | 2020-12-06 | Amite | Mississippi | 28005 | 645 | 15 |
798529 | 798529 | 2020-12-05 | Amite | Mississippi | 28005 | 629 | 15 |
795284 | 795284 | 2020-12-04 | Amite | Mississippi | 28005 | 618 | 15 |
792039 | 792039 | 2020-12-03 | Amite | Mississippi | 28005 | 593 | 15 |
788794 | 788794 | 2020-12-02 | Amite | Mississippi | 28005 | 576 | 15 |
785549 | 785549 | 2020-12-01 | Amite | Mississippi | 28005 | 566 | 15 |
782305 | 782305 | 2020-11-30 | Amite | Mississippi | 28005 | 558 | 14 |
779059 | 779059 | 2020-11-29 | Amite | Mississippi | 28005 | 552 | 14 |
775814 | 775814 | 2020-11-28 | Amite | Mississippi | 28005 | 540 | 14 |
772569 | 772569 | 2020-11-27 | Amite | Mississippi | 28005 | 531 | 14 |
769324 | 769324 | 2020-11-26 | Amite | Mississippi | 28005 | 527 | 14 |
766078 | 766078 | 2020-11-25 | Amite | Mississippi | 28005 | 518 | 14 |
762833 | 762833 | 2020-11-24 | Amite | Mississippi | 28005 | 512 | 14 |
759588 | 759588 | 2020-11-23 | Amite | Mississippi | 28005 | 508 | 14 |
756341 | 756341 | 2020-11-22 | Amite | Mississippi | 28005 | 507 | 14 |
753095 | 753095 | 2020-11-21 | Amite | Mississippi | 28005 | 503 | 14 |
749849 | 749849 | 2020-11-20 | Amite | Mississippi | 28005 | 486 | 14 |
746603 | 746603 | 2020-11-19 | Amite | Mississippi | 28005 | 476 | 14 |
743356 | 743356 | 2020-11-18 | Amite | Mississippi | 28005 | 462 | 14 |
740109 | 740109 | 2020-11-17 | Amite | Mississippi | 28005 | 460 | 14 |
736865 | 736865 | 2020-11-16 | Amite | Mississippi | 28005 | 459 | 14 |
733619 | 733619 | 2020-11-15 | Amite | Mississippi | 28005 | 458 | 14 |
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);