ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28053 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278984 | 1278984 | 2021-05-02 | Humphreys | Mississippi | 28053 | 953 | 32 |
1275737 | 1275737 | 2021-05-01 | Humphreys | Mississippi | 28053 | 953 | 32 |
1272490 | 1272490 | 2021-04-30 | Humphreys | Mississippi | 28053 | 953 | 32 |
1269243 | 1269243 | 2021-04-29 | Humphreys | Mississippi | 28053 | 951 | 32 |
1265996 | 1265996 | 2021-04-28 | Humphreys | Mississippi | 28053 | 949 | 32 |
1262749 | 1262749 | 2021-04-27 | Humphreys | Mississippi | 28053 | 949 | 32 |
1259502 | 1259502 | 2021-04-26 | Humphreys | Mississippi | 28053 | 949 | 32 |
1256255 | 1256255 | 2021-04-25 | Humphreys | Mississippi | 28053 | 948 | 32 |
1253008 | 1253008 | 2021-04-24 | Humphreys | Mississippi | 28053 | 948 | 32 |
1249761 | 1249761 | 2021-04-23 | Humphreys | Mississippi | 28053 | 948 | 32 |
1246514 | 1246514 | 2021-04-22 | Humphreys | Mississippi | 28053 | 947 | 32 |
1243267 | 1243267 | 2021-04-21 | Humphreys | Mississippi | 28053 | 947 | 32 |
1240020 | 1240020 | 2021-04-20 | Humphreys | Mississippi | 28053 | 947 | 32 |
1236773 | 1236773 | 2021-04-19 | Humphreys | Mississippi | 28053 | 947 | 32 |
1233526 | 1233526 | 2021-04-18 | Humphreys | Mississippi | 28053 | 947 | 32 |
1230278 | 1230278 | 2021-04-17 | Humphreys | Mississippi | 28053 | 947 | 32 |
1227030 | 1227030 | 2021-04-16 | Humphreys | Mississippi | 28053 | 946 | 32 |
1223782 | 1223782 | 2021-04-15 | Humphreys | Mississippi | 28053 | 944 | 32 |
1220535 | 1220535 | 2021-04-14 | Humphreys | Mississippi | 28053 | 943 | 32 |
1217287 | 1217287 | 2021-04-13 | Humphreys | Mississippi | 28053 | 943 | 32 |
1214040 | 1214040 | 2021-04-12 | Humphreys | Mississippi | 28053 | 943 | 32 |
1210792 | 1210792 | 2021-04-11 | Humphreys | Mississippi | 28053 | 943 | 32 |
1207543 | 1207543 | 2021-04-10 | Humphreys | Mississippi | 28053 | 943 | 32 |
1204295 | 1204295 | 2021-04-09 | Humphreys | Mississippi | 28053 | 943 | 32 |
1201047 | 1201047 | 2021-04-08 | Humphreys | Mississippi | 28053 | 943 | 32 |
1197798 | 1197798 | 2021-04-07 | Humphreys | Mississippi | 28053 | 943 | 32 |
1194549 | 1194549 | 2021-04-06 | Humphreys | Mississippi | 28053 | 942 | 32 |
1191300 | 1191300 | 2021-04-05 | Humphreys | Mississippi | 28053 | 942 | 32 |
1188052 | 1188052 | 2021-04-04 | Humphreys | Mississippi | 28053 | 942 | 32 |
1184805 | 1184805 | 2021-04-03 | Humphreys | Mississippi | 28053 | 942 | 32 |
1181559 | 1181559 | 2021-04-02 | Humphreys | Mississippi | 28053 | 941 | 32 |
1178312 | 1178312 | 2021-04-01 | Humphreys | Mississippi | 28053 | 941 | 32 |
1175065 | 1175065 | 2021-03-31 | Humphreys | Mississippi | 28053 | 941 | 32 |
1171818 | 1171818 | 2021-03-30 | Humphreys | Mississippi | 28053 | 941 | 31 |
1168570 | 1168570 | 2021-03-29 | Humphreys | Mississippi | 28053 | 941 | 31 |
1165322 | 1165322 | 2021-03-28 | Humphreys | Mississippi | 28053 | 941 | 31 |
1162074 | 1162074 | 2021-03-27 | Humphreys | Mississippi | 28053 | 942 | 30 |
1158826 | 1158826 | 2021-03-26 | Humphreys | Mississippi | 28053 | 941 | 30 |
1155579 | 1155579 | 2021-03-25 | Humphreys | Mississippi | 28053 | 939 | 30 |
1152332 | 1152332 | 2021-03-24 | Humphreys | Mississippi | 28053 | 938 | 30 |
1149085 | 1149085 | 2021-03-23 | Humphreys | Mississippi | 28053 | 938 | 30 |
1145838 | 1145838 | 2021-03-22 | Humphreys | Mississippi | 28053 | 938 | 29 |
1142591 | 1142591 | 2021-03-21 | Humphreys | Mississippi | 28053 | 938 | 29 |
1139344 | 1139344 | 2021-03-20 | Humphreys | Mississippi | 28053 | 938 | 29 |
1136098 | 1136098 | 2021-03-19 | Humphreys | Mississippi | 28053 | 938 | 29 |
1132852 | 1132852 | 2021-03-18 | Humphreys | Mississippi | 28053 | 938 | 29 |
1129604 | 1129604 | 2021-03-17 | Humphreys | Mississippi | 28053 | 938 | 29 |
1126357 | 1126357 | 2021-03-16 | Humphreys | Mississippi | 28053 | 937 | 29 |
1123111 | 1123111 | 2021-03-15 | Humphreys | Mississippi | 28053 | 937 | 29 |
1119864 | 1119864 | 2021-03-14 | Humphreys | Mississippi | 28053 | 937 | 29 |
1116617 | 1116617 | 2021-03-13 | Humphreys | Mississippi | 28053 | 936 | 29 |
1113371 | 1113371 | 2021-03-12 | Humphreys | Mississippi | 28053 | 936 | 29 |
1110125 | 1110125 | 2021-03-11 | Humphreys | Mississippi | 28053 | 936 | 29 |
1106879 | 1106879 | 2021-03-10 | Humphreys | Mississippi | 28053 | 936 | 29 |
1103633 | 1103633 | 2021-03-09 | Humphreys | Mississippi | 28053 | 933 | 28 |
1100387 | 1100387 | 2021-03-08 | Humphreys | Mississippi | 28053 | 931 | 28 |
1097140 | 1097140 | 2021-03-07 | Humphreys | Mississippi | 28053 | 931 | 28 |
1093893 | 1093893 | 2021-03-06 | Humphreys | Mississippi | 28053 | 931 | 28 |
1090647 | 1090647 | 2021-03-05 | Humphreys | Mississippi | 28053 | 931 | 28 |
1087402 | 1087402 | 2021-03-04 | Humphreys | Mississippi | 28053 | 930 | 27 |
1084157 | 1084157 | 2021-03-03 | Humphreys | Mississippi | 28053 | 929 | 27 |
1080911 | 1080911 | 2021-03-02 | Humphreys | Mississippi | 28053 | 928 | 27 |
1077665 | 1077665 | 2021-03-01 | Humphreys | Mississippi | 28053 | 928 | 27 |
1074419 | 1074419 | 2021-02-28 | Humphreys | Mississippi | 28053 | 928 | 27 |
1071173 | 1071173 | 2021-02-27 | Humphreys | Mississippi | 28053 | 925 | 27 |
1067928 | 1067928 | 2021-02-26 | Humphreys | Mississippi | 28053 | 924 | 27 |
1064683 | 1064683 | 2021-02-25 | Humphreys | Mississippi | 28053 | 916 | 26 |
1061439 | 1061439 | 2021-02-24 | Humphreys | Mississippi | 28053 | 913 | 26 |
1058193 | 1058193 | 2021-02-23 | Humphreys | Mississippi | 28053 | 912 | 26 |
1054947 | 1054947 | 2021-02-22 | Humphreys | Mississippi | 28053 | 911 | 26 |
1051700 | 1051700 | 2021-02-21 | Humphreys | Mississippi | 28053 | 911 | 26 |
1048453 | 1048453 | 2021-02-20 | Humphreys | Mississippi | 28053 | 909 | 26 |
1045207 | 1045207 | 2021-02-19 | Humphreys | Mississippi | 28053 | 909 | 26 |
1041962 | 1041962 | 2021-02-18 | Humphreys | Mississippi | 28053 | 908 | 26 |
1038717 | 1038717 | 2021-02-17 | Humphreys | Mississippi | 28053 | 908 | 26 |
1035472 | 1035472 | 2021-02-16 | Humphreys | Mississippi | 28053 | 904 | 26 |
1032227 | 1032227 | 2021-02-15 | Humphreys | Mississippi | 28053 | 902 | 26 |
1028980 | 1028980 | 2021-02-14 | Humphreys | Mississippi | 28053 | 898 | 26 |
1025734 | 1025734 | 2021-02-13 | Humphreys | Mississippi | 28053 | 898 | 26 |
1022489 | 1022489 | 2021-02-12 | Humphreys | Mississippi | 28053 | 896 | 26 |
1019244 | 1019244 | 2021-02-11 | Humphreys | Mississippi | 28053 | 896 | 26 |
1015999 | 1015999 | 2021-02-10 | Humphreys | Mississippi | 28053 | 891 | 26 |
1012754 | 1012754 | 2021-02-09 | Humphreys | Mississippi | 28053 | 891 | 26 |
1009509 | 1009509 | 2021-02-08 | Humphreys | Mississippi | 28053 | 890 | 26 |
1006262 | 1006262 | 2021-02-07 | Humphreys | Mississippi | 28053 | 888 | 26 |
1003016 | 1003016 | 2021-02-06 | Humphreys | Mississippi | 28053 | 887 | 26 |
999771 | 999771 | 2021-02-05 | Humphreys | Mississippi | 28053 | 884 | 25 |
996525 | 996525 | 2021-02-04 | Humphreys | Mississippi | 28053 | 881 | 25 |
993279 | 993279 | 2021-02-03 | Humphreys | Mississippi | 28053 | 881 | 25 |
990033 | 990033 | 2021-02-02 | Humphreys | Mississippi | 28053 | 879 | 25 |
986786 | 986786 | 2021-02-01 | Humphreys | Mississippi | 28053 | 878 | 25 |
983539 | 983539 | 2021-01-31 | Humphreys | Mississippi | 28053 | 876 | 25 |
980293 | 980293 | 2021-01-30 | Humphreys | Mississippi | 28053 | 876 | 25 |
977047 | 977047 | 2021-01-29 | Humphreys | Mississippi | 28053 | 873 | 25 |
973802 | 973802 | 2021-01-28 | Humphreys | Mississippi | 28053 | 868 | 25 |
970557 | 970557 | 2021-01-27 | Humphreys | Mississippi | 28053 | 862 | 25 |
967312 | 967312 | 2021-01-26 | Humphreys | Mississippi | 28053 | 856 | 25 |
964068 | 964068 | 2021-01-25 | Humphreys | Mississippi | 28053 | 848 | 24 |
960823 | 960823 | 2021-01-24 | Humphreys | Mississippi | 28053 | 847 | 24 |
957577 | 957577 | 2021-01-23 | Humphreys | Mississippi | 28053 | 846 | 24 |
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);