ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Montgomery" and fips = 28097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1077687 | 1077687 | 2021-03-01 | Montgomery | Mississippi | 28097 | 1224 | 38 |
1074441 | 1074441 | 2021-02-28 | Montgomery | Mississippi | 28097 | 1222 | 38 |
1071195 | 1071195 | 2021-02-27 | Montgomery | Mississippi | 28097 | 1218 | 38 |
1067950 | 1067950 | 2021-02-26 | Montgomery | Mississippi | 28097 | 1213 | 38 |
1064705 | 1064705 | 2021-02-25 | Montgomery | Mississippi | 28097 | 1212 | 37 |
1061461 | 1061461 | 2021-02-24 | Montgomery | Mississippi | 28097 | 1205 | 37 |
1058215 | 1058215 | 2021-02-23 | Montgomery | Mississippi | 28097 | 1205 | 37 |
1054969 | 1054969 | 2021-02-22 | Montgomery | Mississippi | 28097 | 1202 | 37 |
1051722 | 1051722 | 2021-02-21 | Montgomery | Mississippi | 28097 | 1201 | 37 |
1048475 | 1048475 | 2021-02-20 | Montgomery | Mississippi | 28097 | 1201 | 37 |
1045229 | 1045229 | 2021-02-19 | Montgomery | Mississippi | 28097 | 1199 | 37 |
1041984 | 1041984 | 2021-02-18 | Montgomery | Mississippi | 28097 | 1198 | 37 |
1038739 | 1038739 | 2021-02-17 | Montgomery | Mississippi | 28097 | 1198 | 37 |
1035494 | 1035494 | 2021-02-16 | Montgomery | Mississippi | 28097 | 1189 | 37 |
1032249 | 1032249 | 2021-02-15 | Montgomery | Mississippi | 28097 | 1188 | 37 |
1029002 | 1029002 | 2021-02-14 | Montgomery | Mississippi | 28097 | 1185 | 37 |
1025756 | 1025756 | 2021-02-13 | Montgomery | Mississippi | 28097 | 1183 | 37 |
1022511 | 1022511 | 2021-02-12 | Montgomery | Mississippi | 28097 | 1180 | 37 |
1019266 | 1019266 | 2021-02-11 | Montgomery | Mississippi | 28097 | 1175 | 37 |
1016021 | 1016021 | 2021-02-10 | Montgomery | Mississippi | 28097 | 1172 | 37 |
1012776 | 1012776 | 2021-02-09 | Montgomery | Mississippi | 28097 | 1172 | 36 |
1009531 | 1009531 | 2021-02-08 | Montgomery | Mississippi | 28097 | 1168 | 36 |
1006284 | 1006284 | 2021-02-07 | Montgomery | Mississippi | 28097 | 1165 | 36 |
1003038 | 1003038 | 2021-02-06 | Montgomery | Mississippi | 28097 | 1161 | 36 |
999793 | 999793 | 2021-02-05 | Montgomery | Mississippi | 28097 | 1159 | 36 |
996547 | 996547 | 2021-02-04 | Montgomery | Mississippi | 28097 | 1157 | 36 |
993301 | 993301 | 2021-02-03 | Montgomery | Mississippi | 28097 | 1156 | 36 |
990055 | 990055 | 2021-02-02 | Montgomery | Mississippi | 28097 | 1154 | 36 |
986808 | 986808 | 2021-02-01 | Montgomery | Mississippi | 28097 | 1154 | 36 |
983561 | 983561 | 2021-01-31 | Montgomery | Mississippi | 28097 | 1153 | 36 |
980315 | 980315 | 2021-01-30 | Montgomery | Mississippi | 28097 | 1147 | 36 |
977069 | 977069 | 2021-01-29 | Montgomery | Mississippi | 28097 | 1142 | 36 |
973824 | 973824 | 2021-01-28 | Montgomery | Mississippi | 28097 | 1136 | 36 |
970579 | 970579 | 2021-01-27 | Montgomery | Mississippi | 28097 | 1131 | 36 |
967334 | 967334 | 2021-01-26 | Montgomery | Mississippi | 28097 | 1129 | 36 |
964090 | 964090 | 2021-01-25 | Montgomery | Mississippi | 28097 | 1127 | 36 |
960845 | 960845 | 2021-01-24 | Montgomery | Mississippi | 28097 | 1120 | 36 |
957599 | 957599 | 2021-01-23 | Montgomery | Mississippi | 28097 | 1116 | 36 |
954354 | 954354 | 2021-01-22 | Montgomery | Mississippi | 28097 | 1112 | 36 |
951109 | 951109 | 2021-01-21 | Montgomery | Mississippi | 28097 | 1109 | 36 |
947863 | 947863 | 2021-01-20 | Montgomery | Mississippi | 28097 | 1101 | 36 |
944616 | 944616 | 2021-01-19 | Montgomery | Mississippi | 28097 | 1098 | 34 |
941371 | 941371 | 2021-01-18 | Montgomery | Mississippi | 28097 | 1096 | 34 |
938126 | 938126 | 2021-01-17 | Montgomery | Mississippi | 28097 | 1094 | 34 |
934881 | 934881 | 2021-01-16 | Montgomery | Mississippi | 28097 | 1091 | 34 |
931636 | 931636 | 2021-01-15 | Montgomery | Mississippi | 28097 | 1081 | 34 |
928391 | 928391 | 2021-01-14 | Montgomery | Mississippi | 28097 | 1071 | 34 |
925145 | 925145 | 2021-01-13 | Montgomery | Mississippi | 28097 | 1070 | 34 |
921900 | 921900 | 2021-01-12 | Montgomery | Mississippi | 28097 | 1066 | 34 |
918655 | 918655 | 2021-01-11 | Montgomery | Mississippi | 28097 | 1061 | 32 |
915410 | 915410 | 2021-01-10 | Montgomery | Mississippi | 28097 | 1058 | 32 |
912165 | 912165 | 2021-01-09 | Montgomery | Mississippi | 28097 | 1050 | 32 |
908920 | 908920 | 2021-01-08 | Montgomery | Mississippi | 28097 | 1040 | 32 |
905674 | 905674 | 2021-01-07 | Montgomery | Mississippi | 28097 | 1034 | 31 |
902429 | 902429 | 2021-01-06 | Montgomery | Mississippi | 28097 | 1027 | 31 |
899184 | 899184 | 2021-01-05 | Montgomery | Mississippi | 28097 | 1015 | 31 |
895939 | 895939 | 2021-01-04 | Montgomery | Mississippi | 28097 | 1008 | 31 |
892692 | 892692 | 2021-01-03 | Montgomery | Mississippi | 28097 | 1004 | 31 |
889446 | 889446 | 2021-01-02 | Montgomery | Mississippi | 28097 | 997 | 31 |
886200 | 886200 | 2021-01-01 | Montgomery | Mississippi | 28097 | 994 | 31 |
882955 | 882955 | 2020-12-31 | Montgomery | Mississippi | 28097 | 984 | 31 |
879710 | 879710 | 2020-12-30 | Montgomery | Mississippi | 28097 | 972 | 31 |
876465 | 876465 | 2020-12-29 | Montgomery | Mississippi | 28097 | 962 | 31 |
873220 | 873220 | 2020-12-28 | Montgomery | Mississippi | 28097 | 955 | 31 |
869975 | 869975 | 2020-12-27 | Montgomery | Mississippi | 28097 | 953 | 31 |
866730 | 866730 | 2020-12-26 | Montgomery | Mississippi | 28097 | 951 | 30 |
863485 | 863485 | 2020-12-25 | Montgomery | Mississippi | 28097 | 949 | 30 |
860240 | 860240 | 2020-12-24 | Montgomery | Mississippi | 28097 | 946 | 30 |
856995 | 856995 | 2020-12-23 | Montgomery | Mississippi | 28097 | 941 | 30 |
853750 | 853750 | 2020-12-22 | Montgomery | Mississippi | 28097 | 935 | 30 |
850505 | 850505 | 2020-12-21 | Montgomery | Mississippi | 28097 | 929 | 30 |
847260 | 847260 | 2020-12-20 | Montgomery | Mississippi | 28097 | 923 | 30 |
844014 | 844014 | 2020-12-19 | Montgomery | Mississippi | 28097 | 917 | 30 |
840769 | 840769 | 2020-12-18 | Montgomery | Mississippi | 28097 | 916 | 30 |
837524 | 837524 | 2020-12-17 | Montgomery | Mississippi | 28097 | 908 | 30 |
834278 | 834278 | 2020-12-16 | Montgomery | Mississippi | 28097 | 902 | 30 |
831031 | 831031 | 2020-12-15 | Montgomery | Mississippi | 28097 | 893 | 30 |
827785 | 827785 | 2020-12-14 | Montgomery | Mississippi | 28097 | 889 | 30 |
824538 | 824538 | 2020-12-13 | Montgomery | Mississippi | 28097 | 877 | 30 |
821292 | 821292 | 2020-12-12 | Montgomery | Mississippi | 28097 | 868 | 30 |
818046 | 818046 | 2020-12-11 | Montgomery | Mississippi | 28097 | 863 | 28 |
814800 | 814800 | 2020-12-10 | Montgomery | Mississippi | 28097 | 859 | 27 |
811555 | 811555 | 2020-12-09 | Montgomery | Mississippi | 28097 | 849 | 27 |
808310 | 808310 | 2020-12-08 | Montgomery | Mississippi | 28097 | 842 | 27 |
805065 | 805065 | 2020-12-07 | Montgomery | Mississippi | 28097 | 829 | 26 |
801820 | 801820 | 2020-12-06 | Montgomery | Mississippi | 28097 | 823 | 26 |
798575 | 798575 | 2020-12-05 | Montgomery | Mississippi | 28097 | 816 | 26 |
795330 | 795330 | 2020-12-04 | Montgomery | Mississippi | 28097 | 807 | 26 |
792085 | 792085 | 2020-12-03 | Montgomery | Mississippi | 28097 | 788 | 26 |
788840 | 788840 | 2020-12-02 | Montgomery | Mississippi | 28097 | 784 | 26 |
785595 | 785595 | 2020-12-01 | Montgomery | Mississippi | 28097 | 769 | 26 |
782351 | 782351 | 2020-11-30 | Montgomery | Mississippi | 28097 | 758 | 25 |
779105 | 779105 | 2020-11-29 | Montgomery | Mississippi | 28097 | 754 | 25 |
775860 | 775860 | 2020-11-28 | Montgomery | Mississippi | 28097 | 745 | 25 |
772615 | 772615 | 2020-11-27 | Montgomery | Mississippi | 28097 | 736 | 25 |
769370 | 769370 | 2020-11-26 | Montgomery | Mississippi | 28097 | 728 | 25 |
766124 | 766124 | 2020-11-25 | Montgomery | Mississippi | 28097 | 721 | 25 |
762879 | 762879 | 2020-11-24 | Montgomery | Mississippi | 28097 | 719 | 25 |
759634 | 759634 | 2020-11-23 | Montgomery | Mississippi | 28097 | 719 | 25 |
756387 | 756387 | 2020-11-22 | Montgomery | Mississippi | 28097 | 719 | 25 |
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);