ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lafayette" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278993 | 1278993 | 2021-05-02 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1275746 | 1275746 | 2021-05-01 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1272499 | 1272499 | 2021-04-30 | Lafayette | Mississippi | 28071 | 6142 | 118 |
1269252 | 1269252 | 2021-04-29 | Lafayette | Mississippi | 28071 | 6138 | 118 |
1266005 | 1266005 | 2021-04-28 | Lafayette | Mississippi | 28071 | 6134 | 118 |
1262758 | 1262758 | 2021-04-27 | Lafayette | Mississippi | 28071 | 6126 | 118 |
1259511 | 1259511 | 2021-04-26 | Lafayette | Mississippi | 28071 | 6120 | 118 |
1256264 | 1256264 | 2021-04-25 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1253017 | 1253017 | 2021-04-24 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1249770 | 1249770 | 2021-04-23 | Lafayette | Mississippi | 28071 | 6109 | 118 |
1246523 | 1246523 | 2021-04-22 | Lafayette | Mississippi | 28071 | 6104 | 118 |
1243276 | 1243276 | 2021-04-21 | Lafayette | Mississippi | 28071 | 6099 | 118 |
1240029 | 1240029 | 2021-04-20 | Lafayette | Mississippi | 28071 | 6093 | 118 |
1236782 | 1236782 | 2021-04-19 | Lafayette | Mississippi | 28071 | 6081 | 118 |
1233535 | 1233535 | 2021-04-18 | Lafayette | Mississippi | 28071 | 6077 | 118 |
1230287 | 1230287 | 2021-04-17 | Lafayette | Mississippi | 28071 | 6077 | 118 |
1227039 | 1227039 | 2021-04-16 | Lafayette | Mississippi | 28071 | 6072 | 117 |
1223791 | 1223791 | 2021-04-15 | Lafayette | Mississippi | 28071 | 6063 | 117 |
1220544 | 1220544 | 2021-04-14 | Lafayette | Mississippi | 28071 | 6050 | 117 |
1217296 | 1217296 | 2021-04-13 | Lafayette | Mississippi | 28071 | 6039 | 117 |
1214049 | 1214049 | 2021-04-12 | Lafayette | Mississippi | 28071 | 6028 | 117 |
1210801 | 1210801 | 2021-04-11 | Lafayette | Mississippi | 28071 | 6027 | 117 |
1207552 | 1207552 | 2021-04-10 | Lafayette | Mississippi | 28071 | 6026 | 117 |
1204304 | 1204304 | 2021-04-09 | Lafayette | Mississippi | 28071 | 6020 | 117 |
1201056 | 1201056 | 2021-04-08 | Lafayette | Mississippi | 28071 | 6011 | 117 |
1197807 | 1197807 | 2021-04-07 | Lafayette | Mississippi | 28071 | 5997 | 116 |
1194558 | 1194558 | 2021-04-06 | Lafayette | Mississippi | 28071 | 5991 | 116 |
1191309 | 1191309 | 2021-04-05 | Lafayette | Mississippi | 28071 | 5980 | 116 |
1188061 | 1188061 | 2021-04-04 | Lafayette | Mississippi | 28071 | 5974 | 116 |
1184814 | 1184814 | 2021-04-03 | Lafayette | Mississippi | 28071 | 5969 | 116 |
1181568 | 1181568 | 2021-04-02 | Lafayette | Mississippi | 28071 | 5962 | 116 |
1178321 | 1178321 | 2021-04-01 | Lafayette | Mississippi | 28071 | 5951 | 116 |
1175074 | 1175074 | 2021-03-31 | Lafayette | Mississippi | 28071 | 5938 | 116 |
1171827 | 1171827 | 2021-03-30 | Lafayette | Mississippi | 28071 | 5928 | 116 |
1168579 | 1168579 | 2021-03-29 | Lafayette | Mississippi | 28071 | 5923 | 116 |
1165331 | 1165331 | 2021-03-28 | Lafayette | Mississippi | 28071 | 5918 | 116 |
1162083 | 1162083 | 2021-03-27 | Lafayette | Mississippi | 28071 | 5908 | 116 |
1158835 | 1158835 | 2021-03-26 | Lafayette | Mississippi | 28071 | 5906 | 116 |
1155588 | 1155588 | 2021-03-25 | Lafayette | Mississippi | 28071 | 5899 | 116 |
1152341 | 1152341 | 2021-03-24 | Lafayette | Mississippi | 28071 | 5892 | 116 |
1149094 | 1149094 | 2021-03-23 | Lafayette | Mississippi | 28071 | 5879 | 116 |
1145847 | 1145847 | 2021-03-22 | Lafayette | Mississippi | 28071 | 5873 | 115 |
1142600 | 1142600 | 2021-03-21 | Lafayette | Mississippi | 28071 | 5873 | 115 |
1139353 | 1139353 | 2021-03-20 | Lafayette | Mississippi | 28071 | 5869 | 114 |
1136107 | 1136107 | 2021-03-19 | Lafayette | Mississippi | 28071 | 5866 | 114 |
1132861 | 1132861 | 2021-03-18 | Lafayette | Mississippi | 28071 | 5863 | 114 |
1129613 | 1129613 | 2021-03-17 | Lafayette | Mississippi | 28071 | 5858 | 114 |
1126366 | 1126366 | 2021-03-16 | Lafayette | Mississippi | 28071 | 5842 | 114 |
1123120 | 1123120 | 2021-03-15 | Lafayette | Mississippi | 28071 | 5835 | 114 |
1119873 | 1119873 | 2021-03-14 | Lafayette | Mississippi | 28071 | 5834 | 114 |
1116626 | 1116626 | 2021-03-13 | Lafayette | Mississippi | 28071 | 5832 | 114 |
1113380 | 1113380 | 2021-03-12 | Lafayette | Mississippi | 28071 | 5808 | 114 |
1110134 | 1110134 | 2021-03-11 | Lafayette | Mississippi | 28071 | 5788 | 114 |
1106888 | 1106888 | 2021-03-10 | Lafayette | Mississippi | 28071 | 5779 | 114 |
1103642 | 1103642 | 2021-03-09 | Lafayette | Mississippi | 28071 | 5777 | 114 |
1100396 | 1100396 | 2021-03-08 | Lafayette | Mississippi | 28071 | 5768 | 114 |
1097149 | 1097149 | 2021-03-07 | Lafayette | Mississippi | 28071 | 5768 | 114 |
1093902 | 1093902 | 2021-03-06 | Lafayette | Mississippi | 28071 | 5767 | 114 |
1090656 | 1090656 | 2021-03-05 | Lafayette | Mississippi | 28071 | 5761 | 114 |
1087411 | 1087411 | 2021-03-04 | Lafayette | Mississippi | 28071 | 5747 | 113 |
1084166 | 1084166 | 2021-03-03 | Lafayette | Mississippi | 28071 | 5740 | 113 |
1080920 | 1080920 | 2021-03-02 | Lafayette | Mississippi | 28071 | 5736 | 113 |
1077674 | 1077674 | 2021-03-01 | Lafayette | Mississippi | 28071 | 5733 | 113 |
1074428 | 1074428 | 2021-02-28 | Lafayette | Mississippi | 28071 | 5730 | 113 |
1071182 | 1071182 | 2021-02-27 | Lafayette | Mississippi | 28071 | 5721 | 113 |
1067937 | 1067937 | 2021-02-26 | Lafayette | Mississippi | 28071 | 5716 | 113 |
1064692 | 1064692 | 2021-02-25 | Lafayette | Mississippi | 28071 | 5707 | 113 |
1061448 | 1061448 | 2021-02-24 | Lafayette | Mississippi | 28071 | 5698 | 113 |
1058202 | 1058202 | 2021-02-23 | Lafayette | Mississippi | 28071 | 5688 | 113 |
1054956 | 1054956 | 2021-02-22 | Lafayette | Mississippi | 28071 | 5681 | 113 |
1051709 | 1051709 | 2021-02-21 | Lafayette | Mississippi | 28071 | 5675 | 113 |
1048462 | 1048462 | 2021-02-20 | Lafayette | Mississippi | 28071 | 5679 | 113 |
1045216 | 1045216 | 2021-02-19 | Lafayette | Mississippi | 28071 | 5675 | 113 |
1041971 | 1041971 | 2021-02-18 | Lafayette | Mississippi | 28071 | 5671 | 113 |
1038726 | 1038726 | 2021-02-17 | Lafayette | Mississippi | 28071 | 5670 | 113 |
1035481 | 1035481 | 2021-02-16 | Lafayette | Mississippi | 28071 | 5663 | 112 |
1032236 | 1032236 | 2021-02-15 | Lafayette | Mississippi | 28071 | 5658 | 110 |
1028989 | 1028989 | 2021-02-14 | Lafayette | Mississippi | 28071 | 5642 | 110 |
1025743 | 1025743 | 2021-02-13 | Lafayette | Mississippi | 28071 | 5628 | 110 |
1022498 | 1022498 | 2021-02-12 | Lafayette | Mississippi | 28071 | 5623 | 110 |
1019253 | 1019253 | 2021-02-11 | Lafayette | Mississippi | 28071 | 5605 | 110 |
1016008 | 1016008 | 2021-02-10 | Lafayette | Mississippi | 28071 | 5582 | 110 |
1012763 | 1012763 | 2021-02-09 | Lafayette | Mississippi | 28071 | 5574 | 109 |
1009518 | 1009518 | 2021-02-08 | Lafayette | Mississippi | 28071 | 5568 | 108 |
1006271 | 1006271 | 2021-02-07 | Lafayette | Mississippi | 28071 | 5559 | 108 |
1003025 | 1003025 | 2021-02-06 | Lafayette | Mississippi | 28071 | 5542 | 108 |
999780 | 999780 | 2021-02-05 | Lafayette | Mississippi | 28071 | 5522 | 107 |
996534 | 996534 | 2021-02-04 | Lafayette | Mississippi | 28071 | 5499 | 106 |
993288 | 993288 | 2021-02-03 | Lafayette | Mississippi | 28071 | 5456 | 106 |
990042 | 990042 | 2021-02-02 | Lafayette | Mississippi | 28071 | 5442 | 105 |
986795 | 986795 | 2021-02-01 | Lafayette | Mississippi | 28071 | 5434 | 104 |
983548 | 983548 | 2021-01-31 | Lafayette | Mississippi | 28071 | 5414 | 104 |
980302 | 980302 | 2021-01-30 | Lafayette | Mississippi | 28071 | 5392 | 103 |
977056 | 977056 | 2021-01-29 | Lafayette | Mississippi | 28071 | 5369 | 103 |
973811 | 973811 | 2021-01-28 | Lafayette | Mississippi | 28071 | 5331 | 102 |
970566 | 970566 | 2021-01-27 | Lafayette | Mississippi | 28071 | 5295 | 102 |
967321 | 967321 | 2021-01-26 | Lafayette | Mississippi | 28071 | 5269 | 101 |
964077 | 964077 | 2021-01-25 | Lafayette | Mississippi | 28071 | 5229 | 101 |
960832 | 960832 | 2021-01-24 | Lafayette | Mississippi | 28071 | 5205 | 98 |
957586 | 957586 | 2021-01-23 | Lafayette | Mississippi | 28071 | 5162 | 98 |
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);