ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28095 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279005 | 1279005 | 2021-05-02 | Monroe | Mississippi | 28095 | 4084 | 133 |
1275758 | 1275758 | 2021-05-01 | Monroe | Mississippi | 28095 | 4084 | 133 |
1272511 | 1272511 | 2021-04-30 | Monroe | Mississippi | 28095 | 4084 | 133 |
1269264 | 1269264 | 2021-04-29 | Monroe | Mississippi | 28095 | 4081 | 132 |
1266017 | 1266017 | 2021-04-28 | Monroe | Mississippi | 28095 | 4078 | 132 |
1262770 | 1262770 | 2021-04-27 | Monroe | Mississippi | 28095 | 4076 | 132 |
1259523 | 1259523 | 2021-04-26 | Monroe | Mississippi | 28095 | 4075 | 132 |
1256276 | 1256276 | 2021-04-25 | Monroe | Mississippi | 28095 | 4069 | 132 |
1253029 | 1253029 | 2021-04-24 | Monroe | Mississippi | 28095 | 4069 | 132 |
1249782 | 1249782 | 2021-04-23 | Monroe | Mississippi | 28095 | 4069 | 132 |
1246535 | 1246535 | 2021-04-22 | Monroe | Mississippi | 28095 | 4067 | 132 |
1243288 | 1243288 | 2021-04-21 | Monroe | Mississippi | 28095 | 4066 | 132 |
1240041 | 1240041 | 2021-04-20 | Monroe | Mississippi | 28095 | 4066 | 132 |
1236794 | 1236794 | 2021-04-19 | Monroe | Mississippi | 28095 | 4063 | 132 |
1233547 | 1233547 | 2021-04-18 | Monroe | Mississippi | 28095 | 4063 | 132 |
1230299 | 1230299 | 2021-04-17 | Monroe | Mississippi | 28095 | 4063 | 132 |
1227051 | 1227051 | 2021-04-16 | Monroe | Mississippi | 28095 | 4062 | 132 |
1223803 | 1223803 | 2021-04-15 | Monroe | Mississippi | 28095 | 4061 | 132 |
1220556 | 1220556 | 2021-04-14 | Monroe | Mississippi | 28095 | 4062 | 132 |
1217308 | 1217308 | 2021-04-13 | Monroe | Mississippi | 28095 | 4061 | 132 |
1214061 | 1214061 | 2021-04-12 | Monroe | Mississippi | 28095 | 4057 | 132 |
1210813 | 1210813 | 2021-04-11 | Monroe | Mississippi | 28095 | 4057 | 132 |
1207564 | 1207564 | 2021-04-10 | Monroe | Mississippi | 28095 | 4056 | 132 |
1204316 | 1204316 | 2021-04-09 | Monroe | Mississippi | 28095 | 4055 | 131 |
1201068 | 1201068 | 2021-04-08 | Monroe | Mississippi | 28095 | 4054 | 131 |
1197819 | 1197819 | 2021-04-07 | Monroe | Mississippi | 28095 | 4054 | 131 |
1194570 | 1194570 | 2021-04-06 | Monroe | Mississippi | 28095 | 4053 | 131 |
1191321 | 1191321 | 2021-04-05 | Monroe | Mississippi | 28095 | 4051 | 131 |
1188073 | 1188073 | 2021-04-04 | Monroe | Mississippi | 28095 | 4051 | 131 |
1184826 | 1184826 | 2021-04-03 | Monroe | Mississippi | 28095 | 4051 | 131 |
1181580 | 1181580 | 2021-04-02 | Monroe | Mississippi | 28095 | 4050 | 131 |
1178333 | 1178333 | 2021-04-01 | Monroe | Mississippi | 28095 | 4049 | 131 |
1175086 | 1175086 | 2021-03-31 | Monroe | Mississippi | 28095 | 4047 | 131 |
1171839 | 1171839 | 2021-03-30 | Monroe | Mississippi | 28095 | 4042 | 131 |
1168591 | 1168591 | 2021-03-29 | Monroe | Mississippi | 28095 | 4042 | 130 |
1165343 | 1165343 | 2021-03-28 | Monroe | Mississippi | 28095 | 4042 | 130 |
1162095 | 1162095 | 2021-03-27 | Monroe | Mississippi | 28095 | 4042 | 130 |
1158847 | 1158847 | 2021-03-26 | Monroe | Mississippi | 28095 | 4041 | 130 |
1155600 | 1155600 | 2021-03-25 | Monroe | Mississippi | 28095 | 4039 | 130 |
1152353 | 1152353 | 2021-03-24 | Monroe | Mississippi | 28095 | 4038 | 130 |
1149106 | 1149106 | 2021-03-23 | Monroe | Mississippi | 28095 | 4038 | 130 |
1145859 | 1145859 | 2021-03-22 | Monroe | Mississippi | 28095 | 4035 | 130 |
1142612 | 1142612 | 2021-03-21 | Monroe | Mississippi | 28095 | 4035 | 130 |
1139365 | 1139365 | 2021-03-20 | Monroe | Mississippi | 28095 | 4034 | 130 |
1136119 | 1136119 | 2021-03-19 | Monroe | Mississippi | 28095 | 4032 | 130 |
1132873 | 1132873 | 2021-03-18 | Monroe | Mississippi | 28095 | 4030 | 130 |
1129625 | 1129625 | 2021-03-17 | Monroe | Mississippi | 28095 | 4028 | 130 |
1126378 | 1126378 | 2021-03-16 | Monroe | Mississippi | 28095 | 4028 | 130 |
1123132 | 1123132 | 2021-03-15 | Monroe | Mississippi | 28095 | 4027 | 130 |
1119885 | 1119885 | 2021-03-14 | Monroe | Mississippi | 28095 | 4026 | 130 |
1116638 | 1116638 | 2021-03-13 | Monroe | Mississippi | 28095 | 4025 | 130 |
1113392 | 1113392 | 2021-03-12 | Monroe | Mississippi | 28095 | 4012 | 130 |
1110146 | 1110146 | 2021-03-11 | Monroe | Mississippi | 28095 | 3999 | 129 |
1106900 | 1106900 | 2021-03-10 | Monroe | Mississippi | 28095 | 3999 | 129 |
1103654 | 1103654 | 2021-03-09 | Monroe | Mississippi | 28095 | 3998 | 129 |
1100408 | 1100408 | 2021-03-08 | Monroe | Mississippi | 28095 | 3998 | 129 |
1097161 | 1097161 | 2021-03-07 | Monroe | Mississippi | 28095 | 3998 | 129 |
1093914 | 1093914 | 2021-03-06 | Monroe | Mississippi | 28095 | 3996 | 129 |
1090668 | 1090668 | 2021-03-05 | Monroe | Mississippi | 28095 | 3994 | 128 |
1087423 | 1087423 | 2021-03-04 | Monroe | Mississippi | 28095 | 3993 | 128 |
1084178 | 1084178 | 2021-03-03 | Monroe | Mississippi | 28095 | 3990 | 127 |
1080932 | 1080932 | 2021-03-02 | Monroe | Mississippi | 28095 | 3990 | 126 |
1077686 | 1077686 | 2021-03-01 | Monroe | Mississippi | 28095 | 3989 | 126 |
1074440 | 1074440 | 2021-02-28 | Monroe | Mississippi | 28095 | 3988 | 126 |
1071194 | 1071194 | 2021-02-27 | Monroe | Mississippi | 28095 | 3982 | 126 |
1067949 | 1067949 | 2021-02-26 | Monroe | Mississippi | 28095 | 3981 | 126 |
1064704 | 1064704 | 2021-02-25 | Monroe | Mississippi | 28095 | 3980 | 126 |
1061460 | 1061460 | 2021-02-24 | Monroe | Mississippi | 28095 | 3977 | 126 |
1058214 | 1058214 | 2021-02-23 | Monroe | Mississippi | 28095 | 3971 | 125 |
1054968 | 1054968 | 2021-02-22 | Monroe | Mississippi | 28095 | 3967 | 125 |
1051721 | 1051721 | 2021-02-21 | Monroe | Mississippi | 28095 | 3966 | 125 |
1048474 | 1048474 | 2021-02-20 | Monroe | Mississippi | 28095 | 3963 | 125 |
1045228 | 1045228 | 2021-02-19 | Monroe | Mississippi | 28095 | 3961 | 125 |
1041983 | 1041983 | 2021-02-18 | Monroe | Mississippi | 28095 | 3961 | 125 |
1038738 | 1038738 | 2021-02-17 | Monroe | Mississippi | 28095 | 3961 | 125 |
1035493 | 1035493 | 2021-02-16 | Monroe | Mississippi | 28095 | 3952 | 124 |
1032248 | 1032248 | 2021-02-15 | Monroe | Mississippi | 28095 | 3948 | 123 |
1029001 | 1029001 | 2021-02-14 | Monroe | Mississippi | 28095 | 3946 | 123 |
1025755 | 1025755 | 2021-02-13 | Monroe | Mississippi | 28095 | 3937 | 123 |
1022510 | 1022510 | 2021-02-12 | Monroe | Mississippi | 28095 | 3929 | 123 |
1019265 | 1019265 | 2021-02-11 | Monroe | Mississippi | 28095 | 3926 | 123 |
1016020 | 1016020 | 2021-02-10 | Monroe | Mississippi | 28095 | 3915 | 121 |
1012775 | 1012775 | 2021-02-09 | Monroe | Mississippi | 28095 | 3911 | 121 |
1009530 | 1009530 | 2021-02-08 | Monroe | Mississippi | 28095 | 3903 | 119 |
1006283 | 1006283 | 2021-02-07 | Monroe | Mississippi | 28095 | 3902 | 119 |
1003037 | 1003037 | 2021-02-06 | Monroe | Mississippi | 28095 | 3893 | 119 |
999792 | 999792 | 2021-02-05 | Monroe | Mississippi | 28095 | 3868 | 119 |
996546 | 996546 | 2021-02-04 | Monroe | Mississippi | 28095 | 3857 | 118 |
993300 | 993300 | 2021-02-03 | Monroe | Mississippi | 28095 | 3840 | 118 |
990054 | 990054 | 2021-02-02 | Monroe | Mississippi | 28095 | 3827 | 117 |
986807 | 986807 | 2021-02-01 | Monroe | Mississippi | 28095 | 3819 | 117 |
983560 | 983560 | 2021-01-31 | Monroe | Mississippi | 28095 | 3811 | 117 |
980314 | 980314 | 2021-01-30 | Monroe | Mississippi | 28095 | 3806 | 115 |
977068 | 977068 | 2021-01-29 | Monroe | Mississippi | 28095 | 3791 | 114 |
973823 | 973823 | 2021-01-28 | Monroe | Mississippi | 28095 | 3762 | 112 |
970578 | 970578 | 2021-01-27 | Monroe | Mississippi | 28095 | 3746 | 112 |
967333 | 967333 | 2021-01-26 | Monroe | Mississippi | 28095 | 3727 | 111 |
964089 | 964089 | 2021-01-25 | Monroe | Mississippi | 28095 | 3693 | 110 |
960844 | 960844 | 2021-01-24 | Monroe | Mississippi | 28095 | 3686 | 110 |
957598 | 957598 | 2021-01-23 | Monroe | Mississippi | 28095 | 3671 | 108 |
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);